Question

Please help me correct this question. Thanks

Problem 9-12 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 50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 150, respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of Ain Week 2,50 units of E in Week 1, and also 50 units of Fin Week 1. There are no other scheduled receipts. If 30 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 "O" wherever required.) 7 0 0 O 10 101 0 0 0 0 0 0 10 ol 0 8 30 0 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 10 10 10 10 Ol Item A OH = 0 LT = 2 SS = 0 Q = L4L 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 20 20 0 0 0 0 0 0 0 0 0 0 0 0 40 0 0 10 0 101 10 10 10 Item C OH = 10 LT = 1 SS = 0 Q = 50 40 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 20 0 40 10 50 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50 0 0 0 50 601 0 0 0 0 0 0 0 0 OOO Item B OH = 0 LT = 1 SS=0 Q=L4L 0 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 50 0 0 0 0 0 ol 0 60 60 0 0 50 0 0 ✓ 0 501 60 0 0 ✓ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ 0 160 & 0 ol 0 ✓ 0 0 0 01 0 40 50 0 0 501 40 Item D OH = 0 LT = 2 SS=0 Q = 50 40 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 01 ol 501 50 0 0 200 40 x 10 50 0 160 200 0 0 50 0 01 0 0 ol 0 220 OOOOOOOOOOOOO 0 0 50 1001 ol 0 100 1001 0 100 0 ol 0 0 180 0 180 0 0 1801 Item E OH = 50 LT = 1 SS=0 Q = 200 100 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 180 2201 OOOOOO 0 0 0 0 0 ✓ 0 0 0 400 400 0 0 0 0 0 0 0 V 0 0 0 0 ol 0 0 0 0 0 0 0 200 50 150 0 Item F OH = 150 LT = 1 SS = 0 Q=L4L 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 400 0 0 200 2001 2001 0 0 0 0 0 0 0 0 0 0 0 200 0 0 0 0 0 0 0

Answer 1

		Week		1	2	3	4	5	6	7	8
Item:	A	Gross requirements		0	0	0	0	0	0	0	30
OH =	0	Scheduled receipts		0	10	0	0	0	0	0	0
LT =	2	Projected available balance	0	0	10	10	10	10	10	10	0
SS =	0	Net requirements		0	0	0	0	0	0	0	20
Q =	L4L	Planned order receipts		0	0	0	0	0	0	0	20
		Planned order releases		0	0	0	0	0	20	0	0
		Week		1	2	3	4	5	6	7	8
Item:	C	Gross requirements		0	0	0	0	0	20	0	0
OH =	10	Scheduled receipts		0	0	0	0	0	0	0	0
LT =	1	Projected available balance	10	10	10	10	10	10	40	40	40
SS =	0	Net requirements		0	0	0	0	0	10	0	0
Q =	50	Planned order receipts		0	0	0	0	0	50	0	0
		Planned order releases		0	0	0	0	50	0	0	0
		Week		1	2	3	4	5	6	7	8
Item:	B	Gross requirements		0	0	0	0	50	60	0	0
OH =	0	Scheduled receipts		0	0	0	0	0	0	0	0
LT =	1	Projected available balance	0	0	0	0	0	0	0	0	0
SS =	0	Net requirements		0	0	0	0	50	60	0	0
Q =	L4L	Planned order receipts		0	0	0	0	50	60	0	0
		Planned order releases		0	0	0	50	60	0	0	0
		Week		1	2	3	4	5	6	7	8
Item:	D	Gross requirements		0	0	0	50	60	40	0	0
OH =	0	Scheduled receipts		0	0	0	0	0	0	0	0
LT =	2	Projected available balance	0	0	0	0	0	40	0	0	0
SS =	0	Net requirements		0	0	0	50	60	0	0	0
Q =	50	Planned order receipts		0	0	0	50	100	0	0	0
		Planned order releases		0	50	100	0	0	0	0	0
		Week		1	2	3	4	5	6	7	8
Item:	E	Gross requirements		0	0	0	100	220	0	0	0
OH =	50	Scheduled receipts		50	0	0	0	0	0	0	0
LT =	1	Projected available balance	50	100	100	100	0	180	180	180	180
SS =	0	Net requirements		0	0	0	0	220	0	0	0
Q =	200	Planned order receipts		0	0	0	0	400	0	0	0
		Planned order releases		0	0	0	400	0	0	0	0
		Week		1	2	3	4	5	6	7	8
Item:	F	Gross requirements		0	0	0	400	0	0	0	0
OH =	150	Scheduled receipts		50	0	0	0	0	0	0	0
LT =	1	Projected available balance	150	200	200	200	0	0	0	0	0
SS =	0	Net requirements		0	0	0	200	0	0	0	0
Q =	L4L	Planned order receipts		0	0	0	200	0	0	0	0
		Planned order releases		0	0	200	0	0	0	0	0