# calculate all cost curves

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).

https://brainmass.com/economics/production/calculate-all-cost-curves-225248

$2.19