Production/Operations Management and Business Policy advice for Excelsior

[stillwater89]

Hey guys I am on exam 3 and having a hard time with this problem. Can some point me in the right direction with this problem?
3. (50 points) Correctly fill in the materials plans for all the items. All lot sizing is lot-for-lot.


Item Lead time Inventory on hand X Y
X 1 45 A B C
Y 1 35 (1) (2) (2)
A
2 45
B 2 410 B
C 3 220 (3)

Master Schedule
Period 1 2 3 4 5 6 7 8 9 10 11 12
X 10 10 20 10 35 20 10 30 5 15
Y 15 25 20 20 40 20 10 45 15 15

MRP Worksheets
Item: X Lead time= Lot Sizing rule =
Gross Requirements
Scheduled Receipts
Projected on Hand

Net Requirements
Planned Order Receipts
Planned Order Releases

Item: Y Lead time= Lot sizing rule =
Gross Requirements
Scheduled Receipts 20
Projected on Hand

Net Requirements
Planned Order Receipts
Planned Order Releases

Item: A Lead time= Lot sizing rule =
Gross Requirements
Scheduled Receipts
Projected on Hand

Net Requirements
Planned Order Receipts
Planned Order Releases

Item: B Lead time= Lot Sizing rule =
Gross Requirements
Scheduled Receipts
Projected on Hand

Net Requirements
Planned Order Receipts
Planned Order Releases

Period 1 2 3 4 5 6 7 8 9 10 11 12
Item: C Lead time= Lot Sizing rule =
Gross Requirements
Scheduled Receipts
Projected on Hand

Net Requirements
Planned Order Receipts
Planned Order Releases