Loading...
HomeMy WebLinkAboutAug 22 Fin 1South Bend Venues, Parks and Arts Percentage of Year Completed: 67% 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 26.25 212.50 250.00 37.50 85.00% Charges for Services Culture & Recreation 347001 - Swimming Pool 6,119.90 35,254.16 40,213.00 4,958.84 87.67% 347002 - Picnic Site Rental 505.20 3,451.84 -(3,451.84)0.00% 347003 - Golf Season Pass 678.00 269,172.20 172,000.00 (97,172.20)156.50% 347004 - Golf Green Fees 180,559.23 651,986.26 805,000.00 153,013.74 80.99% 347005 - Golf Cart Rentals 82,890.99 294,308.39 365,000.00 70,691.61 80.63% 347006 - Golf Pro Shop Retail 14,375.59 57,251.02 59,500.00 2,248.98 96.22% 347007 - Golf Driving Range 7,806.00 32,636.00 30,000.00 (2,636.00)108.79% 347008 - Golf Gift Certificate -35.00 -(35.00)0.00% 347009 - Golf Outings 981.15 7,808.89 -(7,808.89)0.00% 347010 - Concession Sales 13,965.13 53,937.18 69,000.00 15,062.82 78.17% 347011 - Recreational Programming 33,837.88 351,169.86 523,565.00 172,395.14 67.07% 347012 - Food Sales 14,763.43 53,449.45 53,277.00 (172.45)100.32% 347013 - Nonalcoholic Beverage 9,041.10 31,761.91 31,500.00 (261.91)100.83% 347014 - Alcoholic Beverage Sales 29,677.91 116,536.71 110,900.00 (5,636.71)105.08% 347015 - Lease of Stadium 15,000.00 60,000.00 75,000.00 15,000.00 80.00% 347016 - East Race Waterway 18,373.12 55,020.97 60,000.00 4,979.03 91.70% 347017 - Ice Skating -197,057.38 300,000.00 102,942.62 65.69% 347019 - Site Mowing 117,974.10 117,974.10 222,839.00 104,864.90 52.94% 347021 - Tree Maintenance 1,136.19 115,402.57 120,000.00 4,597.43 96.17% 347023 - Graffiti Removal 4,930.26 4,930.26 -(4,930.26)0.00% 347026 - Room Rental 9,506.40 84,079.05 56,000.00 (28,079.05)150.14% 347030 - Merch Sales 246.76 1,845.74 -(1,845.74)0.00% 347040 - Pavilion Rental 4,408.76 29,580.51 15,000.00 (14,580.51)197.20% 347100 - Concessions-Employee Discounts (324.70)(1,425.64)-1,425.64 0.00% Total Culture & Recreation 566,452.40 2,623,223.81 3,108,794.00 485,570.19 84.38% Total Charges for Services 566,452.40 2,623,223.81 3,108,794.00 485,570.19 84.38% Fines, Forefeitures, Fees 351002 - Bad Checks Fines 24.00 24.00 -(24.00)0.00% Total Fines, Forfeitures, Fees 24.00 24.00 - (24.00) 0.00% Miscellaneous Revenue 360000 - Miscellaneous 355.52 8,404.34 9,500.00 1,095.66 88.47% 360001 - Sale of Scrap Metal -846.32 -(846.32)0.00% 361000 - Interest Earnings 11,566.76 23,163.84 15,000.00 (8,163.84)154.43% 362000 - Rental of Property 100.00 44,156.00 60,000.00 15,844.00 73.59% 367000 - Donations from Private Sources -640,828.93 1,061,000.00 420,171.07 60.40% Total Miscellaneous Revenue 12,022.28 717,399.43 1,145,500.00 428,100.57 62.63% Refunds & Reimbursements 380000 - Misc Reimbursements -18,071.29 18,253.00 181.71 99.00% 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 47.88 45,795.55 43,284.00 (2,511.55)105.80% Total Refunds & Reimbursements 47.88 69,592.22 307,787.00 238,194.78 22.61% Other Sources 391000 - Interfund Transfers In 9,935.00 79,481.00 119,221.00 39,740.00 66.67% 393000 - Capital Lease Proceeds -1,290,000.00 1,290,000.00 -100.00% Total Other Sources 9,935.00 1,369,481.00 1,409,221.00 39,740.00 97.18% August 31, 2022 Total Revenue 588,507.81 11,008,432.03 17,505,813.00 6,497,380.97 62.88% 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 218,884.48 1,845,262.75 -1,845,262.75 3,049,049.00 1,203,786.25 60.52% 410002 - Teamster Wages 119,655.95 943,087.86 -943,087.86 1,542,175.00 599,087.14 61.15% 410003 - Permanent Part Time 111,641.40 601,654.84 -601,654.84 1,038,670.00 437,015.16 57.93% 410004 - Extra & Overtime 17,749.71 98,905.48 -98,905.48 95,975.00 (2,930.48)103.05% 410005 - Seasonal & Interns 120,035.63 557,708.53 -557,708.53 834,551.00 276,842.47 66.83% 410007 - Longevity Pay 437.49 5,483.32 -5,483.32 8,450.00 2,966.68 64.89% 410014 - Contract Add Pays ------0.00% 410017 - Stand By Pay 340.24 2,015.36 -2,015.36 3,500.00 1,484.64 57.58% 410022 - Park Board Stipend ----1,200.00 1,200.00 0.00% Total Salaries & Wages 588,744.90 4,054,118.14 - 4,054,118.14 6,573,570.00 2,519,451.86 61.67% Employee Benefits 411001 - FICA Regular 43,779.03 314,859.42 -314,859.42 506,363.00 191,503.58 62.18% 411004 - PERF Regular 38,998.39 328,626.44 -328,626.44 530,630.00 202,003.56 61.93% 411005 - PERF Union 1,383.63 12,406.61 -12,406.61 26,912.00 14,505.39 46.10% 411007 - Unemployment Comp 591.52 4,524.25 -4,524.25 7,520.00 2,995.75 60.16% 411008 - Health Insurance 90,927.08 695,796.68 -695,796.68 1,192,876.00 497,079.32 58.33% 411009 - Life Insurance 850.00 6,590.00 -6,590.00 10,560.00 3,970.00 62.41% 411014 - Parental Leave 1,231.59 10,074.83 -10,074.83 16,447.00 6,372.17 61.26% 411015 - Other Fringe Benefits -1,490.00 -1,490.00 1,500.00 10.00 99.33% 411201 - Tool Allowance 105.93 3,029.55 319.93 3,349.48 4,800.00 1,450.52 69.78% 411203 - Job Readiness Allow.-14,875.00 -14,875.00 19,425.00 4,550.00 76.58% 411204 - Auto Allowance 266.66 2,133.28 -2,133.28 3,200.00 1,066.72 66.67% 411206 - Cell Phone Allowance 1,045.00 8,415.00 -8,415.00 12,820.00 4,405.00 65.64% Total Employee Benefits 179,178.83 1,402,821.06 319.93 1,403,140.99 2,333,053.00 929,912.01 60.14% Total Personnel Expenses 767,923.73 5,456,939.20 319.93 5,457,259.13 8,906,623.00 3,449,363.87 61.27% Supplies Expenses Office Supplies 421000 - General Office Supplies 995.94 10,876.48 426.01 11,302.49 23,529.18 12,226.69 48.04% Total Office Supplies 995.94 10,876.48 426.01 11,302.49 23,529.18 12,226.69 48.04% Operating Supplies 422000 - Other Operating Supplies 29,418.45 229,386.58 28,918.17 258,304.75 300,554.02 42,249.27 85.94% 422001 - C.S. Gasoline 20,791.95 161,307.40 -161,307.40 165,000.00 3,692.60 97.76% 422002 - Diesel/CNG 3,546.27 5,432.27 2,331.92 7,764.19 4,000.00 (3,764.19)194.10% 422003 - Gasoline 4,344.07 14,806.68 5,431.50 20,238.18 25,905.00 5,666.82 78.12% 422004 - Oil -35.30 -35.30 50.00 14.70 70.60% 422005 - Uniforms 317.79 7,812.72 1,218.25 9,030.97 21,695.00 12,664.03 41.63% 422006 - Computer Supplies & Equipment -319.93 64.89 384.82 500.00 115.18 76.96% 422007 - Cleaning Supplies 2,378.77 4,043.52 -4,043.52 4,950.00 906.48 81.69% 422008 - Medical/Safety Supplies -11,759.38 -11,759.38 14,756.00 2,996.62 79.69% 422009 - Recreation Supplies 18,267.70 94,782.53 28,032.47 122,815.00 254,301.60 131,486.60 48.30% 422010 - Plants Chemicals Seed & Fertilizer 4,590.28 135,244.36 30,484.97 165,729.33 182,575.00 16,845.67 90.77% 422013 - Promotional Supplies 459.91 459.91 -459.91 -(459.91)0.00% 422014 - Concessions Inventory 28,214.20 110,565.30 7,083.21 117,648.51 84,205.00 (33,443.51)139.72% 422016 - Inventory For Sale 4,542.24 41,811.52 8,486.00 50,297.52 34,035.00 (16,262.52)147.78% Total Operating Supplies 116,871.63 817,767.40 112,051.38 929,818.78 1,092,526.62 162,707.84 85.11% Repair & Maintenance Supplies 423000 - Other R&M Supplies 15,479.55 180,290.77 27,204.19 207,494.96 254,265.04 46,770.08 81.61% 423001 - Building Materials 10,942.61 56,243.34 3,267.00 59,510.34 90,000.00 30,489.66 66.12% 423006 - Small Tools & Equipment 4,833.62 19,336.97 244.11 19,581.08 25,573.00 5,991.92 76.57% 423009 - Repair Parts 8,162.54 46,755.93 3,218.46 49,974.39 82,429.03 32,454.64 60.63% Total Repair & Maintenance Supplies 39,418.32 302,627.01 33,933.76 336,560.77 452,267.07 115,706.30 74.42% Total Supplies Expenses 157,285.89 1,131,270.89 146,411.15 1,277,682.04 1,568,322.87 290,640.83 81.47% Services & Charges Expenses Professional Services 431000 - Other Professional Services 12,384.32 97,515.05 44,132.50 141,647.55 145,377.00 3,729.45 97.43% 431009 - Computer & Technology -31.83 -31.83 500.00 468.17 6.37% 431014 - Collection Costs 17.50 41.25 -41.25 50.00 8.75 82.50% 431015 - Laboratory Water Testing --250.00 250.00 300.00 50.00 83.33% 431019 - Security Services 7,440.52 30,921.36 4,653.00 35,574.36 33,540.00 (2,034.36)106.07% Total Professional Services 19,842.34 128,509.49 49,035.50 177,544.99 179,767.00 2,222.01 98.76% Communication & Transportation 432002 - Mailing 426.89 1,433.20 -1,433.20 4,875.00 3,441.80 29.40% 432003 - Travel 2,226.58 4,958.61 14,178.54 19,137.15 27,450.00 8,312.85 69.72% 432004 - Telecommunications -1,477.34 3,153.80 4,631.14 9,703.80 5,072.66 47.73% 432005 - Mileage Reimb 213.29 628.96 469.96 1,098.92 3,705.00 2,606.08 29.66% Total Communication & Transportation 2,866.76 8,498.11 17,802.30 26,300.41 45,733.80 19,433.39 57.51% Printing & Advertising 433001 - Outside Printing Services 1,091.52 11,877.50 -11,877.50 21,280.00 9,402.50 55.82% 433002 - Publication of Legal Notice 500.50 996.10 1,111.30 2,107.40 2,000.00 (107.40)105.37% 433003 - Promotional 19,594.42 245,576.90 139,553.59 385,130.49 389,614.06 4,483.57 98.85% Total Printing & Advertising 21,186.44 258,450.50 140,664.89 399,115.39 412,894.06 13,778.67 96.66% Utilties 435001 - Electric 36,885.64 339,165.37 -339,165.37 452,847.00 113,681.63 74.90% 435002 - Natural Gas 2,728.20 143,006.53 -143,006.53 113,457.00 (29,549.53)126.04% 435004 - Water 37,508.27 170,863.23 -170,863.23 214,000.00 43,136.77 79.84% Total Utilities 77,122.11 653,035.13 - 653,035.13 780,304.00 127,268.87 83.69% Repairs & Maintenance 436000 - Other R&M 15,386.84 33,952.86 15,729.24 49,682.10 83,600.53 33,918.43 59.43% 436001 - Building R&M 18,920.22 165,180.22 23,669.46 188,849.68 206,994.82 18,145.14 91.23% 436003 - Auto Equip R&M 45,169.04 233,455.07 -233,455.07 297,000.00 63,544.93 78.60% 436005 - Other Equip R&M -1,309.67 108.00 1,417.67 6,800.00 5,382.33 20.85% 436006 - Radio Equip R&M 1,584.64 10,168.23 -10,168.23 3,500.00 (6,668.23)290.52% 436011 - Exterminating -3,416.00 746.00 4,162.00 8,334.00 4,172.00 49.94% Total Repairs & Maintenance 81,060.74 447,482.05 40,252.70 487,734.75 606,229.35 118,494.60 80.45% Rentals 437002 - Equipment Rental 6,639.83 7,199.83 -7,199.83 -(7,199.83)0.00% 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 6,639.83 20,399.83 - 20,399.83 13,200.00 (7,199.83) 154.54% 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 85,294.78 451,702.05 145,438.71 597,140.76 691,555.29 94,414.53 86.35% 439001 - Other Contractual Services 1,843.95 7,777.33 11,000.00 18,777.33 19,000.00 222.67 98.83% 439002 - Licenses & Permits 643.23 12,534.77 -12,534.77 12,625.00 90.23 99.29% 439003 - Subscriptions 582.79 3,153.91 -3,153.91 3,720.00 566.09 84.78% 439004 - Dues & Memberships -9,107.37 -9,107.37 18,010.00 8,902.63 50.57% 439005 - Bank & Credit Card Fees 10,532.32 68,746.63 -68,746.63 65,035.00 (3,711.63)105.71% 439006 - Education & Training 3,100.00 16,094.89 3,956.23 20,051.12 28,025.00 7,973.88 71.55% 439009 - Trash Removal 6,190.87 39,367.40 6,359.70 45,727.10 54,434.41 8,707.31 84.00% 439012 - Uniform Services 1,532.39 10,722.96 -10,722.96 8,200.00 (2,522.96)130.77% 439018 - Demolition & Clearance --18,000.00 18,000.00 18,000.00 -100.00% 439099 - Cashier Over/Short (113.18)567.66 -567.66 2,300.00 1,732.34 24.68% 439100 - Refunds/Awards/Indemnities 4,529.93 22,532.33 -22,532.33 27,485.00 4,952.67 81.98% 439300 - Grants & Subsidies -715,000.00 -715,000.00 715,000.00 -100.00% Total Other Services & Charges 114,137.08 1,357,307.30 184,754.64 1,542,061.94 1,663,389.70 121,327.76 92.71% Total Services & Charges Expenses 322,855.30 3,212,470.55 432,510.03 3,644,980.58 4,117,539.91 472,559.33 88.52% Capital Outlay Buildings 443001 - Building Improvements -100,948.75 1,501.25 102,450.00 102,450.00 -100.00% Total Buildings - 100,948.75 1,501.25 102,450.00 102,450.00 - 100.00% 444000 - Land Improvements 20,817.00 237,533.38 871,504.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 90,633.76 97,696.26 152,581.24 250,277.50 686,027.50 435,750.00 36.48% 445006 - Computer Equip/Network -17,007.12 -17,007.12 17,011.00 3.88 99.98% 445100 - Lease Purchase/Motor Equip --513,394.53 513,394.53 1,290,000.00 776,605.47 39.80% Total Machinery & Equipment 90,633.76 125,570.33 665,975.77 791,546.10 2,003,905.36 1,212,359.26 39.50% Total Capital Expenses 111,450.76 464,052.46 1,538,981.34 2,003,033.80 3,400,825.85 1,397,792.05 58.90% Other Uses 452002 - Allocations-Admin Cost 61,510.58 492,084.68 -492,084.68 738,127.00 246,042.32 66.67% 452003 - Allocations-IT 57,450.84 459,606.64 -459,606.64 689,410.00 229,803.36 66.67% 452004 - Allocations-Liability Insurance 24,384.42 195,075.32 -195,075.32 292,613.00 97,537.68 66.67% 452008 - Allocations-Payroll Cost 6,895.25 55,162.00 -55,162.00 82,743.00 27,581.00 66.67% 452009 - Allocations-Facilities Mgmt 2,296.25 18,370.00 -18,370.00 27,555.00 9,185.00 66.67% Total Other Uses 152,537.34 1,220,298.64 - 1,220,298.64 1,830,448.00 610,149.36 66.67% Bad Debt Expense 490000 - Bad Debt Expense 100.00 1,100.00 -1,100.00 -(1,100.00)0.00% Total Bad Debt Expense 100.00 1,100.00 - 1,100.00 - (1,100.00) 0.00% Total Expenses 1,512,153.02 11,486,131.74 2,118,222.45 13,604,354.19 19,823,759.63 6,219,405.44 68.63%