Loading...
HomeMy WebLinkAboutOct 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 2,987.00 26,959.59 - (26,959.59) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% Total Culture & Recreation 2,987.00 101,959.59 77,000.00 (24,959.59) 132.42% Total Charges for Services 2,987.00 101,959.59 77,000.00 (24,959.59) 132.42% Miscellaneous Revenue 360000 - Miscellaneous - 2,000.00 - (2,000.00) 0.00% 360001 - Sale of Scrap Metal 195.31 1,319.42 - (1,319.42) 0.00% 360011 - Settlement Fees - 50,450.00 - (50,450.00) 0.00% Total Miscellaneous Revenue 195.31 53,769.42 - (53,769.42) 0.00% Refunds & Reimbursements 380000 - Misc Reimbursements 246.62 45,364.79 45,000.00 (364.79) 100.81% 396000 - Refunds 2,268.30 2,487.42 - (2,487.42) 0.00% Total Refunds & Reimbursements 2,514.92 47,852.21 45,000.00 (2,852.21) 106.34% 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 5,697.23 249,351.22 122,000.00 (127,351.22) 204.39% 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 73,974.23 769,207.53 - 769,207.53 913,867.00 144,659.47 84.17% 410002 - Teamster Wages 41,236.51 1,089,423.10 - 1,089,423.10 1,347,281.00 257,857.90 80.86% 410003 - Permanent Part Time 33,285.78 368,522.02 - 368,522.02 260,000.00 (108,522.02) 141.74% 410004 - Extra & Overtime 4,536.11 91,136.39 - 91,136.39 56,300.00 (34,836.39) 161.88% 410005 - Seasonal & Interns 32,648.21 326,088.27 - 326,088.27 300,000.00 (26,088.27) 108.70% 410007 - Longevity Pay - 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 185,680.84 2,652,278.47 - 2,652,278.47 2,886,037.00 233,758.53 91.90% Employee Benefits 411001 - FICA Regular 13,696.03 197,284.81 - 197,284.81 222,609.00 25,324.19 88.62% 411004 - PERF Regular 13,414.57 213,018.96 - 213,018.96 263,192.00 50,173.04 80.94% 411005 - PERF Union 478.36 10,915.21 - 10,915.21 21,452.00 10,536.79 50.88% 411007 - Unemployment Comp 12.44 209.30 - 209.30 2,793.00 2,583.70 7.49% 411008 - Health Insurance 29,629.50 457,110.08 - 457,110.08 616,458.00 159,347.92 74.15% 411009 - Life Insurance 290.00 4,250.00 - 4,250.00 5,280.00 1,030.00 80.49% 411010 - Med/Surgical/Dental 281.49 5,142.30 - 5,142.30 - (5,142.30) 0.00% 411014 - Parental Leave 418.36 6,781.88 - 6,781.88 8,145.00 1,363.12 83.26% 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 699.72 3,664.67 - 3,664.67 3,644.00 (20.67) 100.57% 411203 - Job Readiness Allow. (531.25) (1,381.25) - (1,381.25) 12,750.00 14,131.25 (10.83%) 411206 - Cell Phone Allowance 440.00 4,400.00 - 4,400.00 5,940.00 1,540.00 74.07% Total Employee Benefits 58,829.22 902,949.04 - 902,949.04 1,163,819.00 260,869.96 77.59% October 31, 2023 Total Personnel Expenses 244,510.06 3,555,227.51 - 3,555,227.51 4,049,856.00 494,628.49 87.79% Supplies Expenses Office Supplies 421000 - General Office Supplies 533.52 1,519.51 - 1,519.51 2,000.00 480.49 75.98% Total Office Supplies 533.52 1,519.51 - 1,519.51 2,000.00 480.49 75.98% Operating Supplies 422000 - Other Operating Supplies 19,174.27 151,684.22 16,136.77 167,820.99 161,387.69 (6,433.30) 103.99% 422001 - C.S. Gasoline 16,933.42 184,432.86 - 184,432.86 220,000.00 35,567.14 83.83% 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 4,011.00 0.06 100.00% 422007 - Cleaning Supplies 1,780.98 2,773.12 - 2,773.12 3,600.00 826.88 77.03% 422008 - Medical/Safety Supplies 2,638.60 12,557.32 - 12,557.32 13,104.00 546.68 95.83% 422010 - Plants Chemicals Seed & Fertilizer 17,409.40 94,870.50 15,193.83 110,064.33 120,455.00 10,390.67 91.37% Total Operating Supplies 57,936.67 452,477.90 31,330.60 483,808.50 525,360.94 41,552.44 92.09% Repair & Maintenance Supplies 423000 - Other R&M Supplies 11,339.60 152,124.99 6,000.52 158,125.51 182,634.88 24,509.37 86.58% 423001 - Building Materials 12,472.53 84,104.63 392.83 84,497.46 155,169.45 70,671.99 54.45% 423006 - Small Tools & Equipment 12,788.40 53,198.53 805.79 54,004.32 56,852.00 2,847.68 94.99% 423009 - Repair Parts 14,324.62 86,636.73 25,303.49 111,940.22 107,164.24 (4,775.98) 104.46% Total Repair & Maintenance Supplies 50,925.15 376,064.88 32,502.63 408,567.51 501,820.57 93,253.06 81.42% Total Supplies Expenses 109,395.34 830,062.29 63,833.23 893,895.52 1,029,181.51 135,285.99 86.85% Services & Charges Expenses Professional Services 431000 - Other Professional Services - 116,110.72 11,048.38 127,159.10 135,933.96 8,774.86 93.54% 431001 - Legal Services 2,102.50 14,186.00 14,494.50 28,680.50 29,000.00 319.50 98.90% 431009 - Computer & Technology - 7,789.95 - 7,789.95 8,275.00 485.05 94.14% 431014 - Collection Costs - 64.50 43.75 108.25 100.00 (8.25) 108.25% 431019 - Security Services 5,940.00 44,077.00 20,481.00 64,558.00 69,669.00 5,111.00 92.66% Total Professional Services 8,042.50 182,228.17 46,067.63 228,295.80 242,977.96 14,682.16 93.96% Communication & Transportation 432002 - Mailing - 9.67 - 9.67 104.00 94.33 9.30% 432003 - Travel - 2,251.85 254.50 2,506.35 5,617.50 3,111.15 44.62% 432004 - Telecommunications 58.48 1,109.79 1,885.01 2,994.80 11,587.41 8,592.61 25.85% Total Communication & Transportation 58.48 3,371.31 2,139.51 5,510.82 17,308.91 11,798.09 31.84% Printing & Advertising 433001 - Outside Printing Services 59.82 59.82 - 59.82 2,100.00 2,040.18 2.85% 433002 - Publication of Legal Notice 114.70 1,271.10 759.21 2,030.31 3,277.72 1,247.41 61.94% Total Printing & Advertising 174.52 1,330.92 759.21 2,090.13 5,377.72 3,287.59 38.87% Utilties 435001 - Electric 33,195.49 374,641.97 - 374,641.97 470,043.00 95,401.03 79.70% 435002 - Natural Gas 2,665.08 121,683.54 - 121,683.54 282,938.00 161,254.46 43.01% 435004 - Water 25,066.53 231,550.56 - 231,550.56 300,000.00 68,449.44 77.18% Total Utilities 60,927.10 727,876.07 - 727,876.07 1,052,981.00 325,104.93 69.13% Repairs & Maintenance 436000 - Other R&M 1,028.00 83,958.82 58,835.75 142,794.57 161,324.99 18,530.42 88.51% 436001 - Building R&M 34,378.75 412,196.43 60,463.29 472,659.72 484,177.60 11,517.88 97.62% 436003 - Auto Equip R&M 32,320.26 232,076.54 - 232,076.54 321,750.00 89,673.46 72.13% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 6,992.10 75.68 98.92% 436006 - Radio Equip R&M 3,888.26 25,412.08 - 25,412.08 16,814.00 (8,598.08) 151.14% 436011 - Exterminating 1,251.00 6,112.00 7,275.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 72,866.27 766,672.29 126,574.04 893,246.33 1,007,400.69 114,154.36 88.67% 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 30,723.87 77,230.17 40,329.31 117,559.48 90,627.23 (26,932.25) 129.72% 439001 - Other Contractual Services 15,690.10 145,760.00 7,608.40 153,368.40 206,625.00 53,256.60 74.23% 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 175.00 1,846.00 - 1,846.00 2,494.00 648.00 74.02% 439006 - Education & Training 675.36 12,568.45 7,334.12 19,902.57 25,029.00 5,126.43 79.52% 439009 - Trash Removal 5,259.76 36,455.62 3,041.34 39,496.96 42,493.15 2,996.19 92.95% 439012 - Uniform Services 1,445.87 17,618.85 - 17,618.85 25,941.00 8,322.15 67.92% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 53,969.96 308,945.13 58,313.17 367,258.30 410,698.38 43,440.08 89.42% Total Services & Charges Expenses 196,038.83 2,262,846.11 233,853.56 2,496,699.67 3,009,166.66 512,466.99 82.97% 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 - 599,918.83 362,446.66 962,365.49 1,047,863.30 85,497.81 91.84% Total Machinery & Equipment - 651,337.73 487,960.06 1,139,297.79 1,377,408.30 238,110.51 82.71% Total Capital Expenses - 651,337.73 487,960.06 1,139,297.79 1,377,408.30 238,110.51 82.71% Other Uses 452002 - Allocations-Admin Cost 30,633.42 306,334.20 - 306,334.20 367,601.00 61,266.80 83.33% 452003 - Allocations-IT 13,815.75 138,157.50 - 138,157.50 165,789.00 27,631.50 83.33% 452004 - Allocations-Liability Insurance 14,832.08 148,320.80 - 148,320.80 177,985.00 29,664.20 83.33% 452009 - Allocations-Facilities Mgmt 2,136.75 21,367.50 - 21,367.50 25,641.00 4,273.50 83.33% Total Other Uses 61,418.00 614,180.00 - 614,180.00 737,016.00 122,836.00 83.33% Total Expenses 611,362.23 7,913,653.64 785,646.85 8,699,300.49 10,202,628.47 1,503,327.98 85.27%