A garage band wants to hold a concert. The expected crowd is 2,900. The average expenditure on concessions is $30. Tickets sell for $25 each, and the band's profit is 75% of the ticket and concession...

6 see picture


Extracted text: A garage band wants to hold a concert. The expected crowd is 2,900. The average expenditure on concessions is $30. Tickets sell for $25 each, and the band's profit is 75% of the ticket and concession sales minus a fixed cost of $17,00O. A spreadsheet has been developed to calculate the band's expected profit: 1 Expected Crowd 2 Average Concessions Expenditure 2,900 people $30 per person 3 Fixed Cost $17,000 $25 per person 4 Ticket Price 5 Profit Percentage 75% 6 Ticket Revenue 7 Concession Revenue $72,500.00 $87,000.00 $102,625.00 8 Profit What formula is used in cell B8 to calculate the Profit? Start your formula with an "=" sign, just as you would if you were entering the formula in Excel. Do not use any spaces in your formula. 11.