StepGeneral Description Calc PO How To
1.Needs :Display them , aging the forecast for the week of the month.
2.Customer Needs :Load them into weekly buckets using the Begin Date week.
2.aIf this item is non-stock, zero the forecast other than Customer Needs.
2.bIf the sum of the Customer Needs for a week ,
2.care greater than the week's forecast ,
2.duse the sum of the Customer Needs for the week as the forecast.
3.Inbound:Load them into weekly buckets using the Delivery Date week.
4.On Hand:Calculate the weekly On Hand adding the Inbound and
4a.subtracting the Needs.
5.Safety Quantity: Calculate the safety quantity for each week into the future by
5a.summing the forecast over the following Safety Time weeks.
5b.If the stated Safety Quantity is greater than any of these weekly calculated
5c.Safety Quantities , use the stated safety quantity for that week.
6.Shortfall:Subtract the weekly safety quantity from the projected on hand.
7.Desired Inbound:Calculate the Inbound Desired to cover these shortfalls.
8.Minimum/Multiple:Round the Inbound Desired to consider source minimums and multiples.
9.Calc PO:Backoff by the replenishment lead time to calculate when to order,.
10.Frequency:Adjust the Calc PO to consider the desired replenishment frequency.
11.Projected On Hand:Calculate the weekly On Hand adding the Inbound and
11a.subtracting the Needs and adding in the Calc PO's by expected arrval date.