Live Support
+1-802-778-9005A cost sheet or statement of cost and profit, is a tabular document in cost accounting showing the cost components of a specific product for a given period.
Cost Sheets consist of various elements like prime cost, fixed cost, variable cost, factory cost, administrative cost, etc.
Some examples of cost components are raw material costs, selling and distribution costs, factory overheads, distribution costs, etc.
A cost sheet is used in cost accounting for cost control, selling price fixation, financial reporting, etc. Preparation of the cost sheet can be done using historical cost concepts or estimate cost concepts.
A simple cost sheet format helps determine total cost, unit cost, cost of goods sold, selling price, profit, etc. Cost sheets differ from financial statements as they can be prepared weekly, monthly, or yearly. A cost sheet helps decision-making management, policy formation, and profitability.
Cost Sheet helps with various aspects of the business:
The format of the cost sheet is prepared by identifying the costs of multiple components used in the production of a product. A simple cost sheet format includes elements of cost accounting like direct labor, direct material, factory overheads, cost of production, cost of goods sold, selling expenses, etc.
In the cost sheet, there are different formats for various industries like manufacturing, real estate, clothing, retail, service, etc. A free template of the cost sheet for Excel is provided here for your convenience.
Proforma of a Cost Sheet for a Company
(Template of a Cost Sheet)
| Cost sheet of ________ for the month of ______ | |||
| Particulars | Amount | Amount | |
| Direct Material | |||
| Opening Stock of Raw Material | xxx | ||
| Add: Material Purchased | xxx | ||
| Less: Closing Stock of Raw Materials | xxx | ||
| Direct Labour | xxx | ||
| Direct Expenses: | |||
| Carriage Inwards | xxx | ||
| Royalties | xxx | ||
| Prime Cost | xxx | ||
| Add: Factory Overheads: | |||
| Indirect Material: | |||
| Cleaning Supplies | xxx | ||
| Spare Parts | xxx | ||
| Personal protective equipment | xxx | ||
| Indirect Expenses: | |||
| Power and Fuel | xxx | ||
| Factory Rent | xxx | ||
| Water Supply | xxx | ||
| Depreciation Expenses of Factory Machinery | xxx | xxx | |
| Add: Opening Stock of Work-in-Progress | xxx | ||
| Less: Closing Stock of Work-in-Progress | xxx | ||
| Factory Cost/ Works Cost | xxx | ||
| Add: Office & Administrative Expenses: | |||
| Office Rent | xxx | ||
| Printing and Stationary | xxx | ||
| Audit Fees | xxx | ||
| Legal Charges | xxx | ||
| Telephone and Postage | xxx | ||
| Depreciation Expenses of Office Furniture | xxx | ||
| Bank Charges and Commission | xxx | ||
| Less: Scrap Sold/ Recoveries/ By-Product Produced | xxx | xxx | |
| Cost of Production | xxx | ||
| Add: Opening Stock of Finished Goods: | xxx | ||
| Less: Closing Stock of Finished Goods | xxx | xxx | |
| Cost of Goods Sold | xxx | ||
| Add: Selling & Distribution Overheads: | |||
| Sales Team Salary | xxx | ||
| Commission on Sales | xxx | ||
| Advertising Expenses | xxx | ||
| Traveling Expenses | xxx | ||
| Warehouse Rent | xxx | ||
| Carriage Outwards | xxx | ||
| Marketing Campaign Expenses | xxx | xxx | |
| Total Cost of Sales | xxx | ||
| Add: Profit | xxx | ||
| Total Sales | xxx | ||
Different components of the cost sheet like prime cost, factory cost, cost of production, etc. can be understood by a simple example in tabular format. This will provide us with a better understanding of material consumption, labor wages, direct expenses, etc. Below is a simple cost sheet example with a solution for April 2024, for a manufacturing company.
Solution:
Direct material purchased = 4,500,000
Opening stock of raw materials = 1,500,000
Closing stock of raw materials = 300,000
Direct Labor = 2,500,000
Direct expenses = 700,000
Factory overhead = 90% of direct Labor
Office and administration overhead = 30% of work cost
Selling and distribution overhead = 750,000
Cost of opening stock for finished goods = 350,000
Cost of closing stock for finished goods = 150,000
Profit on cost = 24% on Cost of Sales
| Cost sheet of XYZ LTD. for April 2024 | |||
| Particulars | Amount | Amount | |
| Direct Material: | |||
| Opening Stock of Raw Material | 1500000 | ||
| Add: Material Purchased | 4500000 | ||
| Less: Closing Stock of Raw Materials | -300000 | ||
| Direct Labour | 2500000 | ||
| Direct Expenses | 700000 | ||
| Prime Cost | 8900000 | ||
| Add: Factory Overheads (90% of Direct Labor) | 2250000 | ||
| Factory Cost/ Works Cost | 11150000 | ||
| Add: Office & Administrative Expenses (30% of Work Cost) | 3345000 | ||
| Cost of Production | 14495000 | ||
| Add: Opening Stock of Finished Goods: | 350000 | ||
| Less: Closing Stock of Finished Goods | 150000 | ||
| Cost of Goods Sold | 14695000 | ||
| Add: Selling & Distribution Overheads: | 750000 | ||
| Total Cost of Sales | 15445000 | ||
| Add: Profit (24%of Cost of Sales) | 3706800 | ||
| Total Sales | 19151800 | ||
There are four basic categories of costs: direct, indirect, variable, and fixed costs.
The cost sheet consists of different components in which prime cost, factory cost, cost of production, and cost of sales form the major part. Each part is explained below:
Prime cost, which is also known as first cost or direct cost, includes direct material, direct labor, and direct expenses. It mainly consists of all the items directly related to the production of a product. Prime cost is considered a variable cost because it is directly connected to the units of production done.
The formula for Prime cost is:
Prime Cost = Direct Material + Direct Labor + Direct Expenses
Direct Material is the cost of raw materials used directly in the production process.
The formula for direct material in accounting is:
Direct Material = Opening Stock + Purchases and Expenses on Purchases – Closing Stock
Direct Labour includes all the payroll expenses an organization makes to the workers or employees who are engaged directly in the production. It includes elements like wages and salary, compensation, employee benefits, payroll taxes, health insurance, etc.
Direct Expenses or chargeable expenses are directly connected to the production process. It consists of items like contractual payments, custom duty, job charges, the cost of special designs, etc.
Factory cost is the total manufacturing cost, including prime cost and factory overheads. It is also known as work cost, manufacturing cost, service cost, etc.
The formula for Factory cost is:
Factory Cost = Prime Cost + Factory Overheads
Factory Overheads are indirect expenses which do not contribute to the production process directly but are important to carry out. It mainly includes rent, factory lighting, depreciation charges, maintenance charges, repairs, carriages, etc.
The formula for factory overhead is:
Factory Overheads = Indirect Material + Indirect Labor + Indirect Expenses
Cost of production also known as product cost is equal to the sum of all the expenses incurred in the production process whether they are direct or indirect. It consists of fixed cost, variable cost, average cost, marginal cost, etc.
The formula for calculating the cost of production is:
Cost of Production = Factory Cost + Office & Administrative Overheads
Office and Administrative Overheads are expenses incurred by the overall administrative work and office expenses which indirectly help in the production process. It consists of components like printing and stationary, legal charges, telephone and internet expenses, advertising, etc.
Cost of sales commonly known as total sales is the sum of cost of production and selling & distribution overheads. It helps in determining the final value of a product or service after determining all expenses.
The formula for cost of sales is:
Cost of Sales = Cost of Production + Selling & Distribution Overheads
Selling and Distribution Overheads are indirect expenses facilitating the marketing and sales level of a product. It consists of expenses like advertising, salesmen’s salaries, marketing campaign funds, traveling expenses, distribution and delivery charges, etc.
Follow simple and easy steps to create or produce a cost sheet:
A historical cost sheet is a cost sheet that works on the principle of historical cost by considering the actual expenses the company has to bear. This cost sheet does not fluctuate based on market prices maintaining the financial stability of the document by depicting an accurate image. Historical cost sheets are mainly utilized by industries like manufacturing, real estate, financial services, retail, construction, etc.
An estimated cost sheet is a cost sheet that works on the principle of estimated cost by considering the approximate projected cost of the components of the cost sheet. This cost sheet is vulnerable to market fluctuations and is usually created before starting the production process. The estimated cost sheet helps the organization in the process of quoting prices for the components. This type of cost sheet is used by industries related to education, healthcare, travel, agriculture, etc.
The cost sheet and financial statement both provide profit calculations but are very different from each other.
Below are the differences in table format:
| Basis | Cost Sheet | Financial Statements |
| Meaning | A cost sheet refers to a statement in cost accounting showing the cost of different components incurred by the business for the production of a specific product within a specific period. | A financial statement refers to a set of documents depicting the financial position and performance of the organization within a year. |
| Timeline | Cost sheets can be created at regular intervals for a business like weekly, monthly, quarterly, or yearly. | Financial statements are usually created at the end of a financial year. |
| Cost Concept | Cost sheets can work on both actual and estimated cost concepts usually known as historical cost sheets and estimated cost sheets respectively. | Financial statements only operate on the historical cost concept by using the actual expenses at the end of the year. |
| Usage | The cost sheet is used for multiple purposes like internal decision-making, quoting prices, submitting tenders, etc. | Financial statements are used to evaluate the financial position and profitability of the business. |
| Stakeholders Involved | Management, Suppliers, Operation Managers, Budgeting Teams, Cost Accountants, etc. | Investors, Management, Tax Authorities, Government, Customers, Employees, etc. |
Cost sheet analysis provides you with the cost components of a product and offers many useful insights about the product:
The cost sheet provides multiple insights about the quantitative concepts but also has drawbacks like:
In real estate and construction, cost sheets are crucial for project management. They contain thorough analyses of the price of building supplies, labor, equipment, and permits. Real estate developers also use cost sheets to project development expenses, which aids in property pricing. In this industry, cost assessment and monitoring are essential due to variables, including labor availability, regulatory changes, and fluctuating material prices.
Cost sheets in these industries include a wide range of intricate charges, such as those related to clinical trials, manufacturing, regulatory compliance, and research and development. These sectors frequently have to keep tabs on expenses per patient or prescription unit manufactured. Precise cost accounting is essential for setting drug prices, allocating funds for research, and maintaining profitability while providing high-quality medical care.
The cost of developing software, hardware, or technology goods is determined in the technology and software industry using cost sheets. This covers costs for testing, licensing, support, and coding. To make well-informed decisions on product development and pricing strategies, companies must perform accurate cost analysis in light of the competition and rapid technological improvements.
Excel-based cost sheet templates are widely utilized, because of their familiarity and flexibility . They enable companies to design cost sheets that are unique to their requirements. Smaller companies or those with less complex cost structures can use these templates.
Cost monitoring components are available in QuickBooks, Xero, and Sage, among other specialized accounting programs. These systems offer advanced functionality for cost allocation, expense classification, and interaction with other financial processes. They are appropriate for enterprises of all shapes and sizes.
Cloud-based cost analysis solutions like NetSuite and FreshBooks provide real-time cost tracking, scalability, and collaboration. They are very helpful for companies that need centralized data storage and remote access. Frequent integration of cloud solutions with other corporate applications improves efficiency.
A cost sheet is an important statement showing the break-up cost of each component used in the production process of a specific product in a given period. The cost sheet format depends on the industry type and cost principle followed by the business. The cost sheet plays an important role for different stakeholders of the business like management, suppliers, operation department, etc. The cost sheet remains a central part of the decision-making process independent of the organization’s size, small or big.
