Let us consider a buyer for a department store who is ordering fashion swimwear about 6 months before the summer season. The store plans to hold an August clearance sale to sell any surplus goods by July 31. Each piece costs $44 per pair and sells for $64 per pair. At the sale price of $32 per pair, it is expected that any remaining stock can be sold during the August sale. We will assume that a uniform probability distribution ranging from 350 to 690 items describes the demand. The expected demand is 520 and the standard deviation of demand is 60. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Single Period Inventory Model Item cost $44.00 Selling price $64.00 Sale price $32.00 Formulas Salvage cost, Cs #N/A Shortage cost, Cu #N/A P(demand