Business, 23.09.2021 03:30, ninaaforever

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. Consultants have estimated that they should expect to find someone home 80 percent of the time. When someone is home, 65 percent of the time it is a female. Thirty percent 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 percent of the time, and the dollar value of their purchase is normally distributed with a mean of $28 and a standard deviation of $3. a. What is the total amount they can expect to generate in revenues from these 10 visits?
b. What is the standard deviation of total revenues over 10 visits?
c. What is the probability they will make more than $750?
PLEASE USE SOLVER FOR EXCEL. That is what I am using and my answer doesn't make any sense!
Currently, I have
visit someone answers female male purchase by female purchase by male Female Purchase Amount Male Purchase Amount
1 IF(RAND()<=0.2,1,0) B2IF(RAND()<=0.65,1,0) B2(1-C2) C2IF(RAND()<=0.3,1,0) D2IF(RAND()<=0.2,1,0) IF(E2=1, PsiNormal(22,5), 0) IF(F2=1, PsiNormal(28,3),0)
2 1 0 1 0 0 $0.00 $0.00
3 1 1 0 0 0 $0.00 $0.00
4 1 1 0 0 0 $0.00 $0.00
5 1 0 1 0 0 $0.00 $0.00
6 1 1 0 0 0 $0.00 $0.00
7 1 1 0 0 0 $0.00 $0.00
8 1 1 0 0 0 $0.00 $0.00
9 1 1 0 0 0 $0.00 $0.00
10 1 1 0 0 0 $0.00 $0.00
TOTAL SUM(G2:H11)+PsiOutput()

Answers: 2

Show answers

Other questions on the subject: Business

Business, 22.06.2019 20:20, isabelperez063

Why is it easier for new entrants to get involved in radical innovations when compared to incumbent firms? a. unlike incumbent firms, new entrants do not have to face the high entry barriers, initially. b. new entrants are embedded in an innovation ecosystem, while incumbent firms are not. c. unlike incumbent firms, new entrants do not have formal organizational structures and processes. d. incumbent firms do not have the advantages of network effects that new entrants have.

Answers: 2

continue

Business, 22.06.2019 20:40, julio38

If the ceo of a large, diversified, firm were filling out a fitness report on a division manager (i. e., "grading" the manager), which of the following situations would be likely to cause the manager to receive a better grade? in all cases, assume that other things are held constant. a. the division's basic earning power ratio is above the average of other firms in its industry. b. the division's total assets turnover ratio is below the average for other firms in its industry. c. the division's debt ratio is above the average for other firms in the industry. d. the division's inventory turnover is 6, whereas the average for its competitors is 8.e. the division's dso (days' sales outstanding) is 40, whereas the average for its competitors is 30.

Answers: 1

continue

Business, 22.06.2019 21:00, crazylogic963

China's new 5 percent tax on disposable wooden chopsticks, reflecting concerns about deforestation, has been praised by environmentalists. the move is hitting hard at the japanese, who consume 25 billion set of wooden chopsticks annually. almost all of the chopsticks used in japan come from china. the reuirements for chinese manufacturers of wooden chopsticks to pay the 5 percent tax is a factor in their external environment.

Answers: 3

continue

Business, 22.06.2019 21:20, danielahumajova6

In a market economy, supply and demand are important because theya. (i) play a critical role in the allocation of the economy's scarce resources. b. (ii) determine how much of each good gets produced. c. (iii) can be used to predict the impact on the economy of various events and policies. d. all of (i), (ii), and (iii) are correct.

Answers: 3

continue

Do you know the correct answer?

Door-to-Door Marketing. A small nonprofit organization is planning a door-to-door marketing campaign...