Loading...
HomeMy WebLinkAboutMar 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 - - 75,000.00 75,000.00 0.00% 347019 - Site Mowing - - 222,839.00 222,839.00 0.00% 347021 - Tree Maintenance 46,427.94 49,514.78 120,000.00 70,485.22 41.26% Total Culture & Recreation 46,427.94 49,514.78 417,839.00 368,324.22 11.85% Total Charges for Services 46,427.94 49,514.78 417,839.00 368,324.22 11.85% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal - 211.75 - (211.75) 0.00% 367000 - Donations from Private Sources - 7,867.50 - (7,867.50) 0.00% Total Miscellaneous Revenue - 8,079.25 2,000.00 (6,079.25) 403.96% Refunds & Reimbursements 380000 - Misc Reimbursements - 74.77 - (74.77) 0.00% 381000 - Misc Reimbursements 4,916.40 4,916.40 245,441.00 240,524.60 2.00% 396000 - Refunds 122.76 37,437.85 - (37,437.85) 0.00% Total Refunds & Reimbursements 5,039.16 42,429.02 245,441.00 203,011.98 17.29% Other Sources 393000 - Capital Lease Proceeds - - 269,000.00 269,000.00 0.00% Total Other Sources - - 269,000.00 269,000.00 0.00% Total Revenue 51,467.10 100,023.05 934,280.00 834,256.95 10.71% 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 59,865.60 177,733.51 - 177,733.51 820,100.00 642,366.49 21.67% 410002 - Teamster Wages 108,355.09 330,203.56 - 330,203.56 1,284,700.00 954,496.44 25.70% 410003 - Permanent Part Time 12,753.34 47,852.46 - 47,852.46 205,000.00 157,147.54 23.34% 410004 - Extra & Overtime 7,560.11 23,825.37 - 23,825.37 56,300.00 32,474.63 42.32% 410005 - Seasonal & Interns 5,870.14 20,227.53 - 20,227.53 300,000.00 279,772.47 6.74% 410007 - Longevity Pay 937.50 2,495.83 - 2,495.83 7,450.00 4,954.17 33.50% Total Salaries & Wages 195,341.78 602,338.26 - 602,338.26 2,673,550.00 2,071,211.74 22.53% Employee Benefits 411001 - FICA Regular 14,452.56 54,135.92 - 54,135.92 206,584.00 152,448.08 26.21% 411004 - PERF Regular 18,184.21 68,405.07 - 68,405.07 245,889.00 177,483.93 27.82% 411005 - PERF Union 1,285.84 4,925.55 - 4,925.55 20,541.00 15,615.45 23.98% 411007 - Unemployment Comp 302.56 733.40 - 733.40 3,472.00 2,738.60 21.12% 411008 - Health Insurance 49,096.56 146,958.14 - 146,958.14 582,882.00 435,923.86 25.21% 411009 - Life Insurance 460.00 1,370.00 - 1,370.00 5,160.00 3,790.00 26.55% 411014 - Parental Leave 618.05 1,868.53 - 1,868.53 7,594.00 5,725.47 24.61% 411015 - Other Fringe Benefits 1,200.00 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance 1,000.00 2,423.62 500.00 2,923.62 4,000.00 1,076.38 73.09% 411203 - Job Readiness Allow. - 14,450.00 - 14,450.00 15,750.00 1,300.00 91.75% 411206 - Cell Phone Allowance 440.00 1,320.00 - 1,320.00 5,940.00 4,620.00 22.22% Total Employee Benefits 87,039.78 297,790.23 500.00 298,290.23 1,099,012.00 800,721.77 27.14% Total Personnel Expenditures 282,381.56 900,128.49 500.00 900,628.49 3,772,562.00 2,871,933.51 23.87% Supplies Expenditures March 31, 2022 Office Supplies 421000 - General Office Supplies - 1,158.62 - 1,158.62 5,000.00 3,841.38 23.17% Total Office Supplies - 1,158.62 - 1,158.62 5,000.00 3,841.38 23.17% Operating Supplies 422000 - Other Operating Supplies 13,893.92 33,268.92 50,980.19 84,249.11 151,581.45 67,332.34 55.58% 422001 - C.S. Gasoline 16,066.17 45,339.66 - 45,339.66 165,000.00 119,660.34 27.48% 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% 422006 - Computer Supplies & Equipment 319.93 319.93 - 319.93 500.00 180.07 63.99% 422007 - Cleaning Supplies - 2.68 - 2.68 50.00 47.32 5.36% 422008 - Medical/Safety Supplies 307.05 4,747.27 - 4,747.27 12,480.00 7,732.73 38.04% 422010 - Plants Chemicals Seed & Fertilizer 1,554.97 1,554.97 40,664.13 42,219.10 68,975.00 26,755.90 61.21% Total Operating Supplies 32,142.04 85,268.73 91,694.32 176,963.05 401,041.45 224,078.40 44.13% Repair & Maintenance Supplies 423000 - Other R&M Supplies 29,887.62 52,078.73 31,020.03 83,098.76 233,674.41 150,575.65 35.56% 423001 - Building Materials 8,185.40 24,186.98 - 24,186.98 90,000.00 65,813.02 26.87% 423006 - Small Tools & Equipment 3,241.15 5,998.72 31.53 6,030.25 25,573.00 19,542.75 23.58% 423009 - Repair Parts 2,895.59 13,154.47 9,700.98 22,855.45 79,729.03 56,873.58 28.67% Total Repair & Maintenance Supplies 44,209.76 95,418.90 40,752.54 136,171.44 428,976.44 292,805.00 31.74% Total Supplies Expenditures 76,351.80 181,846.25 132,446.86 314,293.11 835,017.89 520,724.78 37.64% Services & Charges Expenditures Professional Services 431000 - Other Professional Services 242.00 242.00 - 242.00 500.00 258.00 48.40% 431009 - Computer & Technology 31.83 31.83 - 31.83 500.00 468.17 6.37% 431014 - Collection Costs - 6.25 6.25 12.50 50.00 37.50 25.00% 431019 - Security Services - 15,557.60 - 15,557.60 214,652.00 199,094.40 7.25% Total Professional Services 273.83 15,837.68 6.25 15,843.93 215,702.00 199,858.07 7.35% Communication & Transportation 432003 - Travel 1,394.52 1,800.13 3,510.96 5,311.09 6,400.00 1,088.91 82.99% 432004 - Telecommunications 669.40 844.84 2,867.41 3,712.25 8,997.41 5,285.16 41.26% Total Communication & Transportation 2,063.92 2,644.97 6,378.37 9,023.34 15,397.41 6,374.07 58.60% Printing & Advertising 433001 - Outside Printing Services - - - - 2,000.00 2,000.00 0.00% 433002 - Publication of Legal Notice - 495.60 529.40 1,025.00 2,000.00 975.00 51.25% Total Printing & Advertising - 495.60 529.40 1,025.00 4,000.00 2,975.00 25.63% Utilties 435001 - Electric 37,400.60 119,085.53 - 119,085.53 403,180.00 284,094.47 29.54% 435002 - Natural Gas 26,205.02 88,285.94 - 88,285.94 90,938.00 2,652.06 97.08% 435004 - Water 6,454.13 15,845.41 - 15,845.41 214,000.00 198,154.59 7.40% Total Utilities 70,059.75 223,216.88 - 223,216.88 708,118.00 484,901.12 31.52% Repairs & Maintenance 436000 - Other R&M 2,228.00 7,332.46 4,110.99 11,443.45 95,328.99 83,885.54 12.00% 436001 - Building R&M 17,644.80 40,361.82 87,486.37 127,848.19 176,994.82 49,146.63 72.23% 436003 - Auto Equip R&M 26,228.50 90,406.29 - 90,406.29 335,000.00 244,593.71 26.99% 436006 - Radio Equip R&M 582.25 2,411.59 - 2,411.59 2,500.00 88.41 96.46% 436011 - Exterminating 555.00 2,489.00 345.00 2,834.00 13,334.00 10,500.00 21.25% Total Repairs & Maintenance 47,238.55 143,001.16 91,942.36 234,943.52 623,157.81 388,214.29 37.70% Debt Service 438100 - Principal - - - - 51,161.00 51,161.00 0.00% 438200 - Interest - - - - 6,408.00 6,408.00 0.00% Total Debt Service - - - - 57,569.00 57,569.00 0.00% Other Charges & Services 439000 - Misc Charges & Svcs 10,794.09 43,652.58 40,070.11 83,722.69 383,127.50 299,404.81 21.85% 439002 - Licenses & Permits - 1,150.00 - 1,150.00 1,150.00 - 100.00% 439003 - Subscriptions - 125.00 - 125.00 1,220.00 1,095.00 10.25% 439004 - Dues & Memberships - - - - 2,375.00 2,375.00 0.00% 439006 - Education & Training 2,727.00 6,143.00 2,075.00 8,218.00 11,000.00 2,782.00 74.71% 439009 - Trash Removal 3,546.58 10,195.73 17,318.68 27,514.41 32,420.75 4,906.34 84.87% 439012 - Uniform Services 1,551.52 3,551.08 8.00 3,559.08 4,200.00 640.92 84.74% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 18,619.19 79,817.39 59,471.79 139,289.18 450,493.25 311,204.07 30.92% Total Services & Charges Expenditures 138,255.24 465,013.68 158,328.17 623,341.85 2,074,437.47 1,451,095.62 30.05% Capital Outlay Machinery & Equipment 445000 - Motor Equipment 10,866.95 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment - - 108,002.34 108,002.34 386,027.50 278,025.16 27.98% 445100 - Lease Purchase/Motor Equip - - 191,646.00 191,646.00 269,000.00 77,354.00 71.24% Total Machinery & Equipment 10,866.95 10,866.95 299,648.34 310,515.29 665,894.36 355,379.07 46.63% Total Capital Expenditures 10,866.95 10,866.95 299,648.34 310,515.29 665,894.36 355,379.07 46.63% Other Uses 452002 - Allocations-Admin Cost 31,642.25 94,926.75 - 94,926.75 379,707.00 284,780.25 25.00% 452003 - Allocations-IT 12,805.67 38,416.97 - 38,416.97 153,668.00 115,251.03 25.00% 452004 - Allocations-Liability Insurance 11,013.08 33,039.28 - 33,039.28 132,157.00 99,117.72 25.00% 452009 - Allocations-Facilities Mgmt 2,001.00 6,003.00 - 6,003.00 24,012.00 18,009.00 25.00% Total Other Uses 57,462.00 172,386.00 - 172,386.00 689,544.00 517,158.00 25.00% Total Expenditures 565,317.55 1,730,241.37 590,923.37 2,321,164.74 8,037,455.72 5,716,290.98 28.88%