Condominio Las Torres Gemelas

INFORMACION ESTADISTICA Y ANALITICA

Cuadro de texto: INFORMACION ESTADISTICA Y ANALITICA Presupuesto de Gastos 2003 / 2003 Expense Budget

CONDOMINIO LAS TORRES GEMELAS

PRESUPUESTO DE OPERACION

EJERCICIO 2003

A C U M U L A D O

GASTO REAL PRESUPUESTO DIFERENCIA %

SUELDOS Y PRESTACIONES 2002 2,003

SUELDO NOMINAL BASE SALARY 3,824,651.20 4,373,955.49 549,304.29 14.36%

SEGURO SOCIAL SOCIAL SEGURITY 799,706.88 968,919.53 169,212.65 21.16%

ALIMENTOS A EMPLEADOS MEALS FOR EMPLOYEES 1,134,553.73 1,072,763.52 -61,790.21 -5.45%

VALES DE DESPENSA FOOD COUPONS 408,975.00 569,964.83 160,989.83 39.36%

HORAS EXTRAS OVERTIME WAGES 158,602.75 123,746.38 -34,856.37 -21.98%

5% INFONAVIT 5% HOUSING TAX 266,889.90 292,884.01 25,994.11 9.74%

AGUINALDOS CRISTMAS BONUS 255,796.23 270,016.15 14,219.92 5.56%

IDEMNIZACIONES SEVERANCE PAYMENT 256,924.99 260,702.06 3,777.07 1.47%

IMPUESTO ESTATAL STATE PAYROLL TAX 149,692.35 158,865.28 9,172.93 6.13%

VACACIONES VACATION PAYMENT 166,850.08 201,889.71 35,039.63 21.00%

DIAS FESTIVOS DOYBLE TIME ON HOLIDAYS 92,155.30 90,381.36 -1,773.94 -1.92%

OTRAS PRESTACIONES OTRAS BENEFITS 330,791.73 366,441.80 35,650.07 10.78%

S.A.R. RETIREMENT FUND 107,913.16 116,767.67 8,854.51 8.21%

UNIFORMES Y ADIESTRAMIENTO UNIFORMS 65,405.49 122,880.00 57,474.51 87.87%

PRESTACIONES A EJECUTIVOS MANAGEMENT BENEFITS 123,386.29 173,732.80 50,346.51 40.80%

PRIMA DOMINICAL SUNDAY BONUS 83,420.61 91,346.35 7,925.74 9.50%

RESERVA PARA PRIMA DE ANTIGUEDAD RETIREMENT RESERVE 122,853.96 160,000.00 37,146.04 30.24%

PRIMA VACACIONAL VACATION PREMIUM 60,526.68 74,459.80 13,933.12 23.02%

DIFERENCIAS DE INCAPACI. SICK BENEFITS 33,608.52 36,108.00 2,499.48 7.44%

SINDICATO UNION 430,267.80 156,319.92 -273,947.88 -63.67%

COMPENSACION A PRACTICAN. PAYMENTS TO TEMPORARY HELP 12,630.00 14,400.00 1,770.00 14.01%

CREDITO AL SALARIO CREDIT TO SALARY 138,373.36 144,541.48 6,168.12 4.46%

SUB-TOTAL SUELDOS Y P SUB-TOTAL SALARIES AND BENEFITS 9,023,976.01 9,841,086.14 817,110.13 9.05%

ENERGETICOS

LUZ LIGHT 2,462,361.15 2,856,796.88 394,435.73 16.02%

AGUA WATER 1,879,603.21 2,091,089.51 211,486.30 11.25%

DIESEL DIESEL 306,296.62 397,465.20 91,168.58 29.76%

SUB-TOTAL ENERGETICOS SUB TOTAL ENERGETICS 4,648,260.98 5,345,351.59 697,090.61 15.00%

MANTENIMIENTO

MANTO ELEVADORES MAINTENANCE ELEVATORS 274,572.72 282,757.00 8,184.28 2.98%

SUMINISTRO DE HABITACIONES SUPPLIES FOR ROOMS 141,710.71 162,224.25 20,513.54 14.48%

MATERIAL ELECTRICO ELECTRICALSUPPLIES 212,627.97 155,960.71 -56,667.26 -26.65%

MANTO AIRE ACONDICIONADO MAINTENANCE AIRD COND. 26,673.86 60,505.00 33,831.14 126.83%

PINTURA PAINT 343,720.81 253,401.35 -90,319.46 -26.28%

PLOMERIA PLUMBING SUPPLIES 135,119.59 102,089.62 -33,029.97 -24.44%

MATERIAL PARA ALBERCA POOL SUPPLIES 93,686.59 96,550.14 2,863.55 3.06%

MANTO SISTEMA DE COMPUTO MAINTENANCE COMPUTERS 39,971.78 75,500.00 35,528.22 88.88%

SUMINISTRO SER AREAS PUBL CLEANING SUPPLIES COMMON AR 257,694.66 247,128.00 -10,566.66 -4.10%

FUMIGACION FUMIGATION 119,458.61 124,988.71 5,530.10 4.63%

MANTO EQUIPO DE TRANSPORT MAINTENANCE VEHICLES 113,421.20 72,400.00 -41,021.20 -36.17%

MANTO EQUIPO HIDRAULICO MAINTENANCE HIDRAULIC EQUIP 350,429.36 165,500.00 -184,929.36 -52.77%

MANTO. EQUIPO DE SERVICIO MAINTENANCE SERVICE EQUIP 132,276.51 125,420.44 -6,856.07 -5.18%

TAPICERIA UPHOLSTERY MATERIAL/LOUNGES 4,211.50 5,400.00 1,188.50 28.22%

ALBAÑILERIA BUILDING SUPPLIES 103,811.55 104,385.00 573.45 0.55%

CERRAJERIA LOCKSMITH & SULLPIES 93,751.32 65,570.00 -28,181.32 -30.06%

HERRAMIENTAS TOOLS 16,476.67 37,249.80 20,773.13 126.08%

JARDINERIA PLANTS AND GARDENING SUPPLIES 16,145.00 28,000.00 11,855.00 73.43%

TRATAMIENTO Y ANALIS AGUA ANALISIS & TREATMEN OF WATER 16,738.15 27,246.45 10,508.30 62.78%

MANTO EQPO. DE OFICINA MAINTENANCE OFFICE EQUIP 6,404.70 8,400.00 1,995.30 31.15%

HERRERIA, ALUMINIO,VARIOS ALUMINUM, GLASS AND METAL 19,258.34 31,999.92 12,741.58 66.16%

CARPINTERIA CARPINTER SUPPLIES 26,900.45 15,000.00 -11,900.45 -44.24%

MATERIAL Y MANTO PLTA LUZ MAINTENANCE AUX. POWER PLANT 85 25,400.00 25,315.00 ########

RECOLECCION DE BASURA GARBAGE COLLECTION 122,470.00 150,000.00 27,530.00 22.48%

DECORACION DECORATION 51,561.05 43,720.00 -7,841.05 -15.21%

MANTO A CALDERAS MAINTENANCE BOILER 138,734.03 102,999.84 -35,734.19 -25.76%

MANTO SUBESTACIONES MAINTENANCE SUBESTAC 8,500.00 -8,500.00 -100.00%

MANTO CONMUTADOR MAINTENANCE COMMUTATOR 21,500.00 20,000.00 -1,500.00 -6.98%

SUB-TOTAL MANTENIMIENTO SUB TOTAL MAINTENANCE 2,887,912.13 2,589,796.23 -298,115.90 -10.32%

GENERALES

IVA ACREDITABLE SALES TAX 1,362,403.74 879,922.00 -482,481.74 -35.41%

GASTOS LEGALES LEGAL EXPENSES 623,786.59 393,500.00 -230,286.59 -36.92%

MULTAS Y RECARGOS INTEREST& PENALTIES ON TAXES 553,303.60 578,051.11 24,747.51 4.47%

TELEFONOS TELEPHONES 509,425.52 519,864.12 10,438.60 2.05%

HONORARIOS RETAINERS 267,734.64 237,200.00 -30,534.64 -11.40%

COMISIONES A TARJETAS CR. CREDIT CARD COMMISIONS 131,479.01 138,052.96 6,573.95 5.00%

COMITE ADMINISTRATIVO ADMINISTRATIVE COMMITTEE 68,541.46 189,644.91 121,103.45 176.69%

DEPRECIACIONES +AMORTIZ ALBERCA DEPRETATION 472,917.79 472,917.79 0 0.00%

PAPELERIA Y ART. P/ OFNAS PAPER SUPPLIES 260,218.37 273,229.29 13,010.92 5.00%

SEGUROS Y FIANZAS INSURANCE AND BONDS 3,383.90 18,800.75 15,416.85 455.59%

COMIS. BANC. BANK COMISIONS 112,539.91 112,539.91 0 0.00%

LICENCIAS IIMPUESTOS Y DERE LICENCE AND DUTIES 8,836.00 20,000.00 11,164.00 126.35%

AUDITORIA EXTERNA EXTERNAL AUDITORS 100,000.00 100,000.00 0 0.00%

GASTOS DE VIAJE Y REPRES. TRAVEL EXPENSES 48,696.98 100,000.00 51,303.02 105.35%

COMITE DE VIGILANCIA VIGILANCE COMMITTEE 178,431.32 212,687.75 34,256.43 19.20%

FLETES Y ACARREOS FREIGH & COURRIERS 2,761.94 6,000.00 3,238.06 117.24%

CORREOS Y TELEGRAFOS POSTAGE & TELEGRAPHS 34,594.60 45,750.00 11,155.40 32.25%

CORTESIA Y ATENCIONES TOWEL / LINE/ / OTHER SUPPLIES 112,877.71 68,400.00 -44,477.71 -39.40%

PERDIDAS Y DAÑOS LOSSES AND DAMAGES 99,405.24 100,000.00 594.76 0.60%

PASAJES LOCAL TRAVEL EXPENSES 40,988.31 40,988.31 0 0.00%

GASTOS MEDICOS MEDICAL EXPENSES 62,438.30 24,000.00 -38,438.30 -61.56%

ASAMBLEA DE CONDOMINOS ANNUAL MEETING EXPENSE 20,993.31 80,662.00 59,668.69 284.23%

PUBLICIDAD Y PROPAGANDA PUBLICITY AND ADVERTISING 10,320.00 10,000.00 -320 -3.10%

CUOTAS Y SUSCRIPCIONES MISC. FEES AND SUBRIPTIONS 4,984.38 5,200.00 215.62 4.33%

CUENTAS INCOBRABLES IRRECOVERABLE ACCOUNT 61,532.68 47,049.76 -14,482.92 -23.54%

PREDIAL PROPERTY TAX 4,746.77 -4,746.77 -100.00%

AGUA PURIFICADA DRINKING WATER 12,000.00 12,000.00 0.00%

SERVICIOS DE SEGURIDAD SECURITY SERVICE 633,105.33 921,409.40 288,304.07 45.54%

SUB TOTAL DE GASTOS GENERALES SUB TOTAL GENERAL EXPENSES 5,790,447.40 5,607,870.06 -182,577.34 -3.15%

OTRAS PARTIDAS

COMISION NACIONAL AGUA NATIONAL COMISSION W. 138,000.00 150,000.00 12,000.00 8.70%

ZONA FEDERAL MARITIMA TAX BEACH CONSETION 300,000.00 300,000.00 0.00%

SUB TOTAL DE OTRAS PARTIDAS SUB TOTAL OTHER EXPENSES 138,000.00 450,000.00 312,000.00 226.09%

TOTAL DE GASTOS GRAN TOTAL 22,488,596.52 23,834,104.02 1,345,507.50 5.98%

CONDOMINIO LAS TORRES GEMELAS
PRESUPUESTO DE OPERACION
EJERCICIO 2003

		A C U M U L A D O
		GASTO REAL	PRESUPUESTO	DIFERENCIA	%
SUELDOS Y PRESTACIONES		2002	2,003
SUELDO NOMINAL	BASE SALARY	3,824,651.20	4,373,955.49	549,304.29	14.36%
SEGURO SOCIAL	SOCIAL SEGURITY	799,706.88	968,919.53	169,212.65	21.16%
ALIMENTOS A EMPLEADOS	MEALS FOR EMPLOYEES	1,134,553.73	1,072,763.52	-61,790.21	-5.45%
VALES DE DESPENSA	FOOD COUPONS	408,975.00	569,964.83	160,989.83	39.36%
HORAS EXTRAS	OVERTIME WAGES	158,602.75	123,746.38	-34,856.37	-21.98%
5% INFONAVIT	5% HOUSING TAX	266,889.90	292,884.01	25,994.11	9.74%
AGUINALDOS	CRISTMAS BONUS	255,796.23	270,016.15	14,219.92	5.56%
IDEMNIZACIONES	SEVERANCE PAYMENT	256,924.99	260,702.06	3,777.07	1.47%
IMPUESTO ESTATAL	STATE PAYROLL TAX	149,692.35	158,865.28	9,172.93	6.13%
VACACIONES	VACATION PAYMENT	166,850.08	201,889.71	35,039.63	21.00%
DIAS FESTIVOS	DOYBLE TIME ON HOLIDAYS	92,155.30	90,381.36	-1,773.94	-1.92%
OTRAS PRESTACIONES	OTRAS BENEFITS	330,791.73	366,441.80	35,650.07	10.78%
S.A.R.	RETIREMENT FUND	107,913.16	116,767.67	8,854.51	8.21%
UNIFORMES Y ADIESTRAMIENTO	UNIFORMS	65,405.49	122,880.00	57,474.51	87.87%
PRESTACIONES A EJECUTIVOS	MANAGEMENT BENEFITS	123,386.29	173,732.80	50,346.51	40.80%
PRIMA DOMINICAL	SUNDAY BONUS	83,420.61	91,346.35	7,925.74	9.50%
RESERVA PARA PRIMA DE ANTIGUEDAD	RETIREMENT RESERVE	122,853.96	160,000.00	37,146.04	30.24%
PRIMA VACACIONAL	VACATION PREMIUM	60,526.68	74,459.80	13,933.12	23.02%
DIFERENCIAS DE INCAPACI.	SICK BENEFITS	33,608.52	36,108.00	2,499.48	7.44%
SINDICATO	UNION	430,267.80	156,319.92	-273,947.88	-63.67%
COMPENSACION A PRACTICAN.	PAYMENTS TO TEMPORARY HELP	12,630.00	14,400.00	1,770.00	14.01%
CREDITO AL SALARIO	CREDIT TO SALARY	138,373.36	144,541.48	6,168.12	4.46%
SUB-TOTAL SUELDOS Y P	SUB-TOTAL SALARIES AND BENEFITS	9,023,976.01	9,841,086.14	817,110.13	9.05%

ENERGETICOS
LUZ	LIGHT	2,462,361.15	2,856,796.88	394,435.73	16.02%
AGUA	WATER	1,879,603.21	2,091,089.51	211,486.30	11.25%
DIESEL	DIESEL	306,296.62	397,465.20	91,168.58	29.76%
SUB-TOTAL ENERGETICOS	SUB TOTAL ENERGETICS	4,648,260.98	5,345,351.59	697,090.61	15.00%

MANTENIMIENTO
MANTO ELEVADORES	MAINTENANCE ELEVATORS	274,572.72	282,757.00	8,184.28	2.98%
SUMINISTRO DE HABITACIONES	SUPPLIES FOR ROOMS	141,710.71	162,224.25	20,513.54	14.48%
MATERIAL ELECTRICO	ELECTRICALSUPPLIES	212,627.97	155,960.71	-56,667.26	-26.65%
MANTO AIRE ACONDICIONADO	MAINTENANCE AIRD COND.	26,673.86	60,505.00	33,831.14	126.83%
PINTURA	PAINT	343,720.81	253,401.35	-90,319.46	-26.28%
PLOMERIA	PLUMBING SUPPLIES	135,119.59	102,089.62	-33,029.97	-24.44%
MATERIAL PARA ALBERCA	POOL SUPPLIES	93,686.59	96,550.14	2,863.55	3.06%
MANTO SISTEMA DE COMPUTO	MAINTENANCE COMPUTERS	39,971.78	75,500.00	35,528.22	88.88%
SUMINISTRO SER AREAS PUBL	CLEANING SUPPLIES COMMON AR	257,694.66	247,128.00	-10,566.66	-4.10%
FUMIGACION	FUMIGATION	119,458.61	124,988.71	5,530.10	4.63%
MANTO EQUIPO DE TRANSPORT	MAINTENANCE VEHICLES	113,421.20	72,400.00	-41,021.20	-36.17%
MANTO EQUIPO HIDRAULICO	MAINTENANCE HIDRAULIC EQUIP	350,429.36	165,500.00	-184,929.36	-52.77%
MANTO. EQUIPO DE SERVICIO	MAINTENANCE SERVICE EQUIP	132,276.51	125,420.44	-6,856.07	-5.18%
TAPICERIA	UPHOLSTERY MATERIAL/LOUNGES	4,211.50	5,400.00	1,188.50	28.22%
ALBAÑILERIA	BUILDING SUPPLIES	103,811.55	104,385.00	573.45	0.55%
CERRAJERIA	LOCKSMITH & SULLPIES	93,751.32	65,570.00	-28,181.32	-30.06%
HERRAMIENTAS	TOOLS	16,476.67	37,249.80	20,773.13	126.08%
JARDINERIA	PLANTS AND GARDENING SUPPLIES	16,145.00	28,000.00	11,855.00	73.43%
TRATAMIENTO Y ANALIS AGUA	ANALISIS & TREATMEN OF WATER	16,738.15	27,246.45	10,508.30	62.78%
MANTO EQPO. DE OFICINA	MAINTENANCE OFFICE EQUIP	6,404.70	8,400.00	1,995.30	31.15%
HERRERIA, ALUMINIO,VARIOS	ALUMINUM, GLASS AND METAL	19,258.34	31,999.92	12,741.58	66.16%
CARPINTERIA	CARPINTER SUPPLIES	26,900.45	15,000.00	-11,900.45	-44.24%
MATERIAL Y MANTO PLTA LUZ	MAINTENANCE AUX. POWER PLANT	85	25,400.00	25,315.00	########
RECOLECCION DE BASURA	GARBAGE COLLECTION	122,470.00	150,000.00	27,530.00	22.48%
DECORACION	DECORATION	51,561.05	43,720.00	-7,841.05	-15.21%
MANTO A CALDERAS	MAINTENANCE BOILER	138,734.03	102,999.84	-35,734.19	-25.76%
MANTO SUBESTACIONES	MAINTENANCE SUBESTAC	8,500.00		-8,500.00	-100.00%
MANTO CONMUTADOR	MAINTENANCE COMMUTATOR	21,500.00	20,000.00	-1,500.00	-6.98%
SUB-TOTAL MANTENIMIENTO	SUB TOTAL MAINTENANCE	2,887,912.13	2,589,796.23	-298,115.90	-10.32%

GENERALES
IVA ACREDITABLE	SALES TAX	1,362,403.74	879,922.00	-482,481.74	-35.41%
GASTOS LEGALES	LEGAL EXPENSES	623,786.59	393,500.00	-230,286.59	-36.92%
MULTAS Y RECARGOS	INTEREST& PENALTIES ON TAXES	553,303.60	578,051.11	24,747.51	4.47%
TELEFONOS	TELEPHONES	509,425.52	519,864.12	10,438.60	2.05%
HONORARIOS	RETAINERS	267,734.64	237,200.00	-30,534.64	-11.40%
COMISIONES A TARJETAS CR.	CREDIT CARD COMMISIONS	131,479.01	138,052.96	6,573.95	5.00%
COMITE ADMINISTRATIVO	ADMINISTRATIVE COMMITTEE	68,541.46	189,644.91	121,103.45	176.69%
DEPRECIACIONES +AMORTIZ ALBERCA	DEPRETATION	472,917.79	472,917.79	0	0.00%
PAPELERIA Y ART. P/ OFNAS	PAPER SUPPLIES	260,218.37	273,229.29	13,010.92	5.00%
SEGUROS Y FIANZAS	INSURANCE AND BONDS	3,383.90	18,800.75	15,416.85	455.59%
COMIS. BANC.	BANK COMISIONS	112,539.91	112,539.91	0	0.00%
LICENCIAS IIMPUESTOS Y DERE	LICENCE AND DUTIES	8,836.00	20,000.00	11,164.00	126.35%
AUDITORIA EXTERNA	EXTERNAL AUDITORS	100,000.00	100,000.00	0	0.00%
GASTOS DE VIAJE Y REPRES.	TRAVEL EXPENSES	48,696.98	100,000.00	51,303.02	105.35%
COMITE DE VIGILANCIA	VIGILANCE COMMITTEE	178,431.32	212,687.75	34,256.43	19.20%
FLETES Y ACARREOS	FREIGH & COURRIERS	2,761.94	6,000.00	3,238.06	117.24%
CORREOS Y TELEGRAFOS	POSTAGE & TELEGRAPHS	34,594.60	45,750.00	11,155.40	32.25%
CORTESIA Y ATENCIONES	TOWEL / LINE/ / OTHER SUPPLIES	112,877.71	68,400.00	-44,477.71	-39.40%
PERDIDAS Y DAÑOS	LOSSES AND DAMAGES	99,405.24	100,000.00	594.76	0.60%
PASAJES	LOCAL TRAVEL EXPENSES	40,988.31	40,988.31	0	0.00%
GASTOS MEDICOS	MEDICAL EXPENSES	62,438.30	24,000.00	-38,438.30	-61.56%
ASAMBLEA DE CONDOMINOS	ANNUAL MEETING EXPENSE	20,993.31	80,662.00	59,668.69	284.23%
PUBLICIDAD Y PROPAGANDA	PUBLICITY AND ADVERTISING	10,320.00	10,000.00	-320	-3.10%
CUOTAS Y SUSCRIPCIONES	MISC. FEES AND SUBRIPTIONS	4,984.38	5,200.00	215.62	4.33%
CUENTAS INCOBRABLES	IRRECOVERABLE ACCOUNT	61,532.68	47,049.76	-14,482.92	-23.54%
PREDIAL	PROPERTY TAX	4,746.77		-4,746.77	-100.00%
AGUA PURIFICADA	DRINKING WATER		12,000.00	12,000.00	0.00%
SERVICIOS DE SEGURIDAD	SECURITY SERVICE	633,105.33	921,409.40	288,304.07	45.54%
SUB TOTAL DE GASTOS GENERALES	SUB TOTAL GENERAL EXPENSES	5,790,447.40	5,607,870.06	-182,577.34	-3.15%


OTRAS PARTIDAS
COMISION NACIONAL AGUA	NATIONAL COMISSION W.	138,000.00	150,000.00	12,000.00	8.70%
ZONA FEDERAL MARITIMA	TAX BEACH CONSETION		300,000.00	300,000.00	0.00%

SUB TOTAL DE OTRAS PARTIDAS	SUB TOTAL OTHER EXPENSES	138,000.00	450,000.00	312,000.00	226.09%


TOTAL DE GASTOS	GRAN TOTAL	22,488,596.52	23,834,104.02	1,345,507.50	5.98%