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

Info iconThis 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
Background image of page 1

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

View Full DocumentRight 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
Background 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
Background image of page 3

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

View Full DocumentRight 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
Background image of page 4
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

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

View Full DocumentRight Arrow Icon
Background image of page 8
Background 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

This note was uploaded on 09/09/2009 for the course ENNEC 484W taught by Professor Considine,timothy during the Fall '09 term at Penn State.

Page1 / 9

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

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online