Loading...
HomeMy WebLinkAboutApr 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 - - 75,000.00 75,000.00 0.00% 347021 - Tree Maintenance 2,099.38 12,333.34 - (12,333.34) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% Total Culture & Recreation 2,099.38 12,333.34 77,000.00 64,666.66 16.02% Total Charges for Services 2,099.38 12,333.34 77,000.00 64,666.66 16.02% Miscellaneous Revenue 360001 - Sale of Scrap Metal 490.35 723.65 - (723.65) 0.00% Total Miscellaneous Revenue 490.35 723.65 - (723.65) 0.00% Refunds & Reimbursements 380000 - Misc Reimbursements 20.35 71.48 - (71.48) 0.00% 396000 - Refunds - 19.12 - (19.12) 0.00% Total Refunds & Reimbursements 20.35 90.60 - (90.60) 0.00% Total Revenue 2,610.08 13,147.59 77,000.00 63,852.41 17.07% 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.51 299,923.29 - 299,923.29 913,867.00 613,943.71 32.82% 410002 - Teamster Wages 111,767.37 465,306.38 - 465,306.38 1,349,620.00 884,313.62 34.48% 410003 - Permanent Part Time 30,141.09 114,241.89 - 114,241.89 300,000.00 185,758.11 38.08% 410004 - Extra & Overtime 2,830.04 29,089.08 - 29,089.08 56,300.00 27,210.92 51.67% 410005 - Seasonal & Interns 22,079.94 58,149.05 - 58,149.05 300,000.00 241,850.95 19.38% 410007 - Longevity Pay 850.00 3,800.00 - 3,800.00 7,450.00 3,650.00 51.01% 410017 - Stand By Pay 694.72 1,092.78 - 1,092.78 - (1,092.78) 0.00% Total Salaries & Wages 237,508.67 971,602.47 - 971,602.47 2,927,237.00 1,955,634.53 33.19% Employee Benefits 411001 - FICA Regular 17,599.78 71,905.63 - 71,905.63 222,609.00 150,703.37 32.30% 411004 - PERF Regular 21,191.99 86,318.89 - 86,318.89 263,192.00 176,873.11 32.80% 411005 - PERF Union 1,056.50 4,670.04 - 4,670.04 21,452.00 16,781.96 21.77% 411007 - Unemployment Comp 20.02 86.94 - 86.94 2,793.00 2,706.06 3.11% 411008 - Health Insurance 47,995.86 186,435.34 - 186,435.34 616,458.00 430,022.66 30.24% 411009 - Life Insurance 450.00 1,710.00 - 1,710.00 5,280.00 3,570.00 32.39% 411010 - Med/Surgical/Dental 551.54 2,140.29 - 2,140.29 - (2,140.29) 0.00% 411014 - Parental Leave 647.97 2,776.61 - 2,776.61 8,145.00 5,368.39 34.09% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 - (1,200.00) 0.00% 411201 - Tool Allowance - 1,579.52 - 1,579.52 4,000.00 2,420.48 39.49% 411203 - Job Readiness Allow. - - - - 12,750.00 12,750.00 0.00% 411206 - Cell Phone Allowance 440.00 1,760.00 - 1,760.00 5,940.00 4,180.00 29.63% Total Employee Benefits 89,953.66 360,583.26 - 360,583.26 1,162,619.00 802,035.74 31.01% Total Personnel Expenses 327,462.33 1,332,185.73 - 1,332,185.73 4,089,856.00 2,757,670.27 32.57% Supplies Expenses Office Supplies 421000 - General Office Supplies 391.26 580.33 - 580.33 2,000.00 1,419.67 29.02% Total Office Supplies 391.26 580.33 - 580.33 2,000.00 1,419.67 29.02% April 30, 2023 Operating Supplies 422000 - Other Operating Supplies 6,507.74 58,738.15 21,342.63 80,080.78 164,387.69 84,306.91 48.71% 422001 - C.S. Gasoline 16,700.96 70,653.11 - 70,653.11 220,000.00 149,346.89 32.12% 422003 - Gasoline - 13.11 - 13.11 667.00 653.89 1.97% 422005 - Uniforms - 1,218.25 - 1,218.25 1,218.25 - 100.00% 422006 - Computer Supplies & Equipment - - - - 700.00 700.00 0.00% 422007 - Cleaning Supplies - 164.84 - 164.84 600.00 435.16 27.47% 422008 - Medical/Safety Supplies 757.05 8,014.21 - 8,014.21 13,104.00 5,089.79 61.16% 422010 - Plants Chemicals Seed & Fertilizer 1,195.37 51,673.33 15,710.90 67,384.23 120,455.00 53,070.77 55.94% Total Operating Supplies 25,161.12 190,475.00 37,053.53 227,528.53 521,131.94 293,603.41 43.66% Repair & Maintenance Supplies 423000 - Other R&M Supplies 17,973.19 44,010.02 28,148.78 72,158.80 256,863.88 184,705.08 28.09% 423001 - Building Materials 6,930.03 29,255.54 28,034.08 57,289.62 145,169.45 87,879.83 39.46% 423006 - Small Tools & Equipment 3,497.42 16,454.20 2,835.57 19,289.77 26,852.00 7,562.23 71.84% 423009 - Repair Parts 19,197.99 31,266.56 18,215.84 49,482.40 77,164.24 27,681.84 64.13% Total Repair & Maintenance Supplies 47,598.63 120,986.32 77,234.27 198,220.59 506,049.57 307,828.98 39.17% Total Supplies Expenses 73,151.01 312,041.65 114,287.80 426,329.45 1,029,181.51 602,852.06 41.42% Services & Charges Expenses Professional Services 431000 - Other Professional Services 27,901.56 83,483.74 34,025.59 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 6.25 55.75 - 55.75 100.00 44.25 55.75% 431019 - Security Services - - 976.00 976.00 201,669.00 200,693.00 0.48% Total Professional Services 27,907.81 91,289.49 35,001.59 126,291.08 280,977.96 154,686.88 44.95% Communication & Transportation 432003 - Travel 318.96 363.93 715.50 1,079.43 6,617.50 5,538.07 16.31% 432004 - Telecommunications 116.96 175.44 2,177.41 2,352.85 11,687.41 9,334.56 20.13% Total Communication & Transportation 435.92 539.37 2,892.91 3,432.28 18,304.91 14,872.63 18.75% Printing & Advertising 433001 - Outside Printing Services - - - - 2,100.00 2,100.00 0.00% 433002 - Publication of Legal Notice 192.40 1,038.00 677.81 1,715.81 3,277.72 1,561.91 52.35% Total Printing & Advertising 192.40 1,038.00 677.81 1,715.81 5,377.72 3,661.91 31.91% Utilties 435001 - Electric 33,758.17 148,069.24 - 148,069.24 470,043.00 321,973.76 31.50% 435002 - Natural Gas 19,946.22 98,069.09 - 98,069.09 282,938.00 184,868.91 34.66% 435004 - Water 8,936.10 31,031.64 - 31,031.64 300,000.00 268,968.36 10.34% Total Utilities 62,640.49 277,169.97 - 277,169.97 1,052,981.00 775,811.03 26.32% Repairs & Maintenance 436000 - Other R&M 6,232.33 12,368.30 30,905.00 43,273.30 302,942.99 259,669.69 14.28% 436001 - Building R&M 63,782.50 200,391.96 82,369.00 282,760.96 354,902.60 72,141.64 79.67% 436003 - Auto Equip R&M 33,920.21 92,085.70 - 92,085.70 351,750.00 259,664.30 26.18% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 6,992.10 75.68 98.92% 436006 - Radio Equip R&M 2,393.39 5,169.90 - 5,169.90 7,200.00 2,030.10 71.80% 436011 - Exterminating - 554.00 12,833.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 106,328.43 317,486.28 126,107.00 443,593.28 1,040,129.69 596,536.41 42.65% 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 2,421.54 16,860.54 57,393.78 74,254.32 75,627.23 1,372.91 98.18% 439001 - Other Contractual Services 6,110.06 6,110.06 67,941.13 74,051.19 145,900.00 71,848.81 50.75% 439002 - Licenses & Permits - 1,000.00 - 1,000.00 1,208.00 208.00 82.78% 439003 - Subscriptions - 922.09 - 922.09 1,281.00 358.91 71.98% 439004 - Dues & Memberships 65.00 1,335.00 - 1,335.00 2,494.00 1,159.00 53.53% 439006 - Education & Training 4,093.76 7,666.26 2,634.01 10,300.27 12,029.00 1,728.73 85.63% 439009 - Trash Removal 3,863.96 14,434.71 5,771.21 20,205.92 32,493.15 12,287.23 62.19% 439012 - Uniform Services 1,892.35 6,422.48 - 6,422.48 15,941.00 9,518.52 40.29% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 18,446.67 69,751.14 133,740.13 203,491.27 301,973.38 98,482.11 67.39% Total Services & Charges Expenses 215,951.72 893,485.36 298,419.44 1,191,904.80 2,972,166.66 1,780,261.86 40.10% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - - - 35,618.00 35,618.00 0.00% 445003 - Park Equipment - 8,045.00 30,382.00 38,427.00 293,927.00 255,500.00 13.07% 445100 - Lease Purchase/Motor Equip - 13,638.00 84,750.00 98,388.00 1,047,863.30 949,475.30 9.39% Total Machinery & Equipment - 21,683.00 115,132.00 136,815.00 1,377,408.30 1,240,593.30 9.93% Total Capital Expenses - 21,683.00 115,132.00 136,815.00 1,377,408.30 1,240,593.30 9.93% Other Uses 452002 - Allocations-Admin Cost - 91,900.26 - 91,900.26 367,601.00 275,700.74 25.00% 452003 - Allocations-IT - 41,447.25 - 41,447.25 165,789.00 124,341.75 25.00% 452004 - Allocations-Liability Insurance - 44,496.24 - 44,496.24 177,985.00 133,488.76 25.00% 452009 - Allocations-Facilities Mgmt - 6,410.25 - 6,410.25 25,641.00 19,230.75 25.00% Total Other Uses - 184,254.00 - 184,254.00 737,016.00 552,762.00 25.00% Total Expenses 616,565.06 2,743,649.74 527,839.24 3,271,488.98 10,205,628.47 6,934,139.49 32.06%