Loading...
HomeMy WebLinkAboutSept 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,381.40 37,435.91 30,000.00 (7,435.91) 124.79% 347002 - Picnic Site Rental 178.01 3,330.01 6,154.00 2,823.99 54.11% 347010 - Concession Sales 4,719.59 69,622.63 51,100.00 (18,522.63) 136.25% 347011 - Recreational Programming 19,024.18 350,909.27 333,561.00 (17,348.27) 105.20% 347016 - East Race Waterway 4,460.00 66,193.50 50,000.00 (16,193.50) 132.39% 347017 - Ice Skating - 182,387.99 400,000.00 217,612.01 45.60% 347024 - Sponsorship Income 3,500.00 3,500.00 - (3,500.00) 0.00% 347026 - Room Rental 2,085.88 34,525.49 30,000.00 (4,525.49) 115.08% 347030 - Merch Sales 113.60 1,025.91 - (1,025.91) 0.00% 347040 - Pavilion Rental 2,689.42 26,953.64 33,710.00 6,756.36 79.96% Total Culture & Recreation 38,152.08 775,884.35 934,525.00 158,640.65 83.02% Total Charges for Services 38,152.08 775,884.35 934,525.00 158,640.65 83.02% Miscellaneous Revenue 360000 - Miscellaneous - 1,879.00 - (1,879.00) 0.00% 362000 - Rental of Property 6,028.09 62,501.50 72,337.00 9,835.50 86.40% Total Miscellaneous Revenue 6,028.09 64,380.50 72,337.00 7,956.50 89.00% Refunds & Reimbursements 380000 - Misc Reimbursements 32.00 3,948.86 - (3,948.86) 0.00% 396000 - Refunds - 300.00 - (300.00) 0.00% Total Refunds & Reimbursements 32.00 4,248.86 - (4,248.86) 0.00% Total Revenue 44,212.17 844,513.71 1,006,862.00 162,348.29 83.88% 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 63,779.12 404,301.91 - 404,301.91 586,850.00 182,548.09 68.89% 410002 - Teamster Wages 8,329.18 70,622.58 - 70,622.58 116,713.00 46,090.42 60.51% 410003 - Permanent Part Time 16,495.96 141,414.70 - 141,414.70 227,381.00 85,966.30 62.19% 410004 - Extra & Overtime 1,058.91 6,449.58 - 6,449.58 8,000.00 1,550.42 80.62% 410005 - Seasonal & Interns 32,220.54 331,492.23 - 331,492.23 437,305.00 105,812.77 75.80% Total Salaries & Wages 121,883.71 954,281.00 - 954,281.00 1,376,249.00 421,968.00 69.34% Employee Benefits 411001 - FICA Regular 9,230.83 71,389.29 - 71,389.29 105,479.00 34,089.71 67.68% 411004 - PERF Regular 7,623.24 48,702.86 - 48,702.86 79,016.00 30,313.14 61.64% 411005 - PERF Union 73.00 493.21 - 493.21 625.00 131.79 78.91% 411007 - Unemployment Comp 7.19 45.96 - 45.96 844.00 798.04 5.45% 411008 - Health Insurance 13,248.16 108,838.04 - 108,838.04 182,135.00 73,296.96 59.76% 411009 - Life Insurance 125.00 1,025.00 - 1,025.00 1,560.00 535.00 65.71% 411010 - Med/Surgical/Dental 166.78 1,335.49 - 1,335.49 - (1,335.49) 0.00% 411014 - Parental Leave 256.06 1,654.57 - 1,654.57 2,462.00 807.43 67.20% 411203 - Job Readiness Allow. - 425.00 - 425.00 1,275.00 850.00 33.33% 411206 - Cell Phone Allowance 110.00 990.00 - 990.00 660.00 (330.00) 150.00% Total Employee Benefits 30,840.26 234,899.42 - 234,899.42 374,056.00 139,156.58 62.80% Total Personnel Expenses 152,723.97 1,189,180.42 - 1,189,180.42 1,750,305.00 561,124.58 67.94% Supplies Expenses Office Supplies 421000 - General Office Supplies 60.99 735.45 - 735.45 1,978.00 1,242.55 37.18% September 30, 2023 Total Office Supplies 60.99 735.45 - 735.45 1,978.00 1,242.55 37.18% Operating Supplies 422000 - Other Operating Supplies 4,760.03 13,970.52 49.52 14,020.04 37,131.57 23,111.53 37.76% 422005 - Uniforms - 1,755.47 - 1,755.47 10,175.00 8,419.53 17.25% 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 666.08 34,192.10 4,210.07 38,402.17 84,206.00 45,803.83 45.61% 422014 - Concessions Inventory 1,861.38 38,756.04 1,378.05 40,134.09 50,002.36 9,868.27 80.26% Total Operating Supplies 7,287.49 88,674.13 5,637.64 94,311.77 186,739.93 92,428.16 50.50% Total Supplies Expenses 7,348.48 89,409.58 5,637.64 95,047.22 188,717.93 93,670.71 50.36% Services & Charges Expenses Professional Services 431000 - Other Professional Services 7,425.50 82,293.86 36,017.75 118,311.61 119,580.75 1,269.14 98.94% Total Professional Services 7,425.50 82,293.86 36,017.75 118,311.61 119,580.75 1,269.14 98.94% Communication & Transportation 432003 - Travel - - 10,143.14 10,143.14 16,677.14 6,534.00 60.82% 432005 - Mileage Reimb - 864.42 - 864.42 5,318.00 4,453.58 16.25% Total Communication & Transportation - 864.42 10,143.14 11,007.56 21,995.14 10,987.58 50.05% Printing & Advertising 433001 - Outside Printing Services - 871.36 1,446.75 2,318.11 3,000.00 681.89 77.27% 433003 - Promotional 427.28 28,375.59 6,244.75 34,620.34 49,298.00 14,677.66 70.23% Total Printing & Advertising 427.28 29,246.95 7,691.50 36,938.45 52,298.00 15,359.55 70.63% 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,488.00 4,018.14 52.66% Total Debt Service - 125,360.62 - 125,360.62 190,635.00 65,274.38 65.76% Other Charges & Services 439000 - Misc Charges & Svcs 3,971.18 48,438.92 14,831.73 63,270.65 96,561.98 33,291.33 65.52% 439001 - Other Contractual Services - 1,844.00 - 1,844.00 2,159.00 315.00 85.41% 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,451.10 32,963.41 - 32,963.41 62,358.00 29,394.59 52.86% 439006 - Education & Training 930.97 8,386.29 3,851.21 12,237.50 13,789.73 1,552.23 88.74% 439009 - Trash Removal - - - - 530.00 530.00 0.00% 439099 - Cashier Over/Short 0.49 (124.93) - (124.93) 10.00 134.93 (1249.30%) 439100 - Refunds/Awards/Indemnities - 2,862.59 - 2,862.59 24,830.00 21,967.41 11.53% 439300 - Grants & Subsidies 6,024.97 6,399.97 5,670.00 12,069.97 20,000.00 7,930.03 60.35% Total Other Services & Charges 12,378.71 105,265.26 24,352.94 129,618.20 234,252.71 104,634.51 55.33% Total Services & Charges Expenses 20,231.49 365,420.11 78,205.33 443,625.44 641,210.60 197,585.16 69.19% Other Uses 452002 - Allocations-Admin Cost - 79,418.00 - 79,418.00 119,127.00 39,709.00 66.67% 452003 - Allocations-IT - 138,083.36 - 138,083.36 207,125.00 69,041.64 66.67% Total Other Uses - 217,501.36 - 217,501.36 326,252.00 108,750.64 66.67% Total Expenses 180,303.94 1,861,511.47 83,842.97 1,945,354.44 2,906,485.53 961,131.09 66.93%