Loading...
HomeMy WebLinkAboutNov 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) 100,000.00 75,000.00 (25,000.00) 133.33% 347019 - Site Mowing - 1,227.59 95,000.00 93,772.41 1.29% 347021 - Tree Maintenance 1,858.02 99,615.78 120,000.00 20,384.22 83.01% 347023 - Graffiti Removal - 1,482.15 102,529.00 101,046.85 1.45% Total Culture & Recreation (13,141.98) 202,325.52 392,529.00 190,203.48 51.54% Total Charges for Services (13,141.98) 202,325.52 392,529.00 190,203.48 51.54% Miscellaneous Revenue 360000 - Miscellaneous - - 10,000.00 10,000.00 0.00% 360001 - Sale of Scrap Metal 128.58 1,145.56 - (1,145.56) 0.00% 367000 - Donations from Private Sources 370.00 26,190.00 - (26,190.00) 0.00% Total Miscellaneous Revenue 498.58 27,335.56 10,000.00 (17,335.56) 273.36% Refunds & Reimbursements 380000 - Misc Reimbursements - 234.98 - (234.98) 0.00% 380007 - Energy Rebates - 962.27 - (962.27) 0.00% 396000 - Refunds 13.61 2,017.08 2,003.00 (14.08) 100.70% Total Refunds & Reimbursements 13.61 3,214.33 2,003.00 (1,211.33) 160.48% Other Sources 391000 - Interfund Transfers In 21,845.00 240,300.00 262,145.00 21,845.00 91.67% 392000 - Gain/Loss on Sale of Asset - 17,250.00 - (17,250.00) 0.00% Total Other Sources 21,845.00 257,550.00 262,145.00 4,595.00 98.25% Total Revenue 9,215.21 490,425.41 666,677.00 176,251.59 73.56% 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 57,702.10 692,060.35 - 692,060.35 665,358.00 (26,702.35) 104.01% 410002 - Teamster Wages 103,204.12 1,257,093.91 - 1,257,093.91 1,313,543.00 56,449.09 95.70% 410003 - Permanent Part Time 19,905.09 263,771.24 - 263,771.24 243,392.00 (20,379.24) 108.37% 410004 - Extra & Overtime 3,602.27 94,818.19 - 94,818.19 112,552.00 17,733.81 84.24% 410005 - Seasonal & Interns 14,609.45 243,262.17 - 243,262.17 273,000.00 29,737.83 89.11% 410007 - Longevity Pay 350.00 7,450.00 - 7,450.00 10,450.00 3,000.00 71.29% 410014 - Contract Add Pays - 955.98 - 955.98 4,000.00 3,044.02 23.90% Total Salaries & Wages 199,373.03 2,559,411.84 - 2,559,411.84 2,622,295.00 62,883.16 97.60% Employee Benefits 411001 - FICA Regular 14,675.85 191,629.37 - 191,629.37 212,405.00 20,775.63 90.22% 411004 - PERF Regular 18,112.76 226,733.19 - 226,733.19 248,645.00 21,911.81 91.19% 411005 - PERF Union 1,240.81 16,149.86 - 16,149.86 20,036.00 3,886.14 80.60% 411007 - Unemployment Comp 53.64 650.19 - 650.19 834.00 183.81 77.96% 411008 - Health Insurance 46,781.02 531,888.42 - 531,888.42 534,078.00 2,189.58 99.59% 411009 - Life Insurance 450.00 5,155.00 - 5,155.00 6,020.00 865.00 85.63% 411014 - Parental Leave 576.52 7,161.86 - 7,161.86 8,122.00 960.14 88.18% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance 1,600.00 3,694.59 25.21 3,719.80 4,600.00 880.20 80.87% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 14,450.00 - 100.00% 411206 - Cell Phone Allowance 440.00 5,115.00 - 5,115.00 5,640.00 525.00 90.69% Total Employee Benefits 83,930.60 1,003,827.48 25.21 1,003,852.69 1,056,030.00 52,177.31 95.06% November 30, 2021 Total Personnel Expenditures 283,303.63 3,563,239.32 25.21 3,563,264.53 3,678,325.00 115,060.47 96.87% Supplies Expenditures Office Supplies 421000 - General Office Supplies 29.99 696.72 - 696.72 597.00 (99.72) 116.70% 421002 - Stationary & Printing - 2,966.00 - 2,966.00 4,022.00 1,056.00 73.74% Total Office Supplies 29.99 3,662.72 - 3,662.72 4,619.00 956.28 79.30% Operating Supplies 422000 - Other Operating Supplies 6,991.25 183,632.25 12,388.77 196,021.02 232,032.20 36,011.18 84.48% 422001 - C.S. Gasoline 13,295.36 148,285.37 - 148,285.37 148,371.00 85.63 99.94% 422003 - Gasoline - - - - 405.00 405.00 0.00% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 320.00 0.07 99.98% 422007 - Cleaning Supplies 68.18 1,317.82 - 1,317.82 1,433.00 115.18 91.96% 422008 - Medical/Safety Supplies 1,137.13 18,685.42 - 18,685.42 21,207.19 2,521.77 88.11% 422010 - Plants Chemicals Seed & Fertilizer 9,007.93 40,239.06 422.00 40,661.06 58,877.00 18,215.94 69.06% 422013 - Promotional Supplies 17.49 17.49 - 17.49 - (17.49) 0.00% Total Operating Supplies 30,517.34 392,497.34 12,810.77 405,308.11 462,645.39 57,337.28 87.61% Repair & Maintenance Supplies 423000 - Other R&M Supplies 7,931.35 112,837.53 16,892.47 129,730.00 198,394.86 68,664.86 65.39% 423001 - Building Materials 12,637.75 40,105.37 - 40,105.37 49,603.51 9,498.14 80.85% 423006 - Small Tools & Equipment 2,268.73 29,566.80 - 29,566.80 30,771.00 1,204.20 96.09% 423009 - Repair Parts 4,657.97 54,731.00 8,479.37 63,210.37 73,422.30 10,211.93 86.09% Total Repair & Maintenance Supplies 27,495.80 237,240.70 25,371.84 262,612.54 352,191.67 89,579.13 74.57% Total Supplies Expenditures 58,043.13 633,400.76 38,182.61 671,583.37 819,456.06 147,872.69 81.95% Services & Charges Expenditures Professional Services 431000 - Other Professional Services - 6,120.10 - 6,120.10 13,183.00 7,062.90 46.42% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431009 - Computer & Technology - 243.96 - 243.96 300.00 56.04 81.32% 431014 - Collection Costs 106.25 106.25 - 106.25 107.00 0.75 99.30% 431015 - Laboratory Water Testing - 160.00 - 160.00 160.00 - 100.00% 431019 - Security Services - 17,657.93 - 17,657.93 18,444.00 786.07 95.74% Total Professional Services 106.25 24,483.24 - 24,483.24 32,389.00 7,905.76 75.59% Communication & Transportation 432002 - Mailing - 143.88 - 143.88 144.00 0.12 99.92% 432003 - Travel - - - - 106.00 106.00 0.00% 432004 - Telecommunications 102.65 1,744.87 2,235.13 3,980.00 4,328.00 348.00 91.96% Total Communication & Transportation 102.65 1,888.75 2,235.13 4,123.88 4,578.00 454.12 90.08% Printing & Advertising 433001 - Outside Printing Services - 89.00 - 89.00 500.00 411.00 17.80% 433002 - Publication of Legal Notice - 945.94 226.80 1,172.74 1,577.74 405.00 74.33% Total Printing & Advertising - 1,034.94 226.80 1,261.74 2,077.74 816.00 60.73% Utilties 435001 - Electric 37,167.44 400,744.45 - 400,744.45 324,359.00 (76,385.45) 123.55% 435002 - Natural Gas 9,357.45 118,775.96 - 118,775.96 118,963.00 187.04 99.84% 435004 - Water 15,284.89 274,405.58 - 274,405.58 233,000.00 (41,405.58) 117.77% Total Utilities 61,809.78 793,925.99 - 793,925.99 676,322.00 (117,603.99) 117.39% Repairs & Maintenance 436000 - Other R&M 971.69 36,728.12 26,234.39 62,962.51 95,981.12 33,018.61 65.60% 436001 - Building R&M 1,235.95 106,439.48 26,075.28 132,514.76 130,028.44 (2,486.32) 101.91% 436003 - Auto Equip R&M 38,245.08 382,957.66 408.00 383,365.66 265,381.00 (117,984.66) 144.46% 436005 - Other Equip R&M - 762.07 - 762.07 659.00 (103.07) 115.64% 436006 - Radio Equip R&M 2,775.22 13,008.82 - 13,008.82 10,772.00 (2,236.82) 120.77% 436011 - Exterminating 598.00 8,871.64 4,226.00 13,097.64 16,139.00 3,041.36 81.16% Total Repairs & Maintenance 43,825.94 548,767.79 56,943.67 605,711.46 518,960.56 (86,750.90) 116.72% Debt Service 438100 - Principal - 225,466.76 - 225,466.76 225,467.00 0.24 100.00% 438200 - Interest - 2,542.28 - 2,542.28 2,543.00 0.72 99.97% Total Debt Service - 228,009.04 - 228,009.04 228,010.00 0.96 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 11,678.82 259,688.57 78,871.91 338,560.48 314,227.54 (24,332.94) 107.74% 439001 - Other Contractual Services - 2,791.73 - 2,791.73 8,052.86 5,261.13 34.67% 439002 - Licenses & Permits - 2,292.24 - 2,292.24 2,393.00 100.76 95.79% 439003 - Subscriptions - - - - 66.00 66.00 0.00% 439004 - Dues & Memberships - 125.00 - 125.00 375.00 250.00 33.33% 439006 - Education & Training 300.00 3,787.50 - 3,787.50 6,263.00 2,475.50 60.47% 439009 - Trash Removal 250.62 23,063.88 6,490.14 29,554.02 39,543.18 9,989.16 74.74% 439012 - Uniform Services 1,743.52 9,376.11 - 9,376.11 11,196.00 1,819.89 83.75% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 13,972.96 316,125.03 85,362.05 401,487.08 397,116.58 (4,370.50) 101.10% Total Services & Charges Expenditures 119,817.58 1,914,234.78 144,767.65 2,059,002.43 1,859,453.88 (199,548.55) 110.73% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - 10,866.86 10,866.86 10,867.00 0.14 100.00% 445003 - Park Equipment - 13,972.50 108,002.34 121,974.84 400,000.00 278,025.16 30.49% Total Machinery & Equipment - 13,972.50 118,869.20 132,841.70 410,867.00 278,025.30 32.33% Total Capital Expenditures - 13,972.50 118,869.20 132,841.70 410,867.00 278,025.30 32.33% Other Uses 452002 - Allocations-Admin Cost 27,272.00 299,992.00 - 299,992.00 327,264.00 27,272.00 91.67% 452004 - Allocations-Liability Insurance 5,441.00 59,848.00 - 59,848.00 65,289.00 5,441.00 91.67% 452009 - Allocations-Facilities Mgmt 1,436.00 15,794.00 - 15,794.00 17,230.00 1,436.00 91.67% Total Other Uses 34,149.00 375,634.00 - 375,634.00 409,783.00 34,149.00 91.67% Total Expenditures 495,313.34 6,500,481.36 301,844.67 6,802,326.03 7,177,884.94 375,558.91 94.77%