Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
¶ … Behavior
XY Company is considering adding a new product line to its current mix, which consists of products X and Y. There are two options that it faces, Product W. And Product Z. The purpose of this report is to examine these two alternatives in order to try and understand which of these products is a better addition to the product mix. There are a number of variables that come into play. While both products appear to be profitable, the impact of this decision on the company as a whole needs to be taken into consideration.
Product W.
The addition of Product W. To the company's product lines results in a variable cost income statement as follows:
Product X
Product Y
Product W
Total
Sales
$275,000
$400,000
$110,000
$785,000
Less variable expenses
Production
100,000
200,000
55,000
$355,000
Selling and administrative
20,000
60,000
11,000
$91,000
Contribution margin
$155,000
$140,000
$44,000
$339,000
Less direct fixed expenses
10,000
55,000
10,000
$75,000
Segment margin
$145,000
$85,000
$34,000
$264,000
Less common fixed expenses
75,000
Net income
$189,000
Prior to adding Product W, the company was earning a net income of $155,000. Thus, adding the new product adds $34,000 to the company's bottom line.
Product Z
The other alternative is Product Z. The projected sales for Product Z. are significantly higher than the projected sales for Product W. However, the costs are higher as well. The following is the variable cost income statement for Product Z:
Product X
Product Y
Product Z
Total
Sales
$275,000
$400,000
$180,000
$855,000
Less variable expenses
Production
100,000
200,000
126,000
$426,000
Selling and administrative
20,000
60,000
9,000
$89,000
Contribution margin
$155,000
$140,000
$45,000
$340,000
Less direct fixed expenses
10,000
55,000
12,500
$77,500
Segment margin
$145,000
$85,000
$32,500
$262,500
Less common fixed expenses
75,000
Net income
$187,500
As noted, the combined income for the company with Product Z. is $187,500. This is slightly lower...
Based on this analysis, Product W. is the better of the two options, since they are mutually exclusive.
Dropping a Product
There is another option as well, which is to drop one of the existing products. Based on the segment margin for each product, this would not be recommended, at least if the above tables are computed on the basis of an even one-third split for each product. The following table shows the segment margin for each product:
Product X
$145,000
Product Y
$85,000
Product W
$34,000
Product Z
$32,500
All things being equal, it is necessary for the company to take the three best of these, if it can only take three. Thus, the company would not drop either Product X or Product Y. To illustrate, the net income if Product X was dropped would be:
Product W
Product Y
Product Z
Total
Sales
$110,000
$400,000
$180,000
$690,000
Less variable expenses
Production
55,000
200,000
126,000
$381,000
Selling and administrative
11,000
60,000
9,000
$80,000
Contribution margin
$44,000
$140,000
$45,000
$229,000
Less direct fixed expenses
10,000
55,000
12,500
$77,500
Segment margin
$34,000
$85,000
$32,500
$151,500
Less common fixed expenses
75,000
Net income
$76,500
And if Product Y was dropped, it would be:
Product X
Product W
Product Z
Total
Sales
$275,000
$110,000
$180,000
$565,000
Less variable expenses
Production
100,000
$55,000
$126,000
$281,000
Selling and administrative
20,000
$11,000
$9,000
$40,000
Contribution margin
$155,000
$44,000
$45,000
$244,000
Less direct fixed expenses
10,000
$10,000
$12,500
$32,500
Segment margin
$145,000
$34,000
$32,500
$211,500
Less common fixed expenses
75,000
Net income
$136,500
Thus, we can see that the optimal level of net income is $189,000, and that comes from having Product X, Product Y and Product W. As the three-product product mix.
Profitability
The net…
References accountingexplanation.com. (n.d.). Advantages, Disadvantages, and Limitations of Variable Costing Systems. From http://www.accountingexplanation.com/advantages_disadvantages_limitations_of_variable_costing.htm
Martin, J.R. (n.d.) Management Accounting: Concepts, Techniques, and Controversial Issues - Chapter 11: Conventional Linear Cost Volume Profit Analysis. Retrieved from http://maaw.info/Chapter11.htm
Slideshare. (n.d.). Determining How Costs Behave. Retrieved from http://www.slideshare.net/mingxinlu/cost-accounting-determining-how-cost-behaves
Walther, l. (2012). Principles of Accounting. Chapter Twenty-Three: Reporting to Support Managerial Decisions. Retrieved from http://www.principlesofaccounting.com
Decision Analysis System Modeling Using Spreadsheets" "DATA DECISION ANALYSIS SYSTEM MODELING USING SPREADSHEETS" "Data Decision Analysis System Modeling Using Spreadsheets." Spreadsheet is one of the most popular software packages on the planet. Daily, million of business people, students and individuals use spreadsheet program to build models to assist in solving decision problems they face on their work activities. Thus, employers generally look for individuals having experience and skills with spreadsheets. Typically, spreadsheets assist
Primary Dealer Operations Audit1BMO Harris Capital Markets Corp (BMOH) is a Canadian investment dealer and member of the Investment Industry Regulatory Organization of Canada (IIROC). It is a subsidiary of BMO Financial Group. BMOH offers a full range of investment and corporate banking products and services to Canadian and U.S. clients. Its operations functions consist of securities trading, underwriting, research, and retail brokerage. I came to know about this organization
Product Launch Plan The elements of product launch plan that are going to be looked into here include the distribution strategy, financial information, and marketing research. Marketing Research Teas N. Line has undertaken to deal in Oolong, Green, Yellow, and Black tea after realizing that tea after some time tea loses its freshness after it has spent some time on the shelf and that consumers want tea that is freshly packaged and shipped
Product: Nike (Chinese KungFu cloth shoes). The product a consumer product (B2C) existing sports market Australia ( confirm proper research, sport fact a viable Australian market). The product " Australia market. Nike Kung Fu Shoes in the Australian Marketplace The Kung Fu techniques represent one of the most valuable components of the Chinese culture and heritage. Throughout the entire world, Kung Fu has helped increase the awareness and popularity of the Asian
The adverts to be used must be tailored to the lifestyles of the target market. The internet as a promotional tool must be treated with utmost importance. The manufacturer must realize the full potential of the internet as a promotional tool. Showrooms must also be used as tool or mediums of promoting Volkswagen CC. TV adverts too are also not to be forgotten. Hesterberg (2009) noted that the use of
46). Likewise, Gillispie suggests that an incremental approach can be used to "test the waters" for even very small companies seeking to project an internationalized presence. In this regard, Gillespie recommends that companies, "Craft a scaleable master design that represents the major aspects of your business worldwide and anticipates the degree of localization that will be required in each market. The degree of localization can have a real impact