Loading...
HomeMy WebLinkAboutDec 21 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 165.10 56,575.17 56,410.00 (165.17) 100.29% 347002 - Picnic Site Rental 33.68 6,033.13 6,000.00 (33.13) 100.55% 347010 - Concession Sales - 54,694.23 55,500.00 805.77 98.55% 347011 - Recreational Programming (27,681.61) 328,713.38 366,369.00 37,655.62 89.72% 347013 - Nonalcoholic Beverage - - - - 0.00% 347016 - East Race Waterway 244.00 52,144.42 52,060.00 (84.42) 100.16% 347017 - Ice Skating 167,157.25 330,055.55 300,000.00 (30,055.55) 110.02% 347018 - Skate Rental - - - - 0.00% 347026 - Room Rental 8,996.31 67,383.42 60,750.00 (6,633.42) 110.92% 347030 - Merch Sales 1,455.86 3,620.68 2,000.00 (1,620.68) 181.03% 347040 - Pavilion Rental 201.60 33,049.36 33,446.00 396.64 98.81% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347051 - Park Reservations - 100.00 100.00 - 100.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 150,572.19 936,185.83 932,635.00 (3,550.83) 100.38% Total Charges for Services 150,572.19 936,185.83 932,635.00 (3,550.83) 100.38% Miscellaneous Revenue 360000 - Miscellaneous - 128.00 - (128.00) 0.00% 362000 - Rental of Property 5,415.75 74,156.50 75,000.00 843.50 98.88% Total Miscellaneous Revenue 5,415.75 74,284.50 75,000.00 715.50 99.05% Refunds & Reimbursements 380000 - Misc Reimbursements 483.00 24,475.01 14,046.00 (10,429.01) 174.25% 396000 - Refunds - 415.59 - (415.59) 0.00% Total Refunds & Reimbursements 483.00 24,890.60 14,046.00 (10,844.60) 177.21% Total Revenue 156,470.94 1,035,360.93 1,021,681.00 (13,679.93) 101.34% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 69,886.54 941,019.55 - 941,019.55 954,340.00 13,320.45 98.60% 410002 - Teamster Wages 308.08 308.08 - 308.08 400.00 91.92 77.02% 410003 - Permanent Part Time 12,956.52 176,194.57 - 176,194.57 186,788.00 10,593.43 94.33% 410004 - Extra & Overtime - 5,176.10 - 5,176.10 5,639.00 462.90 91.79% 410005 - Seasonal & Interns 23,818.91 381,929.76 - 381,929.76 406,182.00 24,252.24 94.03% Total Salaries & Wages 106,970.05 1,504,628.06 - 1,504,628.06 1,553,349.00 48,720.94 96.86% Employee Benefits 411001 - FICA Regular 8,069.80 111,071.89 - 111,071.89 119,187.00 8,115.11 93.19% 411004 - PERF Regular 7,412.09 100,557.50 - 100,557.50 102,166.00 1,608.50 98.43% 411007 - Unemployment Comp 22.26 294.09 - 294.09 298.00 3.91 98.69% 411008 - Health Insurance 17,740.40 224,465.17 - 224,465.17 226,568.00 2,102.83 99.07% 411009 - Life Insurance 170.00 2,145.00 - 2,145.00 2,165.00 20.00 99.08% 411014 - Parental Leave 249.83 3,305.68 - 3,305.68 3,355.00 49.32 98.53% 411206 - Cell Phone Allowance 165.00 1,980.00 - 1,980.00 2,170.00 190.00 91.24% Total Employee Benefits 33,829.38 443,819.33 - 443,819.33 455,909.00 12,089.67 97.35% Total Personnel Expenditures 140,799.43 1,948,447.39 - 1,948,447.39 2,009,258.00 60,810.61 96.97% December 31, 2021 Supplies Expenditures Office Supplies 421000 - General Office Supplies 243.06 1,969.82 - 1,969.82 3,160.00 1,190.18 62.34% 421002 - Stationary & Printing 252.35 4,530.08 - 4,530.08 7,840.82 3,310.74 57.78% Total Office Supplies 495.41 6,499.90 - 6,499.90 11,000.82 4,500.92 59.09% Operating Supplies 422000 - Other Operating Supplies 1,495.80 27,396.92 - 27,396.92 35,205.05 7,808.13 77.82% 422005 - Uniforms 2,742.48 7,358.97 - 7,358.97 11,128.00 3,769.03 66.13% 422006 - Computer Supplies & Equipment - - - - 2,200.00 2,200.00 0.00% 422008 - Medical/Safety Supplies - 1,124.78 - 1,124.78 2,540.00 1,415.22 44.28% 422009 - Recreation Supplies 11,358.01 96,975.54 - 96,975.54 115,702.22 18,726.68 83.81% 422013 - Promotional Supplies - 557.26 - 557.26 700.00 142.74 79.61% 422014 - Concessions Inventory - 24,968.38 - 24,968.38 30,740.00 5,771.62 81.22% 422016 - Inventory For Sale - 182.33 - 182.33 2,300.00 2,117.67 7.93% Total Operating Supplies 15,596.29 158,564.18 - 158,564.18 200,515.27 41,951.09 79.08% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 6,455.33 - 6,455.33 7,155.00 699.67 90.22% Total Repair & Maintenance Supplies - 6,455.33 - 6,455.33 7,155.00 699.67 90.22% Total Supplies Expenditures 16,091.70 171,519.41 - 171,519.41 218,671.09 47,151.68 78.44% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 3,299.75 56,426.77 - 56,426.77 72,071.00 15,644.23 78.29% Total Professional Services 3,299.75 56,426.77 - 56,426.77 72,071.00 15,644.23 78.29% Communication & Transportation 432002 - Mailing - 0.52 - 0.52 1.00 0.48 52.00% 432003 - Travel 2.00 2,705.10 - 2,705.10 14,010.00 11,304.90 19.31% 432005 - Mileage Reimb 242.85 375.57 - 375.57 6,019.00 5,643.43 6.24% Total Communication & Transportation 244.85 3,081.19 - 3,081.19 20,030.00 16,948.81 15.38% Printing & Advertising 433001 - Outside Printing Services - 3,429.10 - 3,429.10 9,006.00 5,576.90 38.08% 433003 - Promotional 493.02 1,615.02 - 1,615.02 7,885.00 6,269.98 20.48% Total Printing & Advertising 493.02 5,044.12 - 5,044.12 16,891.00 11,846.88 29.86% Repairs & Maintenance 436000 - Other R&M - 10.91 - 10.91 11.00 0.09 99.18% 436001 - Building R&M - 1,568.80 - 1,568.80 3,200.00 1,631.20 49.03% Total Repairs & Maintenance - 1,579.71 - 1,579.71 3,211.00 1,631.29 49.20% 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,900.00 700.00 63.16% Total Rentals - 13,200.00 - 13,200.00 13,900.00 700.00 94.96% Debt Service 438100 - Principal - 160,391.86 - 160,391.86 169,416.00 9,024.14 94.67% 438200 - Interest - 15,555.01 - 15,555.01 21,220.00 5,664.99 73.30% Total Debt Service - 175,946.87 - 175,946.87 190,636.00 14,689.13 92.29% Other Charges & Services 439000 - Misc Charges & Svcs 4,304.13 67,878.39 - 67,878.39 75,179.99 7,301.60 90.29% 439001 - Other Contractual Services 2,189.58 10,840.59 - 10,840.59 21,705.00 10,864.41 49.95% 439002 - Licenses & Permits - 1,812.74 - 1,812.74 2,953.00 1,140.26 61.39% 439004 - Dues & Memberships - 955.26 - 955.26 2,578.00 1,622.74 37.05% 439005 - Bank & Credit Card Fees 9,513.75 41,853.25 - 41,853.25 48,397.00 6,543.75 86.48% 439006 - Education & Training - 4,667.00 - 4,667.00 10,431.00 5,764.00 44.74% 439009 - Trash Removal 359.95 2,304.76 - 2,304.76 3,125.49 820.73 73.74% 439099 - Cashier Over/Short (0.60) (79.35) - (79.35) - 79.35 0.00% 439100 - Refunds/Awards/Indemnities 6,128.90 24,833.28 - 24,833.28 28,966.00 4,132.72 85.73% 439999 - Bad Debt Expense - - - - - - 0.00% Total Other Services & Charges 22,495.71 155,065.92 - 155,065.92 193,335.48 38,269.56 80.21% Total Services & Charges Expenditures 26,533.33 410,344.58 - 410,344.58 510,074.48 99,729.90 80.45% Other Uses 452002 - Allocations-Admin Cost 12,750.00 153,003.00 - 153,003.00 153,003.00 - 100.00% Total Other Uses 12,750.00 153,003.00 - 153,003.00 153,003.00 - 100.00% Total Expenditures 196,174.46 2,683,314.38 - 2,683,314.38 2,891,006.57 207,692.19 92.82%