Question

In: Statistics and Probability

To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major...

To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3700, and the average first-year commission for each new account opened is $5300. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account.
a.

Simulation Trial New Accounts
1 0
2 0
3 0
4 0
5 0
6 2
7 2
8 1
9 1
10 0
11 1
12 2
13 1
14 2
15 0
16 0
17 0
18 0
19 1
20 0
21 1
22 0
23 1
24 0
25 0


Construct a spreadsheet simulation model to analyze the profitability of Gustin’s seminars. Round the answer for the expected profit to the nearest dollar. Round the answer for the probability of a loss to 2 decimal places. Enter minus sign for negative values.

The expected profit from a seminar is $ _____ and there is a ____ probability of a loss.

Would you recommend that Gustin continue running the seminars?

Solutions

Expert Solution

Answer:-

Given That:-

Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3700, and the average first-year commission for each new account opened is $5300.

We are assuming that Gustin must have conducted 100 seminars in a year with 25 individuals each.

So we are simulating 100 times.

According to the simulation the total number of new accounts opened are 24.

This means that out of the 2500 individuals attending the seminars only 24 have opened a new account which is close to the probability of 0.01.

The total cost of the seminars is 3700 * 100 = $ 370000

The total revenue earned is 5300* 24 = $ 127200

The expected profit is 127200 - 370000 = - $ 242800 which is a considerable loss.

A loss will occur when total cost exceeds the total revenue.

Probability that an individual will open an account is 0.01. The probability that out of 25 individuals one opens an account is 0.01 * 25 = 0.25

The probability of having zero loss is 3700/5300 = 0.698113

Thus, the probability of a loss is 1 - 0.25/0.698113 = 0.6419

In order for the seminar to be successful Gustin needs the difference between the cost and revenue to be zero.I would not recommend Gustin to run the seminar since the probability of loss is very high.

i.e. the expected return from the seminar should atleast be 3700

So the probability of success is 3700/5300 = 0.698113

Plz like it...,


Related Solutions

To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major...
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3200, and the average first-year commission for each new account opened is $5200. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. Determine the equation for computing Gustin’s profit per seminar, given values of the relevant...
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major...
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3,500, and the commission for each new account opened is $5,000. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. (a) Determine the equation for computing Gustin's profit per seminar, given values of the relevant parameters....
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major...
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3700, and the average first-year commission for each new account opened is $5300. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. Assume that the number of new accounts you get randomly is: Simulation Trial New...
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida.
To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3500, and the average first-year commission for each new account opened is $5000. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account.Determine the equation for computing Gustin’s profit per seminar, given values of the relevant parameters.To...
Problem 16-05 To generate leads for new business, Gustin Investment Services offers free financial planning seminars...
Problem 16-05 To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3100, and the average first-year commission for each new account opened is $5800. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. Determine the equation for computing Gustin’s profit per seminar, given values of...
Problem 16-05 To generate leads for new business, Gustin Investment Services offers free financial planning seminars...
Problem 16-05 To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3100, and the average first-year commission for each new account opened is $5800. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. Determine the equation for computing Gustin’s profit per seminar, given values of...
Problem 16-05 To generate leads for new business, Gustin Investment Services offers free financial planning seminars...
Problem 16-05 To generate leads for new business, Gustin Investment Services offers free financial planning seminars at major hotels in Southwest Florida. Gustin conducts seminars for groups of 25 individuals. Each seminar costs Gustin $3900, and the average first-year commission for each new account opened is $4900. Gustin estimates that for each individual attending the seminar, there is a 0.01 probability that he/she will open a new account. Determine the equation for computing Gustin’s profit per seminar, given values of...
Seth Feye established Reliance Financial Services on July 1, 2016. Reliance Financial Services offers financial planning...
Seth Feye established Reliance Financial Services on July 1, 2016. Reliance Financial Services offers financial planning advice to its clients. The effect of each transaction and the balances after each transaction for July follow: Assets =Liabilities + Owners Equity Accounts Accounts Seth Feye, Seth Feye, Fees Salaries Rent Auto Supplies Misc. Cash Receivable + Supplies = Payable + Capital - Drawing + Earned - Expense - Expense - Expense - Expense - Expense a. +55,000 +55,000 b. +7,400 +7,400 Bal....
JB Co. is planning to invest in a new koala theme park. The investment will generate...
JB Co. is planning to invest in a new koala theme park. The investment will generate $4.5 million p.a. for 15 years with the first cash inflow received in one year's time. The required rate of return for this type of investment is expected to be 6% p.a. for years 1-9 rising to 11% p.a. for years 10-15. What is the most JB Co. should pay for this investment now?
JB Co. is planning to invest in a new koala theme park. The investment will generate...
JB Co. is planning to invest in a new koala theme park. The investment will generate $4.5 million p.a. for 15 years with the first cash inflow received in one year's time. The required rate of return for this type of investment is expected to be 6% p.a. for years 1-9 rising to 11% p.a. for years 10-15. What is the most JB Co. should pay for this investment now?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT