Assignment 2: Market FormsFor 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

 

Table 1

 

 

 

 

 

 

 

Output

Average Fixed cost

Average Variable Cost

Average Total Cost

Marginal Cost

 Price

Total Revenue

 Marginal Revenue

 

 

 

 

 $ 345.00

 

 

 $   180.00

 $ 135.00

 $    315.00

 

 $ 300.00

 

 

 $     90.00

 $ 127.50

 $    217.50

 

 $ 249.00

 

 

 $     60.00

 $ 120.00

 $    180.00

 

 $ 213.00

 

 

 $     45.00

 $ 112.50

 $    157.50

 

 $ 189.00

 

 

 $     36.00

 $ 111.00

 $    147.00

 

 $ 165.00

 

 

 $     30.00

 $ 112.50

 $    142.50

 

 $ 144.00

 

 

 $     25.71

 $ 115.70

 $    141.41

 

 $ 126.00

 

 

 $     22.50

 $ 121.90

 $    144.40

 

 $ 111.00

 

 

 $     20.00

 $ 130.00

 $    150.00

 

 $   99.00

 

 

10

 $     18.00

 $ 139.50

 $    157.50

 

 $   87.00