Loading...
HomeMy WebLinkAboutMay 23 Fin 3South Bend Venues, Parks and Arts Parks Maintenance: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Charges for Services Culture & Recreation 347015 - Lease of Stadium 15,000.00 15,000.00 75,000.00 60,000.00 20.00% 347021 - Tree Maintenance 2,564.87 14,898.21 - (14,898.21) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% Total Culture & Recreation 17,564.87 29,898.21 77,000.00 47,101.79 38.83% Total Charges for Services 17,564.87 29,898.21 77,000.00 47,101.79 38.83% Miscellaneous Revenue 360000 - Miscellaneous 2,000.00 2,000.00 - (2,000.00) 0.00% 360001 - Sale of Scrap Metal - 723.65 - (723.65) 0.00% 360011 - Settlement Fees - 19,500.00 - (19,500.00) 0.00% Total Miscellaneous Revenue 2,000.00 22,223.65 - (22,223.65) 0.00% Refunds & Reimbursements 380000 - Misc Reimbursements 45,000.00 45,071.48 45,000.00 (71.48) 100.16% 396000 - Refunds - 219.12 - (219.12) 0.00% Total Refunds & Reimbursements 45,000.00 45,290.60 45,000.00 (290.60) 100.65% Total Revenue 64,564.87 97,412.46 122,000.00 24,587.54 79.85% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent of Account String Month Expenses Encumbrances w/ Encumb. Budget Budget Budget Personnel Expenses Salaries & Wages 410001 - Salaried Wages 69,145.58 369,068.87 - 369,068.87 913,867.00 544,798.13 40.39% 410002 - Teamster Wages 111,487.90 578,389.21 - 578,389.21 1,349,620.00 771,230.79 42.86% 410003 - Permanent Part Time 42,308.11 156,550.00 - 156,550.00 300,000.00 143,450.00 52.18% 410004 - Extra & Overtime 4,820.44 33,909.52 - 33,909.52 56,300.00 22,390.48 60.23% 410005 - Seasonal & Interns 32,593.38 90,742.43 - 90,742.43 300,000.00 209,257.57 30.25% 410007 - Longevity Pay 350.00 4,150.00 - 4,150.00 7,450.00 3,300.00 55.70% 410017 - Stand By Pay - 1,092.78 - 1,092.78 - (1,092.78) 0.00% Total Salaries & Wages 260,705.41 1,233,902.81 - 1,233,902.81 2,927,237.00 1,693,334.19 42.15% Employee Benefits 411001 - FICA Regular 19,708.84 91,614.47 - 91,614.47 222,609.00 130,994.53 41.15% 411004 - PERF Regular 20,778.45 107,097.34 - 107,097.34 263,192.00 156,094.66 40.69% 411005 - PERF Union 1,132.98 5,803.02 - 5,803.02 21,452.00 15,648.98 27.05% 411007 - Unemployment Comp 19.93 106.87 - 106.87 2,793.00 2,686.13 3.83% 411008 - Health Insurance 52,612.66 239,048.00 - 239,048.00 616,458.00 377,410.00 38.78% 411009 - Life Insurance 490.00 2,200.00 - 2,200.00 5,280.00 3,080.00 41.67% 411010 - Med/Surgical/Dental 601.30 2,741.59 - 2,741.59 - (2,741.59) 0.00% 411014 - Parental Leave 645.54 3,422.15 - 3,422.15 8,145.00 4,722.85 42.02% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 - (1,200.00) 0.00% 411200 - Clothing Allowance 155.14 155.14 - 155.14 - (155.14) 0.00% 411201 - Tool Allowance - 1,579.52 420.81 2,000.33 4,000.00 1,999.67 50.01% 411203 - Job Readiness Allow. 8,977.84 8,977.84 - 8,977.84 12,750.00 3,772.16 70.41% 411206 - Cell Phone Allowance 440.00 2,200.00 - 2,200.00 5,940.00 3,740.00 37.04% Total Employee Benefits 105,562.68 466,145.94 420.81 466,566.75 1,162,619.00 696,052.25 40.13% Total Personnel Expenses 366,268.09 1,700,048.75 420.81 1,700,469.56 4,089,856.00 2,389,386.44 41.58% Supplies Expenses Office Supplies May 31, 2023 421000 - General Office Supplies 55.67 636.00 - 636.00 2,000.00 1,364.00 31.80% Total Office Supplies 55.67 636.00 - 636.00 2,000.00 1,364.00 31.80% Operating Supplies 422000 - Other Operating Supplies 26,336.80 85,074.95 9,471.73 94,546.68 164,387.69 69,841.01 57.51% 422001 - C.S. Gasoline 19,856.04 90,509.15 - 90,509.15 220,000.00 129,490.85 41.14% 422003 - Gasoline - 13.11 - 13.11 667.00 653.89 1.97% 422005 - Uniforms 917.58 2,135.83 - 2,135.83 1,218.25 (917.58) 175.32% 422006 - Computer Supplies & Equipment 166.43 166.43 - 166.43 700.00 533.57 23.78% 422007 - Cleaning Supplies 311.94 476.78 - 476.78 600.00 123.22 79.46% 422008 - Medical/Safety Supplies 158.81 8,173.02 - 8,173.02 13,104.00 4,930.98 62.37% 422010 - Plants Chemicals Seed & Fertilizer 9,882.87 61,556.20 10,389.17 71,945.37 120,455.00 48,509.63 59.73% Total Operating Supplies 57,630.47 248,105.47 19,860.90 267,966.37 521,131.94 253,165.57 51.42% Repair & Maintenance Supplies 423000 - Other R&M Supplies 20,284.03 64,294.05 36,793.42 101,087.47 256,863.88 155,776.41 39.35% 423001 - Building Materials 8,174.63 37,430.17 21,110.05 58,540.22 145,169.45 86,629.23 40.33% 423006 - Small Tools & Equipment 2,507.89 18,962.09 3,736.08 22,698.17 26,852.00 4,153.83 84.53% 423009 - Repair Parts 6,344.99 37,611.55 17,338.73 54,950.28 77,164.24 22,213.96 71.21% Total Repair & Maintenance Supplies 37,311.54 158,297.86 78,978.28 237,276.14 506,049.57 268,773.43 46.89% Total Supplies Expenses 94,997.68 407,039.33 98,839.18 505,878.51 1,029,181.51 523,303.00 49.15% Services & Charges Expenses Professional Services 431000 - Other Professional Services 8,651.51 92,135.25 25,374.08 117,509.33 70,933.96 (46,575.37) 165.66% 431009 - Computer & Technology - 7,750.00 - 7,750.00 8,275.00 525.00 93.66% 431014 - Collection Costs - 55.75 - 55.75 100.00 44.25 55.75% 431019 - Security Services 5,181.00 7,480.00 28,850.00 36,330.00 201,669.00 165,339.00 18.01% Total Professional Services 13,832.51 107,421.00 54,224.08 161,645.08 280,977.96 119,332.88 57.53% Communication & Transportation 432003 - Travel - 363.93 715.50 1,079.43 6,617.50 5,538.07 16.31% 432004 - Telecommunications 583.47 758.91 2,177.41 2,936.32 11,687.41 8,751.09 25.12% Total Communication & Transportation 583.47 1,122.84 2,892.91 4,015.75 18,304.91 14,289.16 21.94% Printing & Advertising 433001 - Outside Printing Services - - - - 2,100.00 2,100.00 0.00% 433002 - Publication of Legal Notice - 1,038.00 677.81 1,715.81 3,277.72 1,561.91 52.35% Total Printing & Advertising - 1,038.00 677.81 1,715.81 5,377.72 3,661.91 31.91% Utilties 435001 - Electric 38,467.36 186,536.60 - 186,536.60 470,043.00 283,506.40 39.69% 435002 - Natural Gas 10,591.11 108,660.20 - 108,660.20 282,938.00 174,277.80 38.40% 435004 - Water 24,524.37 55,556.01 - 55,556.01 300,000.00 244,443.99 18.52% Total Utilities 73,582.84 350,752.81 - 350,752.81 1,052,981.00 702,228.19 33.31% Repairs & Maintenance 436000 - Other R&M 5,538.20 17,906.50 30,985.00 48,891.50 302,942.99 254,051.49 16.14% 436001 - Building R&M 34,829.69 235,221.65 87,240.00 322,461.65 354,902.60 32,440.95 90.86% 436003 - Auto Equip R&M 30,590.13 122,675.83 - 122,675.83 351,750.00 229,074.17 34.88% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 6,992.10 75.68 98.92% 436006 - Radio Equip R&M 1,069.32 6,239.22 - 6,239.22 7,200.00 960.78 86.66% 436011 - Exterminating - 554.00 12,833.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 72,027.34 389,513.62 131,058.00 520,571.62 1,040,129.69 519,558.07 50.05% Debt Service 438100 - Principal - 122,623.28 - 122,623.28 246,687.00 124,063.72 49.71% 438200 - Interest - 13,587.83 - 13,587.83 25,735.00 12,147.17 52.80% Total Debt Service - 136,211.11 - 136,211.11 272,422.00 136,210.89 50.00% Other Charges & Services 439000 - Misc Charges & Svcs 12,149.09 29,009.63 51,729.07 80,738.70 75,627.23 (5,111.47) 106.76% 439001 - Other Contractual Services 5,485.30 9,296.36 82,274.83 91,571.19 145,900.00 54,328.81 62.76% 439002 - Licenses & Permits 200.00 1,200.00 - 1,200.00 1,208.00 8.00 99.34% 439003 - Subscriptions - 922.09 - 922.09 1,281.00 358.91 71.98% 439004 - Dues & Memberships - 1,335.00 - 1,335.00 2,494.00 1,159.00 53.53% 439006 - Education & Training 1,658.36 9,324.62 2,634.01 11,958.63 12,029.00 70.37 99.41% 439009 - Trash Removal 3,601.72 18,036.43 4,949.68 22,986.11 32,493.15 9,507.04 70.74% 439012 - Uniform Services 2,018.70 8,441.18 - 8,441.18 15,941.00 7,499.82 52.95% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 25,113.17 92,565.31 141,587.59 234,152.90 301,973.38 67,820.48 77.54% Total Services & Charges Expenses 185,139.33 1,078,624.69 330,440.39 1,409,065.08 2,972,166.66 1,563,101.58 47.41% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - - - 35,618.00 35,618.00 0.00% 445003 - Park Equipment - 8,045.00 154,895.40 162,940.40 293,927.00 130,986.60 55.44% 445100 - Lease Purchase/Motor Equip 217,096.00 230,734.00 56,650.00 287,384.00 1,047,863.30 760,479.30 27.43% Total Machinery & Equipment 217,096.00 238,779.00 211,545.40 450,324.40 1,377,408.30 927,083.90 32.69% Total Capital Expenses 217,096.00 238,779.00 211,545.40 450,324.40 1,377,408.30 927,083.90 32.69% Other Uses 452002 - Allocations-Admin Cost - 122,533.68 - 122,533.68 367,601.00 245,067.32 33.33% 452003 - Allocations-IT - 55,263.00 - 55,263.00 165,789.00 110,526.00 33.33% 452004 - Allocations-Liability Insurance - 59,328.32 - 59,328.32 177,985.00 118,656.68 33.33% 452009 - Allocations-Facilities Mgmt - 8,547.00 - 8,547.00 25,641.00 17,094.00 33.33% Total Other Uses - 245,672.00 - 245,672.00 737,016.00 491,344.00 33.33% Total Expenses 863,501.10 3,670,163.77 641,245.78 4,311,409.55 10,205,628.47 5,894,218.92 42.25%