Presupuesto Efectivo
8
MAYO JUNIO JULIO AGOSTO VENTAS $60,000,000 $60,000,000 $120,000,000 $180,000,000 IVA $9,600,000 $9,600,000 $19,200,000 $28,800,000 Retefuente $1,500,000 $1,500,000 $3,000,000 $4,500,000 Total $68,100,000 $68,100,000 $136,200,000 204,300,000 CARTERA MAYO JUNIO JULIO AGOSTO 5% contado $3,405,000 $3,405,000 $6,810,000 $10,215,000 70% a 30 dias $47,670,000 $47,670,000 $95,340,000 25% a 60 dias $17,025,000 $17,025,000 total $3,405,000 $51,075,000 $71,505,000 $122,580,000 MATERIA PRIMA MAYO JUNIO JULIO AGOSTO VENTA $10,000,000 $10,000,000 $22,000,000 $100,000,000 IVA $1,600,000 $1,600,000 $3,520,000 $16,000,000 RETEFUENTE $250,000 $250,000 $550,000 $2,500,000 TOTAL $11,350,000 $11,350,000 $24,970,000 $113,500,000 PAGO A PROVEEDORES PERIODO MAYO JU NIO JULIO AGOSTO A Pagar 0 $11,350,000 $11,350,000 $24,970,000 ARRIENDOS MAYO JUNIO JULIO AGOSTO VENTA $3,000,000 $3,000,000 $3,000,000 $3,000,000 IVA $480,000 $480,000 $480,000 $480,000 RETEFUENTE $105,000 $105,000 $105,000 $105,000 TOTAL $3,375,000 $3,375,000 $3,375,000 $3,375,000 GASTOS FIJOS PERIODO MAYO JUNIO JULIO AGOSTO G.ADMIN $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 G.VENTAS $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 G.FINANCIEROS $ 900,000 $ 900,000 $ 900,000 $ 900,000 MANTENIMIENT TOTAL $ 9,900,000 $ 9,900,000 $ 9,900,000 $ 9,900,000
-
Upload
brayan-mora -
Category
Documents
-
view
214 -
download
1
description
Presupuesto efecivo
Transcript of Presupuesto Efectivo
PRESUPUESTO EN VENTAS
MAYO JUNIO JULIO AGOSTO SEPTIEMBREVENTAS $60,000,000 $60,000,000 $120,000,000 $180,000,000 $240,000,000IVA $9,600,000 $9,600,000 $19,200,000 $28,800,000 $38,400,000Retefuente $1,500,000 $1,500,000 $3,000,000 $4,500,000 $6,000,000Total $68,100,000 $68,100,000 $136,200,000 204,300,000 $272,400,000
CARTERAMAYO JUNIO JULIO AGOSTO SEPTIEMBRE
5% contado $3,405,000 $3,405,000 $6,810,000 $10,215,000 $13,620,00070% a 30 dias $47,670,000 $47,670,000 $95,340,000 $143,010,00025% a 60 dias $17,025,000 $17,025,000 $34,050,000total $3,405,000 $51,075,000 $71,505,000 $122,580,000 $190,680,000
MATERIA PRIMAMAYO JUNIO JULIO AGOSTO SEPTIEMBRE
VENTA $10,000,000 $10,000,000 $22,000,000 $100,000,000 $92,000,000IVA $1,600,000 $1,600,000 $3,520,000 $16,000,000 $14,720,000RETEFUENTE $250,000 $250,000 $550,000 $2,500,000 $2,300,000TOTAL $11,350,000 $11,350,000 $24,970,000 $113,500,000 $104,420,000
PAGO A PROVEEDORESPERIODO MAYO JU NIO JULIO AGOSTO SEPTIEMBRE A Pagar 0 $11,350,000 $11,350,000 $24,970,000 $113,500,000
ARRIENDOSMAYO JUNIO JULIO AGOSTO SEPTIEMBRE
VENTA $3,000,000 $3,000,000 $3,000,000 $3,000,000 $3,000,000IVA $480,000 $480,000 $480,000 $480,000 $480,000RETEFUENTE $105,000 $105,000 $105,000 $105,000 $105,000TOTAL $3,375,000 $3,375,000 $3,375,000 $3,375,000 $3,375,000
GASTOS FIJOS PERIODO MAYO JUNIO JULIO AGOSTO SEPTIEMBREG.ADMIN $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 4,000,000 G.VENTAS $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 G.FINANCIEROS $ 900,000 $ 900,000 $ 900,000 $ 900,000 $ 900,000 MANTENIMIENTTOTAL $ 9,900,000 $ 9,900,000 $ 9,900,000 $ 9,900,000 $ 9,900,000
PRESUPUESTO EN VENTAS
OCTUBRE NOVIEMBRE DICIEMBRE$120,000,000 $120,000,000 $30,000,000
$19,200,000 $19,200,000 $4,800,000$3,000,000 $3,000,000 $750,000
$136,200,000 $136,200,000 $34,050,000
OCTUBRE NOVIEMBRE DICIEMBRE ENERO FEBRERO TOTAL$6,810,000 $6,810,000 $1,702,500 52,777,500
$190,680,000 $95,340,000 $95,340,000 $23,835,000 738,885,000$51,075,000 $68,100,000 $34,050,000 $34,050,000 $8,512,500 263,887,500
$248,565,000 $170,250,000 $131,092,500 $57,885,000 $8,512,500 1,055,550,000
OCTUBRE NOVIEMBRE DICIEMBRE TOTAL$58,000,000 $34,000,000 $10,000,000 336,000,000
$9,280,000 $5,440,000 $1,600,000 53,760,000$1,450,000 $850,000 $250,000 8,400,000
$65,830,000 $38,590,000 $11,350,000 $381,360,000
OCTUBRE NOVIEMBRE DICIEMBRE TOTAL $104,420,000 $65,830,000 $38,590,000 $ 347,310,000
OCTUBRE NOVIEMBRE DICIEMBRE TOTAL$3,000,000 $3,000,000 $3,000,000 24,000,000
$480,000 $480,000 $480,000 3,840,000$105,000 $105,000 $105,000 840,000
$3,375,000 $3,375,000 $3,375,000 $27,000,000
OCTUBRE NOVIEMBRE DICIEMBRE TOTAL $ 4,000,000 $ 4,000,000 $ 4,000,000 $ 32,000,000 $ 5,000,000 $ 5,000,000 $ 5,000,000 $ 40,000,000 $ 900,000 $ 900,000 $ 900,000 $ 7,200,000 $ 60,000,000 $ 60,000,000 $ 69,900,000 $ 9,900,000 $ 9,900,000 $ 139,200,000
IVAMAYO JUNIO JULIO AGOSTO
VENTA $9,600,000 $9,600,000 $19,200,000 $28,800,000COMPRAS M P $1,600,000 $1,600,000 $3,520,000 $16,000,000ARRENDAMIENTO $480,000 $480,000 $480,000 $480,000TOTAL $7,520,000 $7,520,000 $15,200,000 $12,320,000
A PAGAR $15,040,000
RETEFUENTEMAYO JUNIO JULIO AGOSTO
VENTAS $1,500,000 $1,500,000 $3,000,000 $4,500,000COMPRAS M P $250,000 $250,000 $550,000 $2,500,000ARRENDAMIENTO $105,000 $105,000 $105,000 $105,000TOTAL A PAGAR $1,855,000 $1,855,000 $3,655,000 $7,105,000
NOMINA PERIODO MAYO JUNIO JULIO AGOSTOSALARIO $ 19,630,000 $ 19,630,000 $ 19,630,000 $ 19,630,000 AUX TRANSPOR $ 370,000 $ 370,000 $ 370,000 $ 370,000 TOTAL DEVENGA $ 20,000,000 $ 20,000,000 $ 20,000,000 $ 20,000,000 SALUD $ 785,200 $ 785,200 $ 785,200 $ 785,200 PENSION $ 785,200 $ 785,200 $ 785,200 $ 785,200 NETO A PAGAR $ 18,429,600 $ 18,429,600 $ 18,429,600 $ 18,429,600 C.C.F $ 785,200 $ 785,200 $ 785,200 $ 785,200 ARL $ 102,469 $ 102,469 $ 102,469 $ 102,469 PENSION $ 2,355,600 $ 2,355,600 $ 2,355,600 $ 2,355,600 TOTAL $ 3,243,269 $ 3,243,269 $ 3,243,269 $ 3,243,269 CESANTIAS $ 1,666,000 $ 1,666,000 $ 1,666,000 $ 1,666,000 I/CESANTIAS $ 16,660 $ 16,660 $ 16,660 $ 16,660 PRIMA LEGAL $ 1,666,000 $ 1,666,000 $ 1,666,000 $ 1,666,000 VACACIONES $ 818,571 $ 818,571 $ 818,571 $ 818,571 TOTAL $ 4,167,231 $ 4,167,231 $ 4,167,231 $ 4,167,231
FLUJO DE CAJA PERIODO JULIO AGOSTO SEPTIEMBRE OCTUBRE SALDO INICIAL $ 10,000,000 $ 19,812,131 $ 81,819,263 $ 72,926,394 VENTAS $ 71,505,000 $ 122,580,000 $ 190,680,000 $ 248,565,000 TOTAL INGRESOS $ 81,505,000 $ 142,392,131 $ 272,499,263 $ 321,491,394 COMPRAS $ 11,350,000 $ 24,970,000 $ 113,500,000 $ 104,420,000
GASTOS $ 13,275,000 $ 13,275,000 $ 13,275,000 $ 73,275,000 IMPUESTOS $ 15,395,000 $ 655,000 $ 51,125,000 $ 2,405,000 O.LABORALES $ 18,429,600 $ 18,429,600 $ 18,429,600 $ 18,429,600 PRESTACIONES $ 3,243,269 $ 3,243,269 $ 3,243,269 $ 3,243,269 TOTAL EGRESOS $ 61,692,869 $ 60,572,869 $ 199,572,869 $ 201,772,869 SALDO FINAL $ 19,812,131 $ 81,819,263 $ 72,926,394 $ 119,718,526
SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE TOTAL$38,400,000 $19,200,000 $19,200,000 $4,800,000 148,800,000$14,720,000 $9,280,000 $5,440,000 $1,600,000 53,760,000
$480,000 $480,000 $480,000 $480,000 3,840,000$23,200,000 $9,440,000 $13,280,000 $2,720,000 91,200,000
$27,520,000 $32,640,000
SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE TOTAL$6,000,000 $3,000,000 $3,000,000 $750,000 23,250,000$2,300,000 $1,450,000 $850,000 $250,000 8,400,000
$105,000 $105,000 $105,000 $105,000 840,000$8,405,000 $4,555,000 $3,955,000 $1,105,000 32,490,000
SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE TOTAL $ 19,630,000 $ 19,630,000 $ 19,630,000 $ 19,630,000 $ 157,040,000 $ 370,000 $ 370,000 $ 370,000 $ 370,000 $ 2,960,000 $ 20,000,000 $ 20,000,000 $ 20,000,000 $ 20,000,000 $ 160,000,000 $ 785,200 $ 785,200 $ 785,200 $ 785,200 $ 6,281,600 $ 785,200 $ 785,200 $ 785,200 $ 785,200 $ 6,281,600 $ 18,429,600 $ 18,429,600 $ 18,429,600 $ 18,429,600 $ 110,577,600 $ 785,200 $ 785,200 $ 785,200 $ 785,200 $ 4,711,200 $ 102,469 $ 102,469 $ 102,469 $ 102,469 $ 614,812 $ 2,355,600 $ 2,355,600 $ 2,355,600 $ 2,355,600 $ 14,133,600 $ 3,243,269 $ 3,243,269 $ 3,243,269 $ 3,243,269 $ 25,946,149 $ 1,666,000 $ 1,666,000 $ 1,666,000 $ 1,666,000 $ 13,328,000 $ 16,660 $ 16,660 $ 16,660 $ 16,660 $ 133,280 $ 1,666,000 $ 1,666,000 $ 1,666,000 $ 1,666,000 $ 13,328,000 $ 818,571 $ 818,571 $ 818,571 $ 818,571 $ 6,548,568 $ 4,167,231 $ 4,167,231 $ 4,167,231 $ 4,167,231 $ 33,337,848
NOVIEMBRE DICIEMBRE TOTAL $ 119,718,526 $ 154,995,657 $ 459,271,971 $ 170,250,000 $ 131,092,500 $ 934,672,500 $ 289,968,526 $ 286,088,157 $ 1,393,944,471 $ 65,830,000 $ 38,590,000 $ 358,660,000
$ 13,275,000 $ 13,275,000 $ 139,650,000 $ 34,195,000 $ 21,955,000 $ 125,730,000 $ 18,429,600 $ 18,429,600 $ 110,577,600 $ 3,243,269 $ 28,246,655 $ 44,462,998 $ 134,972,869 $ 120,496,255 $ 779,080,598 $ 154,995,657 $ 165,591,902 $ 614,863,873
