Costing RTP Nov 18 Inter New
Costing RTP Nov 18 Inter New
com
m
Normal usage 425 parts per week
co
Minimum usage 140 parts per week
Maximum usage 710 parts per week
Lead time to supply 3-5 weeks s.
te
COMPUTE from the above:
o
(i) Economic Order Quantity (EOQ). If the supplier is willing to supply quarterly 30,000
yn
Employee Cost
.c
2. A job can be executed either through workman A or B. A takes 32 hours to complete the
w
job while B finishes it in 30 hours. The standard time to finish the job is 40 hours.
w
The hourly wage rate is same for both the workers. In addition workman A is entitled to
receive bonus according to Halsey plan (50%) sharing while B is paid bonus as per Rowan
w
plan. The works overheads are absorbed on the job at ` 7.50 per labour hour worked. The
factory cost of the job comes to ` 2,600 irrespective of the workman engaged.
INTERPRET the hourly wage rate and cost of raw materials input. Also show cost against
each element of cost included in factory cost.
Overheads: Absorption Costing Method
3. Sree Ajeet Ltd. having fifteen different types of automatic machines furnishes information
as under for 20X8-20X9
(i) Overhead expenses: Factory rent ` 1,80,000 (Floor area 1,00,000 sq. ft.), Heat and
gas ` 60,000 and supervision ` 1,50,000.
(ii) Wages of the operator are ` 200 per day of 8 hours. Operator attends to one machine
when it is under set up and two machines while they are under operation.
In respect of machine B (one of the above machines) the following particulars are
furnished:
(i) Cost of machine `1,80,000, Life of machine- 10 years and scrap value at the end of
its life ` 10,000
(ii) Annual expenses on special equipment attached to the machine are estimated as
` 12,000
(iii) Estimated operation time of the machine is 3,600 hours while set up time is 400 hours
per annum
m
(iv) The machine occupies 5,000 sq. ft. of floor area.
(v) Power costs ` 5 per hour while machine is in operation.
co
ESTIMATE the comprehensive machine hour rate of machine B. Also find out machine
costs to be absorbed in respect of use of machine B on the following two work orders
s.
te
Work order- 1 Work order-2
Machine set up time (Hours) 15 30
o
Machine operation time (Hours) 100 190
yn
4. Family Store wants information about the profitability of individual product lines: Soft
tu
drinks, Fresh produce and Packaged food. Family store provides the following data for the
as
m
(i) Family store currently allocates support cost (all cost other than cost of goods sold)
co
to product lines on the basis of cost of goods sold of each product line. CALCULATE
the operating income and operating income as a % of revenues for each product line.
s.
(ii) If Family Store allocates support costs (all costs other than cost of goods sold) to
product lines using and activity based costing system, CALCULATE the operating
te
income and operating income as a % of revenues for each product line.
o
Cost Sheet
yn
5. From the following data of Arnav Metallic Ltd., CALCULATE Cost of production:
d
Amount (`)
tu
(i) Repair & maintenance paid for plant & machinery 9,80,500
as
- Others 11,60,000
(xiii) Amount realised by selling scrap generated during the 9,200
manufacturing process
(xiv) Packing cost necessary to preserve the goods for further 10,200
processing
(xv) Salary paid to Director (Technical) 8,90,000
Cost Accounting System
6. The financial books of a company reveal the following data for the year ended 31 st March,
20X8:
m
Opening Stock: (`)
Finished goods 625 units 53,125
co
Work-in-process 46,000
01.04.20X7 to 31.03.20X8
s.
te
Raw materials consumed 8,40,000
Direct Labour 6,10,000
o
yn
Work-in-process 41,200
The cost records provide as under:
➢ Factory overheads are absorbed at 70% of direct wages.
➢ Administration overheads are recovered at 15% of factory cost.
➢ Selling and distribution overheads are charged at ` 3 per unit sold.
➢ Opening Stock of finished goods is valued at ` 120 per unit.
➢ The company values work-in-process at factory cost for both Financial and Cost Profit
Reporting.
Required:
(i) PREPARE a statements for the year ended 31 st March, 20X8. Show
➢ the profit as per financial records
➢ the profit as per costing records.
(ii) PREPARE a statement reconciling the profit as per costing records with the profit as
per Financial Records.
Contract Costing
7. A construction company undertook a contract at an estimated price of ` 108 lakhs, which
includes a budgeted profit of ` 18 lakhs. The relevant data for the year ended 31.03.20X8
are as under:
m
(` ‘000)
co
Materials issued to site 5,000
Direct wages paid
Plant hired s. 3,800
700
te
Site office costs 270
o
Materials returned from site 100
yn
this contract till the end of 31.02.20X8, it was valued at ` 5,00,000. This cost of materials at
w
site at the end of the year was estimated at ` 18,00,000 Direct wages accrued as on
31.03.20X8 was ` 1,10,000.
w
Required
w
PREPARE the Contract Account for the year ended 31 st March, 20X8.
Job Costing
8. A company has been asked to quote for a job. The company aims to make a net profit of
30% on sales. The estimated cost for the job is as follows:
Direct materials 10 kg @`10 per kg
Direct labour 20 hours @ `5 per hour
Variable production overheads are recovered at the rate of ` 2 per labour hour.
Fixed production overheads for the company are budgeted to be `1,00,000 each
year and are recovered on the basis of labour hours.
There are 10,000 budgeted labour hours each year. Other costs in relation to
selling, distribution and administration are recovered at the rate of `50 per job.
DETERMINE quote for the job by the Company.
Process Costing
9. From the following information for the month of January, 20X9, PREPARE Process-III cost
accounts.
Opening WIP in Process-III 1,600 units at ` 24,000
m
Transfer from Process-II 55,400 units at ` 6,23,250
Transferred to warehouse 52,200 units
co
Closing WIP of Process-III 4,200 units
Units Scrapped
s. 600 units
te
Direct material added in Process-III ` 2,12,400
Direct wages ` 96,420
o
yn
The normal loss in the process was 5% of the production and scrap was sold @ ` 5 per
w
unit.
w
(Students may treat material transferred from Process – II as Material – A and fresh
material used in Process – III as Material B)
Joint Products & By Products
10. In an Oil Mill four products emerge from a refining process. The total cost of input duri ng
the quarter ending March 20X8 is `1,48,000. The output, sales and additional processing
costs are as under:
Products Output in Litres Additional processing Sales value
cost after split off
(`) (`)
ACH 8,000 43,000 1,72,500
m
(ii) If they are sold at the split off point.
co
Service Costing
11. Sanziet Lifecare Ltd. operates in life insurance business. Last year it has launched a new
s.
term insurance policy for practicing professionals ‘Professionals Protection Plus’. The
te
company has incurred the following expenditures during the last year for the policy:
o
Policy development cost `11,25,000
yn
`1,25,600
IT cost `74,32,000
.c
Standard Costing
12. Aaradhya Ltd.manufactures a commercial product for which the standard cost per unit is
as follows:
(`)
Material:
5 kg. @ ` 4 per kg. 20.00
Labour:
3 hours @ `10 per hour 30.00
Overhead
m
Variable: 3 hours @ `1 3.00
co
Fixed: 3 hours @ `0.50 1.50
Total 54.50
s.
During Jan. 20X8, 600 units of the product were manufactured at the cost shown below:
te
(`)
o
Materials purchased:
yn
Materials used:
tu
3,500 kg.
Direct Labour:
as
Total 38,600
w
The flexible budget required 1,800 direct labour hours for operation at the monthly activity
level used to set the fixed overhead rate.
COMPUTE:
(a) Material price variance, (b) Material Usage variance; (c) Labour rate variance; (d)
Labour efficiency variance; (e) Variable overhead expenditure variance; (f) Variable
overhead efficiency variance; (g) Fixed overhead expenditure variance; (h) Fixed overhead
volume variance; (i) Fixed overhead capacity variance; and (j) Fixed overhead efficiency
variance.
Also RECONCILE the standard and actual cost of production.
Marginal Costing
13. A company sells its product at ` 15 per unit. In a period, if it produces and sells 8,000
units, it incurs a loss of ` 5 per unit. If the volume is raised to 20,000 units, it earns a profit
of ` 4 per unit. CALCULATE break-even point both in terms of rupees as well as in units.
Budget and Budgetary Control
14. Gaurav Ltd. is drawing a production plan for its two products Minimax (MM) and Heavyhigh
(HH) for the year 20X8-X9. The company’s policy is to hold closing stock of finished goods
at 25% of the anticipated volume of sales of the succeeding month. The following are the
estimated data for two products:
m
Minimax (MM) Heavyhigh (HH)
co
Budgeted Production units 1,80,000 1,20,000
s. (`) (`)
te
Direct material cost per unit 220 280
o
Direct labour cost per unit 130 120
yn
The estimated units to be sold in the first four months of the year 20X8-X9 are as under
tu
Miscellaneous
w
15. (a) DISCUSS the essential features of a good cost accounting system.
(b) EXPLAIN the difference between Cost Control and Control Reduction.
(c) DEFINE Controllable Cost and Uncontrollable Cost.
(d) DISTIGUISH between job and batch costing.
SUGGESTED HINTS/ANSWERS
1. (1) A = Annual usage of parts = Monthly demand for monitors × 4 parts × 12 months
= 2,000monitors × 4 parts × 12 months = 96,000units
O = Ordering cost per order = ` 1,000/- per order
C1 = Cost per part =` 350/-
i C1 = Inventory carrying cost per unit per annum
= 20% × ` 350 = ` 70/- per unit, per annum
Economic order quantity (EOQ):
E.O.Q =
2AO
=
2 96,000 units `1,000
om
iC1 `70
. c
= 1,656 parts (approx.)
es
The supplier is willing to supply 30,000 units at a discount of 5%, therefore cost of
each part shall be `350 – 5% of 350 = `332.5
ot
Total cost (when order size is 30,000 units):
y n
= Cost of 96,000 units + Ordering cost + Carrying cost.
` 332.50) s t
30,000 units 2
c a
= `3,19,20,000 + `3,200* + `9,97,500= `3,29,20,700
.
Total cost (when order size is 1,656 units):
w 96,000 units 1
w
= (96,000 units × `350) +
1,656 units
× ` 1,000 + (1,656 units × 20% × `350)
2
w
= `3,36,00,000 + `57,970* + `57,960 = `3,37,15,930
Since, the total cost under the supply of 30,000 units with 5% discount is lower than
that when order size is 1,656 units, therefore the offer should be accepted.
Note: While accepting this offer consideration of capital blocked on order size of
30,000 units has been ignored.
*Order size can also be taken in absolute figure.
(2) Reorder level
= Maximum consumption × Maximum re-order period
m
Workmen A B
co
Standard time (hrs.) 40 40
Actual time taken (hrs.) 32 30
Time saved (hrs.) s. 8 10
te
Wages paid @ ` x per hr. (`) 32x 30x
no
2. Bonus Plan:
dy
Halsey Rowan
Time saved (hrs.) 8 10
tu
8 hrs ` x 10 hrs
2 40 hrs 30hrs ` x
.c
3. Total wages:
w
m
(`)
co
Standing Charges:
Factory rent {(` 1,80,000/1,00,000 sq. ft.) × 5,000 Sq. ft.} 9,000
Heat and Gas (` 60,000/15 machines)
s. 4,000
te
Supervision (` 1,50,000/ 15 machines) 10,000
o
Depreciation [(` 1,80,000 – ` 10,000)/ 10 years] 17,000
yn
13.00 13.00
Power -- 5.00
w
m
(Refer working notes)
Total cost: (D) = {(B) + (C)} 39,00,000 97,50,000 58,50,000 1,95,00,000
o
Operating income: E= {(A)-(D)} 67,500 7,53,000 1,99,500 10,20,000
.c
Operating income as a percentage 1.70% 7.17% 3.30% 4.97%
of revenues: (E/A) × 100)
es
Working notes:
ot
1. Total support cost:
yn
(`)
ud
Delivery 12,60,000
Shelf stocking 8,64,000
a
= 100
Total cost of goods sold
` 45,00,000
100 = 30%
`1,50,00,000
3. Cost for each activity cost driver:
Activity Total cost Cost allocation base Cost driver rate
(`)
(1) (2) (3) (4) = [(2) ÷ (3)]
Ordering 7,80,000 1,560 purchase orders `500 per purchase order
m
Revenues: (A) 39,67,500 1,05,03,000 60,49,500 2,05,20,000
co
Cost & Goods sold 30,00,000 75,00,000 45,00,000 1,50,00,000
Bottle return costs 60,000 0 0 60,000
Ordering cost* 1,80,000 s.
4,20,000 1,80,000 7,80,000
te
(360:840:360)
o
Delivery cost* 1,20,000 8,76,000 2,64,000 12,60,000
yn
(300:2190:660)
Shelf stocking cost* 54,000 5,40,000 2,70,000 8,64,000
d
(540:5400:2700)
tu
(1,26,000:11,04,000:3,06,000)
.c
revenues
w
m
Less: Closing value of W-I-P (6,02,100)
co
1,05,47,000
Less: Amount realised by selling scrap (9,200)
Add: Primary packing cost
s. 10,200
te
Cost of Production 1,05,48,000
o
Notes:
yn
(i) Other administrative overhead does not form part of cost of production.
d
Finished Goods
w
m
Cost of sales:
Opening stock 75,000
co
(625 units ×` 120)
Add: Cost of production of 12,405 units
(Refer to working note 2) s. 21,63,350
te
Less: Closing stock (`174.39 × 415 units) (72,372)
o
Cost of goods sold (12,615 units) 21,65,978
yn
(12,615 units ×` 3)
tu
(`) (`)
w
m
Working notes:
co
1. Number of units produced
s. Units
te
Sales 12,615
Add: Closing stock 415
o
Total 13,030
yn
2. Cost Sheet
as
(` )
Raw materials consumed 8,40,000
.c
m
To Plant hire 700 - Value of work 10,000
certified
co
To Site office cost 270 - Work uncertified 230
To Direct expenses 500
s.
te
To Depreciation (special plant) 300
o
To Notional profit c/d 1,450
yn
12,130 12,130
d
tu
Cost (`)
Direct Material (10kg × `10) 100
.c
`1,00,000 200
w
Net profit is 30% of sales, therefore total costs represent 70% (` 490 × 100) ÷ 70 = ` 700
price to quote for job.
To check answer is correct; profit achieved will be ` 210 (` 700 - ` 490)
= ` 210 ÷ ` 700 = 30%
m
the month
co
Normal loss (5% 2,640 - - - - - -
of 52,800 units)
Closing WIP 4,200 100
s.
4,200 70 2,940 50 2,100
te
Abnormal Gain (2,040) 100 (2,040) 100 (2,040) 100 (2,040)
57,000 57,000 52,760 51,820 51,300
o
yn
Working note:
Production units = Opening units + Units transferred from Process -II – Closing Units
d
= 52,800 units
as
Statement of Cost
.c
units equivalent
units (`)
w
m
Completed- 50,600
units
co
Total cost of 52,200 9,70,422.36
finished goods units
Closing WIP units- Material A (4,200 s.
units × 48,563.34
te
4,200 ` 11.5627)
o
Material B (2,940 units × ` 4.0988) 12,050.47
yn
` 1.0994)
as
66,869.50
Abnormal gain units - (2,040 units × ` 18.6404) 38026.42
.c
2,040
w
* Difference in figure due to rounding off has been adjusted with closing WIP
10. (i) Statement of profitability of the Oil Mill (after carrying out further processing)
for the quarter ending 31st March 20X8.
Products Sales Value Share of Additional Total cost Profit
after further Joint cost processing after (loss)
processing cost processing
ACH 1,72,500 98,667 43,000 1,41,667 30,833
BCH 15,000 19,733 9,000 28,733 (13,733)
CSH 6,000 4,933 -- 4,933 1,067
DSH 45,000 24,667 1,500 26,167 18,833
2,38,500 1,48,000 53,500 2,01,500 37,000
m
(ii) Statement of profitability at the split off point
co
Products Selling Output in Sales value share of joint profit at split
price of units at split off cost off point
ACH
split off
15.00 8,000
point
s.
1,20,000 98,667 21,333
te
BCH 6.00 4,000 24,000 19,733 4,267
o
CSH 3.00 2,000 6,000 4,933 1,067
yn
Note: Share of Joint Cost has been arrived at by considering the sales value at split
off point.
as
11. (i) Calculation of total cost for ‘Professionals Protect Plus’ policy
.c
m
= (` 4 – ` 4.10) × 5,000 = ` 500 Adv.
o
(b) Material usage variance:
.c
= (Std. quantity for actual output – Actual qtty.) × Std. price
= (600 × 5 – 3,500) × 4 = ` 2,000 Adv.
es
(c) Labour Rate Variance:
ot
= (Standard rate – Actual rate) × Actual hours
yn
= (1,700 ×` 1) – ` 1,900
w
= ` 200 Adv.
(f) Variable Overhead Efficiency Variance:
= Std. hours for actual output – Actual hours) × Std. rate
= (600 × 3 – 1,700) × `1 = `100 Fav.
(g) Fixed Overhead Expenditure Variance:
= (Budgeted overhead – Actual overhead)
= (1,800 × 0.50 – 900) = Nil
m
Verification: (`) (`)
co
Overhead recovered: 600 units @ `4.50 2,700
Actual Overhead:
Variable s. 1,900
te
Fixed 900 2,800
o
100 Adv.
yn
Reconciliation Statement
w
13. We know that S – V = F + P (S - Sales, V - Variable cost, F - Fixed cost and P - Profit/loss)
Suppose variable cost = x per unit
Fixed Cost = y
When sales is 8,000 units, then
15 8,000 - 8,000 x = y - 40,000.................... (1)
When sales volume raised to 20,000 units, then
om
15 20,000 - 20,000 x = y + 80,000.............. (2)
Or, 1,20,000 – 8,000 x = y – 40,000.............. (3)
.c
And 3,00,000 – 20,000 x = y + 80,000.............. es (4)
From (3) & (4) we get x = ` 5.
ot
Variable cost per unit = ` 5
yn
or y = ` 1,20,000
as
x = 12,000 units.
Or Break-even sales in units = 12,000
Break-even sales in rupees = 12,000 ` 15 = ` 1,80,000
14. Production budget of Product Minimax and Heavyhigh (in units)
April May June Total
MM HH MM HH MM HH MM HH
Sales 8,000 6,000 10,000 8,000 12,000 9,000 30,000 23,000
Add: Closing 2,500 2,000 3,000 2,250 4,000 3,500 9,500 7,750
Stock (25% of
next month’s
sale
Less: Opening 2,000* 1,500* 2,500 2,000 3,000 2,250 7,500 5,750
Stock
Production units 8,500 6,500 10,500 8,250 13,000 10,250 32,000 25,000
*Opening stock of April is the closing stock of March, which is as per company’s policy
25% of next months sale.
Production Cost Budget
m
Rate (`) Amount (`)
co
Element of cost MM HH MM HH
(32,000 (25,000
units)
s.
units)
te
Direct Material 220 280 70,40,000 70,00,000
o
Direct Labour 130 120 41,60,000 30,00,000
yn
Manufacturing Overhead
(4,00,000/ 1,80,000 × 32,000) 71,111
d
1,12,71,111 1,01,04,167
as
15. (a) The essential features, which a good cost and management accounting system
.c
(i) Informative and simple: Cost and management accounting system should be
tailor-made, practical, simple and capable of meeting the requirements of a
w
business concern. The system of costing should not sacrifice the utility by
w
statistics and operational research etc. to have a complete overview and clarity
in results.
(v) Flexible and adaptive: The cost and management accounting system should
be flexible enough to make necessary amendments and modification in the
system to incorporate changes in technological, reporting, regulatory and other
requirements.
(vi) Trust on the system: Management should have trust on the system and its
output. For this, an active role of management is required for the development
of such a system that reflect a strong conviction in using information for decision
making
(b)
m
Cost Control Cost Reduction
co
1. Cost control aims at 1. Cost reduction is concerned with
maintaining the costs in reducing costs. It challenges all
accordance with the
s.
standards and endeavours to better
te
established standards. them continuously
2. Cost control seeks to attain 2. Cost reduction recognises no
o
lowest possible cost under condition as permanent, since a
yn
present
as
5. Cost control ends when targets 5. Cost reduction has no visible end.
are achieved.
w
(c) (i) Controllable Costs: - Cost that can be controlled, typically by a cost, profit or
w
m
3 Jobs are different from each other Products produced in a batch are
co
and independent of each other. Each homogeneous and lack of
Job is unique. individuality
s.
o te
d yn
tu
as
.c
w
w
w