Loading...
HomeMy WebLinkAboutSept 23 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 75% 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 26.25 157.50 - (157.50) 0.00% Total Licenses & Permits 26.25 157.50 - (157.50) 0.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 1,381.40 37,435.91 30,000.00 (7,435.91) 124.79% 347002 - Picnic Site Rental 178.01 3,330.01 6,154.00 2,823.99 54.11% 347003 - Golf Season Pass 350.00 287,409.19 221,898.00 (65,511.19) 129.52% 347004 - Golf Green Fees 120,930.58 783,847.99 785,529.00 1,681.01 99.79% 347005 - Golf Cart Rentals 57,743.19 362,264.18 392,284.00 30,019.82 92.35% 347006 - Golf Pro Shop Retail 13,100.18 81,496.22 77,652.00 (3,844.22) 104.95% 347007 - Golf Driving Range 6,087.95 43,196.95 34,323.00 (8,873.95) 125.85% 347009 - Golf Outings 3,336.31 13,493.40 - (13,493.40) 0.00% 347010 - Concession Sales 4,719.59 70,018.99 56,200.00 (13,818.99) 124.59% 347011 - Recreational Programming 20,499.98 361,797.17 372,321.00 10,523.83 97.17% 347012 - Food Sales 8,922.32 62,778.84 68,447.00 5,668.16 91.72% 347013 - Nonalcoholic Beverage 5,192.75 37,658.76 41,633.00 3,974.24 90.45% 347014 - Alcoholic Beverage Sales 22,821.45 153,821.32 151,573.00 (2,248.32) 101.48% 347015 - Lease of Stadium - 75,000.00 75,000.00 - 100.00% 347016 - East Race Waterway 4,460.00 66,193.50 50,000.00 (16,193.50) 132.39% 347017 - Ice Skating - 182,387.99 400,000.00 217,612.01 45.60% 347021 - Tree Maintenance 1,644.00 23,972.59 - (23,972.59) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% 347024 - Sponsorship Income 3,500.00 3,500.00 - (3,500.00) 0.00% 347026 - Room Rental 2,215.56 65,752.12 57,972.00 (7,780.12) 113.42% 347030 - Merch Sales 113.60 1,025.91 - (1,025.91) 0.00% 347040 - Pavilion Rental 2,689.42 26,953.64 33,710.00 6,756.36 79.96% 347100 - Concessions-Employee Discounts (261.06) (2,065.19) - 2,065.19 0.00% Total Culture & Recreation 279,625.23 2,741,269.49 2,856,696.00 115,426.51 95.96% Total Charges for Services 279,625.23 2,741,269.49 2,856,696.00 115,426.51 95.96% Miscellaneous Revenue 360000 - Miscellaneous 302.99 8,783.90 6,483.00 (2,300.90) 135.49% 360001 - Sale of Scrap Metal 159.38 1,124.11 - (1,124.11) 0.00% 360011 - Settlement Fees - 50,450.00 - (50,450.00) 0.00% 361000 - Interest Earnings 17,516.26 81,822.57 15,000.00 (66,822.57) 545.48% 362000 - Rental of Property 6,028.09 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 24,006.72 1,650,482.08 5,277,820.00 3,627,337.92 31.27% Refunds & Reimbursements 380000 - Misc Reimbursements 32.00 53,734.04 45,000.00 (8,734.04) 119.41% 396000 - Refunds - 1,324.47 - (1,324.47) 0.00% Total Refunds & Reimbursements 32.00 55,058.51 45,000.00 (10,058.51) 122.35% Other Sources 391000 - Interfund Transfers In - 3,418,903.25 5,860,977.00 2,442,073.75 58.33% 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 - 3,464,673.25 6,296,977.00 2,832,303.75 55.02% September 30, 2023 Total Revenue 303,690.20 14,831,703.08 26,939,101.00 12,107,397.92 55.06% 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 362,549.69 2,394,090.79 - 2,394,090.79 3,467,002.00 1,072,911.21 69.05% 410002 - Teamster Wages 169,324.27 1,154,741.09 - 1,154,741.09 1,630,310.00 475,568.91 70.83% 410003 - Permanent Part Time 157,128.54 899,452.68 - 899,452.68 1,042,770.00 143,317.32 86.26% 410004 - Extra & Overtime 22,920.39 104,027.99 - 104,027.99 71,850.00 (32,177.99) 144.78% 410005 - Seasonal & Interns 91,213.28 637,299.29 - 637,299.29 828,351.00 191,051.71 76.94% 410007 - Longevity Pay 850.00 5,887.50 - 5,887.50 9,389.00 3,501.50 62.71% 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 803,986.17 5,198,013.00 - 5,198,013.00 7,050,872.00 1,852,859.00 73.72% Employee Benefits 411001 - FICA Regular 60,619.39 411,678.50 - 411,678.50 542,270.00 130,591.50 75.92% 411004 - PERF Regular 60,115.62 397,557.45 - 397,557.45 582,642.00 185,084.55 68.23% 411005 - PERF Union 1,788.06 11,960.34 - 11,960.34 24,703.00 12,742.66 48.42% 411007 - Unemployment Comp 56.65 376.10 - 376.10 6,200.00 5,823.90 6.07% 411008 - Health Insurance 88,542.68 792,951.40 - 792,951.40 1,274,947.00 481,995.60 62.19% 411009 - Life Insurance 865.00 7,675.00 - 7,675.00 10,920.00 3,245.00 70.28% 411010 - Med/Surgical/Dental 1,034.10 9,278.71 - 9,278.71 - (9,278.71) 0.00% 411014 - Parental Leave 1,917.94 12,716.24 - 12,716.24 18,082.00 5,365.76 70.33% 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 - 2,964.95 500.00 3,464.95 4,444.00 979.05 77.97% 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 7,315.00 - 7,315.00 11,880.00 4,565.00 61.57% Total Employee Benefits 215,654.44 1,657,560.07 500.00 1,658,060.07 2,496,769.00 838,708.93 66.41% Total Personnel Expenses 1,019,640.61 6,855,573.07 500.00 6,856,073.07 9,547,641.00 2,691,567.93 71.81% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,391.67 11,111.55 1,707.79 12,819.34 18,196.05 5,376.71 70.45% Total Office Supplies 1,391.67 11,111.55 1,707.79 12,819.34 18,196.05 5,376.71 70.45% Operating Supplies 422000 - Other Operating Supplies 23,905.28 240,487.29 22,610.44 263,097.73 304,311.06 41,213.33 86.46% 422001 - C.S. Gasoline 17,665.84 167,499.44 - 167,499.44 220,000.00 52,500.56 76.14% 422002 - Diesel/CNG 1,988.50 8,463.59 2,038.58 10,502.17 10,936.00 433.83 96.03% 422003 - Gasoline - 13,406.59 631.50 14,038.09 27,981.50 13,943.41 50.17% 422005 - Uniforms 257.63 7,982.06 - 7,982.06 20,482.25 12,500.19 38.97% 422006 - Computer Supplies & Equipment - 4,010.94 - 4,010.94 3,924.00 (86.94) 102.22% 422007 - Cleaning Supplies 89.83 992.14 - 992.14 6,120.00 5,127.86 16.21% 422008 - Medical/Safety Supplies 434.39 9,918.72 2,318.03 12,236.75 16,309.00 4,072.25 75.03% 422009 - Recreation Supplies 2,961.95 58,819.64 8,304.07 67,123.71 133,697.68 66,573.97 50.21% 422010 - Plants Chemicals Seed & Fertilizer 8,867.18 185,686.09 14,596.08 200,282.17 264,474.00 64,191.83 75.73% 422014 - Concessions Inventory 7,340.25 149,382.11 2,738.01 152,120.12 188,408.32 36,288.20 80.74% 422016 - Inventory For Sale 1,411.77 61,982.39 2,205.31 64,187.70 69,742.21 5,554.51 92.04% Total Operating Supplies 64,922.62 908,631.00 55,442.02 964,073.02 1,266,386.02 302,313.00 76.13% Repair & Maintenance Supplies 423000 - Other R&M Supplies 9,121.76 178,619.85 15,864.86 194,484.71 278,919.81 84,435.10 69.73% 423001 - Building Materials 1,048.18 71,632.10 18,530.36 90,162.46 145,169.45 55,006.99 62.11% 423006 - Small Tools & Equipment 1,581.54 40,778.21 9,306.68 50,084.89 47,221.00 (2,863.89) 106.06% 423009 - Repair Parts 3,747.88 77,700.23 27,284.60 104,984.83 83,518.24 (21,466.59) 125.70% Total Repair & Maintenance Supplies 15,499.36 368,730.39 70,986.50 439,716.89 554,828.50 115,111.61 79.25% Total Supplies Expenses 81,813.65 1,288,472.94 128,136.31 1,416,609.25 1,839,410.57 422,801.32 77.01% Services & Charges Expenses Professional Services 431000 - Other Professional Services 9,950.50 228,697.91 52,134.13 280,832.04 295,384.71 14,552.67 95.07% 431001 - Legal Services 8,728.00 14,583.50 64,097.00 78,680.50 79,500.00 819.50 98.97% 431009 - Computer & Technology 39.95 7,789.95 - 7,789.95 8,275.00 485.05 94.14% 431014 - Collection Costs - 64.50 - 64.50 100.00 35.50 64.50% 431019 - Security Services 6,551.04 41,564.05 6,421.00 47,985.05 73,869.00 25,883.95 64.96% Total Professional Services 25,269.49 292,699.91 122,652.13 415,352.04 457,128.71 41,776.67 90.86% Communication & Transportation 432002 - Mailing 650.40 5,829.12 108.70 5,937.82 6,575.00 637.18 90.31% 432003 - Travel 40.00 5,892.09 18,069.90 23,961.99 34,880.41 10,918.42 68.70% 432004 - Telecommunications 87.72 1,314.47 2,232.92 3,547.39 12,923.80 9,376.41 27.45% 432005 - Mileage Reimb - 1,131.66 176.96 1,308.62 6,494.96 5,186.34 20.15% Total Communication & Transportation 778.12 14,167.34 20,588.48 34,755.82 60,874.17 26,118.35 57.09% Printing & Advertising 433001 - Outside Printing Services 171.09 5,435.34 2,391.75 7,827.09 15,165.00 7,337.91 51.61% 433002 - Publication of Legal Notice 118.40 1,156.40 797.69 1,954.09 3,277.72 1,323.63 59.62% 433003 - Promotional 182,702.15 409,872.79 102,943.05 512,815.84 702,808.90 189,993.06 72.97% Total Printing & Advertising 182,991.64 416,464.53 106,132.49 522,597.02 721,251.62 198,654.60 72.46% Utilties 435001 - Electric 41,406.95 399,171.44 - 399,171.44 538,707.00 139,535.56 74.10% 435002 - Natural Gas 2,571.27 134,350.59 - 134,350.59 309,583.00 175,232.41 43.40% 435004 - Water 34,768.53 206,484.03 - 206,484.03 300,000.00 93,515.97 68.83% Total Utilities 78,746.75 740,006.06 - 740,006.06 1,148,290.00 408,283.94 64.44% Repairs & Maintenance 436000 - Other R&M 23,010.18 92,918.30 36,797.00 129,715.30 209,322.99 79,607.69 61.97% 436001 - Building R&M 31,301.05 386,992.68 86,266.44 473,259.12 491,077.60 17,818.48 96.37% 436003 - Auto Equip R&M 15,549.77 199,756.28 - 199,756.28 346,750.00 146,993.72 57.61% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 8,042.10 1,125.68 86.00% 436006 - Radio Equip R&M 4,808.91 21,523.82 - 21,523.82 16,814.00 (4,709.82) 128.01% 436011 - Exterminating 1,031.00 4,861.00 8,526.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 75,700.91 712,968.50 131,589.44 844,557.94 1,088,348.69 243,790.75 77.60% Rentals 437002 - Equipment Rental 2,115.60 11,226.50 - 11,226.50 11,421.00 194.50 98.30% 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 2,115.60 24,426.50 - 24,426.50 24,681.00 254.50 98.97% 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 14,883.90 139,208.42 87,654.12 226,862.54 287,752.96 60,890.42 78.84% 439001 - Other Contractual Services 27,696.72 131,913.90 20,543.49 152,457.39 169,059.00 16,601.61 90.18% 439002 - Licenses & Permits - 6,749.11 - 6,749.11 12,640.00 5,890.89 53.39% 439003 - Subscriptions 708.99 5,655.22 - 5,655.22 5,914.00 258.78 95.62% 439004 - Dues & Memberships 949.65 12,216.91 - 12,216.91 21,732.00 9,515.09 56.22% 439005 - Bank & Credit Card Fees 7,193.22 79,257.57 - 79,257.57 108,798.00 29,540.43 72.85% 439006 - Education & Training 4,428.82 31,833.27 22,154.43 53,987.70 51,669.45 (2,318.25) 104.49% 439009 - Trash Removal 5,524.96 41,190.03 6,019.22 47,209.25 55,567.03 8,357.78 84.96% 439012 - Uniform Services 1,824.09 16,172.98 - 16,172.98 25,941.00 9,768.02 62.35% 439018 - Demolition & Clearance 900.00 18,000.00 - 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 5.23 1,926.59 - 1,926.59 10.00 (1,916.59) 19265.90% 439100 - Refunds/Awards/Indemnities - 5,284.07 - 5,284.07 31,587.00 26,302.93 16.73% 439300 - Grants & Subsidies 6,024.97 621,399.97 5,670.00 627,069.97 645,000.00 17,930.03 97.22% Total Other Services & Charges 70,140.55 1,110,808.04 142,041.26 1,252,849.30 1,433,670.44 180,821.14 87.39% Total Services & Charges Expenses 435,743.06 3,831,297.63 989,481.06 4,820,778.69 5,971,135.63 1,150,356.94 80.73% Capital Outlay Buildings 443001 - Building Improvements - - 250.00 250.00 6,000,250.00 6,000,000.00 0.00% Total Buildings - - 250.00 250.00 6,000,250.00 6,000,000.00 0.00% 444000 - Land Improvements - 313,031.45 455,208.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 284,288.02 337,297.64 600,825.38 938,123.02 1,207,819.00 269,695.98 77.67% 445008 - Other Equipment - 29,121.03 - 29,121.03 29,121.03 - 100.00% 445100 - Lease Purchase/Motor Equip 73,853.00 599,918.83 177,009.00 776,927.83 1,047,863.30 270,935.47 74.14% Total Machinery & Equipment 358,141.02 966,337.50 777,834.38 1,744,171.88 2,306,529.33 562,357.45 75.62% Total Capital Expenses 358,141.02 1,279,368.95 1,233,292.64 2,512,661.59 10,344,251.71 7,831,590.12 24.29% Other Uses 452002 - Allocations-Admin Cost - 502,909.44 - 502,909.44 754,364.00 251,454.56 66.67% 452003 - Allocations-IT - 496,931.36 - 496,931.36 745,397.00 248,465.64 66.67% 452004 - Allocations-Liability Insurance - 185,362.64 - 185,362.64 278,044.00 92,681.36 66.67% 452008 - Allocations-Payroll Cost - 56,258.00 - 56,258.00 84,387.00 28,129.00 66.67% 452009 - Allocations-Facilities Mgmt - 19,494.00 - 19,494.00 29,241.00 9,747.00 66.67% Total Other Uses - 1,260,955.44 - 1,260,955.44 1,891,433.00 630,477.56 66.67% Total Expenses 1,895,338.34 14,515,668.03 2,351,410.01 16,867,078.04 29,593,871.91 12,726,793.87 57.00%