Question

Eighty units of end item X are needed at the beginning of week 6, and another 30 units are needed at the beginning of week 8 B(2) D(3) D(2) F(2) Prepare a material requirements plan for component D. D can only be ordered in whole cases (50 units per case). One case of D is automatically received every other week, beginning in week 1 (i.e., weeks 1, 3, 5, 7). Also, there are 30 units of B and 20 units of D now on hand. Lead times for all items are a function of quantity: one week for up to 100 units, two weeks for 101 to 200 units, three weeks for 201 to 300 units, and four weeks for 301 or more units. (Leave no cells blank - be certain to enter "O" wherever required.) Part Beg. Inv Gross requirements Scheduled receipts On hand Net requirements Planned-order receipt Planned-order release

Answer 1

033 1 Part X 2 Gross requirements 3 Scheduled receipts 4 On hand at beginning 5 Net requirements 6 Planned-order receipt 7 Planned oreder release 80 30 80 80 30 30 80 30 9 Part B 10 Gross requirements 11 Scheduled receipts 12 On hand at beginning 13 Net requirements 14 Planned-order receipt 15 Planned oreder release 16 I 17 Part 18 Gross requirements 19 Scheduled receipts 20 On hand at beginning 21 Net requirements 22 Planned-order receipt 23 Planned oreder release 24 160 60 30 30 130 130 30 30 30 30 60 60 130 260 50 70 140 150 200 240 50 10 180 200 100 120 90 50 50 20 20 10 20 100 100 50 70 40 50 150

033 1 Part X 2 Gross requirements 3 Scheduled receipts 4 On hand at beginning 0 5Net requirements 6 Planned-order receipt 7 Planned oreder release 80 30 -H2-H4 80 0 0 30 -J2-J4 30 80 9 PartB 10 Gross requirements 11 Scheduled receipts 12 On hand at beginning 30 13 Net requirements 14 Planned-order receipt 15 Planned oreder release 16 17 Part D 18 Gross requirements 19 Scheduled receipts 20 On hand at beginning 21 Net requirements 22 Planned-order receipt 23 Planned oreder release 24 -G7*2 0 -17*2 0 0 0 -E12 0 0 -B12 -C12 D12 F12 -G10-G12 -E15 0 -G12+G13-G10 H13 -110-112 -H15 G13 -113 -E15*2 50 -G7*3 50 17*3 50 -H22-H21 -118-119 -H23 -H15*2 20 -B20 C19+C20-D20 E22-E21 F20 -G22-G21 E18-E19-E20 0 -C23 200 -G18-G19-G20 H18-H20 -E23 -H21 G23 50 150

033 9 Part B 10 Gross requirements 11 Scheduled receipts 12 On hand at beginning 13 Net requirements 14 Planned-order receipt 15 Planned oreder release 60 160 0 30 130 130 0 0 30 30 30 30 30 60 60 130 60 17 Part D 18 Gross requirements 19 Scheduled receipts 20 On hand at beginning 21 Net requirements 22 Planned-order receipt 23 Planned oreder release 90 50 120 260 50 70 140 150 200 240 50 10 180 200 100 50 20 0 20 70 10 100 100 40 50 0 150 0 Beg inv 26 Part D 27 Gross requirements 28 Scheduled receipts 29 On hand 30 Net requirements 31 Planned-order receipt 32 Planned oreder relea 120 240 50 20 180 200 100 90 50 10 40 50 260 50 0 20 70 70 10 10 20 0 10 70 70 140 150 200 100 100 50 150 se Choot 1

033 9 Part B 10 Gross requirements 11 Scheduled receipts 12 On hand at beginning 30 13 Net requirements 14 Planned-order receipt 15 Planned oreder release 0 -17*2 0 0 0 -B12 0 C12 -D12 -E12 -F12 -G10-G12 -E15 G12+G13-G10 0 0 -113 -H13 -110-112 -H15 -G13 17 Part D 18 Gross requirements 19 Scheduled receipts 20 On hand at beginning 21 Net requirements 22 Planned-order receipt 23 Planned oreder release -H15*2 0 G22-G21 -E15 2 -G7*3 -17*3 C19+C20 D20 E22-E21 -F20 -H22-H21 -118-119 -H23 -B20 -E18-E19-E20 0 -C23 200 -G18-G19-G20-H18-H20 -E23 -H21 -G23 50 150 26 Part D 27 Gross requirementsC20 -C18 28 Scheduled receipts 29 On hand 30 Net requirements 31 Planned-order receipt G20 C22 32 Planned oreder releaseH20 C23 Beg inv 1 =118 -119 -131-130 -127-128-H29 -122 -123 -D18 -D19 -E18 -E19 -F18 -F19 E29 -H18 H19 G 18 -G19 -G31-G30 -G27-G28-B31 H27-B32 -G22 G23 D20 C19 E20 C28+B27-C29 -F20 C21 E31-E30 -E27-E28-B29 F21 -E22 -E23 H31-H30 -D21 -D22 D23 -F22 F23 H22 -H23
Second Part D MRP is done just to replicate the order/table given in the question