Cafe and restaurant profit calculator

Cafe and restaurant business plan calculator

The restaurant profit calculator models two revenue channels: guest orders at the venue and orders handled with your own delivery. It calculates monthly revenue, food and packaging cost, gross profit, variable and fixed expenses, operating profit, break-even revenue, safety margin, investment need and estimated payback.

The calculator does not contain separate inputs for seats or table turnover. The sales plan is entered directly as orders per day and average check for each channel. Build these assumptions from the venue format, opening schedule, location research and actual observations, then test more than one scenario.

Orders at the venue

Enter guest orders per day, average check and the food-plus-packaging cost per order. Monthly venue revenue equals daily orders multiplied by average check and operating days. Direct cost is calculated from the same order volume.

Orders with your own delivery

Enter delivery orders per day, their average check and direct food and packaging cost. Add the cost of your own delivery in the variable expense block. Keeping delivery separate is important because average check, packaging and fulfilment economics may differ from dine-in orders.

Food cost, payroll and operating expenses

Revenue minus food and packaging cost gives gross profit. The model then deducts bonuses, delivery, marketing, turnover taxes and losses to calculate contribution. After that, staff and other fixed expenses are deducted to calculate operating profit.

Up to six staff roles can be added with headcount and salary. Fixed expenses also include rent, utilities, accounting, software support and other recurring payments. Enter a complete team and a realistic schedule cost; leaving out even one role can make the break-even estimate artificially low.

Restaurant startup investment

The startup section includes renovation, kitchen and sales equipment, software investment, other setup expenses, prepaid rent and a cash reserve. Inventory is estimated from direct cost and inventory days. Supplier payment delay reduces the amount that must be financed at the same time. Own capital and loans are recorded separately.

How break-even is calculated

1. Revenue from venue and own-delivery orders is combined.
2. Food and packaging cost is deducted to calculate gross profit.
3. Variable expenses are deducted to calculate contribution.
4. Payroll, premises and other fixed expenses are deducted to calculate operating profit.
5. If the contribution ratio is positive, fixed expenses are divided by it to find break-even revenue.

The safety margin shows how far forecast revenue is above the break-even level. Target order volume estimates the operations needed for the chosen profit goal. Payback appears only when monthly operating profit is positive.

How to test a cafe or restaurant plan

• Separate venue orders from own-delivery orders.
• Use recipe cards, packaging and current supplier prices for direct cost.
• Include the full team, payroll charges, rent, utilities, marketing and taxes.
• Avoid using an unsupported maximum order count for the launch period.
• Compare weak, base and strong order scenarios and their safety margins.

What the result means

A profitable forecast means the entered order volume and check cover the modeled costs. It does not guarantee demand. If break-even looks unrealistic, review average check, food cost, delivery expense, staffing and overhead. After opening, update the plan with actual orders, average checks, write-offs and expenses.