Purpose This assignment is intended to help you learn to do the following: Calcu

This assignment is intended to help you learn to do the following:
Calculate the industry concentrations.
Compare anti-trust guidelines.
Business briefs are used throughout the course to assist students in applying the knowledge obtained through discussions, readings, and simulations to real-world scenarios. In this module, you will be reviewing and using market share data to calculate and asked to make calculations for industry concentration. A hypothetical merger is proposed, and the post-merger concentration must be calculated and compared to anti-trust guidelines.
Action Items
Read the case study, Spectrum – The Spawn of Time Warner Cable and Charter Communications – Navigates Challenges from Cord Cutting and Mobile Competition on pages 473-491 in Baye and Prince (2022).
Review the Business Brief Guidelines.
On page 498 of Baye and Prince (2022), read Memo 13.
Write a 1- to 2-page business brief that includes:
Opening: Provide an overview of the memo itself to inform the reader what the outline will encompass.
Calculate the industry concentration using the file named Marketshare.xls (Note: Page 209 begins the Measures of Industry Concentration)
Then calculate the post-merger concentration.
Compare and contrast the pre-merger and post-merger concentrations providing differences.
Conclude with a comparison of anti-trust guidelines.
Include 1-2 resources in addition to your textbook