Loading...
HomeMy WebLinkAboutSept 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 - 100.00% 347021 - Tree Maintenance 1,644.00 23,972.59 - (23,972.59) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% Total Culture & Recreation 1,644.00 98,972.59 77,000.00 (21,972.59) 128.54% Total Charges for Services 1,644.00 98,972.59 77,000.00 (21,972.59) 128.54% Miscellaneous Revenue 360000 - Miscellaneous - 2,000.00 - (2,000.00) 0.00% 360001 - Sale of Scrap Metal 159.38 1,124.11 - (1,124.11) 0.00% 360011 - Settlement Fees - 50,450.00 - (50,450.00) 0.00% Total Miscellaneous Revenue 159.38 53,574.11 - (53,574.11) 0.00% Refunds & Reimbursements 380000 - Misc Reimbursements - 45,118.17 45,000.00 (118.17) 100.26% 396000 - Refunds - 219.12 - (219.12) 0.00% Total Refunds & Reimbursements - 45,337.29 45,000.00 (337.29) 100.75% Other Sources 392000 - Gain/Loss on Sale of Asset - 37,352.00 - (37,352.00) 0.00% 392005 - Sale of Non-Capital Assets - 8,418.00 - (8,418.00) 0.00% Total Other Sources - 45,770.00 - (45,770.00) 0.00% Total Revenue 1,803.38 243,653.99 122,000.00 (121,653.99) 199.72% 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 110,961.32 695,233.30 - 695,233.30 913,867.00 218,633.70 76.08% 410002 - Teamster Wages 151,652.79 1,048,186.59 - 1,048,186.59 1,347,281.00 299,094.41 77.80% 410003 - Permanent Part Time 59,484.36 335,236.24 - 335,236.24 260,000.00 (75,236.24) 128.94% 410004 - Extra & Overtime 18,206.60 86,600.28 - 86,600.28 56,300.00 (30,300.28) 153.82% 410005 - Seasonal & Interns 56,337.74 293,440.06 - 293,440.06 300,000.00 6,559.94 97.81% 410007 - Longevity Pay 850.00 5,387.50 - 5,387.50 8,589.00 3,201.50 62.73% 410017 - Stand By Pay - 2,513.66 - 2,513.66 - (2,513.66) 0.00% Total Salaries & Wages 397,492.81 2,466,597.63 - 2,466,597.63 2,886,037.00 419,439.37 85.47% Employee Benefits 411001 - FICA Regular 30,034.38 183,588.78 - 183,588.78 222,609.00 39,020.22 82.47% 411004 - PERF Regular 31,115.71 199,604.39 - 199,604.39 263,192.00 63,587.61 75.84% 411005 - PERF Union 1,552.28 10,436.85 - 10,436.85 21,452.00 11,015.15 48.65% 411007 - Unemployment Comp 30.06 196.86 - 196.86 2,793.00 2,596.14 7.05% 411008 - Health Insurance 48,150.70 427,480.58 - 427,480.58 616,458.00 188,977.42 69.34% 411009 - Life Insurance 450.00 3,960.00 - 3,960.00 5,280.00 1,320.00 75.00% 411010 - Med/Surgical/Dental 544.30 4,860.81 - 4,860.81 - (4,860.81) 0.00% 411014 - Parental Leave 981.83 6,363.52 - 6,363.52 8,145.00 1,781.48 78.13% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411200 - Clothing Allowance - 353.08 - 353.08 356.00 2.92 99.18% 411201 - Tool Allowance - 2,964.95 500.00 3,464.95 3,644.00 179.05 95.09% 411203 - Job Readiness Allow. - (850.00) - (850.00) 12,750.00 13,600.00 (6.67%) 411206 - Cell Phone Allowance 440.00 3,960.00 - 3,960.00 5,940.00 1,980.00 66.67% Total Employee Benefits 113,299.26 844,119.82 500.00 844,619.82 1,163,819.00 319,199.18 72.57% September 30, 2023 Total Personnel Expenses 510,792.07 3,310,717.45 500.00 3,311,217.45 4,049,856.00 738,638.55 81.76% Supplies Expenses Office Supplies 421000 - General Office Supplies 349.99 985.99 - 985.99 2,000.00 1,014.01 49.30% Total Office Supplies 349.99 985.99 - 985.99 2,000.00 1,014.01 49.30% Operating Supplies 422000 - Other Operating Supplies 9,910.94 132,509.95 17,091.99 149,601.94 161,387.69 11,785.75 92.70% 422001 - C.S. Gasoline 17,665.84 167,499.44 - 167,499.44 220,000.00 52,500.56 76.14% 422003 - Gasoline - 13.11 - 13.11 667.00 653.89 1.97% 422005 - Uniforms - 2,135.83 - 2,135.83 2,136.25 0.42 99.98% 422006 - Computer Supplies & Equipment - 4,010.94 - 4,010.94 3,924.00 (86.94) 102.22% 422007 - Cleaning Supplies 89.83 992.14 - 992.14 3,600.00 2,607.86 27.56% 422008 - Medical/Safety Supplies 434.39 9,918.72 2,318.03 12,236.75 13,104.00 867.25 93.38% 422010 - Plants Chemicals Seed & Fertilizer 3,616.65 77,461.10 9,604.45 87,065.55 120,455.00 33,389.45 72.28% Total Operating Supplies 31,717.65 394,541.23 29,014.47 423,555.70 525,273.94 101,718.24 80.64% Repair & Maintenance Supplies 423000 - Other R&M Supplies 3,262.54 140,651.01 9,275.79 149,926.80 232,721.88 82,795.08 64.42% 423001 - Building Materials 1,048.18 71,632.10 18,530.36 90,162.46 145,169.45 55,006.99 62.11% 423006 - Small Tools & Equipment 1,581.54 40,410.13 9,306.68 49,716.81 46,852.00 (2,864.81) 106.11% 423009 - Repair Parts 3,446.48 71,922.34 26,542.76 98,465.10 77,164.24 (21,300.86) 127.60% Total Repair & Maintenance Supplies 9,338.74 324,615.58 63,655.59 388,271.17 501,907.57 113,636.40 77.36% Total Supplies Expenses 41,406.38 720,142.80 92,670.06 812,812.86 1,029,181.51 216,368.65 78.98% Services & Charges Expenses Professional Services 431000 - Other Professional Services 775.00 116,110.72 9,298.38 125,409.10 135,933.96 10,524.86 92.26% 431001 - Legal Services 8,403.00 12,083.50 16,597.00 28,680.50 29,000.00 319.50 98.90% 431009 - Computer & Technology 39.95 7,789.95 - 7,789.95 8,275.00 485.05 94.14% 431014 - Collection Costs - 64.50 - 64.50 100.00 35.50 64.50% 431019 - Security Services 6,215.00 38,137.00 6,421.00 44,558.00 69,669.00 25,111.00 63.96% Total Professional Services 15,432.95 174,185.67 32,316.38 206,502.05 242,977.96 36,475.91 84.99% Communication & Transportation 432002 - Mailing - 9.67 - 9.67 104.00 94.33 9.30% 432003 - Travel - 2,251.85 3,040.32 5,292.17 3,617.50 (1,674.67) 146.29% 432004 - Telecommunications 58.48 1,051.31 1,943.49 2,994.80 11,587.41 8,592.61 25.85% Total Communication & Transportation 58.48 3,312.83 4,983.81 8,296.64 15,308.91 7,012.27 54.19% Printing & Advertising 433001 - Outside Printing Services - - - - 2,100.00 2,100.00 0.00% 433002 - Publication of Legal Notice 118.40 1,156.40 797.69 1,954.09 3,277.72 1,323.63 59.62% Total Printing & Advertising 118.40 1,156.40 797.69 1,954.09 5,377.72 3,423.63 36.34% Utilties 435001 - Electric 34,624.36 341,446.48 - 341,446.48 470,043.00 128,596.52 72.64% 435002 - Natural Gas 2,101.08 119,018.46 - 119,018.46 282,938.00 163,919.54 42.07% 435004 - Water 34,768.53 206,484.03 - 206,484.03 300,000.00 93,515.97 68.83% Total Utilities 71,493.97 666,948.97 - 666,948.97 1,052,981.00 386,032.03 63.34% Repairs & Maintenance 436000 - Other R&M 22,256.85 82,930.82 36,797.00 119,727.82 186,324.99 66,597.17 64.26% 436001 - Building R&M 31,301.05 377,817.68 86,266.44 464,084.12 481,902.60 17,818.48 96.30% 436003 - Auto Equip R&M 15,549.77 199,756.28 - 199,756.28 346,750.00 146,993.72 57.61% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 6,992.10 75.68 98.92% 436006 - Radio Equip R&M 4,808.91 21,523.82 - 21,523.82 16,814.00 (4,709.82) 128.01% 436011 - Exterminating 1,031.00 4,861.00 8,526.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 74,947.58 693,806.02 131,589.44 825,395.46 1,055,125.69 229,730.23 78.23% Debt Service 438100 - Principal - 246,686.77 - 246,686.77 246,687.00 0.23 100.00% 438200 - Interest - 25,735.45 - 25,735.45 25,735.00 (0.45) 100.00% Total Debt Service - 272,422.22 - 272,422.22 272,422.00 (0.22) 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 7,336.90 46,506.30 71,189.48 117,695.78 90,627.23 (27,068.55) 129.87% 439001 - Other Contractual Services 27,696.72 130,069.90 20,543.49 150,613.39 165,900.00 15,286.61 90.79% 439002 - Licenses & Permits - 1,200.00 - 1,200.00 1,208.00 8.00 99.34% 439003 - Subscriptions - 1,266.04 - 1,266.04 1,281.00 14.96 98.83% 439004 - Dues & Memberships - 1,671.00 - 1,671.00 2,494.00 823.00 67.00% 439006 - Education & Training 591.88 11,893.09 11,157.28 23,050.37 20,029.00 (3,021.37) 115.08% 439009 - Trash Removal 3,336.51 31,195.86 5,676.28 36,872.14 42,493.15 5,621.01 86.77% 439012 - Uniform Services 1,824.09 16,172.98 - 16,172.98 25,941.00 9,768.02 62.35% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 40,786.10 254,975.17 108,566.53 363,541.70 364,973.38 1,431.68 99.61% Total Services & Charges Expenses 202,837.48 2,066,807.28 278,253.85 2,345,061.13 3,009,166.66 664,105.53 77.93% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - - - 21,726.00 21,726.00 0.00% 445003 - Park Equipment - 51,418.90 125,513.40 176,932.30 307,819.00 130,886.70 57.48% 445100 - Lease Purchase/Motor Equip 73,853.00 599,918.83 177,009.00 776,927.83 1,047,863.30 270,935.47 74.14% Total Machinery & Equipment 73,853.00 651,337.73 302,522.40 953,860.13 1,377,408.30 423,548.17 69.25% Total Capital Expenses 73,853.00 651,337.73 302,522.40 953,860.13 1,377,408.30 423,548.17 69.25% Other Uses 452002 - Allocations-Admin Cost - 245,067.36 - 245,067.36 367,601.00 122,533.64 66.67% 452003 - Allocations-IT - 110,526.00 - 110,526.00 165,789.00 55,263.00 66.67% 452004 - Allocations-Liability Insurance - 118,656.64 - 118,656.64 177,985.00 59,328.36 66.67% 452009 - Allocations-Facilities Mgmt - 17,094.00 - 17,094.00 25,641.00 8,547.00 66.67% Total Other Uses - 491,344.00 - 491,344.00 737,016.00 245,672.00 66.67% Total Expenses 828,888.93 7,240,349.26 673,946.31 7,914,295.57 10,202,628.47 2,288,332.90 77.57%