tarifas sugeridas 2008 virgilio.xlsx
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