Request: The buyer has been assigning A status by selling price. Rebuild consumption values, cumulative shares and variability for two products. Deliver the numerical evidence for a differentiated policy and keep zero-demand variation flagged instead of pretending it is stable demand.
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 has been assigning A status by selling price. Rebuild consumption values, cumulative shares and variability for two products. Deliver the numerical evidence for a differentiated policy and keep zero-demand variation flagged instead of pretending it is stable demand.
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.
ABC starts with annual consumption at cost: units consumed times unit cost. A high unit price alone does not establish A status. Neither does a high stock balance. Rank annual usage values before calculating cumulative shares. The class cutoffs are local policy, not a universal law. The formula stays linked to the inputs when quantities change.