proyecciones electiva v

9
10% PERIODO AÑO X Y X . Y 1 2013 69,840.00 69,840.00 1.00 2 2014 76,824.00 153,648.00 4.00 3 2015 84,506.40 253,519.20 9.00 4 2016 92,957.04 371,828.16 16.00 5 2017 102,252.74 511,263.72 25.00 6 2018 112,478.02 674,868.11 36.00 7 2019 123,725.82 866,080.74 49.00 8 2020 136,098.40 1,088,787.22 64.00 9 2021 149,708.24 1,347,374.18 81.00 10 2022 164,679.07 1,646,790.67 100.00 55 1,113,069.73 6,984,000.00 385.00 5.50 111,306.97 Y = a + b(x) PROYECCION DE LA OFERTA b = X = 100.654,79 + 1.936,768(X a = 1 102,591.55 2 104,528.31 3 106,465.07 4 108,401.83 5 110,338.59 6 112,275.35 7 114,212.11 8 116,148.87 9 118,085.63 10 120,022.39 VENTAS DE TUBERIA (TON.METRICA)

Upload: angel1274

Post on 09-Nov-2015

224 views

Category:

Documents


5 download

DESCRIPTION

Proyecciones

TRANSCRIPT

OFERTA10%PERIODOAOVENTAS DE TUBERIA (TON.METRICA)XYX . YX1201369,840.0069,840.001.002201476,824.00153,648.004.003201584,506.40253,519.209.004201692,957.04371,828.1616.0052017102,252.74511,263.7225.0062018112,478.02674,868.1136.0072019123,725.82866,080.7449.0082020136,098.401,088,787.2264.0092021149,708.241,347,374.1881.00102022164,679.071,646,790.67100.00551,113,069.736,984,000.00385.005.50111,306.97Y = a + b(x)PROYECCION DE LA OFERTAb =1,936.76XY = 100.654,79 + 1.936,768(X)a =100,654.791102,591.552104,528.313106,465.074108,401.835110,338.596112,275.357114,212.118116,148.879118,085.6310120,022.39

Grfico11102591.552104528.313106465.074108401.835110338.596112275.357114212.118116148.879118085.6310120022.39

AOSTONELADAS-METRICASPROYECCION DE LA OFERTA DE TUBERIA

DEMANDA10%PERIODOAOCONSUMO DE TUBERIA (TON-METRICA)XYX . YX12013256,080.00256,080.001.0022014281,688.00563,376.004.0032015309,856.80929,570.409.0042016340,842.481,363,369.9216.0052017374,926.731,874,633.6425.0062018412,419.402,474,516.4036.0072019453,661.343,175,629.3949.0082020499,027.473,992,219.8064.0092021548,930.224,940,372.0081.00102022603,823.246,038,232.45100.00554,081,255.6925,608,000.00385.005.50408,125.57Y = a + b(x)PROYECCION DE LA DEMANDAb =7,908.13XY = 364.630,85,38 + 7.908,13(X)a =364,630.851372,538.982380,447.113388,355.244396,263.375404,171.506412,079.637419,987.768427,895.899435,804.0210443,712.15

Grfico21372538.982380447.113388355.244396263.375404171.56412079.637419987.768427895.899435804.0210443712.15

AOSTONELADAS-METRICASPROYECCION DE LA DEMANDA DE TUBERIA

PRECIOS10%PERIODOAOPRECIO DE TUBERIA D= 6" SCH 40 (BsF/TON-METRICA)XYX . YX120132,412,000.002,412,000.001.00220142,653,200.005,306,400.004.00320152,918,520.008,755,560.009.00420163,210,372.0012,841,488.0016.00520173,531,409.2017,657,046.0025.00620183,884,550.1223,307,300.7236.00720194,273,005.1329,911,035.9249.00820204,700,305.6537,602,445.1664.00920215,170,336.2146,533,025.8981.001020225,687,369.8356,873,698.31100.005538,441,068.14241,200,000.00385.005.503,844,106.81Y = a + b(x)b =77,032.89XY =a =3,420,425.9213,497,458.8123,574,491.7033,651,524.5943,728,557.4853,805,590.3763,882,623.2673,959,656.1584,036,689.0494,113,721.93104,190,754.82

Grfico313497458.8123574491.733651524.5943728557.4853805590.3763882623.2673959656.1584036689.0494113721.93104190754.82

AOSBSF/TON-METRICASPROYECCION DE PRECIOS