Loading...
HomeMy WebLinkAboutOct 20 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 - 45,000.00 75,000.00 30,000.00 40.00% 347019 - Site Mowing 13,900.80 108,979.20 95,000.00 (13,979.20) (14.71%) 347021 - Tree Maintenance 98,781.58 151,297.64 160,000.00 8,702.36 5.44% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% Total Culture & Recreation 112,682.38 305,276.84 432,529.00 127,252.16 29.42% Total Charges for Services 112,682.38 305,276.84 432,529.00 127,252.16 29.42% Miscellaneous Revenue 360000 - Miscellaneous 69.27 2,825.64 10,000.00 7,174.36 71.74% 367000 - Donations from Private Sources 4,000.00 4,000.00 - (4,000.00) 0.00% Total Miscellaneous Revenue 4,069.27 6,825.64 10,000.00 3,174.36 31.74% Refunds & Reimbursements 380000 - Misc Reimbursements 2,913.50 3,823.12 - (3,823.12) 0.00% 381000 - Misc Reimbursements - 1,055.99 1,056.00 0.01 0.00% Total Refunds & Reimbursements 2,913.50 4,879.11 1,056.00 (3,823.11) (362.04%) Other Sources 392000 - Gain/Loss on Sale of Asset - 2,162.00 2,162.00 - 0.00% 392005 - Sale of Non-Capital Assets - 11,270.00 11,270.00 - 0.00% Total Other Sources - 13,432.00 13,432.00 - 0.00% Total Revenue 119,665.15 330,413.59 457,017.00 126,603.41 27.70% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 87,865.07 667,030.57 - 667,030.57 799,449.00 132,418.43 16.56% 410002 - Teamster Wages 158,176.62 1,170,639.10 - 1,170,639.10 1,340,141.00 169,501.90 12.65% 410003 - Permanent Part Time 39,327.49 307,855.29 - 307,855.29 290,000.00 (17,855.29) (6.16%) 410004 - Extra & Overtime 5,649.94 54,501.73 - 54,501.73 71,300.00 16,798.27 23.56% 410005 - Seasonal & Interns 40,527.66 221,555.52 - 221,555.52 233,000.00 11,444.48 4.91% 410007 - Longevity Pay 950.00 6,500.00 - 6,500.00 7,450.00 950.00 12.75% Total Salaries & Wages 332,496.78 2,428,082.21 - 2,428,082.21 2,741,340.00 313,257.79 11.43% Employee Benefits 411001 - FICA Regular 25,016.46 180,545.89 - 180,545.89 214,756.00 34,210.11 15.93% 411004 - PERF Regular 28,045.81 208,818.60 - 208,818.60 254,336.00 45,517.40 17.90% 411005 - PERF Union 1,954.14 14,741.32 - 14,741.32 21,335.00 6,593.68 30.91% 411007 - Unemployment Comp 25.24 190.15 - 190.15 225.00 34.85 15.49% 411008 - Health Insurance 48,769.62 479,239.69 - 479,239.69 580,689.00 101,449.31 17.47% 411009 - Life Insurance 480.02 4,725.20 - 4,725.20 5,690.00 964.80 16.96% 411014 - Parental Leave 884.03 6,638.38 - 6,638.38 7,887.00 1,248.62 15.83% 411200 - Clothing Allowance - 123.04 - 123.04 200.00 76.96 38.48% 411201 - Tool Allowance 991.70 1,754.35 515.29 2,269.64 4,228.00 1,958.36 46.32% 411203 - Job Readiness Allow. - 13,918.75 - 13,918.75 14,450.00 531.25 3.68% 411206 - Cell Phone Allowance 495.00 5,170.00 - 5,170.00 6,160.00 990.00 16.07% Total Employee Benefits 106,662.02 915,865.37 515.29 916,380.66 1,109,956.00 193,575.34 17.44% Total Personnel Expenditures 439,158.80 3,343,947.58 515.29 3,344,462.87 3,851,296.00 506,833.13 13.16% October 31, 2020 Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 400.25 70.00 470.25 500.00 29.75 5.95% 421002 - Stationary & Printing - - 2,819.00 2,819.00 5,000.00 2,181.00 43.62% Total Office Supplies - 400.25 2,889.00 3,289.25 5,500.00 2,210.75 40.20% Operating Supplies 422000 - Other Operating Supplies 11,867.82 136,225.55 41,936.96 178,162.51 172,931.00 (5,231.51) (3.03%) 422001 - C.S. Gasoline 9,588.47 95,667.40 - 95,667.40 165,000.00 69,332.60 42.02% 422003 - Gasoline - - - - 3,196.00 3,196.00 100.00% 422004 - Oil - 957.85 - 957.85 1,000.00 42.15 4.22% 422005 - Uniforms - 11,360.45 - 11,360.45 22,000.00 10,639.55 48.36% 422007 - Cleaning Supplies - 193.28 - 193.28 100.00 (93.28) (93.28%) 422008 - Medical/Safety Supplies 157.72 6,034.41 113.84 6,148.25 6,573.00 424.75 6.46% 422010 - Plants Chemicals Seed & Fertilizer 2,241.17 41,345.82 18,444.33 59,790.15 75,990.00 16,199.85 21.32% Total Operating Supplies 23,855.18 291,784.76 60,495.13 352,279.89 446,790.00 94,510.11 21.15% Repair & Maintenance Supplies 423000 - Other R&M Supplies 5,191.57 52,144.08 137,929.59 190,073.67 156,429.00 (33,644.67) (21.51%) 423001 - Building Materials 1,382.02 55,711.37 5,273.73 60,985.10 89,868.00 28,882.90 32.14% 423006 - Small Tools & Equipment 695.46 16,944.02 2,848.86 19,792.88 30,053.00 10,260.12 34.14% 423009 - Repair Parts 4,205.21 47,418.25 7,966.21 55,384.46 65,179.00 9,794.54 15.03% Total Repair & Maintenance Supplies 11,474.26 172,217.72 154,018.39 326,236.11 341,529.00 15,292.89 4.48% Total Supplies Expenditures 35,329.44 464,402.73 217,402.52 681,805.25 793,819.00 112,013.75 14.11% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 554.34 3,020.20 8,857.14 11,877.34 1,000.00 (10,877.34) (1087.73%) 431009 - Computer & Technology - 403.44 - 403.44 500.00 96.56 19.31% 431014 - Collection Costs 75.00 75.00 - 75.00 500.00 425.00 85.00% Total Professional Services 629.34 3,498.64 8,857.14 12,355.78 2,000.00 (10,355.78) (517.79%) Communication & Transportation 432000 - Other Communication/Transp. - 24.00 - 24.00 - (24.00) 0.00% 432002 - Mailing - 8.40 - 8.40 500.00 491.60 98.32% 432003 - Travel - 842.64 - 842.64 2,250.00 1,407.36 62.55% 432004 - Telecommunications - 1,383.67 - 1,383.67 7,000.00 5,616.33 80.23% Total Communication & Transportation - 2,258.71 - 2,258.71 9,750.00 7,491.29 76.83% Printing & Advertising 433001 - Outside Printing Services 89.00 237.32 - 237.32 1,733.00 1,495.68 86.31% 433002 - Publication of Legal Notice - 277.97 1,900.86 2,178.83 3,000.00 821.17 27.37% Total Printing & Advertising 89.00 515.29 1,900.86 2,416.15 4,733.00 2,316.85 48.95% Utilties 435001 - Electric 17,479.66 355,784.12 - 355,784.12 424,093.00 68,308.88 16.11% 435002 - Natural Gas 210.23 62,171.89 - 62,171.89 100,556.00 38,384.11 38.17% 435004 - Water 31,662.87 187,711.98 20,287.50 207,999.48 198,000.00 (9,999.48) (5.05%) Total Utilities 49,352.76 605,667.99 20,287.50 625,955.49 722,649.00 96,693.51 13.38% Repairs & Maintenance 436000 - Other R&M - 64,150.34 40,081.24 104,231.58 67,308.00 (36,923.58) (54.86%) 436001 - Building R&M 4,566.44 47,951.95 4,562.74 52,514.69 87,284.00 34,769.31 39.83% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 30,029.49 327,129.99 - 327,129.99 240,000.00 (87,129.99) (36.30%) 436005 - Other Equip R&M - 999.80 - 999.80 6,710.00 5,710.20 85.10% 436006 - Radio Equip R&M 1,978.74 10,870.06 1,996.00 12,866.06 16,500.00 3,633.94 22.02% 436011 - Exterminating 532.50 3,275.00 3,126.00 6,401.00 7,500.00 1,099.00 14.65% Total Repairs & Maintenance 37,107.17 454,377.14 49,765.98 504,143.12 433,802.00 (70,341.12) (16.22%) Debt Service 438100 - Principal 104,605.19 261,217.91 - 261,217.91 297,875.00 36,657.09 12.31% 438200 - Interest 2,341.01 6,423.32 - 6,423.32 11,978.00 5,554.68 46.37% Total Debt Service 106,946.20 267,641.23 - 267,641.23 309,853.00 42,211.77 13.62% Other Charges & Services 439000 - Misc Charges & Svcs 23,542.31 281,305.44 94,913.56 376,219.00 359,037.00 (17,182.00) (4.79%) 439001 - Other Contractual Services 279.53 1,605.35 3,429.93 5,035.28 - (5,035.28) 0.00% 439002 - Licenses & Permits - 131.98 - 131.98 - (131.98) 0.00% 439003 - Subscriptions - 65.00 - 65.00 745.00 680.00 91.28% 439004 - Dues & Memberships - 129.00 - 129.00 1,875.00 1,746.00 93.12% 439006 - Education & Training 555.00 6,993.99 1,380.00 8,373.99 15,075.00 6,701.01 44.45% 439009 - Trash Removal 671.53 16,436.10 5,916.14 22,352.24 32,973.00 10,620.76 32.21% Total Other Services & Charges 25,048.37 306,666.86 105,639.63 412,306.49 409,705.00 (2,601.49) (0.63%) Total Services & Charges Expenditures 219,172.84 1,640,625.86 186,451.11 1,827,076.97 1,892,492.00 65,415.03 3.46% 444000 - Land Improvements - 120,892.89 - 120,892.89 120,893.00 0.11 0.00% Other Uses 452002 - Allocations-Admin Cost 30,041.00 300,408.00 - 300,408.00 360,490.00 60,082.00 16.67% 452009 - Allocations-Facilities Mgmt 1,195.00 11,952.00 - 11,952.00 14,342.00 2,390.00 16.66% Total Other Uses 31,236.00 312,360.00 - 312,360.00 374,832.00 62,472.00 16.67% Total Expenditures 724,897.08 5,761,336.17 404,368.92 6,165,705.09 6,912,439.00 746,733.91 10.80%