Loading...
HomeMy WebLinkAboutJan 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 3,853.54 3,853.54 - (3,853.54) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% Total Culture & Recreation 3,853.54 3,853.54 77,000.00 73,146.46 5.00% Total Charges for Services 3,853.54 3,853.54 77,000.00 73,146.46 5.00% Miscellaneous Revenue 360001 - Sale of Scrap Metal 32.40 32.40 - (32.40) 0.00% Total Miscellaneous Revenue 32.40 32.40 - (32.40) 0.00% Refunds & Reimbursements 380000 - Misc Reimbursements 51.13 51.13 - (51.13) 0.00% Total Refunds & Reimbursements 51.13 51.13 - (51.13) 0.00% Total Revenue 3,937.07 3,937.07 77,000.00 73,062.93 5.11% 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 63,956.27 63,956.27 - 63,956.27 913,867.00 849,910.73 7.00% 410002 - Teamster Wages 91,804.00 91,804.00 - 91,804.00 1,349,620.00 1,257,816.00 6.80% 410003 - Permanent Part Time 23,774.33 23,774.33 - 23,774.33 260,000.00 236,225.67 9.14% 410004 - Extra & Overtime 9,136.49 9,136.49 - 9,136.49 56,300.00 47,163.51 16.23% 410005 - Seasonal & Interns 7,875.02 7,875.02 - 7,875.02 300,000.00 292,124.98 2.63% 410007 - Longevity Pay 350.00 350.00 - 350.00 7,450.00 7,100.00 4.70% 410017 - Stand By Pay 398.06 398.06 - 398.06 - (398.06) 0.00% Total Salaries & Wages 197,294.17 197,294.17 - 197,294.17 2,887,237.00 2,689,942.83 6.83% Employee Benefits 411001 - FICA Regular 14,615.05 14,615.05 - 14,615.05 222,609.00 207,993.95 6.57% 411004 - PERF Regular 17,778.65 17,778.65 - 17,778.65 263,192.00 245,413.35 6.76% 411005 - PERF Union 1,024.81 1,024.81 - 1,024.81 21,452.00 20,427.19 4.78% 411007 - Unemployment Comp 18.10 18.10 - 18.10 2,793.00 2,774.90 0.65% 411008 - Health Insurance 45,214.66 45,214.66 - 45,214.66 616,458.00 571,243.34 7.33% 411009 - Life Insurance 415.00 415.00 - 415.00 5,280.00 4,865.00 7.86% 411010 - Med/Surgical/Dental 514.82 514.82 - 514.82 - (514.82) 0.00% 411014 - Parental Leave 579.11 579.11 - 579.11 8,145.00 7,565.89 7.11% 411015 - Other Fringe Benefits 1,200.00 1,200.00 - 1,200.00 - (1,200.00) 0.00% 411201 - Tool Allowance 894.67 894.67 - 894.67 4,000.00 3,105.33 22.37% 411203 - Job Readiness Allow. - - - - 12,750.00 12,750.00 0.00% 411206 - Cell Phone Allowance 440.00 440.00 - 440.00 5,940.00 5,500.00 7.41% Total Employee Benefits 82,694.87 82,694.87 - 82,694.87 1,162,619.00 1,079,924.13 7.11% Total Personnel Expenses 279,989.04 279,989.04 - 279,989.04 4,049,856.00 3,769,866.96 6.91% Supplies Expenses Office Supplies 421000 - General Office Supplies - - - - 2,000.00 2,000.00 0.00% Total Office Supplies - - - - 2,000.00 2,000.00 0.00% Operating Supplies January 31, 2023 422000 - Other Operating Supplies 1,898.34 1,898.34 10,845.76 12,744.10 364,387.69 351,643.59 3.50% 422001 - C.S. Gasoline - - - - 220,000.00 220,000.00 0.00% 422003 - Gasoline - - - - 667.00 667.00 0.00% 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 - - - - 600.00 600.00 0.00% 422008 - Medical/Safety Supplies - - - - 13,104.00 13,104.00 0.00% 422010 - Plants Chemicals Seed & Fertilizer - - 51,958.28 51,958.28 120,455.00 68,496.72 43.14% Total Operating Supplies 1,898.34 1,898.34 64,022.29 65,920.63 721,131.94 655,211.31 9.14% Repair & Maintenance Supplies 423000 - Other R&M Supplies 10,748.64 10,748.64 15,909.50 26,658.14 256,863.88 230,205.74 10.38% 423001 - Building Materials 669.45 669.45 7,641.06 8,310.51 145,169.45 136,858.94 5.72% 423006 - Small Tools & Equipment 1,154.56 1,154.56 - 1,154.56 26,852.00 25,697.44 4.30% 423009 - Repair Parts 1,240.51 1,240.51 2,141.68 3,382.19 77,164.24 73,782.05 4.38% Total Repair & Maintenance Supplies 13,813.16 13,813.16 25,692.24 39,505.40 506,049.57 466,544.17 7.81% Total Supplies Expenses 15,711.50 15,711.50 89,714.53 105,426.03 1,229,181.51 1,123,755.48 8.58% Services & Charges Expenses Professional Services 431000 - Other Professional Services 45.00 45.00 60,013.96 60,058.96 70,933.96 10,875.00 84.67% 431009 - Computer & Technology - - 7,750.00 7,750.00 8,275.00 525.00 93.66% 431019 - Security Services - - 976.00 976.00 1,669.00 693.00 58.48% Total Professional Services 45.00 45.00 68,739.96 68,784.96 80,877.96 12,093.00 85.05% Communication & Transportation 432003 - Travel - - 299.47 299.47 6,617.50 6,318.03 4.53% 432004 - Telecommunications - - 2,237.41 2,237.41 11,687.41 9,450.00 19.14% Total Communication & Transportation - - 2,536.88 2,536.88 18,304.91 15,768.03 13.86% Printing & Advertising 433001 - Outside Printing Services - - - - 2,100.00 2,100.00 0.00% 433002 - Publication of Legal Notice - - 1,523.41 1,523.41 3,277.72 1,754.31 46.48% Total Printing & Advertising - - 1,523.41 1,523.41 5,377.72 3,854.31 28.33% Utilties 435001 - Electric 35,677.78 35,677.78 - 35,677.78 470,043.00 434,365.22 7.59% 435002 - Natural Gas 30,440.86 30,440.86 - 30,440.86 282,938.00 252,497.14 10.76% 435004 - Water 7,971.78 7,971.78 - 7,971.78 300,000.00 292,028.22 2.66% Total Utilities 74,090.42 74,090.42 - 74,090.42 1,052,981.00 978,890.58 7.04% Repairs & Maintenance 436000 - Other R&M 693.00 693.00 7,921.00 8,614.00 302,942.99 294,328.99 2.84% 436001 - Building R&M 34,037.18 34,037.18 87,661.44 121,698.62 354,902.60 233,203.98 34.29% 436003 - Auto Equip R&M - - - - 351,750.00 351,750.00 0.00% 436005 - Other Equip R&M 3,409.34 3,409.34 3,507.08 6,916.42 2,992.10 (3,924.32) 231.16% 436006 - Radio Equip R&M - - - - 7,200.00 7,200.00 0.00% 436011 - Exterminating 554.00 554.00 1,763.00 2,317.00 16,342.00 14,025.00 14.18% Total Repairs & Maintenance 38,693.52 38,693.52 100,852.52 139,546.04 1,036,129.69 896,583.65 13.47% Debt Service 438100 - Principal 122,623.28 122,623.28 - 122,623.28 246,687.00 124,063.72 49.71% 438200 - Interest 13,587.83 13,587.83 - 13,587.83 25,735.00 12,147.17 52.80% Total Debt Service 136,211.11 136,211.11 - 136,211.11 272,422.00 136,210.89 50.00% Other Charges & Services 439000 - Misc Charges & Svcs 9,983.00 9,983.00 14,732.23 24,715.23 25,627.23 912.00 96.44% 439001 - Other Contractual Services - - - - 200,000.00 200,000.00 0.00% 439002 - Licenses & Permits - - - - 1,208.00 1,208.00 0.00% 439003 - Subscriptions 194.61 194.61 - 194.61 1,281.00 1,086.39 15.19% 439004 - Dues & Memberships - - 495.00 495.00 2,494.00 1,999.00 19.85% 439006 - Education & Training - - 1,229.00 1,229.00 12,029.00 10,800.00 10.22% 439009 - Trash Removal 1,711.48 1,711.48 2,469.46 4,180.94 32,493.15 28,312.21 12.87% 439012 - Uniform Services - - - - 15,941.00 15,941.00 0.00% 439300 - Grants & Subsidies - - - - 15,000.00 15,000.00 0.00% Total Other Services & Charges 11,889.09 11,889.09 18,925.69 30,814.78 306,073.38 275,258.60 10.07% Total Services & Charges Expenses 260,929.14 260,929.14 192,578.46 453,507.60 2,772,166.66 2,318,659.06 16.36% Capital Outlay Machinery & Equipment 445003 - Park Equipment - - 9,045.00 9,045.00 264,545.00 255,500.00 3.42% 445100 - Lease Purchase/Motor Equip - - 6,750.00 6,750.00 1,047,863.30 1,041,113.30 0.64% Total Machinery & Equipment - - 15,795.00 15,795.00 1,312,408.30 1,296,613.30 1.20% Total Capital Expenses - - 15,795.00 15,795.00 1,312,408.30 1,296,613.30 1.20% Other Uses 452002 - Allocations-Admin Cost - - - - 367,601.00 367,601.00 0.00% 452003 - Allocations-IT - - - - 165,789.00 165,789.00 0.00% 452004 - Allocations-Liability Insurance - - - - 177,985.00 177,985.00 0.00% 452009 - Allocations-Facilities Mgmt - - - - 25,641.00 25,641.00 0.00% Total Other Uses - - - - 737,016.00 737,016.00 0.00% Total Expenses 556,629.68 556,629.68 298,087.99 854,717.67 10,100,628.47 9,245,910.80 8.46%