Request: The buyer reviews two product families before issuing purchase orders. Reconcile periodic targets, EOQ assumptions and full-carton quantities. The deliverable is a linked order recommendation with the pack rounding visible. Compare the documents in SAP purchasing and goods receipt.
Data: six linked worksheets contain original fictional quantities and cost assumptions. Each completed sheet stays in your workbook as you move to the next task.
Done: all six results pass, with the final numerical finding checked.
The buyer reviews two product families before issuing purchase orders. Reconcile periodic targets, EOQ assumptions and full-carton quantities. The deliverable is a linked order recommendation with the pack rounding visible. Compare the documents in SAP purchasing and goods receipt.
You work on Pine Harbor Distribution's fictional planning file. Before calculating, check the time period, the unit and which business event each input records. Keep those definitions in the workbook so another analyst can reproduce the result. The first task gives you the steps. Later tasks use new quantities, a boundary case and a handoff to another planner. Your answer is recalculated on a second copy of the inputs, so enter a formula rather than a number copied from the example.
A periodic review must cover demand during both the review interval and replenishment lead time. Build the target, add safety stock, then subtract inventory position. A negative result means no order under this policy. Do not subtract on-hand stock again after using inventory position. The formula stays linked to the inputs when quantities change.