A garage band wants to hold a concert. The expected crowd is 3,000. The average

A garage band wants to hold a concert. The expected crowd is 3,000. The average expenditure on concessions is $15. Tickets sell for $10 each, and the band’s profit is 80% of the gate, along with concession sales, minus a fixed cost of $10,000. Develop a spreadsheet model to find their expected profit. Define and run some reasonable scenarios using the Scenario Manager to evaluate profitability for variations in the estimates.

You may also like