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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!