Loading...
HomeMy WebLinkAboutMay 22 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 42% Parks General Fund: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Taxes Property Taxes 311000 - Civil City Property Taxes --10,580,413.00 10,580,413.00 0.00% Total Property Taxes - - 10,580,413.00 10,580,413.00 0.00% Total Taxes - - 10,580,413.00 10,580,413.00 0.00% Total Intergovernmental Revenue - - 953,848.00 953,848.00 0.00% Licenses & Permits Nonbusiness Licenses & Permits 322050 - Park Food Sales Permit 26.25 130.00 -(130.00)0.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 224.00 224.00 57,000.00 56,776.00 0.39% 347002 - Picnic Site Rental 1,111.44 1,448.04 -(1,448.04)0.00% 347003 - Golf Season Pass 27,150.00 256,015.20 172,000.00 (84,015.20)148.85% 347004 - Golf Green Fees 96,614.85 146,871.85 805,000.00 658,128.15 18.24% 347005 - Golf Cart Rentals 47,263.72 67,789.19 365,000.00 297,210.81 18.57% 347006 - Golf Pro Shop Retail 7,994.51 16,152.90 59,500.00 43,347.10 27.15% 347007 - Golf Driving Range 4,965.00 9,464.00 30,000.00 20,536.00 31.55% 347008 - Golf Gift Certificate -35.00 -(35.00)0.00% 347009 - Golf Outings 583.13 2,623.13 -(2,623.13)0.00% 347010 - Concession Sales 6,913.55 9,325.70 69,000.00 59,674.30 13.52% 347011 - Recreational Programming 44,318.66 229,097.23 533,565.00 304,467.77 42.94% 347012 - Food Sales 8,261.26 12,745.13 53,277.00 40,531.87 23.92% 347013 - Nonalcoholic Beverage 4,367.82 6,506.32 31,500.00 24,993.68 20.65% 347014 - Alcoholic Beverage Sales 21,548.30 31,229.51 110,900.00 79,670.49 28.16% 347015 - Lease of Stadium 15,000.00 15,000.00 75,000.00 60,000.00 20.00% 347016 - East Race Waterway 979.50 1,148.55 60,000.00 58,851.45 1.91% 347017 - Ice Skating -197,057.38 300,000.00 102,942.62 65.69% 347019 - Site Mowing --222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 365.00 52,485.46 120,000.00 67,514.54 43.74% 347026 - Room Rental 10,901.03 65,714.44 56,000.00 (9,714.44)117.35% 347030 - Merch Sales 369.08 1,306.30 -(1,306.30)0.00% 347040 - Pavilion Rental 6,059.91 16,152.99 15,000.00 (1,152.99)107.69% 347100 - Concessions-Employee Discounts (299.42)(411.12)-411.12 0.00% Total Culture & Recreation 304,691.34 1,137,981.20 3,135,581.00 1,997,599.80 36.29% Total Charges for Services 304,691.34 1,137,981.20 3,135,581.00 1,997,599.80 36.29% Miscellaneous Revenue 360000 - Miscellaneous 146.23 5,673.78 9,500.00 3,826.22 59.72% 360001 - Sale of Scrap Metal 634.57 846.32 -(846.32)0.00% 361000 - Interest Earnings 581.14 7,132.43 50,000.00 42,867.57 14.26% 362000 - Rental of Property 5,145.75 27,008.75 60,000.00 32,991.25 45.01% 367000 - Donations from Private Sources -480,828.93 1,061,000.00 580,171.07 45.32% Total Miscellaneous Revenue 6,507.69 521,490.21 1,180,500.00 659,009.79 44.18% Refunds & Reimbursements 380000 - Misc Reimbursements -17,766.95 -(17,766.95)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 -43,275.67 -(43,275.67)0.00% Total Refunds & Reimbursements - 66,768.00 246,250.00 179,482.00 27.11% Other Sources 391000 - Interfund Transfers In 9,935.00 49,676.00 119,221.00 69,545.00 41.67% 393000 - Capital Lease Proceeds --1,290,000.00 1,290,000.00 0.00% Total Other Sources 9,935.00 49,676.00 1,409,221.00 1,359,545.00 3.53% Total Revenue 321,160.28 1,776,045.41 17,505,813.00 15,729,767.59 10.15% EXPENDITURES May 31, 2022 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 215,249.13 1,191,205.71 -1,191,205.71 3,049,049.00 1,857,843.29 39.07% 410002 - Teamster Wages 106,013.74 604,786.79 -604,786.79 1,552,175.00 947,388.21 38.96% 410003 - Permanent Part Time 90,144.67 282,534.51 -282,534.51 977,795.00 695,260.49 28.90% 410004 - Extra & Overtime 7,225.15 39,407.85 -39,407.85 82,850.00 43,442.15 47.57% 410005 - Seasonal & Interns 48,677.86 187,642.47 -187,642.47 834,951.00 647,308.53 22.47% 410007 - Longevity Pay 350.00 4,545.83 -4,545.83 8,050.00 3,504.17 56.47% 410014 - Contract Add Pays (604.92)-----0.00% 410017 - Stand By Pay 953.36 953.36 -953.36 3,500.00 2,546.64 27.24% 410022 - Park Board Stipend ----1,200.00 1,200.00 0.00% Total Salaries & Wages 468,008.99 2,311,076.52 - 2,311,076.52 6,509,570.00 4,198,493.48 35.50% Employee Benefits 411001 - FICA Regular 34,554.33 185,383.99 -185,383.99 501,390.00 316,006.01 36.97% 411004 - PERF Regular 35,631.90 214,781.19 -214,781.19 530,630.00 315,848.81 40.48% 411005 - PERF Union 1,278.35 8,285.96 -8,285.96 26,912.00 18,626.04 30.79% 411007 - Unemployment Comp 549.76 2,774.17 -2,774.17 7,520.00 4,745.83 36.89% 411008 - Health Insurance 86,473.78 429,683.14 -429,683.14 1,192,876.00 763,192.86 36.02% 411009 - Life Insurance 820.00 4,080.00 -4,080.00 10,560.00 6,480.00 38.64% 411014 - Parental Leave 1,148.68 6,434.55 -6,434.55 16,447.00 10,012.45 39.12% 411015 - Other Fringe Benefits -1,490.00 -1,490.00 1,500.00 10.00 99.33% 411201 - Tool Allowance -2,923.62 -2,923.62 4,800.00 1,876.38 60.91% 411203 - Job Readiness Allow.-14,875.00 -14,875.00 19,425.00 4,550.00 76.58% 411204 - Auto Allowance 266.66 1,333.30 -1,333.30 3,200.00 1,866.70 41.67% 411206 - Cell Phone Allowance 1,045.00 5,280.00 -5,280.00 11,820.00 6,540.00 44.67% Total Employee Benefits 161,768.46 877,324.92 - 877,324.92 2,327,080.00 1,449,755.08 37.70% Total Personnel Expenses 629,777.45 3,188,401.44 - 3,188,401.44 8,836,650.00 5,648,248.56 36.08% Supplies Expenses Office Supplies 421000 - General Office Supplies 681.61 6,357.65 495.68 6,853.33 23,829.18 16,975.85 28.76% Total Office Supplies 681.61 6,357.65 495.68 6,853.33 23,829.18 16,975.85 28.76% Operating Supplies 422000 - Other Operating Supplies 34,795.69 113,641.09 56,575.49 170,216.58 289,304.02 119,087.44 58.84% 422001 - C.S. Gasoline 23,980.64 86,171.47 -86,171.47 165,000.00 78,828.53 52.23% 422002 - Diesel/CNG 1,886.00 1,886.00 -1,886.00 4,000.00 2,114.00 47.15% 422003 - Gasoline 7,657.61 10,462.61 681.50 11,144.11 26,405.00 15,260.89 42.20% 422004 - Oil -35.30 -35.30 50.00 14.70 70.60% 422005 - Uniforms 196.00 2,978.30 -2,978.30 17,000.00 14,021.70 17.52% 422006 - Computer Supplies & Equipment -319.93 -319.93 500.00 180.07 63.99% 422007 - Cleaning Supplies 69.88 85.13 -85.13 2,450.00 2,364.87 3.47% 422008 - Medical/Safety Supplies 4,970.17 9,781.91 -9,781.91 15,556.00 5,774.09 62.88% 422009 - Recreation Supplies 10,847.57 46,269.73 29,841.55 76,111.28 246,701.60 170,590.32 30.85% 422010 - Plants Chemicals Seed & Fertilizer 31,708.36 109,822.33 35,836.55 145,658.88 180,775.00 35,116.12 80.57% 422014 - Concessions Inventory 4,854.96 26,444.54 5,559.86 32,004.40 79,050.00 47,045.60 40.49% 422016 - Inventory For Sale 1,079.80 30,008.84 2,569.00 32,577.84 36,535.00 3,957.16 89.17% Total Operating Supplies 122,046.68 437,907.18 131,063.95 568,971.13 1,063,326.62 494,355.49 53.51% Repair & Maintenance Supplies 423000 - Other R&M Supplies 29,938.00 108,739.73 57,175.94 165,915.67 276,765.04 110,849.37 59.95% 423001 - Building Materials 1,729.28 27,430.40 748.00 28,178.40 90,000.00 61,821.60 31.31% 423006 - Small Tools & Equipment 2,087.93 9,576.47 31.53 9,608.00 25,573.00 15,965.00 37.57% 423009 - Repair Parts 3,872.72 30,070.68 378.50 30,449.18 83,829.03 53,379.85 36.32% Total Repair & Maintenance Supplies 37,627.93 175,817.28 58,333.97 234,151.25 476,167.07 242,015.82 49.17% Total Supplies Expenses 160,356.22 620,082.11 189,893.60 809,975.71 1,563,322.87 753,347.16 51.81% Services & Charges Expenses Professional Services 431000 - Other Professional Services 10,939.67 46,195.91 9,688.00 55,883.91 103,677.00 47,793.09 53.90% 431009 - Computer & Technology -31.83 -31.83 500.00 468.17 6.37% 431014 - Collection Costs -12.50 11.25 23.75 50.00 26.25 47.50% 431019 - Security Services 481.44 17,373.05 -17,373.05 17,818.00 444.95 97.50% Total Professional Services 11,421.11 63,613.29 9,699.25 73,312.54 122,045.00 48,732.46 60.07% Communication & Transportation 432002 - Mailing 293.56 356.46 -356.46 4,875.00 4,518.54 7.31% 432003 - Travel 257.79 2,552.15 3,669.15 6,221.30 29,550.00 23,328.70 21.05% 432004 - Telecommunications -1,126.46 3,513.80 4,640.26 10,003.80 5,363.54 46.38% 432005 - Mileage Reimb --176.96 176.96 6,205.00 6,028.04 2.85% Total Communication & Transportation 551.35 4,035.07 7,359.91 11,394.98 50,633.80 39,238.82 22.50% Printing & Advertising 433001 - Outside Printing Services 1,934.75 6,443.25 1,080.00 7,523.25 30,280.00 22,756.75 24.85% 433002 - Publication of Legal Notice -495.60 704.40 1,200.00 2,000.00 800.00 60.00% 433003 - Promotional 33,068.56 132,982.59 121,360.50 254,343.09 244,034.06 (10,309.03)104.22% Total Printing & Advertising 35,003.31 139,921.44 123,144.90 263,066.34 276,314.06 13,247.72 95.21% Utilties 435001 - Electric 37,198.81 207,015.38 -207,015.38 452,847.00 245,831.62 45.71% 435002 - Natural Gas 14,963.97 131,537.56 -131,537.56 113,457.00 (18,080.56)115.94% 435004 - Water 20,685.46 45,048.51 -45,048.51 214,000.00 168,951.49 21.05% Total Utilities 72,848.24 383,601.45 - 383,601.45 780,304.00 396,702.55 49.16% Repairs & Maintenance 436000 - Other R&M 1,476.66 11,258.53 8,766.97 20,025.50 95,600.53 75,575.03 20.95% 436001 - Building R&M 26,727.72 82,376.61 92,462.00 174,838.61 206,994.82 32,156.21 84.47% 436003 - Auto Equip R&M 25,549.58 148,792.50 -148,792.50 299,500.00 150,707.50 49.68% 436005 - Other Equip R&M 784.97 1,309.67 -1,309.67 6,800.00 5,490.33 19.26% 436006 - Radio Equip R&M 388.50 3,422.09 -3,422.09 3,500.00 77.91 97.77% 436011 - Exterminating 648.00 3,416.00 746.00 4,162.00 8,334.00 4,172.00 49.94% Total Repairs & Maintenance 55,575.43 250,575.40 101,974.97 352,550.37 620,729.35 268,178.98 56.80% Rentals 437005 - Parking Space Rental -12,000.00 -12,000.00 12,000.00 -100.00% 437006 - Recreation Space Rental -1,200.00 -1,200.00 1,200.00 -100.00% Total Rentals - 13,200.00 - 13,200.00 13,200.00 - 100.00% Debt Service 438100 - Principal 129,769.03 183,746.16 -183,746.16 291,946.00 108,199.84 62.94% 438200 - Interest 7,759.72 14,430.88 -14,430.88 29,076.00 14,645.12 49.63% 438300 - Paying Agent Fees -4,400.00 -4,400.00 5,000.00 600.00 88.00% Total Debt Service 137,528.75 202,577.04 - 202,577.04 326,022.00 123,444.96 62.14% Other Charges & Services 439000 - Misc Charges & Svcs 80,813.97 171,585.95 356,957.36 528,543.31 730,777.29 202,233.98 72.33% 439001 - Other Contractual Services -649.99 -649.99 5,800.00 5,150.01 11.21% 439002 - Licenses & Permits 49.47 9,780.51 -9,780.51 12,025.00 2,244.49 81.33% 439003 - Subscriptions 5.02 1,390.72 -1,390.72 3,720.00 2,329.28 37.38% 439004 - Dues & Memberships 64.99 2,043.01 -2,043.01 18,810.00 16,766.99 10.86% 439005 - Bank & Credit Card Fees 7,069.95 37,287.35 -37,287.35 69,335.00 32,047.65 53.78% 439006 - Education & Training 1,295.17 9,740.94 2,554.00 12,294.94 23,625.00 11,330.06 52.04% 439009 - Trash Removal 8,747.60 25,320.95 13,802.02 39,122.97 44,934.41 5,811.44 87.07% 439012 - Uniform Services 1,618.00 7,220.30 -7,220.30 8,200.00 979.70 88.05% 439018 - Demolition & Clearance --18,000.00 18,000.00 18,000.00 -100.00% 439099 - Cashier Over/Short 389.17 1,808.96 -1,808.96 2,300.00 491.04 78.65% 439100 - Refunds/Awards/Indemnities 3,637.73 12,051.95 -12,051.95 30,585.00 18,533.05 39.40% 439300 - Grants & Subsidies 350,000.00 715,000.00 -715,000.00 715,000.00 -100.00% Total Other Services & Charges 453,691.07 993,880.63 391,313.38 1,385,194.01 1,683,111.70 297,917.69 82.30% Total Services & Charges Expenses 766,619.26 2,051,404.32 633,492.41 2,684,896.73 3,872,359.91 1,187,463.18 69.33% Capital Outlay Buildings 443001 - Building Improvements 4,548.75 4,548.75 97,901.25 102,450.00 102,450.00 -100.00% Total Buildings 4,548.75 4,548.75 97,901.25 102,450.00 102,450.00 - 100.00% 444000 - Land Improvements 29,825.00 207,819.88 240,792.82 448,612.70 1,294,470.49 845,857.79 34.66% Machinery & Equipment 445000 - Motor Equipment -10,866.95 -10,866.95 10,866.86 (0.09)100.00% 445003 - Park Equipment --108,002.34 108,002.34 686,027.50 578,025.16 15.74% 445006 - Computer Equip/Network --17,009.17 17,009.17 -(17,009.17)0.00% 445100 - Lease Purchase/Motor Equip --191,646.00 191,646.00 269,000.00 77,354.00 71.24% Total Machinery & Equipment - 10,866.95 316,657.51 327,524.46 965,894.36 638,369.90 33.91% Total Capital Expenses 34,373.75 223,235.58 655,351.58 878,587.16 2,362,814.85 1,484,227.69 37.18% Other Uses 452002 - Allocations-Admin Cost 61,510.58 307,552.94 -307,552.94 738,127.00 430,574.06 41.67% 452003 - Allocations-IT 57,450.84 287,254.12 -287,254.12 689,410.00 402,155.88 41.67% 452004 - Allocations-Liability Insurance 24,384.42 121,922.06 -121,922.06 292,613.00 170,690.94 41.67% 452008 - Allocations-Payroll Cost 6,895.25 34,476.25 -34,476.25 82,743.00 48,266.75 41.67% 452009 - Allocations-Facilities Mgmt 2,296.25 11,481.25 -11,481.25 27,555.00 16,073.75 41.67% Total Other Uses 152,537.34 762,686.62 - 762,686.62 1,830,448.00 1,067,761.38 41.67% Total Expenses 1,743,664.02 6,845,810.07 1,478,737.59 8,324,547.66 18,465,595.63 10,141,047.97 45.08%