DUE TODAY 4.11.18 BY 7PM eastern standard. 40.00 TO 60.00 BUDGET. A OR B work only. original. completed work.

 
Assignment 2: Market Forms
For this assignment you will do a significant portion of work in MS Excel and import it into an MS Word document for submission. You will use the data below to address Price and Output decisions faced by firms that are not in pure competition. Some numbers may be rounded.
Table 1
Output
Average Fixed cost
Average Variable Cost
Average Total Cost
Marginal Cost
 Price
Total Revenue
 Marginal Revenue
0
 $ 345.00
1
 $   180.00
 $ 135.00
 $    315.00
 $ 300.00
2
 $     90.00
 $ 127.50
 $    217.50
 $ 249.00
3
 $     60.00
 $ 120.00
 $    180.00
 $ 213.00
4
 $     45.00
 $ 112.50
 $    157.50
 $ 189.00
5
 $     36.00
 $ 111.00
 $    147.00
 $ 165.00
6
 $     30.00
 $ 112.50
 $    142.50
 $ 144.00
7
 $     25.71
 $ 115.70
 $    141.41
 $ 126.00
8
 $     22.50
 $ 121.90
 $    144.40
 $ 111.00
9
 $     20.00
 $ 130.00
 $    150.00
 $   99.00
10
 $     18.00
 $ 139.50
 $    157.50
 $   87.00
Address the following:

Complete Table-1. Summarize your calculations.
Prepare a graph showing:

Average Fixed Costs
Average Variable Costs
Average Total Costs
Marginal Revenue
Marginal Costs 

Using the data in the table and on your graph, explain the profit maximizing, or loss minimizing level of output.
normal profit and an economic profit. 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, what type of market structure could this be in the short run? Explain your answers.
If the data in Table-1 represents the long run, what type of firm must this data represent? Explain your answers.

Save your MS Word document using the filename LastnameFirstInitial_M4A2 and submit it to the Submissions Area by the due date assigned.
Quotations, paraphrases, and ideas you get from books, articles, or other sources of information should be cited using APA style. Help with citing sources can be found through the Academic Resources page under the Help menu .
Assignment 2 Grading CriteriaMaximum PointsCorrectly answered all parts of Question 1 and completed Table-120Correctly created a graph showing all required data from Question 212Correctly answered all parts of Question 3, with accurate and complete explanations12Correctly answered all parts of Question 4, with accurate and complete explanations12Correctly answered all parts of Question 5, with accurate and complete explanations12Correctly answered all parts of Question 6, with accurate and explanations12Wrote in a clear and concise manner following APA standards, and demonstrated ethical scholarship in accurate representation of sources20Total: