Inter Costing Homework and Class Test Answers
Inter Costing Homework and Class Test Answers
Ednovate
For subject
ednovateofficial related queries
Ednovate Official 7273 961 961
Ednovate Classes
TABLE OF CONTENTS
SOLUTIONS
HOME WORK SECTION
Solution 1.
Working Notes:
(i) Computation of Annual consumption & Annual Demand for raw material ‘Dee’:
Sales forecast of the product ‘Exe’ 10,000 units
Less: Opening stock of ‘Exe’ 900 units
Fresh units of ‘Exe’ to be produced 9,100 units
Raw material required to produce 9,100 units of ‘Exe’ 18,200 kg.
(9,100 units × 2 kg.)
Less: Opening Stock of ‘Dee’ 1,000 kg.
Annual demand for raw material ‘Dee’ 17,200 kg.
Average Consumption
1 MATERIAL COST
Or, 50 kg. =
(d) Impact on the profitability of the company by not ordering the EOQ.
When purchasing the ROQ When purchasing the EOQ
I Order 1,000 kg. 1,200 kg.
quantity
II No. of orders
a year
III Ordering Cost 18 orders × ` 720 = `12,960 15 orders × ` 720 = `10,800
IV Average
Inventory
V Carrying Cost 500 kg. × ` 17.2 = ` 8,600 600 kg. × ` 17.2 = ` 10,320
VI Total Cost ` 21,560 ` 21,120
Extra Cost incurred due to not ordering EOQ = ` 21,560 - ` 21,120 = `440
Solution 2.
Statement of Total Cost and Ranking
Item Units % of Total Unit cost Total cost % of Total Ranking
units (`) (`) cost
A 12,000 15.30% 30.00 3,60,000 12.97% 2
B 18,000 22.94% 3.00 54,000 1.95% 11
C 6,000 7.65% 35.00 2,10,000 7.57% 5
D 750 0.96% 220.00 1,65,000 5.95% 7
E 3,800 4.84% 75.00 2,85,000 10.27% 4
F 400 0.51% 105.00 42,000 1.51% 12
G 600 0.76% 300.00 1,80,000 6.49% 6
MATERIAL COST 2
H 300 0.38% 350.00 1,05,000 3.78% 10
I 3,000 3.82% 250.00 7,50,000 27.03% 1
J 20,000 25.49% 7.50 1,50,000 5.41% 9
K 11,500 14.66% 27.50 3,16,250 11.40% 3
L 2,100 2.68% 75.00 1,57,500 5.68% 8`
78,450 100.00% 27,74,750 100.00%
Solution 3.
(i) Optimal order quantity i.e. E.O.Q.
2x4,000x135
= 90,000 = 300 units
12
3 MATERIAL COST
2x4,000x80
(ii) Revised EOQ = = 231 units
12
4,000
Ordering cost = = 17.32 say 18 orders at Rs. 80 1,440
231
1
Carrying cost = × 231 × 12 1,386
2
2,826
Different in cost on account of this error = 3,690 – 2,826 = Rs. 864
Solution 4.
2DS
(i) EOQ =
C
96,000units ×1kg.
A = Annual consumption = = 24,000 kgs.
4 units
2x24,000 kgs.x5,500
EOQ = 3,186.5 kgs.
` 26
(ii) Number of orders = 24,000 kgs./ 3,186.5 kgs. = 7.53 or 8 ordersFrequency in placing
orders = 365 days / 8 orders = 45.63 or 46 days
(iii) If company places orders on quarterly basis, percentage of discount in price of raw
material to be negotiated:
Cost under EOQ:
Ordering cost 8 orders ×` 5,500 44,000.00
Carrying cost 3,186.5kgs. × ½ × ` 26 41,424.50
Total 85,424.50
Cost under Ordering on Quarterly Basis :
Ordering cost 4 orders × ` 5,500 22,000.00
Carrying cost (24,000 kgs./ 4 orders) × ½ × ` 26 78,000.00 Inc
Total 1,00,000.00
MATERIAL COST 4
Incremental cost if orders are placed on quarterly basis
= ` 1,00,000– ` 85,424.50 = ` 14,575.50
Reduction in purchase price to be negotiated
= ` 14,575.50 ÷ 24,000 kgs. = ` 0.61 per kg.
Percentage of discount to be negotiated 0.61 ÷ 54 × 100 = 1.13%.
Solution 5.
(i) Optimum run size or Economic Batch Quantity (EBQ) = 2XDXS
C
Batch No. of set-ups Set- up Cost (Rs.) Inventory holding Total Cost
size cost (Rs.) ( Rs.)
23 80,500 3,60,000
40,000 ( 23 × Rs. 3,500)
A 9,20,000 40,000xRs.18 4,40,500
units
40,000 2
49 1,71,500 1,70,235
18,915 9,20,000 18,915xRs.18 3,41,735
B (49x Rs.3,500)
units 18,915 2
Extra Cost (A – B) 98,765
(iii)
Costs Unit level Batch level
(a) Inventory carrying cost Variable cost Variable cost
(b) Designing cost for a job Fixed cost Variable cost, provided the entire job
work is processed in a single batch.
(c) Machine set-up cost to Fixed cost Variable cost
run production
(d) Depreciation of factory Fixed cost Fixed cost
building
5 MATERIAL COST
Solution 6.
Computation of cost per unit
(`)
Net purchase Price 800.00
Add: Packing charges (5 non-returnable boxes) 50.00
850.00
No. of units purchased 200 units
Cost per unit 4.25
Note:
(i) Cash discount is treated as interest and finance charges, hence, it is not considered for
valuation of material.
(ii) Input credit is available for IGST paid; hence it will not be added to purchase cost.
Solution 7.
Classification of the items of inventory as per ABC analysis
1. 15 number of varieties of inventory items should be classified as ‘A’ category items
because of the following reasons:
(i) Constitute 0.375% of total number of varieties of inventory handled by stores of
factory, which is minimum as per given classification in the table.
(ii) 50% of total use value of inventory holding (average), which is maximum, according
to the given table.
(iii) Highest in consumption, about 85% of inventory usage (in end- product).
2. 110 number of varieties of inventory items should be classified as ‘B’ category items
because of the following reasons:
(i) Constitute 2.750% of the total number of varieties of inventory items handled by
stores of factory.
(ii) Requires moderate investment of about 30% of total use value of inventory holding
(average).
(iii) Moderate in consumption, about 10% of inventory usage (in end– product).
3. 3,875 number of varieties of inventory items should be classified as ‘C’ category items
because of the following reasons:
(i) Constitute 96.875% of total varieties of inventory items handled by stores of factory.
(ii) Requires about 20% of total use value of inventory holding (average).
(iii) Minimum inventory consumption, i.e. about 5% of inventory usage (in end-product).
MATERIAL COST 6
Solution 8.
Inventory turnover ratio
(Refer to working note)
Working Note:
(`)
Opening stock of raw material 90,000
Add: Material purchases during the year 2,70,000
Less: Closing stock of raw material 1,10,000
Cost of stock of raw material consumed 2,50,000
Solution 9.
(A) (a) Value of Material Exe consumed during the period 1-4-2020 to 15-4-2020 by using
FIFO method.
Date Description Units Qty. (Units) Rate Amount
(`) (`)
1-4-2020 Opening balance 100 5 500
5-4-2020 Purchased 300 6 1,800
6-4-2020 Issued 100 5
150 6 1,400
8-4-2020 Purchased 500 7 3,500
10-4-2020 Issued 150 6
250 7 2,650
12-4-2020 Purchased 600 8 4,800
14-4-2020 Issued 250 7
250 8 3,750
15-4-2020 Balance 350 8 2,800
Total value of material Exe consumed during the period under FIFO method comes
to (` 1,400 + ` 2,650 + ` 3,750) ` 7,800 and balance on 15-4-2020 is of ` 2,800.
Value of material Exe consumed during the period 01-4-2020 to 15-4-2020 by
using LIFO method
7 MATERIAL COST
Date Description Units Qty. (Units) Rate Amount
(`) (`)
1-4-2020 Opening balance 100 5 500
5-4-2020 Purchased 300 6 1,800
6-4-2020 Issued 250 6 1,500
8-4-2020 Purchased 500 7 3,500
10-4-2020 Issued 400 7 2,800
12-4-2020 Purchased 600 8 4,800
14-4-2020 Issued 500 8 4,000
15-4-2020 Balance 350 — 2,300*
Total value of material Exe issued under LIFO method comes to (` 1,500 + ` 2,800
+ ` 4,000) ` 8,300.
*The balance 350 units on 15-4-2020 of ` 2,300, relates to opening balance on 1-4-
2020 and purchases made on 5-4-2020, 8-4-2020 and 12-4-2020. (100 units @ ` 5,
50 units @ ` 6, 100 units @ ` 7 and 100 units @ ` 8).
(b) As shown in (a) above, the value of stock of materials on 15-4-2020: Under FIFO
method ` 2,800
Under LIFO method ` 2,300
(B) Total value of material Exe issued to production under FIFO and LIFO methods comes to
` 7,800 and ` 8,300 respectively. The value of closing stock of material Exe on 15-4-2020
under FIFO and LIFO methods comes to ` 2,800 and ` 2,300 respectively.
The reasons for the difference of ` 500 (` 8,300 – ` 7,800) as shown by the following table
in the value of material Exe, issued to production under FIFO and LIFO is as follows:
Date Quantity Value Total Value Total
Issued FIFO LIFO
(Units) (`) (`) (`) (`)
6 - 4-2020 250 1,400 1,500
10-4-2020 400 2,650 2,800
14-4-2020 500 3,750 7,800 4,000 8,300
1. On 6-4-2020, 250 units were issued to production. Under FIFO their value comes
to ` 1,400 (100 units × ` 5 + 150 units × ` 6) and under LIFO ` 1,500 (250 × ` 6).
Hence, ` 100 more was charged to production under LIFO.
2. On 10-4-2020, 400 units were issued to production. Under FIFO their value comes
to ` 2,650 (150 × ` 6 + 250 × ` 7) and under LIFO ` 2,800 (400 × ` 7). Hence, ` 150
more was charged to production under LIFO.
MATERIAL COST 8
3. On 14-4-2020, 500 units were issued to production. Under FIFO their value comes
to ` 3,750 (250 × ` 7 + 250 × ` 8) and under LIFO ` 4,000 (500 × ` 8). Hence, ` 250
more was charged to production under LIFO.
Thus the total excess amount charged to production under LIFO comes to ` 500.
The reasons for the difference of ` 500 (` 2,800 – ` 2,300) in the value of 350 units of
Closing Stock of material Exe under FIFO and LIFO are as follows:
1. In the case of FIFO, all the 350 units of the closing stock belongs to the purchase
of material made on 12-4-2020, whereas under LIFO these units were from opening
balance and purchases made on 5-4-2020, 8- 4-2020 and 12-4-2020.
2. Due to different purchase price paid by the concern on different days of purchase,
the value of closing stock differed under FIFO and LIFO. Under FIFO 350 units
of closing stock were valued @ ` 8 p.u. Whereas under LIFO first 100 units were
valued @ ` 5 p.u., next 50 units @ ` 6 p.u., next 100 units @ ` 7 p.u. and last 100
units @ ` 8 p.u.
9 MATERIAL COST
Answer 10
As procurement time is given in days, consumption should also be calculated in days:
350
Maximum Consumption per Day: = 50 Kgs
7
210
Minimum Consumption per Day: = 30 Kgs.
7
(50+30)
Average Consumption per Day: = 30 Kgs.
2
EOQ =
=
(b) Re-Order Level (ROL) = (Maximum consumption Rate × Maximum
Procurement Time)
= 50 kgs per day × 9 days
= 450 kgs
(c) Maximum Stock Level = Recorder Level + Recorder Quantity – (Minimum
Consumption Rate × Minimum Procurement Time)
= 450 kgs + 646 kgs - (30 kgs X 5 days)
= 946 kgs
(d) Minimum Stock Level = Recorder Level – (Average consumption Rate ×
Average Procurement Time)
= 450 kgs – (40 kgs X 7 days)
= 170 kgs
(e) Average Stock Level = Maximum Stock Level + Minimum Stock Level
2
946 kgs + 170 kgs
=
2
= 558 kgs
MATERIAL COST 10
= Annual Consumption of Raw Materials
EOQ
14600 kgs
=
646 kgs
= 22.60 Orders or 23 Orders
11 MATERIAL COST
Answer 11
Working Notes:
Annual requirement (A) = 27,000 units
Cost per order (O) = ` 240
Inventory carrying cost (i) = 12.5%
Cost per unit of spare (c) = ` 50
Carrying cost per unit (i × c) = ` 50 × 12.5% = ` 6.25
27,000units
Consumption per day = = 75 units
360days
MATERIAL COST 12
Answer 12
(i) Calculation of most Economical Production Run
13 MATERIAL COST
SOLUTIONS
CLASS TEST
Solution 2.
(i) Calculation of Economic Order Quantity
Solution 3.
Annual consumption 250 kg × 52 weeks = 13,000 kg.
MATERIAL COST 14
(ii) Re-order level = Max. re-order period × Max, Consumption
= 7 weeks × 300 kg = 2,100 kg
(iii) Maximum level = Re-order level + Re-order Qty – (Min re-order Period × Min. Consumption)
= 2100 kg + 2000 kg – (5 × 200) kg = 3100 kg.
(iv) Minimum level = Re-order level – (Avg. re-order period × Avg. Consumption)
= 2,100 kg – (6 × 250) kg = 600 kg.
(v) Avg. stock level = (Max. level +Min.level)
Solution 4.
(i) Optimum batch size or Economic Batch Quantity (EBQ):
Solution 5.
(a) Total Annual Cost in Existing Inventory Policy
(`)
Ordering cost (6 orders @ ` 25) 150
Carrying cost of average inventory (36,000 ÷ 6) = 6,000 units per order
Average inventory = 3,000 units
Carrying cost = 20% of ` 1 x 3,000 = 3,000 x 0.20 600
Total cost A 750
15 MATERIAL COST
(`)
No. of orders = 36,000 ÷3,000 units = 12 orders
Ordering cost (12 × `Rs 25) = 300
Carrying cost of average inventory (3,000 × 0.20) ÷ 2 = 300
Total Cost B 600
Savings due to E.O.Q ` (750 – 600) 150
(A – B)
Note: As the units purchase cost of ` 1 does not change in both the computation, the
same has not been considered to arrive at total cost of inventory for the purpose of
savings.
Solution 6.
Where,
A = Annual Demand
O = Ordering cost per order
C = Inventory carrying cost per unit per annum
(i) Calculation of EOQ
Super Grow Nature’s Own
(ii) Total annual relevant cost = Total annual relevant ordering costs + Total annual relevant
carrying cost
Super Grow Nature’s Own
Number of Orders = = 2,000/100 =1,280/80
Annual Requirement =20 orders =16 orders
÷EOQ
Ordering Cost 20 × 1200 = ` 24000 16 × 1400 = `22,400
Carrying Cost ½ × 100 × 480 = `24,000 ½ × 80 × 560 = `22,400
Total of Ordering and =` 24,000+ ` 24,000 ` 22,400 + ` 22,400 =
Carrying Cost = ` 48,000 ` 44,800
MATERIAL COST 16
(iii) Number of deliveries for Super Grow and Nature’s own fertilizer per
Solution 7.
Basic Data:
A (Number of units to be purchased annually) = 5,00,000 units
O (Ordering cost per order) = ` 4,000
C (Annual cost of storage per unit) = ` 10
Purchase price per unit inclusive of transportation cost = ` 50
Computations:
(i) Re-ordering level (ROL)
= Maximum usage per period × Maximum lead time
= 2,000 units per day × 15 days = 30,000 units
(ii) Maximum level = ROL + ROQ – [Min. rate of consumption ×
Min. lead time] (Refer to working notes 1 and 2)
= 30,000 units + 20,000 units – [1,000 units per
day×5 days] = 45,000 units
(iii) Minimum level = ROL–Average rate of consumption×
Average re-order-period
= 30,000 units – (1,500 units per day × 10
days) = 15,000 units
(iv) Danger level = Average consumption × Lead time for
emergency purchases
= 1,500 units per day × 4 days = 6,000 units
Working Notes:
1. Minimum rate of consumption per day
2.
17 MATERIAL COST
03 EMPLOYEE COST
SOLUTIONS
HOMEWORK SECTION
Solution 1.
Working Note:
Average number of workers on roll (for the quarter):
Employee Turnover rate using Replacement method
EMPLOYEE COST 18
Solution 2.
Calculation of :
1. Time saved and wages:
Workmen A B
Standard time (hrs.) 40 40
Actual time taken (hrs.) 32 30
Time saved (hrs.) 8 10
Wages paid @ ` x per hr. (`) 32x 30x
2. Bonus Plan:
Halsey Rowan
Time saved (hrs.) 8 10
Bonus (`) 4x 7.5x
8hrsx`x 10hrs
x30hrsx`x
2 40hrs
3. Total wages:
Workman A: 32x + 4x = ` 36x
Workman B: 30x + 7.5x = ` 37.5x
Statement of factory cost of the job
Workmen A (`) B (`)
Material cost (assumed) y y
Wages (shown above) 36x 37.5x
Works overhead 240 225
Factory cost (given) 2,600 2,600
19 EMPLOYEE COST
On substituting the value of x in (i) we get y = ` 2,000
Hence the wage rate per hour is ` 10 and the cost of raw material is ` 2,000 on the job.
Solution 3.
50,000
Output by experienced workers in 50,000 hours = = 5,000 units
10
Solution 4.
(i) Halsey Premium plan :
1
= (Time taken x Rateper hour) + ( x Time saved x Rate per hour)
2
1
= (30 hours x ` 75) + ( x 10 hours x ` 75)
2
= ` 2,250 + ` 375 = ` 2,625
EMPLOYEE COST 20
(iii) Time wage system :
= Time taken × Rate per hour
= 30 × ` 75 = ` 2,250
Solution 5.
`
(i) Rowan Plan : Normal time wage = 15 hours @ ` 5= 75
5 18.75
Bonus = Time saved /Time allowed × (Time taken × Time rate) = X(15 x 5)
20
93.75
(ii) Halsey Plan: Normal time wage = 15 hours @ ` 5= 75
Bonus = 50% of (Time saved x Time rate) = 50% of (5x5)= 12.5
87.5
21 EMPLOYEE COST
Solution 6.
Statement showing computation of effective hourly cost of employee ‘X’
Per month (`) Per annum (`)
(A) Earning of Employee ‘X’:
Basic pay 10,000 1,20,000
Dearness Allowance 2,000 24,000
Bonus 2,400 28,800
Employer’s contribution to provident fund 1,200 14,400
Other allowances 2,500 30,000
18,100 2,17,200
(B) Effective working hours (refer workings) 2,000 hours
(C) Effective hourly cost {(A) ÷ (B)} `108.60
Workings:
Calculation of effective working hours:
Annual working hours less Normal idle time = 2,400 hours – 400 hours = 2,000 hours.
Solution 7.
Statement showing Earnings of Workers A and B
A (`) B (`)
Basic wages 10,000 16,000
Dearness Allowance (50% of Basic Wages) 5,000 8,000
Overtime wages (Refer to Working Note 1) 1,500 --
Gross wages earned 16,500 24,000
Less: Contribution to Provident fund (800) (1,280)
Less: Contribution to ESI (200) (320)
Net wages earned 15,500 22,400
EMPLOYEE COST 22
- Ordinary Wages (4: 3 : 3) 16,000 6,400 4,800 4,800
- Overtime 1,500 -- 1,500 --
Worker B:
- Ordinary Wages (5 : 2 : 3) 25,600 12,800 5,120 7,680
43,100 19,200 11,420 12,480
Working Notes
1. Normal Wages are considered as basic wages
Solution 8.
Calculation of total earnings:
= Time taken × Time rate + 50% (Time Allowed – Time Taken) × Time rate
= 6 hrs. × `60 + 1/2 × (2 hrs. × `60) or `360 + `60 = `420
Of his total earnings, `360 is on account of the time worked and `60 is on account of his share
of the premium bonus.
Solution 9.
Calculation of total earnings:
=Time taken × Rate per hour + × Time taken × Rate per hour
= 6 hours × `60 + x 6 hours × ` 60 = ` 360 + ` 90 = ` 450
Solution 10.
Total earnings (under 50% Halsey Scheme) = Hours worked x Rate per hour + ½
x time saved x Rate per hour
= 3 hours x ` 30 + ½ x1 hour x `30 = `105
Working Note:
Let T hours be the total time worked in hours by the skilled workers (machine man P), `30
is the rate per hour; standard time is 4 hours per unit and effective hourly earnings rate is
`37.50 then
23 EMPLOYEE COST
Earning (under Rowan plan) = Hours worked x Rate per hr + x
Time taken x Rate per hr
`37.5 T =
Solution 11.
(`)
Wages paid to worker during the year {(` 10,000 +2,000) × 12} 1,44,000
Add: Employer Contribution to:
Provident Fund @ 10% 14,400
E.S.I. Premium @ 4.75% (6.5 – 1.75) 6,840
Bonus at 2 months’ wages (Basic + DA) 24,000
Total 1,89,240
Effective hours per year: 285 days × 8 hours = 2,280 hours
Wage-rate per hour (for costing purpose): `1,89,240/2,280 hours = `83
Solution 12.
(i) Effective working days in a year 300
Less: Leave days on full pay 20
Effective working days 280 days
Total effective working hours (280 days × 8 hours) 2,240
(ii) Total wages paid in a year (`)
Basic pay 1,20,000
D.A. 36,000
Fringe benefits 12,000
1,68,000
(iii) Hourly rate : `1,68,000/2,240 hours `75.00
EMPLOYEE COST 24
Answer 13
(a)
Particulars Nasik Satara
Hours worked 32 hr. 30 hr.
Conversion Costs `5,408 `4,950
Less: Overheads `800 (`25×32 hr.) `750 (`25×30 hr.)
Labour Cost `4,608 `4,200
(i) Finding of Normal wage rate:
Let Wage rate be `R per hour, this is same for both the Nasik and Satara factory. Normal
wage rate can be found out taking total cost of either factory.
Nasik: Rowan Plan
Total Labour Cost = Wages for hours worked + Bonus as per Rowan plan
25 EMPLOYEE COST
SOLUTIONS
CLASS TEST
Solution 1.
Let x be the cost of material and y be the normal rate of wage/hour
Worker A (`) Worker B (`)
Material cost x x
Labour wages 90 y 100 y
Bonus Rowan system Halsey system
Hours saved x 50% x rate
EMPLOYEE COST 26
Solution 2.
(a) Labour turnover rate:
It comprises of computation of labour turnover by using following methods:
(i) Replacement Method:
OR
(iii) Flux Method:
27 EMPLOYEE COST
Answer 3
Working Note:
(i) Average number of workers on roll (for the quarter):
Employee Turnover rate using Replacement method
No. of replacements
= Average number of workers on roll ×100
8 72
Or, =
100 Average number of workers on roll
72×100
Or, Average number of workers on roll = = 900
8
16%
Using Flux method = x 4 = 64%
1
8%
Using Replacement method = x 4 = 32%
1
5%
Using Separation method = x 4 = 20%
1
EMPLOYEE COST 28
OVERHEADS :
04 ABSORPTION COSTING
SOLUTIONS
HOMEWORK SECTION
Solution 1.
Computation of Over/Under-absorbed overhead expenses during the month of August
(`) (`)
Total expenses incurred in the month of August: 80,000
Less: The amount paid according to labour court award 15,000
(Assumed to be non-recurring)
Expenses of previous year 5000 (20,000)
Net overhead expenses incurred for the month 60,000
Overhead recovered for 10,000 hours @ ` 5 per hour (50,000)
Under-absorbed overheads 10,000
60% of under-absorbed overhead was due to defective planning, it will be charged to costing
profit & loss account.
40% of under-absorbed overhead i.e. `4,000 may be distributed over Finished Goods and Cost
of Sales using supplementary overhead rate:
Supplementary rate =
= = `0.10
Amount of under-absorbed overheads charged to finished goods
= 10,000 units × `0.10 = `1,000
Amount of under-absorbed overheads charged to cost of sales
= 30,000 units × `0.10 = `3,000
Solution 2.
(i) Amount of under-absorption of production overheads during the year 20x1-x2
(`)
Total production overheads actually incurred 6,00,000
during the year 2019-20
Less : ‘Written off’ obsolete stores ` 45,000
Wages paid for strike period ` 30,000 75,000
`44,00,000
*Budgeted Machine hour rate (Blanket rate) = = ` 20per hour
2,20,000 hours
(ii) Accounting treatment of over absorbed production overheads: As, one fourth of the
over absorbed overheads were due to defective production policies, this being abnormal,
hence should be transferred to Costing Profit and Loss Account.
Amount to be transferred to Costing Profit and Loss Account = (11,700 × ¼) = ` 2,925
Balance of over absorbed production overheads should be distributed over Works in
progress, finished goods and Cost of sales by applying supplementary rate*.
Amount to be distributed = (11,700 × ¾) =` 8,775
`8,775
Supplementary rate = = 0.2659per unit
33,000 units
(iii) Apportionment of under absorbed production overheads over WIP, Finished goods
and Cost of sales:
Equivalent completed Amount (`)
units
Work-in-Progress (18,000 units × 50% × ` 0.2659) 9,000 2,393
Finished goods (2,400 units × ` 0.2659) 2,400 638
Cost of sales (21,600 units × ` 0.2659) 21,600 5,744
Total 33,000 8,775
Solution 6.
Summary of Overhead Distribution
Departments X (`) Y (`) A (`) B (`)
Amount as given above 2,00,000 1,50,000 3,00,000 3,20,000
Expenses of service dept.-X is (2,00,000) 50,000 80,000 70,000
apportioned among other departments-
Y, A and B in the ratio (5:8:7)
2,00,000 3,80,000 3,90,000
Expenses of Dept.-Y apportioned - (2,00,000) 80,000 1,20,000
between department A and B in the
ratio (2:3)
Total Nil Nil 4,60,000 5,10,000
Solution 7.
The total expenses of the two service departments will be determined as follows: Let B stand
for Boiler House expenses and P for Pump Room expenses.
Then
B = 3,00,000 + 0.50 P
P = 60,000 + 0.05 B
Substituting the value of B,
P = 60,000 + 0.05 (3,00,000 + 0.5 P)
Solution 8.
(i) Computation of percentage recovery rates of factory overheads and administrative
overheads.
Let the factory overhead recovery rate as percentage of direct wages be F and
administrative overheads recovery rate as percentage of factory cost be A.
Factory Cost of Jobs:
Direct materials + Direct wages + Factory overhead
For Job 101 = ` 54,000 +` 42,000 + ` 42,000F
For Job 102 = ` 37,500 +` 30,000 + ` 30,000F
Total Cost of Jobs:
Factory cost + Administrative overhead
For Job 101 = (` 96,000 + ` 42,000F) + (` 96,000+ ` 42,000F) A = ` 1,51,500*
For Job-102 = (` 67,500 + ` 30,000F) + (` 67,500+ ` 30,000F) A = ` 1,06,875**
The value of F & A can be found using following equations
96,000 + 42,000F + 96,000A + 42,000AF = 1,51,500 …………eqn (i)
67,500 + 30,000F + 67,500A + 30,000AF = 1,06,875 …………eqn (ii)
Multiply equation (i) by 5 and equation (ii) by 7
Working note:
Solution 9.
Statement of Profit or Loss on Various Products during the year ended March 31, 2020.
Total (`) Products
A (`) B (`) C (`) D (`)
Sales 1,50,00,000 30,00,000 50,00,000 25,00,000 45,00,000
Variable costs:
Cost of goods sold 1,08,50,000 20,00,000 45,00,000 21,00,000 22,50,000
Commissions 4% of sales 6,00,000 1,20,000 2,00,000 1,00,000 1,80,000
Packing wages & 10,00,000 2,00,000 3,00,000 1,50,000 3,50,000
materials @ ` 2 per
parcel
Stationery @ ` 1 per 4,00,000 80,000 1,40,000 60,000 1,20,000
invoice
Total variable costs 1,28,50,000 24,00,000 51,40,000 24,10,000 29,00,000
Contribution 21,50,000 6,00,000 (1,40,000) 90,000 16,00,000
(Sales – variable cost)
Fixed Costs:
Rent & Insurance 3,00,000 75,000 60,000 1,20,000 45,000
(5:4:8:3)
Depreciation (4:6:3:7) 1,00,000 20,000 30,000 15,000 35,000
Salesmen’s salaries 6,00,000 1,20,000 2,00,000 1,00,000 1,80,000
& expenses (6:10:5:9)
Administrative wages & 5,00,000 1,00,000 1,75,000 75,000 1,50,000
salaries (4:7:3:6)
Total Fixed costs 15,00,000 3,15,000 4,65,000 3,10,000 4,10,000
Solution 10.
(i) Computation of overhead absorption rate
(as per the current policy of the company)
Department Budgeted factory Budgeted direct
Overheads wages
(`) (`)
Machinery 3,60,000 80,000
Assembly 1,40,000 3,50,000
Packing 1,25,000 70,000
Total 6,25,000 5,00,000
(ii) Methods available for absorbing factory overheads and their overhead recovery rates
in different departments
1. Machining Department
In the machining department, the use of machine time is the predominant factor
of production. Hence machine hour rate should be used to recover overheads in
this department. The overhead recovery rate based on machine hours has been
calculated as under:
2. Assembly Department
In this department direct labour hours is the main factor of production. Hence direct
labour hour rate method should be used to recover overheads in this department.
The overheads recovery rate in this case is:
3. Packing Department
Labour is the most important factor of production in this department. Hence direct
labour hour rate method should be used to recover overheads in this department.
The overhead recovery rate in this case comes to:
Budgeted factory overhead
(iii) Selling Price of Job CW-7083 [based on the overhead application rates calculated in
(ii) above]
(`)
Direct materials 2,100.00
Direct wages 660.00
Overheads (Refer to Working note) 1,078.00
Factory cost 3,838.00
Add: Mark up (30% of ` 3,838) 1,151.40
Selling price 4,989.40
(2) (a) Company Should accept the offer as it is above its targeted sales price of
` 128.45 per toy.
(b) Company Should accept the offer as it is above its targeted sales price of
` 128.45 per toy.
` 10,35,000
*Budgeted Machine hour rate (Blanket rate) = = ` 11.50 per hour
90,000
` 1,56,000
*Supplementary rate = = ` 5.20 per unit
30,000 units
Solution 2.
(1) Overheads distribution Sheet
Item Basis Total Production Service
Amount Departments Departments
(`) A (`) B (`) X (`) Y (`)
Variable overheads Horse Power 8,40,000 2,40,000 3,00,000 1,80,000 1,20,000
(` 12.60 lakhs - hours used
` 4.20 lakhs)
Fixed Overheads Horse power 4,20,000 1,20,000 1,50,000 90,000 60,000
for Capacity
production
Total Overheads 12,60,000 3,60,000 4,50,000 2,70,000 1,80,000
Service dept X As per the (2,70,000) 1,35,000 90,000 45,000
allocated to A, B ratio given
&Y 6:4:2
Service dept Y As per the (1,80,000+4 1,80,000 45,000
allocated to A & B ratio of 4:1 5000 =
2,25,000)
Total Overheads of 6,75,000 5,85,000
Production
departments
Solution 4.
Statement Showing Distribution of Overheads of Modern Manufactures Ltd.
Particulars Basis Total Production Departments Service Departments
P₁ P₂ P₃ S₁ S₂
(`) (`) (`) (`) (`) (`)
Direct wages Actual 1,695 - - - 1,500 195
Rent & rates Area 5,000 1,000 1,250 1,500 1,000 250
General lighting Light points 600 100 150 200 100 50
Indirect wages Direct wages 1,939 600 400 600 300 39
Power H.P. 1,500 600 300 500 100 -
Depreciation of Value of 10,000 2,400 3,200 4,000 200 200
machines machines
Sundries Direct wages 9,695 3,000 2,000 3,000 1,500 195
30,429 7,700 7,300 9,800 4,700 929
Working Note:
Overhead cost:
(` 3 × 4 hrs.) + (` 2.02 × 5 hrs.) + (` 5.03 × 3 hrs.)
= ` 12 + ` 10.10 + ` 15.09 = ` 37.19
Solution 5.
Calculation of under/ over- absorption of overhead
Amount (`)
Actual factory overhead expenses incurred 4,46,380
Overheads absorbed (2,93,104 hours × ` 1.25) 3,66,380
Under-absorption of overhead 80,000
1. The use of cost of sales figure, would reduce the profit for the period by ` 35,000
and will increase the value of stock of finished goods and work- in-progress by `
4,000 and ` 1,000 respectively.
2. The balance amount of unabsorbed overheads of ` 40,000 due to factory inefficiency
should be debited to Costing Profit & Loss Account, as this is an abnormal loss.
SOLUTIONS
HOME WORK SECTION
Solution 1.
(i) Statement of cost allocation to each product from each activity
Product
M (`) S (`) T (`) Total (`)
Power (Refer to 40,000 80,000 60,000 1,80,000
working note) (10,000 kWh (20,000 kWh (15,000 kWh
× `4) ×`4) ×`4)
Quality Inspections 1,05,000 75,000 90,000 2,70,000
(Refer to (3,500 (2,500 (3,000
working note) inspections inspections × inspections ×
× `30) ` 30) ` 30)
Working note
Rate per unit of cost driver:
Power (` 2,00,000 / 50,000 kWh) ` 4/kWh
Quality Inspection (` 3,00,000 / 10,000 ` 30 per inspection
inspections)
(iii) Factors management consider in choosing a capacity level to compute the budgeted
fixed overhead cost rate:
- Effect on product costing & capacity management
- Effect on pricing decisions.
- Effect on performance evaluation
- Effect on financial statements
- Regulatory requirements.
- Difficulties in forecasting.
(ii) Computation of rate per unit of the cost allocation base for each of the five activity
areas for April 2020
(`)
Customer purchase order processing (` 40 per order
2,20,000/ 5,500 orders)
Line item ordering 3 per line item order
(` 1,75,560/ 58,520 line items)
Store delivery 50 per delivery
(` 1,95,250/ 3,905 store deliveries)
Cartons dispatched 1 per dispatch
(` 2,09,000/ 2,09,000 dispatches)
Shelf-stocking at customer store (`) 16 Per hour
(` 28,160/ 1,760 hours)
Working note:
Computation of operating cost of each distribution channel:
General Super Drugstore Chemist Shops
Market Chains Chains
(`) (`) (`)
Customer purchase order 15,400 39,600 1,65,000
processing (` 40 × 385 (` 40 × 990 (` 40 ×4125
orders) orders) orders)
Line item ordering 16,170 35,640 1,23,750
(` 3 × 14 x (` 3 × 12 x 990) (` 3 × 10 ×
385) 4125)
Store delivery 16,500 41,250 1,37,500
(` 50 × 330 (` 50 × 825 (` 50 × 2750
deliveries) deliveries) deliveries)
Solution 3.
(i) Traditional Absorption Costing
BABYSOF BABYSOFT BABYSOFT Total
T- Gold - Pearl - Diamond
(a) Production of soaps 4,000 3,000 2,000 9,000
(Units)
(b) Direct labour 30 40 60 -
(minutes)
(c) Direct labour hours 2,000 2,000 2,000 6,000
(a × b)/60 minutes
Overhead rate per direct labour hour:
= Budgeted overheads ÷ Budgeted labour hours
= ` 1,98,000 ÷ 6,000 hours
= ` 33 per direct labour hour
Working note-1
Calculation of Direct material cost
BABYSOFT- BABYSOFT- BABYSOFT-
Gold (`) Pearl (`) Diamond (`)
Essential oils 120.00 165.00 195.00
Machine 5 5 6 -
operations
per unit
Total 20,000 15,000 12,000 47,000
operations
Forklifting rate per gram = ` 58,000 ÷ 9,84,000 grams
= ` 0.06 per gram
Supervising rate per direct = ` 60,000 ÷ 6,000 hours labour hour
= ` 10 per labour hour
Utilities rate per machine = ` 80,000 ÷ 47,000 machine operations
= ` 1.70 per machine operations
(iii) Comments: The difference in the total costs under the two systems is due to the
differences in the overheads borne by each of the products. The Activity Based Costs
appear to be more accurate.
Solution 4.
(i) Statement of Operating income and Operating income as a percentage of revenues
for each product line
(When support costs are allocated to product lines on the basis of cost of goods sold of
each product)
Soft Drinks Fresh Packaged Total
(`) Produce Foods (`)
(`) (`)
Revenues: (A) 39,67,500 1,05,03,000 60,49,500 2,05,20,000
Cost of Goods sold (COGS): (B) 30,00,000 75,00,000 45,00,000 1,50,00,000
Support cost (30% of COGS): 9,00,000 22,50,000 13,50,000 45,00,000
(C)
(Refer working notes)
Total cost: (D) = {(B) + (C)} 39,00,000 97,50,000 58,50,000 1,95,00,000
Operating income: E= 67,500 7,53,000 1,99,500 10,20,000
{(A)-(D)}
Operating income as a 1.70% 7.17% 3.30% 4.97%
percentage of revenues: (E/A)
× 100)
Working notes:
1. Total support cost:
(`)
Bottles returns 60,000
Ordering 7,80,000
(ii) Statement of Operating income and Operating income as a percentage of revenues for
each product line
(When support costs are allocated to product lines using an activity- based costing
system)
Soft drinks Fresh Packaged Total
Produce Food
(`) (`) (`) (`)
Revenues: (A) 39,67,500 1,05,03,000 60,49,500 2,05,20,000
Cost & Goods sold 30,00,000 75,00,000 45,00,000 1,50,00,000
Bottle return costs 60,000 0 0 60,000
Ordering cost* (360:840:360) 1,80,000 4,20,000 1,80,000 7,80,000
Delivery cost* (300:2190:660) 1,20,000 8,76,000 2,64,000 12,60,000
Answer 5
(i) Statement of cost allocation to each product from each activity
Product
P (`) Q (`) R (`) Total (`)
Direct Labour 1,00,000 80,000 60,000 2,40,000
hours (Refer to (10,000 Labour (8,000 Labour (6,000 Labour
working note) hours × `10) hours × `10) hours × `10)
Production 60,000 54,000 48,000 1,62,000
runs (Refer to (200 Production (180 Production (160 Production
working note) runs × ` 300) runs × ` 300) runs × ` 300)
Quality 90,000 75,000 45,000 2,10,000
Inspections (3,000 (2,500 (1,500
(Refer to Inspections × Inspections × Inspections ×
working note) `30) ` 30) ` 30)
Working note:
Rate per unit of cost driver
Direct Labour hours (` 3,00,000/30,000 ` 10 per Labour hour
Labour hours)
Production runs (` 1,80,000/600 ` 300 per Production run
Production runs)
Quality Inspection (` 2,40,000/8,000 ` 30 per Inspection
Inspections)
(iii) Cost sheet and Computation of Sales value per quarter of product ‘S’ using ABC
system
Particulars (`)
1500 units of product ‘S’ to be delivered per quarter
Initial design cost per quarter (` 30,000 / 8 quarters) 3,750
Direct Material Cost 18,000
Direct Labour Cost (1,500 Labour hours x ` 10) 15,000
Direct Costs (A) 36,750
Set up Cost (15 Production runs × ` 300) 4,500
Inspection Cost (250 Inspections × ` 30) 7,500
Indirect Costs (B) 12,000
Total Cost (A + B) 48,750
Add: Mark-up (20% on cost) 9,750
Sale Value 58,500
Selling Price per unit ‘S’ (` 58,500/1500 units) 39
SOLUTIONS
HOMEWORK SECTION
Solution 1.
No. of bags manufactured = 1,000 units
Cost sheet for the month of September 2019
Particulars Total Cost Cost per unit
(`) (`)
1. Direct materials consumed:
- Leather sheets 3,20,000 320.00
- Cotton cloths 15,000 15.00
Add: Freight paid on purchase 8,500 8.50
2. Directwages (`80 × 2,000 hours) 1,60,000 160.00
3. Direct expenses (` 10 × 2,000 hours) 20,000 20.00
4. Prime Cost 5,23,500 523.50
5. Factory Overheads: Depreciation on machines
{(`22,00,000×90%)÷120 months} 16,500 16.50
Apportion cost of factory rent 98,000 98.00
6. Works/ Factory Cost 6,38,000 638.00
7. Less: Realisable value of cuttings (‘150×35 kg.) (5,250) (5.25)
8. Cost of Production 6,32,750 632.75
9. Add: Opening stock of bags 0
10. Less: Closing stock of bags (100 bags × ‘632.75) (63,275)
11. Cost of Goods Sold 5,69,475 5,69,475
12. Add: Administrative Overheads: 45,000
- Staff salary 45.00
- Apportioned rent for administrative office 12,000 12.00
13. Add: Selling and Distribution Overheads
- Staff salary 72,000 80.00
- Apportioned rent for sales office 10,000 11.11
- Freight paid on delivery of bags 18,000 20.00
14. Cost of Sales (18+19+20) 7,26,475 800.86
Apportionment of Factory rent: To factory building {(`1,20,000 ÷ 2400 sq.feet) × 1,960 sq.
feet} = ` 98,000
To administrative office {(`1,20,000 ÷ 2400 sq.feet) × 240 sq. feet} = `12,000
To sale office {(`1,20,000 ÷ 2400 sq.feet) × 200 sq. feet} = `10,000
COST SHEET 60
Solution 2.
(i) Cost Sheet of M/s Areeba Pvt. Ltd. for the year 2019.
Normal Capacity: 36,000 units p.a
3 Months 4,500 Units 9 Months 21,600 units
Amount(`) Cost perunit Amount(`) Cost perunit
(`) (`)
Direct material 1,80,000 8,64,000
Less: Scrap (22,500) (1,08,000)
Materials consumed 1,57,500 35 7,56,000 35
Direct Wages 1,44,000 32 6,48,000 30
Prime Cost 3,01,500 67 14,04,000 65
Factory overheads:
- Fixed 90,000 2,70,000
- Variable 45,000 2,16,000
- Semi variable 27,000 36 1,51,200 29.50
Works Cost 4,63,500 103 20,41,200 94.50
Add: Administrative 1,29,600 28.80 3,88,800 18
overheads
Cost of Production 5,93,100 131.80 24,30,000 112.5
Selling Overheads 36,000 8 1,72,800 8
Cost of Sales 6,29,100 139.80 26,02,800 120.5
Working Notes:
1. Calculation of Costs
Particulars 4,500 units Amount (`) 21,600 units Amount (`)
Material 1,80,000 (` 40 × 4,500 units) 8,64,000 (` 40 × 21,600 units)
Wages 1,44,000 (Max. of ` 30 × 4,500units 6,48,000 (21600 Units × 30)
= ` 1,35,000 and ` 48,000× 3 months
= ` 1,44,000)
Variable 45,000 (` 10 × 4,500 units) 2,16,000 (` 10 × 21,600 units)
Cost
Semi-
`1,08,000 `1,08,000
variable 27,000 x 3 months 1,51,200 x 9 months
12 months 12 months
Cost
+ 46,800 (for 20 % increase)
+ 23,400 (for 10% increase)
Selling 36,000 (` 8 × 4,500 units) 1,72,800(` 8 × 21,600 units)
Overhead
61 COST SHEET
Notes:
1. Alternatively scrap of raw material can also be reduced from Work cost.
2. Administrative overhead may be treated alternatively as a part of general overhead.
In that case, Works Cost as well as Cost of Production will be same i.e. ` 4,63,500 and Cost of
Sales will remain same as ` 6,29,100.
(ii) Calculation of Selling price for nine months period
Particulars Amount (`)
Total Cost of sales ` (6,29,100 +26,02,800) 32,31,900
Add: Desired profit 8,76,600
Total sales value 41,08,500
Less: Sales value realised in first three months (`145 × 4,500 units) (6,52,500)
Sales Value to be realised in next nine months 34,56,000
No. of units to be sold in next nine months 21,600
Selling price per unit (` 34,56,000 ÷ 21,600 units) 160
Solution 3.
Cost Sheet
(for the quarter ending 30 September 2018)
Amount (`)
(i) Raw materials consumed
Opening stock of raw materials 2,45,600
Add: Purchase of materials 12,22,650*
Less: Closing stock of raw materials (2,08,000)
Raw materials consumed 12,60,250
Add: Direct wages (1,47,000×175%) 2,57,250
Direct Expenses 1,80,000
(ii) Prime cost 16,97,500
Add: Factory overheads (2,57,250/175%) 1,47,000
Gross Factory cost 18,44,500
Add: Opening work-in-process 1,70,800
Less: Closing work-in-process (1,90,000)
(iii) Factory cost 18,25,300
Add: Administration overheads (10% of factory overheads) 14,700
Add: Opening stock of finished goods 3,10,000
Less: Closing stock of finished goods (2,75,000)
(iv) Cost of goods sold 18,75,000
Add: Selling & distribution overheads 60,000
Cost of sales 19,35,000
(v) Net Profit 2,75,000
Sales 22,10,000
COST SHEET 62
*(18,75,000 + 2,75,000 – 3,10,000– (1,47,000× 10%)+ 1,90,000–1,70,800– (2,57,250×
100/175%) - 1,80,000 – 2,57,250 + 2,08,000 – 2,45,600)= 12,22,650
Working notes :
Purchase of raw materials = Raw material consumed + Closing stock - opening stock of raw
material
Raw material consumed = Prime cost - Direct wages - Direct expenses Factory Overheads =
2,57,250*100/175
Prime cost = Factory cost + Closing WIP – Opening WIP – Factory overheads
Factory Cost = Cost of Production goods sold + Closing stock of Finished goods – Opening stock
of finished goods – Administrative overheads
Net Profit = Sales - Cost of sales
Alternative solution
Cost Sheet
(for the quarter ending 30 September 2018)
Amount (`)
(i) Raw materials consumed
Opening stock of raw materials 2,45,600
Add: Purchase of materials 12,37,350*
Less: Closing stock of raw materials (2,08,000)
Raw Material consumed 12,74,950
Add: Direct wages (1,47,000×175% 2,57,250
Direct Expenses 1,80,000
(ii) Prime cost 17,12,,200
Add: Factory overheads (2,57,250/175%) 1,47,000
Gross Factory cost 18,59,200
Add: Opening work-in-process 1,70,800
Less: Closing work-in-process (1,90,000)
(iii) Factory cost/works cost/cost of production 18,40,000
Add: Opening stock of finished goods 3,10,000
Less: Closing stock of finished goods (2,75,000)
(iv) Cost of goods sold 18,75,000
Add: Administration overheads (10% of factory overheads) 14,700
Add: Selling & distribution overheads 60,000
Cost of sales 19,49,700
(v) Net Profit 2,60,300
Sales 22,10,000
*(18,75,000 + 2,75,000 – 3,10,000+ 1,90,000–1,70,800– 1,47,500 - 1,80,000 – 2,57,250 +
2,08,000 – 2,45,600)= 12,37,350
63 COST SHEET
Working notes
Purchase of raw materials = Raw material consumed + Closing stock - opening stock of raw
material
Raw material consumed = Prime cost - Direct wages - Direct expenses
Factory Overheads = 257250*100/175
Prime cost = Factory cost + Closing WIP – Opening WIP – Factory overheads
Factory Cost = Cost of Production goods sold + Closing stock of Finished goods – Opening stock
of finished goods
Net Profit = Sales - Cost of sales.
Answer 4
Cost Sheet
Particulars Units Amount (`)
Material
Opening stock 1,000 90,00,000
Add: Purchases 49,000 44,10,00,000
Less: Closing stock (1,750) (1,57,50,000)
48,250 43,42,50,000
Less: Normal wastage of materials realized @ ` 5,400 per (250) (13,50,000)
unit
Material consumed 43,29,00,000
Direct employee's wages and allowances 6,88,50,000
Direct expenses- Royalty paid for production 3,64,50,000
Prime cost 48,000 53,82,00,000
Factory overheads - Consumable stores, depreciation etc. 3,42,00,000
Gross Works Cost 48,000 57,24,00,000
Add: Opening WIP 2,000 1,75,50,000
Less: Closing WIP (1,000) (94,50,000)
Factory/Works Cost 49,000 58,05,00,000
Administration Overheads related to production 3,15,00,000
R&D expenses and Quality control cost 2,10,60,000
Add: Primary packaging cost @ ` 1,440 per unit 7,05,60,000
Cost of production 49,000 70,36,20,000
Selling expenses 4,84,30,800
Cost of maintaining website for online sale 60,75,000
Secondary packaging cost @ ` 225 per unit 49,000 1,10,25,000
Cost of sales 76,91,50,800
Add: Profit @ 20% on sales or 25% of cost 19,22,87,700
Sales value 96,14,38,500
COST SHEET 64
Answer 5
Cost Sheet for the Month of April 2020
Particulars (`)
Opening stock of Raw Material 20,000
Add: Purchases [Refer Working Note-2] 1,65,000
Less: Closing stock of Raw Material (25,000)
Raw material consumed 1,60,000
Add: Direct labour cost 1,20,000
Prime cost 2,80,000
Add: Factory overheads 1,00,000
Gross Works cost 3,80,000
Add: Opening work-in-progress 20,000
Less: Closing work-in-progress (30,000)
Works Cost 3,70,000
Cost of Production 3,70,000
Add: Opening stock of finished goods 50,000
Less: Closing stock of finished goods (60,000)
Cost of goods sold 3,60,000
Add: General and administration expenses* 18,000
Add: Selling expenses 22,000
Cost of sales 4,00,000
Profit {Balancing figure (` 5,00,000 – ` 4,00,000)} 1,00,000
Sales 5,00,000
*General and administration expenses have been assumed as not relating to the production
activity.
Working Note:
1. Computation of the raw material consumed
Particulars (`)
Cost of Sales 4,00,000
Less: General and administration expenses (18,000)
Less: Selling expenses (22,000)
Cost of goods sold 3,60,000
Add: Closing stock of finished goods 60,000
Less: Opening stock of finished goods (50,000)
Cost of production/Gross works cost 3,70,000
Add: Closing stock of work-in-progress 30,000
Less: Opening stock of work-in-progress (20,000)
Works cost 3,80,000
65 COST SHEET
Less: Direct labour (1,20,000)
Raw material consumed 1,60,000
COST SHEET 66
SOLUTIONS
CLASS TEST
Solution 1.
1. Calculation of Sales Quantity:
Particular Units
Production units 1,00,000
Less: Defectives (4%×1,00,000 units) 4,000
Less: Closing stock of finished goods 5,000
No. of units sold 91,000
67 COST SHEET
5. Calculation of Prime Cost
Particular Amount (`)
Cost of Gross Factory Cost 83,50,000
Less: Consumable stores & spares (3,50,000)
Less: Lease rental of production assets (2,00,000)
Prime Cost 78,00,000
6. Calculation of Cost of Materials Consumed & Labour cost Let Cost of Material Consumed
= M and Labour cost = 0.5M Prime Cost = Cost of Material Consumed + Labour Cost
78,00,000 = M + 0.5M
M = 52,00,000
Therefore, Cost of Material Consumed = ` 52,00,000 and Labour Cost = ` 26,00,000
(i) Calculation of Value of Materials Purchased
Particular Amount (`)
Cost of Material Consumed 52,00,000
Add: Value of Closing stock 2,92,000
Less: Value of Opening stock (2,42,000)
Value of Materials Purchased 52,50,000
Cost Sheet
Sl. Particulars Total Cost (`)
1. Direct materials consumed:
Opening Stock of Raw Material 2,42,000
Add: Additions/ Purchases [balancing figure as per 52,50,000
requirement (i)]
Less: Closing stock of Raw Material (2,92,000)
Material Consumed 52,00,000
2. Direct employee (labour) cost 26,00,000
3. Prime Cost (1+2) 78,00,000
4. Add: Works/ Factory Overheads
Consumable stores and spares 3,50,000
Lease rent of production asset 2,00,000
5. Gross Works Cost (3+4) 83,50,000
6. Add: Opening Work in Process 2,00,000
7. Less: Closing Work in Process (5,00,000)
8. Works/ Factory Cost (5+6-7) 80,50,000
9. Add: Quality Control Cost 2,00,000
10. Add: Research and Development Cost 2,50,000
11. Less: Credit for Recoveries/Scrap/By-Products/misc. (2,44,000)
income
COST SHEET 68
12. Cost of Production (8+9+10-11) 82,56,000
13. Add: Opening stock of finished goods -
14. Less: Closing stock of finished goods (5000 Units) (4,30,000)
15. Cost of Goods Sold (12+13-14) 78,26,000
16. Add: Administrative Overheads (General) 2,24,000
17. Add: Secondary packing 1,82,000
18. Add: Selling Overheads& Distribution Overheads 4,13,000
19. Cost of Sales (15+16+17+18) 86,45,000
20. Profit 13,65,000
21. Sales 91,000 units@ ` 110 per unit 1,00,10,000
Solution 2.
Cost sheet for the year ended 31st March, 2018.
Units produced - 14,000 units
Units sold - 14,153 units
Particulars Amount (`)
Raw materials purchased 42,25,000
Add: Freight Inward 1,00,000
Add: Opening value of raw materials 2,28,000
Less: Closing value of raw materials (3,05,000)
42,48,000
Less: Sale of scrap of material 8,000
Materials consumed 42,40,000
Direct Wages (12,56,000 + 1,50,000) 14,06,000
Prime Cost 56,46,000
Factory overheads (20% of ` Prime Cost) 11,29,200
Add: Opening value of W-I-P 1,92,500
Less: Closing value of W-I-P (1,40,700)
Factory Cost 68,27,000
Add: Administrative overheads 1,73,000
Cost of Production 70,00,000
Add: Value of opening finished stock 6,08,500
Less: Value of closing finished stock
[` 500(70,00,000/14,000) × 1,064)
(1,217+ 14,000 – 14,153 = 1,064 units) (5,32,000)
Cost of Goods Sold 70,76,500
Distribution expenses (` 16 × 14,153 units) 2,26,448
Cost of Sales 73,02,948
Profit (Balancing figure) 14,43,606
Sales (` 618 × 14,153 units) 87,46,554
69 COST SHEET
07 COST ACCOUNTING SYSTEM
SOLUTIONS
HOMEWORK SECTION
Solution 1.
Journal entries are as follows:
Stores Ledger Control A/c……………………………… Dr. 2,00,000
To Payables (Creditors)/ Bank A/c 2,00,000
(Materials purchased)
Work-in-Process Control A/c…………………………… Dr. 1,50,000
To Stores Ledger Control A/c 1,50,000
(Materials issued to production)
Wages Control A/c………………………………………. Dr. 1,20,000
To Bank A/c 1,20,000
(Wages paid)
Factory Overhead Control A/c…………………………. Dr. 36,000
To Wages Control A/c 36,000
(30% of wages paid being indirect charged to overhead)
Work-in-Process Control A/c…………………………… Dr. 84,000
To Wages Control A/c 84,000
(Direct wages charged to production)
Factory Overhead Control A/c………………………… Dr. 84,000
To Bank A/c 84,000
(Manufacturing overhead incurred)
Work-in-Process Control A/c…………………………… Dr. 92,000
To Factory Overhead Control A/c 92,000
(Manufacturing overhead charged to production)
Selling & Distribution Overhead Control A/c………. Dr. 20,000
To Bank A/c 20,000
(Selling and distribution costs incurred)
Finished Goods Control A/c……………………………. Dr. 2,00,000
To Work-in-Process Control A/c 2,00,000
(Cost of finished goods)
Cost of Sales A/c………………………………………… Dr. 2,20,000
To Finished Goods Control A/c 2,00,000
Solution 2.
Stores Ledger Control A/c
(`) (`)
To Balance b/d 15,000 By Work-in-process 80,000
Control A/c (Issued to
WIP)
To Cost Ledger Control A/c 80,000 By Overhead Control A/c 10,000
(Purchases) (Issued for repairs)
To Work-in-process Control 40,000 By Cost Ledger Control 5,000
A/c (Return from WIP) A/c (Sold at cost)
By Overheads Control 3,000
A/c* (Shortages)
By Balance c/d 37,000
1,35,000 1,35,000
* Assumed normal
Wages Control A/c
(`) (`)
To Cost Ledger Control A/c 35,000 By Work-in-process 30,000
Control A/c
By Overhead Control A/c 5,000
35,000 35,000
Solution 3.
(i) Statement of Profit as per Financial records
(for the year ended March 31, 20X8)
(`) (`)
To Opening stock of Finished Goods 53,125 By Sales 22,80,000
To Work-in-process 46,000 By Closing stock of finished
Goods 45,650
To Raw materials consumed 8,40,000 By Work-in-Process 41,200
To Direct labour 6,10,000 By Rent received 46,000
To Factory overheads 4,22,000 By Interest received 38,000
To Administration overheads 1,98,000 To Selling & distribution
overheads 72,000
To Dividend paid 1,22,000
To Bad debts 18,000 To Profit 69,725
24,50,850 24,50,850
Working notes:
1. Number of units produced Units
Sales 12,615
Add: Closing stock 415
Total 13,030
Less: Opening stock (625)
Number of units produced 12,405
Working:
(`) (`)
To General Ledger 1,36,350 By Work-in-progress A/c 1,36,350
Adjustment A/c
1,36,350 1,36,350
Solution 5.
Memorandum Reconciliation Accounts
Dr. Cr.
(Rs.) (Rs.)
To Net Loss as per Costing By Administration overheads
books 3,47,000 over recovered in cost
accounts 60,000
By Interest on investment not
included in Cost Accounts 96,000
To Factory overheads under By Transfer fees in Financial
absorbed in Cost Accounts 40,000 books 24,000
To Depreciation under 50,000 By Stores adjustment
charged in Cost Accounts (Credit in financial books) 14,000
To Income- Tax not provided By Dividend received in
in Cost Accounts 54,000 financial books 32,000
To Interest on Loan Funds 2,45,000 By Net loss as per Financial
in Financial Accounts books 5,10,00
0
7,36,000 7,36,00
0
Solution 7.
Stores Ledger Control A/c
Particulars (`) Particulars (`)
To Balance b/d 1,08,000 By Work in Process A/c 5,76,000
To General LedgerAdjustment A/c 5,76,000 By Overhead Control A/c 72,000
To Work in Process A/c 2,88,000 By Overhead Control A/c
(Deficiency) 21,600*
By Balance c/d 3,02,400
9,72,000 9,72,000
*Deficiency assumed as normal (alternatively can be treated as abnormal loss)
Solution 8.
Materials Control A/c
(`) (`)
To Balance b/d 32,000 By Work-in-process control 53,000
Cost Ledger Control A/c A/c
To Payables (Creditors) A/c 92,000 By Balance c/d 71,000
(Purchases)
1,24,000 1,24,000
Solution 1.
(a) Stores Ledger Control Account
(`) (`)
To Balance b/d 25,000 By Work in Process Control A/c 30,000
” Creditors/ Bank A/c 75,000 ” Production OH Control A/c 4,000
” Balance c/d 66,000
1,00,000 1,00,000
Notes:
(1) Materials transferred between batches will not affect the Control Accounts.
(2) Non-production time of direct workers is a production overhead and therefore will not
be charged to work-in-Process control A/c.
(3) Production overheads absorbed in work-in-Process Control A/c equals to ` 30,000 (150%
of ` 20,000).
Solution 2.
Profit and Loss Account
(As per financial records)
(`) (`)
To Direct Material 50,00,000 By Sales (1,20,000 units) 1,20,00,000
To Direct Wages 30,00,000 By Closing Stock
To Factory Overheads 16,00,000 Work-in-process 2,40,000
To Gross Profit c/d 29,60,000 Finished Goods (4,000 3,20,000
units)
1,25,60,000 1,25,60,000
To General 7,00,000 By Gross Profit b/d 29,60,000
Administrative
Overheads
To Selling and Dist. OH 9,60,000 By Dividend received 1,00,000
To Bad debts 80,000 By Interest received 20,000
To Preliminary Expenses 40,000
written off
To Legal Charges 10,000
To Net Profit 12,90,000
30,80,000 30,80,000
Statement of Cost and Profit
(As per Cost Records)
Total (`)
Direct Material 56,00,000
Direct Wages 30,00,000
Prime Cost 86,00,000
Factory Overhead (20% of `86,00,000) 17,20,000
1,03,20,000
Less: Closing Stock (WIP) (2,40,000)
Works Cost or Cost of production (1,24,000 units) 1,00,80,000
Less: Finished Goods (4,000 units @ `81.29) (3,25,160)
Cost of goods sold (1,20,000 units) 97,54,840
Administrative overhead (1,20,000 units @ ` 6 p.u.) 7,20,000
Selling and Distribution Overhead (1,20,000 @ ` 8 p.u.) 9,60,000
Cost of Sales 1,14,34,840
Net profit (Balancing figure) 5,65,160
Sales Revenue 1,20,00,000
Solution 3.
(i) Costing Profit and Loss Account for the year ended 31st March 2019:
Particulars Amount (`) Particulars Amount (`)
Material consumed 14,16,000 Sales (30,000 units) 30,00,000
Direct wages 7,42,000
Prime Cost 21,58,000
Works overheads
(20% of Prime cost) 4,31,600
25,89,600
Less: Work in progress (54,000)
Factory cost 25,35,600
Administration overheads
(`5 × 32,000 units) 1,60,000
Cost of production 26,95,600
Less: Finished stock (1,68,475)
Cost of goods sold 25,27,125
Selling and d i s t r i b u t i o n 1,80,000
overheads (`6 × 30,000 unit)
Cost of sales 27,07,125
Profit (balancing figure) 2,92,875
30,00,000 30,00,000
Solution 4.
Journal entries are as follows:
Dr. Cr.
(`) (`)
(i) Stores Ledger Control A/c................... Dr. 27,000
To Cost Ledger Control A/c 27,000
(ii) Work-in-Process Control A/c................... Dr. 6,000
To Manufacturing Overhead Control A/c 6,000
(iii) Cost of Sales A/c……………………………… Dr. 4,000
To Selling & Dist. Overhead Control A/c 4,000
(iv) (1) Wage Control A/c…………………… Dr. 8,000
To Cost Ledger Control A/c 8,000
(2) Manufacturing Overhead Control A/c……… Dr. 8,000
To Wages Control A/c 8,000
OR
Manufacturing Overhead Control A/c……………. Dr. 8,000
8,000
(v) Stores Ledger Control A/c ……………………… Dr. 9,000
To Work-in-Process Control A/c 9,000
*Cost Ledger Control A/c is also known as General Ledger Control A/c
SOLUTIONS
HOMEWORK SECTION
Solution 1.
2DS
Economic Batch Quantity (EBQ)=
C
2×19,00,000×`5,200
=
`1.5
= 1,14,775 bottles
Solution 3.
Statement of Cost per Unit No. of units produced: 10,000 units
Particulars Cost per Amount
unit (`) (`)
Raw Materials Consumed 40.00 4,00,000
Direct Wages 24.00 2,40,000
Prime cost 64.00 6,40,000
Add: Manufacturing Overheads (3,200 hours × ` 40) 12.80 1,28,000
Works cost 76.80 7,68,000
Add: Office Overheads (10% of Works Cost) 7.68 76,800
Cost of goods sold 84.48 8,44,800
Add: Selling Overheads (10,000 units × ` 20) 20.00 2,00,000
Cost of sales / Total cost 104.48 10,44,800
Add: Profit (Bal Figure) 15.52 1,55,200
Sales 120.00 12,00,000
Solution 1.
Statement of Cost and Selling price for 2,000 units of output
Particulars Cost per unit Total Cost
(`) (`)
Direct Materials 7.50 15,000
Direct Labour 3.00 6,000
Prime cost 10.50 21,000
Add: Factory Overheads (Refer working note-2) 17.50 35,000
Total cost 28.00 56,000
Add: Profit (20% of Sales is equivalent to 25% of Cost) 7.00 14,000
Sales 35.00 70,000
Working Notes:
(1) Direct Material and Direct Labour cost is varying directly in proportion to units produced
and shall remain same per unit of output. Thus, direct material cost is equal to ` 9000
÷ 1200 units = ` 7.50 per unit and labour cost is equal to ` 3600 ÷ 1200 units = ` 3 per
unit.
(2) Calculation of Factory Overheads- An observation of cost related to different output
levels for factory overheads shall reveal 2 things
a. Total cost increases from `31,000 to `34,000 along with increase in output from
1,200 units to 1,800 units but cost per unit is not constant. Thus, it is not a variable
cost. Cost per unit is reducing along with increase in output from ` 25.83 (` 31,000
÷ 1,200 units) to ` 18.89 (`34,000 ÷ 1,800 units)
b. Since the cost is varying with the output, it is also not a fixed cost.
Hence, we can see that the cost is a semi- variable cost and has to be calculated for
2,000 units by analysing its fixed and variable components
Week Number Units Manufactured Factory Overheads
1 1,200 31,000
2 1,600 33,000
Difference 400 2,000
Solution 2.
1. Statement of Cost and Total Sales Amount (`)
Particulars First 3 months Next 9 months Total
Capacity Utilisation (No 120,000x3/12x50% 120,000x9/12x50% 87,000
of units) =15,000 =72,000
Direct Material 13,50,000 64,80,000 78,30,000
Direct Labour 9,00,000 43,20,000 52,20,000
Add: Overheads:
- Fixed (1:3) 7,50,000 22,50,000 30,00,000
- Variable 15,00,000 72,00,000 87,00,000
Semi Variable 5,00,000 (For first 3 21,00,000 (at the 26,00,000
months at the rate rate of ` 28,00,000
of ` 20,00,000) for 9 months)
Total cost 50,00,000 2,23,50,000 2,73,50,000
Add: Profit 20,00,000
Sales 2,93,50,000
Average Selling Price = `2,93,50,000 ÷ 87,000 units = ` 337.356
SOLUTIONS
HOME WORK SECTION
Solution 1.
Determination of quotation price for the job
Cost (`)
Direct Material (10kg × `10) 100
Direct Labour (20hrs × `5) 100
Variable production overhead (20hrs × `2) 40
1,00,000
Fixed Overhead x 20hours
10,000 budgeted hours
Other costs 50
Total costs 490
Net profit is 30% of sales, therefore total costs represent 70% (` 490 × 100) ÷ 70 = ` 700 price
to quote for job.
To check answer is correct; profit achieved will be ` 210 (` 700 - ` 490) = ` 210 ÷ ` 700 = 30%
89 JOB COSTING
SOLUTIONS
CLASS TEST
Solution 1.
Production Statement
For the year ended 31st March, 2018
Amount (`)
Direct materials 9,00,000
Direct wages 7,50,000
Prime Cost 16,50,000
Factory overheads 4,50,000
Cost of Production 21,00,000
Administration overheads 4,20,000
Selling and distribution overheads 5,25,000
Cost of Sales 30,45,000
Profit 6,09,000
Sales value 36,54,000
Calculation of Rates:
`4,50,000
1. Percentage of factory overheads to direct wages = = x 100 = 60%
`7,50,000
`4,20,000
= = x 100 = 20%
`21,00,000
`6,03,750
= = x 100 = 28.75%
`21,00,000
`6,09,000
4. Percentage of profit to sales = = x 100 = 16.67%
`36,54,000
JOB COSTING 90
(ii) Calculation of price for the job received in 2018-19
Amount (`)
Direct materials 2,40,000
Direct wages 1,50,000
Prime Cost 3,90,000
Factory overheads (60% of `1,50,000) 90,000
Cost of Production 4,80,000
Administration overheads (20% of `4,80,000) 96,000
Selling and distribution overheads (28.75% of `4,80,000) 1,38,000
Cost of Sales 7,14,000
Profit (20% of `7,14,000) 1,42,800
Sales value 8,56,800
91 JOB COSTING
9B CONTRACT COSTING
SOLUTIONS
HOME WORK SECTION
Solution 1.
Contract Account
Particulars (`) Particulars (`)
To Material issued 9,48,000 By Machine (Working note 1)** 7,45,270
” Direct Wages 3,49,200
(4,57,200 – 1,08,000) 3,49,200
” Administrative charges 7,20,000
” Supervisor’s salary 3,00,000
(` 50,000 × 9 × 2/3)
” Machine** 7,85,270 ” Works cost 23,57,200
(balancing figure)
31,02,470 31,02,470
” Works cost 23,57,200 ” Value of work certified
(50%×42,00,000)
” Costing P&L A/c 3,32,100 ” Cost of work uncertified
(Notional profit) (Working Note 2) 5,89,300
26,89,300 26,89,300
** Alternatively Depreciation on machine can be shown debit side of Contract Account.
Working notes:
1. Written down value of Machine:
Hence the value of machine after the period of 185 days = ` 7,85,270 – ` 40,000 = `
7,45,270
`23,57,200
Cost of 100% “ “ “ x3=`35,35,800
2
Cost of 50% of the contract which has been certified by the architect is `. 17,67,900.
CONTRACT COSTING 92
Also, the cost of 1/3rd of the contract, which has been completed but not certified by
the architect is `. 5,89,300.
Solution 2.
Contract No. 999 Account for the year ended 31st March, 20X8
Dr. Cr.
Particulars Amount Particulars Amount
(Rs.) (Rs.)
To Work in progress b/d: By Material returned to store 30,000
- Work certified 12,00,000 By Material returned tosuppliers 20,000
- Work uncertified 20,000 By Stock (Material) c/d 30,000
To Stock (Materials) b/d 15,000 By Work in progress c/d:
To Material purchased 1,60,000 - Work certifie 35,00,000
To Material issued 5,00,000 - Work uncertified 40,000
To Wages paid 7,00,000
Less: Opening O/s (10,000)
Add: Closing O/s 20,000 7,10,000
To Drawing and maps* 60,000
To Sundry expenses 15,000
To Electricity charges 25,000
To Plant hire expenses 60,000
To Sub- contract cost 20,000
To Notional profit c/d
(balancing figure) 8,35,000 -
36,20,000 36,20,000
*Assumed that expenses incurred for drawing and maps are used exclusively for this contract
only.
Dr. Cr.
Particulars Amount Particulars Amount
(Rs.) (Rs.)
To Balance c/d
(Rs. 35,00,000 × 75%) 26,25,000 By Balance b/d
(75% of Rs. 12,00,000) 9,00,000
By Bank A/c 17,25,000
26,25,000 26,25,000
93 CONTRACT COSTING
Solution 3.
GVL Ltd.
Contract A/c
(April 1, 2018 to March 31, 2019)
Particulars Amount Particulars Amount
(`) (`)
To Materials Issued 18,24,000 By Plant returned to Stores 2,40,000
(Working Note 1)
To Labour 12,20,000 By Materials at Site 1,20,000
Add: Outstanding 96,000 13,16,000 By W.I.P.
To Plant Purchased 9,00,000 Certified 51,00,000 52,60,000
To Expenses 4,00,000 Uncertified 1,60,000 52,60,000
Less: Prepaid 90,000 3,10,000 By Plant at Site 4,80,000
(Working Note 2)
To Notional Profit 17,50,000
61,00,000 61,00,000
GVL Ltd.
Contract A/c
(April 1, 2018 to September 30, 2019)
(For Computing estimated profit)
Particulars Amount Particulars Amount
(`) (`)
To Materials Issued 50,80,000 By Material at Site 3,00,000
(` 18,24,000 + `32,56,000)
To Labour Cost 28,90,000 By Plant returned to Stores 2,40,000
(`12,20,000 + `96,000 + on 31.03.2019.
`14,24,000* + `1,50,000)
To Plant purchased 9,00,000 By Plant returned to Stores 4,32,000
on 30.09.2019 (Working Note 3)
To Expenses 12,00,000 By Contractee A/c 1,08,50,000
(`3,10,000 + `7,90,000 +
`1,00,000)
To Estimated profit 17,52,000
1,18,22,000 1,18,22,000
* Labour paid in 2019-20: `15,20,000 – `96,000 = `14,24,000
CONTRACT COSTING 94
Working Notes
(`)
1. Value of the Plant returned to Stores on 31.03.2019
Historical Cost of the Plant returned 3,00,000
Less: Depreciation @ 20% of WDV for one year (60,000)
2,40,000
2. Value of Plant at Site 31.03.2019
Historical Cost of Plant at Site (`9,00,000 – `3,00,000) 6,00,000
Less: Depreciation @ 20% on WDV for one year (1,20,000)
4,80,000
3. Value of Plant returned to Stores on 30.09.2019
Value of Plant (WDV) on 31.3.2019 4,80,000
Less: Depreciation @ 20% of WDV for a period of 6 months (48,000)
4,32,000
4. Expenses Paid for the year 2018-19
Total expenses paid 4,00,000
Less: Pre-paid at the end (90,000)
3,10,000
Solution 4.
School Contract Account
Particulars Amount Particulars Amount
(`) (`)
To Plant 2,40,000 By Material returned 47,000
To Hire of plant 77,000 By Plant c/d 1,65,000
To Materials 6,62,000 By Materials c/d 50,000
To Direct wages 9,60,000 By WIP c/d:
Add: Accrued 40,000 10,00,000 Value of work certified 24,00,000
To Wages related costs 1,32,000 Cost of work not certified 1,80,000
To Direct expenses 34,000
To Supervisory staff:
Direct 90,000
Indirect 20,000 1,10,000
To Regional office expenses 50,000
To Head office expenses 30,000
T o Surveyors’ fees 27,000
To Notional profit c/d 4,80,000
28,42,000 28,42,000
95 CONTRACT COSTING
Answer 5
Contract Account
Particulars (`) Particulars (`)
To Material issued 12,55,000 By Machine (Working note 1) 12,30,000
” Wages 28,28,000 ” Material (in hand)
” Foreman’s salary 4,06,500 ” Works cost (balancing 52,45,000
figure)
” Machine 13,00,000
” Supervisor’s salary 1,80,000
(` 40,000 × 9)/2
” Administrative charges 6,82,500
66,52,000 66,52,000
” Works cost 52,45,000 ” Value of work certified 50,00,000
” Costing P&L A/c 10,66,250 ” Value of work certified 50,00,000
Cost of work uncertified 13,11,250
(Working Note 2)
63,11,250 63,11,250
Working notes:
1. Written down value of Machine:
Hence the value of machine after the period of 4.8 months = ` 13,00,000 – ` 70,000
= ` 12,30,000
2. The cost of 2/3rd of the contract is ` 52,45,000
` 52,45,000
∴ Cost of 100% of the contract is x 3 = ` 78,67,500
2
∴ Cost of 50% of the contract which has been certified by the architect is ` 39,33,750.
Also, the cost of 1/3rd of the contract, which has been completed but not certified by
the architect is ` 13,11,250.
CONTRACT COSTING 96
SOLUTIONS
CLASS TEST
Solution 1.
Contract Account as on 31-03-2019
Particulars (`) Particulars (`)
To Materials sent to site 18,75,000 By Material returned to 15,000
Supplier
To Wages paid 9,28,500 By Material sold 11,200
Add: Outstanding 84,800 10,13,300 By Plant transferred to 23,750
other contract
To Plant purchased 3,75,000 By Plant returned to stores 30,000
To Sundry Expenses 33,825 By Plant at site c/d 2,90,175
To Salary of Supervisor 35,000 By Material at site c/d 2,16,800
{1/3rd (`15,000 × 7
month)}
To Costing P & L A/c 1,200 By Works Cost 27,46,400
(’11,200-10,000)
33,33,325 33,33,325
To Works Cost 27,46,400 By Work-in-progress c/d 22,50,000
Work certified
By Work uncertified 6,86,600
To Notional profit (Profit for 1,90,200
the year)
29,36,600 29,36,600
Working Notes:
1. Value of plant transferred to other contract:
` 25,000 less Depreciation for 4 months
= ` 25,000-(` 25,000×15%×4/12) = ` 23,750
2. Value of plant returned to stores:
` 32,000 less Depreciation for 5 months
= ` 32,000-(` 32,000×15%×5/12) = ` 30,000
97 CONTRACT COSTING
3. Value for work uncertified:
The cost of 2/3rd of the contract is `27,46,400
` 27,46,400
∴ Cost of 100% “ “ “ “ x 3 = `41,19,600
2
∴ Cost of 50% of the contract which has been certified by the architect is ` 41,19,600
/2 = ` 20,59,800. Also, the cost of 1/3rd of the contract, which has been completed but
not ertified by the architect is ` (27,46,400- 20,59,800) = ` 6,86,600/-
Solution 2.
In case of escalation clause in a contract, a contractor is paid for the any increase in price of
materials and rate of labours which are beyond the control of the contractor. Any increase in
the cost due to inefficiencies in usage of the materials and labours are not admissible. Thus
any increase in cost due to usage in excess of standard quantity or hours are not paid.
CONTRACT COSTING 98
(ii) Contract Account
Dr Cr.
Particulars (Rs.) Particulars (Rs.)
To Material: By Contractee’s A/c 1,55,40,000
A – (3,400 × Rs. 1,100) 37,40,000
B – (2,300 × Rs. 700) 16,10,000
C – (600 × Rs. 3,900) 23,40,000
D – (90 × Rs. 31,500) 28,35,000 1,05,25,000
To Labour:
L1 – (56,000 × Rs.18) 10,08,000
L2 – (38,000 × Rs.35) 13,30,000 23,38,000
To Other expenses 13,45,000
To Estimated Profit 13,32,000
1,55,40,000 1,55,40,000
99 CONTRACT COSTING
PROCESS & OPERATION
10 COSTING
SOLUTIONS
HOMEWORK SECTION
Solution 1.
(i) Statement of Equivalent Production (Average cost method)
Input Particulars Output Equivalent Production
(Units Units
Materials Labour Overheads
(%*) Units** (%)* Units** (%)* Units**
20,000 Completed 14,000 100 14,000 100 14,000 100 14,000
WIP 6,000 100 6,000 33-1/3 2,000 33-1/3 2,000
20,000 20,000 20,000 16,000 16,000
*Percentage of completion ** Equivalent units
Solution 2.
(i) Statement of Equivalent Production
Particulars Input Particulars Output Equivalent Production
Units Units Material Conversion cost
% Units % Units
Opening WIP 1,000 Completed and
transfer red to
Process-2 35,000 100 35,000 100 35,000
Units intro
duced 40,000 Normal Loss
(10% of 40,000) 4,000 — — — —
Abnormal loss
(Balancing
figure) 500 100 500 60 300
Closing WIP 1,500 100 1,500 60 900
41,000 41,000 37,000 36,200
Working note:
Production units = Opening units + Units transferred from Process-II – Closing Units
= 1,600 units + 55,400 units – 4,200 units = 52,800 units
Statement of Cost
Cost (`) Equivalent Cost per
units equivalent
units (`)
Material A (Transferred from previous process) 6,23,250
Less: Scrap value of normal loss (2,640 units × ` 5) (13,200)
6,10,050 52,760 11.5627
Material B 2,12,400 51,820 4.0988
Labour 96,420 51,300 1.8795
Overheads 56,400 51,300 1.0994
9,75,270 18.6404
Solution 4.
Process- P Account
Particulars Kg. Amount Particulars Kg. Amount
(`) (`)
To Input 10,000 50,000 By Normal wastage 1,000 1,000
(1,000 kg. × ` 1)
To Direct Material — 38,000 By Process- Q 9,000 1,39,500
(9,000 kg. × ` 15.50)
To Direct Labour — 30,000
To Production OH — 22,500
(` 90,000 × 3/12)
10,000 1,40,500 10,000 1,40,500
`1,40,500- `1,000
Cost per unit = =` 15.50
10,000 kg.-1,000 kg.
`2,52,000-`900
Cost per unit =
9,000kg.-900kg.
Process- R Account
Particulars Kg. Amount Particulars Kg. Amount
(`) (`)
To Process-Q A/c 8,200 2,54,200 By Normal wastage 820 820
(820 kg. × Re.1)
To Direct Material — 42,880 By Abnormal loss 80 4,160
(80 kg. × ` 52)
To Direct Labour — 50,000 By Finished Goods 7,300 3,79,600
(7,300 kg. × `52)
To Production OH
(` 90,000 × 5/12) — 37,500
8,200 3,84,580 8,200 3,84,580
`3,84,580-`820
Cost per unit = =` 52
8,200 kg.-820 kg.
Answer 6
Process A Account
Particulars Tones Amount (`) Particulars Tones Amount (`)
To Materials 1,000 20,000 By Weight Loss 20 ---
To Wages 4,000 By Scrap 80 160
To Direct Expenses 3,160 By Process B 540 16,200
By Warehouse 360 10,800
Total 1,000 27,160 Total 1,000 27,160
27,160 – 160
Cost per Tonne =
1,000 – 20 – 80
27,000
=
900
= ` 30 per ton
25,456 – 256
Cost per Tonne =
800 – 16 – 64
25,200
=
720
Process C Account
Particulars Tones Amount (`) Particulars Tones Amount (`)
To Process B 360 12,600 By Weight Loss 10 ---
To Materials 140 1,400 By Scrap 40 240
To Wages 2,000 By Warehouse 450 17,100
To Direct Expenses 1,340
Total 500 17,340 Total 500 17,340
17,340 – 240
Cost per Tonne =
500 – 10 – 40
17,100
=
450
= ` 38 per ton
Alternative Presentation
Calculation of Incremental Profit / Loss after further processing
(`)
If 60,000 units are sold @ ` 9 5,40,000
If 60,000 units are processed in process II (60,000 × 1.2 × ` 10) 7,20,000
Incremental Revenue (A) 1,80,000
Incremental Cost: (B)
Material Cost 85,000
Processing Cost 50,000
1,35,000
Incremental Profit (A-B) 45,000
Additional net profit on further processing in Process II is 45,000. Therefore, it is advisable
to process further chemical ‘G’.
Working Notes:
1. Computation of Cost per unit
Particulars Materials Labour Overhead
(`) (`) (`)
Input costs 2,20,000 26,500 61,500
Less: Realisable value of normal (27,625) -- --
scrap (3,250 units x ` 8.5)
Net cost 1,92,375 26,500 61,500
Equivalent Units 51,750 51,050 51,050
Cost Per Unit 3.7174 0.5191 1.2047
Total cost per unit = ` (3.7174 + 0.5191 + 1.2047) = ` 5.4412
Solution 1.
(i)
Dr. Process-1 Account Cr.
Particulars Units Total (`) Particulars Units Total (`)
To Raw Material 10,000 7,50,000 By Normal Loss A/c 500 6,750
Consumed @ 13.5
” Direct Wages -- 3,00,000 ” Process 2 @ 9,000 12,01,500
133.5
” Direct -- 1,50,000 ” By Abnormal 500 66,750
Expenses Loss @ 133.5
“ Manufacturing 75,000
Overheads
10,000 12,75,000 10,000 12,75,000
Cost per unit of completed units and abnormal loss:
`12,75,000 - ` 6,750
= = ` 133.5
10,000units- 500units
(ii)
Dr. Process-2 Account Cr.
Particulars Units Total (`) Particulars Units Total (`)
To Process-I A/c 9,000 12,01500 By Normal Loss A/c 900 1,30,500
@ 145
” To Direct Wages -- 5,60,000 ” By Finished 8,200 21,04,667
Stock A/c [bal
fig]
” Direct -- 3,64,000
Expenses
” Manufacturing -- 84,000
Overheads
” To Abnormal 100 25,667
gain
Solution 3.
(i) Statement of Equivalent Production (FIFO Method)
Input Output Equivalent Production
Materials Labour Production
Overhead
Details Units Details Units % Units % Units % Units
Opening 600 From 600 - - 40 240 40 240
Stock opening
stock
- From 8,300 100 8,300 100 8,300 100 8,300
fresh
materials
Closing 700 100 700 70 490 70 490
W-I-P
Fresh inputs 9,200 Normal loss 392 - - - - - -
SOLUTIONS
HOMEWORK SECTION
Solution 1.
Working Notes:
(i) Computation of Allocation Ratio for Joint Costs
Products
X Y Z.
Rs. Rs. Rs.
Selling Price 13.75 8.75 7.50
Less: Anticipated margin@ 25% on cost or 20% on sales 2.75 1.75 1.50
Cost of sales 11.00 7.00 6.00
Less: Post split off cost 5.00 4.00 2.50
Joint cost per unit 6.00 3.00 3.50
Output (units) 8,000 6,000 4,000
Total output cost 48,000 18,000 14,000
Allocation ratio for joint costs 24 9 7
Note: 1
24
X= x 90,000 = 54,000
40
9
Y= x 90,000 = 20,250
40
7
Z=
x 90,000 = 15,750
40
90,000
Solution 2.
Statement of profitability of an Oil Mill (after carrying out further processing) for the quarter
ending 31st March 2019.
Products Sales Value Share of Additional Total cost Profit (loss)
after further Joint cost processing after
processing cosT processing
A 25,87,500 14,80,000 6,45,000 21,25,000 4,62,500
B 2,25,000 2,96,000 1,35,000 4,31,000 (2,06,000)
C 90,000 74,000 - 74,000 16,000
D 6,75,000 3,70,000 22,500 3,92,500 2,82,500
35,77,500 22,20,000 8,02,500 30,22,500 5,55,000
60 x 8,10,000
Output ‘P1’ = = 4,86,000 kgs.
100
40 x 8,10,000
Output ‘P2’ = = 3,24,000 kgs.
100
(i) Statement showing apportionment of joint costs in the ratio of net sales
Particulars Amount (` In
lakhs)
Joint cost of P1 – 33% of `1,205 lakhs 397.65
Joint cost of P2 – 67% of `1,205 lakhs 807.35
Total 1,205.00
(iv) Further processing of product P1 and converting to product YP1 is beneficial as the profit
of the company increases by `39.33 lakhs.
Working Note:
Profit of Product ‘YP1’ `147.90L
Increase in profit after further processing `108.57L
` 39.33 L
Answer 5
Statement of Comparison of Profits before and after further processing
S (`) P (`) N (`) A (`) Total (`)
A. Sales at split off point 20,000 12,000 28,000 20,000 80,000
B. Apportioned Joint 10,000 6,000 14,000 10,000 40,000
Costs (Refer Working
Note)
C. Profit at split-off point 10,000 6,000 14,000 10,000 40,000
D. Sales after further 1,20,000 40,000 48,000 - 2,08,000
processing
E. Further processing cost 80,000 32,000 36,000 - 1,48,000
F. Apportioned Joint 10,000 6,000 14,000 - -
Costs (Refer Working
Note)
G. Profit if further 30000 2,000 (-) 2,000 - -
processing (D – E + F)
Working Note:
Apportionment of joint costs on the basis of Sales Value at split -off point
Where,
Total Joint cost = ` 40,000
Total sales at split off point (S, P, N and A) = 20,000 + 12,000 + 28,000 + 20,000
= ` 80,000
`40,000
Share of S in joint cost = x ` 20,000 = ` 10,000
`80,000
`40,000
Share of P in joint cost = x ` 12,000 = ` 6,000
`80,000
`40,000
Share of N in joint cost = x ` 28,000 = ` 14,000
`80,000
`40,000
Share of A in joint cost = x ` 20,000 = ` 10,000
`80,000
Alternative Solution
Decision for further processing of Product S, P and N
Products S (`) P (`) N (`)
Sales revenue after further processing 1,20,000 40,000 48,000
Less: sales value at split-off point 20,000 12,000 28,000
Incremental Sales Revenue 1,00,000 28,000 20,000
Less: Further Processing cost 80,000 32,000 36,000
Profit/ loss arising due to further processing 20,000 (-)4,000 (-)16,000
Solution 1.
Total Joint Cost
Amount (`)
Direct Material 30,000
Direct Labour 9,600
Variable Overheads 12,000
Total Variable Cost 51,600
Fixed Overheads 32,000
Total joint cost 83,600
SOLUTIONS
HOMEWORK SECTION
Solution 1.
(i) Calculation of total cost for ‘Professionals Protection Plus’ policy
Particulars Amount (`) Amount (`)
1. Marketing and Sales support:
- Policy development cost 11,25,000
- Cost of marketing 45,20,000
- Sales support expenses 11,45,000 67,90,000
2. Operations:
- Policy issuance cost 10,05,900
- Policy servicing cost 35,20,700
- Claims management cost 1,25,600 46,52,200
3. IT Cost 74,32,000
4. Support functions
- Postage and logistics 10,25,000
- Facilities cost 15,24,000
- Employees cost 5,60,000
- Office administration cost 16,20,400 47,29,400
Total Cost 2,36,03,600
= ` 44,703.79
= ` 0.0018
Solution 1.
(i) Calculation of total project cost per day of concession period:
Activities Amount
(` in lakh)
Site clearance 170.70
Land development and filling work 9,080.35
Sub base and base courses 10,260.70
Bituminous work 35,070.80
Bridge, flyovers, underpasses, Pedestrian subway, footbridge, etc. 29,055.60
Drainage and protection work 9,040.50
Traffic sign, marking and road appurtenance 8,405.00
Maintenance, repairing and rehabilitation 12,429.60
Environmental management 982.00
Total Project cost 114,495.25
Administration and toll plaza operation cost 1,120.00
Total Cost 115,615.25
Concession period in days (25 years × 365 days) 9,125
Cost per day of concession period (` in lakh) 12.67
Solution 2.
(a) Working Notes:
Particulars For 4 weeks For 1 week
(by dividing by 4)
Total distance travelled (40 k.m × 2 3,200 km 800 km
× 2 trips × 5 days × 4 weeks)
Total tonne km (40 k.m × 10 tonnes × 2 16,000 tonne km 4,000 tonne km
× 5 days × 4 weeks)
6,720 1,680
Depreciation on tyres
Solution 3.
Working Notes:
(i) Total equivalent single room suites
Nature of suite Occupancy (Room-days) Equivalent single room
suites (Room-days)
Single room suites 36,000 36,000
(100 rooms x 360 days x (36,000 x 1)
100%)
Double rooms suites 14,400 36,000
(50 rooms x 360 days x 80%) (14,400 x 2.5)
Triple rooms suites 6,480 32,400
(30 rooms x 360 days x 60%) (6,480 x 5)
1,04,400
Alternatively
Let total takings be x
∴ X= 26,41,000 + .25X ( 5% + 20% )
∴ X = 35,21,333
Let the rent of single room be R
Then 1,04,400 R = 35,21,333
Or, R = `33.73
Rent to be charged:
Rent to be charged for single room suite = `33.73
Rent for double rooms suites ` 33.73 x 2.5 = `84.33
Rent for triple rooms suites `33.73 x 5 = `168.65
(ii) Average cost per student per month in respect of students coming from a distance of:
(a) 2 km. from the school {` 6,20,556 / (236 students × 12 months)} ` 219.12
(Refer to Working Note 2)
(b) 4 km. from the school (` 219.12 × 2) ` 438.24
(c) 8 km. from the school (` 219.12 × 4) ` 876.48
(iii) Calculation of minimum bus fare to be recovered from the students during the year
2020:
Statement showing the expenses of operating a single bus in year 2020
Particulars Per bus
per annum
(`)
Running costs : (A)
Diesel (Refer to working note 3) 66,316.80
Repairs & maintenance costs: (B) 15,375
(` 20,500 x 0.75)
Working Notes:
1. Calculation of diesel cost per bus:
No. of trips made by a bus each day 4
Distance travelled in one trip both ways (8 km. × 2 trips) 16 km.
Distance travelled per day by a bus (16 km. × 4 shifts) 64 km.
Distance travelled during a month (64 km. × 22 days) 1,408 km.
Distance travelled per year (1,408 × 10 months) 14,080 km.
No. of litres of diesel required per bus per year 2,816 litres
(14,080 km. ÷ 5 km.)
Cost of diesel per bus per year (2,816 litres × ` 78.50) ` 2,21,056
Answer 5
Operating Cost Sheet
Particulars Amount (`) Amount (`)
Standing Charges:
Depreciation (` 24,00,000 X 10% X 1/12 X 25) 5,00,000
Garage Rent 1,00,000
Insurance 25,000
Road Tax 20,000
Manager’s Salary 60,000
Assistant’s Salary (` 32,000 X 2) 64,000
Supervisor’s Salary (` 24,000 X 3) 72,000
Driver’s Salary (` 20,000 X 25) 5,00,000
Cleaner’s Salary (` 5,000 X 20) 1,00,000
Office Staff’s Salary 1,00,000
Consumables 1,20,000
Repairs & Maintenance 90,000
Other Fixed Expenses 72,000 18,23,000
Running Charges
Diesel (49,600 Kms / 10 Kms X ` 80 per unit) 3,96,800
Oils & Lubricants 1,45,000
Tyres and tubes 35,000 5,76,800
Total Operating Cost 23,99,800
= 0.883
SOLUTIONS
HOMEWORK SECTION
Solution 1.
Material Standard for 10 units Actual for 10 units
Qty. Units Rate (`) Amount (`) Qty. units Rate (`) Amount (`)
X 600 15 9,000 640 17.50 11,200
Y 800 20 16,000 950 18.00 17,100
Z 1,000 25 25,000 870 27.50 23,925
Total 2,400 50,000 2,460 52,225
1. Material Cost Variance = Standard cost – Actual cost
= ` 50,000 – ` 52,225
MCV = ` 2,225 (A)
4. Material Mix Variance = (Revised Std. Qty. – Actual Qty.) × Std. Price
Material X = (615* – 640) × 15 = ` 375 (A)
Material Y = (820* – 950) × 20 = `2,600 (A)
Material Z = (1,025 – 870) × 25 = `3,875 (F)
MMV = ` 900 (F)
2460
Material X = × 600 = 615 units
2400
2460
Material Y = × 800 = 820 units
2400
2460
Material Z = × 1,000 = 1,025 units
2400
5. Material Yield Variance= (Std. Qty - Revised Std. Qty.) × Std. Price
Material X = (600 - 615) × 15 = `225 (A)
Material Y = (800 - 820) × 20 = `400 (A)
Material Z = (1,000 - 1,025) × 25 = `625 (A)
MYV = `1,250 (A)
Check
MUV = MMV + MYV (Or MRUV)
`350 (A) = `900 (F) + `1,250 (A)
or
MCV = MPV + MMV + MYV (Or MRUV)
`2,225 (A) = `1,875 (A) + `900 (F) + `1,250 (A)
Solution 2.
Working Notes:
Budget Actual
1. Working hours per month 24,000 20,160
2. Production units per month 6,000 5,305
= (Budget 24,000 ÷ 4 hrs, Actual given)
3. Standard fixed overhead rate per unit
= ` 1,44,000 ÷ 6,000 = ` 24
4. Standard fixed overhead rate per hour
= `1,44,000 ÷ 24,000 = ` 6
5. Standard fixed overhead rate per day
= ` 1,44,000 ÷ 25 = ` 5,760
Fixed Overhead Variances:
Actual Fixed overhead incurred = ` 1,42,000 (given)
Budgeted fixed overhead for the period = ` 1,44,000.
Standard fixed overhead for actual production
= (Standard output for actual time × Standard Fixed Overhead per unit)
= 5,305 × `24 = `1,27,320.
Solution 3.
For fixed overhead variances:
Actual F.O. incurred (given) `12,000
Budgeted F.O. for the period `10,000
Standard F.O. for production (Standard output for
actual time × Standard Fixed Overhead per unit)
2,100 units × {`10,000 ÷ 2,000 units} `10,500
(i) Fixed Overhead Variance = Standard F.O. – Actual F.O.
= ` 10,500 – `12,000
= `1,500 (A)
(ii) F.O. Expenditure Variance = Budgeted F.O – Actual F.O.
= `10,000 – `12,000
= `2,000 (A)
(iii) F.O. Volume Variance = Standard F.O – Budgeted F.O.
= `10,500 – ` 10,000 = ` 500 (F)
Solution 4.
Basic Calculation
Material Actual for 680 kg. output Actual for 680 kg. output
Qty Kg Rate (`) Amount (`) Qty Kg Rate (`) Amount
A 480 50 24,000 540 60 32,400
B 320 60 19,200 260 50 13,000
Total 800 43,200 800 45,400
Less: Loss 160 - - 120 - -
(i) Material Cost Variance = (Std. cost of actual output – Actual cost)
= (45,900– 45,400)
= ` 500 (F)
(ii) Material Price Variance = (SP – AP) × AQ
Material A = (50 – 60) × 540 = ` 5400 (A)
Material B = (60 – 50)) × 260 = ` 2600 (F)
MPV = ` 2800 (A)
(iii) Material Usage Variance (MUV) = (Std. Quantity for actual output – Actual Quantity) ×
Std. Price
480x680
Material A = - 540 x 50 ` 1,500 (A)
640
320x680
Material B = - 260 x 60 ` 4,800 (F)
640
Solution 5.
Calculation of Variances :
(i) Fixed Overhead Variance: Standard fixed overhead – Actual fixed overhead = ` [
(5,00,000÷5000) ×4800] – ` 4,90,000 = ` 10,000 (A)
(ii) Fixed Overhead Expenditure Variances: Budgeted fixed overhead – Actual fixed overhead
= ` 5,00, 000 – ` 4,90, 000 = ` 10,000 (F)
(iii) Fixed Overhead Volume Variance: Standard fixed overhead – Budgeted fixed overhead =
Solution 6.
Ans.
COMPUTATION OF VARIANCES
(i) Overhead Cost Variance = Absorbed Overheads – Actual Overheads
= (Rs.87,200 + Rs.44,800) – (Rs.1,21,520 + Rs.55,680)
= Rs. 45,200 (A)
(ii) Fixed Overhead Cost = Absorbed Fixed Overheads – Actual Fixed
Overheads Variance = Rs. 87,200 – Rs.1,21,520
= Rs.34,320 (A)
(iii) Variable Overhead Cost = Standard Variable Overheads for Production–
Actual Variance Variable Overheads
= Rs. 44,800 – Rs. 55,680
= Rs. 10,880 (A)
(iv) Fixed Overhead Volume = Absorbed Fixed Overheads – Budgeted Fixed
Variance Overheads
= Rs. 87,200 – Rs.1,09,000
= Rs. 21,800 (A)
(v) Fixed Overhead Expenditure = Budgeted Fixed Overheads – Actual Fixed
Overheads Variance
= Rs.10.90 × 10,000 units – Rs.1,21,520
= Rs.12,520 (A)
(vi) Calendar Variance = Possible Fixed Overheads – Budgeted Fixed
Overheads
= Rs.1,03,550 – Rs.1,09,000
= Rs. 5,450 (A)
WORKING NOTE
Budgeted Fixed Overheads Rs.12,00,000
Fixed Overheads per Unit = = Rs. 10
Budgeted Output 1,20,000units
Fixed Overheads element in Semi-Variable Overheads i.e. 60% of Rs.1,80,000 Rs. 1,08,000
Budgeted Fixed Overheads Rs.1,08,000
Fixed Overheads per Unit = = Rs. 0.09
Budgeted Output 1,20,000units
Solution 7.
The variances may be calculated as under:
(a) Standard cost = Std. Qty × Std. price = 50 units ×`1.00 = `50
(b) Actual cost = Actual qty. × Actual price = 45 units ×`0.80 = ` 36
Variances:
(i) Price variance = Actual qty (Std. price – Actual price)
= 45 units (`1.00 – `0.80) = ` 9 (F)
(ii) Usage variance = Std. price (Std. qty – Actual qty.)
= `1 (50 units – 45 units) = ` 5 (F)
(iii) Material cost variance = Standard cost – Actual cost
(Total variance) = ` 50 – ` 36 = ` 14 (F)
Solution 8.
100 kg
Standard Quantity of input for actual output (SQ) = 2,10,000 kg ×
70 kg
= 3, 00,000 kg.
Actual Price (AP) = (`2,52,000 ÷ 2, 80,000 kg) = `0.90 per kg.
(a) Material Usage Variance = (SQ – AQ) × SP
= (3,00,000 – 2,80,000) × 1= ` 20,000 (F)
(b) Material Price Variance = (SP – AP) × AQ
= (1 – 0.90) × 2,80,000= ` 28, 000 (F)
Solution 9.
(a) Std. labour cost (`)
(1,000 hours × `50) 50,000
(b) Actual wages paid 36,000
(c) Actual rate per hour: ` 36,000/900 hours = `40
Variances
(i) Labour Rate variance = Actual time (Std. rate – Actual rate)
= 900 hours (`50 – `40) = `9,000 (F)
(ii) Efficiency variance = Std. rate per hr. (Std. time – Actual time)
= `50 (1,000 hrs. – 900 hrs.) = `5,000 (F)
(iii) Total labour cost variance = Std. labour cost – Actual labour cost
= {(`50 × 1,000 hours) – `36,000}
= (`50,000 – `36,000) = `14,000 (F)
Solution 10.
For Fixed Overhead Variances
Actual fixed overhead incurred ` 31,000
Budgeted fixed overhead for the period `30,000
Standard fixed overhead for production (Standard output
for actual time × Standard Fixed Overhead per unit) `33,000
(` 30,000 ÷ 20,000 units) × 22,000
Computation of Variances:
(i) Fixed overhead expenditure variance:
= Budgeted fixed overhead – Actual fixed overhead
= `30,000 – `31,000 = ` 1,000 (A)
(ii) Fixed overhead volume variance:
= Standard fixed overhead – Budgeted fixed overhead
= `33,000 – ` 30,000 = ` 3,000 (F)
Solution 11
(1) Fixed Overhead Expenditure Variance
= Budgeted Fixed Overheads – Actual Fixed Overheads
= ` 12,000 – ` 12,800 (as calculated below) = ` 800 (A)
(2) Fixed Overhead Cost Variance= Absorbed Fixed Overheads – Actual Fixed Overheads
2,800 (A) = ` 10,000 – Actual Overheads
Actual Overheads = ` 12,800
(3) Actual Hours for Actual Production = ` 12,800/ `8 = 1,600 hrs.
(4) Fixed Overhead capacity Variance
= Budgeted Fixed Overheads for Actual Hours– Budgeted Fixed Overheads
= ` 5 x 1600 hrs. – ` 12,000 = ` 4,000 (A)
(5) Standard Hours for Actual Production
= Absorbed Overheads/ Std. Rate
= ` 10,000/ ` 5 = 2,000 hrs.
(6) Fixed Overhead Efficiency Variance
= Absorbed Fixed Overheads – Budgeted Fixed Overheads for Actual Hours
= ` 10,000 – ` 5 x 1,600 hrs. = ` 2,000 (F)
Working Note:
(i) Fixed Overhead Volume Variance = Absorbed Fixed Overheads – Budgeted Fixed
Overheads
2,000 (A) = Absorbed Fixed Overheads – `12,000
Absorbed Fixed Overheads = ` 10,000
(ii) Standard Rate/ Hour = ` 5 (` 12,000/2,400 hrs.)
Solution 12
Working Notes:
1. Calculation of standard man hours
When 120 worker works for 1 hr., then the std. output is 20 units.
120 hrs.
Std. man hour per unit = = 6 hrs.
20 units
Solution 1.
a)(ii) Workings:
Take the good output of 195 ltr. The standard quantity of material required for 195 ltr. of
output is
195
x 100 = 243.75 ltr.
80
Computation of Variances:
Material Cost Variance = SQ × SP – AQ × AP
A = ` 146.25 ltr. × ` 40– 140 ltr. × ` 42 = ` 30.00 (A)
B = ` 97.50 ltr. × ` 60 – 110 ltr. × ` 56 = ` 310.00 (A)
Total = ` 30.00 (A) + ` 310.00 (A)
= ` 340.00 (A)
Solution 2.
Working:
Quantity of material purchased and used.
No. of units produced 1,000 units
Std. input per unit 30kg.
Std. quantity (Kg.) 30,000 kg.
Add: Excess usage 7,200 kg.
Actual Quantity 37,200 kg.
Add: Closing Stock 10,000 kg.
Less: Opening stock 5,000 kg.
Quantity of Material purchased 42,200 kg.
(i) Direct Material Price Variance:
= Actual Quantity purchased (Std. Price – Actual Price)
= 42,200 kg.(`350 – `365) = 6,33,000 (Adverse)
Direct Material Usage Variance:
= Std. Price (Std. Quantity – Actual Quantity)
= `350 (30,000 kg. – 37,200 kg.) = `25,20,000 (Adverse)
(ii) Direct Labour Rate Variance:
= Actual hours (Std. Rate – Actual Rate)
= 5,300 hours (`80 – `82) = `10,600 (Adverse)
Direct Labour Efficiency Variance:
= Std. Rate (Std. hours – Actual hours)
= `80 (1,000 units × 5 hours – 5,300 hours) = `24,000 (Adverse)
Reconciliation Statement
Standard Cost: 600 units @ `54.50 32,700
Actual Cost: 38,600
Less: Material Stock at standard cost: 6,000 (32,600) 100 Fav.
(1,500 × `4)
Variances: Adv. (`) Fav. (`)
Material price 500
Material usage 2,000
Labour rate 1,700
Labour efficiency 1,000
Variable expenditure 200
Variable efficiency 100
Total 2,700 2,800 100 Fav.
Solution 4.
Material Price Variance = Actual Quantity (Std. Price – Actual Price)
X = 12,500 units (Rs.40 – Rs.44) = 50,000 (A)
Y = 18,000 units (Rs.30 – Rs.28) = 36,000 (F)
Z = 88,500 units (Rs.10 – Rs.12) = 1,77,000 (A) 1,91,000 (A)
Material Mix Variance = Std. Price (Revised Std. Qty. – Actual Qty.)
1,19,000x2
X = Rs.40 ( - 12,500) = 24,000 (A)
20
Material Yield Variance = Std. Price (Std. Qty. – Revised Std. Qty.)
1,19,000x2
X = Rs.40 (6,000 × 2 - ) = 4,000 (F)
20
1,19,000x3
Y = Rs.30 (6,000 × 3 - ) = 4,500 (F)
20
1,19,000x15
Z = Rs.10 (6,000 × 15 - ) = 7,500 (F) 16,000 (F)
20
Solution 5.
Workings:
Skilled Unskilled
Standard Rate per hour 80 60
Standard time for producing 1.5 hours 1.5 hours
one unit (Rs.120 ÷ Rs.80) (Rs.90 ÷ Rs.60)
Actual hours paid (AHPaid) 6,600 hours 5,400 hours
Standard hours required to 6,000 hours 6,000 hours
produce 4,000 units (SH) (1.5 hours× 4,000 units) (1.5 hours× 4,000 units)
Actual hours worked
(AHWorked)
Idle timeAbnormal 6,600 - 6,435 = 165 hours 5,400 – 5,265 = 135 hours
(i) Labour Rate Variance = AHPaid(Std. Rate – Actual Rate)
- Skilled = 6,600 hours (Rs.80 – Rs.87.50) = Rs.49,500 (A)
- Unskilled = 5,400 hours (Rs.60 – Rs.55) = Rs.27,000 (F)
= Rs.22,500 (A)
= 11,700 hours
SOLUTIONS
HOMEWORK SECTION
Solution 1.
(a) Fixed production costs absorbed: (`)
Budgeted fixed production costs 1,60,000
Budgeted output (normal level of activity 800 units)
Therefore, the absorption rate: 1,60,000/800 = ` 200 per unit
During the first quarter, the fixed production
cost absorbed by ZEST would be (220 units × ` 200) 44,000
Solution 2.
Variable Cost = 100 – P/V Ratio
= 100 – 60 = 40
If Variable cost is 40, then selling price = 100
If Variable cost is 20, then selling price = (100/40) × 20 = ` 50
Solution 3.
Margin of Safety (%) =
= 75%
Total Sales =
Profit = Total Sales – Total Cost
= ` 2,50,000 – ` 1,93,750
= ` 56,250
P/V Ratio =
=
= 30%
Break-even Sales = Total Sales × [100 – Margin of Safety %]
= ` 2,50,000 × 0.25
= ` 62,500
151 MARGINAL COSTING
Fixed Cost = Sales × P/V Ratio – Profit
= ` 2,50,000 × 0.30 – ` 56,250
= ` 18,750
Solution 4.
(i) We know that: B.E. Sales P/V Ratio = Fixed Cost
or ` 1,60,000 x P/V ratio = ` 40,000
P/V ratio = 25%
We also know that Sales P/V Ratio = Fixed Cost + Profit
or ` 2,00,000 0.25 = ` 40,000 + Profit
or Profit = ` 10,000
(ii) Again B.E. Sales x P/V ratio = Fixed Cost
or ` 40,000 x P/V Ratio = ` 20,000
or P/V ratio = 50%
We also know that: Sales x P/V ratio = Fixed Cost + Profit
or Sales x 0.50 = ` 20,000 + ` 10,000
or Sales = ` 60,000.
Solution 5.
Contribution
P/V Ratio = × 100
Sales
Solution 6.
Margin of Safety (%) =
= 75%
Total Sales =
Profit = Total Sales – Total Cost
= ` 2,50,000 – ` 1,93,750
= ` 56,250
P/V Ratio =
Solution 7.
Sales (`) Profit (`)
Year 2016 4,00,000 15,000 (loss)
Year 2017 5,00,000 15,000 (profit)
Difference 1,00,000 30,000
(ii)
(`)
Contribution in 2016 (4,00,000 x 30% 1,20,000
Add: Loss 15,000
Fixed Cost* 1,35,000
*Contribution = Fixed cost + Profit
Fixed cost = Contribution – Profit
Rs.32,000 units
x 100 = 40,000 units
80
2. Component of fixed cost included in semi -variable cost of 32,000 units. Fixed cost =
{Total semi-variable cost – Total variable cost }
= Rs.1,80,000 – 32,000 units × Rs.3.75
= Rs.1,80,000 – Rs.1,20,000
= Rs.60,000
20,000 units
= x 100=50%
40,000 units
8
Or, Rs.25S = Rs.17.5S + Rs.1,50,000 + x (Rs.225)
100
(iii) Profit if selling price is increased by 15% and sales volume drops by 10%
Existing Selling Price per unit = ` 3,400
Revised selling price per unit = ` 3,400 × 115% = ` 3,910
Existing Sales Volume = 50,000 units
Revised sales volume = 50,000 units – 10% of 50,000 = 45,000 units.
Statement of profit at sales volume of 45,000 units @ ` 3,910 per unit
Particulars Per unit (`) Total (` in lakhs)
Sales 3,910.00 1,759.50
Less: Variable Costs (1,400.00) (630.00)
Contribution 2,510.00 1,129.50
Less: Fixed Cost (850.00)
Profit 279.50
` 1,115 lakh
No. of units to be sold = Desired Contribution = = 42,525 units
` 2,622
Solution 10.
(i) Contribution per unit = Selling price – Variable cost
= Rs.100 – Rs.60
= Rs.40
Break-even Point = 60,000 units
(Rs.)
Sales Value (1,50,000 units × Rs.100) 1,50,00,000
Less: Variable Cost (1,50,000 units ×Rs.60) 90,00,000
Contribution 60,00,000
Less: Fixed Cost 24,00,000
Profit 36,00,000
Less: Income Tax @ 40% 14,40,000
Net Return 21,60,000
(ii) Products
X (Rs.) Y (Rs.)
Selling Price per unit 100 150
Variable Cost per unit 60 100
Contribution per unit 40 50
Composite contribution will be as follows:
40 50
Contribution per unit = X5 + X3
8 8
= 25 + 18.75 = Rs.43.75
Rs.28,00,000
Break-even Sale = 64,000 units
Rs.43.75
Solution 10.
(` in ‘000)
Factory Sales Profit P/V Ratio
Actual Over / Budgeted Actual Over / Budget Change in Profit
(Under) Sales (Under) Profit Change inSales
Budget Budget
North 1,100 (400) 1,500 135 (180) 315 45%
East 1,450 150 1,300 210 90 120 60%
South 1,200 (200) 1,400 330 (110) 440 55%
Fixed Cost
Break-even Sales (Company as Whole) =
Composite P / V Ratio *
= ` 13,50,000
54%
=` 25,00,000
Solution 11
Selling Price = ` 500
Profit = ` 125
No of Sticks = 5,000
Solution 12
Contribution to sales ratio (P/V ratio) = 37%
Variable cost ratio = 100% - 37% = 63%
Variable cost = ` 10,00,000 x 63% = ` 6,30,000
After decrease in selling price and fixed cost, sales quantity has not changed. Thus, variable
cost is ` 6,30,000.
Revised Contribution to sales = 30%
Thus, Variable cost ratio = 100% - 30% = 70%
` 6,30,000
Thus, Revised sales = = ` 9,00,000
70%
Revised, Break-even sales ratio = 100% - 40% (revised Margin of safety) = 60%
(i) Revised fixed cost = revised breakeven sales x revised contribution to sales ratio
=
` 5,40,000 (` 9,00,000 x 60%) x 30%
=
` 1,62,000
(ii) Revised sales = ` 9,00,000 (as calculated above)
(iii) Revised Break-even point = Revised sales x Revised break-even sales ratio
=
` 9,00,000 x 60%
=
` 5,40,000
Solution 13
(i) Cost Indifference Point
Method-1 and Method-2
(`)
Differential Fixed Cost (I) ` 2,00,000
(` 3,00,000 – ` 1,00,000)
Differential Variable Costs (II) `5
(` 15 – ` 10)
Cost Indifference Point (I/II) 40,000
(Differential Fixed Cost / Differential Variable Costs
per unit)
Interpretation of Results
Solution 14
Variable Cost per Unit=`16
Fixed Cost per Unit =` 4, Total Fixed Cost= 2,00,000 units x ` 4 = `8,00,000
Total Cost per Unit =`20
Selling Price per Unit=Total Cost+ Profit =` 20+` 4 =` 24
Contribution per Unit=` 24-`16=` 8
Fixed cost ` 8,00,000
(i) Present Break-even Sales (Quantity) = Contribution margin per unit = `8
= 1,00,000 units
Present Break-even Sales (`) = 1,00,000 units x ` 24 = ` 24,00,000
8
(ii) Present P/V Ratio = X 100 = 33.33%
24
5.60
Revised P/V Ratio = X 100 = 25.926%
21.60
Fixed cost 8,00,000
Revised Break-even point (`) = P/V ratio = 25.926% = ` 30,85,705
Or
Fixed cost 8,00,000
Revised Break-even point (units) = Contribution margin per unit = 5.60
= 1,42,857 units
Revised Break-even point (`) = 1,42,857 units x ` 21.60 = ` 30,85,711
Solution 15
Particulars Quarter ending Quarter ending
31st December, 31st March, 2022
2021 (`) (`)
Sales (No. of units sold x ` 450 per unit) 54,00,000 1,35,00,000
Profit (Loss) (4,20,000) 12,00,000
[12,000 × 35] [30,000 × 40]
Change in profit
P/V Ratio = x 100
Change in Sales
16,20,000
∴ × 100 = 20%
81,00,000
(iii) Profit, if sales reach 50,000 units for the quarter ending 30th June, 2022
(`)
Sales (50,000 × ` 450) 2,25,00,000
Less: Variable cost 1,80,00,000
Contribution 45,00,000
Less: Fixed cost 15,00,000
Profit 30,00,000
Solution 1.
100
(a) Total Sales = 2,40,000 × = ` 6,00,000
40
Contribution 2,00,000
(b) P/V ratio = = = 25%
Sales 8,00,000
Profit 1,50,000
Margin of safety = = = ` 6,00,000
P/V ratio 25%
Alternatively:
Fixed cost = Contribution – Profit
=
` 2,00,000 – `1,50,000 = ` 50,000
B.E. Point = ` 50,000 ÷ 25% = ` 2,00,000
Margin of Safety = Actual sales – B.E. sales
= 8,00,000 – 2,00,000 = 6,00,000
Solution 3.
(i) Statement showing Break Even Sales
Particulars Black White
Sales Planned 81,00,000 54,00,000
Selling Price (`) 18 24
Number of Units to be sold 4,50,000 2,25,000
Break Even sales (in Units),70% of total sales 3,15,000 1,57,500
Or
Break Even sales (in `),70% of total sales 56,70,000 37,80,000
Contribution 9,96,000
Less: Fixed cost (Rs. 11,97,000x40%) 4,78,800
Profit 5,17,200
If price has been increased by 11.11% (increases by 200 on 1,800) sales goes down by
20% (decreased by 300 on 1,500). Change in demand is greater than change in price.
Since the variable costs are still same profit has been arose to ` 5,17,200 in-spite of high
elasticity of demand. PH gems would not be able to sustain this policy on account of
change if any in variable costs.
478.80
Variable Overheads
Contribution 612.00
P/V Ratio (` 612/1800x100) 34.0%
To earn profit 20% on sales of readymade suit (along with TIE PIN) company has to sold
1,900 units i.e. 95% of the full capacity. This sales level of 1,900 units is justified only
if variable cost is constant. Any upside in variable cost would impact profitability, to
achieve the desired profitability. Production has to be increased but the scope is limited
to 5% only.
Solution 5.
Rs.
Sales 50,000 units at Rs. 7 3,50,000
Variable cost 50,000 × 3 1,50,000
Contribution 50,000 × 4 2,00,000
Fixed costs 1,20,000
Profit 80,000
Solution 6.
Workings:
Let us assume that the selling price before increment is Rs.100, the other relevant details are
as follows:
Particulars Before increase After increase
Selling Price 100 110
Variable Cost 60 63
Contribution 40 47
P/V Ratio 40% 42.73%
SOLUTIONS
HOMEWORK SECTION
Solution 1.
ABC Ltd.
Budget for 85% capacity level for the period 2020-21
Budgeted production (units) 85,000
Per Unit (`) Amount (`)
Direct Material (note 1) 21.60 18,36,000
Direct Labour (note 2) 10.50 8,92,500
Variable factory overhead (note 3) 2.10 1,78,500
Variable selling overhead (note 4) 4.32 3,67,200
Variable cost 38.52 32,74,200
Fixed factory overhead (note 3) 2,20,000
Fixed selling overhead (note 4) 1,15,000
Administrative overhead 1,76,000
Fixed cost 5,11,000
Total cost 37,85,200
Add: Profit 20% on sales or 25% on total cost 9,46,300
Sales 47,31,500
Contribution (Sales – Variable cost) 14,57,300
Working Notes:
1. Direct Materials:
(`) (`)
75% Capacity 15,00,000 65% Capacity 13,00,000
65% Capacity 13,00,000 55% Capacity 11,00,000
10% change in capacity 2,00,000 10% change in capacity 2,00,000
For 10% increase in capacity, i.e., for increase by 10,000 units, the total direct material
cost regularly changes by ` 2,00,000
Direct material cost (variable) = ` 2,00,000 ÷ 10,000 = ` 20
After 8% increase in price, direct material cost per unit = ` 20 × 1.08
= ` 21.60
Direct material cost for 85,000 budgeted units = 85,000 × ` 21.60
= ` 18,36,000
Solution 3.
Ans.
(i) Preparation of Production Budget (in Units)
January February March April May
Sales 5,000 6,000 7,000 7,500 8,000
Add: Closing stock (25% of next 1,500 1,750 1,875 2,000
month’s sales)
Less: Opening Stock (1200) (1500) (1750) (1875)
Solution 4.
Expense Budget of R Ltd. for the period ……
50% Capacity 60% Capacity
Per unit (`) 60,000 units 72,000 units
Amount (`) Amount (`)
Sales (A) 200.00 1,20,00,000 1,44,00,000
Less: Variable Costs:
- Direct Material 82.50 49,50,000 59,40,000
- Direct Wages 27.50 16,50,000 19,80,000
- Variable Overheads 27.50 16,50,000 19,80,000
- Direct Expenses 16.50 9,90,000 11,88,000
- Variable factory expenses 16.50 9,90,000 11,88,000
(75% of ` 20 p.u.)
- Variable Selling & Dist. exp. 8.80 5,28,000 6,33,600
(80% of ` 10 p.u.)
Solution 5.
(i) Production Budget of ‘X’ for the Second Quarter
Particulars Bags (Nos.)
Budgeted Sales 50,000
Add: Desired Closing stock 11,000
Total Requirements 61,000
Less: Opening stock 15,000
Required Production 46,000
(ii) Raw–Materials Purchase Budget in Quantity as well as in Rs. for 46,000 Bags of ‘X’
Particulars ‘Y’ Kgs. ‘Z’ Kgs. Empty Bags
Nos.
Production Requirements 2.5 7.5 1.0
Per bag of ‘X’
Requirement for Production 1,15,000 3,45,000 46,000
(46,000 × 2.5) (46,000 × 7.5) (46,000 × 1)
Add: Desired Closing Stock 26,000 47,000 28,000
Total Requirements 1,41,000 3,92,000 74,000
Less: Opening Stock 32,000 57,000 37,000
Quantity to be purchased 1,09,000 3,35,000 37,000
Cost per Kg./Bag Rs.120 Rs.20 Rs.80
Cost of Purchase (Rs.) 1,30,80,000 67,00,000 29,60,000
(iii) Computation of Budgeted Variable Cost of Production of 1 Bag of ‘X’
Particulars (Rs.)
Raw – Material
Y 2.5 Kg @120 300.00
Z 7.5 Kg. @20 150.00
Empty Bag 80.00
Direct Labour(Rs.50× 9 minutes / 60 minutes) 7.50
Variable Manufacturing Overheads 45.00
Variable Cost of Production per bag 582.50
Solution 6
(i) Sales Budget (in `)
Particulars Nov, 20 Dec, 20 Jan, 21 Feb, 21 Mar, 21 Total
Sales (in Units) 30,000 35,000 38,000 25,000 40,000 1,68,000
Selling Price per 10 12 15 15 20 -
unit (`)
Total Sales (`) 3,00,000 4,20,000 5,70,000 3,75,000 8,00,000 24,65,000
Solution 1.
(a) Flexible Budget before marketing efforts:
Product A (`) Product B (`)
6,000 units 9,000 units
Per unit Total Per unit Total
Sales 120.00 7,20,000 78.00 7,02,000
Raw material cost 60.00 3,60,000 42.00 3,78,000
Direct labour cost per unit 30.00 1,80,000 18.00 1,62,000
Variable overhead per unit 12.00 72,000 6.00 54,000
Fixed overhead per unit 8.00 48,000 4.00 36,000
Total cost 110.00 6,60,000 70.00 6,30,000
Profit 10.00 60,000 8.00 72,000
Solution 3
(i) Flexible Budget (before promotion)
Particulars Product ‘AYE’ Product ‘ZYE’ Total
Production & Sales 4,000 3,000
(units)
Amount (`) Amount (`) Amount (`)
A. Sales Value 8,00,000 5,40,000 13,40,000
(` 200×4,000) (` 180×3,000)
B. Direct Materials 3,20,000 2,10,000 5,30,000
(` 80 × 4,000) (`70 × 3,000)
C. Direct labour 1,60,000 1,05,000 2,65,000
(` 40 × 4,000) (` 35 × 3,000)
D. Variable Overheads 80,000 75,000 1,55,000
(` 20 × 4,000) (` 25 × 3,000)
E. Total Variable Cost 5,60,000 3,90,000 9,50,000
(B+C+D)
F. Contribution (A-E) 2,40,000 1,50,000 3,90,000
G. Fixed Overhead 40,000 30,000 70,000
(`10 × 4,000) (`10 × 3,000)