Discuss the below problem:
Q: A garden equipment manufacturer has a product that it makes which is represented by the following product structure tree along with other pertinent data. Use this information and the included editable MRP table worksheet to determine a complete material requirements plan for the 5 week planning horizon Your answer must be presented in the tables included below ABC-51 X (3 P (4 (2 Inventory Records File Lead Time On Hand Lot Size Safety Stock Sched. Receipt Item LAL ABC-51 15 LAL 12 P 1 100 140 in wk 1 53 10 LAL 30 10 28 wk 1 20 10 x 2 25 40 0 Master Production Schedule (Weeks) Product ABC-51 75 50
Master Production Schedule(Weeks)
Product 1 2 3 4
ABC-51 0 0 50 0
| Horizon Period |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
| Item: |
Lot siz |
|
|
LT: |
|
|
SS: |
|
|
| Gross Requirements |
|
|
|
|
|
|
|
|
|
| Scheduled Receipts |
|
|
|
|
|
|
|
|
|
| Projected on hand |
|
|
|
|
|
|
|
|
|
| Net Requirements |
|
|
|
|
|
|
|
|
|
| Planned order receipts |
|
|
|
|
|
|
|
|
|
| Planned order releases |
|
|
|
|
|
|
|
|
