Loading...
HomeMy WebLinkAboutApr 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 10,000.00 25,000.00 75,000.00 50,000.00 66.67% 347019 - Site Mowing - - 95,000.00 95,000.00 100.00% 347021 - Tree Maintenance 30,890.00 34,029.40 120,000.00 85,970.60 71.64% 347023 - Graffiti Removal - - 102,529.00 102,529.00 100.00% Total Culture & Recreation 40,890.00 59,029.40 392,529.00 333,499.60 84.96% Total Charges for Services 40,890.00 59,029.40 392,529.00 333,499.60 84.96% Miscellaneous Revenue 360000 - Miscellaneous - - 10,000.00 10,000.00 100.00% 360001 - Sale of Scrap Metal - 154.24 - (154.24) 0.00% 367000 - Donations from Private Sources - 1,320.00 - (1,320.00) 0.00% Total Miscellaneous Revenue - 1,474.24 10,000.00 8,525.76 85.26% Refunds & Reimbursements 380000 - Misc Reimbursements 32.65 105.75 - (105.75) 0.00% 396000 - Refunds 17,978.00 18,003.47 - (18,003.47) 0.00% Total Refunds & Reimbursements 18,010.65 18,109.22 - (18,109.22) 0.00% Other Sources 391000 - Interfund Transfers In 21,845.00 87,385.00 262,145.00 174,760.00 66.67% Total Other Sources 21,845.00 87,385.00 262,145.00 174,760.00 66.67% Total Revenue 80,745.65 165,997.86 664,674.00 498,676.14 75.03% 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 90,245.76 273,542.91 - 273,542.91 760,502.00 486,959.09 64.03% 410002 - Teamster Wages 159,031.43 473,236.82 - 473,236.82 1,353,543.00 880,306.18 65.04% 410003 - Permanent Part Time 33,290.82 93,850.30 - 93,850.30 132,500.00 38,649.70 29.17% 410004 - Extra & Overtime 4,443.98 28,481.40 - 28,481.40 56,300.00 27,818.60 49.41% 410005 - Seasonal & Interns 9,913.50 21,378.70 - 21,378.70 324,200.00 302,821.30 93.41% 410007 - Longevity Pay 1,350.00 3,700.00 - 3,700.00 7,450.00 3,750.00 50.34% Total Salaries & Wages 298,275.49 894,190.13 - 894,190.13 2,634,495.00 1,740,304.87 66.06% Employee Benefits 411001 - FICA Regular 22,619.92 67,983.63 - 67,983.63 203,405.00 135,421.37 66.58% 411004 - PERF Regular 27,485.51 86,991.75 - 86,991.75 246,645.00 159,653.25 64.73% 411005 - PERF Union 1,894.61 6,063.08 - 6,063.08 21,536.00 15,472.92 71.85% 411007 - Unemployment Comp 26.91 79.70 - 79.70 634.00 554.30 87.43% 411008 - Health Insurance 50,150.82 199,954.68 - 199,954.68 534,078.00 334,123.32 62.56% 411009 - Life Insurance 490.00 1,930.00 - 1,930.00 5,520.00 3,590.00 65.04% 411014 - Parental Leave 892.33 2,733.44 - 2,733.44 7,622.00 4,888.56 64.14% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 0.00% 411201 - Tool Allowance - 774.79 - 774.79 2,800.00 2,025.21 72.33% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 14,450.00 - 0.00% 411206 - Cell Phone Allowance 495.00 1,980.00 - 1,980.00 5,940.00 3,960.00 66.67% Total Employee Benefits 104,055.10 384,141.07 - 384,141.07 1,043,830.00 659,688.93 63.20% Total Personnel Expenditures 402,330.59 1,278,331.20 - 1,278,331.20 3,678,325.00 2,399,993.80 65.25% April 30, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies - 516.75 - 516.75 517.00 0.25 0.05% 421002 - Stationary & Printing - - 2,819.00 2,819.00 7,302.00 4,483.00 61.39% Total Office Supplies - 516.75 2,819.00 3,335.75 7,819.00 4,483.25 57.34% Operating Supplies 422000 - Other Operating Supplies 35,260.79 88,338.92 35,057.50 123,396.42 165,043.20 41,646.78 25.23% 422001 - C.S. Gasoline 10,913.63 42,889.47 - 42,889.47 164,871.00 121,981.53 73.99% 422003 - Gasoline - - - - 2,405.00 2,405.00 100.00% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 320.00 0.07 0.02% 422007 - Cleaning Supplies - 232.06 - 232.06 233.00 0.94 0.40% 422008 - Medical/Safety Supplies 767.99 5,706.16 - 5,706.16 12,547.19 6,841.03 54.52% 422010 - Plants Chemicals Seed & Fertilizer 8,444.20 12,717.47 9,142.10 21,859.57 69,377.00 47,517.43 68.49% Total Operating Supplies 55,386.61 150,204.01 44,199.60 194,403.61 414,796.39 220,392.78 53.13% Repair & Maintenance Supplies 423000 - Other R&M Supplies 18,789.55 26,820.97 19,204.16 46,025.13 228,883.86 182,858.73 79.89% 423001 - Building Materials 1,736.72 6,684.15 3,155.11 9,839.26 92,363.51 82,524.25 89.35% 423006 - Small Tools & Equipment 2,434.74 9,076.30 - 9,076.30 25,573.00 16,496.70 64.51% 423009 - Repair Parts 5,694.58 17,219.57 1,699.55 18,919.12 75,020.30 56,101.18 74.78% Total Repair & Maintenance Supplies 28,655.59 59,800.99 24,058.82 83,859.81 421,840.67 337,980.86 80.12% Total Supplies Expenditures 84,042.20 210,521.75 71,077.42 281,599.17 844,456.06 562,856.89 66.65% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 400.00 1,267.00 11,450.28 12,717.28 - (12,717.28) 0.00% 431001 - Legal Services 195.00 195.00 - 195.00 - (195.00) 0.00% 431019 - Security Services - 14,821.93 - 14,821.93 200,660.00 185,838.07 92.61% Total Professional Services 595.00 16,283.93 11,450.28 27,734.21 200,660.00 172,925.79 86.18% Communication & Transportation 432002 - Mailing - 143.88 - 143.88 144.00 0.12 0.08% 432003 - Travel - - - - 2,106.00 2,106.00 100.00% 432004 - Telecommunications 116.96 1,057.42 2,922.58 3,980.00 9,000.00 5,020.00 55.78% Total Communication & Transportation 116.96 1,201.30 2,922.58 4,123.88 11,250.00 7,126.12 63.34% Printing & Advertising 433001 - Outside Printing Services - 89.00 - 89.00 2,000.00 1,911.00 95.55% 433002 - Publication of Legal Notice - 286.94 58.68 345.62 2,322.74 1,977.12 85.12% Total Printing & Advertising - 375.94 58.68 434.62 4,322.74 3,888.12 89.95% Utilties 435001 - Electric 33,166.64 151,331.43 - 151,331.43 324,259.00 172,927.57 53.33% 435002 - Natural Gas 14,592.67 80,266.87 - 80,266.87 77,778.00 (2,488.87) (3.20%) 435004 - Water 8,529.83 66,738.22 - 66,738.22 198,000.00 131,261.78 66.29% Total Utilities 56,289.14 298,336.52 - 298,336.52 600,037.00 301,700.48 50.28% Repairs & Maintenance 436000 - Other R&M 3,579.50 13,240.50 22,618.12 35,858.62 35,981.12 122.50 0.34% 436001 - Building R&M 4,683.45 11,218.35 88,368.44 99,586.79 195,010.44 95,423.65 48.93% 436003 - Auto Equip R&M 20,522.93 101,034.30 11,463.26 112,497.56 332,991.00 220,493.44 66.22% 436005 - Other Equip R&M - - 159.00 159.00 159.00 - 0.00% 436006 - Radio Equip R&M 350.00 3,104.12 - 3,104.12 5,155.00 2,050.88 39.78% 436011 - Exterminating 788.50 2,615.64 10,482.00 13,097.64 9,481.00 (3,616.64) (38.15%) Total Repairs & Maintenance 29,924.38 131,212.91 133,090.82 264,303.73 578,777.56 314,473.83 54.33% Debt Service 438100 - Principal 103,845.32 112,492.49 - 112,492.49 225,467.00 112,974.51 50.11% 438200 - Interest 1,560.87 1,693.99 - 1,693.99 2,543.00 849.01 33.39% Total Debt Service 105,406.19 114,186.48 - 114,186.48 228,010.00 113,823.52 49.92% Other Charges & Services 439000 - Misc Charges & Svcs 7,426.07 50,534.10 84,031.29 134,565.39 256,111.54 121,546.15 47.46% 439001 - Other Contractual Services - - 3,122.86 3,122.86 3,122.86 - 0.00% 439002 - Licenses & Permits - 2,292.24 - 2,292.24 2,293.00 0.76 0.03% 439003 - Subscriptions - - - - 666.00 666.00 100.00% 439004 - Dues & Memberships - 125.00 - 125.00 2,375.00 2,250.00 94.74% 439006 - Education & Training 743.50 1,159.50 1,100.00 2,259.50 12,100.00 9,840.50 81.33% 439009 - Trash Removal 3,866.94 7,376.90 17,371.88 24,748.78 25,743.18 994.40 3.86% 439012 - Uniform Services - 3,851.13 - 3,851.13 3,852.00 0.87 0.02% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 0.00% Total Other Services & Charges 4,610.44 29,804.77 18,471.88 48,276.65 62,029.18 13,752.53 22.17% Total Services & Charges Expenditures 204,368.18 641,935.95 253,148.39 895,084.34 1,944,320.88 1,049,236.54 53.96% Capital Outlay Machinery & Equipment 445003 - Park Equipment - - 24,500.00 24,500.00 400,000.00 375,500.00 93.88% Total Machinery & Equipment - - 24,500.00 24,500.00 400,000.00 375,500.00 93.88% Total Capital Expenditures - - 24,500.00 24,500.00 400,000.00 375,500.00 93.88% Other Uses 452002 - Allocations-Admin Cost 27,272.00 109,088.00 - 109,088.00 327,264.00 218,176.00 66.67% 452004 - Allocations-Liability Insurance 5,441.00 21,761.00 - 21,761.00 65,289.00 43,528.00 66.67% 452009 - Allocations-Facilities Mgmt 1,436.00 5,742.00 - 5,742.00 18,789.00 13,047.00 69.44% Total Other Uses 34,149.00 136,591.00 - 136,591.00 411,342.00 274,751.00 66.79% Total Expenditures 724,889.97 2,267,379.90 348,725.81 2,616,105.71 7,278,443.94 4,662,338.23 64.06%