Question

please solve clearly and show all steps

5. Williston Technologies wishes to use MRP methodology to developing a material requirements plan for the next nine weeks. Williston Technologies has gathered the following information to work with: Bill of Materials: Current Inventory Records: Inventory Leadtime (in weeks) Currently Lotsize On-hand Lot-for-Lot 50 100 100 100 50 400 Master Production Schedule: -Weeks- Part 2 3 4 50 100 5 6 7 8 9 100 2500 2000 50 0 a. Using MRP methodology, how much of Parts A, B, C and D should be ordered, and when should they be ordered? b. Based on the material requirements plan developed for Livingston Technologies, how much of Parts A, B, C and D will remain in inventory at the end of week 9? c. Livingston Technologies has just learned that the order for 200 A's appearing in Week 7 has been cancelled. How does this change the material requirements plan?

Answer 1

Material A
Week	Currently on hand	Week wise requirement	Receipts based on Lead time	Inventory at the end of week	order qty
					50
1	50	-	50	100	50
2	100	50	50	100	-
3&4	100	100	-	-	100
5	-	100	100	-	250
6	-	250	250	-	-
7	-	-	-	-	200
8	-	200	200	-	-
9	-	-	-	-	50
10	-	-	50	50
Material B
Week	Currently on hand	Week wise requirement	Receipts based on Lead time	Inventory at the end of week	order qty
					-
1	100	25	-	75	100
2	75	50	-	25	100
3&4	25	50	100	75	-
5	75	125	100	50	50
6	50	-	-	50	-
7	50	100	50	-	-
8	-	-	-	-	50
9	-	-	-	-	-
10	-	-	50	50
Material C
Week	Currently on hand	Week wise requirement	Receipts based on Lead time	Inventory at the end of week	order qty
					-
1	100	25	-	75	25
2	75	50	-	25	125
3&4	25	50	25	-	-
5	-	125	125	-	100
6	-	-	-	-	-
7	-	100	100	-	-
8	-	-	-	-	25
9	-	-	-	-	-
10	-	-	25	25
Material D
Week	Currently on hand	Week wise requirement	Receipts based on Lead time	Inventory at the end of week	order qty
					-
1	400	-	-	400	-
2	400	50	-	350	-
3&4	350	100	-	250	100
5	250	100	-	150	-
6	150	250	100	-	200
7	-	-	-	-	-
8	-	200	200	-	50
9	-	-	-	-	-
10	-	-	50	50	-

b.The inventory at the end of week 9 will be NIL for A,B, C & D

c. If the Order for 200 A's appearing in week 7 cancelled, the same can be ordered in week 6, because the Lead time 1s 1 week for material A.