Spaces:
Sleeping
Sleeping
File size: 916 Bytes
d02bacd | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | # SOP-FIN-01: Finance Forecasting Standard Operating Procedure
Owner: Finance desk.
## Scope
Next-quarter revenue projection, plan-versus-actual variance, and break-even analysis for every CEO brief.
## Required steps
1. Build monthly revenue from cleaned orders via `monthly_revenue`.
2. Project next quarter using the trailing three months.
3. Apply a confidence band of plus-or-minus 15 percent around the projection.
4. Compare actual revenue to `plan_value` and produce `variance_abs`, `variance_pct`, and `variance_flag`.
- favorable if variance is above +2 percent
- on-plan if variance is within plus-or-minus 2 percent
- unfavorable if variance is below -2 percent
5. Compute break-even units as `fixed_cost / unit_margin`.
## Output contract
The Finance report must include `projection_next_quarter`, `confidence_band`, `variance_abs`, `variance_pct`, `variance_flag`, and `break_even_units`.
|