Scribd
Upload
21 views12 pages

Gross Yield and Weight Analysis

The document appears to be a table containing production data for casted products including product number, gross weight, casting weight, yield percentage, and calculated gross weight at 60% yield. It also includes notes in the last column on some products with actions taken or needed to improve yields and reduce weights. The table contains over 50 products and is analyzing their production results and identifying ways to potentially reduce weights and improve yields.

Uploaded by

Umesh Sakhareliya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views12 pages

Gross Yield and Weight Analysis

The document appears to be a table containing production data for casted products including product number, gross weight, casting weight, yield percentage, and calculated gross weight at 60% yield. It also includes notes in the last column on some products with actions taken or needed to improve yields and reduce weights. The table contains over 50 products and is analyzing their production results and identifying ways to potentially reduce weights and improve yields.

Uploaded by

Umesh Sakhareliya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
  • Data Tables and Calculations
  • Improvement Records

50 - 60 % < 50% > 60%

A B C = (B/A)*100 D

Method Gross weight @


Product No Gross Weight Casting Weight % Yield
Rev. No 60% Yield

9A0004 0 187.88 104.98 55.88 174.97


9A0005 0 62.92 25.99 41.31 43.32
9A0006 0 19.65 8.73 44.43 14.55
570118 0 200 132.4 66.20 220.67
6A0005 0 130.9 76.05 58.10 126.75
6A0001 0 130.65 68.81 52.67 114.68
6A0002 0 254.7 188.75 74.11 314.58
6A0003 0 37.016 20.75 56.06 34.58
6A0004 0 26.83 10.7 39.88 17.83
610003 0 52.78 22.8 43.20 38.00
610004 0 72.58 31.42 43.29 52.37
610003 1 22.8 #DIV/0! 38.00
610004 1 56.68 31.42 55.43 52.37
9A0007 0 15.1 10.65 70.53 17.75
9A0008 0 7.4 2.95 39.86 4.92
9A0009 0 3.775 0.7 18.54 1.17
840001 0 #DIV/0! 0.00
840002 0 65 31.14 47.91 51.90
840003 #DIV/0! 0.00
840004 #DIV/0! 0.00
840005 0 67 35.07 52.34 58.45
840006 #DIV/0! 0.00
840007 0 69 32.11 46.54 53.52
840008 0 162 102.075 63.01 170.13
840011 #DIV/0! 0.00
840012 0 58 29.35 50.60 48.92
570115 0 6.8 2.75 40.44 4.58
400 Casted Plug Nali 98 61.3 62.55 102.17
450 Casted Plug Nali 120 82.7 68.92 137.83
400 Casted Plug P/l 91.85 61.3 66.74 102.17
450 Casted Plug P/l 109.75 82.7 75.35 137.83
570121 0 30.1 23 76.41 38.33
570122 0 14.15 10.2 72.08 17.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
#DIV/0! 0.00
E = A-D

Difference in
Gross weight

12.91
19.60
5.10
-20.67
4.15 126.55 one casting carry
15.97
-59.88 ok
2.43
9.00 Action Taken
14.78 Action Taken
20.21 Action Taken
-38.00
4.31
-2.65
2.48
2.61
0.00
13.10
0.00
0.00
8.55
0.00
15.48
-8.13
0.00
9.08
2.22
-4.17
-17.83
-10.32 Check Casting weight AGAIN
-28.08 Check Casting weight AGAIN
-8.23 OK
-2.85 OK
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
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
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
0.00
0.00
0.00
0.00
Gross Difference
Product Method Gross Casting
% Yield weight @ in Gross
No Rev. No Weight Weight
85% Yield weight

970003 1 242.75 205.3 84.57 241.53 1.22


Old Weight New Weight Weight Reduce
Product No (Kg) Correction (Kg) (Kg) % Imrovments
0 #DIV/0!
Sr No Product No Improvments Status Results
1 . Riser 7" X 8" to modify that 4" X 7
1 570043
2 400 Casted Plug 1 . Boss Height Reduce Done
3 550001 1 . OD Reduce 5mm
2.5 " X 4" - 4 placed 2.5" X 4 " - 2
1.
4 6A0004 Nos May Reduce 5 Kgs
5 6A0001 1. 2.5" X 4" - 6 place 2" X 4 - 6
2. 1.5 X 3 - 12 Placed 1.5 X 3-6
6 6A0003 1. Sprue dia 35 placed 30
2. Runner reduce
3. Ingate reduce
7 6A0004 1 . 2.5 X 4 - 4 placed 2.5 X 4 - 2
2. Runner reduce
3. Ingate single
8 6A0005 1. 2.5" X 4" - 6 place 2" X 4 - 6
2. 1.5 X 3 - 16 Placed 1.5 X 3-8
Sprue Pouring (Bottom Poring) to
1
9 400 Casted Plug Runner Pouring (P/L.P)
Sprue Pouring (Bottom Poring) to
1. Runner Pouring (P/L.P)
10 450 Casted Plug
May Reduce 5 Kgs

50 - 60 % < 50% > 60% A B C = (B/A)*100 D Product No Gross Weight Casting Weight % Yield 9A0004 0 187.88 104.98 55.88 174.97
#DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0!
#DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0! 0.00 #DIV/0!
#DIV/0! 0.00
E = A-D 12.91 19.60 5.10 -20.67 4.15 126.55 one casting carry 15.97 -59.88 ok 2.43 9.00 Action Taken 14.78 Action Taken 20
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 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
% Yield 970003 1 242.75 205.3 84.57 241.53 1.22 Product No Method Rev. No Gross Weight Casting Weight Gross weight @ 85
Product No Correction % Imrovments 0 #DIV/0! Old Weight (Kg) New Weight (Kg) Weight Reduce (Kg)

You might also like