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, 22.06.2019 13:40

A.j. was a newly hired attorney for idle time gaming, inc. even though he reported directly to the president of the company, a.j. noticed that the president always had time to converse with the director of sales, calling on him to get a pulse on legal/regulatory issues that, as the company attorney, a.j. could have probably handled. a.j. also noted that the hr manager’s administrative assistant was the go-to person for a number of things that would make life easier at work. a.j. was recognizing the culture at idle time gaming.

Answers: 3

Answer

Business, 22.06.2019 20:40

David consumes two things: gasoline (g) and bread (b). david's utility function is u(g, b) = 10g^0.25 b^0.75. use the lagrange technique to solve for david's optimal choices of gasoline and bread as a function of the price of gasoline, p_g, the price of bread, p_b, and his income m. with recent decrease in the price of gasoline (maybe due to external shock such as shale gas production) does david increase his consumption of gasoline? for david, how does partial differential g/partial differential p_g depend on his income m? that is, how does david's change in gasoline consumption due to an increase in the price of gasoline depend on his income level? to answer these questions, find the cross-partial derivative, |partial differential^2 g/partial differential m partial differential p_g.

Answers: 1

Answer

Business, 23.06.2019 01:50

Describe two (2) financial career options that an individual with a finance education might pursue and explain the value that such a position adds to a company. explain the essential skills that would make a person successful in each of the described positions. recommend one (1) of the career options. identify the most attractive features of the position.

Answers: 2

Answer

Business, 23.06.2019 14:30

Xavier and shawn are co-owners of a party-planning business. they split all of the profits 50-50 and are able to make decisions that are binding on both parties. at one of their parties a guest is injured on a piece of equipment. the guest sues xavier and shawn, and they find they're personally liable for any damages. what kind of business structure do they have? question 8 options: sole proprietorship general partnership limited liability company corporation

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