Loading...
HomeMy WebLinkAboutNov 22 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 92% 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 52.50 347.50 250.00 (97.50)139.00% Charges for Services Culture & Recreation 347001 - Swimming Pool -35,588.78 40,213.00 4,624.22 88.50% 347002 - Picnic Site Rental -3,596.25 -(3,596.25)0.00% 347003 - Golf Season Pass 450.00 269,622.20 172,000.00 (97,622.20)156.76% 347004 - Golf Green Fees 20,636.00 852,695.32 805,000.00 (47,695.32)105.92% 347005 - Golf Cart Rentals 20,170.03 396,828.94 365,000.00 (31,828.94)108.72% 347006 - Golf Pro Shop Retail 3,767.20 74,150.11 59,500.00 (14,650.11)124.62% 347007 - Golf Driving Range 1,098.00 41,429.00 30,000.00 (11,429.00)138.10% 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,721.12 59,694.58 69,000.00 9,305.42 86.51% 347011 - Recreational Programming 4,539.20 391,713.80 523,565.00 131,851.20 74.82% 347012 - Food Sales 2,247.50 74,063.11 53,277.00 (20,786.11)139.02% 347013 - Nonalcoholic Beverage 1,040.89 40,576.03 31,500.00 (9,076.03)128.81% 347014 - Alcoholic Beverage Sales 4,944.05 155,131.44 110,900.00 (44,231.44)139.88% 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 37,469.82 250,879.20 300,000.00 49,120.80 83.63% 347019 - Site Mowing -117,974.10 222,839.00 104,864.90 52.94% 347021 - Tree Maintenance 1,038.49 148,208.77 120,000.00 (28,208.77)123.51% 347023 - Graffiti Removal -4,930.26 -(4,930.26)0.00% 347026 - Room Rental 7,394.49 108,493.82 56,000.00 (52,493.82)193.74% 347030 - Merch Sales 401.75 3,523.32 -(3,523.32)0.00% 347040 - Pavilion Rental 537.60 32,448.23 15,000.00 (17,448.23)216.32% 347100 - Concessions-Employee Discounts (84.62)(1,909.84)-1,909.84 0.00% Total Culture & Recreation 107,371.52 3,199,984.48 3,108,794.00 (91,190.48) 102.93% Total Charges for Services 107,371.52 3,199,984.48 3,108,794.00 (91,190.48) 102.93% 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 193.20 9,340.27 9,500.00 159.73 98.32% 360001 - Sale of Scrap Metal 81.25 1,110.07 -(1,110.07)0.00% 360011 - Settlement Fees -80,000.00 -(80,000.00)0.00% 361000 - Interest Earnings 1,977.58 38,911.39 15,000.00 (23,911.39)259.41% 362000 - Rental of Property 100.00 61,603.25 60,000.00 (1,603.25)102.67% 367000 - Donations from Private Sources 100.00 640,928.93 1,061,000.00 420,071.07 60.41% Total Miscellaneous Revenue 2,452.03 831,893.91 1,145,500.00 313,606.09 72.62% Refunds & Reimbursements 380000 - Misc Reimbursements 61.00 18,976.62 18,253.00 (723.62)103.96% 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 475.00 48,159.33 43,284.00 (4,875.33)111.26% Total Refunds & Reimbursements 536.00 72,861.33 307,787.00 234,925.67 23.67% Other Sources 391000 - Interfund Transfers In -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% November 30, 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 - 1,454,809.00 1,409,221.00 (45,588.00) 103.23% Total Revenue 110,412.05 11,788,419.29 17,505,813.00 5,717,393.71 67.34% 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 217,119.46 2,600,797.68 -2,600,797.68 3,049,049.00 448,251.32 85.30% 410002 - Teamster Wages 105,997.28 1,315,519.15 -1,315,519.15 1,542,175.00 226,655.85 85.30% 410003 - Permanent Part Time 77,717.96 926,176.91 -926,176.91 1,038,670.00 112,493.09 89.17% 410004 - Extra & Overtime 4,790.05 127,899.88 -127,899.88 95,975.00 (31,924.88)133.26% 410005 - Seasonal & Interns 33,179.32 698,580.48 -698,580.48 834,551.00 135,970.52 83.71% 410007 - Longevity Pay 350.00 6,883.32 -6,883.32 8,450.00 1,566.68 81.46% 410014 - Contract Add Pays ------0.00% 410017 - Stand By Pay -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 439,154.07 5,678,232.05 - 5,678,232.05 6,573,570.00 895,337.95 86.38% Employee Benefits 411001 - FICA Regular 32,365.84 435,467.08 -435,467.08 506,363.00 70,895.92 86.00% 411004 - PERF Regular 36,653.43 455,059.17 -455,059.17 530,630.00 75,570.83 85.76% 411005 - PERF Union 1,127.98 16,555.59 -16,555.59 26,912.00 10,356.41 61.52% 411007 - Unemployment Comp 34.46 4,646.43 -4,646.43 7,520.00 2,873.57 61.79% 411008 - Health Insurance 89,594.18 961,217.12 -961,217.12 1,192,876.00 231,658.88 80.58% 411009 - Life Insurance 835.00 9,075.00 -9,075.00 10,560.00 1,485.00 85.94% 411014 - Parental Leave 1,145.97 14,122.80 -14,122.80 16,447.00 2,324.20 85.87% 411015 - Other Fringe Benefits -1,490.00 -1,490.00 1,500.00 10.00 99.33% 411200 - Clothing Allowance --90.91 90.91 -(90.91)0.00% 411201 - Tool Allowance -3,980.24 500.00 4,480.24 5,281.00 800.76 84.84% 411203 - Job Readiness Allow.-14,875.00 197.94 15,072.94 18,944.00 3,871.06 79.57% 411204 - Auto Allowance 266.66 2,933.26 -2,933.26 3,200.00 266.74 91.66% 411206 - Cell Phone Allowance 1,045.00 11,550.00 -11,550.00 12,820.00 1,270.00 90.09% Total Employee Benefits 163,068.52 1,930,971.69 788.85 1,931,760.54 2,333,053.00 401,292.46 82.80% Total Personnel Expenses 602,222.59 7,609,203.74 788.85 7,609,992.59 8,906,623.00 1,296,630.41 85.44% Supplies Expenses Office Supplies 421000 - General Office Supplies 2,334.72 16,422.12 1,018.68 17,440.80 23,579.18 6,138.38 73.97% Total Office Supplies 2,334.72 16,422.12 1,018.68 17,440.80 23,579.18 6,138.38 73.97% Operating Supplies 422000 - Other Operating Supplies 19,226.24 291,137.54 22,172.85 313,310.39 317,865.02 4,554.63 98.57% 422001 - C.S. Gasoline 16,567.32 220,288.51 -220,288.51 165,000.00 (55,288.51)133.51% 422002 - Diesel/CNG 2,303.18 11,764.45 2,349.00 14,113.45 4,000.00 (10,113.45)352.84% 422003 - Gasoline 4,548.25 22,948.43 1,861.10 24,809.53 25,905.00 1,095.47 95.77% 422004 - Oil -35.30 -35.30 50.00 14.70 70.60% 422005 - Uniforms 595.04 9,093.97 5,461.25 14,555.22 20,234.00 5,678.78 71.93% 422006 - Computer Supplies & Equipment 745.78 1,185.59 -1,185.59 500.00 (685.59)237.12% 422007 - Cleaning Supplies -4,115.02 -4,115.02 6,411.00 2,295.98 64.19% 422008 - Medical/Safety Supplies 1,112.21 16,024.33 -16,024.33 15,256.00 (768.33)105.04% 422009 - Recreation Supplies 6,530.39 147,384.80 20,417.18 167,801.98 245,822.60 78,020.62 68.26% 422010 - Plants Chemicals Seed & Fertilizer 5,334.94 157,797.43 25,199.01 182,996.44 199,575.00 16,578.56 91.69% 422013 - Promotional Supplies 2,073.84 2,573.75 -2,573.75 -(2,573.75)0.00% 422014 - Concessions Inventory 4,047.24 154,480.84 1,387.32 155,868.16 87,505.00 (68,363.16)178.12% 422016 - Inventory For Sale 1,268.11 53,317.62 6,621.21 59,938.83 34,035.00 (25,903.83)176.11% Total Operating Supplies 64,352.54 1,092,147.58 85,468.92 1,177,616.50 1,122,158.62 (55,457.88) 104.94% Repair & Maintenance Supplies 423000 - Other R&M Supplies 14,197.09 224,898.65 22,035.43 246,934.08 225,965.04 (20,969.04)109.28% 423001 - Building Materials 2,986.81 63,699.03 669.45 64,368.48 68,868.00 4,499.52 93.47% 423006 - Small Tools & Equipment 1,942.84 24,530.60 231.99 24,762.59 25,573.00 810.41 96.83% 423009 - Repair Parts 8,575.84 59,960.78 10,015.61 69,976.39 82,429.03 12,452.64 84.89% Total Repair & Maintenance Supplies 27,702.58 373,089.06 32,952.48 406,041.54 402,835.07 (3,206.47) 100.80% Total Supplies Expenses 94,389.84 1,481,658.76 119,440.08 1,601,098.84 1,548,572.87 (52,525.97) 103.39% Services & Charges Expenses Professional Services 431000 - Other Professional Services 21,338.24 143,652.80 59,789.96 203,442.76 179,177.00 (24,265.76)113.54% 431009 - Computer & Technology -31.83 7,750.00 7,781.83 500.00 (7,281.83)1556.37% 431014 - Collection Costs 6.25 62.50 -62.50 100.00 37.50 62.50% 431015 - Laboratory Water Testing -250.00 -250.00 300.00 50.00 83.33% 431019 - Security Services 4,048.77 45,612.02 1,856.00 47,468.02 48,540.00 1,071.98 97.79% Total Professional Services 25,393.26 189,609.15 69,395.96 259,005.11 228,617.00 (30,388.11) 113.29% Communication & Transportation 432002 - Mailing -2,277.37 188.24 2,465.61 4,875.00 2,409.39 50.58% 432003 - Travel 2,265.23 16,496.08 9,367.72 25,863.80 28,637.00 2,773.20 90.32% 432004 - Telecommunications -1,711.26 2,913.80 4,625.06 8,366.80 3,741.74 55.28% 432005 - Mileage Reimb 245.70 874.66 176.96 1,051.62 2,130.00 1,078.38 49.37% Total Communication & Transportation 2,510.93 21,359.37 12,646.72 34,006.09 44,008.80 10,002.71 77.27% Printing & Advertising 433001 - Outside Printing Services -11,877.50 -11,877.50 15,498.00 3,620.50 76.64% 433002 - Publication of Legal Notice -996.10 1,611.30 2,607.40 2,200.00 (407.40)118.52% 433003 - Promotional 51,062.25 387,008.91 23,404.25 410,413.16 391,117.06 (19,296.10)104.93% Total Printing & Advertising 51,062.25 399,882.51 25,015.55 424,898.06 408,815.06 (16,083.00) 103.93% Utilties 435001 - Electric 36,332.36 465,299.58 -465,299.58 452,847.00 (12,452.58)102.75% 435002 - Natural Gas 12,616.90 162,525.23 -162,525.23 113,457.00 (49,068.23)143.25% 435004 - Water 9,050.10 238,693.80 -238,693.80 214,000.00 (24,693.80)111.54% Total Utilities 57,999.36 866,518.61 - 866,518.61 780,304.00 (86,214.61) 111.05% Repairs & Maintenance 436000 - Other R&M 2,013.17 44,216.87 11,956.97 56,173.84 54,251.53 (1,922.31)103.54% 436001 - Building R&M 13,018.02 193,686.18 68,281.60 261,967.78 262,031.82 64.04 99.98% 436002 - Office Equip R&M -28.88 -28.88 -(28.88)0.00% 436003 - Auto Equip R&M 21,421.12 296,219.71 -296,219.71 251,000.00 (45,219.71)118.02% 436005 - Other Equip R&M -1,943.91 2,992.10 4,936.01 5,800.00 863.99 85.10% 436006 - Radio Equip R&M 1,418.76 16,097.38 -16,097.38 10,500.00 (5,597.38)153.31% 436011 - Exterminating 613.00 4,732.00 2,930.00 7,662.00 8,334.00 672.00 91.94% Total Repairs & Maintenance 38,484.07 556,924.93 86,160.67 643,085.60 591,917.35 (51,168.25) 108.64% Rentals 437002 - Equipment Rental 1,948.97 11,298.80 -11,298.80 600.00 (10,698.80)1883.13% 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 1,948.97 24,498.80 - 24,498.80 13,800.00 (10,698.80) 177.53% Debt Service 438100 - Principal 63,110.77 379,953.65 -379,953.65 387,682.81 7,729.16 98.01% 438200 - Interest 1,601.56 19,146.82 -19,146.82 23,339.19 4,192.37 82.04% 438300 - Paying Agent Fees -4,400.00 -4,400.00 5,000.00 600.00 88.00% Total Debt Service 64,712.33 403,500.47 - 403,500.47 416,022.00 12,521.53 96.99% Other Charges & Services 439000 - Misc Charges & Svcs 11,817.10 596,577.62 52,712.75 649,290.37 669,357.29 20,066.92 97.00% 439001 - Other Contractual Services 5,949.00 15,052.49 3,500.00 18,552.49 20,200.00 1,647.51 91.84% 439002 - Licenses & Permits -12,574.77 2,000.00 14,574.77 11,877.00 (2,697.77)122.71% 439003 - Subscriptions 156.99 3,928.80 -3,928.80 4,320.00 391.20 90.94% 439004 - Dues & Memberships 753.40 10,565.77 -10,565.77 14,230.00 3,664.23 74.25% 439005 - Bank & Credit Card Fees 3,961.79 84,199.10 -84,199.10 57,655.00 (26,544.10)146.04% 439006 - Education & Training 387.64 18,888.16 6,495.45 25,383.61 24,879.00 (504.61)102.03% 439009 - Trash Removal 488.54 53,522.96 8,566.83 62,089.79 62,034.41 (55.38)100.09% 439012 - Uniform Services 1,541.87 14,282.06 -14,282.06 11,200.00 (3,082.06)127.52% 439018 - Demolition & Clearance --18,000.00 18,000.00 18,000.00 -100.00% 439099 - Cashier Over/Short (269.59)543.35 -543.35 1,250.00 706.65 43.47% 439100 - Refunds/Awards/Indemnities 1,603.30 28,323.45 -28,323.45 24,053.00 (4,270.45)117.75% 439300 - Grants & Subsidies -715,000.00 -715,000.00 715,000.00 -100.00% Total Other Services & Charges 26,390.04 1,553,458.53 91,275.03 1,644,733.56 1,634,055.70 (10,677.86) 100.65% Total Services & Charges Expenses 268,501.21 4,015,752.37 284,493.93 4,300,246.30 4,117,539.91 (182,706.39) 104.44% 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 47,711.28 383,529.47 766,886.28 1,150,415.75 1,294,470.49 144,054.74 88.87% Machinery & Equipment 445000 - Motor Equipment -10,866.95 -10,866.95 10,866.86 (0.09)100.00% 445003 - Park Equipment 29,116.24 141,232.50 109,045.00 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% 445008 - Other Equipment --29,121.03 29,121.03 -(29,121.03)0.00% 445100 - Lease Purchase/Motor Equip -242,136.70 460,253.83 702,390.53 1,290,000.00 587,609.47 54.45% Total Machinery & Equipment 29,116.24 411,243.27 598,419.86 1,009,663.13 2,023,655.36 1,013,992.23 49.89% Total Capital Expenses 76,827.52 896,972.74 1,365,556.14 2,262,528.88 3,420,575.85 1,158,046.97 66.14% Other Uses 452002 - Allocations-Admin Cost -615,105.84 -615,105.84 738,127.00 123,021.16 83.33% 452003 - Allocations-IT -574,508.32 -574,508.32 689,410.00 114,901.68 83.33% 452004 - Allocations-Liability Insurance -243,844.16 -243,844.16 292,613.00 48,768.84 83.33% 452008 - Allocations-Payroll Cost -68,952.50 -68,952.50 82,743.00 13,790.50 83.33% 452009 - Allocations-Facilities Mgmt -22,962.50 -22,962.50 27,555.00 4,592.50 83.33% Total Other Uses - 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,041,941.16 15,530,060.93 1,770,279.00 17,300,339.93 19,823,759.63 2,523,419.70 87.27%