Loading...
HomeMy WebLinkAboutMay 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 - - 95,000.00 95,000.00 100.00% 347021 - Tree Maintenance 6,077.00 42,770.00 160,000.00 117,230.00 73.27% Total Culture & Recreation 6,077.00 42,770.00 255,000.00 212,230.00 83.23% Total Charges for Services 6,077.00 42,770.00 255,000.00 212,230.00 83.23% Miscellaneous Revenue 360000 - Miscellaneous 64.58 2,474.71 10,000.00 7,525.29 75.25% Total Miscellaneous Revenue 64.58 2,474.71 10,000.00 7,525.29 75.25% Refunds & Reimbursements 380000 - Misc Reimbursements - 46,326.32 - (46,326.32) 0.00% Total Refunds & Reimbursements - 46,326.32 - (46,326.32) 0.00% Total Revenue 6,141.58 91,571.03 265,000.00 173,428.97 65.44% EXPENDITURES Current YTD Total YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenditures Salaries & Wages 410001 - Salaried Wages 88,705.20 345,193.52 - 345,193.52 849,449.00 504,255.48 59.36% 410002 - Teamster Wages 161,325.10 576,721.42 - 576,721.42 1,340,141.00 763,419.58 56.97% 410003 - Permanent Part Time 41,083.44 156,440.06 - 156,440.06 190,000.00 33,559.94 17.66% 410004 - Extra & Overtime 646.98 21,478.62 - 21,478.62 56,300.00 34,821.38 61.85% 410005 - Seasonal & Interns 25,069.34 31,732.34 - 31,732.34 333,000.00 301,267.66 90.47% 410007 - Longevity Pay 500.00 3,700.00 - 3,700.00 7,450.00 3,750.00 50.34% Total Salaries & Wages 317,330.06 1,135,265.96 - 1,135,265.96 2,776,340.00 1,641,074.04 59.11% Employee Benefits 411001 - FICA Regular 23,656.12 84,938.16 - 84,938.16 214,256.00 129,317.84 60.36% 411004 - PERF Regular 27,373.10 103,776.76 - 103,776.76 255,106.00 151,329.24 59.32% 411005 - PERF Union 1,946.64 7,399.67 - 7,399.67 21,335.00 13,935.33 65.32% 411007 - Unemployment Comp 25.15 94.85 - 94.85 225.00 130.15 57.84% 411008 - Health Insurance 47,257.82 235,652.59 - 235,652.59 545,689.00 310,036.41 56.82% 411009 - Life Insurance 465.02 2,325.10 - 2,325.10 5,640.00 3,314.90 58.77% 411014 - Parental Leave 879.19 3,314.29 - 3,314.29 7,887.00 4,572.71 57.98% 411200 - Clothing Allowance - - - - - - 0.00% 411201 - Tool Allowance - 218.10 427.61 645.71 4,428.00 3,782.29 85.42% 411203 - Job Readiness Allow. - 13,918.75 - 13,918.75 14,450.00 531.25 3.68% 411206 - Cell Phone Allowance 495.00 2,695.00 - 2,695.00 5,940.00 3,245.00 54.63% Total Employee Benefits 102,098.04 454,333.27 427.61 454,760.88 1,074,956.00 620,195.12 57.69% Total Personnel Expenditures 419,428.10 1,589,599.23 427.61 1,590,026.84 3,851,296.00 2,261,269.16 58.71% Supplies Expenditures Office Supplies 421000 - Other Office Supplies 229.98 229.98 - 229.98 - (229.98) 0.00% 421002 - Stationary & Printing - - - - 5,000.00 5,000.00 100.00% Total Office Supplies 229.98 229.98 - 229.98 5,000.00 4,770.02 95.40% Operating Supplies 422000 - Other Operating Supplies 31,625.78 69,527.07 39,043.98 108,571.05 129,531.00 20,959.95 16.18% May 31, 2020 422001 - C.S. Gasoline 6,244.20 38,987.34 - 38,987.34 165,000.00 126,012.66 76.37% 422003 - Gasoline - - - - 3,196.00 3,196.00 100.00% 422005 - Uniforms - 10,995.54 - 10,995.54 22,000.00 11,004.46 50.02% 422007 - Cleaning Supplies 97.77 97.77 - 97.77 - (97.77) 0.00% 422008 - Medical/Safety Supplies 1,792.88 3,122.11 297.68 3,419.79 6,573.00 3,153.21 47.97% 422010 - Plants Chemicals Seed & Fertilizer 7,758.93 18,326.01 9,929.46 28,255.47 75,990.00 47,734.53 62.82% Total Operating Supplies 47,519.56 141,055.84 49,271.12 190,326.96 402,290.00 211,963.04 52.69% Repair & Maintenance Supplies 423000 - Other R&M Supplies 919.22 11,549.42 1,773.89 13,323.31 201,429.00 188,105.69 93.39% 423001 - Building Materials 4,337.87 30,696.89 1,047.48 31,744.37 69,868.00 38,123.63 54.57% 423006 - Small Tools & Equipment 3,578.00 10,170.59 188.87 10,359.46 30,053.00 19,693.54 65.53% 423009 - Repair Parts 6,442.68 25,331.08 3,535.31 28,866.39 65,179.00 36,312.61 55.71% Total Repair & Maintenance Supplies 15,277.77 77,747.98 6,545.55 84,293.53 366,529.00 282,235.47 77.00% Total Supplies Expenditures 63,027.31 262,608.45 55,816.67 318,425.12 773,819.00 455,393.88 58.85% Services & Charges Expenditures Professional Services 431000 - Other Professional Services - - 921.86 921.86 - (921.86) 0.00% 431009 - Computer & Technology - - - - - - 0.00% 431014 - Collection Costs - - - - 500.00 500.00 100.00% Total Professional Services - - 921.86 921.86 500.00 (421.86) (84.37%) Communication & Transportation 432000 - Other Communication/Transp. - - - - - - 0.00% 432002 - Mailing - 8.40 - 8.40 500.00 491.60 98.32% 432003 - Travel 824.65 17.99 842.64 2,250.00 1,407.36 62.55% 432004 - Telecommunications - 1,383.67 - 1,383.67 9,000.00 7,616.33 84.63% Total Communication & Transportation - 2,216.72 17.99 2,234.71 11,750.00 9,515.29 80.98% Printing & Advertising 433001 - Outside Printing Services - - 42.00 42.00 1,733.00 1,691.00 97.58% 433002 - Publication of Legal Notice - 186.00 1,814.00 2,000.00 2,000.00 - 0.00% Total Printing & Advertising - 186.00 1,856.00 2,042.00 3,733.00 1,691.00 45.30% Utilties 435001 - Electric 7,223.50 165,082.76 - 165,082.76 324,093.00 159,010.24 49.06% 435002 - Natural Gas 2,935.92 50,415.14 - 50,415.14 55,556.00 5,140.86 9.25% 435004 - Water 5,929.93 34,387.64 163,611.84 197,999.48 198,000.00 0.52 0.00% Total Utilities 16,089.35 249,885.54 163,611.84 413,497.38 577,649.00 164,151.62 28.42% Repairs & Maintenance 436000 - Other R&M 2,105.00 46,044.00 14,108.99 60,152.99 67,308.00 7,155.01 10.63% 436001 - Building R&M 10,186.67 20,986.80 5,027.47 26,014.27 97,284.00 71,269.73 73.26% 436002 - Office Equip R&M - - - - 8,500.00 8,500.00 100.00% 436003 - Auto Equip R&M 17,983.87 170,026.68 - 170,026.68 240,000.00 69,973.32 29.16% 436005 - Other Equip R&M - - - - 6,710.00 6,710.00 100.00% 436006 - Radio Equip R&M 741.44 3,743.67 - 3,743.67 16,500.00 12,756.33 77.31% 436011 - Exterminating - - - - 7,500.00 7,500.00 100.00% Total Repairs & Maintenance 31,016.98 240,801.15 19,136.46 259,937.61 443,802.00 183,864.39 41.43% Debt Service 438100 - Principal 969.64 129,817.05 - 129,817.05 297,875.00 168,057.95 56.42% 438200 - Interest 41.53 3,721.58 - 3,721.58 11,978.00 8,256.42 68.93% Total Debt Service 1,011.17 133,538.63 - 133,538.63 309,853.00 176,314.37 56.90% Other Charges & Services 439000 - Misc Charges & Svcs 20,096.10 134,951.09 131,441.70 266,392.79 359,037.00 92,644.21 25.80% 439001 - Other Contractual Services - - - - - - 439003 - Subscriptions - - - - 745.00 745.00 100.00% 439004 - Dues & Memberships 129.00 129.00 - 129.00 2,375.00 2,246.00 94.57% 439006 - Education & Training 2,265.00 3,752.00 175.00 3,927.00 20,075.00 16,148.00 80.44% 439009 - Trash Removal - 11,035.22 - 11,035.22 32,973.00 21,937.78 66.53% Total Other Services & Charges 70,607.60 776,495.35 317,160.85 1,093,656.20 1,762,492.00 668,835.80 37.95% Total Services & Charges Expenditures 70,607.60 776,495.35 317,160.85 1,093,656.20 1,762,492.00 668,835.80 37.95% 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 150,203.00 - 150,203.00 360,490.00 210,287.00 58.33% 452009 - Allocations-Facilities Mgmt 1,195.00 5,977.00 - 5,977.00 14,342.00 8,365.00 58.33% Total Other Uses 31,236.00 156,180.00 - 156,180.00 374,832.00 218,652.00 58.33% Total Expenditures 584,299.01 2,862,201.27 373,405.13 3,235,606.40 6,883,332.00 3,647,725.60 52.99%