Overview

Dear Excel Lovers!
Dear Fast Food Lovers!

The Excel template contains menus, including the foods and quantities used in the preparation of 27 (twenty seven) kinds of dishes.

The file consists of 6 sheets.
You can use "RecipeContent" sheet as a Cover.
On the "ReadytouseProducts? sheet, served 27 kinds of meals are shown with pictures of prices, costs, and income rates.
In the "PurchasedIngredients" Sheet, the ingredients used in the preparation of 27 different dishes are shown together with their prices.
In the "RecipeCostCalculator" Sheet, used ingredients in the preparation of each dish are shown with their quantities and prices.
In the "RecipeAnalysisPivotTables" sheet, User can get detailed report in pivot table format using Slicers.
And in the last "Dish Cost Report" Sheet, User can prepare the necessary report for Management just filtering product name with data validation option of Excel.
We can present this report to the management in the form of a summary and detailed report of the menus.
Excel features and functions such as Data Validation, Upper, Concatenate, Unique, Filter, Sumifs are used in this template.
Bon Appetit

Reviews Add a review
No reviews yet

More From Excel World

Browse our top rated business templates. See All
What-If_Analysis_Goal_Seek
542
72
                                     What-If Analysis…
Women Volleyball Teams_2018
475
26
This template covers women volleyball players' information of 16 countries in 2018.   Template is consisted of 4 sheets: -Cover…
What-If_Analysis_Scenarios
535
82
This Tutorial is about Scenarios (one of What-If Analysis Tools). It covers "Creating Scenarios", "Merging Scenarios" and "Scenario Summary Report".…
Dynamic Amortization Schedule
841
58
Financial Schedules- Amortization Schedule An amortization schedule is a table detailing each periodic payment on an amortizing loan, as generated…
Static Amortization Schedule
603
52
Financial Schedules- Amortization Schedule An amortization schedule is a table detailing each periodic payment on an amortizing loan, as generated…
Sausage Casings' Transactions Spreadsheet
1,221
52
Hi, This spreadsheet is consisted of the following 11 (eleven) worksheets: 1 - Cover 2 - Chart 3 - Rates…
See All