# Using Excel to complete a cost table

Complete the following table using your understanding of the relationship among the various costs.

Output TC FC VC ATC AFC AVC MC

0 X 125 0 X X X X

10 X X X X X 5.0 X

20 X X X X X X 3.5

30 235 X X X X X X

40 X X 130 X X X X

50 X X X 5.5 X X X

60 X X X X X 3.0 X

70 350 X X X X X X

80 X X X X X X 7.0

https://brainmass.com/economics/pricing-output-decisions/using-excel-to-complete-a-cost-table-477787

#### Solution Preview

See the attached file. Select a cell to see the formula that was used to calculate its ...

#### Solution Summary

This solution shows how to use Excel to fill in the missing values in a table of a firm's costs.

$2.19