Cost-volume-profit analysis, Financial Management

Assignment Help:

Cost-Volume-Profit Analysis

The Cost-Volume-Profit (CVP) analysis provides answers to vital questions such as: At what sales volume would the firm break-even? How sensitive is the profit to variations in output? How sensitive is the profit to variations in selling prices? What should be the sales level in quantity terms for the firm to earn the target level of profits?

One basic assumption of CVP analysis is that all costs could be segregated into fixed and variable, and costs which are of a semi-fixed or semi-variable nature could be segregated into the fixed and variable components.

The method of simple linear regression is commonly used to segregate the fixed and variable components of semi-fixed or semi-variable costs. The illustration given below explains the application of regression technique in CVP analysis.

Example 

The following table gives the repairs and maintenance cost incurred in a cost center for various levels of annual production.

Output  

 (in thousands of units)

Repairs and Maintenance Cost Rs.(in thousands)


1.0

15

2.0

21

2.5

24

3.0

26

3.5

29

4.0

32

5.0

36

6.0

40

7.0

44

8.0

49

 

If the budgeted production of the cost center in the forthcoming year is 8500 units, what would be the estimated repairs and maintenance cost ignoring possible increase in price levels?

In order to segregate the repairs and maintenance cost into fixed and variable components and to forecast the estimated cost at a production level of 8,500 units, first of all, the estimating linear regression equation of the form Y = a + bX must be determined. In this equation, Y is the estimated total cost of repairs, 'a' is the fixed component of the total cost, 'b' is the variable component per unit of production and 'X' is the volume of production sought to be achieved.

In order to determine the estimating equation, the following table should be set up.

X

Y

XY

X2


1

15

15

1

2

21

42

4

2.5

24

60

6.25

3

26

78

9

3.5

29

101.5

12.25

4

32

128

16

5

36

180

25

6

40

240

36

7

44

308

49

8

49

392

64


  Total  42

316

1544.5

222.5

 

1593_cost volume profit analysis.png 

We know that,

 

b    =  2275_cost volume profit analysis1.png

From the table, we know that

1916_cost volume profit analysis2.png


          a        = 31.6 - (4.71)(4.2) = 11.818

Since 'a' the intercept represents the fixed cost, at any volume of production the fixed cost is Rs.11,818. The variable repairs and maintenance cost is Rs.4.71 per unit produced.

For a budgeted production of 8,500 units, the estimated repairs and maintenance cost will be as follows:

 

Rs.

Fixed Component

11,818

Variable Component (8,500 x 4.71)

40,035

Total

51,853

While budgeting this figure it may be approximated to Rs.52,000.

 


Related Discussions:- Cost-volume-profit analysis

Explain the preferred stocks by equity claims, Explain the preferred stocks...

Explain the preferred stocks by equity claims. Preferred stocks are equity claims with limited ownership rights in comparison to common stocks. They differ from common stocks i

Full, Full, Fair and Adequate Disclosure The architecture of business...

Full, Fair and Adequate Disclosure The architecture of business has evolved from proprietorship to partnership to joint stock companies or publicly held companies. Except fro

Define the term shareholders, Shareholders Shareholders are usually ass...

Shareholders Shareholders are usually assumed to be interested in wealth maximisation. This though involves consideration of potential return and risk. Where a company is liste

Dry up of liquidity and increased correlation, Hedge funds are short two ty...

Hedge funds are short two types of funding options. Describe in detail what these options are. Describe why these options become more valuable during a financial crisis. During

What spot exchange should one forecast 5 years into future, The current spo...

The current spot exchange rate is Dr240/$1.00. Long-run inflation in Greece is calculated at 8 percent yearly and 4.5% in the United States.  If PPP is expected to hold among the t

Explain the internalization theory of fdi, Normal 0 false fal...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

What do you mean by collateralized mortgage obligation, Q. What do you mean...

Q. What do you mean by Collateralized Mortgage Obligation? Collateralized Mortgage Obligation (CMO) - SECURITY whose cash flows equal the difference between cash flows of colla

Healthcare Finance, I am trying to make a payment and I can''t seem to get ...

I am trying to make a payment and I can''t seem to get it to go throught on you all site..

Business, Ken started college at the age of 18 with $63,450 already saved, ...

Ken started college at the age of 18 with $63,450 already saved, because 18 years ago his saving account 7.25 per year.

Finance company vital role in investment intermediaries, How is the finance...

How is the finance company play a vital role in investment intermediaries? Finance companies: Finance companies make loans to corporations and individuals by giving consu

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd