Cost Curves - Total and Variable Costs

 

Use the table below and place it in the input area of an Excel spreadsheet. Use the formulas for AFC, AVC, ATC, and MC to calculate and populate the missing columns. Next, create a line graph of all three total cost curves. Then, create a line graph including only the variable cost curves - AVC, ATC, MC, and AFC.

QTFCAFCTVCAVCATCTCMC0$1,0000$1,0001$1,000500$1,5002$1,000700$1,7003$1,000800$1,8004$1,000850$1,8505$1,000875$1,8756$1,000950$1,9507$1,0001050$2,0508$1,0001200$2,2009$1,0001400$2,40010$1,0001650$2,65011$1,0001950$2,95012$1,0002300$3,30013$1,0002700$3,70014$1,0003150$4,15015$1,0003650$4,650