How do production, demand, pricing, and channel assumptions shape the commercial plan?
Model profile
Bakery
An artisan bakery modelled around the decision that defines one: how much to bake at four in the morning for customers who arrive later. Every fresh line has a daily demand and an over-bake buffer, and what sells, what sells out, what goes on the day-old shelf and what is thrown away follow from that, with each line's bake tested against the optimum its own margin and waste cost imply. The oven is the constraint, shared between the counter, wholesale standing orders and celebration cakes. Every recipe is costed from the flour and butter price, bakers are rostered to the bake rather than to a salary line, and the plan is underwritten on the cover ratios a small-business lender tests.
Decision scope
Questions this model helps you examine
What capacity, working capital, operating cost, and funding does the business require?
How do downside cases and key sensitivities affect cash flow and investment returns?
Model capabilities
What this model includes
The profile below is generated from the same catalogue and workspace definitions used by the application.
- Bake plan per product line: demand, variability and an over-bake buffer, with sell-through, sell-outs, day-old sales and waste from the newsvendor result
- Each line's over-bake tested against its critical-ratio optimum, so the cost of waste and the cost of an empty shelf are weighed explicitly
- Oven capacity in tray-minutes, shared between the retail bake, wholesale standing orders and celebration cakes
- Recipes costed from flour, butter, sugar, egg and dairy prices that each inflate at their own rate
- Bakers rostered to the hours the bake needs at a night premium, with salaried bakers displacing hourly hours
- Counter staff rostered to the transactions served rather than to a flat headcount
- Wholesale accounts priced off retail, delivered per drop, on trade terms with bad debt
- Celebration cakes with deposits held as a liability, and catering carried from the reference
- Ingredient stock in days of usage, card and wholesale receivables, and supplier payables
- Capital items with useful lives and the reference's reinvestment cycles
- Food cost, labour, prime cost, rent, waste and oven load gated against the sector's published bands
- Debt service and fixed charge cover on a trailing twelve months, with a covenant holiday for the ramp
- Break-even revenue per trading day, the number an owner can check against the till
- A single-site exit multiple with the share of value coming from the terminal assumption published and tested
- Tornado, the reference's three cases and named shocks, goal seek, stress thresholds and a correlated Monte Carlo on flour, butter and demand
Build the case
Inputs and workspaces
- AssumptionsTrading pattern, the oven, commodity prices, labour, occupancy and working capital
- Channels and bake planCounter demand, the over-bake and the day-old shelf, wholesale, celebration cakes and catering
- FinancingEquity, the term loan, covenants and the covenant holiday
- AnalyticsTax, valuation, the Monte Carlo and its volatilities
Review the result
Outputs and analysis
- Net present valueAt the discount rate
- Project IRRUnlevered, after tax
- Equity IRRLevered, to the exit
- Final-year revenueLast twelve months
- Final-year EBITDA marginLast twelve months
- Food costIncluding waste, share of revenue
- Labour costShare of revenue
- Prime costFood plus labour over revenue
- 13 additional metrics in the workspace
- Financial statementsDetailed schedules
- Bake plan, oven, channels, covenants & valuationDetailed schedules
Designed for review
Who this model is for
- Founders and business owners
- Production and commercial teams
- Financial advisers
- Investors and lenders
Governed evidence
The review trail stays with the result.
Each completed calculation preserves the model version, saved inputs, reporting-currency snapshot, immutable run, and result fingerprint used for its reports.
- Version-controlled calculation logic
- Saved assumptions and scenarios
- Immutable calculation runs
- Reporting context preserved in exports
Ready to explore the case?