Loading...
HomeMy WebLinkAboutNov 21 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,705,124.46 9,247,389.00 3,542,264.54 61.69% Total Property Taxes - 5,705,124.46 9,247,389.00 3,542,264.54 61.69% Total Taxes - 5,705,124.46 9,247,389.00 3,542,264.54 61.69% State Shared Revenue 335002 - Vehicle/Aircraft Excise - 376,063.14 752,272.00 376,208.86 49.99% 335007 - Commercial Vehicle Excise - 85,147.87 154,422.00 69,274.13 55.14% Total State Shared Revenue - 461,211.01 906,694.00 445,482.99 50.87% Total Intergovernmental Revenue - 661,211.01 1,106,694.00 445,482.99 59.75% Total Nonbusiness Licenses & Permits 26.25 200.50 58.00 (142.50) 345.69% Total Licenses & Permits 26.25 200.50 58.00 (142.50) 345.69% Charges for Services Culture & Recreation 347001 - Swimming Pool - 56,410.07 20,000.00 (36,410.07) 282.05% 347002 - Picnic Site Rental - 5,999.45 3,300.00 (2,699.45) 181.80% 347003 - Golf Season Pass - 218,202.77 93,000.00 (125,202.77) 234.63% 347004 - Golf Green Fees 13,148.00 784,700.10 795,000.00 10,299.90 98.70% 347005 - Golf Cart Rentals 6,892.43 382,415.82 360,000.00 (22,415.82) 106.23% 347006 - Golf Pro Shop Retail 1,715.53 74,481.58 59,500.00 (14,981.58) 125.18% 347007 - Golf Driving Range 378.00 33,649.97 30,000.00 (3,649.97) 112.17% 347008 - Golf Gift Certificate - 5.00 - (5.00) 0.00% 347010 - Concession Sales 1,880.47 54,694.23 31,000.00 (23,694.23) 176.43% 347011 - Recreational Programming 41,371.12 366,238.06 361,500.00 (4,738.06) 101.31% 347012 - Food Sales 935.71 67,026.68 53,277.00 (13,749.68) 125.81% 347013 - Nonalcoholic Beverage 509.88 40,712.37 33,398.00 (7,314.37) 121.90% 347014 - Alcoholic Beverage Sales 3,601.84 148,092.24 110,000.00 (38,092.24) 134.63% 347015 - Lease of Stadium (15,000.00) 100,000.00 75,000.00 (25,000.00) 133.33% 347016 - East Race Waterway - 51,900.42 55,000.00 3,099.58 94.36% 347017 - Ice Skating - 162,898.30 300,000.00 137,101.70 54.30% 347018 - Skate Rental - - - - 0.00% 347019 - Site Mowing - 1,227.59 95,000.00 93,772.41 1.29% 347021 - Tree Maintenance 1,858.02 99,615.78 120,000.00 20,384.22 83.01% 347023 - Graffiti Removal - 1,482.15 102,529.00 101,046.85 1.45% 347026 - Room Rental 6,081.90 63,287.11 9,000.00 (54,287.11) 703.19% 347030 - Merch Sales 391.23 2,164.82 2,500.00 335.18 86.59% 347040 - Pavilion Rental 285.64 32,847.76 22,446.00 (10,401.76) 146.34% 347050 - Ice Rink Gift Cards - 3,887.95 - (3,887.95) 0.00% 347051 - Park Reservations - 100.00 - (100.00) 0.00% 347100 - Concessions-Employee Discounts (154.05) (3,528.54) - 3,528.54 0.00% 347101 - Room Rental-Employee Discounts - (71.46) - 71.46 0.00% Total Culture & Recreation 63,895.72 2,748,440.22 2,731,450.00 (16,990.22) 100.62% Total Charges for Services 63,895.72 2,748,440.22 2,731,450.00 (16,990.22) 100.62% Fines, Forefeitures, Fees 351002 - Bad Checks Fines - 12.00 - (12.00) 0.00% Total Fines, Forfeitures, Fees - 12.00 - (12.00) 0.00% Miscellaneous Revenue 360000 - Miscellaneous 57.96 3,843.68 25,000.00 21,156.32 15.37% 360001 - Sale of Scrap Metal 128.58 1,145.56 - (1,145.56) 0.00% 361000 - Interest Earnings 412.40 20,219.33 40,000.00 19,780.67 50.55% 362000 - Rental of Property 5,414.75 68,740.75 60,000.00 (8,740.75) 114.57% 367000 - Donations from Private Sources 370.00 852,899.00 1,805,000.00 952,101.00 47.25% Total Miscellaneous Revenue 6,383.69 946,848.32 1,930,000.00 983,151.68 49.06% Refunds & Reimbursements 380000 - Misc Reimbursements 4.00 27,952.74 38,572.00 10,619.26 72.47% 380007 - Energy Rebates - 962.27 - (962.27) 0.00% 396000 - Refunds 13.61 6,301.52 5,267.00 (1,034.52) 119.64% November 30, 2021 Total Refunds & Reimbursements 17.61 35,216.53 43,839.00 8,622.47 80.33% Other Sources 391000 - Interfund Transfers In 102,711.00 1,129,830.00 1,234,486.00 104,656.00 91.52% 392000 - Gain/Loss on Sale of Asset - 17,250.00 - (17,250.00) 0.00% Total Other Sources 102,711.00 1,147,080.00 1,234,486.00 87,406.00 92.92% Total Revenue 173,034.27 11,244,133.04 16,293,916.00 5,049,782.96 69.01% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 214,904.53 2,604,475.97 - 2,604,475.97 2,764,868.00 160,392.03 94.20% 410002 - Teamster Wages 106,814.01 1,327,426.22 - 1,327,426.22 1,397,385.00 69,958.78 94.99% 410003 - Permanent Part Time 48,455.63 681,040.62 - 681,040.62 731,960.00 50,919.38 93.04% 410004 - Extra & Overtime 4,119.09 105,618.13 - 105,618.13 123,241.00 17,622.87 85.70% 410005 - Seasonal & Interns 27,247.73 668,905.89 - 668,905.89 760,125.00 91,219.11 88.00% 410007 - Longevity Pay 350.00 8,050.00 - 8,050.00 11,050.00 3,000.00 72.85% 410014 - Contract Add Pays - 955.98 - 955.98 4,000.00 3,044.02 23.90% 410022 - Park Board Stipend - - - - 1,200.00 1,200.00 0.00% Total Salaries & Wages 401,890.99 5,396,472.81 - 5,396,472.81 5,793,829.00 397,356.19 93.14% Employee Benefits 411001 - FICA Regular 29,555.86 403,935.99 - 403,935.99 453,706.00 49,770.01 89.03% 411004 - PERF Regular 35,164.80 444,057.74 - 444,057.74 496,040.00 51,982.26 89.52% 411005 - PERF Union 1,294.81 17,045.00 - 17,045.00 21,366.00 4,321.00 79.78% 411007 - Unemployment Comp 102.00 1,259.13 - 1,259.13 1,550.00 290.87 81.23% 411008 - Health Insurance 82,543.99 957,844.66 - 957,844.66 1,013,916.00 56,071.34 94.47% 411009 - Life Insurance 815.00 9,455.00 - 9,455.00 10,945.00 1,490.00 86.39% 411014 - Parental Leave 1,120.12 14,104.20 - 14,104.20 16,267.00 2,162.80 86.70% 411015 - Other Fringe Benefits - 1,600.00 - 1,600.00 1,600.00 - 100.00% 411201 - Tool Allowance 1,600.00 4,095.53 25.21 4,120.74 4,875.00 754.26 84.53% 411203 - Job Readiness Allow. - 15,300.00 - 15,300.00 15,300.00 - 100.00% 411204 - Auto Allowance 266.66 2,933.26 - 2,933.26 3,200.00 266.74 91.66% 411206 - Cell Phone Allowance 1,100.00 12,815.00 - 12,815.00 15,850.00 3,035.00 80.85% Total Employee Benefits 153,563.24 1,884,445.51 25.21 1,884,470.72 2,054,615.00 170,144.28 91.72% Total Personnel Expenditures 555,454.23 7,280,918.32 25.21 7,280,943.53 7,848,444.00 567,500.47 92.77% Supplies Expenditures Office Supplies 421000 - General Office Supplies 496.13 6,495.23 - 6,495.23 7,616.89 1,121.66 85.27% 421002 - Stationary & Printing 1,265.51 10,702.55 248.33 10,950.88 23,535.00 12,584.12 46.53% Total Office Supplies 1,761.64 17,197.78 248.33 17,446.11 31,151.89 13,705.78 56.00% Operating Supplies 422000 - Other Operating Supplies 18,212.74 310,319.43 19,285.72 329,605.15 367,296.78 37,691.63 89.74% 422001 - C.S. Gasoline 13,295.36 149,458.57 - 149,458.57 150,271.00 812.43 99.46% 422002 - Diesel/CNG 1,341.78 11,036.84 1,500.00 12,536.84 12,597.00 60.16 99.52% 422003 - Gasoline 1,260.00 9,696.88 4,200.00 13,896.88 14,511.00 614.12 95.77% 422005 - Uniforms 1,087.29 6,412.35 2,233.98 8,646.33 14,028.00 5,381.67 61.64% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 2,520.00 2,200.07 12.70% 422007 - Cleaning Supplies 68.18 1,317.82 - 1,317.82 1,433.00 115.18 91.96% 422008 - Medical/Safety Supplies 1,137.13 19,810.20 - 19,810.20 23,747.19 3,936.99 83.42% 422009 - Recreation Supplies 18,385.69 171,464.22 6,330.35 177,794.57 263,659.82 85,865.25 67.43% 422010 - Plants Chemicals Seed & Fertilizer 10,618.63 127,003.98 5,525.48 132,529.46 120,828.77 (11,700.69) 109.68% 422013 - Promotional Supplies 17.49 3,745.88 - 3,745.88 6,629.00 2,883.12 56.51% 422014 - Concessions Inventory 541.46 110,870.58 828.10 111,698.68 89,388.00 (22,310.68) 124.96% 422016 - Inventory For Sale 127.31 40,843.62 335.00 41,178.62 44,205.00 3,026.38 93.15% Total Operating Supplies 66,093.06 962,300.30 40,238.63 1,002,538.93 1,111,114.56 108,575.63 90.23% Repair & Maintenance Supplies 423000 - Other R&M Supplies 9,176.86 151,745.50 17,483.10 169,228.60 243,191.86 73,963.26 69.59% 423001 - Building Materials 12,637.75 40,499.01 - 40,499.01 49,997.51 9,498.50 81.00% 423006 - Small Tools & Equipment 2,268.73 60,741.80 - 60,741.80 61,946.00 1,204.20 98.06% 423009 - Repair Parts 4,792.71 59,099.29 8,479.37 67,578.66 77,913.53 10,334.87 86.74% Total Repair & Maintenance Supplies 28,876.05 312,085.60 25,962.47 338,048.07 433,048.90 95,000.83 78.06% Total Supplies Expenditures 96,730.75 1,291,583.68 66,449.43 1,358,033.11 1,575,315.35 217,282.24 86.21% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 5,246.46 86,020.56 4,809.00 90,829.56 134,758.96 43,929.40 67.40% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431009 - Computer & Technology - 243.96 - 243.96 300.00 56.04 81.32% 431014 - Collection Costs 106.25 106.25 - 106.25 107.00 0.75 99.30% 431015 - Laboratory Water Testing 52.48 227.48 - 227.48 275.00 47.52 82.72% 431019 - Security Services 440.95 22,421.96 - 22,421.96 24,318.00 1,896.04 92.20% Total Professional Services 5,846.14 109,215.21 4,809.00 114,024.21 159,953.96 45,929.75 71.29% Communication & Transportation 432002 - Mailing 35.83 911.86 - 911.86 4,433.00 3,521.14 20.57% 432003 - Travel 957.70 4,686.77 1,495.61 6,182.38 20,491.00 14,308.62 30.17% 432004 - Telecommunications 190.80 2,947.30 2,747.70 5,695.00 6,395.81 700.81 89.04% 432005 - Mileage Reimb - 191.52 - 191.52 6,519.00 6,327.48 2.94% Total Communication & Transportation 1,184.33 8,737.45 4,243.31 12,980.76 37,838.81 24,858.05 34.31% Printing & Advertising 433001 - Outside Printing Services 255.00 9,750.30 1,080.00 10,830.30 22,756.00 11,925.70 47.59% 433002 - Publication of Legal Notice - 945.94 226.80 1,172.74 1,577.74 405.00 74.33% 433003 - Promotional 4,701.95 138,896.22 7,839.42 146,735.64 226,668.90 79,933.26 64.74% Total Printing & Advertising 4,956.95 149,592.46 9,146.22 158,738.68 251,002.64 92,263.96 63.24% Utilties 435001 - Electric 38,892.67 464,357.59 - 464,357.59 361,394.00 (102,963.59) 128.49% 435002 - Natural Gas 9,685.98 131,594.30 - 131,594.30 124,382.00 (7,212.30) 105.80% 435004 - Water 15,284.89 274,405.58 - 274,405.58 233,000.00 (41,405.58) 117.77% Total Utilities 63,863.54 870,357.47 - 870,357.47 718,776.00 (151,581.47) 121.09% Repairs & Maintenance 436000 - Other R&M 971.69 65,096.03 32,725.93 97,821.96 131,695.12 33,873.16 74.28% 436001 - Building R&M 1,235.95 108,008.28 26,075.28 134,083.56 133,228.44 (855.12) 100.64% 436003 - Auto Equip R&M 38,245.08 382,957.66 408.00 383,365.66 265,381.00 (117,984.66) 144.46% 436005 - Other Equip R&M - 762.07 - 762.07 659.00 (103.07) 115.64% 436006 - Radio Equip R&M 2,775.22 13,008.82 - 13,008.82 10,772.00 (2,236.82) 120.77% 436011 - Exterminating 598.00 8,871.64 4,226.00 13,097.64 16,139.00 3,041.36 81.16% Total Repairs & Maintenance 43,825.94 578,704.50 63,435.21 642,139.71 557,874.56 (84,265.15) 115.10% Rentals 437002 - Equipment Rental - 556.00 - 556.00 150.00 (406.00) 370.67% 437005 - Parking Space Rental - 12,000.00 - 12,000.00 12,000.00 - 100.00% 437006 - Recreation Space Rental - 1,200.00 700.00 1,900.00 1,900.00 - 100.00% Total Rentals - 13,756.00 700.00 14,456.00 14,050.00 (406.00) 102.89% Debt Service 438100 - Principal 61,282.75 452,897.72 - 452,897.72 461,923.00 9,025.28 98.05% 438200 - Interest 3,429.58 26,619.80 - 26,619.80 32,286.00 5,666.20 82.45% 438300 - Paying Agent Fees - 4,400.00 - 4,400.00 5,000.00 600.00 88.00% Total Debt Service 64,712.33 483,917.52 - 483,917.52 499,209.00 15,291.48 96.94% Other Charges & Services 439000 - Misc Charges & Svcs 22,909.11 346,007.50 86,835.91 432,843.41 435,406.80 2,563.39 99.41% 439001 - Other Contractual Services 3,048.00 11,846.08 - 11,846.08 36,402.26 24,556.18 32.54% 439002 - Licenses & Permits - 8,820.57 - 8,820.57 11,146.00 2,325.43 79.14% 439003 - Subscriptions 42.89 3,377.44 - 3,377.44 3,716.00 338.56 90.89% 439004 - Dues & Memberships 275.00 4,966.15 - 4,966.15 10,872.00 5,905.85 45.68% 439005 - Bank & Credit Card Fees 4,216.63 70,959.56 - 70,959.56 81,897.00 10,937.44 86.64% 439006 - Education & Training 2,972.60 15,107.74 419.03 15,526.77 24,873.00 9,346.23 62.42% 439009 - Trash Removal 568.84 31,333.40 7,906.67 39,240.07 50,138.18 10,898.11 78.26% 439012 - Uniform Services 1,743.52 9,376.11 - 9,376.11 11,196.00 1,819.89 83.75% 439099 - Cashier Over/Short (10.24) 2,946.67 - 2,946.67 4,015.00 1,068.33 73.39% 439100 - Refunds/Awards/Indemnities 1,103.44 20,720.46 - 20,720.46 31,976.00 11,255.54 64.80% 439300 - Grants & Subsidies - 715,000.00 - 715,000.00 715,000.00 - 100.00% 439999 - Bad Debt Expense - - - - - - 0.00% Total Other Services & Charges 36,869.79 1,240,461.68 95,161.61 1,335,623.29 1,416,638.24 81,014.95 94.28% Total Services & Charges Expenditures 221,259.02 3,454,742.29 177,495.35 3,632,237.64 3,655,343.21 23,105.57 99.37% Capital Outlay Buildings 443001 - Building Improvements - 68,352.12 5,097.88 73,450.00 74,000.00 550.00 99.26% Total Buildings - 68,352.12 5,097.88 73,450.00 74,000.00 550.00 99.26% 444000 - Land Improvements 36,649.57 274,078.37 365,885.32 639,963.69 1,591,285.91 951,322.22 40.22% Machinery & Equipment 445000 - Motor Equipment - - 10,866.86 10,866.86 10,867.00 0.14 100.00% 445003 - Park Equipment - 13,972.50 108,002.34 121,974.84 400,000.00 278,025.16 30.49% Total Machinery & Equipment - 13,972.50 118,869.20 132,841.70 410,867.00 278,025.30 32.33% Total Capital Expenditures 36,649.57 356,402.99 489,852.40 846,255.39 2,076,152.91 1,229,897.52 40.76% Other Uses 452002 - Allocations-Admin Cost 57,573.00 633,304.00 - 633,304.00 690,877.00 57,573.00 91.67% 452003 - Allocations-IT 54,596.00 600,553.00 - 600,553.00 655,149.00 54,596.00 91.67% 452004 - Allocations-Liability Insurance 18,500.00 203,488.00 - 203,488.00 221,988.00 18,500.00 91.67% 452008 - Allocations-Payroll Cost 6,680.00 73,476.00 - 73,476.00 80,156.00 6,680.00 91.67% 452009 - Allocations-Facilities Mgmt 1,654.00 18,191.00 - 18,191.00 19,845.00 1,654.00 91.67% Total Other Uses 139,003.00 1,529,012.00 - 1,529,012.00 1,668,015.00 139,003.00 91.67% Total Expenditures 1,049,096.57 13,912,659.28 733,822.39 14,646,481.67 16,823,270.47 2,176,788.80 87.06%