Loading...
HomeMy WebLinkAboutJuly 20 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 347019 - Site Mowing 53,260.80 53,260.80 95,000.00 41,739.20 43.94% 347021 - Tree Maintenance 1,456.00 50,525.00 160,000.00 109,475.00 68.42% Total Culture & Recreation 54,716.80 103,785.80 255,000.00 151,214.20 59.30% Total Charges for Services 54,716.80 103,785.80 255,000.00 151,214.20 59.30% Miscellaneous Revenue 360000 - Miscellaneous - 2,647.27 10,000.00 7,352.73 73.53% Total Miscellaneous Revenue - 2,647.27 10,000.00 7,352.73 73.53% Refunds & Reimbursements 380000 - Misc Reimbursements (113,541.69) (67,215.37) - 67,215.37 0.00% 381000 - Misc Reimbursements - - 1,056.00 1,056.00 100.00% Total Refunds & Reimbursements (113,541.69) (67,215.37) 1,056.00 68,271.37 6465.09% Total Revenue (58,824.89) 39,217.70 266,056.00 226,838.30 85.26% 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 58,485.79 462,165.09 - 462,165.09 849,449.00 387,283.91 45.59% 410002 - Teamster Wages 109,627.37 795,930.79 - 795,930.79 1,340,141.00 544,210.21 40.61% 410003 - Permanent Part Time 28,983.01 213,087.13 - 213,087.13 190,000.00 (23,087.13) (12.15%) 410004 - Extra & Overtime 8,229.93 36,718.71 - 36,718.71 56,300.00 19,581.29 34.78% 410005 - Seasonal & Interns 37,664.85 109,708.34 - 109,708.34 333,000.00 223,291.66 67.05% 410007 - Longevity Pay 150.00 4,350.00 - 4,350.00 7,450.00 3,100.00 41.61% Total Salaries & Wages 243,140.95 1,621,960.06 - 1,621,960.06 2,776,340.00 1,154,379.94 41.58% Employee Benefits 411001 - FICA Regular 17,871.00 120,688.03 - 120,688.03 214,256.00 93,567.97 43.67% 411004 - PERF Regular 19,787.48 142,853.18 - 142,853.18 255,106.00 112,252.82 44.00% 411005 - PERF Union 1,355.55 10,127.43 - 10,127.43 21,335.00 11,207.57 52.53% 411007 - Unemployment Comp 17.65 130.11 - 130.11 225.00 94.89 42.17% 411008 - Health Insurance 48,834.62 332,800.83 - 332,800.83 545,689.00 212,888.17 39.01% 411009 - Life Insurance 480.02 3,285.14 - 3,285.14 5,640.00 2,354.86 41.75% 411014 - Parental Leave 615.00 4,541.66 - 4,541.66 7,887.00 3,345.34 42.42% 411200 - Clothing Allowance - 123.04 - 123.04 - (123.04) 0.00% 411201 - Tool Allowance 347.69 565.79 427.61 993.40 4,428.00 3,434.60 77.57% 411203 - Job Readiness Allow. - 13,918.75 - 13,918.75 14,450.00 531.25 3.68% 411206 - Cell Phone Allowance 495.00 3,685.00 - 3,685.00 5,940.00 2,255.00 37.96% Total Employee Benefits 89,804.01 632,718.96 427.61 633,146.57 1,074,956.00 441,809.43 41.10% Total Personnel Expenditures 332,944.96 2,254,679.02 427.61 2,255,106.63 3,851,296.00 1,596,189.37 41.45% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 34.79 264.77 - 264.77 500.00 235.23 47.05% 421002 - Stationary & Printing - - - - 5,000.00 5,000.00 100.00% Total Office Supplies 34.79 264.77 - 264.77 5,500.00 5,235.23 95.19% Operating Supplies July 31, 2020 422000 - Other Operating Supplies 12,444.70 98,497.54 33,849.63 132,347.17 172,931.00 40,583.83 23.47% 422001 - C.S. Gasoline 11,308.92 63,119.36 - 63,119.36 165,000.00 101,880.64 61.75% 422003 - Gasoline - - - - 3,196.00 3,196.00 100.00% 422004 - Oil 432.30 432.30 525.55 957.85 1,000.00 42.15 4.22% 422005 - Uniforms - 11,360.45 - 11,360.45 22,000.00 10,639.55 48.36% 422007 - Cleaning Supplies 38.44 170.00 - 170.00 100.00 (70.00) (70.00%) 422008 - Medical/Safety Supplies 299.67 5,552.66 113.84 5,666.50 6,573.00 906.50 13.79% 422010 - Plants Chemicals Seed & Fertilizer 4,406.64 31,361.90 5,750.13 37,112.03 75,990.00 38,877.97 51.16% Total Operating Supplies 28,930.67 210,494.21 40,239.15 250,733.36 446,790.00 196,056.64 43.88% Repair & Maintenance Supplies 423000 - Other R&M Supplies 5,588.70 22,171.54 9,148.94 31,320.48 156,429.00 125,108.52 79.98% 423001 - Building Materials 19,835.38 52,442.33 5,332.20 57,774.53 89,868.00 32,093.47 35.71% 423006 - Small Tools & Equipment 1,052.33 15,632.75 99.99 15,732.74 30,053.00 14,320.26 47.65% 423009 - Repair Parts 3,872.14 39,665.50 3,375.17 43,040.67 65,179.00 22,138.33 33.97% Total Repair & Maintenance Supplies 30,348.55 129,912.12 17,956.30 147,868.42 341,529.00 193,660.58 56.70% Total Supplies Expenditures 59,314.01 340,671.10 58,195.45 398,866.55 793,819.00 394,952.45 49.75% Services & Charges Expenditures Professional Services 431000 - Other Professional Services - 921.86 - 921.86 1,000.00 78.14 7.81% 431009 - Computer & Technology 87.72 175.44 - 175.44 500.00 324.56 64.91% 431014 - Collection Costs - - - - 500.00 500.00 100.00% Total Professional Services 87.72 1,097.30 - 1,097.30 2,000.00 902.70 45.14% Communication & Transportation 432000 - Other Communication/Transp. 16.00 24.00 - 24.00 - (24.00) 0.00% 432002 - Mailing - 8.40 - 8.40 500.00 491.60 98.32% 432003 - Travel - 842.64 - 842.64 2,250.00 1,407.36 62.55% 432004 - Telecommunications - 1,383.67 - 1,383.67 7,000.00 5,616.33 80.23% Total Communication & Transportation 16.00 2,258.71 - 2,258.71 9,750.00 7,491.29 76.83% Printing & Advertising 433001 - Outside Printing Services 106.32 148.32 - 148.32 1,733.00 1,584.68 91.44% 433002 - Publication of Legal Notice - 277.97 1,814.00 2,091.97 3,000.00 908.03 30.27% Total Printing & Advertising 106.32 426.29 1,814.00 2,240.29 4,733.00 2,492.71 52.67% Utilties 435001 - Electric 70,782.57 286,905.11 - 286,905.11 324,093.00 37,187.89 11.47% 435002 - Natural Gas 4,729.99 61,905.78 - 61,905.78 70,556.00 8,650.22 12.26% 435004 - Water 28,360.03 82,854.69 115,144.79 197,999.48 198,000.00 0.52 0.00% Total Utilities 103,872.59 431,665.58 115,144.79 546,810.37 592,649.00 45,838.63 7.73% Repairs & Maintenance 436000 - Other R&M 1,574.00 57,103.76 10,279.99 67,383.75 67,308.00 (75.75) (0.11%) 436001 - Building R&M 11,990.63 34,881.41 8,668.30 43,549.71 87,284.00 43,734.29 50.11% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 25,117.18 218,982.03 - 218,982.03 240,000.00 21,017.97 8.76% 436005 - Other Equip R&M - - - - 6,710.00 6,710.00 100.00% 436006 - Radio Equip R&M 558.77 5,542.66 - 5,542.66 16,500.00 10,957.34 66.41% 436011 - Exterminating 1,677.50 1,677.50 4,412.50 6,090.00 7,500.00 1,410.00 18.80% Total Repairs & Maintenance 40,918.08 318,187.36 23,360.79 341,548.15 433,802.00 92,253.85 21.27% Debt Service 438100 - Principal 25,322.67 155,627.46 - 155,627.46 297,875.00 142,247.54 47.75% 438200 - Interest 317.01 4,056.44 - 4,056.44 11,978.00 7,921.56 66.13% Total Debt Service 25,639.68 159,683.90 - 159,683.90 309,853.00 150,169.10 48.46% Other Charges & Services 439000 - Misc Charges & Svcs 42,514.12 211,247.21 95,635.17 306,882.38 359,037.00 52,154.62 14.53% 439001 - Other Contractual Services 523.76 771.02 4,235.50 5,006.52 - (5,006.52) 0.00% 439002 - Licenses & Permits 131.98 131.98 - 131.98 - (131.98) 0.00% 439003 - Subscriptions - 65.00 - 65.00 745.00 680.00 91.28% 439004 - Dues & Memberships - 129.00 - 129.00 1,875.00 1,746.00 93.12% 439006 - Education & Training 308.00 4,514.00 - 4,514.00 15,075.00 10,561.00 70.06% 439009 - Trash Removal 636.69 12,790.26 7,373.59 20,163.85 32,973.00 12,809.15 38.85% Total Other Services & Charges 44,114.55 229,648.47 107,244.26 336,892.73 409,705.00 72,812.27 17.77% Total Services & Charges Expenditures 214,754.94 1,142,967.61 247,563.84 1,390,531.45 1,762,492.00 371,960.55 21.10% 444000 - Land Improvements - 120,892.89 - 120,892.89 120,893.00 0.11 0.00% Other Uses 452002 - Allocations-Admin Cost 30,041.00 210,285.00 - 210,285.00 360,490.00 150,205.00 41.67% 452009 - Allocations-Facilities Mgmt 1,195.00 8,367.00 - 8,367.00 14,342.00 5,975.00 41.66% Total Other Uses 31,236.00 218,652.00 - 218,652.00 374,832.00 156,180.00 41.67% Total Expenditures 638,249.91 3,956,969.73 306,186.90 4,263,156.63 6,782,439.00 2,519,282.37 37.14%