simulador tarifa 2014

45
CULTIVO VOLUMEN S/. MM3 CAÑA DE AZUCAR 365 22,072 0.01849759000 MESES 1 ene 31 0.00 2/7/2014 2 feb 28 66.00 2/7/2014 3 mar 31 34.68 3/7/2014 4 abr 30 33.56 4/7/2014 5 may 31 34.68 5/7/2014 6 jun 30 33.56 6/7/2014 7 jul 31 34.68 7/7/2014 8 ago 31 34.68 8/7/2014 9 sep 30 33.56 9/7/2014 10 oct 31 34.68 10/7/2014 11 nov 30 33.56 11/7/2014 12 dic 31 34.68 12/7/2014 365 408.28 PERIODO VEGETATIVO DIAS DEL MES CUOTA MENSUAL VENCIMIENTO CUOTA

Upload: amalia-zelaya

Post on 08-Sep-2015

226 views

Category:

Documents


0 download

DESCRIPTION

tarifa 2014

TRANSCRIPT

PERMANENTECULTIVOPERIODO VEGETATIVOVOLUMENS/. MM3HECS/.FECHASIEMBRAFECHACOSECHAVALOR DIARIOCAA DE AZUCAR36522,0720.018497590001.00408.281/1/1412/31/141.11857207NMESESDIASDEL MESCUOTA MENSUALVENCIMIENTOCUOTADIAS VENCIDOSINTERESESTOTAL1enero310.002/7/142febrero2866.002/7/14940.9866.983marzo3134.683/7/14660.7635.444abril3033.564/7/14350.3933.955mayo3134.685/7/1450.0634.736junio3033.566/7/14-26-0.2933.567julio3134.687/7/14-56-0.6534.688agosto3134.688/7/14-87-1.0134.689septiembre3033.569/7/14-118-1.3233.5610octubre3134.6810/7/14-148-0.0234.6811noviembre3033.5611/7/14-179-0.0233.5612diciembre3134.6812/7/14-209-0.0234.68

365408.282002.19410.47

TOTAL410.47

val_pervalor x diamesesfecha de siembrafehacosechahoy1.11857207311/1/1412/31/145/12/1434.675734249DIAS EN UN MESFIN DE MESFECHAS DE VENCIMIENTOHOYDIAS DEINTERESESDIAS EN UNMESS/.CUOTASINTERESESINTERESESMESDIASDE SIEMBRADIAEN UNIDAD1311/31/142/7/145/12/14943134.6811/1/1412282/28/142/7/145/12/14942831.320.000333330.9811/2/1413313/31/143/7/145/12/14663134.680.000333330.7611/3/1414304/30/144/7/145/12/14353033.560.000333330.3911/4/1415315/31/145/7/145/12/1453134.680.000333330.0611/5/1416306/30/146/7/145/12/14-263033.560.00033333-0.2911/6/1417317/31/147/7/145/12/14-563134.680.00033333-0.6511/7/1418318/31/148/7/145/12/14-873134.680.00033333-1.0111/8/1419309/30/149/7/145/12/14-1183033.560.00033333-1.3211/9/141103110/31/1410/7/145/12/14-1483134.680.00033333-0.0211/10/141113011/30/1411/7/145/12/14-1793033.560.00033333-0.0211/11/141123112/31/1412/7/145/12/14-2093134.680.00033333-0.0211/12/141131/31/151/7/155/12/14-240310.000.000333330.0011/13/141142/28/152/7/155/12/14-271280.000.000333330.0011/14/141153/31/153/7/155/12/14-299310.000.000333330.0011/15/141164/30/154/7/155/12/14-330300.000.000333330.0011/16/141175/31/155/7/155/12/14-360310.000.000333330.0011/17/141186/30/156/7/155/12/14-391300.000.000333330.0011/18/141197/31/157/7/155/12/14-421310.000.000333330.0011/19/141208/31/158/7/155/12/14-452310.000.000333330.0011/20/141365408.2811/21/14111/22/14111/23/14111/24/14111/25/14111/26/14111/27/14111/28/14111/29/14111/30/14111/31/14122/1/14122/2/14122/3/14122/4/14122/5/14122/6/14122/7/14122/8/14122/9/14122/10/14122/11/14122/12/14122/13/14122/14/14122/15/14122/16/14122/17/14122/18/14122/19/14122/20/14122/21/14122/22/14122/23/14122/24/14122/25/14122/26/14122/27/14122/28/14133/1/14133/2/14133/3/14133/4/14133/5/14133/6/14133/7/14133/8/14133/9/14133/10/14133/11/14133/12/14133/13/14133/14/14133/15/14133/16/14133/17/14133/18/14133/19/14133/20/14133/21/14133/22/14133/23/14133/24/14133/25/14133/26/14133/27/14133/28/14133/29/14133/30/14133/31/14144/1/14144/2/14144/3/14144/4/14144/5/14144/6/14144/7/14144/8/14144/9/14144/10/14144/11/14144/12/14144/13/14144/14/14144/15/14144/16/14144/17/14144/18/14144/19/14144/20/14144/21/14144/22/14144/23/14144/24/14144/25/14144/26/14144/27/14144/28/14144/29/14144/30/14155/1/14155/2/14155/3/14155/4/14155/5/14155/6/14155/7/14155/8/14155/9/14155/10/14155/11/14155/12/14155/13/14155/14/14155/15/14155/16/14155/17/14155/18/14155/19/14155/20/14155/21/14155/22/14155/23/14155/24/14155/25/14155/26/14155/27/14155/28/14155/29/14155/30/14155/31/14166/1/14166/2/14166/3/14166/4/14166/5/14166/6/14166/7/14166/8/14166/9/14166/10/14166/11/14166/12/14166/13/14166/14/14166/15/14166/16/14166/17/14166/18/14166/19/14166/20/14166/21/14166/22/14166/23/14166/24/14166/25/14166/26/14166/27/14166/28/14166/29/14166/30/14177/1/14177/2/14177/3/14177/4/14177/5/14177/6/14177/7/14177/8/14177/9/14177/10/14177/11/14177/12/14177/13/14177/14/14177/15/14177/16/14177/17/14177/18/14177/19/14177/20/14177/21/14177/22/14177/23/14177/24/14177/25/14177/26/14177/27/14177/28/14177/29/14177/30/14177/31/14188/1/14188/2/14188/3/14188/4/14188/5/14188/6/14188/7/14188/8/14188/9/14188/10/14188/11/14188/12/14188/13/14188/14/14188/15/14188/16/14188/17/14188/18/14188/19/14188/20/14188/21/14188/22/14188/23/14188/24/14188/25/14188/26/14188/27/14188/28/14188/29/14188/30/14188/31/14199/1/14199/2/14199/3/14199/4/14199/5/14199/6/14199/7/14199/8/14199/9/14199/10/14199/11/14199/12/14199/13/14199/14/14199/15/14199/16/14199/17/14199/18/14199/19/14199/20/14199/21/14199/22/14199/23/14199/24/14199/25/14199/26/14199/27/14199/28/14199/29/14199/30/1411010/1/1411010/2/1411010/3/1411010/4/1411010/5/1411010/6/1411010/7/1411010/8/1411010/9/1411010/10/1411010/11/1411010/12/1411010/13/1411010/14/1411010/15/1411010/16/1411010/17/1411010/18/1411010/19/1411010/20/1411010/21/1411010/22/1411010/23/1411010/24/1411010/25/1411010/26/1411010/27/1411010/28/1411010/29/1411010/30/1411010/31/1411111/1/1411111/2/1411111/3/1411111/4/1411111/5/1411111/6/1411111/7/1411111/8/1411111/9/1411111/10/1411111/11/1411111/12/1411111/13/1411111/14/1411111/15/1411111/16/1411111/17/1411111/18/1411111/19/1411111/20/1411111/21/1411111/22/1411111/23/1411111/24/1411111/25/1411111/26/1411111/27/1411111/28/1411111/29/1411111/30/1411212/1/1411212/2/1411212/3/1411212/4/1411212/5/1411212/6/1411212/7/1411212/8/1411212/9/1411212/10/1411212/11/1411212/12/1411212/13/1411212/14/1411212/15/1411212/16/1411212/17/1411212/18/1411212/19/1411212/20/1411212/21/1411212/22/1411212/23/1411212/24/1411212/25/1411212/26/1411212/27/1411212/28/1411212/29/1411212/30/1411212/31/141

TRANSITORIOCULTIVOPERIODO VEGETATIVOVOLUMENS/. MM3HECS/.FECHASIEMBRAFECHACOSECHAVALOR DIARIOMAIZ AMARILLO1805,2480.018497590002.00194.151/1/146/29/141.07861503

NMESESDIASDEL MESCUOTA MENSUALVENCIMIENTOCUOTADIAS VENCIDOSINTERESESTOTALPOR MES1enero310.002/7/142febrero2863.642/7/14940.9864.623marzo3133.443/7/14660.7634.204abril3032.364/7/14350.3932.755mayo3133.445/7/1450.0633.496junio3032.366/7/14-26-0.2932.367julio3133.447/7/14-56-0.6533.448agosto3133.448/7/14-87-1.0133.449septiembre3032.369/7/14-118-1.3232.3610octubre3133.4410/7/14-148-0.0233.4411noviembre3032.3611/7/14-179-0.0232.3612diciembre3133.4412/7/14-209-0.0233.44

365393.692002.19395.89

TOTAL GENERAL395.89

val_tranvalor x diamesesfecha de siembrafehacosechahoy1.11857207311/1/1412/31/145/12/1434.675734249DIAS EN UN MESFIN DE MESFECHAS DE VENCIMIENTOHOYDIAS DEINTERESESDIAS EN UNMESS/.CUOTASINTERESESINTERESESMESDIASDE SIEMBRADIAEN UNIDAD1311/31/142/7/145/12/14943111/1/1412282/28/142/7/145/12/14942866.000.000333332.0711/2/1413313/31/143/7/145/12/14663134.680.000333330.7611/3/1414304/30/144/7/145/12/14353033.560.000333330.3911/4/1415315/31/145/7/145/12/1453134.680.000333330.0611/5/1416296/30/146/7/145/12/14-263032.440.00033333-0.2811/6/141707/31/147/7/145/12/14-56310.000.000333330.0011/7/141808/31/148/7/145/12/14-87310.000.000333330.0011/8/141909/30/149/7/145/12/14-118300.000.000333330.0011/9/14110010/31/1410/7/145/12/14-148310.000.000333330.0011/10/14111011/30/1411/7/145/12/14-179300.000.000333330.0011/11/14112012/31/1412/7/145/12/14-209310.000.000333330.0011/12/141131/31/151/7/155/12/14-240310.000.000333330.0011/13/141142/28/152/7/155/12/14-271280.000.000333330.0011/14/141153/31/153/7/155/12/14-299310.000.000333330.0011/15/141164/30/154/7/155/12/14-330300.000.000333330.0011/16/141175/31/155/7/155/12/14-360310.000.000333330.0011/17/141186/30/156/7/155/12/14-391300.000.000333330.0011/18/141197/31/157/7/155/12/14-421310.000.000333330.0011/19/141208/31/158/7/155/12/14-452310.000.000333330.0011/20/141180201.3411/21/14111/22/14111/23/14111/24/14111/25/14111/26/14111/27/14111/28/14111/29/14111/30/14111/31/14122/1/14122/2/14122/3/14122/4/14122/5/14122/6/14122/7/14122/8/14122/9/14122/10/14122/11/14122/12/14122/13/14122/14/14122/15/14122/16/14122/17/14122/18/14122/19/14122/20/14122/21/14122/22/14122/23/14122/24/14122/25/14122/26/14122/27/14122/28/14133/1/14133/2/14133/3/14133/4/14133/5/14133/6/14133/7/14133/8/14133/9/14133/10/14133/11/14133/12/14133/13/14133/14/14133/15/14133/16/14133/17/14133/18/14133/19/14133/20/14133/21/14133/22/14133/23/14133/24/14133/25/14133/26/14133/27/14133/28/14133/29/14133/30/14133/31/14144/1/14144/2/14144/3/14144/4/14144/5/14144/6/14144/7/14144/8/14144/9/14144/10/14144/11/14144/12/14144/13/14144/14/14144/15/14144/16/14144/17/14144/18/14144/19/14144/20/14144/21/14144/22/14144/23/14144/24/14144/25/14144/26/14144/27/14144/28/14144/29/14144/30/14155/1/14155/2/14155/3/14155/4/14155/5/14155/6/14155/7/14155/8/14155/9/14155/10/14155/11/14155/12/14155/13/14155/14/14155/15/14155/16/14155/17/14155/18/14155/19/14155/20/14155/21/14155/22/14155/23/14155/24/14155/25/14155/26/14155/27/14155/28/14155/29/14155/30/14155/31/14166/1/14166/2/14166/3/14166/4/14166/5/14166/6/14166/7/14166/8/14166/9/14166/10/14166/11/14166/12/14166/13/14166/14/14166/15/14166/16/14166/17/14166/18/14166/19/14166/20/14166/21/14166/22/14166/23/14166/24/14166/25/14166/26/14166/27/14166/28/14166/29/1416/30/1417/1/1417/2/1417/3/1417/4/1417/5/1417/6/1417/7/1417/8/1417/9/1417/10/1417/11/1417/12/1417/13/1417/14/1417/15/1417/16/1417/17/1417/18/1417/19/1417/20/1417/21/1417/22/1417/23/1417/24/1417/25/1417/26/1417/27/1417/28/1417/29/1417/30/1417/31/1418/1/1418/2/1418/3/1418/4/1418/5/1418/6/1418/7/1418/8/1418/9/1418/10/1418/11/1418/12/1418/13/1418/14/1418/15/1418/16/1418/17/1418/18/1418/19/1418/20/1418/21/1418/22/1418/23/1418/24/1418/25/1418/26/1418/27/1418/28/1418/29/1418/30/1418/31/1419/1/1419/2/1419/3/1419/4/1419/5/1419/6/1419/7/1419/8/1419/9/1419/10/1419/11/1419/12/1419/13/1419/14/1419/15/1419/16/1419/17/1419/18/1419/19/1419/20/1419/21/1419/22/1419/23/1419/24/1419/25/1419/26/1419/27/1419/28/1419/29/1419/30/14110/1/14110/2/14110/3/14110/4/14110/5/14110/6/14110/7/14110/8/14110/9/14110/10/14110/11/14110/12/14110/13/14110/14/14110/15/14110/16/14110/17/14110/18/14110/19/14110/20/14110/21/14110/22/14110/23/14110/24/14110/25/14110/26/14110/27/14110/28/14110/29/14110/30/14110/31/14111/1/14111/2/14111/3/14111/4/14111/5/14111/6/14111/7/14111/8/14111/9/14111/10/14111/11/14111/12/14111/13/14111/14/14111/15/14111/16/14111/17/14111/18/14111/19/14111/20/14111/21/14111/22/14111/23/14111/24/14111/25/14111/26/14111/27/14111/28/14111/29/14111/30/14112/1/14112/2/14112/3/14112/4/14112/5/14112/6/14112/7/14112/8/14112/9/14112/10/14112/11/14112/12/14112/13/14112/14/14112/15/14112/16/14112/17/14112/18/14112/19/14112/20/14112/21/14112/22/14112/23/14112/24/14112/25/14112/26/14112/27/14112/28/14112/29/14112/30/14112/31/141FALSE1FALSE1FALSE1FALSE1FALSE1

cultiVAJI ESCABECHE1808,0990.01849759IICAA DE AZUCAR21,000365VAJI PANCA1808,0990.01849759IIIALCACHOFA20,000365VAJI PAPRICA1808,0990.01849759IIIESPARRAGO20,000365VAJI PIQUILLO1808,0990.01849759IVALFALFA11,000365VAJOS1808,0990.01849759IVCASUARINA11,000365IIIALCACHOFA36520,6430.01849759IVCHIRIMOYA11,000365IVALFALFA36511,5200.01849759IVCIRUELA11,000365VIALGODON1807,2240.01849759IVDURAZNO11,000365VIIAPIO1805,2480.01849759IVEUCALIPTO11,000365VIIARVERJA1805,2480.01849759IVFLORES11,000365VIICAIHUA1805,2480.01849759IVFORESTALES11,000365VIICAMOTE1805,2480.01849759IVFRAMBUESA11,000365IICAA DE AZUCAR36522,0720.01849759IVFRESA11,000365IVCASUARINA36511,5200.01849759IVFRUTALES11,000365VCEBOLLA BLANCA1808,0990.01849759IVGRANADILLA11,000365VIICEBOLLA CHINA1805,2480.01849759IVLIMON11,000365VCEBOLLA ROJA1808,0990.01849759IVLUCUMO11,000365VCEBOLLIN1808,0990.01849759IVMANDARINA11,000365IVCHIRIMOYA36511,5200.01849759IVMANGO11,000365IVCIRUELA36511,5200.01849759IVMANZANOS11,000365VIICOLIFLOR1805,2480.01849759IVMARACUYA11,000365IVDURAZNO36511,5200.01849759IVMELOCOTON11,000365IIIESPARRAGO36520,6430.01849759IVMEMBRILLO11,000365VIIESPINACA1805,2480.01849759IVMORA11,000365IVEUCALIPTO36511,5200.01849759IVNARANJO11,000365IVFLORES36511,5200.01849759IVOLIVO11,000365IVFORESTALES36511,5200.01849759IVPALTO11,000365IVFRAMBUESA36511,5200.01849759IVPAPAYA11,000365VIIFREJOL NEMA1805,2480.01849759IVPASTO ELEFANTE11,000365IVFRESA36511,5200.01849759IVPASTOS NATURALE11,000365VIIFRIJOL CANARIO1805,2480.01849759IVPECANA11,000365VIIFRIJOL CASTILLA1805,2480.01849759IVPERA11,000365VIIFRIJOL PALO1805,2480.01849759IVPLATANOS11,000365VIIFRIJOL PANAMITO1805,2480.01849759IVSORGO11,000365VIIFRIJOL VAINITA1805,2480.01849759IVTARA11,000365IVFRUTALES36511,5200.01849759IVTUNA11,000365IVGRANADILLA36511,5200.01849759IVVID11,000365VIIHORTALIZA1805,2480.01849759IVYUCA11,000180VIIKIWICHA1805,2480.01849759VAJI ESCABECHE7,800180VIILECHUGA1805,2480.01849759VAJI PANCA7,800180VIILENTEJA1805,2480.01849759VAJI PAPRICA7,800180IVLIMON36511,5200.01849759VAJI PIQUILLO7,800180IVLUCUMO36511,5200.01849759VAJOS7,800180VIIMAIZ AMARILLO1805,2480.01849759VCEBOLLA BLANCA7,800180VIIMAIZ CHALA1805,2480.01849759VCEBOLLA ROJA7,800180VIIMAIZ CHOCLO1805,2480.01849759VCEBOLLIN7,800180VIIMAIZ MORADO1805,2480.01849759VIALGODON7,000180IVMANDARINA36511,5200.01849759VIMARIGOL7,000180IVMANGO36511,5200.01849759VIPAPA7,000180VIIMANI1805,2480.01849759VIIAPIO5,095180IVMANZANOS36511,5200.01849759VIIARVERJA5,095180IVMARACUYA36511,5200.01849759VIICAIHUA5,095180VIMARIGOL1807,2240.01849759VIICAMOTE5,095180IVMELOCOTON36511,5200.01849759VIICEBOLLA CHINA5,095180VIIMELON1805,2480.01849759VIICOLIFLOR5,095180IVMEMBRILLO36511,5200.01849759VIIESPINACA5,095180IVMORA36511,5200.01849759VIIFREJOL NEMA5,095180VIINABO1805,2480.01849759VIIFRIJOL CANARIO5,095180IVNARANJO36511,5200.01849759VIIFRIJOL CASTILLA5,095180IVOLIVO36511,5200.01849759VIIFRIJOL PALO5,095180VIIPALLAR1805,2480.01849759VIIFRIJOL PANAMITO5,095180IVPALTO36511,5200.01849759VIIFRIJOL VAINITA5,095180VIPAPA1807,2240.01849759VIIHORTALIZA5,095180IVPAPAYA36511,5200.01849759VIIKIWICHA5,095180IVPASTO ELEFANTE36511,5200.01849759VIILECHUGA5,095180IVPASTOS NATURALE36511,5200.01849759VIILENTEJA5,095180IVPECANA36511,5200.01849759VIIMAIZ AMARILLO5,095180VIIPEPINILLO1805,2480.01849759VIIMAIZ CHALA5,095180VIIPEPINO1805,2480.01849759VIIMAIZ CHOCLO5,095180IVPERA36511,5200.01849759VIIMAIZ MORADO5,095180IVPLATANOS36511,5200.01849759VIIMANI5,095180VIIPORO1805,2480.01849759VIIMELON5,095180VIIQUINUA1805,2480.01849759VIINABO5,095180VIIREPOLLO1805,2480.01849759VIIPALLAR5,095180VIISANDIA1805,2480.01849759VIIPEPINILLO5,095180IVSORGO36511,5200.01849759VIIPEPINO5,095180IVTARA36511,5200.01849759VIIPORO5,095180VIITOMATE1805,2480.01849759VIIQUINUA5,095180VIITOMILLO1805,2480.01849759VIIREPOLLO5,095180VIITRIGO1805,2480.01849759VIISANDIA5,095180IVTUNA36511,5200.01849759VIITOMATE5,095180VIIVERDURAS1805,2480.01849759VIITOMILLO5,095180VIIVETERRAGA1805,2480.01849759VIITRIGO5,095180IVVID36511,5200.01849759VIIVERDURAS5,095180IVYUCA36511,5200.01849759VIIVETERRAGA5,095180VIIZANAHORIA1805,2480.01849759VIIZANAHORIA5,095180VIIZAPALLO1805,2480.01849759VIIZAPALLO5,095180

Hoja1GRUPO IICRUPO IIIGRUPO IVGRUPO IVGRUPO VIGRUPO VIICAA DE AZUCARALCACHOFAALFALFAAJI ESCABECHEALGODONFRIJOL CANARIOESPARRAGOCASUARINAAJI PANCAMARIGOLFRIJOL CASTILLACHIRIMOYAAJI PAPRICAPAPAFRIJOL PALOCIRUELAAJI PIQUILLOFRIJOL PANAMITODURAZNOAJOSFRIJOL VAINITAEUCALIPTOCEBOLLA BLANCAFREJOL NEMAFLORESCEBOLLA ROJAMAIZ AMARILLOFORESTALESCEBOLLINMAIZ CHALAFRAMBUESAMAIZ CHOCLOFRESAMAIZ MORADOFRUTALESAPIOGRANADILLAARVERJALIMONCAIHUALUCUMOCAMOTEMANDARINAHORTALIZAMANGOLECHUGAMANZANOSLENTEJAMARACUYAESPINACAMELOCOTONCOLIFLORMELONCEBOLLA CHINAMEMBRILLOMANIMORANABONARANJOPALLAROLIVOPEPINILLOPALTOPEPINOPAPAYAVERDURASPASTO ELEFANTEVETERRAGAPASTOS NATURALEZANAHORIAPECANAZAPALLOPERAVIDYUCA