4. 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 general mathematical model and implement it on a spreadsheet to find their expected profit.

15. Use the Markdown Pricing Decisions spreadsheet model (see attached)and a two-way data table to find the total revenue if days at full retail vary from 20 to 40 in increments of 5 and the intermediate markdown varies from 15% to 50% in increments of 5%.

20. For the garage-band model you developed in problem 4, define and run some reasonable scenarios using the scenario manager to evaluate profitability for variations in the estimates.