Weekly demand at a local convenience store for 1-gallon jugs of low-fat milk has varied between 55 to 70 jugs for some time now. Demand in excess of stock cannot be backordered. The store implements a fixed order strategy of 60 jugs every week. Simulate the demand for this item for 25 weeks, using the information found in the tables below. To help you through this process, utilize the Excel template, and utilize the random numbers that have already been generated (i.e. Rand Demand). DO NOT generate new random values for this simulation.
For the following problems use the Excel Template and look for "Milk Problem"
For your simulation, if a random number of 15% was generated for the weekly demand of milk, what value of demand would correspond to this random value?