Multi-location staffing forecast FP&A interview case
Find where staffing capacity is constrained at the location level. An attractive total capacity figure can hide an unserved queue.
Wall Street Playbook ·
Work the capacity test
Three locations each have 300 bookable hours. Forecast demand is 390, 260, and 230 hours, or 880 hours total against 900 hours capacity. Without transfers or overtime, the overloaded site can serve only 300 hours, for 790 hours served across all three sites and 90 hours of unmet demand.
Assume 60 hours of idle staff time can transfer to the overloaded site for $900. Transfer capacity reduces unmet demand to 30 hours. At $40 of contribution per recovered service hour before transfer cost, the transfer adds $1,500 net.
What to tell the operator
Validate travel time, skill requirements, and demand confidence before treating idle hours as fungible. Recheck the decision if flexible labor would cost less or if planned demand would move to another period without losing revenue.
FP&A Interview & Case Workbook
Get the complete guide when you’re ready for more practice.
Sale price $50.15 Original price $59