Plan the production, then the shop
A bakery is two businesses sharing an address. Behind the counter is a manufacturing operation with fixed capacity, long lead times and committed costs. In front of it is a retail business with variable demand. Most plans describe only the second, which is why they miss the constraint that actually governs the numbers.
Start with the oven. It has a fixed capacity per bake and a fixed number of bakes in a working night, and that product is your maximum output. Everything else follows: the labour needed to fill it, the ingredients it consumes, and the sales required to clear it. If the maximum output multiplied by realistic selling prices does not comfortably exceed your fixed costs, no amount of marketing fixes the plan — the oven is too small, or the rent is too high.
Wastage belongs in the forecast
Every bakery bakes ahead of demand, and the difference between what was baked and what sold is a real cost that never appears on an invoice. Plans routinely omit it, which quietly overstates gross margin by several points and makes an unviable site look workable.
Put it in as an explicit percentage of production. Then plan the ways it comes down, because they are what separates bakeries that make money from ones that do not. A wholesale round committed the week before is production with no wastage risk at all. Freezing surplus dough rather than baked goods converts a perishable into stock. Discounting the last hour recovers ingredient cost on what would otherwise be thrown away. Each of these is worth modelling as a separate line, because together they frequently move the margin more than a price rise would.
The VAT question, in detail
No other food business has a VAT position this awkward. A plain loaf is zero-rated. A chocolate digestive is standard-rated because it is a chocolate-covered biscuit, while a chocolate cake is zero-rated because it is a cake. The same brownie is zero-rated in a paper bag and standard-rated on a plate at a table.
For a bakery with seating and a mixed range, that means the effective VAT rate depends entirely on the sales mix, and the sales mix changes with the seasons. Applying a single assumed rate to total turnover produces a forecast that is wrong in a direction you will not discover until the first return. Split the sales lines in the plan and apply the treatment to each. It takes an extra hour and it is the difference between a cash flow that holds and one that does not.
Where SquarePlan fits
You enter your product lines with their costs and prices, your wastage assumption, your production volumes, the equipment and its financing, and the rent and rota. SquarePlan builds the monthly cash flow, the break-even point and the profit and loss, with the VAT position calculated across the sales mix rather than blended into one rate. Change the wholesale share or the wastage percentage and you can see what it does to the year before you commit to an oven.