Scribd
Upload
106 views10 pages

Stock Code Description UOM Purchase Price Product Type Product Cost

The document is a cost sheet that tracks the costs of raw materials, production, administration, selling and distribution, and profits over the production period. It lists expenses like opening/closing stock of raw materials and work in progress, direct costs of raw materials, labor, and overhead expenses. The totals of prime cost, works cost, cost of production, cost of goods sold and cost of sales are calculated by adding the relevant expense items. The final sales figure includes the cost of sales and profits.

Uploaded by

M SAI SHRAVAN KUMAR
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
106 views10 pages

Stock Code Description UOM Purchase Price Product Type Product Cost

The document is a cost sheet that tracks the costs of raw materials, production, administration, selling and distribution, and profits over the production period. It lists expenses like opening/closing stock of raw materials and work in progress, direct costs of raw materials, labor, and overhead expenses. The totals of prime cost, works cost, cost of production, cost of goods sold and cost of sales are calculated by adding the relevant expense items. The final sales figure includes the cost of sales and profits.

Uploaded by

M SAI SHRAVAN KUMAR
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 10

Stock Code Description UOM Purchase Price Product Type Product Cost

Cost Sheet
Description
Opening Stock - Raw Material
Add: Purchase - Raw Material
Add: Other Purchase Expenses - Raw Material
Add: Raw Material Utilised
Add: Direct Labour/Wages
Add: Other Direct Expenses
Less: Closing Stock - Raw Material
PRIME COST (A)
Add:- Over Heads Expenses Factory
Rent - Factory
Electricity Charges
Indirect Material Expenses
Other Indirect Wages
Salaries of Production Heads/Supervisors
Other Salaries
Insurance - Factory
Depreciation - Factory
WORKS COST INCURRED
Add: Opening Stock - Work in Progress
Less: Closing Stock - Work in Progress
WORKS COST (A+B)
Add:-Administration Over Heads:
Office Rent
Asset Depreciation
General Charges
Audit Fees
Bank Charges
Other Office Expenses
COST OF PRODUCTION (B+C)
Add: Opening Stock - Finished Goods
Less: Closing Stock - Finished Goods
COST OF GOODS SOLD (C+D)
Add:- Selling and Distribution Overhead Expenses:-
Commisions
Salary - Sales
Travelling Exps
Advertisement
Delivery Expenses
Sales Tax @ 5 %
Bad Debts
COST OF SALES (D+E)
ADD: PROFIT
SALES
Amount
250000
250000
50000
250000
100000
50000
300000
650000

25000
50000
50000
60000
70000
100000
20000
80000
1105000
300000
250000
1155000

50000
85000
20000
60000
15000
30000
1415000
400000
300000
1515000

50000
60000
45000
65000
90000
60000
25000
1910000
90000
2000000
Row Base Overhead Description From
10 B000 Material
20 C000 Material OH 10
30 Material Usage 0
40 B001 Wages
45 B002 Salaries
50 C001 Manufacturing OH 40
60 Manufacturing Costs 40
70 Cost of goods Manufactured 0
80 C002 Administration OH
90 C003 Sales OH
100 Cost Of Goods Sold
To Row Credit

45
50
0
Row Base Overhead Description From
10 B000 Material
20 C000 Material OH 10
40 B001 Wages
45 B002 Salaries
50 C001 Manufacturing OH 40
60 Cost of goods Manufactured 10
70 C002 Administration OH 60
80 C003 Sales OH 60
90 Cost Of Goods Sold 60
To Row Credit

E01

45 E02
45
E03
E04
90
Product stock Code Component Stock Code Input Quantity

You might also like