Loading...
HomeMy WebLinkAboutAug 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 21,849.60 75,110.40 95,000.00 19,889.60 20.94% 347021 - Tree Maintenance 1,169.86 51,694.86 160,000.00 108,305.14 67.69% Total Culture & Recreation 23,019.46 126,805.26 255,000.00 128,194.74 50.27% Total Charges for Services 23,019.46 126,805.26 255,000.00 128,194.74 50.27% Miscellaneous Revenue 360000 - Miscellaneous 42.86 2,690.13 10,000.00 7,309.87 73.10% Total Miscellaneous Revenue 42.86 2,690.13 10,000.00 7,309.87 73.10% Refunds & Reimbursements 380000 - Misc Reimbursements - (67,215.37) - 67,215.37 0.00% 381000 - Misc Reimbursements 1,055.99 1,055.99 1,056.00 0.01 0.00% Total Refunds & Reimbursements 1,055.99 (66,159.38) 1,056.00 67,215.38 6365.09% Total Revenue 24,118.31 63,336.01 266,056.00 202,719.99 76.19% 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 520,650.88 - 520,650.88 849,449.00 328,798.12 38.71% 410002 - Teamster Wages 109,834.19 905,764.98 - 905,764.98 1,340,141.00 434,376.02 32.41% 410003 - Permanent Part Time 29,176.29 242,263.42 - 242,263.42 290,000.00 47,736.58 16.46% 410004 - Extra & Overtime 6,953.29 43,672.00 - 43,672.00 56,300.00 12,628.00 22.43% 410005 - Seasonal & Interns 39,549.12 149,257.46 - 149,257.46 233,000.00 83,742.54 35.94% 410007 - Longevity Pay 500.00 4,850.00 - 4,850.00 7,450.00 2,600.00 34.90% Total Salaries & Wages 244,498.68 1,866,458.74 - 1,866,458.74 2,776,340.00 909,881.26 32.77% Employee Benefits 411001 - FICA Regular 18,039.77 138,727.80 - 138,727.80 214,256.00 75,528.20 35.25% 411004 - PERF Regular 19,220.10 162,073.28 - 162,073.28 255,106.00 93,032.72 36.47% 411005 - PERF Union 1,346.88 11,474.31 - 11,474.31 21,335.00 9,860.69 46.22% 411007 - Unemployment Comp 17.52 147.63 - 147.63 225.00 77.37 34.39% 411008 - Health Insurance 48,834.62 381,635.45 - 381,635.45 545,689.00 164,053.55 30.06% 411009 - Life Insurance 480.02 3,765.16 - 3,765.16 5,640.00 1,874.84 33.24% 411014 - Parental Leave 614.43 5,156.09 - 5,156.09 7,887.00 2,730.91 34.63% 411200 - Clothing Allowance - 123.04 - 123.04 - (123.04) 0.00% 411201 - Tool Allowance - 565.79 624.47 1,190.26 4,428.00 3,237.74 73.12% 411203 - Job Readiness Allow. - 13,918.75 - 13,918.75 14,450.00 531.25 3.68% 411206 - Cell Phone Allowance 495.00 4,180.00 - 4,180.00 5,940.00 1,760.00 29.63% Total Employee Benefits 89,048.34 721,767.30 624.47 722,391.77 1,074,956.00 352,564.23 32.80% Total Personnel Expenditures 333,547.02 2,588,226.04 624.47 2,588,850.51 3,851,296.00 1,262,445.49 32.78% Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 264.77 - 264.77 500.00 235.23 47.05% 421002 - Stationary & Printing - - - - 5,000.00 5,000.00 100.00% Total Office Supplies - 264.77 - 264.77 5,500.00 5,235.23 95.19% Operating Supplies August 31, 2020 422000 - Other Operating Supplies 16,407.70 114,905.24 28,424.31 143,329.55 172,931.00 29,601.45 17.12% 422001 - C.S. Gasoline 13,574.51 76,693.87 - 76,693.87 165,000.00 88,306.13 53.52% 422003 - Gasoline - - - - 3,196.00 3,196.00 100.00% 422004 - Oil 525.55 957.85 - 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 23.28 193.28 - 193.28 100.00 (93.28) (93.28%) 422008 - Medical/Safety Supplies 190.67 5,743.33 113.84 5,857.17 6,573.00 715.83 10.89% 422010 - Plants Chemicals Seed & Fertilizer 1,722.50 33,084.40 12,674.63 45,759.03 75,990.00 30,230.97 39.78% Total Operating Supplies 32,444.21 242,938.42 41,212.78 284,151.20 446,790.00 162,638.80 36.40% Repair & Maintenance Supplies 423000 - Other R&M Supplies 8,023.81 30,195.35 83,332.50 113,527.85 156,429.00 42,901.15 27.43% 423001 - Building Materials 1,495.73 53,938.06 4,861.18 58,799.24 89,868.00 31,068.76 34.57% 423006 - Small Tools & Equipment 507.23 16,139.98 99.99 16,239.97 30,053.00 13,813.03 45.96% 423009 - Repair Parts 2,467.57 42,133.07 4,601.34 46,734.41 65,179.00 18,444.59 28.30% Total Repair & Maintenance Supplies 12,494.34 142,406.46 92,895.01 235,301.47 341,529.00 106,227.53 31.10% Total Supplies Expenditures 44,938.55 385,609.65 134,107.79 519,717.44 793,819.00 274,101.56 34.53% Services & Charges Expenditures Professional Services 431000 - Other Professional Services - 921.86 143.80 1,065.66 1,000.00 (65.66) (6.57%) 431009 - Computer & Technology 228.00 403.44 - 403.44 500.00 96.56 19.31% 431014 - Collection Costs - - - - 500.00 500.00 100.00% Total Professional Services 228.00 1,325.30 143.80 1,469.10 2,000.00 530.90 26.55% Communication & Transportation 432000 - Other Communication/Transp. - 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 - 2,258.71 - 2,258.71 9,750.00 7,491.29 76.83% Printing & Advertising 433001 - Outside Printing Services - 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 - 426.29 1,814.00 2,240.29 4,733.00 2,492.71 52.67% Utilties 435001 - Electric 50,339.05 337,244.16 - 337,244.16 324,093.00 (13,151.16) (4.06%) 435002 - Natural Gas - 61,905.78 - 61,905.78 70,556.00 8,650.22 12.26% 435004 - Water 36,058.83 118,913.52 79,085.96 197,999.48 198,000.00 0.52 0.00% Total Utilities 86,397.88 518,063.46 79,085.96 597,149.42 592,649.00 (4,500.42) (0.76%) Repairs & Maintenance 436000 - Other R&M 905.00 58,008.76 14,274.99 72,283.75 67,308.00 (4,975.75) (7.39%) 436001 - Building R&M 4,091.80 38,973.21 5,422.30 44,395.51 87,284.00 42,888.49 49.14% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 51,705.11 270,687.14 - 270,687.14 240,000.00 (30,687.14) (12.79%) 436005 - Other Equip R&M 999.80 999.80 - 999.80 6,710.00 5,710.20 85.10% 436006 - Radio Equip R&M 1,790.15 7,332.81 - 7,332.81 16,500.00 9,167.19 55.56% 436011 - Exterminating 532.50 2,210.00 3,880.00 6,090.00 7,500.00 1,410.00 18.80% Total Repairs & Maintenance 60,024.36 378,211.72 23,577.29 401,789.01 433,802.00 32,012.99 7.38% Debt Service 438100 - Principal 491.64 156,119.10 - 156,119.10 297,875.00 141,755.90 47.59% 438200 - Interest 13.93 4,070.37 - 4,070.37 11,978.00 7,907.63 66.02% Total Debt Service 505.57 160,189.47 - 160,189.47 309,853.00 149,663.53 48.30% Other Charges & Services 439000 - Misc Charges & Svcs 27,378.09 238,625.30 119,176.17 357,801.47 359,037.00 1,235.53 0.34% 439001 - Other Contractual Services 277.40 1,048.42 3,958.10 5,006.52 - (5,006.52) 0.00% 439002 - Licenses & Permits - 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 1,399.99 5,913.99 - 5,913.99 15,075.00 9,161.01 60.77% 439009 - Trash Removal 1,960.21 14,750.47 8,898.38 23,648.85 32,973.00 9,324.15 28.28% Total Other Services & Charges 31,015.69 260,664.16 132,032.65 392,696.81 409,705.00 17,008.19 4.15% Total Services & Charges Expenditures 178,171.50 1,321,139.11 236,653.70 1,557,792.81 1,762,492.00 204,699.19 11.61% 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 240,326.00 - 240,326.00 360,490.00 120,164.00 33.33% 452009 - Allocations-Facilities Mgmt 1,195.00 9,562.00 - 9,562.00 14,342.00 4,780.00 33.33% Total Other Uses 31,236.00 249,888.00 - 249,888.00 374,832.00 124,944.00 33.33% Total Expenditures 587,893.07 4,544,862.80 371,385.96 4,916,248.76 6,782,439.00 1,866,190.24 27.52%