Loading...
HomeMy WebLinkAboutSept 22 Fin 3South Bend Venues, Parks and Arts Parks Maintenance: Revenues and Expenditures REVENUES Current YTD Total Estimated Uncollected Account String Month Revenue Revenues Revenue % Uncollected Charges for Services Culture & Recreation 347015 - Lease of Stadium 15,000.00 75,000.00 75,000.00 - 100.00% 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% Total Culture & Recreation 46,427.08 344,734.01 417,839.00 73,104.99 82.50% Total Charges for Services 46,427.08 344,734.01 417,839.00 73,104.99 82.50% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal 78.75 925.07 - (925.07) 0.00% 367000 - Donations from Private Sources - 7,867.50 - (7,867.50) 0.00% Total Miscellaneous Revenue 78.75 8,792.57 2,000.00 (6,792.57) 439.63% Refunds & Reimbursements 380000 - Misc Reimbursements - 157.49 - (157.49) 0.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 739.75 38,342.92 37,603.00 (739.92) 101.97% Total Refunds & Reimbursements 739.75 44,225.79 283,853.00 239,627.21 15.58% Other Sources 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% 393000 - Capital Lease Proceeds - 1,290,000.00 1,290,000.00 - 100.00% Total Other Sources 65,458.00 1,355,458.00 1,290,000.00 (65,458.00) 105.07% Total Revenue 112,703.58 1,753,210.37 1,993,692.00 240,481.63 87.94% 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 90,865.66 603,153.65 - 603,153.65 820,100.00 216,946.35 73.55% 410002 - Teamster Wages 147,722.40 936,645.49 - 936,645.49 1,271,200.00 334,554.51 73.68% 410003 - Permanent Part Time 58,133.25 260,760.30 - 260,760.30 255,000.00 (5,760.30) 102.26% 410004 - Extra & Overtime 10,602.42 82,507.78 - 82,507.78 66,300.00 (16,207.78) 124.45% 410005 - Seasonal & Interns 41,286.97 259,528.43 - 259,528.43 300,000.00 40,471.57 86.51% 410007 - Longevity Pay 700.00 5,283.32 - 5,283.32 7,450.00 2,166.68 70.92% 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% Total Salaries & Wages 349,647.82 2,150,231.45 - 2,150,231.45 2,723,550.00 573,318.55 78.95% Employee Benefits 411001 - FICA Regular 26,124.09 168,019.21 - 168,019.21 210,409.00 42,389.79 79.85% 411004 - PERF Regular 27,648.16 184,381.74 - 184,381.74 245,889.00 61,507.26 74.99% 411005 - PERF Union 1,703.76 12,237.93 - 12,237.93 20,541.00 8,303.07 59.58% 411007 - Unemployment Comp 26.86 2,239.92 - 2,239.92 3,472.00 1,232.08 64.51% 411008 - Health Insurance 48,364.16 398,829.84 - 398,829.84 582,882.00 184,052.16 68.42% 411009 - Life Insurance 440.00 3,710.00 - 3,710.00 5,160.00 1,450.00 71.90% 411014 - Parental Leave 869.83 5,664.49 - 5,664.49 7,594.00 1,929.51 74.59% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance 388.14 3,417.69 488.41 3,906.10 4,000.00 93.90 97.65% 411203 - Job Readiness Allow. - 12,325.00 - 12,325.00 15,750.00 3,425.00 78.25% September 30, 2022 411206 - Cell Phone Allowance 440.00 3,960.00 - 3,960.00 5,940.00 1,980.00 66.67% Total Employee Benefits 106,005.00 795,985.82 488.41 796,474.23 1,102,837.00 306,362.77 72.22% Total Personnel Expenses 455,652.82 2,946,217.27 488.41 2,946,705.68 3,826,387.00 879,681.32 77.01% Supplies Expenses Office Supplies 421000 - General Office Supplies 160.14 3,486.11 876.00 4,362.11 5,000.00 637.89 87.24% Total Office Supplies 160.14 3,486.11 876.00 4,362.11 5,000.00 637.89 87.24% Operating Supplies 422000 - Other Operating Supplies 14,650.72 155,820.59 20,701.52 176,522.11 183,081.45 6,559.34 96.42% 422001 - C.S. Gasoline 26,660.51 187,967.91 - 187,967.91 165,000.00 (22,967.91) 113.92% 422003 - Gasoline - - 50.00 50.00 2,405.00 2,355.00 2.08% 422004 - Oil - 35.30 - 35.30 50.00 14.70 70.60% 422005 - Uniforms - - 1,218.25 1,218.25 3,000.00 1,781.75 40.61% 422006 - Computer Supplies & Equipment 64.89 384.82 - 384.82 500.00 115.18 76.96% 422007 - Cleaning Supplies - 4,024.06 - 4,024.06 4,550.00 525.94 88.44% 422008 - Medical/Safety Supplies 1,217.86 12,927.31 - 12,927.31 12,480.00 (447.31) 103.58% 422010 - Plants Chemicals Seed & Fertilizer 485.54 47,214.20 19,661.98 66,876.18 68,975.00 2,098.82 96.96% Total Operating Supplies 43,079.52 408,374.19 41,631.75 450,005.94 440,041.45 (9,964.49) 102.26% Repair & Maintenance Supplies 423000 - Other R&M Supplies 10,288.41 144,322.82 20,445.96 164,768.78 194,674.41 29,905.63 84.64% 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 46,284.92 4,982.17 51,267.09 79,729.03 28,461.94 64.30% Total Repair & Maintenance Supplies 17,542.31 271,433.27 27,726.13 299,159.40 389,976.44 90,817.04 76.71% Total Supplies Expenses 60,781.97 683,293.57 70,233.88 753,527.45 835,017.89 81,490.44 90.24% Services & Charges Expenses Professional Services 431000 - Other Professional Services 4,633.00 10,624.00 38,474.50 49,098.50 50,000.00 901.50 98.20% 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,443.00 31,476.35 13,164.00 44,640.35 46,640.00 1,999.65 95.71% Total Professional Services 8,091.00 42,188.43 51,888.50 94,076.93 97,540.00 3,463.07 96.45% Communication & Transportation 432003 - Travel 1,384.17 3,568.26 2,517.36 6,085.62 6,400.00 314.38 95.09% 432004 - Telecommunications - 1,108.00 2,597.41 3,705.41 7,697.41 3,992.00 48.14% Total Communication & Transportation 1,384.17 4,676.26 5,114.77 9,791.03 14,097.41 4,306.38 69.45% Printing & Advertising 433001 - Outside Printing Services - 500.00 - 500.00 2,000.00 1,500.00 25.00% 433002 - Publication of Legal Notice - 996.10 1,111.30 2,107.40 2,200.00 92.60 95.79% Total Printing & Advertising - 1,496.10 1,111.30 2,607.40 4,200.00 1,592.60 62.08% Utilties 435001 - Electric 42,851.90 341,022.17 - 341,022.17 403,180.00 62,157.83 84.58% 435002 - Natural Gas 2,386.13 131,353.56 - 131,353.56 90,938.00 (40,415.56) 144.44% 435004 - Water 34,180.54 205,043.77 - 205,043.77 214,000.00 8,956.23 95.81% Total Utilities 79,418.57 677,419.50 - 677,419.50 708,118.00 30,698.50 95.66% Repairs & Maintenance 436000 - Other R&M 4,775.92 32,799.54 5,465.43 38,264.97 66,278.99 28,014.02 57.73% 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,311.21 108.00 1,419.21 5,800.00 4,380.79 24.47% 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 477,481.90 32,121.53 509,603.43 562,907.81 53,304.38 90.53% Rentals 437002 - Equipment Rental - 560.00 - 560.00 600.00 40.00 93.33% Total Rentals - 560.00 - 560.00 600.00 40.00 93.33% Debt Service 438100 - Principal - 133,096.72 - 133,096.72 144,454.62 11,357.90 92.14% 438200 - Interest - 3,114.38 - 3,114.38 3,114.38 - 100.00% Total Debt Service - 136,211.10 - 136,211.10 147,569.00 11,357.90 92.30% Other Charges & Services 439000 - Misc Charges & Svcs 48,660.46 407,596.72 72,303.43 479,900.15 528,139.50 48,239.35 90.87% 439001 - Other Contractual Services - 2,443.96 11,000.00 13,443.96 14,000.00 556.04 96.03% 439002 - Licenses & Permits 40.00 1,374.36 - 1,374.36 1,450.00 75.64 94.78% 439003 - Subscriptions 504.00 2,067.79 - 2,067.79 1,820.00 (247.79) 113.61% 439004 - Dues & Memberships - 390.00 - 390.00 2,375.00 1,985.00 16.42% 439006 - Education & Training 879.63 9,156.80 1,879.00 11,035.80 11,300.00 264.20 97.66% 439009 - Trash Removal 4,496.04 31,060.05 6,619.56 37,679.61 43,920.75 6,241.14 85.79% 439012 - Uniform Services 2,017.23 12,740.19 - 12,740.19 11,200.00 (1,540.19) 113.75% 439100 - Refunds/Awards/Indemnities - 120.13 - 120.13 200.00 79.87 60.07% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 56,597.36 481,950.00 91,801.99 573,751.99 629,405.25 55,653.26 91.16% Total Services & Charges Expenses 181,944.89 1,821,983.29 182,038.09 2,004,021.38 2,164,437.47 160,416.09 92.59% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment - 77,946.26 52,581.24 130,527.50 386,027.50 255,500.00 33.81% 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 330,949.91 323,839.07 654,788.98 1,686,894.36 1,032,105.38 38.82% Total Capital Expenses 242,136.70 330,949.91 323,839.07 654,788.98 1,686,894.36 1,032,105.38 38.82% Other Uses 452002 - Allocations-Admin Cost 31,642.25 284,780.25 - 284,780.25 379,707.00 94,926.75 75.00% 452003 - Allocations-IT 12,805.67 115,250.99 - 115,250.99 153,668.00 38,417.01 75.00% 452004 - Allocations-Liability Insurance 11,013.08 99,117.76 - 99,117.76 132,157.00 33,039.24 75.00% 452009 - Allocations-Facilities Mgmt 2,001.00 18,009.00 - 18,009.00 24,012.00 6,003.00 75.00% Total Other Uses 57,462.00 517,158.00 - 517,158.00 689,544.00 172,386.00 75.00% Total Expenses 997,978.38 6,299,602.04 576,599.45 6,876,201.49 9,202,280.72 2,326,079.23 74.72%