Loading...
HomeMy WebLinkAboutOct 23 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 83% Parks General Fund: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Taxes Property Taxes 311000 - Civil City Property Taxes - 6,352,360.58 11,426,846.00 5,074,485.42 55.59% Total Property Taxes - 6,352,360.58 11,426,846.00 5,074,485.42 55.59% Total Taxes - 6,352,360.58 11,426,846.00 5,074,485.42 55.59% State Shared Revenue 335002 - Vehicle/Aircraft Excise - 341,236.98 730,198.00 388,961.02 46.73% 335007 - Commercial Vehicle Excise - 91,464.69 170,564.00 79,099.31 53.62% Total State Shared Revenue - 432,701.67 900,762.00 468,060.33 48.04% Total Intergovernmental Revenue - 567,701.67 1,035,762.00 468,060.33 54.81% Total Nonbusiness Licenses & Permits - 157.50 - (157.50) 0.00% Total Licenses & Permits - 157.50 - (157.50) 0.00% Charges for Services Culture & Recreation 347001 - Swimming Pool - 37,435.91 30,000.00 (7,435.91) 124.79% 347002 - Picnic Site Rental 15.79 3,345.80 6,154.00 2,808.20 54.37% 347003 - Golf Season Pass (75.00) 287,409.19 221,898.00 (65,511.19) 129.52% 347004 - Golf Green Fees 57,278.50 842,079.99 785,529.00 (56,550.99) 107.20% 347005 - Golf Cart Rentals 29,457.86 392,103.33 392,284.00 180.67 99.95% 347006 - Golf Pro Shop Retail 4,873.99 86,494.12 77,652.00 (8,842.12) 111.39% 347007 - Golf Driving Range 2,526.00 45,722.95 34,323.00 (11,399.95) 133.21% 347009 - Golf Outings - 13,493.40 - (13,493.40) 0.00% 347010 - Concession Sales 2,507.69 72,526.68 56,200.00 (16,326.68) 129.05% 347011 - Recreational Programming 15,486.15 377,283.32 372,321.00 (4,962.32) 101.33% 347012 - Food Sales 5,570.76 68,349.60 68,447.00 97.40 99.86% 347013 - Nonalcoholic Beverage 2,567.30 40,226.06 41,633.00 1,406.94 96.62% 347014 - Alcoholic Beverage Sales 9,541.19 163,362.51 151,573.00 (11,789.51) 107.78% 347015 - Lease of Stadium - 75,000.00 75,000.00 - 100.00% 347016 - East Race Waterway - 66,193.50 50,000.00 (16,193.50) 132.39% 347017 - Ice Skating 3,588.00 198,422.74 400,000.00 201,577.26 49.61% 347021 - Tree Maintenance 2,987.00 26,959.59 - (26,959.59) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% 347024 - Sponsorship Income - 3,500.00 - (3,500.00) 0.00% 347026 - Room Rental 2,991.85 68,743.97 57,972.00 (10,771.97) 118.58% 347030 - Merch Sales 101.43 1,127.34 - (1,127.34) 0.00% 347040 - Pavilion Rental 83.53 27,037.17 33,710.00 6,672.83 80.21% 347100 - Concessions-Employee Discounts (163.40) (2,228.59) - 2,228.59 0.00% Total Culture & Recreation 139,338.64 2,894,588.58 2,856,696.00 (37,892.58) 101.33% Total Charges for Services 139,338.64 2,894,588.58 2,856,696.00 (37,892.58) 101.33% Miscellaneous Revenue 360000 - Miscellaneous 1,244.40 10,795.80 6,483.00 (4,312.80) 166.52% 360001 - Sale of Scrap Metal 195.31 1,319.42 - (1,319.42) 0.00% 360011 - Settlement Fees - 50,450.00 - (50,450.00) 0.00% 361000 - Interest Earnings 16,348.23 98,808.97 15,000.00 (83,808.97) 658.73% 362000 - Rental of Property - 62,501.50 72,337.00 9,835.50 86.40% 367000 - Donations from Private Sources - 1,445,800.00 5,184,000.00 3,738,200.00 27.89% Total Miscellaneous Revenue 17,787.94 1,669,675.69 5,277,820.00 3,608,144.31 31.64% Refunds & Reimbursements 380000 - Misc Reimbursements 439.10 54,173.14 45,000.00 (9,173.14) 120.38% 396000 - Refunds 2,268.30 3,592.77 - (3,592.77) 0.00% Total Refunds & Reimbursements 2,707.40 57,765.91 45,000.00 (12,765.91) 128.37% Other Sources 391000 - Interfund Transfers In 488,414.75 4,395,732.75 5,860,977.00 1,465,244.25 75.00% 392000 - Gain/Loss on Sale of Asset - 37,352.00 - (37,352.00) 0.00% 392005 - Sale of Non-Capital Assets - 8,418.00 - (8,418.00) 0.00% 393000 - Capital Lease Proceeds - - 436,000.00 436,000.00 0.00% Total Other Sources 488,414.75 4,441,502.75 6,296,977.00 1,855,474.25 70.53% October 31, 2023 Total Revenue 648,248.73 15,983,752.68 26,939,101.00 10,955,348.32 59.33% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent of Account String Month Expenses Encumbrances w/ Encumb. Budget Budget Budget Personnel Expenses Salaries & Wages 410001 - Salaried Wages 250,409.44 2,644,500.23 - 2,644,500.23 3,467,002.00 822,501.77 76.28% 410002 - Teamster Wages 117,444.22 1,272,185.31 - 1,272,185.31 1,630,310.00 358,124.69 78.03% 410003 - Permanent Part Time 89,076.44 988,529.12 - 988,529.12 1,042,770.00 54,240.88 94.80% 410004 - Extra & Overtime 7,586.78 111,614.77 - 111,614.77 71,850.00 (39,764.77) 155.34% 410005 - Seasonal & Interns 42,320.15 679,619.44 - 679,619.44 828,351.00 148,731.56 82.04% 410007 - Longevity Pay 350.00 6,237.50 - 6,237.50 9,389.00 3,151.50 66.43% 410017 - Stand By Pay - 2,513.66 - 2,513.66 - (2,513.66) 0.00% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 507,187.03 5,705,200.03 - 5,705,200.03 7,050,872.00 1,345,671.97 80.91% Employee Benefits 411001 - FICA Regular 37,559.10 449,237.60 - 449,237.60 542,270.00 93,032.40 82.84% 411004 - PERF Regular 39,624.23 437,181.68 - 437,181.68 582,642.00 145,460.32 75.03% 411005 - PERF Union 1,150.27 13,110.61 - 13,110.61 24,703.00 11,592.39 53.07% 411007 - Unemployment Comp 38.74 414.84 - 414.84 6,200.00 5,785.16 6.69% 411008 - Health Insurance 89,185.78 882,137.18 - 882,137.18 1,274,947.00 392,809.82 69.19% 411009 - Life Insurance 870.00 8,545.00 - 8,545.00 10,920.00 2,375.00 78.25% 411010 - Med/Surgical/Dental 1,042.24 10,320.95 - 10,320.95 - (10,320.95) 0.00% 411014 - Parental Leave 1,326.37 14,042.61 - 14,042.61 18,082.00 4,039.39 77.66% 411015 - Other Fringe Benefits - 1,400.00 - 1,400.00 1,400.00 - 100.00% 411200 - Clothing Allowance - 353.08 - 353.08 356.00 2.92 99.18% 411201 - Tool Allowance 699.72 3,664.67 - 3,664.67 4,444.00 779.33 82.46% 411203 - Job Readiness Allow. - - - - 15,725.00 15,725.00 0.00% 411204 - Auto Allowance - 1,333.30 - 1,333.30 3,200.00 1,866.70 41.67% 411206 - Cell Phone Allowance 715.00 8,030.00 - 8,030.00 11,880.00 3,850.00 67.59% Total Employee Benefits 172,211.45 1,829,771.52 - 1,829,771.52 2,496,769.00 666,997.48 73.29% Total Personnel Expenses 679,398.48 7,534,971.55 - 7,534,971.55 9,547,641.00 2,012,669.45 78.92% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,622.18 12,733.73 1,682.81 14,416.54 19,196.05 4,779.51 75.10% Total Office Supplies 1,622.18 12,733.73 1,682.81 14,416.54 19,196.05 4,779.51 75.10% Operating Supplies 422000 - Other Operating Supplies 25,729.75 266,217.04 23,036.89 289,253.93 308,311.06 19,057.13 93.82% 422001 - C.S. Gasoline 16,933.42 184,432.86 - 184,432.86 220,000.00 35,567.14 83.83% 422002 - Diesel/CNG 2,038.58 10,502.17 - 10,502.17 11,936.00 1,433.83 87.99% 422003 - Gasoline 1,496.50 14,903.09 2,233.40 17,136.49 27,981.50 10,845.01 61.24% 422005 - Uniforms 1,183.33 9,165.39 373.52 9,538.91 21,982.25 12,443.34 43.39% 422006 - Computer Supplies & Equipment - 4,010.94 - 4,010.94 4,011.00 0.06 100.00% 422007 - Cleaning Supplies 1,780.98 2,773.12 - 2,773.12 6,120.00 3,346.88 45.31% 422008 - Medical/Safety Supplies 2,638.60 12,557.32 - 12,557.32 15,809.00 3,251.68 79.43% 422009 - Recreation Supplies 6,629.19 65,448.83 10,647.47 76,096.30 133,697.68 57,601.38 56.92% 422010 - Plants Chemicals Seed & Fertilizer 20,152.89 205,838.98 17,506.08 223,345.06 254,474.00 31,128.94 87.77% 422014 - Concessions Inventory 21,130.50 170,512.61 1,387.32 171,899.93 188,408.32 16,508.39 91.24% 422016 - Inventory For Sale 600.02 62,582.41 2,125.21 64,707.62 69,742.21 5,034.59 92.78% Total Operating Supplies 100,313.76 1,008,944.76 57,309.89 1,066,254.65 1,262,473.02 196,218.37 84.46% Repair & Maintenance Supplies 423000 - Other R&M Supplies 16,881.22 195,635.45 9,459.04 205,094.49 231,332.81 26,238.32 88.66% 423001 - Building Materials 12,472.53 84,104.63 392.83 84,497.46 155,169.45 70,671.99 54.45% 423006 - Small Tools & Equipment 13,054.83 53,833.04 805.79 54,638.83 57,221.00 2,582.17 95.49% 423009 - Repair Parts 14,351.85 92,441.85 26,045.33 118,487.18 114,018.24 (4,468.94) 103.92% Total Repair & Maintenance Supplies 56,760.43 426,014.97 36,702.99 462,717.96 557,741.50 95,023.54 82.96% Total Supplies Expenses 158,696.37 1,447,693.46 95,695.69 1,543,389.15 1,839,410.57 296,021.42 83.91% Services & Charges Expenses Professional Services 431000 - Other Professional Services 7,186.24 235,884.15 60,552.13 296,436.28 307,744.71 11,308.43 96.33% 431001 - Legal Services 3,252.50 17,836.00 60,844.50 78,680.50 79,500.00 819.50 98.97% 431009 - Computer & Technology - 7,789.95 - 7,789.95 8,275.00 485.05 94.14% 431014 - Collection Costs - 64.50 43.75 108.25 100.00 (8.25) 108.25% 431019 - Security Services 6,237.79 47,801.84 20,481.00 68,282.84 74,869.00 6,586.16 91.20% Total Professional Services 16,676.53 309,376.44 141,921.38 451,297.82 470,488.71 19,190.89 95.92% Communication & Transportation 432002 - Mailing 317.62 6,146.74 108.70 6,255.44 7,075.00 819.56 88.42% 432003 - Travel 4,081.29 9,973.38 15,340.24 25,313.62 36,880.41 11,566.79 68.64% 432004 - Telecommunications 87.72 1,402.19 2,145.20 3,547.39 12,523.80 8,976.41 28.33% 432005 - Mileage Reimb 134.86 1,266.52 176.96 1,443.48 6,494.96 5,051.48 22.22% Total Communication & Transportation 4,621.49 18,788.83 17,771.10 36,559.93 62,974.17 26,414.24 58.06% Printing & Advertising 433001 - Outside Printing Services 1,004.82 6,440.16 1,446.75 7,886.91 15,165.00 7,278.09 52.01% 433002 - Publication of Legal Notice 114.70 1,271.10 759.21 2,030.31 3,277.72 1,247.41 61.94% 433003 - Promotional 47,110.14 456,857.21 109,665.17 566,522.38 698,808.90 132,286.52 81.07% Total Printing & Advertising 48,229.66 464,568.47 111,871.13 576,439.60 717,251.62 140,812.02 80.37% Utilties 435001 - Electric 35,974.04 435,145.48 - 435,145.48 538,707.00 103,561.52 80.78% 435002 - Natural Gas 3,134.19 137,484.78 - 137,484.78 309,583.00 172,098.22 44.41% 435004 - Water 25,066.53 231,550.56 - 231,550.56 300,000.00 68,449.44 77.18% Total Utilities 64,174.76 804,180.82 - 804,180.82 1,148,290.00 344,109.18 70.03% Repairs & Maintenance 436000 - Other R&M 1,438.00 94,356.30 58,835.75 153,192.05 181,322.99 28,130.94 84.49% 436001 - Building R&M 34,378.75 421,371.43 60,463.29 481,834.72 493,352.60 11,517.88 97.67% 436003 - Auto Equip R&M 32,320.26 232,076.54 - 232,076.54 321,750.00 89,673.46 72.13% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 6,992.10 75.68 98.92% 436006 - Radio Equip R&M 3,888.26 25,412.08 - 25,412.08 16,814.00 (8,598.08) 151.14% 436011 - Exterminating 1,251.00 6,112.00 7,275.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 73,276.27 786,244.77 126,574.04 912,818.81 1,036,573.69 123,754.88 88.06% Rentals 437002 - Equipment Rental - 11,226.50 - 11,226.50 13,421.00 2,194.50 83.65% 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 100.00% 437006 - Recreation Space Rental - 1,200.00 - 1,200.00 1,260.00 60.00 95.24% Total Rentals - 24,426.50 - 24,426.50 26,681.00 2,254.50 91.55% Debt Service 438100 - Principal - 462,762.21 394,615.82 857,378.03 924,133.00 66,754.97 92.78% 438200 - Interest - 51,794.54 71,861.44 123,655.98 107,258.00 (16,397.98) 115.29% 438300 - Paying Agent Fees - 5,200.00 - 5,200.00 5,500.00 300.00 94.55% Total Debt Service - 519,756.75 466,477.26 986,234.01 1,036,891.00 50,656.99 95.11% Other Charges & Services 439000 - Misc Charges & Svcs 47,415.00 186,623.42 51,326.29 237,949.71 290,752.96 52,803.25 81.84% 439001 - Other Contractual Services 15,690.10 147,604.00 7,608.40 155,212.40 209,784.00 54,571.60 73.99% 439002 - Licenses & Permits 48.84 6,797.95 900.00 7,697.95 12,540.00 4,842.05 61.39% 439003 - Subscriptions 72.99 5,728.21 - 5,728.21 5,914.00 185.79 96.86% 439004 - Dues & Memberships 175.00 12,391.91 - 12,391.91 22,347.00 9,955.09 55.45% 439005 - Bank & Credit Card Fees 4,021.04 84,091.27 - 84,091.27 98,273.00 14,181.73 85.57% 439006 - Education & Training 4,106.50 35,939.77 16,272.53 52,212.30 56,669.45 4,457.15 92.13% 439009 - Trash Removal 7,321.86 48,511.89 3,041.34 51,553.23 56,567.03 5,013.80 91.14% 439012 - Uniform Services 1,445.87 17,618.85 - 17,618.85 25,941.00 8,322.15 67.92% 439018 - Demolition & Clearance - 18,000.00 - 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 4.86 1,879.45 - 1,879.45 10.00 (1,869.45) 18794.50% 439100 - Refunds/Awards/Indemnities - 5,284.07 - 5,284.07 30,187.00 24,902.93 17.50% 439300 - Grants & Subsidies 10,514.73 631,975.74 40.00 632,015.74 645,000.00 12,984.26 97.99% Total Other Services & Charges 90,816.79 1,202,446.53 79,188.56 1,281,635.09 1,471,985.44 190,350.35 87.07% Total Services & Charges Expenses 297,795.50 4,129,789.11 943,803.47 5,073,592.58 5,971,135.63 897,543.05 84.97% Capital Outlay Buildings 443001 - Building Improvements - - 5,729,840.98 5,729,840.98 6,000,250.00 270,409.02 95.49% Total Buildings - - 5,729,840.98 5,729,840.98 6,000,250.00 270,409.02 95.49% 444000 - Land Improvements 340.00 313,371.45 454,868.26 768,239.71 2,037,472.38 1,269,232.67 37.71% Machinery & Equipment 445000 - Motor Equipment - - - - 21,726.00 21,726.00 0.00% 445003 - Park Equipment 9,600.00 346,897.64 646,284.43 993,182.07 1,207,819.00 214,636.93 82.23% 445008 - Other Equipment - 29,121.03 - 29,121.03 29,121.03 - 100.00% 445100 - Lease Purchase/Motor Equip - 599,918.83 362,446.66 962,365.49 1,047,863.30 85,497.81 91.84% Total Machinery & Equipment 9,600.00 975,937.50 1,008,731.09 1,984,668.59 2,306,529.33 321,860.74 86.05% Total Capital Expenses 9,940.00 1,289,308.95 7,193,440.33 8,482,749.28 10,344,251.71 1,861,502.43 82.00% Other Uses 452002 - Allocations-Admin Cost 62,863.68 628,636.80 - 628,636.80 754,364.00 125,727.20 83.33% 452003 - Allocations-IT 62,116.42 621,164.20 - 621,164.20 745,397.00 124,232.80 83.33% 452004 - Allocations-Liability Insurance 23,170.33 231,703.30 - 231,703.30 278,044.00 46,340.70 83.33% 452008 - Allocations-Payroll Cost 7,032.25 70,322.50 - 70,322.50 84,387.00 14,064.50 83.33% 452009 - Allocations-Facilities Mgmt 2,436.75 24,367.50 - 24,367.50 29,241.00 4,873.50 83.33% Total Other Uses 157,619.43 1,576,194.30 - 1,576,194.30 1,891,433.00 315,238.70 83.33% Total Expenses 1,303,449.78 15,977,957.37 8,232,939.49 24,210,896.86 29,593,871.91 5,382,975.05 81.81%