Door-to-Door Marketing. A small nonprofit organization is planning a door-to-door marketing campaign to sell Christmas wrapping and gifts. They plan to visit 100 homes. Consultant estimate that they should expect to find someone at home 80 percent of the time. When someone is at home, 65% of the time is a female. 30% of females make a purchase, and when they do so the dollar value of their purchase is normally distributed with a mean of $22 and a standard deviation of $5. Males purchase 20% of the time, and the dollar value of their purchase is normally distributed with a mean of $28 and standard deviation of $3.

a. Build a basic model in excel (without simulation).

b. Build simulation model in excel.

c. In simulation model, what is the expected total amount they can get in revenues from 100 visits?

d. In simulation model, what is the standard deviation of the total revenues over 100 visits?

e. In simulation model, what is the probability they will make more than $630?