Loading...
HomeMy WebLinkAboutSept 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 437.80 5,965.77 3,300.00 (2,665.77) 180.78% 347010 - Concession Sales 2,798.81 51,686.81 31,000.00 (20,686.81) 166.73% 347011 - Recreational Programming 15,349.63 304,004.88 300,500.00 (3,504.88) 101.17% 347013 - Nonalcoholic Beverage - - - - 0.00% 347016 - East Race Waterway 3,520.50 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 4,513.08 50,124.61 9,000.00 (41,124.61) 556.94% 347030 - Merch Sales 254.24 1,527.19 2,500.00 972.81 61.09% 347040 - Pavilion Rental 2,200.84 31,738.88 22,446.00 (9,292.88) 141.40% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 29,074.90 720,073.42 743,746.00 23,672.58 96.82% Total Charges for Services 29,074.90 720,073.42 743,746.00 23,672.58 96.82% Miscellaneous Revenue 360000 - Miscellaneous - 100.00 - (100.00) 0.00% 362000 - Rental of Property - 57,910.25 60,000.00 2,089.75 96.52% Total Miscellaneous Revenue - 58,010.25 60,000.00 1,989.75 96.68% Refunds & Reimbursements 380000 - Misc Reimbursements (38,280.00) 23,740.73 35,396.00 11,655.27 67.07% 396000 - Refunds - 415.59 - (415.59) 0.00% Total Refunds & Reimbursements (38,280.00) 24,156.32 35,396.00 11,239.68 68.25% Total Revenue (9,205.10) 802,239.99 839,142.00 36,902.01 95.60% 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 67,868.33 698,785.67 - 698,785.67 867,406.00 168,620.33 80.56% 410003 - Permanent Part Time 12,710.37 133,061.62 - 133,061.62 260,255.00 127,193.38 51.13% 410004 - Extra & Overtime 1,838.68 5,176.10 - 5,176.10 5,639.00 462.90 91.79% 410005 - Seasonal & Interns 14,488.16 337,089.72 - 337,089.72 479,240.00 142,150.28 70.34% Total Salaries & Wages 96,905.54 1,174,113.11 - 1,174,113.11 1,612,540.00 438,426.89 72.81% Employee Benefits 411001 - FICA Regular 6,982.16 86,621.30 - 86,621.30 123,561.00 36,939.70 70.10% 411004 - PERF Regular 7,665.63 74,289.98 - 74,289.98 97,792.00 23,502.02 75.97% 411007 - Unemployment Comp 22.11 216.75 - 216.75 261.00 44.25 83.05% 411008 - Health Insurance 18,791.60 170,192.77 - 170,192.77 197,377.00 27,184.23 86.23% 411009 - Life Insurance 180.00 1,630.00 - 1,630.00 2,040.00 410.00 79.90% 411014 - Parental Leave 244.01 2,452.65 - 2,452.65 3,047.00 594.35 80.49% 411206 - Cell Phone Allowance 165.00 1,485.00 - 1,485.00 2,640.00 1,155.00 56.25% Total Employee Benefits 34,050.51 336,888.45 - 336,888.45 426,718.00 89,829.55 78.95% Total Personnel Expenditures 130,956.05 1,511,001.56 - 1,511,001.56 2,039,258.00 528,256.44 74.10% Supplies Expenditures September 30, 2021 Office Supplies 421000 - Other Office Supplies - 1,146.21 - 1,146.21 2,060.00 913.79 55.64% 421002 - Stationary & Printing 833.13 3,361.70 108.33 3,470.03 6,849.00 3,378.97 50.66% Total Office Supplies 833.13 4,507.91 108.33 4,616.24 8,909.00 4,292.76 51.82% Operating Supplies 422000 - Other Operating Supplies 4,296.17 23,576.98 2,789.87 26,366.85 31,528.62 5,161.77 83.63% 422005 - Uniforms 278.00 3,529.20 - 3,529.20 9,628.00 6,098.80 36.66% 422006 - Computer Supplies & Equipment - - - - 4,200.00 4,200.00 0.00% 422008 - Medical/Safety Supplies - 479.78 645.00 1,124.78 4,540.00 3,415.22 24.77% 422009 - Recreation Supplies 16,969.51 73,279.01 4,017.11 77,296.12 140,303.82 63,007.70 55.09% 422013 - Promotional Supplies - 557.26 - 557.26 700.00 142.74 79.61% 422014 - Concessions Inventory 1,171.13 24,376.66 - 24,376.66 30,040.00 5,663.34 81.15% 422016 - Inventory For Sale - 182.33 - 182.33 3,000.00 2,817.67 6.08% Total Operating Supplies 22,714.81 125,981.22 7,451.98 133,433.20 223,940.44 90,507.24 59.58% Repair & Maintenance Supplies 423000 - Other R&M Supplies - 6,455.33 - 6,455.33 8,500.00 2,044.67 75.95% Total Repair & Maintenance Supplies - 6,455.33 - 6,455.33 8,500.00 2,044.67 75.95% Total Supplies Expenditures 23,547.94 136,944.46 7,560.31 144,504.77 241,349.44 96,844.67 59.87% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 454.00 47,247.71 3,102.00 50,349.71 78,139.00 27,789.29 64.44% Total Professional Services 454.00 47,247.71 3,102.00 50,349.71 78,139.00 27,789.29 64.44% Communication & Transportation 432002 - Mailing - 0.52 - 0.52 - (0.52) 0.00% 432003 - Travel 373.17 812.57 4,307.80 5,120.37 16,810.00 11,689.63 30.46% 432005 - Mileage Reimb - - - - 6,494.00 6,494.00 0.00% Total Communication & Transportation 373.17 813.09 4,307.80 5,120.89 23,304.00 18,183.11 21.97% Printing & Advertising 433001 - Outside Printing Services - 3,429.10 4,072.76 7,501.86 21,156.00 13,654.14 35.46% 433003 - Promotional - - - - 9,550.00 9,550.00 0.00% Total Printing & Advertising - 3,429.10 4,072.76 7,501.86 30,706.00 23,204.14 24.43% 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 700.00 1,900.00 1,900.00 - 100.00% Total Rentals 1,200.00 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 9,108.05 45,845.17 14,287.85 60,133.02 71,554.78 11,421.76 84.04% 439001 - Other Contractual Services - 4,953.01 650.00 5,603.01 25,127.00 19,523.99 22.30% 439002 - Licenses & Permits - 1,812.74 - 1,812.74 1,953.00 140.26 92.82% 439004 - Dues & Memberships 105.00 873.00 - 873.00 4,460.00 3,587.00 19.57% 439005 - Bank & Credit Card Fees 883.61 28,173.80 - 28,173.80 36,325.00 8,151.20 77.56% 439006 - Education & Training 30.00 1,121.60 1,920.00 3,041.60 12,053.00 9,011.40 25.24% 439009 - Trash Removal 850.80 1,780.84 79.28 1,860.12 2,400.00 539.88 77.51% 439099 - Cashier Over/Short 10.00 (79.42) - (79.42) - 79.42 0.00% 439100 - Refunds/Awards/Indemnities 2,224.00 16,820.84 - 16,820.84 26,913.00 10,092.16 62.50% 439999 - Bad Debt Expense (57.00) - - - - - 0.00% Total Other Services & Charges 13,154.46 101,301.58 16,937.13 118,238.71 180,785.78 62,547.07 65.40% Total Services & Charges Expenditures 15,181.63 278,805.73 29,119.69 307,925.42 520,681.78 212,756.36 59.14% Other Uses 452002 - Allocations-Admin Cost 12,750.00 114,753.00 - 114,753.00 153,003.00 38,250.00 75.00% Total Other Uses 12,750.00 114,753.00 - 114,753.00 153,003.00 38,250.00 75.00% Total Expenditures 182,435.62 2,041,504.75 36,680.00 2,078,184.75 2,954,292.22 876,107.47 70.34%