Question

1. 1 Complete the following MRP matrix for item A. Then answer the questions that follow.

When are planned orders scheduled to be released? (Hint: it's the last row of the matrix).

Item:  A                    LLC: 1	Period
Lot size:  Mult 50       LT:   2	1	2	3	4	5	6	7	8
Gross Requirements	10	15	25	75	60	85	45	60
Scheduled Receipts
Projected on Hand         | 50
Net Requirements
Planned Order Receipts
Planned Order Releases

A. Periods 2 through 6

B. Periods 2, 4 and 6

C. Periods 1 through 6

D. Periods 4 through 8

1.2

Complete the following MRP matrix for item A. Then answer the questions that follow.

What is the Projected on Hand at the end of period 5?

Item:  A                    LLC: 1	Period
Lot size:  Mult 50       LT:   2	1	2	3	4	5	6	7	8
Gross Requirements	10	15	25	75	60	85	45	60
Scheduled Receipts
Projected on Hand         | 50
Net Requirements
Planned Order Receipts
Planned Order Releases

A. 0

B. 15

C. 25

D. 30

Answer 1

Answer: The below MRP sheet is filled as below

tem:  A                    LLC: 1	Period
Lot size:  Mult 50       LT:   2	1	2	3	4	5	6	7	8
Gross Requirements	10	15	25	75	60	85	45	60
Scheduled Receipts	0	0	0	0	0	0	0	0
Projected on Hand         | 50	40	25	0	25	15	30	35	25
Net Requirements	0	0	0	0	0	0	0	0
Planned Order Receipts	0	0	0	100	50	100	50	50
Planned Order Releases	0	100	50	100	50	50	0	0

Answer 1.1 : Correct Option – A : Period 2 through 6.

Refer the above MRP chart filled for the same. It shows that planned order to be released for each period starts from period 2 to period 6 for meeting the customer demand in each period.

Answer 1.2: Correct Option – B : 15 nos.

Refer the above MRP chart filled for the same. It shows that the on hand inventory at end of period 5 is 15 nos. only. 50 nos, are planned receipts, 25 nos were previous inventory, so this make total = 75 nos. Demand for the 5^th week is 60 nos. hence inventory left at the end of week 5 = 75 – 60 =15 nos.