Independent demonstration · Synthetic data
FP&A Operating Forecast
Harbor Service Co. · Fictional subscription service business
All data is synthetic. This is an independent portfolio demonstration—not an employer project, client engagement, or actual business result.
Forecast assumptions
July–December only · Base scenario
Starting client count for the forecast
Net new clients added each month, Aug–Dec
Average monthly service revenue
Outsourced delivery; excludes payroll
Employees; constant July–December
Fully loaded: salary, benefits, payroll taxes
Full-year revenue
$2,337,510
-$60,090 · U-2.5%
Full-year operating profit
$377,605
-$76,715 · U-16.9%
Full-year operating margin
16.2%
Operating profit ÷ revenue
July–December operating profit
$232,560
Forecast margin: 18.7%
Monthly outlook vs. budget
12-month P&L
USD · Jan–Jun actuals + Jul–Dec forecast · F = favorable · U = unfavorable
| Latest outlook | JanActual | FebActual | MarActual | AprActual | MayActual | JunActual | JulForecast | AugForecast | SepForecast | OctForecast | NovForecast | DecForecast | FY outlook | FY budget | FY variance |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | $171,500 | $174,240 | $183,340 | $184,080 | $187,950 | $194,400 | $198,000 | $201,600 | $205,200 | $208,800 | $212,400 | $216,000 | $2,337,510 | $2,397,600 | -$60,090 · U-2.5% |
| Direct costs | $54,880 | $57,499 | $58,669 | $57,065 | $60,144 | $62,208 | $63,360 | $64,512 | $65,664 | $66,816 | $67,968 | $69,120 | $747,905 | $719,280 | +$28,625 · U+4.0% |
| Gross profit | $116,620 | $116,741 | $124,671 | $127,015 | $127,806 | $132,192 | $134,640 | $137,088 | $139,536 | $141,984 | $144,432 | $146,880 | $1,589,605 | $1,678,320 | -$88,715 · U-5.3% |
| Operating expenses | $96,000 | $96,000 | $102,000 | $102,000 | $102,000 | $102,000 | $102,000 | $102,000 | $102,000 | $102,000 | $102,000 | $102,000 | $1,212,000 | $1,224,000 | -$12,000 · F-1.0% |
| Operating profit | $20,620 | $20,741 | $22,671 | $25,015 | $25,806 | $30,192 | $32,640 | $35,088 | $37,536 | $39,984 | $42,432 | $44,880 | $377,605 | $454,320 | -$76,715 · U-16.9% |
Display rounded to whole dollars; calculations use unrounded values. Cost rows are positive expenses, not cash payments.
Management summary
The current outlook produces $377,605 in full-year operating profit, versus $454,320 budgeted. The three largest contributors to the profit variance are first-half actuals (-$36,755), direct-cost rate (-$24,840), client volume (-$15,120).
Forecast payroll is $84,000 per month, plus $18,000 of fixed overhead. Monthly break-even revenue is $150,000 at the selected direct-cost rate.
Higher client volume and pricing increase revenue contribution, but additional employees and compensation reduce operating profit. Staffing may support delivery quality; capacity and service quality are not quantified in this model.
This is operating profit, not cash flow. Collection timing, working capital, capital spending, and financing are excluded.
Operating-profit bridge vs. original budget
- First-half actuals
- -$36,755 · U
- Client volume
- -$15,120 · U
- Revenue per client
- $0 · —
- Direct-cost rate
- -$24,840 · U
- Headcount
- $0 · —
- Compensation
- $0 · —
- Other operating expenses
- $0 · —
- Full-year profit variance
- -$76,715 · U-16.9%