Loading...
HomeMy WebLinkAboutJune 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 21,760.06 21,760.06 20,000.00 (1,760.06) 108.80% 347002 - Picnic Site Rental 1,310.25 3,599.57 3,300.00 (299.57) 109.08% 347010 - Concession Sales 12,487.65 22,570.96 31,000.00 8,429.04 72.81% 347011 - Recreational Programming 37,261.54 217,963.27 300,500.00 82,536.73 72.53% 347013 - Nonalcoholic Beverage - - - - 0.00% 347016 - East Race Waterway 8,680.55 9,835.55 55,000.00 45,164.45 17.88% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 54.30% 347018 - Skate Rental - - - - 0.00% 347026 - Room Rental 7,623.16 32,556.25 9,000.00 (23,556.25) 361.74% 347030 - Merch Sales 41.19 799.19 2,500.00 1,700.81 31.97% 347040 - Pavilion Rental 4,320.72 21,839.12 22,446.00 606.88 97.30% 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 93,485.12 497,638.76 743,746.00 246,107.24 66.91% Total Charges for Services 93,485.12 497,638.76 743,746.00 246,107.24 66.91% Miscellaneous Revenue 360000 - Miscellaneous 100.00 100.00 - (100.00) 0.00% 362000 - Rental of Property 10,831.50 47,078.75 60,000.00 12,921.25 78.46% Total Miscellaneous Revenue 10,931.50 47,178.75 60,000.00 12,821.25 78.63% Refunds & Reimbursements 380000 - Misc Reimbursements 15,895.00 32,033.46 35,396.00 3,362.54 90.50% 396000 - Refunds - 415.59 - (415.59) 0.00% Total Refunds & Reimbursements 15,895.00 32,449.05 35,396.00 2,946.95 91.67% Total Revenue 120,311.62 577,266.56 839,142.00 261,875.44 68.79% 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 93,671.13 491,028.48 - 491,028.48 867,756.00 376,727.52 56.59% 410003 - Permanent Part Time 15,958.27 82,360.65 - 82,360.65 262,755.00 180,394.35 31.35% 410004 - Extra & Overtime 1,642.55 1,788.30 - 1,788.30 2,789.00 1,000.70 64.12% 410005 - Seasonal & Interns 56,256.90 142,735.77 - 142,735.77 479,240.00 336,504.23 29.78% Total Salaries & Wages 167,528.85 717,913.20 - 717,913.20 1,612,540.00 894,626.80 44.52% Employee Benefits 411001 - FICA Regular 12,483.04 52,875.08 - 52,875.08 123,561.00 70,685.92 42.79% 411004 - PERF Regular 10,359.03 51,281.59 - 51,281.59 97,792.00 46,510.41 52.44% 411007 - Unemployment Comp 109.99 150.45 - 150.45 261.00 110.55 57.64% 411008 - Health Insurance 24,047.60 113,817.97 - 113,817.97 197,377.00 83,559.03 57.67% 411009 - Life Insurance 230.00 1,090.00 - 1,090.00 2,040.00 950.00 53.43% 411014 - Parental Leave 327.83 1,718.90 - 1,718.90 3,047.00 1,328.10 56.41% 411206 - Cell Phone Allowance 440.00 990.00 - 990.00 2,640.00 1,650.00 37.50% Total Employee Benefits 47,997.49 221,923.99 - 221,923.99 426,718.00 204,794.01 52.01% Total Personnel Expenditures 215,526.34 939,837.19 - 939,837.19 2,039,258.00 1,099,420.81 46.09% Supplies Expenditures June 30, 2021 Office Supplies 421000 - Other Office Supplies 475.10 921.01 - 921.01 220.00 (701.01) 418.64% 421002 - Stationary & Printing 410.82 943.86 133.30 1,077.16 6,050.00 4,972.84 17.80% Total Office Supplies 885.92 1,864.87 133.30 1,998.17 6,270.00 4,271.83 31.87% Operating Supplies 422000 - Other Operating Supplies 3,045.14 16,381.33 2,508.73 18,890.06 29,852.62 10,962.56 63.28% 422005 - Uniforms - 2,005.00 - 2,005.00 11,228.00 9,223.00 17.86% 422008 - Medical/Safety Supplies 93.96 479.78 - 479.78 4,540.00 4,060.22 10.57% 422009 - Recreation Supplies 6,954.95 44,767.29 1,192.24 45,959.53 153,458.82 107,499.29 29.95% 422013 - Promotional Supplies 443.34 443.34 - 443.34 - (443.34) 0.00% 422014 - Concessions Inventory 7,827.86 12,981.40 267.45 13,248.85 31,000.00 17,751.15 42.74% 422016 - Inventory For Sale - - - - 3,000.00 3,000.00 0.00% Total Operating Supplies 18,365.25 77,058.14 3,968.42 81,026.56 233,079.44 152,052.88 34.76% Repair & Maintenance Supplies 423000 - Other R&M Supplies 6,455.33 6,455.33 - 6,455.33 2,000.00 (4,455.33) 322.77% Total Repair & Maintenance Supplies 6,455.33 6,455.33 - 6,455.33 2,000.00 (4,455.33) 322.77% Total Supplies Expenditures 25,706.50 85,378.34 4,101.72 89,480.06 241,349.44 151,869.38 37.07% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 6,786.18 24,162.07 - 24,162.07 83,269.00 59,106.93 29.02% Total Professional Services 6,786.18 24,162.07 - 24,162.07 83,269.00 59,106.93 29.02% Communication & Transportation 432002 - Mailing 0.52 0.52 - 0.52 - (0.52) 0.00% 432003 - Travel - - - - 14,010.00 14,010.00 0.00% 432005 - Mileage Reimb - - - - 7,244.00 7,244.00 0.00% Total Communication & Transportation 0.52 0.52 - 0.52 21,254.00 21,253.48 0.00% Printing & Advertising 433001 - Outside Printing Services 1,240.89 3,343.10 - 3,343.10 21,106.00 17,762.90 15.84% 433003 - Promotional - - - - 10,700.00 10,700.00 0.00% Total Printing & Advertising 1,240.89 3,343.10 - 3,343.10 31,806.00 28,462.90 10.51% Repairs & Maintenance 436001 - Building R&M - 1,568.80 - 1,568.80 1,600.00 31.20 98.05% Total Repairs & Maintenance - 1,568.80 - 1,568.80 1,600.00 31.20 98.05% Rentals 437002 - Equipment Rental - - - - 1,200.00 1,200.00 0.00% 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 100.00% 437006 - Recreation Space Rental - - 700.00 700.00 700.00 - 100.00% Total Rentals - 12,000.00 700.00 12,700.00 13,900.00 1,200.00 91.37% 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,598.57 25,618.48 13,494.20 39,112.68 53,597.78 14,485.10 72.97% 439001 - Other Contractual Services 600.00 4,503.01 - 4,503.01 39,315.00 34,811.99 11.45% 439002 - Licenses & Permits - 1,812.74 - 1,812.74 1,553.00 (259.74) 116.73% 439004 - Dues & Memberships 75.00 553.00 - 553.00 6,660.00 6,107.00 8.30% 439005 - Bank & Credit Card Fees 3,147.25 21,756.07 - 21,756.07 35,975.00 14,218.93 60.48% 439006 - Education & Training - - - - 12,703.00 12,703.00 0.00% 439009 - Trash Removal - - 385.78 385.78 2,400.00 2,014.22 16.07% 439099 - Cashier Over/Short 18.42 4.80 - 4.80 - (4.80) 0.00% 439100 - Refunds/Awards/Indemnities 2,228.38 8,420.26 - 8,420.26 26,013.00 17,592.74 32.37% Total Other Services & Charges 15,667.62 62,668.36 13,879.98 76,548.34 178,216.78 101,668.44 42.95% Total Services & Charges Expenditures 23,695.21 214,977.39 14,579.98 229,557.37 520,681.78 291,124.41 44.09% Other Uses 452002 - Allocations-Admin Cost 12,750.00 76,503.00 - 76,503.00 153,003.00 76,500.00 50.00% Total Other Uses 12,750.00 76,503.00 - 76,503.00 153,003.00 76,500.00 50.00% Total Expenditures 277,678.05 1,316,695.92 18,681.70 1,335,377.62 2,954,292.22 1,618,914.60 45.20%