Loading...
HomeMy WebLinkAboutJune 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 12,716.75 15,108.10 30,000.00 14,891.90 50.36% 347002 - Picnic Site Rental 943.04 2,321.78 6,154.00 3,832.22 37.73% 347010 - Concession Sales 20,590.33 28,932.89 51,100.00 22,167.11 56.62% 347011 - Recreational Programming 43,052.80 285,698.26 333,561.00 47,862.74 85.65% 347016 - East Race Waterway 13,101.10 18,248.30 50,000.00 31,751.70 36.50% 347017 - Ice Skating - 182,387.99 400,000.00 217,612.01 45.60% 347026 - Room Rental 3,840.63 26,939.75 30,000.00 3,060.25 89.80% 347030 - Merch Sales (770.30) (601.76) - 601.76 0.00% 347040 - Pavilion Rental 4,650.83 19,437.36 33,710.00 14,272.64 57.66% Total Culture & Recreation 98,125.18 578,472.67 934,525.00 356,052.33 61.90% Total Charges for Services 98,125.18 578,472.67 934,525.00 356,052.33 61.90% Miscellaneous Revenue 360000 - Miscellaneous 210.00 210.00 - (210.00) 0.00% 362000 - Rental of Property 12,306.18 43,612.23 72,337.00 28,724.77 60.29% Total Miscellaneous Revenue 12,516.18 43,822.23 72,337.00 28,514.77 60.58% Refunds & Reimbursements 380000 - Misc Reimbursements - 3,748.94 - (3,748.94) 0.00% 396000 - Refunds - 300.00 - (300.00) 0.00% Total Refunds & Reimbursements - 4,048.94 - (4,048.94) 0.00% Total Revenue 110,641.36 626,343.84 1,006,862.00 380,518.16 62.21% 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 45,227.17 247,092.96 - 247,092.96 586,850.00 339,757.04 42.10% 410002 - Teamster Wages 10,824.09 48,288.80 - 48,288.80 116,713.00 68,424.20 41.37% 410003 - Permanent Part Time 14,568.92 73,067.22 - 73,067.22 236,006.00 162,938.78 30.96% 410004 - Extra & Overtime 1,279.98 3,332.22 - 3,332.22 - (3,332.22) 0.00% 410005 - Seasonal & Interns 51,660.82 150,779.26 - 150,779.26 437,305.00 286,525.74 34.48% Total Salaries & Wages 123,560.98 522,560.46 - 522,560.46 1,376,874.00 854,313.54 37.95% Employee Benefits 411001 - FICA Regular 9,277.72 38,496.87 - 38,496.87 105,479.00 66,982.13 36.50% 411004 - PERF Regular 5,379.34 29,419.76 - 29,419.76 79,016.00 49,596.24 37.23% 411005 - PERF Union 48.72 322.77 - 322.77 - (322.77) 0.00% 411007 - Unemployment Comp 5.01 28.25 - 28.25 844.00 815.75 3.35% 411008 - Health Insurance 14,326.56 69,087.86 - 69,087.86 182,135.00 113,047.14 37.93% 411009 - Life Insurance 145.00 645.00 - 645.00 1,560.00 915.00 41.35% 411010 - Med/Surgical/Dental 187.91 860.01 - 860.01 - (860.01) 0.00% 411014 - Parental Leave 178.05 1,020.45 - 1,020.45 2,462.00 1,441.55 41.45% 411203 - Job Readiness Allow. 425.00 425.00 - 425.00 1,275.00 850.00 33.33% 411206 - Cell Phone Allowance 110.00 660.00 - 660.00 660.00 - 100.00% Total Employee Benefits 30,083.31 140,965.97 - 140,965.97 373,431.00 232,465.03 37.75% Total Personnel Expenses 153,644.29 663,526.43 - 663,526.43 1,750,305.00 1,086,778.57 37.91% Supplies Expenses Office Supplies June 30, 2023 421000 - General Office Supplies 21.98 674.46 - 674.46 1,978.00 1,303.54 34.10% Total Office Supplies 21.98 674.46 - 674.46 1,978.00 1,303.54 34.10% Operating Supplies 422000 - Other Operating Supplies 400.76 6,688.74 389.59 7,078.33 49,131.57 42,053.24 14.41% 422005 - Uniforms 466.00 849.47 - 849.47 10,175.00 9,325.53 8.35% 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 14,052.13 26,498.73 7,138.12 33,636.85 91,206.00 57,569.15 36.88% 422014 - Concessions Inventory 9,937.81 19,739.02 2,385.52 22,124.54 31,002.36 8,877.82 71.36% Total Operating Supplies 24,856.70 53,775.96 9,913.23 63,689.19 186,739.93 123,050.74 34.11% Total Supplies Expenses 24,878.68 54,450.42 9,913.23 64,363.65 188,717.93 124,354.28 34.11% Services & Charges Expenses Professional Services 431000 - Other Professional Services 11,630.11 48,766.12 36,514.99 85,281.11 99,580.75 14,299.64 85.64% Total Professional Services 11,630.11 48,766.12 36,514.99 85,281.11 99,580.75 14,299.64 85.64% Communication & Transportation 432003 - Travel - - 6,152.14 6,152.14 16,677.14 10,525.00 36.89% 432005 - Mileage Reimb - 578.65 - 578.65 4,875.00 4,296.35 11.87% Total Communication & Transportation - 578.65 6,152.14 6,730.79 21,552.14 14,821.35 31.23% Printing & Advertising 433001 - Outside Printing Services - - 1,446.75 1,446.75 3,000.00 1,553.25 48.23% 433003 - Promotional 320.33 21,167.41 2,400.00 23,567.41 49,298.00 25,730.59 47.81% Total Printing & Advertising 320.33 21,167.41 3,846.75 25,014.16 52,298.00 27,283.84 47.83% 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 982.35 32,263.86 10,533.84 42,797.70 95,161.98 52,364.28 44.97% 439001 - Other Contractual Services - 1,619.00 - 1,619.00 2,102.00 483.00 77.02% 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 3,039.16 25,979.49 - 25,979.49 62,358.00 36,378.51 41.66% 439006 - Education & Training 205.00 6,165.32 1,624.41 7,789.73 10,249.73 2,460.00 76.00% 439009 - Trash Removal - - - - 530.00 530.00 0.00% 439099 - Cashier Over/Short (6.71) (27.68) - (27.68) - 27.68 0.00% 439100 - Refunds/Awards/Indemnities 120.00 2,795.39 - 2,795.39 35,280.00 32,484.61 7.92% 439300 - Grants & Subsidies - - - - 20,000.00 20,000.00 0.00% Total Other Services & Charges 4,339.80 73,290.39 12,158.25 85,448.64 239,695.71 154,247.07 35.65% Total Services & Charges Expenses 16,290.24 291,552.19 58,672.13 350,224.32 626,210.60 275,986.28 55.93% Other Uses 452002 - Allocations-Admin Cost - 39,709.00 - 39,709.00 119,127.00 79,418.00 33.33% 452003 - Allocations-IT - 69,041.68 - 69,041.68 207,125.00 138,083.32 33.33% Total Other Uses - 108,750.68 - 108,750.68 326,252.00 217,501.32 33.33% Total Expenses 194,813.21 1,118,279.72 68,585.36 1,186,865.08 2,891,485.53 1,704,620.45 41.05%