MRP计算表格.xlsx

2848028484292783226133234355413601036210364973670936712386443954333704337063841338414384153841626993273332733628481284852927932262332353504735048 P/NCell 1Cell 1Cell 1Cell 1Cell 1Cell 1Cell 1Cell 1Cell 1Cell 1Cell 1Cell 1Cell 1RSNRSNRSNRSNRSNRSNCell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2 part numberokokokokokokokokokokokokokokokokokokokokokokokokokokokokok DescriptionPN单位statussupplier LOCKNUT, NEEDLE LIFT SCREW24186pcsBYishan11111111111111111111111111111 LIFT ADJUST SCREW ASSEMBLY41421pcsBPPM11111111111110000001111111111 LIFT ADJUST SCREW ASSEMBLY41423pcsBPPM00000000000000000000000000000 LOCKNUT, ADJUSTING SCREW24185pcsBPPM11111111111110000001111111111 SCREW,VALVE LIFT ADJ39600pcsBPPM11111111111110000001111111111 SCREW,VALVE LIFT ADJ39794pcsBPPM00000000000000000000000000000 SCREW,ADJUSTING23705pcsBPPM11111111111110000001111111111 LIFT ADJUST SCREW ASSEMBLY41424pcsBPPM00000000000001111110000000000 LIFT ADJUST SCREW ASSEMBLY41422pcsBPPM00000000000000000000000000000 LOCKNUT, ADJUSTING SCREW30683pcsBPPM00000000000001111110000000000 SCREW,VALVE LIFT ADJ39795pcsBPPM00000000000001111110000000000 SCREW,VALVE LIFT ADJ39796pcsBPPM00000000000000000000000000000 SCREW,ADJUSTING28921pcsBPPM00000000000001111110000000000 Jan/0018964pcsBHarman11111111111110011111111111111 CAP,SHIPPING(INLET)26891pcsBHarman00000000000001100000000000000 SPRING,PRESSURE ADJ28071pcsBC.T.Spring11111111111110000001111111111 350493505035101351023554236011362113671036713386453923039231395443962120493204942049520518222052236522674226752294526684271272783628259284122857128743290063050633708337102274622759227622251422805 Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 2Cell 3Cell 3Cell3Cell3Cell3Cell3Cell3Cell3Cell3Cell3Cell3Cell3Cell3Cell3Cell3Cell 3Cell 3Cell 3Cell 3Cell 3 okokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokok 111111111111111111111111111111111111111 111111111111110000001100000000000000000 000000000000001111110011111111110011111 111111111111110000101100000000000000000 111111111111110000001100000000000000000 000000000000000000000000000000000000000 111111111111110000001100000000000000000 000000000000000000100011101101111110000 000000000000000000000000000000000000000 000000000000000000110011111111111111111 000000000000000000110011111111111111111 000000000000000000000000000000000000000 000000000000000000110011111111111111111 111111111111111111111111111100110000000 000000000000000000000000000011001100000 111111111111110000001100000000000000000 228082281522816228172795727958279592314123142231432338523544235462453024531245322725227253272542830128302283033137031371313723236032361323622663226964286822893529487334053340633407334083340926992 Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3 okokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokokok 101111111111111111111111111111111111111 000000000000000000000000000011000110001 101111111111111111111111111100011000010 000000000000000000000000000011000110001 000000000000000000000000000011000110001 000000000000000000000000000000000000000 000000000000000000000000000011000110001 001100001000001000001010011100011001110 000000000000000000000000000000100000000 101111111111111111111111111100111001110 101111111111111111111111111100011001110 000000000000000000000000000000100000000 101111111111111111111111111100111001110 000000000000000000000000000000000000001 000000000000000000000000000011111111110 000000000000000000000000000011000110001 2049620497204982049920502206682066920670206712067220673206744114641147 Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3Cell 3 okokokokokokokokokokokokokok 11111111111111 00000000000011 11111111111100 00000000000011 00000000000011 00000000000000 00000000000011 01001000000100 00000000000000 11111111111100 11111111111100 00000000000000 11111111111100 11111111111111 00000000000000 00000000000011 WK41WK42WK43WK44WK45WK46WK47WK48 PN10/510/1210/1910/2611/211/911/1611/23 2848000400032016080400 28484016024008032000 292780320017604803200200029602400 322610320320800160160801200 3323400000000 35541088006900500370 3601001201936340284862 362100000000160 3649700024040000880 3670900000000 3671200000000 3864400000000 39543000000080 3370401000000 33706011500001600 3841300000000 3841400000000 3841500404000400 3841602357308128012812084280687 26993080200280000 27333011301601200120960440 273360000240000 28481001600016000 2848508682400720000 29279023181577178092720206600 32262028025001200120240 3323500000000 35047042020286534492274358 350480608000000 3504900000000 3505000000000 3510100000000 3510201604080000 355420800080000 360110080000080 3621100000000 36710000000600 367130117000000 3864500000000 3923000000000 3923100000000 3954400000000 3962100000000 2049300000000 2049400520240003600 2049500000000 20518000000080 2220500000000 22365080000000 2267400000000 2267500000000 2294500000000 2668400000000 2712700000000 2783608000000 2825900000000 2841200000000 2857100000000 2874300000000 29006000080000 30506000080000 33708002000000 337100500300016000 2274600000000 2275900000000 2276200000000 2251400000000 2280501460650000 22808000080000 2281500000000 2281600000000 2281700000000 2795700000000 27958000000029 2795900000000 2314100000000 2314200000000 2314300000000 2338500000000 2354400000000 23546000080000 2453000000000 2453100000000 2453200000000 2725200000000 272530920000042 27254008000080 2830100000000 2830200000000 283030190800000 3137000000000 3137105404210000 31372012000000 3236000000000 3236100000000 3236200000000 2663200000000 26964053012400040000 2868200000000 2893500000000 2948700000000 33405010800000 3340600000000 3340700000000 334080100050320003200 3340900000000 2699200000000 2049600000000 20497000000800 20498000000080 204990800000800 2050200000000 2066800000000 2066900000000 20670008000000 20671001600016000 20672079000000 2067300000000 2067400000000 4114600000000 4114700000000 0152671091557858782831465627668 WK49WK50WK51WK52WK53WK2WK3WK4WK5 11/3012/712/1412/2112/281/41/111/181/25 801602400240160240160320 8003200080240080 25602640192096036803360208020804880 16072016064064024072080800 0000000080 0500480100005050 5753454148444132145 000000000 00064000000 000000000 0000000413 000000000 000000000 0000000080 0001600000160 000000000 0000000080 8004040404040040 7632802001779714270928017604 03600120001601200 00120104002402400960 0240000016000 0024000016000 084001200120010600 170015606601200660017002580720 12000120160120120180240 000000000 290252494124380448270236746 0014000014000 000000000 000000000 80000080000 080000016000 000060080060 00060000080 000000000 000000000 00608000000 000000000 000000000 000000000 000000000 000000000 8000000000 440001202400360120320 801200000000 0120008000080 0000080000 0000080000 000000000 000000000 000000000 000000000 000000000 08000008000 000000000 0080000000 000000000 000000000 000000000 000000000 8000000000 00160000000 000000000 000000000 00080000080 000000000 64000004400 0800000000 000000000 000000000 000000000 000000000 00004700036 0000000080 000000000 0310000000 0000000080 000000000 5500012100059 080000016000 000000000 000000000 000000000 000000000 003800410610 0000800000 000000000 000000000 0000000080 000000000 560000101000 000000000 000000000 000000000 000000000 000000000 32000400003200400 000000000 000000000 000000000 000000000 000000000 000000000 04000000000 000000000 000000000 000000000 000000000 0000000080 0000000800 000000000 0000080000 0800000000 000000000 0016000016000 80000000080 0000080000 000000000 000000000 000000000 7225822668787204729081037955860310913 WK6WK7WK8WK9 2/12/82/152/22 160000 240000 1920020800 56004000 0000 80000 28001730 0000 0000 0000 60470 0000 0000 0000 0000 0000 0000 00800 1820000 540000 0000 240000 0000 0000 0000 0000 0000 17805100 001800 0000 0000 0000 140000 80000 0000 0000 0000 00600 0000 80000 0000 0000 0000 80000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 00800 0000 0000 0000 0000 0000 0000 80000 0000 0000 0000 0000 0000 0000 80000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 80000 0000 0000 0000 0000 97000 0000 0000 0000 0000 0000 67000 80000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 6888036100 DescriptionPNMOQLead timesupplierstateOpen PO OHPNW LOCKNUT, NEEDLE LIFT SCREW241864 weeks谊山 Demand45000108135587 24186谊山 In-transit45000108135587 24186谊山 Balance45000108135587 LIFT ADJUST SCREW ASSEMBLY414214142115004 weeksKersen Demand3356076001818 4142141421Kersen In-transit3356076001818 4142141421Kersen Balance3356076001818 LIFT ADJUST SCREW ASSEMBLY414234142315004 weeksKersen Demand300018424580 4142341423Kersen In-transit300018424580 4142341423Kersen Balance300018424580 LIFT ADJUST SCREW ASSEMBLY41424414248004 weeksKersen Demand854455610 4142441424Kersen In-transit854455610 4142441424Kersen Balance854455610 LIFT ADJUST SCREW ASSEMBLY41422414228004 weeksKersen Demand7880 4142241422Kersen In-transit7880 4142241422Kersen Balance7880 CAP,SHIPPING(INLET6 weeks Harman Demand60000720902332 18964Harman In-transit60000720902332 18964Harman Balance60000720902332 CAP,SHIPPING(INLET)2689104-6 weeks Harman Demand348290 26891Harman In-transit348290 26891Harman Balance348290 SPRING,PRESSURE ADJ2807104-6 weeks C.T.SpringDemand 60000289552117 28071C.T.SpringIn-transit 60000289552117 28071C.T.SpringBalance 60000289552117 SPRING,PRESSURE ADJ28910600004-6 weeks C.T.SpringDemand 196830 28910$0.2980C.T.SpringIn-transit 196830 28910 可分批20000购买 C.T.SpringBalance 196830 SPRING,PRESSURE ADJ2168404-6 weeks C.T.SpringDemand 49070 21684C.T.SpringIn-transit 49070 21684C.T.SpringBalance 49070 SPRING,PRESSURE ADJ2856404-6 weeks C.T.SpringDemand 2000013191448 28564C.T.SpringIn-transit 2000013191448 28564C.T.SpringBalance 2000013191448 SPRING,PRESSURE ADJ2867404-6 weeks C.T.SpringDemand 8380 28674C.T.SpringIn-transit 8380 28674C.T.SpringBalance 8380 SEAT,SPRING2875304 weeks谊山 Demand35000167132690 28753谊山 In-transit35000167132690 28753谊山 Balance35000167132690 SEAT,SPRING3300204 weeks谊山 Demand2100031740 33002谊山 In-transit2100031740 33002谊山 Balance2100031740 WASHER,PLAIN 2062804 weeksFutec Demand100007535124 20628Futec In-transit100007535124 20628Futec Balance100007535124 WASHER,PLAIN 2699004 weeksFutec Demand40000306001769 26990Futec In-transit40000306001769 26990Futec Balance40000306001769 WASHER,PLAIN 32778100008 weekstailent Demand033730 32778tailent In-transit033730 32778tailent Balance033730 WASHER,PLAIN(black)16168016 weeksClassic AdvDemand 100001510461 16168Classic AdvIn-transit 100001510461 16168Classic AdvBalance 100001510461 WASHER,PLAIN 20624016 weeksClassic AdvDemand 46582931 20624Classic AdvIn-transit 46582931 20624Classic AdvBalance 46582931 WASHER,PLAIN 2711908 weeks期初库存 Demand27003 27119期初库存 In-transit27003 27119期初库存 Balance27003 WASHER,PLAIN 32087100008 weekstailent Demand8830 32087tailent In-transit8830 32087tailent Balance8830 WASHER,PLAIN 29110100008 weekstailent Demand08900352 29110tailent In-transit08900352 29110tailent Balance08900352 WASHER,PLAIN 28672100008 weekstailent Demand44580 28672tailent In-transit44580 28672tailent Balance44580 WASHER,PLAIN 29483100008 weekstailent Demand6500 29483tailent In-transit6500 29483tailent Balance6500 SEAL,WASHER/DUST2841105 weeksParker Svc Center Demand9800 28411Parker Svc Center In-transit9800 28411Parker Svc Center Balance9800 SEAL,DUST/WATER3067005 weeksParker Svc Center Demand3810154 30670Parker Svc Center In-transit3810154 30670Parker Svc Center Balance3810154 SEAL,COMBUSTION16389200008 weekstailent Demand10000043000 16389tailent In-transit10000043000 16389tailent Balance10000043000 SEAL,COMBUSTION32779100008 weekstailent Demand148720 32779tailent In-transit148720 32779tailent Balance148720 SEAL,COMBUSTIOweekstailent Demand1403014999110 18839tailent In-transit1403014999110 18839tailent Balance1403014999110 SEAL,COMBUSTION26624100008 weekstailent Demand198110 26624tailent In-transit198110 26624tailent Balance198110 SEAL,DUST/WATER2695904-6 weeks J Royal Demand39160 26959J Royal In-transit39160 26959J Royal Balance39160 SEAL,COMBUSTION32088100008 weekstailent Demand12470 32088tailent In-transit12470 32088tailent Balance12470 SEAL,COMBUSTION28925100008 weekstailent Demand05000103 28925tailent In-transit05000103 28925tailent Balance05000103 SEAL,COMBUSTION28677100008 weekstailent Demand56000 28677tailent In-transit56000 28677tailent Balance56000 SEAL,COMBUSTION29484100008 weekstailent Demand29000 29484tailent In-transit29000 29484tailent Balance29000 SEAL,COMBUSTION30671100008 weekstailent Demand10007100 30671tailent In-transit10007100 30671tailent Balance10007100 CAP,SHIPPING(BODY)16560500004-6 weeks Harman Demand100000412143080 16560Harman In-transit100000412143080 16560Harman Balance100000412143080 CAP,SHIPPING(BODY)2688804-6 weeks Harman Demand395352438 26888Harman In-transit395352438 26888Harman Balance395352438 PLATE,INJECTOR LOCATION2847804 weeksKersen Demand2540079841985 28478Kersen In-transit2540079841985 28478Kersen Balance2540079841985 PLATE,INJECTOR LOCATION3277704 weeksKersen Demand11850 32777Kersen In-transit11850 32777Kersen Balance11850 PLATE,INJECTOR LOCATION3468804 weeksKersen Demand70005171500 34688Kersen In-transit70005171500 34688Kersen Balance70005171500 PLATE,INJECTOR LOCATION2418804 weeksKersen Demand02400192 24188Kersen In-transit02400192 24188Kersen Balance02400192 PLATE,INJECTOR LOCATION2947308 weeksKersen Demand52080 29473Kersen In-transit52080 29473Kersen Balance52080 PLATE,INJECTOR LOCATION2854708 weeksOkay Demand364279 28547Okay In-transit364279 28547Okay Balance364279 PLATE,INJECTOR LOCATION1805308 weeksOkay Demand3004410 18053Okay In-transit3004410 18053Okay Balance3004410 PLATE,INJECTOR LOCATION2251308 weeksOkay Demand300186571 22513Okay In-transit300186571 22513Okay Balance300186571 PLATE,INJECTOR LOCATION2661804 weeksKersen Demand22290 26618Kersen In-transit22290 26618Kersen Balance22290 PLATE,INJECTOR LOCATION3208608 weeksOkay Demand12700 32086Okay In-transit12700 32086Okay Balance12700 CONNECTOR,BACK-LEAKAGE285630期初库存 Demand15500 28563期初库存 In-transit15500 28563期初库存 Balance15500 PLATE,INJECTOR LOCATION3282104 weeksKersen Demand16002020557 32821Kersen In-transit16002020557 32821Kersen Balance16002020557 PLATE,INJECTOR LOCATION2867108 weeksOkay Demand6550 28671Okay In-transit6550 28671Okay Balance6550 PLATE,INJECTOR LOCATION2948808 weeksOkay Demand3170 29488Okay In-transit3170 29488Okay Balance3170 PLATE,INJECTOR LOCATION3119808 weeksOkay Demand3588154 31198Okay In-transit3588154 31198Okay Balance3588154 FILTER,EDGE2267604 weeksKersen Demand3115798652735 22676Kersen In-transit3115798652735 22676Kersen Balance3115798652735 FILTER,EDGE2712104 weeksKersen Demand50001326284 27121Kersen In-transit50001326284 27121Kersen Balance50001326284 CONNECTOR,BACK-LEAKAGE3375704 weeksClassic AdvDemand 6980120 33757Classic AdvIn-transit 6980120 33757Classic AdvBalance 6980120 CONNECTOR,BACK-LEAKAGE245450Dec/99JAX Demand42300 24545JAX In-transit42300 24545JAX Balance42300 CONNECTOR,INJECTOR LEAK-OFF310590Dec/99Interlube Systems Demand00 31059Interlube Systems In-transit00 31059Interlube Systems Balance00 SEAL,BACK-LEAKAGE CONNECTOR2892304-6 weeks J Royal Demand20000200000 28923J Royal In-transit20000200000 28923J Royal Balance20000200000 SEAL, O RING1296604 weeksJAX Demand20176168 12966JAX In-transit20176168 12966JAX Balance20176168 SHIM,PRESSURE ADJ2074204 weeksKersen Demand18000156011532 20742Kersen In-transit18000156011532 20742Kersen Balance18000156011532 SPACER,HOLDER BODY2847704 weeks谊山 Demand60001927237 28477谊山 In-transit60001927237 28477谊山 Balance60001927237 SPACER,HOLDER BODY2847604 weeks谊山 Demand2000080602078 28476谊山 In-transit2000080602078 28476谊山 Balance2000080602078 SPACER,NOZZLE BODY3119904 weeksKersen Demand1334154 31199Kersen In-transit1334154 31199Kersen Balance1334154 CLAMP,INJECTOR 3265104 weeksKersen Demand300190188220 32651Kersen In-transit300190188220 32651Kersen Balance300190188220 CLAMP,TUBING 1616900HagemeyerDemand 00 16169HagemeyerIn-transit 00 16169HagemeyerBalance 00 BOOT,INJECTOR LEAK-OFF1616500Davidon Demand00 16165Davidon In-transit00 16165Davidon Balance00 BOOT,INJECTOR LEAK-OFF1639000Davidon Demand00 16390Davidon In-transit00 16390Davidon Balance00 CAP,INJECTOR LEAK-OFF3128607weeksSino Demand3500018472612 31286Sino In-transit3500018472612 31286Sino Balance3500018472612 CAP,INJECTOR LEAK-OFF3841107weeksSino Demand100006200617 38411Sino In-transit100006200617 38411Sino Balance100006200617 CAP,INJECTOR LEAK-OFF1771907weeksSino Demand26180 17719Sino In-transit26180 17719Sino Balance26180 CAP,INJECTOR LEAK-OFF26839016 weeksClassic AdvDemand 1226154 26839Classic AdvIn-transit 1226154 26839Classic AdvBalance 1226154 CAP, NOZZLE2039804 weeks谊山 Demand1882179 20398谊山 In-transit1882179 20398谊山 Balance1882179 CAP,SHIPPING(CONN)2414104-6 weeks Harman Demand3460332 24141Harman In-transit3460332 24141Harman Balance3460332 CLAMP ASSEMBLY,INJECTOR229990Dec/99Astron Demand0 22999Astron In-transit0 22999Astron Balance0 CLAMP ASSEMBLY,INJECTOR171990Dec/99phase out Demand0 17199phase out In-transit0 17199phase out Balance0 CLAMP ASSEMBLY,INJECTOR268370Dec/99Camcar Demand0 26837Camcar In-transit0 26837Camcar Balance0 CLAMP ASSEMBLY,INJECTOR241981000 PCS from JAXDec/99Astron Demand2000 24198Astron In-transit2000 24198Astron Balance2000 CLAMP ASSEMBLY,INJECTOR285800Dec/99Astron Demand21220 28580Astron In-transit21220 28580Astron Balance21220 CLAMP ASSEMBLY,INJECTOR288960Dec/99Camcar Demand0 28896Camcar In-transit0 28896Camcar Balance0 SPACER,INJECTOR CLAMP2711204 weeks谊山 Demand8000 27112谊山 In-transit8000 27112谊山 Balance8000 SPACER,INJECTOR CLAMP1719504 weeks谊山 Demand00 17195谊山 In-transit00 17195谊山 Balance00 SPACER,INJECTOR CLAMP2870204 weeks谊山 Demand00 287