采购管理:库存与订货策略解析

版权申诉
0 下载量 193 浏览量 更新于2024-07-17 收藏 548KB PPT 举报
"该资源是关于采购管理的第五讲,主要探讨了采购数量与库存控制的主题,涵盖了需求量、订货量、批量等概念,以及订货政策、库存控制策略在供应链运作中的应用。" 在采购管理中,需求量(cycledemand)是指通知给采购部门的实际需求数量,而订货量(Order Quantity)则是采购部门向供应商订购的产品数量,它可以表现为订货总量或订货批量。批量(Lot size or Batch size)定义为一次订购或生产中产生的单一产品的单位或数量。值得注意的是,订货数量并不总是与需求量一致,尤其在经常性需求的情况下,会应用各种订货政策,如订单汇总、预订单、期限合同结合“整订零取”订单、合同组合等,以优化成本和效率。这些政策可能使得单次订货量不同于需求量,但长期来看,采购总量与需求总量保持平衡。 订货政策的制定涉及到需求预测、订单、合同、库存管理等多个环节。例如,订单汇总是为了将多个小需求合并成大订单以获取价格优惠,预订单可以帮助供应商规划生产,期限合同则为供需双方提供了价格和数量的稳定性。此外,库存管理者可能采用“开放性购买”(Open to Buy, OTB)来管理预算与实际购买的差异,或使用“提前预定”系统来确保产品供应。 在供应链运作过程中,需求分析是一个关键步骤,它从原材料到最终产成品的整个生产流程中起着决定性作用。原材料、外购件、外协件、辅料等构成供应链的上游,经过加工、制造、装配等过程转化为零件、半成品、部件,最终形成产成品。这个过程中,需求预测、库存控制和物料需求计划(MRP)共同作用,确保生产活动的顺利进行。 采购与供应系统不仅要考虑直接应用于生产和运营的物资,还需要建立库存以满足未来的需要。这个系统可能集成生产计划和控制,或者利用库存计划和控制来计算恰当的采购数量和时间。生产计划和控制通过政策和程序来确定和调整生产所需物料的需求,确保供应链的流畅运行。 库存控制是采购管理中的核心环节,常见的策略有经济订货批量(EOQ)模型,它旨在最小化库存持有成本和订货成本的总和。数量折扣策略则允许采购方通过批量购买来获取价格优惠,但同时也需要权衡额外库存的成本。这些策略的运用有助于企业在满足需求的同时,优化成本结构,提高运营效率。 采购数量与库存控制是采购管理的重要组成部分,涉及到需求预测、订单策略、库存策略和生产计划等多个方面,企业通过有效的管理,能够在保证供应稳定的同时,实现成本效益的最大化。

SELECT PIS.SHOW_FLT_DETAIL AS SHOW_FLT_DETAIL -- new , PIS.SHOW_AWB_DETAIL AS SHOW_AWB_DETAIL -- new , PIS.DISPLAY_AIRLINE_CODE AS CARRIER_CODE , DECODE(PIS.REVERT_FLOW,'N',PIS.FLOW_TYPE,DECODE(PIS.FLOW_TYPE,'I','E','I')) AS FLOW_TYPE , PIS.SHIP_TO_LOCATION AS SHIP_TO_LOCATION , PIS.INVOICE_SEQUENCE AS INVOICE_SEQUENCE , PFT.FLIGHT_DATE AS FLIGHT_DATE , PFT.FLIGHT_CARRIER_CODE AS FLIGHT_CARRIER_CODE , PFT.FLIGHT_SERIAL_NUMBER AS FLIGHT_SERIAL_NUMBER , PFT.FLOW_TYPE AS AIRCRAFT_FLOW , FAST.AIRCRAFT_SERVICE_TYPE AS AIRCRAFT_SERVICE_TYPE , PPT.AWB_NUMBER AS AWB_NUMBER , PPT.WEIGHT AS WEIGHT , PPT.CARGO_HANDLING_OPERATOR AS CARGO_HANDLING_OPERATOR , PPT.SHIPMENT_PACKING_TYPE AS SHIPMENT_PACKING_TYPE , PPT.SHIPMENT_FLOW_TYPE AS SHIPMENT_FLOW_TYPE , PPT.SHIPMENT_BUILD_TYPE AS SHIPMENT_BUILD_TYPE , PPT.SHIPMENT_CARGO_TYPE AS SHIPMENT_CARGO_TYPE , PPT.REVENUE_TYPE AS REVENUE_TYPE , PFT.JV_FLIGHT_CARRIER_CODE AS JV_FLIGHT_CARRIER_CODE , PPT.PORT_TONNAGE_UID AS PORT_TONNAGE_UID , PPT.AWB_UID AS AWB_UID , PIS.INVOICE_SEPARATION_UID AS INVOICE_SEPARATION_UID , PFT.FLIGHT_TONNAGE_UID AS FLIGHT_TONNAGE_UID FROM PN_FLT_TONNAGES PFT , FZ_AIRLINES FA , PN_TONNAGE_FLT_PORTS PTFP , PN_PORT_TONNAGES PPT , FF_AIRCRAFT_SERVICE_TYPES FAST , SR_PN_INVOICE_SEPARATIONS PIS --new , SR_PN_INVOICE_SEP_DETAILS PISD--new , SR_PN_INV_SEP_PORT_TONNAGES PISPT --new WHERE PFT.FLIGHT_OPERATION_DATE >= trunc( CASE :rundate WHEN TO_DATE('01/01/1900', 'DD/MM/YYYY') THEN ADD_MONTHS(SYSDATE,-1) ELSE ADD_MONTHS(:rundate,-1) END, 'MON') AND PFT.FLIGHT_OPERATION_DATE < trunc( CASE :rundate WHEN TO_DATE('01/01/1900', 'DD/MM/YYYY') THEN TRUNC(SYSDATE) ELSE TRUNC(:rundate) END, 'MON') AND PFT.TYPE IN ('C', 'F') AND PFT.RECORD_TYPE = 'M' AND (PFT.TERMINAL_OPERATOR NOT IN ('X', 'A') OR (PFT.TERMINAL_OPERATOR <> 'X' AND FA.CARRIER_CODE IN (SELECT * FROM SPECIAL_HANDLING_AIRLINE) AND PPT.REVENUE_TYPE IN (SELECT * FROM SPECIAL_REVENUE_TYPE) AND PPT.SHIPMENT_FLOW_TYPE IN (SELECT * FROM SPECIAL_SHIPMENT_FLOW_TYPE) AND PFT.FLIGHT_OPERATION_DATE >= (select EFF_DATE from SPECIAL_HANDLING_EFF_DATE) )) AND PFT.DELETING_DATETIME IS NULL AND FA.AIRLINE_UID = PFT.AIRLINE_UID AND FA.DELETING_DATETIME IS NULL AND PTFP.FLIGHT_TONNAGE_UID = PFT.FLIGHT_TONNAGE_UID AND PTFP.RECORD_TYPE = 'M' AND PTFP.DELETING_DATETIME IS NULL AND PPT.TONNAGE_FLIGHT_PORT_UID (+)= PTFP.TONNAGE_FLIGHT_PORT_UID AND PPT.RECORD_TYPE (+)= 'M' AND PPT.DISCREPANCY_TYPE (+)= 'NONE' AND PPT.ADJUSTMENT_INC_FLAG (+)= 'Y' AND PPT.DELETING_DATETIME (+) IS NULL AND FAST.AIRCRAFT_SERVICE_TYPE_UID = PFT.AIRCRAFT_SERVICE_TYPE_UID AND FAST.DELETING_DATETIME IS NULL AND PIS.TEMPORAL_NAME = TO_CHAR((CASE :rundate --new WHEN TO_DATE('01/01/1900', 'DD/MM/YYYY') THEN TRUNC(SYSDATE) ELSE TRUNC(:rundate) END ), 'YYYYMM') || '00' AND PIS.INVOICE_SEPARATION_UID = PISD.INVOICE_SEPARATION_UID --new AND PISD.INVOICE_SEP_DETAIL_UID = PISPT.INVOICE_SEP_DETAIL_UID --new AND PISPT.PORT_TONNAGE_UID = PPT.PORT_TONNAGE_UID --new AND PIS.PRINT_SUPPORTING_DOC = 'Y';上面是oracle的写法,请转成spark SQL的写法。

2023-06-02 上传