Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Safari File Edit View History Bookmarks Window Help , 97% GSC 3600 Operations an

ID: 364703 • Letter: S

Question

Safari File Edit View History Bookmarks Window Help , 97% GSC 3600 Operations and Supply Chain Homework: Chapter 12 Homework Score: 0 of 1 pt Problem 8 2 of 9 (1 complete) Complete the following MRP record. Note that the minimum order quantity is 200. What is the average ending inventory over the six weeks? E Click the icon to view the MRP record. Week B3* Gross requirements 0 250 350 200 400 250 Projected ending inventory: 50 Min. order 200 Planned receipts More Info 250 350 200 400 250 "B3 LT(weeks)-1 Scheduled receipts Gross requ Projected ending inventory: 50 in the edit fields and then Min. order 200 Planned receipts arts

Explanation / Answer

Material requirement Plan for six weeks is as follows -

Total Projected Ending Inventory for the six weeks = 50+50+50+50 = 200

Average Ending Inventory over the six weeks = Total Projected Ending Inventory for the six weeks /6

= 200 /6 = 33.33

Week 1 2 3 4 5 6 Gross Requirements 0 250 350 200 400 250 OH= 50 Scheduled Receipts 0 0 0 0 0 0 Projected Beginning Inventory 50 50 0 50 50 50 LT = 1 Projected Ending Inventory 50 0 50 50 50 0 Net Requirements 0 200 350 150 350 200 Q = 200 (minimum order) Planned Order Receipt 0 200 400 200 400 200 Planned Order Release 200 400 200 400 200 0