Past SalesSep-07Oct-075.035.29
30.916.50.4570631.2815521.7320511.01454917.51455Nov-075.97Dec-075.89
Forecasted SalesJan-08Jan-08
5.55.5
Lead time (months):
Service level:Lead time demand:Standard Deviation:Service factor:Lead time factor:Safety stock:Reorder point:FormulasSUM(H4:J4)STDEV(B4:G4)NORMSINV(D7)SQRT(D6)D10*D11*D12D9+D13CommentsSumming the forecastsDeviation in the past salesInverse of the normal distributioSquare root of lead-time to forecasCombining factorsLead time demand + safety stoCalculationsBy Lokad.com, Copyright 2007
SalesJan-085.5stsalesributionrecast ratioty stock
因篇幅问题不能全部显示，请点此查看更多更全内容