What are the last two sections of the MRP for 20-AXLE and 20-WHEEL?
Bill of Materials:
Finished products and components:
Inventory Items:
Bills of Materials Figure 1 Figure 2 20-CAR-RED 20-CAR-BLUE 20-WHL-ASSEM 2 required 20-BODY-RED 1 required 20-WHL-ASSEM 2 required 20-BODY-BLUE 1 required 20-AXLE 1 required 20-WHEEL 2 required 20-AXLE 1 required 20-WHEEL 2 required Finished Product and Components Table 1 Component Item Description Characteristic Producer/Supplier 20-CAR-RED Red-and-yellow race car Finished product Boston Manufacturing (M2) 20-CAR-BLUE Blue retro car Finished product Boston Manufacturing (M2) 20-BODY-RED Body of the red-and-yellow car Purchased par Seattle Manufacturing (M1) 20-BODY-BLUE Body of the blue retro car Purchased part Seattle Manufacturing (M1) 20-WHL-ASSEM Wheel assembly Sub assembly Boston Manufacturing (M2) 20-AXLE Purchased part Dallas Manufacturing (M3) 20-WHEEL Car wheel Purchased part Dallas Manufacturing (M3) Car axle Inventory Items Table 2 Item Item Description Characteristic Producer/Supplier J20-CAR-RED Red-and-yellowrace car Finished product Boston Manufacturing (M2 20-CAR-BLUE Blue retro car Finished product Boston Manufacturing (2) 20-BODY-RED Body of the red-and-yellow Purchased part Seattle Manufacturing (MI) 20-BODY-BLUE Body of the blue retro car Purchased part Seattle Manufacturing (M) 20-WHL-ASSEM Wheel assembly Sub assembly Boston Manufacturing (Me 20-AXLE Car axle Purchased part Dallas Manufacturing (MB) 20-WHEEL Car wheel Purchased part Dallas Manufacturing (MB) Lead Safety Time days stock, units 5 30 5 25 5 50 5 75 5 130 10 100 10 100 On-hand Inventory, units 50 35 100 120 210 180 320 Ordering Policy Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lat July Week 3 Week 1 Week 2 Week 4 Week 5 940 30 20-CAR-RED (Supplier M2, finished product, L=1 week) Gross Requirements Safety Stock Amount on Hand Net Requirements Planned Orders Planned Order Releases 30 50 50 920 920 920 850 25 25 20-CAR-BLUE (Supplier M2, finished product, L=1 week) Gross Requirements Safety Stock Amount on Hand Net Requirements Planned Orders Planned Order Releases 35 35 840 840 840 920 50 50 100 100 870 870 870 22 23 20-BODY-RED (Supplier M1, purchased part, L=1 week) 24 Gross Requirements 25 Safety Stock 26 Amount on Hand 27 Net Requirements 28 Planned Orders 29 Planned Order Releases 30 31 20-BODY-BLUE (Supplier M1, purchased part, L=1 week) 32 Gross Requirements 33 Safety Stock 34 Amount on Hand 35 Net Requirements 36 Planned Orders 37 Planned Order Releases 38 840 75 120 75 120 795 795 795 1,665 130 130 210 210 1,585 1,585 1,585 38 39 20-WHL-ASSEM (supplier M2, sub assembly, 1 week) 40 Gross Requirements 41 Safety Stock 42 Amount on Hand 43 Net Requirements 44 Planned Orders 45 Planned Order Releases 46 47 20-AXLE (supplier M2, purchased part, L= 2 weeks 48 Gross Requirements 49 Safety Stock 50 Amount on Hand 51 Net Requirements 52 Planned Orders 53 Planned Order Releases 54 100 100 180 180 100 100 54 55 20-WHEEL (supplier M3, purchased part, L=2 weeks 56 Gross Requirements 57 Safety Stock 58 Amount on Hand 59 Net Requirements 60 Planned Orders 61 Planned Order Releases 62 320 320 63 64 Bills of Materials Figure 1 Figure 2 20-CAR-RED 20-CAR-BLUE 20-WHL-ASSEM 2 required 20-BODY-RED 1 required 20-WHL-ASSEM 2 required 20-BODY-BLUE 1 required 20-AXLE 1 required 20-WHEEL 2 required 20-AXLE 1 required 20-WHEEL 2 required Finished Product and Components Table 1 Component Item Description Characteristic Producer/Supplier 20-CAR-RED Red-and-yellow race car Finished product Boston Manufacturing (M2) 20-CAR-BLUE Blue retro car Finished product Boston Manufacturing (M2) 20-BODY-RED Body of the red-and-yellow car Purchased par Seattle Manufacturing (M1) 20-BODY-BLUE Body of the blue retro car Purchased part Seattle Manufacturing (M1) 20-WHL-ASSEM Wheel assembly Sub assembly Boston Manufacturing (M2) 20-AXLE Purchased part Dallas Manufacturing (M3) 20-WHEEL Car wheel Purchased part Dallas Manufacturing (M3) Car axle Inventory Items Table 2 Item Item Description Characteristic Producer/Supplier J20-CAR-RED Red-and-yellowrace car Finished product Boston Manufacturing (M2 20-CAR-BLUE Blue retro car Finished product Boston Manufacturing (2) 20-BODY-RED Body of the red-and-yellow Purchased part Seattle Manufacturing (MI) 20-BODY-BLUE Body of the blue retro car Purchased part Seattle Manufacturing (M) 20-WHL-ASSEM Wheel assembly Sub assembly Boston Manufacturing (Me 20-AXLE Car axle Purchased part Dallas Manufacturing (MB) 20-WHEEL Car wheel Purchased part Dallas Manufacturing (MB) Lead Safety Time days stock, units 5 30 5 25 5 50 5 75 5 130 10 100 10 100 On-hand Inventory, units 50 35 100 120 210 180 320 Ordering Policy Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lat July Week 3 Week 1 Week 2 Week 4 Week 5 940 30 20-CAR-RED (Supplier M2, finished product, L=1 week) Gross Requirements Safety Stock Amount on Hand Net Requirements Planned Orders Planned Order Releases 30 50 50 920 920 920 850 25 25 20-CAR-BLUE (Supplier M2, finished product, L=1 week) Gross Requirements Safety Stock Amount on Hand Net Requirements Planned Orders Planned Order Releases 35 35 840 840 840 920 50 50 100 100 870 870 870 22 23 20-BODY-RED (Supplier M1, purchased part, L=1 week) 24 Gross Requirements 25 Safety Stock 26 Amount on Hand 27 Net Requirements 28 Planned Orders 29 Planned Order Releases 30 31 20-BODY-BLUE (Supplier M1, purchased part, L=1 week) 32 Gross Requirements 33 Safety Stock 34 Amount on Hand 35 Net Requirements 36 Planned Orders 37 Planned Order Releases 38 840 75 120 75 120 795 795 795 1,665 130 130 210 210 1,585 1,585 1,585 38 39 20-WHL-ASSEM (supplier M2, sub assembly, 1 week) 40 Gross Requirements 41 Safety Stock 42 Amount on Hand 43 Net Requirements 44 Planned Orders 45 Planned Order Releases 46 47 20-AXLE (supplier M2, purchased part, L= 2 weeks 48 Gross Requirements 49 Safety Stock 50 Amount on Hand 51 Net Requirements 52 Planned Orders 53 Planned Order Releases 54 100 100 180 180 100 100 54 55 20-WHEEL (supplier M3, purchased part, L=2 weeks 56 Gross Requirements 57 Safety Stock 58 Amount on Hand 59 Net Requirements 60 Planned Orders 61 Planned Order Releases 62 320 320 63 64
