Use the following information and the attached editable MRP tableau worksheet to determine a complete material requirements plan for the...
aucionUse 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 |
|
|
|
|
|
|
|
|
|
12 years ago
20
- Letter to the editor
- statistic quiz
- Questions in description
- Suppose that the investment opportunity set has N projects, all of which have the same rate of return, R. Graph the investment opportunity set.
- who can do this good
- Assignment Due 09/07
- outline
- sagitahm
- thermal report
- Forensic scientists in the crime laboratory and crime scene investigators
