Explore BrainMass
Share

Explore BrainMass

    Filling in a Cost spreadsheet

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

    During the last few days the Company ABC has been running into problems with its computer system. The last run of the production cost schedule resulted in the incomplete listing shown below. From your knowledge of cost theory, fill in the blanks.

    Q TC TFC TVC ATC AFC AVC MC
    0 40 _____ _____ x x x x
    1 _____ _____ _____ 52 _____ _____ _____
    2 _____ _____ 20 _____ _____ _____ _____
    3 _____ _____ _____ 21.33 _____ _____ _____
    4 _____ _____ _____ _____ _____ _____ 4
    5 _____ _____ 40 _____ _____ _____ _____
    6 _____ _____ _____ 15.67 _____ _____ _____
    7 _____ _____ _____ _____ _____ 10 _____
    8 _____ _____ 96 _____ _____ _____ _____
    9 _____ _____ _____ _____ _____ 15 _____
    10 _____ _____ _____ _____ _____ _____ 45

    Q = Production; TC = Total Cost; FC = Fixed Cost; TVC = Total Variable Cost; ATC = Average Total Cost; AFC = Average Fixed Cost; and MC = Marginal Cost

    © BrainMass Inc. brainmass.com October 10, 2019, 4:37 am ad1c9bdddf
    https://brainmass.com/economics/cost-benefit-analysis/filling-in-a-cost-spreadsheet-469476

    Solution Preview

    See the attached file. The formulas in the cells show how each ...

    Solution Summary

    Given a partially filled-in spreadsheet of a firm's costs, this solution gives the formulas for each type of cost and shows how to calculate the missing values.

    $2.19