Loading...
HomeMy WebLinkAboutApr 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 224.00 448.00 30,000.00 29,552.00 1.49% 347002 - Picnic Site Rental 199.94 284.14 6,154.00 5,869.86 4.62% 347010 - Concession Sales - - 51,100.00 51,100.00 0.00% 347011 - Recreational Programming 26,966.37 190,072.96 333,561.00 143,488.04 56.98% 347016 - East Race Waterway 2,119.00 2,119.00 50,000.00 47,881.00 4.24% 347017 - Ice Skating 1,390.70 181,846.19 400,000.00 218,153.81 45.46% 347026 - Room Rental 3,432.86 20,099.62 30,000.00 9,900.38 67.00% 347030 - Merch Sales (56.35) 549.57 - (549.57) 0.00% 347040 - Pavilion Rental 2,475.28 8,293.49 33,710.00 25,416.51 24.60% Total Culture & Recreation 36,751.80 403,712.97 934,525.00 530,812.03 43.20% Total Charges for Services 36,751.80 403,712.97 934,525.00 530,812.03 43.20% Miscellaneous Revenue 362000 - Rental of Property 6,433.09 31,206.05 72,337.00 41,130.95 43.14% Total Miscellaneous Revenue 6,433.09 31,206.05 72,337.00 41,130.95 43.14% Refunds & Reimbursements 380000 - Misc Reimbursements 213.35 3,748.94 - (3,748.94) 0.00% 396000 - Refunds - 300.00 - (300.00) 0.00% Total Refunds & Reimbursements 213.35 4,048.94 - (4,048.94) 0.00% Total Revenue 43,398.24 438,967.96 1,006,862.00 567,894.04 43.60% 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 38,818.34 159,582.27 - 159,582.27 586,850.00 427,267.73 27.19% 410002 - Teamster Wages 6,835.92 32,230.08 - 32,230.08 116,713.00 84,482.92 27.61% 410003 - Permanent Part Time 7,651.55 48,893.41 - 48,893.41 236,006.00 187,112.59 20.72% 410004 - Extra & Overtime 201.53 2,005.45 - 2,005.45 - (2,005.45) 0.00% 410005 - Seasonal & Interns 5,565.98 88,063.57 - 88,063.57 437,305.00 349,241.43 20.14% Total Salaries & Wages 59,073.32 330,774.78 - 330,774.78 1,376,874.00 1,046,099.22 24.02% Employee Benefits 411001 - FICA Regular 4,268.95 24,111.03 - 24,111.03 105,479.00 81,367.97 22.86% 411004 - PERF Regular 4,592.45 19,445.39 - 19,445.39 79,016.00 59,570.61 24.61% 411005 - PERF Union 48.83 225.16 - 225.16 - (225.16) 0.00% 411007 - Unemployment Comp 4.42 18.65 - 18.65 844.00 825.35 2.21% 411008 - Health Insurance 11,528.86 43,232.44 - 43,232.44 182,135.00 138,902.56 23.74% 411009 - Life Insurance 110.00 390.00 - 390.00 1,560.00 1,170.00 25.00% 411010 - Med/Surgical/Dental 143.36 528.74 - 528.74 - (528.74) 0.00% 411014 - Parental Leave 160.58 675.84 - 675.84 2,462.00 1,786.16 27.45% 411203 - Job Readiness Allow. - - - - 1,275.00 1,275.00 0.00% 411206 - Cell Phone Allowance 110.00 440.00 - 440.00 660.00 220.00 66.67% Total Employee Benefits 20,967.45 89,067.25 - 89,067.25 373,431.00 284,363.75 23.85% Total Personnel Expenses 80,040.77 419,842.03 - 419,842.03 1,750,305.00 1,330,462.97 23.99% Supplies Expenses Office Supplies 421000 - General Office Supplies - 607.22 - 607.22 1,978.00 1,370.78 30.70% April 30, 2023 Total Office Supplies - 607.22 - 607.22 1,978.00 1,370.78 30.70% Operating Supplies 422000 - Other Operating Supplies 1,202.36 5,867.50 389.59 6,257.09 49,131.57 42,874.48 12.74% 422005 - Uniforms - 368.48 - 368.48 10,175.00 9,806.52 3.62% 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 1,202.75 7,865.47 12,947.00 20,812.47 91,206.00 70,393.53 22.82% 422014 - Concessions Inventory 3,071.50 3,071.50 2,673.14 5,744.64 31,002.36 25,257.72 18.53% Total Operating Supplies 5,476.61 17,172.95 16,009.73 33,182.68 186,739.93 153,557.25 17.77% Total Supplies Expenses 5,476.61 17,780.17 16,009.73 33,789.90 188,717.93 154,928.03 17.90% Services & Charges Expenses Professional Services 431000 - Other Professional Services 1,220.00 19,185.51 38,350.00 57,535.51 88,330.75 30,795.24 65.14% Total Professional Services 1,220.00 19,185.51 38,350.00 57,535.51 88,330.75 30,795.24 65.14% Communication & Transportation 432003 - Travel - - 6,152.14 6,152.14 16,677.14 10,525.00 36.89% 432005 - Mileage Reimb - 209.10 - 209.10 4,875.00 4,665.90 4.29% Total Communication & Transportation - 209.10 6,152.14 6,361.24 21,552.14 15,190.90 29.52% Printing & Advertising 433001 - Outside Printing Services - - - - 3,000.00 3,000.00 0.00% 433003 - Promotional 4,444.32 11,392.12 10,800.00 22,192.12 54,473.00 32,280.88 40.74% Total Printing & Advertising 4,444.32 11,392.12 10,800.00 22,192.12 57,473.00 35,280.88 38.61% Repairs & Maintenance 436001 - Building R&M - 6,675.00 2,500.00 9,175.00 - (9,175.00) 0.00% Total Repairs & Maintenance - 6,675.00 2,500.00 9,175.00 - (9,175.00) 0.00% Rentals 437002 - Equipment Rental - 14.00 - 14.00 - (14.00) 0.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,260.00 46.00 99.65% Debt Service 438100 - Principal - 56,845.63 - 56,845.63 182,147.00 125,301.37 31.21% 438200 - Interest - 3,802.66 - 3,802.66 8,488.00 4,685.34 44.80% Total Debt Service - 60,648.29 - 60,648.29 190,635.00 129,986.71 31.81% Other Charges & Services 439000 - Misc Charges & Svcs 3,509.70 13,322.70 6,421.69 19,744.39 111,529.98 91,785.59 17.70% 439001 - Other Contractual Services - 1,619.00 - 1,619.00 998.00 (621.00) 162.22% 439002 - Licenses & Permits - 4,161.01 - 4,161.01 6,170.00 2,008.99 67.44% 439004 - Dues & Memberships 190.00 334.00 - 334.00 7,354.00 7,020.00 4.54% 439005 - Bank & Credit Card Fees 1,553.79 21,171.31 - 21,171.31 62,358.00 41,186.69 33.95% 439006 - Education & Training 2,793.32 4,230.32 1,624.41 5,854.73 10,249.73 4,395.00 57.12% 439009 - Trash Removal - - - - 530.00 530.00 0.00% 439099 - Cashier Over/Short - (0.88) - (0.88) - 0.88 0.00% 439100 - Refunds/Awards/Indemnities 270.00 2,675.39 - 2,675.39 35,770.00 33,094.61 7.48% 439300 - Grants & Subsidies - - - - 20,000.00 20,000.00 0.00% Total Other Services & Charges 8,316.81 47,512.85 8,046.10 55,558.95 254,959.71 199,400.76 21.79% Total Services & Charges Expenses 13,981.13 158,836.87 65,848.24 224,685.11 626,210.60 401,525.49 35.88% Other Uses 452002 - Allocations-Admin Cost - 29,781.75 - 29,781.75 119,127.00 89,345.25 25.00% 452003 - Allocations-IT - 51,781.26 - 51,781.26 207,125.00 155,343.74 25.00% Total Other Uses - 81,563.01 - 81,563.01 326,252.00 244,688.99 25.00% Total Expenses 99,498.51 678,022.08 81,857.97 759,880.05 2,891,485.53 2,131,605.48 26.28%