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 01:00

The following account balances at the beginning of january were selected from the general ledger of fresh bagel manufacturingâ€‹ company: work in process inventory â€‹$0 raw materials inventory $ 29 comma 000 finished goods inventory $ 40 comma 900 additionalâ€‹ data: 1. actual manufacturing overhead for january amounted to $ 62 comma 600. 2. total direct labor cost for january was $ 63 comma 600. 3. the predetermined manufacturing overhead rate is based on direct labor cost. the budget for the year called for $ 255 comma 000 of direct labor cost and $ 382 comma 500 of manufacturing overhead costs. 4. the only job unfinished on january 31 was job no.â€‹ 151, for which total direct labor charges were $ 5 comma 700 â€‹(1 comma 000 direct laborâ€‹ hours) and total direct material charges were $ 14 comma 400. 5. cost of direct materials placed in production during january totaled $ 123 comma 300. there were no indirect material requisitions during january. 6. january 31 balance in raw materials inventory was $ 35 comma 200. 7. finished goods inventory balance on january 31 was $ 35 comma 400. what is the cost of goods manufactured forâ€‹ january

Answers: 1

Answer

Business, 22.06.2019 11:30

(select all that apply) examples of email use that could be considered unethical include denying receiving an e-mail requesting that you work late forwarding a chain letter asking for donations to a good cause sending a quick message to your friend about last weekend sending your boss the monthly sales figures in an attachment setting up a meeting with your co-worker sharing a funny joke with other employees

Answers: 2

Answer

Business, 22.06.2019 12:20

Selected transactions of the carolina company are listed below. classify each transaction as either an operating activity, an investing activity, a financing activity, or a noncash activity. 1. common stock is sold for cash above par value. 2. bonds payable are issued for cash at a discount

Answers: 2

Answer

Business, 22.06.2019 22:40

Johnson company uses the allowance method to account for uncollectible accounts receivable. bad debt expense is established as a percentage of credit sales. for 2018, net credit sales totaled $6,400,000, and the estimated bad debt percentage is 1.40%. the allowance for uncollectible accounts had a credit balance of $61,000 at the beginning of 2018 and $49,500, after adjusting entries, at the end of 2018.required: 1. what is bad debt expense for 2018 as a percent of net credit sales? 2. assume johnson makes no other adjustment of bad debt expense during 2018. determine the amount of accounts receivable written off during 2018.3. if the company uses the direct write-off method, what would bad debt expense be for 2018?

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