Loading...
HomeMy WebLinkAboutMar 21 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 25% 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 - - 33,766.00 33,766.00 100.00% 347002 - Picnic Site Rental 82.62 82.62 2,952.00 2,869.38 97.20% 347003 - Golf Season Pass 39,145.10 185,158.85 175,000.00 (10,158.85) (5.81%) 347004 - Golf Green Fees 28,308.00 28,308.00 684,000.00 655,692.00 95.86% 347005 - Golf Cart Rentals 11,673.54 11,673.54 350,000.00 338,326.46 96.66% 347006 - Golf Pro Shop Retail 3,613.35 3,660.34 60,000.00 56,339.66 93.90% 347007 - Golf Driving Range 1,711.00 1,711.00 25,000.00 23,289.00 93.16% 347008 - Golf Gift Certificate 280.83 (10,893.89) - 10,893.89 0.00% 347010 - Concession Sales 176.00 176.00 - (176.00) 0.00% 347011 - Recreational Programming 91,595.81 107,923.47 718,384.00 610,460.53 84.98% 347012 - Food Sales 1,682.10 1,682.10 90,939.00 89,256.90 98.15% 347013 - Nonalcoholic Beverage 749.61 938.40 60,820.00 59,881.60 98.46% 347014 - Alcoholic Beverage Sales 3,348.85 3,362.86 100,000.00 96,637.14 96.64% 347015 - Lease of Stadium 5,000.00 15,000.00 75,000.00 60,000.00 80.00% 347016 - East Race Waterway - - 38,504.00 38,504.00 100.00% 347017 - Ice Skating 29,023.89 161,174.30 120,000.00 (41,174.30) (34.31%) 347018 - Skate Rental - 120.00 - (120.00) 0.00% 347019 - Site Mowing - - 95,000.00 95,000.00 100.00% 347021 - Tree Maintenance 515.00 3,139.40 120,000.00 116,860.60 97.38% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% 347026 - Room Rental 7,511.20 11,802.21 - (11,802.21) 0.00% 347030 - Merch Sales 159.05 679.00 - (679.00) 0.00% 347040 - Pavilion Rental 3,662.32 3,662.32 12,490.00 8,827.68 70.68% 347041 - Picnic Shelter - - 17,066.00 17,066.00 100.00% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347100 - Concessions-Employee Discounts (31.35) (31.35) - 31.35 0.00% 347101 - Room Rental-Employee Discounts (71.46) (71.46) - 71.46 0.00% Total Culture & Recreation 228,135.46 533,145.66 2,881,450.00 2,348,304.34 81.50% Total Charges for Services 228,135.46 533,145.66 2,881,450.00 2,348,304.34 81.50% Miscellaneous Revenue 360000 - Miscellaneous 898.34 1,564.90 25,000.00 23,435.10 93.74% 360001 - Sale of Scrap Metal - 154.24 - (154.24) 0.00% 361000 - Interest Earnings 697.24 5,394.39 40,000.00 34,605.61 86.51% 362000 - Rental of Property 5,415.75 25,615.75 - (25,615.75) 0.00% 367000 - Donations from Private Sources 284,459.00 730,029.00 715,000.00 (15,029.00) (2.10%) Total Miscellaneous Revenue 291,470.33 762,758.28 780,000.00 17,241.72 2.21% Refunds & Reimbursements 380000 - Misc Reimbursements 25.00 9,640.37 - (9,640.37) 0.00% 396000 - Refunds 262.94 3,552.26 - (3,552.26) 0.00% Total Refunds & Reimbursements 287.94 13,192.63 - (13,192.63) 0.00% Other Sources 391000 - Interfund Transfers In 102,711.00 308,142.00 1,234,486.00 926,344.00 75.04% Total Other Sources 102,711.00 308,142.00 1,234,486.00 926,344.00 - March 31, 2021 Total Revenue 622,604.73 1,617,238.57 15,050,019.00 13,432,780.43 89.25% 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,479.21 694,092.02 - 694,092.02 2,826,600.00 2,132,507.98 75.44% 410002 - Teamster Wages 111,025.91 333,657.25 - 333,657.25 1,437,385.00 1,103,727.75 76.79% 410003 - Permanent Part Time 34,816.48 101,460.62 - 101,460.62 656,511.00 555,050.38 84.55% 410004 - Extra & Overtime 4,969.83 24,471.89 - 24,471.89 58,895.00 34,423.11 58.45% 410005 - Seasonal & Interns 25,509.61 86,345.38 - 86,345.38 841,760.00 755,414.62 89.74% 410007 - Longevity Pay 1,050.00 2,700.00 - 2,700.00 8,050.00 5,350.00 66.46% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 100.00% Total Salaries & Wages 383,851.04 1,242,727.16 - 1,242,727.16 5,830,401.00 4,587,673.84 78.69% Employee Benefits 411001 - FICA Regular 28,874.68 93,611.10 - 93,611.10 449,080.00 355,468.90 79.15% 411004 - PERF Regular 37,036.65 116,017.34 - 116,017.34 489,666.00 373,648.66 76.31% 411005 - PERF Union 1,382.06 4,482.58 - 4,482.58 22,866.00 18,383.42 80.40% 411007 - Unemployment Comp 32.46 105.81 - 105.81 1,278.00 1,172.19 91.72% 411008 - Health Insurance 88,798.92 268,524.43 - 268,524.43 988,554.00 720,029.57 72.84% 411009 - Life Insurance 870.00 2,625.00 - 2,625.00 10,320.00 7,695.00 74.56% 411014 - Parental Leave 1,134.40 3,699.22 - 3,699.22 15,159.00 11,459.78 75.60% 411015 - Other Fringe Benefits - 1,600.00 - 1,600.00 1,600.00 - 0.00% 411201 - Tool Allowance 624.60 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 799.98 - 799.98 3,200.00 2,400.02 75.00% 411206 - Cell Phone Allowance 1,210.00 3,630.00 - 3,630.00 17,820.00 14,190.00 79.63% Total Employee Benefits 160,230.43 511,170.25 - 511,170.25 2,018,043.00 1,506,872.75 74.67% Total Personnel Expenditures 544,081.47 1,753,897.41 - 1,753,897.41 7,848,444.00 6,094,546.59 77.65% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 671.07 2,779.67 32.39 2,812.06 2,767.89 (44.17) (1.60%) 421002 - Stationary & Printing 745.41 899.45 2,819.00 3,718.45 23,258.00 19,539.55 84.01% Total Office Supplies 1,416.48 3,679.12 2,851.39 6,530.51 26,025.89 19,495.38 74.91% Operating Supplies 422000 - Other Operating Supplies 42,680.71 80,809.22 65,178.92 145,988.14 235,560.78 89,572.64 38.03% 422001 - C.S. Gasoline 13,845.83 31,975.84 - 31,975.84 164,871.00 132,895.16 80.61% 422002 - Diesel/CNG - - 1,171.80 1,171.80 - (1,171.80) 0.00% 422003 - Gasoline 3,038.33 3,601.08 1,345.00 4,946.08 25,908.00 20,961.92 80.91% 422005 - Uniforms 1,603.00 1,603.00 523.50 2,126.50 13,428.00 11,301.50 84.16% 422006 - Computer Supplies & Equipment 319.93 319.93 - 319.93 - (319.93) 0.00% 422007 - Cleaning Supplies - 232.06 - 232.06 233.00 0.94 0.40% 422008 - Medical/Safety Supplies 3,109.99 4,938.17 - 4,938.17 17,637.19 12,699.02 72.00% 422009 - Recreation Supplies 13,347.22 32,205.63 2,228.04 34,433.67 306,843.82 272,410.15 88.78% 422010 - Plants Chemicals Seed & Fertilizer 50,112.50 53,864.77 17,032.36 70,897.13 159,433.77 88,536.64 55.53% 422014 - Concessions Inventory 365.78 365.78 7,356.11 7,721.89 116,500.00 108,778.11 93.37% 422016 - Inventory For Sale 29,158.43 29,158.43 8,864.49 38,022.92 38,000.00 (22.92) (0.06%) Total Operating Supplies 157,581.72 239,073.91 103,700.22 342,774.13 1,078,415.56 735,641.43 68.22% Repair & Maintenance Supplies 423000 - Other R&M Supplies 6,302.43 17,770.36 29,028.22 46,798.58 269,956.86 223,158.28 82.66% 423001 - Building Materials 292.05 5,341.07 4,286.53 9,627.60 92,757.51 83,129.91 89.62% 423006 - Small Tools & Equipment 1,133.11 37,816.56 1,623.98 39,440.54 56,748.00 17,307.46 30.50% 423009 - Repair Parts 6,140.80 12,753.39 1,372.04 14,125.43 76,411.53 62,286.10 81.51% Total Repair & Maintenance Supplies 13,868.39 73,681.38 36,310.77 109,992.15 495,873.90 385,881.75 77.82% Total Supplies Expenditures 172,866.59 316,434.41 142,862.38 459,296.79 1,600,315.35 1,141,018.56 71.30% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 7,952.97 16,008.54 20,935.68 36,944.22 160,357.96 123,413.74 76.96% 431001 - Legal Services - - 195.00 195.00 - (195.00) 0.00% 431015 - Laboratory Water Testing - 15.00 - 15.00 15.00 - 0.00% 431019 - Security Services 14,707.87 16,598.60 - 16,598.60 202,316.00 185,717.40 91.80% Total Professional Services 22,660.84 32,622.14 21,130.68 53,752.82 362,688.96 308,936.14 85.18% Communication & Transportation 432002 - Mailing 0.54 149.13 - 149.13 5,019.00 4,869.87 97.03% 432003 - Travel - - - - 27,856.00 27,856.00 100.00% 432004 - Telecommunications 210.38 1,426.35 4,293.46 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 210.92 1,575.48 4,293.46 5,868.94 53,668.81 47,799.87 89.06% Printing & Advertising 433001 - Outside Printing Services 89.00 89.00 620.00 709.00 31,906.00 31,197.00 97.78% 433002 - Publication of Legal Notice - 286.94 58.68 345.62 2,322.74 1,977.12 85.12% 433003 - Promotional 8,898.29 20,434.67 49,408.37 69,843.04 249,702.90 179,859.86 72.03% Total Printing & Advertising 8,987.29 20,810.61 50,087.05 70,897.66 283,931.64 213,033.98 75.03% Utilties 435001 - Electric 40,611.50 132,892.47 225.00 133,117.47 376,926.00 243,808.53 64.68% 435002 - Natural Gas 21,761.59 72,942.72 - 72,942.72 100,297.00 27,354.28 27.27% 435004 - Water 22,406.28 58,208.39 - 58,208.39 198,000.00 139,791.61 70.60% Total Utilities 84,779.37 264,043.58 225.00 264,268.58 675,223.00 410,954.42 60.86% Repairs & Maintenance 436000 - Other R&M 2,228.00 9,661.00 24,846.12 34,507.12 35,981.12 1,474.00 4.10% 436001 - Building R&M 1,950.90 8,103.70 41,499.44 49,603.14 196,610.44 147,007.30 74.77% 436003 - Auto Equip R&M 38,781.04 80,511.37 11,463.26 91,974.63 332,991.00 241,016.37 72.38% 436005 - Other Equip R&M - - 159.00 159.00 159.00 - 0.00% 436006 - Radio Equip R&M 375.70 2,754.12 - 2,754.12 5,155.00 2,400.88 46.57% 436011 - Exterminating 629.50 1,827.14 10,891.86 12,719.00 9,481.00 (3,238.00) (34.15%) Total Repairs & Maintenance 43,965.14 102,857.33 88,859.68 191,717.01 580,377.56 388,660.55 66.97% 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 259.41 48,264.32 - 48,264.32 459,625.00 411,360.68 89.50% 438200 - Interest 9.17 7,972.15 - 7,972.15 34,584.00 26,611.85 76.95% Total Debt Service 268.58 56,236.47 - 56,236.47 494,209.00 437,972.53 88.62% Other Charges & Services 439000 - Misc Charges & Svcs 8,007.87 57,732.15 37,269.91 95,002.06 323,201.80 228,199.74 70.61% 439001 - Other Contractual Services 1,551.22 2,301.48 4,124.26 6,425.74 61,321.26 54,895.52 89.52% 439002 - Licenses & Permits 1,960.12 6,708.49 - 6,708.49 6,562.00 (146.49) (2.23%) 439003 - Subscriptions 77.94 319.87 - 319.87 1,731.00 1,411.13 81.52% 439004 - Dues & Memberships 1,816.04 1,828.99 - 1,828.99 18,975.00 17,146.01 90.36% 439005 - Bank & Credit Card Fees 6,594.79 18,571.99 - 18,571.99 37,800.00 19,228.01 50.87% 439006 - Education & Training 278.34 2,194.34 1,100.00 3,294.34 26,825.00 23,530.66 87.72% 439009 - Trash Removal 1,527.32 3,617.54 19,933.22 23,550.76 30,943.18 7,392.42 23.89% 439012 - Uniform Services 1,526.42 3,851.13 - 3,851.13 3,852.00 0.87 0.02% 439099 - Cashier Over/Short (18.25) (16.15) - (16.15) - 16.15 0.00% 439100 - Refunds/Awards/Indemnities 1,585.87 4,127.37 - 4,127.37 20,000.00 15,872.63 79.36% 439300 - Grants & Subsidies - 365,000.00 - 365,000.00 715,000.00 350,000.00 48.95% Total Other Services & Charges 24,907.68 466,237.20 62,427.39 528,664.59 1,246,211.24 717,546.65 57.58% Total Services & Charges Expenditures 185,779.82 956,382.81 227,723.26 1,184,106.07 3,710,210.21 2,526,104.14 68.09% Capital Outlay Buildings 443001 - Building Improvements - - 9,600.00 9,600.00 - (9,600.00) 0.00% Total Buildings - - 9,600.00 9,600.00 - (9,600.00) 0.00% 444000 - Land Improvements 468.75 109,093.35 351,416.81 460,510.16 380,912.91 (79,597.25) (20.90%) 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 468.75 109,093.35 385,516.81 494,610.16 780,912.91 286,302.75 36.66% Other Uses 452002 - Allocations-Admin Cost 57,573.00 172,720.00 - 172,720.00 690,877.00 518,157.00 75.00% 452003 - Allocations-IT 54,596.00 163,785.00 - 163,785.00 655,149.00 491,364.00 75.00% 452004 - Allocations-Liability Insurance 18,500.00 55,488.00 - 55,488.00 221,988.00 166,500.00 75.00% 452008 - Allocations-Payroll Cost 6,680.00 20,036.00 - 20,036.00 80,156.00 60,120.00 75.00% 452009 - Allocations-Facilities Mgmt 1,654.00 4,959.00 - 4,959.00 19,845.00 14,886.00 75.01% Total Other Uses 139,003.00 416,988.00 - 416,988.00 1,668,015.00 1,251,027.00 75.00% Total Expenditures 1,042,199.63 3,552,795.98 756,102.45 4,308,898.43 15,607,897.47 11,298,999.04 72.39%