Loading...
HomeMy WebLinkAboutDec 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 - 54,425.82 59,000.00 4,574.18 92.25% 347011 - Recreational Programming 7,749.94 353,506.07 465,565.00 112,058.93 75.93% 347016 - East Race Waterway - 57,503.17 60,000.00 2,496.83 95.84% 347017 - Ice Skating 102,774.05 353,653.25 300,000.00 (53,653.25) 117.88% 347026 - Room Rental 6,162.23 58,631.76 26,000.00 (32,631.76) 225.51% 347030 - Merch Sales 510.20 4,033.52 - (4,033.52) 0.00% 347040 - Pavilion Rental 218.44 32,666.67 15,000.00 (17,666.67) 217.78% Total Culture & Recreation 117,414.86 953,605.29 965,778.00 12,172.71 98.74% Total Charges for Services 117,414.86 953,605.29 965,778.00 12,172.71 98.74% Miscellaneous Revenue 362000 - Rental of Property 5,515.75 67,119.00 60,000.00 (7,119.00) 111.87% 367000 - Donations from Private Sources - 23,228.66 - (23,228.66) 0.00% Total Miscellaneous Revenue 5,515.75 90,347.66 60,000.00 (30,347.66) 150.58% Refunds & Reimbursements 380000 - Misc Reimbursements 6,121.87 9,522.23 3,527.00 (5,995.23) 269.98% 396000 - Refunds - 945.38 - (945.38) 0.00% Total Refunds & Reimbursements 6,121.87 10,467.61 3,527.00 (6,940.61) 296.79% Total Revenue 129,052.48 1,054,420.56 1,029,305.00 (25,115.56) 102.44% 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 47,485.13 426,375.79 - 426,375.79 426,376.00 0.21 100.00% 410002 - Teamster Wages 6,736.40 92,054.59 - 92,054.59 110,309.00 18,254.41 83.45% 410003 - Permanent Part Time 10,969.18 128,144.98 - 128,144.98 174,248.00 46,103.02 73.54% 410004 - Extra & Overtime 283.15 15,602.70 - 15,602.70 16,713.00 1,110.30 93.36% 410005 - Seasonal & Interns 22,782.07 364,718.59 - 364,718.59 437,105.00 72,386.41 83.44% 410007 - Longevity Pay - 150.00 - 150.00 200.00 50.00 75.00% Total Salaries & Wages 88,255.93 1,027,046.65 - 1,027,046.65 1,164,951.00 137,904.35 88.16% Employee Benefits 411001 - FICA Regular 6,002.51 80,580.45 - 80,580.45 90,824.00 10,243.55 88.72% 411004 - PERF Regular 3,802.05 62,522.98 - 62,522.98 64,060.00 1,537.02 97.60% 411005 - PERF Union 47.82 624.91 - 624.91 3,000.00 2,375.09 20.83% 411007 - Unemployment Comp 5.53 551.20 - 551.20 819.00 267.80 67.30% 411008 - Health Insurance 8,514.66 141,106.42 - 141,106.42 144,646.00 3,539.58 97.55% 411009 - Life Insurance 70.00 1,250.00 - 1,250.00 1,288.00 38.00 97.05% 411014 - Parental Leave 190.71 1,851.28 - 1,851.28 1,852.00 0.72 99.96% 411203 - Job Readiness Allow. - 1,275.00 - 1,275.00 1,575.00 300.00 80.95% 411206 - Cell Phone Allowance 110.00 1,925.00 - 1,925.00 1,981.00 56.00 97.17% Total Employee Benefits 18,743.28 291,687.24 - 291,687.24 310,045.00 18,357.76 94.08% Total Personnel Expenses 106,999.21 1,318,733.89 - 1,318,733.89 1,474,996.00 156,262.11 89.41% Supplies Expenses December 31, 2022 Office Supplies 421000 - General Office Supplies 315.20 2,010.95 - 2,010.95 2,818.00 807.05 71.36% Total Office Supplies 315.20 2,010.95 - 2,010.95 2,818.00 807.05 71.36% Operating Supplies 422000 - Other Operating Supplies 1,338.39 35,237.57 - 35,237.57 45,317.00 10,079.43 77.76% 422005 - Uniforms 4,243.00 9,379.64 - 9,379.64 11,340.00 1,960.36 82.71% 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 15,777.50 107,422.73 - 107,422.73 117,737.60 10,314.87 91.24% 422014 - Concessions Inventory - 31,551.28 - 31,551.28 34,191.64 2,640.36 92.28% Total Operating Supplies 21,358.89 183,682.18 - 183,682.18 212,223.24 28,541.06 86.55% 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,674.09 185,750.89 - 185,750.89 215,241.24 29,490.35 86.30% Services & Charges Expenses Professional Services 431000 - Other Professional Services 2,626.00 72,390.74 - 72,390.74 92,844.25 20,453.51 77.97% Total Professional Services 2,626.00 72,390.74 - 72,390.74 92,844.25 20,453.51 77.97% Communication & Transportation 432003 - Travel 1,152.76 8,736.53 - 8,736.53 8,846.86 110.33 98.75% 432005 - Mileage Reimb - 874.66 - 874.66 1,013.00 138.34 86.34% Total Communication & Transportation 1,152.76 9,611.19 - 9,611.19 9,859.86 248.67 97.48% Printing & Advertising 433001 - Outside Printing Services - 850.00 - 850.00 928.00 78.00 91.59% 433003 - Promotional 608.78 44,566.48 - 44,566.48 60,417.00 15,850.52 73.76% Total Printing & Advertising 608.78 45,416.48 - 45,416.48 61,345.00 15,928.52 74.03% Repairs & Maintenance 436000 - Other R&M - 1,934.59 - 1,934.59 2,112.00 177.41 91.60% Total Repairs & Maintenance - 1,934.59 - 1,934.59 2,112.00 177.41 91.60% Rentals 437005 - Parking Space Rental - 12,000.00 - 12,000.00 13,091.00 1,091.00 91.67% 437006 - Recreation Space Rental - 1,200.00 - 1,200.00 1,310.00 110.00 91.60% Total Rentals - 13,200.00 - 13,200.00 14,401.00 1,201.00 91.66% Debt Service 438100 - Principal - 179,277.95 - 179,277.95 175,649.19 (3,628.76) 102.07% 438200 - Interest - 10,795.01 - 10,795.01 14,986.81 4,191.80 72.03% Total Debt Service - 190,072.96 - 190,072.96 190,636.00 563.04 99.70% Other Charges & Services 439000 - Misc Charges & Svcs 3,935.55 112,488.03 - 112,488.03 120,848.12 8,360.09 93.08% 439001 - Other Contractual Services - 5,058.54 - 5,058.54 5,499.00 440.46 91.99% 439002 - Licenses & Permits - 5,431.58 - 5,431.58 5,945.00 513.42 91.36% 439004 - Dues & Memberships - 319.00 - 319.00 350.00 31.00 91.14% 439005 - Bank & Credit Card Fees 6,265.25 44,097.94 - 44,097.94 44,098.00 0.06 100.00% 439006 - Education & Training 645.00 4,325.00 - 4,325.00 5,046.27 721.27 85.71% 439009 - Trash Removal - 14.85 - 14.85 104.95 90.10 14.15% 439099 - Cashier Over/Short 0.30 1,094.11 - 1,094.11 1,298.00 203.89 84.29% 439100 - Refunds/Awards/Indemnities 1,215.95 18,117.46 - 18,117.46 18,782.00 664.54 96.46% Total Other Services & Charges 12,062.05 190,946.51 - 190,946.51 201,971.34 11,024.83 94.54% Total Services & Charges Expenses 16,449.59 523,572.47 - 523,572.47 573,169.45 49,596.98 91.35% 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 12,934.00 77,604.00 - 77,604.00 77,604.00 - 100.00% 452003 - Allocations-IT 28,138.34 168,830.00 - 168,830.00 168,830.00 - 100.00% Total Other Uses 41,072.34 246,434.00 - 246,434.00 246,434.00 - 100.00% Total Expenses 186,195.23 2,294,241.25 - 2,294,241.25 2,529,590.69 235,349.44 90.70%