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.

A replenishment order of 100 is needed to satisfy the demand for the next 3 periods. If 10 items are left from the initial inventory, subtract the 10 items and order 90 (i.e., POQ=10010=90 ). At the end of the demand period, there should be no items left in inventory. This minimizes the number of items carried in inventory. A replenishment order of 100 is needed to satisfy the demand for the next 3 periods. If 10 items are left from the initial inventory, subtract the 10 items and order 90 (i.e., POQ=10010=90 ). At the end of the demand period, there should be no items left in inventory. This minimizes the number of items carried in inventory