Loading...
HomeMy WebLinkAboutJune 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 55,000.00 75,000.00 20,000.00 73.33% 347019 - Site Mowing 1,227.59 1,227.59 95,000.00 93,772.41 1.29% 347021 - Tree Maintenance 886.00 35,368.40 120,000.00 84,631.60 29.47% 347023 - Graffiti Removal 1,482.15 1,482.15 102,529.00 101,046.85 1.45% Total Culture & Recreation 18,595.74 93,078.14 392,529.00 299,450.86 23.71% Total Charges for Services 18,595.74 93,078.14 392,529.00 299,450.86 23.71% Miscellaneous Revenue 360000 - Miscellaneous - - 10,000.00 10,000.00 0.00% 360001 - Sale of Scrap Metal 245.35 399.59 - (399.59) 0.00% 367000 - Donations from Private Sources 16,000.00 17,320.00 - (17,320.00) 0.00% Total Miscellaneous Revenue 16,245.35 17,719.59 10,000.00 (7,719.59) 177.20% Refunds & Reimbursements 380000 - Misc Reimbursements - 105.75 - (105.75) 0.00% 380007 - Energy Rebates - 962.27 - (962.27) 0.00% 396000 - Refunds (16,000.00) 2,003.47 2,003.00 (0.47) 100.02% Total Refunds & Reimbursements (16,000.00) 3,071.49 2,003.00 (1,068.49) 153.34% Other Sources 391000 - Interfund Transfers In 21,845.00 131,075.00 262,145.00 131,070.00 50.00% Total Other Sources 21,845.00 131,075.00 262,145.00 131,070.00 50.00% Total Revenue 40,686.09 244,944.22 666,677.00 421,732.78 36.74% 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 56,153.36 388,068.42 - 388,068.42 750,502.00 362,433.58 51.71% 410002 - Teamster Wages 109,865.29 688,870.27 - 688,870.27 1,353,543.00 664,672.73 50.89% 410003 - Permanent Part Time 24,155.84 141,813.29 - 141,813.29 142,500.00 686.71 99.52% 410004 - Extra & Overtime 8,372.76 41,065.77 - 41,065.77 56,300.00 15,234.23 72.94% 410005 - Seasonal & Interns 33,727.54 74,262.74 - 74,262.74 324,200.00 249,937.26 22.91% 410007 - Longevity Pay 650.00 4,700.00 - 4,700.00 7,450.00 2,750.00 63.09% Total Salaries & Wages 232,924.79 1,338,780.49 - 1,338,780.49 2,634,495.00 1,295,714.51 50.82% Employee Benefits 411001 - FICA Regular 17,271.37 101,022.62 - 101,022.62 203,405.00 102,382.38 49.67% 411004 - PERF Regular 19,017.50 124,962.62 - 124,962.62 246,645.00 121,682.38 50.66% 411005 - PERF Union 1,370.55 8,715.72 - 8,715.72 21,536.00 12,820.28 40.47% 411007 - Unemployment Comp 251.51 349.26 - 349.26 634.00 284.74 55.09% 411008 - Health Insurance 48,581.02 297,109.72 - 297,109.72 534,078.00 236,968.28 55.63% 411009 - Life Insurance 470.00 2,875.00 - 2,875.00 5,520.00 2,645.00 52.08% 411014 - Parental Leave 606.05 3,927.28 - 3,927.28 7,622.00 3,694.72 51.53% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance - 774.79 - 774.79 2,800.00 2,025.21 27.67% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 14,450.00 - 100.00% 411206 - Cell Phone Allowance 440.00 2,915.00 - 2,915.00 5,940.00 3,025.00 49.07% Total Employee Benefits 88,008.00 558,302.01 - 558,302.01 1,043,830.00 485,527.99 53.49% Total Personnel Expenditures 320,932.79 1,897,082.50 - 1,897,082.50 3,678,325.00 1,781,242.50 51.57% June 30, 2021 Supplies Expenditures Office Supplies 421000 - Other Office Supplies 73.66 590.41 - 590.41 517.00 (73.41) 114.20% 421002 - Stationary & Printing 2,861.00 2,861.00 174.00 3,035.00 7,302.00 4,267.00 41.56% Total Office Supplies 2,934.66 3,451.41 174.00 3,625.41 7,819.00 4,193.59 46.37% Operating Supplies 422000 - Other Operating Supplies 13,682.81 123,486.44 32,979.25 156,465.69 167,963.20 11,497.51 93.15% 422001 - C.S. Gasoline 17,512.51 72,985.26 - 72,985.26 164,871.00 91,885.74 44.27% 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 193.96 426.02 - 426.02 233.00 (193.02) 182.84% 422008 - Medical/Safety Supplies 915.62 8,730.62 - 8,730.62 12,547.19 3,816.57 69.58% 422010 - Plants Chemicals Seed & Fertilizer 1,752.65 18,457.55 7,781.65 26,239.20 69,377.00 43,137.80 37.82% Total Operating Supplies 34,057.55 224,405.82 40,760.90 265,166.72 417,716.39 152,549.67 63.48% Repair & Maintenance Supplies 423000 - Other R&M Supplies 7,726.51 54,565.70 2,057.34 56,623.04 225,963.86 169,340.82 25.06% 423001 - Building Materials 3,735.56 12,195.09 13,430.98 25,626.07 67,363.51 41,737.44 38.04% 423006 - Small Tools & Equipment 5,369.09 15,275.03 3,269.33 18,544.36 25,573.00 7,028.64 72.52% 423009 - Repair Parts 3,657.23 31,233.36 17,753.26 48,986.62 75,020.30 26,033.68 65.30% Total Repair & Maintenance Supplies 20,488.39 113,269.18 36,510.91 149,780.09 393,920.67 244,140.58 38.02% Total Supplies Expenditures 57,480.60 341,126.41 77,445.81 418,572.22 819,456.06 400,883.84 51.08% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 1,547.82 2,814.82 11,450.28 14,265.10 16,317.00 2,051.90 87.42% 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 - 14,821.93 179,148.00 164,326.07 8.27% Total Professional Services 1,547.82 17,991.75 11,450.28 29,442.03 195,820.00 166,377.97 15.04% 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 116.96 1,174.38 2,805.62 3,980.00 9,000.00 5,020.00 44.22% Total Communication & Transportation 116.96 1,318.26 2,805.62 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 121.70 408.64 89.88 498.52 2,322.74 1,824.22 21.46% Total Printing & Advertising 121.70 497.64 89.88 587.52 4,322.74 3,735.22 13.59% Utilties 435001 - Electric 38,185.14 218,099.78 - 218,099.78 324,259.00 106,159.22 67.26% 435002 - Natural Gas 6,183.56 96,552.99 - 96,552.99 105,563.00 9,010.01 91.46% 435004 - Water 37,734.56 111,853.37 - 111,853.37 198,000.00 86,146.63 56.49% Total Utilities 82,103.26 426,506.14 - 426,506.14 627,822.00 201,315.86 67.93% Repairs & Maintenance 436000 - Other R&M 1,470.00 17,064.50 25,478.12 42,542.62 45,981.12 3,438.50 92.52% 436001 - Building R&M 3,854.94 69,173.05 38,427.17 107,600.22 122,228.44 14,628.22 88.03% 436003 - Auto Equip R&M 59,754.41 215,090.33 5,778.05 220,868.38 327,991.00 107,122.62 67.34% 436005 - Other Equip R&M - - 159.00 159.00 159.00 - 100.00% 436006 - Radio Equip R&M 3,365.00 6,771.12 - 6,771.12 5,155.00 (1,616.12) 131.35% 436011 - Exterminating 1,472.00 4,762.64 8,335.00 13,097.64 18,739.00 5,641.36 69.90% Total Repairs & Maintenance 69,916.35 312,861.64 78,177.34 391,038.98 520,253.56 129,214.58 75.16% Debt Service 438100 - Principal 34.29 112,560.93 - 112,560.93 225,467.00 112,906.07 49.92% 438200 - Interest 0.79 1,695.71 - 1,695.71 2,543.00 847.29 66.68% Total Debt Service 35.08 114,256.64 - 114,256.64 228,010.00 113,753.36 50.11% Other Charges & Services 439000 - Misc Charges & Svcs 12,335.20 69,827.41 108,137.67 177,965.08 134,624.54 (43,340.54) 132.19% 439001 - Other Contractual Services 430.00 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 - 1,339.50 1,269.00 2,608.50 12,100.00 9,491.50 21.56% 439009 - Trash Removal 1,901.16 10,972.62 14,938.47 25,911.09 28,743.18 2,832.09 90.15% 439012 - Uniform Services - 3,851.13 - 3,851.13 3,852.00 0.87 99.98% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 14,666.36 103,837.90 127,468.00 231,305.90 202,776.58 (28,529.32) 114.07% Total Services & Charges Expenditures 168,507.53 977,269.97 219,991.12 1,197,261.09 1,790,254.88 592,993.79 66.88% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - 10,866.86 10,866.86 - (10,866.86) 0.00% 445003 - Park Equipment 13,972.50 13,972.50 10,527.50 24,500.00 400,000.00 375,500.00 6.13% Total Machinery & Equipment 13,972.50 13,972.50 21,394.36 35,366.86 400,000.00 364,633.14 8.84% Total Capital Expenditures 13,972.50 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 163,632.00 - 163,632.00 327,264.00 163,632.00 50.00% 452004 - Allocations-Liability Insurance 5,441.00 32,643.00 - 32,643.00 65,289.00 32,646.00 50.00% 452009 - Allocations-Facilities Mgmt 1,436.00 8,614.00 - 8,614.00 17,230.00 8,616.00 49.99% Total Other Uses 34,149.00 204,889.00 - 204,889.00 409,783.00 204,894.00 50.00% Total Expenditures 595,042.42 3,434,340.38 318,831.29 3,753,171.67 7,097,818.94 3,344,647.27 52.88%