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 bands 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.

Garage Band Expected demand average concessions expenditure Ticket cost Fixed cost Band's gate % 3000 15.00 10.00 $ 10,000.00 80% Band's profit $59,000.00