Kitchen Control Workbook: Excel for Recipe Costing, Prep and Menu Mix
The Kitchen Control Workbook is an Excel file that keeps your ingredient prices, recipe costing, daily prep and menu mix in one place. The example dishes use invented figures, so replace them with your own.
What is inside
- A Read Me sheet that explains each tab
- Ingredients: your price list with usable yield and cost per usable unit
- Recipe Costing: one sheet per dish with cost per portion and food cost %
- Daily Prep Sheet: forecast covers, stock and prep
- Menu Mix: popularity and contribution by dish within each category It is an Excel file: yellow cells with blue text are inputs, and the example rows are there to delete.
It suits owners and head chefs who want a simple, connected set of sheets in Excel.
Download
Use it with a tool
Use it with: Recipe Cost Calculator and Menu Engineering Tool are the web versions of two of the tabs.
Frequently asked questions
Do the example figures matter?
No. They are invented and only show how the sheets work. Replace them with your own prices, recipes and sales.
Can I use it for many dishes?
Yes. Copy the Recipe Costing sheet for each dish, as the Read Me explains.
How to use this form
- Open the workbook and read the Read Me tab.
- Enter your ingredients and prices on the Ingredients sheet, with usable yield.
- Copy the Recipe Costing sheet for each dish and enter the quantities.
- Use the Daily Prep Sheet to forecast and plan prep.
- Enter sales on the Menu Mix sheet to see which dishes carry the menu.
- Update prices whenever a supplier changes them.
