|
| Material Requirements Planning for Oil Leak Valve Assembly |
|
| Item |
| Day: |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
| Oil Leak Valve |
| Gross requirements |
|
| LT=1 day |
| Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
| 14 |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Shield Valve (1) |
| Gross requirements |
|
| LT=1 day |
| Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
| 15 |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Brackets (2) |
| Gross requirements |
|
| LT=2 days |
| Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
| 15 |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Explode the Shield Valve value records to get the records for the Anchor assembly and Sealing Valve components. |
|
| Sealing Valve (1) |
| Gross requirements |
|
| LT=1 days |
| Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
| 15 |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Anchor Assembly (1) |
| Gross requirements |
|
| LT=3 days |
| Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
| 19 |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Explode the oil leak value records to get the records for the Rear cover, Capping Valve, Ubolts, and Front cover components. |
|
| Capping Valve (1) |
| Gross requirements |
|
| LT=1 days |
| Scheduled receipts |
|
|
|
|
|
|
|
|
|
|
| 24 |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| U-Bolts (1) |
| Gross requirements |
|
| LT=3 days |
| Scheduled receipts |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Front Cover (1) |
| Gross requirements |
|
| LT=2 days |
| Scheduled receipts |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
|
|
| Planned order release |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Explode the Capping Valve records to get the records for the Ball bearing and Back flush Valve components. |
|
| Back Flush Valve (1) |
| Gross requirements |
|
| LT=1 days |
| Scheduled receipts |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Ball Bearing (2) |
| Gross requirements |
|
| LT=3 days |
| Scheduled receipts |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Explode the Back flush Valve records to get the records for the Base and Base housing components. |
|
| Base (1) |
| Gross requirements |
|
| LT=3 days |
| Scheduled receipts |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
| Base Housing (1) |
| Gross requirements |
|
| LT=4 days |
| Scheduled receipts |
|
|
|
| Proj. avail. balance |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
|
|
|
| Net requirements |
|
|
|
| Planned order receipt |
|
|
|
| Planned order release |
dream86
Week1-MRPAssignment.xlsx
