Most Indian manufacturers guess their selling price. A cost sheet calculates it precisely — covering materials, machine time, overheads and target profit. Here is how to build one.
Zoplax Team
ERP Specialists · Manufacturing & Logistics Experts
Ask a small manufacturer how they calculated their selling price. The most common answers:
"I added 20% to my material cost." "I checked what the competition charges and matched it." "My customer told me what the maximum price is."
None of these is a cost sheet. All of them lead to the same problem: you do not actually know whether you are making money or losing money on each product.
A cost sheet changes that. It builds the selling price from first principles: exact material cost, machine time cost, overhead allocation, rejection loss, and target profit. The result is a price you can defend to any customer — because you know exactly how it was calculated.
For each component or raw material used: - Material name and specification - Quantity required per unit of finished product - Current purchase price per unit - Scrap / yield loss percentage
Material cost per unit = Σ (Qty × Rate / (1 - Scrap%))
For example: 2 kg of steel at ₹85/kg with 8% scrap = 2 × 85 / 0.92 = ₹184.78 material cost.
For each operation performed: - Operation name (turning, milling, welding, etc.) - Machine used - Standard cycle time (minutes per piece) - Machine rate per hour (electricity, depreciation, maintenance amortised)
Operation cost per unit = Cycle time (min) / 60 × Machine rate (₹/hr)
For example: 12 minutes on a CNC lathe at ₹180/hr = 12/60 × 180 = ₹36.00 per piece.
Some businesses separate direct labour from machine cost: - Operator hours per unit × operator rate per hour
Others include operator cost in the machine rate. Either approach works — consistency is what matters.
Overhead allocation covers factory indirect costs: rent, utilities (portion not in machine rate), supervision salaries, quality department, stores.
A simple method: apply an overhead percentage to total direct cost.
If your monthly overheads are ₹2,00,000 and monthly direct cost of production is ₹10,00,000, overhead percentage = 20%.
Overhead cost per unit = (Material + Machine + Labour) × 20%
In most manufacturing, not every produced part is accepted. If rejection rate is 5%, the cost per good piece is higher because the rejected pieces were produced at cost but not sold.
Rejection-adjusted cost = Direct cost / (1 - Rejection rate)
Finally, add target profit:
Selling price = Total cost per unit / (1 - Target margin%)
If total cost is ₹450 and target margin is 25%: Selling price = ₹450 / 0.75 = ₹600
When a customer asks "what is your best price for 500 pieces of this component?", you have two options:
The second approach lets you: - Give a confident price that you know is profitable - Identify which elements to negotiate on (can we reduce the spec to use cheaper material? Can we change the routing to cut machine time?) - Know your absolute floor price — the minimum below which you lose money
Zoplax has a built-in cost sheet module inside the quotation workflow:
Click "Apply to Line 1" and the calculated price fills the quotation line item.
The cost sheet is saved with the quotation. When the order comes in and you need to review pricing, the cost sheet is right there. When you do a revision, the cost sheet is cloned automatically so you can adjust without losing the original calculation.
You can also toggle "Include Cost in PDF" — if the customer wants to see the cost breakdown (common in industrial B2B negotiations), it is included in the quotation PDF.
When a customer negotiates and you revise the quotation, Zoplax creates a new revision with status "Cancelled" on the old one. The cost sheet is cloned to the new revision.
This means you have a complete history: - Rev 0: Original price ₹600 (cost sheet showing ₹450 cost + 25% margin) - Rev 1: Revised price ₹560 (cost sheet showing ₹450 cost + 20% margin)
You can clearly see at what margin you accepted the order — and whether it is still worthwhile.
When you assign a machine in a cost sheet operation, the rate fills automatically. You only need to enter cycle time.
Keeping machine rates updated (review quarterly or when electricity rates change) ensures your cost sheets remain accurate.
Start building cost sheets for your products — free trial at zoplax.in.
GST updates, inventory tips, manufacturing insights — straight to your inbox. Practical, not promotional.
No spam. Unsubscribe anytime.
Written by Zoplax Team
ERP Specialists with experience in manufacturing, logistics and GST compliance for Indian SMEs. Based in Chennai, India.
30-Day Free Trial · No Credit Card
Join hundreds of Indian manufacturers, traders and logistics businesses who run their entire operations on Zoplax — inventory, GST, manufacturing, logistics and HR in one cloud platform.
India has 63 million MSMEs — and most still manage their manufacturing operations on Excel sheets, paper registers, and WhatsApp messages. Here is why cloud ERP is the game-changer they need.
Read article →ManufacturingSmall manufacturers across India face common operational challenges that limit their growth. We break down the top 5 problems and how modern ERP software solves each one.
Read article →ManufacturingMost small Indian manufacturers are operating at 60-70% efficiency without knowing it. Here is how to measure and systematically improve production efficiency using ERP tools.
Read article →ManufacturingDelivery delays are one of the top complaints customers have about Indian manufacturers. A proper dispatch management system eliminates the chaos and keeps customers informed.
Read article →