1 (218) 451-4151 support@writersnests.org
glass
pen
clip
papers
heaphones

Cost Curves – Total And Variable Costs

Cost Curves – Total And Variable Costs

se 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