FP&A forecast accuracy case
A total forecast can look reasonable while business units carry persistent offsetting bias.
Wall Street Playbook ·
Worked case
Unit A forecast $100, $110, and $120 in three months, with actuals of $90, $100, and $110. Using forecast minus actual, A’s average signed error is +$10. Unit B forecast $80, $90, and $100 and realized $90, $100, and $110. B’s average signed error is −$10. The total error is zero each month, but each unit misses by $10 every time.
Recommendation
Use signed error to detect direction and absolute error to quantify miss size. Review assumptions separately with A and B before accepting a consolidated score. If A is using booked orders and B only shipped orders, reconcile both to the same forecast definition and confirm there is evidence the pattern will persist.
FP&A Interview & Case Workbook
Get the complete guide when you’re ready for more practice.
Sale price $50.15 Original price $59