Production and Cost Spreadsheet

Click here to load reader

download Production and Cost Spreadsheet

of 98

  • date post

    21-Nov-2015
  • Category

    Documents

  • view

    10
  • download

    3

Embed Size (px)

description

Production and Cost Spreadsheet for microeconomics

Transcript of Production and Cost Spreadsheet

Production SRProduction Function:Q = KL =0.50 =0.50KLQLAP(L)MP(L)1000.000.000.001001.0010.001.0010.0010.001002.0014.142.007.074.141003.0017.323.005.773.181004.0020.004.005.002.681005.0022.365.004.472.361006.0024.496.004.082.131007.0026.467.003.781.961008.0028.288.003.541.831009.0030.009.003.331.7210010.0031.6210.003.161.6210011.0033.1711.003.021.5410012.0034.6412.002.891.4710013.0036.0613.002.771.4110014.0037.4214.002.671.3610015.0038.7315.002.581.3110016.0040.0016.002.501.2710017.0041.2317.002.431.2310018.0042.4318.002.361.2010019.0043.5919.002.291.1610020.0044.7220.002.241.1310021.0045.8321.002.181.1010022.0046.9022.002.131.0810023.0047.9623.002.091.0510024.0048.9924.002.041.0310025.0050.0025.002.001.0110026.0050.9926.001.960.9910027.0051.9627.001.920.9710028.0052.9228.001.890.9510029.0053.8529.001.860.9410030.0054.7730.001.830.9210031.0055.6831.001.800.9110032.0056.5732.001.770.8910033.0057.4533.001.740.8810034.0058.3134.001.710.8610035.0059.1635.001.690.8510036.0060.0036.001.670.8410037.0060.8337.001.640.8310038.0061.6438.001.620.8210039.0062.4539.001.600.8110040.0063.2540.001.580.8010041.0064.0341.001.560.7910042.0064.8142.001.540.7810043.0065.5743.001.520.7710044.0066.3344.001.510.7610045.0067.0845.001.490.7510046.0067.8246.001.470.7410047.0068.5647.001.460.7310048.0069.2848.001.440.7310049.0070.0049.001.430.7210050.0070.7150.001.410.7110051.0071.4151.001.400.7010052.0072.1152.001.390.7010053.0072.8053.001.370.6910054.0073.4854.001.360.6810055.0074.1655.001.350.6810056.0074.8356.001.340.6710057.0075.5057.001.320.6710058.0076.1658.001.310.6610059.0076.8159.001.300.6510060.0077.4660.001.290.6510061.0078.1061.001.280.6410062.0078.7462.001.270.6410063.0079.3763.001.260.6310064.0080.0064.001.250.6310065.0080.6265.001.240.6210066.0081.2466.001.230.6210067.0081.8567.001.220.6110068.0082.4668.001.210.6110069.0083.0769.001.200.6010070.0083.6770.001.200.6010071.0084.2671.001.190.6010072.0084.8572.001.180.5910073.0085.4473.001.170.5910074.0086.0274.001.160.5810075.0086.6075.001.150.5810076.0087.1876.001.150.5810077.0087.7577.001.140.5710078.0088.3278.001.130.5710079.0088.8879.001.130.5610080.0089.4480.001.120.5610081.0090.0081.001.110.5610082.0090.5582.001.100.5510083.0091.1083.001.100.5510084.0091.6584.001.090.5510085.0092.2085.001.080.5410086.0092.7486.001.080.5410087.0093.2787.001.070.5410088.0093.8188.001.070.5310089.0094.3489.001.060.5310090.0094.8790.001.050.5310091.0095.3991.001.050.5310092.0095.9292.001.040.5210093.0096.4493.001.040.5210094.0096.9594.001.030.5210095.0097.4795.001.030.5110096.0097.9896.001.020.5110097.0098.4997.001.020.5110098.0098.9998.001.010.5110099.0099.5099.001.010.50100100.00100.00100.001.000.50100101.00100.50101.001.000.50100102.00101.00102.000.990.50100103.00101.49103.000.990.49100104.00101.98104.000.980.49100105.00102.47105.000.980.49100106.00102.96106.000.970.49100107.00103.44107.000.970.48100108.00103.92108.000.960.48100109.00104.40109.000.960.48100110.00104.88110.000.950.48100111.00105.36111.000.950.48100112.00105.83112.000.940.47100113.00106.30113.000.940.47100114.00106.77114.000.940.47100115.00107.24115.000.930.47100116.00107.70116.000.930.47100117.00108.17117.000.920.46100118.00108.63118.000.920.46100119.00109.09119.000.920.46100120.00109.54120.000.910.46100121.00110.00121.000.910.46100122.00110.45122.000.910.45100123.00110.91123.000.900.45100124.00111.36124.000.900.45100125.00111.80125.000.890.45100126.00112.25126.000.890.45100127.00112.69127.000.890.44100128.00113.14128.000.880.44100129.00113.58129.000.880.44100130.00114.02130.000.880.44100131.00114.46131.000.870.44100132.00114.89132.000.870.44100133.00115.33133.000.870.43100134.00115.76134.000.860.43100135.00116.19135.000.860.43100136.00116.62136.000.860.43100137.00117.05137.000.850.43100138.00117.47138.000.850.43100139.00117.90139.000.850.42100140.00118.32140.000.850.42100141.00118.74141.000.840.42100142.00119.16142.000.840.42100143.00119.58143.000.840.42100144.00120.00144.000.830.42100145.00120.42145.000.830.42100146.00120.83146.000.830.41100147.00121.24147.000.820.41100148.00121.66148.000.820.41100149.00122.07149.000.820.41100150.00122.47150.000.820.41100151.00122.88151.000.810.41100152.00123.29152.000.810.41100153.00123.69153.000.810.40100154.00124.10154.000.810.40100155.00124.50155.000.800.40100156.00124.90156.000.800.40100157.00125.30157.000.800.40100158.00125.70158.000.800.40100159.00126.10159.000.790.40100160.00126.49160.000.790.40100161.00126.89161.000.790.39100162.00127.28162.000.790.39100163.00127.67163.000.780.39100164.00128.06164.000.780.39100165.00128.45165.000.780.39100166.00128.84166.000.780.39100167.00129.23167.000.770.39100168.00129.61168.000.770.39100169.00130.00169.000.770.39100170.00130.38170.000.770.38100171.00130.77171.000.760.38100172.00131.15172.000.760.38100173.00131.53173.000.760.38100174.00131.91174.000.760.38100175.00132.29175.000.760.38100176.00132.66176.000.750.38100177.00133.04177.000.750.38100178.00133.42178.000.750.38100179.00133.79179.000.750.37100180.00134.16180.000.750.37100181.00134.54181.000.740.37100182.00134.91182.000.740.37100183.00135.28183.000.740.37100184.00135.65184.000.740.37100185.00136.01185.000.740.37100186.00136.38186.000.730.37100187.00136.75187.000.730.37100188.00137.11188.000.730.37100189.00137.48189.000.730.36100190.00137.84190.000.730.36100191.00138.20191.000.720.36100192.00138.56192.000.720.36100193.00138.92193.000.720.36100194.00139.28194.000.720.36100195.00139.64195.000.720.36100196.00140.00196.000.710.36100197.00140.36197.000.710.36100198.00140.71198.000.710.36100199.00141.07199.000.710.35100200.00141.42200.000.710.35100201.00141.77201.000.710.35100202.00142.13202.000.700.35100203.00142.48203.000.700.35100204.00142.83204.000.700.35100205.00143.18205.000.700.35100206.00143.53206.000.700.35100207.00143.87207.000.700.35100208.00144.22208.000.690.35100209.00144.57209.000.690.35100210.00144.91210.000.690.35100211.00145.26211.000.690.34100212.00145.60212.000.690.34100213.00145.95213.000.690.34100214.00146.29214.000.680.34100215.00146.63215.000.680.34100216.00146.97216.000.680.34100217.00147.31217.000.680.34100218.00147.65218.000.680.34100219.00147.99219.000.680.34100220.00148.32220.000.670.34100221.00148.66221.000.670.34100222.00149.00222.000.670.34100223.00149.33223.000.670.34100224.00149.67224.000.670.33100225.00150.00225.000.670.33100226.00150.33226.000.670.33100227.00150.67227.000.660.33100228.00151.00228.000.660.33100229.00151.33229.000.660.33100230.00151.66230.000.660.33100231.00151.99231.000.660.33100232.00152.32232.000.660.33100233.00152.64233.000.660.33100234.00152.97234.000.650.33100235.00153.30235.000.650.33100236.00153.62236.000.650.33100237.00153.95237.000.650.33100238.00154.27238.000.650.32100239.00154.60239.000.650.32100240.00154.92240.000.650.32100241.00155.24241.000.640.32100242.00155.56242.000.640.32100243.00155.88243.000.640.32100244.00156.20244.000.640.32100245.00156.52245.000.640.32100246.00156.84246.000.640.32100247.00157.16247.000.640.32100248.00157.48248.000.640.32100249.00157.80249.000.630.32100250.00158.11250.000.630.32100251.00158.43251.000.630.32100252.00158.75252.000.630.32100253.00159.06253.000.630.31100254.00159.37254.000.630.31100255.00159.69255.000.630.31100256.00160.00256.000.630.31100257.00160.31257.000.620.31100258.00160.62258.000.620.31100259.00160.93259.000.620.31100260.00161.25260.000.620.31100261.00161.55261.000.620.31100262.00161.86262.000.620.31100263.00162.17263.000.620.31100264.00162.48264.000.620.31100265.00162.79265.000.610.31100266.00163.10266.000.610.31100267.00163.40267.000.610.31100268.00163.71268.000.610.31100269.00164.01269.000.610.31100270.00164.32270.000.610.30100271.00164.62271.000.610.30100272.00164.92272.000.610.30100273.00165.23273.000.610.30100274.00165.53274.000.600.30100275.00165.83275.000.600.30100276.00166.13276.000.600.30100277.00166.43277.000.600.30100278.00166.73278.000.600.30100279.00167.03279.000.600.30100280.00167.33280.000.600.30100281.00167.63281.000.600.30100282.00167.93282.000.600.30100283.00168.23283.000.590.30100284.00168.52284.000.590.30100285.00168.82285.000.590.30100286.00169.12286.000.590.30100287.00169.41287.000.590.30100288.00169.71288.000.590.29100289.00170.00289.000.590.29100290.00170.29290.000.590.29100291.00170.59291.000.590.29100292.00170.88292.000.590.29100293.00171.17293.000.580.29100294.00171.46294.000.580.29100295.00171.76295.000.580.29100296.00172.05296.000.580.29100297.00172.34297.000.580.29100298.00172.63298.000.580.29100299.00172.92299.000.580.29100300.00173.21300.000.580.29100301.00173.49301.000.580.29100302.00173.78302.000.580.29100303.00174.07303.000.570.29100304.00174.36304.000.570.29100305.00174.64305.000.570.29100306.00174.93306.000.570.29100307.00175.21307.000.570.29100308.00175.50308.000.570.29100309.00175.78309.000.570.28100310.00176.07310.000.570.28100311.00176.35311.000.570.28100312.00176.64312.000.570.28100313.00176.92313.000.570.28100314.00177.20314.000.560.28100315.00177.48315.000.560.28100316.00177.76316.000.560.28100317.00178.04317.000.560.28100318.00178.33318.000.560.28100319.00178.61319.000.560.28100320.00178.89320.000.560.28100321.00179.16321.000.560.28100322.00179.44322.000.560.28100323.00179.72323.000.560.28100324.00180.00324.000.560.28100325.00180.28325.000.550.28100326.00180.55326.000.550.28100327.00180.83327.000.550.28100328.00181.11328.000.550.28100329.00181.38329.000.550.28100330.00181.66330.000.550.28100331.00181.93331.000.550.28100332.00182.21332.000.550.27100333.00182.48333.000.550.27100334.00182.76334.000.550.27100335.00183.03335.000.550.27100336.00183.30336.000.550.27100337.00183.58337.000.540.27100338.00183.85338.000.540.27100339.00184.12339.000.540.27100340.00184.39340.000.540.27100341.00184.66341.000.540.27100342.00184.93342.000.540.27100343.00185.20343.000.540.27100344.00185.47344.000.540.27100345.00185.74345.000.540.27100346.00186.01346.000.540.27100347.00186.28347.000.540.27100348.00186.55348.000.540.27100349.00186.82349.000.540.27100350.00187.08350.000.530.27100351.00187.35351.000.530.27100352.00187.62352.000.530.27100353.00187.88353.000