Adding and Dropping Products: The Impact on the Income Statement
Not what you're looking for?
XY Company: Segmented Income Statement
It is important to consider the financial impact of changing the product mix (i.e., adding or dropping products). Preparing a segmented income statement for various scenarios assists management in determining the estimated financial impact of making one choice over another. The case below expands on the variable costing statement from the first module by adding more details about fixed costs (direct versus common) and showing the revenues and costs associated with each product and not just in the aggregate.
The company we are looking at in this module makes two products and is considering adding one more since the company has excess capacity. One aspect of making this decision is to screen the various scenarios to determine the potential profitability. Financial information alone does not tell us what to do, but it is a good start.
XY Company currently manufactures two products, X and Y. The company has the capacity to make one additional product, with two (Z and W) currently under consideration. The forecasted annual sales and related costs for each product are as follows.
- Sales:
Product Z: 110,000
Product W: 150,000
Variable costs
- Production (%)
Product Z: 50%
Product W: 60%
- Selling and administrative (%)
Product Z: 10%
Product W: 5%
- Direct fixed expenses
Product Z: 10,000
Product W: 12,500
See below for the income statement for last year's operations.
Product X: $275,000
Product Y: $400,000
Total Sales: $675,000
Less variable expenses
- Production
Product X: 100,000
Product Y: 200,000
Total: 300,000
- Selling and administrative
Product X: 20,000
Product Y: 60,000
Total: 80,000
- Contribution margin
Product X: $155,000
Product Y: $140,000
Total: $295,000
- Less direct fixed expenses
Product X: 10,000
Product Y: 55,000
Total: 65,000
- Segment margin
Product X: $145,000
Product Y: $85,000
Total: $230,000
- Less common fixed expenses
75,000
Net income
$155,000
Common fixed costs are allocated to each product line on the basis of sales revenues.
Prepare a variable costing income statement that includes products X, Y, and Z. Repeat for products X, Y, and W. Do you recommend adding product Z or W?
Suppose that you could add both Z and W, if either X or Y is dropped. Would you drop one of the current products to add both W and Z? Support your answer with computations.
Which of the products looks the most profitable? Assuming no restraint on customer demand or resources, which product would you choose in order to maximize profitability? What about qualitative, as opposed to quantitative, concerns?
Explain the difference between the contribution margin and the segment margin and how to use the information in the decision-making process.
Purchase this Solution
Solution Summary
The impact on the income statement for adding and dropping products are determined.
Solution Preview
Please see the attachment. Thanks for using BrainMass!
XY COMPANY: SEGMENTED INCOME STATEMENT
It is important to consider the financial impact of changing the product mix (i.e., adding or dropping products). Preparing a segmented income statement for various scenarios assists management in determining the estimated financial impact of making one choice over another. The case below expands on the variable costing statement from the first module by adding more details about fixed costs (direct versus common) and showing the revenues and costs associated with each product and not just in the aggregate.
The company we are looking at in this module makes two products and is considering adding one more since the company has excess capacity. One aspect of making this decision is to screen the various scenarios to determine the potential profitability. Financial information alone does not tell us what to do, but it is a good start.
XY Company currently manufactures two products, X and Y. The company has the capacity to make one additional product, with two (Z and W) currently under consideration. The forecasted annual sales and related costs for each product are as follows.
Product Z Product W
Sales 110,000 150,000
Variable costs 50% 60%
Selling and administrative 10% 5%
Direct fixed expenses 10,000 12,500
See below for the income statement for last year's operations:
Product X Product Y Total
Sales $275,000 $400,000 $675,000
Less Variable expenses
Production ($100,000) ($200,000) ($300,000)
Selling and administrative ($20,000) ($60,000) ($80,000)
Contribution ...
Education
- B. Sc., University of Nigeria
- M. Sc., London South Bank University
Recent Feedback
- "Thank you."
- "thank you Chidi Ngene.. if you have any APA references would be great"
- "Thank you so much for your help, your explanations were easy to understand and apply!"
- "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
- "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution
Free BrainMass Quizzes
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Motivation
This tests some key elements of major motivation theories.
Operations Management
This quiz tests a student's knowledge about Operations Management
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.