Excel analytic solver platform to solve the question

Assignment Help Business Management

Reference no: EM131804570

By using Microsoft Excel's Analytic Solver Platform to solve the question below:

An organization is performing a door-to-door marketing campaign to sell goods to consumers. They will visit 30 homes. Consultants estimated they expect to find someone home 80% of the time. When someone is home 65% it is a female. 30% of females make a purchase, and when they make a purchase it is normally distributed with a mean of $22 and a standard deviation of $5. 20% of males make a purcahse, and when they do it is normall distributed with a mean of $28 and a standard deviation of $3.

1.) What is the total amount they can expect to generate in revenues from these 30 visits?

2.) What is the standard deviation of total revenues over 30 visits?

3.) What is the probability they will make more than 100?

Reference no: EM131804570

Questions Cloud

What the authors mean by diversion-oriented system : Demonstrate your understanding of what the authors mean by "diversion-oriented system" versus "punitive- or punishment-oriented system."

Create a prescriptive section of your playbook : Create a prescriptive section of your playbook providing guidelines to secure each of these areas - Network connections and Mobile devices

How stages of consumer involvement affect promotional mix : Discuss the AIDA concept. How do these different stages of consumer involvement affect the promotional mix?

Calculate the current and quick ratios : Garrett Company had current assets and current liabilities as follows: Calculate the current and quick ratios using the information provided

Excel analytic solver platform to solve the question : By using Microsoft Excel's Analytic Solver Platform to solve the question below:

Prepare the entry for the issuance : Prepare the entry for the issuance under the following assumptions

What is the probability they will make more than 100 : An organization is performing a door-to-door marketing campaign to sell goods to consumers.

How much federal income tax does he have to pay for the year : Included in that amount is $5,000 of qualified dividends. How much federal income tax does he have to pay for the year

Positive impact on performance : Using one (1) specific business example (real or fictitious) of a situation where socially complex resources and capabilities exist

User Account

All Pages