Loading...
HomeMy WebLinkAboutMar 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 - - 33,766.00 33,766.00 100.00% 347002 - Picnic Site Rental 82.62 82.62 2,952.00 2,869.38 97.20% 347010 - Concession Sales 176.00 176.00 - (176.00) 0.00% 347011 - Recreational Programming 91,595.81 107,923.47 657,384.00 549,460.53 83.58% 347012 - Food Sales - - 25,939.00 25,939.00 100.00% 347013 - Nonalcoholic Beverage 12.67 201.46 12,820.00 12,618.54 98.43% 347016 - East Race Waterway - - 38,504.00 38,504.00 100.00% 347017 - Ice Skating 29,023.89 161,174.30 120,000.00 (41,174.30) (34.31%) 347018 - Skate Rental - 120.00 - (120.00) 0.00% 347026 - Room Rental 7,411.20 11,702.21 - (11,702.21) 0.00% 347030 - Merch Sales 159.05 679.00 - (679.00) 0.00% 347040 - Pavilion Rental 3,662.32 3,662.32 12,490.00 8,827.68 70.68% 347041 - Picnic Shelter - - 17,066.00 17,066.00 100.00% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347101 - Room Rental-Employee Discounts (71.46) (71.46) - 71.46 0.00% Total Culture & Recreation 132,052.10 289,537.87 920,921.00 631,383.13 68.56% Total Charges for Services 132,052.10 289,537.87 920,921.00 631,383.13 68.56% Miscellaneous Revenue 362000 - Rental of Property 5,415.75 25,615.75 - (25,615.75) 0.00% Total Miscellaneous Revenue 5,415.75 25,615.75 - (25,615.75) #DIV/0! Refunds & Reimbursements 380000 - Misc Reimbursements 25.00 9,567.27 - (9,567.27) 0.00% 396000 - Refunds 262.94 262.94 - (262.94) 0.00% Total Refunds & Reimbursements 287.94 9,830.21 - (9,830.21) 0.00% Total Revenue 137,755.79 324,983.83 920,921.00 595,937.17 64.71% 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 64,199.91 233,602.04 - 233,602.04 870,500.00 636,897.96 73.16% 410003 - Permanent Part Time 13,758.65 37,668.06 - 37,668.06 262,755.00 225,086.94 85.66% 410004 - Extra & Overtime 101.25 145.75 - 145.75 45.00 (100.75) (223.89%) 410005 - Seasonal & Interns 19,886.85 72,272.97 - 72,272.97 479,240.00 406,967.03 84.92% Total Salaries & Wages 97,946.66 343,688.82 - 343,688.82 1,612,540.00 1,268,851.18 78.69% Employee Benefits 411001 - FICA Regular 7,011.57 25,211.86 - 25,211.86 123,561.00 98,349.14 79.60% 411004 - PERF Regular 7,173.48 23,011.85 - 23,011.85 97,792.00 74,780.15 76.47% 411007 - Unemployment Comp 6.41 23.36 - 23.36 261.00 237.64 91.05% 411008 - Health Insurance 17,736.90 54,289.57 - 54,289.57 197,377.00 143,087.43 72.49% 411009 - Life Insurance 170.00 520.00 - 520.00 2,040.00 1,520.00 74.51% 411014 - Parental Leave 224.67 817.61 - 817.61 3,047.00 2,229.39 73.17% 411206 - Cell Phone Allowance 110.00 330.00 - 330.00 2,640.00 2,310.00 87.50% Total Employee Benefits 32,433.03 104,204.25 - 104,204.25 426,718.00 322,513.75 75.58% Total Personnel Expenditures 130,379.69 447,893.07 - 447,893.07 2,039,258.00 1,591,364.93 78.04% March 31, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 187.62 - 187.62 188.00 0.38 0.20% 421002 - Stationary & Printing 325.41 413.47 - 413.47 3,500.00 3,086.53 88.19% Total Office Supplies 325.41 601.09 - 601.09 3,688.00 3,086.91 83.70% Operating Supplies 422000 - Other Operating Supplies 1,394.37 5,923.19 5,699.11 11,622.30 27,384.62 15,762.32 57.56% 422005 - Uniforms 1,603.00 1,603.00 - 1,603.00 11,228.00 9,625.00 85.72% 422008 - Medical/Safety Supplies - - - - 5,090.00 5,090.00 100.00% 422009 - Recreation Supplies 4,853.81 19,993.35 414.04 20,407.39 157,958.82 137,551.43 87.08% 422014 - Concessions Inventory - - - - 31,000.00 31,000.00 100.00% 422016 - Inventory For Sale - - - - 3,000.00 3,000.00 100.00% Total Operating Supplies 7,851.18 27,519.54 6,113.15 33,632.69 235,661.44 202,028.75 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 8,176.59 28,120.63 6,113.15 34,233.78 241,349.44 207,115.66 85.82% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 5,564.44 11,823.01 2,217.09 14,040.10 133,481.00 119,440.90 89.48% Total Professional Services 5,564.44 11,823.01 2,217.09 14,040.10 133,481.00 119,440.90 89.48% 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 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 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 3,292.10 11,890.99 7,801.14 19,692.13 19,743.78 51.65 0.26% 439001 - Other Contractual Services 1,551.22 2,163.45 - 2,163.45 57,058.00 54,894.55 96.21% 439002 - Licenses & Permits 1,000.00 1,553.08 - 1,553.08 1,553.00 (0.08) (0.01%) 439004 - Dues & Memberships 418.00 418.00 - 418.00 6,660.00 6,242.00 93.72% 439005 - Bank & Credit Card Fees 6,184.66 15,033.16 - 15,033.16 8,000.00 (7,033.16) (87.91%) 439006 - Education & Training - - - - 13,000.00 13,000.00 100.00% 439099 - Cashier Over/Short 1.00 3.00 - 3.00 - (3.00) 0.00% 439100 - Refunds/Awards/Indemnities 1,585.87 3,552.37 - 3,552.37 15,000.00 11,447.63 76.32% Total Other Services & Charges 14,032.85 34,614.05 7,801.14 42,415.19 121,014.78 78,599.59 64.95% Total Services & Charges Expenditures 19,597.29 106,528.07 11,338.23 117,866.30 520,681.78 402,815.48 77.36% Other Uses 452002 - Allocations-Admin Cost 12,750.00 38,253.00 - 38,253.00 153,003.00 114,750.00 75.00% Total Other Uses 12,750.00 38,253.00 - 38,253.00 153,003.00 114,750.00 75.00% Total Expenditures 170,903.57 620,794.77 17,451.38 638,246.15 2,954,292.22 2,316,046.07 78.40%