https://troy.instructure.com/courses/70226/externa...

Part !The market structures influence how price and output decisions are made by the firms in their respective structure. In all market structures, one of the primary goals is to maximize profits or minimize losses.One of the major differences between these market structures is how price and output decisions are made, which in turn depends on the characteristics of each market structure. There are four market structures:Perfect competitionMonopolistic competitionOligopolyMonopolyTasks:Construct a table that describes the various characteristics of each market structure.Identify a firm for each of these market structures and explain why each firm belongs in the market structure identified.Using Microsoft Excel, construct a graph for each of the market structures and explain how price and output decisions are made in each structure and how they differ.How is marginal analysis used in the price and output decisions of firms in the various market structures?Deliverables:Prepare a 2-3 page Microsoft Word document that addresses the questions above and meets APA standards.Include a summary section in your report that contains 5-7 bullet points identifying your major findings or conclusions of your paper.Part IIMarket FormsThe following questions address some of the price and output decisions faced by firms other than those found in perfect competition. Some numbers may be rounded.Table 1-aAverage Fixed costAverage Variable CostAverage Total CostOutput01$ 180.00$ 135.00$ 315.002$ 90.00$ 127.50$ 217.503$ 60.00$ 120.00$ 180.004$ 45.00$ 112.50$ 157.505$ 36.00$ 111.00$ 147.006$ 30.00$ 112.50$ 142.507$ 25.71$ 115.70$ 141.418$ 22.50$ 121.90$ 144.409$ 20.00$ 130.00$ 150.0010$ 18.00$ 139.50$ 157.50Table 1-a (continued)Marginal CostPriceTotal RevenueMarginal RevenueOutput0$ 345.001$ 300.002$ 249.003$ 213.004$ 189.005$ 165.006$ 144.007$ 126.008$ 111.009$ 99.0010$ 87.00Questions:Complete Table 1. Summarize your calculations and use Microsoft Excel.Using Excel, draw one graph showing average fixed costs, average variable costs, average total costs, marginal revenue, and marginal costs.Using the data in the table and on your graph, what is the profit maximizing, or loss minimizing level of output? Explain and justify your answers.What is a normal profit? What is an economic profit? Explain your answer using examples. Are normal profits being earned in this example? Are economic profits present for this firm in this example? Explain your answers.Given the data in the table and the graph, how could you determine or identify the optimal plant size?What is the difference between explicit and implicit cost? Explain your answers.How would we determine if a cost is a fixed cost or a variable cost?Present your analysis in Microsoft Excel format. Enter non-numerical responses in the same worksheet using textboxes. If you want to learn how to use Microsoft Excel to create curves, refer to the Microsoft Excel tutorials.