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 Ilgar Zarbaliyev

Browse our top rated business templates. See All
Row, Column, Index, Match, Offset Functions. Excel Tutorial
 “It's Excel's world, we just live in it.” “To be an accountant in the age of spreadsheet program is —…
New Dynamic Functions. Excel Tutorial
In September, 2018, we released dynamic array formulas for Excel for Microsoft 365. The differences between dynamic arrays and legacy…
Fill Series. Data Validation. Excel Tutorial
 If you have inherited workbooks from someone else or if you have imported data from external data sources, you have…
 This report includes the necessary analyzes according to some characteristics of the people who made and participated in the job…
 Hello, This report is consisted of four pages. 1-Supplier Quality Metrics 2-Supplier Quality Regional 3-Top - Bottom Analysis 4-Downtime Analysis…
Sales_Analysis_Reportin Power BI
Hello, After participating in Enterprise DNA programs, I prepared reports on three topics in Power BI. The first report I…
See All