Loading...
HomeMy WebLinkAboutAug 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 30,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 70.00 66,351.24 120,000.00 53,648.76 55.29% 347023 - Graffiti Removal - 1,482.15 102,529.00 101,046.85 1.45% Total Culture & Recreation 30,070.00 169,060.98 392,529.00 223,468.02 43.07% Total Charges for Services 30,070.00 169,060.98 392,529.00 223,468.02 43.07% Miscellaneous Revenue 360000 - Miscellaneous - - 10,000.00 10,000.00 0.00% 360001 - Sale of Scrap Metal 436.50 836.09 - (836.09) 0.00% 367000 - Donations from Private Sources - 17,320.00 - (17,320.00) 0.00% Total Miscellaneous Revenue 436.50 18,156.09 10,000.00 (8,156.09) 181.56% Refunds & Reimbursements 380000 - Misc Reimbursements - 180.94 - (180.94) 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 - 3,146.68 2,003.00 (1,143.68) 157.10% Other Sources 391000 - Interfund Transfers In 21,845.00 174,765.00 262,145.00 87,380.00 66.67% 392000 - Gain/Loss on Sale of Asset 17,250.00 17,250.00 - (17,250.00) 0.00% Total Other Sources 39,095.00 192,015.00 262,145.00 70,130.00 73.25% Total Revenue 69,601.50 382,378.75 666,677.00 284,298.25 57.36% 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 55,341.59 497,624.97 - 497,624.97 704,502.00 206,877.03 70.63% 410002 - Teamster Wages 106,928.19 906,242.80 - 906,242.80 1,313,543.00 407,300.20 68.99% 410003 - Permanent Part Time 24,207.94 190,283.61 - 190,283.61 207,500.00 17,216.39 91.70% 410004 - Extra & Overtime 13,753.00 65,517.24 - 65,517.24 77,300.00 11,782.76 84.76% 410005 - Seasonal & Interns 44,642.28 161,994.38 - 161,994.38 324,200.00 162,205.62 49.97% 410007 - Longevity Pay 500.00 5,350.00 - 5,350.00 7,450.00 2,100.00 71.81% Total Salaries & Wages 245,373.00 1,827,013.00 - 1,827,013.00 2,634,495.00 807,482.00 69.35% Employee Benefits 411001 - FICA Regular 18,215.23 137,251.19 - 137,251.19 203,405.00 66,153.81 67.48% 411004 - PERF Regular 19,126.67 163,361.99 - 163,361.99 246,645.00 83,283.01 66.23% 411005 - PERF Union 1,400.27 11,530.14 - 11,530.14 21,536.00 10,005.86 53.54% 411007 - Unemployment Comp 56.46 461.91 - 461.91 634.00 172.09 72.86% 411008 - Health Insurance 46,920.22 392,001.36 - 392,001.36 534,078.00 142,076.64 73.40% 411009 - Life Insurance 460.00 3,805.00 - 3,805.00 5,520.00 1,715.00 68.93% 411014 - Parental Leave 609.51 5,143.69 - 5,143.69 7,622.00 2,478.31 67.48% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance - 988.03 - 988.03 2,800.00 1,811.97 35.29% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 14,450.00 - 100.00% 411206 - Cell Phone Allowance 440.00 3,795.00 - 3,795.00 5,940.00 2,145.00 63.89% Total Employee Benefits 87,228.36 733,988.31 - 733,988.31 1,043,830.00 309,841.69 70.32% Total Personnel Expenditures 332,601.36 2,561,001.31 - 2,561,001.31 3,678,325.00 1,117,323.69 69.62% August 31, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies 6.17 596.58 - 596.58 597.00 0.42 99.93% 421002 - Stationary & Printing 105.00 2,966.00 - 2,966.00 6,522.00 3,556.00 45.48% Total Office Supplies 111.17 3,562.58 - 3,562.58 7,119.00 3,556.42 50.04% Operating Supplies 422000 - Other Operating Supplies 8,898.49 156,661.01 18,105.97 174,766.98 173,463.20 (1,303.78) 100.75% 422001 - C.S. Gasoline 16,838.52 104,887.81 - 104,887.81 164,871.00 59,983.19 63.62% 422003 - Gasoline - - - - 2,405.00 2,405.00 0.00% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 320.00 0.07 99.98% 422007 - Cleaning Supplies 713.95 1,139.97 - 1,139.97 1,433.00 293.03 79.55% 422008 - Medical/Safety Supplies 4,891.89 16,564.61 - 16,564.61 16,547.19 (17.42) 100.11% 422010 - Plants Chemicals Seed & Fertilizer 4,470.80 27,124.98 3,119.00 30,243.98 69,377.00 39,133.02 43.59% Total Operating Supplies 35,813.65 306,698.31 21,224.97 327,923.28 428,416.39 100,493.11 76.54% Repair & Maintenance Supplies 423000 - Other R&M Supplies 4,801.20 63,736.93 36,944.67 100,681.60 215,963.86 115,282.26 46.62% 423001 - Building Materials 1,182.10 25,100.07 2,504.36 27,604.43 67,363.51 39,759.08 40.98% 423006 - Small Tools & Equipment 248.05 18,790.85 2,966.75 21,757.60 25,573.00 3,815.40 85.08% 423009 - Repair Parts 4,300.76 38,728.15 18,916.26 57,644.41 75,020.30 17,375.89 76.84% Total Repair & Maintenance Supplies 10,532.11 146,356.00 61,332.04 207,688.04 383,920.67 176,232.63 54.10% Total Supplies Expenditures 46,456.93 456,616.89 82,557.01 539,173.90 819,456.06 280,282.16 65.80% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 2,735.28 5,550.10 9,895.00 15,445.10 16,317.00 871.90 94.66% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431009 - Computer & Technology 243.96 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 - 14,821.93 2,928.00 17,749.93 152,211.00 134,461.07 11.66% Total Professional Services 2,979.24 20,970.99 12,823.00 33,793.99 169,183.00 135,389.01 19.97% Communication & Transportation 432002 - Mailing - 143.88 - 143.88 144.00 0.12 99.92% 432003 - Travel - - - - 2,106.00 2,106.00 0.00% 432004 - Telecommunications 116.96 1,525.26 2,454.74 3,980.00 9,000.00 5,020.00 44.22% Total Communication & Transportation 116.96 1,669.14 2,454.74 4,123.88 11,250.00 7,126.12 36.66% Printing & Advertising 433001 - Outside Printing Services - 89.00 - 89.00 2,000.00 1,911.00 4.45% 433002 - Publication of Legal Notice - 439.84 243.40 683.24 2,322.74 1,639.50 29.42% Total Printing & Advertising - 528.84 243.40 772.24 4,322.74 3,550.50 17.86% Utilties 435001 - Electric 40,173.87 295,276.55 - 295,276.55 324,359.00 29,082.45 91.03% 435002 - Natural Gas 2,271.08 103,138.07 - 103,138.07 113,963.00 10,824.93 90.50% 435004 - Water 44,089.96 195,128.33 - 195,128.33 196,000.00 871.67 99.56% Total Utilities 86,534.91 593,542.95 - 593,542.95 634,322.00 40,779.05 93.57% Repairs & Maintenance 436000 - Other R&M 6,526.90 28,677.40 13,952.12 42,629.52 44,981.12 2,351.60 94.77% 436001 - Building R&M 9,475.23 90,606.28 31,270.43 121,876.71 128,028.44 6,151.73 95.20% 436003 - Auto Equip R&M 37,198.54 298,587.11 - 298,587.11 265,381.00 (33,206.11) 112.51% 436005 - Other Equip R&M 234.00 234.00 - 234.00 1,159.00 925.00 20.19% 436006 - Radio Equip R&M 1,618.85 9,767.60 - 9,767.60 7,772.00 (1,995.60) 125.68% 436011 - Exterminating 635.00 6,311.64 6,786.00 13,097.64 16,739.00 3,641.36 78.25% Total Repairs & Maintenance 55,688.52 434,184.03 52,008.55 486,192.58 464,060.56 (22,132.02) 104.77% Debt Service 438100 - Principal 130.77 120,878.51 - 120,878.51 225,467.00 104,588.49 53.61% 438200 - Interest 1.04 1,759.43 - 1,759.43 2,543.00 783.57 69.19% Total Debt Service 131.81 122,637.94 - 122,637.94 228,010.00 105,372.06 53.79% Other Charges & Services 439000 - Misc Charges & Svcs 28,210.38 140,151.39 61,375.37 201,526.76 202,961.54 1,434.78 99.29% 439001 - Other Contractual Services - 430.00 5,484.59 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 - - - - 666.00 666.00 0.00% 439004 - Dues & Memberships - 125.00 - 125.00 2,375.00 2,250.00 5.26% 439006 - Education & Training 1,220.00 3,059.50 169.00 3,228.50 13,363.00 10,134.50 24.16% 439009 - Trash Removal 2,273.72 17,066.27 10,803.74 27,870.01 28,743.18 873.17 96.96% 439012 - Uniform Services 1,606.65 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 33,310.75 185,756.99 77,832.70 263,589.69 279,106.58 15,516.89 94.44% Total Services & Charges Expenditures 178,762.19 1,359,290.88 145,362.39 1,504,653.27 1,790,254.88 285,601.61 84.05% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - 10,866.86 10,866.86 - (10,866.86) 0.00% 445003 - Park Equipment - 13,972.50 10,527.50 24,500.00 400,000.00 375,500.00 6.13% Total Machinery & Equipment - 13,972.50 21,394.36 35,366.86 400,000.00 364,633.14 8.84% Total Capital Expenditures - 13,972.50 21,394.36 35,366.86 400,000.00 364,633.14 8.84% Other Uses 452002 - Allocations-Admin Cost 27,272.00 218,176.00 - 218,176.00 327,264.00 109,088.00 66.67% 452004 - Allocations-Liability Insurance 5,441.00 43,525.00 - 43,525.00 65,289.00 21,764.00 66.67% 452009 - Allocations-Facilities Mgmt 1,436.00 11,486.00 - 11,486.00 17,230.00 5,744.00 66.66% Total Other Uses 34,149.00 273,187.00 - 273,187.00 409,783.00 136,596.00 66.67% Total Expenditures 591,969.48 4,664,068.58 249,313.76 4,913,382.34 7,097,818.94 2,184,436.60 69.22%