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
![241_Record file.jpg](https://secure.tutorsglobe.com/CMSImages/241_Record file.jpg)
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 |
|
|
|
|
|
|
|
|
![459_Lot Size.jpg](https://secure.tutorsglobe.com/CMSImages/459_Lot Size.jpg)
![1786_Lot Size.jpg](https://secure.tutorsglobe.com/CMSImages/1786_Lot Size.jpg)