Loading...
HomeMy WebLinkAboutJuly 22 Fin 3South Bend Venues, Parks and Arts Parks Maintenance: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Charges for Services Culture & Recreation 347015 - Lease of Stadium 15,000.00 45,000.00 75,000.00 30,000.00 60.00% 347019 - Site Mowing - - 222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 32,133.04 114,266.38 120,000.00 5,733.62 95.22% Total Culture & Recreation 47,133.04 159,266.38 417,839.00 258,572.62 38.12% Total Charges for Services 47,133.04 159,266.38 417,839.00 258,572.62 38.12% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal - 846.32 - (846.32) 0.00% 367000 - Donations from Private Sources - 7,867.50 - (7,867.50) 0.00% Total Miscellaneous Revenue - 8,713.82 2,000.00 (6,713.82) 435.69% Refunds & Reimbursements 380000 - Misc Reimbursements 34.43 157.49 - (157.49) 0.00% 380007 - Energy Rebates - 808.98 809.00 0.02 100.00% 381000 - Misc Reimbursements - 4,916.40 245,441.00 240,524.60 2.00% 396000 - Refunds - 37,603.17 37,603.00 (0.17) 100.00% Total Refunds & Reimbursements 34.43 43,486.04 283,853.00 240,366.96 15.32% Other Sources 393000 - Capital Lease Proceeds - 1,290,000.00 1,290,000.00 - 100.00% Total Other Sources - 1,290,000.00 1,290,000.00 - 100.00% Total Revenue 47,167.47 1,501,466.24 1,993,692.00 492,225.76 75.31% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 60,590.44 451,697.56 - 451,697.56 820,100.00 368,402.44 55.08% 410002 - Teamster Wages 96,190.81 687,720.90 - 687,720.90 1,271,200.00 583,479.10 54.10% 410003 - Permanent Part Time 33,347.01 166,422.41 - 166,422.41 255,000.00 88,577.59 65.26% 410004 - Extra & Overtime 11,270.29 60,145.44 - 60,145.44 66,300.00 6,154.56 90.72% 410005 - Seasonal & Interns 45,502.00 173,895.48 - 173,895.48 300,000.00 126,104.52 57.97% 410007 - Longevity Pay 200.00 4,495.83 - 4,495.83 7,450.00 2,954.17 60.35% 410014 - Contract Add Pays - - - - - - 0.00% 410017 - Stand By Pay 385.64 1,675.12 - 1,675.12 3,500.00 1,824.88 47.86% Total Salaries & Wages 247,486.19 1,546,052.74 - 1,546,052.74 2,723,550.00 1,177,497.26 56.77% Employee Benefits 411001 - FICA Regular 18,282.17 123,046.57 - 123,046.57 210,409.00 87,362.43 58.48% 411004 - PERF Regular 18,076.40 138,309.19 - 138,309.19 245,889.00 107,579.81 56.25% 411005 - PERF Union 1,112.28 9,374.63 - 9,374.63 20,541.00 11,166.37 45.64% 411007 - Unemployment Comp 291.36 1,917.86 - 1,917.86 3,472.00 1,554.14 55.24% 411008 - Health Insurance 44,046.56 304,236.22 - 304,236.22 582,882.00 278,645.78 52.20% 411009 - Life Insurance 410.00 2,850.00 - 2,850.00 5,160.00 2,310.00 55.23% 411014 - Parental Leave 583.34 4,197.06 - 4,197.06 7,594.00 3,396.94 55.27% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance - 2,923.62 - 2,923.62 4,000.00 1,076.38 73.09% 411203 - Job Readiness Allow. - 12,325.00 - 12,325.00 15,750.00 3,425.00 78.25% 411206 - Cell Phone Allowance 440.00 3,080.00 - 3,080.00 5,940.00 2,860.00 51.85% Total Employee Benefits 83,242.11 603,460.15 - 603,460.15 1,102,837.00 499,376.85 54.72% July 31, 2022 Total Personnel Expenses 330,728.30 2,149,512.89 - 2,149,512.89 3,826,387.00 1,676,874.11 56.18% Supplies Expenses Office Supplies 421000 - General Office Supplies 638.50 2,786.10 - 2,786.10 5,000.00 2,213.90 55.72% Total Office Supplies 638.50 2,786.10 - 2,786.10 5,000.00 2,213.90 55.72% Operating Supplies 422000 - Other Operating Supplies 24,912.33 121,380.23 33,645.69 155,025.92 162,081.45 7,055.53 95.65% 422001 - C.S. Gasoline 32,084.94 140,515.45 - 140,515.45 165,000.00 24,484.55 85.16% 422003 - Gasoline - - 50.00 50.00 2,405.00 2,355.00 2.08% 422004 - Oil - 35.30 - 35.30 50.00 14.70 70.60% 422005 - Uniforms - - 1,218.25 1,218.25 3,000.00 1,781.75 40.61% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 500.00 180.07 63.99% 422007 - Cleaning Supplies 132.84 1,645.29 - 1,645.29 2,550.00 904.71 64.52% 422008 - Medical/Safety Supplies 602.48 11,709.45 - 11,709.45 12,480.00 770.55 93.83% 422010 - Plants Chemicals Seed & Fertilizer 544.75 44,174.06 4,879.54 49,053.60 68,975.00 19,921.40 71.12% Total Operating Supplies 58,277.34 319,779.71 39,793.48 359,573.19 417,041.45 57,468.26 86.22% Repair & Maintenance Supplies 423000 - Other R&M Supplies 29,545.27 130,202.42 21,492.96 151,695.38 217,674.41 65,979.03 69.69% 423001 - Building Materials 8,576.22 45,300.73 8,835.10 54,135.83 90,000.00 35,864.17 60.15% 423006 - Small Tools & Equipment 3,686.39 14,503.35 - 14,503.35 25,573.00 11,069.65 56.71% 423009 - Repair Parts 2,974.65 36,113.70 2,515.00 38,628.70 79,729.03 41,100.33 48.45% Total Repair & Maintenance Supplies 44,782.53 226,120.20 32,843.06 258,963.26 412,976.44 154,013.18 62.71% Total Supplies Expenses 103,698.37 548,686.01 72,636.54 621,322.55 835,017.89 213,695.34 74.41% Services & Charges Expenses Professional Services 431000 - Other Professional Services 3,157.00 5,288.00 38,099.00 43,387.00 50,000.00 6,613.00 86.77% 431009 - Computer & Technology - 31.83 - 31.83 500.00 468.17 6.37% 431014 - Collection Costs - 23.75 11.25 35.00 50.00 15.00 70.00% 431019 - Security Services 5,520.00 21,077.60 10,362.00 31,439.60 31,640.00 200.40 99.37% Total Professional Services 8,677.00 26,421.18 48,472.25 74,893.43 82,190.00 7,296.57 91.12% Communication & Transportation 432003 - Travel - 2,184.09 2,517.36 4,701.45 6,400.00 1,698.55 73.46% 432004 - Telecommunications 263.16 1,108.00 2,597.41 3,705.41 7,997.41 4,292.00 46.33% Total Communication & Transportation 263.16 3,292.09 5,114.77 8,406.86 14,397.41 5,990.55 58.39% Printing & Advertising 433001 - Outside Printing Services - 500.00 - 500.00 2,000.00 1,500.00 25.00% 433002 - Publication of Legal Notice - 495.60 894.10 1,389.70 2,000.00 610.30 69.49% Total Printing & Advertising - 995.60 894.10 1,889.70 4,000.00 2,110.30 47.24% Utilties 435001 - Electric 39,816.86 266,848.63 - 266,848.63 403,180.00 136,331.37 66.19% 435002 - Natural Gas 5,906.58 126,907.57 - 126,907.57 90,938.00 (35,969.57) 139.55% 435004 - Water 48,371.19 133,354.96 - 133,354.96 214,000.00 80,645.04 62.32% Total Utilities 94,094.63 527,111.16 - 527,111.16 708,118.00 181,006.84 74.44% Repairs & Maintenance 436000 - Other R&M 3,822.33 15,712.82 14,429.60 30,142.42 69,528.99 39,386.57 43.35% 436001 - Building R&M 7,854.78 146,260.00 28,071.88 174,331.88 206,994.82 32,662.94 84.22% 436003 - Auto Equip R&M 23,484.33 188,286.03 - 188,286.03 297,000.00 108,713.97 63.40% 436005 - Other Equip R&M - 784.97 108.00 892.97 5,800.00 4,907.03 15.40% 436006 - Radio Equip R&M 2,316.15 8,583.59 - 8,583.59 3,500.00 (5,083.59) 245.25% 436011 - Exterminating - 3,416.00 746.00 4,162.00 8,334.00 4,172.00 49.94% Total Repairs & Maintenance 37,477.59 363,043.41 43,355.48 406,398.89 591,157.81 184,758.92 68.75% Rentals 437002 - Equipment Rental 560.00 560.00 - 560.00 - (560.00) 0.00% Total Rentals 560.00 560.00 - 560.00 - (560.00) 0.00% Debt Service 438100 - Principal 133,096.72 133,096.72 - 133,096.72 144,454.62 11,357.90 92.14% 438200 - Interest 3,114.38 3,114.38 - 3,114.38 3,114.38 - 100.00% Total Debt Service 136,211.10 136,211.10 - 136,211.10 147,569.00 11,357.90 92.30% Other Charges & Services 439000 - Misc Charges & Svcs 123,658.65 294,042.85 140,295.93 434,338.78 538,139.50 103,800.72 80.71% 439001 - Other Contractual Services 1,960.00 2,200.00 3,500.00 5,700.00 6,000.00 300.00 95.00% 439002 - Licenses & Permits 184.36 1,334.36 - 1,334.36 1,150.00 (184.36) 116.03% 439003 - Subscriptions 627.00 1,068.94 - 1,068.94 1,220.00 151.06 87.62% 439004 - Dues & Memberships 270.00 390.00 - 390.00 2,375.00 1,985.00 16.42% 439006 - Education & Training 560.00 7,502.17 1,879.00 9,381.17 11,000.00 1,618.83 85.28% 439009 - Trash Removal 5,608.91 22,035.40 8,200.66 30,236.06 33,920.75 3,684.69 89.14% 439012 - Uniform Services 1,970.27 9,190.57 - 9,190.57 8,200.00 (990.57) 112.08% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 134,839.19 352,764.29 153,875.59 506,639.88 617,005.25 110,365.37 82.11% Total Services & Charges Expenses 412,122.67 1,410,398.83 251,712.19 1,662,111.02 2,164,437.47 502,326.45 76.79% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment - 7,062.50 123,465.00 130,527.50 386,027.50 255,500.00 33.81% 445100 - Lease Purchase/Motor Equip - - 513,394.53 513,394.53 1,290,000.00 776,605.47 39.80% Total Machinery & Equipment - 17,929.45 636,859.53 654,788.98 1,686,894.36 1,032,105.38 38.82% Total Capital Expenses - 17,929.45 636,859.53 654,788.98 1,686,894.36 1,032,105.38 38.82% Other Uses 452002 - Allocations-Admin Cost 31,642.25 221,495.75 - 221,495.75 379,707.00 158,211.25 58.33% 452003 - Allocations-IT 12,805.67 89,639.65 - 89,639.65 153,668.00 64,028.35 58.33% 452004 - Allocations-Liability Insurance 11,013.08 77,091.60 - 77,091.60 132,157.00 55,065.40 58.33% 452009 - Allocations-Facilities Mgmt 2,001.00 14,007.00 - 14,007.00 24,012.00 10,005.00 58.33% Total Other Uses 57,462.00 402,234.00 - 402,234.00 689,544.00 287,310.00 58.33% Total Expenses 904,011.34 4,528,761.18 961,208.26 5,489,969.44 9,202,280.72 3,712,311.28 59.66%