Business, 25.02.2021 18:10 treestump090

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 10 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

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 15:50

Aceramics manufacturer sold cups last year for $7.50 each. variable costs of manufacturing were $2.25 per unit. the company needed to sell 20,000 cups to break even. net income was $5,040. this year, the company expects the price per cup to be $9.00; variable manufacturing costs to increase 33.3%; and fixed costs to increase 10%. how many cups (rounded) does the company need to sell this year to break even?

Answers: 2

Answer

Business, 21.06.2019 22:30

Jade international is a highly diversified global firm with headquarters in new jersey. it manufactures a variety of products ranging from home security systems to automotive components. jade's 100,000 employees work at facilities located in more than 60 countries around the world. jade frequently sends american managers overseas to manage the firm's foreign facilities. the hr department is considering the idea of redesigning jade's expatriate support services program.which of the following, if true, best supports jade's decision to provide assistance to trailing spouses in finding jobs overseas? a) jade puts great emphasis on promoting the role of women in global management.b) the majority of jade's expatriate managers have long-term international experience.c) jade has lost a significant chunk of its global cadre in the recent past owing to its failure to offer feasible options to address the dual-career couples dilemma.d) female managers at jade have reported discriminatory treatment while on overseas assignments.

Answers: 1

Answer

Business, 22.06.2019 10:10

An investment offers a total return of 18 percent over the coming year. janice yellen thinks the total real return on this investment will be only 14 percent. what does janice believe the inflation rate will be over the next year?

Answers: 3

Answer

Business, 22.06.2019 10:30

The card shoppe needs to maintain 21 percent of its sales in net working capital. currently, the store is considering a four-year project that will increase sales from its current level of $349,000 to $408,000 the first year and to $414,000 a year for the following three years of the project. what amount should be included in the project analysis for net working capital in year 4 of the project?

Answers: 3

Answer

You know the right answer?

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

Questions