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

60

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

​Item: Driveshaft subassembly						Lot​ Size: FOQequals=60 units
						Lead​ Time: 3 weeks
		Week
		1	2	3	4	5	6	7	8
Gross requirements		30	20	20	25	50	50	55	55
Scheduled receipts		70
Projected​ on-hand inventory	10
Planned receipts

Complete the last three rows of the record by using the L4L​ lot-sizing rule. ​(Enter your responses as integers. A response of​ "0" is equivalent to being not​ applicable.)

Answer 1

steps for MRP

repeat these steps for every period
step 1	IOH=	PIOH of last week
step 2	Requirement=	GR-IOH-SR+SS
step 3	NR=	is equal to requirement (if requirement>0) OR 0 (if requirement is negative)
step 4	PR=	in L4L PR=NR	in FOQ: more than or equal to NR in multiples of lot size
step 5	PIOH=	IOH+PR-GR-SR

A: FOQ based MRP

safety stock, SS=	0
Beginning inventory=	10
Q=	60
	1	2	3	4	5	6	7	8
Gross requirements GR	30	20	20	25	50	50	55	55
Scheduled receipts SR	70	0	0	0	0	0	0	0
On hand at the beginning of period IOH	10	50	30	10	45	55	5	10
Requirement	-50	-30	-10	15	5	-5	50	45
Net requirements NR	0	0	0	15	5	0	50	45
Planned order receipts (PR)	0	0	0	60	60	0	60	60
Projected inventory on hand PIOH	50	30	10	45	55	5	10	15

B: L4L based MRP

safety stock, SS=	0
Beginning inventory=	10
Q=	L4L
	1	2	3	4	5	6	7	8
Gross requirements GR	30	20	20	25	50	50	55	55
Scheduled receipts SR	70	0	0	0	0	0	0	0
On hand at the beginning of period IOH	10	50	30	10	0	0	0	0
Requirement	-50	-30	-10	15	50	50	55	55
Net requirements NR	0	0	0	15	50	50	55	55
Planned order receipts (PR)	0	0	0	15	50	50	55	55
Projected inventory on hand PIOH	50	30	10	0	0	0	0	0