Question

Product A is an end item and is made from two units of B and three of C. B is made of four units of D and two of E. C is made of two units of F and two of E.

A has a lead time of one week. B, C, and E have lead times of two weeks, and D and F have lead times of three weeks.

b.	If 100 units of A are required in Week 10, develop the MRP planning schedule, specifying when items are to be ordered and received. There are currently no units of inventory on hand. (Leave no cells blank - be certain to enter "0" wherever required.)

	Period	1	2	3	4	5	6	7	8	9	10
Item A   OH = 0   LT = 1   SS = 0   Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item B   OH = 0   LT = 2   SS = 0   Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item C   OH = 0   LT = 2   SS = 0   Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item D   OH = 0   LT = 3   SS = 0   Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item E   OH = 0   LT = 2   SS = 0   Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item F   OH = 0   LT = 3   SS = 0   Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases

Answer 1