Request: The service manager sees backlog even though production met its plan. Reconcile the opening obligations, physical supply and inventory position for two product families. The final backlog calculation must retain the unfulfilled commitment. Trace the event difference in SAP sales orders and deliveries.
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 service manager sees backlog even though production met its plan. Reconcile the opening obligations, physical supply and inventory position for two product families. The final backlog calculation must retain the unfulfilled commitment. Trace the event difference in SAP sales orders and deliveries.
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.
Committed demand uses available stock first. Net requirements are demand minus usable stock, floored at zero. Quarantined units cannot satisfy a customer order, even though they appear in the warehouse count. The formula stays linked to the inputs when quantities change.