Question
Charlie Company produces three products, A, B and C. Details on the products are included below. The companys fixed costs total $40,000. A B C
Charlie Company produces three products, A, B and C. Details on the products are included below. The companys 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started