Loading...
HomeMy WebLinkAboutJuly 21 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 58% 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 - 58.00 58.00 - 100.00% Total Licenses & Permits - 58.00 58.00 - 100.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 25,853.31 47,613.37 20,000.00 (27,613.37) 238.07% 347002 - Picnic Site Rental 791.48 4,391.05 3,300.00 (1,091.05) 133.06% 347003 - Golf Season Pass (8,963.08) 217,102.77 93,000.00 (124,102.77) 233.44% 347004 - Golf Green Fees 124,275.88 463,604.24 795,000.00 331,395.76 58.31% 347005 - Golf Cart Rentals 66,811.35 218,436.82 360,000.00 141,563.18 60.68% 347006 - Golf Pro Shop Retail 12,946.19 48,383.34 59,500.00 11,116.66 81.32% 347007 - Golf Driving Range 5,473.00 20,989.97 30,000.00 9,010.03 69.97% 347008 - Golf Gift Certificate 11,082.08 5.00 - (5.00) 0.00% 347010 - Concession Sales 13,069.26 35,640.22 31,000.00 (4,640.22) 114.97% 347011 - Recreational Programming 39,708.01 257,671.28 361,500.00 103,828.72 71.28% 347012 - Food Sales 11,179.12 37,924.70 53,277.00 15,352.30 71.18% 347013 - Nonalcoholic Beverage 7,687.65 23,200.58 33,398.00 10,197.42 69.47% 347014 - Alcoholic Beverage Sales 23,876.40 82,787.35 110,000.00 27,212.65 75.26% 347015 - Lease of Stadium 15,000.00 70,000.00 75,000.00 5,000.00 93.33% 347016 - East Race Waterway 17,679.60 27,515.15 55,000.00 27,484.85 50.03% 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 30,912.84 66,281.24 120,000.00 53,718.76 55.23% 347023 - Graffiti Removal - 1,482.15 102,529.00 101,046.85 1.45% 347026 - Room Rental 7,165.33 40,321.58 9,000.00 (31,321.58) 448.02% 347030 - Merch Sales 141.12 940.31 2,500.00 1,559.69 37.61% 347040 - Pavilion Rental 3,196.36 25,035.48 22,446.00 (2,589.48) 111.54% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347100 - Concessions-Employee Discounts (677.68) (2,054.23) - 2,054.23 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 407,208.22 1,855,214.75 2,731,450.00 876,235.25 67.92% Total Charges for Services 407,208.22 1,855,214.75 2,731,450.00 876,235.25 67.92% Miscellaneous Revenue 360000 - Miscellaneous 342.98 2,912.54 25,000.00 22,087.46 11.65% 360001 - Sale of Scrap Metal - 399.59 - (399.59) 0.00% 361000 - Interest Earnings 7,312.59 16,428.32 40,000.00 23,571.68 41.07% 362000 - Rental of Property - 47,078.75 60,000.00 12,921.25 78.46% 367000 - Donations from Private Sources - 746,029.00 1,805,000.00 1,058,971.00 41.33% Total Miscellaneous Revenue 7,655.57 812,848.20 1,930,000.00 1,117,151.80 42.12% Refunds & Reimbursements 380000 - Misc Reimbursements 10,116.21 45,972.42 38,572.00 (7,400.42) 119.19% 380007 - Energy Rebates - 962.27 - (962.27) 0.00% 396000 - Refunds - 5,837.91 5,267.00 (570.91) 110.84% Total Refunds & Reimbursements 10,116.21 52,772.60 43,839.00 (8,933.60) 120.38% Other Sources 391000 - Interfund Transfers In 102,711.00 718,986.00 1,234,486.00 515,500.00 58.24% July 31, 2021 Total Other Sources 102,711.00 718,986.00 1,234,486.00 515,500.00 58.24% Total Revenue 527,691.00 9,806,215.02 16,293,916.00 6,487,700.98 60.18% 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 210,667.07 1,657,568.89 - 1,657,568.89 2,787,332.00 1,129,763.11 59.47% 410002 - Teamster Wages 116,795.86 844,295.59 - 844,295.59 1,437,385.00 593,089.41 58.74% 410003 - Permanent Part Time 72,853.25 391,806.41 - 391,806.41 695,035.00 303,228.59 56.37% 410004 - Extra & Overtime 11,950.20 56,347.77 - 56,347.77 61,639.00 5,291.23 91.42% 410005 - Seasonal & Interns 149,713.23 387,313.28 - 387,313.28 839,760.00 452,446.72 46.12% 410007 - Longevity Pay 150.00 5,450.00 - 5,450.00 8,050.00 2,600.00 67.70% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 562,129.61 3,342,781.94 - 3,342,781.94 5,830,401.00 2,487,619.06 57.33% Employee Benefits 411001 - FICA Regular 42,053.40 250,565.71 - 250,565.71 449,080.00 198,514.29 55.80% 411004 - PERF Regular 37,122.10 280,680.33 - 280,680.33 489,666.00 208,985.67 57.32% 411005 - PERF Union 1,464.25 10,789.94 - 10,789.94 22,866.00 12,076.06 47.19% 411007 - Unemployment Comp 106.95 790.32 - 790.32 1,278.00 487.68 61.84% 411008 - Health Insurance 86,821.32 618,519.41 - 618,519.41 988,554.00 370,034.59 62.57% 411009 - Life Insurance 865.00 6,085.00 - 6,085.00 10,320.00 4,235.00 58.96% 411014 - Parental Leave 1,178.80 8,952.36 - 8,952.36 15,159.00 6,206.64 59.06% 411015 - Other Fringe Benefits - 1,600.00 - 1,600.00 1,600.00 - 100.00% 411201 - Tool Allowance 213.24 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 1,866.62 - 1,866.62 3,200.00 1,333.38 58.33% 411206 - Cell Phone Allowance 1,155.00 8,360.00 - 8,360.00 17,820.00 9,460.00 46.91% Total Employee Benefits 171,246.72 1,204,497.72 - 1,204,497.72 2,018,043.00 813,545.28 59.69% Total Personnel Expenditures 733,376.33 4,547,279.66 - 4,547,279.66 7,848,444.00 3,301,164.34 57.94% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 463.26 4,281.54 - 4,281.54 2,899.89 (1,381.65) 147.64% 421002 - Stationary & Printing 139.37 4,829.17 921.88 5,751.05 25,598.00 19,846.95 22.47% Total Office Supplies 602.63 9,110.71 921.88 10,032.59 28,497.89 18,465.30 35.20% Operating Supplies 422000 - Other Operating Supplies 37,796.38 227,614.46 28,502.90 256,117.36 271,709.78 15,592.42 94.26% 422001 - C.S. Gasoline 15,064.03 88,049.29 - 88,049.29 164,871.00 76,821.71 53.40% 422002 - Diesel/CNG 1,315.80 6,716.44 - 6,716.44 10,947.00 4,230.56 61.35% 422003 - Gasoline - 6,102.08 - 6,102.08 16,961.00 10,858.92 35.98% 422005 - Uniforms 1,660.32 4,081.54 142.50 4,224.04 14,128.00 9,903.96 29.90% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 320.00 0.07 99.98% 422007 - Cleaning Supplies - 426.02 - 426.02 233.00 (193.02) 182.84% 422008 - Medical/Safety Supplies 2,942.10 12,152.50 - 12,152.50 17,087.19 4,934.69 71.12% 422009 - Recreation Supplies 26,071.75 97,129.41 7,944.54 105,073.95 299,555.82 194,481.87 35.08% 422010 - Plants Chemicals Seed & Fertilizer 16,214.16 94,672.28 8,817.26 103,489.54 153,333.77 49,844.23 67.49% 422013 - Promotional Supplies 1,554.63 3,067.16 - 3,067.16 - (3,067.16) 0.00% 422014 - Concessions Inventory 13,965.71 62,653.57 8,304.54 70,958.11 92,448.00 21,489.89 76.75% 422016 - Inventory For Sale 2,616.39 33,474.31 7,442.08 40,916.39 47,500.00 6,583.61 86.14% Total Operating Supplies 119,201.27 636,458.99 61,153.82 697,612.81 1,089,094.56 391,481.75 64.05% Repair & Maintenance Supplies 423000 - Other R&M Supplies 5,885.78 87,100.54 13,831.81 100,932.35 256,805.86 155,873.51 39.30% 423001 - Building Materials 11,722.88 24,311.61 2,247.92 26,559.53 67,757.51 41,197.98 39.20% 423006 - Small Tools & Equipment 3,267.77 49,717.80 2,966.75 52,684.55 56,748.00 4,063.45 92.84% 423009 - Repair Parts 3,194.03 35,676.68 17,914.50 53,591.18 76,411.53 22,820.35 70.13% Total Repair & Maintenance Supplies 24,070.46 196,806.63 36,960.98 233,767.61 457,722.90 223,955.29 51.07% Total Supplies Expenditures 143,874.36 842,376.33 99,036.68 941,413.01 1,575,315.35 633,902.34 59.76% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 11,872.20 50,445.52 37,593.59 88,039.11 136,441.96 48,402.85 64.52% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431015 - Laboratory Water Testing - 175.00 - 175.00 175.00 - 100.00% 431019 - Security Services 270.43 17,613.59 2,928.00 20,541.59 184,204.00 163,662.41 11.15% Total Professional Services 12,142.63 68,429.11 40,521.59 108,950.70 321,015.96 212,065.26 33.94% Communication & Transportation 432002 - Mailing 2.80 166.10 - 166.10 5,019.00 4,852.90 3.31% 432003 - Travel 439.40 881.61 3,642.60 4,524.21 27,916.00 23,391.79 16.21% 432004 - Telecommunications 368.23 2,284.32 3,435.49 5,719.81 11,049.81 5,330.00 51.76% 432005 - Mileage Reimb - - - - 6,994.00 6,994.00 0.00% Total Communication & Transportation 810.43 3,332.03 7,078.09 10,410.12 50,978.81 40,568.69 20.42% Printing & Advertising 433001 - Outside Printing Services 2,524.62 9,195.30 1,080.00 10,275.30 31,906.00 21,630.70 32.20% 433002 - Publication of Legal Notice 31.20 439.84 272.74 712.58 2,322.74 1,610.16 30.68% 433003 - Promotional 11,725.41 81,664.10 62,482.95 144,147.05 247,552.90 103,405.85 58.23% Total Printing & Advertising 14,281.23 91,299.24 63,835.69 155,134.93 281,781.64 126,646.71 55.06% Utilties 435001 - Electric 44,297.75 293,484.64 - 293,484.64 368,794.00 75,309.36 79.58% 435002 - Natural Gas 4,807.36 112,096.82 - 112,096.82 124,082.00 11,985.18 90.34% 435004 - Water 39,185.00 151,038.37 - 151,038.37 198,000.00 46,961.63 76.28% Total Utilities 88,290.11 556,619.83 - 556,619.83 690,876.00 134,256.17 80.57% Repairs & Maintenance 436000 - Other R&M 5,086.00 30,847.50 46,543.66 77,391.16 60,178.12 (17,213.04) 128.60% 436001 - Building R&M 11,958.00 82,699.85 32,016.94 114,716.79 123,828.44 9,111.65 92.64% 436003 - Auto Equip R&M 46,298.24 261,388.57 - 261,388.57 277,991.00 16,602.43 94.03% 436005 - Other Equip R&M - - 234.00 234.00 1,159.00 925.00 20.19% 436006 - Radio Equip R&M 1,377.63 8,148.75 - 8,148.75 5,155.00 (2,993.75) 158.07% 436011 - Exterminating 914.00 5,676.64 7,421.00 13,097.64 18,739.00 5,641.36 69.90% Total Repairs & Maintenance 65,633.87 388,761.31 86,215.60 474,976.91 487,050.56 12,073.65 97.52% Rentals 437002 - Equipment Rental - - - - 1,200.00 1,200.00 0.00% 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 - 12,000.00 700.00 12,700.00 13,900.00 1,200.00 91.37% Debt Service 438100 - Principal 8,415.93 286,025.60 - 286,025.60 461,923.00 175,897.40 61.92% 438200 - Interest 67.04 22,399.40 - 22,399.40 32,286.00 9,886.60 69.38% Total Debt Service 8,482.97 308,425.00 - 308,425.00 494,209.00 185,784.00 62.41% Other Charges & Services 439000 - Misc Charges & Svcs 46,549.53 149,973.42 79,941.26 229,914.68 265,925.80 36,011.12 86.46% 439001 - Other Contractual Services 661.65 5,786.35 4,124.26 9,910.61 41,228.26 31,317.65 24.04% 439002 - Licenses & Permits 148.41 8,820.57 - 8,820.57 8,562.00 (258.57) 103.02% 439003 - Subscriptions 142.93 618.68 - 618.68 1,926.00 1,307.32 32.12% 439004 - Dues & Memberships 215.00 4,490.94 - 4,490.94 18,975.00 14,484.06 23.67% 439005 - Bank & Credit Card Fees 9,654.93 48,390.36 - 48,390.36 65,075.00 16,684.64 74.36% 439006 - Education & Training 4,536.60 7,654.44 2,459.00 10,113.44 26,582.00 16,468.56 38.05% 439009 - Trash Removal 6,659.96 17,740.16 12,366.47 30,106.63 35,688.18 5,581.55 84.36% 439012 - Uniform Services 2,174.81 6,025.94 - 6,025.94 3,852.00 (2,173.94) 156.44% 439099 - Cashier Over/Short (190.06) (363.91) - (363.91) - 363.91 0.00% 439100 - Refunds/Awards/Indemnities 3,913.54 13,648.09 - 13,648.09 33,518.00 19,869.91 40.72% 439300 - Grants & Subsidies - 715,000.00 - 715,000.00 715,000.00 - 100.00% 439999 - Bad Debt Expense 57.00 57.00 - 57.00 - (57.00) 0.00% Total Other Services & Charges 74,524.30 977,842.04 98,890.99 1,076,733.03 1,216,332.24 139,599.21 88.52% Total Services & Charges Expenditures 264,165.54 2,406,708.56 297,241.96 2,703,950.52 3,556,144.21 852,193.69 76.04% Capital Outlay Buildings 443001 - Building Improvements 38,453.75 40,195.00 33,255.00 73,450.00 74,000.00 550.00 99.26% Total Buildings 38,453.75 40,195.00 33,255.00 73,450.00 74,000.00 550.00 99.26% 444000 - Land Improvements 25,257.52 189,997.81 370,385.38 560,383.19 1,501,978.91 941,595.72 37.31% 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 63,711.27 244,165.31 425,034.74 669,200.05 1,975,978.91 1,306,778.86 33.87% Other Uses 452002 - Allocations-Admin Cost 57,573.00 403,012.00 - 403,012.00 690,877.00 287,865.00 58.33% 452003 - Allocations-IT 54,596.00 382,169.00 - 382,169.00 655,149.00 272,980.00 58.33% 452004 - Allocations-Liability Insurance 18,500.00 129,488.00 - 129,488.00 221,988.00 92,500.00 58.33% 452008 - Allocations-Payroll Cost 6,680.00 46,756.00 - 46,756.00 80,156.00 33,400.00 58.33% 452009 - Allocations-Facilities Mgmt 1,654.00 11,575.00 - 11,575.00 19,845.00 8,270.00 58.33% Total Other Uses 139,003.00 973,000.00 - 973,000.00 1,668,015.00 695,015.00 58.33% Total Expenditures 1,344,130.50 9,013,529.86 821,313.38 9,834,843.24 16,623,897.47 6,789,054.23 59.16%