Loading...
HomeMy WebLinkAboutApr 22 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 33% Parks General Fund: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Taxes Property Taxes 311000 - Civil City Property Taxes - - 10,580,413.00 10,580,413.00 0.00% Total Property Taxes - - 10,580,413.00 10,580,413.00 0.00% Total Taxes - - 10,580,413.00 10,580,413.00 0.00% Total Intergovernmental Revenue - - 953,848.00 953,848.00 0.00% Licenses & Permits Nonbusiness Licenses & Permits 322050 - Park Food Sales Permit 52.50 103.75 - (103.75) 0.00% Charges for Services Culture & Recreation 347001 - Swimming Pool - - 57,000.00 57,000.00 0.00% 347002 - Picnic Site Rental 235.56 336.60 - (336.60) 0.00% 347003 - Golf Season Pass 22,889.00 228,865.20 172,000.00 (56,865.20) 133.06% 347004 - Golf Green Fees 38,237.00 50,257.00 805,000.00 754,743.00 6.24% 347005 - Golf Cart Rentals 16,259.48 20,525.47 365,000.00 344,474.53 5.62% 347006 - Golf Pro Shop Retail 5,867.09 8,158.39 59,500.00 51,341.61 13.71% 347007 - Golf Driving Range 3,678.00 4,499.00 30,000.00 25,501.00 15.00% 347008 - Golf Gift Certificate - 35.00 - (35.00) 0.00% 347009 - Golf Outings 660.00 2,040.00 - (2,040.00) 0.00% 347010 - Concession Sales - 2,412.15 69,000.00 66,587.85 3.50% 347011 - Recreational Programming 51,913.73 184,778.57 594,565.00 409,786.43 31.08% 347012 - Food Sales 3,909.11 4,483.87 53,277.00 48,793.13 8.42% 347013 - Nonalcoholic Beverage 1,729.30 2,138.50 31,500.00 29,361.50 6.79% 347014 - Alcoholic Beverage Sales 8,309.81 9,681.21 110,900.00 101,218.79 8.73% 347015 - Lease of Stadium - - 75,000.00 75,000.00 0.00% 347016 - East Race Waterway 58.80 169.05 60,000.00 59,830.95 0.28% 347017 - Ice Skating 671.00 197,057.38 300,000.00 102,942.62 65.69% 347019 - Site Mowing - - 222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 2,605.68 52,120.46 120,000.00 67,879.54 43.43% 347026 - Room Rental 9,978.73 54,813.41 56,000.00 1,186.59 97.88% 347030 - Merch Sales (143.32) 937.22 - (937.22) 0.00% 347040 - Pavilion Rental 4,485.88 10,093.08 15,000.00 4,906.92 67.29% 347100 - Concessions-Employee Discounts (93.35) (111.70) - 111.70 0.00% Total Culture & Recreation 171,251.50 833,289.86 3,196,581.00 2,363,291.14 26.07% Total Charges for Services 171,251.50 833,289.86 3,196,581.00 2,363,291.14 26.07% Miscellaneous Revenue 360000 - Miscellaneous 63.50 5,527.55 9,500.00 3,972.45 58.18% 360001 - Sale of Scrap Metal - 211.75 - (211.75) 0.00% 361000 - Interest Earnings 951.25 6,551.29 50,000.00 43,448.71 13.10% 362000 - Rental of Property 100.00 21,863.00 60,000.00 38,137.00 36.44% 367000 - Donations from Private Sources - 480,828.93 1,000,000.00 519,171.07 48.08% Total Miscellaneous Revenue 1,114.75 514,982.52 1,119,500.00 604,517.48 46.00% Refunds & Reimbursements 380000 - Misc Reimbursements 5,648.44 17,766.95 - (17,766.95) 0.00% 380007 - Energy Rebates 808.98 808.98 - (808.98) 0.00% 381000 - Misc Reimbursements - 4,916.40 245,441.00 240,524.60 2.00% 396000 - Refunds 165.32 43,275.67 - (43,275.67) 0.00% Total Refunds & Reimbursements 6,622.74 66,768.00 245,441.00 178,673.00 27.20% Other Sources 391000 - Interfund Transfers In 9,935.00 39,741.00 119,221.00 79,480.00 33.33% 393000 - Capital Lease Proceeds - - 269,000.00 269,000.00 0.00% Total Other Sources 9,935.00 39,741.00 388,221.00 348,480.00 10.24% Total Revenue 188,976.49 1,454,885.13 16,484,004.00 15,029,118.87 8.83% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available April 30, 2022 Personnel Expenses Salaries & Wages 410001 - Salaried Wages 330,351.28 975,956.58 - 975,956.58 3,075,049.00 2,099,092.42 31.74% 410002 - Teamster Wages 159,247.49 498,773.05 - 498,773.05 1,555,675.00 1,056,901.95 32.06% 410003 - Permanent Part Time 85,417.79 192,389.84 - 192,389.84 981,395.00 789,005.16 19.60% 410004 - Extra & Overtime 8,261.61 32,182.70 - 32,182.70 58,850.00 26,667.30 54.69% 410005 - Seasonal & Interns 43,512.46 138,964.61 - 138,964.61 834,951.00 695,986.39 16.64% 410007 - Longevity Pay 1,700.00 4,195.83 - 4,195.83 8,050.00 3,854.17 52.12% 410014 - Contract Add Pays 604.92 604.92 - 604.92 - (604.92) 0.00% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 629,095.55 1,843,067.53 - 1,843,067.53 6,515,170.00 4,672,102.47 28.29% Employee Benefits 411001 - FICA Regular 46,902.79 150,829.66 - 150,829.66 501,390.00 350,560.34 30.08% 411004 - PERF Regular 53,824.30 179,149.29 - 179,149.29 530,630.00 351,480.71 33.76% 411005 - PERF Union 1,904.43 7,007.61 - 7,007.61 21,912.00 14,904.39 31.98% 411007 - Unemployment Comp 840.80 2,224.41 - 2,224.41 7,520.00 5,295.59 29.58% 411008 - Health Insurance 86,526.88 343,209.36 - 343,209.36 1,192,876.00 849,666.64 28.77% 411009 - Life Insurance 825.00 3,260.00 - 3,260.00 10,560.00 7,300.00 30.87% 411014 - Parental Leave 1,749.84 5,285.87 - 5,285.87 16,447.00 11,161.13 32.14% 411015 - Other Fringe Benefits - 1,490.00 - 1,490.00 1,500.00 10.00 99.33% 411201 - Tool Allowance 500.00 2,923.62 - 2,923.62 4,800.00 1,876.38 60.91% 411203 - Job Readiness Allow. - 14,875.00 - 14,875.00 19,425.00 4,550.00 76.58% 411204 - Auto Allowance 266.66 1,066.64 - 1,066.64 3,200.00 2,133.36 33.33% 411206 - Cell Phone Allowance 1,045.00 4,235.00 - 4,235.00 11,220.00 6,985.00 37.75% Total Employee Benefits 194,385.70 715,556.46 - 715,556.46 2,321,480.00 1,605,923.54 30.82% Total Personnel Expenses 823,481.25 2,558,623.99 - 2,558,623.99 8,836,650.00 6,278,026.01 28.95% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,088.17 5,676.04 157.18 5,833.22 23,579.18 17,745.96 24.74% Total Office Supplies 1,088.17 5,676.04 157.18 5,833.22 23,579.18 17,745.96 24.74% Operating Supplies 422000 - Other Operating Supplies 21,960.68 78,845.40 72,354.46 151,199.86 281,704.02 130,504.16 53.67% 422001 - C.S. Gasoline 16,851.17 62,190.83 - 62,190.83 165,000.00 102,809.17 37.69% 422002 - Diesel/CNG - - 1,886.00 1,886.00 4,000.00 2,114.00 47.15% 422003 - Gasoline 2,805.00 2,805.00 1,605.20 4,410.20 26,405.00 21,994.80 16.70% 422004 - Oil - 35.30 - 35.30 50.00 14.70 70.60% 422005 - Uniforms - 2,782.30 - 2,782.30 17,000.00 14,217.70 16.37% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 500.00 180.07 63.99% 422007 - Cleaning Supplies 12.57 15.25 - 15.25 2,450.00 2,434.75 0.62% 422008 - Medical/Safety Supplies 14.54 4,811.74 - 4,811.74 15,556.00 10,744.26 30.93% 422009 - Recreation Supplies 7,721.92 35,422.16 33,764.62 69,186.78 246,701.60 177,514.82 28.04% 422010 - Plants Chemicals Seed & Fertilizer 76,559.00 78,113.97 62,015.75 140,129.72 169,975.00 29,845.28 82.44% 422014 - Concessions Inventory 12,166.18 21,589.58 4,817.55 26,407.13 99,400.00 72,992.87 26.57% 422016 - Inventory For Sale 6,984.47 28,929.04 209.00 29,138.04 37,335.00 8,196.96 78.04% Total Operating Supplies 145,075.53 315,860.50 176,652.58 492,513.08 1,066,076.62 573,563.54 46.20% Repair & Maintenance Supplies 423000 - Other R&M Supplies 20,153.68 78,801.73 70,527.20 149,328.93 275,765.04 126,436.11 54.15% 423001 - Building Materials 1,514.14 25,701.12 - 25,701.12 90,000.00 64,298.88 28.56% 423006 - Small Tools & Equipment 1,489.82 7,488.54 300.07 7,788.61 25,573.00 17,784.39 30.46% 423009 - Repair Parts 11,132.52 26,197.96 683.63 26,881.59 82,329.03 55,447.44 32.65% Total Repair & Maintenance Supplies 34,290.16 138,189.35 71,510.90 209,700.25 473,667.07 263,966.82 44.27% Total Supplies Expenses 180,453.86 459,725.89 248,320.66 708,046.55 1,563,322.87 855,276.32 45.29% Services & Charges Expenses Professional Services 431000 - Other Professional Services 7,497.88 35,256.24 11,070.00 46,326.24 102,337.00 56,010.76 45.27% 431009 - Computer & Technology - 31.83 - 31.83 500.00 468.17 6.37% 431014 - Collection Costs 6.25 12.50 - 12.50 50.00 37.50 25.00% 431019 - Security Services 271.44 16,891.61 - 16,891.61 17,818.00 926.39 94.80% Total Professional Services 7,775.57 52,192.18 11,070.00 63,262.18 120,705.00 57,442.82 52.41% Communication & Transportation 432002 - Mailing 1.04 62.90 - 62.90 4,875.00 4,812.10 1.29% 432003 - Travel 494.23 2,294.36 3,414.65 5,709.01 29,550.00 23,840.99 19.32% 432004 - Telecommunications - 1,126.46 3,513.80 4,640.26 11,003.80 6,363.54 42.17% 432005 - Mileage Reimb - - 176.96 176.96 6,200.00 6,023.04 2.85% Total Communication & Transportation 495.27 3,483.72 7,105.41 10,589.13 51,628.80 41,039.67 20.51% Printing & Advertising 433001 - Outside Printing Services 4,298.50 4,508.50 2,969.75 7,478.25 30,280.00 22,801.75 24.70% 433002 - Publication of Legal Notice - 495.60 529.40 1,025.00 2,000.00 975.00 51.25% 433003 - Promotional 16,213.89 99,914.03 37,255.50 137,169.53 244,034.06 106,864.53 56.21% Total Printing & Advertising 20,512.39 104,918.13 40,754.65 145,672.78 276,314.06 130,641.28 52.72% Utilties 435001 - Electric 39,355.11 169,816.57 - 169,816.57 452,847.00 283,030.43 37.50% 435002 - Natural Gas 19,883.97 116,573.59 - 116,573.59 113,457.00 (3,116.59) 102.75% 435004 - Water 8,517.64 24,363.05 - 24,363.05 214,000.00 189,636.95 11.38% Total Utilities 67,756.72 310,753.21 - 310,753.21 780,304.00 469,550.79 39.82% Repairs & Maintenance 436000 - Other R&M 2,449.41 9,781.87 9,506.97 19,288.84 112,800.53 93,511.69 17.10% 436001 - Building R&M 15,287.07 55,648.89 96,146.72 151,795.61 181,994.82 30,199.21 83.41% 436003 - Auto Equip R&M 32,836.63 123,242.92 - 123,242.92 318,000.00 194,757.08 38.76% 436005 - Other Equip R&M - 524.70 - 524.70 1,000.00 475.30 52.47% 436006 - Radio Equip R&M 622.00 3,033.59 - 3,033.59 2,500.00 (533.59) 121.34% 436011 - Exterminating 279.00 2,768.00 1,394.00 4,162.00 13,334.00 9,172.00 31.21% Total Repairs & Maintenance 51,474.11 194,999.97 107,047.69 302,047.66 629,629.35 327,581.69 47.97% 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 - 53,977.13 - 53,977.13 291,946.00 237,968.87 18.49% 438200 - Interest - 6,671.16 - 6,671.16 29,076.00 22,404.84 22.94% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 5,000.00 600.00 88.00% Total Debt Service - 65,048.29 - 65,048.29 326,022.00 260,973.71 19.95% Other Charges & Services 439000 - Misc Charges & Svcs 6,635.07 90,771.98 165,617.07 256,389.05 726,277.29 469,888.24 35.30% 439001 - Other Contractual Services 90.00 649.99 - 649.99 2,300.00 1,650.01 28.26% 439002 - Licenses & Permits 200.00 9,731.04 - 9,731.04 12,025.00 2,293.96 80.92% 439003 - Subscriptions - 1,385.70 - 1,385.70 3,720.00 2,334.30 37.25% 439004 - Dues & Memberships 1,486.20 1,978.02 - 1,978.02 19,810.00 17,831.98 9.98% 439005 - Bank & Credit Card Fees 4,454.91 30,217.40 - 30,217.40 73,855.00 43,637.60 40.91% 439006 - Education & Training 555.00 8,445.77 2,075.00 10,520.77 23,125.00 12,604.23 45.50% 439009 - Trash Removal 1,852.78 16,573.35 19,927.45 36,500.80 44,934.41 8,433.61 81.23% 439012 - Uniform Services 2,051.22 5,602.30 - 5,602.30 4,200.00 (1,402.30) 133.39% 439018 - Demolition & Clearance - - 18,000.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (124.22) 1,419.79 - 1,419.79 2,300.00 880.21 61.73% 439100 - Refunds/Awards/Indemnities 1,950.59 8,414.22 - 8,414.22 29,010.00 20,595.78 29.00% 439300 - Grants & Subsidies - 365,000.00 350,000.00 715,000.00 715,000.00 - 100.00% Total Other Services & Charges 19,151.55 540,189.56 555,619.52 1,095,809.08 1,674,556.70 578,747.62 65.44% Total Services & Charges Expenses 167,165.61 1,284,785.06 721,597.27 2,006,382.33 3,872,359.91 1,865,977.58 51.81% Capital Outlay Buildings 443001 - Building Improvements - - 102,450.00 102,450.00 102,450.00 - 100.00% Total Buildings - - 102,450.00 102,450.00 102,450.00 - 100.00% 444000 - Land Improvements 80,550.00 177,994.88 270,617.82 448,612.70 1,294,470.49 845,857.79 34.66% Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment - - 108,002.34 108,002.34 686,027.50 578,025.16 15.74% 445100 - Lease Purchase/Motor Equip - - - - 269,000.00 269,000.00 0.00% Total Machinery & Equipment - 10,866.95 108,002.34 118,869.29 965,894.36 847,025.07 12.31% Total Capital Expenses 80,550.00 188,861.83 481,070.16 669,931.99 2,362,814.85 1,692,882.86 28.35% Other Uses 452002 - Allocations-Admin Cost 61,510.58 246,042.36 - 246,042.36 738,127.00 492,084.64 33.33% 452003 - Allocations-IT 57,450.84 229,803.28 - 229,803.28 689,410.00 459,606.72 33.33% 452004 - Allocations-Liability Insurance 24,384.42 97,537.64 - 97,537.64 292,613.00 195,075.36 33.33% 452008 - Allocations-Payroll Cost 6,895.25 27,581.00 - 27,581.00 82,743.00 55,162.00 33.33% 452009 - Allocations-Facilities Mgmt 2,296.25 9,185.00 - 9,185.00 27,555.00 18,370.00 33.33% Total Other Uses 152,537.34 610,149.28 - 610,149.28 1,830,448.00 1,220,298.72 33.33% Total Expenses 1,404,188.06 5,102,146.05 1,450,988.09 6,553,134.14 18,465,595.63 11,912,461.49 35.49%