The areas that need to filled are gray marked.

Please use excel formulations except planned order release information.

1 2 Inventory Lot size Pr.LT 130 100 1 3 4 5 4 9 21 30 1 20 0 110 Period Actual Orders Forecast On Hand Before Production Production Projected Inv. 3 30 0 so 7 0 50 51 0 30 (15) 100 85 10 0 30 15 20 15 100 0 80 8 0 50 (155) 6 0 40 (55) 100 155 0 60 (2151 10 (245 80 sa 20 215 165 115 S5 150 Lot Size 200 Lead Time 1 On Hand Back Assembly Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Release 100 0 100 0 100 0 0 0 ol ol ol 0 G 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 0 300 Lot Size 200 Lead Time On Hand Horizantal Supports 21 Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Release 0 0 0 ol 01 0 0 0 ol 0 200 Lot Size 200 Lead Time 0 On Hand Vertical Supports 31 Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Release ol 0 0 0 ol 0 0 0 0 31 32 33 34 35 36 37 0 2 3 4 Chair Leg Assembly(2) Seat Back Assembly Legs (2) Crossbar Side Rails Horizontal Supports (2) Vertical Support(3) 12 13 14 15 16 17 18 BOM 1 2 Inventory Lot size Pr.LT 130 100 1 3 4 5 4 9 21 30 1 20 0 110 Period Actual Orders Forecast On Hand Before Production Production Projected Inv. 3 30 0 so 7 0 50 51 0 30 (15) 100 85 10 0 30 15 20 15 100 0 80 8 0 50 (155) 6 0 40 (55) 100 155 0 60 (2151 10 (245 80 sa 20 215 165 115 S5 150 Lot Size 200 Lead Time 1 On Hand Back Assembly Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Release 100 0 100 0 100 0 0 0 ol ol ol 0 G 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 0 300 Lot Size 200 Lead Time On Hand Horizantal Supports 21 Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Release 0 0 0 ol 01 0 0 0 ol 0 200 Lot Size 200 Lead Time 0 On Hand Vertical Supports 31 Gross Requirements Scheduled Receipts Projected Available Net Requirements Planned Order Release ol 0 0 0 ol 0 0 0 0 31 32 33 34 35 36 37 0 2 3 4 Chair Leg Assembly(2) Seat Back Assembly Legs (2) Crossbar Side Rails Horizontal Supports (2) Vertical Support(3) 12 13 14 15 16 17 18 BOM