Loading...
HomeMy WebLinkAboutAug 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 60,000.00 75,000.00 15,000.00 80.00% 347019 - Site Mowing 117,974.10 117,974.10 222,839.00 104,864.90 52.94% 347021 - Tree Maintenance 1,136.19 115,402.57 120,000.00 4,597.43 96.17% 347023 - Graffiti Removal 4,930.26 4,930.26 - (4,930.26) 0.00% Total Culture & Recreation 139,040.55 298,306.93 417,839.00 119,532.07 71.39% Total Charges for Services 139,040.55 298,306.93 417,839.00 119,532.07 71.39% 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 - 157.49 - (157.49) 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,486.04 283,853.00 240,366.96 15.32% Other Sources 393000 - Capital Lease Proceeds - 1,290,000.00 1,290,000.00 - 100.00% Total Other Sources - 1,290,000.00 1,290,000.00 - 100.00% Total Revenue 139,040.55 1,640,506.79 1,993,692.00 353,185.21 82.28% 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 60,590.43 512,287.99 - 512,287.99 820,100.00 307,812.01 62.47% 410002 - Teamster Wages 101,202.19 788,923.09 - 788,923.09 1,271,200.00 482,276.91 62.06% 410003 - Permanent Part Time 36,204.64 202,627.05 - 202,627.05 255,000.00 52,372.95 79.46% 410004 - Extra & Overtime 11,759.92 71,905.36 - 71,905.36 66,300.00 (5,605.36) 108.45% 410005 - Seasonal & Interns 44,345.98 218,241.46 - 218,241.46 300,000.00 81,758.54 72.75% 410007 - Longevity Pay 87.49 4,583.32 - 4,583.32 7,450.00 2,866.68 61.52% 410014 - Contract Add Pays - - - - - - 0.00% 410017 - Stand By Pay 340.24 2,015.36 - 2,015.36 3,500.00 1,484.64 57.58% Total Salaries & Wages 254,530.89 1,800,583.63 - 1,800,583.63 2,723,550.00 922,966.37 66.11% Employee Benefits 411001 - FICA Regular 18,848.55 141,895.12 - 141,895.12 210,409.00 68,513.88 67.44% 411004 - PERF Regular 18,424.39 156,733.58 - 156,733.58 245,889.00 89,155.42 63.74% 411005 - PERF Union 1,159.54 10,534.17 - 10,534.17 20,541.00 10,006.83 51.28% 411007 - Unemployment Comp 295.20 2,213.06 - 2,213.06 3,472.00 1,258.94 63.74% 411008 - Health Insurance 46,229.46 350,465.68 - 350,465.68 582,882.00 232,416.32 60.13% 411009 - Life Insurance 420.00 3,270.00 - 3,270.00 5,160.00 1,890.00 63.37% 411014 - Parental Leave 597.60 4,794.66 - 4,794.66 7,594.00 2,799.34 63.14% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411201 - Tool Allowance 105.93 3,029.55 319.93 3,349.48 4,000.00 650.52 83.74% 411203 - Job Readiness Allow. - 12,325.00 - 12,325.00 15,750.00 3,425.00 78.25% 411206 - Cell Phone Allowance 440.00 3,520.00 - 3,520.00 5,940.00 2,420.00 59.26% Total Employee Benefits 86,520.67 689,980.82 319.93 690,300.75 1,102,837.00 412,536.25 62.59% August 31, 2022 Total Personnel Expenses 341,051.56 2,490,564.45 319.93 2,490,884.38 3,826,387.00 1,335,502.62 65.10% Supplies Expenses Office Supplies 421000 - General Office Supplies 539.87 3,325.97 157.50 3,483.47 5,000.00 1,516.53 69.67% Total Office Supplies 539.87 3,325.97 157.50 3,483.47 5,000.00 1,516.53 69.67% Operating Supplies 422000 - Other Operating Supplies 19,789.64 141,169.87 25,976.49 167,146.36 167,081.45 (64.91) 100.04% 422001 - C.S. Gasoline 20,791.95 161,307.40 - 161,307.40 165,000.00 3,692.60 97.76% 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 64.89 384.82 500.00 115.18 76.96% 422007 - Cleaning Supplies 2,378.77 4,024.06 - 4,024.06 2,550.00 (1,474.06) 157.81% 422008 - Medical/Safety Supplies - 11,709.45 - 11,709.45 12,480.00 770.55 93.83% 422010 - Plants Chemicals Seed & Fertilizer 2,554.60 46,728.66 2,846.96 49,575.62 68,975.00 19,399.38 71.87% Total Operating Supplies 45,514.96 365,294.67 30,156.59 395,451.26 422,041.45 26,590.19 93.70% Repair & Maintenance Supplies 423000 - Other R&M Supplies 3,831.99 134,034.41 24,517.26 158,551.67 212,674.41 54,122.74 74.55% 423001 - Building Materials 10,942.61 56,243.34 3,267.00 59,510.34 90,000.00 30,489.66 66.12% 423006 - Small Tools & Equipment 4,833.62 19,336.97 244.11 19,581.08 25,573.00 5,991.92 76.57% 423009 - Repair Parts 8,162.54 44,276.24 3,218.46 47,494.70 79,729.03 32,234.33 59.57% Total Repair & Maintenance Supplies 27,770.76 253,890.96 31,246.83 285,137.79 407,976.44 122,838.65 69.89% Total Supplies Expenses 73,825.59 622,511.60 61,560.92 684,072.52 835,017.89 150,945.37 81.92% Services & Charges Expenses Professional Services 431000 - Other Professional Services 703.00 5,991.00 43,107.50 49,098.50 50,000.00 901.50 98.20% 431009 - Computer & Technology - 31.83 - 31.83 500.00 468.17 6.37% 431014 - Collection Costs 17.50 41.25 - 41.25 50.00 8.75 82.50% 431015 - Laboratory Water Testing - - 250.00 250.00 300.00 50.00 83.33% 431019 - Security Services 6,955.75 28,033.35 4,653.00 32,686.35 31,640.00 (1,046.35) 103.31% Total Professional Services 7,676.25 34,097.43 48,010.50 82,107.93 82,490.00 382.07 99.54% Communication & Transportation 432003 - Travel - 2,184.09 3,977.36 6,161.45 6,400.00 238.55 96.27% 432004 - Telecommunications - 1,108.00 2,597.41 3,705.41 7,697.41 3,992.00 48.14% Total Communication & Transportation - 3,292.09 6,574.77 9,866.86 14,097.41 4,230.55 69.99% Printing & Advertising 433001 - Outside Printing Services - 500.00 - 500.00 2,000.00 1,500.00 25.00% 433002 - Publication of Legal Notice 500.50 996.10 1,111.30 2,107.40 2,000.00 (107.40) 105.37% Total Printing & Advertising 500.50 1,496.10 1,111.30 2,607.40 4,000.00 1,392.60 65.19% Utilties 435001 - Electric 31,321.64 298,170.27 - 298,170.27 403,180.00 105,009.73 73.95% 435002 - Natural Gas 2,059.86 128,967.43 - 128,967.43 90,938.00 (38,029.43) 141.82% 435004 - Water 37,508.27 170,863.23 - 170,863.23 214,000.00 43,136.77 79.84% Total Utilities 70,889.77 598,000.93 - 598,000.93 708,118.00 110,117.07 84.45% Repairs & Maintenance 436000 - Other R&M 12,310.80 28,023.62 9,237.70 37,261.32 69,528.99 32,267.67 53.59% 436001 - Building R&M 18,920.22 165,180.22 23,669.46 188,849.68 206,994.82 18,145.14 91.23% 436003 - Auto Equip R&M 45,169.04 233,455.07 - 233,455.07 297,000.00 63,544.93 78.60% 436005 - Other Equip R&M - 784.97 108.00 892.97 5,800.00 4,907.03 15.40% 436006 - Radio Equip R&M 1,584.64 10,168.23 - 10,168.23 3,500.00 (6,668.23) 290.52% 436011 - Exterminating - 3,416.00 746.00 4,162.00 8,334.00 4,172.00 49.94% Total Repairs & Maintenance 77,984.70 441,028.11 33,761.16 474,789.27 591,157.81 116,368.54 80.32% Rentals 437002 - Equipment Rental - 560.00 - 560.00 - (560.00) 0.00% Total Rentals - 560.00 - 560.00 - (560.00) 0.00% Debt Service 438100 - Principal - 133,096.72 - 133,096.72 144,454.62 11,357.90 92.14% 438200 - Interest - 3,114.38 - 3,114.38 3,114.38 - 100.00% Total Debt Service - 136,211.10 - 136,211.10 147,569.00 11,357.90 92.30% Other Charges & Services 439000 - Misc Charges & Svcs 64,893.41 358,936.26 118,095.16 477,031.42 528,139.50 51,108.08 90.32% 439001 - Other Contractual Services 243.96 2,443.96 11,000.00 13,443.96 14,000.00 556.04 96.03% 439002 - Licenses & Permits - 1,334.36 - 1,334.36 1,150.00 (184.36) 116.03% 439003 - Subscriptions 494.85 1,563.79 - 1,563.79 1,220.00 (343.79) 128.18% 439004 - Dues & Memberships - 390.00 - 390.00 2,375.00 1,985.00 16.42% 439006 - Education & Training 775.00 8,277.17 2,836.50 11,113.67 11,000.00 (113.67) 101.03% 439009 - Trash Removal 4,528.61 26,564.01 5,639.75 32,203.76 35,920.75 3,716.99 89.65% 439012 - Uniform Services 1,532.39 10,722.96 - 10,722.96 8,200.00 (2,522.96) 130.77% 439100 - Refunds/Awards/Indemnities 120.13 120.13 - 120.13 - (120.13) 0.00% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 72,588.35 425,352.64 137,571.41 562,924.05 617,005.25 54,081.20 91.23% Total Services & Charges Expenses 229,639.57 1,640,038.40 227,029.14 1,867,067.54 2,164,437.47 297,369.93 86.26% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment 70,883.76 77,946.26 52,581.24 130,527.50 386,027.50 255,500.00 33.81% 445100 - Lease Purchase/Motor Equip - - 513,394.53 513,394.53 1,290,000.00 776,605.47 39.80% Total Machinery & Equipment 70,883.76 88,813.21 565,975.77 654,788.98 1,686,894.36 1,032,105.38 38.82% Total Capital Expenses 70,883.76 88,813.21 565,975.77 654,788.98 1,686,894.36 1,032,105.38 38.82% Other Uses 452002 - Allocations-Admin Cost 31,642.25 253,138.00 - 253,138.00 379,707.00 126,569.00 66.67% 452003 - Allocations-IT 12,805.67 102,445.32 - 102,445.32 153,668.00 51,222.68 66.67% 452004 - Allocations-Liability Insurance 11,013.08 88,104.68 - 88,104.68 132,157.00 44,052.32 66.67% 452009 - Allocations-Facilities Mgmt 2,001.00 16,008.00 - 16,008.00 24,012.00 8,004.00 66.67% Total Other Uses 57,462.00 459,696.00 - 459,696.00 689,544.00 229,848.00 66.67% Total Expenses 772,862.48 5,301,623.66 854,885.76 6,156,509.42 9,202,280.72 3,045,771.30 66.90%