ICA__2_key - 576 Profit 288 Q 24 C(Q 586 P 48 TR 1152...

Info icon This preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Amount of input x x 9 Amount of input y y 9 Quanity of output produced Q 3 Price of input x Px 2 price of input y Py 2 Price of output P 24 Total Cost 36 Total Revenue 72 Profit 36
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Sensitivity Report Worksheet: [ICA #2.xlsx]PART 1 Report Created: 8/31/2009 6:37:09 PM Adjustable Cells Final Reduced Cell Name Value Gradient $B$7 Amount of x 6.05 0.00 $B$8 Amount of y 4.12 0.00 Constraints Final Lagrange Cell Name Value Multiplier $B$2 Expenditures 5.50 0.93
Image of page 2
Income 6.50 Expenditures 6.50 Price of x 0.50 Price of y 0.60 Utility 6.02 alpha 0.55 Amount of x 7.15 Amount of y 4.87
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Amount of input x x 144 Amount of input y y 144 Quanity of output produced Q 12 Price of input x Px 1 price of input y Py 1 Price of output P 48 Total Cost 288 Total Revenue
Image of page 4
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
Image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 576 Profit 288 Q 24 C(Q) 586 P 48 TR 1152 PROFIT 566 Q C(Q) P TR PROFIT 24 586 48 1152 566 25 635 49 1225 590 26 686 50 1300 614 Q Supply (Firm) Supply (Market) 24.00 48 4800 24.50 49 4900 25.00 50 5000 23.80 24. 46.5 47 47.5 48 48.5 49 49.5 50 50.5 MC(Q) = 2Q .00 24.20 24.40 24.60 24.80 25.00 25.20 Firm Level Supply Supply (Firm) Energy Type TW Percent Oil 5.6 37.33% Natural Gas 3.5 23.33% Coal 3.8 25.33% Hydroelectric 0.9 6.00% Nuclear 0.9 6.00% Geothermal, wind, etc… 0.13 0.87% OTHER 0.17 1.13% Total 15 100.00% Percent Oil Natural Gas Coal Hydroelectric Nuclear Geothermal, wind, etc… OTHER...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern