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 powers and functions of sebi, Question 1 What is liquidity ris...

Question 1 What is liquidity risk? What are the causes for liquidity risk? Question 2 Explain the powers and functions of SEBI Question 3 Discuss the various categories

What do you mean by cash flow ratios, Q. What do you mean by Cash Flow Rati...

Q. What do you mean by Cash Flow Ratios? Cash Flow Ratios: - Cash Flow Ratios are an additional device of cash management. Some important cash flow ratios are: (i) Cash Turn

Risks associated with short-term financing working capital, What are the ri...

What are the risks associated with using a large amount of short-term financing for working capital? Using a large amount of short-term financing in general allows funds to be

Dividend policy, DIVIDEND POLICY Dividends provide the portion of a fi...

DIVIDEND POLICY Dividends provide the portion of a firm's net earnings which are paid out to the shareholders. the objective of financial management of maximizing the share

Short-term volatility position, (a) The position of an agency that sells a ...

(a) The position of an agency that sells a callable coupon bond. We supposed that coupon bond has a maturity of 3 years and is callable only at the second year. (b) The market t

Determine primary variables being balanced in the eoq, What are the primary...

What are the primary variables being balanced in the EOQ (Economic Order Quantity) inventory model?  Explain The primary variables being balanced in the EOQ (Economic Order Quant

Define country’s economic well being enhanced, How is a country’s economic ...

How is a country’s economic well-being enhanced through free international trade in goods and services? As per to David Ricardo, with free international trade, it is mutually adv

The need and analyse different savings instruments, Question 1 Financial p...

Question 1 Financial planning is a process of assessing the goals of an investor. Discuss the meaning, need and scope of Financial planning Question 2 Money management is the

Annuties (ordinary vs due), The values shown in ordinary annuity tables (ei...

The values shown in ordinary annuity tables (either present value or compound value) can be adjusted to the annuity due form by ____ the ordinary annuity interest factor by ____. (

Speculating on future exchange rate movements, There is some discussion on ...

There is some discussion on whether Multinational Corporations (MNC's) enhance risk when borrowing foreign currencies. Those in favor of borrowing state that lower costs of financi

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