A management information systems assignment

Assignment Help Management Theories

Reference no: EM131132916

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...

Reference no: EM131132916

Questions Cloud

Communicate and persuade others during a negotiation : The purpose of this assignment is for you to think about personal power type and how it can influence our ability to negotiate, communicate and persuade others during a negotiation.

What are the strong points of theory : Define the theory in your own words- what are the main ideas? What are the strong points of theory? What are the weak points?

Situation that occurs when a persons values are in conflict : a situation that occurs when a person's values are in conflict, making it unclear whether a decision is the right thing to do?

What is the belief that a firm is worthy of consideration : the belief that a firm is worthy of consideration or doing business with because of the impressions or opinions of customers, suppliers, investors, or competitors?

A management information systems assignment : 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.

Characteristics that represent potential social obligations : the characteristics of a business, like trust, consistency, and networks, that represent potential social obligations which are an asset of the firm or entrepreneur?

Determine the optimal order size for the hospital : Community Hospital orders latex sanitary gloves from a hospital supply firm. The hospital ex- pects to use 40,000 pairs of gloves per year. The cost to order and to have the gloves delivered is

Describe the main themes that urban ii uses to motivate : Describe the main themes that Urban II uses to motivate his hearers in Robert the Monk's record of Urban's speech at Clermont and explain why those themes might be convincing to the audience.

Skills used in management of a firms interaction with people : the general description for the processes and skills used in the management of a firm's interactions with people, organizations and institutions outside of its boundary?

User Account

All Pages