Loading...
HomeMy WebLinkAboutOct 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 - 115,000.00 75,000.00 (40,000.00) 153.33% 347019 - Site Mowing - 1,227.59 95,000.00 93,772.41 1.29% 347021 - Tree Maintenance 200.00 97,757.76 120,000.00 22,242.24 81.46% 347023 - Graffiti Removal - 1,482.15 102,529.00 101,046.85 1.45% Total Culture & Recreation 200.00 215,467.50 392,529.00 177,061.50 54.89% Total Charges for Services 200.00 215,467.50 392,529.00 177,061.50 54.89% Miscellaneous Revenue 360000 - Miscellaneous - - 10,000.00 10,000.00 0.00% 360001 - Sale of Scrap Metal - 1,016.98 - (1,016.98) 0.00% 367000 - Donations from Private Sources 8,500.00 25,820.00 - (25,820.00) 0.00% Total Miscellaneous Revenue 8,500.00 26,836.98 10,000.00 (16,836.98) 268.37% Refunds & Reimbursements 380000 - Misc Reimbursements 54.04 234.98 - (234.98) 0.00% 380007 - Energy Rebates - 962.27 - (962.27) 0.00% 396000 - Refunds - 2,003.47 2,003.00 (0.47) 100.02% Total Refunds & Reimbursements 54.04 3,200.72 2,003.00 (1,197.72) 159.80% Other Sources 391000 - Interfund Transfers In 21,845.00 218,455.00 262,145.00 43,690.00 83.33% 392000 - Gain/Loss on Sale of Asset - 17,250.00 - (17,250.00) 0.00% Total Other Sources 21,845.00 235,705.00 262,145.00 26,440.00 89.91% Total Revenue 30,599.04 481,210.20 666,677.00 185,466.80 72.18% 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 82,139.68 634,358.25 - 634,358.25 665,358.00 30,999.75 95.34% 410002 - Teamster Wages 145,449.20 1,153,889.79 - 1,153,889.79 1,313,543.00 159,653.21 87.85% 410003 - Permanent Part Time 30,980.67 243,866.15 - 243,866.15 243,392.00 (474.15) 100.19% 410004 - Extra & Overtime 17,834.78 91,215.92 - 91,215.92 112,552.00 21,336.08 81.04% 410005 - Seasonal & Interns 38,466.19 228,652.72 - 228,652.72 273,000.00 44,347.28 83.76% 410007 - Longevity Pay 1,050.00 7,100.00 - 7,100.00 10,450.00 3,350.00 67.94% 410014 - Contract Add Pays 615.94 955.98 - 955.98 4,000.00 3,044.02 23.90% Total Salaries & Wages 316,536.46 2,360,038.81 - 2,360,038.81 2,622,295.00 262,256.19 90.00% Employee Benefits 411001 - FICA Regular 23,703.93 176,953.52 - 176,953.52 212,405.00 35,451.48 83.31% 411004 - PERF Regular 27,091.32 208,620.43 - 208,620.43 248,645.00 40,024.57 83.90% 411005 - PERF Union 2,019.41 14,909.05 - 14,909.05 21,536.00 6,626.95 69.23% 411007 - Unemployment Comp 81.03 596.55 - 596.55 834.00 237.45 71.53% 411008 - Health Insurance 46,255.42 485,107.40 - 485,107.40 534,078.00 48,970.60 90.83% 411009 - Life Insurance 445.00 4,705.00 - 4,705.00 6,020.00 1,315.00 78.16% 411014 - Parental Leave 863.31 6,585.34 - 6,585.34 8,122.00 1,536.66 81.08% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance 1,106.56 2,094.59 - 2,094.59 2,800.00 705.41 74.81% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 14,450.00 - 100.00% 411206 - Cell Phone Allowance 440.00 4,675.00 - 4,675.00 5,940.00 1,265.00 78.70% Total Employee Benefits 102,005.98 919,896.88 - 919,896.88 1,056,030.00 136,133.12 87.11% October 31, 2021 Total Personnel Expenditures 418,542.44 3,279,935.69 - 3,279,935.69 3,678,325.00 398,389.31 89.17% Supplies Expenditures Office Supplies 421000 - General Office Supplies 70.15 666.73 - 666.73 597.00 (69.73) 111.68% 421002 - Stationary & Printing - 2,966.00 - 2,966.00 4,022.00 1,056.00 73.74% Total Office Supplies 70.15 3,632.73 - 3,632.73 4,619.00 986.27 78.65% Operating Supplies 422000 - Other Operating Supplies 11,925.93 176,641.00 25,237.49 201,878.49 232,032.20 30,153.71 87.00% 422001 - C.S. Gasoline 15,303.75 134,990.01 - 134,990.01 148,371.00 13,380.99 90.98% 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 32.53 1,249.64 - 1,249.64 1,433.00 183.36 87.20% 422008 - Medical/Safety Supplies 341.15 17,548.29 - 17,548.29 21,207.19 3,658.90 82.75% 422010 - Plants Chemicals Seed & Fertilizer 1,930.27 31,231.13 17,089.50 48,320.63 58,877.00 10,556.37 82.07% Total Operating Supplies 29,533.63 361,980.00 42,326.99 404,306.99 462,645.39 58,338.40 87.39% Repair & Maintenance Supplies 423000 - Other R&M Supplies 21,916.29 104,906.18 18,118.46 123,024.64 198,394.86 75,370.22 62.01% 423001 - Building Materials 1,289.39 27,467.62 9,285.40 36,753.02 49,603.51 12,850.49 74.09% 423006 - Small Tools & Equipment 6,691.98 27,298.07 - 27,298.07 29,771.00 2,472.93 91.69% 423009 - Repair Parts 3,570.56 50,073.03 17,242.48 67,315.51 74,422.30 7,106.79 90.45% Total Repair & Maintenance Supplies 33,468.22 209,744.90 44,646.34 254,391.24 352,191.67 97,800.43 72.23% Total Supplies Expenditures 63,072.00 575,357.63 86,973.33 662,330.96 819,456.06 157,125.10 80.83% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 375.00 6,120.10 9,350.00 15,470.10 17,527.00 2,056.90 88.26% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431009 - Computer & Technology - 243.96 - 243.96 300.00 56.04 81.32% 431015 - Laboratory Water Testing - 160.00 - 160.00 160.00 - 100.00% 431019 - Security Services - 17,657.93 92.00 17,749.93 18,444.00 694.07 96.24% Total Professional Services 375.00 24,376.99 9,442.00 33,818.99 36,626.00 2,807.01 92.34% Communication & Transportation 432002 - Mailing - 143.88 - 143.88 144.00 0.12 99.92% 432003 - Travel - - - - 106.00 106.00 0.00% 432004 - Telecommunications - 1,642.22 2,337.78 3,980.00 4,645.00 665.00 85.68% Total Communication & Transportation - 1,786.10 2,337.78 4,123.88 4,895.00 771.12 84.25% Printing & Advertising 433001 - Outside Printing Services - 89.00 - 89.00 500.00 411.00 17.80% 433002 - Publication of Legal Notice 392.70 945.94 302.86 1,248.80 1,367.74 118.94 91.30% Total Printing & Advertising 392.70 1,034.94 302.86 1,337.80 1,867.74 529.94 71.63% Utilties 435001 - Electric 31,884.11 363,577.01 - 363,577.01 324,359.00 (39,218.01) 112.09% 435002 - Natural Gas 3,493.63 109,418.51 - 109,418.51 118,963.00 9,544.49 91.98% 435004 - Water 26,264.23 259,120.69 - 259,120.69 233,000.00 (26,120.69) 111.21% Total Utilities 61,641.97 732,116.21 - 732,116.21 676,322.00 (55,794.21) 108.25% Repairs & Maintenance 436000 - Other R&M 6,742.11 35,756.43 30,739.98 66,496.41 95,981.12 29,484.71 69.28% 436001 - Building R&M 6,997.13 105,203.53 22,052.49 127,256.02 130,028.44 2,772.42 97.87% 436003 - Auto Equip R&M 23,965.46 344,712.58 - 344,712.58 265,381.00 (79,331.58) 129.89% 436005 - Other Equip R&M 351.00 762.07 - 762.07 659.00 (103.07) 115.64% 436006 - Radio Equip R&M - 10,233.60 - 10,233.60 10,772.00 538.40 95.00% 436011 - Exterminating 1,048.00 8,273.64 4,824.00 13,097.64 16,139.00 3,041.36 81.16% Total Repairs & Maintenance 39,103.70 504,941.85 57,616.47 562,558.32 518,960.56 (43,597.76) 108.40% Debt Service 438100 - Principal 104,588.25 225,466.76 - 225,466.76 225,467.00 0.24 100.00% 438200 - Interest 782.85 2,542.28 - 2,542.28 2,543.00 0.72 99.97% Total Debt Service 105,371.10 228,009.04 - 228,009.04 228,010.00 0.96 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 83,236.61 248,009.75 35,027.89 283,037.64 319,427.54 36,389.90 88.61% 439001 - Other Contractual Services - 2,791.73 3,122.86 5,914.59 6,052.86 138.27 97.72% 439002 - Licenses & Permits - 2,292.24 - 2,292.24 2,293.00 0.76 99.97% 439003 - Subscriptions - - - - 66.00 66.00 0.00% 439004 - Dues & Memberships - 125.00 - 125.00 375.00 250.00 33.33% 439006 - Education & Training 428.00 3,487.50 169.00 3,656.50 6,363.00 2,706.50 57.47% 439009 - Trash Removal 2,915.84 22,813.26 7,621.44 30,434.70 35,543.18 5,108.48 85.63% 439012 - Uniform Services - 7,632.59 - 7,632.59 7,652.00 19.41 99.75% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 86,580.45 302,152.07 45,941.19 348,093.26 392,772.58 44,679.32 88.62% Total Services & Charges Expenditures 293,464.92 1,794,417.20 115,640.30 1,910,057.50 1,859,453.88 (50,603.62) 102.72% 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 272,720.00 - 272,720.00 327,264.00 54,544.00 83.33% 452004 - Allocations-Liability Insurance 5,441.00 54,407.00 - 54,407.00 65,289.00 10,882.00 83.33% 452009 - Allocations-Facilities Mgmt 1,436.00 14,358.00 - 14,358.00 17,230.00 2,872.00 83.33% Total Other Uses 34,149.00 341,485.00 - 341,485.00 409,783.00 68,298.00 83.33% Total Expenditures 809,228.36 6,005,168.02 321,482.83 6,326,650.85 7,177,884.94 851,234.09 88.14%