Using Excel to Calculate All Cost Curves
Not what you're looking for?
Cost Data
Consider the following cost functions:
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.
Purchase this Solution
Solution Summary
Cost curves are calculated and graphed in excel. These cost curves are compared and discussed. The curve curves are total cost, total fixed cost, total variable cost, average total cost, average fixed cost, average variable cost, and marginal cost.
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
Elementary Microeconomics
This quiz reviews the basic concept of supply and demand analysis.
Pricing Strategies
Discussion about various pricing techniques of profit-seeking firms.
Economics, Basic Concepts, Demand-Supply-Equilibrium
The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.
Economic Issues and Concepts
This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.
Basics of Economics
Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.