INGRESOSINGRESOS POR VENTAS DE PRODUCTOSPRODUCTOAO 1AO 2AO 3AO 4AO 5Pollo en pie162,811.8589,750.0398,949.41109,091.73120,273.63Pechuga439,592.00545,231.45601,117.68662,732.24730,662.29Pierna y muslo219,796.00272,615.73300,558.84331,366.12365,331.15Retazo51,285.7363,610.3470,130.4077,318.7685,243.93Visceras36,632.6745,435.9550,093.1455,227.6960,888.52Gallinaza105,671.15116,502.45128,443.95141,609.45156,124.42

Total de ingresos1,015,789.401,133,145.951,249,293.421,377,345.991,518,523.94

COSTOSPROYECTO DE ENGORDA DE POLLOSCOSTOS MENSUALES DE OPERACIN DEL PROYECTOCONCEPTO/MESMES 1MES 2MES 3MES 4MES 5MES 6MES 7MES 8MES 9MES 10MES 11MES 12CONCEPTO/MESCompra de pollitos0.00.08,000.008,000.008,000.008,000.008,000.008,000.008,000.008,000.008,000.008,000.00Cuidados y mano de obra8,400.008,400.008,400.008,400.008,400.008,400.008,400.008,400.008,400.008,400.008,400.008,400.00Ventas0.09,000.009,000.009,000.009,000.009,000.009,000.009,000.009,000.009,000.009,000.009,000.00Aserrin500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00Alimento iniciacion5,018.095,018.095,018.095,018.095,018.095,018.095,018.095,018.095,018.095,018.095,018.095,018.09Alimento engorda13,365.2113,365.2113,365.2113,365.2113,365.2113,365.2113,365.2113,365.2113,365.2113,365.2113,365.2113,365.21Maiz molido4,198.584,198.584,198.584,198.584,198.584,198.584,198.584,198.584,198.584,198.584,198.584,198.58Vacunas2,608.312,608.312,608.312,608.312,608.312,608.312,608.312,608.312,608.312,608.312,608.312,608.31Bolsas de plastico0.0305.270.0305.270.0305.270.0305.270.0305.270.0305.27Promocion2,000.000.00.00.00.00.02,000.000.00.00.00.00.0Energia electrica500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00500.00

Subtotal36,590.1943,895.4651,590.1951,895.4651,590.1951,895.4653,590.1951,895.4651,590.1951,895.4651,590.1951,895.46

COTOS FIJOSCONCEPTO/MESMES 1MES 2MES 3MES 4MES 5MES 6MES 7MES 8MES 9MES 10MES 11MES 12Administracion general7,500.007,500.007,500.007,500.007,500.007,500.007,500.007,500.007,500.007,500.007,500.007,500.00Contabilidad450.00450.00450.00450.00450.00450.00450.00450.00450.00450.00450.00450.00Medico veterinario1,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.001,000.00Velador4,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.00Agua80.0080.0080.0080.0080.0080.0080.0080.0080.0080.0080.0080.00Servicio de telefono600.00600.00600.00600.00600.00600.00600.00600.00600.00600.00600.00600.00

Subtotal14,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.00

CAPITAL DE TRABAJOPROYECTO DE ENGORDA DE POLLOSCALCULO DE CAPITAL DE TRABAJOCONCEPTOMESES PRIMER AOMes 1Mes 2Mes 3Mes 4Mes 5Mes 6Mes 7Mes 8Mes 9Mes 10Mes 11Mes 12INGRESOSPor ventas0.00.0101,578.94101,578.94101,578.94101,578.94101,578.94101,578.94101,578.94101,578.94101,578.94101,578.94EGRESOSCostos variables36,590.1943,895.4651,590.1951,895.4651,590.1951,895.4653,590.1951,895.4651,590.1951,895.4651,590.1951,895.46Costos fijos14,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.0014,130.00Total Egresos50,720.1958,025.4665,720.1966,025.4665,720.1966,025.4667,720.1966,025.4665,720.1966,025.4665,720.1966,025.46Flujo de efectivo (ventas-costos)(50,720.19)(58,025.46)35,858.7535,553.4835,858.7535,553.4833,858.7535,553.4835,858.7535,553.4835,858.7535,553.48Efectiv o acumulado (efectivo-efectivo acumulado anterior)(50,720.19)(108,745.65)(72,886.90)(37,333.42)(1,474.67)34,078.8167,937.56103,491.04139,349.79174,903.27210,762.02246,315.50CAPITAL DE TRABAJO =(108,745.65)SE PUEDE NOTAR QUE EXISTEN 5 VALORES NEGATIVOS Y LA CELDA D14 PRESENTA EL VALOR NEGATIVO MAS ALTOENTONCES, EL CAPITAL DE TRABAJO ES IGUAL A $ 108.745,64

PASOS PASOS PARA EL CALCULO DEL CAPITAL DE TRABAJO

PASO 1ENLAZAR O VINCULAR LOS INGREOS POR VENTAS MENSUALES EN LA FILA DE INGRESOS. RECORDAR QUE NO EN TODOS LOS MESES DEL AO VA HABER INGRESOS. EN ESTE CASO EN LOS DOS PRIMEROS MESES NO HUBO INGRESOS, POR LO TANTO EL VALOR DEL AO 1 DE LA TABLA DE INGRESOS SE DEBE DIVIDE POR LOS 10 MESES RESTANTES.PASO 2ENLAZAR O VINCULAR LOS COTOS VARIABLES, COSTOS FIJOS Y HACER LA SUMATORIA DE ESTOS POR MES.PASO 3CALCULAR EL FLUJO DE EFECTIVO MENSUAL CON LA SIGUIENTE OPERACIN: RESTAR= VENTAS MENSUALES - COSTOS TOTALES MENSUALESPASO 4CALCULAR EL FLUJO DE EFECTIVO MENSUAL ACUMULADO CON LA SIGUIENTE OPERACIN: SUMAR = FLUJO DE EFECTIVO MENSUAL + FLUJO DE EFECTIVO DEL MES ANTERIOR