CVP application-eliminate product from operations? Muscle Beach, Inc. makes three models of high-performance weight-training benches. Current operating data are summarized here:
MegaMuscle PowerGym ProForce
Selling price per unit $140 $200 $290
Contribution margin per unit 42 77 58
Monthly sales volume-units 3,000 2,000 1,000
Fixed expenses per month Total of $320,000
a. Calculate the contribution margin ratio of each product.
b. Calculate the firm's overall contribution margin ratio.
c. Calculate the firm's monthly break-even point in sales dollars.
d. Calculate the firm's monthly operating income.
e. Management is considering the elimination of the ProForce model due to its low sales volume and low contribution margin ratio. As a result, total fixed expenses can be reduced to $270,000 per month. Assuming that this change would not affect the other models, would you recommend the elimination of the ProForce model? Explain your answer,
f. Assume the same facts as in part e. Assume also that the sales volume for the PowerGym model will increase by 500 units per month if the ProForce model is eliminated. Would you recommend the elimination of the ProForce model? Explain your answer.
Please see the attached Excel file for format and formulas.
f. Assume the same facts as in part e. Assume also that the sales volume for the PowerGym model will increase by 500 units per ...
The Excel solution clearly answers the questions together with further narrative explanations.