Q#8: (20 pts) Monte Carlo Simulation by MS Excel. Please submit your Excel file together with your answer sheet. A convenient store newsstand orders 250 copies of USA Today daily. Primarily due to weather conditions, the demand for newspapers varies from day to day. The probability distribution of the demand for the newspaper is as follows: 150 175 200 225 250 Number of newspapers Frequency 0.10 0.30 0.30 0.20 0.10 The newsstand makes a 15-cents profit on every newspaper sold, but it loses 10 cents unsold by the end of the day. Use 10 days of simulated results in a spreadsheet to determine whether the newsstand should order 150, 200 or 250 papers per day. What is the average daily profit the newsstand can anticipate based on your recommendation? Q#8: (20 pts) Monte Carlo Simulation by MS Excel. Please submit your Excel file together with your answer sheet. A convenient store newsstand orders 250 copies of USA Today daily. Primarily due to weather conditions, the demand for newspapers varies from day to day. The probability distribution of the demand for the newspaper is as follows: 150 175 200 225 250 Number of newspapers Frequency 0.10 0.30 0.30 0.20 0.10 The newsstand makes a 15-cents profit on every newspaper sold, but it loses 10 cents unsold by the end of the day. Use 10 days of simulated results in a spreadsheet to determine whether the newsstand should order 150, 200 or 250 papers per day. What is the average daily profit the newsstand can anticipate based on your recommendation