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.