Hand Held X5, X6, X7 Products’ Cost-Volume-Profit

Introduction

PDA Sim produces three products (Hand Held X5, Hand Held X6 and Hand Held X7) and desires to come up with a strategic decision about which product to be discontinued from production in the year 2006. The three products are at different stages in the market and an appropriate decision about continuing production of any of the three products is required. In this paper, I will carry out Cost-Volume-Profit analysis for PDA Sim by calculating the contribution margin for products: Hand-Held X5, Hand Held X6, and Hand Held X7 in the year 2004 and 2005. The analysis will help make a decision to continue the production of any of the three products.

CVP analysis

According to Quintana (2002) CVP analysis is a tool used by managers to determine the relationship between costs, volume, and profit that is made by an organization. This tool uses elements such as prices, sales volume, unit variable costs, fixed costs, and the product mix of an organization. CVP analysis is applied in making decisions such as the products to be manufactured in a specific time period, the policy to be adapted to price products, and the type of equipment to be acquired by an organization. The break-even point is used to determine profitable sales capacity. At the break-even point, a company makes neither profits nor losses (Quintana, 2002).

According to Accounting Management (2009, pg. 1) “contribution margin is the amount remaining from sales revenue after variable expenses have been deducted. Thus it is the amount available to cover fixed expenses and then to provide profits for the period.” The contribution margins for PDA Sim vary by great margins in the years 2005 and 2004 for the three Hand Held products. Contribution margins for these products help develop decisions about which product should be discontinued from the production system.

CVP analysis

From the above diagram, it is evident that a company should operate above the break-even point in order to make profits. For a company to make profits, the total costs curve should be below the revenue curve. A loss is made when the revenue curve is below the total costs curve. The diagram helps summarize the CVP framework for a clear graphical analysis.

Handheld X5

X5 Financials for 2005

This Year Last Year % Change
Revenue
Sales Volume 1,448,031 936,039 55%
Revenue Volume 362,007,649 234,009,768 55%
Cost
Variable Costs 202,724,283 131,045,470 55%
Fixed Costs 70,000,000 70,000,000 0%
R & D Costs 6,666,667 6,666,667 0%
Total Costs 279,390,950 207,712,137 35%
Profit
Total Profit 82,616,699 26,297,631 214%
Total Profitability 23% 11% 103%
Economic Value Added
Capital Charge 1,920,000 1,920,000 0%
EVA 80,696,699 24,377,631 231%

Source: Forio (2009).

Contribution margin for Handheld X5

Year 2005

Year 2005

Year 2004

Year 2004

Hand held X6

X6 Financials for 2005.

This Year Last Year % Change
Revenue
Sales Volume 908,627 508,229 79%
Revenue Volume 363,450,944 203,291,529 79%
Cost
Variable Costs 227,156,840 127,057,206 79%
Fixed Costs 35,000,000 35,000,000 0%
R & D Costs 6,868,687 6,868,687 0%
Total Costs 269,025,527 168,925,893 59%
Profit
Total Profit 94,425,417 34,365,637 175%
Total Profitability 26% 17% 54%
Economic Value Added
Capital Charge 1,200,000 1,200,000 0%
EVA 93,225,417 33,165,637 181%

Source: Forio (2009).

Contribution margin for Handheld X6.

Year 2005

Year 2005

Year 2004

Year 2004

Handheld X7

X7 Financials for 2005.

This Year Last Year % Change
Revenue
Sales Volume 244,244 166,897 46%
Revenue Volume 48,848,773 33,379,412 46%
Cost
Variable Costs 15,875,851 10,848,309 46%
Fixed Costs 35,000,000 35,000,000 0%
R & D Costs 6,464,646 6,464,646 0%
Total Costs 57,340,498 52,312,955 10%
Profit
Total Profit -8,491,725 -18,933,544 -55%
Total Profitability -17% -57% -69%
Economic Value Added
Capital Charge 2,400,000 2,400,000 0%
EVA -10,891,725 -21,333,544 -49%

Source: Forio (2009).

Contribution margin for handheld X7.

Year 2005

Year 2005

Year 2004

Year 2004

From the above computations, it is evident that Hand Held X5 has a contribution margin of 159,283,366 which is 44 percent of the total sales made by the company in 2005. In 2004 the company made a contribution margin of 102,964,298, which is 44 percent of the total sales. The net operating income of the company has been found to be 89,283,366 for the year 2005 and 32,964,298 for the year 2004.

Hand-Held X6 had a contribution of 102,964,298, which is 37.50 percent of the total sales in the year 2005 while in the year 2004 the company made a contribution margin of 76,234,323. The net operating income for the year 2005 was 67,964,298 while in the year 2004 the company made an operating income of 41,234,323. Hand-Held X7 the company had a contribution margin of 32,972,922 in the year 2005 while in 2004 the company had a contribution margin of 22,531,103. The net operating income of the company in the year 2005 was -2,027,078 while in the year 2004 the operating income was -12,468,897.

It is clear that from the above analysis, Hand Held X7 has a negative net operating income for the year 2005 and the year 2004. The management of PID Sim should discontinue this product from production since costs exceed the sales revenues. For the two years the product has been in the market only losses have been registered. This is clear evidence that the management should consider discontinuation of the product since there are no benefits generated from the production system for this product.

Hand-Held X6 and Hand Held X7 have a positive net operating income. This indicates that the two products are operating above the break-even point. Since the two products are generating profits for the company, the management should continue the production of Hand-Held X6 and Hand Held X7. In summary, any product that has a negative operating income should be discontinued from the production system since the costs incurred by the company be more than the generated revenues.

References

Accounting management (2009). Cost Volume Profit Relationship – (CVP Analysis). Web.

Forio (2009). PDA Sim. Web.

Quintana, O. (2002). Cost-Volume-Profit Analysis. Web.

Cite this paper

Select style

Reference

StudyCorgi. (2021, February 12). Hand Held X5, X6, X7 Products’ Cost-Volume-Profit. https://studycorgi.com/hand-held-x5-x6-x7-products-cost-volume-profit/

Work Cited

"Hand Held X5, X6, X7 Products’ Cost-Volume-Profit." StudyCorgi, 12 Feb. 2021, studycorgi.com/hand-held-x5-x6-x7-products-cost-volume-profit/.

* Hyperlink the URL after pasting it to your document

References

StudyCorgi. (2021) 'Hand Held X5, X6, X7 Products’ Cost-Volume-Profit'. 12 February.

1. StudyCorgi. "Hand Held X5, X6, X7 Products’ Cost-Volume-Profit." February 12, 2021. https://studycorgi.com/hand-held-x5-x6-x7-products-cost-volume-profit/.


Bibliography


StudyCorgi. "Hand Held X5, X6, X7 Products’ Cost-Volume-Profit." February 12, 2021. https://studycorgi.com/hand-held-x5-x6-x7-products-cost-volume-profit/.

References

StudyCorgi. 2021. "Hand Held X5, X6, X7 Products’ Cost-Volume-Profit." February 12, 2021. https://studycorgi.com/hand-held-x5-x6-x7-products-cost-volume-profit/.

This paper, “Hand Held X5, X6, X7 Products’ Cost-Volume-Profit”, was written and voluntary submitted to our free essay database by a straight-A student. Please ensure you properly reference the paper if you're using it to write your assignment.

Before publication, the StudyCorgi editorial team proofread and checked the paper to make sure it meets the highest standards in terms of grammar, punctuation, style, fact accuracy, copyright issues, and inclusive language. Last updated: .

If you are the author of this paper and no longer wish to have it published on StudyCorgi, request the removal. Please use the “Donate your paper” form to submit an essay.