Use the following information and the attached editable MRP tableau worksheet to determine a complete material requirements plan for the...
mysjonUse 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
10
- Decay of promethium-142 by electron capture
- ANT homework help.
- Research Paper on "“Cognitive Dissonance” in Persuasion- Communication Major
- if 77cm is divided into the ratio 5:2 how long is each section
- RE: QuickBooks
- Teenage Depression
- probability table 2
- Find 3 numbers such that the second is 3 times the first and the third number is four times the...
- 1. Theory/Concept Application Paper : For this assignment, each individual will apply an...
- I need to create an online registration form. An HTML page is to be created for the form. The form...
