Cost-volume-profit analysis, Financial Management

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.

 

Posted Date: 9/17/2012 1:56:52 AM | Location : United States







Related Discussions:- Cost-volume-profit analysis, Assignment Help, Ask Question on Cost-volume-profit analysis, Get Answer, Expert's Help, Cost-volume-profit analysis Discussions

Write discussion on Cost-volume-profit analysis
Your posts are moderated
Related Questions
Sapp Trucking's balance sheet illustrates a total of noncallable $45 million long-term debt with a coupon rate of 7.00% and a yield to maturity of 6.00%.  This debt presently has a

What are the risks related with using a large amount of short-term financing for working capital? Using a large amount of short-term financing usually permits funds to be raised

Suppose the demand for bananas increases. Explain how the price of bananas adjusts after the increase in demand. If the demand for bananas rises, a shortage is made at the origin

Q. Explain about Types of costs? Thus two types of costs are involved in keeping cash balance in a business- (i) Opportunity Cost (ii) Transaction Cost When cash balan

1. Increasing the number of indirect-cost pools is guaranteed to sizably increase the accuracy of product or service costs.do you agree? Support your anser using examples 2. The

Export/Import Bank (Eximbank) Federal Import-Export Bank, whose mainly function originally was to compensate U.S. exporters for subsidies approved competitors by foreign govern

A computer products store stocks color graphics monitors, and the daily demand is normally distributed with a mean of 1.6 monitors and a standard deviation of 0.4 monitor. The lead

FINANCIAL ISSUES OF DIVESTITURES Many corporations review the business portfolio to determine the operations that fit their core strategies. The firm's desire to achieve more f

Why do most international bonds have high Moody’s or Standard & Poor’s credit ratings? Answer:  Moody’s Investors Service and Standard & Poor’s offer credit ratings on several

Selecting the source of the finance: after prepare of the capital structure an appropriate source of the funds. Various sources of the finance may be raised include share capital