Question

The partially completed inventory record for the driveshaft subassembly in the table below shows gross? requirements, scheduled? receipts, lead? time, and current? on-hand inventory.

a. Complete the last three rows of the record for an FOQ of

50

units. ?(Enter your responses as integers. A response of? "0" is equivalent to being not? applicable.)

?Item: Driveshaft subassembly						Lot? Size: FOQequals=50 units
						Lead? Time: 3 weeks
		Week
		1	2	3	4	5	6	7	8
Gross requirements		30	25	20	15	30	30	50	50
Scheduled receipts		75
Projected? on-hand inventory	10
Planned receipts b. Complete the last three rows of the record by using the L4L? lot-sizing rule. c. Complete the last three rows of the record by using the POQ? lot-sizing rule, with Pequals=4.

Answer 1

Please find below filled up MRP table for both L4L as well as POQ rule.

For L4L:

Projected on hand inventory for period t = Projected on hand inventory for period t-1 + Scheduled receipt for period t – Gross requirement for period t( Provided Projected on hand inventory for period t > = 0)

In case Projected on hand inventory for period t <0as per above calculation , in such case:

Planned order receipt for period t = Gross requirement for period t – Scheduled receipt for period t – Projected on hand inventory for period t-1

Lot sizing rule = L4L

Driveshaft subassembly	1	2	3	4	5	6	7	8
Gross requirement	30	25	20	15	30	30	50	50
Scheduled receipt	75	0	0	0	0	0	0	0
Projected on hand inventory: 10	55	30	10	0	0	0	0	0
Planned order receipt	0	0	0	5	30	30	50	50

For POQ ( period order quantity ) = 4 :

Calculation for Projected on hand inventory for period t = same as above In case Projected on hand inventory for period t <0as per above calculation , in such case:

Planned order receipt for period t = Sum of gross requirements for periods ( t, t+1 , t+2 , t+3 ) – Scheduled receipt for period t – Projected on hand inventory for period t-1

Lot sizing rule =POQ of 4

Driveshaft subassembly		2	3	4	5	6	7	8
Gross requirement	30	25	20	15	30	30	50	50
Scheduled receipt	75	0	0	0	0	0	0	0
Projected on hand inventory: 10	50	30	10	110	80	50	0	0
Planned order receipt	0	0	0	115	0	0	0	50