Wonder Co.: The CVP Analysis

CVP Analysis Use

Margin analysis helps to identify the optimal proportions between cost and volume of sales, which allows Wonder Co. to determine the volume of sales for each specific situation, providing break-even activities. This type of analysis is also called CVP analysis (cost – volume – profit or cost – volume – profit).

Critical indicators of margin analysis are:

  • variable costs;
  • fixed costs;
  • margin income;
  • critical production volume;
  • financial strength reserve;
  • the effect of the production lever.

Variable costs are expenses that change with the production volume (costs of raw materials, the operating time of equipment, labor costs, etc.). In the practice of margin analysis, the relationship between production volume and variable costs are considered as directly proportional.

Fixed costs are independent of production volume (depreciation, rent, insurance premiums, etc.). Marginal income is the difference between sales revenue and the number of variable costs (Ermekbaev and Kim 18). The calculation of the margin income gives information to the company about the amount of revenue that must be obtained to recoup fixed costs and profit. The critical volume of production is the minimum allowable sales volume, which covers all costs of manufacturing products while bringing neither profit nor loss.

The margin of financial strength is the difference between the actual sales revenue and the profitability threshold. If sales revenue falls below the profitability threshold, then the financial position of the enterprise deteriorates. If necessary, the stock of financial strength can be calculated as a percentage of sales revenue (Ermekbaev and Kim 18). The effect of the production lever is manifested in the change in profit depending on the move in sales volume and production costs. The metric is calculated as the ratio of profit margin to the revenue.

The first task that arises in margin analysis is the separation of the total cost of production and sales of products into variables and fixed costs. There are several methods of this division, including the maximum and minimum point method, graphical method, and least-squares method. When using the method of maximum and minimum points, the calculations are carried out in the following sequence.

Wonder Co. CVP Analysis

The 2012 report in Wonder Co. indicates that all products had low contribution margin and high break-even points. Nonetheless, the break-even point in dollars and units showed that the appropriate price strategy can contribute to these indexes’ growth. The situation in 2012 was as following:

Variable Name 2012
Sell Price $285
Revenue
Total Sales $968 979
Revenue $ 276 159 075
Cost
Variable Costs $ 145 346 882
Fixed Costs $ 75 000 000
R&D Costs $ 10 000 000
Total Costs $ 230 346 882
Profit
Total Profit $ 45 812 193
Profitability 17%
Contribution Margin 3 399
Contribution Margin Ratio 0,01
Break Even Point
In Units
Fixed Costs $ 75 000 000
Contribution Margin 3399
In Dollars
Fixed Costs $ 75 000 000
Contribution Margin Ratio 0,01

Table 1: CVP for W1 in 2012.

Variable Name 2012
Sell Price $439
Revenue
Total Sales $562 961
Revenue $ 247 139 848
Cost
Variable Costs $ 154 814 256
Fixed Costs $ 37 500 000
R&D Costs $ 14 000 000
Total Costs $ 206 314 256
Profit
Total Profit $ 40 825 593
Profitability 17%
Contribution Margin 1 282
Contribution Margin Ratio 0,02
Break Even Point
In Units
Fixed Costs $ 37 500 000
Contribution Margin 1282
In Dollars
Fixed Costs $ 37 500 000
Contribution Margin Ratio 0,02

Table 2: CVP for W2 in 2012.

Variable Name 2012
Sell Price $185
Revenue
Total Sales $-
Revenue $-
Cost
Variable Costs $-
Fixed Costs $-
R&D Costs $-
Total Costs $-
Profit
Total Profit $-
Profitability 0%
Contribution Margin 0
Contribution Margin Ratio 0
Break Even Point
In Units
Fixed Costs $-
Contribution Margin 0
In Dollars
Fixed Costs $-
Contribution Margin Ratio 0

Table 3: CVP for W3 in 2012.

The represented figures and the CVP definition suggest that the ongoing 2013 indexes should be squared to show promising results and good performance on the market. Nonetheless, the issue is that the W3 product requires more investments than it can produce sales profits so that contribution margin and break-even point can be planned as the two- three-year strategy. In this case, the price strategy should adopt such projections and either increase prices for W3 or decrease expenses on the product (Ermekbaev and Kim 19). However, the further market activity proved that R&D decrease is not a feasible strategy so that the R&D triggers price growth for Wonder Co. to follow the growth strategy.

The represented figures below show changes over time in all three products, where prices are adjusted to the market performance. Moreover, such changes positively affected CVP, as the indexes in contribution margins are squared each year during the growth phase.

2013 2014 2015
$275 $275 $275
$ 1 480 329 $ 3 792 546 $ 2 403 412
$ 429 295 461 $ 948 136 479 $ 660 938 225
$ 222 049 376 $ 568 881 887 $ 460 511 789
$ 75 000 000 $ 75 000 000 $ 75 000 000
$ 7 200 000 $ 1 200 000 $-
$ 304 249 376 $ 645 081 591 $ 645 081 591
$ 125 046 085 $ 303 054 591 $ 221 826 466
29% 32% 29%
5 382 13 791 8 739
0,02 0,05 0,03
13 934 5 439
$ 75 000 000 $ 75 000 000 $ 75 000 000
5382 13791 8739
$ 3 800 216 055 $ 1 483 231 181,55
$ 75 000 000 $ 75 000 000 $ 75 000 000
0,02 0,05 0,03

Table 4: CVP change for W1.

2013 2014 2015
$450 $460 $ 460
$ 1 422 150 $ 1 642 034 $2 308 671
$ 625 746 072 $ 821 016 809 $ 1 061 085 803
$ 391 091 295 $ 451 559 245 $634 720 891
$ 37 500 000 $ 37 500 000 $37 500 000
$ 10 800 000 $ 9 600 000 $10 800 000
$ 439 391 295 $ 498 659 245 $683 060 860
$ 186 354 777 $ 322 357 564 $378 720 942
30% 39% 39%
3 160 3 569 5 018
0,04 0,04 0,06
11 868 10 507
$ 37 500 000 $ 37 500 000 $37 500 000
3160 3569 5018
$ 989 010 989,03 $ 856 550 809,19
$ 37 500 000 $ 37 500 000 $37 500 000
0,04 0,04 0,06

Table 5: CVP change for W2.

2013 2014 2015
$195 $195 $ 210
$165 586 $377 274 $ 412 567
$ 30 633 325 $ 56 591 051 $67 936 041
$ 9 107 205 $ 20 750 052 $20 750 052
$ 37 500 000 $ 37 500 000 $37 500 000
$ 6 000 000 $ 13 200 000 $13 200 000
$ 52 607 205 $ 71 450 052 $71 450 052
$ -21 973 879 $ -14 859 001 $ -2 859 001
-80% -26% -3%
849 1 934 1 964
0 0,01 0,01
44 176 19 385
$ 37 500 000 $ 37 500 000 $37 500 000
849 1934 1964
$ 8 495 387 563,16 $ 3 727 940 532,75
$ 37 500 000 $ 37 500 000 $37 500 000
0 0,01 0,01

Table 6: CVP change for W3.

Benefits from CVP Analysis for Projections

The total cost considers all production costs as related to each type of product manufactured, regardless of whether they are fixed or variable. The unit cost of production calculated by using this method includes direct material, direct labor, and both variables with fixed production overheads. Thus, this method distributes part of the fixed production overhead costs for each unit of production along with variable production costs.

When using margin accounting, production costs include only those expenses that change during the production volumes differentiation. They usually encompass direct material, direct labor, and variable production overheads. Fixed production overheads are not allocated to the product. They are considered as expenses of the period and, like sales and administrative expenses, are fully allocated to the corresponding period (Ermekbaev and Kim 19).

Consequently, the unit cost of work in progress or products sold using this method does not include any fixed production overhead. The technique of margin accounting is sometimes considered as accounting for variable / direct costs. Comparison of profit and loss statements was based on the traditional approach and considered the marginal income indicator.

To summarize the contrast of the methods of full and margin accounting, it is necessary to consider what happens to sales and administrative expenses. Therefore, regardless of which method is used, variable and fixed sales and administrative expenses are always considered as expenses of the period in which they were incurred.

Variable Name 2012 2013 2014 2015
Revenue
Total Sales $ 1 531 940,00 $ 3 068 065,00 $ 5 811 853,00 $ 5 580 163,00
Revenue $ 523 298 924,00 $ 1 085 674 859,00 $ 1 825 744 338,00 $ 1 730 093 175,00
Cost
Variable Costs $ 300 161 138,00 $ 622 247 876,00 $ 1 041 191 184,00 $ 992 572 645,00
Fixed Costs $ 112 500 000,00 $ 150 000 000,00 $ 150 000 000,00 $ 150 000 000,00
R&D Costs $ 24 000 000,00 $ 24 000 000,00 $ 24 000 000,00 $ 24 000 000,00
Total Costs $ 436 661 138,00 $ 796 247 876,00 $ 1 215 191 184,00 $ 1 166 572 654,00
Profit
Total Profit $ 86 637 786,00 $ 289 426 982,00 $ 610 553 154,00 $ 583 681 036,00
Profitability 17% 27% 33% 33%

Table 7: Profitability Change based on CVP.

Margin accounting allows not only to build a forecast of sales based on statistical data but also to predict the level of coverage of fixed costs, that is, to estimate the level of net operating profit at the end of the month already in the middle of the month. However, it should be mentioned that only fixed costs should be attributed to period costs, since assigning variable sales and administrative expenses according to the classical scheme distorts the forecast and accounting model in cases when variable sales and administrative expenses have a high share in the cost structure.

A high level of variable sales costs is characteristic of activities associated with large volumes of logistics when the cost of delivery can significantly affect the price (Ermekbaev and Kim 20). In this case, the task of the enterprise information system is to collect operational information about the cost of loading and unloading, delivery costs, both for planning the value of the proposed transaction, and for calculating the actual price.

Thus, CVP analysis should help to reduce the risk associated with the choice of the decision, and strengthen the creativity in its adoption. It should be based on accounting information, reporting, plans, and forecasts. Analysis requirements are made due to management needs. The analysis itself may impose accounting requirements to review its effectiveness for management (Ermekbaev and Kim 20). The primary demand for the accounting system is to take into account variable costs with the maximum degree of detail in order to get an answer to the question of the effectiveness of each transaction separately, including: by type of activity, manager, region, and warehouse.

It should be noted that the mathematical model of “cost-volume-profit” should underlie both subsystems for forecasting financial results and subsystems for pricing management. Particular attention should be paid to the classification of costs according to their behavior, that is, the division into fixed and variable costs, taking into account the capabilities of the information system, to keep a detailed record of variable costs. However, the costs of maintaining such an accurate accounting may exceed the benefits of the potential of such forecasting.

Work Cited

Ermekbaev, A.Z., and S.A. Kim. “CVP -analysis as a tool for effective business planning.” Eurasian Union Scientists, vol. 1, no. 69, 2019, pp. 18–21. Web.

Cite this paper

Select style

Reference

BusinessEssay. (2022, October 15). Wonder Co.: The CVP Analysis. https://business-essay.com/wonder-co-the-cvp-analysis/

Work Cited

"Wonder Co.: The CVP Analysis." BusinessEssay, 15 Oct. 2022, business-essay.com/wonder-co-the-cvp-analysis/.

References

BusinessEssay. (2022) 'Wonder Co.: The CVP Analysis'. 15 October.

References

BusinessEssay. 2022. "Wonder Co.: The CVP Analysis." October 15, 2022. https://business-essay.com/wonder-co-the-cvp-analysis/.

1. BusinessEssay. "Wonder Co.: The CVP Analysis." October 15, 2022. https://business-essay.com/wonder-co-the-cvp-analysis/.


Bibliography


BusinessEssay. "Wonder Co.: The CVP Analysis." October 15, 2022. https://business-essay.com/wonder-co-the-cvp-analysis/.