Loading...
HomeMy WebLinkAboutApr 23 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 33% 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 224.00 448.00 30,000.00 29,552.00 1.49% 347002 - Picnic Site Rental 199.94 284.14 6,154.00 5,869.86 4.62% 347003 - Golf Season Pass 33,333.50 248,015.19 221,898.00 (26,117.19) 111.77% 347004 - Golf Green Fees 52,133.40 59,990.40 785,529.00 725,538.60 7.64% 347005 - Golf Cart Rentals 24,138.74 25,378.78 392,284.00 366,905.22 6.47% 347006 - Golf Pro Shop Retail 9,237.22 11,885.21 77,652.00 65,766.79 15.31% 347007 - Golf Driving Range 4,656.00 5,418.00 34,323.00 28,905.00 15.79% 347009 - Golf Outings 490.00 2,030.00 - (2,030.00) 0.00% 347010 - Concession Sales - 397.66 56,200.00 55,802.34 0.71% 347011 - Recreational Programming 27,765.87 193,643.76 372,321.00 178,677.24 52.01% 347012 - Food Sales 4,513.59 4,844.27 68,447.00 63,602.73 7.08% 347013 - Nonalcoholic Beverage 2,497.92 2,615.71 41,633.00 39,017.29 6.28% 347014 - Alcoholic Beverage Sales 9,953.78 11,259.78 151,573.00 140,313.22 7.43% 347015 - Lease of Stadium - - 75,000.00 75,000.00 0.00% 347016 - East Race Waterway 2,119.00 2,119.00 50,000.00 47,881.00 4.24% 347017 - Ice Skating 1,390.70 181,846.19 400,000.00 218,153.81 45.46% 347021 - Tree Maintenance 2,099.38 12,333.34 - (12,333.34) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% 347026 - Room Rental 4,466.06 46,273.53 57,972.00 11,698.47 79.82% 347030 - Merch Sales (56.35) 549.57 - (549.57) 0.00% 347040 - Pavilion Rental 2,475.28 8,293.49 33,710.00 25,416.51 24.60% 347100 - Concessions-Employee Discounts (198.73) (204.40) - 204.40 0.00% Total Culture & Recreation 181,439.30 817,421.62 2,856,696.00 2,039,274.38 28.61% Total Charges for Services 181,439.30 817,421.62 2,856,696.00 2,039,274.38 28.61% Miscellaneous Revenue 360000 - Miscellaneous 144.60 476.45 6,483.00 6,006.55 7.35% 360001 - Sale of Scrap Metal 490.35 723.65 - (723.65) 0.00% 361000 - Interest Earnings 7,615.15 35,814.16 15,000.00 (20,814.16) 238.76% 362000 - Rental of Property 6,433.09 31,206.05 72,337.00 41,130.95 43.14% 367000 - Donations from Private Sources - 1,000,500.00 5,184,000.00 4,183,500.00 19.30% Total Miscellaneous Revenue 14,683.19 1,068,720.31 5,277,820.00 4,209,099.69 20.25% Refunds & Reimbursements 380000 - Misc Reimbursements 358.26 8,376.69 - (8,376.69) 0.00% 396000 - Refunds - 319.12 - (319.12) 0.00% Total Refunds & Reimbursements 358.26 8,695.81 - (8,695.81) 0.00% Other Sources 391000 - Interfund Transfers In - 488,414.75 5,860,977.00 5,372,562.25 8.33% 393000 - Capital Lease Proceeds - - 436,000.00 436,000.00 0.00% Total Other Sources - 488,414.75 6,296,977.00 5,808,562.25 7.76% Total Revenue 196,480.75 2,508,331.24 26,884,101.00 24,375,769.76 9.33% EXPENDITURES April 30, 2023 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 249,635.26 1,041,155.61 - 1,041,155.61 3,467,002.00 2,425,846.39 30.03% 410002 - Teamster Wages 118,873.29 501,981.21 - 501,981.21 1,632,649.00 1,130,667.79 30.75% 410003 - Permanent Part Time 80,164.81 263,563.74 - 263,563.74 1,091,395.00 827,831.26 24.15% 410004 - Extra & Overtime 3,192.82 31,737.02 - 31,737.02 58,850.00 27,112.98 53.93% 410005 - Seasonal & Interns 28,635.92 147,430.62 - 147,430.62 834,951.00 687,520.38 17.66% 410007 - Longevity Pay 850.00 3,800.00 - 3,800.00 8,050.00 4,250.00 47.20% 410017 - Stand By Pay 694.72 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 482,046.82 1,990,760.98 - 1,990,760.98 7,094,097.00 5,103,336.02 28.06% Employee Benefits 411001 - FICA Regular 36,054.06 149,913.59 - 149,913.59 542,270.00 392,356.41 27.65% 411004 - PERF Regular 40,763.86 173,317.84 - 173,317.84 582,642.00 409,324.16 29.75% 411005 - PERF Union 1,172.10 5,314.50 - 5,314.50 22,878.00 17,563.50 23.23% 411007 - Unemployment Comp 38.64 163.56 - 163.56 6,200.00 6,036.44 2.64% 411008 - Health Insurance 88,484.84 344,913.46 - 344,913.46 1,274,947.00 930,033.54 27.05% 411009 - Life Insurance 860.00 3,295.00 - 3,295.00 10,920.00 7,625.00 30.17% 411010 - Med/Surgical/Dental 1,037.98 4,050.11 - 4,050.11 - (4,050.11) 0.00% 411014 - Parental Leave 1,309.75 5,503.93 - 5,503.93 18,082.00 12,578.07 30.44% 411015 - Other Fringe Benefits - 1,400.00 - 1,400.00 - (1,400.00) 0.00% 411201 - Tool Allowance - 1,579.52 - 1,579.52 4,800.00 3,220.48 32.91% 411203 - Job Readiness Allow. - - - - 15,725.00 15,725.00 0.00% 411204 - Auto Allowance 266.66 1,066.64 - 1,066.64 3,200.00 2,133.36 33.33% 411206 - Cell Phone Allowance 880.00 3,520.00 - 3,520.00 11,880.00 8,360.00 29.63% Total Employee Benefits 170,867.89 694,038.15 - 694,038.15 2,493,544.00 1,799,505.85 27.83% Total Personnel Expenses 652,914.71 2,684,799.13 - 2,684,799.13 9,587,641.00 6,902,841.87 28.00% Supplies Expenses Office Supplies 421000 - General Office Supplies 969.41 4,712.15 1,174.63 5,886.78 17,238.05 11,351.27 34.15% Total Office Supplies 969.41 4,712.15 1,174.63 5,886.78 17,238.05 11,351.27 34.15% Operating Supplies 422000 - Other Operating Supplies 17,855.75 108,305.36 44,474.14 152,779.50 330,440.06 177,660.56 46.24% 422001 - C.S. Gasoline 16,700.96 70,653.11 - 70,653.11 220,000.00 149,346.89 32.12% 422002 - Diesel/CNG 1,463.65 1,463.65 - 1,463.65 3,472.00 2,008.35 42.16% 422003 - Gasoline 2,330.94 2,344.05 631.50 2,975.55 27,981.50 25,005.95 10.63% 422005 - Uniforms 964.95 3,082.59 1,249.50 4,332.09 18,633.25 14,301.16 23.25% 422006 - Computer Supplies & Equipment - - - - 700.00 700.00 0.00% 422007 - Cleaning Supplies - 164.84 - 164.84 3,120.00 2,955.16 5.28% 422008 - Medical/Safety Supplies 757.05 8,014.21 - 8,014.21 16,309.00 8,294.79 49.14% 422009 - Recreation Supplies 2,872.74 16,262.76 17,062.00 33,324.76 140,697.68 107,372.92 23.69% 422010 - Plants Chemicals Seed & Fertilizer 3,978.02 55,009.35 104,353.54 159,362.89 285,438.00 126,075.11 55.83% 422014 - Concessions Inventory 18,758.03 21,785.27 4,033.10 25,818.37 124,408.32 98,589.95 20.75% 422016 - Inventory For Sale 6,322.15 36,370.02 43,269.95 79,639.97 40,725.21 (38,914.76) 195.55% Total Operating Supplies 72,004.24 323,455.21 215,073.73 538,528.94 1,211,925.02 673,396.08 44.44% Repair & Maintenance Supplies 423000 - Other R&M Supplies 22,803.22 62,502.13 30,835.71 93,337.84 311,061.81 217,723.97 30.01% 423001 - Building Materials 6,930.03 29,255.54 28,034.08 57,289.62 145,169.45 87,879.83 39.46% 423006 - Small Tools & Equipment 3,497.42 16,454.20 2,835.57 19,289.77 26,852.00 7,562.23 71.84% 423009 - Repair Parts 19,241.12 32,137.07 18,215.84 50,352.91 82,164.24 31,811.33 61.28% Total Repair & Maintenance Supplies 52,471.79 140,348.94 79,921.20 220,270.14 565,247.50 344,977.36 38.97% Total Supplies Expenses 125,445.44 468,516.30 296,169.56 764,685.86 1,794,410.57 1,029,724.71 42.61% Services & Charges Expenses Professional Services 431000 - Other Professional Services 29,857.06 107,456.19 89,375.59 196,831.78 197,601.71 769.93 99.61% 431009 - Computer & Technology - 7,750.00 - 7,750.00 8,275.00 525.00 93.66% 431014 - Collection Costs 6.25 55.75 - 55.75 100.00 44.25 55.75% 431019 - Security Services 291.41 1,447.98 976.00 2,423.98 207,869.00 205,445.02 1.17% Total Professional Services 30,154.72 116,709.92 90,351.59 207,061.51 413,845.71 206,784.20 50.03% Communication & Transportation 432002 - Mailing 287.87 3,270.58 550.00 3,820.58 4,350.00 529.42 87.83% 432003 - Travel 318.96 2,334.36 8,760.12 11,094.48 33,895.41 22,800.93 32.73% 432004 - Telecommunications 175.44 263.16 2,583.80 2,846.96 14,023.80 11,176.84 20.30% 432005 - Mileage Reimb - 476.34 176.96 653.30 6,551.96 5,898.66 9.97% Total Communication & Transportation 782.27 6,344.44 12,070.88 18,415.32 58,821.17 40,405.85 31.31% Printing & Advertising 433001 - Outside Printing Services 230.82 2,083.47 - 2,083.47 15,790.00 13,706.53 13.19% 433002 - Publication of Legal Notice 192.40 1,038.00 677.81 1,715.81 3,277.72 1,561.91 52.35% 433003 - Promotional 15,503.87 66,399.94 44,164.45 110,564.39 677,566.90 567,002.51 16.32% Total Printing & Advertising 15,927.09 69,521.41 44,842.26 114,363.67 696,634.62 582,270.95 16.42% Utilties 435001 - Electric 37,864.15 167,839.42 - 167,839.42 538,707.00 370,867.58 31.16% 435002 - Natural Gas 22,146.30 110,256.60 - 110,256.60 309,583.00 199,326.40 35.61% 435004 - Water 8,936.10 31,031.64 - 31,031.64 300,000.00 268,968.36 10.34% Total Utilities 68,946.55 309,127.66 - 309,127.66 1,148,290.00 839,162.34 26.92% Repairs & Maintenance 436000 - Other R&M 6,232.33 14,275.10 32,405.00 46,680.10 330,572.99 283,892.89 14.12% 436001 - Building R&M 63,782.50 207,066.96 84,869.00 291,935.96 354,902.60 62,966.64 82.26% 436003 - Auto Equip R&M 33,920.21 92,085.70 - 92,085.70 351,750.00 259,664.30 26.18% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 8,042.10 1,125.68 86.00% 436006 - Radio Equip R&M 2,393.39 5,169.90 - 5,169.90 7,200.00 2,030.10 71.80% 436011 - Exterminating - 554.00 12,833.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 106,328.43 326,068.08 130,107.00 456,175.08 1,068,809.69 612,634.61 42.68% Rentals 437002 - Equipment Rental - 602.00 - 602.00 - (602.00) 0.00% 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 - 13,802.00 - 13,802.00 13,260.00 (542.00) 104.09% Debt Service 438100 - Principal - 179,468.91 - 179,468.91 548,925.00 369,456.09 32.69% 438200 - Interest - 17,390.49 - 17,390.49 46,466.00 29,075.51 37.43% 438300 - Paying Agent Fees - 4,950.00 - 4,950.00 5,500.00 550.00 90.00% Total Debt Service - 201,809.40 - 201,809.40 600,891.00 399,081.60 33.59% Other Charges & Services 439000 - Misc Charges & Svcs 8,132.75 43,764.02 64,754.22 108,518.24 267,394.96 158,876.72 40.58% 439001 - Other Contractual Services 6,110.06 7,729.06 67,941.13 75,670.19 147,898.00 72,227.81 51.16% 439002 - Licenses & Permits 48.84 6,256.07 - 6,256.07 13,893.00 7,636.93 45.03% 439003 - Subscriptions 283.99 4,301.39 - 4,301.39 5,281.00 979.61 81.45% 439004 - Dues & Memberships 5,971.83 9,901.71 - 9,901.71 21,198.00 11,296.29 46.71% 439005 - Bank & Credit Card Fees 5,289.35 30,996.99 - 30,996.99 102,353.00 71,356.01 30.28% 439006 - Education & Training 9,720.60 17,944.50 5,640.76 23,585.26 33,310.45 9,725.19 70.80% 439009 - Trash Removal 4,883.78 17,376.17 5,771.21 23,147.38 49,987.03 26,839.65 46.31% 439012 - Uniform Services 1,892.35 6,422.48 - 6,422.48 15,941.00 9,518.52 40.29% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short (416.37) (414.50) - (414.50) - 414.50 0.00% 439100 - Refunds/Awards/Indemnities 272.10 5,008.37 - 5,008.37 42,527.00 37,518.63 11.78% 439300 - Grants & Subsidies - 315,000.00 300,000.00 615,000.00 635,000.00 20,000.00 96.85% Total Other Services & Charges 42,189.28 481,386.26 445,007.32 926,393.58 1,352,783.44 426,389.86 68.48% Total Services & Charges Expenses 264,328.34 1,524,769.17 722,379.05 2,247,148.22 5,353,335.63 3,106,187.41 41.98% 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 163,574.47 262,090.77 500,096.40 762,187.17 912,097.38 149,910.21 83.56% Machinery & Equipment 445000 - Motor Equipment - - - - 35,618.00 35,618.00 0.00% 445003 - Park Equipment - 8,045.00 130,382.00 138,427.00 1,193,927.00 1,055,500.00 11.59% 445008 - Other Equipment - - 29,121.03 29,121.03 29,121.03 - 100.00% 445100 - Lease Purchase/Motor Equip - 13,638.00 84,750.00 98,388.00 1,047,863.30 949,475.30 9.39% 445108 - Lease Purchase/Other Equip - - - - 436,000.00 436,000.00 0.00% Total Machinery & Equipment - 21,683.00 244,253.03 265,936.03 2,742,529.33 2,476,593.30 9.70% Total Capital Expenses 163,574.47 283,773.77 744,599.43 1,028,373.20 9,654,876.71 8,626,503.51 10.65% Other Uses 452002 - Allocations-Admin Cost - 188,591.04 - 188,591.04 754,364.00 565,772.96 25.00% 452003 - Allocations-IT - 186,349.26 - 186,349.26 745,397.00 559,047.74 25.00% 452004 - Allocations-Liability Insurance - 69,510.99 - 69,510.99 278,044.00 208,533.01 25.00% 452008 - Allocations-Payroll Cost - 21,096.75 - 21,096.75 84,387.00 63,290.25 25.00% 452009 - Allocations-Facilities Mgmt - 7,310.25 - 7,310.25 29,241.00 21,930.75 25.00% Total Other Uses - 472,858.29 - 472,858.29 1,891,433.00 1,418,574.71 25.00% Total Expenses 1,206,262.96 5,434,716.66 1,763,148.04 7,197,864.70 28,281,696.91 21,083,832.21 25.45%