Question: TASK: Complete the MRP record for component C as it would appear at the beginning of week 2. MRP record for component C as it
TASK: Complete the MRP record for component C as it would appear at the beginning of week 2.
MRP record for component C as it would appear at the beginning of week 1.
| Week | 1 | 2 | 3 | 4 | 5 | 6 |
| Gross Requirements | 15 | 30 | 25 | 25 | 10 | 20 |
| Scheduled Receipts | 40 | 0 | 0 | 0 | 0 | 0 |
| Projected Available Balance | 50 | 20 | 35 | 10 | 0 | 20 |
| Planned Order Receipts | 0 | 0 | 40 | 0 | 0 | 40 |
| Planned Order Releases | 40 | 0 | 0 | 40 | 0 | 0 |
During week 1, the following transactions occurred for component C:
- The open order for 40 units due to be received at the start of week 1 was received on Monday of week 1 with a quantity of 35 (5 units of component C were scrapped on this order).
- An inventory cycle count during week 1 revealed that ten units of component C were missing. Thus, an inventory adjustment of -10 was processed.
- Five units of component C were actually disbursed (instead of the 15 units planned for disbursement to produce end products X and Y). (The MPS quantity of 10 in week 1 for product X was canceled as a result of a customer order cancellation.)
- The MPS quantities for week 7 include 20 units for product X and 10 units for product Y.
- Because of a change in customer order requirements, marketing has requested that the MPS quantity of 5 units for product X scheduled in week 4 be moved to week 3.
- An order for 40 units was released.
Given this information, complete the MRP record for component C as it would appear at the beginning of week 2:
| Week | 2 | 3 | 4 | 5 | 6 | 7 |
| Gross Requirements | ||||||
| Scheduled Receipts | ||||||
| Projected Available Balance | ||||||
| Planned Order Receipts | ||||||
| Planned Order Releases |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
