Suppose the first 100 consumers arrive at a retail store according to a Poisson(5/hour) distribution; so interarrival times are Exponential(5/hour). The first consumer is assumed to have arrived at time 0. From the 101" consumer to the 500h one, the arrival rate increases by 0.25% for every new arrival. Each customer makes a purchasing decision (to choose to purchase being success) according to a Bernoulli(P) distribution, where P is 0.5 for the first 100 customers and it increases by 0.00125 for every additional customer after the 100th one. Once a consumer chooses to buy something, the number of items she buys follow a Binomial(10,0.4) distribution. Your first task is to recreate this story on an Excel or Calc spreadsheet. Note that your simulated numbers must be renewing every time the F9 key is pressed, i.e., the numbers must not be fixed as values. Once you're done with your design, prepare proper graphs of: (1) Number of total arrivals against time (2) Number of total purchase decisions against time (3) Number of total items sold against time Suppose the first 100 consumers arrive at a retail store according to a Poisson(5/hour) distribution; so interarrival times are Exponential(5/hour). The first consumer is assumed to have arrived at time 0. From the 101" consumer to the 500h one, the arrival rate increases by 0.25% for every new arrival. Each customer makes a purchasing decision (to choose to purchase being success) according to a Bernoulli(P) distribution, where P is 0.5 for the first 100 customers and it increases by 0.00125 for every additional customer after the 100th one. Once a consumer chooses to buy something, the number of items she buys follow a Binomial(10,0.4) distribution. Your first task is to recreate this story on an Excel or Calc spreadsheet. Note that your simulated numbers must be renewing every time the F9 key is pressed, i.e., the numbers must not be fixed as values. Once you're done with your design, prepare proper graphs of: (1) Number of total arrivals against time (2) Number of total purchase decisions against time (3) Number of total items sold against time