Loading...
HomeMy WebLinkAboutOct 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 - 37,435.91 30,000.00 (7,435.91) 124.79% 347002 - Picnic Site Rental 15.79 3,345.80 6,154.00 2,808.20 54.37% 347010 - Concession Sales 2,507.69 72,130.32 51,100.00 (21,030.32) 141.16% 347011 - Recreational Programming 13,049.40 363,958.67 333,561.00 (30,397.67) 109.11% 347016 - East Race Waterway - 66,193.50 50,000.00 (16,193.50) 132.39% 347017 - Ice Skating 3,588.00 198,422.74 400,000.00 201,577.26 49.61% 347024 - Sponsorship Income - 3,500.00 - (3,500.00) 0.00% 347026 - Room Rental 3,573.05 38,098.54 30,000.00 (8,098.54) 127.00% 347030 - Merch Sales 101.43 1,127.34 - (1,127.34) 0.00% 347040 - Pavilion Rental 83.53 27,037.17 33,710.00 6,672.83 80.21% Total Culture & Recreation 22,918.89 811,249.99 934,525.00 123,275.01 86.81% Total Charges for Services 22,918.89 811,249.99 934,525.00 123,275.01 86.81% Miscellaneous Revenue 360000 - Miscellaneous - 2,646.50 - (2,646.50) 0.00% 362000 - Rental of Property - 62,501.50 72,337.00 9,835.50 86.40% Total Miscellaneous Revenue - 65,148.00 72,337.00 7,189.00 90.06% Refunds & Reimbursements 380000 - Misc Reimbursements 192.48 4,141.34 - (4,141.34) 0.00% 396000 - Refunds - 300.00 - (300.00) 0.00% Total Refunds & Reimbursements 192.48 4,441.34 - (4,441.34) 0.00% Total Revenue 23,111.37 880,839.33 1,006,862.00 126,022.67 87.48% 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,179.96 442,481.87 - 442,481.87 586,850.00 144,368.13 75.40% 410002 - Teamster Wages 7,037.33 77,659.91 - 77,659.91 116,713.00 39,053.09 66.54% 410003 - Permanent Part Time 9,363.35 150,778.05 - 150,778.05 227,381.00 76,602.95 66.31% 410004 - Extra & Overtime 177.39 6,626.97 - 6,626.97 8,000.00 1,373.03 82.84% 410005 - Seasonal & Interns 7,513.94 339,006.17 - 339,006.17 437,305.00 98,298.83 77.52% Total Salaries & Wages 62,271.97 1,016,552.97 - 1,016,552.97 1,376,249.00 359,696.03 73.86% Employee Benefits 411001 - FICA Regular 4,645.31 76,034.60 - 76,034.60 105,479.00 29,444.40 72.09% 411004 - PERF Regular 4,614.10 53,316.96 - 53,316.96 79,016.00 25,699.04 67.48% 411005 - PERF Union 48.72 541.93 - 541.93 625.00 83.07 86.71% 411007 - Unemployment Comp 4.67 50.63 - 50.63 844.00 793.37 6.00% 411008 - Health Insurance 11,444.86 120,282.90 - 120,282.90 182,135.00 61,852.10 66.04% 411009 - Life Insurance 110.00 1,135.00 - 1,135.00 1,560.00 425.00 72.76% 411010 - Med/Surgical/Dental 140.94 1,476.43 - 1,476.43 - (1,476.43) 0.00% 411014 - Parental Leave 172.03 1,826.60 - 1,826.60 2,462.00 635.40 74.19% 411203 - Job Readiness Allow. - 425.00 - 425.00 1,275.00 850.00 33.33% 411206 - Cell Phone Allowance 110.00 1,100.00 - 1,100.00 660.00 (440.00) 166.67% Total Employee Benefits 21,290.63 256,190.05 - 256,190.05 374,056.00 117,865.95 68.49% Total Personnel Expenses 83,562.60 1,272,743.02 - 1,272,743.02 1,750,305.00 477,561.98 72.72% Supplies Expenses Office Supplies 421000 - General Office Supplies - 735.45 362.61 1,098.06 1,978.00 879.94 55.51% October 31, 2023 Total Office Supplies - 735.45 362.61 1,098.06 1,978.00 879.94 55.51% Operating Supplies 422000 - Other Operating Supplies 3,054.55 17,025.07 316.48 17,341.55 37,131.57 19,790.02 46.70% 422005 - Uniforms 1,010.90 2,766.37 373.52 3,139.89 10,175.00 7,035.11 30.86% 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,223.05 35,415.15 6,553.47 41,968.62 84,206.00 42,237.38 49.84% 422014 - Concessions Inventory 2,407.67 41,163.71 27.36 41,191.07 50,002.36 8,811.29 82.38% Total Operating Supplies 7,696.17 96,370.30 7,270.83 103,641.13 186,739.93 83,098.80 55.50% Total Supplies Expenses 7,696.17 97,105.75 7,633.44 104,739.19 188,717.93 83,978.74 55.50% Services & Charges Expenses Professional Services 431000 - Other Professional Services 5,666.40 87,960.26 40,045.75 128,006.01 125,205.75 (2,800.26) 102.24% Total Professional Services 5,666.40 87,960.26 40,045.75 128,006.01 125,205.75 (2,800.26) 102.24% Communication & Transportation 432003 - Travel 1,843.80 1,843.80 9,139.14 10,982.94 16,677.14 5,694.20 65.86% 432005 - Mileage Reimb 134.86 999.28 - 999.28 5,318.00 4,318.72 18.79% Total Communication & Transportation 1,978.66 2,843.08 9,139.14 11,982.22 21,995.14 10,012.92 54.48% Printing & Advertising 433001 - Outside Printing Services - 871.36 1,446.75 2,318.11 3,000.00 681.89 77.27% 433003 - Promotional 5,144.75 33,520.34 2,400.00 35,920.34 49,298.00 13,377.66 72.86% Total Printing & Advertising 5,144.75 34,391.70 3,846.75 38,238.45 52,298.00 14,059.55 73.12% 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 9,744.25 58,183.17 9,213.23 67,396.40 100,561.98 33,165.58 67.02% 439001 - Other Contractual Services - 1,844.00 - 1,844.00 2,159.00 315.00 85.41% 439002 - Licenses & Permits - 4,161.01 900.00 5,061.01 7,416.00 2,354.99 68.24% 439004 - Dues & Memberships - 334.00 - 334.00 7,498.00 7,164.00 4.45% 439005 - Bank & Credit Card Fees 1,098.85 34,832.26 - 34,832.26 51,833.00 17,000.74 67.20% 439006 - Education & Training 915.26 9,301.55 3,066.63 12,368.18 13,789.73 1,421.55 89.69% 439009 - Trash Removal - - - - 530.00 530.00 0.00% 439099 - Cashier Over/Short (0.90) (125.83) - (125.83) 10.00 135.83 (1258.30%) 439100 - Refunds/Awards/Indemnities - 2,862.59 - 2,862.59 24,830.00 21,967.41 11.53% 439300 - Grants & Subsidies 10,514.73 16,975.74 40.00 17,015.74 20,000.00 2,984.26 85.08% Total Other Services & Charges 22,272.19 128,368.49 13,219.86 141,588.35 228,627.71 87,039.36 61.93% Total Services & Charges Expenses 35,062.00 401,313.15 66,251.50 467,564.65 641,210.60 173,645.95 72.92% Other Uses 452002 - Allocations-Admin Cost 9,927.25 99,272.50 - 99,272.50 119,127.00 19,854.50 83.33% 452003 - Allocations-IT 17,260.42 172,604.20 - 172,604.20 207,125.00 34,520.80 83.33% Total Other Uses 27,187.67 271,876.70 - 271,876.70 326,252.00 54,375.30 83.33% Total Expenses 153,508.44 2,043,038.62 73,884.94 2,116,923.56 2,906,485.53 789,561.97 72.83%