Loading...
HomeMy WebLinkAboutFeb 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 0.00% 347019 - Site Mowing - - 222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 2,806.84 3,086.84 120,000.00 116,913.16 2.57% Total Culture & Recreation 2,806.84 3,086.84 417,839.00 414,752.16 0.74% Total Charges for Services 2,806.84 3,086.84 417,839.00 414,752.16 0.74% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal 211.75 211.75 - (211.75) 0.00% 367000 - Donations from Private Sources - 7,867.50 - (7,867.50) 0.00% Total Miscellaneous Revenue 211.75 8,079.25 2,000.00 (6,079.25) 403.96% Refunds & Reimbursements 380000 - Misc Reimbursements 74.77 74.77 - (74.77) 0.00% 381000 - Misc Reimbursements - - 245,441.00 245,441.00 0.00% 396000 - Refunds 180.24 37,315.09 - (37,315.09) 0.00% Total Refunds & Reimbursements 255.01 37,389.86 245,441.00 208,051.14 15.23% Other Sources 393000 - Capital Lease Proceeds - - 269,000.00 269,000.00 0.00% Total Other Sources - - 269,000.00 269,000.00 0.00% Total Revenue 3,273.60 48,555.95 934,280.00 885,724.05 5.20% 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 60,503.07 117,867.91 - 117,867.91 820,100.00 702,232.09 14.37% 410002 - Teamster Wages 111,329.44 221,848.47 - 221,848.47 1,285,900.00 1,064,051.53 17.25% 410003 - Permanent Part Time 15,717.14 35,099.12 - 35,099.12 205,000.00 169,900.88 17.12% 410004 - Extra & Overtime 11,696.62 16,265.26 - 16,265.26 56,300.00 40,034.74 28.89% 410005 - Seasonal & Interns 6,437.07 14,357.39 - 14,357.39 300,000.00 285,642.61 4.79% 410007 - Longevity Pay 1,558.33 1,558.33 - 1,558.33 7,450.00 5,891.67 20.92% Total Salaries & Wages 207,241.67 406,996.48 - 406,996.48 2,674,750.00 2,267,753.52 15.22% Employee Benefits 411001 - FICA Regular 15,326.65 39,683.36 - 39,683.36 206,584.00 166,900.64 19.21% 411004 - PERF Regular 20,676.85 50,220.86 - 50,220.86 245,889.00 195,668.14 20.42% 411005 - PERF Union 1,400.43 3,639.71 - 3,639.71 20,541.00 16,901.29 17.72% 411007 - Unemployment Comp 154.85 430.84 - 430.84 3,472.00 3,041.16 12.41% 411008 - Health Insurance 49,463.89 97,861.58 - 97,861.58 582,882.00 485,020.42 16.79% 411009 - Life Insurance 460.00 910.00 - 910.00 5,160.00 4,250.00 17.64% 411014 - Parental Leave 646.89 1,250.48 - 1,250.48 7,594.00 6,343.52 16.47% 411201 - Tool Allowance 423.62 1,423.62 - 1,423.62 4,000.00 2,576.38 35.59% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 15,750.00 1,300.00 91.75% 411206 - Cell Phone Allowance 440.00 880.00 - 880.00 5,940.00 5,060.00 14.81% Total Employee Benefits 88,993.18 210,750.45 - 210,750.45 1,097,812.00 887,061.55 19.20% Total Personnel Expenditures 296,234.85 617,746.93 - 617,746.93 3,772,562.00 3,154,815.07 16.37% Supplies Expenditures Office Supplies February 28, 2022 421000 - General Office Supplies 492.72 1,158.62 - 1,158.62 5,000.00 3,841.38 23.17% Total Office Supplies 492.72 1,158.62 - 1,158.62 5,000.00 3,841.38 23.17% Operating Supplies 422000 - Other Operating Supplies 10,783.23 19,375.00 56,542.34 75,917.34 151,581.45 75,664.11 50.08% 422001 - C.S. Gasoline 15,635.98 29,273.49 - 29,273.49 165,000.00 135,726.51 17.74% 422003 - Gasoline - - - - 2,405.00 2,405.00 0.00% 422004 - Oil - 35.30 - 35.30 50.00 14.70 70.60% 422007 - Cleaning Supplies - 2.68 - 2.68 50.00 47.32 5.36% 422008 - Medical/Safety Supplies 2,833.83 4,440.22 - 4,440.22 12,480.00 8,039.78 35.58% 422010 - Plants Chemicals Seed & Fertilizer - - 22,604.57 22,604.57 68,975.00 46,370.43 32.77% Total Operating Supplies 29,253.04 53,126.69 79,146.91 132,273.60 400,541.45 268,267.85 33.02% Repair & Maintenance Supplies 423000 - Other R&M Supplies 11,393.05 22,191.11 30,786.91 52,978.02 234,174.41 181,196.39 22.62% 423001 - Building Materials 13,683.16 16,001.58 4,100.00 20,101.58 90,000.00 69,898.42 22.34% 423006 - Small Tools & Equipment 1,941.76 2,757.57 583.52 3,341.09 25,573.00 22,231.91 13.06% 423009 - Repair Parts 2,640.10 10,258.88 6,929.03 17,187.91 79,729.03 62,541.12 21.56% Total Repair & Maintenance Supplies 29,658.07 51,209.14 42,399.46 93,608.60 429,476.44 335,867.84 21.80% Total Supplies Expenditures 59,403.83 105,494.45 121,546.37 227,040.82 835,017.89 607,977.07 27.19% Services & Charges Expenditures Professional Services 431014 - Collection Costs 6.25 6.25 - 6.25 50.00 43.75 12.50% 431019 - Security Services - 15,557.60 - 15,557.60 214,652.00 199,094.40 7.25% Total Professional Services 6.25 15,563.85 - 15,563.85 214,702.00 199,138.15 7.25% Communication & Transportation 432003 - Travel - 405.61 3,049.03 3,454.64 6,400.00 2,945.36 53.98% 432004 - Telecommunications 175.44 175.44 3,543.65 3,719.09 8,997.41 5,278.32 41.34% Total Communication & Transportation 175.44 581.05 6,592.68 7,173.73 15,397.41 8,223.68 46.59% Printing & Advertising 433001 - Outside Printing Services - - - - 2,000.00 2,000.00 0.00% 433002 - Publication of Legal Notice - 495.60 179.40 675.00 2,000.00 1,325.00 33.75% Total Printing & Advertising - 495.60 179.40 675.00 4,000.00 3,325.00 16.88% Utilties 435001 - Electric 40,170.07 81,684.93 - 81,684.93 403,180.00 321,495.07 20.26% 435002 - Natural Gas 33,089.76 62,080.92 - 62,080.92 90,938.00 28,857.08 68.27% 435004 - Water 2,655.18 9,391.28 - 9,391.28 214,000.00 204,608.72 4.39% Total Utilities 75,915.01 153,157.13 - 153,157.13 708,118.00 554,960.87 21.63% Repairs & Maintenance 436000 - Other R&M 4,935.00 5,104.46 9,326.49 14,430.95 95,328.99 80,898.04 15.14% 436001 - Building R&M 8,129.79 22,717.02 62,221.30 84,938.32 176,994.82 92,056.50 47.99% 436003 - Auto Equip R&M 25,448.02 64,177.79 - 64,177.79 335,000.00 270,822.21 19.16% 436006 - Radio Equip R&M 1,164.50 1,829.34 - 1,829.34 2,000.00 170.66 91.47% 436011 - Exterminating 1,057.00 1,934.00 900.00 2,834.00 13,334.00 10,500.00 21.25% Total Repairs & Maintenance 40,734.31 95,762.61 72,447.79 168,210.40 622,657.81 454,447.41 27.01% 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 20,908.99 32,858.49 11,850.00 44,708.49 388,127.50 343,419.01 11.52% 439002 - Licenses & Permits 1,150.00 1,150.00 - 1,150.00 1,150.00 - 100.00% 439003 - Subscriptions 125.00 125.00 - 125.00 1,220.00 1,095.00 10.25% 439004 - Dues & Memberships - - - - 2,375.00 2,375.00 0.00% 439006 - Education & Training 2,246.00 3,416.00 2,075.00 5,491.00 11,000.00 5,509.00 49.92% 439009 - Trash Removal 3,942.00 6,649.15 20,593.28 27,242.43 31,120.75 3,878.32 87.54% 439012 - Uniform Services - 1,999.56 - 1,999.56 2,000.00 0.44 99.98% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 28,371.99 61,198.20 34,518.28 95,716.48 451,993.25 356,276.77 21.18% Total Services & Charges Expenditures 145,203.00 326,758.44 113,738.15 440,496.59 2,074,437.47 1,633,940.88 21.23% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - 10,866.86 10,866.86 10,866.86 - 100.00% 445003 - Park Equipment - - 108,002.34 108,002.34 386,027.50 278,025.16 27.98% 445100 - Lease Purchase/Motor Equip - - - - 269,000.00 269,000.00 0.00% Total Machinery & Equipment - - 118,869.20 118,869.20 665,894.36 547,025.16 17.85% Total Capital Expenditures - - 118,869.20 118,869.20 665,894.36 547,025.16 17.85% Other Uses 452002 - Allocations-Admin Cost 31,642.25 63,284.50 - 63,284.50 379,707.00 316,422.50 16.67% 452003 - Allocations-IT 12,805.67 25,611.30 - 25,611.30 153,668.00 128,056.70 16.67% 452004 - Allocations-Liability Insurance 11,013.08 22,026.20 - 22,026.20 132,157.00 110,130.80 16.67% 452009 - Allocations-Facilities Mgmt 2,001.00 4,002.00 - 4,002.00 24,012.00 20,010.00 16.67% Total Other Uses 57,462.00 114,924.00 - 114,924.00 689,544.00 574,620.00 16.67% Total Expenditures 558,303.68 1,164,923.82 354,153.72 1,519,077.54 8,037,455.72 6,518,378.18 18.90%