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 10%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 take-off the menuThis assignment has TWO parts:PART A worth 5 pointsPART B worth 5 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 sold)Total CostPopularity %Menu Engineering Designation1Spicy Meatballs $13.00 $4.53752Eggplant Spread $10.00 $1.93273Focaccia Bread $8.50 $1.27434Bruschetta $10.00 $2.25225Antipasto $12.00 $4.07356Fried Squid $17.00 $7.22387Subtotal 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 Italiano(Aperitivos) Appetizer MenuPart BResearch Section - On line 7 in your answer template, you must:1. Research an appetizer of your choosing2. Tell me what the suggested retail price of this appetizer is3. Tell me what the expected food cost for this item should be4. COMPLETE THE SUBTOTAL CALCULATIONS (Subtotal Appetizers row) AFTERCOMPLETING YOUR RESEARCH (LINE 7 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!