Use the following information and the attached editable MRP tableau worksheet to determine a complete material requirements plan for the 5 week planning horizon. A garden equipment manufacturer has a product that it makes which is represented by the following product structure tree along with other pertinent data:
ABC-51
--------------------------------------------------------------
l l l
l l l
W X (3 L
l l
l --------------------------------
P (4 l l
l l
P R (2
Inventory Records File
|
|
Item
|
Lead Time
|
On Hand
|
Lot Size
|
Safety Stock
|
Sched. Receipt
|
|
ABC-51
|
1
|
15
|
L4L
|
0
|
---
|
|
L
|
1
|
12
|
L4L
|
0
|
---
|
|
P
|
1
|
53
|
100
|
10
|
140 in wk 1
|
|
R
|
1
|
30
|
L4L
|
10
|
28 wk 1
|
|
W
|
1
|
10
|
20
|
0
|
---
|
|
X
|
2
|
25
|
40
|
0
|
---
|
Master Production Schedule (Weeks)
Product 1 2 3 4 5
ABC-51 0 0 50 0 75
|
Horizon Period
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
|
Item:
|
Lot Size:
|
LT:
|
SS:
|
|
Gross Requirements
|
|
|
|
|
|
|
|
|
|
|
Scheduled Receipts
|
|
|
|
|
|
|
|
|
|
|
Projected On Hand
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Receipts
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Releases
|
|
|
|
|
|
|
|
|
|
|
Item:
|
Lot Size:
|
LT:
|
SS:
|
|
Gross Requirements
|
|
|
|
|
|
|
|
|
|
|
Scheduled Receipts
|
|
|
|
|
|
|
|
|
|
|
Projected On Hand
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Receipts
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Releases
|
|
|
|
|
|
|
|
|
|
|
Item:
|
Lot Size:
|
LT:
|
SS:
|
|
Gross Requirements
|
|
|
|
|
|
|
|
|
|
|
Scheduled Receipts
|
|
|
|
|
|
|
|
|
|
|
Projected On Hand
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Receipts
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Releases
|
|
|
|
|
|
|
|
|
|
|
Item:
|
Lot Size:
|
LT:
|
SS:
|
|
Gross Requirements
|
|
|
|
|
|
|
|
|
|
|
Scheduled Receipts
|
|
|
|
|
|
|
|
|
|
|
Projected On Hand
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Receipts
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Releases
|
|
|
|
|
|
|
|
|
|
|
Horizon Period
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
|
Item:
|
Lot Size:
|
LT:
|
SS:
|
|
Gross Requirements
|
|
|
|
|
|
|
|
|
|
|
Scheduled Receipts
|
|
|
|
|
|
|
|
|
|
|
Projected On Hand
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Receipts
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Releases
|
|
|
|
|
|
|
|
|
|
|
Item:
|
Lot Size:
|
LT:
|
SS:
|
|
Gross Requirements
|
|
|
|
|
|
|
|
|
|
|
Scheduled Receipts
|
|
|
|
|
|
|
|
|
|
|
Projected On Hand
|
|
|
|
|
|
|
|
|
|
|
Net Requirements
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Receipts
|
|
|
|
|
|
|
|
|
|
|
Planned-Order Releases
|
|
|
|
|
|
|
|
|
|