Loading...
HomeMy WebLinkAboutMay 21 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 40,000.00 75,000.00 35,000.00 46.67% 347019 - Site Mowing - - 95,000.00 95,000.00 100.00% 347021 - Tree Maintenance 453.00 34,482.40 120,000.00 85,517.60 71.26% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% Total Culture & Recreation 15,453.00 74,482.40 392,529.00 318,046.60 81.02% Total Charges for Services 15,453.00 74,482.40 392,529.00 318,046.60 81.02% Miscellaneous Revenue 360000 - Miscellaneous - - 10,000.00 10,000.00 100.00% 360001 - Sale of Scrap Metal - 154.24 - (154.24) 0.00% 367000 - Donations from Private Sources - 1,320.00 - (1,320.00) 0.00% Total Miscellaneous Revenue - 1,474.24 10,000.00 8,525.76 85.26% Refunds & Reimbursements 380000 - Misc Reimbursements - 105.75 - (105.75) 0.00% 380007 - Energy Rebates 962.27 962.27 - (962.27) 0.00% 396000 - Refunds - 18,003.47 - (18,003.47) 0.00% Total Refunds & Reimbursements 962.27 19,071.49 - (19,071.49) 0.00% Other Sources 391000 - Interfund Transfers In 21,845.00 109,230.00 262,145.00 152,915.00 58.33% Total Other Sources 21,845.00 109,230.00 262,145.00 152,915.00 58.33% Total Revenue 38,260.27 204,258.13 664,674.00 460,415.87 69.27% 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 58,372.15 331,915.06 - 331,915.06 760,502.00 428,586.94 56.36% 410002 - Teamster Wages 105,768.16 579,004.98 - 579,004.98 1,353,543.00 774,538.02 57.22% 410003 - Permanent Part Time 23,807.15 117,657.45 - 117,657.45 132,500.00 14,842.55 11.20% 410004 - Extra & Overtime 4,211.61 32,693.01 - 32,693.01 56,300.00 23,606.99 41.93% 410005 - Seasonal & Interns 19,156.50 40,535.20 - 40,535.20 324,200.00 283,664.80 87.50% 410007 - Longevity Pay 350.00 4,050.00 - 4,050.00 7,450.00 3,400.00 45.64% Total Salaries & Wages 211,665.57 1,105,855.70 - 1,105,855.70 2,634,495.00 1,528,639.30 58.02% Employee Benefits 411001 - FICA Regular 15,767.62 83,751.25 - 83,751.25 203,405.00 119,653.75 58.83% 411004 - PERF Regular 18,953.37 105,945.12 - 105,945.12 246,645.00 140,699.88 57.05% 411005 - PERF Union 1,282.09 7,345.17 - 7,345.17 21,536.00 14,190.83 65.89% 411007 - Unemployment Comp 18.05 97.75 - 97.75 634.00 536.25 84.58% 411008 - Health Insurance 48,574.02 248,528.70 - 248,528.70 534,078.00 285,549.30 53.47% 411009 - Life Insurance 475.00 2,405.00 - 2,405.00 5,520.00 3,115.00 56.43% 411014 - Parental Leave 587.79 3,321.23 - 3,321.23 7,622.00 4,300.77 56.43% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 0.00% 411201 - Tool Allowance - 774.79 - 774.79 2,800.00 2,025.21 72.33% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 14,450.00 - 0.00% 411206 - Cell Phone Allowance 495.00 2,475.00 - 2,475.00 5,940.00 3,465.00 58.33% Total Employee Benefits 86,152.94 470,294.01 - 470,294.01 1,043,830.00 573,535.99 54.95% Total Personnel Expenditures 297,818.51 1,576,149.71 - 1,576,149.71 3,678,325.00 2,102,175.29 57.15% May 31, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 516.75 - 516.75 517.00 0.25 0.05% 421002 - Stationary & Printing - - 2,819.00 2,819.00 7,302.00 4,483.00 61.39% Total Office Supplies - 516.75 2,819.00 3,335.75 7,819.00 4,483.25 57.34% Operating Supplies 422000 - Other Operating Supplies 21,464.71 109,803.63 34,214.50 144,018.13 165,963.20 21,945.07 13.22% 422001 - C.S. Gasoline 12,583.28 55,472.75 - 55,472.75 164,871.00 109,398.25 66.35% 422003 - Gasoline - - - - 2,405.00 2,405.00 100.00% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 320.00 0.07 0.02% 422007 - Cleaning Supplies - 232.06 - 232.06 233.00 0.94 0.40% 422008 - Medical/Safety Supplies 2,108.84 7,815.00 - 7,815.00 12,547.19 4,732.19 37.72% 422010 - Plants Chemicals Seed & Fertilizer 3,987.43 16,704.90 6,301.15 23,006.05 69,377.00 46,370.95 66.84% Total Operating Supplies 40,144.26 190,348.27 40,515.65 230,863.92 415,716.39 184,852.47 44.47% Repair & Maintenance Supplies 423000 - Other R&M Supplies 20,018.22 46,839.19 8,635.61 55,474.80 227,963.86 172,489.06 75.67% 423001 - Building Materials 1,775.38 8,459.53 3,614.35 12,073.88 92,363.51 80,289.63 86.93% 423006 - Small Tools & Equipment 829.64 9,905.94 5,668.17 15,574.11 25,573.00 9,998.89 39.10% 423009 - Repair Parts 10,356.56 27,576.13 7,081.68 34,657.81 75,020.30 40,362.49 53.80% Total Repair & Maintenance Supplies 32,979.80 92,780.79 24,999.81 117,780.60 420,920.67 303,140.07 72.02% Total Supplies Expenditures 73,124.06 283,645.81 68,334.46 351,980.27 844,456.06 492,475.79 58.32% Services & Charges Expenditures Professional Services 431000 - Other Professional Services - 1,267.00 11,450.28 12,717.28 16,317.00 3,599.72 22.06% 431001 - Legal Services - 195.00 - 195.00 195.00 - 0.00% 431015 - Laboratory Water Testing 160.00 160.00 - 160.00 160.00 - 0.00% 431019 - Security Services - 14,821.93 - 14,821.93 184,148.00 169,326.07 91.95% Total Professional Services 160.00 16,443.93 11,450.28 27,894.21 200,820.00 172,925.79 86.11% Communication & Transportation 432002 - Mailing - 143.88 - 143.88 144.00 0.12 0.08% 432003 - Travel - - - - 2,106.00 2,106.00 100.00% 432004 - Telecommunications - 1,057.42 2,922.58 3,980.00 9,000.00 5,020.00 55.78% Total Communication & Transportation - 1,201.30 2,922.58 4,123.88 11,250.00 7,126.12 63.34% Printing & Advertising 433001 - Outside Printing Services - 89.00 - 89.00 2,000.00 1,911.00 95.55% 433002 - Publication of Legal Notice - 286.94 180.38 467.32 2,322.74 1,855.42 79.88% Total Printing & Advertising - 375.94 180.38 556.32 4,322.74 3,766.42 87.13% Utilties 435001 - Electric 28,583.21 179,914.64 - 179,914.64 324,259.00 144,344.36 44.52% 435002 - Natural Gas 10,102.56 90,369.43 - 90,369.43 105,563.00 15,193.57 14.39% 435004 - Water 7,380.59 74,118.81 - 74,118.81 198,000.00 123,881.19 62.57% Total Utilities 46,066.36 344,402.88 - 344,402.88 627,822.00 283,419.12 45.14% Repairs & Maintenance 436000 - Other R&M 2,354.00 15,594.50 20,264.12 35,858.62 35,981.12 122.50 0.34% 436001 - Building R&M 54,099.76 65,318.11 38,950.44 104,268.55 186,228.44 81,959.89 44.01% 436003 - Auto Equip R&M 41,245.54 155,335.92 1,749.82 157,085.74 332,991.00 175,905.26 52.83% 436005 - Other Equip R&M - - 159.00 159.00 159.00 - 0.00% 436006 - Radio Equip R&M 302.00 3,406.12 - 3,406.12 5,155.00 1,748.88 33.93% 436011 - Exterminating 675.00 3,290.64 9,807.00 13,097.64 18,739.00 5,641.36 30.10% Total Repairs & Maintenance 98,676.30 242,945.29 70,930.38 313,875.67 579,253.56 265,377.89 45.81% Debt Service 438100 - Principal 34.15 112,526.64 - 112,526.64 225,467.00 112,940.36 50.09% 438200 - Interest 0.93 1,694.92 - 1,694.92 2,543.00 848.08 33.35% Total Debt Service 35.08 114,221.56 - 114,221.56 228,010.00 113,788.44 49.91% Other Charges & Services 439000 - Misc Charges & Svcs 6,958.11 57,492.21 100,661.21 158,153.42 224,690.54 66,537.12 29.61% 439001 - Other Contractual Services - - 3,122.86 3,122.86 3,122.86 - 0.00% 439002 - Licenses & Permits - 2,292.24 - 2,292.24 2,293.00 0.76 0.03% 439003 - Subscriptions - - - - 666.00 666.00 100.00% 439004 - Dues & Memberships - 125.00 - 125.00 2,375.00 2,250.00 94.74% 439006 - Education & Training 180.00 1,339.50 1,269.00 2,608.50 12,100.00 9,491.50 78.44% 439009 - Trash Removal 1,694.56 9,071.46 15,936.98 25,008.44 28,743.18 3,734.74 12.99% 439012 - Uniform Services - 3,851.13 - 3,851.13 3,852.00 0.87 0.02% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 0.00% Total Other Services & Charges 1,874.56 31,679.33 17,205.98 48,885.31 65,029.18 16,143.87 24.83% Total Services & Charges Expenditures 153,770.41 808,762.44 206,473.67 1,015,236.11 1,944,320.88 929,084.77 47.78% Capital Outlay Machinery & Equipment 445003 - Park Equipment - - 24,500.00 24,500.00 400,000.00 375,500.00 93.88% Total Machinery & Equipment - - 24,500.00 24,500.00 400,000.00 375,500.00 93.88% Total Capital Expenditures - - 24,500.00 24,500.00 400,000.00 375,500.00 93.88% Other Uses 452002 - Allocations-Admin Cost 27,272.00 136,360.00 - 136,360.00 327,264.00 190,904.00 58.33% 452004 - Allocations-Liability Insurance 5,441.00 27,202.00 - 27,202.00 65,289.00 38,087.00 58.34% 452009 - Allocations-Facilities Mgmt 1,436.00 7,178.00 - 7,178.00 18,789.00 11,611.00 61.80% Total Other Uses 34,149.00 170,740.00 - 170,740.00 411,342.00 240,602.00 58.49% Total Expenditures 558,861.98 2,839,297.96 299,308.13 3,138,606.09 7,278,443.94 4,139,837.85 56.88%