Loading...
HomeMy WebLinkAboutOct 22 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 83% 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 -295.00 250.00 (45.00)118.00% Charges for Services Culture & Recreation 347001 - Swimming Pool -35,588.78 40,213.00 4,624.22 88.50% 347002 - Picnic Site Rental 33.68 3,596.25 -(3,596.25)0.00% 347003 - Golf Season Pass -269,172.20 172,000.00 (97,172.20)156.50% 347004 - Golf Green Fees 59,804.00 832,059.32 805,000.00 (27,059.32)103.36% 347005 - Golf Cart Rentals 31,934.83 376,658.91 365,000.00 (11,658.91)103.19% 347006 - Golf Pro Shop Retail 4,807.51 70,382.91 59,500.00 (10,882.91)118.29% 347007 - Golf Driving Range 2,703.00 40,331.00 30,000.00 (10,331.00)134.44% 347008 - Golf Gift Certificate -35.00 -(35.00)0.00% 347009 - Golf Outings -7,808.89 -(7,808.89)0.00% 347010 - Concession Sales 2,070.08 57,973.46 69,000.00 11,026.54 84.02% 347011 - Recreational Programming 25,225.05 386,969.73 523,565.00 136,595.27 73.91% 347012 - Food Sales 6,538.59 71,815.61 53,277.00 (18,538.61)134.80% 347013 - Nonalcoholic Beverage 2,384.08 39,535.14 31,500.00 (8,035.14)125.51% 347014 - Alcoholic Beverage Sales 12,421.40 150,187.39 110,900.00 (39,287.39)135.43% 347015 - Lease of Stadium -75,000.00 75,000.00 -100.00% 347016 - East Race Waterway -57,503.17 60,000.00 2,496.83 95.84% 347017 - Ice Skating 1,837.50 213,409.38 300,000.00 86,590.62 71.14% 347019 - Site Mowing -117,974.10 222,839.00 104,864.90 52.94% 347021 - Tree Maintenance 340.63 147,170.28 120,000.00 (27,170.28)122.64% 347023 - Graffiti Removal -4,930.26 -(4,930.26)0.00% 347026 - Room Rental 6,928.60 101,099.33 56,000.00 (45,099.33)180.53% 347030 - Merch Sales 263.42 3,121.57 -(3,121.57)0.00% 347040 - Pavilion Rental 716.80 31,910.63 15,000.00 (16,910.63)212.74% 347100 - Concessions-Employee Discounts (166.26)(1,825.22)-1,825.22 0.00% Total Culture & Recreation 157,842.91 3,092,408.09 3,108,794.00 16,385.91 99.47% Total Charges for Services 157,842.91 3,092,408.09 3,108,794.00 16,385.91 99.47% 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 122.72 9,147.07 9,500.00 352.93 96.28% 360001 - Sale of Scrap Metal 103.75 1,028.82 -(1,028.82)0.00% 360011 - Settlement Fees 80,000.00 80,000.00 -(80,000.00)0.00% 361000 - Interest Earnings 6,034.11 36,929.49 15,000.00 (21,929.49)246.20% 362000 - Rental of Property 5,915.75 61,503.25 60,000.00 (1,503.25)102.51% 367000 - Donations from Private Sources -640,828.93 1,061,000.00 420,171.07 60.40% Total Miscellaneous Revenue 92,176.33 829,437.56 1,145,500.00 316,062.44 72.41% Refunds & Reimbursements 380000 - Misc Reimbursements 344.33 18,915.62 18,253.00 (662.62)103.63% 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 949.03 47,684.33 43,284.00 (4,400.33)110.17% Total Refunds & Reimbursements 1,293.36 72,325.33 307,787.00 235,461.67 23.50% Other Sources 391000 - Interfund Transfers In 9,935.00 99,351.00 119,221.00 19,870.00 83.33% 392000 - Gain/Loss on Sale of Asset -53,682.00 -(53,682.00)0.00% October 31, 2022 392005 - Sale of Non-Capital Assets -11,776.00 -(11,776.00)0.00% 393000 - Capital Lease Proceeds -1,290,000.00 1,290,000.00 -100.00% Total Other Sources 9,935.00 1,454,809.00 1,409,221.00 (45,588.00) 103.23% Total Revenue 261,247.60 11,677,798.05 17,505,813.00 5,828,014.95 66.71% 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 220,385.72 2,383,678.22 -2,383,678.22 3,049,049.00 665,370.78 78.18% 410002 - Teamster Wages 108,590.47 1,209,521.87 -1,209,521.87 1,542,175.00 332,653.13 78.43% 410003 - Permanent Part Time 96,958.65 848,458.95 -848,458.95 1,038,670.00 190,211.05 81.69% 410004 - Extra & Overtime 12,160.72 123,109.83 -123,109.83 95,975.00 (27,134.83)128.27% 410005 - Seasonal & Interns 37,619.01 665,401.16 -665,401.16 834,551.00 169,149.84 79.73% 410007 - Longevity Pay 350.00 6,533.32 -6,533.32 8,450.00 1,916.68 77.32% 410014 - Contract Add Pays ------0.00% 410017 - Stand By Pay 22.15 2,374.63 -2,374.63 3,500.00 1,125.37 67.85% 410022 - Park Board Stipend ----1,200.00 1,200.00 0.00% Total Salaries & Wages 476,086.72 5,239,077.98 - 5,239,077.98 6,573,570.00 1,334,492.02 79.70% Employee Benefits 411001 - FICA Regular 35,209.99 403,101.24 -403,101.24 506,363.00 103,261.76 79.61% 411004 - PERF Regular 35,829.72 418,405.74 -418,405.74 530,630.00 112,224.26 78.85% 411005 - PERF Union 1,239.01 15,427.61 -15,427.61 26,912.00 11,484.39 57.33% 411007 - Unemployment Comp 35.69 4,611.97 -4,611.97 7,520.00 2,908.03 61.33% 411008 - Health Insurance 88,520.98 871,622.94 -871,622.94 1,192,876.00 321,253.06 73.07% 411009 - Life Insurance 830.00 8,240.00 -8,240.00 10,560.00 2,320.00 78.03% 411014 - Parental Leave 1,182.20 12,976.83 -12,976.83 16,447.00 3,470.17 78.90% 411015 - Other Fringe Benefits -1,490.00 -1,490.00 1,500.00 10.00 99.33% 411201 - Tool Allowance 562.55 3,980.24 -3,980.24 4,800.00 819.76 82.92% 411203 - Job Readiness Allow.-14,875.00 -14,875.00 19,425.00 4,550.00 76.58% 411204 - Auto Allowance 266.66 2,666.60 -2,666.60 3,200.00 533.40 83.33% 411206 - Cell Phone Allowance 1,045.00 10,505.00 -10,505.00 12,820.00 2,315.00 81.94% Total Employee Benefits 164,721.80 1,767,903.17 - 1,767,903.17 2,333,053.00 565,149.83 75.78% Total Personnel Expenses 640,808.52 7,006,981.15 - 7,006,981.15 8,906,623.00 1,899,641.85 78.67% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,386.34 14,087.40 984.82 15,072.22 23,579.18 8,506.96 63.92% Total Office Supplies 1,386.34 14,087.40 984.82 15,072.22 23,579.18 8,506.96 63.92% Operating Supplies 422000 - Other Operating Supplies 17,629.60 271,739.38 34,298.28 306,037.66 309,104.02 3,066.36 99.01% 422001 - C.S. Gasoline 15,753.28 203,721.19 -203,721.19 165,000.00 (38,721.19)123.47% 422002 - Diesel/CNG 4,029.00 9,461.27 2,283.00 11,744.27 4,000.00 (7,744.27)293.61% 422003 - Gasoline 3,593.50 18,400.18 5,104.66 23,504.84 25,905.00 2,400.16 90.73% 422004 - Oil -35.30 -35.30 50.00 14.70 70.60% 422005 - Uniforms -8,498.93 1,614.25 10,113.18 19,695.00 9,581.82 51.35% 422006 - Computer Supplies & Equipment 54.99 439.81 -439.81 500.00 60.19 87.96% 422007 - Cleaning Supplies 71.50 4,115.02 -4,115.02 6,950.00 2,834.98 59.21% 422008 - Medical/Safety Supplies 1,934.88 14,912.12 -14,912.12 15,256.00 343.88 97.75% 422009 - Recreation Supplies 19,972.06 140,854.41 19,885.50 160,739.91 242,451.60 81,711.69 66.30% 422010 - Plants Chemicals Seed & Fertilizer 16,177.09 152,462.49 30,308.58 182,771.07 199,575.00 16,803.93 91.58% 422013 - Promotional Supplies -499.91 -499.91 -(499.91)0.00% 422014 - Concessions Inventory 14,771.19 150,329.43 3,362.67 153,692.10 87,505.00 (66,187.10)175.64% 422016 - Inventory For Sale 471.26 52,049.51 2,125.21 54,174.72 34,035.00 (20,139.72)159.17% Total Operating Supplies 94,458.35 1,027,518.95 98,982.15 1,126,501.10 1,110,026.62 (16,474.48) 101.48% Repair & Maintenance Supplies 423000 - Other R&M Supplies 17,314.70 210,120.66 29,286.77 239,407.43 225,965.04 (13,442.39)105.95% 423001 - Building Materials 744.80 60,712.22 2,658.00 63,370.22 81,000.00 17,629.78 78.23% 423006 - Small Tools & Equipment 1,688.95 22,547.06 -22,547.06 25,573.00 3,025.94 88.17% 423009 - Repair Parts 2,620.33 51,384.94 11,973.71 63,358.65 82,429.03 19,070.38 76.86% Total Repair & Maintenance Supplies 22,368.78 344,764.88 43,918.48 388,683.36 414,967.07 26,283.71 93.67% Total Supplies Expenses 118,213.47 1,386,371.23 143,885.45 1,530,256.68 1,548,572.87 18,316.19 98.82% Services & Charges Expenses Professional Services 431000 - Other Professional Services 9,172.87 122,314.56 66,172.50 188,487.06 179,177.00 (9,310.06)105.20% 431009 - Computer & Technology -31.83 -31.83 500.00 468.17 6.37% 431014 - Collection Costs -56.25 -56.25 100.00 43.75 56.25% 431015 - Laboratory Water Testing 250.00 250.00 -250.00 300.00 50.00 83.33% 431019 - Security Services 6,808.77 41,563.25 5,420.00 46,983.25 48,540.00 1,556.75 96.79% Total Professional Services 16,231.64 164,215.89 71,592.50 235,808.39 228,617.00 (7,191.39) 103.15% Communication & Transportation 432002 - Mailing 4.16 2,277.37 150.00 2,427.37 4,875.00 2,447.63 49.79% 432003 - Travel 4,392.58 14,230.85 9,225.63 23,456.48 28,637.00 5,180.52 81.91% 432004 - Telecommunications 233.92 1,711.26 2,913.80 4,625.06 8,366.80 3,741.74 55.28% 432005 - Mileage Reimb -628.96 469.96 1,098.92 2,375.00 1,276.08 46.27% Total Communication & Transportation 4,630.66 18,848.44 12,759.39 31,607.83 44,253.80 12,645.97 71.42% Printing & Advertising 433001 - Outside Printing Services -11,877.50 -11,877.50 18,480.00 6,602.50 64.27% 433002 - Publication of Legal Notice -996.10 1,111.30 2,107.40 2,200.00 92.60 95.79% 433003 - Promotional 47,293.45 335,946.66 70,466.32 406,412.98 391,117.06 (15,295.92)103.91% Total Printing & Advertising 47,293.45 348,820.26 71,577.62 420,397.88 411,797.06 (8,600.82) 102.09% Utilties 435001 - Electric 34,878.57 428,967.22 -428,967.22 452,847.00 23,879.78 94.73% 435002 - Natural Gas 4,021.68 149,908.33 -149,908.33 113,457.00 (36,451.33)132.13% 435004 - Water 24,599.93 229,643.70 -229,643.70 214,000.00 (15,643.70)107.31% Total Utilities 63,500.18 808,519.25 - 808,519.25 780,304.00 (28,215.25) 103.62% Repairs & Maintenance 436000 - Other R&M 3,474.92 42,203.70 12,481.97 54,685.67 54,251.53 (434.14)100.80% 436001 - Building R&M 1,783.96 180,668.16 71,623.21 252,291.37 261,331.82 9,040.45 96.54% 436002 - Office Equip R&M -28.88 -28.88 -(28.88)0.00% 436003 - Auto Equip R&M 23,925.75 274,798.59 -274,798.59 251,000.00 (23,798.59)109.48% 436005 - Other Equip R&M 108.00 1,943.91 2,444.10 4,388.01 5,800.00 1,411.99 75.66% 436006 - Radio Equip R&M 4,509.39 14,678.62 -14,678.62 10,500.00 (4,178.62)139.80% 436011 - Exterminating 703.00 4,119.00 3,543.00 7,662.00 8,334.00 672.00 91.94% Total Repairs & Maintenance 34,505.02 518,440.86 90,092.28 608,533.14 591,217.35 (17,315.79) 102.93% Rentals 437002 - Equipment Rental -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 - 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 62,033.24 584,760.52 47,642.70 632,403.22 662,752.29 30,349.07 95.42% 439001 - Other Contractual Services -9,103.49 11,000.00 20,103.49 20,200.00 96.51 99.52% 439002 - Licenses & Permits -12,574.77 -12,574.77 11,877.00 (697.77)105.87% 439003 - Subscriptions 90.95 3,771.81 -3,771.81 4,320.00 548.19 87.31% 439004 - Dues & Memberships 705.00 9,812.37 -9,812.37 14,930.00 5,117.63 65.72% 439005 - Bank & Credit Card Fees 4,578.86 80,230.26 -80,230.26 57,655.00 (22,575.26)139.16% 439006 - Education & Training 1,014.00 18,500.52 2,998.73 21,499.25 26,025.00 4,525.75 82.61% 439009 - Trash Removal 5,812.64 53,034.42 4,751.12 57,785.54 62,034.41 4,248.87 93.15% 439012 - Uniform Services -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 (59.99)812.94 -812.94 1,250.00 437.06 65.04% 439100 - Refunds/Awards/Indemnities 1,619.02 26,667.33 -26,667.33 26,285.00 (382.33)101.45% 439300 - Grants & Subsidies -715,000.00 -715,000.00 715,000.00 -100.00% Total Other Services & Charges 75,793.72 1,527,008.62 84,392.55 1,611,401.17 1,631,528.70 20,127.53 98.77% Total Services & Charges Expenses 241,954.67 3,747,191.29 330,414.34 4,077,605.63 4,117,539.91 39,934.28 99.03% Capital Outlay Buildings 443001 - Building Improvements -102,200.00 250.00 102,450.00 102,450.00 -100.00% Total Buildings - 102,200.00 250.00 102,450.00 102,450.00 - 100.00% 444000 - Land Improvements 85,386.81 335,818.19 791,743.48 1,127,561.67 1,294,470.49 166,908.82 87.11% Machinery & Equipment 445000 - Motor Equipment -10,866.95 -10,866.95 10,866.86 (0.09)100.00% 445003 - Park Equipment 14,420.00 112,116.26 138,161.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 271,257.83 513,394.53 1,290,000.00 776,605.47 39.80% Total Machinery & Equipment 14,420.00 382,127.03 409,419.07 791,546.10 2,023,655.36 1,232,109.26 39.11% Total Capital Expenses 99,806.81 820,145.22 1,201,412.55 2,021,557.77 3,420,575.85 1,399,018.08 59.10% Other Uses 452002 - Allocations-Admin Cost 61,510.58 615,105.84 -615,105.84 738,127.00 123,021.16 83.33% 452003 - Allocations-IT 57,450.84 574,508.32 -574,508.32 689,410.00 114,901.68 83.33% 452004 - Allocations-Liability Insurance 24,384.42 243,844.16 -243,844.16 292,613.00 48,768.84 83.33% 452008 - Allocations-Payroll Cost 6,895.25 68,952.50 -68,952.50 82,743.00 13,790.50 83.33% 452009 - Allocations-Facilities Mgmt 2,296.25 22,962.50 -22,962.50 27,555.00 4,592.50 83.33% Total Other Uses 152,537.34 1,525,373.32 - 1,525,373.32 1,830,448.00 305,074.68 83.33% 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,253,320.81 14,487,162.21 1,675,712.34 16,162,874.55 19,823,759.63 3,660,885.08 81.53%