Noticias Animadas de hoy – [XLS Document]

Cuadros del Dimensionamiento Economico Financiero

InfoInicialESTA PLANILLA PUEDE SER UTILIZADA SOLAMENTE PARA EL TRABAJO PRACTICO:Tasa porcentual de IVA21%Tasa porcentual de Impuesto a las Ganancias35%Honorarios al Directorio4%Variable sobre Utilidad economica antes de HD e IGFinanciacion30.0Tiempo de Amortizacin Activos Fijos:Se considera una depreciacin lineal y un valor residual nuloedificios y obras complementarias30aosinstalaciones industriales10aosmquinas, equipos y accesorios10aosrodados y equipos auxiliares5aosmuebles y tiles5aosrepuestos iniciales3aosOtros Activos y Cargos Diferidos5aoscargos diferidos5aosNombre del ProductoAceite de olivaVentas Anuales Promedio266426$Precio Promedio $/l120en $Cantidad de personal totalen Produccin3personasen Comercializacin2personasen Administracin2personasAo 8Tamao de la planta en metros cuadrados8600m2Periodo de Instalacin6en mesesPerodo de Puesta en Marcha4en mesesTasa de Cambio8.05$ por cada1U$STasa de Credito Bancario17%anualComisiones y Gastos Bancarios2%Rubro a financiarActivo Fijo% sobre el total del Rubro50%Dias de Financiacin de Proveedores180% sobre Compras60%Tasa de financiacin22%Anualimprevistos2%

E-PventaPeriodoAoMESINGRESO MP [kg]PRODUCCIN [kg]PRODUCCIN [lts]Egreso Aceite [lt]STOCK ACEITE [lt]% TANQUES OCUPADOS250000Tanques requeridos10000DIAS DISPONIBLES PRODUCCIN [dias]PROCESAMIENTO DE MATERIA PRIMA POR DIA [KG/DIA]BOTELLAS A ENVASAR POR DA [0,5lts / botella]CAPACADIDAD DE PROCESAMIENTO DIARIO POR MQUINA [KG]CAPACIDAD DE PROCESAMIENTO MENSUAL POR MQUINA [KG]% APROVECHAMIENTO CAPACIDAD INSTALADAEQUIPOS REQUERIDOSCAPACADIDAD INSTALADA [KG/DIA]% APROVECHAMIENTO CAPACIDAD INSTALADAkg de aceitunaAo 12015Feb-15104,740.012,219.713,139.40.013,139.45%0%5.000146,235019,200268,80032.5%119,20032.5%$2.50Ao 12015Mar-15209,480.124,439.326,278.94,778.034,640.314%0%5.000315,63130819,200595,20029.3%119,20029.3%Ao 12015Apr-15104,740.012,219.713,139.44,778.043,001.817%0%5.000155,81931919,200288,00030.3%119,20030.3%Ao 12015May-15-00.04,778.038,223.815%0%5.000–30819,200–119,200-Ao 12015Jun-15-00.04,778.033,445.813%0%5.000–31919,200–119,200-Ao 12015Jul-15-00.04,778.028,667.811%0%5.000–30819,200–119,200-Ao 12015Aug-15-00.04,778.023,889.910%0%5.000–30819,200–119,200-Ao 12015Sep-15-00.04,778.019,111.98%0%5.000–31919,200–119,200-Ao 12015Oct-15-00.04,778.014,333.96%0%5.000–30819,200–119,200-Ao 12015Nov-15-00.04,778.09,555.94%0%5.000–31919,200–119,200-Ao 12015Dec-15-00.04,778.04,778.02%0%5.000–30819,200–119,200-Ao 22016Jan-16-00.04,778.0-0.00%0%6.000–30819,200–119,200-Ao 22016Feb-16116,959.716,374.417,606.80.017,606.87%0%6.00014.508,066019,200278,40042.0%119,20042.0%Ao 22016Mar-16233,919.432,748.735,213.76,402.546,418.019%0%6.000317,54641319,200595,20039.3%119,20039.3%Ao 22016Apr-16116,959.716,374.417,606.86,402.557,622.423%0%6.000157,79742719,200288,00040.6%119,20040.6%Ao 22016May-16-00.06,402.551,219.920%0%6.000–41319,200–119,200-Ao 22016Jun-16-00.06,402.544,817.418%0%6.000–42719,200–119,200-Ao 22016Jul-16-00.06,402.538,414.915%0%6.000–41319,200–119,200-Ao 22016Aug-16-00.06,402.532,012.413%0%6.000–41319,200–119,200-Ao 22016Sep-16-00.06,402.525,609.910%0%6.000–42719,200–119,200-Ao 22016Oct-16-00.06,402.519,207.58%0%6.000–41319,200–119,200-Ao 22016Nov-16-00.06,402.512,805.05%0%6.000–42719,200–119,200-Ao 22016Dec-16-00.06,402.56,402.53%0%6.000–41319,200–119,200-Ao 32017Jan-17-00.06,402.5-0.00%0%8.000–41319,200–119,200-Ao 32017Feb-17156,726.021,941.623,593.20.023,593.29%0%8.0001411,195019,200268,80058.3%119,20058.3%Ao 32017Mar-17313,452.043,883.347,186.38,579.362,200.225%0%8.0003110,11155419,200595,20052.7%119,20052.7%Ao 32017Apr-17156,726.021,941.623,593.28,579.377,214.031%0%8.0001510,44857219,200288,00054.4%119,20054.4%Ao 32017May-17-00.08,579.368,634.627%0%8.000–55419,200–119,200-Ao 32017Jun-17-00.08,579.360,055.324%0%8.000–57219,200–119,200-Ao 32017Jul-17-00.08,579.351,476.021%0%8.000–55419,200–119,200-Ao 32017Aug-17-00.08,579.342,896.717%0%8.000–55419,200–119,200-Ao 32017Sep-17-00.08,579.334,317.314%0%8.000–57219,200–119,200-Ao 32017Oct-17-00.08,579.325,738.010%0%8.000–55419,200–119,200-Ao 32017Nov-17-00.08,579.317,158.77%0%8.000–57219,200–119,200-Ao 32017Dec-17-00.08,579.38,579.33%0%8.000–55419,200–119,200-Ao 42018Jan-18-00.08,579.3-0.00%0%11.000–55419,200–119,200-Ao 42018Feb-18210,012.829,401.831,614.80.031,614.813%0%11.0001415,001019,200268,80078.1%119,20078.1%Ao 42018Mar-18420,025.758,803.663,229.711,496.383,348.233%0%11.0003113,54974219,200595,20070.6%119,20070.6%Ao 42018Apr-18210,012.829,401.831,614.811,496.3103,466.741%0%11.0001514,00176619,200288,00072.9%119,20072.9%Ao 42018May-18-00.011,496.391,970.437%0%11.000–74219,200–119,200-Ao 42018Jun-18-00.011,496.380,474.132%0%11.000–76619,200–119,200-Ao 42018Jul-18-00.011,496.368,977.828%0%11.000–74219,200–119,200-Ao 42018Aug-18-00.011,496.357,481.523%0%11.000–74219,200–119,200-Ao 42018Sep-18-00.011,496.345,985.218%0%11.000–76619,200–119,200-Ao 42018Oct-18-00.011,496.334,488.914%0%11.000–74219,200–119,200-Ao 42018Nov-18-00.011,496.322,992.69%0%11.000–76619,200–119,200-Ao 42018Dec-18-00.011,496.311,496.35%0%11.000–74219,200–119,200-Ao 52019Jan-19-00.011,496.3-0.00%0%14.000–74219,200–119,200-Ao 52019Feb-19281,417.239,398.442,363.90.042,363.917%0%14.0001420,101019,200537,600104.7%238,40052.3%Ao 52019Mar-19562,834.478,796.884,727.815,405.0111,686.645%0%14.0003118,15699419,2001,190,40094.6%238,40047.3%Ao 52019Apr-19281,417.239,398.442,363.915,405.0138,645.455%0%14.0001518,7611,02719,200576,00097.7%238,40048.9%Ao 52019May-19-00.015,405.0123,240.449%0%14.000–99419,200–238,400-Ao 52019Jun-19-00.015,405.0107,835.343%0%14.000–1,02719,200–238,400-Ao 52019Jul-19-00.015,405.092,430.337%0%14.000–99419,200–238,400-Ao 52019Aug-19-00.015,405.077,025.231%0%14.000–99419,200–238,400-Ao 52019Sep-19-00.015,405.061,620.225%0%14.000–1,02719,200–238,400-Ao 52019Oct-19-00.015,405.046,215.118%0%14.000–99419,200–238,400-Ao 52019Nov-19-00.015,405.030,810.112%0%14.000–1,02719,200–238,400-Ao 52019Dec-19-00.015,405.015,405.06%0%14.000–99419,200–238,400-Ao 62020Jan-20-00.015,405.0-0.00%0%19.000–99419,200–238,400-Ao 62020Feb-20377,099.052,793.956,767.60.056,767.623%0%19.0001526,007019,200556,800135.5%238,40067.7%Ao 62020Mar-20754,198.1105,587.7113,535.220,642.8149,660.060%0%19.0003124,3291,33219,2001,190,400126.7%238,40063.4%Ao 62020Apr-20377,099.052,793.956,767.620,642.8185,784.974%0%19.0001525,1401,37619,200576,000130.9%238,40065.5%Ao 62020May-20-00.020,642.8165,142.166%0%19.000–1,33219,200–238,400-Ao 62020Jun-20-00.020,642.8144,499.358%0%19.000–1,37619,200–238,400-Ao 62020Jul-20-00.020,642.8123,856.650%0%19.000–1,33219,200–238,400-Ao 62020Aug-20-00.020,642.8103,213.841%0%19.000–1,33219,200–238,400-Ao 62020Sep-20-00.020,642.882,571.133%0%19.000–1,37619,200–238,400-Ao 62020Oct-20-00.020,642.861,928.325%0%19.000–1,33219,200–238,400-Ao 62020Nov-20-00.020,642.841,285.517%0%19.000–1,37619,200–238,400-Ao 62020Dec-20-00.020,642.820,642.88%0%19.000–1,33219,200–238,400-Ao 72021Jan-21-00.020,642.8-0.00%0%25.000–1,33219,200–238,400-Ao 72021Feb-21505,312.770,743.876,068.60.076,068.630%0%25.0001436,094019,200537,600188.0%238,40094.0%Ao 72021Mar-211,010,625.4141,487.6152,137.227,661.3200,544.480%0%25.0003132,6011,78519,2001,190,400169.8%238,40084.9%Ao 72021Apr-21505,312.770,743.876,068.627,661.3248,951.7100%0%25.0001533,6881,84419,200576,000175.5%238,40087.7%Ao 72021May-21-00.027,661.3221,290.489%0%25.000–1,78519,200–238,400-Ao 72021Jun-21-00.027,661.3193,629.177%0%25.000–1,84419,200–238,400-Ao 72021Jul-21-00.027,661.3165,967.866%0%25.000–1,78519,200–238,400-Ao 72021Aug-21-00.027,661.3138,306.555%0%25.000–1,78519,200–238,400-Ao 72021Sep-21-00.027,661.3110,645.244%0%25.000–1,84419,200–238,400-Ao 72021Oct-21-00.027,661.382,983.933%0%25.000–1,78519,200–238,400-Ao 72021Nov-21-00.027,661.355,322.622%0%25.000–1,84419,200–238,400-Ao 72021Dec-21-00.027,661.327,661.311%0%25.000–1,78519,200–238,400-Ao 82022Jan-22-00.027,661.3-0.00%0%34.000–1,78519,200–238,400-Ao 82022Feb-22677,119.094,796.7101,931.90.0101,931.941%0%34.0001448,366019,200537,600251.9%238,400126.0%Ao 82022Mar-221,354,238.1189,593.3203,863.837,066.1268,729.6107%0%34.0003143,6852,39119,2001,190,400227.5%238,400113.8%Ao 82022Apr-22677,119.094,796.7101,931.937,066.1333,595.3133%0%34.0001545,1412,47119,200576,000235.1%238,400117.6%Ao 82022May-22-00.037,066.1296,529.2119%0%34.000–2,39119,200–238,400-Ao 82022Jun-22-00.037,066.1259,463.0104%0%34.000–2,47119,200–238,400-Ao 82022Jul-22-00.037,066.1222,396.989%0%34.000–2,39119,200–238,400-Ao 82022Aug-22-00.037,066.1185,330.774%0%34.000–2,39119,200–238,400-Ao 82022Sep-22-00.037,066.1148,264.659%0%34.000–2,47119,200–238,400-Ao 82022Oct-22-00.037,066.1111,198.444%0%34.000–2,39119,200–238,400-Ao 82022Nov-22-00.037,066.174,132.330%0%34.000–2,47119,200–238,400-Ao 82022Dec-22-00.037,066.137,066.115%0%34.000–2,39119,200–238,400-Ao 92023Jan-23-00.037,066.1-0.00%0%45.000–2,39119,200–238,400-Ao 92023Feb-23907,339.5127,027.5136,588.70.0136,588.755%0%45.0001464,810019,200537,600337.6%238,400168.8%Ao 92023Mar-231,814,679.0254,055.1273,177.549,668.6360,097.6144%0%45.0003158,5383,20419,2001,190,400304.9%238,400152.4%Ao 92023Apr-23907,339.5127,027.5136,588.749,668.6447,017.7179%0%45.0001560,4893,31119,200576,000315.0%238,400157.5%Ao 92023May-23-00.049,668.6397,349.1159%0%45.000–3,20419,200–238,400-Ao 92023Jun-23-00.049,668.6347,680.4139%0%45.000–3,31119,200–238,400-Ao 92023Jul-23-00.049,668.6298,011.8119%0%45.000–3,20419,200–238,400-Ao 92023Aug-23-00.049,668.6248,343.299%0%45.000–3,20419,200–238,400-Ao 92023Sep-23-00.049,668.6198,674.579%0%45.000–3,31119,200–238,400-Ao 92023Oct-23-00.049,668.6149,005.960%0%45.000–3,20419,200–238,400-Ao 92023Nov-23-00.049,668.699,337.340%0%45.000–3,31119,200–238,400-Ao 92023Dec-23-00.049,668.649,668.620%0%45.000–3,20419,200–238,400-Ao 102024Jan-24-00.049,668.6-0.00%0%60.000–3,20419,

Publicaciones Similares