Loading...
HomeMy WebLinkAboutSept 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 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 31,206.52 97,557.76 120,000.00 22,442.24 81.30% 347023 - Graffiti Removal - 1,482.15 102,529.00 101,046.85 1.45% Total Culture & Recreation 46,206.52 215,267.50 392,529.00 177,261.50 54.84% Total Charges for Services 46,206.52 215,267.50 392,529.00 177,261.50 54.84% Miscellaneous Revenue 360000 - Miscellaneous - - 10,000.00 10,000.00 0.00% 360001 - Sale of Scrap Metal 180.89 1,016.98 - (1,016.98) 0.00% 367000 - Donations from Private Sources - 17,320.00 - (17,320.00) 0.00% Total Miscellaneous Revenue 180.89 18,336.98 10,000.00 (8,336.98) 183.37% 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 196,610.00 262,145.00 65,535.00 75.00% 392000 - Gain/Loss on Sale of Asset - 17,250.00 - (17,250.00) 0.00% Total Other Sources 21,845.00 213,860.00 262,145.00 48,285.00 81.58% Total Revenue 68,232.41 450,611.16 666,677.00 216,065.84 67.59% 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 54,593.60 552,218.57 - 552,218.57 655,358.00 103,139.43 84.26% 410002 - Teamster Wages 102,197.79 1,008,440.59 - 1,008,440.59 1,313,543.00 305,102.41 76.77% 410003 - Permanent Part Time 22,601.87 212,885.48 - 212,885.48 243,392.00 30,506.52 87.47% 410004 - Extra & Overtime 7,863.90 73,381.14 - 73,381.14 89,552.00 16,170.86 81.94% 410005 - Seasonal & Interns 28,192.15 190,186.53 - 190,186.53 324,200.00 134,013.47 58.66% 410007 - Longevity Pay 700.00 6,050.00 - 6,050.00 7,450.00 1,400.00 81.21% 410014 - Contract Add Pays 340.04 340.04 - 340.04 1,000.00 659.96 34.00% Total Salaries & Wages 216,489.35 2,043,502.35 - 2,043,502.35 2,634,495.00 590,992.65 77.57% Employee Benefits 411001 - FICA Regular 15,998.40 153,249.59 - 153,249.59 203,405.00 50,155.41 75.34% 411004 - PERF Regular 18,167.12 181,529.11 - 181,529.11 246,645.00 65,115.89 73.60% 411005 - PERF Union 1,359.50 12,889.64 - 12,889.64 21,536.00 8,646.36 59.85% 411007 - Unemployment Comp 53.61 515.52 - 515.52 634.00 118.48 81.31% 411008 - Health Insurance 46,850.62 438,851.98 - 438,851.98 534,078.00 95,226.02 82.17% 411009 - Life Insurance 455.00 4,260.00 - 4,260.00 5,520.00 1,260.00 77.17% 411014 - Parental Leave 578.34 5,722.03 - 5,722.03 7,622.00 1,899.97 75.07% 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 4,235.00 - 4,235.00 5,940.00 1,705.00 71.30% Total Employee Benefits 83,902.59 817,890.90 - 817,890.90 1,043,830.00 225,939.10 78.35% September 30, 2021 Total Personnel Expenditures 300,391.94 2,861,393.25 - 2,861,393.25 3,678,325.00 816,931.75 77.79% Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 596.58 - 596.58 597.00 0.42 99.93% 421002 - Stationary & Printing - 2,966.00 - 2,966.00 6,522.00 3,556.00 45.48% Total Office Supplies - 3,562.58 - 3,562.58 7,119.00 3,556.42 50.04% Operating Supplies 422000 - Other Operating Supplies 8,054.06 164,715.07 24,099.64 188,814.71 186,963.20 (1,851.51) 100.99% 422001 - C.S. Gasoline 14,798.45 119,686.26 - 119,686.26 158,371.00 38,684.74 75.57% 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 77.14 1,217.11 - 1,217.11 1,433.00 215.89 84.93% 422008 - Medical/Safety Supplies 642.53 17,207.14 - 17,207.14 16,547.19 (659.95) 103.99% 422010 - Plants Chemicals Seed & Fertilizer 2,175.88 29,300.86 15,625.92 44,926.78 69,377.00 24,450.22 64.76% Total Operating Supplies 25,748.06 332,446.37 39,725.56 372,171.93 435,416.39 63,244.46 85.47% Repair & Maintenance Supplies 423000 - Other R&M Supplies 19,252.96 82,989.89 22,001.58 104,991.47 208,963.86 103,972.39 50.24% 423001 - Building Materials 1,078.16 26,178.23 9,285.40 35,463.63 67,363.51 31,899.88 52.65% 423006 - Small Tools & Equipment 1,815.24 20,606.09 2,966.75 23,572.84 25,573.00 2,000.16 92.18% 423009 - Repair Parts 7,774.32 46,502.47 15,972.05 62,474.52 75,020.30 12,545.78 83.28% Total Repair & Maintenance Supplies 29,920.68 176,276.68 50,225.78 226,502.46 376,920.67 150,418.21 60.09% Total Supplies Expenditures 55,668.74 512,285.63 89,951.34 602,236.97 819,456.06 217,219.09 73.49% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 195.00 5,745.10 9,725.00 15,470.10 16,317.00 846.90 94.81% 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 2,836.00 17,657.93 92.00 17,749.93 103,344.00 85,594.07 17.18% Total Professional Services 3,031.00 24,001.99 9,817.00 33,818.99 120,316.00 86,497.01 28.11% 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,642.22 2,337.78 3,980.00 7,000.00 3,020.00 56.86% Total Communication & Transportation 116.96 1,786.10 2,337.78 4,123.88 9,250.00 5,126.12 44.58% Printing & Advertising 433001 - Outside Printing Services - 89.00 - 89.00 2,000.00 1,911.00 4.45% 433002 - Publication of Legal Notice 113.40 553.24 680.86 1,234.10 2,322.74 1,088.64 53.13% Total Printing & Advertising 113.40 642.24 680.86 1,323.10 4,322.74 2,999.64 30.61% Utilties 435001 - Electric 36,416.35 331,692.90 - 331,692.90 324,359.00 (7,333.90) 102.26% 435002 - Natural Gas 2,786.81 105,924.88 - 105,924.88 113,963.00 8,038.12 92.95% 435004 - Water 37,728.13 232,856.46 - 232,856.46 233,000.00 143.54 99.94% Total Utilities 76,931.29 670,474.24 - 670,474.24 671,322.00 847.76 99.87% Repairs & Maintenance 436000 - Other R&M 336.92 29,014.32 13,952.12 42,966.44 44,981.12 2,014.68 95.52% 436001 - Building R&M 7,600.12 98,206.40 24,780.25 122,986.65 128,028.44 5,041.79 96.06% 436003 - Auto Equip R&M 22,160.01 320,747.12 - 320,747.12 265,381.00 (55,366.12) 120.86% 436005 - Other Equip R&M 177.07 411.07 - 411.07 1,159.00 747.93 35.47% 436006 - Radio Equip R&M 466.00 10,233.60 - 10,233.60 9,772.00 (461.60) 104.72% 436011 - Exterminating 914.00 7,225.64 5,872.00 13,097.64 16,739.00 3,641.36 78.25% Total Repairs & Maintenance 31,654.12 465,838.15 44,604.37 510,442.52 466,060.56 (44,381.96) 109.52% Debt Service 438100 - Principal - 120,878.51 - 120,878.51 225,467.00 104,588.49 53.61% 438200 - Interest - 1,759.43 - 1,759.43 2,543.00 783.57 69.19% Total Debt Service - 122,637.94 - 122,637.94 228,010.00 105,372.06 53.79% Other Charges & Services 439000 - Misc Charges & Svcs 24,621.75 164,773.14 43,712.47 208,485.61 283,027.54 74,541.93 73.66% 439001 - Other Contractual Services 2,361.73 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 - - - - 666.00 666.00 0.00% 439004 - Dues & Memberships - 125.00 - 125.00 2,375.00 2,250.00 5.26% 439006 - Education & Training - 3,059.50 169.00 3,228.50 13,363.00 10,134.50 24.16% 439009 - Trash Removal 2,831.15 19,897.42 8,999.01 28,896.43 29,743.18 846.75 97.15% 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 29,814.63 215,571.62 56,003.34 271,574.96 360,172.58 88,597.62 75.40% Total Services & Charges Expenditures 141,661.40 1,500,952.28 113,443.35 1,614,395.63 1,859,453.88 245,058.25 86.82% 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 245,448.00 - 245,448.00 327,264.00 81,816.00 75.00% 452004 - Allocations-Liability Insurance 5,441.00 48,966.00 - 48,966.00 65,289.00 16,323.00 75.00% 452009 - Allocations-Facilities Mgmt 1,436.00 12,922.00 - 12,922.00 17,230.00 4,308.00 75.00% Total Other Uses 34,149.00 307,336.00 - 307,336.00 409,783.00 102,447.00 75.00% Total Expenditures 531,871.08 5,195,939.66 322,263.89 5,518,203.55 7,177,884.94 1,659,681.39 76.88%