Question: Menu EngineeringAssignment 1 0 % No percentages or points will be awarded unless all instructions are followed.InstructionsYou have been hired as a consultant by an
Menu EngineeringAssignment No percentages or points will be awarded unless all instructions are followed.InstructionsYou have been hired as a consultant by an Italian restaurant. Your mission is to analyzethe appetizers section of their menu by using concepts we reviewed in class about MenuEngineering. Successful completion of this assignment will highlight the menu items andpresent their findings according to the below criteria: Plow horses, Stars, Puzzles, and Dogs Contribution Margin Menu Item Popularity Suggestions to the Restaurant of what items are best to keep or takeoff the menuThis assignment has TWO parts:PART A worth pointsPART B worth pointsTHE USE OF AI IS STRICTLY PROHIBITED IN THE COMPLETION OF THISASSIGNMENT.ONLY MICROSOFT EXCEL DOCUMENTS WILL BE ACCEPTED FORSUBMISSION ON MOODLE.PART AComplete the Following Menu Engineering TableMenu ItemMenu PricePlate CostFood Cost Contribution MarginQuantity SoldNet Income based on quantity soldTotal CostPopularity Menu Engineering DesignationSpicy Meatballs $ $Eggplant Spread $ $Focaccia Bread $ $Bruschetta $ $Antipasto $ $Fried Squid $ $Subtotal AppetizersUse the Microsoft Excel sheet provided, as well as the answer template provided. You mustuse the formulas available on Microsoft Excel to receive full marks on this assessment.Restaurante ItalianoAperitivos Appetizer MenuPart BResearch Section On line in your answer template, you must: Research an appetizer of your choosing Tell me what the suggested retail price of this appetizer is Tell me what the expected food cost for this item should be COMPLETE THE SUBTOTAL CALCULATIONS Subtotal Appetizers row AFTERCOMPLETING YOUR RESEARCH LINE IN THE CHART WITH YOUR OWNSUGGESTED APPETIZER
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
