Loading...
HomeMy WebLinkAboutJuly 22 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 13,504.80 29,134.26 40,213.00 11,078.74 72.45% 347002 - Picnic Site Rental 522.04 2,946.64 - (2,946.64) 0.00% 347010 - Concession Sales 6,940.04 35,167.59 59,000.00 23,832.41 59.61% 347011 - Recreational Programming 30,932.34 280,081.86 465,565.00 185,483.14 60.16% 347016 - East Race Waterway 22,545.05 36,647.85 60,000.00 23,352.15 61.08% 347017 - Ice Skating - 197,057.38 300,000.00 102,942.62 65.69% 347026 - Room Rental 1,635.70 33,964.36 26,000.00 (7,964.36) 130.63% 347030 - Merch Sales 162.40 1,598.98 - (1,598.98) 0.00% 347040 - Pavilion Rental 4,087.92 25,171.75 15,000.00 (10,171.75) 167.81% Total Culture & Recreation 80,330.29 641,770.67 965,778.00 324,007.33 66.45% Total Charges for Services 80,330.29 641,770.67 965,778.00 324,007.33 66.45% Miscellaneous Revenue 362000 - Rental of Property 11,231.50 44,056.00 60,000.00 15,944.00 73.43% 367000 - Donations from Private Sources - 23,228.66 - (23,228.66) 0.00% Total Miscellaneous Revenue 11,231.50 67,284.66 60,000.00 (7,284.66) 112.14% Refunds & Reimbursements 380000 - Misc Reimbursements 123.91 3,094.32 3,527.00 432.68 87.73% Total Refunds & Reimbursements 123.91 3,094.32 3,527.00 432.68 87.73% Total Revenue 91,685.70 712,149.65 1,029,305.00 317,155.35 69.19% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 30,313.24 242,385.82 - 242,385.82 385,392.00 143,006.18 62.89% 410002 - Teamster Wages 6,053.20 64,136.97 - 64,136.97 110,309.00 46,172.03 58.14% 410003 - Permanent Part Time 12,023.00 53,870.44 - 53,870.44 232,406.00 178,535.56 23.18% 410004 - Extra & Overtime 2,067.75 10,970.61 - 10,970.61 16,000.00 5,029.39 68.57% 410005 - Seasonal & Interns 87,074.93 236,841.12 - 236,841.12 437,105.00 200,263.88 54.18% 410007 - Longevity Pay - 150.00 - 150.00 200.00 50.00 75.00% Total Salaries & Wages 137,532.12 608,354.96 - 608,354.96 1,181,412.00 573,057.04 51.49% Employee Benefits 411001 - FICA Regular 10,301.68 47,248.92 - 47,248.92 90,824.00 43,575.08 52.02% 411004 - PERF Regular 4,183.97 36,783.38 - 36,783.38 57,561.00 20,777.62 63.90% 411005 - PERF Union 47.78 409.93 - 409.93 3,000.00 2,590.07 13.66% 411007 - Unemployment Comp 61.92 474.03 - 474.03 819.00 344.97 57.88% 411008 - Health Insurance 11,331.66 81,208.04 - 81,208.04 135,554.00 54,345.96 59.91% 411009 - Life Insurance 100.00 715.00 - 715.00 1,200.00 485.00 59.58% 411014 - Parental Leave 132.02 1,100.29 - 1,100.29 1,791.00 690.71 61.43% 411203 - Job Readiness Allow. - 1,275.00 - 1,275.00 1,575.00 300.00 80.95% 411206 - Cell Phone Allowance 165.00 1,155.00 - 1,155.00 1,260.00 105.00 91.67% Total Employee Benefits 26,324.03 170,369.59 - 170,369.59 293,584.00 123,214.41 58.03% Total Personnel Expenses 163,856.15 778,724.55 - 778,724.55 1,474,996.00 696,271.45 52.80% Supplies Expenses Office Supplies July 31, 2022 421000 - General Office Supplies 48.28 656.25 - 656.25 1,700.00 1,043.75 38.60% Total Office Supplies 48.28 656.25 - 656.25 1,700.00 1,043.75 38.60% Operating Supplies 422000 - Other Operating Supplies 4,164.03 27,790.36 3,587.57 31,377.93 82,823.57 51,445.64 37.89% 422005 - Uniforms 545.00 4,912.00 - 4,912.00 12,800.00 7,888.00 38.38% 422007 - Cleaning Supplies - 19.46 - 19.46 2,400.00 2,380.54 0.81% 422008 - Medical/Safety Supplies - - - - 1,776.00 1,776.00 0.00% 422009 - Recreation Supplies 17,340.91 45,593.18 33,339.78 78,932.96 124,101.60 45,168.64 63.60% 422014 - Concessions Inventory 5,499.85 23,863.16 704.93 24,568.09 27,300.00 2,731.91 89.99% Total Operating Supplies 27,549.79 102,178.16 37,632.28 139,810.44 251,201.17 111,390.73 55.66% Repair & Maintenance Supplies 423000 - Other R&M Supplies 57.76 57.76 - 57.76 - (57.76) 0.00% Total Repair & Maintenance Supplies 57.76 57.76 - 57.76 - (57.76) 0.00% Total Supplies Expenses 27,655.83 102,892.17 37,632.28 140,524.45 252,901.17 112,376.72 55.56% Services & Charges Expenses Professional Services 431000 - Other Professional Services 16,626.38 42,758.36 2,022.34 44,780.70 53,207.00 8,426.30 84.16% Total Professional Services 16,626.38 42,758.36 2,022.34 44,780.70 53,207.00 8,426.30 84.16% Communication & Transportation 432003 - Travel - 547.94 2,451.58 2,999.52 11,000.00 8,000.48 27.27% 432005 - Mileage Reimb 112.35 415.67 293.00 708.67 2,305.00 1,596.33 30.74% Total Communication & Transportation 112.35 963.61 2,744.58 3,708.19 13,305.00 9,596.81 27.87% Printing & Advertising 433001 - Outside Printing Services 850.00 850.00 - 850.00 3,700.00 2,850.00 22.97% 433003 - Promotional 975.68 38,334.51 3,250.00 41,584.51 44,900.00 3,315.49 92.62% Total Printing & Advertising 1,825.68 39,184.51 3,250.00 42,434.51 48,600.00 6,165.49 87.31% Repairs & Maintenance 436000 - Other R&M 341.39 1,533.79 - 1,533.79 1,100.00 (433.79) 139.44% Total Repairs & Maintenance 341.39 1,533.79 - 1,533.79 1,100.00 (433.79) 139.44% Rentals 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 100.00% 437006 - Recreation Space Rental - 1,200.00 - 1,200.00 1,200.00 - 100.00% Total Rentals - 13,200.00 - 13,200.00 13,200.00 - 100.00% Debt Service 438100 - Principal - 116,167.18 - 116,167.18 175,649.19 59,482.01 66.14% 438200 - Interest - 9,193.45 - 9,193.45 14,986.81 5,793.36 61.34% Total Debt Service - 125,360.63 - 125,360.63 190,636.00 65,275.37 65.76% Other Charges & Services 439000 - Misc Charges & Svcs 7,429.67 61,109.51 19,086.51 80,196.02 93,430.10 13,234.08 85.84% 439001 - Other Contractual Services 2,693.99 3,613.39 - 3,613.39 3,500.00 (113.39) 103.24% 439002 - Licenses & Permits 1,063.38 5,431.58 - 5,431.58 6,545.00 1,113.42 82.99% 439004 - Dues & Memberships - 90.00 - 90.00 3,260.00 3,170.00 2.76% 439005 - Bank & Credit Card Fees 3,349.70 29,689.66 - 29,689.66 50,565.00 20,875.34 58.72% 439006 - Education & Training - 2,890.00 1,119.73 4,009.73 6,700.00 2,690.27 59.85% 439009 - Trash Removal - 14.85 - 14.85 504.95 490.10 2.94% 439099 - Cashier Over/Short (21.87) 1,098.98 - 1,098.98 2,300.00 1,201.02 47.78% 439100 - Refunds/Awards/Indemnities 585.10 10,654.29 - 10,654.29 19,555.00 8,900.71 54.48% Total Other Services & Charges 15,099.97 114,592.26 20,206.24 134,798.50 186,360.05 51,561.55 72.33% Total Services & Charges Expenses 34,005.77 337,593.16 28,223.16 365,816.32 506,408.05 140,591.73 72.24% Capital Outlay Machinery & Equipment 445003 - Park Equipment - - 19,750.00 19,750.00 - (19,750.00) 0.00% Total Machinery & Equipment - - 19,750.00 19,750.00 - (19,750.00) 0.00% Total Capital Expenses - - 19,750.00 19,750.00 - (19,750.00) 0.00% Other Uses 452002 - Allocations-Admin Cost 6,467.00 45,269.00 - 45,269.00 77,604.00 32,335.00 58.33% 452003 - Allocations-IT 14,069.17 98,484.15 - 98,484.15 168,830.00 70,345.85 58.33% Total Other Uses 20,536.17 143,753.15 - 143,753.15 246,434.00 102,680.85 58.33% Total Expenses 246,053.92 1,362,963.03 85,605.44 1,448,568.47 2,480,739.22 1,032,170.75 58.39%