Metal Density (Kg/m3) 7200

Core Density (Kg/m3) 1500

Sand Density (Kg/m3) 1500
Evapouration Loss (EL) 3%
Un-recoverable Spillage Loss (SL) 2%
%C in Pig Iron 3.80%
Carbon Recovery From Carburiser 85%
%Si in Pig Iron 1.40%
Silicon Recovery from FeSi 65%
%Mn in Pig Iron 0.20%
Mn Recovery from FeMn 60%
%Cu in Pig Iron 0.00%
Cu Recovery from Boughtout Cu 90%
%Sn in Pig Iron 0.00%
Sn Recovery from Tin Addition 95%
%Ni in Pig Iron 0.00%
Ni Recovery from Ni Addition 95%

Power Rate/Unit (Rs.) 6.55

CRCA Steel Scrap (Rs) 42.8
MS Steel Scrap (Rs) 32.5
Pig Iron 38
Carburiser (Rs) 50
CPC (Rs) 48
FeSi (Rs) 125
FeMn (Rs) 95
Copper (Cu) (Rs) 730
Tin (Sn) 1200
Nickel (Rs) 1426
FeSiMg (Rs) 158
Ladle Inoculant (SG) (Rs) 142
Stream Inoculant (SG) (Rs) 142
Ladle Inoculant (Grey) (Rs) 175
Stream Inoculant (Grey) (Rs) 175
RC Sand (Rs) 15
LPG Cost/Kg of RC Sand (Rs) 1.45
Mould Length (mm) 900
Mould Width (mm) 800
Mould Height (mm) 600
New Sand (Rs) 3.97
Bentonite (Rs) 9.34
Coal Dust (Rs) 20.57
Consumables/Kg (Rs) 1.5
Repair & Maintenance/Kg (Rs) 2.5
Shot Blasting/Kg (Rs) 1.2
Fettling/Kg (Grey) (Rs) 1.0
Fettling/Kg (SG) (Rs) 1.5
Painting/Kg (No Painting) (Rs) 0.0
Painting/Kg (Single Painting) (Rs) 1.0
Painting/Kg (Double Painting) (Rs) 1.5
Transportation/Kg (Rs) 1.5
Personnel Cost/Kg (Rs) 8.0
Interest/Kg (Rs) 7.5
Depreciation/Kg (Rs) 5.0

Rear Hub 2894.4

FWH 739 5546.75
FWH 896 3519.65
Nav 023 3914
Nav 210 605
Nav 101 309
Nav 940 2925
Nav 941 2890
FWH 800 2986.75
Clutch Hsg 2476.48
FWH 6661 3216.5
Signa 933 839
Part2 - SG
Part3 - SG
Part4 - SG
Part5 - SG
Part6 - Grey
Part7 - Grey
Part8 - Grey
Part9 - Grey
Part10 - Grey
 Cost Calculation

Casting Name
Part No.
Good Casting Weight (GCW) Kgs
No of Cavity
Casting Rejection (CR) at Foundry
Casting Rejection After Machining (CRAM) at Machine Shop
Total Rejection (TR)
At TR, the Required Casting Weight (RCW) (GCW/(1-(TR/100)
Pattern Plate Yield (PPY)
At PPY, the Required Liquid Metal (RLM) (RCW/(PPY/100) Kgs
Evapouration Loss (EL)
Un-recoverable Spillage Loss (SL)
Melting Loss (ML)
At ML, the Total Metallics Required (TMR) (RLM/(1-ML/100) Kgs
Runner, Riser & Rejection Generated (RRR) (RLM-GCW) Kgs

Charge Mix Calculation

RRR in the charge Kgs

Pig Iron Addition (X%)
Pig Iron Addition Required (X% of TMR) Kgs
Steel Scrap (CRCA) (TMR-RRR-PI) Kgs
Base %C
Final %C
Carburiser ((TMR* %Base Carbon - RRR * %Final Carbon - Pig Iron * %C in Pig Iron) / %Carbon
Recovery) Kgs
Base %Si
Final %Si
FeSi ((TMR*%Base Silicon-RRR*%Final Silicon - Pig Iron *%Silicon in Pig Iron)/%Si recovery in FeSi)
Kgs
Base %Mn
Final %Mn
FeMn ((TMR*%Base Mn-RRR*%Final Mn - Pig Iron *%Mn in Pig Iron)/%Mn recovery in FeMn) Kgs

Base %Cu
Final %Cu
Copper ((TMR*%Base Cu-RRR*%Final Cu - Pig Iron *%Cu in Pig Iron)/%Cu recovery ) Kgs
Base %Sn
Final %Sn
Tin ((TMR*%Base Sn-RRR*%Final Sn - Pig Iron *%Sn in Pig Iron)/%Sn recovery ) Kgs
Base %Ni
Final %Ni
Nickel ((TMR*%Base Ni-RRR*%Final Ni - Pig Iron *%Ni in Pig Iron)/%Ni recovery ) Kgs
%FeSiMg Addition
FeSiMg (RLM * %FeSiMg Addition) Kgs
%Ladle Inoculant Addition
Ladle Inoculant (RLM * %Ladle Inoculant Addition) Kgs
%Stream Inoculant Addition
Strem Inoculant (RLM * %Stream Inoculant Addition) Kgs

Power Cost Calculation

Melting Power Consumption(Px) (Number of Units/Ton of Liquid Metal) Unit

Auxiliary Power Consumption (Py) (Number of Units/Ton of Liquid Metal) Unit
Total Power Consumption (P) (Px + Py) (Units/Ton of Liquid Metal) Unit
Power Cost Per Good Castings (RLM/1000 * P * Rate/Unit) Rs.
Power Cost Per Kg of Good Castings (Power Cost Per Good Castings /Casting Wt.) Rs.

Core Cost Calculation

Number Of Cores/Casting
Core Wt. - Main Core (Kgs)
Core Wt. - All Small Core (Kgs)
Total Core Wt. (Main Core + Small Core) Kgs / Casting (Wc)
Core Rejection
Core Sand Spillage
Total Core Rejection (RCR)
Casting Rejection (TR)
Rate of RC Sand Rs.
Cost of LPG Consumption/Kg of RC Sand Rs.
Cost of Core Making/Kgs Rs.
Core Sand Required per Good Casting (Wc/((1-RCR)(1-TR))) Kgs
Core Cost per Good Castings Rs.

Sand to Metal Ratio Calculation

Mould Volume (L x B x H) m3
Poured Metal Weight ((No of Castings x Good Casting Wt.)/%Yield) Kgs
Metal Volume (Metal Weight/Metal Density) m3
Core Weight Kgs
Core Volume (Core Weight/Core Density) m3
Sand Volume (Mould Volume-Metal Volume-Core Volume) m3
Sand Weight (Sand Volume x Sand Density) Kgs
Sand to Metal Ratio (Sand Weight / Metal Weight)

Mould Material Cost

Sand to Metal Ratio (Sand Weight / Metal Weight)

Metal Weight Kgs (RLM)
Sand Weight (Metal Weight x Sand to Metal Ratio) Kgs
Mould Rejection
Sand Spillage
Sand Mix Required (SMR) ((Sand Weight)/(1-%Mould Rejection)(1-%Sand Spillage)) Kgs
New Sand Addition
New Sand Addition Kgs
New Sand Cost Rs.
Bentonite Addition
Bentonite Addition Kgs
Bentonite Cost Rs.
Coal Dust Addition
Coal Dust Addition Kgs
Coal Dust Cost Rs.
Molding Material Cost

Filter Type1
Filter1 /Mould
Filter1 Cost/Piece
Filter Type2
Filter2 /Mould
Filter2 Cost/Piece
Filter Cost/Casting
Sleeve Type1
Sleeve Cost/Piece
No of Sleeve used/Mould
Sleeve Type2
Sleeve Cost/Piece
No of Sleeve used/Mould
Sleeve Cost/Mould
Sleeve Cost/Casting
 Auto

Rear Hub FWH 739 FWH 896 Nav 023 Nav 210
5501 739 896 023 210
37 58.3 32.3 38.4 5.9
2 1 1 1 8
2% 3% 3% 3% 3%
5% 3% 3% 1% 3%
7% 6% 6% 4% 6%
39.78 62.02 34.36 40.00 6.28
70% 60% 49.60% 61.30% 58.50%
56.84 103.37 69.28 65.25 10.73
3% 3% 3% 3% 3%
2% 2% 2% 2% 2%
5% 5% 5% 5% 5%
59.83 108.81 72.92 68.69 11.29
19.84 45.07 36.98 26.85 4.83

19.84 45.07 36.98 26.85 4.83

5% 5% 5% 5% 5%
2.99 5.44 3.65 3.43 0.56
37.00 58.30 32.30 38.40 5.90
3.75% 3.70% 3.65% 3.70% 3.70%
3.50% 3.55% 3.55% 3.55% 3.55%
1.69 2.61 1.42 1.71 0.26

1.60% 1.55% 1.55% 1.65% 1.65%

2.30% 2.45% 2.45% 2.45% 2.45%

0.71 0.78 0.27 0.66 0.09

0.50% 0.35% 0.35% 0.45% 0.45%
0.50% 0.35% 0.35% 0.45% 0.45%

0.32 0.35 0.20 0.30 0.05

0.52% 0.30% 0.28% 0.50% 0.50%

0.52% 0.30% 0.28% 0.50% 0.50%
0.23 0.21 0.11 0.23 0.04
0.00% 0.00% 0.00% 0.00% 0.00%
0.00% 0.00% 0.00% 0.00% 0.00%
0.00 0.00 0.00 0.00 0.00
0.00% 0.00% 0.00% 0.00% 0.00%
 0.00% 0.00% 0.00% 0.00% 0.00%
0.00 0.00 0.00 0.00 0.00
1.40% 1.40% 1.40% 1.40% 1.40%
0.80 1.45 0.97 0.91 0.15
0.40% 0.40% 0.40% 0.40% 0.40%
0.23 0.41 0.28 0.26 0.04
0.10% 0.10% 0.10% 0.10% 0.10%
0.06 0.10 0.07 0.07 0.01

600 600 625 625 625

200 225 225 225 225
800 825 850 850 850
297.82 558.58 385.70 363.30 59.73
8.05 9.58 11.94 9.46 10.12

2 3 2 2 4
8.25 10 12.65 9.74 2.1
0.1 5 0 0 0
8.35 15 12.65 9.74 2.1
2% 2% 2% 2% 2%
1% 1% 1% 1% 1%
3% 3% 3% 3% 3%
7% 6% 6% 4% 6%
15 15 15 15 15
1.45 1.45 1.45 1.45 1.45
16.45 16.45 16.45 16.45 16.45
9.26 16.45 13.87 10.46 2.30
152.26 270.62 228.22 172.06 37.89

tion

0.432 0.432 0.432 0.432 0.432

105.71 97.17 65.12 62.64 80.68
0.0147 0.0135 0.0090 0.0087 0.0112
8.35 15 12.65 9.74 2.1
0.006 0.010 0.008 0.006 0.001
0.412 0.409 0.415 0.417 0.419
617.63 612.76 621.78 625.21 629.09
 5.84 6.31 9.55 9.98 7.80

5.84 6.31 9.55 9.98 7.80

56.84 103.37 69.28 65.25 10.73
332.06 651.87 661.47 651.26 83.66
3% 3% 3% 3% 3%
5% 5% 5% 5% 5%
360.34 707.40 717.82 706.74 90.78
1% 1% 1% 1% 1%
3.60 7.07 7.18 7.07 0.91
14.31 28.08 28.50 28.06 3.60
0.75% 0.75% 0.75% 0.75% 0.75%
2.70 5.31 5.38 5.30 0.68
25.24 49.55 50.28 49.51 6.36
0.25% 0.25% 0.25% 0.25% 0.25%
0.90 1.77 1.79 1.77 0.23
18.53 36.38 36.91 36.34 4.67
58.08 114.02 115.69 113.91 14.63

Filter 100*75*22 Filter 100*75*22 Filter 75*75*22 Filter 75*75*22 Filter 100*75*22
1 1 1 1 1
45 45 31 31 45

22.5 45 31 31 5.625
Sleeve 80*110 Sleeve 50*110 Sleeve 50*110 Sleeve 50*110
60.3 17.1 17.1 17.1
2 1 3 1
Sleeve 80*110
30.15
2
120.6 77.4 51.3 17.1 0
60.3 77.4 51.3 17.1 0
Nav 101 Nav 940 Nav 941 Signa 933 Part2 - SG
101 940 941 933
2.95 23.2 21.2 9.1
7 1 1 4
3% 3% 3% 3%
3% 5% 5% 3%
6% 8% 8% 6% 0%
3.14 25.22 23.04 9.68 0.00
37.70% 40.67% 37.93% 43.18%
8.32 62.00 60.75 22.42 #DIV/0!
3% 3% 3% 3% 3%
2% 2% 2% 2% 2%
5% 5% 5% 5% 5%
8.76 65.27 63.95 23.60 #DIV/0!
5.37 38.80 39.55 13.32 #DIV/0!

5.37 38.80 39.55 13.32 #DIV/0!

5% 5% 5% 5%
0.44 3.26 3.20 1.18 #DIV/0!
2.95 23.20 21.20 9.10 #DIV/0!
3.70% 3.75% 3.75% 3.70%
3.55% 3.65% 3.65% 3.55%
0.14 1.07 0.98 0.42 #DIV/0!

1.65% 1.65% 1.65% 1.55%

2.45% 2.45% 2.45% 2.45%

0.01 0.12 0.06 0.04 #DIV/0!

0.45% 0.45% 0.45% 0.35%
0.45% 0.45% 0.45% 0.35%

0.02 0.19 0.17 0.06 #DIV/0!

0.50% 0.50% 0.50% 0.30%

0.50% 0.50% 0.50% 0.30%
0.02 0.15 0.14 0.03 #DIV/0!
0.00% 0.00% 0.00% 0.00%
0.00% 0.00% 0.00% 0.00%
0.00 0.00 0.00 0.00 #DIV/0!
0.00% 0.38% 0.38% 0.00%
0.00% 0.38% 0.38% 0.00%
0.00 0.11 0.10 0.00 #DIV/0!
1.40% 1.40% 1.40% 1.40%
0.12 0.87 0.85 0.31 #DIV/0!
0.40% 0.40% 0.40% 0.40%
0.03 0.25 0.24 0.09 #DIV/0!
0.10% 0.10% 0.10% 0.10%
0.01 0.06 0.06 0.02 #DIV/0!

625 650 650 625

225 250 250 225
850 900 900 850 0
46.35 365.52 358.14 124.82 #DIV/0!
15.71 15.76 16.89 13.72 #DIV/0!

0 1 1 0
0 21.25 19.55
0 0 0
0 21.25 19.55 0 0
2% 2%
1% 1%
0% 3% 3% 0% 0%
0% 8% 8% 6% 0%
15 15 15 15 15
1.45 1.45 1.45 1.45 1.45
16.45 16.45 16.45 16.45 16.45
0.00 23.81 21.91 0.00 0.00
0.00 391.71 360.37 0.00 0.00

0.432 0.432 0.432 0.432 0.432

54.77 57.04 55.89 84.30 #DIV/0!
0.0076 0.0079 0.0078 0.0117 #DIV/0!
0 21.25 19.55 0 0
0.000 0.014 0.013 0.000 0.000
0.424 0.410 0.411 0.420 #DIV/0!
636.59 614.87 616.81 630.44 #DIV/0!
 11.62 10.78 11.04 7.48 #DIV/0!

11.62 10.78 11.04 7.48 #DIV/0!

8.32 62.00 60.75 22.42 #DIV/0!
96.75 668.33 670.44 167.67 #DIV/0!
3% 3% 3% 3%
5% 5% 5% 5%
104.99 725.27 727.55 181.95 #DIV/0!
1% 1% 1% 1%
1.05 7.25 7.28 1.82 #DIV/0!
4.17 28.79 28.88 7.22 #DIV/0!
0.75% 0.75% 0.75% 0.75%
0.79 5.44 5.46 1.36 #DIV/0!
7.35 50.80 50.97 12.75 #DIV/0!
0.25% 0.25% 0.25% 0.25%
0.26 1.81 1.82 0.45 #DIV/0!
5.40 37.30 37.41 9.36 #DIV/0!
16.92 116.89 117.26 29.33 #DIV/0!

Filter 75*75*22 Filter 75*75*22 Filter 75*75*22 Filter 75*75*22

1 1 1 1
31 31 31 31

4.42857142857 31 31 7.75 #DIV/0!

Sleeve 50*110 Sleeve 50*110
17.1 17.1
1 1
Sleeve 30*80 Sleeve 30*80
6 6
1 1
0 23.1 23.1
0 23.1 23.1 0 #DIV/0!
Part3 - SG Part4 - SG Part5 - SG Part6 - Grey Part7 - Grey

0% 0% 0% 0% 0%
0.00 0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

3% 3% 3% 3% 3%
2% 2% 2% 2% 2%
5% 5% 5% 5% 5%
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

0 0 0 0 0
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

0 0 0 0 0

0% 0% 0% 0% 0%
0% 0% 0% 0% 0%
15 15 15 15 15
1.45 1.45 1.45 1.45 1.45
16.45 16.45 16.45 16.45 16.45
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00

0.432 0.432 0.432 0.432 0.432

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0 0 0 0 0
0.000 0.000 0.000 0.000 0.000
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Part8 - Grey Part9 - Grey Part10 - Grey

0% 0% 0%
0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0!

3% 3% 3%
2% 2% 2%
5% 5% 5%
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

0 0 0
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

0 0 0

0% 0% 0%
0% 0% 0%
15 15 15
1.45 1.45 1.45
16.45 16.45 16.45
0.00 0.00 0.00
0.00 0.00 0.00

0.432 0.432 0.432

#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
0 0 0
0.000 0.000 0.000
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

The Cost of Metallics

S. No. Particulars

1 CRCA Steel Scrap

2 MS Steel Scrap
3 Pig Iron
4 Carburiser/CPC
5 CPC
6 FeSi
7 FeMn
8 Copper (Cu)
9 Tin (Sn)
10 Nickel
11 FeSiMg
12 Ladle Inoculant (SG)
13 Stream Inoculant (SG)
14 Ladle Inoculant (Grey)
15 Stream Inoculant (Grey)
A Total

B Power Cost

C Core Cost

18 New Sand Cost

19 Bentonite Cost
20 Coal Dust Cst
D Total

21 Filter Cost
22 Sleeve Cost
E Total

Consumables
Repair & Maintenance
Shot Blasting
Fettling
Painting
F Total

Transportation
Personnel Cost
 Interest
Depreciation
G Total

H Total Cost

I Total Cost Without Interest/Depreciation

J Selling Price/Pcs

K Overall Profit (Selling Price-Total Cost)

L Cash Profit (Selling Price-(Total Cost-Depreciation))

EBIDTA (Selling Price-Total Cost without

M
Interest/Depreciation)

N Contribution /Variable Loss (Selling Price-(Total

Cost -Personal cost-Interest-Depreciation))
 Rear Hub FWH 739
Cost of Metallics per Good Casting Cost of Metallics per Good Casting
1583.60 2495.24

113.67 206.74
84.45 130.54

88.29 97.34
30.71 33.60
168.67 155.10
0.00 0.00
0.00 0.00
125.72 228.65
32.28 58.71
8.07 14.68

2235.47 3420.61

297.82 558.58

152.26 270.62

14.31 28.08
25.24 49.55
18.53 36.38
58.08 114.02

22.50 45.00
60.30 77.40
82.80 122.40

55.5 87.45
92.5 145.75
44.4 70.0
55.5 87.45
55.5 58.3
303.40 448.91

55.5 87.45
296.0 466.4
 277.5 437.25
185.0 291.5
814.00 1282.60

3943.84 6217.74

3481.34 5488.99

2894.4 5546.75

-1049.44 -670.99

-864.44 -379.49

-586.94 57.76

-290.94 524.16
 FWH 896 Nav 023 Nav 210
Cost of Metallics per Good Casting Cost of Metallics per Good Casting Cost of Metallics per Good Casting
1382.44 1643.52 252.52

138.56 130.51 21.46

71.20 85.74 13.23

33.33 82.19 11.56

18.77 28.72 4.43
81.64 169.66 26.22
0.00 0.00 0.00
0.00 0.00 0.00
153.24 144.34 23.73
39.35 37.06 6.09
9.84 9.27 1.52

1928.36 2331.00 360.77

385.70 363.30 59.73

228.22 172.06 37.89

28.50 28.06 3.60

50.28 49.51 6.36
36.91 36.34 4.67
115.69 113.91 14.63

31.00 31.00 5.63

51.30 17.10 0.00
82.30 48.10 5.63

48.45 57.6 8.85

80.75 96 14.75
38.8 46.1 7.1
48.45 57.6 8.85
32.3 38.4 5.9
248.71 295.68 45.43

48.45 57.6 8.85

258.4 307.2 47.2
242.25 288 44.25
161.5 192.0 29.5
710.60 844.80 129.80

3699.59 4168.85 653.88

3295.84 3688.85 580.13

3519.65 3914 605

-179.94 -254.85 -48.88

-18.44 -62.85 -19.38

223.81 225.15 24.87

482.21 532.35 72.07

 Nav 101 Nav 940
Cost of Metallics per Good Casting Cost of Metallics per Good Casting
126.26 992.96

16.65 124.01
6.87 53.36

1.30 15.48
2.28 17.82
13.74 107.32
0.00 0.00
0.00 150.95
18.41 137.15
4.73 35.22
1.18 8.80

191.42 1643.09

46.35 365.52

0.00 391.71

4.17 28.79
7.35 50.80
5.40 37.30
16.92 116.89

4.43 31.00
0.00 23.10
4.43 54.10

4.425 34.8
7.375 58
3.5 27.8
4.425 34.8
2.95
22.72 155.44

4.425 34.8
23.6 185.6
22.125 174
14.8 116.0
64.90 510.40

346.73 3237.15

309.86 2947.15

309 2925

-37.73 -312.15

-22.98 -196.15

-0.86 -22.15

22.74 163.45
 Nav 941 FWH 800
Cost of Metallics per Good Casting Cost of Metallics per Good Casting
907.36
1274.00
121.51 127.86
49.00
70.90
7.96 137.62
16.37 56.22
98.95 51.79
0.00 0.00
139.16 0.00
134.38 0.00
34.51
8.63
22.38
11.19
1517.82 1751.95

358.14 345.47

360.37 268.81

28.88 28.44
50.97 50.19
37.41 36.84
117.26 115.47

31.00 11.40
23.10 0.00
54.10 11.40

31.8 58.8
53 98
25.4 47.0
31.8 39.2
39.2
142.04 282.24

31.8 58.8
169.6 313.6
 159 294
106.0 196.0
466.40 862.40

3016.13 3637.74

2751.13 3147.74

2890 2986.75

-126.13 -650.99

-20.13 -454.99

138.87 -160.99

308.47 152.61
 Clutch Hsg FWH 6661 Signa 933
Cost of Metallics per Good Casting Cost of Metallics per Good Casting Cost of Metallics p
389.48
1189.50 1376.38
133.55 116.07 44.84
20.91
64.95 76.78
127.45 150.30 4.41
52.87 60.14 5.32
97.61 55.24 25.01
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 49.59
12.73
3.18
23.37 20.31
11.69 10.16
1700.99 1865.37 555.49

360.83 313.61 124.82

152.45 234.54 0.00

28.71 28.58 7.22

50.66 50.43 12.75
37.19 37.02 9.36
116.57 116.04 29.33

31.00 0.00 7.75

0.00 0.00 0.00
31.00 0.00 7.75

54.9 63.525 13.65

91.5 105.875 22.75
43.9 50.8 10.9
36.6 42.35 9.1
54.9 42.35 9.1
281.82 304.92 65.52

54.9 63.525 13.65

292.8 338.8 72.8
 274.5 317.625 68.25
183.0 211.8 45.5
805.20 931.70 200.20

3448.86 3766.17 983.11

2991.36 3236.80 869.36

2476.48 3216.5 839

-972.38 -549.67 -144.11

-789.38 -337.92 -98.61

-514.88 -20.30 -30.36

-222.08 318.50 42.44

 Part2 - SG Part3 - SG Part4 - SG Part5 - SG Part6 - Grey
Cost of Metallics p Cost of Metallics p Cost of Metallics p Cost of Metallics p Cost of Metallics p
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0!
#DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

0.00 0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

0 0 0 0 0
0 0 0 0 0
0.0 0.0 0.0 0.0 0.0
0 0 0 0 0
0 0 0 0 0
0.00 0.00 0.00 0.00 0.00

0 0 0 0 0
0.0 0.0 0.0 0.0 0.0
 0 0 0 0 0
0.0 0.0 0.0 0.0 0.0
0.00 0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

0 0 0 0 0

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 Part7 - Grey Part8 - Grey Part9 - Grey Part10 - Grey
Cost of Metallics p Cost of Metallics p Cost of Metallics p Cost of Metallics per Good Casting

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0!

0 0 0 0
0 0 0 0
0.0 0.0 0.0 0.0
0 0 0 0
0 0 0 0
0.00 0.00 0.00 0.00

0 0 0 0
0.0 0.0 0.0 0.0
 0 0 0 0
0.0 0.0 0.0 0.0
0.00 0.00 0.00 0.00

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

0 0 0 0

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0!

 S. No.
Metallics per Good Casting
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
A

18
19
20
D

21
22
E

F
G

N
 Rear Hub FWH 739 FWH 896
Particulars
Cost of Metallics peCost of Metallics peCost of Metallics pe
CRCA Steel Scrap 42.80 42.80 42.80
MS Steel Scrap 0.00 0.00 0.00
Pig Iron 3.07 3.55 4.29
Carburiser 2.28 2.24 2.20
CPC 0.00 0.00 0.00
FeSi 2.39 1.67 1.03
FeMn 0.83 0.58 0.58
Copper (Cu) 4.56 2.66 2.53
Tin (Sn) 0.00 0.00 0.00
Nickel 0.00 0.00 0.00
FeSiMg 3.40 3.92 4.74
Ladle Inoculant (SG) 0.87 1.01 1.22
Stream Inoculant (SG) 0.22 0.25 0.30
Ladle Inoculant (Grey) 0.00 0.00 0.00
Stream Inoculant (Grey) 0.00 0.00 0.00
Total 60.42 58.67 59.70

Power Cost 8.05 9.58 11.94

Core Cost 4.12 4.64 7.07

New Sand Cost 0.39 0.48 0.88

Bentonite Cost 0.68 0.85 1.56
Coal Dust Cst 0.50 0.62 1.14
Total 1.57 1.96 3.58

Filter Cost 0.61 0.77 0.96

Sleeve Cost 1.63 1.33 1.59
Total 2.24 2.10 2.55

Consumables/Kg 1.50 1.50 1.50

Repair & Maintenance/Kg 2.50 2.50 2.50
Shot Blasting/Kg 1.20 1.20 1.20
Fettling/Kg 1.50 1.50 1.50
Painting/Kg 1.50 1.00 1.00
Total 8.20 7.70 7.70

Transportation/Kg 1.50 1.50 1.50

Personnel Cost/Kg 8.00 8.00 8.00
Interest/Kg 7.50 7.50 7.50
Depreciation/Kg 5.00 5.00 5.00
Total 22.00 22.00 22.00

Total Cost 106.59 106.65 114.54

Total Cost Without Interest/Depreciation 94.09 94.15 102.04

Selling Price/Kgs 78.23 95.14 108.97

Overall Profit (Selling Price-Total Cost) -28.36 -11.51 -5.57

Cash Profit (Selling Price-(Total Cost-Depreciation)) -23.36 -6.51 -0.57

EBIDTA (Selling Price-Total Cost without

-15.86 0.99 6.93
Interest/Depreciation)

Contribution /Variable Loss (Selling Price-(Total -7.86 8.99 14.93

Cost -Personal cost-Interest-Depreciation))
 Nav 023 Nav 210 Nav 101 Nav 940 Nav 941
Cost of Metallics peCost of Metallics peCost of Metallics peCost of Metallics peCost of Metallics pe
42.80 42.80 42.80 42.80 42.80
0.00 0.00 0.00 0.00 0.00
3.40 3.64 5.64 5.35 5.73
2.23 2.24 2.33 2.30 2.31
0.00 0.00 0.00 0.00 0.00
2.14 1.96 0.44 0.67 0.38
0.75 0.75 0.77 0.77 0.77
4.42 4.44 4.66 4.63 4.67
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 6.51 6.56
3.76 4.02 6.24 5.91 6.34
0.97 1.03 1.60 1.52 1.63
0.24 0.26 0.40 0.38 0.41
0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00 0.00 0.00
60.70 61.15 64.89 70.82 71.60

9.46 10.12 15.71 15.76 16.89

4.48 6.42 0.00 16.88 17.00

0.73 0.61 1.41 1.24 1.36

1.29 1.08 2.49 2.19 2.40
0.95 0.79 1.83 1.61 1.76
2.97 2.48 5.74 5.04 5.53

0.81 0.95 1.50 1.34 1.46

0.45 0.00 0.00 1.00 1.09
1.25 0.95 1.50 2.33 2.55

1.50 1.50 1.50 1.50 1.50

2.50 2.50 2.50 2.50 2.50
1.20 1.20 1.20 1.20 1.20
1.50 1.50 1.50 1.50 1.50
1.00 1.00 1.00 0.00 0.00
7.70 7.70 7.70 6.70 6.70

1.50 1.50 1.50 1.50 1.50

8.00 8.00 8.00 8.00 8.00
7.50 7.50 7.50 7.50 7.50
5.00 5.00 5.00 5.00 5.00
22.00 22.00 22.00 22.00 22.00

108.56 110.83 117.54 139.53 142.27

96.06 98.33 105.04 127.03 129.77

101.93 102.54 104.75 126.08 136.32

-6.64 -8.28 -12.79 -13.45 -5.95

-1.64 -3.28 -7.79 -8.45 -0.95

5.86 4.22 -0.29 -0.95 6.55

13.86 12.22 7.71 7.05 14.55

 FWH 800 Clutch Hsg FWH 6661 Signa 933 Part2 - SG
Cost of Metallics peCost of Metallics peCost of Metallics peCost of Metallics peCost of Metallics pe
0.00 0.00 0.00 42.80 #DIV/0!
32.50 32.50 32.50 0.00 #DIV/0!
3.26 3.65 2.74 4.93 #DIV/0!
0.00 0.00 0.00 2.30 #DIV/0!
1.81 1.77 1.81 0.00 #DIV/0!
3.51 3.48 3.55 0.48 #DIV/0!
1.43 1.44 1.42 0.58 #DIV/0!
1.32 2.67 1.30 2.75 #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0!
0.00 0.00 0.00 0.00 #DIV/0!
0.00 0.00 0.00 5.45 #DIV/0!
0.00 0.00 0.00 1.40 #DIV/0!
0.00 0.00 0.00 0.35 #DIV/0!
0.57 0.64 0.48 0.00 #DIV/0!
0.29 0.32 0.24 0.00 #DIV/0!
44.69 46.48 44.05 61.04 #DIV/0!

8.81 9.86 7.41 13.72 #DIV/0!

6.86 4.17 5.54 0.00 #DIV/0!

0.73 0.78 0.67 0.79 #DIV/0!

1.28 1.38 1.19 1.40 #DIV/0!
0.94 1.02 0.87 1.03 #DIV/0!
2.95 3.18 2.74 3.22 #DIV/0!

0.29 0.85 0.00 0.85 #DIV/0!

0.00 0.00 0.00 0.00 #DIV/0!
0.29 0.85 0.00 0.85 #DIV/0!

1.50 1.50 1.50 1.50 #DIV/0!

2.50 2.50 2.50 2.50 #DIV/0!
1.20 1.20 1.20 1.20 #DIV/0!
1.00 1.00 1.00 1.00 #DIV/0!
1.00 1.50 1.00 1.00 #DIV/0!
7.20 7.70 7.20 7.20 #DIV/0!

1.50 1.50 1.50 1.50 #DIV/0!

8.00 8.00 8.00 8.00 #DIV/0!
7.50 7.50 7.50 7.50 #DIV/0!
5.00 5.00 5.00 5.00 #DIV/0!
22.00 22.00 22.00 22.00 #DIV/0!

92.80 94.23 88.93 108.03 #DIV/0!

80.30 81.73 76.43 95.53 #DIV/0!

76.19 67.66 75.95 92.20 #DIV/0!

-16.61 -26.57 -12.98 -15.84 #DIV/0!

-11.61 -21.57 -7.98 -10.84 #DIV/0!

-4.11 -14.07 -0.48 -3.34 #DIV/0!

3.89 -6.07 7.52 4.66 #DIV/0!

 Part3 - SG Part4 - SG Part5 - SG Part6 - Grey Part7 - Grey
Cost of Metallics peCost of Metallics peCost of Metallics peCost of Metallics peCost of Metallics pe
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 Part8 - Grey Part9 - Grey Part10 - Grey
Cost of Metallics peCost of Metallics peCost of Metallics per Kg Casting
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

 1 2 3 4 5

CRCA Steel MS Steel

Scrap Scrap Pig Iron Carburiser CPC
Rear Hub 42.80 0.00 3.07 2.28 0.00
FWH 739 42.80 0.00 3.55 2.24 0.00
FWH 896 42.80 0.00 4.29 2.20 0.00
Nav 023 42.80 0.00 3.40 2.23 0.00
Nav 210 42.80 0.00 3.64 2.24 0.00
Nav 101 42.80 0.00 5.64 2.33 0.00
Nav 940 42.80 0.00 5.35 2.30 0.00
Nav 941 42.80 0.00 5.73 2.31 0.00
FWH 800 0.00 32.50 3.26 0.00 1.81
Clutch Hsg 0.00 32.50 3.65 0.00 1.77
FWH 6661 0.00 32.50 2.74 0.00 1.81
Signa 933 42.80 0.00 4.93 2.30 0.00
Part2 - SG #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Part3 - SG #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Part4 - SG #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Part5 - SG #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Part6 - Grey #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Part7 - Grey #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Part8 - Grey #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Part9 - Grey #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Part10 - Grey #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
 6 7 8 9 10 11 12

FeSi FeMn Copper (Cu) Tin (Sn) Nickel FeSiMg Ladle Inoculant (SG)
2.39 0.83 4.56 0.00 0.00 3.40 0.87
1.67 0.58 2.66 0.00 0.00 3.92 1.01
1.03 0.58 2.53 0.00 0.00 4.74 1.22
2.14 0.75 4.42 0.00 0.00 3.76 0.97
1.96 0.75 4.44 0.00 0.00 4.02 1.03
0.44 0.77 4.66 0.00 0.00 6.24 1.60
0.67 0.77 4.63 0.00 6.51 5.91 1.52
0.38 0.77 4.67 0.00 6.56 6.34 1.63
3.51 1.43 1.32 0.00 0.00 0.00 0.00
3.48 1.44 2.67 0.00 0.00 0.00 0.00
3.55 1.42 1.30 0.00 0.00 0.00 0.00
0.48 0.58 2.75 0.00 0.00 5.45 1.40
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
 13 14 15 A B

Power
Stream Inoculant (SG) Ladle Inoculant (Grey) Stream Inoculant (Grey) Total Cost
0.22 0.00 0.00 60.42 8.05
0.25 0.00 0.00 58.67 9.58
0.30 0.00 0.00 59.70 11.94
0.24 0.00 0.00 60.70 9.46
0.26 0.00 0.00 61.15 10.12
0.40 0.00 0.00 64.89 15.71
0.38 0.00 0.00 70.82 15.76
0.41 0.00 0.00 71.60 16.89
0.00 0.57 0.29 44.69 8.81
0.00 0.64 0.32 46.48 9.86
0.00 0.48 0.24 44.05 7.41
0.35 0.00 0.00 61.04 13.72
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
 C 18 19 20 D 21 22

New Sand Bentonite Coal Dust Sleeve

Core Cost Cost Cost Cst Total Filter Cost Cost
4.12 0.39 0.68 0.50 1.57 0.61 1.63
4.64 0.48 0.85 0.62 1.96 0.77 1.33
7.07 0.88 1.56 1.14 3.58 0.96 1.59
4.48 0.73 1.29 0.95 2.97 0.81 0.45
6.42 0.61 1.08 0.79 2.48 0.95 0.00
0.00 1.41 2.49 1.83 3.58 1.50 0.00
16.88 1.24 2.19 1.61 5.04 1.34 1.00
17.00 1.36 2.40 1.76 5.53 1.46 1.09
6.86 0.73 1.28 0.94 2.95 0.29 0.00
4.17 0.78 1.38 1.02 3.18 0.85 0.00
5.54 0.67 1.19 0.87 2.74 0.00 0.00
0.00 0.79 1.40 1.03 3.22 0.85 0.00
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
 E F

Repair & Shot

Consumable Maintenanc Blasting/K Painting/K
Total s/Kg e/Kg g Fettling/Kg g Total
2.24 1.50 2.50 1.20 1.50 1.50 8.20
2.10 1.50 2.50 1.20 1.50 1.00 7.70
2.55 1.50 2.50 1.20 1.50 1.00 7.70
1.25 1.50 2.50 1.20 1.50 1.00 7.70
0.95 1.50 2.50 1.20 1.50 1.00 7.70
1.50 1.50 2.50 1.20 1.50 1.00 7.70
2.33 1.50 2.50 1.20 1.50 0.00 6.70
2.55 1.50 2.50 1.20 1.50 0.00 6.70
0.29 1.50 2.50 1.20 1.00 1.00 7.20
0.85 1.50 2.50 1.20 1.00 1.50 7.70
0.00 1.50 2.50 1.20 1.00 1.00 7.20
0.85 1.50 2.50 1.20 1.00 1.00 7.20
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
 G H

Transportati Personnel Interest/K Depreciati

on/Kg Cost/Kg g on/Kg Total Total Cost
1.50 8.00 7.50 5.00 22.00 106.59
1.50 8.00 7.50 5.00 22.00 106.65
1.50 8.00 7.50 5.00 22.00 114.54
1.50 8.00 7.50 5.00 22.00 108.56
1.50 8.00 7.50 5.00 22.00 110.83
1.50 8.00 7.50 5.00 22.00 117.54
1.50 8.00 7.50 5.00 22.00 139.53
1.50 8.00 7.50 5.00 22.00 142.27
1.50 8.00 7.50 5.00 22.00 92.80
1.50 8.00 7.50 5.00 22.00 94.23
1.50 8.00 7.50 5.00 22.00 88.93
1.50 8.00 7.50 5.00 22.00 108.03
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
 I J K

Total Cost Without Overall Profit (Selling Price-

Selling Price/Kgs
Interest/Depreciation Total Cost)

94.09 78.23 -28.36

94.15 95.14 -11.51
102.04 108.97 -5.57
96.06 101.93 -6.64
98.33 102.54 -8.28
105.04 104.75 -12.79
127.03 126.08 -13.45
129.77 136.32 -5.95
80.30 76.19 -16.61
81.73 67.66 -26.57
76.43 75.95 -12.98
95.53 92.20 -15.84
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
#DIV/0! #DIV/0! #DIV/0!
 L M

Cash Profit (Selling Price- EBIDTA (Selling Price-Total Cost

(Total Cost-Depreciation)) without Interest/Depreciation)

-23.36 -15.86
-6.51 0.99
-0.57 6.93
-1.64 5.86
-3.28 4.22
-7.79 -0.29
-8.45 -0.95
-0.95 6.55
-11.61 -4.11
-21.57 -14.07
-7.98 -0.48
-10.84 -3.34
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
 N

Contribution /Variable Loss (Selling Price-

(Total Cost -Personal cost-Interest-
Depreciation))

-7.86
8.99
14.93
13.86
12.22
7.71
7.05
14.55
3.89
-6.07
7.52
4.66
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
S. No. Particulars Signa 933
1 CRCA Steel Scrap 42.80
2 MS Steel Scrap 0.00
3 Pig Iron 4.93
4 Carburiser 2.30
5 CPC 0.00
6 FeSi 0.48
7 FeMn 0.58
8 Copper (Cu) 2.75
9 Tin (Sn) 0.00
10 Nickel 0.00
11 FeSiMg 5.45
12 Ladle Inoculant (SG) 1.40
13 Stream Inoculant (SG) 0.35
14 Ladle Inoculant (Grey) 0.00
15 Stream Inoculant (Grey) 0.00
A Total 61.04

B Power Cost 13.72

C Core Cost 0.00

18 New Sand Cost 0.79

19 Bentonite Cost 1.40
20 Coal Dust Cost 1.03
D Sand Cost 3.22

20 Filter Cost 0.85

20 Sleeve Cost 0.00
E Mould Cost 0.85

Consumables/Kg 1.50
Repair & Maintenance/Kg 2.50
Shot Blasting/Kg 1.20
Fettling/Kg 1.00
Painting/Kg 1.00
F Total 7.20

Transportation/Kg 1.50
Personnel Cost/Kg 8.00
Interest/Kg 7.50
 Depreciation/Kg 5.00
G Total 22.00

H Total Cost 108.03

Total Cost Without

I 95.53
Interest/Depreciation

J Selling Price/Kgs 92.20

K Overall Profit/Kgs -15.84

L Cash Profit/Kgs -10.84

M EBIDTA/Kgs -3.34

N Contribution/Variable Loss per Kgs 4.66