Loading...
HomeMy WebLinkAboutSept 21 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 75% 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 - 5,705,124.46 9,247,389.00 3,542,264.54 61.69% Total Property Taxes - 5,705,124.46 9,247,389.00 3,542,264.54 61.69% Total Taxes - 5,705,124.46 9,247,389.00 3,542,264.54 61.69% State Shared Revenue 335002 - Vehicle/Aircraft Excise - 376,063.14 752,272.00 376,208.86 49.99% 335007 - Commercial Vehicle Excise - 85,147.87 154,422.00 69,274.13 55.14% Total State Shared Revenue - 461,211.01 906,694.00 445,482.99 50.87% Total Intergovernmental Revenue - 661,211.01 1,106,694.00 445,482.99 59.75% Total Nonbusiness Licenses & Permits 30.00 174.25 58.00 (116.25) 300.43% Total Licenses & Permits 30.00 174.25 58.00 (116.25) 300.43% Charges for Services Culture & Recreation 347001 - Swimming Pool - 56,410.07 20,000.00 (36,410.07) 282.05% 347002 - Picnic Site Rental 437.80 5,965.77 3,300.00 (2,665.77) 180.78% 347003 - Golf Season Pass 118.00 218,202.77 93,000.00 (125,202.77) 234.63% 347004 - Golf Green Fees 120,111.92 725,812.45 795,000.00 69,187.55 91.30% 347005 - Golf Cart Rentals 51,942.38 341,285.43 360,000.00 18,714.57 94.80% 347006 - Golf Pro Shop Retail 9,144.70 68,470.87 59,500.00 (8,970.87) 115.08% 347007 - Golf Driving Range 4,762.00 31,177.97 30,000.00 (1,177.97) 103.93% 347008 - Golf Gift Certificate - 5.00 - (5.00) 0.00% 347010 - Concession Sales 2,798.81 51,686.81 31,000.00 (20,686.81) 166.73% 347011 - Recreational Programming 15,349.63 313,847.95 361,500.00 47,652.05 86.82% 347012 - Food Sales 11,398.38 60,621.21 53,277.00 (7,344.21) 113.78% 347013 - Nonalcoholic Beverage 5,951.78 37,488.33 33,398.00 (4,090.33) 112.25% 347014 - Alcoholic Beverage Sales 23,093.56 132,370.04 110,000.00 (22,370.04) 120.34% 347015 - Lease of Stadium 15,000.00 115,000.00 75,000.00 (40,000.00) 153.33% 347016 - East Race Waterway 3,520.50 51,900.42 55,000.00 3,099.58 94.36% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 54.30% 347018 - Skate Rental - - - - 0.00% 347019 - Site Mowing - 1,227.59 95,000.00 93,772.41 1.29% 347021 - Tree Maintenance 31,206.52 97,557.76 120,000.00 22,442.24 81.30% 347023 - Graffiti Removal - 1,482.15 102,529.00 101,046.85 1.45% 347026 - Room Rental 4,963.08 52,424.61 9,000.00 (43,424.61) 582.50% 347030 - Merch Sales 254.24 1,527.19 2,500.00 972.81 61.09% 347040 - Pavilion Rental 2,200.84 31,738.88 22,446.00 (9,292.88) 141.40% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347100 - Concessions-Employee Discounts (386.10) (3,182.53) - 3,182.53 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 301,868.04 2,559,735.53 2,731,450.00 171,714.47 93.71% Total Charges for Services 301,868.04 2,559,735.53 2,731,450.00 171,714.47 93.71% Fines, Forefeitures, Fees 351002 - Bad Checks Fines 12.00 12.00 - (12.00) 0.00% Total Fines, Forfeitures, Fees 12.00 12.00 - (12.00) 0.00% Miscellaneous Revenue 360000 - Miscellaneous 254.67 3,635.19 25,000.00 21,364.81 14.54% 360001 - Sale of Scrap Metal 180.89 1,016.98 - (1,016.98) 0.00% 361000 - Interest Earnings 1,556.60 18,980.52 40,000.00 21,019.48 47.45% 362000 - Rental of Property - 57,910.25 60,000.00 2,089.75 96.52% 367000 - Donations from Private Sources - 776,029.00 1,805,000.00 1,028,971.00 42.99% Total Miscellaneous Revenue 1,992.16 857,571.94 1,930,000.00 1,072,428.06 44.43% Refunds & Reimbursements 380000 - Misc Reimbursements (38,280.00) 27,647.42 38,572.00 10,924.58 71.68% 380007 - Energy Rebates - 962.27 - (962.27) 0.00% 396000 - Refunds - 6,287.91 5,267.00 (1,020.91) 119.38% Total Refunds & Reimbursements (38,280.00) 34,897.60 43,839.00 8,941.40 79.60% September 30, 2021 Other Sources 391000 - Interfund Transfers In 102,711.00 924,408.00 1,234,486.00 310,078.00 74.88% 392000 - Gain/Loss on Sale of Asset - 17,250.00 - (17,250.00) 0.00% Total Other Sources 102,711.00 941,658.00 1,234,486.00 292,828.00 76.28% Total Revenue 368,333.20 10,760,384.79 16,293,916.00 5,533,531.21 66.04% 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 206,497.29 2,074,012.23 - 2,074,012.23 2,675,115.00 601,102.77 77.53% 410002 - Teamster Wages 108,481.98 1,066,173.76 - 1,066,173.76 1,397,385.00 331,211.24 76.30% 410003 - Permanent Part Time 69,695.53 539,415.39 - 539,415.39 767,427.00 228,011.61 70.29% 410004 - Extra & Overtime 10,282.14 82,782.20 - 82,782.20 100,241.00 17,458.80 82.58% 410005 - Seasonal & Interns 49,885.90 581,077.15 - 581,077.15 879,983.00 298,905.85 66.03% 410007 - Longevity Pay 700.00 6,650.00 - 6,650.00 8,050.00 1,400.00 82.61% 410014 - Contract Add Pays 340.04 340.04 - 340.04 1,000.00 659.96 34.00% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 445,882.88 4,350,450.77 - 4,350,450.77 5,830,401.00 1,479,950.23 74.62% Employee Benefits 411001 - FICA Regular 33,280.08 325,980.76 - 325,980.76 449,080.00 123,099.24 72.59% 411004 - PERF Regular 36,236.56 354,842.83 - 354,842.83 489,666.00 134,823.17 72.47% 411005 - PERF Union 1,408.63 13,655.44 - 13,655.44 22,866.00 9,210.56 59.72% 411007 - Unemployment Comp 103.32 1,000.23 - 1,000.23 1,278.00 277.77 78.27% 411008 - Health Insurance 85,766.62 790,122.25 - 790,122.25 988,554.00 198,431.75 79.93% 411009 - Life Insurance 855.00 7,800.00 - 7,800.00 10,320.00 2,520.00 75.58% 411014 - Parental Leave 1,139.98 11,269.21 - 11,269.21 15,159.00 3,889.79 74.34% 411015 - Other Fringe Benefits - 1,600.00 - 1,600.00 1,600.00 - 100.00% 411201 - Tool Allowance - 988.03 - 988.03 3,200.00 2,211.97 30.88% 411203 - Job Readiness Allow. - 15,300.00 - 15,300.00 15,300.00 - 100.00% 411204 - Auto Allowance 266.66 2,399.94 - 2,399.94 3,200.00 800.06 75.00% 411206 - Cell Phone Allowance 1,100.00 10,560.00 - 10,560.00 17,820.00 7,260.00 59.26% Total Employee Benefits 160,156.85 1,535,518.69 - 1,535,518.69 2,018,043.00 482,524.31 76.09% Total Personnel Expenditures 606,039.73 5,885,969.46 - 5,885,969.46 7,848,444.00 1,962,474.54 75.00% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 97.89 4,888.23 - 4,888.23 5,182.89 294.66 94.31% 421002 - Stationary & Printing 1,390.63 8,382.90 108.33 8,491.23 24,354.00 15,862.77 34.87% Total Office Supplies 1,488.52 13,271.13 108.33 13,379.46 29,536.89 16,157.43 45.30% Operating Supplies 422000 - Other Operating Supplies 25,895.17 273,986.04 29,451.68 303,437.72 292,197.78 (11,239.94) 103.85% 422001 - C.S. Gasoline 15,971.65 120,859.46 - 120,859.46 160,271.00 39,411.54 75.41% 422002 - Diesel/CNG - 8,199.94 1,500.00 9,699.94 10,947.00 1,247.06 88.61% 422003 - Gasoline 2,334.80 8,436.88 - 8,436.88 12,961.00 4,524.12 65.09% 422005 - Uniforms 519.81 5,319.92 142.50 5,462.42 12,528.00 7,065.58 43.60% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 4,520.00 4,200.07 7.08% 422007 - Cleaning Supplies 77.14 1,217.11 - 1,217.11 1,433.00 215.89 84.93% 422008 - Medical/Safety Supplies 642.53 17,686.92 645.00 18,331.92 21,087.19 2,755.27 86.93% 422009 - Recreation Supplies 29,299.01 138,401.43 17,970.48 156,371.91 283,259.82 126,887.91 55.20% 422010 - Plants Chemicals Seed & Fertilizer 3,627.53 106,482.00 25,675.78 132,157.78 153,728.77 21,570.99 85.97% 422013 - Promotional Supplies - 3,684.89 - 3,684.89 6,629.00 2,944.11 55.59% 422014 - Concessions Inventory 7,948.62 92,696.03 12,292.14 104,988.17 94,088.00 (10,900.17) 111.59% 422016 - Inventory For Sale - 34,644.64 7,912.08 42,556.72 44,905.00 2,348.28 94.77% Total Operating Supplies 86,316.26 811,935.19 95,589.66 907,524.85 1,098,555.56 191,030.71 82.61% Repair & Maintenance Supplies 423000 - Other R&M Supplies 21,721.86 115,602.99 25,046.40 140,649.39 246,205.86 105,556.47 57.13% 423001 - Building Materials 1,078.16 26,571.87 9,285.40 35,857.27 67,757.51 31,900.24 52.92% 423006 - Small Tools & Equipment 1,815.24 51,781.09 2,966.75 54,747.84 56,748.00 2,000.16 96.48% 423009 - Repair Parts 8,225.95 48,688.61 16,133.29 64,821.90 76,511.53 11,689.63 84.72% Total Repair & Maintenance Supplies 32,841.21 242,644.56 53,431.84 296,076.40 447,222.90 151,146.50 66.20% Total Supplies Expenditures 120,645.99 1,067,850.88 149,129.83 1,216,980.71 1,575,315.35 358,334.64 77.25% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,964.04 69,416.53 36,135.31 105,551.84 132,021.96 26,470.12 79.95% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431009 - Computer & Technology - 243.96 - 243.96 300.00 56.04 81.32% 431015 - Laboratory Water Testing - 175.00 - 175.00 175.00 - 100.00% 431019 - Security Services 3,408.68 21,710.58 92.00 21,802.58 108,400.00 86,597.42 20.11% Total Professional Services 5,372.72 91,741.07 36,227.31 127,968.38 241,091.96 113,123.58 53.08% Communication & Transportation 432002 - Mailing - 876.03 - 876.03 5,032.00 4,155.97 17.41% 432003 - Travel 373.17 1,254.78 8,421.55 9,676.33 26,966.00 17,289.67 35.88% 432004 - Telecommunications 206.32 2,696.38 2,998.62 5,695.00 8,892.81 3,197.81 64.04% 432005 - Mileage Reimb 58.80 58.80 - 58.80 6,994.00 6,935.20 0.84% Total Communication & Transportation 638.29 4,885.99 11,420.17 16,306.16 47,884.81 31,578.65 34.05% Printing & Advertising 433001 - Outside Printing Services - 9,195.30 5,152.76 14,348.06 31,956.00 17,607.94 44.90% 433002 - Publication of Legal Notice 113.40 553.24 680.86 1,234.10 2,322.74 1,088.64 53.13% 433003 - Promotional 11,958.66 113,888.63 67,288.37 181,177.00 229,733.90 48,556.90 78.86% Total Printing & Advertising 12,072.06 123,637.17 73,121.99 196,759.16 264,012.64 67,253.48 74.53% Utilties 435001 - Electric 44,160.35 383,501.87 - 383,501.87 369,394.00 (14,107.87) 103.82% 435002 - Natural Gas 2,989.78 117,924.35 - 117,924.35 129,382.00 11,457.65 91.14% 435004 - Water 37,728.13 232,856.46 - 232,856.46 233,000.00 143.54 99.94% Total Utilities 84,878.26 734,282.68 - 734,282.68 731,776.00 (2,506.68) 100.34% Repairs & Maintenance 436000 - Other R&M 336.92 37,722.23 40,103.66 77,825.89 85,189.12 7,363.23 91.36% 436001 - Building R&M 7,600.12 99,775.20 24,780.25 124,555.45 131,228.44 6,672.99 94.91% 436003 - Auto Equip R&M 22,160.01 320,747.12 - 320,747.12 265,381.00 (55,366.12) 120.86% 436005 - Other Equip R&M 177.07 411.07 - 411.07 1,159.00 747.93 35.47% 436006 - Radio Equip R&M 466.00 10,233.60 - 10,233.60 9,772.00 (461.60) 104.72% 436011 - Exterminating 914.00 7,225.64 5,872.00 13,097.64 16,739.00 3,641.36 78.25% Total Repairs & Maintenance 31,654.12 476,114.86 70,755.91 546,870.77 509,468.56 (37,402.21) 107.34% Rentals 437002 - Equipment Rental 420.00 556.00 - 556.00 - (556.00) 0.00% 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 700.00 1,900.00 1,900.00 - 100.00% Total Rentals 1,620.00 13,756.00 700.00 14,456.00 13,900.00 (556.00) 104.00% Debt Service 438100 - Principal - 287,026.72 - 287,026.72 461,923.00 174,896.28 62.14% 438200 - Interest - 22,407.37 - 22,407.37 32,286.00 9,878.63 69.40% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 5,000.00 600.00 88.00% Total Debt Service - 313,834.09 - 313,834.09 499,209.00 185,374.91 62.87% Other Charges & Services 439000 - Misc Charges & Svcs 44,652.16 230,802.12 58,792.75 289,594.87 391,585.80 101,990.93 73.95% 439001 - Other Contractual Services 2,361.73 8,148.08 4,774.26 12,922.34 32,874.26 19,951.92 39.31% 439002 - Licenses & Permits - 8,820.57 - 8,820.57 10,037.00 1,216.43 87.88% 439003 - Subscriptions 64.99 3,191.62 - 3,191.62 2,056.00 (1,135.62) 155.23% 439004 - Dues & Memberships 117.95 4,608.89 - 4,608.89 16,354.00 11,745.11 28.18% 439005 - Bank & Credit Card Fees 6,078.97 63,662.98 - 63,662.98 69,225.00 5,562.02 91.97% 439006 - Education & Training 170.00 9,074.44 3,041.82 12,116.26 33,395.00 21,278.74 36.28% 439009 - Trash Removal 5,720.24 26,409.49 9,310.47 35,719.96 36,488.18 768.22 97.89% 439012 - Uniform Services - 7,632.59 - 7,632.59 7,652.00 19.41 99.75% 439099 - Cashier Over/Short (183.54) (681.89) - (681.89) 15.00 696.89 (4545.93%) 439100 - Refunds/Awards/Indemnities 2,365.07 18,660.25 - 18,660.25 33,318.00 14,657.75 56.01% 439300 - Grants & Subsidies - 715,000.00 - 715,000.00 715,000.00 - 100.00% 439999 - Bad Debt Expense (57.00) - - - - - 0.00% Total Other Services & Charges 61,290.57 1,095,329.14 75,919.30 1,171,248.44 1,348,000.24 176,751.80 86.89% Total Services & Charges Expenditures 197,526.02 2,853,581.00 268,144.68 3,121,725.68 3,655,343.21 533,617.53 85.40% Capital Outlay Buildings 443001 - Building Improvements - 67,597.12 5,852.88 73,450.00 74,000.00 550.00 99.26% Total Buildings - 67,597.12 5,852.88 73,450.00 74,000.00 550.00 99.26% 444000 - Land Improvements 15,610.99 237,428.80 375,449.39 612,878.19 1,591,285.91 978,407.72 38.51% Machinery & Equipment 445000 - Motor Equipment - - 10,866.86 10,866.86 10,867.00 0.14 100.00% 445003 - Park Equipment - 13,972.50 108,002.34 121,974.84 400,000.00 278,025.16 30.49% Total Machinery & Equipment - 13,972.50 118,869.20 132,841.70 410,867.00 278,025.30 32.33% Total Capital Expenditures 15,610.99 318,998.42 500,171.47 819,169.89 2,076,152.91 1,256,983.02 39.46% Other Uses 452002 - Allocations-Admin Cost 57,573.00 518,158.00 - 518,158.00 690,877.00 172,719.00 75.00% 452003 - Allocations-IT 54,596.00 491,361.00 - 491,361.00 655,149.00 163,788.00 75.00% 452004 - Allocations-Liability Insurance 18,500.00 166,488.00 - 166,488.00 221,988.00 55,500.00 75.00% 452008 - Allocations-Payroll Cost 6,680.00 60,116.00 - 60,116.00 80,156.00 20,040.00 75.00% 452009 - Allocations-Facilities Mgmt 1,654.00 14,883.00 - 14,883.00 19,845.00 4,962.00 75.00% Total Other Uses 139,003.00 1,251,006.00 - 1,251,006.00 1,668,015.00 417,009.00 75.00% Total Expenditures 1,078,825.73 11,377,405.76 917,445.98 12,294,851.74 16,823,270.47 4,528,418.73 73.08%