Restaurant 5-Year Plan & Menu Costing Workbook
The Restaurant 5-Year Plan & Menu Costing Workbook is a planning workbook of eight sheets for a restaurant, cafe or food-truck business. Ingredient and menu prices move the food cost %, and the cost of goods, the break-even point and the 60-month projection follow it.
Price
$39, a one-off payment. The licence covers one business and one user. Purchases are processed by Gumroad.
What the download contains
- Two .xlsx files: a blank template and a worked example. The worked example uses invented numbers for an invented restaurant.
- The buyer licence (LICENSE-BUYER.md).
- A read-me (README.md).
What is in the workbook
- How to use: what each sheet does, the colour code for input and formula cells, the scope limits and the AI-assistance disclosure.
- Assumptions: named input cells for the opening date, seats, covers by weekday band, average check, operating costs, loan terms, a tax rate placeholder and growth rates.
- Startup costs: a pre-opening budget in seven categories, three funding lines labelled Owner cash, Loan and Other funding, and a Funding gap line.
- Ingredients: a price list of up to 300 ingredients, each with a unit, a price, the units per purchase and a usable share.
- Menu costing: up to 200 menu items with up to 12 recipe lines each, showing cost per portion, food cost % and contribution margin per item, and a sales-mix weighted food cost %.
- 5-year projection: 60 monthly columns and 5 annual columns, from covers and average check with a ramp-up, through cost of goods, operating costs and EBITDA, to loan interest, principal and cash flow.
- Break-even: break-even revenue, covers per open day and months to cumulative break-even, with a 5 by 5 sensitivity table over average check and food cost %.
- Dashboard: one page of key outputs and an input check list.
The file has no macros and no links to other files.
What it does not do
It has no balance sheet and does not compute tax. Break-even revenue, covers per open day and months to cumulative break-even are before loan payments and tax. It is a planning tool, not financial, tax, legal or lending advice. No figure in either file is a benchmark or a forecast.
Compatibility
Formulas are restricted to a documented function allowlist: SUM, SUMIFS, SUMPRODUCT, INDEX, MATCH, IF, IFERROR, MIN, MAX, ROUND, EDATE, PMT, IPMT, PPMT, TEXT. Both workbooks use no other function.
The file has not been tested in Excel. The file has not been tested in Google Sheets. Northgate does not promise identical results in Google Sheets.
Refunds
Section 6 of LICENSE-BUYER.md in the download says you may ask for a full refund of the price you paid within 14 days of the purchase date.
To ask, email legal@northgate-enterprises.com from the address you bought with, or give that address in your message, and say you want a refund. The refund is issued through Gumroad.
Support
For a support question, write to legal@northgate-enterprises.com. Northgate replies to a message sent to legal@northgate-enterprises.com within 3 business days. Emails to Northgate, refund requests included, are sorted with an AI service, as PRIVACY.md in the download describes.
Read more
- How a restaurant financial model fits together
- Restaurant menu costing: working out food cost % per dish and across the menu
How it was made
This workbook was built with AI assistance and generated by a script that has automated tests.
Privacy and terms
Read the privacy notice and the terms. The workbook is sold by Northgate Enterprises LLC.