Purchase Solution

CVP Analysis

Not what you're looking for?

Ask Custom Question

Problem #1
A company has a goal of earning $100,000 in after-tax income. The company must pay $28,000 in income tax if it achieves the goal. The contribution margin ratio is 30%. What dollar amount of sales must be achieved to reach the goal if fixed costs are $64,000?

Problem #2
Thomas Company has total fixed costs of $360,000 and variable costs of $14 per unit. If the unit sales price is reduced from $24 to $20 and advertising is increased by $10,000, sales will increase from 40,000 to 65,000 units. Should Thomas reduce it's per unit sales price and pay for the additional advertising? (Support your answer with calculations.) A yes or no answer will not be an acceptable answer without supporting evidence.

Problem # 3
A retail store has three departments, A, B, and C, each of which has four full-time employees. The store does general advertising that benefits all departments. Advertising expense totaled $90,000 for the current year, and departmental sales were:

Department A $356,250
Department B 641,250
Department C 427,500

How much advertising expense should be allocated to each department?

Problem #4

This year Calypso Company sold 60,000 units of its only product for $20 per unit. Manufacturing and selling the product required $97,500 of fixed manufacturing costs and $157,500 of fixed selling and administrative costs. Its per unit variable costs follows:

Material..............................................................$8.00
Direct labor (paid on the basis of completed units)..............5.00
Variable overhead costs........................................... 1.60
Variable selling and administrative costs........................0.40

Next year the company will use new material, which will reduce material costs by 50% and direct labor costs by 60% and will not affect product quality or marketability. Management is considering an increase in the unit sales price to reduce the number of units sold because the factory's output is nearing its annual output capacity of 65,000 units. Two plans are being considered. Under plan 1 the company will keep the price at the current level and sell the same volume as last year. This plan will increase income because of the reduced costs from using the new material. Under plan 2 the company will increase price by 25%. This plan will decrease unit sales volume by 15%. Under both plan 1 and 2 the total fixed costs and the variable costs per unit for overhead and for selling and administrative costs will remain the same.

1.Compute the break-even point in dollar sales for both plan 1 and plan 2
2.Prepare a forecasted contribution margin income statement with two columns showing the expected results of plan 1 and plan 2. The statement should report sales, total variables costs, contribution margin, total fixed costs, income before taxes, income taxes (30% rate), and net income.

Attachments
Purchase this Solution

Solution Summary

There are four problems. Solution to each problem depicts the step by step methodology to reach the final answer.

Solution Preview

Please refer attached file for better clarity of tables and expressions.

Solutions:

Problem #1
Fixed Cost=F=$64000
Income Tax=T=$28000
Contribution Margin ratio=CMR=30%
After Tax income=I=$100000
Dollar Sales Needed=(F+T+I)/CM Ratio=(64000+28000+100000)/30%=$640,000

Problem #2
Case -1 Price is $24
Price=P=$24
Variable Cost per unit=VC=$14
Fixed Cost=F=$360000
Sales=Q=40000

Total Costs=F+VQ=360000+14*40000=$920,000
Total Revenue=P*Q=24*40000=$960,000
Profit=Total Revenue-Total Cost=$960000-$920000=$40000

Case 2, Price is reduced to $20
Price=P=$20
Variable Cost per unit=VC=$14
New Fixed Cost=F1=Earlier Fixed Costs+ Adv. Expanses= $360000+$10000=$370000

Sales=Q=65000

Total Costs=F+VQ=370000+14*65000=$1,280,000

Total Revenue=P*Q=20*65000=$1,300,000
Profit=Total Revenue-Total Cost=$1,300,000-$1,280,000=$20000

Profit has reduced. Price reduction with advertising expenditure is not advisable.

Problem #3

Advertising expanses should be ...

Solution provided by:
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution


Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations