Explore BrainMass
Share

Explore BrainMass

    Cost Benefit Analysis

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

    Cost Benefit Analysis

    Given the following information:
    UnitsQ Total Benefit B(Q) Total Cost C(Q) Net Benefits NB(Q) Marginal Benefits MB(Q) Marginal Cost MC(Q) MNB(Q)
    100 1200 950 210 40
    101 1400 50
    102 1590 60
    103 1770 70
    104 1940 80
    105 2100 90
    106 2250 100
    107 2390 110
    108 2520 120
    109 2640 130
    110 2750 140

    Complete the above table by filling in all the blank areas using the data given. Next, use Excel to provide a graph of Total Benefits and Costs and a graph of Marginal benefits and costs. Given the table, and the developed graphs, discuss your results.

    © BrainMass Inc. brainmass.com April 3, 2020, 7:44 pm ad1c9bdddf
    https://brainmass.com/economics/cost-benefit-analysis/cost-benefit-analysis-277957

    Attachments

    Solution Preview

    Please refer attached file for better clarity of table and complete description. Graphs are missing here.

    Solution:

    UnitsQ Total Benefit B(Q) Total Cost C(Q) Net Benefits NB(Q) Marginal Benefits MB(Q) Marginal Cost MC(Q) MNB(Q)
    100 1200 950 250 210 40 170
    101 1400 1000 400 200 50 150
    102 1590 1060 530 190 60 130
    103 1770 ...

    Solution Summary

    Solution describes the formulas needed to calculate missing numbers. It also discusses the results of graphs.

    $2.19

    ADVERTISEMENT