Loading...
HomeMy WebLinkAboutJuly 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 70,000.00 75,000.00 5,000.00 93.33% 347019 - Site Mowing - 1,227.59 95,000.00 93,772.41 1.29% 347021 - Tree Maintenance 30,912.84 66,281.24 120,000.00 53,718.76 55.23% 347023 - Graffiti Removal - 1,482.15 102,529.00 101,046.85 1.45% Total Culture & Recreation 45,912.84 138,990.98 392,529.00 253,538.02 35.41% Total Charges for Services 45,912.84 138,990.98 392,529.00 253,538.02 35.41% Miscellaneous Revenue 360000 - Miscellaneous - - 10,000.00 10,000.00 0.00% 360001 - Sale of Scrap Metal - 399.59 - (399.59) 0.00% 367000 - Donations from Private Sources - 17,320.00 - (17,320.00) 0.00% Total Miscellaneous Revenue - 17,719.59 10,000.00 (7,719.59) 177.20% Refunds & Reimbursements 380000 - Misc Reimbursements 75.19 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 75.19 3,146.68 2,003.00 (1,143.68) 157.10% Other Sources 391000 - Interfund Transfers In 21,845.00 152,920.00 262,145.00 109,225.00 58.33% Total Other Sources 21,845.00 152,920.00 262,145.00 109,225.00 58.33% Total Revenue 67,833.03 312,777.25 666,677.00 353,899.75 46.92% 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,214.96 442,283.38 - 442,283.38 725,502.00 283,218.62 60.96% 410002 - Teamster Wages 110,444.34 799,314.61 - 799,314.61 1,353,543.00 554,228.39 59.05% 410003 - Permanent Part Time 24,262.38 166,075.67 - 166,075.67 167,500.00 1,424.33 99.15% 410004 - Extra & Overtime 10,698.47 51,764.24 - 51,764.24 56,300.00 4,535.76 91.94% 410005 - Seasonal & Interns 43,089.36 117,352.10 - 117,352.10 324,200.00 206,847.90 36.20% 410007 - Longevity Pay 150.00 4,850.00 - 4,850.00 7,450.00 2,600.00 65.10% Total Salaries & Wages 242,859.51 1,581,640.00 - 1,581,640.00 2,634,495.00 1,052,855.00 60.04% Employee Benefits 411001 - FICA Regular 18,013.34 119,035.96 - 119,035.96 203,405.00 84,369.04 58.52% 411004 - PERF Regular 19,272.70 144,235.32 - 144,235.32 246,645.00 102,409.68 58.48% 411005 - PERF Union 1,414.15 10,129.87 - 10,129.87 21,536.00 11,406.13 47.04% 411007 - Unemployment Comp 56.19 405.45 - 405.45 634.00 228.55 63.95% 411008 - Health Insurance 47,971.42 345,081.14 - 345,081.14 534,078.00 188,996.86 64.61% 411009 - Life Insurance 470.00 3,345.00 - 3,345.00 5,520.00 2,175.00 60.60% 411014 - Parental Leave 606.90 4,534.18 - 4,534.18 7,622.00 3,087.82 59.49% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance 213.24 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,355.00 - 3,355.00 5,940.00 2,585.00 56.48% Total Employee Benefits 88,457.94 646,759.95 - 646,759.95 1,043,830.00 397,070.05 61.96% Total Personnel Expenditures 331,317.45 2,228,399.95 - 2,228,399.95 3,678,325.00 1,449,925.05 60.58% July 31, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 590.41 - 590.41 517.00 (73.41) 114.20% 421002 - Stationary & Printing - 2,861.00 174.00 3,035.00 7,302.00 4,267.00 41.56% Total Office Supplies - 3,451.41 174.00 3,625.41 7,819.00 4,193.59 46.37% Operating Supplies 422000 - Other Operating Supplies 24,276.08 147,762.52 21,601.32 169,363.84 167,963.20 (1,400.64) 100.83% 422001 - C.S. Gasoline 15,064.03 88,049.29 - 88,049.29 164,871.00 76,821.71 53.40% 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 - 426.02 - 426.02 233.00 (193.02) 182.84% 422008 - Medical/Safety Supplies 2,942.10 11,672.72 - 11,672.72 12,547.19 874.47 93.03% 422010 - Plants Chemicals Seed & Fertilizer 4,196.63 22,654.18 5,436.33 28,090.51 69,377.00 41,286.49 40.49% Total Operating Supplies 46,478.84 270,884.66 27,037.65 297,922.31 417,716.39 119,794.08 71.32% Repair & Maintenance Supplies 423000 - Other R&M Supplies 4,370.03 58,935.73 10,327.04 69,262.77 225,963.86 156,701.09 30.65% 423001 - Building Materials 11,722.88 23,917.97 2,247.92 26,165.89 67,363.51 41,197.62 38.84% 423006 - Small Tools & Equipment 3,267.77 18,542.80 2,966.75 21,509.55 25,573.00 4,063.45 84.11% 423009 - Repair Parts 3,194.03 34,427.39 17,753.26 52,180.65 75,020.30 22,839.65 69.56% Total Repair & Maintenance Supplies 22,554.71 135,823.89 33,294.97 169,118.86 393,920.67 224,801.81 42.93% Total Supplies Expenditures 69,033.55 410,159.96 60,506.62 470,666.58 819,456.06 348,789.48 57.44% Services & Charges Expenditures Professional Services 431000 - Other Professional Services - 2,814.82 12,120.28 14,935.10 16,317.00 1,381.90 91.53% 431001 - Legal Services - 195.00 - 195.00 195.00 - 100.00% 431015 - Laboratory Water Testing - 160.00 - 160.00 160.00 - 100.00% 431019 - Security Services - 14,821.93 2,928.00 17,749.93 179,148.00 161,398.07 9.91% Total Professional Services - 17,991.75 15,048.28 33,040.03 195,820.00 162,779.97 16.87% 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 233.92 1,408.30 2,571.70 3,980.00 9,000.00 5,020.00 44.22% Total Communication & Transportation 233.92 1,552.18 2,571.70 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 31.20 439.84 272.74 712.58 2,322.74 1,610.16 30.68% Total Printing & Advertising 31.20 528.84 272.74 801.58 4,322.74 3,521.16 18.54% Utilties 435001 - Electric 37,002.90 255,102.68 - 255,102.68 324,259.00 69,156.32 78.67% 435002 - Natural Gas 4,314.00 100,866.99 - 100,866.99 105,563.00 4,696.01 95.55% 435004 - Water 39,185.00 151,038.37 - 151,038.37 198,000.00 46,961.63 76.28% Total Utilities 80,501.90 507,008.04 - 507,008.04 627,822.00 120,813.96 80.76% Repairs & Maintenance 436000 - Other R&M 5,086.00 22,150.50 20,392.12 42,542.62 44,981.12 2,438.50 94.58% 436001 - Building R&M 11,958.00 81,131.05 32,016.94 113,147.99 122,228.44 9,080.45 92.57% 436003 - Auto Equip R&M 46,298.24 261,388.57 - 261,388.57 277,991.00 16,602.43 94.03% 436005 - Other Equip R&M - - 234.00 234.00 1,159.00 925.00 20.19% 436006 - Radio Equip R&M 1,377.63 8,148.75 - 8,148.75 5,155.00 (2,993.75) 158.07% 436011 - Exterminating 914.00 5,676.64 7,421.00 13,097.64 18,739.00 5,641.36 69.90% Total Repairs & Maintenance 65,633.87 378,495.51 60,064.06 438,559.57 470,253.56 31,693.99 93.26% Debt Service 438100 - Principal 8,186.81 120,747.74 - 120,747.74 225,467.00 104,719.26 53.55% 438200 - Interest 62.68 1,758.39 - 1,758.39 2,543.00 784.61 69.15% Total Debt Service 8,249.49 122,506.13 - 122,506.13 228,010.00 105,503.87 53.73% Other Charges & Services 439000 - Misc Charges & Svcs 42,113.60 111,941.01 66,720.13 178,661.14 184,624.54 5,963.40 96.77% 439001 - Other Contractual Services - 430.00 3,122.86 3,552.86 3,122.86 (430.00) 113.77% 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 500.00 1,839.50 1,269.00 3,108.50 12,100.00 8,991.50 25.69% 439009 - Trash Removal 3,819.93 14,792.55 12,055.10 26,847.65 28,743.18 1,895.53 93.41% 439012 - Uniform Services 2,174.81 6,025.94 - 6,025.94 3,852.00 (2,173.94) 156.44% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 48,608.34 152,446.24 83,167.09 235,613.33 252,776.58 17,163.25 93.21% Total Services & Charges Expenditures 203,258.72 1,180,528.69 161,123.87 1,341,652.56 1,790,254.88 448,602.32 74.94% 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 190,904.00 - 190,904.00 327,264.00 136,360.00 58.33% 452004 - Allocations-Liability Insurance 5,441.00 38,084.00 - 38,084.00 65,289.00 27,205.00 58.33% 452009 - Allocations-Facilities Mgmt 1,436.00 10,050.00 - 10,050.00 17,230.00 7,180.00 58.33% Total Other Uses 34,149.00 239,038.00 - 239,038.00 409,783.00 170,745.00 58.33% Total Expenditures 637,758.72 4,072,099.10 243,024.85 4,315,123.95 7,097,818.94 2,782,694.99 60.80%