Loading...
HomeMy WebLinkAboutAug 21 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 67% 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 86.25 144.25 58.00 (86.25) 248.71% Total Licenses & Permits 86.25 144.25 58.00 (86.25) 248.71% 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% 347003 - Golf Season Pass 982.00 218,084.77 93,000.00 (125,084.77) 234.50% 347004 - Golf Green Fees 142,096.29 605,700.53 795,000.00 189,299.47 76.19% 347005 - Golf Cart Rentals 70,906.23 289,343.05 360,000.00 70,656.95 80.37% 347006 - Golf Pro Shop Retail 10,942.83 59,326.17 59,500.00 173.83 99.71% 347007 - Golf Driving Range 5,426.00 26,415.97 30,000.00 3,584.03 88.05% 347008 - Golf Gift Certificate - 5.00 - (5.00) 0.00% 347010 - Concession Sales 13,247.78 48,888.00 31,000.00 (17,888.00) 157.70% 347011 - Recreational Programming 40,827.04 298,498.32 361,500.00 63,001.68 82.57% 347012 - Food Sales 11,298.13 49,222.83 53,277.00 4,054.17 92.39% 347013 - Nonalcoholic Beverage 8,335.97 31,536.55 33,398.00 1,861.45 94.43% 347014 - Alcoholic Beverage Sales 26,489.13 109,276.48 110,000.00 723.52 99.34% 347015 - Lease of Stadium 30,000.00 100,000.00 75,000.00 (25,000.00) 133.33% 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% 347019 - Site Mowing - 1,227.59 95,000.00 93,772.41 1.29% 347021 - Tree Maintenance 70.00 66,351.24 120,000.00 53,648.76 55.29% 347023 - Graffiti Removal - 1,482.15 102,529.00 101,046.85 1.45% 347026 - Room Rental 7,139.95 47,461.53 9,000.00 (38,461.53) 527.35% 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% 347100 - Concessions-Employee Discounts (742.20) (2,796.43) - 2,796.43 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 402,652.74 2,257,867.49 2,731,450.00 473,582.51 82.66% Total Charges for Services 402,652.74 2,257,867.49 2,731,450.00 473,582.51 82.66% Miscellaneous Revenue 360000 - Miscellaneous 467.98 3,380.52 25,000.00 21,619.48 13.52% 360001 - Sale of Scrap Metal 436.50 836.09 - (836.09) 0.00% 361000 - Interest Earnings 995.60 17,423.92 40,000.00 22,576.08 43.56% 362000 - Rental of Property 10,831.50 57,910.25 60,000.00 2,089.75 96.52% 367000 - Donations from Private Sources 30,000.00 776,029.00 1,805,000.00 1,028,971.00 42.99% Total Miscellaneous Revenue 42,731.58 855,579.78 1,930,000.00 1,074,420.22 44.33% Refunds & Reimbursements 380000 - Misc Reimbursements 19,955.00 65,927.42 38,572.00 (27,355.42) 170.92% 380007 - Energy Rebates - 962.27 - (962.27) 0.00% 396000 - Refunds 450.00 6,287.91 5,267.00 (1,020.91) 119.38% Total Refunds & Reimbursements 20,405.00 73,177.60 43,839.00 (29,338.60) 166.92% Other Sources 391000 - Interfund Transfers In 102,711.00 821,697.00 1,234,486.00 412,789.00 66.56% August 31, 2021 392000 - Gain/Loss on Sale of Asset 17,250.00 17,250.00 - (17,250.00) 0.00% Total Other Sources 119,961.00 838,947.00 1,234,486.00 395,539.00 67.96% Total Revenue 585,836.57 10,392,051.59 16,293,916.00 5,901,864.41 63.78% 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 209,946.05 1,867,514.94 - 1,867,514.94 2,741,482.00 873,967.06 68.12% 410002 - Teamster Wages 113,396.19 957,691.78 - 957,691.78 1,397,385.00 439,693.22 68.53% 410003 - Permanent Part Time 77,913.45 469,719.86 - 469,719.86 728,535.00 258,815.14 64.47% 410004 - Extra & Overtime 16,152.29 72,500.06 - 72,500.06 87,989.00 15,488.94 82.40% 410005 - Seasonal & Interns 143,877.97 531,191.25 - 531,191.25 865,760.00 334,568.75 61.36% 410007 - Longevity Pay 500.00 5,950.00 - 5,950.00 8,050.00 2,100.00 73.91% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 561,785.95 3,904,567.89 - 3,904,567.89 5,830,401.00 1,925,833.11 66.97% Employee Benefits 411001 - FICA Regular 42,134.97 292,700.68 - 292,700.68 449,080.00 156,379.32 65.18% 411004 - PERF Regular 37,925.94 318,606.27 - 318,606.27 489,666.00 171,059.73 65.07% 411005 - PERF Union 1,456.87 12,246.81 - 12,246.81 22,866.00 10,619.19 53.56% 411007 - Unemployment Comp 106.59 896.91 - 896.91 1,278.00 381.09 70.18% 411008 - Health Insurance 85,836.22 704,355.63 - 704,355.63 988,554.00 284,198.37 71.25% 411009 - Life Insurance 860.00 6,945.00 - 6,945.00 10,320.00 3,375.00 67.30% 411014 - Parental Leave 1,176.87 10,129.23 - 10,129.23 15,159.00 5,029.77 66.82% 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,133.28 - 2,133.28 3,200.00 1,066.72 66.67% 411206 - Cell Phone Allowance 1,100.00 9,460.00 - 9,460.00 17,820.00 8,360.00 53.09% Total Employee Benefits 170,864.12 1,375,361.84 - 1,375,361.84 2,018,043.00 642,681.16 68.15% Total Personnel Expenditures 732,650.07 5,279,929.73 - 5,279,929.73 7,848,444.00 2,568,514.27 67.27% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 508.80 4,790.34 - 4,790.34 5,070.89 280.55 94.47% 421002 - Stationary & Printing 2,163.10 6,992.27 207.64 7,199.91 23,854.00 16,654.09 30.18% Total Office Supplies 2,671.90 11,782.61 207.64 11,990.25 28,924.89 16,934.64 41.45% Operating Supplies 422000 - Other Operating Supplies 20,476.41 248,090.87 27,689.40 275,780.27 280,309.78 4,529.51 98.38% 422001 - C.S. Gasoline 16,838.52 104,887.81 1,173.20 106,061.01 167,371.00 61,309.99 63.37% 422002 - Diesel/CNG 1,483.50 8,199.94 1,500.00 9,699.94 10,947.00 1,247.06 88.61% 422003 - Gasoline - 6,102.08 1,161.60 7,263.68 12,961.00 5,697.32 56.04% 422005 - Uniforms 718.57 4,800.11 420.50 5,220.61 12,228.00 7,007.39 42.69% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 4,520.00 4,200.07 7.08% 422007 - Cleaning Supplies 713.95 1,139.97 - 1,139.97 1,433.00 293.03 79.55% 422008 - Medical/Safety Supplies 4,891.89 17,044.39 - 17,044.39 21,087.19 4,042.80 80.83% 422009 - Recreation Supplies 11,973.01 109,102.42 8,829.57 117,931.99 283,559.82 165,627.83 41.59% 422010 - Plants Chemicals Seed & Fertilizer 8,182.19 102,854.47 6,499.93 109,354.40 152,333.77 42,979.37 71.79% 422013 - Promotional Supplies 617.73 3,684.89 - 3,684.89 6,629.00 2,944.11 55.59% 422014 - Concessions Inventory 22,093.84 84,747.41 7,469.21 92,216.62 94,088.00 1,871.38 98.01% 422016 - Inventory For Sale 1,170.33 34,644.64 7,777.08 42,421.72 45,500.00 3,078.28 93.23% Total Operating Supplies 89,159.94 725,618.93 62,520.49 788,139.42 1,092,967.56 304,828.14 72.11% Repair & Maintenance Supplies 423000 - Other R&M Supplies 6,780.59 93,881.13 39,807.54 133,688.67 252,405.86 118,717.19 52.97% 423001 - Building Materials 1,182.10 25,493.71 2,504.36 27,998.07 67,757.51 39,759.44 41.32% 423006 - Small Tools & Equipment 248.05 49,965.85 2,966.75 52,932.60 56,748.00 3,815.40 93.28% 423009 - Repair Parts 4,785.98 40,462.66 19,077.50 59,540.16 76,511.53 16,971.37 77.82% Total Repair & Maintenance Supplies 12,996.72 209,803.35 64,356.15 274,159.50 453,422.90 179,263.40 60.46% Total Supplies Expenditures 104,828.56 947,204.89 127,084.28 1,074,289.17 1,575,315.35 501,026.18 68.20% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 17,006.97 67,452.49 28,937.31 96,389.80 131,721.96 35,332.16 73.18% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431009 - Computer & Technology 243.96 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 688.31 18,301.90 2,928.00 21,229.90 157,267.00 136,037.10 13.50% Total Professional Services 17,939.24 86,368.35 31,865.31 118,233.66 289,658.96 171,425.30 40.82% Communication & Transportation 432002 - Mailing 709.93 876.03 - 876.03 5,032.00 4,155.97 17.41% 432003 - Travel - 881.61 9,362.92 10,244.53 26,966.00 16,721.47 37.99% 432004 - Telecommunications 205.74 2,490.06 3,204.94 5,695.00 10,892.81 5,197.81 52.28% 432005 - Mileage Reimb - - - - 6,994.00 6,994.00 0.00% Total Communication & Transportation 915.67 4,247.70 12,567.86 16,815.56 49,884.81 33,069.25 33.71% 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 - 439.84 243.40 683.24 2,322.74 1,639.50 29.42% 433003 - Promotional 20,265.87 101,929.97 55,863.12 157,793.09 247,733.90 89,940.81 63.69% Total Printing & Advertising 20,265.87 111,565.11 61,259.28 172,824.39 282,012.64 109,188.25 61.28% Utilties 435001 - Electric 45,856.88 339,341.52 - 339,341.52 369,394.00 30,052.48 91.86% 435002 - Natural Gas 2,837.75 114,934.57 - 114,934.57 129,382.00 14,447.43 88.83% 435004 - Water 44,089.96 195,128.33 - 195,128.33 196,000.00 871.67 99.56% Total Utilities 92,784.59 649,404.42 - 649,404.42 694,776.00 45,371.58 93.47% Repairs & Maintenance 436000 - Other R&M 6,537.81 37,385.31 40,103.66 77,488.97 60,189.12 (17,299.85) 128.74% 436001 - Building R&M 9,475.23 92,175.08 31,270.43 123,445.51 131,228.44 7,782.93 94.07% 436003 - Auto Equip R&M 37,198.54 298,587.11 - 298,587.11 265,381.00 (33,206.11) 112.51% 436005 - Other Equip R&M 234.00 234.00 - 234.00 1,159.00 925.00 20.19% 436006 - Radio Equip R&M 1,618.85 9,767.60 - 9,767.60 7,772.00 (1,995.60) 125.68% 436011 - Exterminating 635.00 6,311.64 6,786.00 13,097.64 16,739.00 3,641.36 78.25% Total Repairs & Maintenance 55,699.43 444,460.74 78,160.09 522,620.83 482,468.56 (40,152.27) 108.32% Rentals 437002 - Equipment Rental 136.00 136.00 - 136.00 1,200.00 1,064.00 11.33% 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 136.00 12,136.00 700.00 12,836.00 13,900.00 1,064.00 92.35% Debt Service 438100 - Principal 1,001.12 287,026.72 - 287,026.72 461,923.00 174,896.28 62.14% 438200 - Interest 7.97 22,407.37 - 22,407.37 32,286.00 9,878.63 69.40% Total Debt Service 1,009.09 309,434.09 - 309,434.09 494,209.00 184,774.91 62.61% Other Charges & Services 439000 - Misc Charges & Svcs 36,176.54 186,149.96 76,493.10 262,643.06 283,301.80 20,658.74 92.71% 439001 - Other Contractual Services - 5,786.35 6,485.99 12,272.34 37,992.26 25,719.92 32.30% 439002 - Licenses & Permits - 8,820.57 - 8,820.57 10,037.00 1,216.43 87.88% 439003 - Subscriptions 2,507.95 3,126.63 - 3,126.63 2,056.00 (1,070.63) 152.07% 439004 - Dues & Memberships - 4,490.94 - 4,490.94 18,554.00 14,063.06 24.20% 439005 - Bank & Credit Card Fees 9,193.65 57,584.01 - 57,584.01 69,225.00 11,640.99 83.18% 439006 - Education & Training 1,250.00 8,904.44 2,749.00 11,653.44 33,395.00 21,741.56 34.90% 439009 - Trash Removal 2,949.09 20,689.25 12,401.44 33,090.69 35,488.18 2,397.49 93.24% 439012 - Uniform Services 1,606.65 7,632.59 - 7,632.59 7,652.00 19.41 99.75% 439099 - Cashier Over/Short (134.44) (498.35) - (498.35) 15.00 513.35 ######## 439100 - Refunds/Awards/Indemnities 2,647.09 16,295.18 - 16,295.18 36,518.00 20,222.82 44.62% 439300 - Grants & Subsidies - 715,000.00 - 715,000.00 715,000.00 - 100.00% 439999 - Bad Debt Expense - 57.00 - 57.00 - (57.00) 0.00% Total Other Services & Charges 56,196.53 1,034,038.57 98,129.53 1,132,168.10 1,249,234.24 117,066.14 90.63% Total Services & Charges Expenditures 244,946.42 2,651,654.98 282,682.07 2,934,337.05 3,556,144.21 621,807.16 82.51% Capital Outlay Buildings 443001 - Building Improvements 27,402.12 67,597.12 5,852.88 73,450.00 74,000.00 550.00 99.26% Total Buildings 27,402.12 67,597.12 5,852.88 73,450.00 74,000.00 550.00 99.26% 444000 - Land Improvements 31,820.00 221,817.81 391,060.38 612,878.19 1,501,978.91 889,100.72 40.80% Machinery & Equipment 445000 - Motor Equipment - - 10,866.86 10,866.86 - (10,866.86) 0.00% 445003 - Park Equipment - 13,972.50 10,527.50 24,500.00 400,000.00 375,500.00 6.13% Total Machinery & Equipment - 13,972.50 21,394.36 35,366.86 400,000.00 364,633.14 8.84% Total Capital Expenditures 59,222.12 303,387.43 418,307.62 721,695.05 1,975,978.91 1,254,283.86 36.52% Other Uses 452002 - Allocations-Admin Cost 57,573.00 460,585.00 - 460,585.00 690,877.00 230,292.00 66.67% 452003 - Allocations-IT 54,596.00 436,765.00 - 436,765.00 655,149.00 218,384.00 66.67% 452004 - Allocations-Liability Insurance 18,500.00 147,988.00 - 147,988.00 221,988.00 74,000.00 66.66% 452008 - Allocations-Payroll Cost 6,680.00 53,436.00 - 53,436.00 80,156.00 26,720.00 66.67% 452009 - Allocations-Facilities Mgmt 1,654.00 13,229.00 - 13,229.00 19,845.00 6,616.00 66.66% Total Other Uses 139,003.00 1,112,003.00 - 1,112,003.00 1,668,015.00 556,012.00 66.67% Total Expenditures 1,280,650.17 10,294,180.03 828,073.97 11,122,254.00 16,623,897.47 5,501,643.47 66.91%