Complete the spreadsheets in the homework workbook by manually calculating the required numerical values. The yellow-colored spreadsheet cells contain the problem data. Fill in the light blue colored cells in order to complete the spreadsheets.

 
 

Transcribed Image Text:

A 1 2 Item: AB500 3 Lot size rule: Lot for Lot (L4L) 4 Lead Time: 2 Weeks 5 6 Gross Requirements 7 Scheduled Receipts 8 Planned Order Receipts 9 Projected Available: 0 10 Planned Orders 11 12 13 14 15 16 Item: AB501 17 Lot size rule: Lot for Lot (L4L) 18 Usage Factor: 2 19 20 Gross Requirements 21 Scheduled Receipts 22 Planned Order Receipts 23 Projected Available: 24 Planned Orders 25 1100 26 Item: AB511 27 Lot size rule: Fixed Order Quant (FOQ): 28 Usage Factor: 1 29 30 Gross Requirements 31 Scheduled Receipts 32 Planned Order Receipts 33 Projected Available: 34 Planned Orders 650 B C D 1 Parent: None Children: AB501, AB511, AB521 2 Lead Time: 2 Weeks Parent: AB500 Children: None 1 2 Lead Time: 3 Weeks E 350 Parent: AB500 Children: None 1 2 3 200 3 3 LL F 4 200 4 G 4 5 200 The planned orders row become the gross requirements row for each of their children. 5 H 5 6 250 6 7 250 6 7 7 J 8 300 8 8 K 9 200 9 9 L 10 250 10 10 BE A 1 2 Item: AB500 3 Lot size rule: Lot for Lot (L4L) 4 Lead Time: 2 Weeks 5 6 Gross Requirements 7 Scheduled Receipts 8 Planned Order Receipts 9 Projected Available: 0 10 Planned Orders 11 12 13 14 15 16 Item: AB501 17 Lot size rule: Lot for Lot (L4L) 18 Usage Factor: 2 19 20 Gross Requirements 21 Scheduled Receipts 22 Planned Order Receipts 23 Projected Available: 24 Planned Orders 25 1100 26 Item: AB511 27 Lot size rule: Fixed Order Quant (FOQ): 28 Usage Factor: 1 29 30 Gross Requirements 31 Scheduled Receipts 32 Planned Order Receipts 33 Projected Available: 34 Planned Orders 650 B C D 1 Parent: None Children: AB501, AB511, AB521 2 Lead Time: 2 Weeks Parent: AB500 Children: None 1 2 Lead Time: 3 Weeks E 350 Parent: AB500 Children: None 1 2 3 200 3 3 LL F 4 200 4 G 4 5 200 The planned orders row become the gross requirements row for each of their children. 5 H 5 6 250 6 7 250 6 7 7 J 8 300 8 8 K 9 200 9 9 L 10 250 10 10 BE