Question: Please help me with this problem AsAp A D 3 BOOK 4 5 Step 1: Calculate the total food cost, total sales, total profit to


Please help me with this problem AsAp
A D 3 BOOK 4 5 Step 1: Calculate the total food cost, total sales, total profit to fill in the gray cells. 6 Step 2: Calculate the average and total of each column to fill in the green cells. Step 3: Calculate the contribution margin percentage, to fill in the blue cells. 7 8 9 10 Centennial Square Restaurant Last Month's Sales Portion Number Sold Sales Cost Price Total Food Cost Total Sales Total Profit Contribution Margin % 448 $4.96 $16.00 532 $4.06 $14.00 + 520 $3.36 $12.00 180 $2.20 $11.00 160 $6.12 $17.00 176 $5.51 $19.00 288 $7.04 $22.00 12 13 Menu Item 14 Korean Chicken Lettuce Wrap 15 Roaring 40's Wedge Salad 16 Crispy Brussels 17 Fries With Aioli 18 Stone Fired Cauliflower Crust Pizza 19 Truffle Mushroom Pasta 20 Blackened Creole Chicken 21 Seared Steelhead Trout 22 Baby Back Ribs 23 Steak Frites 24 Centennial Square Burger 25 Impossible Burger 26 Crispy Chicken Sandwich 27 Power Bowl 28 Tuna Poke Bowl 29 Crispy Tofu Bowl 20 Market Greens 500 $8.06 $26.00 240 $7.50 $25.00 288 $10.15 $29.00 510 $5.44 $18.75 128 56.24 $19.50 $6.30 $18.00 350 308 $20.00 316 $21.00 $5.20 $6.72 $5.46 $2.94 521.00 180 236 $14.00 1 Total Weekly Sales Excercise + 34 35 Step 4: Based on your calculations above, what are the average number of items sold and average contribution margin percentage? 36 37 Average Number of Items Sold: 38 Average Contribution Margin % 39 40 41 Step 5: For each menu item, indicate whether it falls above (high) or below (low) the average: 42. 43 Menu Item 44 Items Sold Contribution Margin Matrix Classification 45 Kerean Chicken Lettuce Wrap 46 Roaring 40's Wedge Salad 47 Crispy Brussels 48 Fries With Aioli 49 Stone Fired Cauliflower Crust Pizza 50 Truffle Mushroom Pasta 51 Blackened Creole Chicken 52 Seared Steelhead Trout 53 Baby Back Ribs 54 Steak Frites 55 Centennial Square Burger 56 Impossible Burger 57 Crispy Chicken Sandwich 58 Power Bowl 59 Tuna Poke Bowl 60 Crispy Tofu Bowl 61 Market Greens 62 63 64 Step 6: Now that you have completed your calculations, complete the eCentennial activity to drag and drop the menu Weekly Sales Excercise +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
