ch10 Homework

.xlsx

School

Northern Arizona University *

*We aren’t endorsed by this school

Course

280

Subject

Business

Date

Apr 3, 2024

Type

xlsx

Pages

6

Uploaded by alympakes

Report
Chapter 10 Q 2 Chapter 10, Question 4 Goal Value Analysis Data Item 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 0.32 152 $8.95 0.28 Goal Value Analysis Results Item Enchilada Dinner 0.35 200 $9.95 0.28 Taco Dinner 0.26 225 $5.95 0.28 Burrito Dinner 0.33 168 $9.95 0.28 Fajita Plate 0.38 147 $12.95 0.28 Chalupa Dinner 0.28 125 $8.95 0.28 Mexican Salad 0.30 117 $7.95 0.28 Menudo 0.25 82 $6.95 0.28 b. Help Garikai calculate the Goal Value for the chulupa dinner if he lowers the selling pri Results of Changes Made to Chalupa Dinner a. Using the following goal value analysis data, help Garikai analyze the restaurant's menu items. Food Cost % (in decimal form) Number Sold Selling Price Variable Cost % (in decimal form) Overall Menu (Goal Value) After computing the following goal values, sort (in descending rank order) by goal value. include the overall menu in the appropriate rank order. Spreadsheet hint: Calculate the g placing the ENTIRE goal value formula for each item in the Goal Value column as follows %) x item popularity x selling price x (1 - (variable cost % + food cost %)). The table will n correctly if partial calculations for goal value exist in columns A, B, C, or D. For example, calculate (1 - food cost %) in the A column or (1- (variable cost % + food cost %)) in the D "A" Food Cost % (in decimal form) "B" Number Sold "C" Selling Price "D" Variable Cost % (in decimal form)
Chapter 10 Q 2 Item Chalupa Dinner 0.29 150 $8.55 0.29 "A" Food Cost % (in decimal form) "B" Number Sold "C" Selling Price "D" Variable Cost % (in decimal form) If he makes these changes, will the chalupa dinner meet or exceed the overall menu goal value? Should these changes? Answer: He should make the changes because he will then be greater than the menu goal.
Chapter 10 Q 2 Goal Value 478.6 455.7 436.8 401.3 354.4 273.5 200.9 ice. . Be sure to goal values by s: (1 - food cost not sort , DO NOT D column.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help