Cloud hosting cost variance FP&A case
Explain whether a gross-margin decline comes from customers using more of the product or from rising unit cost. Build a bridge the product team can act on.
Wall Street Playbook ·
Work the operating bridge
Budget is 4 million compute units at $0.020 per unit, or $80,000. Actual usage is 5 million units at $0.022 per unit, or $110,000. The unfavorable hosting cost variance is $30,000. At the budget rate, usage explains $20,000. The rate difference on actual volume explains $10,000.
At $500,000 of unchanged revenue, the hosting variance reduces gross margin by 6 percentage points if other costs are flat.
Present a recommendation
Ask which product or customer cohorts drove usage. Check provider rates, workload efficiency, and committed capacity separately. Assign the usage question to Product or Engineering and the rate question to the team that owns infrastructure purchasing. If revenue also changed, rebuild the margin bridge before presenting this simple six-point result.
FP&A Interview & Case Workbook
Get the complete guide when you’re ready for more practice.
Sale price $50.15 Original price $59