Loading...
HomeMy WebLinkAboutAug 23 Fin 5South Bend Venues, Parks and Arts Recreation: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Charges for Services Culture & Recreation 347001 - Swimming Pool 4,218.61 34,489.26 30,000.00 (4,489.26) 114.96% 347002 - Picnic Site Rental 354.48 2,949.92 6,154.00 3,204.08 47.94% 347010 - Concession Sales 13,893.40 64,851.89 51,100.00 (13,751.89) 126.91% 347011 - Recreational Programming 31,771.25 327,969.13 333,561.00 5,591.87 98.32% 347016 - East Race Waterway 13,547.95 56,822.20 50,000.00 (6,822.20) 113.64% 347017 - Ice Skating - 182,387.99 400,000.00 217,612.01 45.60% 347026 - Room Rental 3,173.25 32,439.61 30,000.00 (2,439.61) 108.13% 347030 - Merch Sales 74.33 901.61 - (901.61) 0.00% 347040 - Pavilion Rental 1,373.67 22,724.84 33,710.00 10,985.16 67.41% Total Culture & Recreation 68,406.94 725,536.45 934,525.00 208,988.55 77.64% Total Charges for Services 68,406.94 725,536.45 934,525.00 208,988.55 77.64% Miscellaneous Revenue 360000 - Miscellaneous - 1,114.00 - (1,114.00) 0.00% 362000 - Rental of Property 12,406.18 56,108.41 72,337.00 16,228.59 77.57% Total Miscellaneous Revenue 12,406.18 57,222.41 72,337.00 15,114.59 79.11% Refunds & Reimbursements 380000 - Misc Reimbursements - 3,910.86 - (3,910.86) 0.00% 396000 - Refunds - 300.00 - (300.00) 0.00% Total Refunds & Reimbursements - 4,210.86 - (4,210.86) 0.00% Total Revenue 80,813.12 786,969.72 1,006,862.00 219,892.28 78.16% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent of Account String Month Expenses Encumbrances w/ Encumb. Budget Budget Budget Personnel Expenses Salaries & Wages 410001 - Salaried Wages 38,179.91 305,002.78 - 305,002.78 586,850.00 281,847.22 51.97% 410002 - Teamster Wages 6,003.20 62,293.40 - 62,293.40 116,713.00 54,419.60 53.37% 410003 - Permanent Part Time 24,826.29 124,918.74 - 124,918.74 227,381.00 102,462.26 54.94% 410004 - Extra & Overtime 1,194.86 5,390.67 - 5,390.67 8,000.00 2,609.33 67.38% 410005 - Seasonal & Interns 67,728.71 299,271.69 - 299,271.69 437,305.00 138,033.31 68.44% Total Salaries & Wages 137,932.97 796,877.28 - 796,877.28 1,376,249.00 579,371.72 57.90% Employee Benefits 411001 - FICA Regular 10,554.99 59,486.72 - 59,486.72 105,479.00 45,992.28 56.40% 411004 - PERF Regular 4,645.64 37,669.73 - 37,669.73 79,016.00 41,346.27 47.67% 411005 - PERF Union 48.72 420.21 - 420.21 625.00 204.79 67.23% 411007 - Unemployment Comp 4.44 35.45 - 35.45 844.00 808.55 4.20% 411008 - Health Insurance 11,444.86 86,573.38 - 86,573.38 182,135.00 95,561.62 47.53% 411009 - Life Insurance 110.00 825.00 - 825.00 1,560.00 735.00 52.88% 411010 - Med/Surgical/Dental 140.94 1,050.81 - 1,050.81 - (1,050.81) 0.00% 411014 - Parental Leave 155.48 1,274.32 - 1,274.32 2,462.00 1,187.68 51.76% 411203 - Job Readiness Allow. - 425.00 - 425.00 1,275.00 850.00 33.33% 411206 - Cell Phone Allowance 110.00 880.00 - 880.00 660.00 (220.00) 133.33% Total Employee Benefits 27,215.07 188,640.62 - 188,640.62 374,056.00 185,415.38 50.43% Total Personnel Expenses 165,148.04 985,517.90 - 985,517.90 1,750,305.00 764,787.10 56.31% Supplies Expenses Office Supplies August 31, 2023 421000 - General Office Supplies - 674.46 - 674.46 1,978.00 1,303.54 34.10% Total Office Supplies - 674.46 - 674.46 1,978.00 1,303.54 34.10% Operating Supplies 422000 - Other Operating Supplies 512.14 8,015.49 95.52 8,111.01 44,131.57 36,020.56 18.38% 422005 - Uniforms 500.00 1,755.47 - 1,755.47 10,175.00 8,419.53 17.25% 422007 - Cleaning Supplies - - - - 2,520.00 2,520.00 0.00% 422008 - Medical/Safety Supplies - - - - 2,705.00 2,705.00 0.00% 422009 - Recreation Supplies 3,858.43 33,526.02 3,958.12 37,484.14 92,206.00 54,721.86 40.65% 422014 - Concessions Inventory 5,797.77 36,894.66 2,194.50 39,089.16 35,002.36 (4,086.80) 111.68% Total Operating Supplies 10,668.34 80,191.64 6,248.14 86,439.78 186,739.93 100,300.15 46.29% Total Supplies Expenses 10,668.34 80,866.10 6,248.14 87,114.24 188,717.93 101,603.69 46.16% Services & Charges Expenses Professional Services 431000 - Other Professional Services 11,790.75 74,868.36 42,818.25 117,686.61 104,580.75 (13,105.86) 112.53% Total Professional Services 11,790.75 74,868.36 42,818.25 117,686.61 104,580.75 (13,105.86) 112.53% Communication & Transportation 432003 - Travel - - 10,143.14 10,143.14 16,677.14 6,534.00 60.82% 432005 - Mileage Reimb 220.08 864.42 - 864.42 5,318.00 4,453.58 16.25% Total Communication & Transportation 220.08 864.42 10,143.14 11,007.56 21,995.14 10,987.58 50.05% Printing & Advertising 433001 - Outside Printing Services 871.36 871.36 1,446.75 2,318.11 3,000.00 681.89 77.27% 433003 - Promotional 702.83 27,948.31 6,244.75 34,193.06 49,298.00 15,104.94 69.36% Total Printing & Advertising 1,574.19 28,819.67 7,691.50 36,511.17 52,298.00 15,786.83 69.81% Repairs & Maintenance 436001 - Building R&M - 9,175.00 - 9,175.00 9,175.00 - 100.00% Total Repairs & Maintenance - 9,175.00 - 9,175.00 9,175.00 - 100.00% Rentals 437002 - Equipment Rental - 14.00 - 14.00 14.00 - 100.00% 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,260.00 60.00 95.24% Total Rentals - 13,214.00 - 13,214.00 13,274.00 60.00 99.55% Debt Service 438100 - Principal - 120,890.76 - 120,890.76 182,147.00 61,256.24 66.37% 438200 - Interest - 4,469.86 - 4,469.86 8,488.00 4,018.14 52.66% Total Debt Service - 125,360.62 - 125,360.62 190,635.00 65,274.38 65.76% Other Charges & Services 439000 - Misc Charges & Svcs 8,315.86 44,467.74 13,591.74 58,059.48 94,121.98 36,062.50 61.69% 439001 - Other Contractual Services 225.00 1,844.00 - 1,844.00 2,159.00 315.00 85.41% 439002 - Licenses & Permits - 4,161.01 - 4,161.01 6,516.00 2,354.99 63.86% 439004 - Dues & Memberships - 334.00 - 334.00 7,498.00 7,164.00 4.45% 439005 - Bank & Credit Card Fees 1,505.07 30,756.14 - 30,756.14 62,358.00 31,601.86 49.32% 439006 - Education & Training 1,290.00 7,455.32 3,794.41 11,249.73 13,789.73 2,540.00 81.58% 439009 - Trash Removal - - - - 530.00 530.00 0.00% 439099 - Cashier Over/Short 1.75 (125.42) - (125.42) 10.00 135.42 (1254.20%) 439100 - Refunds/Awards/Indemnities - 2,862.59 - 2,862.59 27,270.00 24,407.41 10.50% 439300 - Grants & Subsidies 375.00 375.00 3,000.00 3,375.00 20,000.00 16,625.00 16.88% Total Other Services & Charges 11,712.68 92,130.38 20,386.15 112,516.53 234,252.71 121,736.18 48.03% Total Services & Charges Expenses 25,297.70 344,432.45 81,039.04 425,471.49 626,210.60 200,739.11 67.94% Other Uses 452002 - Allocations-Admin Cost - 59,563.50 - 59,563.50 119,127.00 59,563.50 50.00% 452003 - Allocations-IT - 103,562.52 - 103,562.52 207,125.00 103,562.48 50.00% Total Other Uses - 163,126.02 - 163,126.02 326,252.00 163,125.98 50.00% Total Expenses 201,114.08 1,573,942.47 87,287.18 1,661,229.65 2,891,485.53 1,230,255.88 57.45%