Antecedentes de la hoteleria

EJEMPLO:
PUNTOS | AÑOS | PRECIO | CANTIDAD | P% | C% | PTc | CTC |
0 | 2000 | 100 | 1000 | 0.76 | 7.75 | 100 | -10 |
1 | 2001 | 200 | 900 | 1.52 | 6.97 | 150 | -33.33 |
2 | 2002 | 500 | 600| 3.81 | 4.65 | -20 | 233.33 |
3 | 2003 | 400 | 2000 | 3.05 | 15.50 | 50 | -15 |
4 | 2004 | 600 | 1700 | 4.58 | 13.17 | 100 | -41.17 |
5 | 2005 | 1200 | 1000 | 9.16 | 7.75 | -8.33 | 300 |
6 |2006 | 1100 | 4000 | 8.39 | 31.00 | 81.81 | -62.5 |
7 | 2007 | 2000 | 1500 | 15.26 | 11.62 | 250 | -86.66 |
8 | 2008 | 7000 | 200 | 53.43 | 1.55 | | |
TOTAL | | 13,100 | 12,900 | 100% | 100%| | |

A) Elasticidades (Precio de la Demanda y cruzada)
(0,1); (1,2); (2,3); (3,4); (4,5); (5,6); (6,7); (7,8)
Formula 1:
* PRECIO DE LA DEMANDA
Ed = Q1-Q2Q1+Q2 ÷ P1-P2P1+P2Formula 2:
* ELASTICIDAD CRUZADA
Exy = Qx1-Qx2PQxi
Py1-Py2Py1
B) Pronostico de 1 año y grafica
Formula 3:
* Y2009 = a + bx

C) Tasa %
Formula 4:
*y=Na+ xb
Formula 5:
* xy= xa+ x2b

D) Tasa de crecimiento (TC)
Formula 6:
* Tc = (nVfVi -1)* 100
DONDE:
* Tc = Tasa de crecimiento
* vf = Valor final
* Vi =Valor inicial
PTC = (1200100 -1)* 100 = 100%
PTC = (1500200 -1)* 100 = 150%
PTC = (1400500 -1)* 100 = -20%
PTC = (1600400 -1)* 100 = 50%
PTC = (11200600 -1)* 100 = 100%
PTC= (111001200 -1)* 100 = -8.33%
PTC = (120001100 -1)* 100 = 81.81%
PTC = (170002000 -1)* 100 = 250%
A)
Ed = 1000-9001000+900 ÷ 100-200100+200 = 1001900÷ 100300 = .0526316-.03333 =-.1578 RI
Ed = 900-600900+600 ÷ 200-500200+500 = 3001500÷ -300700 = 0.200000-0.4228571 = -0.4729 RI
Ed = 600-2000600+2000 ÷ 500-400500+400 = -1400 2600÷ 100900 = -0.53840.1111 = - 4.8460 RI
Ed =2000-17002000+1700 ÷ 400-600400+600 = 3003700÷ -2001000 = 0.0810-0.2000 = -0.4050 RI
Ed = 1700-10001700+1000 ÷ 600-1200600+1200 = 7002700÷ -6001800 = 0.2592-0.3333 = -0.7776 RI
Ed = 1000-40001000+4000...