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 $3000, 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.
Simulation Trial |
New Accounts |
1 |
0 |
2 |
0 |
3 |
1 |
4 |
0 |
5 |
1 |
6 |
0 |
7 |
1 |
8 |
1 |
9 |
1 |
10 |
0 |
11 |
0 |
12 |
0 |
13 |
2 |
14 |
0 |
15 |
0 |
16 |
0 |
17 |
0 |
18 |
0 |
19 |
0 |
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.
The expected profit from a seminar is $ and there is a
probability of a loss.
Would you recommend that Gustin continue running the
seminars?
Gustin
the seminars in their current format.
Answer= Profit = (New Accounts Opened × $5300)-$ 3000
Answer =The number of new accounts opened is a binomial random variable having 25 trials and 0.01 probability of getting success in each trail.
Answer =
Gustin | |||
Seminar Cost | 3000 | ||
New account commission | 5300 | ||
Probability | 0.01 | ||
Profit | |||
1 | 0 | -3000 | |
2 | 0 | -3000 | |
3 | 1 | 2300 | |
4 | 0 | -3000 | |
5 | 1 | 2300 | |
6 | 0 | -3000 | |
7 | 1 | 2300 | |
8 | 1 | 2300 | |
9 | 1 | 2300 | |
10 | 0 | -3000 | |
11 | 0 | -3000 | |
12 | 0 | -3000 | |
13 | 2 | 7600 | |
14 | 0 | -3000 | |
15 | 0 | -3000 | |
16 | 0 | -3000 | |
17 | 0 | -3000 | |
18 | 0 | -3000 | |
19 | 0 | -3000 | |
20 | 0 | -3000 | |
21 | 1 | 2300 | |
22 | 0 | -3000 | |
23 | 1 | 2300 | |
24 | 0 | -3000 | |
25 | 0 | -3000 | |
Total Profit | -27300 | ||
Mean Profit | -1092 |
Get Answers For Free
Most questions answered within 1 hours.