he

Susan's Home Furnishings produces end tables. Each end table costs Susan $65 and sells for $125. Monthly demand for the end table is described by a normal probability distribution with a mean of 90 units and a standard deviation of 10 units. Susan receives monthly deliveries from their supplier and replenishes their inventory to a level of Q at the beginning of each month, keeping in mind that you only want to replenish what you have sold. This beginning inventory level is referred to as the replenishment level. If monthly demand is less than the replenishment level, an inventory holding cost of $15 is charged to each table that is not sold. However, if monthly demand is greater than the replenishment level, an out of stock situation occurs and a shortage cost of $20 is charged for each demanded table that cannot be satisfied. Susan would like to use a simulation model to determine the average monthly net profit resulting from the following replenishment levels: 70,75,80,85,90,95,100,105,110,115,120,125,130. Referring to the image below, what formula should go in cell A18? =