Purchase Solution

calculate all cost curves

Not what you're looking for?

Ask Custom Question

Cost Data (Excel application)

TC = 20 + 4Q

TC = 20 + 2Q + 0.5Q2

TC = 20 + 4Q - 0.1Q2

Using Excel, calculate all cost curves using a range of quantity from 0 to 15.
Total cost
Total fixed Cost
Total variable cost
Average total cost
Average fixed cost
Average variable cost
Marginal cost

Plot these curves on graphs
Compare the cost curves and discuss their characteristics.

Solution Guide

To calculate the average and marginal costs, use the following formulas:
ATC = TC÷Q
AFC = TFC÷Q
AVC = TVC÷Q
MC = change in TC ÷ change in Q

Using the numbers in the tables, plot the different cost curves using Excel graphing features.
The cost numbers are plotted on the vertical axis (y).
The quantity numbers are plotted on the horizontal axis (x).

Purchase this Solution

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.