Spreadsheet: 833975d1687371803-why-isnt-vlookup-working-here-fix-this-for-real
Sheet: Routing

Level | Part Number | P/N Description | Gate | Opr | Wrk | Description | Setup | Run | Subcontracting | STD Hours from Baan | [NAME] (HRS) | STD Budget ($$$) | Std hours w Efficiency Factor | AVG Actual ($$$) |  | Subcontractors (Value STD and Ave hrs at zero) | Inspection | Rework | Work Center Rate | Work Center Location | WC ([NAME])
1 | 200-5580-103 LP | Axle Beam, MLG | 1 | 1300 | 601 | REC. INSPECTION |  | 0 | 0
1 | 200-5580-103 LP | Axle Beam, MLG | 3 | 7000 | 8 | Buffer Management 30 Day Que |  | 0 | 0
1 | 200-5580-103 LP | Axle Beam, MLG | 10 | 1300 | 606 | REC. INSPECTION SERIAL NUMBERS |  | 0 | 0
1 | 200-5580-103 LP | Axle Beam, MLG | 50 | 1200 | 138 | 138 NIIGATA 800 |  | 410 | 820
1 | 200-5580-103 LP | Axle Beam, MLG | 70 | 1200 | 138 | 138 NIIGATA 800 |  | 670 | 1340
1 | 200-5580-103 LP | Axle Beam, MLG | 80 | 1200 | 285 | 285 MEGA95#2(CNC LATHE)(37.4in |  | 90 | 180
1 | 200-5580-103 LP | Axle Beam, MLG | 90 | 1200 | 285 | 285 MEGA95#2(CNC LATHE)(37.4in |  | 180 | 360
1 | 200-5580-103 LP | Axle Beam, MLG | 100 | 1200 | 599 | 599 BURR & BARBER |  | 450 | 900
1 | 200-5580-103 LP | Axle Beam, MLG | 110 | 1200 | 255 | 255 SPRINGFIELD (MANUAL) |  | 120 | 240
1 | 200-5580-103 LP | Axle Beam, MLG | 120 | 1200 | 560 | 560 BENCH |  | 35 | 70
1 | 200-5580-103 LP | Axle Beam, MLG | 130 | 1200 | 607 | 607 INSP. BEFORE HEAT TREAT |  | 0 | 0
1 | 200-5580-103 LP | Axle Beam, MLG | 140 | 6010 | SH0 | HERCULES HEAT TREATING |  | 2400 | 1043.77
1 | 200-5580-103 LP | Axle Beam, MLG | 150 | 1200 | 604 | 604 INSP. FROM OUTSIDE |  | 0 | 0
1 | 200-5580-103 LP | Axle Beam, MLG | 160 | 1200 | 116 | 116 TOYODA #2 (HOR MILL) |  | 780 | 1560
1 | 200-5580-103 LP | Axle Beam, MLG | 170 | 1200 | 215 | 215 VDF (CNC GAP) (92 in) |  | 300 | 600
1 | 200-5580-103 LP | Axle Beam, MLG | 180 | 1200 | 138 | 138 NIIGATA 800 |  | 300 | 600
1 | 200-5580-103 LP | Axle Beam, MLG | 190 | 1200 | 599 | 599 BURR & BARBER |  | 270 | 540
1 | 200-5580-103 LP | Axle Beam, MLG | 210 | 1200 | 579 | 579 HONE TABLE |  | 102.5 | 205
1 | 200-5580-103 LP | Axle Beam, MLG | 220 | 1200 | 579 | 579 HONE TABLE |  | 187.5 | 375
1 | 200-5580-103 LP | Axle Beam, MLG | 225 | 1200 | 160 | 160 CIMX 3 (HOR. HONE) |  | 67.5 | 135
1 | 200-5580-103 LP | Axle Beam, MLG | 230 | 1200 | 608 | 608 INSP. BEFORE NDT |  | 0 | 0
1 | 200-5580-103 LP | Axle Beam, MLG | 990 | 9990 | 990 | Springfield Machine Rework |  | 0 | 0
1 | 200-5580-103 LP | Axle Beam, MLG | 991 | 9991 | 991 | Spring. Outside Machine Rework |  | 0 | 0
1 | 200-5580-103 LP | Axle Beam, MLG | 992 | 9992 | 992 | Springfield Caused Burr Rework |  | 0 | 0
1 | 200-5580-103 LP | Axle Beam, MLG | 993 | 9993 | 993 | Spring. Outside Burr Rework |  | 0 | 0
 | Site | Setup Hours (Total) | Run-Time (Per Pcs) | STD HRS (Per Pc) | STD Cost (Per Pc) | Avg Actual Hrs |  | FY23 BDGT Hours | FY23 BDGT $$$ | Set-up QTY
 | Springfield |  |  |  |  |  |  | 75.32258305731243 |  | 4
 | Cleveland (PRO- Grind/Polish)
 | Cleveland (PRO- [NAME])
 | Cleveland (PRO- CAD)
 | Cleveland (PRO- [NAME])
 | Cleveland (PRO- Nickel)
 | Cleveland (BHS)
 | Cleveland (PAINT)
 | Cleveland (ASSY)
 | TOTAL
 | Check
 | Subcontract operations = STD Hours and AVG Hours are both zero
 | Inspections operations = STD Hours and AVG Hours are both zero
 | Inspections operations = STD Hours and AVG Hours are both zero
 | REWORK operations = STD Hours and AVG Hours are both zero
 | REWORK operations = STD Hours and AVG Hours are both zero
 | REWORK operations = STD Hours and AVG Hours are both zero
 | Cleveland Finishing Operations start