Estado de Resultados Por Centro de Costos 2003 (Base Flujo de Efectivo)

Profit and Loss Statment 2003 by Cost Center (Cashflow Basis)

 

CONDOMINIO LAS TORRES GEMELAS
Analsis Por centro de Costos (Base flujo de efectivo)
INGRESOS PRESUPUESTADOS			INGRESO		%		Centro de Costos
							Cuotas Diarias		Mantenimiento		Estacionamiento		Telefonos		Otros
646 Unidades por Cuota Promedio de $3,365.24	646 Units times Average Fee of $3,365.24
Cuotas de Mantenimiento	Maintenenca Fees		$13,043,676		40%				$13,043,676
Intereses	Interest		$320,606		1%				$320,606
69,479 Noches con Cuota Promedio de $105.04	69,479 Nights at Average Fee of $105.04		$7,302,729
15,922 Noches con Cuota Promedio de $105.05	15,922 Nights at Average Fee of $105.05		$1,673,402
Cuotas de Occupacion	Daily Fees		$8,976,250		27%		$8,976,250
Telefonos, Estacionamiento y Varios	Telephone, Parking and Others		$1,340,693		4%						$867,995		$453,740		$18,958
Concesión Alimentos y Bebidas	Food and Beverage Concesion		$263,162		1%										$263,162
TOTAL INGRESOS GLOBALES	TOTAL INCOME ALL SOURCES		$32,920,519		100%		$8,976,250		$13,364,282		$867,995		$453,740		$282,120
INGRESOS REALES			INGRESO		%		Centro de Costos
CUOTAS DE MANTENIMIENTO FIJAS	FIXED MAINTENENCE FEES						Cuotas Diarias		Mantenimiento		Estacionamiento		Telefonos		Otros
Año Actual (Mant., Fondo, TCO y Cuota 02)	Current Year		$10,673,378		50%				$10,673,378
Años Anteriores (Mant., Fondo, TCO y Cuota 02)	Previous Years		$1,567,712		7%				$1,567,712
Intereses			$184,533		1%				$184,533
TOTAL INGRESOS FIJOS	TOTAL FIXED INCOME		$12,425,623		58%		$0		$12,425,623		$0		$0		$0
OTROS INGRESOS VARIABLES	OTHER VARIABLE INCOME
Cuotas de Occupacion	Daily Fees		$7,595,085		35%		$7,595,085
Telefonos, Estacionamiento y Varios	Telephone, Parking and Others		$1,312,795		6%						$912,558		$332,226		$68,012
Concesión Alimentos y Bebidas	Food and Beverage Concesion		$154,685		1%										$154,685
TOTAL INGRESOS VARIABLES	TOTAL VARIABLE INCOME		$9,062,566		42%		$7,595,085		$0		$912,558		$332,226		$222,697
TOTAL INGRESOS GLOBALES	TOTAL INCOME ALL SOURCES		$21,488,188		100%		$7,595,085		$12,425,623		$912,558		$332,226		$222,697
DIFERENCIA DE INGRESOS CONTRA PRESPUESTO	DIFERENCE ACTUAL INCOME VS. BUDGET		-$11,432,330		-35%		-$1,381,165		-$938,659		$44,563		-$121,515		-$59,423
GASTOS			GASTO REAL		%		Cuotas Diarias		Mantenimiento		Estacionamiento		Telefonos		Otros
SUELDOS Y PRESTACIONES
SUELDO NOMINAL	BASE SALARY		$4,180,553		18%		$1,399,303		$2,648,166		$0		$133,083		$0
ALIMENTOS A EMPLEADOS	MEALS FOR EMPLOYEES		$1,162,802		5%		$389,210		$736,576		$0		$37,017		$0
SEGURO SOCIAL	SOCIAL SEGURITY		$906,309		4%		$303,357		$574,101		$0		$28,851		$0
SINDICATO	UNION		$441,320		2%		$147,717		$279,554		$0		$14,049		$0
OTRAS PRESTACIONES	OTRAS BENEFITS		$333,218		1%		$111,534		$211,077		$0		$10,608		$0
AGUINALDOS	CRISTMAS BONUS		$294,313		1%		$98,512		$186,433		$0		$9,369		$0
5% INFONAVIT	5% HOUSING TAX		$286,852		1%		$96,014		$181,706		$0		$9,132		$0
CREDITO AL SALARIO	SALARY CREDIT		$247,546		1%		$82,858		$156,807		$0		$7,880		$0
VACACIONES	VACATION PAYMENT		$245,010		1%		$82,009		$155,201		$0		$7,800		$0
VALES DE DESPENSA	MEALS CUPONS		$192,225		1%		$64,341		$121,765		$0		$6,119		$0
IMPUESTO ESTATAL	STATE PAYROLL TAX		$163,918		1%		$54,866		$103,834		$0		$5,218		$0
UNIFORMES	UNIFOMS		$125,740		1%		$42,087		$79,650		$0		$4,003		$0
PRESTACIONES A EJECUTIVOS	MANAGEMENT BENEFITS		$121,135		1%		$40,546		$76,733		$0		$3,856		$0
S.A.R.	RETIREMENT FUND		$116,547		1%		$39,010		$73,827		$0		$3,710		$0
DIAS FESTIVOS	DOYBLE TIME ON HOLIDAYS		$108,625		0%		$36,359		$68,808		$0		$3,458		$0
PRIMA DOMINICAL	SUNDAY BONUS		$92,203		0%		$30,862		$58,406		$0		$2,935		$0
HORAS EXTRAS	OVERTIME WAGES		$89,993		0%		$30,122		$57,006		$0		$2,865		$0
PRIMA VACACIONAL	VACATION PREMIUM		$87,622		0%		$29,328		$55,504		$0		$2,789		$0
DIFERENCIAS DE INCAPACI.	SICK BENEFITS		$31,832		0%		$10,655		$20,164		$0		$1,013		$0
COMPENSACION A PRACTICAN.	PAYMENTS TO TEMPORARY HELP		$5,360		0%		$1,794		$3,395		$0		$171		$0
SUB-TOTAL SUELDOS Y PRESTACIONES	SUB-TOTAL SALARIES AND BENEFITS		$9,233,124		40%		$3,090,486		$5,848,712		$0		$293,926		$0
ENERGETICOS
LUZ	LIGHT		$3,025,155		13%		$1,905,848		$1,119,307		$0		$0		$0
AGUA	WATER		$1,693,038		7%		$1,523,734		$169,304		$0		$0		$0
DIESEL	DIESEL		$435,321		2%		$391,789		$43,532		$0		$0		$0
SUB-TOTAL ENERGETICOS	SUB TOTAL  ENERGETICS		$5,153,513		22%		$3,821,370		$1,332,143		$0		$0		$0
MANTENIMIENTO
MANTO ELEVADORES	MAINTENENCE ELEVATORS		$388,061		2%				$388,061
SUMINISTROS DE HABITACIONES	SUPPLIES FOR ROOMS		$131,579		1%		$131,579
MATERIAL ELECTRICO	ELECTRICALSUPPLIES		$125,771		1%				$125,771
MANTO AIRE ACONDICIONADO	MAINTENANCE AIRD COND.		$17,421		0%				$17,421
PINTURA	PAINT		$195,259		1%				$195,259
PLOMERIA	PLUMBING SUPPLIES		$161,710		1%				$161,710
MATERIAL PARA ALBERCA	POOL SUPPLIES		$90,139		0%				$90,139
MANTO SISTEMA DE COMPUTO	MAINETENCE COMPUTERS		$17,324		0%				$17,324
SUMINISTROS AREAS PUBLICAS	CEANING SUPPLIES COMMON AR		$190,219		1%				$190,219
FUMIGACION	FUMIGATION		$126,810		1%		$126,810
MANTO EQUIPO DE TRANSPORT	MAINTENANCE VEHICLES		$99,240		0%				$99,240
MANTO EQUIPO HIDRAULICO	MAINTENENCE HIDRAULIC EQUIP		$130,823		1%				$130,823
MANTO. EQUIPO DE SERVICIO	MAINTENANCE SERVICE EQUIP		$203,072		1%				$203,072
TAPICERIA	UPHOLSTERY MATERIAL/LOUNGES		$620		0%				$620
ALBAÑILERIA	BUILDING SUPPLIES		$63,198		0%				$63,198
CERRAJERIA	LOCKSMITH & SULLPIES		$86,679		0%				$86,679
HERRAMIENTAS	TOOLS		$25,221		0%				$25,221
JARDINERIA	PLANTS AND GARDENING SUPPLIES		$910		0%				$910
TRATAMIENTO Y ANALIS AGUA	ANALISIS & TREATMEN OF WATER		$25,460		0%				$25,460
MANTO EQPO. DE OFICINA	MAINTENANCE OFFICE EQUIP		$2,748		0%				$2,748
HERRERIA, ALUMINIO,VARIOS	ALUMINUM, GLASS AND METAL		$2,349		0%				$2,349
CARPINTERIA	CARPINTER SUPPLIES		$22,652		0%				$22,652
MATERIAL Y MANTO PLTA LUZ	MAINTENANCE AUX. POWER PLANT		$10,110		0%				$10,110
RECOLECCION DE BASURA	GARBAGE COLLECTION		$140,874		1%		$140,874
DECORACION	DECORATION		$37,739		0%				$37,739
MANTO A CALDERAS	MAINTENANCE TO FURNACES		$33,120		0%				$33,120
MANTO SUBESTAC ELECTRI	MAINTENANCE TO TRANSFORMERS		$0		0%				$0
MANTO CONMUTADOR	MAINTENANCE TO TELEPHONE SISTEM		$17,953		0%								$17,953
SUB-TOTAL MANTENIMIENTO	SUB TOTAL MAINTENANCE		$2,347,063		10%		$399,263		$1,929,847		$0		$17,953		$0
GENERALES
IVA ACREDITABLE	SALES TAX		$1,630,921		7%		$710,114		$882,043				$38,764
GASTOS LEGALES	LEGAL EXPENSES		$760,176		3%				$760,176
TELEFONOS	TELEPHONES		$461,889		2%				$230,944				$230,944
HONORARIOS	RETAINERS		$238,595		1%				$238,595
COMISIONES A TARJETAS CR.	CREDIT CARD COMMISIONS		$82,161		0%		$82,161
COMITE ADMINISTRATIVO	ADMINISTRATIVE COMMITTEE		$86,955		0%				$86,955
PAPELERIA Y ART. P/ OFNAS	PAPER SUPPLIES		$254,947		1%				$254,947
SEGUROS Y FIANZAS	INSURANCE AND BONDS		$0		0%				$0
COMIS. BANC.	BANK COMISIONS		$118,021		1%				$118,021
LICENCIAS IMPTOS Y DERE.	TAXES AND LOCAL LICENCES		$13,176		0%				$13,176
AUDITORIA EXTERNA	EXTERNAL AUDITORS		$100,000		0%				$100,000
GASTOS DE VIAJE Y REPRES.	TRAVEL EXPENSES		$134,642		1%				$134,642
COMITE DE VIGILANCIA	VIGILANCE COMMITTEE		$93,779		0%				$93,779
FLETES Y ACARREOS	FREIGH & COURRIERS		$6,550		0%				$6,550
CORREOS Y TELEGRAFOS	POSTAGE & TELEGRAPHS		$41,114		0%				$41,114
CORTESIA Y ATENCIONES	TOWEL / LINE/ / OTHER SUPPLIES		$242,430		1%				$242,430
PERDIDAS Y DAÑOS	LOSSES AND DAMAGES		$51,482		0%				$51,482
PASAJES	LOCAL TRAVEL EXPENSES		$28,945		0%				$28,945
GASTOS MEDICOS	MEDICAL EXPENSES		$43,590		0%				$43,590
ASAMBLEA DE CONDOMINOS	ANNUAL MEETING EXPENSE		$53,313		0%				$53,313
PUBLICIDAD Y PROPAGANDA	PUBLICITY AND PUBLICATIONS		$7,158		0%				$7,158
CUOTAS Y SUSCRIPCIONES	MISC. FEES AND SUBRIPTIONS		$11,758		0%				$11,758
DONATIVOS	DONATIONS		$0		0%				$0
AGUA PURIFICADA	PURIFIED WATER		$8,098		0%				$8,098
PREDIAL	PROPERTY  TAX		$22,300		0%				$22,300
NO DEDUCIBLE	NON DEDUCTIBLES		$579,818		3%				$579,818
DEPARTAMENTO DE SEGURIDAD	SECURITY DEPARTMENT		$963,368		4%				$963,368
SEVICIOS ADMINISTRATIVO	ADMINISTRATIVE EXPENSES		$33,900		0%				$33,900
SUB TOTAL DE GASTOS GENERALES	SUB TOTAL GENERAL EXPENSES		$6,069,087		26%		$792,275		$5,007,102		$0		$269,709		$0
OTRAS PARTIDAS
COMISION NACIONAL AGUA	NATIONAL WATER COMISSION TAX		$112,990		0%				$112,990
ZONA FEDERAL MARITIMA	FEDERAL ZONE TAX		$0		0%
SUB TOTAL DE OTRAS PARTIDAS	SUB TOTAL OTHER EXPENSES		$112,990		0%		$0		$112,990		$0		$0		$0
TOTAL DE GASTOS	GRAN TOTAL		$22,915,777		100%		$8,103,394		$14,230,794		$0		$581,588		$0
RESULTADO NETO	NET RESULT		-$1,427,588				-$508,309		-$1,805,171		$912,558		-$249,363		$222,697
INGRESOS NO OPERATIVOS	NON OPERATING INCOME
VENTA TIEMPO COMPARTIDO	Sale of Apartments		$1,273,845		N/A		$508,309		$516,173		$0		$249,363		$0
RESULTADO DESPUES INGRESOS NO OP.	RESULTS AFTER NON OP. INCOME		-$153,743		N/A		$0		-$1,288,998		$912,558		$0		$222,697