written by Khatabook | December 20, 2021

Know the Meaning and Format of Cost Sheet

×

Table of Content


A cost sheet, as the name itself suggests, is a document or a sheet containing the cost of a product or a group of products. The industry uses it to determine the cost of the products manufactured and fixation of the selling price after adding the Profit Margin. A cost sheet is a report that lists all of the costs connected with a product or manufacturing process. A cost sheet is used to calculate the profit margin on a product or activity and set prices for similar products in the future. It can also be used to support a variety of cost-cutting methods.

Although cost sheets are generally and more frequently used in manufacturing companies, they can also be useful for service providers. Any business owner (manufacturer or service provider) can calculate the overall production cost or service cost and set the price per item for commodities or services using this information.

Did you know?

According to Google, “how to start a business” was a trending topic in 2023 and it was searched more times than “how to get a job”.

What is the Purpose of Preparing a Cost Sheet?

A cost sheet is an analytical statement of presentation of various types of costs or expenses incurred for manufacturing a product or a group of products or costs incurred/to be incurred for providing a service or bundle of services. 

Generally, the cost sheet is used and always preferred to determine per unit cost of an item or product so that its price can be fixed by adding desired profit margin. But many times, cost sheets are also used to determine the cost of a particular lot of items. Like in the garment industry where a pre-decided quantity of similar size and design is prepared by the same type of manufacturing process using the same type of fabric and accessories etc. The total cost of the task, order, or operation is revealed on the cost sheet. 

What is the Importance of Cost Sheet?

 The cost sheet is an important statement for the management as well as for the customers as described below- 

1. For Management

The primary goal of preparing a cost sheet is to determine an accurate cost of the product or group of products. It has the total cost as well as the cost per unit of a product. It helps and allows the management to compare a product's current cost per unit to an earlier cost per unit for the same product. If costs have escalated, comparing them allows management to take necessary corrective action in time. Thus, the cost sheet is an important document for the management in controlling production costs in a manufacturing unit. 

The cost sheet is used to make some of the most significant decisions made by management. Managers use the cost sheet whenever a company wants to manufacture or purchase a component or quote pricing for its goods. Therefore a cost sheet always helps the management in the decision-making process.

2. For Customers

Another important objective of preparing a cost sheet is from the customer’s point of view. Often, a manufacturer has to share the cost sheet of their product or group of products with their customer to negotiate the selling price for any new product. Or it may be for increasing the selling price of an existing product due to various cost escalation factors like increase in the cost of raw material and other consumable items, increase in the wages to workers, increase on account of freight, increase in taxes or duties, etc. A cost sheet is also needed while participating in the tenders to supply various items/components to the Govt. Departments or to other big companies in the private sector.

What are the Types of Costs?

Before understanding the various components of a cost sheet, we must understand the types of costs in any business organisation. There are two types of costs in every business organisation which are given as under-

  1. Fixed Costs: These costs are those that remain fixed, like building rent (if business premises are on rent).  If a business entity owns a building, then the fixed costs include depreciation of building, depreciation of machinery, insurance expenses, pre-decided advertisement expenses, remuneration paid to directors and other senior managers, etc.
  2.  Variable Costs: These types of costs do not remain fixed but are variable, i.e., they keep on changing with the production level. If the production level goes up, variable cost increases, and if production level comes down, variable cost decreases. The examples of variable costs are the cost of raw material, cost of wages, cost of power & fuel, cost of freight & cartage, etc.

 Both types of costs are taken into account while preparing a cost sheet. 

What are the Components of a Cost Sheet?

 After understanding the different types of costs in the business organisation, now it's time to prepare a cost sheet that consists of the following important elements- 

  • Prime Cost: The complete direct cost of the manufacturing process is referred to as prime cost. Direct material costs, direct labour costs, and direct expenses are all included. 

Examples of such expenses: Raw material cost, consumables cost, wages to workers, incentives to workers, power & fuel, salary to production supervisors, foreman, junior engineers, freight & cartage, and unloading charges of incoming raw material & consumables, etc. 

In a summarised way, it can be written as:

Prime Cost = Direct Material Direct + Wages Direct Expenses

  • Factory Cost or Works CostThe factory cost or Works Cost consists of Prime Cost plus factory overheads, i.e. cost of all types of indirect material, indirect wages, and indirect expenses. 

Examples of such expenses: repair & maintenance to machinery & factory building, machine tools, consumption of oils, lubricants, gas, etc., salary to Production Manager, stores and warehouse for raw material (RM) Store In-charge, and other Production & Store Staff, Factory Lighting, rent, labour welfare expenses, etc. It also includes the cost of semi-finished goods or incomplete units, popularly known as Work in Process (WIP). 

In a summarised way, Factory Cost can be written as:

Works cost formula = Prime Cost Factory Overheads (Indirect Material + Indirect Wages Indirect Expenses) + Opening WIP – Closing WIP

  • Cost of Production: The cost of production consists of factory cost plus all types of other direct and indirect costs, i.e. office or administration cost (Administration Overheads). 

Examples of such expenses: Salary to office staff working in accounts, costing, purchase, human resources departments, etc., stationery, telephone expenses, office lighting, remuneration to directors, staff welfare expenses, audit expenses, legal & professional charges, etc. 

In a summarised way, Cost of Production can be written as:

Cost of Production = Factory Cost + Administration Overheads 

  • Cost of Goods sold: If the cost of Finished Goods is included in the cost of production, we can arrive at the cost of goods sold in the following manner:

Cost of Goods Sold = Cost of Production + Opening Stock of Finished Goods – Closing Stock of Finished Goods

  • Cost of Sales: When the selling & distribution overheads/expenses are added to the Cost of goods sold, we arrive at the cost of sales. 

Examples of such expenses: Salary to the sales team, commission on sales, advertisement expenses, travelling & hotel stay expenses of sales staff, warehouse or showroom rent or depreciation, etc. Thus, Cost of Sales is summarised as:

Cost of Sales = Cost of Goods Sold + Selling & Distribution Overheads

  • Profit: The last item of every cost sheet is Profit which can be termed as the difference of selling price and cost of sales in the case of existing items. But for the new item, the manufacturer has to keep a minimum desired level of profit margin and decide about the selling price accordingly. Thus, a cost sheet also helps in setting up Maximum Retail Price (MRP). 

The formula for determination of Profit can be written as:

Profit = Selling price – Cost of Goods sold

Alternatively, the Selling Price of a Product can be determined by the following formula: Selling Price = Cost of Sales + Profit

Also Read: Balance Sheet - Definition & Examples (Assets = Liabilities + Equity)

Cost Sheet Format

The format of cost sheet is as follows:                  

Name of Company………………………………..

S. No.

Particulars

Total Cost

Cost Per Unit

1.

Direct Materials Consumed (RM & consumables):

   
 

Opening Stock of raw Material

xx

 
 

Add: Additions/Purchases

xx

 
 

Less: Closing Stock of Raw Material

(xx)

 
 

Net Material Consumed:

   

2.

Direct Labour Cost :

   
 

Wages to workers

xx

 
 

Incentive to Workers

xx

 

3.

Direct Expenses:

   
 

Power & Fuel

xx

 
 

Freight & Cartage for incoming material

xx

 
 

Salary to production supervisors, supervisors, junior engineers, etc.

xx

 
 

Unloading charges of incoming material

xx

 
 

Depreciation of Machinery

xx

 
 

Depreciation of factory building (if owned)

xx

 

4.

Prime Cost (1 2 3)

xxx

 

5.

Add: Factory/Works Overheads

   
 

Repair & Maintenance of Machinery

xx

 
 

Repair & Maintenance of Factory Building

xx

 
 

Cost of Machine Tools

xx

 
 

Salary to Production Manager, RM Store In-charge and other Production & Store Staff, etc.

xx

 
 

Labour Welfare Expenses

xx

 
 

Factory Rent

xx

 
 

Factory Lighting

xx

 
 

Other factory overheads like housekeeping, salary to security guards, factory stationery, etc.

xx

 

6.

Gross Factory / Works Cost (4 5)

xxx

 

7.

Add: Opening Work in Progress

xx

 

8.

Less: Closing Work in Progress

(xx)

 

9.

Factory/Works Cost (6 7-8)

xxx

 

10.

Add: Administration Overheads:

   
 

Salary to Office Staff

xx

 
 

Incentive to Office Staff

xx

 
 

Stationery & Printing Expenses

xx

 
 

Office Lighting Expenses

xx

 
 

Telephone Expenses

xx

 
 

Remuneration to Directors

xx

 
 

Staff Welfare Expenses

xx

 
 

Audit Expenses

xx

 
 

Legal & Professional Charges

xx

 

11.

Cost of Production (9 10)

xxx

 

12.

Add: Opening Stock of Finished Goods

xx

 

13.

Less: Closing Stock of Finished Goods

(xx)

 

14.

Cost of Goods Sold (11 12-13)

xxx

 

15.

Add: Selling & Distribution Overheads

   
 

Salary to Sales Team

xx

 
 

Commission on sales

xx

 
 

Advertisement expenses

xx

 
 

Travelling & Hotel Stay Expenses of Sales Staff

xx

 
 

Warehouse Rent or Depreciation

xx

 

16.

Cost of Sales (18,19,20)

xxx

 

17.

Profit

xxx

 

18.

Sales / Selling Price (16 17)

xxx

 

Cost Sheet Example

 Let us take an example to prepare a cost sheet for XYZ Ltd for the year ending on 31 March, …………….on the basis of the following information available with us: 

  • Purchases of stores and warehouse for raw material (RM) & Direct Consumables= Rs. 25,000/-
  • Opening stock of RM & Direct Consumables= Rs. 4,000/-
  • Closing stock of RM & Direct Consumables= Rs. 2,000/-
  • Direct Wages paid to workers= Rs. 6,000/-
  • Other Direct expenses= Rs. 2,000/-
  • Factory Expenses/Overheads= Rs. 2,500/-
  • Office and administration overhead is assumed to be 30% of Factory costs in the absence of exact data.
  • Opening stock for finished goods= Rs. 3,000/-
  • Closing stock for finished goods= Rs. 4,000/-
  • Selling and distribution Expenses/Overhead= Rs. 5,000/-
  • Profit Margin on Total on cost=  30%

 Now, the cost sheet can be prepared as follows: 

Particulars

Amount (Rs.)

RM & Direct Consumable Material Consumed:

 

Opening Stock of Raw Material & Direct Consumables

4,000

Add: Purchases of RM & Direct Consumables

25,000

Less: Closing Stock of Raw Material & Direct Consumables

2,000

Net RM & Direct Consumable Material Consumed 

27,000

Direct Wages paid to Workers

6,000

Other Direct Expenses

2,000

Prime Cost

35,000

Add: Factory Expenses/Overheads 

2,500

Factory/Works Cost

37,500

Add: Office & Administrative Overheads (30% of Factory cost) 

(30% of Rs. 37,500)

11,250

Cost of Production

48,750

Add: Opening Stock of Finished Goods

3,000

Less: Closing Stock of Finished Goods

4,000

Cost of Goods Sold

47,750

Add: Selling & Distribution Expenses/Overheads

5,000

Cost of Sales

52,750

Add: Profit i.e. 30% of Total Cost (30% of 52,750)

15,825

Sales (or Per Unit Selling Price)

68,575

Also Read: What is Double Entry System of Accounting

Conclusion

This article on the cost sheet is meant for everybody doing business or intending to do business. You can now understand the various important aspects of determining the cost of a product/group of products. You can also know the profit margin on one product or group of products for decision making. We hope the article would have given you the required information about cost Sheet meaning, cost sheet format, components of cost sheet, etc.

Reduce your worries by downloading the Cashbook app where you can do real-time calculations and create separate books for each account. Easily make PDF and excel reports for your business and elevate your business functioning.

FAQs

Q: Can a cost sheet be prepared before the start of Business?

Ans:

Yes, a cost sheet can be prepared on an estimated basis before the start of business, but its accuracy will depend on the reliability of the correct data/information about the costs.

Q: Is there any legal requirement for preparing a cost sheet?

Ans:

Those companies or business houses where the Government has made a cost audit are required to prepare the cost sheet for their products/components. On that basis only, the Cost Auditor will be able to conduct the Cost Audit.

Q: Can an estimated cost sheet be prepared?

Ans:

Yes, an estimated cost sheet can be prepared based on the availability of details of expenses on an approximate basis. But it should be revised immediately when exact data is available.

Q: How can I manage my cash books?

Ans:

Easy! You can download the Cashbook app where you can manage single to multiple cash books. You can even do real-time calculations just by adding the transaction.

Q: Is there an app that can aid me in growing my business?

Ans:

Download the Biz Analyst app where you can always stay connected to your business. Easily send payment reminders and avoid poor cash flow. Moreover, Biz Analyst has the necessary tools for data entry and analysing your sales which you can use to rapidly grow your business and increase the productivity of your sales team.

Q: Is there any other format for preparing the cost sheet for a Service provider or a Trader?

Ans:

No, the cost sheet format is the same as given in this article.

Q: How to prepare a cost sheet for a Service Sector or a Trading House?

Ans:

The cost sheet for a Service provider or a Trading House can be prepared in the same manner as for a manufacturer. They can incorporate the relevant costs for the cost sheet to be prepared in a precise manner.

Disclaimer :
The information, product and services provided on this website are provided on an “as is” and “as available” basis without any warranty or representation, express or implied. Khatabook Blogs are meant purely for educational discussion of financial products and services. Khatabook does not make a guarantee that the service will meet your requirements, or that it will be uninterrupted, timely and secure, and that errors, if any, will be corrected. The material and information contained herein is for general information purposes only. Consult a professional before relying on the information to make any legal, financial or business decisions. Use this information strictly at your own risk. Khatabook will not be liable for any false, inaccurate or incomplete information present on the website. Although every effort is made to ensure that the information contained in this website is updated, relevant and accurate, Khatabook makes no guarantees about the completeness, reliability, accuracy, suitability or availability with respect to the website or the information, product, services or related graphics contained on the website for any purpose. Khatabook will not be liable for the website being temporarily unavailable, due to any technical issues or otherwise, beyond its control and for any loss or damage suffered as a result of the use of or access to, or inability to use or access to this website whatsoever.
Disclaimer :
The information, product and services provided on this website are provided on an “as is” and “as available” basis without any warranty or representation, express or implied. Khatabook Blogs are meant purely for educational discussion of financial products and services. Khatabook does not make a guarantee that the service will meet your requirements, or that it will be uninterrupted, timely and secure, and that errors, if any, will be corrected. The material and information contained herein is for general information purposes only. Consult a professional before relying on the information to make any legal, financial or business decisions. Use this information strictly at your own risk. Khatabook will not be liable for any false, inaccurate or incomplete information present on the website. Although every effort is made to ensure that the information contained in this website is updated, relevant and accurate, Khatabook makes no guarantees about the completeness, reliability, accuracy, suitability or availability with respect to the website or the information, product, services or related graphics contained on the website for any purpose. Khatabook will not be liable for the website being temporarily unavailable, due to any technical issues or otherwise, beyond its control and for any loss or damage suffered as a result of the use of or access to, or inability to use or access to this website whatsoever.