Request: The demand planner compares a rolling forecast with a manual adjustment. Rebuild both products using the same information date, smoothing convention and WAPE denominator. The final checked error is the decision evidence; an appealing sales explanation cannot replace the calculation.
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 demand planner compares a rolling forecast with a manual adjustment. Rebuild both products using the same information date, smoothing convention and WAPE denominator. The final checked error is the decision evidence; an appealing sales explanation cannot replace the calculation.
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 forecast made before period four can use periods one through three only. Give these three observed periods equal weight. The next period is held out; including its actual demand leaks information that a planner did not have at the forecast date. The formula stays linked to the inputs when quantities change.