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 150, 130, and 100 units of demand for period 4, 5, and 6.

Develop MRP records for all items needed for item

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

Gross Requirements Quantities for Item F

Period 1

Period 2

Period 3

Period 4

Period 5

Product D (2) F (1) E (1) F (2) G(1) E (1) I (3) Product D (2) F (1) E (1) F (2) G(1) E (1) I (3)

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!