help

Need to answer 2.10

its right nvm

o Product A Part E 1 2 Factory Supplier 1 .1 ..2 2 Product B Part E 1 Assembly) 2 Part K 1 Part 1 3 Factory Supplier Supplier Supplier K Supplier L. 5. BOM Level 1 MRP Materials Requirements Planning Use the Master Schedule Release from Problem 2.9 Part E Lead Time=1wk: Lot Size-250; Safety Stock-50 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 0 220 300 0 0 300 0 0 Net Requirements 205 105 On-Hand 175 175 -45 -95 155 155 -148 105 105 Schedule Receipts 0 0 0 0 0 0 0 0 Planned Order Receipt 250 250 0 0 250 0 0 Planned Order Release 2504 0 0 250 0 0 0 155+ 2504 Planned Order Release 2504 2508 0 2501 0 Week 22 Week 23 0 Week 24 0 Assembly J Lead Time 1wk; Lot Size 600; Reorder Pointo Week 17 Week 18 Week 19 Week 20 Week 21 Gross Requirements 0 440 0 0 0 Net Requirements 235 On-Hand 175 175 -285 235 235 Schedule Receipts 0 0 0 0 0 Planned Order Receipt 0 500 0 0 0 Planned Order Release 0 0 0 0 235 235 235 0 235 0 0 0 0 500 0 0 0 0 6. BOM Level 2 MRP Materials Requirements Planning Part 1 Lead Time=3wks; Lot Size 2,000; Safety Stock-300 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 1500 660 0 ol 0 0 0 Net Requirements 2265 On-Hand 425 925 265 2265 2265 2265 2265 2265 2265 Schedule Receipts 2,000 0 0 0 0 0 Planned Order Receipt 0 2000 0 0 0 0 0 0 Planned Order Release 2,000 0 0 0 0 0 0 0 0 0 0 Product A Manufacturing Cycle Time-1wk; Lot Size=150; Reorder Point=50 May June Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 150 0 0 150 0 0 150 0 Projected Available Balance 110 110 Start Inventory 110 110 110 110 -40 110 110 -40 110 Scheduled Receipts 150 0 0 0 0 0 0 Master Schedule Receipt 0 0 0 150 0 0 150 0 Master Schedule Release 0 0 150 0 0 150 0 0 0 Product B Manufacturing Cycle Time-2wks: Lot Size-220; Reorder Point 100 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 195 0 0 195 0 75 0 0 Projected Available Balance 177 Start Inventory 127 152 152 152 -43 177 102 102 102 Scheduled Receipts 220 0 0 0 0 0 0 0 Master Schedule Receipt 0 0 220 0 0 0 Master Schedule Release 0 2204 0 0 0 0 0 0 220 0 Scheduled Receipts Master Schedule Receipt Master Schedule Release 0 0 0 0 0 220 0 0 0 0 220 0 0 0 0 0 0 0 O 0 1. Demand Forecast 4 Product A Products Products DC DC1 DC2 Mary Pune Week 17 Werk in Week 19 Week 20 Week 1 Week 2 Week 23 Week 24 50 so sol wi 50 sa so 50 26 221 2N 291 10 31 32 11 SH 53 42 39 54 43 32 9 10 2. DRP Distribution Requirements Planning 12 14 DRP Product A-DC 1 Transit Time. w Lot sure 150; Safety Stock 50 May June Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Demand Forecast Week 24 SO 50 50 vo SO 50 50 so Net Requirements 195 155 155 On Hand Inventory 105 55 105 53 105 Schedule Recept ol al 0 O ol 0 0 0 Planned Order Receipt 150 0 0 150 0 0 150 Planned Order Release 1501 0 0 150 ol 0 150 DRP Product B.D. 1 Trans Time 2wks of 15 Safety Stork-10 Week 12 Week 1 Week 1 Week 20 Week 21 Week 22 Week 3 Week 24 Demand forecast 26 27 2 10 31 12 33 Net Requirements 70 55 On Hand inventory 1 50 2.1 41 11 2 23 -10 Schedule Receipts 251 ol 0 0 0 0 Planned Order Heceipt ol 0 15 0 75 Planned Order Release 24 0 0 o 25 DRP Product B OC 82 Transit Timeslo Se 120 Safety Stock 20 Week 17 Week 18 Wonk 19 Week 20 Week 21 Week 22 Week 23 Week 24 Demand Forecast 42 11 19 50 12 Het Repairments 106 Onland Inventory RS 32 79 40 Schedule Receipts 120 0 0 0 ol Planned Order Receipt 0 120 ol 120 ol Planned Order Release 0 0 0 0 0 110 release 12014 ol 120 29 3. MPS Master Production Schedule 110 Product A Manufacturing Cycle Time-1w Lot Sure-150: Reader Poin-50 May June Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 150 150 0 150 Projected Available Balance 110 Start Inventory 110 110 110 110 110 40 Scheduled Receipts 110 40 110 150 0 ol 0 0 0 Master Schedule Receipt 0 0 0 150 Master Schedule Release 0 o 150 O 0 o 150 ol 0 150 al 0 Product Manufacturing Cycle Tune-w Lot Size-220Roder Point 100 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Gross Requirements Week 24 195 195 o 75 Projected Available Balance 177 Start livestory 127 152 152 152 A 172 Scheduled Receipts 102 102 102 220 0 olol Master Schedule Recept 0 0 al 230 Master Schedule Release 0 0 22014 0 0 ol 0 220 0 88853336853 Scheduled Receipts Master Schedule Recept Master Schedule Release 0 ol 0 0 220 0 O 0 0 ol ol 0 o Product A Part E 1 2 Factory Supplier 1 .1 ..2 2 Product B Part E 1 Assembly) 2 Part K 1 Part 1 3 Factory Supplier Supplier Supplier K Supplier L. 5. BOM Level 1 MRP Materials Requirements Planning Use the Master Schedule Release from Problem 2.9 Part E Lead Time=1wk: Lot Size-250; Safety Stock-50 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 0 220 300 0 0 300 0 0 Net Requirements 205 105 On-Hand 175 175 -45 -95 155 155 -148 105 105 Schedule Receipts 0 0 0 0 0 0 0 0 Planned Order Receipt 250 250 0 0 250 0 0 Planned Order Release 2504 0 0 250 0 0 0 155+ 2504 Planned Order Release 2504 2508 0 2501 0 Week 22 Week 23 0 Week 24 0 Assembly J Lead Time 1wk; Lot Size 600; Reorder Pointo Week 17 Week 18 Week 19 Week 20 Week 21 Gross Requirements 0 440 0 0 0 Net Requirements 235 On-Hand 175 175 -285 235 235 Schedule Receipts 0 0 0 0 0 Planned Order Receipt 0 500 0 0 0 Planned Order Release 0 0 0 0 235 235 235 0 235 0 0 0 0 500 0 0 0 0 6. BOM Level 2 MRP Materials Requirements Planning Part 1 Lead Time=3wks; Lot Size 2,000; Safety Stock-300 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 1500 660 0 ol 0 0 0 Net Requirements 2265 On-Hand 425 925 265 2265 2265 2265 2265 2265 2265 Schedule Receipts 2,000 0 0 0 0 0 Planned Order Receipt 0 2000 0 0 0 0 0 0 Planned Order Release 2,000 0 0 0 0 0 0 0 0 0 0 Product A Manufacturing Cycle Time-1wk; Lot Size=150; Reorder Point=50 May June Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 150 0 0 150 0 0 150 0 Projected Available Balance 110 110 Start Inventory 110 110 110 110 -40 110 110 -40 110 Scheduled Receipts 150 0 0 0 0 0 0 Master Schedule Receipt 0 0 0 150 0 0 150 0 Master Schedule Release 0 0 150 0 0 150 0 0 0 Product B Manufacturing Cycle Time-2wks: Lot Size-220; Reorder Point 100 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 195 0 0 195 0 75 0 0 Projected Available Balance 177 Start Inventory 127 152 152 152 -43 177 102 102 102 Scheduled Receipts 220 0 0 0 0 0 0 0 Master Schedule Receipt 0 0 220 0 0 0 Master Schedule Release 0 2204 0 0 0 0 0 0 220 0 Scheduled Receipts Master Schedule Receipt Master Schedule Release 0 0 0 0 0 220 0 0 0 0 220 0 0 0 0 0 0 0 O 0 1. Demand Forecast 4 Product A Products Products DC DC1 DC2 Mary Pune Week 17 Werk in Week 19 Week 20 Week 1 Week 2 Week 23 Week 24 50 so sol wi 50 sa so 50 26 221 2N 291 10 31 32 11 SH 53 42 39 54 43 32 9 10 2. DRP Distribution Requirements Planning 12 14 DRP Product A-DC 1 Transit Time. w Lot sure 150; Safety Stock 50 May June Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Demand Forecast Week 24 SO 50 50 vo SO 50 50 so Net Requirements 195 155 155 On Hand Inventory 105 55 105 53 105 Schedule Recept ol al 0 O ol 0 0 0 Planned Order Receipt 150 0 0 150 0 0 150 Planned Order Release 1501 0 0 150 ol 0 150 DRP Product B.D. 1 Trans Time 2wks of 15 Safety Stork-10 Week 12 Week 1 Week 1 Week 20 Week 21 Week 22 Week 3 Week 24 Demand forecast 26 27 2 10 31 12 33 Net Requirements 70 55 On Hand inventory 1 50 2.1 41 11 2 23 -10 Schedule Receipts 251 ol 0 0 0 0 Planned Order Heceipt ol 0 15 0 75 Planned Order Release 24 0 0 o 25 DRP Product B OC 82 Transit Timeslo Se 120 Safety Stock 20 Week 17 Week 18 Wonk 19 Week 20 Week 21 Week 22 Week 23 Week 24 Demand Forecast 42 11 19 50 12 Het Repairments 106 Onland Inventory RS 32 79 40 Schedule Receipts 120 0 0 0 ol Planned Order Receipt 0 120 ol 120 ol Planned Order Release 0 0 0 0 0 110 release 12014 ol 120 29 3. MPS Master Production Schedule 110 Product A Manufacturing Cycle Time-1w Lot Sure-150: Reader Poin-50 May June Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Week 24 Gross Requirements 150 150 0 150 Projected Available Balance 110 Start Inventory 110 110 110 110 110 40 Scheduled Receipts 110 40 110 150 0 ol 0 0 0 Master Schedule Receipt 0 0 0 150 Master Schedule Release 0 o 150 O 0 o 150 ol 0 150 al 0 Product Manufacturing Cycle Tune-w Lot Size-220Roder Point 100 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23 Gross Requirements Week 24 195 195 o 75 Projected Available Balance 177 Start livestory 127 152 152 152 A 172 Scheduled Receipts 102 102 102 220 0 olol Master Schedule Recept 0 0 al 230 Master Schedule Release 0 0 22014 0 0 ol 0 220 0 88853336853 Scheduled Receipts Master Schedule Recept Master Schedule Release 0 ol 0 0 220 0 O 0 0 ol ol 0