Question

One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F.

     Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks.

     Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and F; lots of size 65, 65, and 180 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 12, 80, and 150, respectively; all other items have zero beginning inventory. We are scheduled to receive 9 units of A in Week 2, 50 units of E in Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If 35 units of A are required in Week 8, use the low-level-coded bill of materials to find the necessary planned order releases for all components.

Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank - be certain to enter "0" wherever required.)

	Period	1	2	3	4	5	6	7	8
Item A 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 = 12 LT = 1 SS = 0 Q = 65	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item B OH = 0 LT = 1 SS = 0 Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item D OH = 0 LT = 2 SS = 0 Q = 65	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item E OH = 80 LT = 1 SS = 0 Q = 180	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases
Item F OH = 150 LT = 1 SS = 0 Q = L4L	Gross requirements
	Scheduled receipts
	Projected available balance
	Net requirements
	Planned order receipts
	Planned order releases

Answer 1

Solution :

A, LT - 2, Lot - L4L	On Hand	1	2	3	4	5	6	7	8	Total
Gross Requirements		0	0	0	0	0	0	0	35	35
Scheduled Receipts		0	9	0	0	0	0	0	0
Projected On Hand	0	0	9	9	9	9	9	9	0
Net requirements		0	0	0	0	0	0	0	26
Planned order receipts		0	0	0	0	0	0	0	26
Planned order releases		0	0	0	0	0	26	0	0
C, LT - 1, Lot - 65	On Hand	1	2	3	4	5	6	7	8	Total
Gross Requirements		0	0	0	0	0	26	0	0	26
Scheduled Receipts		0	0	0	0	0	0	0	0
Projected On Hand	12	12	12	12	12	12	51	51	51
Net requirements		0	0	0	0	0	14	0	0
Planned order receipts		0	0	0	0	0	65	0	0
Planned order releases		0	0	0	0	65	0	0	0
B, LT - 1, Lot - L4L	On Hand	1	2	3	4	5	6	7	8	Total
Gross Requirements		0	0	0	0	65	78	0	0	143
Scheduled Receipts		0	0	0	0	0	0	0	0
Projected On Hand	0	0	0	0	0	0	0	0	0
Net requirements		0	0	0	0	65	78	0	0
Planned order receipts		0	0	0	0	65	78	0	0
Planned order releases		0	0	0	65	78	0	0	0
D, LT - 2, Lot - 65	On Hand	1	2	3	4	5	6	7	8	Total
Gross Requirements		0	0	0	65	78	52	0	0	195
Scheduled Receipts		0	0	0	0	0	0	0	0
Projected On Hand	0	0	0	0	0	52	0	0	0
Net requirements		0	0	0	65	78	0	0	0
Planned order receipts		0	0	0	65	130	0	0	0
Planned order releases		0	65	130	0	0	0	0	0
E, LT - 1, Lot - 180	On Hand	1	2	3	4	5	6	7	8	Total
Gross Requirements		0	0	0	130	286	0	0	0	416
Scheduled Receipts		50	0	0	0	0	0	0	0
Projected On Hand	80	130	130	130	0	74	74	74	74
Net requirements		0	0	0	0	286	0	0	0
Planned order receipts		0	0	0	0	360	0	0	0
Planned order releases		0	0	0	360	0	0	0	0
F, LT - 1, Lot - L4L	On Hand	1	2	3	4	5	6	7	8	Total
Gross Requirements		0	0	0	360	0	0	0	0	360
Scheduled Receipts		50	0	0	0	0	0	0	0
Projected On Hand	150	200	200	200	0	0	0	0	0
Net requirements		0	0	0	160	0	0	0	0
Planned order receipts		0	0	0	160	0	0	0	0
Planned order releases		0	0	160	0	0	0	0	0