Read Only-You can\'t save changes to this file. 3 Sissy\'s Quick Wok 4 Item 5 Be
ID: 2552064 • Letter: R
Question
Read Only-You can't save changes to this file. 3 Sissy's Quick Wok 4 Item 5 Beef and broccoli 6 General Tao's chicken 7 Vegetable stir-f 8 Coconut shri 9 Overall Menu Goals 10 Sweet and sour pork 11 Three-item combo 12 Asian ribs | Number Sold | Selling Price | Variable Cost %| Goal Value Food Cost % 0.25 0.20 0.11 0.24 0.25 0.18 0.41 0.30 773 640 440 485 445 321 310 145 4.99 4.99 4.49 5.99 5.50 3.99 6.99 6.99 0.35 0.35 0.35 0.35 0.35 0.35 0.35 0.35 4 a. Using this type analysis, which item would be considered Sissy's most profitable item? 15 Answer 16 17 b. What is the primary cause of that item's high goal value? 18 Answer 19 c.Using this type analysis, which item would be considered Sissy's least profitable item? 21 Answer: 23 24 25 d. What is the primary cause of that item's lower goal value? Answer: e. Based on the results of the goal value analysis, identify specific actions you would recommend Sissy take to 28 do not meet her goals 29 Q 1 Bonus Q 8Explanation / Answer
Item
Food Cost
Number Sold
Selling Price
Variable Cost
Contribution %
Goal Value
A
B
C
D
E = 1 - (A+D)
F = E*C*B
Beef and Broccolli
0.25
773
$ 4.99
0.35
0.40
$ 1,542.91
General Tao's Chicken
0.20
640
$ 4.99
0.35
0.45
$ 1,437.12
Vegetable Stir fry
0.11
440
$ 4.99
0.35
0.54
$ 1,185.62
Cocunut Shrimp
0.24
485
$ 5.99
0.35
0.41
$ 1,191.11
Overll Menu goals
0.25
445
$ 5.50
0.35
0.40
$ 979.00
sweet and sour prok
0.18
321
$ 3.99
0.35
0.47
$ 601.97
Three item combo
0.41
310
$ 6.99
0.35
0.24
$ 520.06
Asian ribs
0.30
145
$ 6.99
0.35
0.35
$ 354.74
a. The most profitable item of Sissy is Beef and Broccoli. It yields her $1,543 (appx). As given from the above table
b. The Contribution for Beef and broccoli is not the highest among all the items but the high quantity sold makes the product the most profitable product
c. Using the above type analysis the least profitable item of Sissy is Asian Rib. The Ribs yield her profit of $354.74 only
d. The ribs have low contribution per unit of 35% only. Along with this the ribs are sold the least in the quantity.
Item
Food Cost
Number Sold
Selling Price
Variable Cost
Contribution %
Goal Value
A
B
C
D
E = 1 - (A+D)
F = E*C*B
Beef and Broccolli
0.25
773
$ 4.99
0.35
0.40
$ 1,542.91
General Tao's Chicken
0.20
640
$ 4.99
0.35
0.45
$ 1,437.12
Vegetable Stir fry
0.11
440
$ 4.99
0.35
0.54
$ 1,185.62
Cocunut Shrimp
0.24
485
$ 5.99
0.35
0.41
$ 1,191.11
Overll Menu goals
0.25
445
$ 5.50
0.35
0.40
$ 979.00
sweet and sour prok
0.18
321
$ 3.99
0.35
0.47
$ 601.97
Three item combo
0.41
310
$ 6.99
0.35
0.24
$ 520.06
Asian ribs
0.30
145
$ 6.99
0.35
0.35
$ 354.74
a. The most profitable item of Sissy is Beef and Broccoli. It yields her $1,543 (appx). As given from the above table
b. The Contribution for Beef and broccoli is not the highest among all the items but the high quantity sold makes the product the most profitable product
c. Using the above type analysis the least profitable item of Sissy is Asian Rib. The Ribs yield her profit of $354.74 only
d. The ribs have low contribution per unit of 35% only. Along with this the ribs are sold the least in the quantity.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.