This 40-minute assessment uses original planner, buyer and logistics questions. It is a practical job-test format, not an ASCM exam or a certificate. The clock continues between questions and across reloads. State the grain, time unit and denominator before choosing a 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.
WAPE divides total absolute forecast error by total actual demand. Aggregate the two totals before dividing; averaging line percentages weights small lines too heavily. A period with zero demand still contributes its absolute error. If all demand is zero, this exercise returns the agreed sentinel 0. The formula stays linked to the inputs when quantities change.