MS.53 An office furniture manufacturer needs to calculate material requirements for one of its most popular tables. The graphic above shows the bill of material for this item. Below are the MRP tables for the top-level assembly (the Office Table Final Assembly) and one of its sub-assemblies (the Table-Top Assembly):

Office TableFinal Assembly 8/1 8/8 8/15 8/22 8/29 9/5 9/12 9/19 9/26

Gross Requirements 500 200 300 300 600 100

Scheduled Receipts

Projected On-Hand Inv. 440

Net Requirements

Planned Order Receipts

Planned Order Releases

Lead Time (in weeks) 1

Lot Size 150

Table-Top Assembly 8/1 8/8 8/15 8/22 8/29 9/5 9/12 9/19 9/26

Gross Requirements

Scheduled Receipts 70

Projected On-Hand Inv. 100

Net Requirements

Planned Order Receipts

Planned Order Releases

Lead Time (in weeks) 1

Lot Size 60

For theOffice Tableabove (the firstMRP table), what is theProjected On-Hand Inventoryin the week of 9/19?

For theOffice Tableabove, what are thePlanned Order Receiptsin the week of 8/8?

For theTable-Top Assemblyabove, what are theNet Requirementsin the week of 9/19?

For theTable-Top Assemblyabove, what are thePlanned Order Releasesin the week of 9/5?