Question

IT 6312 Fall 2020 (On-Line) (1) mework: Chapter 11 Homework Problems : 0 of 3 pts 6 of 6 (4 complete) lem 19 gure below shows a partially completed inventory record for the real wheel subassembly. Gross requirements, scheduled receipts, load time, and current on hand inventory are shown 9 10 Item: MQ-09 Lot Size: Description: Rear wheel Lead Time: 1 week subassembly Week 1 2 3 4 5 6 7 8 Gross requirements 75 85 90 80 10 15 110 40 Scheduled receipts Projected on-hand inventory 100 Planned receipts Planned order releases mplete the last three rows of the record for an FOQ of 200 units (Enter your responses as whole numbers. A response of Vis equivalent to benignol applicable) Item: MQ-09 Lot Size: FOQ=200 Description: Rear wheel Lead Time: 1 week subassembly Week 1 4 5 6 7. 8 Gross requirements 75 85 90 B0 10 15 110 40 Scheduled receipts Projected on hand inventory 100 Planned receipts 9 10 DE OD your answer in the edit fields and then click Check Answer arts emering Clear All Type here to search o 105 е

Answer 1

If you like my explanation, please give a "thumbs up"

A B c D E F G H 1 K L M N 1 2 3 4 6 7 9 10 1 75 2 85 8 40 4 90 80 10 15 110 5 Gross Requirements Scheduled Receipts Projected on-hand inventory Planned receipts 6 100 25 50 1600 145 35 195 195 140 200 170 200 195 200 7 8

For calculation ref:

А B с D E F H 1 J K L M 1 2 3 4 5 1 2 3 14 5 6 7 8 19 10 Gross Requirements 75 85 90 80 10 15 110 40 Scheduled Receipts Projected on-hand inventory 100 =C6+D7-D4 =D6+E7-E4 =E6+F7-F4 =F6+G7-G4 =G6+H7-H4 =H6+07-14 =16+J7-14 =J6+K7-K4 =K6+L7-L4 =L6+M7-M4 Planned receipts 200 200 200 6 7 8