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.
The dashboard visualizes the control panel with main indicators and graphs obtained from the sales control and technical sheets.

Menu Engineering Excel Spreadsheet Template
average rating 4.5 out of 5
Based on 2 reviews
  • 5 Stars
    1 Review
  • 4 Stars
    1 Review
  • 3 Stars
    0 Reviews
  • 2 Stars
    0 Reviews
  • 1 Star
    0 Reviews
100% of reviewers would recommend this product to a friend
2 Reviews
Reviewed by Nelson Martins Tristao J.
Verified Buyer
I recommend this product
Como você usou a planilha adquirida?
No planejamento de um novo projeto
Qual o seu nível de conhecimento de Excel?
O que você usava antes da planilha?
Uma planilha própria
Age Range
55 - 64
O que lhe agradou mais no produto?
  • Facilidade de Preenchimento
Rated 5 out of 5
Review posted


Ótima planilha

Quanto tempo você ganhou com essa planilha?
Rated 3 out of 5
Was this helpful?
Reviewed by Mudanças b.
Verified Buyer
I recommend this product
Rated 4 out of 5
Review posted

4 Stars

Alguns pontos passíveis de edição simples poderiam ser liberados. Por exemplo: a colocação da vírgula nos valores para conseguir ter três dígitos do lado direito da vírgula.

Was this helpful?
Download Free Trial Version

Product Specs:

  • License to 3 Computers
  • 100% Editable File
  • Immediate Access
  • Works on MAC and PC
  • All Excel Versions
  • Premium Support
  • Over 30.000 satisfied customers