Loading...
HomeMy WebLinkAboutAug 21 Fin 6South 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 8,796.70 56,410.07 20,000.00 (36,410.07) 282.05% 347002 - Picnic Site Rental 1,136.92 5,527.97 3,300.00 (2,227.97) 167.51% 347010 - Concession Sales 13,247.78 48,888.00 31,000.00 (17,888.00) 157.70% 347011 - Recreational Programming 34,375.89 288,655.25 300,500.00 11,844.75 96.06% 347013 - Nonalcoholic Beverage - - - - 0.00% 347016 - East Race Waterway 20,864.77 48,379.92 55,000.00 6,620.08 87.96% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 54.30% 347018 - Skate Rental - - - - 0.00% 347026 - Room Rental 6,089.95 45,611.53 9,000.00 (36,611.53) 506.79% 347030 - Merch Sales 332.64 1,272.95 2,500.00 1,227.05 50.92% 347040 - Pavilion Rental 4,502.56 29,538.04 22,446.00 (7,092.04) 131.60% 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 89,347.21 690,998.52 743,746.00 52,747.48 92.91% Total Charges for Services 89,347.21 690,998.52 743,746.00 52,747.48 92.91% Miscellaneous Revenue 360000 - Miscellaneous - 100.00 - (100.00) 0.00% 362000 - Rental of Property 10,831.50 57,910.25 60,000.00 2,089.75 96.52% Total Miscellaneous Revenue 10,831.50 58,010.25 60,000.00 1,989.75 96.68% Refunds & Reimbursements 380000 - Misc Reimbursements 19,946.25 62,020.73 35,396.00 (26,624.73) 175.22% 396000 - Refunds - 415.59 - (415.59) 0.00% Total Refunds & Reimbursements 19,946.25 62,436.32 35,396.00 (27,040.32) 176.39% Total Revenue 120,124.96 811,445.09 839,142.00 27,696.91 96.70% 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 69,974.93 630,917.34 - 630,917.34 867,406.00 236,488.66 72.74% 410003 - Permanent Part Time 19,700.15 120,351.25 - 120,351.25 260,255.00 139,903.75 46.24% 410004 - Extra & Overtime 1,063.34 3,337.42 - 3,337.42 5,639.00 2,301.58 59.18% 410005 - Seasonal & Interns 84,890.13 322,601.56 - 322,601.56 479,240.00 156,638.44 67.32% Total Salaries & Wages 175,628.55 1,077,207.57 - 1,077,207.57 1,612,540.00 535,332.43 66.80% Employee Benefits 411001 - FICA Regular 13,032.58 79,639.14 - 79,639.14 123,561.00 43,921.86 64.45% 411004 - PERF Regular 7,675.33 66,624.35 - 66,624.35 97,792.00 31,167.65 68.13% 411007 - Unemployment Comp 22.11 194.64 - 194.64 261.00 66.36 74.57% 411008 - Health Insurance 18,791.60 151,401.17 - 151,401.17 197,377.00 45,975.83 76.71% 411009 - Life Insurance 180.00 1,450.00 - 1,450.00 2,040.00 590.00 71.08% 411014 - Parental Leave 244.97 2,208.64 - 2,208.64 3,047.00 838.36 72.49% 411206 - Cell Phone Allowance 165.00 1,320.00 - 1,320.00 2,640.00 1,320.00 50.00% Total Employee Benefits 40,111.59 302,837.94 - 302,837.94 426,718.00 123,880.06 70.97% Total Personnel Expenditures 215,740.14 1,380,045.51 - 1,380,045.51 2,039,258.00 659,212.49 67.67% Supplies Expenditures August 31, 2021 Office Supplies 421000 - Other Office Supplies 111.84 1,146.21 - 1,146.21 1,948.00 801.79 58.84% 421002 - Stationary & Printing 1,463.13 2,528.57 207.64 2,736.21 6,349.00 3,612.79 43.10% Total Office Supplies 1,574.97 3,674.78 207.64 3,882.42 8,297.00 4,414.58 46.79% Operating Supplies 422000 - Other Operating Supplies 2,057.77 19,280.81 5,901.56 25,182.37 32,140.62 6,958.25 78.35% 422005 - Uniforms - 3,251.20 278.00 3,529.20 9,328.00 5,798.80 37.83% 422006 - Computer Supplies & Equipment - - - - 4,200.00 4,200.00 0.00% 422008 - Medical/Safety Supplies - 479.78 - 479.78 4,540.00 4,060.22 10.57% 422009 - Recreation Supplies 3,465.31 56,309.50 3,532.45 59,841.95 140,603.82 80,761.87 42.56% 422013 - Promotional Supplies 113.92 557.26 - 557.26 700.00 142.74 79.61% 422014 - Concessions Inventory 3,666.15 23,205.53 - 23,205.53 30,040.00 6,834.47 77.25% 422016 - Inventory For Sale 182.33 182.33 - 182.33 3,000.00 2,817.67 6.08% Total Operating Supplies 9,485.48 103,266.41 9,712.01 112,978.42 224,552.44 111,574.02 50.31% 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 11,060.45 113,396.52 9,919.65 123,316.17 241,349.44 118,033.27 51.09% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 12,077.69 46,793.71 354.00 47,147.71 77,839.00 30,691.29 60.57% Total Professional Services 12,077.69 46,793.71 354.00 47,147.71 77,839.00 30,691.29 60.57% Communication & Transportation 432002 - Mailing - 0.52 - 0.52 - (0.52) 0.00% 432003 - Travel - 439.40 3,850.08 4,289.48 16,810.00 12,520.52 25.52% 432005 - Mileage Reimb - - - - 6,494.00 6,494.00 0.00% Total Communication & Transportation - 439.92 3,850.08 4,290.00 23,304.00 19,014.00 18.41% 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 - 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 10.91 1,579.71 - 1,579.71 3,211.00 1,631.29 49.20% 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 7,241.66 36,737.12 14,325.30 51,062.42 61,336.78 10,274.36 83.25% 439001 - Other Contractual Services - 4,953.01 - 4,953.01 30,245.00 25,291.99 16.38% 439002 - Licenses & Permits - 1,812.74 - 1,812.74 1,953.00 140.26 92.82% 439004 - Dues & Memberships - 768.00 - 768.00 6,660.00 5,892.00 11.53% 439005 - Bank & Credit Card Fees 2,596.95 27,290.19 - 27,290.19 36,325.00 9,034.81 75.13% 439006 - Education & Training 30.00 1,091.60 1,190.00 2,281.60 12,053.00 9,771.40 18.93% 439009 - Trash Removal 79.26 930.04 465.02 1,395.06 2,400.00 1,004.94 58.13% 439099 - Cashier Over/Short 28.60 (89.42) - (89.42) - 89.42 0.00% 439100 - Refunds/Awards/Indemnities 2,457.36 14,596.84 - 14,596.84 30,113.00 15,516.16 48.47% 439999 - Bad Debt Expense - 57.00 - 57.00 - (57.00) 0.00% Total Other Services & Charges 12,433.83 88,147.12 15,980.32 104,127.44 181,085.78 76,958.34 57.50% Total Services & Charges Expenditures 24,522.43 263,624.10 24,957.16 288,581.26 520,681.78 232,100.52 55.42% Other Uses 452002 - Allocations-Admin Cost 12,750.00 102,003.00 - 102,003.00 153,003.00 51,000.00 66.67% Total Other Uses 12,750.00 102,003.00 - 102,003.00 153,003.00 51,000.00 66.67% Total Expenditures 264,073.02 1,859,069.13 34,876.81 1,893,945.94 2,954,292.22 1,060,346.28 64.11%