Calculate margin and asset turnover for each product line

Assignment Help Managerial Accounting
Reference no: EM131694054

Problem 1:

Shoe Shock Innovations manufactures athletic shoe inserts that cushion the foot and reduce the impact of exercise on the joints. The company has two divisions, Sole Inserts and Heel Inserts. A segmented income statement from last month follows.


Sole Inserts
Division

Heel Inserts
Division

Total Shoe
Shock

Revenue

$493,000

$2,533,000

$3,026,000

Less variable expenses

301,000

2,023,000

2,324,000

Contribution margin

192,000

510,000

702,000

Less traceable fixed expenses

122,300

350,000

472,300

Segment margin

$69,700

$160,000

229,700

Common fixed costs



174,100

Net operating income



$55,600

Chris Kelly is Shoe Shock's sales manager. Although this statement provides useful information, Chris wants to know how well the company's two distribution channels, specialty footwear stores and drug stores, are performing. Marketing data indicates that 20% of sole inserts and 75% of heel inserts are sold through specialty footwear stores. A recent analysis of corporate fixed costs revealed that 50% of all fixed costs are traceable to specialty footwear stores and 45% of all fixed costs to drug stores.

(a) Prepare a segment margin income statement for Shoe Shock's two distribution channels.

Problem 2

Hamilton and Battles, Ltd. produces and sells two products-guitar cases and violin cases. Each of these products is made in a dedicated manufacturing facility, and the product line managers are evaluated based on the product line's return on investment. The following data is from the most recent year of operations.



Guitar Cases


Violin Cases

Sales


$3,000,000


$4,522,000

Variable costs


1,232,000


2,719,000

Direct fixed costs


1,444,100


1,532,400

Average assets


2,000,000


1,500,000

(a) Calculate the margin and asset turnover for each product line.

Problem 3:

Trent Weaver was reviewing the latest income statement for Taryn Enterprises. For the second year in a row, the Collectibles division was showing a negative segment margin, and Trent thought it was time to close the division to increase the company's operating income. The income statement that he examined follows.


Promotions
Division

Collectibles
Division

Total

Revenue

$5,317,500

$2,863,900

$8,181,400

Less variable expenses

3,652,100

1,647,300

5,299,400

Contribution margin

1,665,400

1,216,600

2,882,000

Less traceable fixed expenses

947,800

1,278,400

2,226,200

Segment margin

$717,600

$(61,800

655,800

Common fixed costs



584,000

Net operating income



$71,800

When Trent broke the news, Taylor Tatum, manager of the Collectibles division, was upset. Taylor thought that Trent could be making a snap judgment, and suggested that he look at the division's detailed operating results. The Collectibles division is composed of two groups, Sports Memorabilia and Coins and Stamps. Sports Memorabilia accounts for 60% of the division's sales and contribution margin; Coins and Stamps accounts for the other 40%. Sports Memorabilia's traceable fixed costs are $810,800; Coins and Stamps, $246,400.

(a) Prepare a segment margin income statement for the Collectibles division that shows the segment margin of each group.

Reference no: EM131694054

Questions Cloud

How much net sales should the illini company recognize : Larry paid 100,000 in full on 1/25/2016. How much net sales should the Illini Company recognize for this transaction
Estimate the average value of works of art : An art dealer wants to estimate the average value of works of art of a certain period and type. A random sample of 20 works of art is appraised.
Describe a business scenario : Describe a business scenario where a UNION relational set operator may be used to merge two similar data sets.
What kinds of resistance might the leader expect to see : What kinds of resistance might the leader expect to see? Identify and explain five kinds of resistance. How can managers effectively address this conflict?
Calculate margin and asset turnover for each product line : Prepare a segment margin income statement for Shoe Shock's two distribution channels - Calculate the margin and asset turnover for each product line.
Prepare the production budget : Soft Pillows Unlimited makes decorative throw pillows for home use. Prepare the production budget
Describe the importance of using sub queries in a database : Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system.
What is the probability that estimated proportion is less : If the true proportion of transactions that had errors was 6% that day, what is the probability that the estimated proportion is less than 5%?
Prepare single-step income statement : Prepare single-step income statement for 2018, including EPS disclosures. Prepare multiple-step income statement for 2018, including EPS disclosures

Reviews

Write a Review

Managerial Accounting Questions & Answers

  What is wilson profit margin and debt ratio

What is Wilson's profit margin and debt ratio?

  Spam inc had the following standard costs and plans for

spam inc. had the following standard costs and plans for fiscal current year for the production of custom meat products

  What is the amount of direct materials cost

What is the amount of direct materials cost in the August 31st Work in process inventory account - Information on these measures of activity

  The companys activity-based costing system

Using the companys activity-based costing system, compute the customer margin of Wave Rider - Management would like an analysis of the profitability

  Johnson companys costs for the month of august were as

johnson companys costs for the month of august were as follows direct materials 25000 direct labor 30000 sales salaries

  What is the total manufacturing cost assigned

What is the total manufacturing cost assigned to Job 413? What is the unit product cost for Job 413?

  Management accountants versus users

"Managerial accountants should understand the uses of accounting data, and users of data should understand accounting. Only in this way can accountants provide the appropriate accounting data for the correct uses." Do you agree with this statement..

  Discuss what this ratio measures and what a change like this

Discuss what this ratio measures and what a change like this could indicate for the company.

  How these ratios are used to assess a company performance

List three debt-related ratios, and discuss how these ratios are used to assess a company's performance.

  Past performance and industry norms

How are past performance and industry norms useful in evaluating a company’s performance? What are their limitations?

  Constructing direct materials budget

Preparing the direct materials budget: It takes three pounds of direct materials to produce the Regular product and five pounds of direct materials to produce the Deluxe product.

  Break-even in units for revenue

Assume a fixed cost for an investment in a piece of equipment of $15,000, a variable cost to produce each unit of product with the equipment at $10, and a selling price for the finished product of $25.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd