Chapter 6 (Cost Sheet)
Chapter 6 (Cost Sheet)
29
GUnit or Output Costing (Cost Sheet) 6.1
Introduction
6.1
Cost Sheet
Method of Preparing Cost Sheet 6.2
Treatment of Scrap 6.7
Price QuotationsTenders and
or
Estimated Cost Sheet
Problems and Solutions 6.8
Examination Questions 6.9
6.25
C H A R T E R
Introduction
Outputcosting, Single costing or unit costing is a method of cost ascertainment which is used in
thoseindustr+es which have the folowing features
Production consists of a single product or a few varieties of the
same product with vanations in size, shape, quality, etc., and Output Costing is used
() Production is uniform and on continuous basis. in:
Examples of industries in which this method is commonly used are Steel mills
cement, steel, sugar, paper, brick works, quarmies, breweries, dairies, etc. Brick works
Cost units in these industries are a tonne of cement or steel or sugar, 1,000 Paper mills
bricks, a barrel of beer, a gallon of milk, etc. Breweries
Cement mills, etc.
Costing Procedure
In order to ascertain cost of products, a statement known as 'Cost Sheet' is prepared periodically.
As the production is uniform and cost units are identical, the cost per unit is the average cost. It is
ascertained by dividing the total cost by the number of units produced. The cost sheet is designed to
show the total cost as well as cost per unit of output for the given period.
COST SHEET
Cost sheet is "a document which provides for the assembly of the detailed cost of a cost centre or
COSt unit." Thus cost sheet is a periodical statement of cost designed to show in detail the vanous
elements of cost of goods produced like prime cost, factory cost of production and
As the
Loral cost. It is prepared at regular intervals, eg., weekly, monthly, quarterly,
shown in the production is
Comparative
yearly, etc. figures of the previous period may also be uniform and all
SE Sheet so that assessment can be made about the progress of the business.
cost units are
Production Statement. Though the term Production Statement is ustuidentical, the
the former is
an form of the latter. In
expanded
angeably with cost sheet, stocks and
cost per unit is
ition to costelements, a production statement includes items of sales, the average cost.
are shown in a
nen the details of cost sheet or production statement
6.1
6.2 Cost and Management Accou
ounting
cost and Profit.
tatement
T-shape account, it is known as Production Account. Other names used are Cost Statement and
and State
statement of
Purposes. Cost sheet serves the following purposes:
1. It reveals the total cost and cost per unit of goods produced.
2. It discloses the break-up of total cost into different elements of cost.
3. It
provides a comparative study of the cost of current period with that of the corresnond
previous period. onding
4. It acts as a guide to management in fixation of seling
pices and quotation of tenders
Method of Preparing Cost Sheet
A cost sheet is prepared by
clarifying costs according to elements materials, labour and
overhead.
1. Materials Cost of materials includes cost of
materials purchased plus all In cost
cost sheet,
In sheet.
expenses relating to purchases, e.g., carmiage inward, octroi, custom duty on im-
costs are
ported materials, etc.
2. Labour-A distinction is to be made accumulated
between direct labour and indirect element-wise
labour. Direct labour cost which is also known as
productive wages, is taken in the
prime cost. Indirect labour cost or unproductive wages are added in the
3. Overheads- Overheads are classified
factory overhead.
into three broad categories:
(i) Factory Overhead.
(ii) Office Overhead.
(iü) Selling and Distribution Overhead.
Treatment of Stocks
Stocks may be of three types
: (a) Stocks of raw materials, (b) Stocks of
Stocks of finished goods. work-in-progress, and (¢)
(a) Stock of Raw Materials. In cost sheet, materials
calculating the value of raw materials consumed during the consumed in production are shown. In
added in purchases and the value of period, opening stock of raw matenal is
closing stock is subtracted from
purchases. In the following
example with assumed figures, the treatment of stock of raw
material has been shown:
Opening stock of raw materials
Add: Purchases 30,000
80,000
Less: Closing stock of 1,10,000
raw materials
17,000
Cost of materials consumed
93,000
(b) Stock of Work-in-progress. This is the stock of semi-finished
process. The cost of work-in-progress consists of cost goods,
in manufacturing i.e., the goods whicn
consumed, direct wages and a proportionate of materials Opening stocks
part of the factory overhead. Onening stocks
fore, in the preparation of cost sheet, There- are added while
opening and closing stocks of
progress are adjusted at the stage of
is
factory cost. Opening stock of work-in-
work-in- closing stocks
progress added works cost and closing stock is
subtracted from this figure. In are deducted
to deducted in
in
the following example,
figures have been assumed to show the treatment of the sheet.
Costing (Cost Sheet) 6.3
luit or Ontyut
stock of work-in-progress.
Prime Cost
Add Works or Factory Overheads
Indirect Materials
Indirect Wages
Leave Wages
Overtime Premium
Fuel and Power
Coal
Factory Rent and Taxes
Insurance
(Contd.
Costing (Cost Sheet)
hil or Output 6.5
Particulars
Total cost Cost per unit
Factory Lighting
Supervision
Works Stationery
Canteen and Welfare Expenses
Repairs
Works Salaries
Depreciation of Plant & Machinery
Works Expenses
Gas and Water
Drawing 0ffice Salaries
Technical Director's Fees
Laboratory Expenses
Works Telephone Expenses
Internal Transport Expenses
Less: Sale of Scrap
Add: Opening Stock of Work-in-progress
Less: Closing Stock of Work-in-progress
Works Cost
Add: Office and Administrative 0verheads
Office Salaries
Director's Fees
Office Rent and Rates
Office Stationery and Printing
Sundry Office Expenses
Depreciation and Repairs of Office Equipment
Depreciation of Office Furniture
Subscription to Trade Journals
Office Lighting
Establishment Charges
Director's Travelling Expenses
Postage
Legal Charges
Audit Fees
Cost of Production
Add: Opening Stock of Finished Goods
Less: Closing Stock of Finished Goods
Cost of Goods Sold
Add: Selling and Distribution Overheads
Advertising
Showroom Expenses
Bad Debts
(Contd...)
Cost and Management
Acco.
6.6 nting,
Total cost Cost per unit
Particulars
Illustration 6.1
The Bangalore Ltd. supplies you the following information and requires you to prepare a cost
sheet.
Advertising 3,500
Solution
Cost Sheet
for the Month ending 30th April, 2012
Treatment of Scrap
in the form of cuttings, trimmings,
ncertain manufacturinq industries, scrap of materials arises of scrap
generally can be sold at a price. The realisable value
boring
ngs from metals or timber, etc. Scrap while preparing the cost sheet. This is shown in the
is d overheads factory cost
eaucted from factory or
following illustration.
6.8 Cost and Manageiment
Accounting
Ilustration 6.2
From the following information prepare a cost sheet to show:
(a) Prime cost; () Works cost; (c) Cost of production (d) Cost of sales; and (e) Profit.
Raw materials
35,250
Add: Carriage on purchases
Direct wages
850 36,100
18,450
(a) Prime Cost 54,550
Factory overhead
2,750
57,300
Less Sale of factory scrap 250
(b) Works Cost 57,050
Office overhead
1,850
(c) Cost of Production 58,900
Add Opening stock of finished goods 9,750
Less 68,650
Closing stock of finished goods 11,100
Cost of Goods Sold 57,550
Selling overhead
2,450
(d) Cost of Sales 60,000
(e) Profit 15,000
Sales
75,000
Price Quotations Tenders and Estimated Cost Sheet
or
age
absorption like percentage of direct materials, or wages or machine hour rate, etc. When profit is
metho were discussed:in the overhead chapter.
These
1/5 of cost, it
Calculation of Profit. After the total cost has been estimated, 1s equal to 1/6
a desired
ntage of profit is added to arive at the price to be quoted. Such profit may of sales
yen as a percentage of cost or percentage of selling price. In order to calculate the amountot
D 4 i t is easy to assume that figure as 100 on which profit percentage is given and then calculate
profit,
amount of profit.
the
Example 1
Given:
Total cost 50,000
Profit 20% of cost
Suppose cost = 100
Profit 100 x 20% = 20
. When cost is 50,000
Profit 50,000 20% = 10,000
x
Example 2
100 20= 80
it is 20/80 1/4 or 25% of cost. When total cost
So when profit is 20% or 1/5 of selling price,
will be calculated as follows:
given as 50,000, the profit
Profit =Cost 50,000 x 25% =
12,500
Example 3
= 750,000
Given: Seling price
Profit 20% of cost
= 100
Suppose cost
= 20
Profit 100 x 20%
-Cost+Profit
Selling price 100 20 = 7 120
cost is equal to 20/120 or 1/6 of selling price. Thus, the profit will be
0 profit of 20% of
calculated as follows
1/6 8333.33.
Proit =Cost 7 50,000x =
Direct materials
15,000 0.87
Direct labour
9,000 0.526
Prime Cost 24,000
Production overheads (900 machine hrs. @ 75 1.403
per hour) 4,500 0.263
Works Cost 28,500 1.666
Administration overhead (@ 20% on works cost) 5,700 0.334
Cost of Production 34,200 2.000
Less: Closing stock on 30th April, 2012 (1,100 units @ 72 per unit) 2,200
Cost of Goods Sold 32,000 2.000
Selling overhead (@Re. 0.50 per unit for 16,000) 8,000 0.500
Cost of Sales 40,000 2,500
Profit
Sales (16,000 units) 24,000 1.500
64,000 400
Problem 6.2
A factory produces a standard product. The following information is qiven to you from which you a
required toprepare "Cost Sheet" for the period ended 31st March, 2012
Consumable materials:
Opening stock
10,000
Purchases 85,000
Closing Stock 4,000
Direct wages 20,000
Other direct expenses 10,000
Factory overheads 100% of direct labour
Office overheads 10% of works cost
2 per unit sold
Selling and distribution expenses
(Cost Sheet) 6.11
or
Output Costing
nit
product:
Units of finished
In hand at the beginning of the period Units 1,000 (value 7 16,000)
10,000 units
Produced during the period
2,000 units
In hand at the end of the period
made to yield
Alea find out the selling price per unit on the basis that profit mark-up is uniformly
There was no work-in-progress either at the beginning or at the end
t of 20% of the selling price.
ofthe period
Solution:
Purchases 85,000
95,000
4,000
Less: Clossing stock
91,000
Raw material consumption
20,000
Direct wages
10,000
Other direct expenses
1,21,000
Prime cost
20,000
Factory overheads
1,41,000
Works Cost
14,100
Office overheads (10°% of 7 1,41,000)
Cost of Production
1,55,100
16,000
Add Opening finished goods (1000 units)
1,71,100
31,020
Less: Closing stock (2000 units@7 15.51)* 1,40,080
Cost of Goods Sold (9000 units)
18,000
Selling expenses (for 9000 units@ 2)
1,58,080
Cost of Sales
39,520
Profit (20% on Sales)
Sales 1,58,080
007 1,97,600
80
21.95
1,97,600 9,000 units
per unit
=
Solution
Statement of cost
for the year 2011
Calculation of Rates:
3,00,000 100
1. Factory overhead as a percentage of wages x 100 60%
5,00,000
2. Administration charges as a percentage of factory cost 3,36,000
x
100 24%
14,00,000
3. Selling charges as a percentage of factory cost 2,24,000 x 100 = 16%
14,00,000
4. Distribution charges as a percentage of factory cost 1,40,000
x 100 10%
14,00,000
Materials 8,000
5,000
Wages
Prime Cost 13,000
Administration Charges (24% of factory cost, increased by 15%, i.e., 27.6%) , ,581
Cost of Production 21,181
Selling Charges (16% of factory cost, increased by 15%, i.e., 18.4%) 3,054
1,494
Distribution Charges (10% of factory cost, decreased by 10%, ie., 96)
Cost of Sales 25,729
Problem 6.4
six
disclose the following information for the
The accounts of a machine manufacturing company
2012.
months ending 31st Dec.,
1,50,000
Materials used
1,20,000
Direct wages
24,000
Factory overhead expenses
17,640
Office expenses
for
the price which the company should quote
Prepare aCost Sheet of the machines and calculate on productive
materials valued at F 1,250 and expenditure
the manufacture of a machine requiring
wages of 750, so that the price may
yield a profit of 20% on the selling price.
and
factory overhead as a percentage of direct wages
For the purpose of pice quotation, charge
cost.
charge office overhead as a percentage of works
Solution
Cost Sheet
months ending 31st Dec. 2012
for the period of six
1,50,000
Materials used 1,20,000
Direct wages 2,70,000
Prime Cost
24,000
Factory overhead expenses 2,94,000
Works or Factory Cost
17,640
Office and general expenses Cost of Production 3,11,640
6.14 Cost and Managenient Accounti.
Factory overheads 24,000
o of factory overhead to direct wages x 100 1,20,000 * 100
Direct wages
Office overheads
x 100
17,640
o of office overhead to factory cost X
100 6
Factory cost 2,94,000
Statement showing the Quotation of Price of a Machine
Materials
Wages 1,250.00
Prime Cost
750.00
Factory overhead (20% on wages) 2,000.00
150.00
Factory Cost
Office overhead (6% on factory cost)
2,150.00
Total Cost or Cost of Production
129.00
Profit (25% of total cost)
2,279.00
569.75
Selling Price
2,848.75
*Profit of 20% on seling price is equal to 25% of total cost.
Problem 6.5
From the understated particulars, you are required to prepare a monthly cost sheet of
Soap
Manufacturers Lt showing therein:
i) Prime cost; (i) Works cost; (ii) Cost of production;
iv) Cost of sales; and (v) Profit per unit.
Opening Inventory (1-1-2012):
Raw materials 6,000
Work-in-progress 9,620
Finished goods (1,000 units) 13,680
Closing Inventory (31-1-2012):
Raw materials 7,000
Work-in-progress 8,020
Finished goods
Donations to home for destitutes 2,100
Raw materials purchased 72,000
Import duty on raw materials purchased 14,400
Productive wages 18,000
Machine hours worked 21,600 hours
Machine hour rate 1.50
Chargeable expenses 2,000
Office and Administration expenses Re. 1 per unit
Selling expenses Re. 0.90 per unit
Units soldd 8,000 units
Units produced 8,200 units
Profit on sale 10%
Costing (Cost Sheet) 6.15
thnil orOulput
Solution
Cost Sheet for January, 2012
Units 8,200
Particulars
materials 6,000
Opening stock of
raw
*Working notes:
1,000 + 8,200 8,000 1,200 units.
Units in closing stock of finished goods
=
1.
Problem 6.6
units of a product manufactured during the
E Ltd. furmish the following information for 10,000
year 2011:
90,000
Material 60,000
Direct wages 12,000
Power and consumable stores
15,000
Indirect wages
6.16 Cost andManagenent nling
cost.
Solution:
(a) Cost Sheet for the year 2011
Output: 10,000 units
Total Per unit
90,000 9.00
Materials
60,000 6.00
Wages
Prime Cost 1,50,000 15.00
Factory Overheads:
Power and consumable stores 12,000 1.20
15,000 1.50
Factory indirect wages
0.55
Lighting of factory 5,500
Defective work (cost of rectification) 3,000 0.30
9) x + 10% =
1,48,500
Materials (15,000 1,48,500 9.90
6) +
x 10% =
99,000
Wages (15,000 99,000 6.60
Prime Cost 2,47,500 16.50
Factory
overheads (75% of wages) 74,250 .95
Works Cost 3,21,750 21.45
0ffice and selling
overheads (20% of works cost) 64,350
-
4.29
Cost of Sales 3,86,100 25.74
Profit 78,900 5.26
Sales 4,65,000 31.00
45,000
Factory overhead x 100 75% of wages
60,000
1,95,000
Problem 6.7
2012. Following
manufactured and sold 1,000 sewing machines in
Bharat Engineering Company
are the particulars obtained from
the records of the company:
80,000
Cost of materials 1,20,000
*Working Notes
Materials + Labour in 2013
1. Mfg. expenses in 2013 = x Mtg. exp. in 2012
Materials+ Labour in 2012
222
x
50 55.50 per unit.
200
2. Profit of 10% or 1/10 on selling price = 1/9 of total cost i.c. 382.50 x 1/9 = 42.50 per machine.
Problem 6.8
Delco Shoe Co. manufacture two types of shoes A and B. Costs for the year ended 31-3-2012
were:
27,00,000
There was no work-in-progress at the beginning or at the end of the year. It is ascertained tha
(a) Direct material in type A shoes consists twice as much as that in type B shoes,
(b) The direct wages for type B shoes were 60% of those of type A shoes,
(c) Production overhead was the same per pair of A and B type.
(d) Administrative overhead for each type was 150% of direct wages,
(e) Selling cost was 1.50 per pair.
(Cost Sheet)
Costing 6.19
nitor Output
() Droduction during the year were : Type A 40,000 pairs of which 36,000 were sold; Type B
1,20,000 pairs of which 1,00,000 were sold.
o)Selling price was 44 for type A and T 28 for type B per pai
a statement showing cost and profit.
Prepare
Solution
Statement of Cost and Profit
for the year ending 31st March. 2012
Working Notes
1. Materials cost has been allocated as follows
Suppose Type B's material cost is =
x
X = 7.50
B material cost 7.50 per pair
Type
=
60
Then labour charges for B x or 0.6x
100
40,000x + (l,20,000 x
0,6 x) =
78,40,000
1,12.000x = 8,40,000
X =7.550
A's labour charges = 7.50 per pair
Steel Products Company produces a machine that sells for 300. An increase of 15% in co
cost
materials and of 10% in cost of labour is anticipated.
If the only figures available are those given below, what must be the selling price to give the e
percentage of gross profit as before ? same
(a) Material costs have been 45% of cost of sales, (b) Labour costs have been 40% of cost of
(c) Overhead costs have been 15% of cost of sales, (d) The anticipated increased costs in relation tosales.
present sale price would cause 35% decrease in the present gross profit. the
Solution
Statement of Cost
(Suppose cost of Sales = 100
Assumed present Increase
cost of sales
Anticipated
cost of sales
gross profit
Rs. 10.75
Gross profit = - 30.72
35 %
Gross 30.72
profit as a
percentage of sales 300 x 100 - R 10.24%
300
Actual present cost of sales R 300 30.72 7 269.28
Taking the anticipated increase
Problem 6.10
books
cme Ltd. present the following data for the month of Jan., 2010.
of Acm
The
Solution:
in the question. It is ascertained as shown below by
Note. Purchase of raw materials is not given of
a reverse cost sheet i.e., working
backward from cost of goods sold upto the amount
preparing
purchases.
56,000
Cost of goods sold
Add: Closing stock of finished goods 18,000
74,000
Less: Opening stock of finished goods. 14,000
Cost of Production 60,000
2,600
Less: General administrative expenses
Factory Cost 57,400
12,000
Add: Closing stock of work-in-progress
69,400
8,000
Less: Opening stock of work-in-progress 61,400
100 10,000
Less: Factory overhead 16,000 160
Prime Cost 51,400
16,000
Less: Labour cost Materials Consumed 35,400
Add: Closing stock of raw matenñals
8,600
44,000
8,000
Less: Opening stock of raw materials 36,000
Purchases
6.22
Cost and Managenuent Accounin.
Cost Sheet
for the month ending 31st January, 2010
Sales
32,00,000
Operating expenses
Insurance
40,000
Gas, electricity and water
1,00,000
Direct labour cost
Indirect labour cost 6,00,000
Depreciation of factory equipment 1,20,000
Raw materials 1,60,000
purchased during the year 12,00,000
Rent
Selling and admn. overheads 4,00,000
3,20,000 29,40,000
Net profit 2,60,000
You have been asked to assist the
company in preparing a correct Profit and Loss Statement for the
year 2012. The following additional information are
available.
io
1. The company is a
manufacturing concerm that produces a product for sale to outside mers.
Solution:
Particulars
in 2012 12,00,000
Direct materials purchased 10,50,000
Less: Closing stock
1,50,000
6,00,000
Direct labour cost
16,50,000
Prime Cost
Manufactuing overhead 1,20,000
Indirect labour cost
of 1,00,000] 90,000
Gas, electricity and water [90% 28,000
Insurance (70% of F 40,000]
1,60,000
Depreciation on equipment 7,18,000
3,20,000
Rent [80% of 4,00,000] 23,68,000
4,20,000
Add: Opening work-in-progress
27,88,000
4,80,000
Less: Closing work-in-progress
Cost of Goods Manufactured 23,08,000
Particulars
23,08,000
Cost of goods manufactured (as calculated above)
5,40,000
Add: Opening stock of finished goods
28,48,000
4,00,000
Less: Closing stock of finished goods
Cost of goods sold 24,48,000
Sales 32,00,000
Cost and Management
6.24 Account
*Working Note:
Output: First 3 months at 50% capacity 50 = 7,500 units
-60,000 * 100
80
For next 9 months 80% capacity 60,000x 100 =36,000
100
EXAMINATION QUESTIONS
Theoretical Questions
Opening stock:
Raw materials
Finished goods 5,000
Closing stock: 4,000
Raw materials
Finished goods 4,000
Raw materials purchased 5,000
Wages paid to labourers 50,000
20,000
Chargeable expenses 2,000
Rent, rates and taxes
Power 5,000
2,000
Factory heating and lighting
2,000
Factory insurance
1,000
Experimental expenses 500
Office management salaries
4,000
Office printing and stationery
200
Salaries of salesmen
2,000
Commission of travelling agents
1,000
Sales
1,00,000
[Ans. (a) 7 51,000 (b) 7 87,700 (c) 7 86,700 (d) 10,300)
5. The Modern Manufacturing Company submits the
following information on 31st March, 2008
Sales for the year R 2,75,000
Inventories at the beginning of the year were
Finished goods 7,000
Work-in-progress 4,000
Purchases of materials for the year were: 1,10,000
Materials inventory at the beginning of the year was
1,000 1,500
Materials
Labour 1,200 1,400
600 700
Manufacturing expenses
2,800 3,600
Total
Statement of Cost of Production.
During the year, 600 sets are produced. Prepare a
Materials 1,98,000
Direct wages 12,000
Stores overheads 19,800
Running expenses of machine 4,400
Depreciation 2,200
Labour amenities 1,500
Works general overhead 30,000
Administration and selling overhead 26,800
Costing
(Cost Sheet) 6.29
Output
n i to rO n t
or
available to you is :
The otherdata
A:B
cost ratio per
unit 1:2
Material
ratio per unit
labour
2:3
Direct 1 2
utilisation ratio per unit
Machine
Calculate the cost of each toy per unit giving the bases of apportionment adopted by you.
B2,11,4271
TAns. Total cost AR 83,273;
particulars have been extracted from the accounts of Exids Motors Ltd. for the year
10. Thefollowing
ending 31-12-2012.