Costing Practise Sheet Jan 2025
Costing Practise Sheet Jan 2025
Costing Practise Sheet Jan 2025
COSTING
PRACTICE
SHEETS
JAN 25 -
MAY 25
CA NITIN GURU
Introduction
I am pleased to present to you this practice booklet, specially compiled to aid your preparation for the CA
Intermediate exams. This comprehensive resource, brought to you by EDU91 and meticulously compiled by CA
Nitin Guru, is designed to provide you with an invaluable study aid.
Inside this booklet, you will find past years' exam questions, revision test papers, and mock test paper
questions presented by ICAI. These have been simplified and organized in a chapter-wise manner to facilitate
easier understanding and revision. Additionally, this booklet includes multiple-choice questions (MCQs) and
case-based questions, also provided by ICAI, to help you practice and perfect your exam techniques.
Every effort has been made to ensure that this booklet is error-free. However, if you come across any mistakes,
please do not hesitate to bring them to our attention so we can correct them. Your feedback is invaluable to
us.
I extend my heartfelt thanks to my students for their continuous appreciation, hard work, and consistent
support. Your dedication is the driving force behind this initiative. This practice booklet is a small token of
gratitude from EDU91 and CA Nitin Guru to help you succeed in your exams.
Yours
CA Nitin Guru
CLASS ATTRACTIONS
● Start the topic from the base.
● Explains reasons and logic inbuilt behind concepts and has a unique method of making students
understand them.
● Real life examples make classes interesting & lively.
Thank You !!
CA Nitin Guru
INDEX
3 Overheads 3.1-3.12
7 Reconciliation 7.1-7.4
Material Costing
Question 1 : (RTP Sept 2024)
‘Axe Trade’, an unregistered supplier under GST, purchased material from Vye Ltd. which is registered supplier
under GST. During the month of June 2024, the Axe Traders has purchased a lot of 5,000 units on credit from
Vye Ltd. The information related to the purchase are as follows:
Listed price of one lot of 5,000 units ₹ 2,50,000
Trade discount @ 10% on listed price
CGST and SGST (Credit available) 18% (9% CGST + 9% SGST)
Cash discount @ 10%
(Will be given only if payment is made within 30 days.)
Toll Tax paid ₹ 5,000
Freight and Insurance ₹ 17,220
Demurrage paid to transporter ₹ 5,000
Commission and brokerage on purchases ₹ 10,000
Amount deposited for returnable containers ₹ 30,000
Amount of refund on returning the container ₹ 20,000
Other Expenses @ 2% of total cost
A 20% shortage in material on receipt is expected considering the nature of the raw material.
The payment to the supplier was made within 21 days of the purchases.
(i) If Axe Traders pays the supplier within 30 days of purchase, then, what is the total amount of cash discount
received from the supplier and how it is treated to calculate material cost?
(a) ₹ 25,000 & it will not be deducted from the material cost
(b) ₹ 26,550 & it will be deducted from the material cost
(c) ₹ 26,550 & it will not be deducted from the material cost
(d) ₹ 22,500 & it will not be deducted from the material cost
(ii) What will be the amount of other expenses and how it is treated in material cost?
(a) ₹ 6,154.40 & it will be added with the material cost
(b) ₹ 6,280.00 & it will be added with the material cost
(c) ₹ 5,344.40 & it will be added with the material cost
(d) ₹ 5,453.47 & it will not be added with the material cost
(iii) What is the amount of GST and how will it be treated in cost sheet of Axe Traders?
(a) ₹ 40,500 & it will not be added with material cost
(b) ₹ 40,500 & it will be added with material cost
(c) ₹ 45,000 & it will not be added with material cost
(d) ₹ 45,000 & it will be added with material cost
(iv) What is the total material cost chargeable in the cost sheet of Axe Traders?
(a) ₹ 3,14,000
(b) ₹ 2,73,500
(c) ₹ 2,72,673
(d) ₹ 3,13,874
(v) The number of good units and cost per unit of the materials received are:
(a) 5,000 units & ₹ 62.80
(b) 5,000 units & ₹ 54.70
(c) 4,000 units & ₹ 78.50
(d) 4,000 units & ₹ 68.38
Solution 1 :
(i) (d) Cash discount is received when credit amount is paid within the stipulated period of 30 days. The
amount of cash discount to be received from the supplier is:
Particulars Amount (₹)
A. Listed price 2,50,000
B. Less: Trade Discount @10% (25,000)
C. Taxable value (A-B) 2.25,000
D. Add: GST@18% (18% of C) 40,500
(ii) (b)
Particulars Units (₹)
Listed Price of Materials 5,000 2,50,000
Less: Trade discount @ 10% on invoice price (25,000)
2,25,000
Add: GST @ 18% of ₹ 2,25,000 40,500
2,65,500
Add: Toll Tax 5,000
Freight and Insurance 17,220
Commission and Brokerage Paid 10,000
Add: Cost of returnable containers:
Amount deposited ₹ 30,000
Less: Amount refunded ₹ 20,000 10,000
3,07,720
Add: Other Expenses @ 2% of Total Cost (
3,07,720
×2) 6,280
98
Total cost of material 3,14,000
Less: Shortage material due to normal reasons @ 20% 1,000 -
Total cost of material of good units 4,000 3,14,000
Cost per unit (₹ 3,14,000/4,000 units) 78.5
(iii) (b) Axe Traders is an unregistered supplier in the GST; thus, GST credit is not applicable for it. GST paid on
the purchase of the material will be the part of the material cost.
(iv) (a) Please refer the solution above
(v) (c) Please refer the solution above
(ii)The economic order quantity (EOQ) for both the material A & B:
(a) 13,856 kg & 16,181 kg respectively
(b) 16,197 kg & 17,327 kg respectively
(c) 16,181 kg & 17,165 kg respectively
(iv) Calculate saving/ loss in purchase of Material A if the purchase order quantity is equal to EOQ.
(a) Profit of Rs. 3,21,201.
(b) Loss of Rs. 3,21,201.
(c) Profit of Rs. 2,52,500.
(d) Loss of Rs. 2,52,500.
Solution 2 :
(i) (d) Monthly Production of X = 30,000 kgs.
30,000
Raw Material Required = 3 ×5 = 50,000 kgs.
50,000
Material A = 5
×3 = 30,000 kg.
50,000
Material B = 5
×2 = 20,000 kg.
(iv) (b) Calculation of Savings/ loss in Material A if purchase quantity equals to EOQ.
Purchase Quantity = 15,000 kg. Purchase Quantity = EOQ i.e. 13,856 kg.
3,60,000 kg. 3,60,000 kg.
Annual consumption
(30,000 × 12 months) (30,000 × 12 months)
30 30
No. of orders [Note- (i)]
(3,60,000 ÷ 12,000) (3,60,000 ÷ 12,000)
Ordering Cost (a) ₹36,000 ₹36,000
Labour Costing
Question 3 :(RTP May 2024)
The board of the J Ltd. has been appraised by the General Manager (HR) that the employee attrition rate in the
company has increased. The following facts has been presented by the GM(HR):
(1) Training period of the new recruits is 50,000 hours. During this period their productivity is 60% of the
experienced workers. Time required by an experienced worker is 10 hours per unit.
(2) 20% of the output during training period was defective. Cost of rectification of a defective unit was ₹ 25.
(3) Potential productive hours lost due to delay in recruitment were 1,00,000 hours.
(4) Selling price per unit is ₹ 180 and P/V ratio is 20%.
(5) Settlement cost of the workers leaving the organization was ₹ 1,83,480.
(6) Recruitment cost was ₹ 1,56,340
(7) Training cost was ₹ 1,13,180
You being an associate finance to GM(HR), has been asked the following questions:
(i) How much quantity of output is lost due to labour turnover?
(a) 10,000 units
(b) 8,000 units
(c) 12,000 units
(d) 12,600 units
(ii) How much loss in the form of contribution, the company incurred due to labour turnover?
(a) ₹ 4,32,000
(b) ₹ 4,20,000
(c) ₹ 4,36,000
(d) ₹ 4,28,000
(iv) Calculate the profit lost by the company due to increased labour turnover.
(a) ₹ 7,50,000
(b) ₹ 15,00,000
(c) ₹ 5,00,000
(d) ₹ 9,00,000
(v) How much quantity of output is lost due to inexperience of the new worker?
(a) 1,000 units
(b) 2,600 units
(c) 2,000 units
(d) 12,600 units
Solution 3 :
50,000
(i)(c) Output by experienced workers in 50,000 hours = 10
= 5,000 units
Output by new recruits = 60% of 5,000 = 3,000 units
Loss of output = 5,000 – 3,000 = 2,000 units
Total loss of output = Due to delay recruitment + Due to inexperience
= 10,000 +2,000=12,000 units
50,000
(v) (c) Output by experienced workers in 50,000 hours = 10
= 5,000 units
Output by new recruits = 60% of 5,000 = 3,000 units
Loss of output = 5,000 – 3,000 = 2,000 units
Overhead
Question 4 : (RTP Sept 2024)
The accountant for Brilliant Tools Ltd applies overhead based on machine hours. The budgeted overhead and
machine hours for the year are ₹ 1,30,000 and 8,000 hours, respectively. The actual overhead and machine
hours incurred were ₹ 1,37,500 and 10,000 hours. The cost of goods sold and inventory data compiled for the
year is as follows:
Direct Material ₹ 25,000
Cost of Goods Sold ₹ 2,25,000
Units: WIP 50,000 and Finished Goods 75,000
Solution 4 :
(a) Overabsorbed by ₹ 25,000
Predetermined Overhead Rate = Budgeted Overhead / Budgeted hours
i.e. 130,000 / 8,000 = ₹ 16.25 per hour.
Hence, absorbed overhead = 10,000 X 16.25 = ₹ 1,62,500.
Since actual overhead incurred were ₹ 1,37,500
For a period of first six months of the financial year, following information were extracted from the books:
Actual production overheads ₹ 34,08,000
The above amount is inclusive of the following payments made:
Paid as per court’s order ₹ 4,50,000
Expenses of previous year booked in current year ₹ 1,00,000
Paid to workers for strike period under an award ₹ 4,20,000
Obsolete stores written off ₹ 36,000
Production and sales data for the six months are as under:
Production:
Finished goods 1,10,000 units
Works-in-progress (50% complete in every respect) 80,000 units
Sale:
Finished goods 90,000 units
Machine worked during the period was 3,000 hours.
At the of preparation of revenue budget, it was estimated that a total of
₹ 50,40,000 would be required for budgeted machine hours of 6,000 as production overheads for the entire
year.
During the meeting, a data analytic report revealed that 40% of the over/under-absorption was due to defective
production policies and the balance was attributable to increase in costs.
You were also present at the meeting; the chairperson of the meeting has asked you to be ready with the
followings for the performance appraisal of the departmental heads:
(i) How much was the budgeted machine hour rate used to recover overhead?
(a) ₹ 760
(b) ₹ 820
(c) ₹ 780
(d) ₹ 840
(ii) How much amount of production overhead has been recovered (absorbed) upto the end of half year end?
(a) ₹ 25,20,000
(b) ₹ 34,08,000
(c) ₹ 24,00,000
(d) ₹ 24,60,000
(iv) What is the supplementary rate for apportionment of over/under absorbed overheads over WIP, Finished
goods and Cost of sales?
(a) ₹ 0.315 per unit
(b) ₹ 0.472 per unit
(c) ₹ 0.787 per unit
(d) ₹ 1 per unit
(v) What is the amount of over/under absorbed overhead apportioned to Work in Progress?
(a) ₹ 9,440
(b) ₹ 42,480
(c) ₹ 18,880
(d) ₹ 70,800
Solution 5 :
₹ 50, 40,000
(i) (d) Budgeted Machine hour rate (Blanket rate) = 6,000 ℎ𝑜𝑢𝑟𝑠
= ₹ 840 per hour
(ii) (a) ₹ 25,20,000
(iii) (a)
Amount (₹) Amount (₹)
Total production overheads actually incurred during the period 34,08,000
Less: Amount paid to worker as per court order 4,50,000
Expenses of previous year booked in the current year 1,00,000
Wages paid for the strike period under an award 4,20,000
Obsolete stores written off 36,000 10,06,000
24,02,000
Less: Production overheads absorbed as per machine hour
rate (3,000 hours × ₹ 840*) 25,20,000
Amount of over absorbed production overheads 1,18,000
* Budgeted Machine hour rate (Blanket rate) calculated in part (i)
(iv) (b) Accounting treatment of over absorbed production overheads: As, 40% of the over absorbed
overheads were due to defective production policies, this being abnormal, hence should be credited to Costing
Profit and Loss Account.
Amount to be credited to Costing Profit and Loss Account = ₹ 1,18,000× 40% = ₹ 47,200.
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 = ₹ 1,18,000× 60% = ₹ 70,800
₹ 70,800
Supplementary rate = 1,50,000 𝑢𝑛𝑖𝑡𝑠 = ₹ 0.472 per unit
(v) (c) Apportionment of over absorbed production overheads over WIP, Finished goods and Cost of sales:
Equivalent completed units Amount (₹)
Work-in-Progress 40,000 18,880
(80,000 units × 50% ×0.472)
Finished Goods 20,000 9,440
(20,000 units × 0.472)
Cost of Sales 90,000 42,480
(90,000 units × 0.472)
Total 1,50,000 70,800
Process Costing
Question 6 :(RTP Sept 2024)
The following information is available in respect of Process I: Raw material purchased and introduced 10,000
units @ 5 per unit Raw Material received from store 4000 units @ 6 per unit Direct Labour 40,000 Overheads
28,000 Output of Process is 13,500 units, Normal wastage 5% of inputs Scrap value of wastage 4 per unit The
value of Abnormal Gain is:
(a) ₹ 2062.68
(b) ₹ 2135.34
(c) ₹ 2103.70
(d) ₹ 2093.2
Solution 6 :
(d) ₹ 2093.2
Process a/c
Particulars Units AmountParticulars units Amount
Raw material 10,000 50,000Normal loss 700 2,800
Stores 4,000 24,000Units transferred 13,500 1,41,293.2
Direct Wages 40,000
Production
overheads 28,000
Abnormal gain
200 2,093.2
1,44,093.2 1,44,093.2
1,42,000−2,800
Cost per unit= 14,000−700
= 10.466 per unit
(i). How much quantity of raw material was introduced during the month?
A. 4,300 Litres
B. 3,500 Litres
C. 4,200 Litres
D. 3,800 Litres
(iii). Value of raw material added to the process during the month is:
A. ₹ 10,10,000
B. ₹ 10,33,600
C. ₹ 10,18,400
D. ₹ 10,20,000
C. ₹ 22,44,000
D. ₹ 19,27,200
Solution 7 :
(i).D
Inflow into process Litres Outflow from process Litres
Opening WIP 500 Transferred to finished goods 3,400
Quantity introduced (Balancing figure) 3,800 Total loss 800
Closing WIP 100
4,300 4,300
(ii). A
Total loss 800 litres
Normal loss (10% of fresh input i.e. 3,800) 380 litres
Abnormal loss 420 litres
(iii). B
Calculation of Equivalent production units
Equivalent Production
Input Details Units Output Particulars Units Material Labour Overheads
% Units % Units % Units
Opening WIP 500 From Opening WIP 500 - - 20 100 40 200
Fresh inputs 3,800 From fresh units 2900 100 2900 100 2900 100 2900
Normal loss 380 - - -
Closing WIP 100 100 100 20 20 10 10
Abnormal loss 420 100 420 100 420 100 420
4,300 4,300 3,420 3,440 3,530
(iv). A
Value of labour and overhead in closing Work in process
Cost elements Equivalent units Cost per EU (₹) Total cost (₹)
Labour 20 200 4,000
Overheads 10 160 1,600
(v). C
Value of output transferred to finished goods Output transferred (Units) × Equivalent cost per unit 3,400 Litres
× ₹660 = ₹22,44,000
Cost Sheet
Question 8 :(MTP March 2024)
M Ltd. is producing a single product and may expand into product diversification in the next one to two years.
M Ltd. is amongst a labour-intensive company where the majority of processes are done manually. Employee
cost is a major cost element in the total cost of the company. The company conventionally uses performance
parameters Earnings per manshift (EMS) to measure cost paid to an employee for a shift of 8 hours, and
Output per manshift (OMS) to measure an employee’s output in a shift of 8 hours.
The Chief Manager (Finance) of the company has emailed you few information related to the last month. The
email contains the following data related to the last month:
During the last month, the company has produced 2,34,000 tonnes of output. Expenditures for the last months
are:
(i) Raw materials consumed ₹ 50,00,000
(ii) Power consumed 13,000 Kwh @ ₹ 8 per Kwh to run the machines for production.
(iii)Diesels consumed 2,000 litres @ ₹ 93 per litre to run power generators used as alternative or backup for
power cuts.
(iv) Wages & salary paid – ₹ 6,40,00,000
(v) Gratuity & leave encashment paid – ₹ 64,20,000
(vi) Hiring charges paid for HEMM- ₹ 30,00,000. HEMM are directly used in production.
(vii)Hiring charges paid for cars used for official purpose – ₹ 66,000
(viii)Reimbursement of diesel cost for the cars – ₹ 22,000
(ix) The hiring of cars attracts GST under RCM @5% without credit.
(x) Maintenance cost paid for weighing bridge (used for weighing of final goods at the time of dispatch) – ₹
12,000
(xi) AMC cost of CCTV installed at weighing bridge (used for weighing of final goods at the time of dispatch)
and factory premises is ₹ 8,000 and ₹ 18,000 per month respectively.
(xii) TA/ DA and hotel bill paid for sales manager- ₹ 36,000
(xiii)The company has 1,800 employees who work for 26 days in a month.
(ii).What is the total and per shift cost of production for last month:
A. ₹ 7,87,10,000 and ₹ 336.37 respectively
B. ₹ 7,87,10,000 and ₹ 1,681.84 respectively
C. ₹ 7,87,28,000 and ₹ 1,682.22 respectively
D. ₹ 7,87,28,000 and ₹ 336.44 respectively
(iii).What is the value of administrative cost incurred during the last month:
A. ₹ 92,400
B. ₹ 88,000
C. ₹ 1,48,400
D. ₹ 1,44,000
(iv).What is the value of selling and distribution cost and total cost of sales:
A. ₹ 36,000 & ₹ 7,88,76,400 respectively
B. ₹ 56,000 & ₹ 7,88,76,400 respectively
C. ₹ 36,000 & ₹ 7,88,72,000 respectively
D. ₹ 56,000 & ₹ 7,88,72,000 respectively
(v). What is the value EMS and OMS for the last month:
A. ₹ 1,504.70 & 5 tonnes respectively
B. ₹ 1,367.52 & 5 tonnes respectively
C. ₹ 1,504.70 & 4.37 tonnes respectively
D. ₹ 1,367.52 & 4.37 tonnes respectively
Solution 8 :
(I). D
(ii).C Please refer cost sheet below for cost of production Cost of production per manshift = Cost of
production ÷ Total manshift, ₹ 7,87,28,000 ÷ 46,800 = ₹1,682.22
(iii). A Car hire charges including GST @5%, please refer the cost sheet
(iv). B Selling and distribution cost includes the following:
Maintenance cost for weighing bridge 12,000
AMC cost of CCTV installed at weigh bridge 8,000
TA/ DA & hotel bill of sales manager 36,000
56,000
For Cost of Sale please refer the cost sheet
Workings
Cost Sheet of M Ltd. for the last month
Particulars Amount (₹) Amount (₹)
Materials consumed 50,00,000
Wages & Salary 6,40,00,000
Gratuity & leave encashment 64,20,000 7,04,20,000
Power cost (13,000 kwh × ₹8) 1,04,000
Diesel cost (2,000 ltr × ₹93) 1,86,000 2,90,000
HEMM hiring charges 30,00,000
Prime Cost 7,87,10,000
AMC cost of CCTV installed at factory premises 18,000
Cost of Production/ Cost of Goods Sold 7,87,28,000
Hiring charges of cars 66,000
Reimbursement of diesel cost 22,000
88,000
Add: GST @5% on RCM basis 4,400 92,400
Maintenance cost for weighing bridge 12,000
AMC cost of CCTV installed at weighbridge 8,000 20,000
TA/ DA & hotel bill of sales manager 36,000
Cost of Sales 7,88,76,400
Marginal Costing
Question 9 : (MTP April 2024)
A meeting of the heads of departments of the Arnav Ltd. has been called to review the operating performance
of the company in the last financial year. The head of the production department appraised that during the last
year the company could operate at 70% capacity level but in the coming financial year 95% capacity level can
be achieved if an additional amount of ₹100 Crore on capex and working capital is incurred.
The head of the finance department has presented that during the last financial year the company had a P/V
ratio of 40%, margin of safety and the break-even were ₹50 crore and ₹200 crore respectively.
To reply to the proposal of increasing the production capacity level to 95%, the head of the finance department
has informed that this could be achieved if the selling price and variable cost are reduced by 8% and 5% of
sales respectively. Fixed cost will also increase by ₹20 crore due to increased depreciation on additional
assets. The additional capital will be arranged at a cost of 15% p.a. from a bank.
In the coming financial year, it has been aimed to achieve an additional profit of ₹10 crore over and above the
last year’s profit after adjusting the interest cost on the additional capital.
The following points are required to be calculated on an urgent basis to put the same in the meeting. You
being an assistant to the head of finance, has been asked the followings:
(i).What will be the revised sales for the coming financial year?
A. ₹ 322.22 Crore
B. ₹ 311.11 Crore
C. ₹ 300.00 Crore
D. ₹ 324.24 Crore
(ii). What will be the revised break-even point for the coming financial year?
A. ₹ 222.22 Crore
B. ₹ 252.22 Crore
C. ₹ 244.44 Crore
D. ₹ 255.56 Crore
(iii). What will be the revised margin of safety for the coming financial year?
A. ₹ 100 Crore
B. ₹ 58.89 Crore
C. ₹ 55.56 Crore
D. ₹ 66.66 Crore
(iv).The profit of the last year and for the coming year are:
A. ₹ 50 Crore & ₹95 Crore respectively
B. ₹ 20 Crore & ₹ 65 Crore respectively
C. ₹ 20 Crore & ₹ 30 Crore respectively
D. ₹ 45 Crore & ₹ 66.66 Crore respectively
(v). The total cost of the last year and for the coming year are:
A. ₹ 230 Crore & ₹292.22
B. ₹ 230 Crore & ₹275 Crore
C. ₹ 220 Crore & ₹282.22 Crore
D. ₹ 220 Crore & ₹292.22 Crore
Solution 9 :
𝑅𝑒𝑣𝑖𝑠𝑒𝑑 𝐹𝑖𝑥𝑒𝑑𝐶𝑜𝑠𝑡 + 𝐸𝑥𝑝𝑒𝑐𝑡𝑒𝑑 𝑃𝑟𝑜𝑓𝑖𝑡
(i). A Revised Sale = 𝑃 / 𝑉 𝑅𝑎𝑡𝑖𝑜
= {₹115 + (20+10)} ÷ 45% = ₹ 322.22 crores
𝐹𝑖𝑥𝑒𝑑 𝐶𝑜𝑠𝑡
(ii). D 𝑅𝑒𝑣𝑖𝑠𝑒𝑑 𝐵𝑟𝑒𝑎𝑘 – 𝑒𝑣𝑒𝑛 𝑃𝑜𝑖𝑛𝑡 = 𝑃 / 𝑉 𝑅𝑎𝑡𝑖𝑜 = ₹115 Crore ÷ 45% = ₹255.56 Crore (Refer working notes)
(iii).D Revised Margin of Safety = Revised Sales – Revised Break-even Sales
= ₹ 322.22Crores – ₹ 255.56Crores = ₹ 66.66 Crores.
(iv).C ₹ 20 Crore & ₹30 Crore respectively (Refer working note)
(v). A Total cost in last year = ₹230 Crore
Total cost in coming year = Variable Cost + Fixed Cost Revised sales × 55% + 115 Crore
= ₹ 322.22 Crore × 55% + ₹ 115 Crore = ₹ 292.22 Crore
Working Note
Present Sales and Profit
Total Sales = Break – even Sales + Margin of Safety = ₹ 200 Crores + ₹ 50 Crores = ₹ 250 Crores
P/V Ratio = 40%
Variable Cost = 60% of Sales = ₹ 250 Crores × 60% = ₹ 150 Crores
Fixed Cost = Break – even Sales × P/V Ratio = ₹ 200 Crores × 40% = ₹ 80 Crores
Total Cost = ₹ 150 Crores + ₹ 80 Crores = ₹ 230 Crores
Profit = Total Sales – Total Cost = ₹ 250 Crores – ₹ 230 Crores = ₹ 20 Cores
Standard Costing
Question 10 : (RTP Sept 2024)
ABC Pvt Ltd is engaged in the manufacture of a Product Q. The product has the following standard production
requirements determined by the technical team of the company post satisfactory completion of test run.
Raw Material Z – 2 units @ ₹ 2 per unit
Skilled labour of – 2.5 hours@ ₹ 5 per hour
Fixed Overheads – ₹ 7.5 per unit
The input of Raw material Z has a yield of 80% everytime when infused into production. The actual quantity of
Raw material Z consumed for production during the year was 24,000 units. The Usage variance of Material Z
was 2,000 Favourable. Further the actual amount of material cost for the material consumed amounted to ₹
45,000.
During the said year, the actual working hours were 30,000 for which the labour cost paid by the company
amounted to ₹1,20,000. The idle time variance amounted to 10,000 Adverse.
The actual fixed overheads incurred for the year amounted to ₹ 1,50,000 and the expenditure variance was
₹25,000 Favourable.
In the context of the above, the following needs to be determined:
(i) The Actual output of Product Q produced during the year is:
(a) 10,000 units
(b) 12,500 units
(c) 25,000 units
(d) 15,000 units
(iii)The Standard Hours, Net Actual hours and the idle time are:
(a) Standard Hours – 27,500 Net Actual Hours – 28,000 hours Idle Time – 2,000 hours
(b) Standard Hours – 22,500 Net Actual Hours – 28,500 hours Idle Time – 1,500 hours
(c) Standard Hours – 24,000 Net Actual Hours – 29,000 hours Idle Time – 1,000 hours
(d) Standard Hours – 25,000 hours Net Actual Hours –28,000 hours Idle Time – 2,000 hours
Solution 10:
(i)(a)10,000 units
Usage variance of Material Z = 2,000 F
Usage Variance = SQ x SP – AQ x SP
SP =₹2
AQ = 24,000 units
2 x (SQ – 24,000) = 2,000
2SQ = 50,000
Therefore SQ = 25,000
No of units of Input required per output = 2
Yield of input = 80% = (25000/2) x 80% = 10,000 units.
(ii).What is the amount of fixed overhead volume variance for the month of March 2024:
A. ₹ 9,000 (F)
B. ₹ 9,000 (A)
C. ₹ 21,800 (A)
D. ₹ 11,000 (A)
(iii).What is the amount of fixed overhead expenditure variance for the month of March 2024:
A. ₹ 21,520 (A)
B. ₹ 21,500 (A)
C. ₹ 21,400 (A)
D. ₹ 21,480 (A)
(iv).What is the amount of fixed overhead calendar variance for the month of March 2024:
A. ₹ 5,400 (A)
B. ₹ 5,450 (A)
C. ₹ 5,480 (A)
D. ₹ 5.420 (A)
(v).What is the amount of fixed overhead cost variance for the month of March 2024:
A. ₹ 43,320 (A)
B. ₹ 43,300 (A)
C. ₹ 43,200 (A)
D. ₹ 43,380 (A)
Solution 11 :
(i). D Variable Overhead Cost Variance = Standard Variable Overheads for Production – Actual
Variable Overheads
= ₹ 44,800 – ₹ 55,680 = ₹ 10,880 (A)
(ii). C Fixed Overhead Volume Variance = Absorbed Fixed Overheads – Budgeted Fixed Overheads
= ₹ 87,200 – ₹ 1,09,000 =₹ 21,800 (A)
(iii). A Fixed Overhead Expenditure Variance = Budgeted Fixed Overheads – Actual Fixed Overheads
= ₹ 10.9 × 10,000 units – ₹ 1,30,520 = ₹ 21,520 (A)
(v). A Fixed Overhead Cost Variance = Absorbed Fixed Overheads – Actual Fixed Overheads
= ₹ 87,200 – ₹ 1,30,520= ₹ 43,320 (A)
WORKING NOTE
Fixed Overheads =
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝐹𝑖𝑥𝑒𝑑 𝑂𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠
= 12,00,000÷1,20,000 ₹ 10.00
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑂𝑢𝑡𝑝𝑢𝑡
Fixed Overheads element in Semi-Variable Overheads ₹ 1,08,000
i.e. 60% of ₹ 1,80,000
Fixed Overheads =
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝐹𝑖𝑥𝑒𝑑 𝑂𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠
= ₹ 1,08,000/120,000 ₹ 0.90
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑂𝑢𝑡𝑝𝑢𝑡
Standard Rate of Absorption of Fixed Overheads per unit (₹ 10.00 + ₹ 0.90) ₹ 10.90
Fixed Overheads Absorbed on 8,000 units @ ₹10.90 ₹ 87,200
Budgeted Variable Overheads ₹ 6,00,000
Add: Variable element in Semi-Variable Overheads 40% of ₹ 1,80,000 ₹ 72,000
Total Budgeted Variable Overheads ₹ 6,72,000
Standard Variable Cost per unit
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑉𝑎𝑟𝑖𝑎𝑏𝑙𝑒 𝑂𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 ₹5.60
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑂𝑢𝑡𝑝𝑢𝑡
Standard Variable Overheads for 8,000 units @ ₹5.60 ₹ 44,800
Budgeted Annual Fixed Overheads (₹ 12,00,000 + 60% of ₹ 1,80,000) ₹ 13,08,000
Possible Fixed Overheads
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝐹𝑖𝑥𝑒𝑑 𝑂𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 × 𝐴𝑐𝑡𝑢𝑎𝑙 𝐷𝑎𝑦𝑠 ₹ 1,03,550
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝐷𝑎𝑦𝑠
= 1,09,000/20 days ×19 days
Actual Fixed Overheads (₹ 1,19,000 + 60% of ₹ 19,200) ₹ 1,30,520
Actual Variable Overheads (₹ 48,000 + 40% of ₹ 19,200) ₹ 55,680
Service Costing
Question 12 :(RTP Sept 2024)
A hotel has 200 rooms (120 Deluxe rooms and 80 Premium rooms). The normal occupancy in summer is 80%
and winter 60%. The period of summer and winter is taken as 8 months and 4 months respectively. Assume 30
days in each month. Room rent of Premium room will be double of Deluxe room. Hotel is expecting a profit of
20% on total revenue, total cost for the year is 2,66,11,200. Calculate the room rent to be charged for Premium
room.
(a) ₹ 450 per room day
(b) ₹ 900 per room day
(c) ₹ 380 per room day
(d) ₹ 760 per room day
Solution 12 :
(b) ₹ 900 per room day
Total Revenue (2,66,11,200/80%) = 3,32,64,000
Calculation of Room Days:
Deluxe Premium
Summer 120 rooms x 80% x 30 days x 8 80 rooms x 80% x 30 days x 8
months = 23,040 months = 15,360
Winter 120 rooms x 60% x 30 days x 4 80 rooms x 60% x 30 days x
months = 8,640 4 months = 5,760
Total room days 31,680 21,120
Let’s assume the room rent of Deluxe room be ‘x’
Then rent of Premium room will be ‘2x’
Therefore: 31,680x + 42,240x = 3,32,64,000 , X = 450
Rent of Premium room will be 450 x 2 = ₹ 900 per room day
Solution 13 :
(a) ₹ 0.0017
Cost per rupee of insured value
= Total Cost/ Total Insured Value
= 1.6 cr/920 cr = ₹ 0.0017
Solution 14 :
(b) 1,90,000 units
Units
Sales budget 2,00,000
Add: Closing Inventory (25,000 x 0.6) 15,000
Less: Opening Inventory (25,000)
Production Budget 1,90,000
Mixed MCQs
Question 15 : (MTP March 2024)
The wages budget for the last period was based on a standard repair time of 30 minutes per unit and a
standard wage rate of ₹ 50 per hour. The actual data for the last period are as follows:
Number of units = 30,000 Labour rate variance = 7,500 (A) Labour efficiency variance = Nil
From the information find out the actual rate of wages per unit
A. ₹ 50
B. ₹ 25.50
C. ₹ 50.50
D. ₹ 25.25
Solution 15 :
D. Labour rate variance = Standard time for actual production (SR- AR)
7,500 (A) = (30,000 × 30 minutes/60 minutes) × (50-AR)
AR = (7,50,000 + 7,500)/15,000 = ₹50.50 per hour
Actual wages per unit = 50.50/2 = ₹25.25
Solution 16 :
B
40,00,000−30,00,000
Variable overhead for each % of level of activity = 75−50
= 40,000
Fixed cost = 30,00,000 – (40,000 × 50) = 10,00,000
Total overheads for 60% level of activity
= 10,00,000 + (40,000 × 60) = 34,00,000
Solution 17:
C
Solution 18:
B Actual Overhead – (Actual machine hours × machine hour rate)
5,20,000 – (17040 × 30) = 8,800 under absorbed
Solution 19 :
A Optimum batch size or Economic Batch Quantity (EBQ):
Solution 20 :
A (TT x 60) + [0.50 x (8-TT) x 60] = 420 TT* = 6 hours, Time saved = 8-6 = 2
* TT=Total Time Taken
Solution 21:
C Ordering Cost = 4,00,000/320 = 1,250 , Delivery Cost = 1,35,000/270 = 500
A = 1,250 x 100 + 500 x 70 = 1,60,000
B = 1,250 x 220 + 500 x 200 = 3,75,000
Solution 22 :
B Direct labour : ₹ 45,000
Direct expenses : ₹ 15,000
Direct materials consumed : ₹ 67,500
Prime Cost ₹ 1,27,500
Solution 23 :
A Abnormal gain units = 7600 - [8000 - 800] = 400 Abnormal gain
= [40,000 - (800 x 5)]/ 7200 units x 400 units = 2,000
Solution 24 :
B Total cost = ₹ 5,25,000
Tonnes Km carried = 6,55,000
Unit Cost = ₹ 525000/655000 Km = ₹ 0.801
Solution 1 :
2𝐴𝑂
(i) Economic Order Quantity (EOQ) = 𝐶
Where, A= Annual demand for the material CEE = 1,94,400 Kgs
O = Ordering cost = ₹ 150
C = Carrying cost per unit per annum = 6% of ₹ 300 = 18
2×1,94,400×150
EOQ = 18
= 1,800 Units (Kgs.)
Solution 3 :
Calculation of cost per unit:
Particulars Units (₹)
Listed Price of Materials 5,000 2,50,000
Less: Trade discount @ 10% on invoice price (25,000)
2,25,000
Add: CGST @ 6% of ₹ 2,25,000 13,500
Add: SGST @ 6% of ₹ 2,25,000 13,500
2,52,000
Add: Toll Tax 5,000
Freight and Insurance 17,000
Commission and Brokerage Paid 10,000
Add: Cost of returnable containers:
Amount deposited ₹ 30,000
Less: Amount refunded ₹ 20,000 10,000
2,94,000
Add: Other Expenses @ 2% of Total Cost (
₹2,94,000
×2) 6,000
98
Total cost of material 3,00,000
Less: Shortage material due to normal reasons @ 20% 1,000 -
Total cost of material of good units 4,000 3,00,000
Cost per unit (₹ 3,00,000/4,000 units) 75
Note:
1. GST is payable on net price i.e., listed price less discount.
2. Cash discount is treated as interest and finance charges; hence it is ignored.
3. Demurrage is penalty imposed by the transporter for delay in uploading or off -loading of materials. It
is an abnormal cost and not included.
4. Shortage due to normal reasons should not be deducted from cost to ascertain total cost of good units
Solution 4 :
(i)Economic Order Quantity (E.O.Q)
Solution 5 :
Calculation of cost per unit:
Particulars Units (₹)
Listed Price of Materials 5,000 5,00,000
Less: Trade discount @ 10% on invoice price (50,000)
4,50,000
Add: GST @18% of ₹ 4,50,000 81,000
5,31,000
Add: Toll Tax 1,800
Freight and Insurance 36,000
Commission and Brokerage Paid 10,000
Add: Cost of returnable containers: Amount
deposited ₹ 30,000
Less: Amount refunded ₹ 26,000 4,000
5,82,800
Add: Other Expenses @ 2% of Total Cost 11,894
₹ 5,82,800
( 98
x 2)
Total cost of material 5,94,694
Less: Shortage material due to normal reasons @ -
250
5%
Total cost of material of good units 4,750 5,94,694
Cost per unit (₹ 5,94,694/4,750 units) 125.20
Note:
1. GST is payable on net price i.e., listed price less discount.
2. GST paid on purchase is added with cost as ITC on GST cannot be claimed
3. Cash discount is treated as interest and finance item; hence it is ignored.
4. Demurrage is penalty imposed by the transporter for delay in uploading or off-loading of materials. It is an
abnormal cost and not included.
5. Shortage due to normal reasons should not be deducted from cost to ascertain total cost of good units.
Solution 6 :
(i) Calculation of Economic Order Quantity
2 × 𝐴𝑛𝑛𝑢𝑎𝑙 𝐷𝑒𝑚𝑎𝑛𝑑 × 𝐶𝑎𝑟𝑟𝑦𝑖𝑛𝑔 𝐶𝑜𝑠𝑡 2 × 12.000 𝑈𝑛𝑖𝑡𝑠 × ₹ 1,200
EOQ = 𝐶𝑎𝑟𝑟𝑦𝑖𝑛𝑔 𝐶𝑜𝑠𝑡 𝑝𝑒𝑟 𝑈𝑛𝑖𝑡 𝑝𝑒𝑟 𝑎𝑛𝑛𝑢𝑚
= ₹1,740 × 0.12
= 371 units (Approx)
Solution 7 :
Difference between Minimum lead time Maximum lead time = 4 days
Max. lead time – Min. lead time = 4 days
Or, Max. lead time = Min. lead time + 4 days.............................................................................................. (i)
Average lead time is given as 6 days i.e.
𝑀𝑎𝑥.𝑙𝑒𝑎𝑑 𝑡𝑖𝑚𝑒 +𝑀𝑖𝑛.𝑙𝑒𝑎𝑑 𝑡𝑖𝑚𝑒
2
= 6 days ............................................................................................ (ii)
Putting the value of (i) in (ii),
𝑀𝑖𝑛. 𝑙𝑒𝑎𝑑 𝑡𝑖𝑚𝑒 + 4 𝑑𝑎𝑦𝑠+𝑀𝑖𝑛.𝑙𝑒𝑎𝑑 𝑡𝑖𝑚𝑒
2
= 6 Days
Or, Min. lead time + 4 days + Min. lead time = 12 days
Or, 2 Min. lead time = 8 days
8 𝐷𝑎𝑦𝑠
Or, Minimum lead time = 2 = 4 Days
Putting this Minimum lead time value in (i), we get
Maximum lead time = 4 days + 4 days = 8 days
1,60,000𝑢𝑛𝑖𝑡𝑠
Or, Maximum Consumption per day = 8 𝐷𝑎𝑦𝑠
= 20,000 units
60,000 𝑢𝑛𝑖𝑡𝑠
Or, Minimum Consumption per day = 4 𝐷𝑎𝑦𝑠
= 15,000 units
Solution 1 :
(i) Calculation of standard time and effective hourly rate:
Standard time = Actual hours worked + time saved = 60 +12 = 72 hours
𝑇𝑜𝑡𝑎𝑙 𝑙𝑎𝑏𝑜𝑢𝑟 𝑐𝑜𝑠𝑡 5,280
Effective hourly rate under Halsey premium plan = 𝐴𝑐𝑡𝑢𝑎𝑙 ℎ𝑜𝑢𝑟 𝑤𝑜𝑟𝑘𝑒𝑑 = 60 = ₹ 88
(ii) Calculation of effective rate earnings under Rowan plan:
𝑇𝑖𝑚𝑒 𝑆𝑎𝑣𝑒𝑑
(Rate × Actual hours worked) + Rate × 𝑆𝑡𝑑. 𝑇𝑖𝑚𝑒 × Time taken
12
₹ 80 × 60 hours + ₹ 80 × 72 × 60
₹ 4,800 + 800 = ₹ 5,600
Effective rate per hour = 5,600 ÷ 60 hour = ₹ 93.33
Working Note:
(1)Calculation of labour cost = Factory cost – Material cost – Factory Overhead
= 37,280 – 28,400 – (₹ 60 × 60 hours)
= 37,280 – 28,400 – 3,600 = ₹ 5,280
(2)Calculation of bonus and time saved
Total labour cost = Normal Rate × Actual hours worked + ½ time saved × normal rate
₹ 5,280 = (₹ 80 × 60 hours) + ½ (time saved × ₹ 80)
40 × time saved = ₹ 5,280 – ₹ 4,800
Time saved = (5,280 - 4,800) ÷ 40
Time saved = 12 hours
𝑇𝑖𝑚𝑒 𝑆𝑎𝑣𝑒𝑑
(i) Wages under Halsey Plan (Rate × Actual hours worked) + Rate × 𝑆𝑡𝑑. 𝑡𝑖𝑚𝑒
× time taken
₹ 5,280 = 60 x ₹ 80 + (S* – 60)/2 x ₹ 80
₹ 5,280 = ₹ 4,800 + 40S – 2,400
S = ₹ 2,880/40 = 72 hours
*Standard time
Effective rate of earnings per hour = 5,280/60 = ₹ 88
𝑇𝑖𝑚𝑒 𝑆𝑎𝑣𝑒𝑑
(ii) Wages under Rowan Plan: (Rate × Actual hours worked) + Rate × 𝑆𝑡𝑑. 𝑇𝑖𝑚𝑒
× taken
72−60
= 60 x 80 + 72
x 60 x 80 = ₹ 5,600
Effective rate of earnings per hour = 5,600/60 = ₹ 93.33
Solution 2 :
𝑁𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠 𝑟𝑒𝑝𝑙𝑎𝑐𝑒𝑑
Labour Turnover Rate (Replacement method) = 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑛𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠
8 36
Or, 100
= 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑁𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠
Or, Average No. of workers = 450
𝑁𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠 𝑠𝑒𝑝𝑎𝑟𝑎𝑡𝑒𝑑
Labour Turnover Rate (Separation method) = 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑁𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠
6 𝑁𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠 𝑠𝑒𝑝𝑎𝑟𝑎𝑡𝑒𝑑
Or, 100
= 450
Or, No. of workers separated = 27
𝑁𝑜. 𝑜𝑓 𝑆𝑒𝑝𝑎𝑟𝑎𝑡𝑖𝑜𝑛𝑠 + 𝑁𝑜. 𝑜𝑓 𝑎𝑐𝑐𝑒𝑠𝑠𝑖𝑜𝑛 (𝐽𝑜𝑖𝑛𝑖𝑛𝑔𝑠)
Labour Turnover Rate (Flux Method) = 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑁𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠
14 27+ 𝑁𝑜. 𝑜𝑓 𝑎𝑐𝑐𝑒𝑠𝑠𝑖𝑜𝑛𝑠 (𝐽𝑜𝑖𝑛𝑖𝑛𝑔𝑠)
Or, 100
= 450
Or, 100 (27 + No. of Accessions) = 6,300
Or, No. of Accessions = 36
(i) The No. of workers recruited and Joined = 36
(ii) The No. of workers left and discharged = 27
Solution 4 :
50,000
Output by experienced workers in 50,000 hours = 10 = 5,000 units
Output by new recruits = 60% of 5,000 = 3,000 units
Loss of output = 5,000 – 3,000 = 2,000 units
Total loss of output = Due to delay recruitment + Due to inexperience
= 10,000 + 2,000 = 12,000 units
Contribution per unit = 20% of ₹180 = ₹ 36
Solution 5 :
(i) Labour Turnover Rate (Separation method)
𝑁𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠 𝑠𝑒𝑝𝑎𝑟𝑎𝑡𝑒𝑑
= 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑛𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠 𝑜𝑛 𝑟𝑜𝑙𝑙
5 40
Or, 100
= 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑛𝑜. 𝑜𝑓 𝑤𝑜𝑟𝑘𝑒𝑟𝑠 𝑜𝑛 𝑟𝑜𝑙𝑙
Or, Average no. of workers on roll = 800
Solution 6 :
(i) Computation of wages of each worker under guaranteed hourly rate basis
Worker Actual hours worked (Hours) Hourly wage rate (₹) Wages (₹)
I 380 40 15,200
II 100 50 5,000
III 540 60 32,400
(ii) Computation of Wages of each worker under piece work earning basis
Product Piece rate per Worker-I Worker-II Worker-III
unit
(₹) Units Wages (₹) Units Wages (₹) Units Wages (₹)
X 15 210 3,150 - - 600 9,000
Y 20 360 7,200 - - 1,350 27,000
Z 30 460 13,800 250 7,500 - -
Total 24,150 7,500 36,000
Since each worker’s earnings are more than 50% of basic pay. Therefore, worker-I, II and III will be paid the
wages as computed i.e. ₹24,150, ₹7,500 and ₹36,000 respectively.
Working Notes:
1. Piece rate per unit
Product Standard time per unit in minute Piece rate each minute (₹) Piece rate per unit (₹)
X 15 1 15
Y 20 1 20
Z 30 1 30
(iii) Computation of wages of each worker under Premium bonus basis (where each worker receives bonus
based on Rowan Scheme)
Worker Time Time Time Wage Rate Earnings (₹) Bonus (₹)* Total Earning
Allowed (Hr.) Taken saved per hour (₹) (₹)
(Hr.) (Hr.)
I 402.5 380 22.5 40 15,200 850 16,050
II 125 100 25 50 5,000 1,000 6,000
III 600 540 60 60 32,400 3,240 35,640
𝑇𝑖𝑚𝑒 𝑇𝑎𝑘𝑒𝑛
* 𝑇𝑖𝑚𝑒 𝐴𝑙𝑙𝑜𝑤𝑒𝑑
x Time Saved x WageRate
380
Worker-I = 402.5
x 22.5 x 40 = 850
100
Worker-II = 125 x 25 x 50 = 1,000
540
Worker-III = 600 x 60 x 60 = 3,240
Solution 7 :
Let T hours be the total time worked in hours by the skilled worker (machine-man Sam); ₹ 30/- is the rate per
hour; standard time is 4 hours per unit and effective hourly earning rate is ₹ 37.50 then
𝑇𝑖𝑚𝑒 𝑠𝑎𝑣𝑒𝑑
Earning = Hours worked × Rate per hour + 𝑇𝑖𝑚𝑒 𝑎𝑙𝑙𝑜𝑤𝑒𝑑
× Time taken × Rate per hour
(Under Rowan incentive plan)
(4 − 𝑇)
₹ 37.5 T = (T × ₹ 30) + 4 × T × ₹ 30
₹ 37.5 = ₹ 30 + (4 – T) × ₹ 7.5
Or ₹ 7.5 T = ₹ 22.5
Or T= 3 hours
Total earnings and effective hourly rate of skilled worker (machine man Sam) under Halsey Incentive
Scheme (50%)
Total earnings = (Hours worked × Rate per hour) + (½ Time saved × Rate per hour)
(under 50% Halsey Incentive Scheme)
= (3 hours × ₹ 30) + (½ × 1 hour × ₹ 30)
Solution 8 :
(i) Effective hourly rate of earnings under Rowan Incentive Plan
𝑇𝑖𝑚𝑒 𝑆𝑎𝑣𝑒𝑑
Earnings under Rowan Incentive plan = (Actual time taken × wage rate) + 𝑇𝑖𝑚𝑒 𝐴𝑙𝑙𝑜𝑤𝑒𝑑
× Time taken × Wage rate
= (5 hours × ₹ 120) + ( 1 ℎ𝑜𝑢𝑟
6 ℎ𝑜𝑢𝑟 )
𝑋 5 ℎ𝑜𝑢𝑟𝑠 𝑋 ₹ 120 = ₹ 600 + ₹ 100 = ₹ 700
Effective hourly rate = ₹ 700/5 hours = ₹ 140 /hour
(ii) Let time taken = X
𝐸𝑎𝑟𝑛𝑖𝑛𝑔𝑠 𝑢𝑛𝑑𝑒𝑟 𝐻𝑎𝑙𝑠𝑎𝑦 𝑆𝑐ℎ𝑒𝑚𝑒
Effective hourly rate = 𝑇𝑖𝑚𝑒 𝑇𝑎𝑘𝑒𝑛
(𝑇𝑖𝑚𝑒 𝑡𝑎𝑘𝑒𝑛 𝑋 𝑅𝑎𝑡𝑒) + 50% 𝑜𝑓 𝑅𝑎𝑡𝑒 𝑋 (𝑇𝑖𝑚𝑒 𝑎𝑙𝑙𝑜𝑤𝑒𝑑 −𝑇𝑖𝑚𝑒 𝑡𝑎𝑘𝑒𝑛)
Or, Effective hourly rate under Halsey Incentive plan = 𝑇𝑖𝑚𝑒𝑇𝑎𝑘𝑒𝑛
Solution 1 :
(i) Overhead Distribution Statement
Particular Basis Total Production Service Departments
Amount Departments
(₹) P (₹) Q (₹) R (₹) S (₹)
Indirect material Direct 1,77,500 94,750 49,750 18,270 14,730
Indirect labour Direct 1,55,000 35,000 75,000 15,000 30,000
Factory rent (125:75:20:30) Floor Area 75,000 37,500 22,500 6,000 9,000
Depreciation of machinery Book value of 37,500 26,250 6,250 1,250 3,750
(21:5:1:3) machinery
Power (80:20:8:12) H.P. of 96,000 64,000 16,000 6,400 9,600
machines
Security expenses for factory Floor Area 24,000 12,000 7,200 1,920 2,880
premises (125:75:20:30)
Insurance- machinery (21:5:1:3) Book value of 12,000 8,400 2,000 400 1,200
machinery
Supervisor expenses (10:30:6:4) Number of 48,000 9,600 28,800 5,760 3,840
employees
Total 6,25,000 2,87,500 2,07,500 55,000 75,000
(ii) Redistribution of Service Department’s Expenses
Particular Production Departments Service Departments
P (₹) Q (₹) R (₹) S (₹)
Overhead as per primary distribution 2,87,500 2,07,500 55,000 75,000
Expenses of service department R is 12,500 37,500 (55,000) 5,000
apportioned among other
The solution 3(a) can also be presented in following way for Distribution of Power expenses:
Overhead Distribution Statement
Particular Basis Total Amount Production Service
(₹) Departments Departments
P (₹) Q (₹) R (₹) S (₹)
Indirect material Direct 1,77,500 94,750 49,750 18,270 14,730
Indirect labour Direct 1,55,000 35,000 75,000 15,000 30,000
Factory rent (125:75:20:30) Floor Area 75,000 37,500 22,500 6,000 9,000
Depreciation of machinery Book value 37,500 26,250 6,250 1,250 3,750
(21:5:1:3) of machinery
Power (3200:200:48:96) H.P. x 96,000 86,682 5,418 1,300 2,600
machine
hours
Security expenses for factory Floor Area 24,000 12,000 7,200 1,920 2,880
premises (125:75:20:30)
Insurance- machinery (21:5:1:3) Book value 12,000 8,400 2,000 400 1,200
of machinery
Supervisor expenses (10:30:6:4) Number of 48,000 9,600 28,800 5,760 3,840
employees
Total 6,25,000 3,10,182 1,96,918 49,900 68,000
Power can be distributed on the basis of HP of machines x machine hours
800 x 4000 = 32,00,000, 200 x 1000 = 2,00,000, 80 x 600 = 48,000, 120 x 800 = 96,000
Ratio is 3200:200:48:96
Solution 2 :
Effective machine hours = 200 hours × 75% = 150 hours
Computation of Comprehensive Machine Hour Rate
Per month Per hour
(₹) (₹)
Fixed cost
Supervision charges 18,000.00
Electricity and lighting 9,500.00
Insurance of Plant and building (₹ 18,000 ÷12) 1,500.00
Other General Expenses (₹ 18,000÷12) 1,500.00
Depreciation (₹ 1,29,600÷12) 10,800.00
41,300.00 275.33
Direct Cost
Repairs and maintenance 17,500.00 116.67
Power 1,30,000.00 866.67
Wages of machine man 196.00
Wages of Helper 136.00
Machine Hour rate (Comprehensive) 1,590.67
Solution 3 :
(a) Effective machine hours = 200 hours × 75% = 150 hours
Computation of Comprehensive Machine Hour Rate
Per month (`) Per hour (`)
Fixed cost
Supervision charges 18,000.00
Electricity and lighting 9,500.00
Insurance of Plant and building (`18,250 ÷12) 1,520.83
Other General Expenses (`17,500÷12) 1,458.33
Depreciation (`64,800÷12) 5,400.00
35,879.16 239.19
Direct Cost
Repairs and maintenance 17,500.00 116.67
Power 65,000.00 433.33
Wages of machine man 139.27
Wages of Helper 109.41
Machine Hour rate (Comprehensive) 1,037.87
● Actual production overheads incurred were ₹4,50,000 which included ₹42,000 on account of ‘written
off’ obsolete stores.
● 18,000 units were produced during the year out of which 10,000 units were sold and 8,000 units of
finished goods were in stock.
● There were also 5,000 units in progress which may be reckoned as 40% complete.
● The actual machine hours worked during the period were 43,000.
ABC Ltd. absorbs the production overheads at a predetermined rate of ₹8 per machine hour.
On investigation, it has been found that 20% of the under-absorption of production overheads was due to
defective planning and the rest was attributable to normal increase in costs of indirect materials and indirect
labour.
You are required to:
(i) Calculate the amount of under-absorption of production overheads during the year 2023-24; and
(ii) Show the treatment of under-absorption of production overheads in cost accounts.
(The foreman and the attendant control all the three machines and spend equal time on them.)
The following additional information is also available:
Machines
P Q R
Estimated Direct Labour Hours 1,00,000 1,50,000 1,50,000
Ratio of K.W. Rating 3 2 3
Floor space (sq. ft.) 40,000 40,000 20,000
There are 14 holidays besides Sundays in the year, of which two were on Saturdays. The manufacturing
department works 8 hours a day but Saturdays are half days. All machines work at 85% capacity throughout
the year and 2% is reasonable for breakdown.
You are required to :
CALCULATE predetermined machine hour rates for the above machines after taking into consideration the
following factors:
● An increase of 15% in the price of spare parts.
● An increase of 25% in the consumption of spare parts for machine ‘Q’ & ‘R’ only.
● 20% general increase in wages rates.
● A 10% decrease in the consumption of consumable stores.
Solution 5 :
Computation of Machine Hour Rate
Basis of Total Machines
apportionment P Q R
(₹) (₹) (₹) (₹)
(A) Standing Charges
Insurance Depreciation Basis 8,000 3,000 3,000 2,000
Working Notes:
(i) Calculation of effective working hours:
No. of holidays 52 (Sundays) + 14 (other holidays) = 66
Saturday (52 – 2) = 50
No. of days (Work full time) = 365 – 66 – 50 = 249
Hours
Full days work 249 x 8 = 1,992
Half days work 50 x 4 = 200
2,192
Hours
Effective capacity 85% of 2,192 1,863 (Rounded off)
Less: Normal loss of time (Breakdown) 2% 37 (Rounded off)
Effective running hour 1,826
(v) Interest on capital outlay is a financial matter and, therefore it has been excluded from the cost accounts.
Solution 6 :
Job Cost Sheet for the period…..
₹
Direct materials 2,13,000
Direct wages:
Machine shop 63,000
Assembly shop 48,000 1,11,000
Prime Cost 3,24,000
Works overhead:
Machine shop 88,200
Assembly shop 51,800 1,40,000
Work Cost 4,64,000
Administration overhead 92,800
Cost of Production 5,56,800
Selling overhead 81,000
Distribution overhead 62,100
Total Cost 6,99,900
92,800
(ii) Administrative Overhead as a % of works cost = 4,64,000
x 100 = 20%
81,000 + 62,100
(iii) Selling and distribution overhead as % of works cost = 4,64,000
x 100 = 30.84%
Labour hour rates are calculated as under:
Machine shop = ₹ 63,000 ÷ 12,000 hrs. = ₹ 5.25
Assembly shop = ₹ 48,000÷10,000 hrs. = ₹ 4.80
Solution 7 :
Working Notes:
(i) Total Productive hours = Estimated Working hours – Machine Maintenance hours
= 2,200 hours – 200 hours = 2,000 hours
10,00,000 −10,000
(ii) Depreciation per annum = 10
= ₹ 99,000
(iii) Chemical solution cost per annum = ₹ 2,000 × 50 weeks = ₹ 1,00,000
9,000 × 50 𝑤𝑒𝑒𝑘𝑠
(iv) Wages of attendants (per annum) = 6 𝑚𝑎𝑐ℎ𝑖𝑛𝑒𝑠 = ₹ 75,000
Calculation of Machine hour rate
Particulars Amount (per annum) Amount (per hour)
A. Standing Charge
(i)Wages of attendants 75,000
(ii)Departmental and general works overheads 20,000
Total Standing Charge 95,000
Standing Charges per hour 47.50
B. Machine Expense
(iii) Depreciation 99,000 49.50
(iv) Electricity (7 × 1,900 × 16 units) ÷ 2,000 - 106.40
(v)Chemical solution 1,00,000 50.00
(vi) Maintenance cost 1,20,000 60.00
Machine operating cost per hour (A + B) 313.40
(i) The original cost of the machine used (Purchased in June 2023) was ₹ 10,000. Its estimated life is 10
years, the estimated scrap value at the end of its life is ₹ 1,000, and the estimated working time per year (50
weeks of 44 hours) is 2,200 hours of which machine maintenance etc., is estimated to take up 200 hours.
No other loss of working time expected. Setting up time, estimated at 100 hours, is regarded as productive
time. (Holiday to be ignored).
(ii) Electricity used by the machine during production is 16 units per hour at cost of a 9 paisa per unit. No
current is taken during maintenance or setting up.
(iii) The machine required a chemical solution which is replaced at the end of week at a cost of ₹ 20 each
time.
(iv) The estimated cost of maintenance per year is ₹ 1,800.
(v) Two attendants control the operation of machine together with five other identical machines. Their
combined weekly wages, insurance and the employer's contribution to holiday pay amount ₹ 120.
(vi) Departmental and general works overhead allocated to this machine for the current year amount to ₹
3,000.
You are required to CALCULATE the machine hour rate of operating the machine.
Solution 8 :
Working Notes:
(i) Total Productive hours = Estimated Working hours – Machine Maintenance hours
= 2,200 hours – 200 hours = 2,000 hours
₹10,000−₹1,000
(ii) Depreciation per annum = 10 𝑦𝑒𝑎𝑟𝑠 = ₹ 900
(iii) Chemical solution cost per annum = ₹ 20 × 50 weeks = ₹ 1,000
₹120 × 50 𝑤𝑒𝑒𝑘𝑠
(iv) Wages of attendants (per annum) = 6 𝑚𝑎𝑐ℎ𝑖𝑛𝑒𝑠 = ₹ 1,000
(b) As the machinery is used to a varying degree in different departments, the use of departmental rates is
to be preferred. The overhead recovery rates in different departments would be as follows:
(i) Operating Department: The use of machine hours is the predominant factor of production in
Operating Department. Hence, machine hour rate should be used to recover overheads.
The overhead recovery rate based on machine hours would be calculated as follows:
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑓𝑎𝑐𝑡𝑜𝑟𝑦 𝑜𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 ₹35,64,000
Machine hour rate = 𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑚𝑎𝑐ℎ𝑖𝑛𝑒 ℎ𝑜𝑢𝑟𝑠 = 7,92,000 = ₹ 4.50 per hour
(ii) Assembly Department: Direct labour hours is the main factor of production in Assembly
Department. Hence, direct labour hour rate should be used to recover overheads.
The overhead recovery rate based on direct labour hours would be calculated as follows:
Budgeted factory Overheads
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑓𝑎𝑐𝑡𝑜𝑟𝑦 𝑜𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 ₹9,66,000
Direct labour hour rate = 𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑑𝑖𝑟𝑒𝑐𝑡 𝑙𝑎𝑏𝑜𝑢𝑟 ℎ𝑜𝑢𝑟𝑠 = 6,90,000 = ₹ 1.40 per hour
(iii) Quality Control Department: Direct labour hours is the main factor of production in Quality Control
Department. Hence, direct labour hour rate should be used to recover overheads.
The overhead recovery rate based on direct labour hours would be calculated as follows:
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑓𝑎𝑐𝑡𝑜𝑟𝑦 𝑜𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 ₹4,20,000
Direct labour hour rate = 𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑑𝑖𝑟𝑒𝑐𝑡 𝑙𝑎𝑏𝑜𝑢𝑟 ℎ𝑜𝑢𝑟𝑠 = 3,00,000 = ₹ 1.40 per hour
(iv) Packing Department: Direct labour hours is the main factor of production in Packing Department.
Hence, direct labour hour rate should be used to recover overheads.
The overhead recovery rate based on direct labour hours would be calculated as follows:
𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑓𝑎𝑐𝑡𝑜𝑟𝑦 𝑜𝑣𝑒𝑟ℎ𝑒𝑎𝑑𝑠 ₹12,37,500
Direct labour hour rate = 𝐵𝑢𝑑𝑔𝑒𝑡𝑒𝑑 𝑑𝑖𝑟𝑒𝑐𝑡 𝑙𝑎𝑏𝑜𝑢𝑟 ℎ𝑜𝑢𝑟𝑠 = 4,95,000 = ₹ 2.50 per hour
Working note:
Overhead Statement
Department Basis Hours Rate (₹) Overheads
(₹)
Operating Machine hour 1,782 4.50 8,019
Assembly Direct labour hour 828 1.40 1,159
Quality Control Direct labour hour 360 1.40 504
Packing Direct labour hour 396 2.50 990
Total 10,672
The management wishes to introduce activity-based method (ABC) system of attributing production
overheads to products and has identified major cost pools for production overheads and their associated cost
drivers as follows:
Cost pool Amount Cost driver
Purchasing Department Cost ₹ 7,00,000 Number of Purchase orders
Machine setup Cost ₹ 9,00,000 Number of Machine setups
Quality Control Cost ₹ 6,56,000 Number of inspections
Machining Cost ₹ 5,64,000 Machine hours
Required:
(i) Calculate the total cost per unit and selling price per unit for each of the three products using:
(a) The traditional costing approach currently used by JH Plastics Limited;
(b) Activity based costing (ABC) approach.
(ii) Calculate the difference in selling price per unit as per (a) and (b) above and show which product is
under-priced or over-priced.
Solution 1 :
(i) (a) Statement showing ‘Cost per unit & Selling price per unit – Traditional Method’.
Particular Products
S (₹) M (₹) L (₹)
Direct material cost per unit 158 179 250
Direct labour cost per unit 40 45 60
Production overhead @ ₹ 240 per 72 96 120
machine hour (₹ 240 x 0.3) (₹ 240 x 0.4) (₹ 240 x 0.5)
Cost per unit 270 320 430
Add: Profit @ 40% 108 128 172
Selling price per unit 378 448 602
(b) Statement showing ‘Cost per unit & Selling price per unit – Activity Based Costing’.
Particular Activity Drivers Total Products
Amount S M L
(₹)
Production (units) - - 7500 12500 9000
Machine hours - - 2250 5000 4500
(7500 x 0.3) (12500 x 0.4) (9000 x 0.5)
(₹) (₹) (₹)
Direct material cost per 158 179 250
unit (i)
Direct labour cost per 40 45 60
unit (ii)
Overheads
Now, Green-lush Ltd. is considering adopting an Activity Based Costing system. For this, additional information
regarding budgeted overheads and their cost drivers is provided below:
Particulars (₹) Cost drivers
Forklifting cost 58,000 Weight of material lifted
Supervising cost 60,000 Direct labour hours
Utility cost 80,000 Number of Machine operations
The number of machine operators per unit of production are 5, 5, and 6 for SOFTHUG- Gold, SOFTHUG- Pearl,
and SOFTHUG- Diamond respectively.
(Consider (i) Mass of 1 litre of Essential Oils and Filtered Water equivalent to 0.8 kg and 1 kg respectively (ii)
Mass of output produced is equivalent to the mass of input materials taken together.)
Solution 2 :
(i) Traditional Absorption Costing
SOFTHUG- Gold SOFTHUG - SOFTHUG - Diamond Total
Pearl
(a) Production of soaps (Units) 4,000 3,0002,000 9,000
(b) Direct labour (minutes) 30 40 60 -
(c) Direct labour hours 2,000 2,0002,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
Unit Costs:
SOFTHUG-Gold (₹) SOFTHUG-Pearl (₹) SOFTHUG-Diamond (₹)
Direct Costs:
- Direct Labour 5.00 (
10×30
60
6.67 )
10×40
60
10×60
10.00 ( 60 )( )
- Direct Material 167.50 215.50 248.50
(Refer working note 1)
Production Overhead: 16.50 ( 33×30
60 ) 22.00 ( 33×40
60 ) 33.00 ( 33×60
60 )
Total unit costs 189.00 244.17 291.50
Number of units 4,000 3,000 2,000
Total costs 7,56,000 7,32,510 5,83,000
Working note -1
Calculation of Direct material cost
SOFTHUG- Gold SOFTHUG- Pearl (₹) SOFTHUG- Diamond (₹)
(₹)
120.00 165.00 195.00
Essential oils 200×60
( 300×55
100 ) 300×65
( 100 ) ( 100 )
40.00 40.00 40.00
Cocoa Butter
( 200×20
100 ) ( 200×20
100 ) ( 200×20
100 )
Filtered water 4.50 4.50 4.50
Chemicals
( 15×30
100 ) ( 15×30
100 ) ( 15×30
100 )
3.00 6.00 9.00
( 30×10
100 ) ( 50×12
100 ) ( 60×15
100 )
Total costs 167.50 215.50 248.50
Supervising rate per direct labour hour = ₹ 60,000 ¸ 6,000 hours = ₹ 10 per labour hour
Utilities rate per machine operations = ₹ 80,000 ¸ 47,000 machine operations
Solution 4 :
(i) PCP Limited’s
Statement of operating income and gross margin percentage
for each of its supermarket segments
Particulars Supermarket A Supermarket B Total
Revenues: (₹) 11,21,67,000 9,52,87,500 20,74,54,500
(660 × ₹ 1,69,950) (1,650 × ₹57,750)
Less: Cost of goods sold: (₹) 10,89,00,000 9,07,50,000 19,96,50,000
(660 × ₹ 1,65,000) (1650 × ₹ 55,000)
Gross Margin: (₹) 32,67,000 45,37,500 78,04,500
Less: Other operating costs: (₹) 16,55,995
Operating income: (₹) 61,48,505
Gross Margin 2.91% 4.76 % 3.76%
Operating income % 2.96%
The bank budgets a volume of 58,600 deposit accounts, 13,000 loan accounts, and 14,000 Credit Card
Accounts.
Required:
(i) Calculate the budgeted rate for each activity.
(ii) Prepare the budgeted cost statement activity wise.
(iii) Compute the budgeted product cost per account for each product using (i) and (ii) above.
Solution 5 :
Statement Showing “Budgeted Cost per unit of the Product”
Activity Activity Cost Activity Driver No. of Activity Deposits Loans Credit
(Budgeted) Units of Rate (₹) Cards
(₹) Activity
Driver
(Budget)
ATM Services 8,00,000No. of ATM 2,00,000 4.00 6,00,000 --- 2,00,000
Transaction
Computer 10,00,000No. of Computer 20,00,000 0.50 7,50,000 1,00,000 1,50,000
Processing processing
Transaction
Issuing 20,00,000No. of Statements 5,00,000 4.00 14,00,000 2,00,000 4,00,000
Statements
Customer 3,60,000Telephone 7,20,000 0.50 1,80,000 90,000 90,000
Inquiries Minutes
Budgeted 41,60,000 29,30,000 3,90,000 8,40,000
Cost
Units of Product (as estimated in the budget period) 58,600 13,000 14,000
Budgeted Cost per unit of the product 50 30 60
Working Note
Activity Budgeted Cost Remark
(₹)
ATM Services:
(a) Machine Maintenance 4,00,000−All fixed, no change.
(b) Rents 2,00,000−Fully fixed, no change.
(c) Currency Replenishment Cost 2,00,000−Doubled during budget period.
Total 8,00,000
Computer Processing 2,50,000−₹ 2,50,000 (half of ₹5,00,000) is
fixed and no change is expected.
7,50,000 −₹ 2,50,000 (variable portion) is expected to
Total 10,00,000 increase to three times the current level.
Issuing Statements 18,00,000−Existing.
2,00,000−2 lakh statements are expected to
Total 20,00,000 be increased in budgeted period. For every
increase of one lakh statement, one lakh
rupees is the budgeted increase.
Computer Inquiries 3,60,000 - Estimated to increase by 80% during the
. budget period.
Total 3,60,000 (₹2,00,000 × 180%)
Solution 6 :
Profit Statement using Activity based costing (ABC) method:
Particulars Product Total
A B C
A. Sales Quantity 1,00,000 80,000 60,000
B. Selling price per unit (₹) 90 180 140
C. Sales Value (₹) [A×B] 90,00,000 1,44,00,000 84,00,000 3,18,00,000
D. Direct cost per unit (₹) 50 90 95
E. Direct Cost (₹) [A×D] 50,00,000 72,00,000 57,00,000 1,79,00,000
F. Overheads:
(Refer working note-3)
(i) Machining services (₹) 21,00,000 22,40,000 21,00,000 64,40,000
(ii) Assembly services (₹) 24,00,000 12,80,000 7,20,000 44,00,000
(iii) Set-up costs (₹) 4,50,000 3,00,000 1,50,000 9,00,000
(iv) Order processing (₹) 2,20,000 2,40,000 2,60,000 7,20,000
(v) Purchasing (₹) 1,50,000 1,75,000 75,000 4,00,000
G. Total Cost (₹) [E+F] 1,03,20,000 1,14,35,000 90,05,000 3,07,60,000
H. Profit (₹) (C-G) (13,20,000) 29,65,000 (6,05,000) 10,40,000
Working Notes: 1.
Products
A B C Total
A. Production (units) 1,00,000 80,000 60,000
B. Machine hours per unit 3 4 5
C. Total Machine hours [A×B] 3,00,000 3,20,000 3,00,000 9,20,000
D. Rate per hour (₹) 8 8 8
E. Machine Dept. cost [C×D] 24,00,000 25,60,000 24,00,000 73,60,000
F. Labour hours per unit 6 4 3
G. Total labour hours [A×F] 6,00,000 3,20,000 1,80,000 11,00,000
H. Rate per hour (₹) 5 5 5
I. Assembly Dept. cost [G×H] 30,00,000 16,00,000 9,00,000 55,00,000
₹73,60,000
Machine hour rate = 9,20,000ℎ𝑜𝑢𝑟𝑠
= ₹8
₹55,00,000
Labour hour rate = 11,00,000ℎ𝑜𝑢𝑟𝑠
= ₹5
Solution 7 :
(i) Statement of cost allocation to each product from each activity
Product
A (₹) B (₹) C (₹) Total (₹)
Power 10,00,000 20,00,000 15,00,000 45,00,000
(Refer to working
note)
(10,000 kWh ×₹ 100) (20,000 kWh × ₹ 100) (15,000 kWh × ₹ 100)
Quality 31,50,000 22,50,000 27,00,000 81,00,000
P Q R
Units produced and sold 15,000 12,000 18,000
Machine hours worked 30,000 hrs. 48,000 hrs. 54,000 hrs.
Assembly hours worked (direct labour hours) 15,000 hrs. - 27,000 hrs.
Customers’ orders executed (in numbers) 1,250 1,000 1,500
Number of requisitions raised on the stores 40 30 50
Prepare a statement showing details of overhead costs allocated to each product type using activity-based
costing.
Solution 8 :
Calculation of “Activity Rate”
Cost (₹) Cost Driver Cost
Cost Pool Driver
[A] [B] Rate (₹)
Machine Department Expenses 18,48,000Machine Hours (1,32,000 hrs.) 14.00
Assembly Department Expenses 6,72,000Assembly Hours (42,000 hrs.) 16.00
Setup Cost 90,000No. of Production Runs (450*) 200.00
Stores Receiving Cost 1,20,000No.of RequisitionsRaised on the Stores (120) 1,000.00
Order Processing and Dispatch 1,80,000No. of Customers Orders Executed (3,750) 48.00
Inspection &Quality Control Cost 36,000No. of Production Runs (450*) 80.00
Total (₹) 29,46,000
*Number of Production Run is 450 (150 + 120 + 180)
Statement Showing “Overheads Allocation”
Solution 9 :
Working note:
1. Computation of revenues (at listed price), discount, cost of goods sold and customer level operating
activities costs:
Customers
A B C D E
Units sold: (a) 4,500 6,000 9,500 7,500 12,750
Revenues (at listed price) (₹): 2,91,60,000 3,88,80,000 6,15,60,000 4,86,00,000 8,26,20,000
(b)
{(a) ×₹6,480)}
Revenues (at listed price) (₹): 2,91,60,000 3,82,32,000 5,64,30,000 4,69,80,000 7,43,58,000
© {(a) ×Actual selling price)} (4,500 × (6,000 × 6,372) (9,500 × (7,500 × (12,750 ×
6,480) 5,940) 6,264) 5,832)
Discount (₹) (d) 0 6,48,000 51,30,000 16,20,000 82,62,000
{(b) – (c)}
Cost of goods sold (₹) : (e) {(a) 2,43,00,000 3,24,00,000 5,13,00,000 4,05,00,000 6,88,50,000
x ₹5,400}
Solution 10 :
1. Estimation of cost-driver rate
Activity Overhead cost (₹) Cost driver Cost driver rate (₹)
Packaging 1,50,00,000 950 Packaging hours 15,789.47
Fridge 2,10,00,000 1,900 Fridge hours 11,052.63
Solution 1 :
Cost Sheet for the product BXE
Sl. Particulars (₹) (₹)
No.
(i) Material Consumed:
Raw materials purchased 2,48,00,000
Freight inwards 7,50,000
Insurance on material procured 15,000
Less: Trade discount (4,50,000)
Add: Opening stock of raw materials 27,00,000
Less: Closing stock of raw materials (32,60,000) 2,45,55,000
(ii) Direct wages 42,00,000
(iii) Direct expenses:
Power & fuel 18,75,000
Cost of special drawings 3,60,000 22,35,000
Prime Cost 3,09,90,000
(iv) Works/ Factory overheads:
Rent of factory building (4/5th of 7,00,000) 5,60,000
Depreciation on machinery 6,25,000
Solution 2 :
Since 10% units are scrapped.
Units produced (total) is 14,000 (12,600/90%)
Calculation of cost of sales and profit
Particulars ₹
Raw Material (28,000 × ₹ 72) 20,16,000
Wages 8,82,000
Prime Cost 28,98,000
Factory overheads 7,05,600
Factory Cost 36,03,600
Sale of Scrap (1,400 × ₹ 45) (63,000)
Cost of Production 35,40,600
Less: Closing Stock of finished goods 2,24,800
Cost of goods sold 33,15,800
Add: Administration overheads 4,72,000
Add: Selling & Distribution overheads (₹ 54 x 11,800) 6,37,200
Cost of Sales 44,25,000
Sales (11,800 × ₹ 416) 49,08,800
Profit 4,83,800
Solution 3 :
Calculation of Cost of Production of Appu Ltd.
Particulars Amount (₹)
Raw materials purchased 64,00,000
Add: Opening stock 2,88,000
Less: Closing stock (4,46,000)
Material consumed 62,42,000
Wages paid 23,20,000
Prime cost 85,62,000
Repair and maintenance cost of plant & machinery 9,80,500
Insurance premium paid for inventories 26,000
Insurance premium paid for plant & machinery 96,000
Quality control cost 86,000
Research & development cost 92,600
Administrative overheads related with factory and 9,00,000
production
1,07,43,100
Add: Opening value of W-I-P 4,06,000
Less: Closing value of W-I-P (6,02,100)
1,05,47,000
Less: Amount realised by selling scrap (9,200)
Add: Primary packing cost 10,200
Cost of Production 1,05,48,000
Notes:
(i) Other administrative overhead does not form part of cost of production.
(ii) Salary paid to Director (Technical) is an administrative cost.
Solution 4 :
Cost Sheet of M/s A&R Brothers for the month ended March 2023:
Particulars Amount (`) Amount (`)
(i) Materials consumed:
- Opening stock 6,06,000
- Add: Purchases 28,57,000
34,63,000
- Less: Closing stock (7,50,000) 27,13,000
Direct wages 37,50,000
(ii) Prime cost 64,63,000
Factory expenses 21,25,000
85,88,000
Add: Opening W-I-P 12,56,000
Less: Closing W-I-P (14,22,000)
Factory cost 84,22,000
Less: Sale of scrap (26,000)
(iii) Cost of Production 83,96,000
Add: Opening stock of finished goods 3,59,000
Less: Closing stock of finished goods (3,09,000)
(iv) Cost of Goods Sold 84,46,000
Office and administration expenses 10,34,000
Selling and distribution expenses 7,50,000
(v) Cost of Sales 1,02,30,000
(vi) Profit (balancing figure) 31,70,000
Sales 1,34,00,000
Solution 5 :
Cost sheet for the year ended 31st March, 2023.
Units produced - 14,000 units Units sold - 14,153 units
Particulars Amount (₹)
Raw materials purchased 43,50,000
Add: Freight Inward 1,20,000
Add: Opening value of raw materials 2,28,000
Less: Closing value of raw materials (3,05,000)
43,93,000
Less: Sale of scrap of material (7,000)
Materials consumed 43,86,000
Direct Wages (12,56,000 + 1,50,000) 14,06,000
Prime Cost 57,92,000
Factory overheads (20% of Prime Cost) 11,58,400
Add: Opening value of W-I-P 1,92,500
Less: Closing value of W-I-P (1,40,700)
Factory Cost 70,02,200
Add: Administrative overheads 1,73,000
Cost of Production 71,75,200
Add: Value of opening finished stock 6,08,500
Less: Value of closing finished stock [₹
500(71,75,200/14,350) × 767] (3,83,500)
(1,320 + 14,350 – 14,903 = 767 units)
Cost of Goods Sold 74,00,200
Distribution expenses (₹16 × 14,903 units) 2,38,448
Cost of Sales 76,38,648
Profit (Balancing figure) 9,90,189
Sales (₹ 579 × 14,903 units) 86,28,837
Solution 6 :
Cost Sheet of A Ltd. for the month of July 2023
Particulars Amount (₹) Amount (₹)
Materials consumed 15,00,000
Wages & Salary 64,00,000
Gratuity & leave encashment 44,20,000 1,08,20,000
Power cost (13,000 kwh × ₹ 7) 91,000
Diesel cost (1,000 ltr × ₹ 93) 93,000 1,84,000
HEMM hiring charges 13,00,000
Prime Cost 1,38,04,000
AMC cost of CCTV installed at factory premises 18,000
Cost of Production/ Cost of Goods Sold 1,38,22,000
Hiring charges of cars 80,000
Reimbursement of diesel cost 20,000
1,00,000
Add: GST @5% on RCM basis 5,000 1,05,000
Maintenance cost for weighing bridge 7,000
AMC cost of CCTV installed at weigh bridge 6,000 13,000
TA/ DA & hotel bill of sales manager 16,000
Cost of Sales 1,39,56,000
Amount realized by selling of scrap and waste generated during manufacturing process – ₹ 48,000/-
The board meeting is scheduled to be held next week and you, being an associate to the chief cost controller
of the company, has been asked to PREPARE a cost sheet.
Solution 7 :
Statement of Cost of P Ltd. for the year ended 31st December, 2023:
Sl. No. Particulars Amount (₹) Amount (₹)
(i) Material Consumed:
- Raw materials purchased 5,00,00,000
- Freight inward 9,20,600
Add: Opening stock of raw materials 10,00,000
Less: Closing stock of raw materials (8,40,000) 5,10,80,600
(ii) Direct employee (labour) cost:
- Wages paid to factory workers 25,20,000
(iii) Direct expenses:
- Royalty paid for production 1,80,000
- Amount paid for power & fuel 3,50,000
- Job charges paid to job workers 3,10,000 8,40,000
Prime Cost 5,44,40,600
(iv) Works/ Factory overheads:
- Stores and spares consumed 1,10,000
- Repairs & Maintenance paid for plant & machinery 40,000
- Insurance premium paid for plant & machinery 28,200
- Insurance premium paid for factory building 18,800
- Expenses paid for pollution control and engineering
& maintenance 36,000 2,33,000
Gross factory cost 5,46,73,600
Add: Opening value of W-I-P 8,60,000
Less: Closing value of W-I-P (6,60,000)
Factory Cost 5,48,73,600
(v) Quality control cost:
- Expenses paid for quality control check activities 18,000
(vi) Research & development cost paid for improvement in 20,000
production process
(vii) Less: Realisable value on sale of scrap and waste (48,000)
(viii) Add: Primary packing cost 46,000
Cost of Production 5,49,09,600
Add: Opening stock of finished goods 12,00,000
Less: Closing stock of finished goods (10,50,000)
Cost of Goods Sold 5,50,59,600
(ix) Administrative overheads:
- Depreciation on office building 50,000
- Salary paid to General Manager 6,40,000
- Fee paid to independent directors 1,20,000 8,10,000
(x) Selling overheads:
- Repairs & Maintenance paid for sales office 20,000
building
Solution 8.
Calculation of Cost of Production of Meta Ltd for the period…..
Particulars Amount (₹)
Raw materials purchased 64,00,000
Add: Opening stock 2,88,000
Less: Closing stock (4,46,000)
Material consumed 62,42,000
Wages paid 23,20,000
Prime cost 85,62,000
Repair and maintenance cost of plant & machinery 9,80,500
Insurance premium paid for inventories 26,000
Insurance premium paid for plant & machinery 96,000
Quality control cost 86,000
Research & development cost 92,600
Administrative overheads related with factory and production 9,00,000
1,07,43,100
Add: Opening value of W-I-P 4,06,000
Less: Closing value of W-I-P (6,02,100)
1,05,47,000
Less: Amount realised by selling scrap (9,200)
Add: Primary packing cost 10,200
Add: Expenses paid for pollution control and engineering & 22,000
maintenance
Cost of Production 1,05,70,000
Notes:
(i) Other administrative overhead does not form part of cost of production.
(ii) Salary paid to Director (Technical) is an administrative cost.
Solution 9.
Cost Sheet
Particulars Units Amount (₹)
Material
Opening stock 10,000 5,00,00,000
Add: Purchases 4,90,000 25,20,00,000
Less: Closing stock (17,500) (85,00,000)
4,82,500 29,35,00,000
Less: Normal wastage of materials realized @ ₹ 350 per unit (2,000) (7,00,000)
Material consumed 29,28,00,000
Direct employee's wages and allowances 5,50,50,000
Direct expenses- Royalty paid for production 3,10,50,000
Prime cost 4,80,500 37,89,00,000
Solution 1 :
Journal entries are as follows
DR. (₹) Cr. (₹)
Stores Ledger Control A/c Dr. 4,40,000
To Payables (Creditors)/ Bank A/c (Materials purchased) 4,40,000
Work-in-Process Control A/c Dr. 3,60,000
To Stores Ledger Control A/c (Materials issued to production) 3,60,000
Work-in-Process Control A/c To Wages Control A/c Dr. 80,000
(Direct wages charged to production) 80,000
Work-in-Process Control A/c Dr. 1,32,000
To Factory Overhead Control A/c (Manufacturing overhead 1,32,000
charged to production)
Solution 2 :
Memorandum Reconciliation Accounts
Dr. Cr.
(₹) (₹)
To Net Loss as per Costing 3,47,000By Administration overheads 60,000
books over recovered in cost
accounts
To Factory overheads under 40,000 By Interest on investment not 96,000
absorbed in Cost Accounts included in Cost Accounts
To Depreciation under charged 50,000 By Transfer fees in financial 24,000
in Cost Accounts books
To Income-Tax not provided in 54,000 By Stores adjustment (Credit in 14,000
Cost Accounts financial books)
To Interest on Loan Funds 2,45,000 By Dividend received in 32,000
in Financial Accounts financial books
By Net loss as per 5,10,000
financial books
7,36,000 7,36,000
Solution 3 :
Statement of Cost of G Ltd. for the year ended 31st March, 2023:
Sl. No. Particulars Amount (₹) Amount (₹)
(i) Material Consumed:
Raw materials purchased 20,00,00,000
Freight inward 22,41,200
Add: Opening stock of raw materials 36,00,000
Less: Closing stock of raw materials (19,20,000) 20,39,21,200
(ii) Direct employee (labour) cost:
Wages paid to factory workers 58,40,000
(iii) Direct expenses:
Royalty paid for production 3,45,200
Solution 4 :
(i) Statement of Profit as per financial records (for the year ended March 31, 2023)
(₹) (₹)
To Opening stock of Finished Goods 1,06,250 By Sales 45,60,000
To Work-in-process 92,000 By Closing stock of finished Goods 91,300
To Raw materials consumed 16,80,000 By Work-in-Process 82,400
To Direct labour 12,20,000 By Rent received 92,000
To Factory overheads 8,44,000 By Interest received 76,000
To Administration overheads 3,96,000
To Selling & distribution overheads 1,44,000
To Dividend paid 2,44,000
To Bad debts 36,000
To Profit 1,39,450
49,01,700 49,01,700
Statement of Profit as per costing records (for the year ended March 31,2023)
(₹)
Sales revenue (A) (12,615 units) 45,60,000
Cost of sales:
Opening stock (625 units × ₹ 240) 1,50,000
Add: Cost of production of 12,405 units (Refer to working note 2) 43,28,140
Less: Closing stock (1,44,795)
₹ 43,28,140 𝑋 415 𝑢𝑛𝑖𝑡𝑠
12,405 𝑢𝑛𝑖𝑡𝑠
Production cost of goods sold (12,615 units) 43,33,345
Selling & distribution overheads (12,615 units × ₹6)
75,690
Cost of sales: (B) 44,09,035
Profit: {(A) – (B)} 1,50,965
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
2.Cost Sheet
(₹)
Raw materials consumed 16,80,000
Direct labour 12,20,000
Solution 5 :
Statement of Profit as per financial records (for the year ended March 31, 2023)
(₹) (₹)
To Opening stock: By Sales 20,80,000
Finished goods 76,525 By Closing stock:
Work-in-process 33,000 Finished Goods 43,250
To Raw materials consumed 7,84,000 Work-in-Process 48,200
To Direct labour 4,65,000 By Rent received 72,000
To Factory overheads 2,65,000 By Interest received 18,500
To Goodwill written off 95,000
To Administration overheads 3,15,000
To Selling & distribution overheads 65,000
To Income tax paid 72,000
To Bad debts 21,000
To Profit 70,425
22,61,950 22,61,950
Statement of Profit as per costing records (for the year ended March 31,2023)
(₹) (₹)
Sales revenue (14,500 units) (A) 20,80,000
Cost of Sales:
Opening stock (875 units x ₹ 105) 91,875
Add: Cost of production of 14,000 units 18,15,360
(Refer to Working Note 1& 2)
Less: Closing stock (
₹18,15,360 × 375 𝑢𝑛𝑖𝑡𝑠
14,000 𝑈𝑛𝑖𝑡𝑠 ) (48,626)
Production cost of goods sold (14,500 units) 18,58,609
Selling & distribution overheads (14,500 units x ₹ 5) 72,500
Cost of sales: (B) 19,31,109 19,31,109
Profit: {(A) – (B)} 1,48,891
Workings:
1.Number of units produced Units
Sales 14,500
Add: Closing stock 375
Total 14,875
Less: Opening stock 875
Number of units produced 14,000
Cost Sheet
(₹) (₹)
Raw materials consumed 7,84,000
Direct labour 4,65,000
Prime cost 12,49,000
Factory overheads (60% of direct wages) 2,79,000
Factory cost 15,28,000
Add: Opening work-in-process 33,000
Less: Closing work-in-process (48,200)
Factory cost of goods produced 15,12,800
Administration overheads (20% of factory cost) 3,02,560
Cost of production of 14,000 units 18,15,360
Statement of Reconciliation
(Reconciling the profit as per costing records with the profit as per financial records)
(₹) (₹)
Profit as per Cost Accounts 1,48,891
Add: Factory overheads over absorbed 14,000
(₹ 2,79,000 – ₹ 2,65,000)
S & D overheads over absorbed 7,500
(₹ 72,500 - ₹ 65,000)
Opening stock overvalued (₹ 91,875 – ₹ 76,525) 15,350
Interest received 18,500
Rent received 72,000 1,27,350
2,76,241
Less: Administration overheads under recovery 12,440
(₹ 3,15000 – ₹ 3,02,560)
Closing stock overvalued (₹ 48,626 – ₹ 43,250) 5,376
Goodwill written off 95,000
Income tax paid 72,000
Bad debts 21,000 2,05,816
Profit as per financial accounts 70,425
Solution 2 .
Statement of Reconciliation of profit as obtained under Cost and Financial Accounts
(`) (`)
Profit as per cost records 5,40,400
Add: Administrative Overhead over absorbed 24,000
Interest & Dividend Received 65,200
Notional rent of own premises 60,000
Stores adjustments (Credited in financial books) 7,500
Depreciation over charged in cost accounts 40,000 1,96,700
7,37,100
Less: Factory overheads under absorbed 84,800
Interest paid on bank borrowings 50,000
Lossed on sale of fixed assets and investments 48,000
Donations and subscriptions 18,800
Over-valuation of closing stock of finished goods in cost 1,25,000
accounts
Income tax 1,50,000 (4,76,600)
Profit as per Financial Records 2,60,500
Solution 2 .
Memorandum Reconciliation Accounts
Dr. Cr.
Particulars Amount Particulars Amount
(₹ ) (₹ )
To Net Loss as per Cost Accounts 48,700 By Administration overheads over 65,000
recovered in Cost Accounts
To Factory overheads under 30,500 By Depreciation overcharged in 45,000
absorbed in Cost Accounts Cost Accounts
(₹ 2,70,000 –₹ 2,25,000)
To Provision for Income tax 52,400 By Transfer fees in Financial 10,200
Accounts
To Obsolescence loss 20,700 By Notional Rent of own 49,000
premises
To Overvaluation of closing stock 9,500 By Overvaluation of Opening stock in 23,000
in Cost Accounts** Cost Accounts*
To Net Profit (as per Financial 30,400
Accounts)
1,92,200 1,92,200
* Overvaluation of Opening Stock as per Cost Accounts
= Value in Cost Accounts – Value in Financial Accounts
= ₹ 1,38,000 – ₹ 1,15,000 = ₹ 23,000.
** Overvaluation of Closing Stock as per Cost Accounts
= Value in Cost Accounts – Value in Financial Accounts = ₹ 1,22,000 – ₹ 1,12,500 = ₹ 9,500.
● The company values work-in-process at factory cost for both Financial and Cost Profit
Reporting.
Required:
(i) Prepare statements for the year ended 31st March, 2024 show
● the profit as per financial records
● the profit as per costing records.
(ii) Present a statement reconciling the profit as per costing records with the profit as per Financial Records.
Solution 3 .
(i) Statement of Profit as per financial records
(for the year ended March 31, 2024)
(₹) (₹)
To Opening stock of Finished 48,250By Sales 13,96,500
Goods
To Work-in-process 38,000By Closing stock of finished 44,500
Goods
To Raw materials 5,00,000By Work-in-Process 36,200
consumed
To Direct labour 4,20,000By Interest received 42,000
To Factory overheads 3,56,000By Loss 3,35,050
To Administration 2,10,000
overheads
To Selling & distribution 84,000
overheads
To Dividend paid 98,000
To Bad debts 16,000
To Stores adjustment 50,000
To Income tax 34,000
18,54,250 18,54,250
(31,808)
Less: Factory overheads over recovered (₹ 1,04,000
3,56,000 - ₹2,52,000)
Closing stock overvalued (₹ 45,742 – ₹ 44,500) 1,242
Stores adjustment 50,000
Income tax 34,000
Dividend 98,000
Bad debts 16,000 (3,03,242)
Loss as per financial accounts (3,35,050)
Working notes:
2. Cost Sheet
(₹)
Raw materials consumed 5,00,000
Direct labour 4,20,000
Prime cost 9,20,000
Factory overheads 2,52,000
(60% of direct wages)
Factory cost 11,72,000
Add: Opening work-in-process 38,000
Less: Closing work-in-process 36,200
Factory cost of goods produced 11,73,800
Administration overheads 2,34,760
(20% of factory cost)
Cost of production of 14,165 units (Refer to working note 1) 14,08,560
Cost of production per unit:
₹14,08,560 99.44
14,165
Solution 1 :
Statement of Cost and Profit per batch
Particulars Jan. Feb. March April May June Total
Batch output (in units) 310 300 320 280 300 320 1,830
Sale value (₹) 2,480 2,400 2,560 2,240 2,400 2,560 14,640
Material cost (₹) 1,150 1,140 1,180 1,130 1,200 1,220 7,020
Direct wages (₹) 120 140 150 140 150 160 860
Chargeable expenses* (₹) 600 672 672 621 780 800 4,145
Total cost (₹) 1,870 1,952 2,002 1,891 2,130 2,180 12,025
Profit per batch (₹) 610 448 558 349 270 380 2,615
Total cost per unit (₹) 6.03 6.51 6.26 6.75 7.10 6.81 6.57
Profit per unit (₹) 1.97 1.49 1.74 1.25 0.90 1.19 1.43
Overall position of the order for 1,800 units
Sales value of 1,800 units @ ₹ 8 per unit ₹ 14,400
Total cost of 1,800 units @ ₹ 6.57 per unit ₹ 11,826
Profit ₹ 2,574
𝐶ℎ𝑎𝑟𝑔𝑒𝑎𝑏𝑙𝑒 𝑒𝑥𝑝𝑒𝑛𝑠𝑒𝑠
* 𝐷𝑖𝑟𝑒𝑐𝑡 𝑙𝑎𝑏𝑜𝑢𝑟 ℎ𝑜𝑢𝑟 𝑓𝑜𝑟 𝑡ℎ𝑒 𝑚𝑜𝑛𝑡ℎ ×Direct labour hours for batch
Solution 2 :
2×𝐷×𝑆
(i) Optimum run size or Economic Batch Quantity (EBQ) = 𝐶
Where, D = Annual demand = 9,20,000 units
S = Set-up cost per run = ₹ 3,500
C = Inventory holding cost per unit per annum
= ₹ 1.5 × 12 months = ₹ 18
2×9,20,000 𝑢𝑛𝑖𝑡𝑠×₹3,500
EBQ = ₹18
= 18,915 units
(ii) Calculation of Total Cost of set-up and inventory holding
Batch size No. of set- ups Set-up Cost Inventory holding Total Cost
(₹) cost (₹) (₹)
23 80,500 3,60,000 4,40,500
A 40,000 units (9,20,000
40,000 )
(23 × ₹ 3,500) (
40,000×₹18
2 )
B 18,915 units 49 1,71,500 1,70,235 3,41,735
( 9,20,000
18,915 ) (49 × ₹ 3,500) ( 18,915×₹18
2 )
Extra Cost (A – B) 98,765
Solution 3 :
(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
4,80,000 + 2,10,000F + 4,80,000A + 2,10,000AF = 7,57,500 ……eqn (iii)
4,72,500 + 2,10,000F + 4,72,500A + 2,10,000AF = 7,48,125 ……eqn (iv)
- - - - -
7,500 + 7,500A = 9,325
7,500 A = 9,325 – 7,500
A = 0.25
Now put the value of A in equation (i) to find the value of F
96,000 + 42,000F + 24,000 + 10,500F = 1,51,500
52,500F = 1,51,500 – 1,20,000
F = 0.6
(ii) Statement of jobs, showing amount of factory overheads, administrative overheads and profit:
Job 101 Job 102
(₹) (₹)
Direct materials 54,000 37,500
Direct wages 42,000 30,000
Prime cost 96,000 67,500
Factory overheads
60% of direct wages 25,200 18,000
Factory cost 1,21,200 85,500
Administrative overheads
25% of factory cost 30,300 21,375
Total cost 1,51,500 1,06,875
Profit (10% & 20% respectively) 15,150 21,375
Selling price 1,66,650 1,28,250
Solution 4 :
Workings:
5,000 𝑙𝑡𝑟𝑠
1. Maximum number of bottles that can be processed in a batch: 𝐵𝑜𝑡𝑡𝑙𝑒 𝑣𝑜𝑙𝑢𝑚𝑒
2×𝐷×𝑆
Computation of Economic Batch Quantity (EBQ): 𝐶
During the FY 2023-24, the company has received an order from a car manufacturer where it estimates that
the cost of material and labour will be ₹ 80,00,000 and ₹ 40,50,000 respectively. The company charges factory
overhead as a percentage of direct labour and administrative overheads as a percentage of factory cost based
on previous year's cost.
Cost of delivery of the components at customer's premises is estimated at ₹ 4,50,000. You are required to:
(i) Calculate the overhead recovery rates based on actual costs for 2022-23.
(ii) Prepare a Job cost sheet for the order received and the price to be quoted if the desired profit is 25% on
sales.
Solution 5 :
(i) Calculation of Overhead Recovery Rate:
₹ 30,80,000
Factory Overhead Recovery Rate = ₹90,50,000 X 100 = 34% of Direct labour
₹ 20,50,400
Administrative Overhead Recovery Rate = ₹ 2,96,80,000
X 100 = 6.91% of Factory Cost
Working Note: Calculation of Factory Cost in 2022-23
Particulars Amount (₹)
Opening Stock of Material 15,00,000
Add: Purchase of Material 1,80,50,000
Less: Closing Stock of Material (20,00,000)
Material Consumed 1,75,50,000
Direct Labour 90,50,000
Prime Cost 2,66,00,000
Factory Overhead 30,80,000
Factory Cost 2,96,80,000
2×60,000×₹4,800
= 12×12
= 2,000 Vaccine
Solution 1 :
Process A Account
Particulars Units ₹Particulars Units ₹
To Material 78,000 3,90,000By Normal Loss 7,800 -
To Wages 2,85,000By Abnormal Loss 1,560 18,720
To Overheads 1,67,400By Process B A/c 68,640 8,23,680
Total 78,000 8,42,400Total 78,000 8,42,400
8,42,400
Cost per unit of completed units and abnormal loss = 78,000 𝑢𝑛𝑖𝑡𝑠−7,800 𝑢𝑛𝑖𝑡𝑠 = ₹ 12 unit
Process B Account
Particulars Units ₹Particulars Units ₹
To Process A A/c 68,640 8,23,680By Normal loss 240 -
To Indirect Material 34,320By Finished stock 69,000 13,11,000
To Wages 3,30,000
To Overheads 1,11,600
To Abnormal gain 600 11,400
Total 69,240 13,11,000 Total 69,240 13,11,000
Cost per unit of completed units and abnormal gains:
𝑇𝑜𝑡𝑎𝑙 𝐶𝑜𝑠𝑡 ₹12,99,600
𝐼𝑛𝑝𝑢𝑡𝑠−𝑁𝑜𝑟𝑚𝑎𝑙 𝑙𝑜𝑠𝑠
= 68,640 𝑢𝑛𝑖𝑡𝑠−240 𝑢𝑛𝑖𝑡𝑠 = ₹19
Solution 2 :
(i) Statement of Equivalent Production (FIFO Method)
Input Output Equivalent Production
Materials Labour Production
Overhead
Details Units Details Units % Units % Units % Units
Opening Stock 600From opening stock 600 - - 40 240 40 240
- From fresh materials 8,300 100 8,300 100 8,300 100 8,300
Less: Abnormal Gain (192) 100 (192) 100 (192) 100 (192)
9,800 9,800 8,808 8,838 8,838
Solution 4 :
Process-I A/c
Particulars Qty. (kgs) Amount ) Particulars Qty. (kgs) Amount (₹)
To Material A 6,000 3,00,000 By Normal loss 500 8,000
To Material B 4,000 4,00,000 By Process-II A/c 9,200 7,38,857
To Labour -- 21,500 By Abnormal loss A/c 300 24,093
To Overhead -- 49,450
( ₹92,000×430ℎ𝑟𝑠
800 ℎ𝑟𝑠 )
10,000 7,70,950 10,000 7,70,950
{(₹3,00,000+₹4,00,000+₹21,500+₹49,450)−₹8,000} ₹7,70,950−₹8,000
* (10,000−500)𝑢𝑛𝑖𝑡𝑠
= 9,500 𝑢𝑛𝑖𝑡𝑠
= ₹80.3105
Process-II A/c
Particulars Qty.(kgs) Amount (₹) Particulars Qty. (kgs) Amount (₹)
To Process-I A/c 9,200 7,38,857 By Normal loss 1,000 --
To Material C 6,600 8,25,000 By Packing Dept. A/c 18,000 18,42,496
(See the working notes)
To Material D 4,200 3,15,000 By WIP A/c 1,000 1,00,711
(See the working notes)
To Flavouring essence -- 3,300
To Labour -- 18,500
To Overheads -- 42,550
( ₹92,000×370 ℎ𝑟𝑠
800 ℎ𝑟𝑠 )
20,000 19,43,207 20,000 19,43,207
Working Notes:
Calculation of Equivalent Production units
Input Units Output Units Process-I Mat-C & D Labour & OH
(%) Units (%) Units (%) Units
9,200Transferred to 18,000 100 18,000 100 18,000 100 18,000
Packing.
Mat-C 6,600Closing WIP 1,000 100 1,000 100 1,000 50 500
Mat-D 4,200Normal loss 1,000 -- -- -- -- -- --
20,000 20,000 19,000 19,000 18,500
Solution 5 :
(i) Process- A Account
Particulars Units Amount (₹) Particulars Units Amount (₹)
To Inputs 40,000 3,60,000 By Normal wastage 2,000 30,000
(2,000 units × ₹15)
To Material --- 2,42,000 By Abnormal loss 1,000 27,000
A/c
(1,000 units × ₹27)
To Direct wages --- 2,58,000 By Process- B 29,600 7,99,200
(29,600 units × ₹27)
To Manufacturing Exp. --- 1,96,000 By Profit & Loss A/c 7,400 1,99,800
(7,400 units × ₹27)
40,000 10,56,000 40,000 10,56,000
₹10,56,000−₹30,000
Cost per unit = 40,000 𝑢𝑛𝑖𝑡𝑠−2,000 𝑢𝑛𝑖𝑡𝑠
=₹27 per unit
Normal wastage = 40,000 units × 5% = 2,000 units
Abnormal loss = 40,000 units – (37,000 units + 2,000 units) = 1,000 units
Transfer to Process- B = 37,000 units × 80% = 29,600 units
Sale = 37,000 units × 20% = 7,400 units
Process- B Account
Particulars Units Amount (₹)Particulars Units Amount (₹)
To Process- A A/c 29,600 7,99,200By Normal wastage 2,960 59,200
(2,960 units × ₹ 20)
To Material --- 2,25,000By Profit & Loss A/c 27,000 12,96,000
To Direct Wages --- 1,90,000 (27,000 units × ₹ 48)
To Manufacturing Exp. --- 1,23,720
To Abnormal Gain A/c 360 17,280
(360 units × ₹ 48)
29,960 13,55,200 29,960 13,55,200
₹13,37,920−₹59,200
Cost per unit = 29,600 𝑢𝑛𝑖𝑡𝑠−2,960𝑢𝑛𝑖𝑡𝑠 = ₹ 48 per unit
Normal wastage = 29,600 units × 10% = 2,960 units
Abnormal gain = (27,000 units + 2,960 units) – 29,600 units = 360 units
19,55,880 19,55,880
Working Notes:
Normal wastage (Loss) Account
Particulars Units Amount Particulars Units Amount (₹)
(₹)
To Process- A A/c 2,000 30,000By Abnormal Gain 360 7,200
A/c
(360 units × ₹ 20)
To Process- B A/c 2,960 59,200By Bank (Sales) 4,600 82,000
4,960 89,200 4,960 89,200
Solution 6 :
Process A Account
Dr Cr.
₹ ₹
To Materials 40,000 By Transfer to Process B A/c 1,20,000
To Labour 40,000
To Overheads 16,000
96,000
To Profit (20% of transfer price, i.e.,
25% of cost) 24,000
1,20,000 1,20,000
Process B Account
Dr Cr.
₹ ₹
To Transferred from Process A A/c 1,20,000 By Transfer to Finished Stock A/c 2,88,000
To Labour 56,000
To Overhead 40,000
2,16,000
Solution 7 :
(i) Statement of Equivalent Production
Equivalent Production
Labour &
Material- A* Consumables
Output Particulars Overheads
Input Details Units Units
% Units % Units % Units
Units
Units transferred to
transferred 55,000 51,000 100 51,000 100 51,000 100 51,000
Process-III
from Process-I
Normal loss (4%
2,200 - - - - - -
of 55,000)
Closing W-I-P 2,000 100 2,000 80 1,600 60 1,200
Abnormal Gain (200) 100 (200) 100 (200) 100 (200)
55,000 55,000 52,800 52,400 52,000
*Material A represent transferred-in units from process-I
Solution 8 :
(i) Statement of Equivalent Production (FIFO Method)
Solution 9.
(a) Statement of Equivalent Production
Input Units Output ParticularsUnits Equivalent Production
Details Material Labour Overhead
% Units % Units % Units
Unit 45,000 Finished output 42,000 100 42,000 100 42,000 100 42,000
Introduced Normal 900 - - - - - -
loss
(2% of
45,000)
Abnormal loss 300 100 300 80 240 60 180
Closing W-I-P 1,800 100 1,800 50 900 40 720
45,000 45,000 44,100 43,140 42,900
Statement of Cost
Particulars Units Rate Amount Amount
(₹) (₹) (₹)
(i) Finished goods 42,000 17.9042 7,51,976.40
(ii) Abnormal Loss
Material 300 11.5873 3,476.19
Labour 240 2.1048 505.15
Overhead 180 4.2121 758.18 4,739.52
(iii) Closing W-I-P:
Material 1,800 11.5873 20,857.14
Labour 900 2.1048 1,894.32
Overhead 720 4.2121 3,032.71 25,784.17
Cost per Unit
Particulars Amount (₹) Units Per Unit (₹)
(i) Direct Material :
Unit Introduced 4,50,000
Add: Material 65,500
5,15,500
Less: Value of normal loss (900 units × ₹ (4,500)
5)
5,11,000 44,100 11.5873
(ii) Labour 90,800 43,140 2.1048
(iii) Overhead 1,80,700 42,900 4.2121
17.9042
Process – P A/c
Particulars Units Amount Particulars Units
Amount
(₹) (₹)
To Input 45,000 4,50,000 By Normal loss 900 4,500
To Direct Material - 65,500 By Abnormal loss 300 4,740
To Labour - 90,800 By Finished goods 42,000 7,51,976
To Overhead 1,80,700 By Closing W-I-P 1,800 25,784
45,000 7,87,000 45,000 7,87,000
Solution 1 :
(i) Statement showing apportionment of joint cost to the products using NRV method
Particulars Product A (₹) Product B (₹) Product C (₹)
Sales value 34,20,000 12,60,000 54,00,000
(3,60,000 x ₹ 9.5) (2,10,000 x ₹ 6) (4,50,000 x ₹ 12)
Less: Further processing cost 8,60,000 - 10,40,000
Net Realisable Value 25,60,000 12,60,000 43,60,000
Apportionment of Joint cost of ₹ 17,92,000 8,82,000 30,52,000
57,26,000 in the ratio of 256:126:436
Solution 2 :
Working Notes:
(i) Computation of Allocation Ratio for Joint Costs
Products
X Y Z.
₹ ₹ ₹
Selling Price 13.75 8.75 7.50
Less: anticipated margin@ 25% on cost of 20% on 2.75 1.75 1.50
sales
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
₹ ₹ ₹ ₹ ₹ ₹
X 6.75 5.00 11.75 13.75 2.00 17.02
Y 3.38 4.00 7.38 8.75 1.37 18.56
Z 3.94 2.50 6.44 7.50 1.06 16.46
Note: 1
24
X= 40 × 90, 000 =54,000
9
Y= 40 × 90, 000 = 20,250
Solution 4 :
(i) Statement showing the apportionment of joint costs to A, B and X
Products A B X Total
Output (kg) 18,000 10,000 54,000
Sales value at the point 9,00,000 4,00,000 5,40,000 18,40,000
of split off (₹) (₹ 50 x 18,000) (₹ 40 x 10,000) (₹ 10 x 54,000)
Joint cost 6,30,000 2,80,000 3,78,000 12,88,000
apportionment on the
basis of sales value at
(
₹12,88,000
18,40,000 )(
₹12,88,000
× 9, 00, 000 18,40,000 × 4, 00, 000 )( ₹12,88,000
18,40,000 )
× 5, 40, 000
(iii) Statement showing the product wise and total profit for the period
Products A B X Total
Sales value (₹) 12,24,000 2,50,000 7,92,000
Add: Closing stock value (₹)
(Refer to Working note 2) 45,000 2,15,000 90,000
Value of production (₹) 12,69,000 4,65,000 8,82,000 26,16,000
Apportionment of joint cost (₹) 6,30,000 2,80,000 3,78,000
Add: Further processing cost (₹) 1,80,000 1,50,000 1,08,000
Total cost (₹) 8,10,000 4,30,000 4,86,000 17,26,000
Profit (₹) 4,59,000 35,000 3,96,000 8,90,000
Working Notes
1.
Products A B X
Sales value (₹) 12,24,000 2,50,000 7,92,000
Quantity sold (Kgs.) 17,000 5,000 44,000
Selling price ₹/kg 72 50 18
( ₹12,24,000
17,000 𝑘𝑔 ) ( ₹2,50,000
5,000 𝑘𝑔 ) ( ₹7,92,000
44,000 𝑘𝑔 )
2. Valuation of closing stock:
Since the selling price per kg of products A, B and X is more than their total costs, therefore closing stock will
be valued at cost.
Products A B X Total
Closing stock (kgs.) 1,000 5,000 10,000
Cost per kg (₹) 45 43 9
Closing stock value (₹) 45,000 2,15,000 90,000 3,50,000
(₹ 45 x 1,000 kg) (₹ 43 x 5,000 kg) (₹9x10,000 kg)
A B
5,000 3,000
Selling prices are
A ₹ 16,000
B ₹ 8,000
Estimated profit on selling prices is 25% for A and 20% for B.
Assume that selling and distribution expenses are in proportion of sales prices. Show how you would
apportion joint costs of manufacture and prepare a statement showing cost of production of A and B.
Solution 5 :
(a) Apportionment of Joint Costs
Particulars A (₹) B (₹)
Selling Price 16,000 8,000
Less: Estimated profit 4,000 1,600
(25% of ₹16,000) (20% of ₹ 8,000)
Cost of sales 12,000 6,400
Less: Selling & Distribution exp. 267 133
(Refer working note) (₹ 400 × 2/3) (₹ 400 × 1/3)
Less: Subsequent cost 5,000 3,000
Share of Joint cost 6,733 3,267
So, Joint cost of manufacture is to be distributed to A & B in the ratio of 6733 : 3267
Statement showing Cost of Production of A and B
Elements of cost Joint Cost Subsequent Cost Total Cost
A B A B A B
Material 3,367 1,633 3,000 1,500 6,367 3,133
Labour 2,020 980 1,400 1,000 3,420 1,980
Overheads 1,346 654 600 500 1,946 1,154
Cost of production 11,733 6,267
Working Note:
Calculation of Selling and Distribution Expenses
Particulars (₹)
Total Sales Revenue (₹ 16,000 + ₹ 8,000) 24,000
Less: Estimated Profit (₹ 4,000 + ₹ 1,600) (5,600)
Cost of Sales 18,400
Less: Cost of production:
- Joint Costs (10,000)
- Subsequent costs (₹ 5,000 + ₹ 3,000) (8,000)
Selling and Distribution expenses (Balancing figure) 400
Solution 6 :
Apportionment of Joint Costs
Particulars A (₹) B (₹)
Selling Price 16,000 8,000
4,000 1,600
Less: Estimated profit
(25% of ₹16,000) (20% of ₹ 8,000)
Cost of sales 12,000 6,400
Less: Selling & Distribution exp. 267 133
(Refer working note) (₹ 400 × 2/3) (₹ 400 × 1/3)
Less: Subsequent cost 5,000 3,000
Share of Joint cost 6,733 3,267
So, Joint cost of manufacture is to be distributed to A & B in the ratio of 6733 : 3267
Statement showing Cost of Production of A and B
Joint Cost Subsequent Cost Total Cost
Elements of cost
A B A B A B
Material 3,367 1,633 3,000 1,500 6,367 3,133
Labour 2,020 980 1,400 1,000 3,420 1,980
Overheads 1,346 654 600 500 1,946 1,154
Cost of production 11,733 6,267
Working Note:
Calculation of Selling and Distribution Expenses
Particulars (₹)
Total Sales Revenue (₹ 16,000 + ₹ 8,000) 24,000
Less: Estimated Profit (₹ 4,000 + ₹ 1,600) (5,600)
Cost of Sales 18,400
Less: Cost of production:
- Joint Costs (10,000)
- Subsequent costs (₹ 5,000 + ₹ 3,000) (8,000)
Selling and Distribution expenses (Balancing figure) 400
Solution 1 :
Calculation of room days:
Nature of Room Occupancy (Room-days)
Deluxe room 5760
(20 x 80% x 360)
Executive room 2160
(10 x 60% x 360)
Suite room 1080
(4 x 75% x 360)
Solution 2 :
(i) Calculation of total project cost per day of concession period:
Activities Amount (₹ in
lakh)
Site clearance 170.70
The cost per day has to be recovered from the daily traffic. Each type of vehicle is to be converted into
equivalent unit. Let’s convert all vehicle types equivalent to Two-wheeler
Sl. Type of vehicle Daily traffic Weight Ratio Equivalent
No. volume Two-wheeler
[A] [B] [A×B]
1. Two wheelers 44,500 0.05 1 44,500
2. Car and SUVs 3,450 0.20 4 13,800
3. Bus and LCV 1,800 0.30 6 10,800
4. Heavy commercial vehicles 816 0.45 9 7,344
Total 76,444
Solution 4:
(i) Annual Cost Statement of three vehicles
(₹)
Diesel {(1,34,784 km. ÷ 4 km) × ₹ 65) (Refer to Working Note 1) 21,90,240
Oil & sundries {(1,34,784 km. ÷ 100 km.) × ₹ 250} 3,36,960
Maintenance {(1,34,784 km. × ₹ 0.25) + ₹ 6,000} (Refer to 39,696
Working Note 2)
Drivers' salary {(₹24,000 × 12 months) × 3 trucks} 8,64,000
Licence and taxes (₹ 25,000 × 3 trucks) 75,000
Insurance 45,000
Depreciation {(₹ 29,00,000 ÷ 10 years) × 3 trucks} 8,70,000
General overhead 1,15,600
Total annual cost 45,36,496
(iii) Freight rate per tonne km (to yield a profit of 10% on freight)
𝑇𝑜𝑡𝑎𝑙 𝑎𝑛𝑛𝑢𝑎𝑙 𝑐𝑜𝑠𝑡 𝑜𝑓 𝑡ℎ𝑟𝑒𝑒 𝑣𝑒ℎ𝑖𝑐𝑙𝑒𝑠
Cost per tonne km.= 𝑇𝑜𝑡𝑎𝑙 𝑒𝑓𝑓𝑒𝑐𝑡𝑖𝑣𝑒 𝑡𝑜𝑛𝑛𝑒𝑠 𝑘𝑚𝑠. 𝑝𝑒𝑟 𝑎𝑛𝑛𝑢𝑚 (Refer to Working Note 1)
₹45,36,496
= 6,06,528 𝑘𝑚𝑠 = ₹ 7.48
₹7.48
Freight rate per tonne km. 0.9
×1
Working Notes:
1. Total kilometer travelled and Commercial tonnes kilometer (load carried) by three trucks in one year
Truck One way No. of Total distance Total distance Load carried Total effective
distance in trips covered in km covered in km per trip / day tonnes km
kms per day (with per day (up & in tonnes
load) down)
a b c=a×b d=c×2 e f = 27/3 × c
1 16 4 64 128 6 576
2 40 2 80 160 9 720
3 30 3 90 180 12 810
Total 234 468 27 2,106
Total kilometre travelled by three trucks in one year
(468 km. × 24 days × 12 months) = 1,34,784
Total effective tonnes kilometre of load carried by three trucks during one year
(2,106 tonnes km. × 24 days × 12 months) = 6,06,528 tonne-km
Solution 5 :
Working Notes:
(1) Calculation of number of patient days
35 Beds × 150 days = 5,250
25 Beds × 80 days = 2,000
Extra beds = 750
Total = 8,000
Statement of Profitability
Particulars Amount Amount
Income for the year (₹ 2,000 per patient per day × 1,60,00,000
8,000 patient days)
Variable Costs:
Doctor Fees (₹ 2,50,000 per month × 12) 30,00,000
Food to Patients (Variable) 8,80,000
Other services to patients (Variable) 3,00,000
Laundry charges (Variable) – (₹) 6,00,000
Solution 6 :
(i) Calculation of Absolute Ton-km for the next month:
Journey Distance in Weight- Up Ton-km Weight- Ton-km Total
km (in Down (in
MT) MT)
(a) (b) (c)=(a)×(b) (d) (e)= (a)×(d) (c)+(e)
Delhi to Kochi 2,700 14 37,800 6 16,200 54,000
Delhi to Guwahati 1,890 12 22,680 0 0 22,680
Solution 7 :
Workings:
Total occupancy = Occupancy in normal season + Occupancy in off- season
= (20 rooms × 80% × 8 months × 30 days) + (20 rooms × 50% × 4 months × 30 days)
= 3,840 + 1,200 = 5,040 room-days
Total Cost = Variable cost + Fixed cost
= (₹ 500 × 5,040 room-days) + ₹ 53,25,000
= ₹ 25,20,000 + ₹ 53,25,000 = 78,45,000
(a) Calculation of tariff rate per room
Tariff per room per day = (Total cost + 25% Margin on total cost) ÷ Total occupancy
Solution 8 :
Operating cost statement of P Holiday Resorts
Apart from the above, the following are the additional information:
Particulars
You have been approached by the management of A LMV Pvt. Ltd. for consultation on the two options of
operating the cab service.
CALCULATE the operating cost of vehicle per month per car for both CNG & EV options.
Solution 9 :
Workings:
1.Calculation of Depreciation per month:
Particulars CNG Car EV Car
A Car purchase price (₹) 9,20,000 15,20,000
B Less: Govt. subsidy (₹) -- (1,50,000)
B Maintenance cost:
Annual Maintenance cost [Annual cost ÷12] 666.67 433.33
Annual Insurance cost [Annual cost ÷12] 633.33 1,216.67
Amortised cost of Tyre replacement [Refer WN-3] 177.78 133.33
Amortised cost of Battery replacement [Refer WN-4] 66.67 4,500
1,544.45 6,283.33
C Fixed cost:
Depreciation [Refer WN-1] 4,583.33 10,000
Driver’s salary 20,000 20,000
Garage rent 4,500 4,500
Share of Office & Administration cost 1,500 1,500
30,583.33 36,000
D Operating cost per month [A+B+C] 36,627.78 43,708.33
Solution 10 :
b) Operating Cost Statement
Particulars Total Cost Per
annum (₹)
A. Fixed Charges:
Insurance 15,600
Garage rent (₹ 2,400 × 4 quarters) 9,600
Road Tax 5,000
Salary of operating staff (₹ 7,200 × 12 months) 86,400
Depreciation 68,000
Total (A) 1,84,600
B. Variable Charges:
Repairs (₹ 4,800 × 4 quarters) 19,200
Tyres and Tubes (₹ 3,600 × 4 quarters) 14,400
Diesel {(1,80,000 km. ÷ 5 km.) × ₹ 13} 4,68,000
Oil and Sundries {(1,80,000 km. ÷ 100 km.) ×₹ 22} 39,600
Total (B) 5,41,200
Total Operating Cost (A+B) 7,25,800
Add: Passenger tax (Refer to WN-1) 3,01,275
Add: Profit (Refer to WN-1) 3,42,359
Total takings 13,69,434
Calculation of Cost per passenger kilometre and one way fare per passenger:
𝑇𝑜𝑡𝑎𝑙 𝑂𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝐶𝑜𝑠𝑡
Cost per Passenger-Km. = 𝑇𝑜𝑡𝑎𝑙 𝑝𝑎𝑠𝑠𝑒𝑛𝑔𝑒𝑟 − 𝑘𝑚
₹7,25,800
= 40,32,000 𝑃𝑎𝑠𝑠𝑒𝑛𝑔𝑒𝑟−𝑘𝑚 = ₹ 0.18
𝑇𝑜𝑡𝑎𝑙 𝑇𝑎𝑘𝑖𝑛𝑔𝑠
One way fare per passenger = 𝑇𝑜𝑡𝑎𝑙 𝑃𝑎𝑠𝑠𝑒𝑛𝑔𝑒𝑟 − 𝐾𝑚
× 30 𝐾𝑚
₹13,69,434
= 40,32,000 𝑃𝑎𝑠𝑠𝑒𝑛𝑔𝑒𝑟 − 𝐾𝑚
×30 km = ₹10.20
Working Notes:
1. Let total taking be X then Passenger tax and profit will be as follows:
X = ₹ 7,25,800 + 0.22 X + 0.25X
X – 0.47 X = ₹ 7,25,800
₹7,25,800
X = 0.53 = ₹ 13,69,434
Passenger tax = ₹ 13,69,434 × 0.22 = ₹ 3,01,275
Profit = ₹ 13,69,434 × 0.25 = ₹ 3,42,359
2. Total Kilometres to be run during the year
= 30 km.× 2 sides × 10 trips × 25 days × 12 months = 1,80,000 Kilometres
3. Total passenger Kilometres
= 1,80,000 km. × 32 passengers × 70% = 40,32,000 Passenger- km.
Insurance 50
License, Tax etc 80
Interest 40
Other Overheads 190
Depreciation
(54,000−36,000) 300
5×12
(C) 660
Total Cost (A + B + C) 2,700
(i) Cost per days maintained = ₹ 2700/30 days = ₹ 90
(ii) Cost per days operated = ₹ 2700/25 days = ₹ 108
(iii) Cost per hours operated = ₹ 2700/300 hours = ₹ 9
(iv) Cost per kilometres covered = ₹ 2700/2500 kms = ₹ 1.08
(v) Cost per commercial tonne kms= ₹ 2700/5000 tonne kms = ₹ 0.54
*Commercial tonne kms = Total distance travelled x Average load
(4 𝑡𝑜𝑛𝑛𝑒𝑠 + 0 𝑡𝑜𝑛𝑛𝑒𝑠)
= 2
x 2500 kms
= 5000 tonne kms
Solution 1 :
Calculation of actual hours
𝑉𝑎𝑟𝑖𝑎𝑏𝑙𝑒 𝑓𝑎𝑐𝑡𝑜𝑟𝑦 𝑜𝑣𝑒𝑟ℎ𝑒𝑎𝑑 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡 16
Standard rate per hour = 𝑆𝑡𝑎𝑛𝑑𝑎𝑟𝑑 𝑡𝑖𝑚𝑒 𝑓𝑜𝑟 𝑜𝑛𝑒 𝑢𝑛𝑖𝑡 𝑜𝑓 𝑜𝑢𝑡𝑝𝑢𝑡 = 0.8 = ₹ 20
Variable Overhead Efficiency Variance:
(Standard hours for actual production – Actual hours) × Standard rate per hour
Let actual hours be x
[(87,600 × 0.8) – x] ×20 = -67,200
(70,080 – x) × 20 = -67,200
x = 73,440
The solution can also be presented in following way based on Quantity (units)
Solution 2 :
Workings:
1. Calculation of Standard Qty. of Explosives and Detonators for actual output:
Particulars Iron ore Overburden (OB) Total
SME:
A Actual Output 20,000 tonne 58,000 M3
B Standard Qty per unit 2.4 kg./tonne 1.9 kg./M3
C Standard Qty. for 48,000 kg. 1,10,200 kg. 1,58,200 kg.
actual production [A×B]
Detonators:
D Standard Qty per unit 2 pcs/tonne 2 pcs/𝑀3
E Standard Qty. for actual 40,000 pcs. 1,16,000 pcs 1,56,000 pcs
production [AxD]
Solution 3 :
(a) (i)Statement Showing Cost Elements Equivalent Units of Performance and the Actual Cost per
Equivalent Unit
Detail of Returns Detail of Details Equivalent Units
Input Output Labour Overheads
Units Units Units % Units %
Returns in 200Returns 900 900 100 900 100
Process Completed in
at Start July
Returns Started in July 825Returns in 125 100 80 100 80
Process at the
end of July
1,025 1,025 1,000 1,000
Solution 4 :
Budgeted Production 30,000 hours ÷ 6 hours per unit = 5,000 units
Budgeted Fixed Overhead Rate = ₹ 4,50,000 ÷ 5,000 units = ₹ 90 per unit Or
= ₹ 4,50,000 ÷ 30,000 hours = ₹ 15 per hour.
(i) Material Cost Variance = (Std. Qty. × Std. Price) – (Actual Qty. × Actual Price)
= (4,800 units × 15 kg. × ₹15) - ₹ 9,85,000
= ₹ 10,80,000 – ₹ 9,85,000 = ₹ 95,000 (F)
(ii) Labour Cost Variance = (Std. Hours × Std. Rate) – (Actual Hours × Actual rate)
= (4,800 units × 6 hours × ₹ 5) – ₹1,40,000
= ₹ 1,44,000 – ₹ 1,40,000 = ₹ 4,000 (F)
(iii)Fixed Overhead Cost Variance = (Budgeted Rate × Actual Qty) – Actual Overhead
= (₹ 90 x 4,800 units) – ₹ 4,70,000 = ₹ 38,000 (A)
OR
= (Budgeted Rate × Std. Hours) – Actual Overhead
= (₹ 15 x 4,800 units × 6 hours) – ₹ 4,70,000 = ₹ 38,000 (A)
(iv)Variable Overhead Cost Variance = (Std. Rate × Std. Hours) – Actual Overhead
= (4,800 units × 6 hours × ₹ 12) - ₹ 3,60,200
= ₹ 3,45,600 - ₹ 3,60,200 = ₹ 14,600 (A)
Solution 5 :
SR – Standard labour Rate per Hour
AR – Actual labour rate per hour
SH – Standard Hours AH – Actual hours
(i) Labour rate Variance = AH (SR – AR)
Or 17,094 (8 – AR) = 68,376(A)
Or 17,094 (8 – AR) = - 68,376
Or 8 – AR = -4 Or AR = ₹12
𝑆𝐻
(ii) Labour Efficiency = 𝐴𝐻
x 100 = 105.3
𝐴𝐻 𝑋 105.3 17,094 𝑋 105.3
= SH = 100
= 100
= 17,999.982
= SH = 18,000 hours
(iii) Labour Efficiency Variance = SR (SH – AH)
= 8(18,000 – 17,094)
= 8 X 906
= ₹ 7,248(F)
18,000 𝑋 8
(iv)Standard Labour Cost per Unit = 6,000
= ₹ 24
17,094 𝑋 12
(v)Actual Labour Cost Per Unit = 6,000
= ₹ 34.19
Solution 6 :
Workings:
1. Calculation of Standard Qty. of Explosives and Detonators for actual output:
Particulars Coal Overburden (OB) Total
SME:
A Actual Output 20,000 tonne 58,000 M3
B Standard Qty per unit 2.4 kg./ tonne 1.9 kg./M3
C Standard Qty. for actual 48,000 kg. 1,10,200 kg. 1,58,200 kg.
production [A×B]
Detonators:
D Standard Qty per unit 2 pcs/ tonne 2 pcs/ M3
E Standard Qty. for actual 40,000 pcs. 1,16,000 pcs 1,56,000 pcs
production [A × D]
Solution 7 :
(i) Material Usage Variance = Std. Price (Std.Quantity – Actual Quantity)
= ₹ 45 (9,000 kgs. – 8,900 kgs.)
= ₹ 4,500 (Favourable)
(ii) Material Price Variance = Actual Quantity (Std. Price – Actual Price)
= 8,900 kgs. (₹ 45 – ₹ 46)
= ₹ 8,900 (Adverse)
(iii) Material Cost Variance = Std. Material Cost – Actual Material Cost
= (SQ × SP) – (AQ × AP)
= (9,000 kgs. × ₹ 45) – (8,900 kgs. × ₹ 46)
= ₹ 4,05,000 – ₹ 4,09,400
= ₹ 4,400 (Adverse)
(iv) Labour Efficiency Variance = Std. Rate (Std. Hours – Actual Hours)
9,000
= ₹ 50 ( 10 ×8hours – 7,000 hrs.)
= ₹ 50 (7,200 hrs. – 7,000 hrs.)
= ₹ 10,000 (Favourable)
(v) Labour Rate Variance = Actual Hours (Std. Rate – Actual Rate)
= 7,000 hrs. (₹ 50 – ₹ 52)
= ₹ 14,000 (Adverse)
(vi) Labour Cost Variance = Std. Labour Cost – Actual Labour Cost
= (SH × SR) – (AH × AR)
= (7,200 hrs. × ₹ 50) – (7,000 hrs. × ₹ 52)
= ₹ 3,60,000 – ₹ 3,64,000
= ₹ 4,000 (Adverse)
(vii) Variable Overhead Cost Variance = Std. Overhead for Actual Production – Actual Variable Overhead
Cost
= (7,200 hrs. × ₹ 10) – ₹ 72,500
= ₹ 500 (Adverse)
(viii) Fixed Overhead Cost Variance = Absorbed Fixed Overhead – Actual Fixed Overhead
₹200
= 10 𝑘𝑔𝑠 ×9,000kgs.- ₹1,92,000
= ₹ 1,80,000 – ₹ 1,92,000
= ₹ 12,000 (Adverse)
Solution 1 :
Statement of profit
Particulars ₹
Selling Price 15 per unit
Less : Variable cost 12 per unit
Contribution 3 per unit
Capacity 60,000 units
Total contribution (60,000 units × ₹ 3) 1,80,000
Less: Fixed Cost 4,20,000
Loss (2,40,000)
Shut down cost
Particular ₹
Fixed cost 1,70,000
Additional cost 25,000
Shut down cost 1,95,000
(i) Since the loss of Noida plant exceeds shut down cost it is better to shut down the plant.
𝑇𝑜𝑡𝑎𝑙 𝑓𝑖𝑥𝑒𝑑 𝑐𝑜𝑠𝑡−𝑆ℎ𝑢𝑡 𝑑𝑜𝑤𝑛 𝑐𝑜𝑠𝑡
(ii) Shut down point: 𝐶𝑜𝑛𝑡𝑟𝑖𝑏𝑢𝑡𝑖𝑜𝑛 𝑝𝑒𝑟 𝑢𝑛𝑖𝑡
4,20,000−1,95,000
3
= 75,000 units
Solution 2 :
(i) Contribution per unit = Selling price – Variable cost
= ₹ 100 – ₹ 60
= ₹ 40
₹24,00,000
Break-even Point = ₹40
= 60,000 units
𝐴𝑐𝑡𝑢𝑎𝑙 𝑆𝑎𝑙𝑒𝑠−𝐵𝑟𝑒𝑎𝑘𝑒𝑣𝑒𝑛 𝑠𝑎𝑙𝑒𝑠
Percentage Margin of Safety = 𝐴𝑐𝑡𝑢𝑎𝑙 𝑠𝑎𝑙𝑒𝑠
𝐴𝑐𝑡𝑢𝑎𝑙 𝑆𝑎𝑙𝑒𝑠−60,000 𝑢𝑛𝑖𝑡𝑠
Or, 60% = 𝐴𝑐𝑡𝑢𝑎𝑙 𝑆𝑎𝑙𝑒𝑠
Actual Sales = 1,50,000 units
(₹)
Sales Value (1,50,000 units × ₹ 100) 1,50,00,000
Less: Variable Cost (1,50,000 units × ₹ 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
Rate of Net Return on Sales = 14.40% ( ₹21,60,000
₹1,50,00,000
× 100 )
(ii) Products
X (₹) Y (₹)
Selling Price per unit 100 150
Variable Cost per unit 60 100
Contribution per unit 40 50
Composite contribution will be as follows:
40
(
Contribution per unit = 8 × 5 + 8 × 3
50
) ( )
= 25 + 18.75 = ₹ 43.75
Break-even Sale = 64,000 units (
₹28,00,000
₹43.75 )
Break-even Sales Mix:
X (64,000 units × 5/8) = 40,000 units
Y (64,000 units × 3/8) = 24,000 units
Solution 4 :
𝐹𝑖𝑥𝑒𝑑 𝐶𝑜𝑠𝑡
(i) Break-even sales = 𝑃/𝑉 𝑅𝑎𝑡𝑖𝑜
𝐶ℎ𝑎𝑛𝑔𝑒 𝑖𝑛 𝑃𝑟𝑜𝑓𝑖𝑡 ₹37,50,000
P/V Ratio = 𝐶ℎ𝑎𝑛𝑔𝑒 𝑖𝑛 𝑆𝑎𝑙𝑒𝑠
× 100 or, ₹7,80,60,000−₹5,93,10,000
× 100
₹37,50,000
Or, ₹1,87,50,000 × 100 or 20%
₹98,50,000
Break-even sales = 20%
= ₹4,92,50,000
Solution 5 :
Statement Showing “Operating Loss”
If Plant is Continued If Plant is Shutdown
Sales 7,60,000 ---
Less: Variable Cost 5,70,000 ---
Contribution 1,90,000 ---
Less: Fixed Cost 3,50,000 1,30,000
Less: Additional Cost --- 15,000
Operating Loss 1,60,000 1,45,000
Decision on Shut Down
A comparison of loss figures (indicated as above) points out that loss is reduced by ₹15,000
(₹ 1,60,000 - ₹ 1,45,000) if plant is shut down.
→ Accordingly, plant should be Shut Down.
₹3,50,000−₹1,45,000
Shut Down Point = ₹8−₹6
= 1,02,500 units
Capacity Level at Shut Down Point (%)
At 100% Level – Production Capacity
95,000 𝑢𝑛𝑖𝑡𝑠
= 1,18,750 × 0.80
Capacity Level at Shut Down Point
( )
1,02,500 𝑢𝑛𝑖𝑡𝑠
= 86.32% 1,18,750 𝑢𝑛𝑖𝑡𝑠
Other data:
(i) The variable overheads are absorbed on a machine hour basis at a rate of ₹ 1.20 per machine hour.
(ii) Fixed overheads total ₹ 46,84,000 per annum.
(iii) Production capacity available 8,15,000 machine hours per annum.
(iv) Products P, Q and R can be bought-in at ₹ 21.36 per unit, ₹ 24 per unit and ₹ 48 per unit respectively.
You are required to calculate Best product mix and Profitability statement for the year.
Solution 6 :
(a) (i) Statement Showing “Calculation of Contribution/ unit”
P (₹) Q (₹) R (₹) S (₹)
Selling Price …(A) 23.88 28.68 55.08 47.88
Variable Cost
Direct Material 10.08 13.20 30.48 24.96
Direct Labour 4.08 4.08 6.72 6.36
Variable Overheads 1.44 1.44 2.40 2.16
Total Variable Cost …(B) 15.60 18.72 39.60 33.48
Contribution per unit …(A) - (B) 8.28 9.96 15.48 14.40
Solution 7 :
(i) Statement of Profit under Absorption Costing
Workings:
1. Calculation of full production cost
(₹)
Direct Materials (4 kg. × ₹ 120) 480
Direct labour (6 hours × ₹ 60) 360
Variable production Overhead (150% of ₹ 360) 540
Total Variable cost 1,380
(
₹60,00,000
Fixed production overhead 60,000𝑢𝑛𝑖𝑡𝑠 ) 100
1,480
Solution 8 :
Total Fixed Cost = ₹ 6,00,000 + ₹20,00,000 + ₹8,00,000 + ₹ 2,00,000 = ₹ 36,00,000
Contribution per unit = ₹600 - ₹470 = ₹130
Solution 9 :
Working Notes:
Solution 10 :
(1) Comparative Profitability Statements
Particulars Process- A (₹) Process- B (₹)
Selling Price per unit 20.00 20.00
Less: Variable Cost per unit 12.00 14.00
Contribution per unit 8.00 6.00
32,00,000 24,00,000
Total Contribution
(₹ 8 × 4,00,000) (₹ 6 × 4,00,000)
Less: Total fixed costs 30,00,000 21,00,000
Profit 2,00,000 3,00,000
Capacity (units) 4,30,000 5,00,000
34,40,000 30,00,000
Total Contribution at full capacity
(₹ 8 × 4,30,000) (₹ 6 × 5,00,000)
Fixed Cost 30,00,000 21,00,000
Profit 4,40,000 9,00,000
Process - B gives more profit.
(2)
Particulars Process- A (₹) Process- B (₹)
*Capacity (units) 6,00,000 5,00,000
48,00,000 30,00,000
Total contribution
(₹ 8 × 6,00,000) (₹ 6 × 5,00,000)
Fixed Cost 30,00,000 21,00,000
Profit 18,00,000 9,00,000
Process-A be chosen.
*Note: It is assumed that capacity produced equals sales.
Solution 11 :
Workings:
Calculation of Cost of Goods Sold (COGS):
COGS = {(DM- 0.3 COGS) + (DL- 0.15 COGS) + (FOH- 0.10 COGS +
₹ 2,30,000) + (G&AOH- 0.02 COGS + ₹ 71,000)} Or COGS = 0.57 COGS + ₹ 3,01,000
₹3,01,000
Or COGS = 0.43
= ₹ 7,00,000
Calculation of Cost of Sales (COS):
COS = COGS + (S&DOH- 0.04 COS + ₹ 68,000)
Or COS = ₹ 7,00,000 + (0.04 COS + ₹ 68,000)
₹7,68,000
Or COS = 0.96 = ₹ 8,00,000
Standard Quantity of closing stock for the period September 2023 to December 2023 is as follows:
(in units)
Hot Coffee Cold Coffee Fruit Juice Carbonated Soft Drink
September 2023 12,000 13,000 11,000 7,500
October 2023 15,000 14,000 12,000 5,500
November 2023 13,000 15,000 10,000 6,000
December 2023 11,000 16,000 13,000 7,000
You are required to prepare a Production Budget (in units) and Sales Budget (in units and sales value) for the
months of October, November and December 2023.
Solution 1 :
Production Budget (in units)
Particulars Hot Coffee Cold Coffee Fruit Juice Carbonated Soft Drink
October 2023
Sales* 2,10,000 2,38,000 3,36,000 60,000
Add: Closing stock 15,000 14,000 12,000 5,500
Total Quantity Required 2,25,000 2,52,000 3,48,000 65,500
Less: Opening stock 12,000 13,000 11,000 7,500
Production 2,13,000 2,39,000 3,37,000 58,000
November 2023
Sales* 3,15,000 1,66,600 3,36,000 50,000
Add: Closing stock 13,000 15,000 10,000 6,000
Total Quantity Required 3,28,000 1,81,600 3,46,000 56,000
Less: Opening stock 15,000 14,000 12,000 5,500
Production 3,13,000 1,67,600 3,34,000 50,500
December 2023
Sales* 4,72,500 1,16,620 3,36,000 30,000
Add: Closing stock 11,000 16,000 13,000 7,000
Total Quantity Required 4,83,500 1,32,620 3,49,000 37,000
Less: Opening stock 13,000 15,000 10,000 6,000
Production 4,70,500 1,17,620 3,39,000 31,000
*sales units are taken from sales budget
Solution 2 :
(b) 1,90,000 units
Units
Sales budget 2,00,000
Add: Closing Inventory (25,000 x 0.6) 15,000
Less: Opening Inventory (25,000)
Production Budget 1,90,000
Solution 3 :
Workings
Statement Showing “Total Variable Cost for the year”
Particulars Amount (₹)
Estimated Sales Revenue 3,02,40,000
Less: Desired Profit Margin on Sale @ 20% 60,48,000
Estimated Total Cost 2,41,92,000
Less: Fixed Selling and Distribution Overheads 69,12,000
Total Variable Cost 1,72,80,000
Solution 6 :
(a) (i) Production Budget (in units) for the year ended 31st March 2023
Product M Product N
Budgeted sales (units) 28,000 13,000
Add: Increase in closing stock 320 160
No. good units to be produced 28,320 13,160
Post production rejection rate 4% 6%
No. of units to be produced 29,500 14,000
( 28,320
0.96 ) ( 13,160
0.94 )
(ii) Purchase budget (in kgs and value) for Material Z
Product M Product N
No. of units to be produced 29,500 14,000
Usage of Material Z per unit of production 5 kg. 6 kg.
Material needed for production 1,47,500 kg. 84,000 kg.
Materials to be purchased 1,63,889 kg. 88,421 kg.
( 1,47,500
0.90 ) ( 84,000
0.95 )
Total quantity to be purchased 2,52,310 kg.
Rate per kg. of Material Z ₹36
Total purchase price ₹90,83,160
Solution 7 :
(i) Preparation of Production Budget (in units)
October November December January
Demand for the month (Nos.) 40,000 35,000 45,000 60,000
Add: 20% of next month’s demand 7,000 9,000 12,000 13,000
Less: Opening Stock (9,500) (7,000) (9,000) (12,000)
Vehicles to be produced 37,500 37,000 48,000 61,000
Product X Product Y
Sales (units) 28,000 13,000
Finished goods stock increase by year-end 320 160
Post-production rejection rate (%) 4 6
Material Z usage (per completed unit, net of wastage) 5 kg 6 kg
Material Z wastage (%) 10 5
Additional information:
● Usage of raw material Z is expected to be at a constant rate over the period.
● Annual cost of holding one unit of raw material in stock is 11% of the material cost.
● The cost of placing an order is ₹ 15,600 per order.
● The management of P Ltd. has decided that there should not be more than 40 orders in a year for the
raw material Z.
Required:
(a) (i) Prepare Production budget for Products X and Y (in units) for the year ended 31st March 2025.
(ii) Calculate the Economic Order Quantity for Material Z (in kgs).
(b)Prepare Purchases budget for Material Z (in kgs and value) for the year ended 31st March 2025.
(c)If there is a sole supplier for the raw material Z in the market and the supplier do not sale more than 4,000
kg. of material Z at a time. Keeping the management purchase policy and production quantity mix into
consideration, calculate the maximum number of units of Product X and Y that could be produced.
Solution 8 :
(a) (i) Production Budget (in units) for the year ended 31st March 2025
Product X Product Y
Budgeted sales (units) 28,000 13,000
Add: Increase in closing stock 320 160
No. good units to be produced 28,320 13,160
Post production rejection rate 4% 6%
No. of units to be produced 29,500 14,000
( 28,320
0.96 ) ( 13,160
0.94 )
(ii) Calculation of Economic Order Quantity for Material Z
2×2,52,310×15,600 5,04,620×15,600
EOQ = 72×11%
= 72×11%
= 31,526.95 kg.
(b) Purchase budget (in kgs and value) for Material Z
Product X Product Y
No. of units to be produced 29,500 14,000
Usage of Material Z per unit of 5 kg. 6 kg.
production
Material needed for production 1,47,500 kg. 84,000 kg.
Materials to be purchased 1,63,889 kg. 88,421 kg.
( 1,47,500
0.90 ) ( 84,000
0.95 )
Total quantity to be purchased 2,52,310 kg.
Rate per kg. of Material Z ₹72
Total purchase price ₹1,81,66,320
(c)
Since, the maximum number of orders per year cannot be more than 40 orders and the maximum quantity per
order that can be purchased is 4,000 kg. Hence, the total quantity of Material Z that can be available for
production:
= 4,000 kg. × 40 orders =1,60,000 kg.
Product X Product Y
Material needed for 1,03,929 kg. 56,071 kg.
production to maintain the
same production mix
( 1,63,889
1, 60, 000 × 2,52,310 ) ( 88,421
1, 60, 000 × 2,52,310 )
Less: Process wastage 10,393 kg. 2,804 kg.
Net Material available for 93,536 kg. 53,267 kg.
production
Units to be produced 18,707 units 8,878 units
( 93,536𝑘𝑔
5 𝐾𝑔 ) ( 53,267𝑘𝑔
6 𝐾𝑔 )
Solution 9 :
(a) Flexible Budget for different levels
₹ ₹ ₹ ₹ ₹
No. of Students 60 90 120 150 180
VARIABLE COST
Since semi-fixed costs relate to a block of 50 students, the fixed and semi-variable cost for three level will be:
Level of Student 51–100 101–150 151-200
Fixed + Semi–variable cost (₹) 19,000 27,000 35,000
Contribution per unit (₹) 220 220 220
Break Even level of students 86 123 159
Solution 10 :
Statement Showing Sales Budget for 2023-24
Product X Product Y Total
Division Qty. Rate (₹) Amt. (₹) Qty. Rate (₹) Amt. (₹) Amt. (₹)
Workings
1. 400 × 110% + 60 = 500 units
2. 600 × 105% + 70 = 700 units
3. 300 × 120% + 40 = 400 units
4. 500 × 110% + 50 = 600 units
Statement Showing Sales Budget for 2022-23
Product X Product Y Total
Division
Qty. Rate (₹) Amt. (₹) Qty. Rate (₹) Amt. (₹) Amt. (₹)
East 400 9 3,600 300 21 6,300 9,900
West 600 9 5,400 500 21 10,500 15,900
Total 1,000 9,000 800 16,800 25,800
Solution 11 :
Revenue Budget (Flexible Budget) of M Ltd. for the Year 2024
Particulars PY 2023 CY 2024
Working Notes:
1. At 80% level of capacity (current year), the production is 80,000 units.
Thus, total level of capacity is 1,00,000 units.
Therefore, Year 2 is at 70% capacity and Year 3 is at 60% capacity as the production is increasing
by 10% of its capacity consistently.
2. Direct Material
(₹) (₹)
80% Capacity 16,00,00070% Capacity 14,00,000
70% Capacity 14,00,00060% Capacity 12,00,000
10% change in capacity 2,00,00010% change in capacity 2,00,000
For 10% increase in capacity, the total direct material cost regularly changes by ₹ 2,00,000
Thus, Direct material cost (variable) = ₹ 2,00,000 ÷ 10,000
= ₹ 20
After 10% increase in price, direct material cost per unit = ₹ 20 ×
1.10 = ₹ 22
Direct material cost at 90,000 budgeted units = 90,000 × ₹ 22
= ₹ 19,80,000
3. Direct labour:
(₹) (₹)
80% Capacity 8,00,00070% Capacity 7,00,000
70% Capacity 7,00,00060% Capacity 6,00,000
10% change in capacity 1,00,00010% change in capacity 1,00,000
For 10% increase in capacity, direct labour cost regularly changes by ₹ 1,00,000.
Direct labour cost per unit = ₹ 1,00,000 ÷ 10,000 = ₹ 10
After 20% increase in price, direct labour cost per unit = ₹ 10 × 1.20 = ₹ 12
Direct labour for 90,000 units = 90,000 units × ₹ 12 = ₹ 10,80,000.