EVALUACION 19032015EVALUACION 19/03/2015

SOLUCIN

PRESUPUESTO DE FACTURACIN

DICENEFEBMARTOTALVENTAS NETAS$ 32,000,000$ 36,000,000$ 32,000,000$ 45,000,000$ 145,000,000IVA GENERADO16%$ 5,120,000$ 5,760,000$ 5,120,000$ 7,200,000$ 23,200,000TOTAL FACTURACION$ 37,120,000$ 41,760,000$ 37,120,000$ 52,200,000$ 168,200,000

PRESUPUESTO DE RECAUDOS DE CARTERA

DICENEFEBMARTOTALDE CONTADO10%$ 3,712,000$ 4,176,000$ 3,712,000$ 5,220,000$ 16,820,000A 30 DAS 50%$ 18,560,000$ 20,880,000$ 18,560,000$ 58,000,000A 60 DAS 40%$ 14,848,000$ 16,704,000$ 31,552,000TOTAL RECAUDO100%$ 3,712,000$ 22,736,000$ 39,440,000$ 40,484,000$ 106,372,000

PRESUPUESTO DE COMOPRAS CON IMPUESTOS

DICENEFEBMARTOTALCOMPRAS M.P $ 22,000,000$ 30,000,000$ 28,000,000$ 40,000,000$ 120,000,000IVA DESCONTABLE 16%$ 3,520,000$ 4,800,000$ 4,480,000$ 6,400,000$ 19,200,000TOTAL FACTURACION$ 25,520,000$ 34,800,000$ 32,480,000$ 46,400,000$ 139,200,000

PRESUPUESTO DE PAGO DE IVA

DICENEFEBMARTOTALIVA CONTABLE16%$ 5,120,000$ 5,760,000$ 5,120,000$ 7,200,000$ 23,200,000IVA DESCONTABLE16%$ 3,520,000$ 4,800,000$ 4,480,000$ 6,400,000$ 19,200,000DIFERENCIA$ 1,600,000$ 960,000$ 640,000$ 800,000$ 4,000,000PAGO BIMESTRAL $ 1,600,000$ 1,600,000$ 3,200,000

PRESUPUESTO DE PAGO DE PROVEEDORES

DICENEFEBMARTOTALPAGO M.P60 DAS$ 22,000,000$ 30,000,000$ 52,000,000IVA DESCONTABLE16%$ 3,520,000$ 4,800,000$ 8,320,000PAGO BIMESTRAL $ 25,520,000$ 34,800,000$ 60,320,000

PRESUPUESTO DE MANO DE OBRA DIRECTA

CONCEPTO DICENEFEBMARTOTALSUELDO$ 4,926,000$ 4,926,000$ 4,926,000$ 4,926,000$ 4,926,000$ 4,926,000$ 4,926,000$ 34,482,000SUBSIDIO$ 74,000$ 74,000$ 74,000$ 74,000$ 74,000$ 74,000$ 74,000$ 518,000HORAS EXTRAS S.S.I MAS PARAFISCALES $ 839,587$ 839,587$ 839,587$ 839,587$ 839,587$ 839,587$ 839,587$ 5,877,112PROVISINES SIN VACACIONES $ 883,000$ 883,000$ 883,000$ 883,000$ 883,000$ 883,000$ 883,000$ 6,181,000PROVISIN VACASIONES$ 205,414$ 205,414$ 205,414$ 205,414$ 205,414$ 205,414$ 205,414$ 1,437,899TOTAL $ 6,928,002$ 6,928,002$ 6,928,002$ 6,928,002$ 6,928,002$ 6,928,002$ 6,928,002$ 48,496,011

CEDULA GMF 4 POR MIL

DICENEFEBMARTOTALRETIROS DE LA CUENTA GMF4 POR MIL TOTAL DEVENGADO 5.000.000 SUBSIDIO DE TRANSPORTE 74.0005,000,0004,926,00074,000

PRESUPUESTO DE EFECTIVO

CONCEPTODICENEFEBMARTOTALRECAUDOS DE CARTERA $ 22,736,000$ 39,440,000$ 40,484,000$ 102,660,000MENOS PAGOS A PROVEEDORES$ 25,520,000$ 34,800,000$ 60,320,000SALARIOS $ 6,928,002$ 6,928,002$ 6,928,002$ 20,784,005GAT. ADMINISTRATIVOS Y VENTAS$ 3,000,000$ 3,000,000$ 3,000,000$ 9,000,000ARRENDAMIENTOS $ 1,000,000$ 1,000,000$ 1,000,000$ 3,000,000IMPUESTO A LA VENTA$ 1,600,000$ 1,600,000$ 3,200,000IMPUESTO DE RENTATOTAL DE EGRESOS OPERATIVOS $ 12,528,002$ 36,448,002$ 47,328,002$ 96,304,005

EGO (EFECT. GRADO. OPERACIN)

MENOS ACTIVIDAD DE FINANCIACIN $ 10,207,998$ 2,991,998$ (6,844,002)$ 6,355,995GASTOS FINANCIEROS gmf $ 50,000$ 50,000$ 50,000$ 150,000

MENOS INVERSIONES$ 4,000,000$ 4,000,000

IGUAL A AUMENTO O DISMINUCION DE CAJA $ 6,157,998$ 2,941,998$ (6,894,002)$ 2,205,995MAS EFECTIVO INICIAL $ 2,000,000$ 7,157,998$ 10,099,997$ 19,257,995MENOS EFECTIVO MINIMO$ 1,000,000$ 1,000,000IGUAL A EFECTIVO DISPONIBLE$ 7,157,998$ 10,099,997$ 3,205,995$ 20,463,990 HORIZONTAL $ 20,463,990

VERTICAL