Consider a retail store which sells a perishable good with a life of only one period. At the beginning of each period, the store in anticipation of demand, order Q pounds from a supplier at a cost of $75/lb. The demand (a continuous characteristic) is uncertain, but based on historical data, it follows a normal distribution with mean m= 300 and standard deviation s = 75. The retail price of this item is $95/lb. If demand exceeds Q, it is lost. In case the demand is less than Q, any unused amount is sold to a discount chain for a salvage value of $30/lb.

1. Design an EXCEL simulation model to simulate this system for 100 periods (you will create 100 rows in your EXCEL spreadsheet) to estimate the expected profit per period for the store if it decides to order 350 pound (that is, Q = 350) every period. Please Show me the Detailed Excel spreadsheet in the answer!
2. Experiment with your model (iteratively and systematically change the value of Q and rerun your simulation by clicking on F9) to determine the optimum Q for the store so as to maximize its expected profit per period.