Loading...
HomeMy WebLinkAboutMay 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 15,000.00 15,000.00 75,000.00 60,000.00 20.00% 347019 - Site Mowing - - 222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 365.00 52,485.46 120,000.00 67,514.54 43.74% Total Culture & Recreation 15,365.00 67,485.46 417,839.00 350,353.54 16.15% Total Charges for Services 15,365.00 67,485.46 417,839.00 350,353.54 16.15% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal 634.57 846.32 - (846.32) 0.00% 367000 - Donations from Private Sources - 7,867.50 - (7,867.50) 0.00% Total Miscellaneous Revenue 634.57 8,713.82 2,000.00 (6,713.82) 435.69% Refunds & Reimbursements 380000 - Misc Reimbursements - 123.06 - (123.06) 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 - 37,603.17 - (37,603.17) 0.00% Total Refunds & Reimbursements - 43,451.61 246,250.00 202,798.39 17.65% Other Sources 393000 - Capital Lease Proceeds - - 1,290,000.00 1,290,000.00 0.00% Total Other Sources - - 1,290,000.00 1,290,000.00 0.00% Total Revenue 15,999.57 119,650.89 1,956,089.00 1,836,438.11 6.12% 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.46 329,959.56 - 329,959.56 820,100.00 490,140.44 40.23% 410002 - Teamster Wages 22,505.86 506,852.11 - 506,852.11 1,281,200.00 774,347.89 39.56% 410003 - Permanent Part Time 26,085.89 100,964.69 - 100,964.69 205,000.00 104,035.31 49.25% 410004 - Extra & Overtime (3,410.67) 28,388.33 - 28,388.33 56,300.00 27,911.67 50.42% 410005 - Seasonal & Interns 30,785.05 77,820.62 - 77,820.62 300,000.00 222,179.38 25.94% 410007 - Longevity Pay 50.00 3,995.83 - 3,995.83 7,450.00 3,454.17 53.64% 410014 - Contract Add Pays (604.92) - - - - - 0.00% 410017 - Stand By Pay 953.36 953.36 - 953.36 3,500.00 2,546.64 27.24% Total Salaries & Wages 136,955.03 1,048,934.50 - 1,048,934.50 2,673,550.00 1,624,615.50 39.23% Employee Benefits 411001 - FICA Regular 9,067.80 86,279.90 - 86,279.90 206,584.00 120,304.10 41.77% 411004 - PERF Regular 7,220.67 102,419.09 - 102,419.09 245,889.00 143,469.91 41.65% 411005 - PERF Union 330.52 7,077.55 - 7,077.55 20,541.00 13,463.45 34.46% 411007 - Unemployment Comp 175.18 1,345.54 - 1,345.54 3,472.00 2,126.46 38.75% 411008 - Health Insurance 21,787.26 217,257.96 - 217,257.96 582,882.00 365,624.04 37.27% 411009 - Life Insurance 210.00 2,040.00 - 2,040.00 5,160.00 3,120.00 39.53% 411014 - Parental Leave 278.63 3,042.32 - 3,042.32 7,594.00 4,551.68 40.06% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance - 2,923.62 - 2,923.62 4,000.00 1,076.38 73.09% 411203 - Job Readiness Allow. (2,125.00) 12,325.00 - 12,325.00 15,750.00 3,425.00 78.25% 411206 - Cell Phone Allowance 440.00 2,200.00 - 2,200.00 5,940.00 3,740.00 37.04% Total Employee Benefits 37,385.06 438,110.98 - 438,110.98 1,099,012.00 660,901.02 39.86% May 31, 2022 Total Personnel Expenses 174,340.09 1,487,045.48 - 1,487,045.48 3,772,562.00 2,285,516.52 39.42% Supplies Expenses Office Supplies 421000 - General Office Supplies 204.39 1,751.72 148.50 1,900.22 5,000.00 3,099.78 38.00% Total Office Supplies 204.39 1,751.72 148.50 1,900.22 5,000.00 3,099.78 38.00% Operating Supplies 422000 - Other Operating Supplies 9,618.41 53,622.89 52,134.51 105,757.40 151,581.45 45,824.05 69.77% 422001 - C.S. Gasoline 23,980.64 86,171.47 - 86,171.47 165,000.00 78,828.53 52.23% 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% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 500.00 180.07 63.99% 422007 - Cleaning Supplies 69.88 85.13 - 85.13 50.00 (35.13) 170.26% 422008 - Medical/Safety Supplies 4,970.17 9,731.98 - 9,731.98 12,480.00 2,748.02 77.98% 422010 - Plants Chemicals Seed & Fertilizer 18,933.71 40,660.44 6,558.54 47,218.98 68,975.00 21,756.02 68.46% Total Operating Supplies 57,572.81 190,627.14 58,743.05 249,370.19 401,041.45 151,671.26 62.18% Repair & Maintenance Supplies 423000 - Other R&M Supplies 21,244.61 86,147.36 46,869.04 133,016.40 233,674.41 100,658.01 56.92% 423001 - Building Materials 1,729.28 27,430.40 748.00 28,178.40 90,000.00 61,821.60 31.31% 423006 - Small Tools & Equipment 2,087.93 9,576.47 31.53 9,608.00 25,573.00 15,965.00 37.57% 423009 - Repair Parts 3,489.62 27,722.97 378.50 28,101.47 79,729.03 51,627.56 35.25% Total Repair & Maintenance Supplies 28,551.44 150,877.20 48,027.07 198,904.27 428,976.44 230,072.17 46.37% Total Supplies Expenses 86,328.64 343,256.06 106,918.62 450,174.68 835,017.89 384,843.21 53.91% Services & Charges Expenses Professional Services 431000 - Other Professional Services 425.00 1,446.00 7,722.00 9,168.00 11,500.00 2,332.00 79.72% 431009 - Computer & Technology - 31.83 - 31.83 500.00 468.17 6.37% 431014 - Collection Costs - 12.50 11.25 23.75 50.00 26.25 47.50% 431019 - Security Services - 15,557.60 - 15,557.60 16,218.00 660.40 95.93% Total Professional Services 425.00 17,047.93 7,733.25 24,781.18 28,268.00 3,486.82 87.67% Communication & Transportation 432003 - Travel - 2,012.21 3,602.39 5,614.60 6,400.00 785.40 87.73% 432004 - Telecommunications - 844.84 2,867.41 3,712.25 7,997.41 4,285.16 46.42% Total Communication & Transportation - 2,857.05 6,469.80 9,326.85 14,397.41 5,070.56 64.78% Printing & Advertising 433001 - Outside Printing Services 500.00 500.00 - 500.00 2,000.00 1,500.00 25.00% 433002 - Publication of Legal Notice - 495.60 704.40 1,200.00 2,000.00 800.00 60.00% Total Printing & Advertising 500.00 995.60 704.40 1,700.00 4,000.00 2,300.00 42.50% Utilties 435001 - Electric 33,234.62 187,605.61 - 187,605.61 403,180.00 215,574.39 46.53% 435002 - Natural Gas 13,703.65 118,968.00 - 118,968.00 90,938.00 (28,030.00) 130.82% 435004 - Water 20,685.46 45,048.51 - 45,048.51 214,000.00 168,951.49 21.05% Total Utilities 67,623.73 351,622.12 - 351,622.12 708,118.00 356,495.88 49.66% Repairs & Maintenance 436000 - Other R&M 89.98 9,650.44 2,275.43 11,925.87 81,528.99 69,603.12 14.63% 436001 - Building R&M 26,727.72 82,376.61 92,462.00 174,838.61 206,994.82 32,156.21 84.47% 436003 - Auto Equip R&M 25,549.58 148,792.50 - 148,792.50 299,500.00 150,707.50 49.68% 436005 - Other Equip R&M 784.97 784.97 - 784.97 5,800.00 5,015.03 13.53% 436006 - Radio Equip R&M 388.50 3,422.09 - 3,422.09 3,500.00 77.91 97.77% 436011 - Exterminating 648.00 3,416.00 746.00 4,162.00 8,334.00 4,172.00 49.94% Total Repairs & Maintenance 54,188.75 248,442.61 95,483.43 343,926.04 605,657.81 261,731.77 56.79% Debt Service 438100 - Principal - - - - 51,161.00 51,161.00 0.00% 438200 - Interest - - - - 6,408.00 6,408.00 0.00% Total Debt Service - - - - 57,569.00 57,569.00 0.00% Other Charges & Services 439000 - Misc Charges & Svcs 75,624.34 119,396.65 336,978.74 456,375.39 581,561.50 125,186.11 78.47% 439001 - Other Contractual Services - - - - 3,500.00 3,500.00 0.00% 439002 - Licenses & Permits - 1,150.00 - 1,150.00 1,150.00 - 100.00% 439003 - Subscriptions - 125.00 - 125.00 1,220.00 1,095.00 10.25% 439004 - Dues & Memberships - 120.00 - 120.00 2,375.00 2,255.00 5.05% 439006 - Education & Training 204.17 6,347.17 2,554.00 8,901.17 11,000.00 2,098.83 80.92% 439009 - Trash Removal 3,829.38 15,877.89 13,802.02 29,679.91 32,420.75 2,740.84 91.55% 439012 - Uniform Services 1,618.00 7,220.30 - 7,220.30 8,200.00 979.70 88.05% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 81,275.89 165,237.01 353,334.76 518,571.77 656,427.25 137,855.48 79.00% Total Services & Charges Expenses 204,013.37 786,202.32 463,725.64 1,249,927.96 2,074,437.47 824,509.51 60.25% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment - - 108,002.34 108,002.34 386,027.50 278,025.16 27.98% 445100 - Lease Purchase/Motor Equip - - 191,646.00 191,646.00 269,000.00 77,354.00 71.24% Total Machinery & Equipment - 10,866.95 299,648.34 310,515.29 665,894.36 355,379.07 46.63% Total Capital Expenses - 10,866.95 299,648.34 310,515.29 665,894.36 355,379.07 46.63% Other Uses 452002 - Allocations-Admin Cost 31,642.25 158,211.25 - 158,211.25 379,707.00 221,495.75 41.67% 452003 - Allocations-IT 12,805.67 64,028.31 - 64,028.31 153,668.00 89,639.69 41.67% 452004 - Allocations-Liability Insurance 11,013.08 55,065.44 - 55,065.44 132,157.00 77,091.56 41.67% 452009 - Allocations-Facilities Mgmt 2,001.00 10,005.00 - 10,005.00 24,012.00 14,007.00 41.67% Total Other Uses 57,462.00 287,310.00 - 287,310.00 689,544.00 402,234.00 41.67% Total Expenses 522,144.10 2,914,680.81 870,292.60 3,784,973.41 8,037,455.72 4,252,482.31 47.09%