# Manufacturing Cost Sheet Template in Rupees for Indian Plants

> Source: https://netray.co/tools/india-manufacturing-cost-sheet-template-rs
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable cost sheet that builds prime cost, works cost, cost of production, cost of sales and unit cost by product for a period or batch.

## Category

cost-finance

## Region

India

## Industry

Manufacturing

## Audience

- Cost accountant
- Finance controller
- Plant owner
- Pricing manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** Rs 

**Columns:**

#### Product

**Key:** product

**Type:** text

#### Units produced

**Key:** units

**Type:** number

**Unit:** nos

#### Direct materials

**Key:** dm

**Type:** number

**Format:** currency

#### Direct labour

**Key:** dl

**Type:** number

**Format:** currency

#### Direct expenses

**Key:** de

**Type:** number

**Format:** currency

#### Factory overhead

**Key:** fo

**Type:** number

**Format:** currency

#### Administration overhead

**Key:** ao

**Type:** number

**Format:** currency

#### Selling and distribution

**Key:** so

**Type:** number

**Format:** currency

#### Prime cost

**Key:** prime

**Type:** number

**Expr:** dm + dl + de

**Format:** currency

#### Cost of production

**Key:** cop

**Type:** number

**Expr:** dm + dl + de + fo + ao

**Format:** currency

#### Cost of sales

**Key:** cos

**Type:** number

**Expr:** dm + dl + de + fo + ao + so

**Format:** currency

#### Cost per unit

**Key:** unit_cost

**Type:** number

**Expr:** cos / units

**Format:** currency

**Rows:**

#### Hydraulic cylinder 50 mm

**Units:** 1200

**Dm:** 1380000

**Dl:** 276000

**De:** 48000

**Fo:** 312000

**Ao:** 96000

**So:** 84000

#### Gear housing casting

**Units:** 3500

**Dm:** 2275000

**Dl:** 420000

**De:** 105000

**Fo:** 560000

**Ao:** 154000

**So:** 140000

#### Control panel enclosure

**Units:** 800

**Dm:** 512000

**Dl:** 144000

**De:** 16000

**Fo:** 128000

**Ao:** 48000

**So:** 64000

#### Machined shaft 40 mm

**Units:** 6000

**Dm:** 1620000

**Dl:** 540000

**De:** 60000

**Fo:** 690000

**Ao:** 180000

**So:** 120000

#### Cable harness assembly

**Units:** 2500

**Dm:** 750000

**Dl:** 325000

**De:** 25000

**Fo:** 200000

**Ao:** 87500

**So:** 100000

**Totals:**

#### Total direct materials

**Key:** dm

**Agg:** sum

**Format:** currency

#### Total prime cost

**Key:** prime

**Agg:** sum

**Format:** currency

#### Total cost of production

**Key:** cop

**Agg:** sum

**Format:** currency

#### Total cost of sales

**Key:** cos

**Agg:** sum

**Format:** currency

**Summary:**

#### Works cost

**Key:** works

**Expr:** sum_prime + sum_fo

**Format:** currency

**Description:** Prime cost plus factory overhead.

#### Material share of cost of sales

**Key:** mat_share

**Expr:** sum_dm / sum_cos * 100

**Format:** percent

#### Overhead share of cost of sales

**Key:** oh_share

**Expr:** (sum_fo + sum_ao + sum_so) / sum_cos * 100

**Format:** percent

#### Average cost of sales per line

**Key:** avg_cost

**Expr:** sum_cos / count

**Format:** currency

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use the template

**Body:** 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

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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.

**Cta:** 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.

**Faq:**

#### What is the difference between works cost and cost of production?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

cost sheet format, manufacturing cost sheet excel, cost sheet template india, prime cost works cost cost of production, cost sheet with example, product costing format, cost of sales statement, cost sheet for manufacturing company

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json