Loading...
HomeMy WebLinkAboutOct 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 - 56,410.07 20,000.00 (36,410.07) 282.05% 347002 - Picnic Site Rental 33.68 5,999.45 3,300.00 (2,699.45) 181.80% 347010 - Concession Sales 1,126.95 52,813.76 31,000.00 (21,813.76) 170.37% 347011 - Recreational Programming 11,018.99 315,023.87 300,500.00 (14,523.87) 104.83% 347013 - Nonalcoholic Beverage - - - - 0.00% 347016 - East Race Waterway - 51,900.42 55,000.00 3,099.58 94.36% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 54.30% 347018 - Skate Rental - - - - 0.00% 347026 - Room Rental 3,480.60 53,605.21 9,000.00 (44,605.21) 595.61% 347030 - Merch Sales 246.40 1,773.59 2,500.00 726.41 70.94% 347040 - Pavilion Rental 823.24 32,562.12 22,446.00 (10,116.12) 145.07% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347051 - Park Reservations 100.00 100.00 - (100.00) 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 16,829.86 736,903.28 743,746.00 6,842.72 99.08% Total Charges for Services 16,829.86 736,903.28 743,746.00 6,842.72 99.08% Miscellaneous Revenue 360000 - Miscellaneous - 100.00 - (100.00) 0.00% 362000 - Rental of Property 5,415.75 63,326.00 60,000.00 (3,326.00) 105.54% Total Miscellaneous Revenue 5,415.75 63,426.00 60,000.00 (3,426.00) 105.71% Refunds & Reimbursements 380000 - Misc Reimbursements 247.28 23,988.01 35,396.00 11,407.99 67.77% 396000 - Refunds - 415.59 - (415.59) 0.00% Total Refunds & Reimbursements 247.28 24,403.60 35,396.00 10,992.40 68.94% Total Revenue 22,492.89 824,732.88 839,142.00 14,409.12 98.28% 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 103,554.71 802,340.38 - 802,340.38 954,340.00 151,999.62 84.07% 410003 - Permanent Part Time 17,094.28 150,155.90 - 150,155.90 216,788.00 66,632.10 69.26% 410004 - Extra & Overtime - 5,176.10 - 5,176.10 5,639.00 462.90 91.79% 410005 - Seasonal & Interns 10,854.05 347,943.77 - 347,943.77 406,582.00 58,638.23 85.58% Total Salaries & Wages 131,503.04 1,305,616.15 - 1,305,616.15 1,583,349.00 277,732.85 82.46% Employee Benefits 411001 - FICA Regular 9,733.49 96,354.79 - 96,354.79 119,187.00 22,832.21 80.84% 411004 - PERF Regular 11,462.75 85,752.73 - 85,752.73 102,166.00 16,413.27 83.93% 411007 - Unemployment Comp 32.97 249.72 - 249.72 298.00 48.28 83.80% 411008 - Health Insurance 18,791.60 188,984.37 - 188,984.37 226,568.00 37,583.63 83.41% 411009 - Life Insurance 175.00 1,805.00 - 1,805.00 2,165.00 360.00 83.37% 411014 - Parental Leave 362.42 2,815.07 - 2,815.07 3,355.00 539.93 83.91% 411206 - Cell Phone Allowance 165.00 1,650.00 - 1,650.00 2,170.00 520.00 76.04% Total Employee Benefits 40,723.23 377,611.68 - 377,611.68 455,909.00 78,297.32 82.83% Total Personnel Expenditures 172,226.27 1,683,227.83 - 1,683,227.83 2,039,258.00 356,030.17 82.54% October 31, 2021 Supplies Expenditures Office Supplies 421000 - General Office Supplies 479.45 1,625.66 - 1,625.66 2,160.00 534.34 75.26% 421002 - Stationary & Printing 232.07 3,593.77 - 3,593.77 8,049.00 4,455.23 44.65% Total Office Supplies 711.52 5,219.43 - 5,219.43 10,209.00 4,989.57 51.13% Operating Supplies 422000 - Other Operating Supplies 940.20 24,517.18 2,191.67 26,708.85 36,328.62 9,619.77 73.52% 422005 - Uniforms - 3,529.20 - 3,529.20 8,228.00 4,698.80 42.89% 422006 - Computer Supplies & Equipment - - - - 2,200.00 2,200.00 0.00% 422008 - Medical/Safety Supplies 645.00 1,124.78 - 1,124.78 3,440.00 2,315.22 32.70% 422009 - Recreation Supplies 6,441.91 79,720.92 562.22 80,283.14 138,103.82 57,820.68 58.13% 422013 - Promotional Supplies - 557.26 - 557.26 700.00 142.74 79.61% 422014 - Concessions Inventory 521.46 24,898.12 - 24,898.12 32,340.00 7,441.88 76.99% 422016 - Inventory For Sale - 182.33 - 182.33 2,300.00 2,117.67 7.93% Total Operating Supplies 8,548.57 134,529.79 2,753.89 137,283.68 223,640.44 86,356.76 61.39% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 6,455.33 - 6,455.33 7,500.00 1,044.67 86.07% Total Repair & Maintenance Supplies - 6,455.33 - 6,455.33 7,500.00 1,044.67 86.07% Total Supplies Expenditures 9,260.09 146,204.55 2,753.89 148,958.44 241,349.44 92,391.00 61.72% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 3,721.62 50,969.33 100.00 51,069.33 81,388.00 30,318.67 62.75% Total Professional Services 3,721.62 50,969.33 100.00 51,069.33 81,388.00 30,318.67 62.75% Communication & Transportation 432002 - Mailing - 0.52 - 0.52 1.00 0.48 52.00% 432003 - Travel 938.12 1,750.69 4,923.36 6,674.05 13,510.00 6,835.95 49.40% 432005 - Mileage Reimb 132.72 132.72 - 132.72 5,819.00 5,686.28 2.28% Total Communication & Transportation 1,070.84 1,883.93 4,923.36 6,807.29 19,330.00 12,522.71 35.22% Printing & Advertising 433001 - Outside Printing Services - 3,429.10 4,072.76 7,501.86 12,956.00 5,454.14 57.90% 433003 - Promotional 110.00 110.00 - 110.00 6,685.00 6,575.00 1.65% Total Printing & Advertising 110.00 3,539.10 4,072.76 7,611.86 19,641.00 12,029.14 38.75% 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 700.00 1,900.00 1,900.00 - 100.00% Total Rentals - 13,200.00 700.00 13,900.00 13,900.00 - 100.00% Debt Service 438100 - Principal - 99,109.11 - 99,109.11 169,416.00 70,306.89 58.50% 438200 - Interest - 12,125.43 - 12,125.43 21,220.00 9,094.57 57.14% Total Debt Service - 111,234.54 - 111,234.54 190,636.00 79,401.46 58.35% Other Charges & Services 439000 - Misc Charges & Svcs 7,630.30 53,475.47 10,446.89 63,922.36 85,355.78 21,433.42 74.89% 439001 - Other Contractual Services 650.00 5,603.01 2,070.00 7,673.01 22,095.00 14,421.99 34.73% 439002 - Licenses & Permits - 1,812.74 - 1,812.74 2,953.00 1,140.26 61.39% 439004 - Dues & Memberships 82.26 955.26 - 955.26 3,278.00 2,322.74 29.14% 439005 - Bank & Credit Card Fees 681.80 28,855.60 - 28,855.60 38,397.00 9,541.40 75.15% 439006 - Education & Training 872.80 1,994.40 3,805.00 5,799.40 10,231.00 4,431.60 56.68% 439009 - Trash Removal 79.28 1,860.12 - 1,860.12 2,800.00 939.88 66.43% 439099 - Cashier Over/Short 0.67 (78.75) - (78.75) - 78.75 0.00% 439100 - Refunds/Awards/Indemnities 780.10 17,600.94 - 17,600.94 27,466.00 9,865.06 64.08% 439999 - Bad Debt Expense - - - - - - 0.00% Total Other Services & Charges 10,777.21 112,078.79 16,321.89 128,400.68 192,575.78 64,175.10 66.68% Total Services & Charges Expenditures 15,679.67 294,485.40 26,118.01 320,603.41 520,681.78 200,078.37 61.57% Other Uses 452002 - Allocations-Admin Cost 12,750.00 127,503.00 - 127,503.00 153,003.00 25,500.00 83.33% Total Other Uses 12,750.00 127,503.00 - 127,503.00 153,003.00 25,500.00 83.33% Total Expenditures 209,916.03 2,251,420.78 28,871.90 2,280,292.68 2,954,292.22 673,999.54 77.19%