Loading...
HomeMy WebLinkAboutMay 23 Fin 5South Bend Venues, Parks and Arts Recreation: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Charges for Services Culture & Recreation 347001 - Swimming Pool 1,943.35 2,391.35 30,000.00 27,608.65 7.97% 347002 - Picnic Site Rental 1,094.60 1,378.74 6,154.00 4,775.26 22.40% 347010 - Concession Sales 8,342.56 8,342.56 51,100.00 42,757.44 16.33% 347011 - Recreational Programming 52,572.50 242,645.46 333,561.00 90,915.54 72.74% 347016 - East Race Waterway 3,028.20 5,147.20 50,000.00 44,852.80 10.29% 347017 - Ice Skating 541.80 182,387.99 400,000.00 217,612.01 45.60% 347026 - Room Rental 2,999.50 23,099.12 30,000.00 6,900.88 77.00% 347030 - Merch Sales (381.03) 168.54 - (168.54) 0.00% 347040 - Pavilion Rental 6,493.04 14,786.53 33,710.00 18,923.47 43.86% Total Culture & Recreation 76,634.52 480,347.49 934,525.00 454,177.51 51.40% Total Charges for Services 76,634.52 480,347.49 934,525.00 454,177.51 51.40% Miscellaneous Revenue 362000 - Rental of Property 100.00 31,306.05 72,337.00 41,030.95 43.28% Total Miscellaneous Revenue 100.00 31,306.05 72,337.00 41,030.95 43.28% Refunds & Reimbursements 380000 - Misc Reimbursements - 3,748.94 - (3,748.94) 0.00% 396000 - Refunds - 300.00 - (300.00) 0.00% Total Refunds & Reimbursements - 4,048.94 - (4,048.94) 0.00% Total Revenue 76,734.52 515,702.48 1,006,862.00 491,159.52 51.22% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent of Account String Month Expenses Encumbrances w/ Encumb. Budget Budget Budget Personnel Expenses Salaries & Wages 410001 - Salaried Wages 42,283.52 201,865.79 - 201,865.79 586,850.00 384,984.21 34.40% 410002 - Teamster Wages 5,234.63 37,464.71 - 37,464.71 116,713.00 79,248.29 32.10% 410003 - Permanent Part Time 9,604.89 58,498.30 - 58,498.30 236,006.00 177,507.70 24.79% 410004 - Extra & Overtime 46.79 2,052.24 - 2,052.24 - (2,052.24) 0.00% 410005 - Seasonal & Interns 11,054.87 99,118.44 - 99,118.44 437,305.00 338,186.56 22.67% Total Salaries & Wages 68,224.70 398,999.48 - 398,999.48 1,376,874.00 977,874.52 28.98% Employee Benefits 411001 - FICA Regular 5,108.12 29,219.15 - 29,219.15 105,479.00 76,259.85 27.70% 411004 - PERF Regular 4,595.03 24,040.42 - 24,040.42 79,016.00 54,975.58 30.42% 411005 - PERF Union 48.89 274.05 - 274.05 - (274.05) 0.00% 411007 - Unemployment Comp 4.59 23.24 - 23.24 844.00 820.76 2.75% 411008 - Health Insurance 11,528.86 54,761.30 - 54,761.30 182,135.00 127,373.70 30.07% 411009 - Life Insurance 110.00 500.00 - 500.00 1,560.00 1,060.00 32.05% 411010 - Med/Surgical/Dental 143.36 672.10 - 672.10 - (672.10) 0.00% 411014 - Parental Leave 166.56 842.40 - 842.40 2,462.00 1,619.60 34.22% 411203 - Job Readiness Allow. - - - - 1,275.00 1,275.00 0.00% 411206 - Cell Phone Allowance 110.00 550.00 - 550.00 660.00 110.00 83.33% Total Employee Benefits 21,815.41 110,882.66 - 110,882.66 373,431.00 262,548.34 29.69% Total Personnel Expenses 90,040.11 509,882.14 - 509,882.14 1,750,305.00 1,240,422.86 29.13% Supplies Expenses Office Supplies 421000 - General Office Supplies 45.26 652.48 - 652.48 1,978.00 1,325.52 32.99% May 31, 2023 Total Office Supplies 45.26 652.48 - 652.48 1,978.00 1,325.52 32.99% Operating Supplies 422000 - Other Operating Supplies 420.48 6,287.98 389.59 6,677.57 49,131.57 42,454.00 13.59% 422005 - Uniforms 14.99 383.47 - 383.47 10,175.00 9,791.53 3.77% 422007 - Cleaning Supplies - - - - 2,520.00 2,520.00 0.00% 422008 - Medical/Safety Supplies - - - - 2,705.00 2,705.00 0.00% 422009 - Recreation Supplies 4,581.13 12,446.60 13,653.72 26,100.32 91,206.00 65,105.68 28.62% 422014 - Concessions Inventory 6,729.71 9,801.21 653.21 10,454.42 31,002.36 20,547.94 33.72% Total Operating Supplies 11,746.31 28,919.26 14,696.52 43,615.78 186,739.93 143,124.15 23.36% Total Supplies Expenses 11,791.57 29,571.74 14,696.52 44,268.26 188,717.93 144,449.67 23.46% Services & Charges Expenses Professional Services 431000 - Other Professional Services 17,950.50 37,136.01 41,083.00 78,219.01 99,580.75 21,361.74 78.55% Total Professional Services 17,950.50 37,136.01 41,083.00 78,219.01 99,580.75 21,361.74 78.55% Communication & Transportation 432003 - Travel - - 6,152.14 6,152.14 16,677.14 10,525.00 36.89% 432005 - Mileage Reimb 369.55 578.65 - 578.65 4,875.00 4,296.35 11.87% Total Communication & Transportation 369.55 578.65 6,152.14 6,730.79 21,552.14 14,821.35 31.23% Printing & Advertising 433001 - Outside Printing Services - - 1,446.75 1,446.75 3,000.00 1,553.25 48.23% 433003 - Promotional 9,379.25 20,771.37 2,400.00 23,171.37 49,298.00 26,126.63 47.00% Total Printing & Advertising 9,379.25 20,771.37 3,846.75 24,618.12 52,298.00 27,679.88 47.07% Repairs & Maintenance 436001 - Building R&M 2,500.00 9,175.00 - 9,175.00 9,175.00 - 100.00% Total Repairs & Maintenance 2,500.00 9,175.00 - 9,175.00 9,175.00 - 100.00% Rentals 437002 - Equipment Rental - 14.00 - 14.00 14.00 - 100.00% 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,260.00 60.00 95.24% Total Rentals - 13,214.00 - 13,214.00 13,274.00 60.00 99.55% Debt Service 438100 - Principal 64,045.13 120,890.76 - 120,890.76 182,147.00 61,256.24 66.37% 438200 - Interest 667.20 4,469.86 - 4,469.86 8,488.00 4,018.14 52.66% Total Debt Service 64,712.33 125,360.62 - 125,360.62 190,635.00 65,274.38 65.76% Other Charges & Services 439000 - Misc Charges & Svcs 17,958.81 31,281.51 9,013.49 40,295.00 95,161.98 54,866.98 42.34% 439001 - Other Contractual Services - 1,619.00 - 1,619.00 2,102.00 483.00 77.02% 439002 - Licenses & Permits - 4,161.01 - 4,161.01 6,516.00 2,354.99 63.86% 439004 - Dues & Memberships - 334.00 - 334.00 7,498.00 7,164.00 4.45% 439005 - Bank & Credit Card Fees 1,769.02 22,940.33 - 22,940.33 62,358.00 39,417.67 36.79% 439006 - Education & Training - 4,230.32 1,829.41 6,059.73 10,249.73 4,190.00 59.12% 439009 - Trash Removal - - - - 530.00 530.00 0.00% 439099 - Cashier Over/Short (20.09) (20.97) - (20.97) - 20.97 0.00% 439100 - Refunds/Awards/Indemnities - 2,675.39 - 2,675.39 35,280.00 32,604.61 7.58% 439300 - Grants & Subsidies - - - - 20,000.00 20,000.00 0.00% Total Other Services & Charges 19,707.74 67,220.59 10,842.90 78,063.49 239,695.71 161,632.22 32.57% Total Services & Charges Expenses 114,619.37 273,456.24 61,924.79 335,381.03 626,210.60 290,829.57 53.56% Other Uses 452002 - Allocations-Admin Cost - 39,709.00 - 39,709.00 119,127.00 79,418.00 33.33% 452003 - Allocations-IT - 69,041.68 - 69,041.68 207,125.00 138,083.32 33.33% Total Other Uses - 108,750.68 - 108,750.68 326,252.00 217,501.32 33.33% Total Expenses 216,451.05 921,660.80 76,621.31 998,282.11 2,891,485.53 1,893,203.42 34.52%