omplete 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.

Survey Of Economics
10th Edition
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Tucker, Irvin B.
Chapter6: Proudction Costs
Section: Chapter Questions
Problem 8SQP
icon
Related questions
Question

Average Fixed cost

Average Variable Cost

Average Total Cost

 

Output

 

0

 

 

 

 

1

 $   180.00

 $ 135.00

 $    315.00

 

2

 $     90.00

 $ 127.50

 $    217.50

 

3

 $     60.00

 $ 120.00

 $    180.00

 

4

 $     45.00

 $ 112.50

 $    157.50

 

5

 $     36.00

 $ 111.00

 $    147.00

 

6

 $     30.00

 $ 112.50

 $    142.50

 

7

 $     25.71

 $ 115.70

 $    141.41

 

8

 $     22.50

 $ 121.90

 $    144.40

 

9

 $     20.00

 $ 130.00

 $    150.00

 

10

 $     18.00

 $ 139.50

 $    157.50

 

 

 

Table 1-a (continued)

     

 

Marginal Cost

Price

Total Revenue

Marginal Revenue

Output

0

 

 $ 345.00

 

 

1

 

 $ 300.00

 

 

2

 

 $ 249.00

 

 

3

 

 $ 213.00

 

 

4

 

 $ 189.00

 

 

5

 

 $ 165.00

 

 

6

 

 $ 144.00

 

 

7

 

 $ 126.00

 

 

8

 

 $ 111.00

 

 

9

 

 $   99.00

 

 

10

 

 $   87.00

 

  1. Complete Table 1. Summarize your calculations and use Microsoft Excel.
  2. Using Excel, draw one graph showing average fixed costs, average variable costs, average total costs, marginal revenue, and marginal costs.
  3. 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. 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Cost Curves
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Survey Of Economics
Survey Of Economics
Economics
ISBN:
9781337111522
Author:
Tucker, Irvin B.
Publisher:
Cengage,
Micro Economics For Today
Micro Economics For Today
Economics
ISBN:
9781337613064
Author:
Tucker, Irvin B.
Publisher:
Cengage,
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Economics For Today
Economics For Today
Economics
ISBN:
9781337613040
Author:
Tucker
Publisher:
Cengage Learning
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Essentials of Economics (MindTap Course List)
Essentials of Economics (MindTap Course List)
Economics
ISBN:
9781337091992
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning