Enter formulas to add the following calculations to the Inventory worksheet:a$.$ In the range G$10$:G$391,$ calculate the value of each item in the warehouse inventory by mul$-$tiplying the item$$s unit price by the quantity in stock.b$.$ In the range I$10$:I$391,$ calculate the difference between the Quantity in Stock values in column F and the Reorder at Quantity values in column H to determine whether items have dropped below the automatic reorder level. c$.$ In cell B$5,$ use the COUNT function to count the values in column F to calculate the total number of items in the warehouse. Use the range reference F:F to reference the entire column.d$.$ In cell B$6,$ use the SUM function to sum the values in column G to calculate the total inventory value.e$.$ In cell B$7,$ use the AVERAGE function to average the values in column J to determine the average days to reorder new items.