Loading...
HomeMy WebLinkAboutApr 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 - - 20,000.00 20,000.00 100.00% 347002 - Picnic Site Rental 1,533.10 1,615.72 3,300.00 1,684.28 51.04% 347010 - Concession Sales 929.13 1,105.13 31,000.00 29,894.87 96.44% 347011 - Recreational Programming 38,120.94 146,044.41 300,500.00 154,455.59 51.40% 347013 - Nonalcoholic Beverage (201.46) - - - 0.00% 347016 - East Race Waterway - - 55,000.00 55,000.00 100.00% 347017 - Ice Skating 1,724.00 162,898.30 300,000.00 137,101.70 45.70% 347018 - Skate Rental (120.00) - - - 0.00% 347026 - Room Rental 4,725.40 16,427.61 9,000.00 (7,427.61) (82.53%) 347030 - Merch Sales 64.00 743.00 2,500.00 1,757.00 70.28% 347040 - Pavilion Rental 6,340.28 10,002.60 22,446.00 12,443.40 55.44% 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 53,115.39 342,653.26 743,746.00 401,092.74 53.93% Total Charges for Services 53,115.39 342,653.26 743,746.00 401,092.74 53.93% Miscellaneous Revenue 362000 - Rental of Property 5,215.75 30,831.50 60,000.00 29,168.50 48.61% Total Miscellaneous Revenue 5,215.75 30,831.50 60,000.00 29,168.50 48.61% Refunds & Reimbursements 380000 - Misc Reimbursements 1,177.19 10,744.46 - (10,744.46) 0.00% 396000 - Refunds - 262.94 - (262.94) 0.00% Total Refunds & Reimbursements 1,177.19 11,007.40 - (11,007.40) 0.00% Total Revenue 59,508.33 384,492.16 803,746.00 419,253.84 52.16% 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 98,151.25 331,753.29 - 331,753.29 870,500.00 538,746.71 61.89% 410003 - Permanent Part Time 16,952.93 54,620.99 - 54,620.99 262,755.00 208,134.01 79.21% 410004 - Extra & Overtime - 145.75 - 145.75 45.00 (100.75) (223.89%) 410005 - Seasonal & Interns 5,201.06 77,474.03 - 77,474.03 479,240.00 401,765.97 83.83% Total Salaries & Wages 120,305.24 463,994.06 - 463,994.06 1,612,540.00 1,148,545.94 71.23% Employee Benefits 411001 - FICA Regular 8,887.38 34,099.24 - 34,099.24 123,561.00 89,461.76 72.40% 411004 - PERF Regular 10,733.77 33,745.62 - 33,745.62 97,792.00 64,046.38 65.49% 411007 - Unemployment Comp 10.18 33.54 - 33.54 261.00 227.46 87.15% 411008 - Health Insurance 17,740.40 72,029.97 - 72,029.97 197,377.00 125,347.03 63.51% 411009 - Life Insurance 170.00 690.00 - 690.00 2,040.00 1,350.00 66.18% 411014 - Parental Leave 343.61 1,161.22 - 1,161.22 3,047.00 1,885.78 61.89% 411206 - Cell Phone Allowance 110.00 440.00 - 440.00 2,640.00 2,200.00 83.33% Total Employee Benefits 37,995.34 142,199.59 - 142,199.59 426,718.00 284,518.41 66.68% Total Personnel Expenditures 158,300.58 606,193.65 - 606,193.65 2,039,258.00 1,433,064.35 70.27% Supplies Expenditures Office Supplies April 30, 2021 421000 - Other Office Supplies 258.29 445.91 - 445.91 188.00 (257.91) (137.19%) 421002 - Stationary & Printing 70.00 483.47 - 483.47 3,500.00 3,016.53 86.19% Total Office Supplies 328.29 929.38 - 929.38 3,688.00 2,758.62 74.80% Operating Supplies 422000 - Other Operating Supplies 4,888.84 10,812.03 2,478.53 13,290.56 27,384.62 14,094.06 51.47% 422005 - Uniforms - 1,603.00 - 1,603.00 11,228.00 9,625.00 85.72% 422008 - Medical/Safety Supplies 50.15 50.15 - 50.15 5,090.00 5,039.85 99.01% 422009 - Recreation Supplies 13,090.26 33,083.61 908.26 33,991.87 157,958.82 123,966.95 78.48% 422014 - Concessions Inventory 2,309.02 2,309.02 - 2,309.02 31,000.00 28,690.98 92.55% 422016 - Inventory For Sale - - - - 3,000.00 3,000.00 100.00% Total Operating Supplies 20,338.27 47,857.81 3,386.79 51,244.60 235,661.44 184,416.84 43.98% Repair & Maintenance Supplies 423000 - Other R&M Supplies - - - - 2,000.00 2,000.00 100.00% Total Repair & Maintenance Supplies - - - - 2,000.00 2,000.00 100.00% Total Supplies Expenditures 20,666.56 48,787.19 3,386.79 52,173.98 241,349.44 189,175.46 78.38% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 3,862.09 15,685.10 1,004.00 16,689.10 133,481.00 116,791.90 87.50% Total Professional Services 3,862.09 15,685.10 1,004.00 16,689.10 133,481.00 116,791.90 87.50% Communication & Transportation 432003 - Travel - - - - 18,000.00 18,000.00 100.00% 432005 - Mileage Reimb - - - - 9,244.00 9,244.00 100.00% Total Communication & Transportation - - - - 27,244.00 27,244.00 100.00% Printing & Advertising 433001 - Outside Printing Services 620.00 620.00 - 620.00 21,106.00 20,486.00 97.06% 433003 - Promotional - - - - 11,700.00 11,700.00 100.00% Total Printing & Advertising 620.00 620.00 - 620.00 32,806.00 32,186.00 98.11% Repairs & Maintenance 436001 - Building R&M - 1,568.80 - 1,568.80 1,600.00 31.20 1.95% Total Repairs & Maintenance - 1,568.80 - 1,568.80 1,600.00 31.20 0.00% Rentals 437002 - Equipment Rental - - - - 1,200.00 1,200.00 100.00% 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 0.00% 437006 - Recreation Space Rental - - 700.00 700.00 700.00 - 0.00% Total Rentals - 12,000.00 700.00 12,700.00 13,900.00 1,200.00 8.63% Debt Service 438100 - Principal - 38,720.41 - 38,720.41 167,118.00 128,397.59 76.83% 438200 - Interest - 7,801.80 - 7,801.80 23,518.00 15,716.20 66.83% Total Debt Service - 46,522.21 - 46,522.21 190,636.00 144,113.79 75.60% Other Charges & Services 439000 - Misc Charges & Svcs 1,159.28 13,050.27 8,721.86 21,772.13 19,743.78 (2,028.35) (10.27%) 439001 - Other Contractual Services 1,164.56 3,328.01 250.00 3,578.01 57,058.00 53,479.99 93.73% 439002 - Licenses & Permits 259.66 1,812.74 - 1,812.74 1,553.00 (259.74) (16.73%) 439004 - Dues & Memberships - 418.00 - 418.00 6,660.00 6,242.00 93.72% 439005 - Bank & Credit Card Fees 1,696.63 16,729.79 - 16,729.79 8,000.00 (8,729.79) (109.12%) 439006 - Education & Training - - - - 13,000.00 13,000.00 100.00% 439099 - Cashier Over/Short - 3.00 - 3.00 - (3.00) 0.00% 439100 - Refunds/Awards/Indemnities 583.84 4,136.21 - 4,136.21 15,000.00 10,863.79 72.43% Total Other Services & Charges 4,863.97 39,478.02 8,971.86 48,449.88 121,014.78 72,564.90 59.96% Total Services & Charges Expenditures 9,346.06 115,874.13 10,675.86 126,549.99 520,681.78 394,131.79 75.70% Other Uses 452002 - Allocations-Admin Cost 12,750.00 51,003.00 - 51,003.00 153,003.00 102,000.00 66.67% Total Other Uses 12,750.00 51,003.00 - 51,003.00 153,003.00 102,000.00 66.67% Total Expenditures 201,063.20 821,857.97 14,062.65 835,920.62 2,954,292.22 2,118,371.60 71.70%