Case 12 C-141For this case analysis, your group will prepare a written analysis of 3 to 5 pages that uses the text and other credible sources as appropriate. Your group paper should have 1" margins, be double spaced, and use APA formats fortopic and subtopic headingscitationsreferencesYour group case must minimally address the following issues / questions:Review trends in the general environment that affect the movie exhibition business, and establish whether their effects are helpful or harmful to theater owners.Assess the five competitive forces at work in the industry environment. Identify the forces that threaten the profitability of prevailing movie circuits, and prescribe the level of competition that can be anticipated amongst industry rivals.Perform comparative situation and strategy analyses for the four companies with dominant market share. What are the advantages and disadvantages for each of the industry’s top competitors?Evaluate the revenue sources and major costs for movie exhibitors. Discuss how the income structure of their business impacts their financial results.Summarize your findings and the current situation for exhibitor circuits. Based on your analysis, what strategic actions do you propose for theater operators to increase the appeal of the theater setting to attract the audiences needed for improved performance under existing industry conditions?Your grade for this assignment will be based on the Group Submission ONLY (see the rubric for more details).This assignment is due at the end of Module 3.RubricThe Movie Exhibition Industry: 2015 -GROUPThe Movie Exhibition Industry: 2015 -GROUPCriteriaRatingsPtsThis criterion is linked to a Learning OutcomeGroup - External analysis of trends in the general environment3.0 ptsExceeds expectations and indicates critical opportunities and threats with potential to affect the success of theater owners.2.0 ptsAnalysis fully and accurately identifies the external conditions that influence growth and performance in the film industry.1.0 ptsAnalysis identifies the external conditions that influence growth and performance in the film industry.0.0 ptsAnalysis fails to identify some of the external conditions that influence growth and performance in the film industry.3.0 ptsThis criterion is linked to a Learning OutcomeGroup - External analysis of competitive forces in the industry environment4.0 ptsExceeds expectations and weighs the competitive forces to provide a reliable prediction of the intensity of rivalry anticipated in the industry.3.0 ptsAssessment accurately estimates the competitive forces with potential to reduce theater profitability and determines their likely effect on competitive rivalry.2.0 ptsAssessment includes and accurately estimates the competitive forces which have the potential to reduce theater profitability.1.0 ptsAssessment excludes or inaccurately estimates some of the competitive forces which have the potential to reduce theater profitability.4.0 ptsThis criterion is linked to a Learning OutcomeGroup - Competitor analysis of companies with dominant market share3.0 ptsExceeds expectations and integrates the advantages and disadvantages of each of the competitors' strategies into the analysis.2.0 ptsAnalysis provides a comprehensive and precise overview of the top competitors' business situations and approaches.1.0 ptsAnalysis provides a good overview of the top competitors' business situations and approaches.0.0 ptsAnalysis fails to provide a complete overview of the top competitors' business situations and approaches.3.0 ptsThis criterion is linked to a Learning OutcomeGroup - Evaluation of revenue sources and major costs associated with theater operations3.0 ptsExceeds expectations and emphasizes the severe constraints of managing an unprofitable business model.2.0 ptsFinancial review presents a thorough and detailed accounting of the industry's income structure and discusses its impact on the financial performance of exhibitors.1.0 ptsFinancial review considers the revenue sources and major costs that impact today's film exhibitors.0.0 ptsFinancial review does not consider all of the revenue sources and/or major costs that impact today's film exhibitors.3.0 ptsThis criterion is linked to a Learning OutcomeGroup - Grammar, Writing, APA Format2.0 ptsInformation is appropriately sequenced with topical headings and subheadings. Language use, grammar, spelling, and punctuation are at an appropriate graduate level, with no errors. Uses paragraph form with topical sentences that are supported by the remainder of the paragraph, and effective transitions. Writing is clear, concise, and in correct voice and tense. Correct application of APA format. Up to two to three errors in citations and references.1.0 ptsThere is some order to the information with some heading usage. Presentation has two to four misspellings or grammar errors, or two or three word use errors. Uses paragraph form but sentences within the paragraph may not be related. Somewhat correct application of APA format. Four to six errors in citations and references.0.0 ptsLimited structure or no topical headings used. Presentation has more than four misspellings or grammar errors, or more than four word use errors. Language use makes it difficult to understand the intended meaning. Incorrect application of APA format. Several errors in or missing citations and references.2.0 ptsTotal Points: 15.Only need to answer to object 5

The question attached needs to be solved using the Excel Solver. Can anyone assist?