Loading...
HomeMy WebLinkAboutMay 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 673.60 2,289.32 3,300.00 1,010.68 30.63% 347010 - Concession Sales 8,978.18 10,083.31 31,000.00 20,916.69 67.47% 347011 - Recreational Programming 34,657.32 180,701.73 300,500.00 119,798.27 39.87% 347013 - Nonalcoholic Beverage - - - - 0.00% 347016 - East Race Waterway 1,155.00 1,155.00 55,000.00 53,845.00 97.90% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 45.70% 347018 - Skate Rental - - - - 0.00% 347026 - Room Rental 8,505.48 24,933.09 9,000.00 (15,933.09) (177.03%) 347030 - Merch Sales 15.00 758.00 2,500.00 1,742.00 69.68% 347040 - Pavilion Rental 7,515.80 17,518.40 22,446.00 4,927.60 21.95% 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 61,500.38 404,153.64 743,746.00 339,592.36 45.66% Total Charges for Services 61,500.38 404,153.64 743,746.00 339,592.36 45.66% Miscellaneous Revenue 362000 - Rental of Property 5,415.75 36,247.25 60,000.00 23,752.75 39.59% Total Miscellaneous Revenue 5,415.75 36,247.25 60,000.00 23,752.75 39.59% Refunds & Reimbursements 380000 - Misc Reimbursements 5,394.00 16,138.46 - (16,138.46) 0.00% 396000 - Refunds 152.65 415.59 - (415.59) 0.00% Total Refunds & Reimbursements 5,546.65 16,554.05 - (16,554.05) 0.00% Total Revenue 72,462.78 456,954.94 803,746.00 346,791.06 43.15% 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 65,604.06 397,357.35 - 397,357.35 870,500.00 473,142.65 54.35% 410003 - Permanent Part Time 11,781.39 66,402.38 - 66,402.38 262,755.00 196,352.62 74.73% 410004 - Extra & Overtime - 145.75 - 145.75 45.00 (100.75) (223.89%) 410005 - Seasonal & Interns 9,004.84 86,478.87 - 86,478.87 479,240.00 392,761.13 81.95% Total Salaries & Wages 86,390.29 550,384.35 - 550,384.35 1,612,540.00 1,062,155.65 65.87% Employee Benefits 411001 - FICA Regular 6,292.80 40,392.04 - 40,392.04 123,561.00 83,168.96 67.31% 411004 - PERF Regular 7,176.94 40,922.56 - 40,922.56 97,792.00 56,869.44 58.15% 411007 - Unemployment Comp 6.92 40.46 - 40.46 261.00 220.54 84.50% 411008 - Health Insurance 17,740.40 89,770.37 - 89,770.37 197,377.00 107,606.63 54.52% 411009 - Life Insurance 170.00 860.00 - 860.00 2,040.00 1,180.00 57.84% 411014 - Parental Leave 229.85 1,391.07 - 1,391.07 3,047.00 1,655.93 54.35% 411206 - Cell Phone Allowance 110.00 550.00 - 550.00 2,640.00 2,090.00 79.17% Total Employee Benefits 31,726.91 173,926.50 - 173,926.50 426,718.00 252,791.50 59.24% Total Personnel Expenditures 118,117.20 724,310.85 - 724,310.85 2,039,258.00 1,314,947.15 64.48% Supplies Expenditures Office Supplies May 31, 2021 421000 - Other Office Supplies - 445.91 - 445.91 220.00 (225.91) (102.69%) 421002 - Stationary & Printing 49.57 533.04 - 533.04 4,500.00 3,966.96 88.15% Total Office Supplies 49.57 978.95 - 978.95 4,720.00 3,741.05 79.26% Operating Supplies 422000 - Other Operating Supplies 2,524.16 13,336.19 3,391.51 16,727.70 28,852.62 12,124.92 42.02% 422005 - Uniforms 402.00 2,005.00 - 2,005.00 11,228.00 9,223.00 82.14% 422008 - Medical/Safety Supplies 335.67 385.82 - 385.82 5,090.00 4,704.18 92.42% 422009 - Recreation Supplies 4,728.73 37,812.34 1,499.50 39,311.84 155,458.82 116,146.98 74.71% 422014 - Concessions Inventory 2,844.52 5,153.54 - 5,153.54 31,000.00 25,846.46 83.38% 422016 - Inventory For Sale - - - - 3,000.00 3,000.00 100.00% Total Operating Supplies 10,835.08 58,692.89 4,891.01 63,583.90 234,629.44 171,045.54 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 10,884.65 59,671.84 4,891.01 64,562.85 241,349.44 176,786.59 73.25% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,690.79 17,375.89 4,668.00 22,043.89 113,647.00 91,603.11 80.60% Total Professional Services 1,690.79 17,375.89 4,668.00 22,043.89 113,647.00 91,603.11 80.60% Communication & Transportation 432003 - Travel - - - - 17,400.00 17,400.00 100.00% 432005 - Mileage Reimb - - - - 7,844.00 7,844.00 100.00% Total Communication & Transportation - - - - 25,244.00 25,244.00 100.00% Printing & Advertising 433001 - Outside Printing Services 1,482.21 2,102.21 620.00 2,722.21 21,106.00 18,383.79 87.10% 433003 - Promotional - - - - 11,700.00 11,700.00 100.00% Total Printing & Advertising 1,482.21 2,102.21 620.00 2,722.21 32,806.00 30,083.79 91.70% 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 60,388.70 99,109.11 - 99,109.11 167,118.00 68,008.89 40.70% 438200 - Interest 4,323.63 12,125.43 - 12,125.43 23,518.00 11,392.57 48.44% Total Debt Service 64,712.33 111,234.54 - 111,234.54 190,636.00 79,401.46 41.65% Other Charges & Services 439000 - Misc Charges & Svcs 2,969.64 16,019.91 15,341.44 31,361.35 42,782.78 11,421.43 26.70% 439001 - Other Contractual Services 575.00 3,903.01 600.00 4,503.01 50,853.00 46,349.99 91.15% 439002 - Licenses & Permits - 1,812.74 - 1,812.74 1,553.00 (259.74) (16.73%) 439004 - Dues & Memberships 60.00 478.00 - 478.00 6,660.00 6,182.00 92.82% 439005 - Bank & Credit Card Fees 1,879.03 18,608.82 - 18,608.82 13,000.00 (5,608.82) (43.14%) 439006 - Education & Training - - - - 13,000.00 13,000.00 100.00% 439099 - Cashier Over/Short (16.62) (13.62) - (13.62) - 13.62 0.00% 439100 - Refunds/Awards/Indemnities 2,055.67 6,191.88 - 6,191.88 15,000.00 8,808.12 58.72% Total Other Services & Charges 7,522.72 47,000.74 15,941.44 62,942.18 142,848.78 79,906.60 55.94% Total Services & Charges Expenditures 75,408.05 191,282.18 21,929.44 213,211.62 520,681.78 307,470.16 59.05% Other Uses 452002 - Allocations-Admin Cost 12,750.00 63,753.00 - 63,753.00 153,003.00 89,250.00 58.33% Total Other Uses 12,750.00 63,753.00 - 63,753.00 153,003.00 89,250.00 58.33% Total Expenditures 217,159.90 1,039,017.87 26,820.45 1,065,838.32 2,954,292.22 1,888,453.90 63.92%