Request: The operations manager needs a feasible monthly family plan. Rebuild projected supply, overload hours and closing backlog for two scenarios. Keep negative supply balances visible and do not confuse output with fulfilled orders. The final workbook identifies what demand can remain unserved despite a busy production line.
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 operations manager needs a feasible monthly family plan. Rebuild projected supply, overload hours and closing backlog for two scenarios. Keep negative supply balances visible and do not confuse output with fulfilled orders. The final workbook identifies what demand can remain unserved despite a busy production line.
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 sales and operations plan reconciles opening stock, feasible supply and agreed demand. Use one product-family unit and one planning bucket. A negative closing balance is an exposed shortage, not a zero to hide. Unapproved upside demand stays outside the consensus baseline. The formula stays linked to the inputs when quantities change.