Loading...
HomeMy WebLinkAboutAug 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 6,119.90 35,254.16 40,213.00 4,958.84 87.67% 347002 - Picnic Site Rental 505.20 3,451.84 - (3,451.84) 0.00% 347010 - Concession Sales 13,468.75 48,636.34 59,000.00 10,363.66 82.43% 347011 - Recreational Programming 30,430.88 310,512.74 465,565.00 155,052.26 66.70% 347016 - East Race Waterway 18,373.12 55,020.97 60,000.00 4,979.03 91.70% 347017 - Ice Skating - 197,057.38 300,000.00 102,942.62 65.69% 347026 - Room Rental 3,861.75 37,826.11 26,000.00 (11,826.11) 145.49% 347030 - Merch Sales 246.76 1,845.74 - (1,845.74) 0.00% 347040 - Pavilion Rental 4,408.76 29,580.51 15,000.00 (14,580.51) 197.20% Total Culture & Recreation 77,415.12 719,185.79 965,778.00 246,592.21 74.47% Total Charges for Services 77,415.12 719,185.79 965,778.00 246,592.21 74.47% Miscellaneous Revenue 362000 - Rental of Property 100.00 44,156.00 60,000.00 15,844.00 73.59% 367000 - Donations from Private Sources - 23,228.66 - (23,228.66) 0.00% Total Miscellaneous Revenue 100.00 67,384.66 60,000.00 (7,384.66) 112.31% Refunds & Reimbursements 380000 - Misc Reimbursements - 3,094.32 3,527.00 432.68 87.73% 396000 - Refunds 47.88 47.88 - (47.88) 0.00% Total Refunds & Reimbursements 47.88 3,142.20 3,527.00 384.80 89.09% Total Revenue 77,563.00 789,712.65 1,029,305.00 239,592.35 76.72% 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 28,647.01 271,032.83 - 271,032.83 385,392.00 114,359.17 70.33% 410002 - Teamster Wages 6,053.20 70,190.17 - 70,190.17 110,309.00 40,118.83 63.63% 410003 - Permanent Part Time 15,614.43 69,484.87 - 69,484.87 232,406.00 162,921.13 29.90% 410004 - Extra & Overtime 2,778.11 13,748.72 - 13,748.72 16,000.00 2,251.28 85.93% 410005 - Seasonal & Interns 69,273.52 306,114.64 - 306,114.64 437,105.00 130,990.36 70.03% 410007 - Longevity Pay - 150.00 - 150.00 200.00 50.00 75.00% Total Salaries & Wages 122,366.27 730,721.23 - 730,721.23 1,181,412.00 450,690.77 61.85% Employee Benefits 411001 - FICA Regular 9,220.22 56,469.14 - 56,469.14 90,824.00 34,354.86 62.17% 411004 - PERF Regular 4,243.44 41,026.82 - 41,026.82 57,561.00 16,534.18 71.28% 411005 - PERF Union 47.78 457.71 - 457.71 3,000.00 2,542.29 15.26% 411007 - Unemployment Comp 59.04 533.07 - 533.07 819.00 285.93 65.09% 411008 - Health Insurance 11,373.66 92,581.70 - 92,581.70 135,554.00 42,972.30 68.30% 411009 - Life Insurance 100.00 815.00 - 815.00 1,200.00 385.00 67.92% 411014 - Parental Leave 127.28 1,227.57 - 1,227.57 1,791.00 563.43 68.54% 411203 - Job Readiness Allow. - 1,275.00 - 1,275.00 1,575.00 300.00 80.95% 411206 - Cell Phone Allowance 165.00 1,320.00 - 1,320.00 1,260.00 (60.00) 104.76% Total Employee Benefits 25,336.42 195,706.01 - 195,706.01 293,584.00 97,877.99 66.66% Total Personnel Expenses 147,702.69 926,427.24 - 926,427.24 1,474,996.00 548,568.76 62.81% Supplies Expenses August 31, 2022 Office Supplies 421000 - General Office Supplies - 656.25 - 656.25 1,700.00 1,043.75 38.60% Total Office Supplies - 656.25 - 656.25 1,700.00 1,043.75 38.60% Operating Supplies 422000 - Other Operating Supplies 2,404.56 30,194.92 1,607.57 31,802.49 81,823.57 50,021.08 38.87% 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 15,000.71 60,593.89 26,149.47 86,743.36 125,101.60 38,358.24 69.34% 422014 - Concessions Inventory 4,225.39 28,088.55 27.36 28,115.91 27,300.00 (815.91) 102.99% Total Operating Supplies 21,630.66 123,808.82 27,784.40 151,593.22 251,201.17 99,607.95 60.35% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 57.76 - 57.76 - (57.76) 0.00% Total Repair & Maintenance Supplies - 57.76 - 57.76 - (57.76) 0.00% Total Supplies Expenses 21,630.66 124,522.83 27,784.40 152,307.23 252,901.17 100,593.94 60.22% Services & Charges Expenses Professional Services 431000 - Other Professional Services 8,840.84 51,599.20 445.00 52,044.20 56,207.00 4,162.80 92.59% Total Professional Services 8,840.84 51,599.20 445.00 52,044.20 56,207.00 4,162.80 92.59% Communication & Transportation 432003 - Travel 1,860.58 2,408.52 5,703.43 8,111.95 9,500.00 1,388.05 85.39% 432005 - Mileage Reimb 213.29 628.96 293.00 921.96 2,305.00 1,383.04 40.00% Total Communication & Transportation 2,073.87 3,037.48 5,996.43 9,033.91 11,805.00 2,771.09 76.53% Printing & Advertising 433001 - Outside Printing Services - 850.00 - 850.00 3,700.00 2,850.00 22.97% 433003 - Promotional 1,452.53 39,787.04 2,400.00 42,187.04 44,900.00 2,712.96 93.96% Total Printing & Advertising 1,452.53 40,637.04 2,400.00 43,037.04 48,600.00 5,562.96 88.55% Repairs & Maintenance 436000 - Other R&M 93.05 1,626.84 - 1,626.84 1,100.00 (526.84) 147.89% Total Repairs & Maintenance 93.05 1,626.84 - 1,626.84 1,100.00 (526.84) 147.89% 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 12,822.36 73,931.87 26,188.55 100,120.42 105,730.10 5,609.68 94.69% 439001 - Other Contractual Services 99.99 3,713.38 - 3,713.38 3,500.00 (213.38) 106.10% 439002 - Licenses & Permits - 5,431.58 - 5,431.58 6,545.00 1,113.42 82.99% 439004 - Dues & Memberships - 90.00 - 90.00 3,260.00 3,170.00 2.76% 439005 - Bank & Credit Card Fees 2,479.82 32,169.48 - 32,169.48 39,765.00 7,595.52 80.90% 439006 - Education & Training - 2,890.00 1,119.73 4,009.73 6,700.00 2,690.27 59.85% 439009 - Trash Removal - 14.85 - 14.85 504.95 490.10 2.94% 439099 - Cashier Over/Short (5.27) 1,093.71 - 1,093.71 2,300.00 1,206.29 47.55% 439100 - Refunds/Awards/Indemnities 3,733.15 14,387.44 - 14,387.44 16,555.00 2,167.56 86.91% Total Other Services & Charges 19,130.05 133,722.31 27,308.28 161,030.59 184,860.05 23,829.46 87.11% Total Services & Charges Expenses 31,590.34 369,183.50 36,149.71 405,333.21 506,408.05 101,074.84 80.04% Capital Outlay Machinery & Equipment 445003 - Park Equipment 19,750.00 19,750.00 - 19,750.00 - (19,750.00) 0.00% Total Machinery & Equipment 19,750.00 19,750.00 - 19,750.00 - (19,750.00) 0.00% Total Capital Expenses 19,750.00 19,750.00 - 19,750.00 - (19,750.00) 0.00% Other Uses 452002 - Allocations-Admin Cost 6,467.00 51,736.00 - 51,736.00 77,604.00 25,868.00 66.67% 452003 - Allocations-IT 14,069.17 112,553.32 - 112,553.32 168,830.00 56,276.68 66.67% Total Other Uses 20,536.17 164,289.32 - 164,289.32 246,434.00 82,144.68 66.67% Total Expenses 241,209.86 1,604,172.89 63,934.11 1,668,107.00 2,480,739.22 812,632.22 67.24%