Overheads Allocation Techniques Explained
Overheads Allocation Techniques Explained
(Lecture #1)
Overheads
Production
Non-manufacturing
.
Oh
(DM/DL)
Like
High/low method etc will be used to
find rothuit.
Folt
Allocated basis .
arbitrary
> No link to it :
on
Overheads allocation
i) for accounting to
finda stock value.
i) For
pricing
ii) For Decision
Making
Pricing
DM 10 Sales
fecounting
-
DL 5
Department DM 10
Upon & DL 5
19 Admin Vot 4
FRONT FPOH
22
Sot 5
for
30
Full cost
Markup a
t o
Allocation of overheads
① Blanket Rate of
Single/plant wide Rate
systems system
-
&
Product x 20 X 16 .
5 = 330 + 670 - 1000
Product y 12 X 16 .
5 = 198 +
482 =
680
Product z 30 X 16 .
5 = 495 + 305 - 800
② Departmental of Rate
System
Equip. Factory Heating & Power Maintenance Supervision
Dep. Rent. Lighting. Cost. Cost. Cost
27 OAR = 13 5 . OAR = 9
Hours in
A Hours in B Hours in C Direct cost
Product X 7 .
00 8 .
00 500 67
Product y 12- 00 0 00.
0 00 .
482
Product 0 00. 5 00.
25 00
.
305
u (7x27) + (8x 13 .
5) + (5x9) = 342
(12x27) 324
y
-
= 292 5 .
⑧ HoL
-
400
So
X
X 250
X6g
Heating lighting
G frea 30008
187560 45000
Depreciation Machine value
480000 920000 300080
others
fixed Ous Labour hours 2160008 1200000 1480550
5685550 3975000 3425550
Labour hours 216050 120080 140088
Total
offs allocated
A - (8x26 32)·
+ (5x33 + 25) + 0 -
376-185 x 12000 =
-
B (12x 26 ·
32) + 0 +12x 24 46)
.
-
364 76
: x 1000
-
Canteen
DI Da D3
MSF
QC
PD PD PD Other deput .
PD SD
Step# Service
departments costs will be allocated to
production departments
.
98508 122006
114208 19350 17350
Reallocation (19350)
of X 9675 5805 3870
Reallocation 3470 6940 6940 (17350)
of Y
111645 134795 125018 - -
GAR . 50
2 502
.
2 49
.
.
Repeated distribution Method
Inter-service
department cost allocation
A B C X Y
Cost 500 600 300 50 80
A B C X Y
Cost allocated 580 600 300 50 80
Reallocation 15 (50)
of X 10 20 5
Reallocation 34 17 (85)
of y 17 17
549 627 337 17
-
Reallocation 5 7 (f) 2
of X 3
> T ↑
OAR ~ ~ ~
Do
single digit
this till
Simultaneous Equation Method
A BC X Y
Cost 500 600 300 50 80
A B 2 X
Y
Cost 500 600 300 50 80
Reallocate 34 70 17 34 17 34 17 34 (86
73)
ofy
. -
. . -
554 9 . 630 81 .
344 26 .
- -
x 50 20 %
y
= +
80 10% v
y
= +
u = 50 + 20 % (80 + 10x)
u = 50 + 16 + 2%
x =
67 34 .
00 10 % (67 34)
y
= + -
y = 86 .
73
(Lecture#3)
②
PDA PDB PBC X
Y
Cost Sor 7oo 900 40 70
Reallocation
R 20 % yo 301- 10%
50% 20 % 10 % 20 %
Y
x 40 20 %
y
+
=
y
10% 1
=
70 +
x = 40 + 20 % (70 + 10 % x)
n 90 + 2% V
19
=
+
n = 55
x 35
y 70 10 %
= +
755
y
=
n 16500 20 %
y
= +
10600 + 10 % R
y
=
n = 10620 + 2% n
n = 19, 000
12500
y
=
So
A B Y Z
3630 + 30 % Z
y
=
z 2000 + 20%
y
=
y
=
3630 + 30% (200 + 20 %
600
y)
3630 + + 6%
y y
=
458
y
=
z = 2000 + 20 % x4500
- 298
Concept
Revised OAB
Case
after bringing a New Machine
Factory
his: 9000/year
M1 M2 M3
Maintenance = (300) 100X3
New Machine
(240)
Setup = 80X 3
OAR = 310
2622600
Budgeted OH = 8460X310 =
hus =
700 Additional depreciation -
400000
(150)
Electricity
Maint =
= 600000
Setup
Loss as
200880
operators
= =
other OHS -
18500
130880
Revised OAR
of company
-2622650
+13000
=
32140 Blanket. as
S
12500
Idle (900)
11600 x 390
4524000 Of
existing
=
machine
New =
853000
5377080
Revised
=577000-300
Ar =
10 12
(2400X85)
Electricity
Maintenance (25000x11)
204000
275000 =
10000/month
Parts replacement (10000x1) 110008
853850
2024 Question
Sol
=
Old machines
2x2500 I
5000
Effective hours
of old machines = 4700
OAR I 850
Existing
OHS = 3995000
Depreciation 120000
(2310 x 180)
Electricait
415800
maintenance 200000
1145800
1145800
4700 + 2310
= 733 35 .
/Lecture # 4)
Concept
Different allocation basis
PD A .
PD B .
PD . C
Machine hours 58 70 =
70
/labhu 10/Machr
R 5) Machine hours X 10 = 50
y 2 Machine hours X 10 = 20
Z 3 Machine hours X 10 =
30
Dept-
Safai Rs 500000 = 5000000
.
- 0 .
1/rsofmaterial
A Bu
Material 2000000
Budgeted
1000000 2000000
Overheads F 3)760000 =
30% = OAR
117200050
C =
60000000X30% = 1824000 + 20000 =
912/mit
②
Product A 5
Si cost
/ Induct S [235ste
.
3 .
Material zolmit S
Sid
Direct ·
Ex-factory cost
Prime cost 38
Ex-factory cost 93 7 .
Dm)
Admin OH (20
% a
Full cost 47 4 .
20% .5
9
Markup
SP.
56 9 .
Product - -
140%
of DM)
Full cost 113500
(113500X0 .
25)
Sp
11875
Product X Product Y
D .
Material 2000 4500
D Labour.
6000 4508
Admin (25%
ofDM) 500 1125
11500
12375
Profit (20% ) 2308 2475
SP 13800 14050
10)
② spalling %
A
of this question was
B
less than
Sp 13800 14850
DM 2000 4580
6000
DL 4500
Post
of DL
are a %
·
folt %
of DM
are a
A B
Sp 13800 : 1 2 -
14850 = 12
.
DM (2000) (4500)
DL (6000) (4500)
Pot +folt 3500
3375
pot+ for 3500
6000
=
- 1 33
.
60002 + 3500
2000 y
=
45004 +
958y =
3375
X 1 .
333
6000dHorry
6000K
-
4500
2000y = -- 3500
4000 y
= 1000
y to
-
= 25%
60002 + 2000 X0 .
25= 3500
6000K - 3500 -
500
=
R
= 50 %
A B
Sp 54125= 1 25 .
61667X0 25
.
(10825) (1546)
Profit
43308 46250
(16000) (12500)
DM 12500 R +
20000y 13750
DL (15000) (20000)
30 %
Poo 12300
13750 U = 7
pot
y = 50% >
fot
(Lecture #5)
Over/under Absorption
Day 1
Bug 000
f
it is
DM 50
DL 40
OH 12 5
:
102 5 .
Profit 17 5
.
120
365hDoy
Actual output =
,
15 000
X12 5.
Recovered Fo =
187500
Actual Fo = 120500)
Sept
2022 2023
00030 500 t
33
Steph
14800x30 = 444000
17200 x 33 =
567688
fatual =
(465200) fatual = 150 2000)
-
S
ha
20
-00000
=
Applied
A B
otR/unit 60 48
Actual
Depreciation 82500
67550
Maintenance 130000 70000
Insurance 98050 42000
Building related 104000 56500
j
Applied For 41450 235570
Fol
Budgeted 39008 223200
(24500) (12300)
=> FoH
Budget
: Units
X Actual output =
Recovered Fol
OAR
A fetual
B
PD1 PD2 PD3 Output
C
Day-I
Budgeted Fott
Product
A
Actual output B
=
Recovered Fort
C
futual Fort
PDC OR OAR
PD3
OnR
faul output =
feel For
teuel
Applied
Shine Glow
Actual output 100000 60000
OAR/unit 1800
1700
Recovered/Applied Fot 100000 102000
A B X Y
) 69000 11500 11500
Salary(Emene)
23000
50000 30000 - -
Building (Area)
125000 5000 5000 250
Reallocation (20000)
Fy
o 15000 3000 2000
Reallocation (30500)
qu 24480 6180
18000
40008
90
100
X22 =
S
00
x8 = 800
A B X
Y
Rent (Area) 1250 938 187 125 2000 X 22000
3400
Fuel (M- hrs) 990 810 - -
Reallocation (305)
of 6
R 122 122
4314 3004 - -
OAR 300
196 .
x 269 + 15%
y
=
180 201
y = +
n = 305
241
y
=
Lecture #6)
#March-
24
Sol
-
A B X Y
Reallocation (26500)
of y 11925 10600 3975
158425 130600
3975
-
Reallocation
of se
1987 1590 (3975) 396
160412 132190
-
396
Reallocation 29 23 (59) 6
of 160619 132371
17
go
hos as
Machine
②
2023
OAR/mit =
50
(Max 50000)
Budgeted output =
90000
capacity
-
Required
Budgeted , Applied & futual Fort
otR-aged
2023
2024 i) Overtime = 200,000
Budgeted Fort
2000000
-
> 2075000 + 600000 ii) Electricity bill = 500
, 000 -
OR 58 51 07
.
Insurance #0000)
Actual opp
X
year's Actual
Fort
FOH
Budgeted
Prio > Next
year
-
>
-
* 150000
·
S or
GS
Cover-applied) %556 034)
**
(under-Applied)
Recovery <E S&
. With i) a
Cover-Applied) -
% So 9. . Overheads
& Last
year Current
year
9220000
Budgeted
Fot 9000000 + 300000 + 200000
45000
Budgeted op 45000
OAR 200 204 89 .
(A) *In point one over production would result in over recovery of overheads. However, no cost is increasing in point one overall point one is
-
*In point two actual factory overheads are increasing and no change in application/recovery of overheads. This will result in under application of
overheads.
*In point number three actual overheads are increasing with no corresponding change in recovery of overheads as a result under recovery of
overhead would result.
Important concept
M1 M2 M3
Hours
for B 270 360 450
(90x0 3) .
(900x0 %) .
(900X0 5).
X3 X2 X3
Operator
hour
26851720 3975
(KWH) 33125
Electricity 13425
(095x15)
17208
(800 x 20) (125X25)
(Lecture #f)
I L 3
Hours
for A 900 750 1200
Hour
for B 400 366 720
Machine hours 1380 III0 1920
operators 4 3 2
Electricity 76020
=
2128500 = = 28
↓ 2 3
888
OAR/Machine hour 954 916
1 2 3
840 720
for A
Hours 600
160 240
zaro
Hours
for 320
1 2 3
(kwH) 700000
Electricity
936000 1196000
&
* 264X00%
MH = X hoo
FA
DM
X 3000
* 53 X100
X -
1708
X 400
X 300
Sol ( RS in 000 (
-
Machine
Assembly Finishing Maintenance
Indirect Labour 46 27 36
137
Indirect Material 60 18 36 91
25
Depreciation 62 9 12
of
=
of Machine
hours
*
felocated the basis
Reallocation (53)
on
20% cost 12 9 =
of
31
of Floor Area
.
8000
Hours 40000 16000
OAR 24 .
3 19 3 .
10 L .
"Production
~
Direct hours
wages
↓ (Both)
By sir
-
-
S
Selection Jam Distribution
making Bottling Storage
Direct 8000 20000
Wages
Rent (Floor Area) 20400 27200 17000 13600 6000
OAR/Hour 60 64 to
D -
material 36
D
. Labour 25
Of
"
A 10 .
1 X 60 6
B (0 25/64.
16
C (0 .
15 x 70 10 .
5
93 5X12
Cost/Bottle 1122 cost
of each Carton
.