tarifas sugeridas 2008 virgilio.xlsx

21
BODEGA DESTINO TVH 900 BARRANQUILLA TVH 350 900 CARTAGENA TVH 350 900 SANTA MARTA TVH 350 900 SINCELEJO TVH 350 900 VALLEDUPAR TVH 350 900 MONTERIA TVH 350 900 CAUCACIA TVH 350 9.23% Total TVH 350 900 BARRANQUILLA TVH TURBO 900 CARTAGENA TVH TURBO 900 SANTA MARTA TVH TURBO 900 SINCELEJO TVH TURBO 900 VALLEDUPAR TVH TURBO 900 MONTERIA TVH TURBO 900 CAUCACIA TVH TURBO 9.48% Total TVH TURBO 900 BARRANQUILLA TVH 600 900 CARTAGENA TVH 600 900 SANTA MARTA TVH 600 900 SINCELEJO TVH 600 900 VALLEDUPAR TVH 600 900 MONTERIA TVH 600 900 CAUCACIA TVH 600 9.95% Total TVH 600 900 BARRANQUILLA TVH 800 900 CARTAGENA TVH 800 900 SANTA MARTA TVH 800 900 SINCELEJO TVH 800 900 VALLEDUPAR TVH 800 900 MONTERIA TVH 800 900 CAUCACIA TVH 800 -7.57% Total TVH 800 8.98% Total general

Upload: olgaluciabermudezlindado

Post on 15-Nov-2015

18 views

Category:

Documents


2 download

TRANSCRIPT

Hoja10.07BODEGADESTINO TVHDesp. Dia 2007Part x DespTARIFA 2007FACT. x DIA 2007Part x Facturacion 2007TARIFA 2008 POND% OPT TARIFA 2008Difrencia Tarifas 2008 vs 2007FACT. x DIA 2008Part x Facturacion 2008900BARRANQUILLA TVH 3502.7397.08%$ 82,000$ 224,5982.27%$ 90,0009.76%$8,000$ 246,5102.29%900CARTAGENA TVH 3501.1653.01%$ 234,500$ 273,1932.76%$ 255,0008.74%$20,500$ 297,0752.76%900SANTA MARTA TVH 3500.0320.08%$ 245,200$ 7,8460.08%$ 272,00010.93%$26,800$ 8,7040.08%900SINCELEJO TVH 3500.0040.01%00.00.00%0.00.00%$00.00.00%900VALLEDUPAR TVH 3500.0000.00%00.00.00%0.00.00%$00.00.00%900MONTERIA TVH 3500.0000.00%00.00.00%0.00.00%$00.00.00%900CAUCACIATVH 3500.0000.00%00.00.00%0.00.00%$00.00.00%9.23%Total TVH 3503.94010.19%$ 505,6375.12%$ 552,2895.13%900BARRANQUILLA TVH TURBO10.47827.09%$ 92,100$ 965,0249.77%$ 107,00016.18%$14,900$ 1,121,14610.41%900CARTAGENA TVH TURBO6.73517.41%$ 275,000$ 1,852,12518.74%$ 300,0009.09%$25,000$ 2,020,50018.76%900SANTA MARTA TVH TURBO1.3783.56%$ 286,000$ 394,1083.99%$ 310,0008.39%$24,000$ 427,1803.97%900SINCELEJO TVH TURBO0.8312.15%$ 491,600$ 408,5204.13%$ 523,0006.39%$31,400$ 434,6134.04%900VALLEDUPAR TVH TURBO0.7071.83%$ 540,900$ 382,4163.87%$ 580,0007.23%$39,100$ 410,0603.81%900MONTERIA TVH TURBO0.8512.20%$ 540,900$ 460,3064.66%$ 580,0007.23%$39,100$ 493,5804.58%900CAUCACIATVH TURBO0.5301.37%$ 831,600$ 440,7484.46%$ 870,0004.62%$38,400$ 461,1004.28%9.48%Total TVH TURBO21.51055.61%$ 4,903,24749.62%$ 5,368,17949.85%900BARRANQUILLA TVH 6005.14113.29%$ 101,100$ 519,7555.26%$ 130,00028.59%$28,900$ 668,3306.21%900CARTAGENA TVH 6001.2373.20%$ 344,400$ 426,0234.31%$ 370,0007.43%$25,600$ 457,6904.25%900SANTA MARTA TVH 6003.2218.33%$ 360,600$ 1,161,49311.75%$ 390,0008.15%$29,400$ 1,256,19011.66%900SINCELEJO TVH 6000.8352.16%$ 591,400$ 493,8195.00%$ 623,0005.34%$31,600$ 520,2054.83%900VALLEDUPAR TVH 6000.8712.25%$ 649,100$ 565,3665.72%$ 700,0007.84%$50,900$ 609,7005.66%900MONTERIA TVH 6001.0802.79%$ 649,100$ 701,0287.09%$ 700,0007.84%$50,900$ 756,0007.02%900CAUCACIATVH 6000.2250.58%$ 936,600$ 210,7352.13%$ 960,0002.50%$23,400$ 216,0002.01%9.95%Total TVH 60012.61032.60%$ 4,078,21941.27%$ 4,484,11541.64%900BARRANQUILLA TVH 8000.0240.06%$ 108,900$ 2,6140.03%$ 130,00019.38%$21,100$ 3,1200.03%900CARTAGENA TVH 8000.0400.10%$ 420,900$ 16,8360.17%$ 370,000(12.09%)($50,900)$ 14,8000.14%900SANTA MARTA TVH 8000.1450.37%$ 420,900$ 61,0310.62%$ 390,000(7.34%)($30,900)$ 56,5500.53%900SINCELEJO TVH 8000.0560.14%$ 690,250$ 38,6540.39%$ 623,000(9.74%)($67,250)$ 34,8880.32%900VALLEDUPAR TVH 8000.1450.37%$ 757,600$ 109,8521.11%$ 700,000(7.60%)($57,600)$ 101,5000.94%900MONTERIA TVH 8000.1930.50%$ 757,600$ 146,2171.48%$ 700,000(7.60%)($57,600)$ 135,1001.25%900CAUCACIATVH 8000.0200.05%$ 993,600$ 19,8720.20%$ 960,000(3.38%)($33,600)$ 19,2000.18%-7.57%Total TVH 8000.6231.61%$ 395,0754.00%$ 365,1583.39%8.98%Total general38.683100.00%$ 9,882,177100.00%$ 10,769,741100.00%

BODEGADESTINO TVHDesp. Dia 2007Part x DespTARIFA 2007FACT. x DIA 2007Part x Facturacion 2007TARIFA 2008 POND% OPT TARIFA 2008Difrencia Tarifas 2008 vs 2007FACT. x DIA 2008Part x Facturacion 2008904 FRUVERBARRANQUILLA TVH 35011.42823.73%$ 60,187$ 687,8157.61%$ 74,00022.95%$13,813$ 845,6728.64%904 FRUVERCARTAGENA TVH 3500.6041.25%$ 230,062$ 138,9581.54%$ 245,0006.49%$14,938$ 147,9801.51%904 FRUVERSANTA MARTA TVH 3500.4340.90%$ 240,662$ 104,4471.15%$ 255,0005.96%$14,338$ 110,6701.13%904 FRUVERSINCELEJO TVH 3500.0000.00%0.00.00.00%0.00.00%$00.00.00%904 FRUVERVALLEDUPAR TVH 3500.0000.00%0.00.00.00%0.00.00%$00.00.00%904 FRUVERMONTERIA TVH 3500.0000.00%0.00.00.00%0.00.00%$00.00.00%904 FRUVERCAUCACIATVH 3500.0000.00%0.00.00.00%0.00.00%$00.00.00%18.59%Total TVH 35012.46625.88%$ 931,22010.30%$ 1,104,32211.28%904 FRUVERBARRANQUILLA TVH 350 REF1.6373.40%$ 64,013$ 104,7901.16%$ 81,00026.54%$16,987$ 132,5971.35%904 FRUVERCARTAGENA TVH 350 REF0.0110.02%$ 234,302$ 2,5770.03%$ 250,0006.70%$15,698$ 2,7500.03%904 FRUVERSANTA MARTA TVH 350 REF0.0000.00%$ 244,902$ 00.00%$ 270,00010.25%$25,098$ 00.00%904 FRUVERSINCELEJO TVH 350 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 FRUVERVALLEDUPAR TVH 350 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 FRUVERMONTERIA TVH 350 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 FRUVERCAUCACIATVH 350 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%26.06%Total TVH 350 REF1.6483.42%$ 107,3671.19%$ 135,3471.38%904 FRUVERBARRANQUILLA TVH TURBO6.29613.07%$ 67,119$ 422,5824.67%$ 90,00034.09%$22,881$ 566,6405.79%904 FRUVERCARTAGENA TVH TURBO4.7649.89%$ 269,696$ 1,284,83114.21%$ 288,0006.79%$18,304$ 1,372,03214.01%904 FRUVERSANTA MARTA TVH TURBO1.7203.57%$ 280,296$ 482,1095.33%$ 299,0006.67%$18,704$ 514,2805.25%904 FRUVERSINCELEJO TVH TURBO0.2250.47%$ 482,512$ 108,5651.20%$ 510,0005.70%$27,488$ 114,7501.17%904 FRUVERVALLEDUPAR TVH TURBO0.4620.96%$ 530,869$ 245,2622.71%$ 568,0006.99%$37,131$ 262,4162.68%904 FRUVERMONTERIA TVH TURBO0.2090.43%$ 530,869$ 110,9521.23%$ 568,0006.99%$37,131$ 118,7121.21%904 FRUVERCAUCACIATVH TURBO0.0930.19%$ 816,200$ 75,9070.84%$ 840,0002.92%$23,800$ 78,1200.80%10.87%Total TVH TURBO13.76928.59%$ 2,730,20730.19%$ 3,026,95030.91%904 FRUVERBARRANQUILLA TVH TURBO REF5.79112.02%$ 76,765$ 444,5474.92%$ 117,00052.41%$40,235$ 677,5476.92%904 FRUVERCARTAGENA TVH TURBO REF0.4180.87%$ 328,070$ 137,1331.52%$ 350,0006.68%$21,930$ 146,3001.49%904 FRUVERSANTA MARTA TVH TURBO REF0.0220.05%$ 338,670$ 7,4510.08%$ 360,0006.30%$21,330$ 7,9200.08%904 FRUVERSINCELEJO TVH TURBO REF0.5381.12%$ 488,395$ 262,7572.91%$ 522,0006.88%$33,605$ 280,8362.87%904 FRUVERVALLEDUPAR TVH TURBO REF0.5381.12%$ 552,101$ 297,0303.28%$ 590,0006.86%$37,899$ 317,4203.24%904 FRUVERMONTERIA TVH TURBO REF0.7251.51%$ 552,101$ 400,2734.43%$ 590,0006.86%$37,899$ 427,7504.37%904 FRUVERCAUCACIATVH TURBO REF0.2860.59%$ 869,200$ 248,5912.75%$ 910,0004.69%$40,800$ 260,2602.66%17.81%Total TVH TURBO REF8.31817.27%$ 1,797,78319.88%$ 2,118,03321.63%904 FRUVERBARRANQUILLA TVH 6002.8235.86%$ 70,819$ 199,9212.21%$ 120,00069.45%$49,181$ 338,7603.46%904 FRUVERCARTAGENA TVH 6000.4560.95%$ 338,013$ 154,1341.70%$ 360,0006.50%$21,987$ 164,1601.68%904 FRUVERSANTA MARTA TVH 6000.2020.42%$ 353,913$ 71,4900.79%$ 378,0006.81%$24,087$ 76,3560.78%904 FRUVERSINCELEJO TVH 6000.0980.20%$ 580,414$ 56,8810.63%$ 621,0006.99%$40,586$ 60,8580.62%904 FRUVERVALLEDUPAR TVH 6000.1700.35%$ 637,039$ 108,2971.20%$ 681,0006.90%$43,961$ 115,7701.18%904 FRUVERMONTERIA TVH 6000.1150.24%$ 637,039$ 73,2590.81%$ 681,0006.90%$43,961$ 78,3150.80%904 FRUVERCAUCACIATVH 6000.0050.01%$ 922,200$ 4,6110.05%$ 940,0001.93%$17,800$ 4,7000.05%25.48%Total TVH 6003.8698.03%$ 668,5937.39%$ 838,9198.57%904 FRUVERBARRANQUILLA TVH 600 REF0.0220.05%$ 79,023$ 1,7390.02%$ 148,00087.29%$68,977$ 3,2560.03%904 FRUVERCARTAGENA TVH 600 REF0.0000.00%$ 408,7890.00.00%$ 440,0007.63%$31,2110.00.00%904 FRUVERSANTA MARTA TVH 600 REF0.0000.00%$ 424,6890.00.00%$ 460,0008.31%$35,3110.00.00%904 FRUVERSINCELEJO TVH 600 REF0.2530.53%$ 637,039$ 161,1711.78%$ 681,0006.90%$43,961$ 172,2931.76%904 FRUVERVALLEDUPAR TVH 600 REF0.2860.59%$ 707,815$ 202,4352.24%$ 757,0006.95%$49,185$ 216,5022.21%904 FRUVERMONTERIA TVH 600 REF0.4510.94%$ 707,815$ 319,2253.53%$ 757,0006.95%$49,185$ 341,4073.49%904 FRUVERCAUCACIATVH 600 REF0.0550.11%$ 985,800$ 54,2190.60%$ 1,020,0003.47%$34,200$ 56,1000.57%6.87%Total TVH 600 REF1.0672.22%$ 738,7888.17%$ 789,5588.06%904 FRUVERBARRANQUILLA TVH 350 std by0.0380.08%$ 64,013$ 2,4320.03%$ 81,00026.54%$16,987$ 3,0780.03%904 FRUVERCARTAGENA TVH 350 std by0.0060.01%$ 266,102$ 1,5970.02%$ 250,000(6.05%)($16,102)$ 1,5000.02%904 FRUVERSANTA MARTA TVH 350 std by0.0000.00%0.00.00.00%$ 270,0000.00%$270,0000.00.00%904 FRUVERSINCELEJO TVH 350 std by0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 FRUVERVALLEDUPAR TVH 350 std by0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 FRUVERMONTERIA TVH 350 std by0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 FRUVERCAUCACIATVH 350 std by0.0000.00%0.00.00.00%0.00.00%$00.00.00%13.62%Total TVH 350 std by0.0440.09%$ 4,0290.04%$ 4,5780.05%904 FRUVERBARRANQUILLA TVH TURBO STD BY5.02610.44%$ 169,600$ 852,4109.43%$ 117,000(31.01%)($52,600)$ 588,0426.01%904 FRUVERCARTAGENA TVH TURBO STD BY0.3460.72%$ 359,870$ 124,5151.38%$ 350,000(2.74%)($9,870)$ 121,1001.24%904 FRUVERSANTA MARTA TVH TURBO STD BY0.0000.00%$ 370,4700.00.00%$ 360,000(2.83%)($10,470)0.00.00%904 FRUVERSINCELEJO TVH TURBO STD BY0.3650.76%$ 520,195$ 189,8712.10%$ 522,0000.35%$1,805$ 190,5301.95%904 FRUVERVALLEDUPAR TVH TURBO STD BY0.0000.00%$ 583,9010.00.00%$ 590,0001.04%$6,0990.00.00%904 FRUVERMONTERIA TVH TURBO STD BY0.5641.17%$ 583,901$ 329,3203.64%$ 590,0001.04%$6,099$ 332,7603.40%904 FRUVERCAUCACIATVH TURBO STD BY0.2440.51%$ 901,000$ 219,8442.43%$ 910,0001.00%$9,000$ 222,0402.27%-15.24%Total TVH TURBO STD BY6.54513.59%$ 1,715,96018.97%$ 1,454,47214.85%904 FRUVERBARRANQUILLA TVH 600 STD BY0.0130.03%$ 169,600$ 2,2050.02%$ 148,000(12.74%)($21,600)$ 1,9240.02%904 FRUVERCARTAGENA TVH 600 STD BY0.0000.00%$ 440,5890.00.00%$ 440,000(0.13%)($589)0.00.00%904 FRUVERSANTA MARTA TVH 600 STD BY0.0000.00%$ 456,9150.00.00%$ 460,0000.68%$3,0850.00.00%904 FRUVERSINCELEJO TVH 600 STD BY0.0580.12%$ 668,839$ 38,7930.43%$ 681,0001.82%$12,161$ 39,4980.40%904 FRUVERVALLEDUPAR TVH 600 STD BY0.0000.00%$ 739,5210.00.00%$ 757,0002.36%$17,4790.00.00%904 FRUVERMONTERIA TVH 600 STD BY0.0640.13%$ 739,615$ 47,3350.52%$ 757,0002.35%$17,385$ 48,4480.49%904 FRUVERCAUCACIATVH 600 STD BY0.0190.04%$ 1,017,600$ 19,3340.21%$ 1,020,0000.24%$2,400$ 19,3800.20%1.47%Total TVH 600 STD BY0.1540.32%$ 107,6671.19%$ 109,2501.12%904 FRUVERBARRANQUILLA TVH 800 STD BY0.0000.00%$ 168,7280.00.00%$ 148,000(12.28%)($20,728)0.00.00%904 FRUVERCARTAGENA TVH 800 STD BY0.0000.00%$ 513,1140.00.00%$ 440,000(14.25%)($73,114)0.00.00%904 FRUVERSANTA MARTA TVH 800 STD BY0.0000.00%$ 513,1140.00.00%$ 460,000(10.35%)($53,114)0.00.00%904 FRUVERSINCELEJO TVH 800 STD BY0.0770.16%$ 764,451$ 58,8630.65%$ 681,000(10.92%)($83,451)$ 52,4370.54%904 FRUVERVALLEDUPAR TVH 800 STD BY0.0000.00%$ 881,1890.00.00%$ 757,000(14.09%)($124,189)0.00.00%904 FRUVERMONTERIA TVH 800 STD BY0.1920.40%$ 881,189$ 169,1881.87%$ 757,000(14.09%)($124,189)$ 145,3441.48%904 FRUVERCAUCACIATVH 800 STD BY0.0130.03%$ 1,075,900$ 13,9870.15%$ 1,020,000(5.20%)($55,900)$ 13,2600.14%-12.81%Total TVH 800 STD BY0.2820.59%$ 242,0382.68%$ 211,0412.16%904 FRUVERBARRANQUILLA TVH 800 REF0.00%$ 117,4470.00.00%$ 125,6687.00%$8,2210.00.00%904 FRUVERCARTAGENA TVH 800 REF0.00%$ 481,3140.00.00%$ 515,0067.00%$33,6920.00.00%904 FRUVERSANTA MARTA TVH 800 REF0.00%$ 481,3140.00.00%$ 515,0067.00%$33,6920.00.00%904 FRUVERSINCELEJO TVH 800 REF0.00%$ 732,6510.00.00%$ 783,9377.00%$51,2860.00.00%904 FRUVERVALLEDUPAR TVH 800 REF0.00%$ 849,3890.00.00%$ 908,8467.00%$59,4570.00.00%904 FRUVERMONTERIA TVH 800 REF0.00%$ 849,3890.00.00%$ 908,8467.00%$59,4570.00.00%904 FRUVERCAUCACIATVH 800 REF0.00%$ 1,044,1000.00.00%$ 1,117,1877.00%$73,0870.00.00%ERROR:#DIV/0!Total TVH 800 REF0.0000.00%0.00.00%0.00.00%8.28%Total general48.162100.00%$ 9,043,652100.00%$ 9,792,470100.00%

BODEGADESTINO TVHDesp. Dia 2007Part x DespTARIFA 2007FACT. x DIA 2007Part x Facturacion 2007TARIFA 2008 POND% OPT TARIFA 2008Difrencia Tarifas 2008 vs 2007FACT. x DIA 2008Part x Facturacion 2008904 GRANOSBARRANQUILLA TVH 3502.13218.60%$ 66,960$ 142,7596.07%$ 74,00010.51%$7,040$ 157,7686.14%904 GRANOSCARTAGENA TVH 3500.3192.78%$ 230,062$ 73,3903.12%$ 245,0006.49%$14,938$ 78,1553.04%904 GRANOSSANTA MARTA TVH 3500.1261.10%$ 240,662$ 30,3231.29%$ 255,0005.96%$14,338$ 32,1301.25%904 GRANOSSINCELEJO TVH 3500.0000.00%0.00.00.00%0.00.00%$00.00.00%904 GRANOSVALLEDUPAR TVH 3500.0040.03%0.00.00.00%0.00.00%$00.00.00%904 GRANOSMONTERIA TVH 3500.0000.00%0.00.00.00%0.00.00%$00.00.00%904 GRANOSCAUCACIATVH 3500.0000.00%0.00.00.00%0.00.00%$00.00.00%8.76%Total TVH 3502.58122.52%$ 246,47310.47%$ 268,05310.43%904 GRANOSBARRANQUILLA TVH TURBO3.56131.07%$ 75,027$ 267,17011.35%$ 90,00019.96%$14,973$ 320,49012.47%904 GRANOSCARTAGENA TVH TURBO1.61614.10%$ 269,696$ 435,82818.52%$ 288,0006.79%$18,304$ 465,40818.10%904 GRANOSSANTA MARTA TVH TURBO1.0228.92%$ 280,296$ 286,46212.17%$ 299,0006.67%$18,704$ 305,57811.89%904 GRANOSSINCELEJO TVH TURBO0.1321.15%$ 482,512$ 63,6922.71%$ 510,0005.70%$27,488$ 67,3202.62%904 GRANOSVALLEDUPAR TVH TURBO0.3132.73%$ 530,869$ 166,1627.06%$ 568,0006.99%$37,131$ 177,7846.92%904 GRANOSMONTERIA TVH TURBO0.3523.07%$ 530,869$ 186,8667.94%$ 568,0006.99%$37,131$ 199,9367.78%904 GRANOSCAUCACIATVH TURBO0.1921.68%$ 816,200$ 156,7106.66%$ 840,0002.92%$23,800$ 161,2806.27%8.63%Total TVH TURBO7.18862.72%$ 1,562,89166.41%$ 1,697,79666.04%904 GRANOSBARRANQUILLA TVH 6000.7636.66%$ 82,108$ 62,6482.66%$ 120,00046.15%$37,892$ 91,5603.56%904 GRANOSCARTAGENA TVH 6000.1361.19%$ 338,013$ 45,9701.95%$ 360,0006.50%$21,987$ 48,9601.90%904 GRANOSSANTA MARTA TVH 6000.2352.05%$ 353,913$ 83,1703.53%$ 378,0006.81%$24,087$ 88,8303.46%904 GRANOSSINCELEJO TVH 6000.1581.38%$ 580,414$ 91,705.33.90%$ 621,0006.99%$40,586$ 98,118.03.82%904 GRANOSVALLEDUPAR TVH 6000.1921.68%$ 637,039$ 122,311.45.20%$ 681,0006.90%$43,961$ 130,752.05.09%904 GRANOSMONTERIA TVH 6000.1851.61%$ 637,039$ 117,8525.01%$ 681,0006.90%$43,961$ 125,9854.90%904 GRANOSCAUCACIATVH 6000.0220.19%$ 922,200$ 20,2880.86%$ 940,0001.93%$17,800$ 20,6800.80%11.20%Total TVH 6001.69114.76%$ 543,94523.11%$ 604,88523.53%9.24%Total general11.460100.00%$ 2,353,308100.00%$ 2,570,734100.00%

BODEGADESTINO TVHDesp. Dia 2007Part x DespTARIFA 2007FACT. x DIA 2007Part x Facturacion 2007TARIFA 2008 POND% OPT TARIFA 2008Difrencia Tarifas 2008 vs 2007FACT. x DIA 2008Part x Facturacion 2008904 PESCADOBARRANQUILLA TVH 350 AIS0.0842.08%$ 66,960$ 5,6310.87%$ 74,00010.51%$7,040$ 6,2230.89%904 PESCADOCARTAGENA TVH 350 AIS0.0000.00%$ 240,6620.00.00%$ 257,0006.79%$16,3380.00.00%904 PESCADOSANTA MARTA TVH 350 AIS0.0020.05%$ 240,662$ 4810.07%$ 257,0006.79%$16,338$ 5140.07%904 PESCADOCIENAGATVH 350 AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOSINCELEJO TVH 350 AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOVALLEDUPAR TVH 350 AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOMONTERIA TVH 350 AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOCAUCACIATVH 350 AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%10.22%Total TVH 350 AIS0.0862.13%$ 6,1130.94%$ 6,7370.97%904 PESCADOBARRANQUILLA TVH 350 REF0.74218.32%$ 70,787$ 52,5248.11%$ 81,00014.43%$10,213$ 60,1028.61%904 PESCADOCARTAGENA TVH 350 REF0.0000.00%$ 244,9020.00.00%$ 262,0006.98%$17,0980.00.00%904 PESCADOSANTA MARTA TVH 350 REF0.0000.00%$ 244,9020.00.00%$ 262,0006.98%$17,0980.00.00%904 PESCADOCIENAGATVH 350 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOSINCELEJO TVH 350 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOVALLEDUPAR TVH 350 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOMONTERIA TVH 350 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOCAUCACIATVH 350 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%14.43%Total TVH 350 REF0.74218.32%$ 52,5248.11%$ 60,1028.61%904 PESCADOBARRANQUILLA TVH TURBO AIS0.64816.00%$ 75,027$ 48,6177.51%$ 82,0009.29%$6,973$ 53,1367.61%904 PESCADOCARTAGENA TVH TURBO AIS0.0050.12%$ 269,696$ 1,3480.21%$ 288,0006.79%$18,304$ 1,4400.21%904 PESCADOSANTA MARTA TVH TURBO AIS0.0000.00%$ 280,2960.00.00%$ 299,0006.67%$18,7040.00.00%904 PESCADOCIENAGATVH TURBO AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOSINCELEJO TVH TURBO AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOVALLEDUPAR TVH TURBO AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOMONTERIA TVH TURBO AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOCAUCACIATVH TURBO AIS0.0000.00%0.00.00.00%0.00.00%$00.00.00%9.23%Total TVH TURBO AIS0.65316.12%$ 49,9667.72%$ 54,5767.82%904 PESCADOBARRANQUILLA TVH TURBO REF1.59339.32%$ 84,662$ 134,86720.83%$ 91,0007.49%$6,338$ 144,96320.76%904 PESCADOCARTAGENA TVH TURBO REF0.46711.53%$ 338,670$ 158,15924.43%$ 362,0006.89%$23,330$ 169,05424.21%904 PESCADOSANTA MARTA TVH TURBO REF0.2255.55%$ 338,670$ 76,20111.77%$ 362,0006.89%$23,330$ 81,45011.67%904 PESCADOCIENAGATVH TURBO REF0.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOSINCELEJO TVH TURBO REF0.0270.67%$ 488,395$ 13,1872.04%$ 522,0006.88%$33,605$ 14,0942.02%904 PESCADOVALLEDUPAR TVH TURBO REF0.0992.44%$ 552,101$ 54,6588.44%$ 590,0006.86%$37,899$ 58,4108.37%904 PESCADOMONTERIA TVH TURBO REF0.1152.84%$ 552,101$ 63,4929.81%$ 590,0006.86%$37,899$ 67,8509.72%904 PESCADOCAUCACIATVH TURBO REF0.0441.09%$ 869,200$ 38,2455.91%$ 930,0006.99%$60,800$ 40,9205.86%7.04%Total TVH TURBO REF2.57063.44%$ 538,80783.23%$ 576,74182.61%904 PESCADOBARRANQUILLA TVH 600 REF0.0000.00%$ 85,2900.00.00%$ 148,00073.53%$62,7100.00.00%904 PESCADOCARTAGENA TVH 600 REF0.0000.00%$ 408,7890.00.00%$ 437,0006.90%$28,2110.00.00%904 PESCADOSANTA MARTA TVH 600 REF0.0000.00%$ 424,6890.00.00%$ 454,0006.90%$29,3110.00.00%904 PESCADOCIENAGATVH 600 REF0.0000.00%0.00.00.00%0.00.00%$00.00.00%904 PESCADOSINCELEJO TVH 600 REF0.0000.00%$ 637,0890.00.00%$ 681,0006.89%$43,9110.00.00%904 PESCADOVALLEDUPAR TVH 600 REF0.0000.00%$ 707,8150.00.00%$ 757,0006.95%$49,1850.00.00%904 PESCADOMONTERIA TVH 600 REF0.0000.00%$ 707,8150.00.00%$ 757,0006.95%$49,1850.00.00%904 PESCADOCAUCACIATVH 600 REF0.0000.00%$ 985,8000.00.00%$ 1,000,0001.44%$14,2000.00.00%ERROR:#DIV/0!Total TVH 600 REF0.0000.00%0.00.00%0.00.00%7.84%Total general4.051100.00%$ 647,410100.00%$ 698,156100.00%

BODEGADESTINO TVHDesp. Dia 2007Part x DespTARIFA 2007FACT. x DIA 2007Part x Facturacion 2007TARIFA 2008 POND% OPT TARIFA 2008Difrencia Tarifas 2008 vs 2007FACT. x DIA 2008Part x Facturacion 2008904 CARNESBARRANQUILLA TVH 350 AIS0.03315.57%$ 113,634$ 3,7500.033$ 121,0006.48%$7,366$ 3,9930.033904 CARNESCARTAGENA TVH 350 AIS0.0000.00%$ 210,0940.00.000$ 224,0006.62%$13,9060.00.000904 CARNESSANTA MARTA TVH 350 AIS0.0000.00%$ 210,0940.00.000$ 224,0006.62%$13,9060.00.000904 CARNESCIENAGATVH 350 AIS0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESSINCELEJO TVH 350 AIS0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESVALLEDUPAR TVH 350 AIS0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESMONTERIA TVH 350 AIS0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESCAUCACIATVH 350 AIS0.0000.00%0.00.00.0000.00.00%$00.00.0006.48%Total TVH 350 AIS0.03315.57%$ 3,7500.033$ 3,9930.033904 CARNESBARRANQUILLA TVH 350 REF0.0052.36%$ 123,585$ 6180.005$ 132,0006.81%$8,415$ 6600.005904 CARNESCARTAGENA TVH 350 REF0.0000.00%$ 213,8020.00.000$ 228,0006.64%$14,1980.00.000904 CARNESSANTA MARTA TVH 350 REF0.0000.00%$ 213,8020.00.000$ 237,00010.85%$23,1980.00.000904 CARNESCIENAGATVH 350 REF0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESSINCELEJO TVH 350 REF0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESVALLEDUPAR TVH 350 REF0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESMONTERIA TVH 350 REF0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESCAUCACIATVH 350 REF0.0000.00%0.00.00.0000.00.00%$00.00.0006.81%Total TVH 350 REF0.0052.36%$ 6180.005$ 6600.005904 CARNESBARRANQUILLA TVH TURBO AIS0.04923.11%$ 148,302$ 7,2670.049$ 158,0006.54%$9,698$ 7,7420.049904 CARNESCARTAGENA TVH TURBO AIS0.0000.00%$ 274,1400.00.000$ 293,0006.88%$18,8600.00.000904 CARNESSANTA MARTA TVH TURBO AIS0.0000.00%0.00.00.000$ 293,0000.00%$293,0000.00.000904 CARNESCIENAGATVH TURBO AIS0.0000.00%$ 180,0000.00.0000.0(100.00%)($180,000)0.00.000904 CARNESSINCELEJO TVH TURBO AIS0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESVALLEDUPAR TVH TURBO AIS0.0000.00%$ 467,8570.00.0000.0(100.00%)($467,857)0.00.000904 CARNESMONTERIA TVH TURBO AIS0.0000.00%$ 467,8570.00.0000.0(100.00%)($467,857)0.00.000904 CARNESCAUCACIATVH TURBO AIS0.0000.00%0.00.00.0000.00.00%$00.00.0006.54%Total TVH TURBO AIS0.04923.11%$ 7,2670.049$ 7,7420.049904 CARNESBARRANQUILLA TVH TURBO REF0.09946.70%$ 160,666$ 15,9060.099$ 172,0007.05%$11,334$ 17,0280.099904 CARNESCARTAGENA TVH TURBO REF0.0167.55%$ 296,604$ 4,7460.016$ 317,0006.88%$20,396$ 5,0720.016904 CARNESSANTA MARTA TVH TURBO REF0.0052.36%$ 296,604$ 1,4830.005$ 317,0006.88%$20,396$ 1,5850.005904 CARNESCIENAGATVH TURBO REF0.0052.36%$ 185,377$ 9270.005$ 198,0006.81%$12,623$ 9900.005904 CARNESSINCELEJO TVH TURBO REF0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESVALLEDUPAR TVH TURBO REF0.0000.00%$ 481,9810.00.000$ 516,0007.06%$34,0190.00.000904 CARNESMONTERIA TVH TURBO REF0.0000.00%$ 481,9810.00.000$ 516,0007.06%$34,0190.00.000904 CARNESCAUCACIATVH TURBO REF0.0000.00%0.00.00.0000.00.00%$00.00.0007.00%Total TVH TURBO REF0.12558.96%$ 23,0620.125$ 24,6750.125904 CARNESBARRANQUILLA TVH 600 REF0.0000.00%$ 185,3770.00.0000.0(100.00%)($185,377)0.00.000904 CARNESCARTAGENA TVH 600 REF0.0000.00%$ 432,5470.00.0000.0(100.00%)($432,547)0.00.000904 CARNESSANTA MARTA TVH 600 REF0.0000.00%$ 502,4930.00.0000.0(100.00%)($502,493)0.00.000904 CARNESCIENAGATVH 600 REF0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESSINCELEJO TVH 600 REF0.0000.00%0.00.00.0000.00.00%$00.00.000904 CARNESVALLEDUPAR TVH 600 REF0.0000.00%$ 642,0000.00.0000.0(100.00%)($642,000)0.00.000904 CARNESMONTERIA TVH 600 REF0.0000.00%$ 642,0000.00.0000.0(100.00%)($642,000)0.00.000904 CARNESCAUCACIATVH 600 REF0.0000.00%0.00.00.0000.00.00%$00.00.000ERROR:#DIV/0!Total TVH 600 REF0.0000.00%0.00.0000.00.0006.84%Total general0.212100.00%$ 34,6960.212$ 37,0700.212

ponderado8.98%BOD. 900-901-98038.68337.71%$ 9,882,1774.1%$ 10,769,74145.12%8.28%BOD. 904 FRUVER48.16246.96%$ 9,043,6523.4%$ 9,792,47041.03%9.24%BOD. 904 GRANOS11.46011.17%$ 2,353,3081.0%$ 2,570,73410.77%7.84%BOD. 903 PESCADO4.0513.95%$ 647,4100.2%$ 698,1562.93%6.84%BOD. 903 CARNES0.2120.21%$ 34,6960.0%$ 37,0700.16%41.18%TOTALES102.568100.00%$ 21,961,2438.68%$ 23,868,171100.00%$ 7,378,977,638$ 8,019,705,599

Hoja2

Hoja3