Excel Micro Econ

The 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-a

Average Fixed cost

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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

Questions:

  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.
  4. 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.
  5. Given the data in the table and the graph, how could you determine or identify the optimal plant size?
  6. What is the difference between explicit and implicit cost?  Explain your answers.
  7.  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.

Submit your documents to the Submissions Area by the due date assigned.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"
[promo2]