Business, 24.02.2021 20:30, josh5527

Hi, please help me A garage band wants to hold a concert. The expected crowd has a Normal distribution with the mean of 3000 and standard deviation of 200. The average expenditure on concessions is Uniformly distributed with a minimum of $10 and maximum of 25 dollars. Tickets sell for $10 each, and the band’s profit is 80% of the gate (ticket sale) and concession sales, minus a fixed cost of $12,000. Use the provided spreadsheet model and conduct a Monte Carlo simulation with 500 trials to analyze the band profit.
In your analysis,
a. find the minimum, maximum, average, and standard deviation for band profit.
b. create the frequency distribution (using FREQUENCY function) and the histogram for
band profit.
c. Find the probability that band profit will be greater than $62000.

Answers: 2

Show answers

Other questions on the subject: Business

Business, 21.06.2019 20:40, brittany7436

Astock is selling today for $50 per share. at the end of the year, it pays a dividend of $3 per share and sells for $58. a. what is the total rate of return on the stock? (enter your answer as a whole percent.) b. what are the dividend yield and percentage capital gain? (enter your answers as a whole percent.) c. now suppose the year-end stock price after the dividend is paid is $42. what are the dividend yield and percentage capital gain in this case? (negative amounts should be indicated by a minus sign. enter your answers as a whole percent.)

Answers: 1

continue

Business, 21.06.2019 20:40, alix1234567888

Balances for each of the following accounts appear in an adjusted trial balance. identify each as an asset, liability, revenue, or expense. 1. accounts receivable 2. equipment 3. fees earned 4. insurance expense 5. prepaid advertising 6. prepaid rent 7. rent revenue 8. salary expense 9. salary payable 10. supplies 11. supplies expense 12. unearned rent

Answers: 3

continue

Business, 22.06.2019 12:30, bella51032

True or false entrepreneurs try to meet the needs of the marketplace by supplying a service or product

Answers: 1

continue

Business, 22.06.2019 19:00, 3peak101

Andy purchases only two goods, apples (a) and kumquats (k). he has an income of $125 and can buy apples at $5 per pound and kumquats at $5 per pound. his utility function is u(a, k) = 6a + 2k. what is his marginal utility for apples and his marginal utility for kumquats? andy's marginal utility for apples (mu subscript a) is mu subscript aequals 6 and his marginal utility for kumquats (mu subscript k) is

Answers: 2

continue

Do you know the correct answer?

Hi, please help me A garage band wants to hold a concert. The expected crowd has a Normal distribut...