Stat

expected profit A garage band wants to hold a concert. The expected crowd is 2,400. The average expenditure on concessions is $35. Tickets sell for $30 each, and the band's profit is 85% of the gate and concession sales minus a fixed cost of $17,000. Develop a mathematical model and implement it on a spreadsheet to find the band's Write Excel formulas for the unknown values in the model. Expected Crowd 2 Average Concessions Expenditure 3 Fixed Cost Ticket Price 5 Profit percentage 6 Ticket Revenue Concession Revenue 8 Profit