Loading...
HomeMy WebLinkAboutHouston Moore BudgetHouston Moore (004) Budget Comparison Period = Apr 2024-Jun 2024 Book = Accrual 2999-99-999 3000-00-000 3100-00-000 3101-00-000 3111-00-000 3113-00-000 3119-00-000 3120-01-000 3120-04-000 3120-05-000 3120-07-000 3120-09-000 3121-00-000 3121-03-000 3129-00-000 3199-00-000 3400-00-000 3401-00-000 3422-00-000 3499-00-000 3600-00-000 3610-00-000 3611-00-000 3650-00-000 3699-00-000 3999-00-000 4000-00-000 4100-00-000 4100-99-000 4110-00-000 4110-01-000 4110-03-000 4110-04-000 4110-99-000 4130-00-000 4130-04-000 4131-00-000 4139-00-000 4140-00-000 4150-00-000 4171-00-000 4180-00-000 4189-00-000 4190-00-000 4190-03-000 4190-04-000 4190-06-000 4190-07-000 4190-08-000 4190-09-000 4190-10-000 4190-12-000 4190-13-000 4190-15-000 4190-16-000 4190-20-000 4190-22-000 4190-23-000 4190-30-000 4191-00-000 4195-01-000 4195-02-000 4195-03-000 4195-10-000 4199-00-000 4200-00-000 4230-01-000 4299-00-000 4300-00-000 4310-00-000 4320-00-000 4330-00-000 4390-00-000 4390-01-000 4399-00-000 4400-00-000 4400-99-000 4410-00-000 4410-02-000 4410-03-000 4410-04-000 4410-05-000 4419-00-000 4420-00-000 4420-01-000 4420-02-000 4420-03-000 4420-04-000 4420-06-000 4420-08-000 4420-09-000 4420-10-000 4420-13-000 4420-16-000 4420-22-000 4420-23-000 4420-99-000 4429-00-000 4430-00-000 4430-01-000 4430-02-000 4430-03-000 4430-04-000 4430-05-000 4430-06-000 4430-07-000 4430-08-000 4430-09-000 4430-10-000 4430-11-000 4430-12-000 4430-13-000 4430-15-000 4430-16-000 4430-17-000 4430-18-000 4430-19-000 4430-22-000 4430-24-000 4430-99-000 4439-00-000 4495-21-000 4495-22-000 4495-23-000 4495-24-000 4495-25-000 4495-26-000 4495-27-000 4495-28-000 4495-30-000 4499-00-000 4500-00-000 4510-00-000 4510-01-000 4510-02-000 4570-00-000 4570-01-000 4586-00-000 4590-00-000 4599-00-000 4600-99-000 4680-01-000 4680-02-000 4680-03-000 4699-00-000 4700-00-000 4715-03-000 4799-00-000 5000-00-000 5100-05-000 5100-06-000 5100-07-000 5100-08-000 5100-09-000 5100-10-000 5100-11-000 5999-00-000 8000-00-000 9000-00-000 Revenue & Expenses INCOME TENANT INCOME Rental Income Tenant Rent Less: Vacancies Total Rental Income Laundry and Vending Late Charges Legal Fees - Tenant Tenant Owed Utilities Misc.Tenant Income TPA RENT TPA MISC Total Other Tenant Income NET TENANT INCOME GRANT INCOME HUD PHA Operating Grants/Subsidy HUD Capital Fund Operations TOTAL GRANT INCOME OTHER INCOME Investment Income - Unrestricted Investment Income - Restricted Miscellaneous Other Income TOTAL OTHER INCOME TOTAL INCOME EXPENSES ADMINISTRATIVE Administrative Salaries Administrative Salaries Administrative Salaries Frt Line Comp Absences-Admin Employee Benefits-Admin Total Administrative Salaries Legal Expense General Legal Expense Total Legal Expense Other Admin Expenses Staff Training Travel Auditing Fees Office Rent Total Other Admin Expenses Miscellaneous Admin Expenses Advertising Office Supplies Computer Equipment Telephone Postage Software License Fees Copiers Software Internet Cell Phones/Pagers Court Papers and Fees Bank Fees Meetings Equipment Lease Other Misc Admin Expenses Total Miscellaneous Admin Expenses Management Fees Bookkeeping Fees Asset Management Fees IT Fee for Service TOTAL ADMINISTRATIVE EXPENSES TENANT SERVICES Tenant Participation TOTAL TENANT SERVICES EXPENSES UTILITIES Water Electricity Gas Sewer Stormwater TOTAL UTILITY EXPENSES MAINTENANCE AND OPERATIONS General Maint Expense Maintenance Salaries Maint-Overtime Comp Absences-Maint. Employee Benefits-Maint. Temporary Labor-Maint. Total General Maint Expense Materials Materials-Grounds Materials-Appliances Materials-Building Exterior Materials-Electrical Materials-Janitorial/Cleaning Materials-Plumbing Materials-Unit Interiors Occupied Materials-Unit Interiors Vacant Materials-HVAC Materials-Uniforms Materials-Remediation Materials-Tools Materials-Other Maintenance Total Materials Contract Costs Contract-Grounds Contract-Appliances Contract-Building Exterior Contract-Electrical Contract-Exterminating Contract-Janitorial/Cleaning Contract-Bed Bugs Contract-Plumbing Contract-Unit Interiors Occupied Contract-Unit Interiors Vacant Contract-Trash Removal Contract-Asbestos Contract-HVAC Contract-Fire and Burglary Contract-Uniforms Contract-Vehicle Expense Contract-Flooring Contract-Inspections Contract-Remediation Contract-Consultants Contract Costs-Other Maintenance Total Contract Costs Program Mgr Fee for Svc Painter Fee for Svc HVAC Fee for Svc Janitor Lawn Fee for Svc Plumber Fee for Svc Electrician Fee for Svc Dump Truck Fee for Svc Unit Turns Fee for Svc Pest Control Fee for Svc TOTAL MAINTENANCE EXPENSES GENERAL EXPENSES Property Insurance Liability Insurance Work Comp Insurance Bad Debt-Tenant Rents Bad Debt-Other Relocation Expense Other General Expense TOTAL GENERAL EXPENSES General Security Expense Protective Svcs - WPD Protective Svcs - ShotSpotter Contract Security Total Security Expenses HOUSING ASSISTANCE PAYMENTS FSS Escrow Payments TOTAL HOUSING ASSISTANCE PAYMENTS NON-OPERATING ITEMS Depreciation - Buildings Depreciation - Capital Leases Depreciation - Equip & Machinery Depreciation - Vehicles Depreciation - LI Exterior Depreciation - LI Interior Depreciation-CF Projects Improvemnts TOTAL NON-OPERATING ITEMS TOTAL EXPENSES NET INCOME PTD Actual 73956 -30960 42996 0 2030 0 0 1271.97 -2713 -680.97 -92 42904 277756 0 277756 3.43 9.63 0 13.06 320673.06 16783.06 1458.03 208.41 6553.06 25002.56 1118.31 1118.31 0 0 0 744 744 0 1078.04 0 501.47 10.06 0 0 9361.83 415.13 548.52 126 316 0 325.5 787.85 13470.4 11654 1440 4500 672 58601.27 0 0 22154.68 3837.13 9438.09 22652.88 2442.4 60525.18 9753.37 5793.6 0 5914.23 1699.33 23160.53 352.91 1601.79 0 2023.89 0 337.73 0 0 6231.35 0 0 0 1907.56 12455.23 5821.58 0 0 0 1700 0 0 0 0 0 5644.44 0 0 448.26 441.49 3575.67 0 0 0 432 0 18063.44 0 805 1190 2922.5 350 52.5 0 210 2257.5 61466.7 0 0 0 -1075 0 810.16 50 -214.84 5626.92 0 4095.88 9722.8 0 0 417.42 877.74 5503.83 2269.29 14448.54 2751.54 62734.32 89002.68 279103.79 41569.27 PTD Budget 85609.74 -5623.5 79986.24 512.49 2288.25 480.99 1184.49 2134.26 1644.99 0 8245.47 88231.71 373897.26 21174.99 395072.25 22.26 69.51 180 271.77 483575.73 17491.5 7066.26 570.66 10553.94 35682.36 654.99 654.99 360 200.01 1718.25 744 3022.26 72.99 385.74 80.01 1968.24 24.51 210 60 802.26 1235.25 1112.49 0 0 66.75 272.25 60 6350.49 17379.75 3105 4500 3550.26 74245.11 562.5 562.5 22812.24 41120.49 11687.49 19962.51 3391.74 98974.47 23124.99 2057.76 1112.49 11043.99 3649.5 40988.73 255 1214.25 684 196.26 296.25 695.49 761.76 600 3495 165 260.01 222.51 7230 16075.53 6462.51 2349.99 851.25 188.49 3463.26 360 804.99 11418.75 669.99 760.5 7437.51 615 2247.75 986.76 551.76 1569.99 51 71.25 1701.24 2445.99 3188.49 48196.47 3607.74 2775.24 4995.24 2220 0 4162.74 4162.74 2220 0 129404.43 11337 897.24 995.25 5623.74 157.5 4396.74 645.51 24052.98 8188.74 1275 0 9463.74 1056 1056 718.74 877.74 5799.99 2399.97 14448.51 2751.51 62734.26 89730.72 427489.95 56085.78 Variance -11653.74 -25336.5 -36990.24 -512.49 -258.25 -480.99 -1184.49 -862.29 -4357.99 -680.97 -8337.47 -45327.71 -96141.26 -21174.99 -117316.25 -18.83 -59.88 -180 -258.71 -162902.67 708.44 5608.23 362.25 4000.88 10679.8 -463.32 -463.32 360 200.01 1718.25 0 2278.26 72.99 -692.3 80.01 1466.77 14.45 210 60 -8559.57 820.12 563.97 -126 -316 66.75 -53.25 -727.85 -7119.91 5725.75 1665 0 2878.26 15643.84 562.5 562.5 657.56 37283.36 2249.4 -2690.37 949.34 38449.29 13371.62 -3735.84 1112.49 5129.76 1950.17 17828.2 -97.91 -387.54 684 -1827.63 296.25 357.76 761.76 600 -2736.35 165 260.01 222.51 5322.44 3620.3 640.93 2349.99 851.25 188.49 1763.26 360 804.99 11418.75 669.99 760.5 1793.07 615 2247.75 538.5 110.27 -2005.68 51 71.25 1701.24 2013.99 3188.49 30133.03 3607.74 1970.24 3805.24 -702.5 -350 4110.24 4162.74 2010 -2257.5 67937.73 11337 897.24 995.25 6698.74 157.5 3586.58 595.51 24267.82 2561.82 1275 -4095.88 -259.06 1056 1056 301.32 0 296.16 130.68 -0.03 -0.03 -0.06 728.04 148386.16 -14516.51 % Var -13.61 -450.55 -46.25 -100 -11.29 -100 -100 -40.4 -264.92 N/A -101.12 -51.37 -25.71 -100 -29.69 -84.59 -86.15 -100 -95.19 -33.69 4.05 79.37 63.48 37.91 29.93 -70.74 -70.74 100 100 100 0 75.38 100 -179.47 100 74.52 58.96 100 100 -1066.93 66.39 50.69 N/A N/A 100 -19.56 -1213.08 -112.12 32.94 53.62 0 81.07 21.07 100 100 2.88 90.67 19.25 -13.48 27.99 38.85 57.82 -181.55 100 46.45 53.44 43.5 -38.4 -31.92 100 -931.23 100 51.44 100 100 -78.29 100 100 100 73.62 22.52 9.92 100 100 100 50.91 100 100 100 100 100 24.11 100 100 54.57 19.99 -127.75 100 100 100 82.34 100 62.52 100 70.99 76.18 -31.64 N/A 98.74 100 90.54 N/A 52.5 100 100 100 119.12 100 81.57 92.25 100.89 31.28 100 N/A -2.74 100 100 41.92 0 5.11 5.45 0 0 0 0.81 34.71 -25.88 YTD Actual 73956 -30960 42996 0 2030 0 0 1271.97 -2713 -680.97 -92 42904 277756 0 277756 3.43 9.63 0 13.06 320673.06 16783.06 1458.03 208.41 6553.06 25002.56 1118.31 1118.31 0 0 0 744 744 0 1078.04 0 501.47 10.06 0 0 9361.83 415.13 548.52 126 316 0 325.5 787.85 13470.4 11654 1440 4500 672 58601.27 0 0 22154.68 3837.13 9438.09 22652.88 2442.4 60525.18 9753.37 5793.6 0 5914.23 1699.33 23160.53 352.91 1601.79 0 2023.89 0 337.73 0 0 6231.35 0 0 0 1907.56 12455.23 5821.58 0 0 0 1700 0 0 0 0 0 5644.44 0 0 448.26 441.49 3575.67 0 0 0 432 0 18063.44 0 805 1190 2922.5 350 52.5 0 210 2257.5 61466.7 0 0 0 -1075 0 810.16 50 -214.84 5626.92 0 4095.88 9722.8 0 0 417.42 877.74 5503.83 2269.29 14448.54 2751.54 62734.32 89002.68 279103.79 41569.27 YTD Budget 85609.74 -5623.5 79986.24 512.49 2288.25 480.99 1184.49 2134.26 1644.99 0 8245.47 88231.71 373897.26 21174.99 395072.25 22.26 69.51 180 271.77 483575.73 17491.5 7066.26 570.66 10553.94 35682.36 654.99 654.99 360 200.01 1718.25 744 3022.26 72.99 385.74 80.01 1968.24 24.51 210 60 802.26 1235.25 1112.49 0 0 66.75 272.25 60 6350.49 17379.75 3105 4500 3550.26 74245.11 562.5 562.5 22812.24 41120.49 11687.49 19962.51 3391.74 98974.47 23124.99 2057.76 1112.49 11043.99 3649.5 40988.73 255 1214.25 684 196.26 296.25 695.49 761.76 600 3495 165 260.01 222.51 7230 16075.53 6462.51 2349.99 851.25 188.49 3463.26 360 804.99 11418.75 669.99 760.5 7437.51 615 2247.75 986.76 551.76 1569.99 51 71.25 1701.24 2445.99 3188.49 48196.47 3607.74 2775.24 4995.24 2220 0 4162.74 4162.74 2220 0 129404.43 11337 897.24 995.25 5623.74 157.5 4396.74 645.51 24052.98 8188.74 1275 0 9463.74 1056 1056 718.74 877.74 5799.99 2399.97 14448.51 2751.51 62734.26 89730.72 427489.95 56085.78 Variance -11653.74 -25336.5 -36990.24 -512.49 -258.25 -480.99 -1184.49 -862.29 -4357.99 -680.97 -8337.47 -45327.71 -96141.26 -21174.99 -117316.25 -18.83 -59.88 -180 -258.71 -162902.67 708.44 5608.23 362.25 4000.88 10679.8 -463.32 -463.32 360 200.01 1718.25 0 2278.26 72.99 -692.3 80.01 1466.77 14.45 210 60 -8559.57 820.12 563.97 -126 -316 66.75 -53.25 -727.85 -7119.91 5725.75 1665 0 2878.26 15643.84 562.5 562.5 657.56 37283.36 2249.4 -2690.37 949.34 38449.29 13371.62 -3735.84 1112.49 5129.76 1950.17 17828.2 -97.91 -387.54 684 -1827.63 296.25 357.76 761.76 600 -2736.35 165 260.01 222.51 5322.44 3620.3 640.93 2349.99 851.25 188.49 1763.26 360 804.99 11418.75 669.99 760.5 1793.07 615 2247.75 538.5 110.27 -2005.68 51 71.25 1701.24 2013.99 3188.49 30133.03 3607.74 1970.24 3805.24 -702.5 -350 4110.24 4162.74 2010 -2257.5 67937.73 11337 897.24 995.25 6698.74 157.5 3586.58 595.51 24267.82 2561.82 1275 -4095.88 -259.06 1056 1056 301.32 0 296.16 130.68 -0.03 -0.03 -0.06 728.04 148386.16 -14516.51 % Var -13.61 -450.55 -46.25 -100 -11.29 -100 -100 -40.4 -264.92 N/A -101.12 -51.37 -25.71 -100 -29.69 -84.59 -86.15 -100 -95.19 -33.69 4.05 79.37 63.48 37.91 29.93 -70.74 -70.74 100 100 100 0 75.38 100 -179.47 100 74.52 58.96 100 100 -1066.93 66.39 50.69 N/A N/A 100 -19.56 -1213.08 -112.12 32.94 53.62 0 81.07 21.07 100 100 2.88 90.67 19.25 -13.48 27.99 38.85 57.82 -181.55 100 46.45 53.44 43.5 -38.4 -31.92 100 -931.23 100 51.44 100 100 -78.29 100 100 100 73.62 22.52 9.92 100 100 100 50.91 100 100 100 100 100 24.11 100 100 54.57 19.99 -127.75 100 100 100 82.34 100 62.52 100 70.99 76.18 -31.64 N/A 98.74 100 90.54 N/A 52.5 100 100 100 119.12 100 81.57 92.25 100.89 31.28 100 N/A -2.74 100 100 41.92 0 5.11 5.45 0 0 0 0.81 34.71 -25.88 Annual 342439 -22494 319945 2050 9153 1924 4738 8537 6580 0 32982 352927 1495589 84700 1580289 89 278 720 1087 1934303 69966 28265 2282.7 42215.75 142729.45 2620 2620 1440 800 6873 2976 12089 292 1543 320 7873 98 840 240 3209 4941 4450 0 0 267 1089 240 25402 69519 12420 18000 14201 296980.45 2250 2250 91249 164482 46750 79850 13567 395898 92500 8231 4450 44176.02 14598 163955.02 1020 4857 2736 785 1185 2782 3047 2400 13980 660 1040 890 28920 64302 25850 9400 3405 754 13853 1440 3220 45675 2680 3042 29750 2460 8991 3947 2207 6280 204 285 6805 9784 12754 192786 14431 11101 19981 8880 0 16651 16651 8880 0 517618.02 45348 3589 3981 22495 630 17587 2582 96212 32755 5100 0 37855 4224 4224 2875 3511 23200 9599.84 57794 11006 250937 358922.84 1709960.31 224342.69