Loading...
HomeMy WebLinkAboutDec 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 810.35 38,246.26 30,000.00 (8,246.26) 127.49% 347002 - Picnic Site Rental 101.04 3,446.84 6,154.00 2,707.16 56.01% 347010 - Concession Sales 365.09 75,380.80 51,100.00 (24,280.80) 147.52% 347011 - Recreational Programming 6,364.59 381,373.16 333,561.00 (47,812.16) 114.33% 347016 - East Race Waterway 4,219.20 70,412.70 50,000.00 (20,412.70) 140.83% 347017 - Ice Skating 103,537.78 338,450.38 400,000.00 61,549.62 84.61% 347024 - Sponsorship Income - 3,500.00 - (3,500.00) 0.00% 347026 - Room Rental 7,099.13 49,110.10 30,000.00 (19,110.10) 163.70% 347030 - Merch Sales 681.45 2,083.77 - (2,083.77) 0.00% 347040 - Pavilion Rental 722.20 28,173.84 33,710.00 5,536.16 83.58% Total Culture & Recreation 123,900.83 990,177.85 934,525.00 (55,652.85) 105.96% Total Charges for Services 123,900.83 990,177.85 934,525.00 (55,652.85) 105.96% Miscellaneous Revenue 360000 - Miscellaneous 157.50 2,804.00 - (2,804.00) 0.00% 362000 - Rental of Property 6,128.09 71,340.33 72,337.00 996.67 98.62% Total Miscellaneous Revenue 6,285.59 74,144.33 72,337.00 (1,807.33) 102.50% Refunds & Reimbursements 380000 - Misc Reimbursements 700.00 4,982.34 - (4,982.34) 0.00% 396000 - Refunds - 450.00 - (450.00) 0.00% Total Refunds & Reimbursements 700.00 5,432.34 - (5,432.34) 0.00% Total Revenue 130,886.42 1,069,754.52 1,006,862.00 (62,892.52) 106.25% 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 48,674.88 529,340.36 - 529,340.36 586,850.00 57,509.64 90.20% 410002 - Teamster Wages 6,376.47 92,390.99 - 92,390.99 114,153.00 21,762.01 80.94% 410003 - Permanent Part Time 9,971.84 171,543.86 - 171,543.86 227,381.00 55,837.14 75.44% 410004 - Extra & Overtime 4,767.52 12,113.29 - 12,113.29 12,115.00 1.71 99.99% 410005 - Seasonal & Interns 21,881.19 371,760.05 - 371,760.05 433,175.00 61,414.95 85.82% Total Salaries & Wages 91,671.90 1,177,148.55 - 1,177,148.55 1,373,674.00 196,525.45 85.69% Employee Benefits 411001 - FICA Regular 6,943.71 88,162.88 - 88,162.88 105,479.00 17,316.12 83.58% 411004 - PERF Regular 6,611.17 64,572.15 - 64,572.15 79,016.00 14,443.85 81.72% 411005 - PERF Union 48.75 639.57 - 639.57 640.00 0.43 99.93% 411007 - Unemployment Comp 5.78 60.88 - 60.88 844.00 783.12 7.21% 411008 - Health Insurance 11,490.92 143,218.68 - 143,218.68 182,135.00 38,916.32 78.63% 411009 - Life Insurance 130.00 1,375.00 - 1,375.00 1,560.00 185.00 88.14% 411010 - Med/Surgical/Dental 140.94 1,758.31 - 1,758.31 1,900.00 141.69 92.54% 411014 - Parental Leave 208.97 2,200.90 - 2,200.90 2,462.00 261.10 89.39% 411203 - Job Readiness Allow. - 425.00 - 425.00 1,275.00 850.00 33.33% 411206 - Cell Phone Allowance 110.00 1,320.00 - 1,320.00 1,320.00 - 100.00% Total Employee Benefits 25,690.24 303,733.37 - 303,733.37 376,631.00 72,897.63 80.64% Total Personnel Expenses 117,362.14 1,480,881.92 - 1,480,881.92 1,750,305.00 269,423.08 84.61% Supplies Expenses Office Supplies 421000 - General Office Supplies 878.61 1,974.17 - 1,974.17 2,481.02 506.85 79.57% December 31, 2023 Total Office Supplies 878.61 1,974.17 - 1,974.17 2,481.02 506.85 79.57% Operating Supplies 422000 - Other Operating Supplies 1,650.65 22,912.16 - 22,912.16 30,226.46 7,314.30 75.80% 422005 - Uniforms 5,582.52 8,348.89 - 8,348.89 10,675.00 2,326.11 78.21% 422007 - Cleaning Supplies - 11.51 - 11.51 1,220.00 1,208.49 0.94% 422008 - Medical/Safety Supplies - - - - 2,705.00 2,705.00 0.00% 422009 - Recreation Supplies 3,713.75 43,869.07 - 43,869.07 77,706.00 33,836.93 56.46% 422014 - Concessions Inventory 177.78 42,137.30 - 42,137.30 50,502.36 8,365.06 83.44% Total Operating Supplies 11,124.70 117,278.93 - 117,278.93 173,034.82 55,755.89 67.78% Total Supplies Expenses 12,003.31 119,253.10 - 119,253.10 175,515.84 56,262.74 67.94% Services & Charges Expenses Professional Services 431000 - Other Professional Services 4,547.05 95,228.31 - 95,228.31 133,305.75 38,077.44 71.44% Total Professional Services 4,547.05 95,228.31 - 95,228.31 133,305.75 38,077.44 71.44% Communication & Transportation 432003 - Travel 737.97 3,528.47 - 3,528.47 13,121.14 9,592.67 26.89% 432005 - Mileage Reimb - 999.28 - 999.28 5,318.00 4,318.72 18.79% Total Communication & Transportation 737.97 4,527.75 - 4,527.75 18,439.14 13,911.39 24.56% Printing & Advertising 433001 - Outside Printing Services 904.10 1,894.86 - 1,894.86 3,000.00 1,105.14 63.16% 433003 - Promotional 8,530.32 43,510.50 - 43,510.50 48,498.00 4,987.50 89.72% Total Printing & Advertising 9,434.42 45,405.36 - 45,405.36 51,498.00 6,092.64 88.17% Repairs & Maintenance 436001 - Building R&M - 9,175.00 - 9,175.00 9,175.00 - 100.00% Total Repairs & Maintenance - 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 - 120,890.76 - 120,890.76 182,147.00 61,256.24 66.37% 438200 - Interest - 4,469.86 - 4,469.86 8,490.00 4,020.14 52.65% Total Debt Service - 125,360.62 - 125,360.62 190,637.00 65,276.38 65.76% Other Charges & Services 439000 - Misc Charges & Svcs 2,685.52 65,980.68 286.46 66,267.14 96,784.98 30,517.84 68.47% 439001 - Other Contractual Services - 1,844.00 - 1,844.00 2,159.00 315.00 85.41% 439002 - Licenses & Permits 900.00 5,583.01 - 5,583.01 7,916.00 2,332.99 70.53% 439004 - Dues & Memberships 144.00 478.00 - 478.00 5,198.00 4,720.00 9.20% 439005 - Bank & Credit Card Fees 6,097.30 42,802.01 - 42,802.01 51,833.00 9,030.99 82.58% 439006 - Education & Training 1,319.80 11,897.35 - 11,897.35 14,621.15 2,723.80 81.37% 439009 - Trash Removal - - - - 530.00 530.00 0.00% 439099 - Cashier Over/Short 0.95 (126.48) - (126.48) 11.00 137.48 (1149.82%) 439100 - Refunds/Awards/Indemnities - 2,862.59 - 2,862.59 22,830.00 19,967.41 12.54% 439300 - Grants & Subsidies - 26,075.24 - 26,075.24 35,000.00 8,924.76 74.50% Total Other Services & Charges 11,147.57 157,396.40 286.46 157,682.86 236,883.13 79,200.27 66.57% Total Services & Charges Expenses 25,867.01 450,307.44 286.46 450,593.90 653,212.02 202,618.12 68.98% Other Uses 452002 - Allocations-Admin Cost 9,927.25 119,127.00 - 119,127.00 119,127.00 - 100.00% 452003 - Allocations-IT 17,260.42 207,125.04 - 207,125.04 207,125.00 (0.04) 100.00% Total Other Uses 27,187.67 326,252.04 - 326,252.04 326,252.00 (0.04) 100.00% Bad Debt Expense 490000 - Bad Debt Expense 240.00 240.00 - 240.00 - (240.00) 0.00% Total Bad Debt Expense 240.00 240.00 - 240.00 - (240.00) 0.00% Total Expenses 182,660.13 2,376,934.50 286.46 2,377,220.96 2,905,284.86 528,063.90 81.82%