Question
Given the Master Production Schedule and the Bill of Material that follow, fill in the MRP records for parts 9001, 8821, K9861, and K3390. planned
Given the Master Production Schedule and the Bill of Material that follow, fill in the MRP records for parts 9001, 8821, K9861, and K3390. planned order release information has been provided so you can complete the MRP records. For each gross requirements line within each record, clearly explain or show how arrived at the numbers.
MPS:
Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|
|
|
|
|
|
|
|
Part #9001 | 56 | 72 | 94 | 80 | 95 | 90 | 85 |
|
|
|
|
|
|
|
|
Part #8821 | 81 | 101 | 85 | 77 | 92 | 95 | 102 |
Part 9001 has a scheduled receipt of 150 pieces for period 1
Part K3390 has a scheduled receipt of 180 pieces for period 1
Part K9861 has a scheduled receipt of 175 pieces for period 2
Part 8821 has a scheduled receipt of 90 for period 1.
Part K9861
Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
Gross Requirements |
|
|
|
|
|
|
|
Scheduled Receipts |
|
|
|
|
|
|
|
Planned Order Receipts |
|
|
|
|
|
|
|
Projected Available Balance | 500 |
|
|
|
|
|
|
|
Planned Order Releases |
|
|
|
|
| 125 | 150 |
Safety Stock = 80
Lead Time = 2
Lot Size = 25
Part K3390
Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
Gross Requirements |
|
|
|
|
|
|
|
Scheduled Receipts |
|
|
|
|
|
|
|
Planned Order Receipts |
|
|
|
|
|
|
|
Projected Available Balance | 985 |
|
|
|
|
|
|
|
Planned Order Releases |
|
|
|
|
|
| --- |
Safety Stock = 60
Lead Time = 1
Lot Size = 60
Part 9001 Part 8821 K9861 Qty 2 K7756 Oty 2 K9822 Oty 3 K9861 Oty 1 KX722 Oty 4 K3320-Oly 4 K8829 Oly 1 K3390 - Oty 4 K8829 Olv! Part 9001 Part 8821 K9861 Qty 2 K7756 Oty 2 K9822 Oty 3 K9861 Oty 1 KX722 Oty 4 K3320-Oly 4 K8829 Oly 1 K3390 - Oty 4 K8829 Olv
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started