Business financial model file
Bakery Financial Model
Plan a US bakery's startup investment, monthly operating costs and working cash with a bread-production example that makes yield, unsold stock and break-even sales explicit.

Separate startup investment, pre-opening expense and working cash
For an original leased takeaway-bread bakery illustration, selected CAPEX is $88,000, pre-opening expenses are $14,000 and working cash is $50,700, totaling $152,700. These are planning assumptions, not a US startup-cost range or supplier quotes. The case excludes a café, wholesale credit accounts, delivery vehicles and buying the premises.
| Category | Selected cash use | Amount |
|---|---|---|
| CAPEX | Food-preparation premises fit-out | 24,000 |
| CAPEX | Installed oven and proofer | 28,000 |
| CAPEX | Mixers and dough-preparation equipment | 14,000 |
| CAPEX | Refrigeration and display | 13,000 |
| CAPEX | Racks, smallwares and POS equipment | 9,000 |
| Pre-opening expense | Plans, permits and professional setup | 3,000 |
| Pre-opening expense | Recruitment and training before trading | 4,500 |
| Pre-opening expense | Pre-opening rent, utilities, insurance and cleaning | 4,000 |
| Pre-opening expense | Opening signage and promotion | 2,500 |
| Working cash | Refundable lease/security deposit | 6,600 |
| Working cash | Initial ingredients and packaging stock | 3,000 |
| Working cash | Reserve: two assumed fixed-cost months at $20,550 | 41,100 |
| Total | Selected opening cash allowance | 152,700 |
The refundable deposit ties up cash without becoming monthly rent expense. Pre-opening payments belong before the first trading month; operating insurance and payroll below cover the later trading period. Check that equipment quotes include the required installation, freight and applicable purchase taxes. The reserve is a chosen fixed-commitment buffer, not proof of adequate total funding or two months of zero-sales baking: continued production also consumes ingredients and energy.
FDA food-business guidance explains that requirements depend on the food and business activity, with retail food establishments generally overseen by state and local government. Confirm the actual health, premises and food-safety requirements before agreeing a fit-out or permit allowance. For scope context, the Census 2022 Retail Bakeries classification concerns on-premises production from flour for retail sale, rather than treating every café or wholesale operation as identical.
Budget the monthly crew and fixed OPEX
Assume 24 trading days, two bakers paid for 160 hours each at $22/hour, a counter worker paid for 160 hours at $18/hour and a paid manager for 80 hours at $26/hour. Gross wages total $12,000; an original 22% employer-cost allowance adds $2,640. Replace that allowance with actual payroll taxes, benefits and insurance; it is not a statutory US percentage or owner-distribution forecast.
For comparison, BLS reports a national median baker employee wage of $17.86/hour and $37,160/year for May 2025. That is a reported all-industry employee-pay observation, not a 2026 local hiring quote, fully loaded employer cost or recommended bakery selling price. None of the rent, equipment or operating assumptions here is a national benchmark.
| Commitment | Monthly amount |
|---|---|
| Crew and manager payroll including employer allowance | 14,640 |
| Rent and common charges | 3,300 |
| Base utilities, excluding the variable oven allowance below | 650 |
| Operating insurance | 350 |
| Equipment maintenance | 300 |
| POS and software | 180 |
| Cleaning, pest control and waste services | 420 |
| Marketing | 350 |
| Accounting and administration | 220 |
| Recurring fees | 140 |
| Total fixed monthly cash | 20,550 |
Cost the dough started, not only the loaves sold
Assume four batches of 60 dough pieces per day: 96 batches and 5,760 pieces in the month. A 95% good-unit bake yield leaves 5,472 saleable loaves after 288 rejects. Selling 200 loaves per day means 4,800 monthly sales and 672 good loaves left unsold. The case assigns zero recovery revenue to rejects and unsold goods; it does not assume a donation or tax benefit.
The oven schedule allows four complete 90-minute cycles in six hours per trading day, including loading and turnaround. At 2.5 direct baker person-hours per batch, production uses 240 of the bakers' 320 paid hours; the remaining 80 cover the selected other work. Elapsed oven hours are not person-hours. Verify proofing, cooling racks, cleaning and the actual daily crew sequence before accepting these aggregate limits.
| Item | Cost basis | Amount |
|---|---|---|
| Ingredients | 5,760 dough starts × $1.10 | 6,336.00 |
| Variable oven energy | 5,760 dough starts × $0.12 | 691.20 |
| Packaging | 4,800 sold loaves × $0.20 | 960.00 |
| Card processing | 3% of $33,600 net sales | 1,008.00 |
| Total variable cash | Includes the cost of rejects and unsold production | 8,995.20 |
| Contribution before fixed OPEX | 4,800 sold loaves × $7 less variable cash | 24,604.80 |
At these sales, the selected operating result is $24,604.80 minus $20,550, or $4,054.80 before finance, income tax, replacement capital and working-capital changes. The illustration assumes same-month customer receipts and payments, with stock replenished to its opening level. A real reserve decision needs dated purchases, payroll and card settlements; monthly totals do not prove that every week's payments can be made.
Find break-even for this production schedule
Keep all 5,760 dough starts in the cost base when testing lower sales. Ingredients and variable oven energy still cost $7,027.20 for that schedule. Each additional sold loaf from the scheduled bake brings $7 less $0.20 packaging and $0.21 processing: $6.59 toward those production costs and fixed OPEX.
Break-even is therefore ($20,550 + $7,027.20) ÷ $6.59 = 4,184.70 loaves, rounded up to 4,185 whole monthly sales and $29,295 revenue. That averages 174.375 loaves over 24 days; a constant whole-loaf daily target of 175 would produce 4,200 sales. A different batch schedule, product mix, markdown or wage commitment changes the calculation. The SBA planning method supports matching contribution with the costs being tested; it supplies none of these bakery amounts.
| Monthly sold loaves | Net revenue | Result after variable and fixed OPEX |
|---|---|---|
| 4,000 | 28,000 | −1,217.20 |
| 4,185 break-even count | 29,295 | 1.95 |
| 4,800 planned | 33,600 | 4,054.80 |
| 5,472 all good loaves sold | 38,304 | 8,483.28 |
The last row is an output ceiling under the assumed yield, not evidence of customer demand. Increasing oven capacity does not create buyers or remove proofing and labor constraints. If smaller batches reduce waste, rebuild both production cost and available good output rather than retaining an average per-sold-loaf cost from the old schedule.
Measure yield, sell-through and labor separately
| KPI and denominator | Case value |
|---|---|
| Good-unit bake yield: good loaves ÷ dough pieces started | 5,472 ÷ 5,760 = 95.0% |
| Sell-through: sold loaves ÷ good saleable loaves | 4,800 ÷ 5,472 = 87.7% |
| Unsold rate: unsold good loaves ÷ good saleable loaves | 672 ÷ 5,472 = 12.3%; separate from the 5% bake rejects |
| Ingredient cost per sold loaf: ingredient cost of all starts ÷ sold loaves | $6,336 ÷ 4,800 = $1.32, rather than $1.10 per dough start |
| Direct production share: direct batch person-hours ÷ all paid baker hours | 240 ÷ 320 = 75.0%; excludes counter/manager hours from both numerator and denominator |
| Average customer check: net retail sales ÷ actual customer transactions | Requires POS transaction counts; 4,800 loaves are not automatically 4,800 customer covers |
Connect the production plan to the selected financial model
The official Bakery Financial Model listing describes an editable five-year forecast built from customer covers, average checks, category mix, staffing, recurring costs and dated capital spending, with profit and loss, cash-flow, break-even and dashboard outputs.
Translate the bread units above into actual basket sizes and customer transactions before entering a cover/check forecast. The unchanged bakery planning guide addresses a different wholesale-versus-retail opportunity-cost decision; its assumptions are not this startup budget.
Planning guide
