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:

  1. Complete Table-1. Summarize your calculations or 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, what type of market structure could this be in the short run? Explain your answers.
  6. 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

Reviews

Write a Review

Microeconomics Questions & Answers

  Find the mixed strategy nash equilibria in other words find

consider the employee-employer relationship - an employee would like to be paid but also gets some benefit by

  Discuss the health care problem of limited access

Two major areas of health care reform involve universal access and containing costs. List the specific options discussed in your text that work toward these reforms.

  Describe how can we save social security

For this week, we are continuing our discussion on GDP and economic growth. We will realize that most of government spending goes towards welfare such as social security. However, it is a common belief that social security benefits

  How to created jobs in both the public and private sectors

The fiscal policy measure that has more direct impact on the economy is an increase in government spending if consumer confidence is lower than the previous month. One of the ways the President Obama stimulated the economy was through increased g..

  Complements of digital cameras are

Owners of digital cameras have to buy memory cards in order to use the cameras. Cameras and memory cards are  substitutes or complements,

  Explain adverse selection problem

You sell bicycle theft insurance. If bicycle owners do not know whether they are high- or low-risk consumers, is there an adverse selection problem?

  Analysis effects of non-price factors on demand

Suppose the demand for computers. For each of the following, state effect on demand, find the equation of the demand curve if consumer incomes are $30,000,

  How the article relates to concepts & theories

Discuss how the article relates to concepts & theories (international investment) examined (clearly note the concepts & theories being illustrated)

  Two centuries ago there were more buffalo than cattle

Two centuries ago there were more buffalo than cattle in the United States. Even though millions of cattle are killed for beef consumption each year, the cattle population continues to grow while the buffalo are virtually extinct. Why?

  You are a member of a presidential commission appointed to

you are a member of a presidential commission appointed to consider a mandatory national health insurance plan and the

  Define aggregate production function with typical shape

Draw an aggregate production function with typical shape and label it "F". Make sure to label the axis of the graph. Now, add two more production functions based on the following scenarios.Efficient institutions are adopted in a country. Label this..

  Determine which city provides the lowest overall costs

Wiebe Trucking, Inc., is planning a new warehouse to serve the western United States. Denver, Santa Fe, and Salt Lake City are under consideration. For each location, annual fixed costs (rent, equipment, and insurance) and average variable costs p..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd