please include all formulas for excel and steps on how to do it
ITEC320 - Business Analytics Assigned: January 27, 2020 Due: Electronically via Blackboard by Sam on Monday, February 3, 2020. Analytics Deliverable 1 For all spreadsheets, use the techniques we've been going over in class: Use cell styles Name cells (CRTL+SHIFT+F3) Don't put numbers in formulae Anything else we've mentioned in class or that will make your spreadsheets more readable. Part I Burr's Revenge You are thinking of opening a Broadway play, "Burr's Revenge". It will cost $5 million to develop the show. There are 8 shows per week, (shown in 6 days: Mondays are off, and there are 2 shows on Wednesdays and Sundays). You project the show will run for 100 weeks. It costs $1000 to open the theater each day. Tickets sell for $50.00, and you earn an average of $1.50 profit per ticket holder from concessions. The theater holds 800, and you expect 80% of the seats to be full. (Hint: when you build your model, it may be beneficial to calculate intermediate values such as "number of total shows" and "number of customers per night", rather than having one big messy equation at the end with profit in it). (To validate your model, the profit to start with should be about $21 million.) Answer the following three questions in text boxes in Excel. A) Given your other assumptions, how many weeks will the play have to run for you to make $5,000,000 profit? (Set your answers back to the original after you check this out) B) Given your other assumptions, how does the percentage of seats full affect profit? (Make a one-way data table with a chart) C) Even if you get the two questions above correct, we know that the model is not a perfect representation of the world. What would be the next improvement you would make? ITEC320 - Business Analytics Assigned: January 27, 2020 Due: Electronically via Blackboard by Sam on Monday, February 3, 2020. Analytics Deliverable 1 For all spreadsheets, use the techniques we've been going over in class: Use cell styles Name cells (CRTL+SHIFT+F3) Don't put numbers in formulae Anything else we've mentioned in class or that will make your spreadsheets more readable. Part I Burr's Revenge You are thinking of opening a Broadway play, "Burr's Revenge". It will cost $5 million to develop the show. There are 8 shows per week, (shown in 6 days: Mondays are off, and there are 2 shows on Wednesdays and Sundays). You project the show will run for 100 weeks. It costs $1000 to open the theater each day. Tickets sell for $50.00, and you earn an average of $1.50 profit per ticket holder from concessions. The theater holds 800, and you expect 80% of the seats to be full. (Hint: when you build your model, it may be beneficial to calculate intermediate values such as "number of total shows" and "number of customers per night", rather than having one big messy equation at the end with profit in it). (To validate your model, the profit to start with should be about $21 million.) Answer the following three questions in text boxes in Excel. A) Given your other assumptions, how many weeks will the play have to run for you to make $5,000,000 profit? (Set your answers back to the original after you check this out) B) Given your other assumptions, how does the percentage of seats full affect profit? (Make a one-way data table with a chart) C) Even if you get the two questions above correct, we know that the model is not a perfect representation of the world. What would be the next improvement you would make
