Presupuesto Parque 2008

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 4

ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC TOTAL

Ventas
JARDIN PRIV. 0 0 0 0 0 0 0 0 147,000 0 0 0 147,000
1/0 0 0 0 0 0 0 0 0 0 0 0 0 0
TA 1/1 N 0 42,000 0 42,000 21,000 42,000 42,000 21,000 0 0 42,000 21,000 273,000
TT 2/0 N 0 0 29,400 29,400 0 29,400 0 0 29,400 29,400 29,400 0 176,400
TA 2/2 N 378,000 403,200 428,400 403,200 428,400 554,400 201,600 352,800 579,600 378,000 882,000 453,600 5,443,200
TA 2/2 P 60,060 60,060 90,090 0 30,030 30,030 30,030 30,030 90,090 30,030 60,060 30,030 540,540
TT 3/1 N 75,600 37,800 0 0 0 37,800 0 37,800 37,800 37,800 75,600 37,800 378,000
TT 3/1 P 42,000 42,000 42,000 0 0 0 0 0 42,000 42,000 42,000 0 252,000
TA 3/3 N 94,500 31,500 31,500 31,500 31,500 94,500 31,500 63,000 63,000 157,500 189,000 94,500 913,500
TA 3/3 P 117,810 39,270 39,270 0 0 39,270 39,270 39,270 78,540 78,540 78,540 78,540 628,320
NICHOS 0 0 0 0 0 0 0 0 0 0 0 0 0

Suma 767,970 24 655,830 22 660,660 22 506,100 18 510,930 18 827,400 28 344,400 13 543,900 18 1,067,430 31 753,270 23 1,398,600 46 715,470 24 8,751,960 287

Costo de Ventas
JARDIN PRIV. 0 0 0 0 0 0 0 0 35,769 0 0 0 35,769
1/0 0 0 0 0 0 0 0 0 0 0 0 0 0
TA 1/1 N 0 14,553 0 14,553 7,276 14,553 14,553 7,276 0 0 14,553 7,276 94,594
TT 2/0 N 0 0 8,290 8,290 0 8,290 0 0 8,290 8,290 8,290 0 49,739
TA 2/2 N 142,439 151,935 161,431 151,935 161,431 208,911 75,968 132,943 218,407 142,439 332,358 170,927 2,051,123
TA 2/2 P 19,592 19,592 29,388 0 9,796 9,796 9,796 9,796 29,388 9,796 19,592 9,796 176,327
TT 3/1 N 22,557 11,278 0 0 0 11,278 0 11,278 11,278 11,278 22,557 11,278 112,783
TT 3/1 P 11,278 11,278 11,278 0 0 0 0 0 11,278 11,278 11,278 0 67,670
TA 3/3 N 22,374 7,458 7,458 7,458 7,458 22,374 7,458 14,916 14,916 37,290 44,748 22,374 216,282
TA 3/3 P 22,374 7,458 7,458 0 0 7,458 7,458 7,458 14,916 14,916 14,916 14,916 119,328
NICHOS 0 0 0 0 0 0 0 0 0 0 0 0 0

Suma 240,614 223,552 225,303 182,236 185,961 282,660 115,232 183,668 344,242 235,287 468,291 236,568 2,923,614

Utilidad Bruta
JARDIN PRIV. 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 111,231 123.5% 0 #DIV/0! 0 0.0% 0 0.0% 111,231 75.7%
1/0 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%
TA 1/1 N 0 #DIV/0! 27,447 65.4% 0 0.0% 27,447 65.4% 13,724 0.0% 27,447 65.4% 27,447 65.4% 13,724 65.4% 0 #DIV/0! 0 0.0% 27,447 65.4% 13,724 65.4% 178,406 65.4%
TT 2/0 N 0 #DIV/0! 0 0.0% 21,110 71.8% 21,110 67.0% 0 0.0% 21,110 22.3% 0 0.0% 0 0.0% 21,110 33.5% 21,110 13.4% 21,110 11.2% 0 0.0% 126,662 71.8%
TA 2/2 N 235,561 62.3% 251,265 62.3% 266,969 62.3% 251,265 62.3% 266,969 62.3% 345,489 62.3% 125,632 62.3% 219,857 62.3% 361,193 62.3% 235,561 62.3% 549,642 62.3% 282,673 62.3% 3,392,077 62.3%
TA 2/2 P 40,468 67.4% 40,468 67.4% 60,702 67.4% 0 #DIV/0! 20,234 67.4% 20,234 67.4% 20,234 67.4% 20,234 67.4% 60,702 67.4% 20,234 67.4% 40,468 67.4% 20,234 67.4% 364,213 67.4%
TT 3/1 N 53,044 6.9% 26,522 70.2% 0 0.0% 0 0.0% 0 0.0% 26,522 70.2% 0 0.0% 26,522 70.2% 26,522 2.5% 26,522 3.5% 53,044 3.8% 26,522 3.7% 265,218 70.2%
TT 3/1 P 30,722 0.0% 30,722 0.0% 30,722 0.0% 0 0.0% 0 0.0% 0 0.0% 0 #DIV/0! 0 0.0% 30,722 0.0% 30,722 73.1% 30,722 0.0% 0 0.0% 184,331 73.1%
TA 3/3 N 72,126 76.3% 24,042 76.3% 24,042 0.0% 24,042 76.3% 24,042 76.3% 72,126 0.0% 24,042 0.0% 48,084 76.3% 48,084 76.3% 120,210 0.0% 144,252 76.3% 72,126 76.3% 697,218 76.3%
TA 3/3 P 95,436 81.0% 31,812 81.0% 31,812 81.0% 0 0.0% 0 #DIV/0! 31,812 81.0% 31,812 81.0% 31,812 81.0% 63,624 81.0% 63,624 81.0% 63,624 81.0% 63,624 81.0% 508,992 81.0%
NICHOS 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0% 0 0.0%

Suma 527,356 319,180 348,781 299,822 300,927 414,281 173,314 253,814 554,237 276,905 638,668 316,631 4,172,588
% 68.7% 48.7% 52.8% 59.2% 58.9% 50.1% 50.3% 46.7% 51.9% 36.8% 45.7% 44.3% 47.7%

Gastos de Operación
GASTOS GENERALES, #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Suma #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Utilidad de Operación #REF! #REF! 0 #REF! 0 #REF! 0 #REF! 0 #REF! 0 #REF! 0 #REF! 0 #REF! 0 #REF! 0 #REF! 0 #REF! #REF!
% #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Otros Ingresos #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!

Utilidad Neta #REF!


% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% #REF!

739203441.xls 03/26/202423:20:36 1
Tipo de Servicio. ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC TOTAL

T.A. 1/1 0.00 2.00 0.00 2.00 1.00 2.00 2.00 1.00 0.00 0.00 2.00 1.00 13

T.A. 2/2 PREF. 2.00 2.00 3.00 0.00 1.00 1.00 1.00 1.00 3.00 1.00 2.00 1.00 18

T.A. 2/2 NORMAL 15.00 16.00 17.00 16.00 17.00 22.00 8.00 14.00 23.00 15.00 35.00 18.00 216

T/A 3/3 PREF. 3.00 1.00 1.00 0.00 0.00 1.00 1.00 1.00 2.00 2.00 2.00 2.00 16

T.A. 3/3 NORMAL 3.00 1.00 1.00 1.00 1.00 3.00 1.00 2.00 2.00 5.00 6.00 3.00 29

T.T. 2/0 NORMAL 0.00 0.00 1.00 1.00 0.00 1.00 0.00 0.00 1.00 1.00 1.00 0.00 6

T.T. 3/1 PREF. 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 1.00 0.00 6

T.T. 3/1 NORMAL 2.00 1.00 0.00 0.00 0.00 1.00 0.00 1.00 1.00 1.00 2.00 1.00 10

JARDIN PRIV. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 1

NICHOS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0

Total servicios 24 22 22 18 18 28 13 18 31 23 46 24 315

Piso 0.08 Flotilla 0.058 Intercambio 0.043 Casa 0.04

Ventas por Tipo de Servicios Precio Unit. ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC TOTAL
T.A. 1/1 21,000 0 42,000 0 42,000 21,000 42,000 42,000 21,000 0 0 42,000 21,000 273,000
T.A. 2/2 PREF. 30,030 60,060 60,060 90,090 0 30,030 30,030 30,030 30,030 90,090 30,030 60,060 30,030 540,540
T.A. 2/2 NORMAL 25,200 378,000 403,200 428,400 403,200 428,400 554,400 201,600 352,800 579,600 378,000 882,000 453,600 5,443,200
T/A 3/3 PREF. 39,270 117,810 39,270 39,270 0 0 39,270 39,270 39,270 78,540 78,540 78,540 78,540 628,320
T.A. 3/3 NORMAL 31,500 94,500 31,500 31,500 31,500 31,500 94,500 31,500 63,000 63,000 157,500 189,000 94,500 913,500
T.T. 2/0 NORMAL 29,400 0 0 29,400 29,400 0 29,400 0 0 29,400 29,400 29,400 0 176,400
T.T. 3/1 PREF. 42,000 42,000 42,000 42,000 0 0 0 0 0 42,000 42,000 42,000 0 252,000
T.T. 3/1 NORMAL 37,800 75,600 37,800 0 0 0 37,800 0 37,800 37,800 37,800 75,600 37,800 378,000
JARDIN PRIV. 147,000 0 0 0 0 0 0 0 0 147,000 0 0 0 147,000
NICHOS 0 0 0 0 0 0 0 0 0 0 0 0 0 0

TOTAL 403,200 767,970 655,830 660,660 506,100 510,930 827,400 344,400 543,900 1,067,430 753,270 1,398,600 715,470 8,751,960
Costo de Venta por Tipo de Se Costo Unit. ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC TOTAL
T.A. 1/1 7,276 0 14,553 0 14,553 7,276 14,553 14,553 7,276 0 0 14,553 7,276 94,594
T.A. 2/2 PREF. 9,796 19,592 19,592 29,388 0 9,796 9,796 9,796 9,796 29,388 9,796 19,592 9,796 176,327
T.A. 2/2 NORMAL 9,496 142,439 151,935 161,431 151,935 161,431 208,911 75,968 132,943 218,407 142,439 332,358 170,927 2,051,123
T/A 3/3 PREF. 7,458 22,374 7,458 7,458 0 0 7,458 7,458 7,458 14,916 14,916 14,916 14,916 119,328
T.A. 3/3 NORMAL 7,458 22,374 7,458 7,458 7,458 7,458 22,374 7,458 14,916 14,916 37,290 44,748 22,374 216,282
T.T. 2/0 NORMAL 8,290 0 0 8,290 8,290 0 8,290 0 0 8,290 8,290 8,290 0 49,739
T.T. 3/1 PREF. 11,278 11,278 11,278 11,278 0 0 0 0 0 11,278 11,278 11,278 0 67,670
T.T. 3/1 NORMAL 11,278 22,557 11,278 0 0 0 11,278 0 11,278 11,278 11,278 22,557 11,278 112,783
JARDIN PRIV. 35,769 0 0 0 0 0 0 0 0 35,769 0 0 0 35,769
NICHOS 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Total Costo Servicios 108,100 240,614 223,552 225,303 182,236 185,961 282,660 115,232 183,668 344,242 235,287 468,291 236,568 2,923,614

Resumen Servicios ENE FEB MAR ABR MAY JUN JUL AGO SEP OCT NOV DIC TOTAL
767,970 655,830 660,660 506,100 510,930 827,400 344,400 543,900 1,067,430 753,270 1,398,600 715,470 8,751,960
COSTO TOTAL 240,614 223,552 225,303 182,236 185,961 282,660 115,232 183,668 344,242 235,287 468,291 236,568 2,923,614
UTILIDAD BRUTA 527,356 432,278 435,357 323,864 324,969 544,740 229,168 360,232 723,188 517,983 930,309 478,902 5,828,346
% MARGEN 68.7% 65.9% 65.9% 64.0% 63.6% 65.8% 66.5% 66.2% 67.8% 68.8% 66.5% 66.9% 66.6%
EJERCICIO 2008
MES VTAS IMPORTE
ENERO 30 702,415.45
FEBRERO 17 439,663.65
MARZO 23 679,972.50
ABRIL 26 571,799.97
MAYO 27 634,199.97
JUNIO 19 491,618.16
JULIO 16 369,027.26
AGOSTO 19 466,581.83
SEPTIEMBRE 30 692,849.99
OCTUBRE 19 457,227.28
NOVIEMBRE 33 795,817.67
DICIEMBRE 30 647,863.65
TOTALES 289 6,949,037.38

You might also like