Question: The BOM for product A, and data from the inventory records, are shown below. In the master production schedule for product A, the MPS quantity
The BOM for product A, and data from the inventory records, are shown below. In the master production schedule for product A, the MPS quantity row (showing completion dates) calls for 250 units in week 8. The lead time for production of A is three weeks.
| Data Category | B | C | D |
| Lot sizing rule | P = 2 | FOQ = 800 | LFL |
| Lead time | 2 weeks | 1 week | 1 week |
| Scheduled receipts | 120 (week 1) | 0 | 0 |
| Beginning (on-hand) inventory | 0 | 80 | 0 |
Develop the materials requirements plan for the next eight weeks for Items B, C, and D. Round your answers to the nearest whole number. Do not leave fields blank, enter zero if applicable.
| MPS | Lead time = 3 weeks for assembly | ||||||||
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Product Aend item | |||||||||
| Planned order releases | |||||||||
| Item C (two units of C are needed for one unit of A) | Lot size: 800 units | ||||||||
| Description | Lead time: 1 week | ||||||||
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Gross requirements | |||||||||
| Scheduled receipts | |||||||||
| Projected OH inventory | 80 | ||||||||
| Planned order receipts | |||||||||
| Planned order releases | |||||||||
| Item D | Lot size: LFL | ||||||||
| Description | Lead time: 1 week | ||||||||
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Gross requirements | |||||||||
| Scheduled receipts | |||||||||
| Projected OH inventory | 0 | ||||||||
| Planned order receipts | |||||||||
| Planned order releases | |||||||||
| Item B | Lot size: POQ = 2 weeks | ||||||||
| Description | Lead time: 2 weeks | ||||||||
| Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Gross requirements | |||||||||
| Scheduled receipts | |||||||||
| Projected OH inventory | 0 | ||||||||
| Planned order receipts | |||||||||
| Planned order releases | |||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
