Question

In: Accounting

ChipotleTM offers three items: tacos, burritos, and bowls at the price and variable costs below. The...

  1. ChipotleTM offers three items: tacos, burritos, and bowls at the price and variable costs below. The restaurant has a fixed cost of $50,000, and average sales for the items are like below. Answer the following.

Item

Price

VC

Sales%

Taco

$7.00

$3.00

25%

Burrito

$8.50

$4.00

40%

Bowl

$8.00

$3.75

35%

  1. a) What is the sum of weighted contribution margin % (ΣWiCM%i) of Taco, Burrito, and Bowl?
  1. b) What is the breakeven sales level in dollars (BE$) ?
  1. c) What is the desired sales revenue (S$) in order to generate profit of $15,000?

Solutions

Expert Solution

Solution

Chipotle™

a. Determination of the sum of weighted contribution margin percent of Taco, Burrito and Bowl:

Contribution margin = sales – variable cost

Contribution margin percent = (contribution margin/sales) x 100

Weighted contribution margin percent = sum of CM percentages

Taco

Burrito

Bowl

Sales price per unit

$7

$8.50

$8

Variable cost per unit

$3

$4

$3.75

Contribution margin per unit

$4

$4.50

$4.25

CM percent

57.14%

52.94%

53.13%

sales proportions

25%

40%

35%

sum of weighted contribution margin

=

[(57.14 x 25) + (52.94 x 40) + (53.13 x 35)]

=

54.06%

Hence, sum of weighted contribution margin = 54.06%

b. Determination of break-even sales in dollars:

Break-even sales in dollars = fixed cost/Weighted Contribution margin

Fixed cost = $50,000

Weighted contribution margin = 54.06%

Break-even sales in dollars = 50,000/54.06% = $92,497

c. Determination of desired sales revenue to generate profit of $15,000:

Desired sales revenue = (fixed cost + target profit)/CM ratio

= (50,000 + 15,000)/54.06% = 65,000/54.06%

Desired sales revenue = $120,246


Related Solutions

Using the income statement below compute the following items. Sales $1,250,000 25 Variable costs 750,000 15...
Using the income statement below compute the following items. Sales $1,250,000 25 Variable costs 750,000 15 Contribution margin 500,000 10 40% Fixed operating costs 200,000 Earnings before interest and taxes 300,000 Interest 125,000 Earnings before taxes 175,000 Taxes (30%) 52,500 Net income $122,500 Note: The company made and sold 50,000 units this year Required: Record the answers in the designated spots below. Round to the dollar, do not record the dollar sign, and no comma is needed between thousands and...
In this chapter we suggested that whenever market price fell below average variable costs, the firm...
In this chapter we suggested that whenever market price fell below average variable costs, the firm will shut down. At that point, revenue is not covering its variable costs and the firm is losing more money than it would if it shut down and lost its fixed costs. Clearly, shutting the firm down is more complicated than that. Under what circumstances might the firm continue to operate even though prices are below average variable costs? a. It would not continue...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow:     Product     A      B      C Selling price   $   180         $   270         $   240      Variable expenses:                                    Direct materials      24            72            32      Other variable expenses      102            90  ...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow:    Product A B C   Selling price $ 240 $ 320 $ 300   Variable expenses:     Direct materials 18 72 27     Other variable expenses 174 152 228   Total variable expenses 192 224 255   Contribution margin $ 48 $ 96 $ 45   Contribution margin ratio 20 % 30 % 15 %    The same raw material is used...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 240 $ 360 $ 320 Variable expenses: Direct materials 21 63 28 Other variable expenses 147 153 212 Total variable expenses 168 216 240 Contribution margin $ 72 $ 144 $ 80 Contribution margin ratio 30 % 40 % 25 % The same raw material is used in all...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 150 $ 240 $ 200 Variable expenses: Direct materials 12 48 18 Other variable expenses 108 120 152 Total variable expenses 120 168 170 Contribution margin $ 30 $ 72 $ 30 Contribution margin ratio 20 % 30 % 15 % The same raw material is used in all three...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 180 $ 270 $ 240 Variable expenses: Direct materials 24 80 32 Other variable expenses 102 90 148 Total variable expenses 126 170 180 Contribution margin $ 54 $ 100 $ 60 Contribution margin ratio 30 % 37 % 25 % The same raw material is used in all three...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 180 $ 240 $ 220 Variable expenses: Direct materials 18 72 30 Other variable expenses 126 96 140 Total variable expenses 144 168 170 Contribution margin $ 36 $ 72 $ 50 Contribution margin ratio 20 % 30 % 23 % The same raw material is used in all three...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 180 $ 300 $ 250 Variable expenses: Direct materials 20 90 30 Other variable expenses 120 120 184 Total variable expenses 140 210 214 Contribution margin $ 40 $ 90 $ 36 Contribution margin ratio 22 % 30 % 14 % The same raw material is used in all three...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 150 $ 240 $ 200 Variable expenses: Direct materials 12 48 18 Other variable expenses 108 120 152 Total variable expenses 120 168 170 Contribution margin $ 30 $ 72 $ 30 Contribution margin ratio 20 % 30 % 15 % The same raw material is used in all three...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT