Loading...
HomeMy WebLinkAboutMar 23 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 25% 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 900,762.00 775,762.00 13.88% Total Nonbusiness Licenses & Permits 26.25 78.75 - (78.75) 0.00% Total Licenses & Permits 26.25 78.75 - (78.75) 0.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 224.00 224.00 30,000.00 29,776.00 0.75% 347002 - Picnic Site Rental 16.84 84.20 6,154.00 6,069.80 1.37% 347003 - Golf Season Pass 21,638.00 214,681.69 221,898.00 7,216.31 96.75% 347004 - Golf Green Fees 5,920.00 7,857.00 785,529.00 777,672.00 1.00% 347005 - Golf Cart Rentals 1,220.44 1,240.04 392,284.00 391,043.96 0.32% 347006 - Golf Pro Shop Retail 1,112.97 2,647.99 77,652.00 75,004.01 3.41% 347007 - Golf Driving Range 762.00 762.00 34,323.00 33,561.00 2.22% 347009 - Golf Outings 1,540.00 1,540.00 - (1,540.00) 0.00% 347010 - Concession Sales - 397.66 56,200.00 55,802.34 0.71% 347011 - Recreational Programming 105,896.71 165,877.89 372,321.00 206,443.11 44.55% 347012 - Food Sales 330.68 330.68 68,447.00 68,116.32 0.48% 347013 - Nonalcoholic Beverage 117.79 117.79 41,633.00 41,515.21 0.28% 347014 - Alcoholic Beverage Sales 804.21 1,306.00 151,573.00 150,267.00 0.86% 347015 - Lease of Stadium - - 75,000.00 75,000.00 0.00% 347016 - East Race Waterway - - 50,000.00 50,000.00 0.00% 347017 - Ice Skating 13,661.91 180,455.49 400,000.00 219,544.51 45.11% 347021 - Tree Maintenance 2,769.77 10,233.96 - (10,233.96) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% 347026 - Room Rental 12,158.45 41,807.47 57,972.00 16,164.53 72.12% 347030 - Merch Sales 320.19 975.75 - (975.75) 0.00% 347040 - Pavilion Rental 2,064.34 5,818.21 33,710.00 27,891.79 17.26% 347100 - Concessions-Employee Discounts (5.67) (5.67) - 5.67 0.00% Total Culture & Recreation 170,552.63 636,352.15 2,856,696.00 2,220,343.85 22.28% Total Charges for Services 170,552.63 636,352.15 2,856,696.00 2,220,343.85 22.28% Miscellaneous Revenue 360000 - Miscellaneous 0.82 331.85 6,483.00 6,151.15 5.12% 360001 - Sale of Scrap Metal - 233.30 - (233.30) 0.00% 361000 - Interest Earnings - 10,188.06 15,000.00 4,811.94 67.92% 362000 - Rental of Property 12,501.18 24,772.96 72,337.00 47,564.04 34.25% 367000 - Donations from Private Sources 1,000,000.00 1,000,500.00 5,184,000.00 4,183,500.00 19.30% Total Miscellaneous Revenue 1,012,502.00 1,036,026.17 5,277,820.00 4,241,793.83 19.63% Refunds & Reimbursements 380000 - Misc Reimbursements 5,926.96 8,018.43 - (8,018.43) 0.00% 396000 - Refunds 19.12 319.12 - (319.12) 0.00% Total Refunds & Reimbursements 5,946.08 8,337.55 - (8,337.55) 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 1,189,026.96 2,294,209.37 26,759,101.00 24,464,891.63 8.57% EXPENDITURES March 31, 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 344,639.27 790,698.81 - 790,698.81 3,467,002.00 2,676,303.19 22.81% 410002 - Teamster Wages 164,588.39 377,244.74 - 377,244.74 1,632,649.00 1,255,404.26 23.11% 410003 - Permanent Part Time 79,903.34 183,126.44 - 183,126.44 1,091,395.00 908,268.56 16.78% 410004 - Extra & Overtime 13,465.96 28,544.20 - 28,544.20 58,850.00 30,305.80 48.50% 410005 - Seasonal & Interns 47,335.18 118,794.70 - 118,794.70 834,951.00 716,156.30 14.23% 410007 - Longevity Pay 1,650.00 2,950.00 - 2,950.00 8,050.00 5,100.00 36.65% 410017 - Stand By Pay - 398.06 - 398.06 - (398.06) 0.00% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 651,582.14 1,501,756.95 - 1,501,756.95 7,094,097.00 5,592,340.05 21.17% Employee Benefits 411001 - FICA Regular 50,080.56 113,859.53 - 113,859.53 542,270.00 428,410.47 21.00% 411004 - PERF Regular 57,553.70 132,553.98 - 132,553.98 582,642.00 450,088.02 22.75% 411005 - PERF Union 1,728.10 4,142.40 - 4,142.40 22,878.00 18,735.60 18.11% 411007 - Unemployment Comp 54.51 124.92 - 124.92 6,200.00 6,075.08 2.01% 411008 - Health Insurance 85,771.04 256,428.62 - 256,428.62 1,274,947.00 1,018,518.38 20.11% 411009 - Life Insurance 820.00 2,435.00 - 2,435.00 10,920.00 8,485.00 22.30% 411010 - Med/Surgical/Dental 1,009.14 3,012.13 - 3,012.13 - (3,012.13) 0.00% 411014 - Parental Leave 1,831.26 4,194.18 - 4,194.18 18,082.00 13,887.82 23.20% 411015 - Other Fringe Benefits - 1,400.00 - 1,400.00 - (1,400.00) 0.00% 411201 - Tool Allowance 45.99 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 799.98 - 799.98 3,200.00 2,400.02 25.00% 411206 - Cell Phone Allowance 880.00 2,640.00 - 2,640.00 11,880.00 9,240.00 22.22% Total Employee Benefits 200,040.96 523,170.26 - 523,170.26 2,493,544.00 1,970,373.74 20.98% Total Personnel Expenses 851,623.10 2,024,927.21 - 2,024,927.21 9,587,641.00 7,562,713.79 21.12% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,337.22 3,742.74 986.28 4,729.02 17,238.05 12,509.03 27.43% Total Office Supplies 1,337.22 3,742.74 986.28 4,729.02 17,238.05 12,509.03 27.43% Operating Supplies 422000 - Other Operating Supplies 40,431.85 90,449.61 23,926.11 114,375.72 330,440.06 216,064.34 34.61% 422001 - C.S. Gasoline - 28,454.54 - 28,454.54 220,000.00 191,545.46 12.93% 422002 - Diesel/CNG - - 1,463.65 1,463.65 3,472.00 2,008.35 42.16% 422003 - Gasoline - 13.11 2,962.44 2,975.55 27,981.50 25,005.95 10.63% 422005 - Uniforms 343.59 2,117.64 1,249.50 3,367.14 18,633.25 15,266.11 18.07% 422006 - Computer Supplies & Equipment - - - - 700.00 700.00 0.00% 422007 - Cleaning Supplies 164.84 164.84 - 164.84 3,120.00 2,955.16 5.28% 422008 - Medical/Safety Supplies 6,485.30 7,257.16 - 7,257.16 16,309.00 9,051.84 44.50% 422009 - Recreation Supplies 8,205.42 13,387.88 8,746.94 22,134.82 140,697.68 118,562.86 15.73% 422010 - Plants Chemicals Seed & Fertilizer 48,546.37 51,031.33 75,284.69 126,316.02 285,438.00 159,121.98 44.25% 422014 - Concessions Inventory 1,922.21 3,027.24 4,766.68 7,793.92 124,408.32 116,614.40 6.26% 422016 - Inventory For Sale 29,065.37 30,047.87 45,835.05 75,882.92 40,725.21 (35,157.71) 186.33% Total Operating Supplies 135,164.95 225,951.22 164,235.06 390,186.28 1,211,925.02 821,738.74 32.20% Repair & Maintenance Supplies 423000 - Other R&M Supplies 18,579.97 39,698.91 32,699.32 72,398.23 311,061.81 238,663.58 23.27% 423001 - Building Materials 9,493.20 22,325.51 5,901.16 28,226.67 145,169.45 116,942.78 19.44% 423006 - Small Tools & Equipment 4,113.91 12,956.78 2,519.95 15,476.73 26,852.00 11,375.27 57.64% 423009 - Repair Parts 6,410.92 12,895.95 29,064.71 41,960.66 82,164.24 40,203.58 51.07% Total Repair & Maintenance Supplies 38,598.00 87,877.15 70,185.14 158,062.29 565,247.50 407,185.21 27.96% Total Supplies Expenses 175,100.17 317,571.11 235,406.48 552,977.59 1,794,410.57 1,241,432.98 30.82% Services & Charges Expenses Professional Services 431000 - Other Professional Services 37,233.93 77,599.13 89,947.15 167,546.28 197,601.71 30,055.43 84.79% 431009 - Computer & Technology - 7,750.00 - 7,750.00 8,275.00 525.00 93.66% 431014 - Collection Costs - 49.50 - 49.50 - (49.50) 0.00% 431019 - Security Services 367.91 1,156.57 976.00 2,132.57 207,869.00 205,736.43 1.03% Total Professional Services 37,601.84 86,555.20 90,923.15 177,478.35 413,745.71 236,267.36 42.90% Communication & Transportation 432002 - Mailing 497.76 2,982.71 550.00 3,532.71 2,250.00 (1,282.71) 157.01% 432003 - Travel 209.09 2,015.40 8,760.12 10,775.52 33,895.41 23,119.89 31.79% 432004 - Telecommunications - 87.72 2,759.24 2,846.96 14,023.80 11,176.84 20.30% 432005 - Mileage Reimb 469.96 476.34 176.96 653.30 6,551.96 5,898.66 9.97% Total Communication & Transportation 1,176.81 5,562.17 12,246.32 17,808.49 56,721.17 38,912.68 31.40% Printing & Advertising 433001 - Outside Printing Services 1,730.25 1,852.65 171.00 2,023.65 15,790.00 13,766.35 12.82% 433002 - Publication of Legal Notice - 845.60 677.81 1,523.41 3,277.72 1,754.31 46.48% 433003 - Promotional 25,882.37 50,896.07 29,088.00 79,984.07 677,566.90 597,582.83 11.80% Total Printing & Advertising 27,612.62 53,594.32 29,936.81 83,531.13 696,634.62 613,103.49 11.99% Utilties 435001 - Electric 44,175.25 129,975.27 - 129,975.27 538,707.00 408,731.73 24.13% 435002 - Natural Gas 23,926.65 88,110.30 - 88,110.30 309,583.00 221,472.70 28.46% 435004 - Water 7,214.32 22,095.54 - 22,095.54 300,000.00 277,904.46 7.37% Total Utilities 75,316.22 240,181.11 - 240,181.11 1,148,290.00 908,108.89 20.92% Repairs & Maintenance 436000 - Other R&M 3,213.77 8,042.77 28,217.33 36,260.10 330,572.99 294,312.89 10.97% 436001 - Building R&M 68,805.59 143,284.46 143,491.25 286,775.71 354,902.60 68,126.89 80.80% 436003 - Auto Equip R&M - 40,372.42 - 40,372.42 351,750.00 311,377.58 11.48% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 4,042.10 (2,874.32) 171.11% 436006 - Radio Equip R&M - 1,306.51 - 1,306.51 7,200.00 5,893.49 18.15% 436011 - Exterminating - 554.00 1,763.00 2,317.00 16,342.00 14,025.00 14.18% Total Repairs & Maintenance 72,019.36 200,476.58 173,471.58 373,948.16 1,064,809.69 690,861.53 35.12% 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 14,879.43 35,631.27 18,487.67 54,118.94 219,494.96 165,376.02 24.66% 439001 - Other Contractual Services - 1,619.00 3,215.37 4,834.37 201,998.00 197,163.63 2.39% 439002 - Licenses & Permits 2,431.65 6,207.23 - 6,207.23 13,893.00 7,685.77 44.68% 439003 - Subscriptions 3,252.33 4,017.40 - 4,017.40 5,281.00 1,263.60 76.07% 439004 - Dues & Memberships 2,184.00 3,929.88 190.00 4,119.88 21,658.00 17,538.12 19.02% 439005 - Bank & Credit Card Fees 7,427.83 25,657.64 - 25,657.64 102,353.00 76,695.36 25.07% 439006 - Education & Training 1,667.00 8,223.90 6,220.72 14,444.62 32,850.45 18,405.83 43.97% 439009 - Trash Removal 4,872.52 12,492.39 4,674.34 17,166.73 49,987.03 32,820.30 34.34% 439012 - Uniform Services 1,482.09 4,530.13 - 4,530.13 15,941.00 11,410.87 28.42% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 2.75 1.87 - 1.87 - (1.87) 0.00% 439100 - Refunds/Awards/Indemnities 1,780.28 4,736.27 - 4,736.27 42,527.00 37,790.73 11.14% 439300 - Grants & Subsidies - 315,000.00 300,000.00 615,000.00 635,000.00 20,000.00 96.85% Total Other Services & Charges 39,979.88 439,146.98 333,688.10 772,835.08 1,358,983.44 586,148.36 56.87% Total Services & Charges Expenses 253,706.73 1,241,127.76 640,265.96 1,881,393.72 5,353,335.63 3,471,941.91 35.14% 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 82,002.58 98,516.30 663,170.87 761,687.17 912,097.38 150,410.21 83.51% Machinery & Equipment 445000 - Motor Equipment - - - - 65,000.00 65,000.00 0.00% 445003 - Park Equipment 8,045.00 8,045.00 130,382.00 138,427.00 1,164,545.00 1,026,118.00 11.89% 445008 - Other Equipment - - 29,121.03 29,121.03 29,121.03 - 100.00% 445100 - Lease Purchase/Motor Equip - 13,638.00 28,100.00 41,738.00 1,047,863.30 1,006,125.30 3.98% 445108 - Lease Purchase/Other Equip - - - - 436,000.00 436,000.00 0.00% Total Machinery & Equipment 8,045.00 21,683.00 187,603.03 209,286.03 2,742,529.33 2,533,243.30 7.63% Total Capital Expenses 90,047.58 120,199.30 851,023.90 971,223.20 9,654,876.71 8,683,653.51 10.06% Other Uses 452002 - Allocations-Admin Cost - 62,863.68 - 62,863.68 754,364.00 691,500.32 8.33% 452003 - Allocations-IT - 62,116.42 - 62,116.42 745,397.00 683,280.58 8.33% 452004 - Allocations-Liability Insurance - 23,170.33 - 23,170.33 278,044.00 254,873.67 8.33% 452008 - Allocations-Payroll Cost - 7,032.25 - 7,032.25 84,387.00 77,354.75 8.33% 452009 - Allocations-Facilities Mgmt - 2,436.75 - 2,436.75 29,241.00 26,804.25 8.33% Total Other Uses - 157,619.43 - 157,619.43 1,891,433.00 1,733,813.57 8.33% Total Expenses 1,370,477.58 3,861,444.81 1,726,696.34 5,588,141.15 28,281,696.91 22,693,555.76 19.76%