could you solve question 3b and 4

Paste BI. B .A. Merge & Center - Clipboard Font Alignment D29 X fx =B29*C29 24 Desired Product Cost Percentage: 32% 26 Factor Method 28 Item 29 Steak Fajitas 30 Chicken Fajitas 31 Carne Asada 32 Cheese Enchiladas 33 Beef Enchiladas 34 Enchiladas Verde 35 Chili Rellenos 36 Tacos 37 Bean Chalupas 38 Tortilla Soup Cost of Product $4.50 4.00 4.25 2.00 2.50 200 2.75 0.30 0.25 0.30 Factor 3.125 3.125 3.125 3.125 3.125 3.125 3.125 3.125 3.125 3.125 Selling Price $14.06 $12.50 $13.28 $6.25 $7.81 $6.25 $8.59 $0.94 $0.78 $0.94 | Q1 Q2 Q3 Q4| Ready Clipboard Font Alignment Number Styles A3 ! X David's Menu Analysis Worksheet 3 David's Menu Analysis Worksheet 5 Menu Item 6 Dry Rubbed Ribs 7 BBQ Ribs 8 Salmon Grill 9 Brisket 10 Sausage Links 11 Cowboy Combo 12 1/2 Roast Chicken 13 Mesquite Chicken 14 Total Number Selling Sold Price 210 $11.95 242 9.95 51 14.95 8.95 6.95 9.95 8.95 160 6.95 1184 Total Sales $2,509.50 $2.407.90 $762.45 $787.60 $715.85 $1,442.75 $1,655.75 $1,112.00 $11,393.80 Item Cost Total Cost $4.10 $861.00 4.25 $1,028.50 6.451 $328.95 2.85 $250.80 1.45 $149.35 $609.00 3.10 $573.50 $280.00 4,081.10 Item Total Contribution Contribution Margin Margin $7.85 $1,648.50 $5.70 $1,379.40 $8.50 $433,50 $6.10 $536.80 $5.50 $566.50 $5.75 $833.75 $5.85 $1,082.25 $5.20 $832.00 $7,312.70 Food Cost% 34% 43% 43% 32% 21% 42% 35% 25% 4.20 1.75 16 Weighted Average 1481 $9.83 $1,424.23 $3.52 $510.14 $6.31 $914.09 34% | Q1 Q2 Q3 Q4 Ready File Home Insert Draw Page Layout Formulas Data Review View Help == > Genera IG- Arial -12 - A A BIU - P. C.A 2 Wrap Text Merge & Center Paste lipboard 5 Font Alignment X foc Mesquite Chicken, Dry Rubbed Ribs A Chapter 7, Question 3 Part 3.A. Food Cost Percentage Matrix Low Popularity High Popularity (Below__148Sold) (Above_148Sold) High Food Cost % (Above _34_ %) Salmon Grill, Cowboy Combo BBQ Ribs, 1/2 Roast Chicken Low Food Cost% (Below_34_%) Sausage Links Brisket Mesquite Chicken, Dry Rubbed Ribs 0 a. Using this type analysis, which items are David's "best"? 1 3 N b. Using this type analysis, which items might David's consider removing from his menu? c. What is one strength of this type menu analysis system? | Q1 Q2 Q3 Q4 Ready File AutoSave On A 9 .8.: Chapter 07 Excel 20071 Home Insert Draw Page Layout Formulas Data Review View Help X Arial - 12 - AA == 2 Wrap Text General - B IU.E.A.A. Merge & Center - 9 - % Clipboard Font Num Mesquite Chicken, Dry Rubbed Ribs Alignment 40 41 Part 3.B. 43 Contribution Margin Matrix Low Popularity (Below Sold) High Popularity (Above Sold) High Contribution Margin 46 (Above $ _ Low Contribution Margin 47 (Below $__) 49 a. Using this type analysis, which items are David's 'best'? 50 51 b. Using this type analysis, which items might David's consider removing from 52 his menu? 54 c. What is one strength of this type menu analysis system? 55 01 02 03 04 Ready Arial - 12 === -A A . A Wrap Text Merge & Center - Paste BI U . Clipboard Font Alignment 09 Mesquite Chicken, Dry Rubbed Ribs 49 a. Using this type analysis, which items are David's "best"? 50 51 b. Using this type analysis, which items might David's consider removing from 52 his menu? 54 c. What is one strength of this type menu analysis system? d. What is one weakness of this type menu analysis system? e. What marketing strategies might David use for items that fall in Square 12 Answers co e doo Q1 Q2 Q3 Q4 Ready G H 1 Chapter 7, Question 4 After computing goal values below, sort in descending rank order) by goal value. Be sure to 3 include the Overall Menu Goals in the appropriate rank order 5 Sissy's Quick Wok 0.18 440 Food Cost % Number Selling Variable Cost% Goal 7 Item (in decimal form) Sold Price in decimal form) Value 8 Beef and Broccoli 0.25 773 4.99 0.35 9 Sweet and Sour Pork 321 3.99 0.35 10 General Tao's Chicken 0.20 640 4.99 0.35 11 Vegetable Stir Fry 0.11 4.49 0.35 12 3-Item Combo 0.41 310 6.99 0.35 13 Coconut Shrimp 0.24 485 5.99 0.35 14 Asian Ribs 0.30 145 6.99 0.35 15 Overall Menu Goals 0.25 445 5.50 0.35 16 " a. Using this type analysis, which item would be considered Sissy's most profitable item? 18 Q1 Q2 Q3 Q4 Ready B1 fx 6.99 5.99 12 3-Item Combo 13 Coconut Shrimp 14 Asian Ribs 15 Overall Menu Goals 0.24 0.30 0.25 6.99 5.50 0.35 0.35 0.35 a. Using this type analysis, which item would be considered Sissy's most profitable item? b. What is the primary cause of that item's high goal value? c. Using this type analysis, which item would be considered Sissy's least profitable item? 23 d. What is the primary cause of that item's lower goal value? e. Based on the results of the goal value analysis, identify specific actions you would recommend Sissy take to improve the profitability of her menu items that do not meet her goals Answers Q1 Q2 Q3 Q4 Paste BI. B .A. Merge & Center - Clipboard Font Alignment D29 X fx =B29*C29 24 Desired Product Cost Percentage: 32% 26 Factor Method 28 Item 29 Steak Fajitas 30 Chicken Fajitas 31 Carne Asada 32 Cheese Enchiladas 33 Beef Enchiladas 34 Enchiladas Verde 35 Chili Rellenos 36 Tacos 37 Bean Chalupas 38 Tortilla Soup Cost of Product $4.50 4.00 4.25 2.00 2.50 200 2.75 0.30 0.25 0.30 Factor 3.125 3.125 3.125 3.125 3.125 3.125 3.125 3.125 3.125 3.125 Selling Price $14.06 $12.50 $13.28 $6.25 $7.81 $6.25 $8.59 $0.94 $0.78 $0.94 | Q1 Q2 Q3 Q4| Ready Clipboard Font Alignment Number Styles A3 ! X David's Menu Analysis Worksheet 3 David's Menu Analysis Worksheet 5 Menu Item 6 Dry Rubbed Ribs 7 BBQ Ribs 8 Salmon Grill 9 Brisket 10 Sausage Links 11 Cowboy Combo 12 1/2 Roast Chicken 13 Mesquite Chicken 14 Total Number Selling Sold Price 210 $11.95 242 9.95 51 14.95 8.95 6.95 9.95 8.95 160 6.95 1184 Total Sales $2,509.50 $2.407.90 $762.45 $787.60 $715.85 $1,442.75 $1,655.75 $1,112.00 $11,393.80 Item Cost Total Cost $4.10 $861.00 4.25 $1,028.50 6.451 $328.95 2.85 $250.80 1.45 $149.35 $609.00 3.10 $573.50 $280.00 4,081.10 Item Total Contribution Contribution Margin Margin $7.85 $1,648.50 $5.70 $1,379.40 $8.50 $433,50 $6.10 $536.80 $5.50 $566.50 $5.75 $833.75 $5.85 $1,082.25 $5.20 $832.00 $7,312.70 Food Cost% 34% 43% 43% 32% 21% 42% 35% 25% 4.20 1.75 16 Weighted Average 1481 $9.83 $1,424.23 $3.52 $510.14 $6.31 $914.09 34% | Q1 Q2 Q3 Q4 Ready File Home Insert Draw Page Layout Formulas Data Review View Help == > Genera IG- Arial -12 - A A BIU - P. C.A 2 Wrap Text Merge & Center Paste lipboard 5 Font Alignment X foc Mesquite Chicken, Dry Rubbed Ribs A Chapter 7, Question 3 Part 3.A. Food Cost Percentage Matrix Low Popularity High Popularity (Below__148Sold) (Above_148Sold) High Food Cost % (Above _34_ %) Salmon Grill, Cowboy Combo BBQ Ribs, 1/2 Roast Chicken Low Food Cost% (Below_34_%) Sausage Links Brisket Mesquite Chicken, Dry Rubbed Ribs 0 a. Using this type analysis, which items are David's "best"? 1 3 N b. Using this type analysis, which items might David's consider removing from his menu? c. What is one strength of this type menu analysis system? | Q1 Q2 Q3 Q4 Ready File AutoSave On A 9 .8.: Chapter 07 Excel 20071 Home Insert Draw Page Layout Formulas Data Review View Help X Arial - 12 - AA == 2 Wrap Text General - B IU.E.A.A. Merge & Center - 9 - % Clipboard Font Num Mesquite Chicken, Dry Rubbed Ribs Alignment 40 41 Part 3.B. 43 Contribution Margin Matrix Low Popularity (Below Sold) High Popularity (Above Sold) High Contribution Margin 46 (Above $ _ Low Contribution Margin 47 (Below $__) 49 a. Using this type analysis, which items are David's 'best'? 50 51 b. Using this type analysis, which items might David's consider removing from 52 his menu? 54 c. What is one strength of this type menu analysis system? 55 01 02 03 04 Ready Arial - 12 === -A A . A Wrap Text Merge & Center - Paste BI U . Clipboard Font Alignment 09 Mesquite Chicken, Dry Rubbed Ribs 49 a. Using this type analysis, which items are David's "best"? 50 51 b. Using this type analysis, which items might David's consider removing from 52 his menu? 54 c. What is one strength of this type menu analysis system? d. What is one weakness of this type menu analysis system? e. What marketing strategies might David use for items that fall in Square 12 Answers co e doo Q1 Q2 Q3 Q4 Ready G H 1 Chapter 7, Question 4 After computing goal values below, sort in descending rank order) by goal value. Be sure to 3 include the Overall Menu Goals in the appropriate rank order 5 Sissy's Quick Wok 0.18 440 Food Cost % Number Selling Variable Cost% Goal 7 Item (in decimal form) Sold Price in decimal form) Value 8 Beef and Broccoli 0.25 773 4.99 0.35 9 Sweet and Sour Pork 321 3.99 0.35 10 General Tao's Chicken 0.20 640 4.99 0.35 11 Vegetable Stir Fry 0.11 4.49 0.35 12 3-Item Combo 0.41 310 6.99 0.35 13 Coconut Shrimp 0.24 485 5.99 0.35 14 Asian Ribs 0.30 145 6.99 0.35 15 Overall Menu Goals 0.25 445 5.50 0.35 16 " a. Using this type analysis, which item would be considered Sissy's most profitable item? 18 Q1 Q2 Q3 Q4 Ready B1 fx 6.99 5.99 12 3-Item Combo 13 Coconut Shrimp 14 Asian Ribs 15 Overall Menu Goals 0.24 0.30 0.25 6.99 5.50 0.35 0.35 0.35 a. Using this type analysis, which item would be considered Sissy's most profitable item? b. What is the primary cause of that item's high goal value? c. Using this type analysis, which item would be considered Sissy's least profitable item? 23 d. What is the primary cause of that item's lower goal value? e. Based on the results of the goal value analysis, identify specific actions you would recommend Sissy take to improve the profitability of her menu items that do not meet her goals Answers Q1 Q2 Q3 Q4