You are responsible for an analysis of the profitability of the movie industry, based on the dataset provided, for which you will:

1. Organize the data in various ways as necessary to understand the trends.
2. Analyze the data. Your analysis should outline the trends that are occurring and identify any relationships found in the data.
3. Identify which genre you consider to be most successful, and providea  rationale based on the data.
4. Determine what the better predictor of success is – Audience Score or Rotten Tomatoes Rating, and explain your rationale.
5. Provide a forecast for 2020 which will include what you think the worldwide gross sales will be, including sales by genre and by the  studio, based on your analysis.

This assignment will be completed individually, or in groups of two. Students will select their own groups.

Organizing and analyzing

The first step is to organize the data, so that you are able to analyze it and identify trends. You will organize the data using an Excel workbook; data is available on eConestoga.

To help in your analysis, consider the following tips:

1. You will want to use separate worksheets to organize the data into various segments – by genre, by studio, by year.
2. Calculate the market share of each studio, and the segment share of each genre. This should be done for each year.
3. Calculate the relevant trends; this will include growth/decline of sales, of profit, of market share and of segment share. Trends must be calculated year by year (eg how much did sales increase from 2015 to 2016, from 2016 to 2017etc.). Note:
   1. Trends based on $ (eg sales) are best indicated by % change, not by $ value (eg $32,600 sales to 33,000 is a 1.2% increase).
   2. Trends based on % (eg market share, segment share) are best indicated by point change (eg difference from one year to the next; 32.6 % share to 33% share is a .4 increase).
   3. Analyze trends overall (profit, sales), and also by genre and studio.
4. Be sure to use pivot tables to help you identify trends. For example, using pivot tables to evaluate the relationship between Audience Score and Sales, and Rotten Tomatoes Rating and Sales can be helpful in determining which is the better predictor of success.

Preparing the Report

The report should be no more than 4 pages in length, excluding your appendices (that means 4 pages of insightful comments). Please ensure that your names, the title of the projec,t and the date are clearly visible (typed) on the Executive Summary.

This assignment will consist of 2 submissions:

1. Your report, as either a Word document or a PowerPoint deck. No pdfs will be accepted.
2. A copy of the Excel file that includes all of your organization and manipulation of the data.

NOTE: Assignments must be submitted in both ways, by the beginning of class on the due date. No assignments will be accepted after the due date/time.

REPORT FORMAT

1. Executive Summary¹(1 page)
2. Summary of Key Trends (max 2 pages)
   1. will be a visual representation of the trends, with some explanatory/descriptive comments.

3. Conclusions 

This will identify what genre you think is most successful, and providea  rationale for that. It will also identify what you think the best predictor of success is, and your rationale for that.

4. Forecast²
5. Appendices³

1 The Executive Summary should provide a one-page visual overview of the key points you have made throughout the report, and should summarize your conclusions and forecast. This should also include typical cover page information, like student names, student numbers, the title of the report, instructor name, and due date. This should be professional in appearance and attractively designed.

2 The forecast should be comprehensive and estimate what you think gross sales will be for 2020, including sales by genre and by the studio.

3 The appendices will include anything you think would be useful to support the Summary of Key Trends and Conclusions. There must be at least 2 pivot tables included in the appendices, and at least 3 trend calculations. For example, you might include a graph of the change in Gross Sales, year over year, in the Summary of Key Trends. Then, an Appendix would include the relevant data table showing the Gross Sales, by year, and the % change.