Analyzing profitabilityFather Furniture Company manufactures and sells oak tables and chairs. Price and cost data for the furniture follow:

Tables Chairs Sales Price \( 800 \) 70 Variable manufacturing costs 60025Sales commission (10%) 807Relative Furniture has three sales representatives: Adam, Ben, and Caleb. Adam sold 100 tables with 6 chairs each. Ben sold 110 tables with 4 chairs each. Caleb sold 80 tables with 8 chairs each.

Requirements

1. Calculate the total contribution margin and the contribution margin ratio for each sales representative (round to two decimal places).

2. Which sales representative has the highest contribution margin ratio? Explain why.

Short Answer

Expert verified
  1. The contribution margin ratio ofAdam, Ben and Caleb is25.21% and 25.12% and 25.34%respectively.
  2. Caleb has highest contribution margin ratio because of appropriate sales mix.

Step by step solution

01

Calculation of total contribution and the contribution margin ratio for each sales representative (a)

Particulars

Adam (100 tables and 6 Chairs)

Ben (110 tables and 4 Chairs)

Caleb (80 tables and 8 Chairs)

Sales price

($800*100+$70*6) =$80,420

($800*110+$70*4) =$88,280

($800*80+$70*8) =$64,560

Variable cost

($600*100+$25*6) =$60,150

($600*110+$25*4) =$66,100

($600*80+$25*8) =$48,200

Contribution Margin

$20,270

$22,180

$16,360

Contribution margin ratio (Contribution margin/Sales)

$20,270/$80,420=25.21%

$22,180/$88,280 =25.12%

$16,360/$64,560 =25.34%

02

Reason of difference in the contribution margin ratio between sales representatives (b)

Caleb has the highest contribution margin ratio because of the appropriate sales mix.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

When units produced are less than units sold, how does operating income differ between variable costing and absorption costing? Why

Analyzing profitability analysis, service company Burlington Internet Services is an Internet service provider for commercial and residential customers. The company provided the following data for its two types of customers for the month of August:

For each type of customer, determine both the contribution margin per customer and the contribution margin ratio. Round to two decimal places.

Which type of service is more profitable?

Computing variable costing contribution margin

Refer to your answers to Short Exercise S21-6. Product X sells for \(175 per unit. Assume no beginning inventories. Calculate the contribution margin using variable costing when Adamson:

  1. Produces and sells 2,000 units.
  2. Produces 2,500 units and sells 2,000 units
  3. Produces 5,000 units and sells 2,000 units.

S21-6 Direct materials \) 41 per unit Direct labor 57 per unit Variable manufacturing overhead 7 per unit Fixed manufacturing overhead 20,000 per year

Question: Preparing variable and absorption costing income statements

Game Store manufactures video games that it sells for \(38 each. The company uses a fixed manufacturing overhead allocation rate of \)3 per game. Assume all costs and production levels are exactly as planned. The following data are from Game Store’s first two months in business during 2018:

October November

Sales 1,500 units 2,900 units

Production 2,800 units 2,800 units

Variable manufacturing cost per game \( 16 \) 16

Sales commission cost per game 8 8

Total fixed manufacturing overhead 8,400 8,400

Total fixed selling and administrative costs 8,000 8,000 Requirements

1. Compute the product cost per game produced under absorption costing and under variable costing.

2. Prepare monthly income statements for October and November, including columns for each month and a total column, using these costing methods:

a. absorption costing.

b. variable costing.

3. Is operating income higher under absorption costing or variable costing in October? In November? Explain the pattern of differences in operating income based on absorption costing versus variable costing.

4. Determine the balance in Finished Goods Inventory on October 31 and November 30 under absorption costing and variable costing. Compare the differences in inventory balances and the differences in operating income. Explain the differences in inventory balances based on absorption costing versus variable costing.

Sampson Company operates a manufacturing facility where several products are made. Each product is considered a business segment, and the product managers have the opportunity to receive a bonus based on the profit of the segment. Franco Hopper is the manager for the scissors product line. Production and sales data for the scissors product line for the past three years are shown below:

Year 1 Year 2 Year 3 Units produced 100,000 units 125,000 units 160,000 units Units sold 100,000 units 100,000 units 100,000 units Sales price per unit \( 12.00 per unit \) 12.00 per unit $ 12.00 per unit Variable manufacturing cost per unit 5.00 per unit 5.00 per unit 5.00 per unit Total fixed manufacturing costs 200,000 per year 200,000 per year 200,000 per year

Hopper’s bonus is 0.5% of the gross profit of the scissors product line, based on absorption costing. Upper management is discussing changing the bonus system so that bonuses are based on operating income using variable costing. Hopper is opposed to this change and has been trying to convince the other product managers to join him in voicing their opposition. There are no beginning inventories in Year 1.

Requirements:

  1. Calculate the fixed cost per unit produced for each year.
  2. Prepare income statements for the three years using absorption costing.
  3. Calculate Hopper’s bonus based on the current plan.
  4. Prepare income statements for the three years using variable costing.
  5. Calculate Hopper’s bonus based on the proposed plan.
  6. Give possible reasons why Hopper is opposed to the proposed bonus plan. Do you think Hopper’s actions have been ethical the past three years? Why or why not?
See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free