Complete the following MRP record. Note that the minimum order quantity is 500.
ID: 366706 • Letter: C
Question
Complete the following MRP record. Note that the minimum order quantity is
500.
What is the average ending inventory over the six weeks?
Complete the material requirements plan (enter your responses as whole numbers).
Week
1
2
3
4
5
6
***B3***
Gross requirements
0
600
350
600
350
200
LT(weeks)equals=1
Scheduled receipts
Projected ending inventory: 0
?
?
?
?
?
?
Net requirements
?
?
?
?
?
?
orderequals=500
Planned receipts
?
?
?
? ? ?
Week
1
2
3
4
5
6
***B3***
Gross requirements
0
600
350
600
350
200
LT(weeks)equals=1
Scheduled receipts
Projected ending inventory: 0
?
?
?
?
?
?
Net requirements
?
?
?
?
?
?
Min.orderequals=500
Planned receipts
?
?
?
? ? ?
Explanation / Answer
Week 1 2 3 4 5 6 Avg ***B3*** Gross requirements 0 600 350 600 350 200 350 LT(weeks)equals=1 Scheduled receipts Projected ending inventory: 0 0 400 50 450 100 400 233 Ans Net requirements 600 -50 550 -100 100 -50 175 Min. Planned receipts 1000 0 1000 0 500 0 417 orderequals=500