Costing Homework Solutions
Costing Homework Solutions
Ednovate
For subject
ednovateofficial related queries
Ednovate Official 7273 961 961
Ednovate Classes
TABLE OF CONTENTS
9A JOB COSTING 54
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
Relevant Cost of this order quantity Rs.
4000 1,890
Ordering cost = 13.33 say 14 orders at Rs. 135
300
1
Carrying cost = x300x12 1,800
2
Relevant cost 3,690
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
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
No. of workers recruited and joined 42.
Hence, number of workers left and discharged comes to 18
EMPLOYEE COST 10
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
11 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 12
(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
13 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 14
- 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
15 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 16
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
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
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
37 COST SHEET
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
COST SHEET 38
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
39 COST SHEET
*(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
COST SHEET 40
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.
41 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
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
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%
JOB COSTING 54
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:
7,85,270 185 days
Depreciation= x = ` 40,000
9years 365 days
Hence the value of machine after the period of 185 days = ` 7,85,270 – ` 40,000 = `
7,45,270
Cost of 50% of the contract which has been certified by the architect is `. 17,67,900.
55 CONTRACT COSTING
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
CONTRACT COSTING 56
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
57 CONTRACT COSTING
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
CONTRACT COSTING 58
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.
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
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
69 SERVICE COSTING
Solution 2.
(i) Total equivalent single room suites
Nature of suite Occupancy Equivalent single room suites
(Room-days) (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
(ii) Statement of total cost:
(`)
Staff salaries 14,25,00,000
Room attendant’s wages 4,50,00,000
Lighting, heating and power 2,15,00,000
Repairs and renovation 1,23,50,000
Laundry charges 80,50,000
Interior decoration 74,00,000
Sundries 1,53,00,000
25,21,00,000
Building rent {(`10,00,000 x 12 months) + 1,20,00,000+ 5% on total takings
5% on total taking}
Total cost 26,41,00,000 + 5% on total takings
Profit is 20% of total takings
Total takings = ` 26,41,00,000 + 25% (5% +20%) of total takings
Let x be rent for single room suite
Then 1,04,400 x = 26,41,00,000 + 0.25 × 1,04,400 x
Or, 1,04,400 x = 26,41,00,000 + 26,100 x
Or, 78,300 x = 26,41,00,000
Or, x = 3,373
(iii) Rent to be charged for single room suite = ` 3,373
Rent for double rooms suites ` 3,373 x 2.5 = ` 8,432.5
Rent for triple rooms suites ` 3,373 x 5 = ` 16,865.
SERVICE COSTING 70
13 STANDARD COSTING
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)
71 STANDARD COSTING
*Revised Standard Quantity (RSQ) is calculated as follows:
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.
STANDARD COSTING 72
Variances:
(i) F.O. Expenditure Variance = (Budgeted fixed overhead – Actual fixed
overhead)
= 1,44,000 – 1,42,000 = ` 2,000 (F)
(ii) Total Volume Variance = (Standard fixed overhead – Budgeted
fixed overhead)
= 1,27,320 – 1,44,000 = `16,680 (A)
(iii) Fixed overhead variance = (Standard fixed overhead – Actual Fixed
overhead)
= 1,27,320 – 1,42,000 = `14,680 (A)
Alternatively:
Expenditure Variance + Volume Variance = 2,000 (F) + 16,680 (A) = `14, 680 (A)
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 - -
73 STANDARD COSTING
640 43,200 680 45,400
Std. cost of actual output = ` 43,200 × 680/640 = ` 45,900
Calculation of Variances
(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 =
STANDARD COSTING 74
` 4,80, 000 – ` 5,00, 000 = ` 20,000 (A)
(iv) Fixed Overhead efficiency Variance: Standard fixed overhead – Budgeted fixed overhead
for Actual days = ` 4,80, 000 – [(` 5,00, 000÷25) ×23] = ` 20,000 (F)
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
75 STANDARD COSTING
Standard Rate of Absorption of Fixed Overheads per unit (Rs.10 + Rs.0.90) Rs.10.90
Fixed Overheads Absorbed on 8,000 units @ Rs10.90 Rs. 87,200
Budgeted Variable Overheads Rs. 6,00,000
Add : Variable element in Semi-Variable Overheads 40% of Rs. 1,80,000 Rs. 72,000
Total Budgeted Variable Overheads Rs. 6,72,000
Budgeted Fixed Overheads Rs.6,72,000
Standard Variable Cost per unit = = Rs. 5.60
Budgeted Output 1,20,000units
Standard Variable Overheads for 8,000 units @ Rs.5.60 Rs. 44,800
Budgeted Annual Fixed Overheads (Rs. 12,00,000 + 60% of Rs. 1,80,000) Rs.13,08,000
Budgeted Fixed Overheads
Possible Fixed Overheads = x Actual Days Rs.1,03,550
Budgeted Days
Rs.1,09,000
x 19Days
20 Days
Actual Fixed Overheads (Rs.1,10,000 + 60% of Rs. 19,200) Rs.1,21,520
Actual Variable Overheads (Rs.48,000 + 40% of Rs.19,200) Rs. 55,680
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)
STANDARD COSTING 76
(c) Material Cost Variance = (SQ × SP) – (AQ × AP)
= (3, 00,000 × 1) – (2, 80,000 × 0.90)
= ` 48, 000 (F)
Check MCV = MPV + MUV
` 48, 000 (F) = ` 28, 000 (F) + `20, 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)
77 STANDARD COSTING
(iii) Fixed overhead variance:
= Standard fixed overhead – Actual fixed overhead
= `33,000 – ` 31,000 = ` 2,000 (F)
STANDARD COSTING 78
14 MARGINAL COSTING
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
79 MARGINAL COSTING
(d) Profit for the Quarter (Marginal Costing)
(`) (`)
Sales revenue (160 units × ` 2,000): (A) 3,20,000
Less: Production costs:
- Variable cost (220 units × ` 800) 1,76,000
Add: Opening stock --
(48,000)
Less: Closing Stock
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
MARGINAL COSTING 80
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 =
81 MARGINAL COSTING
=
30%
Break-even Sales = Total Sales × [100 – Margin of Safety %]
=
` 2,50,000 × 0.25
=
` 62,500
Fixed Cost = Sales × P/V Ratio – Profit
=
` 2,50,000 × 0.30 – ` 56,250
=
` 18,750
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
MARGINAL COSTING 82
Solution 8.
Working notes:
1. (i) Number of units sold at 80% capacity
Turnover Rs.8,00,000
=
Selling price p.u. Rs.25
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
83 MARGINAL COSTING
Fixed cost Rs. 1,50,000
Break-even point (units) = = = 20,000 units
Contribution per unit Rs. 7.50
20,000 units
= x 100=50%
40,000 units
8
Or, Rs.25S = Rs.17.5S + Rs.1,50,000 + x (Rs.225)
100
Or, Rs.25S = Rs.17.5S + Rs.1,50,000 + Rs.2S
Or, S = (Rs.1,50,000/Rs.5.5) units
Or, S = 27,273 units.
MARGINAL COSTING 84
Solution 9.
Sales Volume 50,000 Units
Computation of existing contribution
Particulars Per unit (`) Total (` in lakhs)
Sales 3,400 1,700
Fixed Cost 1,700 850
Profit 300 150
Contribution 2,000 1,000
Variable Cost 1,400 700
(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
85 MARGINAL COSTING
(iv) Volume to be achieved to earn target profit of ` 350 lakhs with revised selling price and
reduction of 8% in variable costs and ` 85 lakhs in fixed cost.
Revised selling price per unit = ` 3,910
Variable costs per unit existing = ` 1,400
Revised Variable Costs
Reduction of 8% in variable costs = ` 1,400 – 8% of 1,400
= ` 1,400 – ` 112
= ` 1,288
Total Fixed Cost (existing) = ` 850 lakhs
Reduction in fixed cost = ` 85 lakhs
Revised fixed cost = ` 850 lakhs – ` 85 lakhs = ` 765 lakhs
Revised Contribution (unit) = Revised selling price per unit – Revised
Variable Costs per units
Revised Contribution per unit = ` 3,910 – ` 1,288 = ` 2,622
Desired Contribution = Revised Fixed Cost + Target Profit
= ` 765 lakhs + `350 lakhs= `1,115 lakhs
` 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
MARGINAL COSTING 86
Rs.21,60,000
Rate of Net Return on Sales = 14.40% X 100
Rs. 1,50,00,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
87 MARGINAL COSTING
15 BUDGET & BUDGETARY
CONTROL
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