Loading...
HomeMy WebLinkAboutMay 23 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 42% 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 - - 11,426,846.00 11,426,846.00 0.00% Total Property Taxes - - 11,426,846.00 11,426,846.00 0.00% Total Taxes - - 11,426,846.00 11,426,846.00 0.00% State Shared Revenue 335002 - Vehicle/Aircraft Excise - - 730,198.00 730,198.00 0.00% 335007 - Commercial Vehicle Excise - - 170,564.00 170,564.00 0.00% Total State Shared Revenue - - 900,762.00 900,762.00 0.00% Total Intergovernmental Revenue - 125,000.00 1,025,762.00 900,762.00 12.19% Total Nonbusiness Licenses & Permits - 78.75 - (78.75) 0.00% Total Licenses & Permits - 78.75 - (78.75) 0.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 1,943.35 2,391.35 30,000.00 27,608.65 7.97% 347002 - Picnic Site Rental 1,094.60 1,378.74 6,154.00 4,775.26 22.40% 347003 - Golf Season Pass 22,438.00 270,453.19 221,898.00 (48,555.19) 121.88% 347004 - Golf Green Fees 113,860.50 173,850.90 785,529.00 611,678.10 22.13% 347005 - Golf Cart Rentals 52,532.40 77,911.18 392,284.00 314,372.82 19.86% 347006 - Golf Pro Shop Retail 11,907.69 23,792.90 77,652.00 53,859.10 30.64% 347007 - Golf Driving Range 6,720.00 12,138.00 34,323.00 22,185.00 35.36% 347009 - Golf Outings 1,532.30 3,562.30 - (3,562.30) 0.00% 347010 - Concession Sales 8,342.56 8,740.22 56,200.00 47,459.78 15.55% 347011 - Recreational Programming 55,169.85 248,813.61 372,321.00 123,507.39 66.83% 347012 - Food Sales 11,786.62 16,630.89 68,447.00 51,816.11 24.30% 347013 - Nonalcoholic Beverage 5,658.64 8,274.35 41,633.00 33,358.65 19.87% 347014 - Alcoholic Beverage Sales 30,974.63 42,234.41 151,573.00 109,338.59 27.86% 347015 - Lease of Stadium 15,000.00 15,000.00 75,000.00 60,000.00 20.00% 347016 - East Race Waterway 3,028.20 5,147.20 50,000.00 44,852.80 10.29% 347017 - Ice Skating 541.80 182,387.99 400,000.00 217,612.01 45.60% 347021 - Tree Maintenance 2,564.87 14,898.21 - (14,898.21) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% 347026 - Room Rental 3,707.75 49,981.28 57,972.00 7,990.72 86.22% 347030 - Merch Sales (381.03) 168.54 - (168.54) 0.00% 347040 - Pavilion Rental 6,493.04 14,786.53 33,710.00 18,923.47 43.86% 347100 - Concessions-Employee Discounts (368.77) (573.17) - 573.17 0.00% Total Culture & Recreation 354,547.00 1,171,968.62 2,856,696.00 1,684,727.38 41.03% Total Charges for Services 354,547.00 1,171,968.62 2,856,696.00 1,684,727.38 41.03% Miscellaneous Revenue 360000 - Miscellaneous 2,491.45 2,967.90 6,483.00 3,515.10 45.78% 360001 - Sale of Scrap Metal - 723.65 - (723.65) 0.00% 360011 - Settlement Fees - 19,500.00 - (19,500.00) 0.00% 361000 - Interest Earnings 3,735.19 39,556.50 15,000.00 (24,556.50) 263.71% 362000 - Rental of Property 100.00 31,306.05 72,337.00 41,030.95 43.28% 367000 - Donations from Private Sources - 1,445,500.00 5,184,000.00 3,738,500.00 27.88% Total Miscellaneous Revenue 6,326.64 1,539,554.10 5,277,820.00 3,738,265.90 29.17% Refunds & Reimbursements 380000 - Misc Reimbursements 45,000.00 53,376.69 45,000.00 (8,376.69) 118.61% 396000 - Refunds - 519.12 - (519.12) 0.00% Total Refunds & Reimbursements 45,000.00 53,895.81 45,000.00 (8,895.81) 119.77% Other Sources 391000 - Interfund Transfers In - 1,465,244.25 5,860,977.00 4,395,732.75 25.00% 393000 - Capital Lease Proceeds - - 436,000.00 436,000.00 0.00% Total Other Sources - 1,465,244.25 6,296,977.00 4,831,732.75 23.27% Total Revenue 405,873.64 4,355,741.53 26,929,101.00 22,573,359.47 16.17% May 31, 2023 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 261,152.55 1,303,923.56 - 1,303,923.56 3,467,002.00 2,163,078.44 37.61% 410002 - Teamster Wages 116,992.53 620,568.67 - 620,568.67 1,632,649.00 1,012,080.33 38.01% 410003 - Permanent Part Time 107,765.73 369,714.07 - 369,714.07 1,091,395.00 721,680.93 33.88% 410004 - Extra & Overtime 5,462.22 37,199.24 - 37,199.24 58,850.00 21,650.76 63.21% 410005 - Seasonal & Interns 45,142.25 192,572.87 - 192,572.87 834,951.00 642,378.13 23.06% 410007 - Longevity Pay 350.00 4,150.00 - 4,150.00 8,050.00 3,900.00 51.55% 410017 - Stand By Pay - 1,092.78 - 1,092.78 - (1,092.78) 0.00% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 536,865.28 2,529,221.19 - 2,529,221.19 7,094,097.00 4,564,875.81 35.65% Employee Benefits 411001 - FICA Regular 39,372.26 189,285.85 - 189,285.85 542,270.00 352,984.15 34.91% 411004 - PERF Regular 40,503.26 213,821.10 - 213,821.10 582,642.00 368,820.90 36.70% 411005 - PERF Union 1,181.87 6,496.37 - 6,496.37 22,878.00 16,381.63 28.40% 411007 - Unemployment Comp 39.17 202.73 - 202.73 6,200.00 5,997.27 3.27% 411008 - Health Insurance 91,236.34 436,149.80 - 436,149.80 1,274,947.00 838,797.20 34.21% 411009 - Life Insurance 890.00 4,185.00 - 4,185.00 10,920.00 6,735.00 38.32% 411010 - Med/Surgical/Dental 1,067.00 5,117.11 - 5,117.11 - (5,117.11) 0.00% 411014 - Parental Leave 1,335.80 6,839.73 - 6,839.73 18,082.00 11,242.27 37.83% 411015 - Other Fringe Benefits - 1,400.00 - 1,400.00 - (1,400.00) 0.00% 411200 - Clothing Allowance 155.14 155.14 - 155.14 - (155.14) 0.00% 411201 - Tool Allowance - 1,579.52 420.81 2,000.33 4,800.00 2,799.67 41.67% 411203 - Job Readiness Allow. 8,977.84 8,977.84 - 8,977.84 15,725.00 6,747.16 57.09% 411204 - Auto Allowance 266.66 1,333.30 - 1,333.30 3,200.00 1,866.70 41.67% 411206 - Cell Phone Allowance 825.00 4,345.00 - 4,345.00 11,880.00 7,535.00 36.57% Total Employee Benefits 185,850.34 879,888.49 420.81 880,309.30 2,493,544.00 1,613,234.70 35.30% Total Personnel Expenses 722,715.62 3,409,109.68 420.81 3,409,530.49 9,587,641.00 6,178,110.51 35.56% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,693.12 6,405.27 771.69 7,176.96 17,288.05 10,111.09 41.51% Total Office Supplies 1,693.12 6,405.27 771.69 7,176.96 17,288.05 10,111.09 41.51% Operating Supplies 422000 - Other Operating Supplies 42,366.98 150,672.34 26,733.12 177,405.46 329,259.06 151,853.60 53.88% 422001 - C.S. Gasoline 19,856.04 90,509.15 - 90,509.15 220,000.00 129,490.85 41.14% 422002 - Diesel/CNG - 1,463.65 - 1,463.65 4,936.00 3,472.35 29.65% 422003 - Gasoline 5,663.07 8,007.12 631.50 8,638.62 27,981.50 19,342.88 30.87% 422005 - Uniforms 1,093.78 4,176.37 1,249.50 5,425.87 20,064.25 14,638.38 27.04% 422006 - Computer Supplies & Equipment 166.43 166.43 - 166.43 700.00 533.57 23.78% 422007 - Cleaning Supplies 311.94 476.78 - 476.78 3,120.00 2,643.22 15.28% 422008 - Medical/Safety Supplies 158.81 8,173.02 - 8,173.02 16,309.00 8,135.98 50.11% 422009 - Recreation Supplies 7,918.00 24,180.76 17,904.68 42,085.44 140,697.68 98,612.24 29.91% 422010 - Plants Chemicals Seed & Fertilizer 99,605.56 154,614.91 12,600.17 167,215.08 283,674.00 116,458.92 58.95% 422014 - Concessions Inventory 14,634.27 36,419.54 13,489.68 49,909.22 124,408.32 74,499.10 40.12% 422016 - Inventory For Sale 5,393.76 41,763.78 35,628.82 77,392.60 40,725.21 (36,667.39) 190.04% Total Operating Supplies 197,168.64 520,623.85 108,237.47 628,861.32 1,211,875.02 583,013.70 51.89% Repair & Maintenance Supplies 423000 - Other R&M Supplies 23,740.26 86,242.39 40,739.87 126,982.26 311,061.81 184,079.55 40.82% 423001 - Building Materials 8,174.63 37,430.17 21,110.05 58,540.22 145,169.45 86,629.23 40.33% 423006 - Small Tools & Equipment 2,507.89 18,962.09 3,736.08 22,698.17 26,852.00 4,153.83 84.53% 423009 - Repair Parts 7,082.54 39,219.61 17,338.73 56,558.34 82,164.24 25,605.90 68.84% Total Repair & Maintenance Supplies 41,505.32 181,854.26 82,924.73 264,778.99 565,247.50 300,468.51 46.84% Total Supplies Expenses 240,367.08 708,883.38 191,933.89 900,817.27 1,794,410.57 893,593.30 50.20% Services & Charges Expenses Professional Services 431000 - Other Professional Services 29,231.06 136,687.25 83,457.08 220,144.33 211,659.71 (8,484.62) 104.01% 431001 - Legal Services - - - - 500.00 500.00 0.00% 431009 - Computer & Technology - 7,750.00 - 7,750.00 8,275.00 525.00 93.66% 431014 - Collection Costs - 55.75 - 55.75 100.00 44.25 55.75% 431019 - Security Services 5,682.41 9,429.39 28,850.00 38,279.39 207,869.00 169,589.61 18.42% Total Professional Services 34,913.47 153,922.39 112,307.08 266,229.47 428,403.71 162,174.24 62.14% Communication & Transportation 432002 - Mailing 367.65 3,638.23 458.70 4,096.93 4,350.00 253.07 94.18% 432003 - Travel - 2,334.36 8,760.12 11,094.48 34,487.41 23,392.93 32.17% 432004 - Telecommunications 612.71 875.87 2,583.80 3,459.67 14,023.80 10,564.13 24.67% 432005 - Mileage Reimb 369.55 845.89 176.96 1,022.85 6,551.96 5,529.11 15.61% Total Communication & Transportation 1,349.91 7,694.35 11,979.58 19,673.93 59,413.17 39,739.24 33.11% Printing & Advertising 433001 - Outside Printing Services - 2,083.47 1,938.75 4,022.22 14,682.00 10,659.78 27.40% 433002 - Publication of Legal Notice - 1,038.00 677.81 1,715.81 3,277.72 1,561.91 52.35% 433003 - Promotional 31,591.66 97,991.60 37,439.45 135,431.05 673,391.90 537,960.85 20.11% Total Printing & Advertising 31,591.66 101,113.07 40,056.01 141,169.08 691,351.62 550,182.54 20.42% Utilties 435001 - Electric 40,963.53 208,802.95 - 208,802.95 538,707.00 329,904.05 38.76% 435002 - Natural Gas 11,898.18 122,154.78 - 122,154.78 309,583.00 187,428.22 39.46% 435004 - Water 24,524.37 55,556.01 - 55,556.01 300,000.00 244,443.99 18.52% Total Utilities 77,386.08 386,513.74 - 386,513.74 1,148,290.00 761,776.26 33.66% Repairs & Maintenance 436000 - Other R&M 7,038.20 21,313.30 30,985.00 52,298.30 326,484.99 274,186.69 16.02% 436001 - Building R&M 37,329.69 244,396.65 87,240.00 331,636.65 364,077.60 32,440.95 91.09% 436003 - Auto Equip R&M 30,590.13 122,675.83 - 122,675.83 351,750.00 229,074.17 34.88% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 8,042.10 1,125.68 86.00% 436006 - Radio Equip R&M 1,069.32 6,239.22 - 6,239.22 7,200.00 960.78 86.66% 436011 - Exterminating - 554.00 12,833.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 76,027.34 402,095.42 131,058.00 533,153.42 1,073,896.69 540,743.27 49.65% Rentals 437002 - Equipment Rental 327.18 929.18 - 929.18 602.00 (327.18) 154.35% 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 327.18 14,129.18 - 14,129.18 13,862.00 (267.18) 101.93% Debt Service 438100 - Principal 101,214.39 280,683.30 - 280,683.30 548,925.00 268,241.70 51.13% 438200 - Interest 2,525.64 19,916.13 - 19,916.13 46,466.00 26,549.87 42.86% 438300 - Paying Agent Fees - 4,950.00 - 4,950.00 5,500.00 550.00 90.00% Total Debt Service 103,740.03 305,549.43 - 305,549.43 600,891.00 295,341.57 50.85% Other Charges & Services 439000 - Misc Charges & Svcs 44,398.68 88,162.70 61,702.31 149,865.01 246,745.96 96,880.95 60.74% 439001 - Other Contractual Services 5,485.30 10,915.36 82,274.83 93,190.19 149,002.00 55,811.81 62.54% 439002 - Licenses & Permits 297.68 6,553.75 - 6,553.75 14,244.00 7,690.25 46.01% 439003 - Subscriptions (206.01) 4,095.38 - 4,095.38 5,381.00 1,285.62 76.11% 439004 - Dues & Memberships 238.17 10,139.88 - 10,139.88 25,201.00 15,061.12 40.24% 439005 - Bank & Credit Card Fees 8,074.20 39,071.19 - 39,071.19 102,398.00 63,326.81 38.16% 439006 - Education & Training 1,808.36 19,752.86 5,845.76 25,598.62 33,310.45 7,711.83 76.85% 439009 - Trash Removal 4,089.58 21,465.75 4,949.68 26,415.43 49,967.03 23,551.60 52.87% 439012 - Uniform Services 2,018.70 8,441.18 - 8,441.18 15,941.00 7,499.82 52.95% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (58.77) (473.27) - (473.27) - 473.27 0.00% 439100 - Refunds/Awards/Indemnities - 5,008.37 - 5,008.37 42,037.00 37,028.63 11.91% 439300 - Grants & Subsidies 300,000.00 615,000.00 - 615,000.00 635,000.00 20,000.00 96.85% Total Other Services & Charges 366,145.89 845,233.15 155,672.58 1,000,905.73 1,337,227.44 336,321.71 74.85% Total Services & Charges Expenses 691,481.56 2,216,250.73 451,073.25 2,667,323.98 5,353,335.63 2,686,011.65 49.83% 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 14,979.67 277,070.44 485,846.39 762,916.83 912,097.38 149,180.55 83.64% Machinery & Equipment 445000 - Motor Equipment - - - - 35,618.00 35,618.00 0.00% 445003 - Park Equipment - 8,045.00 454,895.40 462,940.40 1,193,927.00 730,986.60 38.77% 445008 - Other Equipment - - 29,121.03 29,121.03 29,121.03 - 100.00% 445100 - Lease Purchase/Motor Equip 217,096.00 230,734.00 56,650.00 287,384.00 1,047,863.30 760,479.30 27.43% 445108 - Lease Purchase/Other Equip - - - - 436,000.00 436,000.00 0.00% Total Machinery & Equipment 217,096.00 238,779.00 540,666.43 779,445.43 2,742,529.33 1,963,083.90 28.42% Total Capital Expenses 232,075.67 515,849.44 1,026,762.82 1,542,612.26 9,654,876.71 8,112,264.45 15.98% Other Uses 452002 - Allocations-Admin Cost - 251,454.72 - 251,454.72 754,364.00 502,909.28 33.33% 452003 - Allocations-IT - 248,465.68 - 248,465.68 745,397.00 496,931.32 33.33% 452004 - Allocations-Liability Insurance - 92,681.32 - 92,681.32 278,044.00 185,362.68 33.33% 452008 - Allocations-Payroll Cost - 28,129.00 - 28,129.00 84,387.00 56,258.00 33.33% 452009 - Allocations-Facilities Mgmt - 9,747.00 - 9,747.00 29,241.00 19,494.00 33.33% Total Other Uses - 630,477.72 - 630,477.72 1,891,433.00 1,260,955.28 33.33% Total Expenses 1,886,639.93 7,480,570.95 1,670,190.77 9,150,761.72 28,281,696.91 19,130,935.19 32.36%