Chapter 10, Question 4 a. Using the following goal value analysis data, help Garikai analyze the restaurant's menu items. Goal Value Analysis Data Food Cost % Numbe Variable Cost (in decimal Selling % Item form) Sold Price (in decimal Fajita Plate 0.38 147 $12.95 0.28 Enchilada Dinner 0.35 200 $9.95 0.28 Menudo 0.25 82 $6.95 0.28 Mexican Salad 0.30 117 $7.95 0.28 Taco Dinner 0.26 225 $5.95 0.28 Chalupa Dinner 0.28 125 $8.95 0.28 Burrito Dinner 0.33 168 $9.95 0.28 Overall Menu (Goal Value) 0.32 152 $8.95 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 Z) x item popularity x selling price x (1 - (variable cost % + food cost Z}). 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 Z) in the A column or (1- | - Goal Value Analysis Results Food Cost % "B" "C" Variable Cost (in decimal Number Selling Goal Item form) Sold Price (in decimal Value 7 b. Help Garikai calculate the Goal Value for the chulupa dinner if he lovers the selling prica Results of Changes Made to Chalupa Dinner Food Cost 2 "B" "C" Variable Cost (in decimal Number Selling 7 Item form) Sold Price (in decimal Goal Value Chalupa Dinner If he makes these changes, will the chalupa dinner meet or exceed the overall menu goal value? Should Garikai make these changes