Loading...
HomeMy WebLinkAboutMay 22 Fin 5South Bend Venues, Parks and Arts Recreation: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected 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% 347010 - Concession Sales 6,913.55 7,411.68 59,000.00 51,588.32 12.56% 347011 - Recreational Programming 40,152.56 221,360.38 470,565.00 249,204.62 47.04% 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% 347026 - Room Rental 2,908.60 28,960.35 26,000.00 (2,960.35) 111.39% 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% Total Culture & Recreation 58,718.64 475,069.67 987,565.00 512,495.33 48.11% Total Charges for Services 58,718.64 475,069.67 987,565.00 512,495.33 48.11% Miscellaneous Revenue 362000 - Rental of Property 5,145.75 27,008.75 60,000.00 32,991.25 45.01% 367000 - Donations from Private Sources - 23,228.66 - (23,228.66) 0.00% Total Miscellaneous Revenue 5,145.75 50,237.41 60,000.00 9,762.59 83.73% Refunds & Reimbursements 380000 - Misc Reimbursements - 2,960.41 - (2,960.41) 0.00% Total Refunds & Reimbursements - 2,960.41 - (2,960.41) 0.00% Total Revenue 63,864.39 528,267.49 1,047,565.00 519,297.51 50.43% 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 (160,681.55) 163,998.88 - 163,998.88 385,392.00 221,393.12 42.55% 410002 - Teamster Wages 48,754.57 48,754.57 - 48,754.57 110,309.00 61,554.43 44.20% 410003 - Permanent Part Time (35,331.55) 29,190.99 - 29,190.99 232,406.00 203,215.01 12.56% 410004 - Extra & Overtime 7,432.34 7,432.34 - 7,432.34 16,000.00 8,567.66 46.45% 410005 - Seasonal & Interns 10,295.23 96,460.50 - 96,460.50 437,305.00 340,844.50 22.06% 410007 - Longevity Pay 150.00 150.00 - 150.00 - (150.00) 0.00% Total Salaries & Wages (129,380.96) 345,987.28 - 345,987.28 1,181,412.00 835,424.72 29.29% Employee Benefits 411001 - FICA Regular (10,294.04) 27,419.02 - 27,419.02 90,824.00 63,404.98 30.19% 411004 - PERF Regular (13,060.66) 25,118.66 - 25,118.66 57,561.00 32,442.34 43.64% 411005 - PERF Union 313.46 313.46 - 313.46 3,000.00 2,686.54 10.45% 411007 - Unemployment Comp (167.78) 316.38 - 316.38 819.00 502.62 38.63% 411008 - Health Insurance (18,752.16) 52,552.46 - 52,552.46 135,554.00 83,001.54 38.77% 411009 - Life Insurance (220.00) 460.00 - 460.00 1,200.00 740.00 38.33% 411014 - Parental Leave (369.92) 763.33 - 763.33 1,791.00 1,027.67 42.62% 411203 - Job Readiness Allow. 1,275.00 1,275.00 - 1,275.00 1,575.00 300.00 80.95% 411206 - Cell Phone Allowance 165.00 825.00 - 825.00 1,260.00 435.00 65.48% Total Employee Benefits (41,111.10) 109,043.31 - 109,043.31 293,584.00 184,540.69 37.14% Total Personnel Expenses (170,492.06) 455,030.59 - 455,030.59 1,474,996.00 1,019,965.41 30.85% Supplies Expenses Office Supplies May 31, 2022 421000 - General Office Supplies - 573.99 - 573.99 1,500.00 926.01 38.27% Total Office Supplies - 573.99 - 573.99 1,500.00 926.01 38.27% Operating Supplies 422000 - Other Operating Supplies 13,157.86 22,419.17 1,607.57 24,026.74 84,823.57 60,796.83 28.33% 422005 - Uniforms 196.00 1,783.00 - 1,783.00 10,000.00 8,217.00 17.83% 422007 - Cleaning Supplies - - - - 2,400.00 2,400.00 0.00% 422008 - Medical/Safety Supplies - - - - 2,576.00 2,576.00 0.00% 422009 - Recreation Supplies 8,418.76 23,126.37 9,530.00 32,656.37 117,101.60 84,445.23 27.89% 422014 - Concessions Inventory 3,676.34 8,588.30 742.31 9,330.61 29,500.00 20,169.39 31.63% Total Operating Supplies 25,448.96 55,916.84 11,879.88 67,796.72 246,401.17 178,604.45 27.51% Total Supplies Expenses 25,448.96 56,490.83 11,879.88 68,370.71 247,901.17 179,530.46 27.58% Services & Charges Expenses Professional Services 431000 - Other Professional Services 7,029.11 20,074.70 1,966.00 22,040.70 49,707.00 27,666.30 44.34% Total Professional Services 7,029.11 20,074.70 1,966.00 22,040.70 49,707.00 27,666.30 44.34% Communication & Transportation 432003 - Travel 257.79 539.94 - 539.94 10,500.00 9,960.06 5.14% 432005 - Mileage Reimb - - - - 4,805.00 4,805.00 0.00% Total Communication & Transportation 257.79 539.94 - 539.94 15,305.00 14,765.06 3.53% Printing & Advertising 433001 - Outside Printing Services - - - - 10,200.00 10,200.00 0.00% 433003 - Promotional 12,231.75 20,097.71 17,565.00 37,662.71 45,500.00 7,837.29 82.78% Total Printing & Advertising 12,231.75 20,097.71 17,565.00 37,662.71 55,700.00 18,037.29 67.62% Repairs & Maintenance 436000 - Other R&M 646.68 646.68 - 646.68 1,100.00 453.32 58.79% Total Repairs & Maintenance 646.68 646.68 - 646.68 1,100.00 453.32 58.79% 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 62,190.05 116,167.18 - 116,167.18 173,206.00 57,038.82 67.07% 438200 - Interest 2,522.29 9,193.45 - 9,193.45 17,430.00 8,236.55 52.74% Total Debt Service 64,712.34 125,360.63 - 125,360.63 190,636.00 65,275.37 65.76% Other Charges & Services 439000 - Misc Charges & Svcs 4,186.40 44,803.43 16,028.62 60,832.05 89,230.10 28,398.05 68.17% 439001 - Other Contractual Services - 530.00 - 530.00 800.00 270.00 66.25% 439002 - Licenses & Permits - 4,368.20 - 4,368.20 5,945.00 1,576.80 73.48% 439004 - Dues & Memberships - 90.00 - 90.00 7,260.00 7,170.00 1.24% 439005 - Bank & Credit Card Fees 1,733.73 22,225.24 - 22,225.24 40,565.00 18,339.76 54.79% 439006 - Education & Training 1,091.00 1,521.00 - 1,521.00 5,300.00 3,779.00 28.70% 439009 - Trash Removal - 14.85 - 14.85 504.95 490.10 2.94% 439099 - Cashier Over/Short (0.62) 1,543.38 - 1,543.38 2,300.00 756.62 67.10% 439100 - Refunds/Awards/Indemnities 1,801.89 8,124.78 - 8,124.78 23,855.00 15,730.22 34.06% Total Other Services & Charges 8,812.40 83,220.88 16,028.62 99,249.50 175,760.05 76,510.55 56.47% Total Services & Charges Expenses 93,690.07 263,140.54 35,559.62 298,700.16 501,408.05 202,707.89 59.57% Other Uses 452002 - Allocations-Admin Cost 6,467.00 32,335.00 - 32,335.00 77,604.00 45,269.00 41.67% 452003 - Allocations-IT 14,069.17 70,345.81 - 70,345.81 168,830.00 98,484.19 41.67% Total Other Uses 20,536.17 102,680.81 - 102,680.81 246,434.00 143,753.19 41.67% Total Expenses (30,816.86) 877,342.77 47,439.50 924,782.27 2,470,739.22 1,545,956.95 37.43%