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

Traditional capital budgeting techniques, Traditional   Capital Budgeting ...

Traditional   Capital Budgeting Techniques These techniques are usually very simple and easily catchable. But the fundamental drawback of these methods is that they don't cons

Calculate the ex-right stock price, DIY Inc. plans to raise $200,000 with a...

DIY Inc. plans to raise $200,000 with a right offering. The current stock price is $100 and there are 80,000 shares outstanding. a. If DIY sets the subscription price to be $80

#title.case let., this case has been framed in order to test the skills

this case has been framed in order to test the skills

Advantages to the investors, Advantages to the Investors: The warran...

Advantages to the Investors: The warrant acts as a sweetener and ensures a better subscription to the NCDs, especially for companies with good track record. NCDs with warran

Discuss about stock market and stock exchanges , Successful managers and in...

Successful managers and investors understand the various financial markets and the investments these markets offer. A good understanding of potential gains and losses, as well as t

Zero-volatility spread, The zero-volatility spread is a measure of th...

The zero-volatility spread is a measure of the spread that the investor would realize over the entire Treasury spot rate curve if a mortgage-backed or asset-backe

Plan for financial management, 1. Review and analyse financial data for the...

1. Review and analyse financial data for the last year to establish areas which have generated a profit or loss in your organisation. 2. Conduct a research to review reasons for

Which ratios would a banker be most interested, Which ratios would a banker...

Which ratios would a banker be most interested in when considering whether to approve an application for a short-term business loan? Explain. Bankers and other lenders use liq

Analysis of capitalization, You must analyze how the company is financed th...

You must analyze how the company is financed through equity and debt financing. You will discuss the level of leverage and how it compares to similar companies in the Industry.

State about the manufacturing overseas, State about the Manufacturing overs...

State about the Manufacturing overseas or exporting Dyson (appliances manufacturer) relocated UK production to Malaysia in 2002 though still retained its head office within the

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