Cost Sheet Problems
Cost Sheet Problems
Direct material - Rs. 40,000, Direct labour - Rs. 30,000 Direct expenses - Rs. 25.000
OR
Illustration 5. Prepare cost sheet from the following particular in the book of B. M. Rehman
Raw material purchased = Rs. 1, 20,000
Paid freight charges = Rs 10,000
Wages paid to laborers = Rs 35,000
Directly chargeable expenses = Rs 25,000
Factory on cost = 20% of prime cost
General and administrative expenses = 4% of factory cost
Selling and distribution expenses = 5% of production cost
Profit 20% on sales
Opening stock Closing stock
Raw material 15,000 20,000
Work in progress 17,500 24,000
Finished goods 20,000 27,500
Solution:-
Book of B. M. Rehman
Cost sheet
Illustration 6. Prepare cost sheet in the book of M. B. Rehman from the following particulars.
Solution:-
Book of B. M. Rehman
Cost sheet
Assuming that all products manufactured and sold, what should be the selling price be fixed to
obtain a profit of 20% on selling price.
Solution
Cost Sheet
Direct material:-
Material used in manufacturing 5,500
Material used in Packing material 1,000
Freight on material 500
------------- 7,000
Direct wages:-
labour require in production 1,000
Direct expenses:- Direct factory 500
------------
Prime cost 8,500
Add:- Factory overhead
Indirect material used in factory 75
Indirect labour required for supervision 200
Indirect factory expenses 100
Depreciation factory 175
------------- 275
------------- 550
Factory on works cost 9050
Add:- office & administrative expenses
Indirect material 125
Indirect expenses office 125
Indirect depreciation 75
------------ 200
------------- 325
Total cost of production 9375
Add:- selling and distribution overhead:-
Indirect material 150
Indirect expenses 350
Advertisement 125
------------ 475
------------- 625
Cost of sales 10,000
Profit 2,500
-----------
Sales 12,500
Illustration 8.
Prepare a statement of cost from the following trading and P/L account for the year ending
March 31, 2008
Solution
Statement of cost
(For the year ending 31st March 2008)
Particular Details (Rs) Amount (Rs)
Direct material:-
Raw material purchased 1,20,000
Add:- opening stock of raw materials 12,000
---------------
Raw material for consumption 1,32,000
Less:- Closing sock of raw materials 20,000
---------------
Raw material consumed 1,12,000
Add:- Direct labour 30,000
---------------
Prime cost 1,42,000
Add:- Factory overhead:-
Cost of moulds 3,000
Factory manager salary 1,000
Depreciation on machinery 800
--------------- 4,800
---------------
Factory cost 1,46,800
Add:- office and administrate overhead
Salary 9,000
Insurance 1,000
Directors fees 2,000
Telephone charges 700
--------------- 12,700
-------------
Cost of production 1,59,500
Add:- Opening stock of finished goods 40,000
--------------
Goods available for sales 1,99,500
Less:- Closing stock of finished goods 50,000
--------------
Cost of goods sold 1,49,500
Add:- selling & distribution ext:-
Salesman’s salary 6,000
Insurance (godown) 800
Showroom expenses 1,200
Expenses of delivery van 1,500
Market research expenses 600
------------- 10,100
----------------
Cost of sales 1,59,600
Profit 40,400
----------------
Sales 2,00,000
Illustration 9.
The following inventory data relate to Nazia Ltd.
Inventories
Opening Closing
Finish goods Rs 1,100 Rs 950
Work in progress Rs 700 Rs 800
Raw materials Rs 900 Rs 950
Additional information:-
Cost of goods available for sales = Rs 6840
Total goods processed during the period = Rs 6540
Factory on cost = Rs 1670
Direct material used = Rs 1930
Requirements:-
(i) determine raw material purchase
(ii) determine the direct labour and cost incurred
(iii) determine the cost of goods sold
Solution
Illustration 10.
Mr. Zia furnishes the following data related to the manufacture of a standard product during the
month of August 2008
You are required to prepare a cost sheet from the above showing:-
The cost per unit
Cost per unit sold and profit for the period
Solution
Book of Zia
Cost sheet
(For the month of August 31, 2008)
Exercise Questions.
Theoretical Questions:-
3) What is cost accounting? Discuss briefly its important functions in a business firm
4) Explain the important objectives of cost accounting?
5) Distinguish between:-
a) Direct expenses and indirect expenses?
b) Direct labour and indirect labour?
c) Direct materials and indirect materials?
6) Distinguish between ‘costing’ and ‘cost accounting’
7) What is financial accounting? How it is different from cost-accounting?
8) Mention the elements of cost
9) Explain the classification of direct labour
10)How the overheads are different from the expenses?
11)State at least five each type of overheads
a) Factory overheads
b) Administrative overheads
c) Selling and distribution overheads
12)What are the components of direct cost?
13) Write the formula of calculating the raw material consumed
14)Explain the meaning of cost of goods sold and cost of sales
15)Explain the meaning of
a) First cost
b) Works cost and works on cost
c) Cost of production and goods available for sales
Practical problems (Short Answers)
1. From the following particulars prepare a cost sheet showing the total cost per tone for the
period ended 31st December 1998
Rs Rs
The total output for the period has been 10,000 tones.
(Ans. Prime cost Rs 71,000 works cost Rs 1,08,050 office cost Rs 1,13,600 total cost Rs 1,18,200
cost per tone Rs 11.82)
2. Prepare a cost sheet to show the total cost of production and cost per unit of goods
manufactured by a company for the month of July 1994. Also find out the cost of sales.
Rs Rs
(Ans. Prime cost Rs 33,500 factory cost Rs 38,000 cost of production Rs 38,900 cost of sales Rs
37416)
3. The following particulars relating to the year 1994 have been taken from the books of a
chemical works manufacturing and selling a chemical mixture:
Rs Rs
The stock of finished mixture at the end of 1994 is to be valued at the factory cost of the mixture
for that year. The purchase price of raw–materials uncharged throughout 1994.
Prepare a statement giving the maximum possible information about cost and its break up for the
year 1994.
(Ans. Prime cost Rs 3,77,800 factory cost Rs 5,16,200 cost of production of finished mixture sold Rs
5,71,852 cost of sales Rs 6,31,352)
4. Calculate
a) Value of raw-materials consumed
b) Total cost of production
c) Cost of goods sold and
d) The amount of profit from the following particulars:
Rs Rs
Rs
Assuming that all the products manufactured are sold, what should be the selling price to obtain a
profit of 20% on cost price?
Illustrate in a chart fork for presentation to your mange, the division of costs of product ‘X’
[Ans. Prime cost Rs 16,200, works cost Rs 17,100 cost of sales Rs 18,225 sales Rs 21,870]
6. Calculate the prime cost, factory cost, total cost of production and cost of sales from the
following particulars:
Rs.
[Ans. Prime cost Rs 15,000, factory cost Rs 19225 total cost of production Rs 19,800 cost of sales Rs
21,395]
7. Calculate
a) Value of raw-materials consumed
b) Total cost of production
c) Cost of goods sold and
d) The amount of profit from the following particulars:
Rs
Opening stock:
Raw materials 1,350
Finished goods 2,500
Closing stock:
Raw-materials 750
Finished goods 1,500
Raw materials purchased 20,000
Wages paid to labourers 8,000
Direct expenses 1,250
Experimental expenses 450
Factory printing and stationery 350
Rent :
Factory 250
Office 120
-------- 370
Wages of fireman 1,000
Lighting – office 125
Audit fees 150
Telephone expenses 500
Advertising 1,250
Market research expenses 550
Salary of godown – keepers 175
Traveling expenses 750
Commission of traveling agent 500
Sales 50,000
[Ans. (a) value of raw – materials consumed Rs. 20,600 (b) Total cost of production Rs 32,795, (c)
cost of goods sold Rs 33,795, (d) profit Rs 12,980]
8. Prepare a statement of cost from the following trading and profit and loss account for the
year ending 31st March, 1995.
Particulars Rs Particulars Rs
[Ans. Prime cost Rs 73,000, works cost Rs 75,000, total cost of production Rs 80,000 cost of goods
sold Rs 75000 cost of sales Rs 79,000 profit Rs 21,000]
9. The following data relate to the manufacture of standard product during the four week
ending on 28th Oct. 1994.
10. A firm has purchased a plant to manufacture a new product, the cost data for which is given
below:
[Ans. Rs 9.20]
11. Prepare a cost sheet from the following data to find out profit and cost per unit:
[Ans. Prime cost Rs 2,40,000, factory cost Rs 2,56,000, cost of production Rs 2,81,600, cost of sales
Rs 2,65,440, profit Rs 94,560]