Question

Diversified Products, Inc., has recently acquired a small publishing company that offers three books for sale—a...

Diversified Products, Inc., has recently acquired a small publishing company that offers three books for sale—a cookbook, a travel guide, and a handy speller. Each book sells for $13. The publishing company’s most recent monthly income statement is shown below.

Product line

Total
Company
Cookbook Travel
Guide
Handy
Speller
Sales $ 315,000 $ 96,000 $ 156,000 $ 63,000
Expenses:
Printing costs 105,000 30,000 63,300 11,700
Advertising 39,000 13,800 21,000 4,200
General sales 18,900 5,760 9,360 3,780
Salaries 36,000 21,000 9,300 5,700
Equipment depreciation 6,600 2,200 2,200 2,200
Sales commissions 31,500 9,600 15,600 6,300
General administration 42,900 14,300 14,300 14,300
Warehouse rent 12,600 3,840 6,240 2,520
Depreciation—office facilities 3,900 1,300 1,300 1,300
Total expenses 296,400 101,800 142,600 52,000
Net operating income (loss) $ 18,600 $ (5,800 ) $ 13,400 $ 11,000

The following additional information is available:

  1. Only printing costs and sales commissions are variable; all other costs are fixed. The printing costs (which include materials, labor, and variable overhead) are traceable to the three product lines as shown in the income statement above. Sales commissions are 10% of sales.

  2. The same equipment is used to produce all three books, so the equipment depreciation cost has been allocated equally among the three product lines. An analysis of the company’s activities indicates that the equipment is used 30% of the time to produce cookbooks, 50% of the time to produce travel guides, and 20% of the time to produce handy spellers.

  3. The warehouse is used to store finished units of product, so the rental cost has been allocated to the product lines on the basis of sales dollars. The warehouse rental cost is $3 per square foot per year. The warehouse contains 50,400 square feet of space, of which 7,800 square feet is used by the cookbook line, 24,600 square feet by the travel guide line, and 18,000 square feet by the handy speller line.

  4. The general sales cost above includes the salary of the sales manager and other sales costs not traceable to any specific product line. This cost has been allocated to the product lines on the basis of sales dollars.

  5. The general administration cost and depreciation of office facilities both relate to administration of the company as a whole. These costs have been allocated equally to the three product lines.

  6. All other costs are traceable to the three product lines in the amounts shown on the income statement above.

The management of Diversified Products, Inc., is anxious to improve the publishing company’s 6% return on sales.

Required:

1. Prepare a new contribution format segmented income statement for the month. Adjust allocations of equipment depreciation and of warehouse rent as indicated by the additional information provided.

2. Based on the segmented income statements given in the problem, management plans to eliminate the cookbook because it is not returning a profit, and to focus all available resources on promoting the travel guide. However, based on the new contribution format segmented income statement that you prepared:

a. Do you agree with management's plan to eliminate the cookbook?

b-1. Compute the contribution margin ratio for each product.

b-2. Based on the statement you have prepared, do you agree with the decision to focus all available resources on promoting the travel guide?

Homework Answers

Answer #1
Segmented Income Statement
Total Company Cookbook Travel Guide Handy Speller
Sales 315,000 96,000 156,000 63,000
Less: Variable expenses
Printing costs 105,000 30,000 63,300 11,700
Sales Commissions 31,500 9,600 15,600 6,300
Contribution Margin 178,500 56,400 77,100 45,000
Lesse: Fixed costs
Advertising 39,000 13,800 21,000 4,200
Equipment Depreciation 6,600 1,980 3,300 1,320
Warehouse Rent 12,600 1,950 6,150 4,500
Total traceable fixed expenses 58,200 17,730 30,450 10,020
Segment Margin 120,300 38,670 46,650 34,980
Fixed expenses not traceable
General Sales 18,900
Salaries 36,000
General Administration 42,900
Depreciation-Office facilities 3,900
Net operating income 18,600
2a. No, as it is generating a segment margin of $38,670
Total Company Cookbook Travel Guide Handy Speller
b-1 CM Ratio = CM/Sales 56.67% 58.75% 49.42% 71.43%
b-2 No, since the contribution margin ratio is lowest for travel guide
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Diversified Products, Inc., has recently acquired a small publishing company that offers three books for sale—a...
Diversified Products, Inc., has recently acquired a small publishing company that offers three books for sale—a cookbook, a travel guide, and a handy speller. Each book sells for $10. The publishing company’s most recent monthly income statement is given below: Product Line Total Company Cookbook Travel Guide Handy Speller   Sales $ 300,000 $ 90,000 $ 150,000 $ 60,000   Expenses:        Printing costs 102,000 27,000 63,000 12,000        Advertising 36,000 13,500 19,500 3,000        General sales 18,000 5,400 9,000 3,600        Salaries 33,000 18,000 9,000...
Pacific Rim Industries is a diversified company whose products are marketed both domestically and internationally. The...
Pacific Rim Industries is a diversified company whose products are marketed both domestically and internationally. The company’s major product lines are furniture, sports equipment, and household appliances. At a recent meeting of Pacific Rim’s board of directors, there was a lengthy discussion on ways to improve overall corporate profitability. The members of the board decided that they required additional financial information about individual corporate operations in order to target areas for improvement. Danielle Murphy, the controller, has been asked to...
Williams Products Inc. manufactures and sells a number of items, including school knapsacks. The company has...
Williams Products Inc. manufactures and sells a number of items, including school knapsacks. The company has been experiencing losses on the knapsacks for some time, as shown by the contribution format income statement below: WILLIAMS PRODUCTS INC. Income Statement—School Knapsacks For the Quarter Ended June 30   Sales $ 205,000   Variable expenses:      Variable manufacturing expenses $ 57,400      Sales commissions 22,550      Shipping 6,150   Total variable expenses 86,100   Contribution margin 118,900   Fixed expenses:      Salary of product-line manager 7,250      General factory overhead 41,050 *...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow: Total Dirt Bikes Mountain Bikes Racing Bikes Sales $ 921,000 $ 264,000 $ 405,000 $ 252,000 Variable manufacturing and selling expenses 465,000 117,000 193,000 155,000 Contribution margin 456,000 147,000 212,000 97,000 Fixed expenses: Advertising, traceable 69,700 8,600 40,700 20,400 Depreciation of special equipment 43,700 20,500 7,300 15,900 Salaries of product-line managers 115,300...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow: Total Dirt Bikes Mountain Bikes Racing Bikes   Sales $ 920,000 $ 262,000 $ 402,000   $ 256,000     Variable manufacturing and selling expenses 467,000 114,000 199,000   154,000     Contribution margin 453,000 148,000 203,000 102,000     Fixed expenses:     Advertising, traceable 69,900 8,600 40,700 20,600     Depreciation of special equipment 43,600 20,400 7,800 15,400       Salaries of product-line managers 115,000...
Galley, Inc. manufactures two product lines, toasters and blenders. Below is the most recent contribution margin...
Galley, Inc. manufactures two product lines, toasters and blenders. Below is the most recent contribution margin segmented income statement prepared by Galley’s accountant, who allocated common fixed costs between the two segments based on sales revenue. Total    Toasters Blenders Sales $ 1,000,000 $ 450,000 $ 550,000 Variable costs 745,000 300,000 445,000 Contribution margin 255,000 150,000 105,000 Traceable fixed costs (80,000) (25,000) (55,000) Segment margin $175,000 $125,000 $50,000 Common fixed costs (40,000) (18,000) (22,000) Operating income (loss) $135,000 $107,000 $28,000...
Williams Products Inc. manufactures and sells a number of items, including school knapsacks. The company has...
Williams Products Inc. manufactures and sells a number of items, including school knapsacks. The company has been experiencing losses on the knapsacks for some time, as shown by the contribution format income statement below: WILLIAMS PRODUCTS INC. Income Statement—School Knapsacks For the Quarter Ended June 30   Sales $ 215,000   Variable expenses:      Variable manufacturing expenses $ 60,200      Sales commissions 23,650      Shipping 6,450   Total variable expenses 90,300   Contribution margin 124,700   Fixed expenses:      Salary of product-line manager 7,750      General factory overhead 43,150 *...
Exercise 6-2 (Algo) Dropping or Retaining a Segment [LO6-2] The Regal Cycle Company manufactures three types...
Exercise 6-2 (Algo) Dropping or Retaining a Segment [LO6-2] The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow: Total Dirt Bikes Mountain Bikes Racing Bikes Sales $ 926,000 $ 265,000 $ 405,000 $ 256,000 Variable manufacturing and selling expenses 465,000 113,000 201,000 151,000 Contribution margin 461,000 152,000 204,000 105,000 Fixed expenses: Advertising, traceable 70,200 8,600 40,800 20,800 Depreciation of special equipment...
The Ferre Publishing Company has three service departments and two operating departments. Selected data from a...
The Ferre Publishing Company has three service departments and two operating departments. Selected data from a recent period on the five departments follow: Service Departments Operating Departments Administration Janitorial Maintenance Binding Printing Total Costs $147,000 $110,250 $50,400 $288,750 $451,500 $1,047,900 Number of employees 60 35 140 315 210 760 Square feet of space occupied 15,000 10,000 20,000 40,000 100,000 185,000 Hours of press time 30,000 60,000 90,000 Administration is allocated based on number of employees; Janitorial based on space occupied;...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a...
The Regal Cycle Company manufactures three types of bicycles—a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow: Total Dirt Bikes Mountain Bikes Racing Bikes Sales $ 924,000 $ 264,000 $ 406,000 $ 254,000 Variable manufacturing and selling expenses 466,000 118,000 194,000 154,000 Contribution margin 458,000 146,000 212,000 100,000 Fixed expenses: Advertising, traceable 70,600 8,700 40,900 21,000 Depreciation of special equipment 43,500 20,300 7,600 15,600 Salaries of product-line managers 116,000...