Loading...
HomeMy WebLinkAboutMay 21 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 42% 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 - - 9,247,389.00 9,247,389.00 100.00% Total Property Taxes - - 9,247,389.00 9,247,389.00 100.00% Total Taxes - - 9,247,389.00 9,247,389.00 100.00% Intergovernmental Revenue State Shared Revenue 335002 - Vehicle/Aircraft Excise - - 752,272.00 752,272.00 100.00% 335007 - Commercial Vehicle Excise - - 154,422.00 154,422.00 100.00% Total State Shared Revenue - - 906,694.00 906,694.00 100.00% Total Intergovernmental Revenue - - 906,694.00 906,694.00 100.00% Licenses & Permits Nonbusiness Licenses & Permits 322050 - Park Food Sales Permit 30.00 30.00 - (30.00) 0.00% Total Nonbusiness Licenses & Permits 30.00 30.00 - (30.00) 0.00% Total Licenses & Permits 30.00 30.00 - (30.00) 0.00% Charges for Services Culture & Recreation 347001 - Swimming Pool - - 20,000.00 20,000.00 100.00% 347002 - Picnic Site Rental 673.60 2,289.32 3,300.00 1,010.68 30.63% 347003 - Golf Season Pass 16,015.00 219,751.85 93,000.00 (126,751.85) (136.29%) 347004 - Golf Green Fees 111,329.81 201,585.91 795,000.00 593,414.09 74.64% 347005 - Golf Cart Rentals 49,049.61 89,604.50 360,000.00 270,395.50 75.11% 347006 - Golf Pro Shop Retail 10,795.41 22,197.89 59,500.00 37,302.11 62.69% 347007 - Golf Driving Range 4,590.97 9,871.97 30,000.00 20,128.03 67.09% 347008 - Golf Gift Certificate (844.85) (12,713.74) - 12,713.74 0.00% 347010 - Concession Sales 8,978.18 10,083.31 31,000.00 20,916.69 67.47% 347011 - Recreational Programming 34,657.32 180,701.73 361,500.00 180,798.27 50.01% 347012 - Food Sales 8,590.85 16,176.02 53,277.00 37,100.98 69.64% 347013 - Nonalcoholic Beverage 4,788.47 8,166.57 33,398.00 25,231.43 75.55% 347014 - Alcoholic Beverage Sales 21,080.12 35,415.42 110,000.00 74,584.58 67.80% 347015 - Lease of Stadium 15,000.00 40,000.00 75,000.00 35,000.00 46.67% 347016 - East Race Waterway 1,155.00 1,155.00 55,000.00 53,845.00 97.90% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 45.70% 347018 - Skate Rental - - - - 0.00% 347019 - Site Mowing - - 95,000.00 95,000.00 100.00% 347021 - Tree Maintenance 453.00 34,482.40 120,000.00 85,517.60 71.26% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% 347026 - Room Rental 8,705.48 25,233.09 9,000.00 (16,233.09) (180.37%) 347030 - Merch Sales 15.00 758.00 2,500.00 1,742.00 69.68% 347040 - Pavilion Rental 7,515.80 17,518.40 22,446.00 4,927.60 21.95% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347100 - Concessions-Employee Discounts (563.12) (754.26) - 754.26 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 301,985.65 1,068,238.17 2,731,450.00 1,663,211.83 60.89% Total Charges for Services 301,985.65 1,068,238.17 2,731,450.00 1,663,211.83 60.89% Miscellaneous Revenue 360000 - Miscellaneous 326.08 2,027.81 25,000.00 22,972.19 91.89% 360001 - Sale of Scrap Metal - 154.24 - (154.24) 0.00% 361000 - Interest Earnings 251.64 9,085.26 40,000.00 30,914.74 77.29% 362000 - Rental of Property 5,415.75 36,247.25 60,000.00 23,752.75 39.59% 367000 - Donations from Private Sources - 730,029.00 805,000.00 74,971.00 9.31% Total Miscellaneous Revenue 5,993.47 777,543.56 930,000.00 152,456.44 16.39% Refunds & Reimbursements 380000 - Misc Reimbursements 5,394.00 16,244.21 - (16,244.21) 0.00% May 31, 2021 380007 - Energy Rebates 962.27 962.27 - (962.27) 0.00% 396000 - Refunds 152.65 21,682.91 - (21,682.91) 0.00% Total Refunds & Reimbursements 6,508.92 38,889.39 - (38,889.39) 0.00% Other Sources 391000 - Interfund Transfers In 102,711.00 513,564.00 1,234,486.00 720,922.00 58.40% Total Other Sources 102,711.00 513,564.00 1,234,486.00 720,922.00 - Total Revenue 417,229.04 2,398,265.12 15,050,019.00 12,651,753.88 84.06% 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 217,128.69 1,230,542.88 - 1,230,542.88 2,826,600.00 1,596,057.12 56.47% 410002 - Teamster Wages 109,009.76 614,389.91 - 614,389.91 1,437,385.00 822,995.09 57.26% 410003 - Permanent Part Time 65,692.55 246,095.56 - 246,095.56 658,511.00 412,415.44 62.63% 410004 - Extra & Overtime 4,669.11 33,630.74 - 33,630.74 58,895.00 25,264.26 42.90% 410005 - Seasonal & Interns 33,764.98 139,058.65 - 139,058.65 839,760.00 700,701.35 83.44% 410007 - Longevity Pay 350.00 4,650.00 - 4,650.00 8,050.00 3,400.00 42.24% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 100.00% Total Salaries & Wages 430,615.09 2,268,367.74 - 2,268,367.74 5,830,401.00 3,562,033.26 61.09% Employee Benefits 411001 - FICA Regular 31,962.62 170,443.67 - 170,443.67 449,080.00 278,636.33 62.05% 411004 - PERF Regular 36,807.49 206,542.73 - 206,542.73 489,666.00 283,123.27 57.82% 411005 - PERF Union 1,333.33 7,905.33 - 7,905.33 22,866.00 14,960.67 65.43% 411007 - Unemployment Comp 34.83 192.16 - 192.16 1,278.00 1,085.84 84.96% 411008 - Health Insurance 87,357.82 444,333.27 - 444,333.27 988,554.00 544,220.73 55.05% 411009 - Life Insurance 865.00 4,360.00 - 4,360.00 10,320.00 5,960.00 57.75% 411014 - Parental Leave 1,155.78 6,594.86 - 6,594.86 15,159.00 8,564.14 56.50% 411015 - Other Fringe Benefits - 1,600.00 - 1,600.00 1,600.00 - 0.00% 411201 - Tool Allowance - 774.79 - 774.79 3,200.00 2,425.21 75.79% 411203 - Job Readiness Allow. - 15,300.00 - 15,300.00 15,300.00 - 0.00% 411204 - Auto Allowance 266.66 1,333.30 - 1,333.30 3,200.00 1,866.70 58.33% 411206 - Cell Phone Allowance 1,210.00 6,050.00 - 6,050.00 17,820.00 11,770.00 66.05% Total Employee Benefits 160,993.53 865,430.11 - 865,430.11 2,018,043.00 1,152,612.89 57.12% Total Personnel Expenditures 591,608.62 3,133,797.85 - 3,133,797.85 7,848,444.00 4,714,646.15 60.07% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 127.65 3,206.89 32.39 3,239.28 2,899.89 (339.39) (11.70%) 421002 - Stationary & Printing 135.91 1,312.85 2,819.00 4,131.85 24,048.00 19,916.15 82.82% Total Office Supplies 263.56 4,519.74 2,851.39 7,371.13 26,947.89 19,576.76 72.65% Operating Supplies 422000 - Other Operating Supplies 32,432.38 161,648.04 42,940.74 204,588.78 250,437.78 45,849.00 18.31% 422001 - C.S. Gasoline 12,583.28 55,472.75 - 55,472.75 164,871.00 109,398.25 66.35% 422002 - Diesel/CNG - 1,171.80 1,168.00 2,339.80 6,000.00 3,660.20 61.00% 422003 - Gasoline - 4,946.08 1,156.00 6,102.08 21,908.00 15,805.92 72.15% 422005 - Uniforms 818.22 2,421.22 186.62 2,607.84 13,428.00 10,820.16 80.58% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 320.00 0.07 0.02% 422007 - Cleaning Supplies - 232.06 - 232.06 233.00 0.94 0.40% 422008 - Medical/Safety Supplies 2,444.51 8,200.82 - 8,200.82 17,637.19 9,436.37 53.50% 422009 - Recreation Supplies 7,211.54 53,188.63 9,040.40 62,229.03 304,343.82 242,114.79 79.55% 422010 - Plants Chemicals Seed & Fertilizer 8,322.82 74,548.74 19,024.70 93,573.44 156,833.77 63,260.33 40.34% 422013 - Promotional Supplies - 642.40 - 642.40 - (642.40) 0.00% 422014 - Concessions Inventory 6,526.27 22,594.83 2,756.00 25,350.83 111,748.00 86,397.17 77.31% 422016 - Inventory For Sale 518.87 30,857.92 7,888.42 38,746.34 38,000.00 (746.34) (1.96%) Total Operating Supplies 70,857.89 416,245.22 84,160.88 500,406.10 1,085,760.56 585,354.46 53.91% Repair & Maintenance Supplies 423000 - Other R&M Supplies 20,351.73 58,231.53 11,298.47 69,530.00 261,689.86 192,159.86 73.43% 423001 - Building Materials 1,775.38 8,853.17 3,614.35 12,467.52 92,757.51 80,289.99 86.56% 423006 - Small Tools & Equipment 829.64 41,080.94 5,668.17 46,749.11 56,748.00 9,998.89 17.62% 423009 - Repair Parts 10,377.45 28,825.42 7,242.92 36,068.34 76,411.53 40,343.19 52.80% Total Repair & Maintenance Supplies 33,334.20 136,991.06 27,823.91 164,814.97 487,606.90 322,791.93 66.20% Total Supplies Expenditures 104,455.65 557,756.02 114,836.18 672,592.20 1,600,315.35 927,723.15 57.97% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 5,749.79 27,664.36 32,336.59 60,000.95 163,122.96 103,122.01 63.22% 431001 - Legal Services - 195.00 - 195.00 195.00 - 0.00% 431015 - Laboratory Water Testing 160.00 175.00 - 175.00 175.00 - 0.00% 431019 - Security Services 477.28 17,343.16 - 17,343.16 187,204.00 169,860.84 90.74% Total Professional Services 6,387.07 45,377.52 32,336.59 77,714.11 350,696.96 272,982.85 77.84% Communication & Transportation 432002 - Mailing - 161.23 - 161.23 5,019.00 4,857.77 96.79% 432003 - Travel - - - - 27,256.00 27,256.00 100.00% 432004 - Telecommunications 61.06 1,709.06 4,010.75 5,719.81 11,049.81 5,330.00 48.24% 432005 - Mileage Reimb - - - - 8,344.00 8,344.00 100.00% Total Communication & Transportation 61.06 1,870.29 4,010.75 5,881.04 51,668.81 45,787.77 88.62% Printing & Advertising 433001 - Outside Printing Services 1,482.21 5,089.96 1,700.00 6,789.96 31,906.00 25,116.04 78.72% 433002 - Publication of Legal Notice - 286.94 180.38 467.32 2,322.74 1,855.42 79.88% 433003 - Promotional 16,447.02 55,154.75 36,884.30 92,039.05 249,702.90 157,663.85 63.14% Total Printing & Advertising 17,929.23 60,531.65 38,764.68 99,296.33 283,931.64 184,635.31 65.03% Utilties 435001 - Electric 30,847.50 201,272.83 - 201,272.83 376,294.00 175,021.17 46.51% 435002 - Natural Gas 11,057.32 100,806.60 - 100,806.60 128,082.00 27,275.40 21.30% 435004 - Water 7,380.59 74,118.81 - 74,118.81 198,000.00 123,881.19 62.57% Total Utilities 49,285.41 376,198.24 - 376,198.24 702,376.00 326,177.76 46.44% Repairs & Maintenance 436000 - Other R&M 2,354.00 15,594.50 28,961.12 44,555.62 44,678.12 122.50 0.27% 436001 - Building R&M 54,099.76 66,886.91 38,950.44 105,837.35 187,828.44 81,991.09 43.65% 436003 - Auto Equip R&M 41,245.54 155,335.92 1,749.82 157,085.74 332,991.00 175,905.26 52.83% 436005 - Other Equip R&M - - 159.00 159.00 159.00 - 0.00% 436006 - Radio Equip R&M 302.00 3,406.12 - 3,406.12 5,155.00 1,748.88 33.93% 436011 - Exterminating 675.00 3,290.64 9,807.00 13,097.64 18,739.00 5,641.36 30.10% Total Repairs & Maintenance 98,676.30 244,514.09 79,627.38 324,141.47 589,550.56 265,409.09 45.02% Rentals 437002 - Equipment Rental - - - - 1,200.00 1,200.00 100.00% 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 0.00% 437006 - Recreation Space Rental - - 700.00 700.00 700.00 - 0.00% Total Rentals - 12,000.00 700.00 12,700.00 13,900.00 1,200.00 8.63% Debt Service 438100 - Principal 125,011.12 277,347.17 - 277,347.17 459,625.00 182,277.83 39.66% 438200 - Interest 12,786.20 22,326.30 - 22,326.30 34,584.00 12,257.70 35.44% Total Debt Service 137,797.32 299,673.47 - 299,673.47 494,209.00 194,535.53 39.36% Other Charges & Services 439000 - Misc Charges & Svcs 12,993.07 79,871.94 116,466.13 196,338.07 300,273.80 103,935.73 34.61% 439001 - Other Contractual Services 575.00 4,041.04 4,724.26 8,765.30 55,116.26 46,350.96 84.10% 439002 - Licenses & Permits 148.41 8,541.27 - 8,541.27 8,562.00 20.73 0.24% 439003 - Subscriptions 64.99 462.80 - 462.80 1,926.00 1,463.20 75.97% 439004 - Dues & Memberships 2,217.95 4,071.94 - 4,071.94 18,975.00 14,903.06 78.54% 439005 - Bank & Credit Card Fees 4,731.87 26,900.77 - 26,900.77 39,800.00 12,899.23 32.41% 439006 - Education & Training 180.00 3,117.84 1,269.00 4,386.84 26,879.00 22,492.16 83.68% 439009 - Trash Removal 1,694.56 9,179.04 15,936.98 25,116.02 33,493.18 8,377.16 25.01% 439012 - Uniform Services - 3,851.13 - 3,851.13 3,852.00 0.87 0.02% 439099 - Cashier Over/Short 12.57 (49.61) - (49.61) - 49.61 0.00% 439100 - Refunds/Awards/Indemnities 2,508.13 7,267.32 - 7,267.32 20,000.00 12,732.68 63.66% 439300 - Grants & Subsidies - 715,000.00 - 715,000.00 715,000.00 - 0.00% Total Other Services & Charges 25,126.55 862,255.48 138,396.37 1,000,651.85 1,223,877.24 223,225.39 18.24% Total Services & Charges Expenditures 335,262.94 1,902,420.74 293,835.77 2,196,256.51 3,710,210.21 1,513,953.70 40.81% Capital Outlay Buildings 443001 - Building Improvements 1,741.25 1,741.25 71,708.75 73,450.00 - (73,450.00) 0.00% Total Buildings 1,741.25 1,741.25 71,708.75 73,450.00 - (73,450.00) 0.00% 444000 - Land Improvements 28,036.33 137,817.18 353,727.97 491,545.15 380,912.91 (110,632.24) (29.04%) Machinery & Equipment 445003 - Park Equipment - - 24,500.00 24,500.00 400,000.00 375,500.00 93.88% Total Machinery & Equipment - - 24,500.00 24,500.00 400,000.00 375,500.00 93.88% Total Capital Expenditures 29,777.58 139,558.43 449,936.72 589,495.15 780,912.91 191,417.76 24.51% Other Uses 452002 - Allocations-Admin Cost 57,573.00 287,866.00 - 287,866.00 690,877.00 403,011.00 58.33% 452003 - Allocations-IT 54,596.00 272,977.00 - 272,977.00 655,149.00 382,172.00 58.33% 452004 - Allocations-Liability Insurance 18,500.00 92,488.00 - 92,488.00 221,988.00 129,500.00 58.34% 452008 - Allocations-Payroll Cost 6,680.00 33,396.00 - 33,396.00 80,156.00 46,760.00 58.34% 452009 - Allocations-Facilities Mgmt 1,654.00 8,267.00 - 8,267.00 19,845.00 11,578.00 58.34% Total Other Uses 139,003.00 694,994.00 - 694,994.00 1,668,015.00 973,021.00 58.33% Total Expenditures 1,200,107.79 6,428,527.04 858,608.67 7,287,135.71 15,607,897.47 8,320,761.76 53.31%