Question $4$

$20$ Points

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

Planning Data

Data Category

D

E

F

G

I

Lot size rule

Q$=15*$

L$4$L

L$4$L

Q$=300*$

L$4$L

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$

$0$

$0$

$170$

$130$

$60$

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$

Question