Question: Develop MRP records for all items needed for item F in the following product structure for product H, using the information provided in the following
Develop MRP records for all items needed for item F in the following product structure for product H, using the information provided in the following tables. The lead time to complete product H is one week. Master production schedule (MPS) calls for 160, 140, and 70 units of demand for period 4, 5, and 6.
|
|
| Planning Data | |||||
| Data Category | D | E | F | G | I |
| Lot size rule | Q= 15* | L4L | L4L | Q=300* | L4L |
| Lead time | 2 weeks | 1 week | 1 week | 2 weeks | 2 weeks |
| Safety stock | 15** | 25 | 20 | 35 | 0 |
| Scheduled receipts | None | none | 1,300 (wk 1) | 700 (wk 1) | 900 (wk 1) |
| Beginning inventory | 30 | 40 | 20 | 50 | 0 |
*Planned order schedules must be the same or multiples of Q amount
**minimum on hand (ending inventory) quantity to be observed
FORMAT FOR ENTRIES: All quantities are INTEGER (120, for example). Enter 0 if you do not have quantity for any period.
PROVIDE THE FOLLOWING SELECTED VALUES:
| Planned Order Release Quantities for Product H | ||||
| Period 1 | Period 2 | Period 3 | Period 4 | Period 5 |
| Blank 1 | Blank 2 | Blank 3 | Blank 4 | Blank 5 |
| Gross Requirements Quantities for Item F | ||||
| Period 1 | Period 2 | Period 3 | Period 4 | Period 5 |
| Blank 6 | Blank 7 | Blank 8 | Blank 9 | Blank 10 |
- Blank 1 -
- Blank 2 -
- Blank 3 -
- Blank 4 -
- Blank 5 -
- Blank 6 -
- Blank 7 -
- Blank 8 -
- Blank 9 -
- Blank 10 -
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
