A supermarket uses a periodic review system to manage inventory of gallons of drinking water. Average demand is 152 gallons of water per day with standard deviation of 33 gallons per day. It costs $57 to order water from the supplier, and orders are delivered after 4 days. The holding cost for a gallon of water is $0.11 per year. The supermarket is open 360 days per year. If the supermarket aims for a 94.5% service level for gallons of drinking water (z = 1.6), what value should be used for T, the target inventory position at the time of ordering? The target inventory position is T= gallons.

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding