Question

Charlie Company produces three products, A, B and C. Details on the products are included below....

Charlie Company produces three products, A, B and C. Details on the products are included below. The company’s fixed costs total $40,000.

A

B

C

Selling price

$15

$21

$36

Variable cost/unit

9

14

19

Sales Mix

20%

20%

60%

Using EXCEL:

A. Compute the Breakeven in units for the company. (Be sure to indicate how many of each product must be sold at breakeven.)

B. Will the company breakeven if the sales mix changes so sales mix of A = 40% and sales mix of C = 40%? Will it make or lose money?

C. Will the company breakeven if the sales mix changes so sales mix of B = 10% and sales mix of C= 70%? Will it make or lose money?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
BBC Builders Inc. produces three products: A, B, and C. The following information is presented for...
BBC Builders Inc. produces three products: A, B, and C. The following information is presented for the three products: Calculate the contribution margin for each product Calculate the break-even point in units of the three products A, B, and C combination based on the sales mix percentaage Fixed Cost $321,000 Product A Product B Product C Price Per Unit $40 $34 $20 Variable Cost Per Unit $25 $20 $6 Contribution Margin Per Unit Product Mix 30% 20% 50% 100% Weighted...
RMN produces and sells three products. The details of each products has been given in the...
RMN produces and sells three products. The details of each products has been given in the statement below. RMN's fixed costs are RM330,000 per period. Budgeted sales revenue for next period is RM650,000 in the standard mix. Product E Product F Product G RM per unit RM per unit RM per unit Selling price 45 25 21 Variable cost 13 6 9 Maximum demand (units) 26,000 14,000 12,000 Required: Calculate the margin of safety in terms of sales revenue and...
ABC Company sells three products with exactly the same price of $20 a unit. However, A’s...
ABC Company sells three products with exactly the same price of $20 a unit. However, A’s variable cost is at 40%, B’s at 50%, and C’s at 60%. Sales mix for A, B, and C is at 500, 1500, and 3000 units respectively. Fixed costs amount to $18,000. Breakeven sales for B should be a. 600 b. 1,200 c. 1,800 d. 2,000 ABC’s sales mix has drastically changed due to market conditions to 3000, 1500, and 500 units for A,...
ABC Company produces three products: A, B, and C.   The company only has 300 labor hours...
ABC Company produces three products: A, B, and C.   The company only has 300 labor hours per week to produce these 3 products Product information is as follows: A B C Unit selling price 140 75 240 Unit variable costs 100 50 180 Unit contribution margin 40 25 60 Labor hours per unit 5 4 6 Maximum demand in units per week 15 20 30 Required: What is the optimal product mix(how many A, B, and C should be produced)...
XYZ company produces and sells five products: A, B, C, D and E. The following data...
XYZ company produces and sells five products: A, B, C, D and E. The following data relate to its five products A B C D E Monthly demand in units 80 60 40 90 50 Selling price per unit $230 $70 $100 $80 $90 Variable costs per unit $110 $37 $64 $44 $ 27 Total fixed costs $100,000 Labor time in hours per unit 1.2 0.3 0.6 0.4 0.9 There are a total of 201 labor hours available per month...
A company produces two products in one of its plants: A and B. Annual production of...
A company produces two products in one of its plants: A and B. Annual production of Product A is 3000 units and of Product B is 2000 units. Product A has 25 components and Product B has 36 components. For Product A, 40% of the components are made in the plant, while 60% are purchased parts. For Product B, 30% of the components are made in the plant, while 70% are purchased. For these two products taken together, what is...
TheDon Ltd produces three products but the number of machine hours available is limited to 33000...
TheDon Ltd produces three products but the number of machine hours available is limited to 33000 hours. Details of each product are as follows: A B C Selling price per unit                   ¢40 ¢60 ¢66 Variable cost per unit                  ¢30 ¢40 ¢30 Machine hours per unit      4 10 12 Maximum production and sales (units) 2000 1000 2000 The company’s fixed cost per annum is ¢32,000. Required: Determine the optimum product mix for TheDon Ltd. Prepare the...
A company sells three different products: Product A, Product B, and Product C. The contribution margin...
A company sells three different products: Product A, Product B, and Product C. The contribution margin per unit for each of the products is as follows: $30 for Product A, $50 for Product B, and $60 for Product C. The company’s sales mix in units is as follows: 50% Product A, 30% Product B, and 20% Product C. The company’s fixed costs amount to $1,680,000. How many units of each product must the company sell in order to break even?
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 80.00 $ 60.00 $ 72.00 Variable expenses: Direct materials 24.00 15.00 9.00 Other variable expenses 24.00 33.00 45.00 Total variable expenses 48.00 48.00 54.00 Contribution margin $ 32.00 $ 12.00 $ 18.00 Contribution margin ratio 40 % 20 % 25 % The company estimates that it can sell 1,000 units of each product per month. The same...
A company sells three different products: Product A, Product B, and Product C. The contribution margin...
A company sells three different products: Product A, Product B, and Product C. The contribution margin per unit for each of the products is as follows: $30 for Product A, $50 for Product B, and $60 for Product C. The company’s sales mix in units is as follows: 50% Product A, 30% Product B, and 20% Product C. The company’s fixed costs amount to $1,680,000. How many units of each product must the company sell in order to break even?...