FP培训教材(经典作品)500强企业

Inventec Supply Chain ManagementAPlanB2BD-PlanSUPPLIERSCUSTOMERSINVENTECSAPEDIRosetta NetAgilei2 FPi2 DFForecast NettingMasterPlanSDSales OrdersPPProduction OrderMMPurchase OrderSales Order ATPDaily EngineWeekly EngineCustomerForecastATPForecastCommitmentPIRDaily Production PlanMaterial Requirement Plan(JIT or SOI)BlanketPurchase OrderProduction Order RequirementCustomerOrdersOrder CommitmentOrder DeliveryCP01/CP07/CP08 PIRi2 SCPMaster PlanI2 FPModel Instruction(參考)BOM in SAP:129x6yyy129y129x6yyy129y129y111LPA111MBB131DDA129x6xxx142CD.142HD.142MR.142BY.Weekly Run流程圖Daily Run流程圖Weekly Job事項？08:00 採購維護Control Tab？08:30 產銷上傳Forecast08:3009:30 FP每周入料報表 FP每周多余料件報表 FP每周ERROR MESSAGE 報表09:30？採購依採購WEEKLY入料報表入料09:30？採購、產銷看無效料Report，處理無效料 產銷依FP ERROR MESSAGE 報表處理沒有BOM的問題15:00？採購依FP ERROR MESSAGE 報表來維護Control table及SAP的buyer code/Source list/qutoa/vendor data/rounding value/alternative part percentage 資料Daily Job事項08:00？產銷看Open sales order report？08:30產銷上傳成製生產排程08:3009:30 FP產生每日成製欠料報表(MAKE TO ORDER)FP每日成制工單報表FP每日ERROR MESSAGE 報表09:30？採購依採購DAILY入料報表通知廠商入料09:30？產銷依成製欠料報表來調整成製排程 依工單報表開工單,依FP ERROR MESSAGE 報表處理沒有BOM的問題15:00？採購依FP ERROR MESSAGE 報表來維護Control table及SAP的buyer code/Source list/qutoa/vendor data/rounding value/alternative part pecentage 資料Weekly RunWeekly 產銷工作說明Forecast時間：存放路徑:172.20.15.81shareScheduleWeekly_Schedule.xlsplantproduct_typelineplan_start_datepart_numberdemand_quantityeditorCPB1NORMALCBA12010/3/1LAC200ZZ99CN1000JERRYCPB2PILOTCBA22010/3/2LAC200ZZ99CN1000JERRYCPB2FRUCBA32010/3/3LAC200ZZ99CN1000JERRY每周入料報表採購料號品名Block 數量 庫存量跨廠調撥在途量配額廠商代碼414605406316001INSU-PC6403-ST.POINT-01(MYLAR,8*20*0.1T)02503405.00 0.00 0.00 0.5000000330016414605406316001INSU-PC6403-ST.POINT-01(MYLAR,8*20*0.1T)02503405.00 0.00 0.00 0.50000003305314146054A0002201LATP-PC6912-LCD BRACKET-01(3M467,195*4.001.00 0.00 0.00 1.00000003302904146054A0027401GASKET,NI/CU PPW FOF,10.0mm,6mm,3mm,RECT037566.00 0.00 0.00 1.00000003302704146054A0033301INSU-TC8245-LCM-01-PLUG(PC)00.00 0.00 0.00 1.00000003302904146054A0037501DSTP-TC8245-PCB-01(G9000,13x13)05734.00 0.00 0.00 1.00000003303444146054A0053901INSULATOR-INVERTER-DAINAMIC-01-TC8511 00.00 0.00 0.00 1.0000000330344每周多余料件報表 Procument_partBuyerDescrMaterial_groupCPB1_StockCPB1_FstockCPB1_Pstock 6013A0023001857RES-CHIP-475-1%-1/16W-0402-TAP726233006013A0023201857RES-CHIP-182-1%-1/16W-0402-TAP109394006013A0023201857RES-CHIP-182-1%-1/16W-0402-TAP109394006013A0023201857RES-CHIP-182-1%-1/16W-0402-TAP109394006013A0023301857RES-CHIP-750-1%-1/16W-0402-TAP619933006013A0023301857RES-CHIP-750-1%-1/16W-0402-TAP619933006013A0023701857RES-CHIP-200-1%-1/16W-0402-TAP219471006013A0024401857RES-CHIP-18.2-1%-1/10W-0603-TAP2096006013A0024401857RES-CHIP-18.2-1%-1/10W-0603-TAP2096006013A0024401857RES-CHIP-18.2-1%-1/10W-0603-TAP2096006013A0024701857RES-CHIP-33.2K-1%-1/16W-0402-TAP2584400每周ERROR MESSAGE 報表處理BOM errorERROR TYPEBUYERDESCRIPTIONBuyer Code 維護錯誤6060B1115201採購代碼維護錯誤(採購代碼為 278)Buyer Code 維護錯誤6Z60B1044701採購代碼維護錯誤(採購代碼為 AK1)Buyer Code 維護錯誤6Z61B0515501採購代碼維護錯誤(採購代碼為 217)沒有Maintain QuotaFE26053B0084201 沒有Maintain Quota沒有Maintain QuotaFK26060B0400501 沒有Maintain Quota沒有Maintain QuotaFK26060B0433201 沒有Maintain Quota沒有維護Safety LeadTime Control Table 2286013B0077901沒有 Maintain Transportation(採購代碼為 228,廠商代號為0000330066)沒有維護Safety LeadTime Control Table 8456060B1107101沒有 Maintain Transportation(採購代碼為 845,廠商代號為0000330540)沒有維護Vendor Code2176061B0515101 沒有維護 Vendor Code 和Source List(採購代碼為 217)沒有維護Vendor CodeAK16Z60B1044701 沒有維護 Vendor Code 和Source List(採購代碼為 AK1)Weekly 採購工作說明Control table maintainmaterialbuyervendortypetransportation_time safety_leadtimefrequency b2b_typeeditorcdtNULL7320000200011SOI7147Y餘玲華2010-04-20NULL7320000230457SOI7147Y餘玲華2010-04-20NULL7320000231303SOI7147Y餘玲華2010-04-20NULL7320000232392SOI7147Y餘玲華2010-04-20NULL7320000330002SOI171Y餘玲華2010-04-20NULL7320000330016SOI7147Y餘玲華2010-04-20NULL7320000330311SOI171Y餘玲華2010-04-20NULL7320000330585SOI171Y餘玲華2010-04-20NULL7320000330603SOI7147Y餘玲華2010-04-20NULL7320000330643SOI171Y餘玲華2010-04-20NULL732IEC-TP01SOI7147N餘玲華2010-04-20NULL7330000232992SOI7147Y餘玲華2010-04-20NULL7330000330110SOI777Y餘玲華2010-04-20Control Table各欄位含義(已經區分廠別)Buyer Code+Vendor Code 以材料6035B0006001為例，control table如下：Control table是根據採購與廠商的對應關係維護的，而不具體到料號，因此當有新的採購或者新的廠商時，一定要維護好control table才可正常入料BuyerVendorTypeTransportation timeSafety leadtimefrequencyB2B type846220049 SOI7147 YControl Table各欄位含義(料號)Material+Buyer Code+Vendor Code 設定料號Control table 根據料號,採購與廠商的對應關係 First priority以料號為主,找不到才使用不包括料號的control tablematerialbuyer vendortypeTransportation timeSafety leadtimefrequency6015B0017101709231988SOI7147Control table各欄位含義及影響Buyer Code：T-code:MM03 Purchasing ViewSAP的material master中所維護的採購員代碼Control table各欄位含義及影響T-code：ME03 Source ListVendor：SAP的source list中所維護的廠商編號（MRP寫“1”）Control table各欄位含義及影響 Type：SOI用根據Forecast算出的Weekly Pull List的W1上傳最大可交量JIT用根據Real Order算出的Daily Pull List的D1上傳最大可交量Control table各欄位含義及影響 Transportation time：運輸時間 Safety Leadtime：安全庫存時間 Frequency：採買頻率天數 B2B type：Y受B2B最大可交量管控N不受B2B最大可交量管控Weekly pull list與Control table的關係 針對SOI材料，首先，根據forecast計算出欠料的情況，然後將欠料根據control table維護的資料提前buffer後產生weekly pull listbuffer 天數=safety leadtime+transportation time+frequency Daily RunDaliy 產銷工作說明Open Sales Order Report產銷排程時間:?存放路徑:172.20.15.81shareScheduleDaily_Schedule.xls每日成制欠料報表每日成制工單報表每日ERROR MESSAGE 報表產銷處理的錯誤：1.Check no BOM回復執行時間:?資料格式：回EDI 855Daily 採購工作說明Bom替代料百分比替代料 在一個料號,有另1個以上的料號可互相替換 例如:下列1510B0035901有10個替代料,%分別下在不同4個料號上,各25 SAP T-CODE:CS03(僅查看)Quota 同一個料號,有2家以上的不同廠商 Source List將MRP設為“1”SAP T-CODE:ME03Source ListQuota百分比lQuota List Maintain各廠商分配的%SAP T-CODE:MEQ3Buyer CodeSAP T-CODE:MM03 Purchasing ViewSAP的material master中所維護的採購代碼FP 試算1Bom替代料百分比與Quota百分比差異 試算:151AXXX有2個替代料,見圖,如果forecast 151AXXX客人來了50pcs需求,V1/V2 會各下單多少?基本庫存如下 151AXXX沒庫存 601A 庫存5 pcs 601B 庫存10 pcs151AXXX151AXXX601A601A 20%601B601B 80%V1V1 70%V2V230%V3V3100%Answer料號料號庫存庫存需求需求151AXXX050601A5(50-5-10)*20%=7601B10(50-5-10)*80%=28Vendor%PRV170%7*70%=4.9(5)V230%7*30%=2.1(2)V3100%28151AXXX151AXXX601A601A 20%601B601B 80%V1V1 70%V2V230%V3V3100%FP 試算1Bom替代料百分比與Quota百分比差異每日ERROR MESSAGE 報表採購處理的錯誤：1.Check bom Usage_probability2.Check buyer code3.Check 沒有Maintain Quota4.Check not Maintain Vendor Code5.Check Vendor Name6.Buyer Code Maintain Error7.Not Maintain Safety LeadTime Control Table每日ERROR MESSAGE 報表ERROR TYPEBUYERDESCRIPTIONBuyer Code 維護錯誤6060B1115201採購代碼維護錯誤(採購代碼為 278)Buyer Code 維護錯誤6Z60B1044701採購代碼維護錯誤(採購代碼為 AK1)Buyer Code 維護錯誤6Z61B0515501採購代碼維護錯誤(採購代碼為 217)沒有Maintain QuotaFE26053B0084201 沒有Maintain Quota沒有Maintain QuotaFK26060B0400501 沒有Maintain Quota沒有Maintain QuotaFK26060B0433201 沒有Maintain Quota沒有維護Safety LeadTime Control Table 2286013B0077901沒有 Maintain Transportation(採購代碼為 228,廠商代號為0000330066)沒有維護Safety LeadTime Control Table 8456060B1107101沒有 Maintain Transportation(採購代碼為 845,廠商代號為0000330540)沒有維護Vendor Code2176061B0515101 沒有維護 Vendor Code 和Source List(採購代碼為 217)沒有維護Vendor CodeAK16Z60B1044701 沒有維護 Vendor Code 和Source List(採購代碼為 AK1)SAP 相關設定 Rounding ValueT-code：MM03 MRP1 View在Material Master Data內的MRP1根據Rounding Value 產生最小包裝量Ex:如果欠料只有5pcsRounding Value=10,000FP欠料報表的採購需求為10,000SAP 相關設定 Purchasing View設定Buyer CodeFP 試算2 加入Rounding Value 試算:151AXXX有2個替代料,見圖,如果forecast 151AXXX客人來了50pcs需求,V1/V2 會各下單多少?基本庫存如下 151AXXX沒庫存 601A 庫存5 pcs 601B 庫存10 pcs 601A/601B Rounding Value=50151AXXX151AXXX601A601A 20%601B601B 80%V1V170%V2V230%V3V3100%FP 試算2 加入Rounding Value Answer料號料號庫存庫存需求需求151AXXX050601A5(50-5-10)*20%=7601B10(50-5-10)*80%=28Vendor%PRV170%7*70%=4.9(5)PR:50V230%7*30%=2.1(2)PR:50-5-2=432PR=0V3100%28 PR:50151AXXX151AXXX601A601A 20%601B601B 80%V1V170%V2V230%V3V3100%FP 試算3 Pull List ReportMaterialMaterialDescDesc2/52/52/122/122/192/192/262/263/53/53/123/126035B00060016035B0006001FFC,26P,1L,2.16X0.5FFC,26P,1L,2.16X0.5X0.004,0.01/0.01,PDX0.004,0.01/0.01,PDMM0 0800800550550850850100100300300Rounding Value:1000Lot Size:MOpen Po:100Lead Time:14 days Q.請算出採購pull list report,W1值為多少?BuyerVendorTypeTransportation timeSafety leadtimeFrequencyB2B type846220049 SOI714 7YShortage ReportControl TableFP 試算3 Pull List Report共7+14+7天,從2/5開始到3/4的欠料數都會Show在第1周採購應該拉料800+550+850-100(open po)=2100同時，由於6035B0006001維護的 最小包裝數為1000pcs 因此在2/5的Weekly pull list中W1為3000pcs，即B2B上的最大可交量為3000pcs100Thank you