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.

Concept illustration for Bakery: A sunlit artisan bakery production corner with a spiral mixer, dough on a wooden bench, flour sacks without labels and a full cooling rack beside the oven.

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.

Original opening cash budget, $; replace amounts with local quotes and payment dates
CategorySelected cash useAmount
CAPEXFood-preparation premises fit-out24,000
CAPEXInstalled oven and proofer28,000
CAPEXMixers and dough-preparation equipment14,000
CAPEXRefrigeration and display13,000
CAPEXRacks, smallwares and POS equipment9,000
Pre-opening expensePlans, permits and professional setup3,000
Pre-opening expenseRecruitment and training before trading4,500
Pre-opening expensePre-opening rent, utilities, insurance and cleaning4,000
Pre-opening expenseOpening signage and promotion2,500
Working cashRefundable lease/security deposit6,600
Working cashInitial ingredients and packaging stock3,000
Working cashReserve: two assumed fixed-cost months at $20,55041,100
TotalSelected opening cash allowance152,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.

Original monthly fixed cash OPEX, $; scheduled payroll is not deducted again per loaf
CommitmentMonthly amount
Crew and manager payroll including employer allowance14,640
Rent and common charges3,300
Base utilities, excluding the variable oven allowance below650
Operating insurance350
Equipment maintenance300
POS and software180
Cleaning, pest control and waste services420
Marketing350
Accounting and administration220
Recurring fees140
Total fixed monthly cash20,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.

Original variable OPEX and contribution at the selected bake schedule; $ per month
ItemCost basisAmount
Ingredients5,760 dough starts × $1.106,336.00
Variable oven energy5,760 dough starts × $0.12691.20
Packaging4,800 sold loaves × $0.20960.00
Card processing3% of $33,600 net sales1,008.00
Total variable cashIncludes the cost of rejects and unsold production8,995.20
Contribution before fixed OPEX4,800 sold loaves × $7 less variable cash24,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.

Original sales sensitivity with four batches per day held unchanged; $
Monthly sold loavesNet revenueResult after variable and fixed OPEX
4,00028,000−1,217.20
4,185 break-even count29,2951.95
4,800 planned33,6004,054.80
5,472 all good loaves sold38,3048,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

Bakery KPIs for the original case; none is an asserted industry target
KPI and denominatorCase value
Good-unit bake yield: good loaves ÷ dough pieces started5,472 ÷ 5,760 = 95.0%
Sell-through: sold loaves ÷ good saleable loaves4,800 ÷ 5,472 = 87.7%
Unsold rate: unsold good loaves ÷ good saleable loaves672 ÷ 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 hours240 ÷ 320 = 75.0%; excludes counter/manager hours from both numerator and denominator
Average customer check: net retail sales ÷ actual customer transactionsRequires 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

Read the supporting planning guide

Bakery Financial Planning Guide