For each day over the last year data is available $($in the spreadsheet Problem $1$ in the

ISE$362$F$2023\_$HW$2$Data.xlsx file$)$ on the beginning of day inventory of a particular SKU $($column

B$)$ and the sales during the corresponding day $($column C$).$

$1.$ Determine the minimum and maximum inventory levels.

$2.$ Determine the minimum and maximum daily sales.

$3.$ Determine the number of occurrences of each inventory level.

$4.$ Compute the frequency of each inventory level.

$5.$ Compute the probability that the inventory level is greater than $15.$

$6.$ Compute the expected inventory level.

$7.$ Compute the expected inventory holding cost per year $($based on beginning of day

inventory$)$ if the inventory carrying cost is $20\%$ per year and the average cost of an item

is $$22\mathrm{.}50.$

$8.$ Compute the expected sales per day.

$9.$ How many days were there potentially lost sales due to insufficient inventory?

$10.$ Determine an estimate of the average of actual daily demand? Describe different ways

you can think of estimate actual demand and illustrate with the available data.