Spreadsheet: 87345d1287155708-finding-the-value-from-the-list-parts-and-insert-extra-part-in-the-list-book1
Sheet: Timing-PE-HHHD

Standard Time & Takt Time for the P19 / CDN / P90 model in HHD
Sr No | MODEL | Component | Std Processing Time ( in Seconds ) |  |  |  |  |  |  |  |  | Total | Time @ 95 % n | Takt Time | Weighted Avg | Takt Time @ 95 % n | Capacity @ 90% n
 |  |  | Alum. | Steel | Gears | HT | E/a | Press | Weld | Paint | F/a
 | P19 / CDN | KSS |  |  | 143.2087619047619 | 79.08333333333334 | 23 |  |  |  |  | 245.2920952380952 | 258.2022055137845 | 19.288 |  | 20.30315789473684 | 4132.8
 | P90 |  |  |  | 93.11257142857141 | 71.596 | 23 |  |  |  |  | 187.7085714285714 | 197.587969924812 | 19.288 |  | 20.30315789473684 | 1337.4
 | P19 / CDN | Gear C1 |  |  | 42.31982417582417 | 19.87068965517241 |  |  |  |  |  | 62.19051383099659 | 65.4636987694701 | 202.04 |  | 212.6736842105263 | 3378.309677419355
 |  | Gear C2 |  |  | 24.62105263157895 | 25.53571428571428 |  |  |  |  |  | 50.15676691729323 | 52.79659675504551
 |  | [NAME] |  |  | 31.30688384512683 | 26.29120879120879 |  |  |  |  |  | 57.59809263633562 | 60.62957119614276
 |  | Gear C4 |  |  | 18.62857142857143 | 26.29120879120879 |  |  |  |  |  | 44.91978021978022 | 47.28397917871602
 |  | Gear M2 |  |  | 31.85779310344828 | 33 |  |  |  |  |  | 64.85779310344827 | 68.2713611615245
 |  | [NAME] |  |  | 32.87257142857143 | 20 |  |  |  |  |  | 52.87257142857143 | 55.65533834586466
 |  | GPD |  |  | 82.48571428571428 | 17.02537593984962 | 20 |  |  |  |  | 119.5110902255639 | 125.8011476058567
 |  | GPDn |  |  | 133.232 |  |  |  |  |  |  | 133.232 | 140.2442105263158
 |  | GSD |  |  | Offloaded |  | 28.13
 |  | KSP |  |  | 7 | 26 |  |  |  |  |  | 33
 | P90 | GPD |  |  | 94.68571428571428 | 17.02537593984962 | 20 |  |  |  |  | 131.7110902255639 | 138.6432528690146 | 177.04 |  | 186.3578947368421 | 1200
 |  | Gear C1 |  |  | 39.31982417582417 | 19.87068965517241 |  |  |  |  |  | 59.19051383099659 | 62.30580403262799
 |  | Gear C2 |  |  | 21.62105263157895 | 25.53571428571428 |  |  |  |  |  | 47.15676691729323 | 49.6387020182034
 |  | [NAME] |  |  | 23.64859813084112 | 26.29120879120879 |  |  |  |  |  | 49.93980692204991 | 52.56821781268412
 |  | Gear C4 |  |  | 17.62857142857143 | 26.29120879120879 |  |  |  |  |  | 43.91978021978022 | 46.23134759976865
 |  | Gear M2 |  |  | 30.85779310344828 | 25.66666666666667 |  |  |  |  |  | 56.52445977011494 | 59.4994313369631
 |  | Gear M3 |  |  | 51.104 | 22.96875 |  |  |  |  |  | 74.07275 | 77.97131578947369
 |  | [NAME] |  |  | 26.92857142857143 | 15.26785714285714 |  |  |  |  |  | 42.19642857142857 | 44.41729323308271
 |  | GSR |  |  | 142.1792207792208 | 54.45054945054946 |  |  |  |  |  | 196.6297702297702 | 206.9787055050213 | 49.3 |  | 51.89473684210526
 |  | KSP |  |  | 7 | 26 |  |  |  |  |  | 33
 | P19 / CDN | Gear M3 |  |  | 63.16 | 22.96875 |  |  |  |  |  | 86.12875 | 90.66184210526316 | 21.58 |  | 22.71578947368421 | 4097.7
 | P19 / CDN /P90 | Main [NAME] |  |  | 139.1422142857143 | 71.17301038062283 | 24.44 |  |  |  |  | 234.7552246663371 | 247.1107628066707 | 23.5 |  | 24.73684210526316
 | P19 / CDN | [NAME] |  |  | 70.58792857142856 | 44.1 | 38.4 |  |  |  |  | 153.0879285714286 | 161.1451879699248 | 20.28946428571428 |  | 21.35733082706767 | 4873.5
 | P90 |  |  |  | 70.58792857142856 | 44.1 | 38.4 |  |  |  |  | 153.0879285714286 | 161.1451879699248 | 40.57892857142857 |  | 42.71466165413534
 | P90 | GCSD |  |  | 190.7 | 83.125 |  |  |  |  |  | 273.825 | 288.2368421052632 | 92.7 |  | 97.57894736842105 | 1674
 | P90 | GPDn |  |  | 216.992 |  |  |  |  |  |  | 216.992 | 228.4126315789474 | 50.832 |  | 53.50736842105263 | 1400.4
 | P19 / CDN | [NAME] R |  | 254.6742857142858 |  | 24.71542857142857 |  |  |  |  |  | 279.3897142857143 | 294.0944360902256 | 23.9 |  | 25.15789473684211 | 3441
 |  | [NAME] |  | 159.5142857142857 |  | 24.71542857142857 |  |  |  |  |  | 184.2297142857143 | 193.926015037594 | 21.6 |  | 22.73684210526316 | 3441
 |  | [NAME] |  | 121.106 |  |  | 50 |  |  |  |  | 171.106 | 180.1115789473684 | 16.5 |  | 17.36842105263158
 |  | Cyl Block |  | 279.185 |  |  |  |  |  |  |  | 279.185 | 293.8789473684211 | 23.25 |  | 24.47368421052632 | 3004
 | [NAME] / P90 | [NAME] |  | 108.408 |  | 69.16279069767442 |  |  |  |  |  | 177.5707906976744 | 186.9166217870257 | 36 |  | 37.89473684210527 | 5443
 | P90 | Cyl Block |  | 307.02 |  |  |  |  |  |  |  | 307.02 | 323.1789473684211 | 46.35 |  | 48.78947368421053 | 1430
 |  | [NAME] R |  | 254.6742857142858 |  | 24.71542857142857 |  |  |  |  |  | 279.3897142857143 | 294.0944360902256 | 47.8 |  | 50.31578947368421 | 1311
 |  | [NAME] |  | 159.5142857142857 |  | 24.71542857142857 |  |  |  |  |  | 184.2297142857143 | 193.926015037594 | 43.2 |  | 45.47368421052632 | 1311
 |  | [NAME] |  | 121.106 |  |  | 50 |  |  |  |  | 171.106 | 180.1115789473684 | 33 |  | 34.73684210526316
 | P19 | Cam shaft |  |  | 223.8534285714286 |  |  |  |  |  |  | 223.8534285714286 | 235.6351879699249 | 34.4 |  | 36.21052631578947 | 4482
 | P90 / CDN |  |  |  | 264.1640952380952 |  |  |  |  |  |  | 264.1640952380952 | 278.0674686716792
 |  | Engine assy |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.52631578947368
 | CDN (HHD Exp) | Cr shaft ( L ) |  | 158.2297142857143 |  |  |  |  |  |  |  | 158.2297142857143 | 166.5575939849624 | 32.24 |  | 33.93684210526316 | 2159
 |  | [NAME] ( R ) |  | 233.3897142857143 |  |  |  |  |  |  |  | 233.3897142857143 | 245.6733834586467 | 32.24 |  | 33.93684210526316 | 2159
 |  | Cyl Block |  | 267.185 |  |  |  |  |  |  |  | 267.185 | 281.2473684210527 | 43.35 |  | 45.63157894736842 | 2085
 |  | [NAME] |  | 106.408 |  | 69.16279069767442 |  |  |  |  |  | 175.5707906976744 | 184.811358629131 | 33 |  | 34.73684210526316 | 2037
 |  | Engine Assy |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 21.05263157894737
 | CDN | Crank case L ( Module Line ) | 533 |  |  |  |  |  |  |  |  | 533 | 561.0526315789474 | 51 | 431.2429610292747 | 53.68421052631579 | 1535
 |  | Crank case L ( Sakurai Line ) | 479 |  |  |  |  |  |  |  |  | 479 | 504.2105263157895 | 51 |  | 53.68421052631579 | 1510
 |  | Crank case L ( New al. phase) | 332 |  |  |  |  |  |  |  |  | 332 | 349.4736842105264 | 50 |  | 52.63157894736842 | 583
 |  | Crank case L ( New expansion) | 333 |  |  |  |  |  |  |  |  | 333 | 350.5263157894737 | 50 |  | 52.63157894736842 | 1735
 |  | Crank case R ( [NAME] ) | 533 |  |  |  |  |  |  |  |  | 533 | 561.0526315789474 | 51 | 408.0614915740409 | 53.68421052631579 | 1535
 |  | Crank case R ( Sakurai Line ) | 479 |  |  |  |  |  |  |  |  | 479 | 504.2105263157895 | 51 |  | 53.68421052631579 | 1510
 |  | Crank case R ( New al. phase) | 299 |  |  |  |  |  |  |  |  | 299 | 314.7368421052632 | 50 |  | 52.63157894736842 | 583
 |  | Crank case R ( New expansion) | 323 |  |  |  |  |  |  |  |  | 323 | 340 | 50 |  | 52.63157894736842 | 1735
 |  | Cylinder head  ( [NAME] ) | 576 |  |  |  |  |  |  |  |  | 576 | 606.3157894736843 | 48 | 411.4360432063672 | 50.52631578947368 | 1725
 |  | Cylinder head ( Sakurai Line ) | 527 |  |  |  |  |  |  |  |  | 527 | 554.7368421052632 | 47 |  | 49.47368421052632 | 1450
 |  | Cylinder head ( New al. phase) | 430 |  |  |  |  |  |  |  |  | 430 | 452.6315789473684 | 47 |  | 49.47368421052632 | 549
 |  | Cylinder head( New expansion) | 486 |  |  |  |  |  |  |  |  | 486 | 511.5789473684211 | 51 |  | 53.68421052631579 | 1854
 |  | Crank case cover R ( [NAME] ) | 287 |  |  |  |  |  |  | 337.5 |  | 624.5 | 657.3684210526316 | 44 | 616.9247491638796 | 46.31578947368421 | 1480
 |  | Crank case cover R ( Sakurai Line ) | 272 |  |  |  |  |  |  | 337.5 |  | 609.5 | 641.578947368421 | 43 |  | 45.26315789473684 | 1510
 |  | Crank case cover L (HHD Expansion) | 97 |  |  |  |  |  |  | 337.5 |  | 434.5 | 457.3684210526316 | 24 |  | 25.26315789473684 | 4046
 | P90 | Crank Case L ( New Al. Phase) | 353 |  |  |  |  |  |  |  |  | 353 | 371.5789473684211 | 50 |  | 52.63157894736842 | 1173.333333333333
 |  | Crank Case R ( New Al. Phase) | 336 |  |  |  |  |  |  |  |  | 336 | 353.6842105263158 | 50 |  | 52.63157894736842 | 1173.333333333333
 |  | Cylinder head ( New al. phase) | 548 |  |  |  |  |  |  |  |  | 548 | 576.8421052631579 | 47 |  | 49.47368421052632 | 1086.666666666667
 |  | Crank case cover L ( New Al. Phase) | 187 |  |  |  |  |  |  | 337.5 |  | 524.5 | 552.1052631578948 | 38 |  | 40 | 1770
 |  | Crank case cover R ( New Al. phase) | 215 |  |  |  |  |  |  | 337.5 |  | 552.5 | 581.578947368421 | 38 |  | 40 | 1686
 |  | New Al Phase Capacities @ 100% n
 | CDN | Fuel Tank Body ( R ) |  |  |  |  |  | 73.68 | 723.4782608695652 | 4026 |  | 4823.158260869565 | 5077.008695652175 | Press = 30 | 31.57894736842105 | Press = 31.58 | Press =2400
 |  | Fuel Tank Body ( L ) |  |  |  |  |  | 73.68 |  |  |  |  |  | Weld = 11 | 11.57894736842105 | Weld = 11.58 | Weld :- 7200 for CDN, Spl +, P90, NXG
 |  | Tank Bottom |  |  |  |  |  | 23.08 |  |  |  |  |  | Paint = 9.5 | 10 | Paint = 10 | Paint :- 4750 (Equivalent veh.) or CDN.pl +, P90, NXG & 2200 in Exp.
 | Spl + | Fuel Tank Body ( R ) |  |  |  |  |  | Offloaded | 733.9130434782609 | 4234 |  | 756.9930434782609 | 796.8347826086957 | Press = 11 |  | Press = 11.55 | Press opr [NAME]
 |  | Fuel Tank Body ( L ) |  |  |  |  |  |  |  |  |  |  |  | Weld = 24.5 sec (3 lines) | 8.593333333333334 | Weld = 25.78 sec (3 lines)
 |  | Tank Bottom |  |  |  |  |  | 23.08 |  |  |  |  |  | Paint =9.5 |  | Paint =9.47 | Press 2000
 | P90 | Fuel Tank |  |  |  |  |  | Offloaded | 719.1304347826087 | 4234 |  | 4953.130434782609 | 5213.821510297484 | Weld = 24.5 sec (3 lines) | 8.593333333333334 | Weld = 25.78 sec (3 lines)
 | [NAME] | Fuel Tank |  |  |  |  |  | Offloaded | 777.3913043478261 |  |  | 777.3913043478261 | 818.3066361556065 | Weld = 26 sec (1 lines) | 27.36 | Weld = 27.36 sec (1 lines)
 | Spl + | Fuel Tank Lid |  |  |  |  |  |  |  | 180 |  | 180
 | CDN | Frame Body |  |  |  |  |  |  | 304.3478260869566 | 2700 |  | 3004.347826086957 | 3162.471395881007 | Weld =43.11 (3 lines) | 15.12333333333333 | Weld =45.37 (3 lines) | Weld :- 7350 for CDN, Spl+, [NAME], NXG
 | Spl + |  |  |  |  |  |  |  | 296.5217391304348 | 2700 |  | 2996.521739130435 | 3154.233409610984 | Weld =43.71 (4 lines) | 11.5025 | Weld =46 (4 lines)
 | P90 |  |  |  |  |  |  |  | 348.6956521739131 | 2700 |  | 3048.695652173913 | 3209.153318077803 | Weld =47.31 (2 lines) | 25 | Weld =50 (2 lines) | Paint :- 4750 (Equivalent veh.) or CDN.pl +, P90, NXG & 2200 in Exp.
 | [NAME] |  |  |  |  |  |  |  | 303.4782608695652 | 2700 |  | 3003.478260869565 | 3161.556064073226 | Weld =44.31 (2 lines) | 23.32 | Weld =46.64 (2 lines)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Paint = 9.5 | 10 | Paint = 10
 | CDN ([NAME]) | Side Cover (per set) |  |  |  |  |  |  |  | 1125 | 36 | 1161 | 1222.105263157895 | 19 |  | 21
 | CDN (Dlx) |  |  |  |  |  |  |  |  | 1125 | 36 | 1161 | 1222.105263157895 | 19 |  | 21
 | Spl + |  |  |  |  |  |  |  |  | 1125 | 36 | 1161 | 1222.105263157895 | 19 |  | 21
 | P90 |  |  |  |  |  |  |  |  | 1125 | 36 | 1161 | 1222.105263157895 | 19 |  | 21
 | [NAME] |  |  |  |  |  |  |  |  | 1125 | 36 | 1161 | 1222.105263157895 | 19 |  | 21
 | CDN (Dlx) | Visor |  |  |  |  |  |  |  | 1125 | 18 | 1143 | 1203.157894736842 | 19 |  | 21
 | Spl + |  |  |  |  |  |  |  |  | 1125 | 18 | 1143 | 1203.157894736842 | 19 |  | 21
 | P90 |  |  |  |  |  |  |  |  | 1125 | 198 | 1323 | 1392.631578947369 | 19 |  | 21
 | [NAME] |  |  |  |  |  |  |  |  | 1125 |  | 1125 | 1184.21052631579 | 19 |  | 21
 | CDN (Dlx) | Front Fendor |  |  |  |  |  |  |  | 1125 |  | 1125
 | Spl + |  |  |  |  |  |  |  |  | 1125 |  | 1125
 | P90 |  |  |  |  |  |  |  |  | 1125 |  | 1125
 | [NAME] |  |  |  |  |  |  |  |  | 1125 |  | 1125
 | CDN (Dlx) | Rear Cowl (per Set) |  |  |  |  |  |  |  | 1125 | 72 | 1197 | 1260 | 19 |  | 21
 | Spl + |  |  |  |  |  |  |  |  | 1125 | 72 | 1197 | 1260 | 19 |  | 21
 | P90 |  |  |  |  |  |  |  |  | 1125 | 72 | 1197 | 1260 | 19 |  | 21
 | [NAME] |  |  |  |  |  |  |  |  | 1125 | 72 | 1197 | 1260 | 19 |  | 21
 | CDN (Dlx) / Spl +/ P90 / Spl NXG | Centre Cowl |  |  |  |  |  |  |  | 214.2857142857143 |  | 214.2857142857143
 |  | Total [NAME]