Using excel sketch one graph showing average fixed costs

Assignment Help Microeconomics

Reference no: EM13453700

The following questions address some of the Price and Output decisions faced by firms other than those found 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

Questions:

Complete Table-1. Summarize your calculations or 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, 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.

Reference no: EM13453700

Questions Cloud

How expensive would it be to convert to the alternative : it is easy to criticize society for not using renewable resources but in reality how difficult would this transition

A customer calls in and has a complaint about the quality : on-time technology products recognizes that they should do more to connect with customers after a sale.assume you work

The accounting manager has supplied you with data and asked : phelps glass inc. has reported the following financial data net revenue of 10 million. variable cost of 5 million

Explain the purpose of and reasoning behind executive order : your responses are to be in your own words with no quotes paraphrasing or copying. what i am looking for in your

Using excel sketch one graph showing average fixed costs : the following questions address some of the price and output decisions faced by firms other than those found in pure

Your organization is about to review their energy use and : your organization is about to review their energy use and develop an energy plan including as many renewable power

You want to be part of the green revolution and are : you want to be part of the green revolution and are looking to find ways to reduce your energy use. but first you

In the examination of property plant and equipment the : in the examination of property plant and equipment the auditor tries to determine all of the following except thea

The auditor is most likely to seek information from the : the auditor is most likely to seek information from the plant manager with respect to thea adequacy of the

User Account

All Pages