Loading...
HomeMy WebLinkAboutNov 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 - 35,588.78 40,213.00 4,624.22 88.50% 347002 - Picnic Site Rental - 3,596.25 - (3,596.25) 0.00% 347010 - Concession Sales 1,721.12 54,425.82 59,000.00 4,574.18 92.25% 347011 - Recreational Programming 2,325.70 345,756.13 465,565.00 119,808.87 74.27% 347016 - East Race Waterway - 57,503.17 60,000.00 2,496.83 95.84% 347017 - Ice Skating 37,469.82 250,879.20 300,000.00 49,120.80 83.63% 347026 - Room Rental 6,508.79 52,469.53 26,000.00 (26,469.53) 201.81% 347030 - Merch Sales 401.75 3,523.32 - (3,523.32) 0.00% 347040 - Pavilion Rental 537.60 32,448.23 15,000.00 (17,448.23) 216.32% Total Culture & Recreation 48,964.78 836,190.43 965,778.00 129,587.57 86.58% Total Charges for Services 48,964.78 836,190.43 965,778.00 129,587.57 86.58% Miscellaneous Revenue 362000 - Rental of Property 100.00 61,603.25 60,000.00 (1,603.25) 102.67% 367000 - Donations from Private Sources - 23,228.66 - (23,228.66) 0.00% Total Miscellaneous Revenue 100.00 84,831.91 60,000.00 (24,831.91) 141.39% Refunds & Reimbursements 380000 - Misc Reimbursements 61.00 3,400.36 3,527.00 126.64 96.41% 396000 - Refunds - 945.38 - (945.38) 0.00% Total Refunds & Reimbursements 61.00 4,345.74 3,527.00 (818.74) 123.21% Total Revenue 49,125.78 925,368.08 1,029,305.00 103,936.92 89.90% 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 30,167.16 378,890.66 - 378,890.66 385,392.00 6,501.34 98.31% 410002 - Teamster Wages - 85,318.19 - 85,318.19 110,309.00 24,990.81 77.34% 410003 - Permanent Part Time 21,335.95 117,175.80 - 117,175.80 232,406.00 115,230.20 50.42% 410004 - Extra & Overtime - 15,319.55 - 15,319.55 16,000.00 680.45 95.75% 410005 - Seasonal & Interns 9,961.89 341,936.52 - 341,936.52 437,105.00 95,168.48 78.23% 410007 - Longevity Pay - 150.00 - 150.00 200.00 50.00 75.00% Total Salaries & Wages 61,465.00 938,790.72 - 938,790.72 1,181,412.00 242,621.28 79.46% Employee Benefits 411001 - FICA Regular 7,251.37 74,577.94 - 74,577.94 90,824.00 16,246.06 82.11% 411004 - PERF Regular 7,499.52 58,720.93 - 58,720.93 57,561.00 (1,159.93) 102.02% 411005 - PERF Union - 577.09 - 577.09 3,000.00 2,422.91 19.24% 411007 - Unemployment Comp 3.01 545.67 - 545.67 819.00 273.33 66.63% 411008 - Health Insurance 17,262.74 132,591.76 - 132,591.76 135,554.00 2,962.24 97.81% 411009 - Life Insurance 165.00 1,180.00 - 1,180.00 1,200.00 20.00 98.33% 411014 - Parental Leave 105.57 1,660.57 - 1,660.57 1,791.00 130.43 92.72% 411203 - Job Readiness Allow. - 1,275.00 - 1,275.00 1,575.00 300.00 80.95% 411206 - Cell Phone Allowance 165.00 1,815.00 - 1,815.00 1,260.00 (555.00) 144.05% Total Employee Benefits 32,452.21 272,943.96 - 272,943.96 293,584.00 20,640.04 92.97% Total Personnel Expenses 93,917.21 1,211,734.68 - 1,211,734.68 1,474,996.00 263,261.32 82.15% Supplies Expenses November 30, 2022 Office Supplies 421000 - General Office Supplies 702.59 1,695.75 - 1,695.75 1,750.00 54.25 96.90% Total Office Supplies 702.59 1,695.75 - 1,695.75 1,750.00 54.25 96.90% Operating Supplies 422000 - Other Operating Supplies 1,550.84 33,899.18 1,704.57 35,603.75 69,002.57 33,398.82 51.60% 422005 - Uniforms 224.64 5,136.64 4,243.00 9,379.64 11,339.00 1,959.36 82.72% 422007 - Cleaning Supplies - 90.96 - 90.96 1,861.00 1,770.04 4.89% 422008 - Medical/Safety Supplies - - - - 1,776.00 1,776.00 0.00% 422009 - Recreation Supplies 2,298.35 91,645.23 15,227.50 106,872.73 116,622.60 9,749.87 91.64% 422014 - Concessions Inventory 830.55 31,551.28 27.36 31,578.64 30,600.00 (978.64) 103.20% Total Operating Supplies 4,904.38 162,323.29 21,202.43 183,525.72 231,201.17 47,675.45 79.38% 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 5,606.97 164,076.80 21,202.43 185,279.23 233,151.17 47,871.94 79.47% Services & Charges Expenses Professional Services 431000 - Other Professional Services 7,458.36 69,764.74 2,251.00 72,015.74 62,307.00 (9,708.74) 115.58% Total Professional Services 7,458.36 69,764.74 2,251.00 72,015.74 62,307.00 (9,708.74) 115.58% Communication & Transportation 432003 - Travel 2,265.23 7,583.77 7,680.45 15,264.22 11,000.00 (4,264.22) 138.77% 432005 - Mileage Reimb 245.70 874.66 - 874.66 975.00 100.34 89.71% Total Communication & Transportation 2,510.93 8,458.43 7,680.45 16,138.88 11,975.00 (4,163.88) 134.77% Printing & Advertising 433001 - Outside Printing Services - 850.00 - 850.00 900.00 50.00 94.44% 433003 - Promotional 1,565.49 43,957.70 2,639.50 46,597.20 46,403.00 (194.20) 100.42% Total Printing & Advertising 1,565.49 44,807.70 2,639.50 47,447.20 47,303.00 (144.20) 100.30% Repairs & Maintenance 436000 - Other R&M - 1,934.59 - 1,934.59 1,988.00 53.41 97.31% Total Repairs & Maintenance - 1,934.59 - 1,934.59 1,988.00 53.41 97.31% 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 63,110.77 179,277.95 - 179,277.95 175,649.19 (3,628.76) 102.07% 438200 - Interest 1,601.56 10,795.01 - 10,795.01 14,986.81 4,191.80 72.03% Total Debt Service 64,712.33 190,072.96 - 190,072.96 190,636.00 563.04 99.70% Other Charges & Services 439000 - Misc Charges & Svcs 4,312.94 108,552.48 10,102.33 118,654.81 115,327.10 (3,327.71) 102.89% 439001 - Other Contractual Services 19.00 5,058.54 - 5,058.54 4,700.00 (358.54) 107.63% 439002 - Licenses & Permits - 5,431.58 - 5,431.58 5,497.00 65.42 98.81% 439004 - Dues & Memberships 229.00 319.00 - 319.00 180.00 (139.00) 177.22% 439005 - Bank & Credit Card Fees 2,613.70 37,832.69 - 37,832.69 32,385.00 (5,447.69) 116.82% 439006 - Education & Training - 3,680.00 2,062.73 5,742.73 4,400.00 (1,342.73) 130.52% 439009 - Trash Removal - 14.85 - 14.85 104.95 90.10 14.15% 439099 - Cashier Over/Short - 1,093.81 - 1,093.81 1,250.00 156.19 87.50% 439100 - Refunds/Awards/Indemnities 957.74 16,901.51 - 16,901.51 15,155.00 (1,746.51) 111.52% Total Other Services & Charges 8,132.38 178,884.46 12,165.06 191,049.52 178,999.05 (12,050.47) 106.73% Total Services & Charges Expenses 84,379.49 507,122.88 24,736.01 531,858.89 506,408.05 (25,450.84) 105.03% 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 - 64,670.00 - 64,670.00 77,604.00 12,934.00 83.33% 452003 - Allocations-IT - 140,691.66 - 140,691.66 168,830.00 28,138.34 83.33% Total Other Uses - 205,361.66 - 205,361.66 246,434.00 41,072.34 83.33% Total Expenses 183,903.67 2,108,046.02 45,938.44 2,153,984.46 2,480,739.22 326,754.76 86.83%