Lab 1
Draft Acme’s FY2027 budget in an hour
Scenario
Acme Services ($1.8M revenue, 12 employees) is budgeting FY2027 at $2.1M with two known changes: a second location whose $4,200/month rent starts in July, and one field technician hire planned for April at $58,000/year fully loaded. You have 18 months of actuals in Fintra.
Steps
- 1
Create "FY2027 Operating Budget", monthly granularity, fiscal year January–December 2027.
Expected: An empty budget grid appears with your P&L accounts as rows and 12 months as columns.
- 2
Fill Service revenue with the seasonality method against a $2,100,000 annual target.
Expected: Monthly revenue follows the historical curve (summer months noticeably higher) and sums to $2.1M.
- 3
Fill Wages with driver-based: current headcount cost per month, plus the new tech at $4,833/month from April.
Expected: Wages step up from April onward by roughly $4,833.
- 4
Fill Merchant fees as 2.9% of revenue and Commission expense as 5% of revenue.
Expected: Both lines track the revenue curve month by month.
- 5
Fill the remaining expense lines with prior year + 3%, then manually override Rent to add $4,200/month from July.
Expected: Rent shows the July step; other lines mirror last year’s pattern plus 3%.
- 6
Review budgeted net income by month, take a snapshot named "pre-approval draft", and submit for approval.
Expected: The budget enters the approval workflow with the snapshot recorded.
Checkpoints - you got it right if…
- Revenue sums to exactly $2,100,000 with a seasonal (not flat) shape
- Wages and Rent both show visible step changes in the right months (April, July)
- Merchant fees and Commission move proportionally with revenue
- A named snapshot exists and the budget is awaiting approval