Question
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
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.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66796f4ef0ac4_38266796f4ed94af.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started