Unit 4 Final
Unit 4 Final
Unit 4 Final
Prepared in advance
Based on objectives to be attained
Expressed in monetary and/or physical units
Prepared for the implementation of policy
formulated by the management
2
Budget may provide for:
a sale of Rs. 1,00,000(i.e., monetary
units) or
for a sale of 10,000 units (i.e., physical
units) or
For a sale of 10,000 units of Rs. 1,00,000
(i.e., both)
3
4
Means of control
Actual state of affairs is compared with the
budget
Appropriate action is taken to correct
deviations if any
Use of a budget to control a firm’s activities
is known as BUDGETARY CONTROL.
5
Provide an organized procedure for planning
Coordinating all activities of various
departments of a business firm
Maximum profit to be achieved by using
minimum resources
Provides a means for determining the
responsibility for all deviations from the plan
(budget)
Supply information on the basis of which
corrective action may be taken.
6
7
To ensure efficient & maximum use of scarce
resources
Budget incorporates expected performance
and present managerial targets
Target guides business operations, help in
overcoming problems and analyzing the
future
Influences the formulation of all business
strategies
Subsequently assists business managers in
executing such strategies
8
Existence of a well laid plan thereby forcing
executives to think of the relationships
among individual operations & the company
Budgets broaden individual thinking by
helping to remove unconscious biases on the
part of engineers , sales and production
officers.
Help to search out weaknesses in the
organizational structure by isolating
problems of communication, fixed
responsibility and of working relationships
9
Budgets inform each other of what others
have agreed to do
Also inform managers of the resources
available to achieve objectives and targets
10
11
Essential requirements for sound budgeting:
Clear lines of defined authority &
responsibility throughout the organization
Quantified organizational goal clearly stated
Participation of personnel in setting budgets
motivates them to achieve budget levels of
efficiency and activity.
Budget should be flexible designed to change
in relation to the level of activity attained.
12
Proper communication systems should be
established for management reporting and
information service
Education of the budget process and creation
of a cost awareness atmosphere
Top Management’s involvement in setting
the budgets and targets, checking their
actual attainment, motivating the personnel,
rewarding achievements, investigating
deviation and taking punitive actions.
Appointment of a Budgetary Controller
13
Basis for internal audit since regularly
evaluating departmental results.
Wastages & Losses are avoided and thus
maximum efficiency is attained
‘Management by exception’ reporting –
reporting only the deviations from budgets
Management plans ahead to achieve long
term goals
Increased communication & coordination in
the firm
Motivated workforce because of their
participation in setting of budgets 14
Identification of areas of efficiency &
inefficiency
Acts as a yardstick for comparing actual
performance
Establishes divisional & departmental
responsibility, helps in identification of people
responsible for deviation from budget
Managements with well ordered budget plan
receive greater favour from credit agencies.
Extent of financing is predetermined thus
avoiding possibility of over or under
capitalization
15
Based on estimates, so total accuracy is not
certain
Tend to be misleading in due course of time
due to changes in market, technology etc.
Long term budgets suffer from inflexibility
since managers would have to operate within
the set limits
Complacency in managers if budgeted
performance is easy to achieve
If perceived as pressure devices , work force
can get demotivated
16
Overestimation of costs by managers saves
them from being held responsible, in future,
for overspending
Departmental conflict arises because of
competition for resource allocation
Short term perspective of the budget limits
their perspective
17
1) Obtaining estimates of sales, production
levels, expected costs and availability of
resources from each sub unit/ division/
department.
2) Coordinating estimates: Determining
potential of plans, estimate amount of
resources available and their allocation
3) Communicating the budget to responsible
managers and the concerned departments
4) Implementing the budget plan.
5) Reporting interim progress towards
budgeted objectives 18
19
To lay down general policies of management in
relation to the budgetary system
To provide necessary information to various
departments to prepare their budgets
To make available the advice and guidelines, if
needed for the preparation of budgets
To receive & scrutinize budgets
To evaluate & suggest lines of revisions and
amendments where necessary
To formulate master budget
20
To compare actual results with the budget
estimates and to recommend corrective
actions to be taken if required
To coordinate the budgetary programme
21
A written document or booklet specifying the
objectives of the budgeting organization and
procedures. Important matters covered:
Objectives of the organization and how they
can be achieved
Functions and responsibilities of each
executive both regarding preparation &
execution of budgets
Procedure to be followed for obtaining the
necessary approval of budgets
Time tables for all stages of budgeting
22
Reports, statements, forms and other records
to be maintained
The framework within which the costs,
revenues and other financial amounts are
classified must be identical both in accounts
and budget departments.
23
The length of the Budget period depends on:
The type of business
Length of the manufacturing cycle from raw
material to finished product
Ease of difficulty of forecasting future
market conditions and other factors
Financial cycle
However, a business enterprise generally
prepares:
Short range budget
Long range budget
24
Created for administrative and control
purposes
For a particular centre costs controllable by
the person responsible for that centre should
be precisely specified
Costs having joint responsibility such as work
carried out by a maintenance department,
should be kept separate from costs which can
be controlled by one manager.
Costs apportioned between 2 or more budget
centres should be controlled and 1 person
should be made responsible
25
Also called Limiting Factor
Influences the activities of an undertaking
Limits the volume of output
Has a direct impact on the profitability of
the organization
Its limitation or shortage may result in
restricting capacity utilization
May shift from time to time due to external
and internal circumstances
26
(a) Sales (i) Shortage of talented & experienced salesmen
(ii) Weak market demand or consumers’
resistance
(iii) Inadequate advertising due to lack of funds
(b) Materials (i) Availability of supply
(ii) Constraints due to licenses & quotas
(c) Labour (i) Shortage of labour
(ii) Shortage in Labour related facilities
(d) Plant & (i) Limited capacity due to lack of capital
Equipment (ii) Inadequate capacity due to shortage of space
(e) Management (i) Overall inadequacy of capital
(ii) Limited availability of technical & managerial
experts
(iii) Inadequate research efforts and product
designing 27
Budgets may be classified on the following
basis:
29
There may be 3 types of budgets:
30
Cover periods extending beyond 1 year.
Factors to be considered are:
Market trends, economic factors, growth of
population, consumption pattern, industrial
production, national income, government
economic and industrial policy
33
Also known as Progressive Budget
There will always be a budget for a year in
advance
New budget prepared at the end of each
month / quarter for a full year ahead.
Figures for the month or quarter which has
rolled down are dropped and the figures for
the next month or quarter are added
34
35
Designed to remain unchanged irrespective
of the level of activity actually attained
Based on a single level of activity
Cannot be used for the purpose of cost
control since actual output is often
significantly different from budgeted output
Since units are overlooked, a cost to cost
comparison without considering the units
may give misleading results.
36
Prepared for a range i.e., more than one
level of activity
Set of alternative budgets to different
expected levels of activity
Provides a reliable basis for comparisons as it
is automatically geared to changes in
production activity
Facilitates development of departmental
expense budgets
Provides expense goals for managers of
responsibility centres
37
Budget estimates of a plant servicing
department:
Items of Cost Planned at 6000 Planned at 9000
service hour (Rs.) service hour (Rs.)
Salaries 28,000 28,000
Indirect Materials 42,000 63,000
Miscellaneous Costs 16,000 20,500
Required:
A flexible budget for the department for
7,000, 8,000 and 9,500 service hours
38
Budget estimates of a plant servicing
department:
Items of Cost Planned at 6000 Planned at 9000
service hour (Rs.) service hour (Rs.)
Salaries 28,000 28,000
Indirect Materials 42,000 63,000
Miscellaneous Costs = 6000*1.5= 9000*1.5=13500
9000+7000 (FC) +7000(FC)
16,000 20,500
Required:
A flexible budget for the department for
7,000, 8,000 and 9,500 service hours
39
Flexible budget of the department
7,000 Service 8,000 Service 9,500 Service
Hours (Rs.) Hours (Rs.) Hours (Rs.)
Salaries (fixed) 28,000 28,000 28,000
Indirect 49,000 56,000 66,500
Materials
(Variable at
Rs. 7 per hour)
Miscellaneous
Costs:
Variable at Rs. 10,500 12,000 14,250
1.5 per hour
Fixed 7,000 7,000 7,000
94,500 1,03,000 1,15,750
40
Indirect materials:
46
Drawn up after taking into account expected
opening stock, estimated sales, desired
closing stock of each article.
Production Budget = budgeted sales+ closing
stock –opening stock.
47
ABC Co. plans to sell 1,08,000 units of
certain product in first fiscal quarter,
1,20,000 units in 2nd quarter; 1,32,000 in 3rd
qtr. & 1,56,000 units in 4th qtr. And 1,38,000
units in the 1st qtr. Of the following yr. At
the beginning of the 1st qtr. Of the current
year, there are 18,000 units of product in the
stock. At the end of each qtr. the company
plans to have an inventory equal to one-sixth
of the sales for the next fiscal qtr.
How many units must be manufactured in
each qtr.?
48
ABC COMPANY
Production Budget
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
Units Units Units Units
Sales Budget 1,08,000 1,20,000 1,32,000 1,56,000
Add: Stock
required at the
end of period 20,000 22,000 26,000 23,000
Total 1,28,000 1,42,000 1,58,000 1,79,000
Less: Stock in
the beginning 18,000 20,000 22,000 26,000
Estimated
Production 1,10,000 1,22,000 1,36,000 1,53,000
49
Shows quantities of materials required in
budgeted production
Also shows level of material stocks to be
maintained at the end of the period
50
Estimated sales during next year will be
40,000 units. Materials required will be 3
units of A and 5 units of B for each unit sold.
Note: The total production required for the year (42,000) has been
calculated as: Estimated sales (40,000) + Closing Stock (7,000) –
Opening Stock (5,000)
Materials Required : A = 42,000 x 3 = 1,26,000
B = 42,000 x 5 = 2,10,000 52
It shows the quantity of raw material which
should be available at a particular time
Also the estimated cost of the material
Provides a plan that enables the purchase
department to purchase the required
material sufficiently in advance
53
Estimates of raw material inventory:
Type of Qty. as on Price as on Amount as on Qty. as on
Material 1.1.09 1.1.09 1.1.09 31.12.09
L 700 units Rs. 3.00 Rs. 2,100 800 units
M 15 tons Rs. 35.00 Rs. 525 7 tons
N 1,500 Kg Rs. 0.75 Rs. 1,125 1,050 Kg
O 800 gallons Re. 1.00 Rs. 800 750 gallons
P 10,500 units Rs. 0.20 Rs. 2,100 600 units
Consumption of different types of raw material for various
departments:
Material Departments
I II III IV
L (units) 4,500 - 3,000 500
M (tons) 11 3 - 4
N (Kg) - 600 700 1,350
O (gallons) 350 700 - -
P (units) 5,600 6,300 1,500 800
54
Estimates of raw material inventory:
Type of Qty. as on Price as on Amount as on Qty. as on
Material 1.1.09 1.1.09 1.1.09 31.12.09
L 700 units Rs. 3.00 Rs. 2,100 800 units
M 15 tons Rs. 35.00 Rs. 525 7 tons
N 1,500 Kg Rs. 0.75 Rs. 1,125 1,050 Kg
O 800 gallons Re. 1.00 Rs. 800 750 gallons
P 10,500 units Rs. 0.20 Rs. 2,100 600 units
Consumption of different types of raw material for various
departments:
Material Departments
I II III IV
L (units) 4,500 - 3,000 500
M (tons) 11 3 - 4
N (Kg) - 600 700 1,350
O (gallons) 350 700 - -
P (units) 5,600 6,300 1,500 800
55
Purchase Budget
Material Units Opening Exp. Closing Requir- Price Budget
Stock Consu- Stock ements Rs. Rs.
mption
L Units 700 8,000 800 8,100 3.00 24,300
M Tons 15 18 7 10 35 350
N Kgs 1,500 2,650 1,050 2,200 0.75 1,650
O Gallon 800 1,050 750 1,000 1.00 1,000
P Units 10,500 14,200 600 4,300 0.20 860
28,160
56
A part of production budget
Contains an estimate of all direct labour cost
required to produce budgeted products
Labour of different grades are ascertained in
terms of labour hour, machine hours and
wage rate
Total labour cost is ascertained accordingly
i.e., budgeted output multiplied by labour
cost per unit
57
Labour hour requirements of 3 products manufactured in a factory:
Direct labour hours per unit
( in minutes)
Products 1 2 3
Operation 1 18 42 30
2 - 12 24
3 9 6 -
The factory works 8 hours per day, 6 days in a week. Budget qtr. is 13
weeks and during a qtr. lost hours due to leave etc. are 124 hrs.
Budgeted hourly rates for workers for operation I, II and III are Rs. 2.00,
Rs. 2.50 and Rs. 3.00.
Budgeted sales: Product 1: 9,000 units; Product 2: 15,000 units; Product
3: 12,000 units. A carry over of 5,000 units of Product 2 and 4,000 units
of Product 3 and stock at the end of the budget qtr.: Product 1: 1,000
units; Product 3: 2,000 units.
Prepare (i) direct labour hours, (ii) direct labour cost and (iii) number of
workers
58
Quarterly Man-Power Budget
Product 1 Product 2 Product 3 Total
Hrly.
Operati Rate D.L. Cost D.L. D.L. D.L. No. of
on (Rs.) Hrs. Rs. Hrs. Cost Rs. Hrs. Cost Rs. Hrs. Cost Rs. workers
I 2.00 3,000 6,000 7,000 14,000 5,000 10,000 15,000 30,000 30
II 2.50 - - 2,000 5,000 4,000 10,000 6,000 15,000 12
III 3.00 1,500 4,500 1,000 3,000 - - 2,500 7,500 5
Total 4,500 10,500 10,000 22,000 9,000 20,000 23,500 52,500 47
Working Notes: 1
Production Budget
Product 1 2 3
Units Units Units
Sales 9,000 15,000 12,000
Add: Closing Stock 1,000 - 2,000
Less: Opening Stock - 5,000 4,000
Production Budget 10,000 10,000 10,000
59
Note 2: Total available hours in a quarter per man
Total Hours = 8 x 6 x 13 = 624
Less: Hours lost due to leave etc. = 124
Total available hours per man = 500
Note 3: The calculation of direct labour hours, direct labour cost
and number of men has been made as:
= 30 men
Similarly calculations have been made for other products
60
Shows the forecast of all production
overheads
Production overheads divided between fixed,
variable and semi variable factory overheads
Fixed overheads increase with an increase in
capacity or size of the factory
Variable & Semi variable change with the
level of activity
Factory overheads distributed among
production and service deptts. and thereafter
service deptt. overheads are reallocated to
production deptt. 61
Accounting year of ABC Cosmetics starts from
1st April 2009. Estimates of items of factory
overhead costs are:
Volume of Production (in units) 1,20,000 1,50,000
Expenses:
Indirect Materials Rs. 2,64,000 Rs. 3,30,000
Indirect Labour 1,50,000 1,87,500
Maintenance 84,000 1,02,000
Supervision 1,98,000 2,34,000
Engineering Services 94,000 94,000
63
Represents the plant & machinery
requirements to meet the production budget
Will show the load of machine in each
department
Shows the extent of under and over loading
on plant & machinery and corrective
measures may be taken on time.
64
3 articles X,Y & Z are produced in a factory. They pass through 2
cost centres A & B. Sale budget for the year
Product Annual Budgeted Opening stock of Closing Stock
Sales (units) finished product
(units)
X 4,800 600 Equivalent to 2 month sales
Y 2,400 300 Equivalent to 2 month sales
Z 2,400 800 Equivalent to 2 month sales
Machine hours per unit of production
Cost Centre A Cost Centre B
Product X 30 70
Product Y 200 100
Product Z 30 20
Total No. of machines in Cost Centre A are 284 and Cost Centre B are 256; total
no. of working hours during the year are estimated 2,500 hours per machine.
Compile a statement for budgeted machine utilization in both centres.
65
Production Budget
Product Sales Closing Opening Production Budget: Sales +
(units) Stock (units) Stock (units) Closing Stock – Opening Stock
X 4800 800 600 5000
Y 2400 400 300 2500
Z 2400 400 800 2000
66
A combination of 3 budgets
67
Prepare a production budget for each month and a summarized
Production Cost Budget for the 6 months period ending 31st Dec
2009. The units to be sold for different months are:
Variable per unit – Rs. 1.50, Fixed per unit Rs. 2.50
68
Production Budget for Product X- 6 months ending 31 Dec ‘09
July Aug. Sept. Oct. Nov. Dec. Total
Estimated Sales 1,100 1,100 1,700 1,900 2,500 2,300 10,600
Add: Desired Closing
Stock 550 850 950 1,250 1,150 1,000 1,000
1,650 1,950 2,650 3,150 3,650 3,300 11,600
Less: Likely Opening
Stock 550 550 850 950 1,250 1,150 550
1,100 1,400 1,800 2,200 2,400 2,150 11,050
70
Prepared to depict budgeted cost of goods
meant for sales
Prepared by adjusting cost of production by
opening or closing stocks of finished goods
May also be prepared product wise.
71
Shows estimated expenditure of
administration, offices and management
remunerations during the budget period
Budgets prepared by several departments or
budget centres are incorporated in this
budget
Expenditure may also be classified into fixed
and variable overheads estimated on the
basis of past records and future plans
72
Forecast of all expenses incurred in selling
and distribution function during the budget
period
Closely connected with sales budget as it is
based on the volume of sales projected
May be certain expenses which cover future
budget period such as advertising
73
Prepare sales overhead budget
Advertising Rs. 2,500
Salaries of the sales department Rs. 5,000
Expenses of sales department Rs. 1,500
Counter salesmen’s salaries & dearness allowances Rs. 6,000
Commission to counter salesmen at 1% on their sales
Travelling salesmen’s commission at 10% on their sales and
expenses at 5% on their sales.
Sales during the period were:
Counter Sales (Rs.) Travelling salesmen’s sales (Rs.)
Period I 80,000 10,000
Period II 1,20,000 15,000
Period III 1,40,000 20,000
74
Sales Overhead Budget
Estimated Sales Rs. 90,000 Rs. 1,35,000 Rs. 1,60,000
Fixed Overheads:
Advertising 2,500 2,500 2,500
Salaries of sales deptt. 5,000 5,000 5,000
Expenses of Sales deptt. 1,500 1,500 1,500.
Counter salesmen’s salaries & D.A. 6,000 6,000 6,000
15,000 15,000 15,000
Variable Overheads:
Counter salesmen’s commission 800 1,200 1,400
(1% on sales)
Travelling salesmen’s commission 1,000 1,500 2,000
@ 10%
Expenses (5%) 500 750 1,000
2,300 3,450 4,400
Total Sales Overheads 17,300 18,450 19,400
75
Research: to find new products and to find
new ways of old products
Drawn up taking into account the research
projects in hand and the new projects to be
taken up
Also necessitates the analysis of expenses into
fixed & variable
Normally a long term budget, not part of
production budget
Prepared for each project separately and sub
divided into short term budgets on annual
basis
76
Shows how much machine capacity is needed
and when, determines what new machines
have to be installed and at what time
Capital expenditure may be avoided by getting
some work done by outsiders
May be short term or long term
Availability of capital fund is a limiting factor
It must be coordinated with each budget as in
the cash budget, provision for cash required
for capital expenditure has to be made and in
factory overhead, provision for repairs,
maintenance, insurance etc.
77
A summary statement of the firm’s expected
cash inflows and outflows over a projected time
period
Helps in determining the future cash needs of
the firm
Helps in planning for financing of those needs
Helps in exercising control over cash & liquidity
of the firm
Overall objective is to enable the firm to meet
all its commitments in time and preventing
accumulation of unnecessary large balances
with it
78
79
The cash receipts from various sources and
cash payments to different agencies are
estimated
Receipts & Payments are divided into capital
& revenue
In the opening balance of cash of a period,
cash receipts are added and the estimated
cash payments are deducted to find out the
closing balance which will become the
opening balance of cash for the next period
80
Prepare cash budget for May, June & July’10
Income & Expenditure Forecasts
Manufac-
Credit Credit turing Office Selling
Month Sales Purchases Wages Expenses Expenses Expenses
March 60,000 36,000 9,000 4,000 2,000 4,000
April 62,000 38,000 8,000 3,000 1,500 5,000
May 64,000 33,000 10,000 4,500 2,500 4,500
June 58,000 35,000 8,500 3,500 2,000 3,500
July 56,000 39,000 9,500 4,000 1,000 4,500
August 60,000 34,000 8,000 3,000 1,500 4,500
Cash balance on 1st May ’10: Rs. 8,000. Plant costing Rs. 16,000 is
due for delivery in July, payable 10% on delivery and the balance
after 3 months. Advance Tax: Rs. 8,000 is payable in March &
June. Period of credit allowed (i) by suppliers – 2 months and (ii)
to customers – 1 month. Lag in payment of manufacturing
expenses - ½ month, office & selling expenses – 1 month
81
CASH BUDGET
Particulars May '10 June '10 July '10
Opening Balance 8,000 13,750 12,250
Estimated Cash Receipts
Debtors (Credit Sales) 62,000 64,000 58,000
70,000 77,750 70,250
Estimated Cash Payments
Creditors (Credit Purchases) 36,000 38,000 33,000
Wages 10,000 8,500 9,500
Manufacturing Expenses 3,750 4,000 3,750
Office Expenses 1,500 2,500 2,000
Selling Expenses 5,000 4,500 3,500
Plant - payment on delivery - - 1,600
Advance Tax - 8,000 -
Total 56,250 65,500 53,350
Closing Balance 13,750 12,250 16,900
One-half of the manufacturing expenses of April and one-
half of those of May shall be paid in May i.e., (1/2 of Rs.
3,000) + (1/2 of Rs. 4,500) i.e., Rs. 3,750 and so on…
82