See the tab marked Dataset 1 on Spreadsheet. This represents sales data for the past 50 days for bottles of Brambles juice at a grocery store. Replenishment from a nearby warehouse occurs every 10 days. It takes 3 days from the time an order is placed to the time of replenishment. This replenishment period is represented by the cells highlights in green. The grocery stores safety stock of Brambles juice must last for all three days, and so it therefore must take all three days worth of demand into account. Assume that the standard deviation of demand for Brambles Juice is 11.09 bottles. In order to have a service level of 95% during the replenishment period, how many bottles of juice should the store keep in safety stock?

Hint: In times like this, it is important to think about the data you have vs. the data you need. You may not need to use all of the data you have available for a calculation. Remember that for safety stock, you are really only concerned with the demand faced during the three days of the replenishment period!

HN 3