Business financial model file
Catering Business Financial Model
Separate a catering company's kitchen and transport investment from the cash and crew required for each booked event.
Opening investment and working cash
The original illustration serves 50 guests per comparable event at $60 each. Reusable service equipment and a vehicle are investment cash, while an event's food and casual labor are variable. It is not a quote for a wedding venue or a national catering startup range.
| Cash use | $ |
|---|---|
| CAPEX: Production equipment | 24,000 |
| CAPEX: Refrigeration | 12,000 |
| CAPEX: Transport vehicle | 28,000 |
| CAPEX: Reusable event/service equipment | 10,000 |
| Pre-opening: Contracts, permits and setup | 4,000 |
| Pre-opening: Trial menus, pre-opening training and launch | 5,000 |
| Refundable deposit / tied-up cash | 6,000 |
| Opening stock / initial working inputs | 3,000 |
| Reserve: 2 selected fixed-cost months | 32,352 |
| Selected opening cash total | 124,352 |
CAPEX totals $74,000, pre-opening expense $9,000 and working cash $41,352. The deposit and opening stock tie up cash; they are not added again as monthly rent or consumed inputs. The reserve is a chosen fixed-cost buffer, not proof of full funding. Obtain actual installed/tax-inclusive quotes and dated opening payments.
Monthly fixed and variable OPEX
Permanent chef wages are assumed at $28/hour for 160 hours plus 20% employer costs; the coordinator is $4,000 gross/month plus 20%. Casual event labor below is already a loaded all-in rate and is not given the allowance twice. Kitchen rental and vehicle commitments remain even with fewer bookings.
| Commitment | $ per month |
|---|---|
| Permanent chef: loaded 160-hour roster | 5,376 |
| Coordinator: loaded monthly budget | 4,800 |
| Commissary rental | 3,000 |
| Base utilities | 500 |
| Insurance | 600 |
| Storage | 300 |
| Software | 200 |
| Marketing | 600 |
| Accounting/admin | 350 |
| Vehicle fixed commitments | 450 |
| Total selected fixed cash | 16,176 |
| Item | $ per unit |
|---|---|
| Net collected selling value | 3,000 |
| Food:50 guests ×$18 | 900 |
| Casual event crew:3 people ×8 hours ×$25 loaded | 600 |
| Event transport/consumables | 200 |
| Percentage-only fee allocation (3%) | 90 |
| Contribution before scheduled payroll/fixed OPEX | 1,210 |
The percentage fee is an aggregate allocation, with no fixed per-payment charge assumed. Unit contribution is not owner income: the full listed monthly roster and overhead still need coverage.
Capacity, break-even and a lower-sales case
Each 50-guest event assumes 16 prep person-hours: eight from the permanent chef and eight from a casual prep role. The $600 event labor line funds 24 casual person-hours at $25: eight prep hours plus 16 service hours from two eight-hour service roles. Each paid hour is counted once; the coordinator covers bookings and administration, with no production hours counted. The 160 paid chef hours permit 20 event-prep allocations at eight chef hours each; 14 events use 112 chef prep hours, leaving 48 for other chef work. Transport/service booking slots still limit the month to 16 events. Confirm the actual tasks, skills and timing before committing the crew.
For this fixed mix and commitment, whole-unit cash break-even is 14 completed 50-guest events per month: ($16,176) ÷ $1,210, rounded up. The aggregate capacity is 16 units; it does not establish customer demand or a workable daily sequence.
| Paid units | Net sales $ | Selected result $ |
|---|---|---|
| 10 | 30,000 | -4,076 |
| 14 (planned) | 42,000 | 764 |
| 16 | 48,000 | 3,184 |
Ten comparable events keep the permanent team and commissary commitment. The separate guide's 100-to 101 guest step shows why a guest increase can require a new crew/vehicle and reduce contribution; it is not this 50-guest monthly case.
Practical KPI definitions
Measure contribution per completed event and per billable guest after casual crew and transport. Compare confirmed, collectable bookings with crew slots; refundable deposits are not automatically earned income. Record the guest-count deadline and resource steps instead of applying one linear food margin to every party size.
This simplified month aligns collections and event payments; actual deposits, refunds and final balances need an event-level cash calendar. Debt, income tax and replacement spending are excluded.
Method context: SBA business planning. All case prices, wages, cost ratios, reserve and capacity inputs above are original planning assumptions.
What the selected model covers
The official Catering Service Financial Model listing describes weekday cover plans, midweek and weekend checks, category sales mix, salaries, staffing and dated investments. Calendar weekday counts build monthly revenue and annual summaries. Stated outputs include profit and loss, monthly and annual cash projections, dashboard charts and break-even indicators.
Price the resource step before raising the volume plan
Our original 100-guest event contributes $1,500. A 101st guest triggers $500 of extra crew and vehicle cost and reduces contribution to $1,025. Only at 121 guests does the enlarged booking begin beating the 100-guest contribution.
Confirm billable guests and the last date crew or transport can change. Translate a feasible event calendar into broader cover and staffing assumptions after pricing each resource step. The Catering Business planning guide develops the original worked case.
Planning guide