Burn Rate Excel Model
This is a small Excel project that calculates burn rate for two example client projects.
It compares budgeted hours, actual hours used, and hours remaining.
The file also includes fee calculations and a clustered column chart that shows Hours Used vs Hours Remaining for each client project.
What's inside:
- Budget sheet - Budget hours, hourly rate and total fee
- Actuals sheet - Actual hours worked, hourly rate and fee used (referenced Budget sheet using VLOOKUP)
- Burn_Calcs sheet - Summary and chart
Excel functions utilized
- SUMIF
- VLOOKUP
- Basic formulas
Why did I build this?
To showcase cross section of FP&A and Excel skills.
Screenshot:
