Loading...
HomeMy WebLinkAboutOct 22 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 - 75,000.00 75,000.00 - 100.00% 347019 - Site Mowing - 117,974.10 222,839.00 104,864.90 52.94% 347021 - Tree Maintenance 340.63 147,170.28 120,000.00 (27,170.28) 122.64% 347023 - Graffiti Removal - 4,930.26 - (4,930.26) 0.00% Total Culture & Recreation 340.63 345,074.64 417,839.00 72,764.36 82.59% Total Charges for Services 340.63 345,074.64 417,839.00 72,764.36 82.59% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal 103.75 1,028.82 - (1,028.82) 0.00% 360011 - Settlement Fees 80,000.00 80,000.00 - (80,000.00) 0.00% 367000 - Donations from Private Sources - 7,867.50 - (7,867.50) 0.00% Total Miscellaneous Revenue 80,103.75 88,896.32 2,000.00 (86,896.32) 4444.82% Refunds & Reimbursements 380000 - Misc Reimbursements 89.10 246.59 - (246.59) 0.00% 380007 - Energy Rebates - 808.98 809.00 0.02 100.00% 381000 - Misc Reimbursements - 4,916.40 245,441.00 240,524.60 2.00% 396000 - Refunds - 38,342.92 37,603.00 (739.92) 101.97% Total Refunds & Reimbursements 89.10 44,314.89 283,853.00 239,538.11 15.61% Other Sources 392000 - Gain/Loss on Sale of Asset - 53,682.00 - (53,682.00) 0.00% 392005 - Sale of Non-Capital Assets - 11,776.00 - (11,776.00) 0.00% 393000 - Capital Lease Proceeds - 1,290,000.00 1,290,000.00 - 100.00% Total Other Sources - 1,355,458.00 1,290,000.00 (65,458.00) 105.07% Total Revenue 80,533.48 1,833,743.85 1,993,692.00 159,948.15 91.98% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 60,590.56 663,744.21 - 663,744.21 820,100.00 156,355.79 80.93% 410002 - Teamster Wages 102,241.38 1,038,886.87 - 1,038,886.87 1,271,200.00 232,313.13 81.72% 410003 - Permanent Part Time 38,592.79 299,353.09 - 299,353.09 255,000.00 (44,353.09) 117.39% 410004 - Extra & Overtime 11,355.29 93,863.07 - 93,863.07 66,300.00 (27,563.07) 141.57% 410005 - Seasonal & Interns 24,846.73 284,375.16 - 284,375.16 300,000.00 15,624.84 94.79% 410007 - Longevity Pay 350.00 5,633.32 - 5,633.32 7,450.00 1,816.68 75.62% 410014 - Contract Add Pays - - - - - - 0.00% 410017 - Stand By Pay 22.15 2,374.63 - 2,374.63 3,500.00 1,125.37 67.85% Total Salaries & Wages 237,998.90 2,388,230.35 - 2,388,230.35 2,723,550.00 335,319.65 87.69% Employee Benefits 411001 - FICA Regular 17,584.14 185,603.35 - 185,603.35 210,409.00 24,805.65 88.21% 411004 - PERF Regular 18,367.76 202,749.50 - 202,749.50 245,889.00 43,139.50 82.46% 411005 - PERF Union 1,190.39 13,428.32 - 13,428.32 20,541.00 7,112.68 65.37% 411007 - Unemployment Comp 18.48 2,258.40 - 2,258.40 3,472.00 1,213.60 65.05% 411008 - Health Insurance 48,364.16 447,194.00 - 447,194.00 582,882.00 135,688.00 76.72% 411009 - Life Insurance 440.00 4,150.00 - 4,150.00 5,160.00 1,010.00 80.43% 411014 - Parental Leave 599.52 6,264.01 - 6,264.01 7,594.00 1,329.99 82.49% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance 562.55 3,980.24 - 3,980.24 4,000.00 19.76 99.51% October 31, 2022 411203 - Job Readiness Allow. - 12,325.00 - 12,325.00 15,750.00 3,425.00 78.25% 411206 - Cell Phone Allowance 440.00 4,400.00 - 4,400.00 5,940.00 1,540.00 74.07% Total Employee Benefits 87,567.00 883,552.82 - 883,552.82 1,102,837.00 219,284.18 80.12% Total Personnel Expenses 325,565.90 3,271,783.17 - 3,271,783.17 3,826,387.00 554,603.83 85.51% Supplies Expenses Office Supplies 421000 - General Office Supplies 7.99 3,494.10 958.25 4,452.35 5,000.00 547.65 89.05% Total Office Supplies 7.99 3,494.10 958.25 4,452.35 5,000.00 547.65 89.05% Operating Supplies 422000 - Other Operating Supplies 12,326.51 168,147.10 24,155.32 192,302.42 185,081.45 (7,220.97) 103.90% 422001 - C.S. Gasoline 15,753.28 203,721.19 - 203,721.19 165,000.00 (38,721.19) 123.47% 422003 - Gasoline - - 50.00 50.00 2,405.00 2,355.00 2.08% 422004 - Oil - 35.30 - 35.30 50.00 14.70 70.60% 422005 - Uniforms - - 1,218.25 1,218.25 3,000.00 1,781.75 40.61% 422006 - Computer Supplies & Equipment - 384.82 - 384.82 500.00 115.18 76.96% 422007 - Cleaning Supplies - 4,024.06 - 4,024.06 4,550.00 525.94 88.44% 422008 - Medical/Safety Supplies 1,934.88 14,862.19 - 14,862.19 12,980.00 (1,882.19) 114.50% 422010 - Plants Chemicals Seed & Fertilizer 13,283.09 60,497.29 5,564.57 66,061.86 85,975.00 19,913.14 76.84% Total Operating Supplies 43,297.76 451,671.95 30,988.14 482,660.09 459,541.45 (23,118.64) 105.03% Repair & Maintenance Supplies 423000 - Other R&M Supplies 9,874.01 154,196.83 21,826.84 176,023.67 184,174.41 8,150.74 95.57% 423001 - Building Materials 744.80 60,712.22 2,658.00 63,370.22 81,000.00 17,629.78 78.23% 423006 - Small Tools & Equipment 1,688.95 22,547.06 - 22,547.06 25,573.00 3,025.94 88.17% 423009 - Repair Parts 2,620.33 48,905.25 11,973.71 60,878.96 79,729.03 18,850.07 76.36% Total Repair & Maintenance Supplies 14,928.09 286,361.36 36,458.55 322,819.91 370,476.44 47,656.53 87.14% Total Supplies Expenses 58,233.84 741,527.41 68,404.94 809,932.35 835,017.89 25,085.54 97.00% Services & Charges Expenses Professional Services 431000 - Other Professional Services 302.00 10,926.00 66,172.50 77,098.50 78,000.00 901.50 98.84% 431009 - Computer & Technology - 31.83 - 31.83 500.00 468.17 6.37% 431014 - Collection Costs - 56.25 - 56.25 100.00 43.75 56.25% 431015 - Laboratory Water Testing 250.00 250.00 - 250.00 300.00 50.00 83.33% 431019 - Security Services 6,534.00 38,010.35 5,420.00 43,430.35 46,640.00 3,209.65 93.12% Total Professional Services 7,086.00 49,274.43 71,592.50 120,866.93 125,540.00 4,673.07 96.28% Communication & Transportation 432003 - Travel - 3,568.26 2,517.36 6,085.62 6,400.00 314.38 95.09% 432004 - Telecommunications 175.44 1,283.44 2,417.41 3,700.85 6,360.41 2,659.56 58.19% Total Communication & Transportation 175.44 4,851.70 4,934.77 9,786.47 12,760.41 2,973.94 76.69% Printing & Advertising 433001 - Outside Printing Services - 500.00 - 500.00 2,000.00 1,500.00 25.00% 433002 - Publication of Legal Notice - 996.10 1,111.30 2,107.40 2,200.00 92.60 95.79% Total Printing & Advertising - 1,496.10 1,111.30 2,607.40 4,200.00 1,592.60 62.08% Utilties 435001 - Electric 32,407.57 373,429.74 - 373,429.74 403,180.00 29,750.26 92.62% 435002 - Natural Gas 3,526.18 134,879.74 - 134,879.74 90,938.00 (43,941.74) 148.32% 435004 - Water 24,599.93 229,643.70 - 229,643.70 214,000.00 (15,643.70) 107.31% Total Utilities 60,533.68 737,953.18 - 737,953.18 708,118.00 (29,835.18) 104.21% Repairs & Maintenance 436000 - Other R&M 815.00 33,614.54 5,990.43 39,604.97 39,278.99 (325.98) 100.83% 436001 - Building R&M 1,783.96 180,668.16 71,623.21 252,291.37 261,331.82 9,040.45 96.54% 436002 - Office Equip R&M - 28.88 - 28.88 - (28.88) 0.00% 436003 - Auto Equip R&M 23,925.75 274,798.59 - 274,798.59 251,000.00 (23,798.59) 109.48% 436005 - Other Equip R&M 108.00 1,419.21 2,444.10 3,863.31 4,800.00 936.69 80.49% 436006 - Radio Equip R&M 4,509.39 14,678.62 - 14,678.62 10,500.00 (4,178.62) 139.80% 436011 - Exterminating 703.00 4,119.00 3,543.00 7,662.00 8,334.00 672.00 91.94% Total Repairs & Maintenance 31,845.10 509,327.00 83,600.74 592,927.74 575,244.81 (17,682.93) 103.07% Rentals 437002 - Equipment Rental - 560.00 - 560.00 600.00 40.00 93.33% Total Rentals - 560.00 - 560.00 600.00 40.00 93.33% Debt Service 438100 - Principal - 133,096.72 - 133,096.72 144,454.62 11,357.90 92.14% 438200 - Interest - 3,114.38 - 3,114.38 3,114.38 - 100.00% Total Debt Service - 136,211.10 - 136,211.10 147,569.00 11,357.90 92.30% Other Charges & Services 439000 - Misc Charges & Svcs 46,773.25 454,369.97 34,485.18 488,855.15 489,139.50 284.35 99.94% 439001 - Other Contractual Services - 2,443.96 11,000.00 13,443.96 14,000.00 556.04 96.03% 439002 - Licenses & Permits - 1,374.36 - 1,374.36 1,450.00 75.64 94.78% 439003 - Subscriptions 58.00 2,125.79 - 2,125.79 1,820.00 (305.79) 116.80% 439004 - Dues & Memberships - 390.00 - 390.00 2,375.00 1,985.00 16.42% 439006 - Education & Training 424.00 9,580.80 1,879.00 11,459.80 11,300.00 (159.80) 101.41% 439009 - Trash Removal 3,943.34 35,003.39 4,751.12 39,754.51 43,920.75 4,166.24 90.51% 439012 - Uniform Services - 12,740.19 - 12,740.19 11,200.00 (1,540.19) 113.75% 439100 - Refunds/Awards/Indemnities - 120.13 - 120.13 200.00 79.87 60.07% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 51,198.59 533,148.59 52,115.30 585,263.89 590,405.25 5,141.36 99.13% Total Services & Charges Expenses 150,838.81 1,972,822.10 213,354.61 2,186,176.71 2,164,437.47 (21,739.24) 101.00% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment 14,420.00 92,366.26 38,161.24 130,527.50 386,027.50 255,500.00 33.81% 445100 - Lease Purchase/Motor Equip - 242,136.70 271,257.83 513,394.53 1,290,000.00 776,605.47 39.80% Total Machinery & Equipment 14,420.00 345,369.91 309,419.07 654,788.98 1,686,894.36 1,032,105.38 38.82% Total Capital Expenses 14,420.00 345,369.91 309,419.07 654,788.98 1,686,894.36 1,032,105.38 38.82% Other Uses 452002 - Allocations-Admin Cost 31,642.25 316,422.50 - 316,422.50 379,707.00 63,284.50 83.33% 452003 - Allocations-IT 12,805.67 128,056.66 - 128,056.66 153,668.00 25,611.34 83.33% 452004 - Allocations-Liability Insurance 11,013.08 110,130.84 - 110,130.84 132,157.00 22,026.16 83.33% 452009 - Allocations-Facilities Mgmt 2,001.00 20,010.00 - 20,010.00 24,012.00 4,002.00 83.33% Total Other Uses 57,462.00 574,620.00 - 574,620.00 689,544.00 114,924.00 83.33% Total Expenses 606,520.55 6,906,122.59 591,178.62 7,497,301.21 9,202,280.72 1,704,979.51 81.47%