Please answer 15-14 parts a-de answer problem 15-14 a-d for Brady family finances

324 CHAPTER 15 You would like to estimate how much money you might make if you take this job, ow many phone calls you will make, and how much time you will spend. Create a worksheet to simulate this job. You should have a row for each of the 500 people you'll be given. You should have a cell in each row for at least: the prospect number to 500), how many calls it takes to reach the person (1, 2, 3, never), how much you sell to the person (S0, $200, $300, $400, S1000), how much you make in commission for the person, and how much time you spend on each rson. On the top of the worksheet you should have well-labeled cells with: (a) the total number of calls made, (b) the total number of sales pitches (answered calls) made, (c) the total number of sales made, (d) the total amount of commission made, (e) the total time spent, and (f) the expected dollars per hour you will make random fer revenae vs expenses 15-14. Create a worksheet to simulate the Brady family finances for five years under the following neea matti ple rardoms, e0 yows need Separe assumptions Their monthly income varies. In any given month the probabilities are 10% they make no money, 25% they make $1,000, 25% they make $2,000, 25% they make $3,000, and 15% they make $4,000 . Their expenses generally (85% of the time) are $1,800 per month, but in a given month there is a 10% chance their expenses are $3,000 and a 5% chance their expenses are $5,000. Monthly expenses are independent of monthly ncome All funds accumulate in their bank account. Currently they have $3,000 in the account. When the account is positive they make 0.25% per month interest on the funds in the account for the entire month. If their account goes below $0 they have to pay 1.5% per month interest on the debt. Again, this all accumulates in the account. Assume that all income and expenses occur at the end of the month (a) Your worksheet should have a row for each month. There should be columns at least for: month number, income, expenses, interest, and balance. You can have as many additional cells as you wish. Set wriShut (b) At the top of your worksheet please show the maximum amount in the bank account, the minimum amount in the bank account, the number of months they were in debt, and the total of the interest for the five years. M (c) Create a chart that has the month number along the X axis and dollars along the Y axis and plots the Brady family bank account over the 5 years. dollarS 324 CHAPTER 15 You would like to estimate how much money you might make if you take this job, ow many phone calls you will make, and how much time you will spend. Create a worksheet to simulate this job. You should have a row for each of the 500 people you'll be given. You should have a cell in each row for at least: the prospect number to 500), how many calls it takes to reach the person (1, 2, 3, never), how much you sell to the person (S0, $200, $300, $400, S1000), how much you make in commission for the person, and how much time you spend on each rson. On the top of the worksheet you should have well-labeled cells with: (a) the total number of calls made, (b) the total number of sales pitches (answered calls) made, (c) the total number of sales made, (d) the total amount of commission made, (e) the total time spent, and (f) the expected dollars per hour you will make random fer revenae vs expenses 15-14. Create a worksheet to simulate the Brady family finances for five years under the following neea matti ple rardoms, e0 yows need Separe assumptions Their monthly income varies. In any given month the probabilities are 10% they make no money, 25% they make $1,000, 25% they make $2,000, 25% they make $3,000, and 15% they make $4,000 . Their expenses generally (85% of the time) are $1,800 per month, but in a given month there is a 10% chance their expenses are $3,000 and a 5% chance their expenses are $5,000. Monthly expenses are independent of monthly ncome All funds accumulate in their bank account. Currently they have $3,000 in the account. When the account is positive they make 0.25% per month interest on the funds in the account for the entire month. If their account goes below $0 they have to pay 1.5% per month interest on the debt. Again, this all accumulates in the account. Assume that all income and expenses occur at the end of the month (a) Your worksheet should have a row for each month. There should be columns at least for: month number, income, expenses, interest, and balance. You can have as many additional cells as you wish. Set wriShut (b) At the top of your worksheet please show the maximum amount in the bank account, the minimum amount in the bank account, the number of months they were in debt, and the total of the interest for the five years. M (c) Create a chart that has the month number along the X axis and dollars along the Y axis and plots the Brady family bank account over the 5 years. dollarS