Question

Please help me correct this question. Thanks

Problem 9-15 One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times, and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 20, 40, and 160 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 5, 10, 100, and 100, respectively; all other items have zero beginning inventories. We are scheduled to receive 10 units of Ain Week 3, 20 units of B in Week 7, 40 units of F in Week 5, and 60 units of E in Week 2; there are no other scheduled receipts. If 20 units of A are required in Week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned order releases for all components. (Leave no cells blank - be certain to enter "0" wherever required.) 2 4 5 7 8 10 20 0 0 0 0 0 ol 0 0 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 10 15 0 15 15 Item A OH = 5 LT = 2 SS = 0 Q = 20 15 5 0 >>>>>> 15 0 0 15 0 0 15 0 15 5 20 0 ✓ 0 0 0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 20 0 0 0 0 0 0 0 0 0 Item C OH = 0 LT = 1 SS = 0 Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 x 0 20 20 0 0 0 01 0 0 0 0 201 0 X 0 0 0 0 0 40 ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ 0 01 0 0 0 ol 0 0 0 0 0 0 0 0 0 10 10 OOOOOOOOOOOOOOO 10 10 40 Item B OH = 10 LT = 2 SS = 0 Q = 40 40 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases оооооо 10 0 601 20 10 30 % 0 401 0 0 0 40 40 0 OOOOOOOOOOOOOOOOOO 0 0 0 0 0 0 0 0 0 0 OOO OOOOO ® ® ® ® 10 la pololololo 40 0 0 0 0 40 elop pollo 0 ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܘ ܀ 0 0 0 0 0 140 0 0 0 0 0 BOOOOOOOOOOOOOOOOOOOOOOO 0 0 0 100 0 1401 100 100 0 0 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item D OH = 100 LT = 3 SS = 0 Q = 160 120 0 100 % 20 160 0 0 0 100 0 0 160 0 0 0 0 01 0 0 0 0 0 0 0 0 0 0 0 0 401 0 0 0 0 0 40 0 0 40 0 401 0 0 Item F OH = 0 LT = 2 SS = 0 Q = L4L 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 40 401 ol 0 0 0 0 0 0 0 0 0 0 40 0 0 0 BOOOOOOOOOOO 0 160 0 801 0 0 0 0 60 x x 0 0 0 0 E 100 0 Item E OH = 100 LT = 2 SS = 0 Q = L4L 0 160 0 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 801 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80 0 0 0 0 80 0 0 0 0 0

Answer 1

		Week		1	2	3	4	5	6	7	8	9	10
Item:	A	Gross requirements		0	0	0	0	0	0	0	0	0	20
OH =	5	Scheduled receipts		0	0	10	0	0	0	0	0	0	0
LT =	2	Projected available balance	5	5	5	15	15	15	15	15	15	15	15
SS =	0	Net requirements		0	0	0	0	0	0	0	0	0	5
Q =	20	Planned order receipts		0	0	0	0	0	0	0	0	0	20
		Planned order releases		0	0	0	0	0	0	0	20	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	C	Gross requirements		0	0	0	0	0	0	0	20	0	0
OH =	0	Scheduled receipts		0	0	0	0	0	0	0	0	0	0
LT =	1	Projected available balance	0	0	0	0	0	0	0	0	0	0	0
SS =	0	Net requirements		0	0	0	0	0	0	0	20	0	0
Q =	L4L	Planned order receipts		0	0	0	0	0	0	0	20	0	0
		Planned order releases		0	0	0	0	0	0	20	0	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	B	Gross requirements		0	0	0	0	0	0	60	40	0	0
OH =	10	Scheduled receipts		0	0	0	0	0	0	20	0	0	0
LT =	2	Projected available balance	10	10	10	10	10	10	10	10	10	10	10
SS =	0	Net requirements		0	0	0	0	0	0	30	30	0	0
Q =	40	Planned order receipts		0	0	0	0	0	0	40	40	0	0
		Planned order releases		0	0	0	0	40	40	0	0	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	D	Gross requirements		0	0	0	0	120	120	20	0	0	0
OH =	100	Scheduled receipts		0	0	0	0	0	0	0	0	0	0
LT =	3	Projected available balance	100	100	100	100	100	140	20	0	0	0	0
SS =	0	Net requirements		0	0	0	0	20	0	0	0	0	0
Q =	160	Planned order receipts		0	0	0	0	160	0	0	0	0	0
		Planned order releases		0	160	0	0	0	0	0	0	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	F	Gross requirements		0	0	0	0	40	40	0	0	0	0
OH =	0	Scheduled receipts		0	0	0	0	40	0	0	0	0	0
LT =	2	Projected available balance	0	0	0	0	0	0	0	0	0	0	0
SS =	0	Net requirements		0	0	0	0	0	40	0	0	0	0
Q =	L4L	Planned order receipts		0	0	0	0	0	40	0	0	0	0
		Planned order releases		0	0	0	40	0	0	0	0	0	0
		Week		1	2	3	4	5	6	7	8	9	10
Item:	E	Gross requirements		0	160	0	0	0	0	80	0	0	0
OH =	100	Scheduled receipts		0	60	0	0	0	0	0	0	0	0
LT =	2	Projected available balance	100	100	0	0	0	0	0	0	0	0	0
SS =	0	Net requirements		0	0	0	0	0	0	80	0	0	0
Q =	L4L	Planned order receipts		0	0	0	0	0	0	80	0	0	0
		Planned order releases		0	0	0	0	80	0	0	0	0	0