4. Garikai is a manager at Boniso's Mexican Restaurant (from the previous question), and he believes that goal value analysis, rather than Boniso's matrix analysis, is a better way to study the profitability of his menu items. (15 points) A. Using the following goal value analysis data, help Garikai analyze the restaurant's menu items. Goal Value Analysis Data Food Cost % Number Selling Variable Cost % in decimal form sold Price in decimal form Fajita Plate 0.38 $12.95 Enchilada Dinner 59.95 0.28 Menudo $6.95 Mexican Salad 0.30 5 7.95 Chalupa Dinner $ 8.95 Burrito Dinner $9.95 Taco Dinner 0.26 225 $5.95 0.28 Overall Monu 0.32 152 $ 8.95 0.28 (Goal Value Item 147 0.28 200 0.35 0.25 82 0.28 117 0.28 0.28 125 0.28 0.33 168 0.28 After computing the following goal values, sort (in descending rank order) by goal value. Be sure to include the overall menu in the appropriate rank order. Spreadsheet hint: Calculate the goal values by placing the ENTIRE Goal Value formula for each item in the Goal Value column as follows: (1 - Food Cost %) x Item Popularity x Selling Price x (1 - (Variable Cost % + Food Cost %)). The table will not sort correctly if partial calculations for Goal Value exist in columns A, B, C. or D. For example, DO NOT calculate (1 - Food Cost %) in the A column or (1 -(Variable Cost % + Food Cost %))in the D column. Goal Value Analysis Results "A" Food Cost Item in decimal form Number Sold "C" Selling Price - Variable Cost in decimal form Goal Value 4. Garikai is a manager at Boniso's Mexican Restaurant (from the previous question), and he believes that goal value analysis, rather than Boniso's matrix analysis, is a better way to study the profitability of his menu items. (15 points) A. Using the following goal value analysis data, help Garikai analyze the restaurant's menu items. Goal Value Analysis Data Food Cost % Number Selling Variable Cost % in decimal form sold Price in decimal form Fajita Plate 0.38 $12.95 Enchilada Dinner 59.95 0.28 Menudo $6.95 Mexican Salad 0.30 5 7.95 Chalupa Dinner $ 8.95 Burrito Dinner $9.95 Taco Dinner 0.26 225 $5.95 0.28 Overall Monu 0.32 152 $ 8.95 0.28 (Goal Value Item 147 0.28 200 0.35 0.25 82 0.28 117 0.28 0.28 125 0.28 0.33 168 0.28 After computing the following goal values, sort (in descending rank order) by goal value. Be sure to include the overall menu in the appropriate rank order. Spreadsheet hint: Calculate the goal values by placing the ENTIRE Goal Value formula for each item in the Goal Value column as follows: (1 - Food Cost %) x Item Popularity x Selling Price x (1 - (Variable Cost % + Food Cost %)). The table will not sort correctly if partial calculations for Goal Value exist in columns A, B, C. or D. For example, DO NOT calculate (1 - Food Cost %) in the A column or (1 -(Variable Cost % + Food Cost %))in the D column. Goal Value Analysis Results "A" Food Cost Item in decimal form Number Sold "C" Selling Price - Variable Cost in decimal form Goal Value
