Loading...
HomeMy WebLinkAboutMar 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,769.77 10,233.96 - (10,233.96) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% Total Culture & Recreation 2,769.77 10,233.96 77,000.00 66,766.04 13.29% Total Charges for Services 2,769.77 10,233.96 77,000.00 66,766.04 13.29% Miscellaneous Revenue 360001 - Sale of Scrap Metal - 233.30 - (233.30) 0.00% Total Miscellaneous Revenue - 233.30 - (233.30) 0.00% Refunds & Reimbursements 380000 - Misc Reimbursements - 51.13 - (51.13) 0.00% 396000 - Refunds 19.12 19.12 - (19.12) 0.00% Total Refunds & Reimbursements 19.12 70.25 - (70.25) 0.00% Total Revenue 2,788.89 10,537.51 77,000.00 66,462.49 13.69% 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 103,058.94 230,777.78 - 230,777.78 913,867.00 683,089.22 25.25% 410002 - Teamster Wages 152,790.23 348,213.74 - 348,213.74 1,349,620.00 1,001,406.26 25.80% 410003 - Permanent Part Time 36,934.15 84,100.80 - 84,100.80 300,000.00 215,899.20 28.03% 410004 - Extra & Overtime 12,539.21 26,259.04 - 26,259.04 56,300.00 30,040.96 46.64% 410005 - Seasonal & Interns 17,931.06 36,069.11 - 36,069.11 300,000.00 263,930.89 12.02% 410007 - Longevity Pay 1,650.00 2,950.00 - 2,950.00 7,450.00 4,500.00 39.60% 410017 - Stand By Pay - 398.06 - 398.06 - (398.06) 0.00% Total Salaries & Wages 324,903.59 728,768.53 - 728,768.53 2,927,237.00 2,198,468.47 24.90% Employee Benefits 411001 - FICA Regular 24,575.34 54,305.85 - 54,305.85 222,609.00 168,303.15 24.40% 411004 - PERF Regular 27,835.44 65,126.90 - 65,126.90 263,192.00 198,065.10 24.75% 411005 - PERF Union 1,515.58 3,613.54 - 3,613.54 21,452.00 17,838.46 16.84% 411007 - Unemployment Comp 29.77 66.92 - 66.92 2,793.00 2,726.08 2.40% 411008 - Health Insurance 46,290.86 138,439.48 - 138,439.48 616,458.00 478,018.52 22.46% 411009 - Life Insurance 420.00 1,260.00 - 1,260.00 5,280.00 4,020.00 23.86% 411010 - Med/Surgical/Dental 533.89 1,588.75 - 1,588.75 - (1,588.75) 0.00% 411014 - Parental Leave 944.55 2,128.64 - 2,128.64 8,145.00 6,016.36 26.13% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 - (1,200.00) 0.00% 411201 - Tool Allowance 45.99 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,320.00 - 1,320.00 5,940.00 4,620.00 22.22% Total Employee Benefits 102,631.42 270,629.60 - 270,629.60 1,162,619.00 891,989.40 23.28% Total Personnel Expenses 427,535.01 999,398.13 - 999,398.13 4,089,856.00 3,090,457.87 24.44% Supplies Expenses Office Supplies 421000 - General Office Supplies 169.08 189.07 - 189.07 2,000.00 1,810.93 9.45% Total Office Supplies 169.08 189.07 - 189.07 2,000.00 1,810.93 9.45% March 31, 2023 Operating Supplies 422000 - Other Operating Supplies 31,544.84 52,230.41 3,993.43 56,223.84 164,387.69 108,163.85 34.20% 422001 - C.S. Gasoline - 28,454.54 - 28,454.54 220,000.00 191,545.46 12.93% 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 - 164.84 600.00 435.16 27.47% 422008 - Medical/Safety Supplies 6,485.30 7,257.16 - 7,257.16 13,104.00 5,846.84 55.38% 422010 - Plants Chemicals Seed & Fertilizer 47,993.00 50,477.96 6,635.39 57,113.35 120,455.00 63,341.65 47.41% Total Operating Supplies 86,187.98 139,816.27 10,628.82 150,445.09 521,131.94 370,686.85 28.87% Repair & Maintenance Supplies 423000 - Other R&M Supplies 7,932.19 26,036.83 28,210.29 54,247.12 256,863.88 202,616.76 21.12% 423001 - Building Materials 9,493.20 22,325.51 5,901.16 28,226.67 145,169.45 116,942.78 19.44% 423006 - Small Tools & Equipment 4,113.91 12,956.78 2,519.95 15,476.73 26,852.00 11,375.27 57.64% 423009 - Repair Parts 5,583.54 12,068.57 29,064.71 41,133.28 77,164.24 36,030.96 53.31% Total Repair & Maintenance Supplies 27,122.84 73,387.69 65,696.11 139,083.80 506,049.57 366,965.77 27.48% Total Supplies Expenses 113,479.90 213,393.03 76,324.93 289,717.96 1,029,181.51 739,463.55 28.15% Services & Charges Expenses Professional Services 431000 - Other Professional Services 27,966.45 55,582.18 61,927.15 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 - 49.50 - 49.50 - (49.50) 0.00% 431019 - Security Services - - 976.00 976.00 201,669.00 200,693.00 0.48% Total Professional Services 27,966.45 63,381.68 62,903.15 126,284.83 280,877.96 154,593.13 44.96% Communication & Transportation 432003 - Travel - 44.97 715.50 760.47 6,617.50 5,857.03 11.49% 432004 - Telecommunications - 58.48 2,294.37 2,352.85 11,687.41 9,334.56 20.13% Total Communication & Transportation - 103.45 3,009.87 3,113.32 18,304.91 15,191.59 17.01% Printing & Advertising 433001 - Outside Printing Services - - - - 2,100.00 2,100.00 0.00% 433002 - Publication of Legal Notice - 845.60 677.81 1,523.41 3,277.72 1,754.31 46.48% Total Printing & Advertising - 845.60 677.81 1,523.41 5,377.72 3,854.31 28.33% Utilties 435001 - Electric 37,345.58 114,311.07 - 114,311.07 470,043.00 355,731.93 24.32% 435002 - Natural Gas 20,931.68 78,122.87 - 78,122.87 282,938.00 204,815.13 27.61% 435004 - Water 7,214.32 22,095.54 - 22,095.54 300,000.00 277,904.46 7.37% Total Utilities 65,491.58 214,529.48 - 214,529.48 1,052,981.00 838,451.52 20.37% Repairs & Maintenance 436000 - Other R&M 1,856.97 6,135.97 26,717.33 32,853.30 302,942.99 270,089.69 10.84% 436001 - Building R&M 68,805.59 136,609.46 141,491.25 278,100.71 354,902.60 76,801.89 78.36% 436003 - Auto Equip R&M - 40,372.42 - 40,372.42 351,750.00 311,377.58 11.48% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 2,992.10 (3,924.32) 231.16% 436006 - Radio Equip R&M - 1,306.51 - 1,306.51 7,200.00 5,893.49 18.15% 436011 - Exterminating - 554.00 1,763.00 2,317.00 16,342.00 14,025.00 14.18% Total Repairs & Maintenance 70,662.56 191,894.78 169,971.58 361,866.36 1,036,129.69 674,263.33 34.92% 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,228.00 14,439.00 10,276.23 24,715.23 25,627.23 912.00 96.44% 439001 - Other Contractual Services - - 3,215.37 3,215.37 200,000.00 196,784.63 1.61% 439002 - Licenses & Permits 1,000.00 1,000.00 - 1,000.00 1,208.00 208.00 82.78% 439003 - Subscriptions 327.00 922.09 - 922.09 1,281.00 358.91 71.98% 439004 - Dues & Memberships 375.00 1,270.00 - 1,270.00 2,494.00 1,224.00 50.92% 439006 - Education & Training 1,667.00 3,572.50 3,679.00 7,251.50 12,029.00 4,777.50 60.28% 439009 - Trash Removal 4,340.03 10,570.75 4,674.34 15,245.09 32,493.15 17,248.06 46.92% 439012 - Uniform Services 1,482.09 4,530.13 - 4,530.13 15,941.00 11,410.87 28.42% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 11,419.12 51,304.47 21,844.94 73,149.41 306,073.38 232,923.97 23.90% Total Services & Charges Expenses 175,539.71 658,270.57 258,407.35 916,677.92 2,972,166.66 2,055,488.74 30.84% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - - - 65,000.00 65,000.00 0.00% 445003 - Park Equipment 8,045.00 8,045.00 30,382.00 38,427.00 264,545.00 226,118.00 14.53% 445100 - Lease Purchase/Motor Equip - 13,638.00 28,100.00 41,738.00 1,047,863.30 1,006,125.30 3.98% Total Machinery & Equipment 8,045.00 21,683.00 58,482.00 80,165.00 1,377,408.30 1,297,243.30 5.82% Total Capital Expenses 8,045.00 21,683.00 58,482.00 80,165.00 1,377,408.30 1,297,243.30 5.82% Other Uses 452002 - Allocations-Admin Cost - 30,633.42 - 30,633.42 367,601.00 336,967.58 8.33% 452003 - Allocations-IT - 13,815.75 - 13,815.75 165,789.00 151,973.25 8.33% 452004 - Allocations-Liability Insurance - 14,832.08 - 14,832.08 177,985.00 163,152.92 8.33% 452009 - Allocations-Facilities Mgmt - 2,136.75 - 2,136.75 25,641.00 23,504.25 8.33% Total Other Uses - 61,418.00 - 61,418.00 737,016.00 675,598.00 8.33% Total Expenses 724,599.62 1,954,162.73 393,214.28 2,347,377.01 10,205,628.47 7,858,251.46 23.00%