Explore BrainMass

Explore BrainMass

    Calculating Marginal Costs With Excel

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

    Using the given table, find the quantity where MC = ATC. Find the quantity where ATC is at its minimum.
    Find the quantity that is the most efficient operating point for the firm.

    The table
    Output Costs TFC TVC AFC AVC ATC MC
    0 $100
    1 $150
    2 $225
    3 $230
    4 $300
    5 $400

    © BrainMass Inc. brainmass.com October 10, 2019, 4:00 am ad1c9bdddf

    Solution Preview

    ** Please see the attached file for the completed table **
    To see how each ...

    Solution Summary

    This solution shows how to use Excel to instantly and accurately solve problems that require the calculation of fixed, variable, and marginal costs from minimal data.