indu 423 labThe table in Sheet Q1 provides daily data regarding the inventory movement of a product for a six month period. For any given date the table provides information on the observed demand, whether an order placed or received from the supplier, end of day on-hand inventory level, and end of day backorder level. Using excel functions (including lookup&reference), extract the following information from this data set. a. Average and standard deviation of on-hand inventory and backorder levels. b. The dates and values when maximum on hand inventory and maximum backorder levels are observed. c. The fraction of the days that the on- hand inventory and backorder levels are more than their "average + 1*standard deviation". (Calculate for on-hand inventory and backorder levels separately) d. The fraction of the days the item was out of stock over this period. e. The fraction of the demand that is satisfied from available inventory. f. The average daily demand