MRP X

Use the information below to work the problems in this section and the next three sections. Read the instructions in each section that follows fully and carefully.

Each X is made of 2Y and 1Z

Each Y is made of 3A and B

Each Z is made of 5A and C

We will ignore scheduling B and C

Inventory information is as follows:

X

Lot size 1,200

On hand 1,100

Safety stock 300

Allocated 0

Lead time 1

Gross requirements for periods 1-8 are: 600, 700, 600, 700, 600, 700, 600, and 700.

What is the projected on hand at the end of period 1-8? What are the net requirements in period 1-8? What are the planned order releases in period 1-8?

Please explain your answers.

This is the feedback from my professor but I am still confused how to end up with the table.

5 600 6 700 7 600 600 700 600 700 700 800H 100 600 Gross Requirements Scheduled Receipts Projected on Hand (Begin) Projected on Hand (End) Net Requirements Planned Order Receipts Planned Order Releases 800 200 200 700 500 1,200 700 100 - 1,100 400 500 700 1,200 1,200 500 1,100 100 1.200 1,200 1,200 1,200 1,200