Restaurant Menu Engineering Excel Spreadsheet Template

Restaurant Menu Engineering Excel Spreadsheet Template

Download this template

Enjoy all benefits of a LUZ Templates subscription:

  • 120+ spreadsheets
  • 80+ presentations
  • Usage lessons
  • Cancel anytime

Gain productivity in your consulting services with ready-to-use templates

Already a member? Download this template in the member’s area

Restaurant Menu Engineering Excel Spreadsheet Template

Ingredients Registration:
In the first tab, you need to register all the ingredients used in your kitchen defining their unit of measurement and cost for each unit.
Classification of Revenues and Units of Measure:
Along with the ingredients, you can create a classification for all your recipes and customize the units of measure used.
Technical Sheets:
Then you will enter into the focus of the spreadsheet which are 20 technical sheets of your dishes. In those 20 sheets, you can fill in the name, the classification, the ingredients, and the way of preparation.

Sales Control:
Record the sales of each of the registered dishes as datasheets to know your revenues, costs, and the profits from these sales.
Sales Report:
Monitor the monthly profits from the dishes sold in your restaurant.
Ranking of the Dishes:
Check out which dishes have generated a better result & profit by analyzing their performance ranking.
Dashboard:
The dashboard visualizes the control panel with main indicators and graphs obtained from the sales control and technical sheets.

Menu Engineering Excel Spreadsheet Template

×

 

Support LUZ

× .