Explore BrainMass
Share

Explore BrainMass

    Using Excel to Calculate All Cost Curves

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

    Cost Data

    Consider the following cost functions:
    TC = 20 + 4Q
    TC = 20 + 2Q + 0.5Q2
    TC = 20 + 4Q - 0.1Q2

    Using Excel, calculate all cost curves using a range of quantity from 0 to 15.
    Total cost
    Total fixed Cost
    Total variable cost
    Average total cost
    Average fixed cost
    Average variable cost
    Marginal cost

    Plot these curves on graphs
    Compare the cost curves and discuss their characteristics.

    © BrainMass Inc. brainmass.com October 9, 2019, 10:37 pm ad1c9bdddf
    https://brainmass.com/economics/production-function/using-excel-calculate-all-cost-curves-226215

    Solution Summary

    Cost curves are calculated and graphed in excel. These cost curves are compared and discussed. The curve curves are total cost, total fixed cost, total variable cost, average total cost, average fixed cost, average variable cost, and marginal cost.

    $2.19