Need help with excel pareto file

profileglen_x
trmf_gmc.xlsx
Home>Business & Finance homework help>Accounting homework help>Need help with excel pareto file

Pareto

Part Number Description Vendor Number Vendor Name Returnable Cost Annual Expendable Cost Shipping Location Expedited Frieght Cost Total Cost Ergonomics Risk Quality Ricks Is Funding Available Requisition Approval Return on Investment Implementation Date (If applicable)
AAM: AAM: 		Internal packaging per part (if applicable) Completion Cost Save to date
45054774 Axle Shaft (Mach) PTI A&M $10,000 Detroit 0 0 Yes Med Yes No
25904962 Park Break TRW 610 58,589 0 Laredo, TX $54,741 54,741.00 Yes Med Yes Yes 1.1 10-Jun Req # 520085 54,741
40153073 Axle Tube USM GMT610 $9,000 0 ' Warren MI 0 $ Low Low Yes No
40125792 Pump / Motor Assembly SLW 27,218 77,486 Sallisaw, OK 74955 0 77,486 Low Med Yes Yes 17-Jun Req # 5192558 / 5192559 77,486
40055350 40088785 Pinion Flange 'DMI GMT610 59,801 0 'Iztapalapa, MX 0 0 Low Low Yes No No Change for DMI, No expendable cost.
40015757 Excitor Ring SSI GMT 610 $58,632 0 Janesville, WI 0 0 Low Low No No
40137329 RDM Cover Gibbs 16,865 56,606 Henderson, KY 42420 0 56606 Med Low Yes No
40082168 26060884 '26060884 40065702 26064017 Flange Asm, Deflector Deflector Flange & Sleeve JD Norman 104,262 122,286 San Luis Potosi, SLP 78395 Mexico 0 122,286 High High Yes No Req 5227508 pending approval Appropriation Request 425 pending approval
40065702 26064017 610 10.5 DW Rotor Assembly Rassini 33,744 0 Mexico 0 0 High High No No Safety issue
40128387 40128384 Differential Case (CAST) Waupaca Quote pending 54,321 0 54321 Low Low No No
496030 Pinion Gear VCST Quote pending 83,822 Mexico 0 83,822 Low Low No No
496030 SUN GEAR 496033 VCST Quote pending 0 Mexico 0 0 Low Low No No
15234971/72 Caliper Assembly RH/LH Akebono GMT610 Quote pending 0 'Glasgow, KY 0 0 Low Low No No
5436813 COVER-CLUTCH, INNER, X2 86147 Roseau Injection Molding US Roseau, MN 1.4 N 9800189 N/A P634800LD NA 20 12 box
86147
5438307 Cover-Clutch, Inner RZR S-4 86147 Roseau Injection Molding US Roseau, MN 1.6 N 9800189 N/A P634800LD NA 15 12 box
86147
86147
86147
5435028-070 CV Shield Front LH Spirit 86147 Roseau Injection Molding US Roseau, MN 0.366 N 9800275 N/A P634800LD 9800227 4/box 55 18 box
5435029-070 CV Shield Front RH Spirit 86147 Roseau Injection Molding US Roseau, MN 0.366 N 9800275 N/A P634800LD 9800227 4/box 55 18 box
86147
86147
86147
5437473-070 Rear Fender LH TPO 86147 Roseau Injection Molding US Roseau, MN 1.56 N 9800192 N/A P634800LD 9820039 1/part 2255326 4/box 20 6 2255326 Kleenguard - estimated quantity box
5437475-070 Rear Fender RH TPO 86147 Roseau Injection Molding US Roseau, MN 1.56 N 9800192 N/A P634800LD 9820039 1/part 2255326 4/box 20 6 2255326 Kleenguard - estimated quantity box
5437544-070 SHIELD-CV,FRONT,LH,BLK, Ranger 86147 Roseau Injection Molding US Roseau, MN 0.22 N 9800275 N/A P634800LD 9800227 4/box 75 18 box
5437545-070 SHIELD-CV,FRONT,RH,BLK, Ranger 86147 Roseau Injection Molding US Roseau, MN 0.22 N 9800275 N/A P634800LD 9800227 4/box 75 18 box
5437568-070 T-Rex Wheel Trim LH 86147 Roseau Injection Molding US Roseau, MN 0.272 N 9800189 N/A P634800LD 9800227 2/box 9800208 2/part 45 12 box
5437569-070 T-Rex Wheel Trim RH 86147 Roseau Injection Molding US Roseau, MN 0.272 N 9800189 N/A P634800LD 9800227 2/box 9800208 2/part 45 12
86147
86147
86147
5437644-070 PANEL-DASH,CONTROLS,SPEEDO,BLK Ranger 86147 Roseau Injection Molding US Roseau, MN 5.7 N 9800190 N/A P634800LD 9800210 3/box 48 8 box
86147
86147
86147
86147
86147
5437780-070 Mercury Cup Holder RH 86147 Roseau Injection Molding US Roseau, MN 0.385 N 9800190 N/A P634800LD 9800210 3/box 64 8 box
86147
86147
5437797-070 Mercury Fender Frt LH 86147 Roseau Injection Molding US Roseau, MN 1.05 N 9800286 N/A P634800LD 9800186 2/box 9800397 1/box 32 6 box
5437798-070 Mercury Fender Frt RH 86147 Roseau Injection Molding US Roseau, MN 1.05 N 9800286 N/A P634800LD 9800186 2/box 9800397 1/box 32 6 box
86147
86147
86147
86147
86147
86147
86147
86147
86147
5437963-070 Mercury Cup Holder LH 86147 Roseau Injection Molding US Roseau, MN 0.385 N 9800190 N/A P634800LD 9800210 3/box 64 8 box
5438046-070 Mercury Glove Box Door 86147 Roseau Injection Molding US Roseau, MN 0.624 N 9800190 N/A P634800LD 9800210 1/box 56 8 box
86147
86147
86147
5438181-070 Brkt-Bumper, Guard, Blk 86147 Roseau Injection Molding US Roseau, MN 0.399 N 9800189 N/A P634800LD 9800227 2/box 50 12 box
5438206-070 RZR Cover Winch Pocket 86147 Roseau Injection Molding US Roseau, MN 0.23 N 9800189 N/A P634800LD 9800227 2/box 94 12 box
5438207-070 RZR Fender Flair Front LH 86147 Roseau Injection Molding US Roseau, MN 0.272 N 9800190 N/A P634800LD 9800210 1/box 72 8 box
5438208-070 RZR Fender Flair Front RH 86147 Roseau Injection Molding US Roseau, MN 0.27 N 9800190 N/A P634800LD 9800210 1/box 72 8 box
5438210-070 RZR Fender Flair Rear RH 86147 Roseau Injection Molding US Roseau, MN 0.25 N 9800275 N/A P634800LD 9800227 2/box 45 18 box
5438211-070 RZR Fender Flair Rear LH 86147 Roseau Injection Molding US Roseau, MN 0.25 N 9800275 N/A P634800LD 9800227 2/box 45 18 box
86147
5438240-070 Screen, bumper, upper 86147 Roseau Injection Molding US Roseau, MN 0.104 N 9800199 N/A P634800LD NA 150 20 box
5438241-070 Screen, facia 86147 Roseau Injection Molding US Roseau, MN 0.157 N 9800199 N/A P634800LD NA 150 20 box
86147
86147
86147
86147
86147
86147
5438569-070 Front Grill - RZR 86147 Roseau Injection Molding US Roseau, MN 0.344 N 9800189 N/A P634800LD NA 50 12 box
86147
86147
86147
86147
86147
5438585-070 PANEL-DASH,CONTROLS,SPEEDO,BLK Ranger 86147 Roseau Injection Molding US Roseau, MN 0.57 N 9800190 N/A P634800LD 9800210 3/box 48 8 box
86147
86147
5438693-070 Floor, foot, LH 86147 Roseau Injection Molding US Roseau, MN 0.352 N 9800189 N/A P634800LD 9800397 3/box 72 12 box
5438694-070 Floor, foot, RH 86147 Roseau Injection Molding US Roseau, MN 0.352 N 9800189 N/A P634800LD 9800397 3/box 72 12 box
86147
86147
86147
86147
86147
86147
86147
86147
86147
86147
86147 fender
5438813-070 Dash Panel, 900D Crew, Mil Roseau Injection Molding US Roseau, MN 0.57 N 9800190 N/A P634800LD 9800210 3/box 48 8 box
86147
86147
86147
86147
86147
86147
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Roseau
Exhaust
Exhaust
Exhaust
Painted Plastic
Painted Plastic
Painted Plastic
Painted Plastic
Painted Plastic
Painted Plastic
Painted Plastic
Roseau Tube Fab
Roseau Tube Fab
Roseau Tube Fab

GMC