Explore BrainMass
Share

Explore BrainMass

    Using Excel to complete a cost table

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com October 10, 2019, 4:48 am ad1c9bdddf
    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