Question

In: Finance

Comprehensive In Class Problem Cost Profit Relationships A manufacturer predicts fixed costs of $502,000 for next...

Comprehensive In Class Problem Cost Profit Relationships

  1. A manufacturer predicts fixed costs of $502,000 for next year. Its one product sells for $180 per unit and it incurs variable costs of $126 per unit. Its target (pretax) income is $200,000.
    1. Compute the contribution margin ratio
    2. Compute the dollars sales needed to yield the target income
    3. Compute the unit sales needed to yield the target income
  1. The sales mix of a company’s two products, X and Y, is 2:1. Unit variable costs for both products are $2, and unit selling prices are $5 for X and $4 for Y. The company has $640,000 of fixed costs.
    1. What is the contribution margin per composite unit?
    2. What is the break-even point in composite units?
    3. How many units of X and how many units of Y will be sold at the break-even point?

Solutions

Expert Solution

1)

Contribution margin = Selling price - Variable cost

= 180 - 126

= $54

Ratio = 54/180

= 30%

Dollar sales required

= ( Fixed cost + Target income )/Contribution margin ratio

= ( 502,000 + 200,000)/30%

= $2,340,000

Units sales required

= ( Fixed cost + Target income )/ Contribution margin per unit

= ( 502,000 + 200,000)/54

= 13,000 units

2)

Contribution margin

For X

= 5 - 2

= $3

For Y

= 4 - 2

= $2

Sales ratio = 2:1

Contribution margin for composite unit

= 3*2/3 + 2*1/3

= 2 + 0.67

= $2.67

Fixed cost = 640,000

Breakeven = Fixed cost / Contribution margin per unit

= 640,000/2.67

= 239,700

Units to be sold for individual product

For X

= 239,700*2/3

= 159,800 units

For Y

= 239,700*1/3

= 79,900 units.


Related Solutions

A felt-tip pen manufacturer is forecasted to sell 31000 pens next month. Their fixed costs are...
A felt-tip pen manufacturer is forecasted to sell 31000 pens next month. Their fixed costs are $23400 per month and variable costs are $0.35 per pen. Management wants to generate $12000 in profits next month. Assuming that the demand is met, what must the selling price be? Your Answer:
Cost-Volume Profit Analysis Guiseppe is operating a restaurant. Fixed costs are 45,000 $. Average cost of...
Cost-Volume Profit Analysis Guiseppe is operating a restaurant. Fixed costs are 45,000 $. Average cost of food and other variable costs are 3.20 $. The average bill is 8$. The income tax rate is 30 %, the net target profit is 105,000 $ (i.e. after income tax). a) How many customers are needed to earn a net target profit of 105,000 $ and to break even? (6 points) b) Calculate the net target profit if you have 15,000 customers! (3...
Cost, volume, profit analysis identifies a transaction’s “contribution’ to fixed costs. Explain the meaning of ‘contribution’...
Cost, volume, profit analysis identifies a transaction’s “contribution’ to fixed costs. Explain the meaning of ‘contribution’ and discuss the usefulness of such analysis in making business decisions. (limit 120 words)
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. Units Produced Total Lumber Cost Total Utilities Cost Total Machine Depreciation Cost 14,000 shelves $154,000    $17,100    $145,000    28,000 shelves 308,000    33,200    145,000    56,000 shelves 616,000    65,400    145,000    70,000 shelves 770,000    81,500    145,000    1. Determine whether the costs...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. Units Produced Total Lumber Cost Total Utilities Cost Total Machine Depreciation Cost 13,000 shelves $143,000    $16,950    $135,000    26,000 shelves 286,000    31,900    135,000    52,000 shelves 572,000    61,800    135,000    65,000 shelves 715,000    76,750    135,000    1. Determine whether the costs...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. Units Produced Total Lumber Cost Total Utilities Cost Total Machine Depreciation Cost 11,000 shelves $110,000    $13,650    $145,000    22,000 shelves 220,000    26,300    145,000    44,000 shelves 440,000    51,600    145,000    55,000 shelves 550,000    64,250    145,000    1. Determine whether the costs...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. Units Produced Total Lumber Cost Total Utilities Cost Total Machine Depreciation Cost 15,000 shelves $165,000    $19,250    $140,000    30,000 shelves 330,000    36,500    140,000    60,000 shelves 660,000    71,000    140,000    75,000 shelves 825,000    88,250    140,000    1. Determine whether the costs...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. Units Produced Total Lumber Cost Total Utilities Cost Total Machine Depreciation Cost 6,000 shelves $60,000    $8,400    $120,000    12,000 shelves 120,000    15,300    120,000    24,000 shelves 240,000    29,100    120,000    30,000 shelves 300,000    36,000    120,000    1. Determine whether the costs...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. Units Produced Total Lumber Cost Total Utilities Cost Total Machine Depreciation Cost 15,000 shelves $150,000    $18,750    $135,000    30,000 shelves 300,000    36,000    135,000    60,000 shelves 600,000    70,500    135,000    75,000 shelves 750,000    87,750    135,000    1. Determine whether the costs...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The...
Mastery Problem: Cost-Volume-Profit Analysis Cost Behavior Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow. Units Produced Total Lumber Cost Total Utilities Cost Total Machine Depreciation Cost 7,000 shelves $70,000    $9,550    $145,000    14,000 shelves 140,000    17,600    145,000    28,000 shelves 280,000    33,700    145,000    35,000 shelves 350,000    41,750    145,000    1. Determine whether the costs...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT