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

Another question on Business

Business, 22.06.2019 10:50

Kimberly has been jonah in preparing his personal income tax forms for a couple of years. jonah's boss recommended kimberly because she had done a good job setting up the company's new accounting system. jonah is very satisfied with kimberly's work and feels that the fees she charges are quite reasonable. kimberly would be classified as a(n) (a) independent auditor (b) private accountant (c) public accountant (d) accounting broker

Answers: 1

Answer

Business, 22.06.2019 15:30

Brenda wants a new car that will be dependable transportation and look good. she wants to satisfy both functional and psychological needs. true or false

Answers: 1

Answer

Business, 23.06.2019 03:20

Georgia orchards produced a good crop of peaches this year. after preparing the following income statement, the company is concerned about the net loss on its no. 3 peaches. georgia orchards income statement for year ended december 31, 2017 no. 1 no. 2 no. 3 combined sales (by grade) no. 1: 300,000 ibs. @ $1.50/lb $ 450,000 no. 2: 300,000 ibs. @ $1.00/lb $ 300,000 no. 3: 750,000 ibs. @ $0.25/lb $ 187,500 total sales $ 937,500 costs tree pruning and care @ $0.30/ib 90,000 90,000 225,000 405,000 picking, sorting, and grading @ $0.15/ib 45,000 45,000 112,500 202,500 delivery costs 15,000 15,000 37,500 67,500 total costs 150,000 150,000 375,000 675,000 net income (loss) $ 300,000 $ 150,000 $ (187,500 ) $ 262,500 in preparing this statement, the company allocated joint costs among the grades on a physical basis as an equal amount per pound. the company’s delivery cost records show that $30,000 of the $67,500 relates to crating the no. 1 and no. 2 peaches and hauling them to the buyer. the remaining $37,500 of delivery costs is for crating the no. 3 peaches and hauling them to the cannery. required: 1. prepare reports showing cost allocations on a sales value basis to the three grades of peaches. separate the delivery costs into the amounts directly identifiable with each grade. then allocate any shared delivery costs on the basis of the relative sales value of each grade. (do not round intermediate calculations.)

Answers: 1

Answer

Business, 23.06.2019 10:00

In two or three sentences describe how open market

Answers: 1

Answer

You know the right answer?

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

Questions