Old MathJax webview

I got to a point but my teacher didn't provide information on how to do the rest of the chart

that is the full problem. I have some of it solved which is up until total item CM sloved. teacher has not showed us how to do the rest.

Table 1. 1. Please conduct a menu engineering analysis, filling in the table below. 3.12.56 2.54.58921496.06 1.09. 300= 327.00 171.259=442.94 11.95 123=239.85 10.37.2593 234.03 15.95 = 177.50 ITEM PRICE MENU MIX % (MM%) ITEM ABC COST ITE M CM TOTAL ITEM REVENU E TOTA L ITEM COST MENU ITEM NAME MM 9% CATEGOR Y SOLD (Menu Mix) MENU ITEM CLASS TOTA L ITEM CM CM CATEGOR Y COST % PROFIT FACTO R 947.229= 107.63 0.99-5= 465.69 57. 310 = 405.70 12.50.153= 407.50 5.88% 7.63 8.95 229 1.32 1747.27/2049.55 302.28 5.13% 200 8.75 11.70 2.57.105= 269.95 220.63=138.60 172.67 =101.84 1.98.65=128.70 2.97|1750 29 0.74% 8.75 11.70 Chopped Salad Chopped Salad w Chicken Chopped Salad w Tuna Arugula Pear Salad Arugula w Chicken Arugula w Tuna 2.57% 100 8.75 7.64 3.85% 150 8.38 2340.00 590.00 12.95/253.75 339.30/85.55 Kell 1764.00/875.00 111.00 13.12/1257 1725.00 1468.00 11.50 3.12 469.23644,00 124.72 2.54 4835.696331.75|1496.06 11.09 12658 /2985.00/327.00! 11.50 Item price. = total it 18.95.229. 111.70.200 - 11.00.29= 18.75.100 111.50.150 11.50.50 56 1.44% 8.38 589 15.12% 8.21 10.75 7.70% 300 8.86 9.95 No.75.5 11.95 19.95 1.21 9.95 1442.89 6.65% 259 8.24 12134.16257705 Cobb Salad Chicken Caesar Wrap BBQ Chicken Wrap Chicken Tender Wrap Cheeseburg er Chicken Mushroom 7.95 19.9 7. 9. 10 9.95 123 8.00 3.16% 269 6.90% 7.95 7.08 195984.00 1223.85.239.85 10.87/1904.52/2138.55/234,03 1851777.60955.20177.60 Item Price - Item ABC Lost Item( 9.95-8.86=1.09 96 2.46% 8.10 9.95 Item ABC costa #sold - tota 7.6.2298174721 8 oooh 7.48 7.95 10.47 1slo al 1605.90 107.53 8.86 9.75 8.93 10.50 8.45 10.95 Burger Grilled Garden 202 5.18% Burger Smoked Turkey & 521 13.37% Avocado 7.96% 310 440 Sandwich 163 4.18% Turkey Club Signature 105 2.70% Pasta Angel Hair 63 1.62% Bolognese Traditional 67 1.72% Tomato Basil Mac & 65 1.67% Cheese Total Menu Items Sold: 3,896 8.93 11.50 6.89 4616.06 507935453.51 11.57 2.768 30 3255.00 456.76 2.50 13773778485 407.50 1937.651207.50/26985 10.95 12.20/553.77/689.85 /138.60 1.52 1551.41653.25 /101.84 11.98 1518.05/646.7/128.70 2.57 8.79 8.23 9.75 7.97 9.95 Once you have completed the worksheet, find the following totals: Total Menu Cost: Total Menu Revenue: Total Menu CM: Average Menu Mix (%): Average Menu Item Contribution Margin ($): Menu Food Cost (%): 1 would you provide to management based on the results of your analysis 22 Table 1. 1. Please conduct a menu engineering analysis, filling in the table below. MENU ITEM NAME # SOLD (Menu Mix) MENU MIX % (MM%) ITEM ABC COST ITEM PRICE ITE M CM TOTA 1 ITEM COST TOTAL ITEM REVENU E TOTA L ITEM CM MM% CATEGOR Y CM CATEGOR Y MENU ITEM CLAS S. PROFIT FACTO R COST % 229 5.88% 7.63 8.95 Chopped Salad Chopped Salad w Chicken 200 5.13% 8.75 11.70 Chopped 29 0.74% 8.75 11.70 100 2.57% 7.64 8.75 Salad w Tuna Arugula Pear Salad Arugula w Chicken Arugula w Tuna 150 3.85% 8.38 11.50 56 1.44% 8.38 11.50 589 15.12% 8.21 10.75 300 7.70% 8.86 9.95 Cobb Salad Chicken Caesar Wrap BBQ Chicken Wrap Chicken Tender Wrap Cheeseburg er 259 6.65% 8.24 9.95 123 3.16% 8.00 9.95 269 6.90% 7.08 7.95 Chicken Mushroom Burger 96 2.46% 8.10 9.95 Grilled 202 5.18% 7.48 7.95 Garden Burger Smoked Turkey & Avocado 521 13.37% 8.86 9.75 310 7.96% 8.93 10.50 440 Sandwich 163 4.18% 8.45 10.95 Turkey Club Signature Pasta 105 2.70% 8.93 11.50 Angel Hair 8.79 10.95 8.23 9.75 63 1.62% Bolognese Traditional 67 1.72% Tomato Basil Mac & 65 Cheese 1.67% Total Menu Items Sold: 3,896 7.97 9.95 Once you have completed the worksheet, find the following totals: Total Menu Cost: Total Menu Revenue: Total Menu CM: Average Menu Mix (%): Average Menu Item Contribution Margin ($): Menu Food Cost (%)