Loading...
HomeMy WebLinkAboutApr 21 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 - - 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% Charges for Services Culture & Recreation 347001 - Swimming Pool - - 20,000.00 20,000.00 100.00% 347002 - Picnic Site Rental 1,533.10 1,615.72 3,300.00 1,684.28 51.04% 347003 - Golf Season Pass 18,578.00 203,736.85 93,000.00 (110,736.85) (119.07%) 347004 - Golf Green Fees 61,948.10 90,256.10 795,000.00 704,743.90 88.65% 347005 - Golf Cart Rentals 28,881.35 40,554.89 360,000.00 319,445.11 88.73% 347006 - Golf Pro Shop Retail 7,742.14 11,402.48 59,500.00 48,097.52 80.84% 347007 - Golf Driving Range 3,570.00 5,281.00 30,000.00 24,719.00 82.40% 347008 - Golf Gift Certificate (975.00) (11,868.89) - 11,868.89 0.00% 347010 - Concession Sales 929.13 1,105.13 31,000.00 29,894.87 96.44% 347011 - Recreational Programming 38,120.94 146,044.41 361,500.00 215,455.59 59.60% 347012 - Food Sales 5,903.07 7,585.17 53,277.00 45,691.83 85.76% 347013 - Nonalcoholic Beverage 2,439.70 3,378.10 33,398.00 30,019.90 89.89% 347014 - Alcoholic Beverage Sales 10,972.44 14,335.30 110,000.00 95,664.70 86.97% 347015 - Lease of Stadium 10,000.00 25,000.00 75,000.00 50,000.00 66.67% 347016 - East Race Waterway - - 55,000.00 55,000.00 100.00% 347017 - Ice Skating 1,724.00 162,898.30 300,000.00 137,101.70 45.70% 347018 - Skate Rental (120.00) - - - 0.00% 347019 - Site Mowing - - 95,000.00 95,000.00 100.00% 347021 - Tree Maintenance 30,890.00 34,029.40 120,000.00 85,970.60 71.64% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% 347026 - Room Rental 4,725.40 16,527.61 9,000.00 (7,527.61) (83.64%) 347030 - Merch Sales 64.00 743.00 2,500.00 1,757.00 70.28% 347040 - Pavilion Rental 6,340.28 10,002.60 22,446.00 12,443.40 55.44% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347100 - Concessions-Employee Discounts (159.79) (191.14) - 191.14 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 233,106.86 766,252.52 2,731,450.00 1,965,197.48 71.95% Total Charges for Services 233,106.86 766,252.52 2,731,450.00 1,965,197.48 71.95% Miscellaneous Revenue 360000 - Miscellaneous 136.83 1,701.73 25,000.00 23,298.27 93.19% 360001 - Sale of Scrap Metal - 154.24 - (154.24) 0.00% 361000 - Interest Earnings 3,439.23 8,833.62 40,000.00 31,166.38 77.92% 362000 - Rental of Property 5,215.75 30,831.50 60,000.00 29,168.50 48.61% 367000 - Donations from Private Sources - 730,029.00 805,000.00 74,971.00 9.31% Total Miscellaneous Revenue 8,791.81 771,550.09 930,000.00 158,449.91 17.04% Refunds & Reimbursements 380000 - Misc Reimbursements 1,209.84 10,850.21 - (10,850.21) 0.00% 396000 - Refunds 17,978.00 21,530.26 - (21,530.26) 0.00% Total Refunds & Reimbursements 19,187.84 32,380.47 - (32,380.47) 0.00% Other Sources 391000 - Interfund Transfers In 102,711.00 410,853.00 1,234,486.00 823,633.00 66.72% Total Other Sources 102,711.00 410,853.00 1,234,486.00 823,633.00 - April 30, 2021 Total Revenue 363,797.51 1,981,036.08 15,050,019.00 13,068,982.92 86.84% 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 319,322.17 1,013,414.19 - 1,013,414.19 2,826,600.00 1,813,185.81 64.15% 410002 - Teamster Wages 171,722.90 505,380.15 - 505,380.15 1,437,385.00 932,004.85 64.84% 410003 - Permanent Part Time 78,942.39 180,403.01 - 180,403.01 658,511.00 478,107.99 72.60% 410004 - Extra & Overtime 4,489.74 28,961.63 - 28,961.63 58,895.00 29,933.37 50.82% 410005 - Seasonal & Interns 18,948.29 105,293.67 - 105,293.67 839,760.00 734,466.33 87.46% 410007 - Longevity Pay 1,600.00 4,300.00 - 4,300.00 8,050.00 3,750.00 46.58% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 100.00% Total Salaries & Wages 595,025.49 1,837,752.65 - 1,837,752.65 5,830,401.00 3,992,648.35 68.48% Employee Benefits 411001 - FICA Regular 44,869.95 138,481.05 - 138,481.05 449,080.00 310,598.95 69.16% 411004 - PERF Regular 53,717.90 169,735.24 - 169,735.24 489,666.00 319,930.76 65.34% 411005 - PERF Union 2,089.42 6,572.00 - 6,572.00 22,866.00 16,294.00 71.26% 411007 - Unemployment Comp 51.52 157.33 - 157.33 1,278.00 1,120.67 87.69% 411008 - Health Insurance 88,451.02 356,975.45 - 356,975.45 988,554.00 631,578.55 63.89% 411009 - Life Insurance 870.00 3,495.00 - 3,495.00 10,320.00 6,825.00 66.13% 411014 - Parental Leave 1,739.86 5,439.08 - 5,439.08 15,159.00 9,719.92 64.12% 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,066.64 - 1,066.64 3,200.00 2,133.36 66.67% 411206 - Cell Phone Allowance 1,210.00 4,840.00 - 4,840.00 17,820.00 12,980.00 72.84% Total Employee Benefits 193,266.33 704,436.58 - 704,436.58 2,018,043.00 1,313,606.42 65.09% Total Personnel Expenditures 788,291.82 2,542,189.23 - 2,542,189.23 7,848,444.00 5,306,254.77 67.61% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 299.57 3,079.24 32.39 3,111.63 2,867.89 (243.74) (8.50%) 421002 - Stationary & Printing 277.49 1,176.94 2,819.00 3,995.94 23,048.00 19,052.06 82.66% Total Office Supplies 577.06 4,256.18 2,851.39 7,107.57 25,915.89 18,808.32 72.57% Operating Supplies 422000 - Other Operating Supplies 48,406.44 129,215.66 40,506.39 169,722.05 235,350.78 65,628.73 27.89% 422001 - C.S. Gasoline 10,913.63 42,889.47 - 42,889.47 164,871.00 121,981.53 73.99% 422002 - Diesel/CNG 1,171.80 1,171.80 - 1,171.80 - (1,171.80) 0.00% 422003 - Gasoline 1,345.00 4,946.08 - 4,946.08 25,908.00 20,961.92 80.91% 422005 - Uniforms - 1,603.00 550.10 2,153.10 13,428.00 11,274.90 83.97% 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 818.14 5,756.31 - 5,756.31 17,637.19 11,880.88 67.36% 422009 - Recreation Supplies 13,771.46 45,977.09 1,793.26 47,770.35 306,843.82 259,073.47 84.43% 422010 - Plants Chemicals Seed & Fertilizer 12,361.15 66,225.92 18,606.86 84,832.78 159,433.77 74,600.99 46.79% 422013 - Promotional Supplies 642.40 642.40 - 642.40 - (642.40) 0.00% 422014 - Concessions Inventory 15,702.78 16,068.56 - 16,068.56 116,500.00 100,431.44 86.21% 422016 - Inventory For Sale 1,180.62 30,339.05 7,935.92 38,274.97 38,000.00 (274.97) (0.72%) Total Operating Supplies 106,313.42 345,387.33 69,392.53 414,779.86 1,078,525.56 663,745.70 61.54% Repair & Maintenance Supplies 423000 - Other R&M Supplies 20,109.44 37,879.80 21,768.08 59,647.88 269,956.86 210,308.98 77.90% 423001 - Building Materials 1,736.72 7,077.79 3,155.11 10,232.90 92,757.51 82,524.61 88.97% 423006 - Small Tools & Equipment 2,434.74 40,251.30 - 40,251.30 56,748.00 16,496.70 29.07% 423009 - Repair Parts 5,694.58 18,447.97 1,860.79 20,308.76 76,411.53 56,102.77 73.42% Total Repair & Maintenance Supplies 29,975.48 103,656.86 26,783.98 130,440.84 495,873.90 365,433.06 73.69% Total Supplies Expenditures 136,865.96 453,300.37 99,027.90 552,328.27 1,600,315.35 1,047,987.08 65.49% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 5,906.03 21,914.57 30,717.59 52,632.16 160,357.96 107,725.80 67.18% 431001 - Legal Services 195.00 195.00 - 195.00 - (195.00) 0.00% 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 0.00% 431019 - Security Services 267.28 16,865.88 - 16,865.88 202,316.00 185,450.12 91.66% Total Professional Services 6,368.31 38,990.45 30,717.59 69,708.04 362,688.96 292,980.92 80.78% Communication & Transportation 432002 - Mailing 12.10 161.23 - 161.23 5,019.00 4,857.77 96.79% 432003 - Travel - - - - 27,856.00 27,856.00 100.00% 432004 - Telecommunications 221.65 1,648.00 4,071.81 5,719.81 11,049.81 5,330.00 48.24% 432005 - Mileage Reimb - - - - 9,744.00 9,744.00 100.00% Total Communication & Transportation 233.75 1,809.23 4,071.81 5,881.04 53,668.81 47,787.77 89.04% Printing & Advertising 433001 - Outside Printing Services 3,518.75 3,607.75 - 3,607.75 31,906.00 28,298.25 88.69% 433002 - Publication of Legal Notice - 286.94 58.68 345.62 2,322.74 1,977.12 85.12% 433003 - Promotional 18,273.06 38,707.73 38,195.87 76,903.60 249,702.90 172,799.30 69.20% Total Printing & Advertising 21,791.81 42,602.42 38,254.55 80,856.97 283,931.64 203,074.67 71.52% Utilties 435001 - Electric 37,532.86 170,425.33 - 170,425.33 376,926.00 206,500.67 54.79% 435002 - Natural Gas 16,806.56 89,749.28 - 89,749.28 100,297.00 10,547.72 10.52% 435004 - Water 8,529.83 66,738.22 - 66,738.22 198,000.00 131,261.78 66.29% Total Utilities 62,869.25 326,912.83 - 326,912.83 675,223.00 348,310.17 51.58% Repairs & Maintenance 436000 - Other R&M 3,579.50 13,240.50 31,315.12 44,555.62 35,981.12 (8,574.50) (23.83%) 436001 - Building R&M 4,683.45 12,787.15 88,368.44 101,155.59 196,610.44 95,454.85 48.55% 436003 - Auto Equip R&M 20,522.93 101,034.30 11,463.26 112,497.56 332,991.00 220,493.44 66.22% 436005 - Other Equip R&M - - 159.00 159.00 159.00 - 0.00% 436006 - Radio Equip R&M 350.00 3,104.12 - 3,104.12 5,155.00 2,050.88 39.78% 436011 - Exterminating 788.50 2,615.64 10,482.00 13,097.64 9,481.00 (3,616.64) (38.15%) Total Repairs & Maintenance 29,924.38 132,781.71 141,787.82 274,569.53 580,377.56 305,808.03 52.69% 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 104,071.73 152,336.05 - 152,336.05 459,625.00 307,288.95 66.86% 438200 - Interest 1,567.95 9,540.10 - 9,540.10 34,584.00 25,043.90 72.41% Total Debt Service 105,639.68 161,876.15 - 161,876.15 494,209.00 332,332.85 67.25% Other Charges & Services 439000 - Misc Charges & Svcs 9,146.72 66,878.87 95,418.08 162,296.95 323,147.80 160,850.85 49.78% 439001 - Other Contractual Services 1,164.56 3,466.04 4,374.26 7,840.30 61,321.26 53,480.96 87.21% 439002 - Licenses & Permits 1,684.37 8,392.86 - 8,392.86 6,562.00 (1,830.86) (27.90%) 439003 - Subscriptions 77.94 397.81 - 397.81 1,731.00 1,333.19 77.02% 439004 - Dues & Memberships 25.00 1,853.99 - 1,853.99 18,975.00 17,121.01 90.23% 439005 - Bank & Credit Card Fees 3,596.91 22,168.90 - 22,168.90 37,800.00 15,631.10 41.35% 439006 - Education & Training 743.50 2,937.84 1,100.00 4,037.84 26,879.00 22,841.16 84.98% 439009 - Trash Removal 3,866.94 7,484.48 17,371.88 24,856.36 30,943.18 6,086.82 19.67% 439012 - Uniform Services - 3,851.13 - 3,851.13 3,852.00 0.87 0.02% 439099 - Cashier Over/Short (46.03) (62.18) - (62.18) - 62.18 0.00% 439100 - Refunds/Awards/Indemnities 631.82 4,759.19 - 4,759.19 20,000.00 15,240.81 76.20% 439300 - Grants & Subsidies 350,000.00 715,000.00 - 715,000.00 715,000.00 - 0.00% Total Other Services & Charges 370,891.73 837,128.93 118,264.22 955,393.15 1,246,211.24 290,818.09 23.34% Total Services & Charges Expenditures 597,718.91 1,554,101.72 333,795.99 1,887,897.71 3,710,210.21 1,822,312.50 49.12% Capital Outlay Buildings 443001 - Building Improvements - - 73,450.00 73,450.00 - (73,450.00) 0.00% Total Buildings - - 73,450.00 73,450.00 - (73,450.00) 0.00% 444000 - Land Improvements 687.50 109,780.85 350,989.31 460,770.16 380,912.91 (79,857.25) (20.96%) 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 687.50 109,780.85 448,939.31 558,720.16 780,912.91 222,192.75 28.45% Other Uses 452002 - Allocations-Admin Cost 57,573.00 230,293.00 - 230,293.00 690,877.00 460,584.00 66.67% 452003 - Allocations-IT 54,596.00 218,381.00 - 218,381.00 655,149.00 436,768.00 66.67% 452004 - Allocations-Liability Insurance 18,500.00 73,988.00 - 73,988.00 221,988.00 148,000.00 66.67% 452008 - Allocations-Payroll Cost 6,680.00 26,716.00 - 26,716.00 80,156.00 53,440.00 66.67% 452009 - Allocations-Facilities Mgmt 1,654.00 6,613.00 - 6,613.00 19,845.00 13,232.00 66.68% Total Other Uses 139,003.00 555,991.00 - 555,991.00 1,668,015.00 1,112,024.00 66.67% Total Expenditures 1,662,567.19 5,215,363.17 881,763.20 6,097,126.37 15,607,897.47 9,510,771.10 60.94%