Purchase Solution

XYZ COMPANY P16-24 Continue or discontinue a segment?

Not what you're looking for?

Ask Custom Question

P16-24 Continue or discontinue a segment? [LO 2, 3]. Please see attachment for questions.

P16-24 Continue or discontinue a segment? [LO 2, 3]

The segmented income statement for XYZ Company for the year ended December 31, 2010, follows:

XYZ COMPANY
Segmented Income Statement
For the Year Ended December 31, 2010
Total
Company Product A Product B Product C
Sales $ 1,200,000 $ 600,000 $ 240,000 $ 360,000
Variable expenses 552,000 300,000 108,000 144,000
________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________
Contribution margin $ 648,000 $ 300,000 $ 132,000 $ 216,000
Fixed expenses $ 564,000 328,000 92,000 144,000
________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________ ________________________________________
Operating income $ 84,000 $ (28,000 ) $ 40,000 $ 72,000
________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________
________________________________________

The company is concerned about the performance of product A, and you have been asked to analyze the situation and recommend to the president whether to continue or discontinue the product. During your investigation, you discover that certain fixed expenses are traceable directly to each product line as indicated here:

Total
Company Product A Product B Product C
Direct fixed expenses $204,000 $148,000 $20,000 $36,000
________________________________________

The remaining fixed expenses are considered to be corporatewide expenses that have been allocated to each product line based on sales revenue.

Required:
(a) What will be the effect of the decision to discontinue product A on operating income? (Input the amount as positive value. Omit the "$" sign in your response.)

Operating income will by $ for the XYZ Company if it discontinues
Product A.

(b) Assume that product A is discontinued. Prepare a segmented income statement for the remaining products. Allocate corporatewide fixed expenses as described. (Input all amounts as positive values except operating losses which should be indicated by a minus sign. Omit the "$" sign in your response.)

XYZ COMPANY
Segmented Income Statement
For the Year Ended December 31, 2010
Total
Company Product B Product C
Sales $
$
$

Variable expenses

________________________________________ ________________________________________ ________________________________________
Contribution margin $
$
$

Direct fixed expenses

Common fixed expenses

________________________________________ ________________________________________ ________________________________________
Operating income/loss $
$
$

________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________
________________________________________

(c) Starting with the segmented income statement, use the information you discovered during your investigation to present a more appropriately designed segmented income statement. (Input the amount as positive value. Omit the "$" sign in your response.)

XYZ COMPANY
Segmented Income Statement
For the Year Ended December 31, 2010
Total
Company Product A Product B Product C
Sales $
$
$
$

Variable expenses

________________________________________ ________________________________________ ________________________________________ ________________________________________
Contribution margin $
$
$
$

Direct fixed expenses

________________________________________ ________________________________________ ________________________________________ ________________________________________
Segment margin $
$
$
$

________________________________________________________________________________ ________________________________________________________________________________ ________________________________________________________________________________
Common fixed expenses

________________________________________

$

________________________________________________________________________________
________________________________________

Purchase this Solution

Solution Summary

Your tutorial to complete this is in Excel (attached). The key is to separate avoidable fixed and common fixed costs.

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Introduction to Finance

This quiz test introductory finance topics.

Basics of corporate finance

These questions will test you on your knowledge of finance.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.