Loading...
HomeMy WebLinkAboutSept 22 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 75% Parks General Fund: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Taxes Property Taxes 311000 - Civil City Property Taxes -5,801,007.69 10,580,413.00 4,779,405.31 54.83% Total Property Taxes - 5,801,007.69 10,580,413.00 4,779,405.31 54.83% Total Taxes - 5,801,007.69 10,580,413.00 4,779,405.31 54.83% Total Intergovernmental Revenue - 427,491.38 953,848.00 526,356.62 44.82% Licenses & Permits Nonbusiness Licenses & Permits 322050 - Park Food Sales Permit 82.50 295.00 250.00 (45.00)118.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 334.62 35,588.78 40,213.00 4,624.22 88.50% 347002 - Picnic Site Rental 110.73 3,562.57 -(3,562.57)0.00% 347003 - Golf Season Pass -269,172.20 172,000.00 (97,172.20)156.50% 347004 - Golf Green Fees 120,269.06 772,255.32 805,000.00 32,744.68 95.93% 347005 - Golf Cart Rentals 50,415.69 344,724.08 365,000.00 20,275.92 94.44% 347006 - Golf Pro Shop Retail 8,324.38 65,575.40 59,500.00 (6,075.40)110.21% 347007 - Golf Driving Range 4,992.00 37,628.00 30,000.00 (7,628.00)125.43% 347008 - Golf Gift Certificate -35.00 -(35.00)0.00% 347009 - Golf Outings -7,808.89 -(7,808.89)0.00% 347010 - Concession Sales 1,966.20 55,903.38 69,000.00 13,096.62 81.02% 347011 - Recreational Programming 10,574.82 361,744.68 523,565.00 161,820.32 69.09% 347012 - Food Sales 11,827.57 65,277.02 53,277.00 (12,000.02)122.52% 347013 - Nonalcoholic Beverage 5,389.15 37,151.06 31,500.00 (5,651.06)117.94% 347014 - Alcoholic Beverage Sales 21,229.28 137,765.99 110,900.00 (26,865.99)124.23% 347015 - Lease of Stadium 15,000.00 75,000.00 75,000.00 -100.00% 347016 - East Race Waterway 2,482.20 57,503.17 60,000.00 2,496.83 95.84% 347017 - Ice Skating 14,514.50 211,571.88 300,000.00 88,428.12 70.52% 347019 - Site Mowing -117,974.10 222,839.00 104,864.90 52.94% 347021 - Tree Maintenance 31,427.08 146,829.65 120,000.00 (26,829.65)122.36% 347023 - Graffiti Removal -4,930.26 -(4,930.26)0.00% 347026 - Room Rental 10,091.68 94,170.73 56,000.00 (38,170.73)168.16% 347030 - Merch Sales 1,012.41 2,858.15 -(2,858.15)0.00% 347040 - Pavilion Rental 1,613.32 31,193.83 15,000.00 (16,193.83)207.96% 347100 - Concessions-Employee Discounts (233.32)(1,658.96)-1,658.96 0.00% Total Culture & Recreation 311,341.37 2,934,565.18 3,108,794.00 174,228.82 94.40% Total Charges for Services 311,341.37 2,934,565.18 3,108,794.00 174,228.82 94.40% Fines, Forefeitures, Fees 351002 - Bad Checks Fines -24.00 -(24.00)0.00% Total Fines, Forfeitures, Fees - 24.00 - (24.00) 0.00% Miscellaneous Revenue 360000 - Miscellaneous 620.01 9,024.35 9,500.00 475.65 94.99% 360001 - Sale of Scrap Metal 78.75 925.07 -(925.07)0.00% 361000 - Interest Earnings 7,731.54 30,895.38 15,000.00 (15,895.38)205.97% 362000 - Rental of Property 11,431.50 55,587.50 60,000.00 4,412.50 92.65% 367000 - Donations from Private Sources -640,828.93 1,061,000.00 420,171.07 60.40% Total Miscellaneous Revenue 19,861.80 737,261.23 1,145,500.00 408,238.77 64.36% Refunds & Reimbursements 380000 - Misc Reimbursements 500.00 18,571.29 18,253.00 (318.29)101.74% 380007 - Energy Rebates -808.98 809.00 0.02 100.00% 381000 - Misc Reimbursements -4,916.40 245,441.00 240,524.60 2.00% 396000 - Refunds 939.75 46,735.30 43,284.00 (3,451.30)107.97% Total Refunds & Reimbursements 1,439.75 71,031.97 307,787.00 236,755.03 23.08% Other Sources 391000 - Interfund Transfers In 9,935.00 89,416.00 119,221.00 29,805.00 75.00% 392000 - Gain/Loss on Sale of Asset 53,682.00 53,682.00 -(53,682.00)0.00% 392005 - Sale of Non-Capital Assets 11,776.00 11,776.00 -(11,776.00)0.00% September 30, 2022 393000 - Capital Lease Proceeds -1,290,000.00 1,290,000.00 -100.00% Total Other Sources 75,393.00 1,444,874.00 1,409,221.00 (35,653.00) 102.53% Total Revenue 408,118.42 11,416,550.45 17,505,813.00 6,089,262.55 65.22% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 318,029.75 2,163,292.50 -2,163,292.50 3,049,049.00 885,756.50 70.95% 410002 - Teamster Wages 157,843.54 1,100,931.40 -1,100,931.40 1,542,175.00 441,243.60 71.39% 410003 - Permanent Part Time 149,845.46 751,500.30 -751,500.30 1,038,670.00 287,169.70 72.35% 410004 - Extra & Overtime 12,043.63 110,949.11 -110,949.11 95,975.00 (14,974.11)115.60% 410005 - Seasonal & Interns 70,073.62 627,782.15 -627,782.15 834,551.00 206,768.85 75.22% 410007 - Longevity Pay 700.00 6,183.32 -6,183.32 8,450.00 2,266.68 73.18% 410014 - Contract Add Pays ------0.00% 410017 - Stand By Pay 337.12 2,352.48 -2,352.48 3,500.00 1,147.52 67.21% 410022 - Park Board Stipend ----1,200.00 1,200.00 0.00% Total Salaries & Wages 708,873.12 4,762,991.26 - 4,762,991.26 6,573,570.00 1,810,578.74 72.46% Employee Benefits 411001 - FICA Regular 53,031.83 367,891.25 -367,891.25 506,363.00 138,471.75 72.65% 411004 - PERF Regular 53,949.58 382,576.02 -382,576.02 530,630.00 148,053.98 72.10% 411005 - PERF Union 1,781.99 14,188.60 -14,188.60 26,912.00 12,723.40 52.72% 411007 - Unemployment Comp 52.03 4,576.28 -4,576.28 7,520.00 2,943.72 60.85% 411008 - Health Insurance 87,305.28 783,101.96 -783,101.96 1,192,876.00 409,774.04 65.65% 411009 - Life Insurance 820.00 7,410.00 -7,410.00 10,560.00 3,150.00 70.17% 411014 - Parental Leave 1,719.80 11,794.63 -11,794.63 16,447.00 4,652.37 71.71% 411015 - Other Fringe Benefits -1,490.00 -1,490.00 1,500.00 10.00 99.33% 411201 - Tool Allowance 388.14 3,417.69 488.41 3,906.10 4,800.00 893.90 81.38% 411203 - Job Readiness Allow.-14,875.00 -14,875.00 19,425.00 4,550.00 76.58% 411204 - Auto Allowance 266.66 2,399.94 -2,399.94 3,200.00 800.06 75.00% 411206 - Cell Phone Allowance 1,045.00 9,460.00 -9,460.00 12,820.00 3,360.00 73.79% Total Employee Benefits 200,360.31 1,603,181.37 488.41 1,603,669.78 2,333,053.00 729,383.22 68.74% Total Personnel Expenses 909,233.43 6,366,172.63 488.41 6,366,661.04 8,906,623.00 2,539,961.96 71.48% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,824.58 12,701.06 1,162.28 13,863.34 23,579.18 9,715.84 58.79% Total Office Supplies 1,824.58 12,701.06 1,162.28 13,863.34 23,579.18 9,715.84 58.79% Operating Supplies 422000 - Other Operating Supplies 24,723.20 254,109.78 29,377.23 283,487.01 310,604.02 27,117.01 91.27% 422001 - C.S. Gasoline 26,660.51 187,967.91 -187,967.91 165,000.00 (22,967.91)113.92% 422002 - Diesel/CNG -5,432.27 6,309.00 11,741.27 4,000.00 (7,741.27)293.53% 422003 - Gasoline -14,806.68 9,025.00 23,831.68 25,905.00 2,073.32 92.00% 422004 - Oil -35.30 -35.30 50.00 14.70 70.60% 422005 - Uniforms 686.21 8,498.93 1,218.25 9,717.18 21,695.00 11,977.82 44.79% 422006 - Computer Supplies & Equipment 64.89 384.82 -384.82 500.00 115.18 76.96% 422007 - Cleaning Supplies -4,043.52 -4,043.52 6,950.00 2,906.48 58.18% 422008 - Medical/Safety Supplies 1,217.86 12,977.24 -12,977.24 14,756.00 1,778.76 87.95% 422009 - Recreation Supplies 26,099.82 120,882.35 24,507.95 145,390.30 230,251.60 84,861.30 63.14% 422010 - Plants Chemicals Seed & Fertilizer 1,041.04 136,285.40 47,299.99 183,585.39 182,575.00 (1,010.39)100.55% 422013 - Promotional Supplies 40.00 499.91 -499.91 -(499.91)0.00% 422014 - Concessions Inventory 24,992.94 135,558.24 3,362.67 138,920.91 94,205.00 (44,715.91)147.47% 422016 - Inventory For Sale 9,766.73 51,578.25 2,596.47 54,174.72 34,035.00 (20,139.72)159.17% Total Operating Supplies 115,293.20 933,060.60 123,696.56 1,056,757.16 1,090,526.62 33,769.46 96.90% Repair & Maintenance Supplies 423000 - Other R&M Supplies 12,515.19 192,805.96 23,132.89 215,938.85 236,465.04 20,526.19 91.32% 423001 - Building Materials 3,724.08 59,967.42 2,298.00 62,265.42 90,000.00 27,734.58 69.18% 423006 - Small Tools & Equipment 1,521.14 20,858.11 -20,858.11 25,573.00 4,714.89 81.56% 423009 - Repair Parts 2,008.68 48,764.61 4,982.17 53,746.78 82,429.03 28,682.25 65.20% Total Repair & Maintenance Supplies 19,769.09 322,396.10 30,413.06 352,809.16 434,467.07 81,657.91 81.21% Total Supplies Expenses 136,886.87 1,268,157.76 155,271.90 1,423,429.66 1,548,572.87 125,143.21 91.92% Services & Charges Expenses Professional Services 431000 - Other Professional Services 15,626.64 113,141.69 40,176.68 153,318.37 148,277.00 (5,041.37)103.40% 431009 - Computer & Technology -31.83 -31.83 500.00 468.17 6.37% 431014 - Collection Costs 15.00 56.25 -56.25 100.00 43.75 56.25% 431015 - Laboratory Water Testing --250.00 250.00 300.00 50.00 83.33% 431019 - Security Services 3,833.12 34,754.48 13,164.00 47,918.48 48,540.00 621.52 98.72% Total Professional Services 19,474.76 147,984.25 53,590.68 201,574.93 197,717.00 (3,857.93) 101.95% Communication & Transportation 432002 - Mailing 840.01 2,273.21 150.00 2,423.21 4,875.00 2,451.79 49.71% 432003 - Travel 4,879.66 9,838.27 13,592.72 23,430.99 27,450.00 4,019.01 85.36% 432004 - Telecommunications -1,477.34 3,153.80 4,631.14 9,703.80 5,072.66 47.73% 432005 - Mileage Reimb -628.96 469.96 1,098.92 2,975.00 1,876.08 36.94% Total Communication & Transportation 5,719.67 14,217.78 17,366.48 31,584.26 45,003.80 13,419.54 70.18% Printing & Advertising 433001 - Outside Printing Services -11,877.50 -11,877.50 19,480.00 7,602.50 60.97% 433002 - Publication of Legal Notice -996.10 1,111.30 2,107.40 2,200.00 92.60 95.79% 433003 - Promotional 43,076.31 288,653.21 112,315.81 400,969.02 388,654.06 (12,314.96)103.17% Total Printing & Advertising 43,076.31 301,526.81 113,427.11 414,953.92 410,334.06 (4,619.86) 101.13% Utilties 435001 - Electric 54,923.28 394,088.65 -394,088.65 452,847.00 58,758.35 87.02% 435002 - Natural Gas 2,880.12 145,886.65 -145,886.65 113,457.00 (32,429.65)128.58% 435004 - Water 34,180.54 205,043.77 -205,043.77 214,000.00 8,956.23 95.81% Total Utilities 91,983.94 745,019.07 - 745,019.07 780,304.00 35,284.93 95.48% Repairs & Maintenance 436000 - Other R&M 4,775.92 38,728.78 11,956.97 50,685.75 80,930.53 30,244.78 62.63% 436001 - Building R&M 13,703.98 178,884.20 22,302.10 201,186.30 206,994.82 5,808.52 97.19% 436002 - Office Equip R&M 28.88 28.88 -28.88 -(28.88)0.00% 436003 - Auto Equip R&M 17,417.77 250,872.84 -250,872.84 265,000.00 14,127.16 94.67% 436005 - Other Equip R&M 526.24 1,835.91 108.00 1,943.91 6,800.00 4,856.09 28.59% 436006 - Radio Equip R&M 1.00 10,169.23 -10,169.23 10,500.00 330.77 96.85% 436011 - Exterminating -3,416.00 4,246.00 7,662.00 8,334.00 672.00 91.94% Total Repairs & Maintenance 36,453.79 483,935.84 38,613.07 522,548.91 578,559.35 56,010.44 90.32% Rentals 437002 - Equipment Rental 2,150.00 9,349.83 -9,349.83 600.00 (8,749.83)1558.31% 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,200.00 -100.00% Total Rentals 2,150.00 22,549.83 - 22,549.83 13,800.00 (8,749.83) 163.40% Debt Service 438100 - Principal -316,842.88 -316,842.88 387,682.81 70,839.93 81.73% 438200 - Interest -17,545.26 -17,545.26 23,339.19 5,793.93 75.18% 438300 - Paying Agent Fees -4,400.00 -4,400.00 5,000.00 600.00 88.00% Total Debt Service - 338,788.14 - 338,788.14 416,022.00 77,233.86 81.44% Other Charges & Services 439000 - Misc Charges & Svcs 71,025.23 522,727.28 85,795.20 608,522.48 695,795.29 87,272.81 87.46% 439001 - Other Contractual Services 1,326.16 9,103.49 11,000.00 20,103.49 21,300.00 1,196.51 94.38% 439002 - Licenses & Permits 40.00 12,574.77 -12,574.77 13,125.00 550.23 95.81% 439003 - Subscriptions 526.95 3,680.86 -3,680.86 4,320.00 639.14 85.21% 439004 - Dues & Memberships -9,107.37 -9,107.37 17,310.00 8,202.63 52.61% 439005 - Bank & Credit Card Fees 6,904.77 75,651.40 -75,651.40 57,655.00 (17,996.40)131.21% 439006 - Education & Training 1,391.63 17,486.52 2,998.73 20,485.25 29,925.00 9,439.75 68.46% 439009 - Trash Removal 7,854.38 47,221.78 6,978.59 54,200.37 62,434.41 8,234.04 86.81% 439012 - Uniform Services 2,017.23 12,740.19 -12,740.19 11,200.00 (1,540.19)113.75% 439018 - Demolition & Clearance --18,000.00 18,000.00 18,000.00 -100.00% 439099 - Cashier Over/Short 305.27 872.93 -872.93 1,650.00 777.07 52.90% 439100 - Refunds/Awards/Indemnities 2,515.98 25,048.31 -25,048.31 28,085.00 3,036.69 89.19% 439300 - Grants & Subsidies -715,000.00 -715,000.00 715,000.00 -100.00% Total Other Services & Charges 93,907.60 1,451,214.90 124,772.52 1,575,987.42 1,675,799.70 99,812.28 94.04% Total Services & Charges Expenses 292,766.07 3,505,236.62 347,769.86 3,853,006.48 4,117,539.91 264,533.43 93.58% Capital Outlay Buildings 443001 - Building Improvements 1,251.25 102,200.00 250.00 102,450.00 102,450.00 -100.00% Total Buildings 1,251.25 102,200.00 250.00 102,450.00 102,450.00 - 100.00% 444000 - Land Improvements 12,898.00 250,431.38 858,606.32 1,109,037.70 1,294,470.49 185,432.79 85.68% Machinery & Equipment 445000 - Motor Equipment -10,866.95 -10,866.95 10,866.86 (0.09)100.00% 445003 - Park Equipment -97,696.26 152,581.24 250,277.50 705,777.50 455,500.00 35.46% 445006 - Computer Equip/Network -17,007.12 -17,007.12 17,011.00 3.88 99.98% 445100 - Lease Purchase/Motor Equip 242,136.70 242,136.70 271,257.83 513,394.53 1,290,000.00 776,605.47 39.80% Total Machinery & Equipment 242,136.70 367,707.03 423,839.07 791,546.10 2,023,655.36 1,232,109.26 39.11% Total Capital Expenses 256,285.95 720,338.41 1,282,695.39 2,003,033.80 3,420,575.85 1,417,542.05 58.56% Other Uses 452002 - Allocations-Admin Cost 61,510.58 553,595.26 -553,595.26 738,127.00 184,531.74 75.00% 452003 - Allocations-IT 57,450.84 517,057.48 -517,057.48 689,410.00 172,352.52 75.00% 452004 - Allocations-Liability Insurance 24,384.42 219,459.74 -219,459.74 292,613.00 73,153.26 75.00% 452008 - Allocations-Payroll Cost 6,895.25 62,057.25 -62,057.25 82,743.00 20,685.75 75.00% 452009 - Allocations-Facilities Mgmt 2,296.25 20,666.25 -20,666.25 27,555.00 6,888.75 75.00% Total Other Uses 152,537.34 1,372,835.98 - 1,372,835.98 1,830,448.00 457,612.02 75.00% Bad Debt Expense 490000 - Bad Debt Expense -1,100.00 -1,100.00 -(1,100.00)0.00% Total Bad Debt Expense - 1,100.00 - 1,100.00 - (1,100.00) 0.00% Total Expenses 1,747,709.66 13,233,841.40 1,786,225.56 15,020,066.96 19,823,759.63 4,803,692.67 75.77%