Loading...
HomeMy WebLinkAboutJune 22 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 30,000.00 75,000.00 45,000.00 40.00% 347019 - Site Mowing - - 222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 29,647.88 82,133.34 120,000.00 37,866.66 68.44% Total Culture & Recreation 44,647.88 112,133.34 417,839.00 305,705.66 26.84% Total Charges for Services 44,647.88 112,133.34 417,839.00 305,705.66 26.84% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal - 846.32 - (846.32) 0.00% 367000 - Donations from Private Sources - 7,867.50 - (7,867.50) 0.00% Total Miscellaneous Revenue - 8,713.82 2,000.00 (6,713.82) 435.69% Refunds & Reimbursements 380000 - Misc Reimbursements - 123.06 - (123.06) 0.00% 380007 - Energy Rebates - 808.98 809.00 0.02 100.00% 381000 - Misc Reimbursements - 4,916.40 245,441.00 240,524.60 2.00% 396000 - Refunds - 37,603.17 37,603.00 (0.17) 100.00% Total Refunds & Reimbursements - 43,451.61 283,853.00 240,401.39 15.31% Other Sources 393000 - Capital Lease Proceeds 1,290,000.00 1,290,000.00 1,290,000.00 - 100.00% Total Other Sources 1,290,000.00 1,290,000.00 1,290,000.00 - 100.00% Total Revenue 1,334,647.88 1,454,298.77 1,993,692.00 539,393.23 72.95% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent Account String Month Expenditures Encumbrances w/ Encumb. Budget Budget Available Personnel Expenses Salaries & Wages 410001 - Salaried Wages 61,147.56 391,107.12 - 391,107.12 820,100.00 428,992.88 47.69% 410002 - Teamster Wages 84,677.98 591,530.09 - 591,530.09 1,281,200.00 689,669.91 46.17% 410003 - Permanent Part Time 32,110.71 133,075.40 - 133,075.40 255,000.00 121,924.60 52.19% 410004 - Extra & Overtime 20,486.82 48,875.15 - 48,875.15 56,300.00 7,424.85 86.81% 410005 - Seasonal & Interns 50,572.86 128,393.48 - 128,393.48 300,000.00 171,606.52 42.80% 410007 - Longevity Pay 300.00 4,295.83 - 4,295.83 7,450.00 3,154.17 57.66% 410014 - Contract Add Pays - - - - - - 0.00% 410017 - Stand By Pay 336.12 1,289.48 - 1,289.48 3,500.00 2,210.52 36.84% Total Salaries & Wages 249,632.05 1,298,566.55 - 1,298,566.55 2,723,550.00 1,424,983.45 47.68% Employee Benefits 411001 - FICA Regular 18,484.50 104,764.40 - 104,764.40 210,409.00 105,644.60 49.79% 411004 - PERF Regular 17,813.70 120,232.79 - 120,232.79 245,889.00 125,656.21 48.90% 411005 - PERF Union 1,184.80 8,262.35 - 8,262.35 20,541.00 12,278.65 40.22% 411007 - Unemployment Comp 280.96 1,626.50 - 1,626.50 3,472.00 1,845.50 46.85% 411008 - Health Insurance 42,931.70 260,189.66 - 260,189.66 582,882.00 322,692.34 44.64% 411009 - Life Insurance 400.00 2,440.00 - 2,440.00 5,160.00 2,720.00 47.29% 411014 - Parental Leave 571.40 3,613.72 - 3,613.72 7,594.00 3,980.28 47.59% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance - 2,923.62 - 2,923.62 4,000.00 1,076.38 73.09% 411203 - Job Readiness Allow. - 12,325.00 - 12,325.00 15,750.00 3,425.00 78.25% 411206 - Cell Phone Allowance 440.00 2,640.00 - 2,640.00 5,940.00 3,300.00 44.44% Total Employee Benefits 82,107.06 520,218.04 - 520,218.04 1,102,837.00 582,618.96 47.17% June 30, 2022 Total Personnel Expenses 331,739.11 1,818,784.59 - 1,818,784.59 3,826,387.00 2,007,602.41 47.53% Supplies Expenses Office Supplies 421000 - General Office Supplies 395.88 2,147.60 148.50 2,296.10 5,000.00 2,703.90 45.92% Total Office Supplies 395.88 2,147.60 148.50 2,296.10 5,000.00 2,703.90 45.92% Operating Supplies 422000 - Other Operating Supplies 42,845.01 96,467.90 28,500.05 124,967.95 146,081.45 21,113.50 85.55% 422001 - C.S. Gasoline 22,259.04 108,430.51 - 108,430.51 165,000.00 56,569.49 65.72% 422003 - Gasoline - - 50.00 50.00 2,405.00 2,355.00 2.08% 422004 - Oil - 35.30 - 35.30 50.00 14.70 70.60% 422005 - Uniforms - - 1,218.25 1,218.25 3,000.00 1,781.75 40.61% 422006 - Computer Supplies & Equipment - 319.93 - 319.93 500.00 180.07 63.99% 422007 - Cleaning Supplies 1,427.32 1,512.45 - 1,512.45 2,550.00 1,037.55 59.31% 422008 - Medical/Safety Supplies 1,374.99 11,106.97 165.84 11,272.81 12,480.00 1,207.19 90.33% 422010 - Plants Chemicals Seed & Fertilizer 2,968.87 43,629.31 5,408.54 49,037.85 68,975.00 19,937.15 71.10% Total Operating Supplies 70,875.23 261,502.37 35,342.68 296,845.05 401,041.45 104,196.40 74.02% Repair & Maintenance Supplies 423000 - Other R&M Supplies 14,509.79 100,657.15 46,529.00 147,186.15 233,674.41 86,488.26 62.99% 423001 - Building Materials 9,294.11 36,724.51 9,402.35 46,126.86 90,000.00 43,873.14 51.25% 423006 - Small Tools & Equipment 1,240.49 10,816.96 31.53 10,848.49 25,573.00 14,724.51 42.42% 423009 - Repair Parts 5,416.08 33,139.05 2,175.00 35,314.05 79,729.03 44,414.98 44.29% Total Repair & Maintenance Supplies 30,460.47 181,337.67 58,137.88 239,475.55 428,976.44 189,500.89 55.82% Total Supplies Expenses 101,731.58 444,987.64 93,629.06 538,616.70 835,017.89 296,401.19 64.50% Services & Charges Expenses Professional Services 431000 - Other Professional Services 685.00 2,131.00 11,574.00 13,705.00 17,000.00 3,295.00 80.62% 431009 - Computer & Technology - 31.83 - 31.83 500.00 468.17 6.37% 431014 - Collection Costs 11.25 23.75 - 23.75 50.00 26.25 47.50% 431019 - Security Services - 15,557.60 - 15,557.60 16,218.00 660.40 95.93% Total Professional Services 696.25 17,744.18 11,574.00 29,318.18 33,768.00 4,449.82 86.82% Communication & Transportation 432003 - Travel 171.88 2,184.09 3,602.39 5,786.48 6,400.00 613.52 90.41% 432004 - Telecommunications - 844.84 2,867.41 3,712.25 7,997.41 4,285.16 46.42% Total Communication & Transportation 171.88 3,028.93 6,469.80 9,498.73 14,397.41 4,898.68 65.98% Printing & Advertising 433001 - Outside Printing Services - 500.00 - 500.00 2,000.00 1,500.00 25.00% 433002 - Publication of Legal Notice - 495.60 879.40 1,375.00 2,000.00 625.00 68.75% Total Printing & Advertising - 995.60 879.40 1,875.00 4,000.00 2,125.00 46.88% Utilties 435001 - Electric 39,426.16 227,031.77 - 227,031.77 403,180.00 176,148.23 56.31% 435002 - Natural Gas 2,032.99 121,000.99 - 121,000.99 90,938.00 (30,062.99) 133.06% 435004 - Water 39,935.26 84,983.77 - 84,983.77 214,000.00 129,016.23 39.71% Total Utilities 81,394.41 433,016.53 - 433,016.53 708,118.00 275,101.47 61.15% Repairs & Maintenance 436000 - Other R&M 2,240.05 11,890.49 18,037.20 29,927.69 74,528.99 44,601.30 40.16% 436001 - Building R&M 56,028.61 138,405.22 43,236.91 181,642.13 206,994.82 25,352.69 87.75% 436003 - Auto Equip R&M 16,009.20 164,801.70 - 164,801.70 297,000.00 132,198.30 55.49% 436005 - Other Equip R&M - 784.97 - 784.97 5,800.00 5,015.03 13.53% 436006 - Radio Equip R&M 2,845.35 6,267.44 - 6,267.44 3,500.00 (2,767.44) 179.07% 436011 - Exterminating - 3,416.00 746.00 4,162.00 8,334.00 4,172.00 49.94% Total Repairs & Maintenance 77,123.21 325,565.82 62,020.11 387,585.93 596,157.81 208,571.88 65.01% Debt Service 438100 - Principal - - - - 144,454.62 144,454.62 0.00% 438200 - Interest - - - - 3,114.38 3,114.38 0.00% Total Debt Service - - - - 147,569.00 147,569.00 0.00% Other Charges & Services 439000 - Misc Charges & Svcs 50,987.55 170,384.20 295,327.58 465,711.78 581,561.50 115,849.72 80.08% 439001 - Other Contractual Services 240.00 240.00 5,460.00 5,700.00 6,000.00 300.00 95.00% 439002 - Licenses & Permits - 1,150.00 - 1,150.00 1,150.00 - 100.00% 439003 - Subscriptions 316.94 441.94 - 441.94 1,220.00 778.06 36.22% 439004 - Dues & Memberships - 120.00 - 120.00 2,375.00 2,255.00 5.05% 439006 - Education & Training 595.00 6,942.17 2,554.00 9,496.17 11,000.00 1,503.83 86.33% 439009 - Trash Removal 548.60 16,426.49 14,445.16 30,871.65 33,920.75 3,049.10 91.01% 439012 - Uniform Services - 7,220.30 - 7,220.30 8,200.00 979.70 88.05% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 52,688.09 217,925.10 317,786.74 535,711.84 660,427.25 124,715.41 81.12% Total Services & Charges Expenses 212,073.84 998,276.16 398,730.05 1,397,006.21 2,164,437.47 767,431.26 64.54% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment 7,062.50 7,062.50 120,939.84 128,002.34 386,027.50 258,025.16 33.16% 445100 - Lease Purchase/Motor Equip - - 513,394.53 513,394.53 1,290,000.00 776,605.47 39.80% Total Machinery & Equipment 7,062.50 17,929.45 634,334.37 652,263.82 1,686,894.36 1,034,630.54 38.67% Total Capital Expenses 7,062.50 17,929.45 634,334.37 652,263.82 1,686,894.36 1,034,630.54 38.67% Other Uses 452002 - Allocations-Admin Cost 31,642.25 189,853.50 - 189,853.50 379,707.00 189,853.50 50.00% 452003 - Allocations-IT 12,805.67 76,833.98 - 76,833.98 153,668.00 76,834.02 50.00% 452004 - Allocations-Liability Insurance 11,013.08 66,078.52 - 66,078.52 132,157.00 66,078.48 50.00% 452009 - Allocations-Facilities Mgmt 2,001.00 12,006.00 - 12,006.00 24,012.00 12,006.00 50.00% Total Other Uses 57,462.00 344,772.00 - 344,772.00 689,544.00 344,772.00 50.00% Total Expenses 710,069.03 3,624,749.84 1,126,693.48 4,751,443.32 9,202,280.72 4,450,837.40 51.63%