Loading...
HomeMy WebLinkAboutSept 22 Fin 5South Bend Venues, Parks and Arts Recreation: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Charges for Services Culture & Recreation 347001 - Swimming Pool 334.62 35,588.78 40,213.00 4,624.22 88.50% 347002 - Picnic Site Rental 110.73 3,562.57 - (3,562.57) 0.00% 347010 - Concession Sales 2,008.28 50,644.62 59,000.00 8,355.38 85.84% 347011 - Recreational Programming 8,878.77 319,391.51 465,565.00 146,173.49 68.60% 347016 - East Race Waterway 2,482.20 57,503.17 60,000.00 2,496.83 95.84% 347017 - Ice Skating 14,514.50 211,571.88 300,000.00 88,428.12 70.52% 347026 - Room Rental 4,022.75 41,848.86 26,000.00 (15,848.86) 160.96% 347030 - Merch Sales 1,012.41 2,858.15 - (2,858.15) 0.00% 347040 - Pavilion Rental 1,613.32 31,193.83 15,000.00 (16,193.83) 207.96% Total Culture & Recreation 34,977.58 754,163.37 965,778.00 211,614.63 78.09% Total Charges for Services 34,977.58 754,163.37 965,778.00 211,614.63 78.09% Miscellaneous Revenue 362000 - Rental of Property 11,431.50 55,587.50 60,000.00 4,412.50 92.65% 367000 - Donations from Private Sources - 23,228.66 - (23,228.66) 0.00% Total Miscellaneous Revenue 11,431.50 78,816.16 60,000.00 (18,816.16) 131.36% Refunds & Reimbursements 380000 - Misc Reimbursements - 3,094.32 3,527.00 432.68 87.73% 396000 - Refunds - 47.88 - (47.88) 0.00% Total Refunds & Reimbursements - 3,142.20 3,527.00 384.80 89.09% Total Revenue 46,409.08 836,121.73 1,029,305.00 193,183.27 81.23% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 97,015.30 368,048.13 - 368,048.13 385,392.00 17,343.87 95.50% 410002 - Teamster Wages - 70,190.17 - 70,190.17 110,309.00 40,118.83 63.63% 410003 - Permanent Part Time 27,342.94 96,827.81 - 96,827.81 232,406.00 135,578.19 41.66% 410004 - Extra & Overtime 992.29 14,741.01 - 14,741.01 16,000.00 1,258.99 92.13% 410005 - Seasonal & Interns 17,718.10 323,832.74 - 323,832.74 437,105.00 113,272.26 74.09% 410007 - Longevity Pay - 150.00 - 150.00 200.00 50.00 75.00% Total Salaries & Wages 143,068.63 873,789.86 - 873,789.86 1,181,412.00 307,622.14 73.96% Employee Benefits 411001 - FICA Regular 10,618.81 67,087.95 - 67,087.95 90,824.00 23,736.05 73.87% 411004 - PERF Regular 10,744.43 51,771.25 - 51,771.25 57,561.00 5,789.75 89.94% 411005 - PERF Union - 457.71 - 457.71 3,000.00 2,542.29 15.26% 411007 - Unemployment Comp 10.48 543.55 - 543.55 819.00 275.45 66.37% 411008 - Health Insurance 17,262.74 109,844.44 - 109,844.44 135,554.00 25,709.56 81.03% 411009 - Life Insurance 170.00 985.00 - 985.00 1,200.00 215.00 82.08% 411014 - Parental Leave 341.31 1,568.88 - 1,568.88 1,791.00 222.12 87.60% 411203 - Job Readiness Allow. - 1,275.00 - 1,275.00 1,575.00 300.00 80.95% 411206 - Cell Phone Allowance 165.00 1,485.00 - 1,485.00 1,260.00 (225.00) 117.86% Total Employee Benefits 39,312.77 235,018.78 - 235,018.78 293,584.00 58,565.22 80.05% Total Personnel Expenses 182,381.40 1,108,808.64 - 1,108,808.64 1,474,996.00 366,187.36 75.17% Supplies Expenses September 30, 2022 Office Supplies 421000 - General Office Supplies - 656.25 - 656.25 1,750.00 1,093.75 37.50% Total Office Supplies - 656.25 - 656.25 1,750.00 1,093.75 37.50% Operating Supplies 422000 - Other Operating Supplies 1,413.51 31,608.43 1,607.57 33,216.00 75,873.57 42,657.57 43.78% 422005 - Uniforms - 4,912.00 - 4,912.00 12,800.00 7,888.00 38.38% 422007 - Cleaning Supplies - 19.46 - 19.46 2,400.00 2,380.54 0.81% 422008 - Medical/Safety Supplies - - - - 1,776.00 1,776.00 0.00% 422009 - Recreation Supplies 17,853.55 78,447.44 18,084.95 96,532.39 101,051.60 4,519.21 95.53% 422014 - Concessions Inventory 1,990.10 30,078.65 27.36 30,106.01 37,300.00 7,193.99 80.71% Total Operating Supplies 21,257.16 145,065.98 19,719.88 164,785.86 231,201.17 66,415.31 71.27% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 57.76 - 57.76 200.00 142.24 28.88% Total Repair & Maintenance Supplies - 57.76 - 57.76 200.00 142.24 28.88% Total Supplies Expenses 21,257.16 145,779.99 19,719.88 165,499.87 233,151.17 67,651.30 70.98% Services & Charges Expenses Professional Services 431000 - Other Professional Services 6,574.50 58,173.70 1,702.18 59,875.88 59,107.00 (768.88) 101.30% Total Professional Services 6,574.50 58,173.70 1,702.18 59,875.88 59,107.00 (768.88) 101.30% Communication & Transportation 432003 - Travel 2,775.02 5,183.54 6,577.61 11,761.15 9,500.00 (2,261.15) 123.80% 432005 - Mileage Reimb - 628.96 293.00 921.96 1,575.00 653.04 58.54% Total Communication & Transportation 2,775.02 5,812.50 6,870.61 12,683.11 11,075.00 (1,608.11) 114.52% Printing & Advertising 433001 - Outside Printing Services - 850.00 - 850.00 1,900.00 1,050.00 44.74% 433003 - Promotional 1,149.77 40,936.81 2,400.00 43,336.81 43,940.00 603.19 98.63% Total Printing & Advertising 1,149.77 41,786.81 2,400.00 44,186.81 45,840.00 1,653.19 96.39% Repairs & Maintenance 436000 - Other R&M - 1,626.84 - 1,626.84 1,680.00 53.16 96.84% Total Repairs & Maintenance - 1,626.84 - 1,626.84 1,680.00 53.16 96.84% Rentals 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,200.00 - 100.00% Total Rentals - 13,200.00 - 13,200.00 13,200.00 - 100.00% Debt Service 438100 - Principal - 116,167.18 - 116,167.18 175,649.19 59,482.01 66.14% 438200 - Interest - 9,193.45 - 9,193.45 14,986.81 5,793.36 61.34% Total Debt Service - 125,360.63 - 125,360.63 190,636.00 65,275.37 65.76% Other Charges & Services 439000 - Misc Charges & Svcs 17,883.21 91,815.08 11,126.01 102,941.09 109,970.10 7,029.01 93.61% 439001 - Other Contractual Services 1,326.16 5,039.54 - 5,039.54 5,800.00 760.46 86.89% 439002 - Licenses & Permits - 5,431.58 - 5,431.58 6,745.00 1,313.42 80.53% 439004 - Dues & Memberships - 90.00 - 90.00 2,560.00 2,470.00 3.52% 439005 - Bank & Credit Card Fees 1,629.56 33,799.04 - 33,799.04 32,385.00 (1,414.04) 104.37% 439006 - Education & Training 335.00 3,225.00 1,119.73 4,344.73 8,300.00 3,955.27 52.35% 439009 - Trash Removal - 14.85 - 14.85 504.95 490.10 2.94% 439099 - Cashier Over/Short - 1,093.71 - 1,093.71 1,650.00 556.29 66.29% 439100 - Refunds/Awards/Indemnities 1,139.20 15,526.64 - 15,526.64 16,955.00 1,428.36 91.58% Total Other Services & Charges 22,313.13 156,035.44 12,245.74 168,281.18 184,870.05 16,588.87 91.03% Total Services & Charges Expenses 32,812.42 401,995.92 23,218.53 425,214.45 506,408.05 81,193.60 83.97% Capital Outlay Machinery & Equipment 445003 - Park Equipment - 19,750.00 - 19,750.00 19,750.00 - 100.00% Total Machinery & Equipment - 19,750.00 - 19,750.00 19,750.00 - 100.00% Total Capital Expenses - 19,750.00 - 19,750.00 19,750.00 - 100.00% Other Uses 452002 - Allocations-Admin Cost 6,467.00 58,203.00 - 58,203.00 77,604.00 19,401.00 75.00% 452003 - Allocations-IT 14,069.17 126,622.49 - 126,622.49 168,830.00 42,207.51 75.00% Total Other Uses 20,536.17 184,825.49 - 184,825.49 246,434.00 61,608.51 75.00% Total Expenses 256,987.15 1,861,160.04 42,938.41 1,904,098.45 2,480,739.22 576,640.77 76.76%