Sales and Margins forecast for Restaurants Free Excel Template

Sales and Margins forecast for Restaurants Free Excel Template.

With the following simple Excel template you can calculate finished product costs, you can plan menus costs and you can plan a monthly sales forecasts for a year of finished products, menus and drinks.

 

In addition, this tool calculates the income and the gross margin for finished products, menus and drinks based on sales forecasts.

 

This free Excel spreadsheet for planning costs, sales forecasts and calculating margins for Restaurants includes:

 

  • Configurable up to 10 Ingredients costs
  • Configurable up to 3 Drink costs
  • Configurable up to 10 finished products categories
  • Configurable up to 5 product costs
  • Configurable up to 1 Menus
  • Configurable up to 1 recipes per menu and 2 drinks per menu
  • Sales forecast for up to 5 recipes, 1 menus and 3 drinks

 

All these parameters are expandable with customization.

The template is open, so you can customize it by your own.

 

Images Sales and Margins forecast for Restaurants Free Excel Template

 

Sales and Margins forecast for Restaurants Free Excel Template

 

Sales and Margins forecast for Restaurants Free Excel Template

 

Sales and Margins forecast for Restaurants Free Excel Template

 

Sales and Margins forecast for Restaurants Free Excel Template

 

Sales and Margins forecast for Restaurants Free Excel Template

 

Sales and Margins forecast for Restaurants Free Excel Template

 

Sales and Margins forecast for Restaurants Free Excel Template

 

 

Download this Template here

Free Excel Templates

 

More information about Controlling Excel Tools

 

More Videos about Management Accounting

Dani Granero

Controlling Consultant
Controller ODOO ERP

Dani Consultor Controller y ODOO

Email: dani@cashtrainers.com

More INFO and ways to contact

Leave a Comment