Wednesday, May 9, 2012

Cost Volume Profit Analysis


The CVP model makes the assumptions that costs can be simply divided into fixed and variable costs. It assumes that over a range of output levels - the relevant range - fixed costs remain constant and variable costs increase directly with output. The variable costs behave in a linear fashion. The fixed costs are periodic costs so that cost items such as rent, rates, insurance, depreciation etc. are constant at all levels of output. There is also an assumption that the sales revenue behave in a linear fashion ie. the selling price  is constant per unit of output.

Economists take a more realistic view of cost behaviour. They contend that variable costs do not behave in a linear fashion but are effected by economies of scale. Companies can benefit from discounts for bulk purchases of materials and
the economies from the division of labour. The economists’ model represented in a curvilinear graph shows the total cost line rises steeply at low output levels, levels off within a range of output and finally rises steeply again as the benefits of economies of scale decline. The total revenue line rises steeply, levels off and then declines. This curvilinear total revenue line reflects the fact that  to achieve more sales the company may have to reduce the selling price and does not increase proportionally with output.
  

As a compromise it is possible to accept the assumptions that the CVP model is based on within a certain range of output - the relevant range. Therefore, the CVP model can be used as a planning technique to:


            (a)        find the break-even point

            (b)       determine the margin of safety

            (c)        determine a target volume

            (d)       establish the profit volume ratio or contribution volume ratio

            (e)        determine the operating gearing


It is possible to ascertain these by using a break-even chart or by using formulae.
















Let us look at a basic accounting equation ie.


Sales - Total costs = Profit

            or


Sales - ( Variable costs - Fixed costs ) = Profit

            then

Sales - Variable costs = Contribution



Contribution is the excess of sales over variable costs and it represents the surplus available to meet the fixed costs. Once the fixed costs have been met any contribution left is profit.



At the break-even point the sales revenue generated covers the total costs and no more.



At the break-even point the contribution is sufficient to meet the fixed costs. 


Contribution = Fixed costs



BEP  =       Fixed Costs
              Contribution per Unit


P/V or C/S ratio = Contribution   X   100
                                      Sales



The P/V ratio indicates the % of contribution to sales.














Formulae:


1          Break-even point = Fixed costs/ Contribution per unit


2          Margin of safety = Break-even point(units) - The Expected Sales


3          Sales(units) to achieve a profit   Fixed costs + Target profit
                                                                   -----------------------------------
                                                                    Contribution per unit


4          Profit volume ratio = Contribution   x  100
                                                 ----------------------------
                                                  Sales revenue


5          The Operating Gearing = Contribution / Profit




It is possible to present the profit volume relationship in a chart, a profit-volume chart. This chart dispenses with the need to draw cost and revenue lines and concentrates on the relationship between profit and output.

 

Revenues
   and
Costs (£)



 



                                                                                    Output (units)



A break-even chart




 

Profit



                                                                                 Output (units)



Loss




Limitations of cost volume profit analysis.



CVP analysis is based on a number of simplistic assumptions about cost behaviour which undermine the model’s effectiveness.

1          Costs can be divided into fixed and variable costs but  in reality many   costs have a fixed and variable element(semi-variable) and may not be       easy to divide.

2          There is a linear relationship between output and costs and revenues.
             The economists view tends to dispute this and presents a curvilinear
             model.

3          The business has only one product or there is a specific constant product
            mix.

4          The only factor influencing costs and revenues is output. Other factors
            such as production efficiency and production methods may impact on output.    




Example:

A company has sales of 120,000 units which sell for £1 with the variable costs 50p per unit. The fixed costs are £40,000. The management want to know the B/P point, the margin of safety and the profit. Solve graphically and by formula.





















BUDGETING
The Planning Process

All organisations have their objectives.  Some of the objectives may not be expressed in accounting terms for example objectives to improve the welfare of the staff or to improve the  impact on the local environment. However, in this chapter  the emphasis is on objectives usually expressed in quantitative terms eg. increase in market share, profit growth, increase in the asset value etc which they wish to achieve. There are three levels of planning - corporate long term planning, medium term planning and annual planning or budgeting. The annual budgets are steps along the way to achieve the long-range plan of the organisation.
 To ensure that the objectives are achieved plans or budgets must be prepared.

Definition: A budget is a financial or quantitative interpretation prior to a defined period of time, of a policy to be pursued for that period, to attain a given objective.


Budgets are part of the planning and control process. They help to define the objectives of the organisation. Budgeting is probably the most important contribution that the accounting department makes to the role of management.

The accountant draws up a plan which integrates the various functional areas of the business. Control is exercised by firstly, delegating responsibility to departmental managers for the attainment of the budgets and then the regular comparison of the actual results with the planned outcomes. 

Budgets assists an organisation 

·      to plan and control profitability

·      to plan and control production resources

·      to plan and control capital expenditure

·      to plan and control finance

An organisation which engages in budgeting can obtain the benefits of

·      better planning and awareness of what has to be achieved

·      greater coordination of the different functional areas

·      better communication with staff contributing to the targets to tbe set

·      motivation of the staff with staff assigned their responsibilities

·      efficient and effective use of scarce resources and an awareness of cost-consciousness






Administration of the budget.

The administration of the budget is the responsibility of the budget officer who is usually the accountant . The accountant works in conjunction with the budget committee comprised of the departmental management. Senior management
outline the broad strategic objectives of the organisation and communicate these to the functional managers. The budget committee identifies the key budget factor which determines what acts as a constraint on the organisation’s activities. This key budget factor decides the key budget ie. the one which sets the objectives for the subordinate budget. The subordinate budgets are constructed by asking the questions - when are the goods to be sold, where are the goods to be sold and how are the goods to be produced.It may be the sales volume which drives the other subsidiary budgets. For instance, if the sales department forecasts the annual sales at 20,000 units then the production budget must be integrated with this figure. Alternatively, productive capacity may be the key budget factor . The company may have the capacity to produce only 18,000 units a year so this figure sets the objectives for the other budgets.

The accountant helps the managers to set the budgets by providing information as required. Sales forecasting may proceed by means of statistical methods which are based on economic indicators  or by carrying out an internal forecast by canvassing the sales staff. The current sales level, past trends, market research can provide useful information.

On receipt of the various budgets  the accountant notifies managers of revisions to their budget. Once the accountant and the committee agree  the master budget which is a forecasted profit and loss account  and balance sheet can be drawn up.
In terms of control the accountant is responsible for the regular monitoring of the budgets,  for reporting back to the budget committee regularly( daily,weekly or monthly basis) through variance reports and for revising the budgets if necessary.

Preparing budgets

Example

The budgeted sales of Magee Engineering Lt. for 19x0 is as follows:

Product
Sales units
Unit selling price
Dag
20,000
£25
Mag
18,000
£20
Pag
15,000
£22

The opening stocks at the beginning of the year 19x0
Product
Product units
Component
Part units
Dag
3,000
A
40,000
Mag
3,000
B
50,000
Pag
2,000
C
60,000


D
40,000


E
10,000

The marketing director intends to run a marketing campaign towards the end of 19x0 and has requested that product unit stocks should be increased at the end of 19x0 above the commencement stocks by the following

                                    Dag increased by 20%
                                    Mag increased by 50%
                                    Pag increased by 20%

The purchasing director has requested that all components part stocks be reduced by 20% at the end of 19x0 because of improved delivery times from suppliers.

The product material specification and component cost for each of the products are as follows:















Component part
A
B
C
D
E

Part cost (each)
50p
35p
60p
55p
£1.0
Product
Component parts






per product





Dag

3
4
6
2
1
Mag

2
3
4
2
1
Pag

5
2
3
3
1

The newly appointed managing director asks you to prepare the following budgets and to explain the linkage between them.

1                    Sales budget in product units and value
2                    Production budget in product units
3                    Material usage budget in component parts.
4                    Materials purchase budget in component parts and value.

1. Sales Budget 19x0

Product
Units
Price
Total sales
Dag
20,000
£25
£500,000
Mag
18,000
£20
360,000
Pag
15,000
£22
330,000

--------

------------

53,000

£1,190,000

--------

------------

Comment: the sales budget is computed from the sales information stated, the budget shows the the individual product sales units,sales value and total sales value. The budgeted sales for 19x0 are 53,000 units with a total sales value of £1,190,000.


Production budget 19x0


Dag
Mag
Pag
Sales units (from the sales budget)
20,000
18,000
15,000
Add closing stock
3,600
4,500
2,400

--------
--------
--------

23,000
22,500
17,400
Less opening stock
3,000
3,000
3,000

-------
--------
--------
Budgeted output
20,600
19,500
15,400

--------
--------
--------

Comment: the production budget is the required production to meet sales budget requirements and changes in stocks, thus since closing stock requirements are greater than opening stocks then production must be increased to cope with required production for sales and increased closing stock requirements.

3. Materials Usage Budget 19x0 (Component usage)

Product
Prod. units
A
B
C
D
E
Dag
20,600
61,800
82,400
123,600
41,200
20,600
Mag
19,500
39,000
58,500
78,000
39,000
19,500
Pag
15,400
77,000
30,800
46,200
46,200
15,400

--------
--------
--------
--------
--------
--------

55,500
177,000
30,800
171,700
247,800
55,500

--------
---------
--------
---------
---------
--------

Comment: the material usage budget is the component usage. This is simply the production units from the production budget equated to the component specification in each production unit eg. material usage of compont A is the total usage of component A in Dag, Mag and Pag.


4. The Material Purchase Budget 19x0
Component
A
B
C
D
E
Material usage budget
177,800
171,700
247,800
126,400
55,500
Closing stock
32,000
40,000
48,000
32,000
8,000

----------
----------
---------
----------
----------

209,800
211,700
295,800
158,400
63,500
Opening stock
40,000
50,000
60,000
40,000
10,000

---------
---------
---------
---------
---------

169,800
161,700
235,800
118,400
53,500
Price per component
50p
35p
60p
55p
£1.00

£84,900
£56,595
£141,480
£65,120
£53,500


Comment: The material purchase budget gives the cost and quantity of each component that is needed to be purchased and the overall cost of all five components. This budget is based on the material usage budget adjusted for oppening and closing stocks.




Cash Budgets


The cash budget shows the forecasted cash inflows and outflows of a business and measure the estimated balance or deficit of cashfor a particular period.
The advantages of planning for cash resources is essential since a business cannot survive without cash.

Advantages:

The cash budget ensures adequate cash planning and control


(a)               Cash deficits are revealed and management can respond by taking appropriate action. Remedial action can be taken by  injecting more capital into the business, by borrowing, by examining their credit policy or by deferring capital expenditure.

(b)               Cash surpluses are indicated and once recognised need to be managed. Management can invest cash in the short-term, or avail of trade discounts by bulk purchasing materials or finance capital projects.

Example

The London Toy Co. Ltd. commenced operations in December 19x0 with a capital of £600,000 which was raised through an issue of 600,000 ordinary shares of £1 each. The proceeds of the share issue were paid into the company bank account. During the course of December a number of transactions took place and these are summarized below.

Cash summary December 19x0


£
£
Proceeds from share issue

600,000
Less Leasehold premises (20 years)
300,000

Plant (est. life 10 years)
80,000

Equipment (est. life 10 years)
160,000

Tools
20,000

Raw materials
10,000
570,000

----------
----------
Cash balance available

30,000


======

You are given the following  additional information.

(a)               Sales are budgeted as follows: £80,000 in January; £160,000 in February and £240,000 in subsequent months. Fifty per cent of the sales will be cash sales and the other fifty per cent credit sales. The period of credit extended to customes will be one month.

(b)               The cost of raw materials will amount to 40% of the sales revenue. Half the materials cost for any one month will be paid in cash; the other half will be paid for during the month of  purchase.

(c)                The company intends to keep a stock of raw materials of £10,000 throughout the year.

(d)               Direct wages will be incurred at the rate of £50,000 per month. No time lag is expected here.

Other expenses- depreciation on premises, plant and equipment will be calculated on a straight-line basis.The tools will be re-valued annually and it is expected that annual losses will amount to 20 per cent. All other expenses will be incurred at the rate of £40,000 per month - the time lag here will be one month.

You are asked to prepare the company’s Cash budget, a budgeted Profit and Loss account for the first six months of operations and a budgeted Balance Sheet as at 30 June 19x1.


Jan
Feb
Mar
Apr
May
Jun
Memo

£000
£000
£000
£000
£000
£000
£000
Opening balance
30
4
(14)
16
70
124

Cash inflow







Cash sales
40
80
120
120
120
120

Credit sales

40
80
120
120
120
120Dr

------
------
------
------
-------
-------

Total
70
124
186
256
310
364


------
------
-----
-----
------
------









Cash outflow







Raw mats. -cash
16
32
48
48
48
48

Raw mat. -credit

16
32
48
48
48
48Cr
Direct wages
50
50
50
50
50
50

Other expenses

40
40
40
40
40
40Cr

------
------
------
------
------
------

Total
66
138
170
186
186
186


------
------
------
------
------
------

Closing balance
4
(14)
16
70
124
178


===
===
===
===
===
===


Students should note that:

(a)               Depreciation never appears in a cash budget as it is a non-cash expense.

(b)               In respect to credit transactions time lags have to be built into the cash budget

It is useful to have a memo column to record items which will appear in the balance sheet if required.





Budgeted Profit and Loss Account
for six months ending 30 June 19x1


£
£


£
Cost of sales
480,000


Sales
1,200,000
Direct wages
300,000
780,000




----------




Operating profit

420,000





----------


-----------


1,200,000


1,200,000


=======


=======
Depreciation



Operating profit
420,000
Premises
7,500




Plant
4,000




Equipment
8,000




Tools
2,000





-------
21,500



Other expenses

240,000



Net profit

158,500





----------


----------


420,000


420,000


======


======







The profit and loss account is prepared on an accruals basis unlike the cash budget which is prepared on a receipts and payments basis. Also, depreciation appears as an expense in the profit and loss account.

Budgeted Balance Sheet
as at 30 June 19x1

Authorised and Issued Capital
£

£
£
£


Fixed assets
Cost
Dep.
NBV
600,000 Ord. shares £1 each
600,000
Premises
300,000
7,500
292,500
Reserves

Plant
80,000
4,000
76,000
Profit and loss account
158,500
Equipment
160,000
8,000
152,000


Tools
20,000
2,000
18,000



---------
--------
---------



560,000
21,500
538,500



---------
---------

Current Liabilities

Current assets



Creditors
48,000
Materials
10,000


Accrued expenses
40,000
Debtors
120,000




Cash
178,000

308,000

--------

----------

----------

846,000



846,000

======



=====

Budgeted debtors, creditors and cash balance is obtained from the cash budget. Details of  fixed assets can be obtained from the capital expenditure budget. Information about share capital, debentures etc. can also be obtained from the previous balance sheet.

 Budgeting - the Control Process

Definition:

Budgetary control is the establishment of departmental budgets relating the responsibilities of executives and the continuous comparison of actual with budgeted results, either to secure by individual action the objective of that policy or to provide a basis for its revision. The budget itself is merely a plan on paper which of itself will not be effective unless there is a system of control which can monitor the organisation’s progress to achieving the objectives.

By means of comparing actual results with the budgets and identifying any differences (variances) which occur management can take remedial action or revise the budget if necessary. The  annual budgets are broken down into months so the comparison is performed regularly and results in a  budget report ipresented to the departmental managers. To ensure that management are not overburdened with  accounting data exception reports may be furnished. These reports identify only significant variances that require management’s attention and consequently are more user friendly and should encourage an appropriate managerial response.

Personnel Dept                      Monthly Budget Report       February
Cost code
Description
Budget
Actual
Variance
Budget
Actual
Variance
010
Supervisors’ salary
£58,000
£65,000
£7,000 (A)
£116,000
£125,000
£9,000 (A)

Flexible Budgeting

Up to this point the budget has been fixed. This is quite appropriate for planning purposes but of little use for control purposes. The fixed budget does not respond to the actual level of activity. When organisations compile the master budget it is
based on a certain level of output and sales. In most instances, the company may find that this operating level is not set at the actual level of activity. Indeed  most organisations find it difficult to forecast the actual level of activity eg. there may be a seasonal characteristic to the company’ trading. In such cases the business may find it more useful to prepare flexible budgets. A flexible budget is ‘designed to change in accordance with the level of activity attained’ (CIMA)

A fixed budget is not designed to change with different levels of activity. It does not allow for the pre-determination of costs and revenues at different levels of output which would facilitate comparison with actual costs and the identification of variances.
A flexible budget is designed to recognise cost behaviour at different levels of output so actual results can be compared with the expected results and the computation of variances and variance analysis is  made possible.


Example:

A company produces garden furniture which experiences fluctuations in production levels because of its seasonal nature. The following costs for the budgeted level of activity of 20,000 units and the actual production costs fpr the period are given.


Budget Costs (20,000 units)
Actual costs incurred (17,600 units)

£
£
Materials - variable
21,000
20,000
Labour - variable
1,000
980
Maintenance - variable
3,000
2,680
Fixed production costs
10,000
10,000
Selling costs - fixed
5,000
6,000

--------
--------

40,000
39600

--------
--------

During the relevant period, the actual number of units produced was 17,600. You are required to prepare a budget flexed at the actual level of activity. In preparing the flexed budgets it is important to identify fixed and variable costs to forecast costs at different levels of activity.



Actual  costs
Flexed budget (17,600 units)
Variance

£
£
£
Materials
20,000
18,480
1,520 (A)
Labour
980
880
100 (A)
Maintenance
2,680
2,640
40 (A)
Fixed productioon costs
10,000
10,000
-----
Selling costs
6,000
5,000
1,000 (A)

-------
-------
-----------

39,660
5,000
2,660

--------
-------
----------

The variance report highlights that in respect to actual materials, labour, maintenance and selling costs, these are higher than expected. Management can examine and analyse the variances and take appropriate action.

Many businesses prepare fixed budgets for departments where expenditure may be more predictable such as the administration department. Flexible budgets can be compiled for those departments whose expenditure is closely linked to the level of operations such as the production department.








The Human Element in Budgeting

So far the emphasis has been on the technical aspects of budgeting viz. the preparation and administration of budgets. However, the behavioural context deserves mention.  One of the main components of budgeting is control which is all about altering the behaviour of the human resources in the organisation. Consequently, there may be some staff who regard budgets as a constraint on their freedom and may try to subvert the effectiveness of the budget. How can  senior management ensure that the budgeting system can be most effective?

Research findings assert that managers prefer to work towards achieving objectives which motivate them. It appears that motivation is the glue which holds the budgeting and control systems together so creating this motivation is the key. There appear to be a number of factors involved.

1                    Budgets (targets) should be set at a level which are stringent and challenging but attainable. If set too high to be unattainable the staff may be demoralised and may not try to achieve the targets.

2                    Departmental managers in consultation with their staff should be permitted to participate in the setting of their budgets by so doing they will have ownership of them and will strive to attain them. Participation clarifies responsibilities, increases communication throughout the organisation and can help to promote line-staff relations. However, it is well to acknowledge possible dysfunctional behaviour as a consequence of participation in budget-setting such as ‘budgetary padding’ or ‘budgetary slack’. It may serve the manager to build ‘slack into the budget ie. to have a ‘pad’ between the formal plan and the expected actual results so that they have a cushion in case unanticipated events cause their performance to decline.

3                    Since budgets tend to be used as a management performance criteria there should be a reward system in place. Too often budgets are used as a mechanism to focus on  poor performance so is it any wonder that the staff have negative feeling about them.

4                    Overemphasis on performance/variance reports may encourage negative attitudes to budgeting. Hopwood referred to the ‘budget constrained’ style of management with performance in  meeting the budget  as the main criteria.

The organisation should be concerned with other management performance criteria such as concern with quality, good industrial relations, cooperation with colleagues etc.        

There are significant benefits for organisations which engage in budgeting.

1                    Budgeting forces management to focus on the future, to consider the dynamics of the external environment  and identify the potential opportunities and threats.

2                    In the process of preparing the budgets managers are compelled to co-ordinate the various activities of the organisation and to be less ‘departmental minded’  and to be more ‘company minded’.

3                    It tends to encourage communication throughout the organisation. Staff are aware of what they are expected to achieve and regular budget reports and budget meetings keep them informed.

4                    By assigning managerial responsibility for the attainment of the  budgets and the regular comparison of  actual results and expected outcomes  individual managerial performance can be ascertained.

5                    Research has indicated the role budgets have in motivating managers to achieve the company’s objectives. Good performance can lead to career advancement so the managers desire to be successful is linked to the success of the company.


No comments:

Post a Comment