Complete the spreadsheets in the homework workbook by using the formulas throughout the textbook to calculate the required numerical values. You should also manually double$-$check your answers. The yellow$-$colored spreadsheet cells contain the problem data. Fill in the light blue colored cells in order to complete the spreadsheets.The numerical values for the demand have been changed from the ones shown in the textbook.There are some videos in the Ch $13$ Videos folder that show how these aggregate planning spreadsheets are organized. Problem $1$: Level Aggregate Plan Using Inventories and BackordersThe average demand per period is an exact whole number; for example, $100\mathrm{.}000$ rather than $100\mathrm{.}05.$ As a result, the ending inventory and the number of backorders for period $6$ should be zero. You can use this fact as a check to verify that your calculations are correct.Ch