Use of Microsoft Excel is allowed.

Monte Carlo Simulation The manager of computer world, a store that sells computers and related equipment, is attempting to determine how many laptops the store should order each week. A laptop sells gives the profit of Php 5,000.00. The number of laptop demanded each week ranges from 0 to 4. From past sales records, the manager has determined probability of demand for laptops for the past 100 weeks. Demand: 0 1 2 3 4 Frequency: 20 40 20 10 10 Total = 100 Simulate the demand of 15 weeks from the following random numbers: 39, 45, 72, 53, 37, 02, 87, 98, 10, 47, 93, 21, 95, 15, 69. Create a Monte Carlo Simulation for the problem. What is the average sales, average profit for the 15 week period. Determine the risk factor for the company