Attached you will find a Management Information Systems assignment. Can you please assist with answer the questions with the guidelines in the bottom of the excel document.
Document Preview:
1500 1625 1600 1585 345 421 400 367 2000 2015 1975 1800 101 85 116 92 2105 2000 1916 1945 562 461 532 488 105 125 101 132 93 105 100 115 162 143 181 162 658 745 723 699 7 5 Premiere Movie Source (Weekly Attendance) Type of Movie Week 1 Week 2 Week 3 Week 4 Category Total Attendance Projected Revenue Action & Adventure Animation Comedy Documentary Drama Family & Kids Foreign Horror Musicals Sci-Fi & Fantasy Weekly totals Projected Revenue using combination of High / Low Pricing Flat Rate Projected Revenue using Flat Rate Low Price High Price Objective: You are consdering buying a theatre and have the following data to help make decisions.
• Sample data for 4 weeks for different Types of Movies.
•2014 Ticket Price the seller is using to justify price Directions a) Use the appropriate built-in functions to answer the following questions. b) Where the appropriate built-in function does not exist, build the necessary equation, using variables (cell references) where possible and where it makes sense. Assume: For each Week and "Type of Movie" there is one and only one movie playing at this theatre for that Week/Type of Movie combination 1) Add formatting to make the table easier to read. This should include, but is not limited to: Adding borders to help delineate the cells Use of fill or border thickness to help call out title lines, summaries and totals Numbers are properly formatted as integers (whole numbers), decimals or percentages, and currency US $ Currency has no decimal places. Using all of the Weeks/Type of Movie combintations, what was the: 2a) Maximum Attendance? 2a) Minimum Attendance? 2c) Average Attendance? 2d) Median Attendance? 3) Your company is going to buy this theatre. The current owner says the usual attendance for any one week and movie type combination is about 750 people. He says that he has a lot of movies with a weekly attendance of well over 1500 people. Using your data from #2 above, what's...