Loading...
HomeMy WebLinkAboutJune 23 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 50% 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 12,716.75 15,108.10 30,000.00 14,891.90 50.36% 347002 - Picnic Site Rental 943.04 2,321.78 6,154.00 3,832.22 37.73% 347003 - Golf Season Pass 7,920.00 278,373.19 221,898.00 (56,475.19) 125.45% 347004 - Golf Green Fees 123,477.29 297,328.19 785,529.00 488,200.81 37.85% 347005 - Golf Cart Rentals 56,982.99 134,894.17 392,284.00 257,389.83 34.39% 347006 - Golf Pro Shop Retail 12,102.67 35,895.57 77,652.00 41,756.43 46.23% 347007 - Golf Driving Range 6,782.00 18,920.00 34,323.00 15,403.00 55.12% 347009 - Golf Outings 3,107.03 6,669.33 - (6,669.33) 0.00% 347010 - Concession Sales 20,590.33 29,330.55 56,200.00 26,869.45 52.19% 347011 - Recreational Programming 44,538.80 293,352.41 372,321.00 78,968.59 78.79% 347012 - Food Sales 11,356.70 27,987.59 68,447.00 40,459.41 40.89% 347013 - Nonalcoholic Beverage 6,881.54 15,155.89 41,633.00 26,477.11 36.40% 347014 - Alcoholic Beverage Sales 25,567.42 67,801.83 151,573.00 83,771.17 44.73% 347015 - Lease of Stadium 30,000.00 45,000.00 75,000.00 30,000.00 60.00% 347016 - East Race Waterway 13,101.10 18,248.30 50,000.00 31,751.70 36.50% 347017 - Ice Skating - 182,387.99 400,000.00 217,612.01 45.60% 347021 - Tree Maintenance 3,366.21 19,508.09 - (19,508.09) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% 347026 - Room Rental 4,800.73 54,782.01 57,972.00 3,189.99 94.50% 347030 - Merch Sales (770.30) (601.76) - 601.76 0.00% 347040 - Pavilion Rental 4,650.83 19,437.36 33,710.00 14,272.64 57.66% 347100 - Concessions-Employee Discounts (385.12) (958.29) - 958.29 0.00% Total Culture & Recreation 387,730.01 1,560,942.30 2,856,696.00 1,295,753.70 54.64% Total Charges for Services 387,730.01 1,560,942.30 2,856,696.00 1,295,753.70 54.64% Miscellaneous Revenue 360000 - Miscellaneous 804.64 3,772.54 6,483.00 2,710.46 58.19% 360001 - Sale of Scrap Metal 241.08 964.73 - (964.73) 0.00% 360011 - Settlement Fees 30,950.00 50,450.00 - (50,450.00) 0.00% 361000 - Interest Earnings 3,980.31 43,536.81 15,000.00 (28,536.81) 290.25% 362000 - Rental of Property 12,306.18 43,612.23 72,337.00 28,724.77 60.29% 367000 - Donations from Private Sources - 1,445,500.00 5,184,000.00 3,738,500.00 27.88% Total Miscellaneous Revenue 48,282.21 1,587,836.31 5,277,820.00 3,689,983.69 30.09% Refunds & Reimbursements 380000 - Misc Reimbursements 26.07 53,402.76 45,000.00 (8,402.76) 118.67% 396000 - Refunds - 519.12 - (519.12) 0.00% Total Refunds & Reimbursements 26.07 53,921.88 45,000.00 (8,921.88) 119.83% 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 436,038.29 4,793,023.49 26,929,101.00 22,136,077.51 17.80% June 30, 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 265,031.67 1,568,955.23 - 1,568,955.23 3,467,002.00 1,898,046.77 45.25% 410002 - Teamster Wages 131,748.58 752,317.25 - 752,317.25 1,632,649.00 880,331.75 46.08% 410003 - Permanent Part Time 119,006.68 488,558.75 - 488,558.75 1,051,395.00 562,836.25 46.47% 410004 - Extra & Overtime 14,339.83 51,539.07 - 51,539.07 58,850.00 7,310.93 87.58% 410005 - Seasonal & Interns 98,353.81 290,926.68 - 290,926.68 834,951.00 544,024.32 34.84% 410007 - Longevity Pay 350.00 4,500.00 - 4,500.00 8,050.00 3,550.00 55.90% 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 628,830.57 3,157,889.76 - 3,157,889.76 7,054,097.00 3,896,207.24 44.77% Employee Benefits 411001 - FICA Regular 46,198.60 235,472.06 - 235,472.06 542,270.00 306,797.94 43.42% 411004 - PERF Regular 41,669.15 255,490.25 - 255,490.25 582,642.00 327,151.75 43.85% 411005 - PERF Union 1,241.65 7,738.02 - 7,738.02 22,878.00 15,139.98 33.82% 411007 - Unemployment Comp 40.05 242.78 - 242.78 6,200.00 5,957.22 3.92% 411008 - Health Insurance 89,536.74 525,686.54 - 525,686.54 1,274,947.00 749,260.46 41.23% 411009 - Life Insurance 875.00 5,060.00 - 5,060.00 10,920.00 5,860.00 46.34% 411010 - Med/Surgical/Dental 1,053.58 6,170.69 - 6,170.69 - (6,170.69) 0.00% 411014 - Parental Leave 1,363.62 8,203.35 - 8,203.35 18,082.00 9,878.65 45.37% 411015 - Other Fringe Benefits - 1,400.00 - 1,400.00 - (1,400.00) 0.00% 411200 - Clothing Allowance - 155.14 - 155.14 156.00 0.86 99.45% 411201 - Tool Allowance 420.81 2,000.33 - 2,000.33 4,644.00 2,643.67 43.07% 411203 - Job Readiness Allow. (8,977.84) - - - 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 770.00 5,115.00 - 5,115.00 11,880.00 6,765.00 43.06% Total Employee Benefits 174,191.36 1,054,067.46 - 1,054,067.46 2,493,544.00 1,439,476.54 42.27% Total Personnel Expenses 803,021.93 4,211,957.22 - 4,211,957.22 9,547,641.00 5,335,683.78 44.12% Supplies Expenses Office Supplies 421000 - General Office Supplies 699.64 7,104.91 2,085.01 9,189.92 17,596.05 8,406.13 52.23% Total Office Supplies 699.64 7,104.91 2,085.01 9,189.92 17,596.05 8,406.13 52.23% Operating Supplies 422000 - Other Operating Supplies 23,908.37 175,087.98 11,988.04 187,076.02 328,951.06 141,875.04 56.87% 422001 - C.S. Gasoline 17,621.41 108,130.56 - 108,130.56 220,000.00 111,869.44 49.15% 422002 - Diesel/CNG - 1,463.65 1,767.98 3,231.63 4,936.00 1,704.37 65.47% 422003 - Gasoline 1,690.50 9,697.62 631.50 10,329.12 27,981.50 17,652.38 36.91% 422005 - Uniforms 652.68 4,829.05 1,249.50 6,078.55 20,982.25 14,903.70 28.97% 422006 - Computer Supplies & Equipment 599.99 766.42 - 766.42 767.00 0.58 99.92% 422007 - Cleaning Supplies 113.58 590.36 - 590.36 3,120.00 2,529.64 18.92% 422008 - Medical/Safety Supplies 660.74 9,062.34 - 9,062.34 16,309.00 7,246.66 55.57% 422009 - Recreation Supplies 19,969.22 44,149.98 11,253.12 55,403.10 140,697.68 85,294.58 39.38% 422010 - Plants Chemicals Seed & Fertilizer 7,236.53 161,891.19 12,230.67 174,121.86 283,674.00 109,552.14 61.38% 422014 - Concessions Inventory 42,452.72 78,872.26 8,343.38 87,215.64 124,408.32 37,192.68 70.10% 422016 - Inventory For Sale 17,695.11 59,458.89 2,205.31 61,664.20 40,725.21 (20,938.99) 151.42% Total Operating Supplies 132,600.85 654,000.30 49,669.50 703,669.80 1,212,552.02 508,882.22 58.03% Repair & Maintenance Supplies 423000 - Other R&M Supplies 25,383.33 112,508.24 40,838.68 153,346.92 310,076.81 156,729.89 49.45% 423001 - Building Materials 19,100.50 56,530.67 15,065.00 71,595.67 145,169.45 73,573.78 49.32% 423006 - Small Tools & Equipment 8,296.15 28,175.47 315.62 28,491.09 26,852.00 (1,639.09) 106.10% 423009 - Repair Parts 9,897.13 50,403.94 16,910.37 67,314.31 82,164.24 14,849.93 81.93% Total Repair & Maintenance Supplies 62,677.11 247,618.32 73,129.67 320,747.99 564,262.50 243,514.51 56.84% Total Supplies Expenses 195,977.60 908,723.53 124,884.18 1,033,607.71 1,794,410.57 760,802.86 57.60% Services & Charges Expenses Professional Services 431000 - Other Professional Services 38,973.55 175,660.80 52,813.37 228,474.17 256,659.71 28,185.54 89.02% 431001 - Legal Services 500.00 500.00 49,500.00 50,000.00 500.00 (49,500.00) 10000.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 11,730.54 21,159.93 25,022.00 46,181.93 207,869.00 161,687.07 22.22% Total Professional Services 51,204.09 205,126.48 127,335.37 332,461.85 473,403.71 140,941.86 70.23% Communication & Transportation 432002 - Mailing 36.60 3,674.83 883.31 4,558.14 6,650.00 2,091.86 68.54% 432003 - Travel 151.96 2,486.32 9,104.60 11,590.92 33,880.41 22,289.49 34.21% 432004 - Telecommunications - 875.87 2,671.52 3,547.39 13,023.80 9,476.41 27.24% 432005 - Mileage Reimb - 845.89 176.96 1,022.85 6,551.96 5,529.11 15.61% Total Communication & Transportation 188.56 7,882.91 12,836.39 20,719.30 60,106.17 39,386.87 34.47% Printing & Advertising 433001 - Outside Printing Services 443.50 2,526.97 2,391.75 4,918.72 14,565.00 9,646.28 33.77% 433002 - Publication of Legal Notice - 1,038.00 677.81 1,715.81 3,277.72 1,561.91 52.35% 433003 - Promotional 19,341.04 117,408.35 27,502.67 144,911.02 698,508.90 553,597.88 20.75% Total Printing & Advertising 19,784.54 120,973.32 30,572.23 151,545.55 716,351.62 564,806.07 21.16% Utilties 435001 - Electric 40,019.96 248,822.91 - 248,822.91 538,707.00 289,884.09 46.19% 435002 - Natural Gas 5,101.83 127,256.61 - 127,256.61 309,583.00 182,326.39 41.11% 435004 - Water 40,841.71 96,397.72 - 96,397.72 300,000.00 203,602.28 32.13% Total Utilities 85,963.50 472,477.24 - 472,477.24 1,148,290.00 675,812.76 41.15% Repairs & Maintenance 436000 - Other R&M 17,545.62 38,858.92 26,505.00 65,363.92 323,156.99 257,793.07 20.23% 436001 - Building R&M 49,340.03 293,736.68 61,547.82 355,284.50 364,077.60 8,793.10 97.58% 436003 - Auto Equip R&M 16,840.41 139,516.24 - 139,516.24 351,750.00 212,233.76 39.66% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 8,042.10 1,125.68 86.00% 436006 - Radio Equip R&M 5,573.87 11,813.09 - 11,813.09 7,200.00 (4,613.09) 164.07% 436011 - Exterminating 1,488.00 2,042.00 11,345.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 90,787.93 492,883.35 99,397.82 592,281.17 1,070,568.69 478,287.52 55.32% Rentals 437002 - Equipment Rental 1,215.40 2,144.58 - 2,144.58 930.00 (1,214.58) 230.60% 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 1,215.40 15,344.58 - 15,344.58 14,190.00 (1,154.58) 108.14% Debt Service 438100 - Principal - 280,683.30 - 280,683.30 548,925.00 268,241.70 51.13% 438200 - Interest - 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 - 305,549.43 - 305,549.43 600,891.00 295,341.57 50.85% Other Charges & Services 439000 - Misc Charges & Svcs 10,506.58 98,695.35 61,972.42 160,667.77 246,052.96 85,385.19 65.30% 439001 - Other Contractual Services 30,072.36 40,987.72 73,731.07 114,718.79 149,002.00 34,283.21 76.99% 439002 - Licenses & Permits 48.84 6,602.59 - 6,602.59 14,211.00 7,608.41 46.46% 439003 - Subscriptions 385.91 4,481.29 - 4,481.29 5,414.00 932.71 82.77% 439004 - Dues & Memberships 536.40 10,676.28 - 10,676.28 25,201.00 14,524.72 42.36% 439005 - Bank & Credit Card Fees 9,587.46 48,658.65 - 48,658.65 102,398.00 53,739.35 47.52% 439006 - Education & Training 1,564.27 23,047.13 6,727.47 29,774.60 36,310.45 6,535.85 82.00% 439009 - Trash Removal 3,896.22 25,361.97 3,384.62 28,746.59 49,967.03 21,220.44 57.53% 439012 - Uniform Services 3,359.09 11,800.27 - 11,800.27 15,941.00 4,140.73 74.02% 439018 - Demolition & Clearance - 17,100.00 900.00 18,000.00 18,000.00 - 100.00% 439099 - Cashier Over/Short 116.58 (356.69) - (356.69) - 356.69 0.00% 439100 - Refunds/Awards/Indemnities 208.50 5,216.87 - 5,216.87 42,037.00 36,820.13 12.41% 439300 - Grants & Subsidies - 615,000.00 - 615,000.00 635,000.00 20,000.00 96.85% Total Other Services & Charges 60,282.21 907,271.43 146,715.58 1,053,987.01 1,339,534.44 285,547.43 78.68% Total Services & Charges Expenses 309,426.23 2,527,508.74 416,857.39 2,944,366.13 5,423,335.63 2,478,969.50 54.29% 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 18,313.51 295,383.95 467,532.88 762,916.83 2,037,097.38 1,274,180.55 37.45% Machinery & Equipment 445000 - Motor Equipment - - - - 28,116.00 28,116.00 0.00% 445003 - Park Equipment - 8,045.00 912,397.40 920,442.40 1,201,429.00 280,986.60 76.61% 445008 - Other Equipment - - 29,121.03 29,121.03 29,121.03 - 100.00% 445100 - Lease Purchase/Motor Equip 41,800.00 272,534.00 14,850.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 41,800.00 280,579.00 956,368.43 1,236,947.43 2,742,529.33 1,505,581.90 45.10% Total Capital Expenses 60,113.51 575,962.95 1,424,151.31 2,000,114.26 10,779,876.71 8,779,762.45 18.55% 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,368,539.27 8,854,630.16 1,965,892.88 10,820,523.04 29,436,696.91 18,616,173.87 36.76%