Manufacturing Cost Sheet Template in Rupees for Indian Plants
A cost sheet shows how the cost of a product builds up from materials to the final cost of sales. This editable template follows the classical Indian format used in cost accounting, with prime cost, works cost, cost of production and cost of sales for each product.
| Product | Units produced (nos) | Direct materials | Direct labour | Direct expenses | Factory overhead | Administration overhead | Selling and distribution | Prime cost | Cost of production | Cost of sales | Cost per unit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Rs 1,704,000 | Rs 2,112,000 | Rs 2,196,000 | Rs 1,830 | |||||||||
Rs 2,800,000 | Rs 3,514,000 | Rs 3,654,000 | Rs 1,044 | |||||||||
Rs 672,000 | Rs 848,000 | Rs 912,000 | Rs 1,140 | |||||||||
Rs 2,220,000 | Rs 3,090,000 | Rs 3,210,000 | Rs 535 | |||||||||
Rs 1,100,000 | Rs 1,387,500 | Rs 1,487,500 | Rs 595 |
Add one row per product or batch for the period. Enter overhead after allocation to the product. Opening and closing work in progress and finished goods stock are not adjusted here, so adjust separately if your statement needs them. Add a profit margin on top of cost of sales to arrive at the selling price.
Build cost sheets from ERP production orders
Optional: discuss pulling product costs automatically from your ERP.
Optional. The tool and every export work without this. No spam.
How to use the template
Replace the example rows with your products or batches. Enter units produced and the cost heads in rupees, with overheads already allocated to each product. The sheet computes prime cost, cost of production, cost of sales and unit cost in every row, and the totals and summary update below. Export to Excel or PDF to attach to a quotation file, a costing review or a lender discussion. Run it once per period or per work order.
The cost build-up
Prime cost is direct materials, direct labour and direct expenses. Adding factory overhead gives works cost. Adding administration overhead gives cost of production. Adding selling and distribution overhead gives cost of sales. Profit on top gives the selling price. This structure follows the cost accounting standard approach to cost sheets, with each layer reflecting a different management question, from shop floor efficiency to total commercial cost.
- Prime cost: what the product directly consumes
- Works cost: adds the plant's running costs
- Cost of sales: the full cost to deliver to the customer
Reading the summary
The material share tells you how exposed you are to commodity swings. In many engineering plants it sits well above half of the cost of sales. The overhead share shows how much cost depends on volume and allocation methods. If one product shows a unit cost far above peers with similar processes, check its overhead basis and any scrap or rework not captured in materials. Compare the unit cost with the selling price to see contribution.
Common mistakes
Mistakes include loading all overhead on a single driver, leaving out scrap and wastage, mixing GST into material cost, and ignoring stock changes between periods. Input GST should be excluded from material cost where credit is available. In your ERP, pull direct costs from production orders and overheads from cost centres so the sheet ties back to ledgers.
Frequently Asked Questions
What is the difference between works cost and cost of production?
Works cost is prime cost plus factory overhead. Cost of production adds administration overhead to works cost, after adjusting for work in progress. The first measures the plant, the second includes the general management burden of producing the goods.
Should GST be included in the cost sheet?
No, where input tax credit is available. Material cost should be net of recoverable GST. If credit is blocked or the business cannot claim it, the non-creditable part becomes part of the cost of the item.
How do I allocate overhead to products?
Common bases are machine hours, direct labour hours or direct labour cost for factory overhead, and a percentage of works cost for administration. Pick a driver that reflects actual consumption, and apply it consistently from period to period.
Can I use this for quotation pricing?
Yes. Use the cost of sales per unit as the base, add the margin you need, and compare with market price and customer targets. Review materials separately when quoting long contracts, since price changes affect the margin quickly.
If your cost sheets are still built from exports and manual allocations, we can help produce them directly from ERP production orders and cost centres.
Related Tools
PLI Scheme Readiness Assessment for Indian Manufacturers
A 10-question score of how ready your company is to apply for and claim a Production Linked Incentive, with recommendations by band.
Country & TaxTDS on Purchase of Goods Section 194Q Calculator (India)
Works out section 194Q TDS on a vendor invoice after the annual Rs 50 lakh threshold, excluding GST shown separately, and the net amount to pay.
Country & TaxGratuity Calculator for Indian Manufacturing Employees
Calculates gratuity on the 15 days per year formula with the divisor of 26 working days, service rounding and the statutory ceiling, with a service-length chart.
Country & TaxMonthly GST Compliance Checklist for Indian Manufacturers
A month-end GST routine for Indian plants covering sales, purchases, ITC, job work, e-way bills and return filing.
More Costing & Finance tools
See all- India Plant and Machinery WDV Depreciation Calculator
- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet