Question

For the Office Table above (the first MRP table), what is the Projected On-Hand Inventory in the week of 9/19?
   

For the Office Table above, what are the Planned Order Receipts in the week of 8/8?

   
For the Table-Top Assembly above, what are the Net Requirements in the week of 9/19?

   
For the Table-Top Assembly above, what are the Planned Order Releases in the week of 9/5?
  

Answer 1

or the Office Table above (the first MRP table), what is the Projected On-Hand Inventory in the week of 9/19?

Correct answer is 65
For the Office Table above, what are the Planned Order Receipts in the week of 8/8?

Correct answer is 225

For the Table-Top Assembly above, what are the Net Requirements in the week of 9/19?

Correct answer is 270

For the Table-Top Assembly above, what are the Planned Order Releases in the week of 9/5?

Correct answer is 480

office table final assembly

Week		8/1	8/8	8/15	8/22	8/29	9/5	9/12	9/19	9/26
Gross requirement		500	200	0	600	0	500	0	500	300
Scheduled receipt		0	0	0	0	0	0	0	0	0
Projected on hand Inv.	440	440	15	40	40	40	40	65	65	15
Net requirement		60	185	0	560	0	460	0	435	285
Planned order receipt		75	225	0	600	0	525	0	450	300
Planned order release		225	0	600	0	525	0	450	300	0

Table-top assembly

Week		8/1	8/8	8/15	8/22	8/29	9/5	9/12	9/19	9/26
Gross requirement		225	0	600	0	525	0	450	300	0
Scheduled receipt		80	0	0	0	0	0	0	0	0
Projected on hand Inv.	190	270	45	45	5	5	0	0	30	0
Net requirement		0	0	555	0	520	0	450	270	10
Planned order receipt		0	0	560	0	520	0	480	280	0
Planned order release		0	560	0	520	0	480	280	0	0