Now, this Module 5 assignment is designed to check your knowledge of Production

Now, this Module 5 assignment is designed to check your knowledge of Production

Now, this Module 5 assignment is designed to check your knowledge of Production in Monopoly vs. Perfect Competition markets and Herfindahl-Hirschman Index calculation, as well as your skill of using Excel to do the calculation and graphing. This Excel file includes two spreadsheets: Production and HHI. Module 5 Assignment-1.xlsx Download Module 5 Assignment-1.xlsx (1) Using the “Module 5 Assignment” Excel file to calculate the revenue, cost, and output in the spreadsheet “Production”. Be careful, and you MUST show the Excel calculation rather than simply put a number in the cells. After the calculation, point out the production for Monopoly and that for Perfect competition firms, and then, compare the differences of the P and Q for those two productions in the two different markets based on the values you calculated. (2) Create a third spreadsheet and name it “Graphs”. Using the values from your calculation, first, insert a graph of ATC, P, MC, and MR (against Q), pointing out the maximizing production point for Monopoly. Second, insert a graph of P, TR, and TC (against Q), pointing out the maximizing production point for a Perfect Competition firm. Then, comparing the differences of the P and Q for the productions in the two different markets based on the graph information. (3) Herfindahl-Hirschman Index (calculation): There are 6 health organizations in the market, what’s the share of the S6? What’s the HHI?