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
More information about Controlling Excel Tools
- Balanced Scorecard Excel Template Key Indicators (KPIs) Control
- Impacting Charts for your Excel Templates
- Human Resources Excel Templates
- Business Plan Budget 5 Years M1 Free Excel Template
- Cost product BOM components example Excel spreadsheet
- Decisions Sale Price Lists Calculation Free Excel Template
- Actual Vs Budget Excel Templates
- Projects Control with Tasks Free Excel Template