Loading...
HomeMy WebLinkAboutDec 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 - 100.00% 347019 - Site Mowing 143,577.84 261,551.94 222,839.00 (38,712.94) 117.37% 347021 - Tree Maintenance 32,524.50 180,733.27 120,000.00 (60,733.27) 150.61% 347023 - Graffiti Removal - 4,930.26 - (4,930.26) 0.00% Total Culture & Recreation 176,102.34 522,215.47 417,839.00 (104,376.47) 124.98% Total Charges for Services 176,102.34 522,215.47 417,839.00 (104,376.47) 124.98% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal - 1,110.07 - (1,110.07) 0.00% 360011 - Settlement Fees - 80,000.00 - (80,000.00) 0.00% 367000 - Donations from Private Sources - 7,867.50 - (7,867.50) 0.00% Total Miscellaneous Revenue - 88,977.57 2,000.00 (86,977.57) 4448.88% Refunds & Reimbursements 380000 - Misc Reimbursements - 246.59 - (246.59) 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 - 38,342.92 37,603.00 (739.92) 101.97% Total Refunds & Reimbursements - 44,314.89 283,853.00 239,538.11 15.61% Other Sources 392000 - Gain/Loss on Sale of Asset - 53,682.00 - (53,682.00) 0.00% 392005 - Sale of Non-Capital Assets - 11,776.00 - (11,776.00) 0.00% 393000 - Capital Lease Proceeds - 1,290,000.00 1,290,000.00 - 100.00% Total Other Sources - 1,355,458.00 1,290,000.00 (65,458.00) 105.07% Total Revenue 176,102.34 2,010,965.93 1,993,692.00 (17,273.93) 100.87% 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 80,283.91 804,618.57 - 804,618.57 805,100.00 481.43 99.94% 410002 - Teamster Wages 88,846.88 1,197,822.22 - 1,197,822.22 1,226,062.00 28,239.78 97.70% 410003 - Permanent Part Time 27,801.63 359,986.53 - 359,986.53 362,384.00 2,397.47 99.34% 410004 - Extra & Overtime 8,314.41 102,582.55 - 102,582.55 102,838.00 255.45 99.75% 410005 - Seasonal & Interns 9,574.31 313,859.89 - 313,859.89 331,948.00 18,088.11 94.55% 410007 - Longevity Pay 350.00 6,333.32 - 6,333.32 7,450.00 1,116.68 85.01% 410014 - Contract Add Pays - - - - - - 0.00% 410017 - Stand By Pay - 2,374.63 - 2,374.63 3,500.00 1,125.37 67.85% Total Salaries & Wages 215,171.14 2,787,577.71 - 2,787,577.71 2,839,282.00 51,704.29 98.18% Employee Benefits 411001 - FICA Regular 17,538.78 216,686.93 - 216,686.93 217,253.00 566.07 99.74% 411004 - PERF Regular 18,940.95 235,443.88 - 235,443.88 245,889.00 10,445.12 95.75% 411005 - PERF Union 1,084.02 15,194.88 - 15,194.88 20,541.00 5,346.12 73.97% 411007 - Unemployment Comp 19.03 2,292.24 - 2,292.24 3,472.00 1,179.76 66.02% 411008 - Health Insurance 42,719.36 530,269.12 - 530,269.12 549,696.00 19,426.88 96.47% 411009 - Life Insurance 395.00 4,915.00 - 4,915.00 5,160.00 245.00 95.25% 411014 - Parental Leave 613.50 7,337.03 - 7,337.03 7,594.00 256.97 96.62% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,310.00 110.00 91.60% 411200 - Clothing Allowance 90.91 90.91 - 90.91 91.00 0.09 99.90% December 31, 2022 411201 - Tool Allowance 1,000.00 4,980.24 - 4,980.24 4,981.00 0.76 99.98% 411203 - Job Readiness Allow. 294.24 12,619.24 - 12,619.24 15,178.00 2,558.76 83.14% 411206 - Cell Phone Allowance 440.00 5,280.00 - 5,280.00 5,940.00 660.00 88.89% Total Employee Benefits 83,135.79 1,036,309.47 - 1,036,309.47 1,077,105.00 40,795.53 96.21% Total Personnel Expenses 298,306.93 3,823,887.18 - 3,823,887.18 3,916,387.00 92,499.82 97.64% Supplies Expenses Office Supplies 421000 - General Office Supplies 172.43 4,707.33 - 4,707.33 5,039.00 331.67 93.42% Total Office Supplies 172.43 4,707.33 - 4,707.33 5,039.00 331.67 93.42% Operating Supplies 422000 - Other Operating Supplies 6,751.33 188,055.56 - 188,055.56 196,558.76 8,503.20 95.67% 422001 - C.S. Gasoline 18,799.31 239,087.82 - 239,087.82 243,000.00 3,912.18 98.39% 422003 - Gasoline 211.48 211.48 - 211.48 2,405.00 2,193.52 8.79% 422004 - Oil - 35.30 - 35.30 50.00 14.70 70.60% 422005 - Uniforms - - - - 1,781.75 1,781.75 0.00% 422006 - Computer Supplies & Equipment 128.38 1,258.98 - 1,258.98 1,259.00 0.02 100.00% 422007 - Cleaning Supplies - 4,024.06 - 4,024.06 4,327.00 302.94 93.00% 422008 - Medical/Safety Supplies 64.29 16,038.69 - 16,038.69 17,396.00 1,357.31 92.20% 422010 - Plants Chemicals Seed & Fertilizer - 65,832.23 - 65,832.23 82,555.00 16,722.77 79.74% Total Operating Supplies 25,954.79 514,544.12 - 514,544.12 549,332.51 34,788.39 93.67% Repair & Maintenance Supplies 423000 - Other R&M Supplies 5,221.17 170,560.81 - 170,560.81 178,183.53 7,622.72 95.72% 423001 - Building Materials 539.56 64,238.59 - 64,238.59 69,490.55 5,251.96 92.44% 423006 - Small Tools & Equipment 1,957.34 26,487.94 - 26,487.94 26,488.00 0.06 100.00% 423009 - Repair Parts 10,610.89 68,015.87 - 68,015.87 71,004.79 2,988.92 95.79% Total Repair & Maintenance Supplies 18,328.96 329,303.21 - 329,303.21 345,166.87 15,863.66 95.40% Total Supplies Expenses 44,456.18 848,554.66 - 848,554.66 899,538.38 50,983.72 94.33% Services & Charges Expenses Professional Services 431000 - Other Professional Services 733.89 23,946.22 - 23,946.22 31,303.04 7,356.82 76.50% 431009 - Computer & Technology - 31.83 - 31.83 35.00 3.17 90.94% 431014 - Collection Costs 6.25 68.75 - 68.75 100.00 31.25 68.75% 431015 - Laboratory Water Testing - 250.00 - 250.00 300.00 50.00 83.33% 431019 - Security Services 880.00 42,454.35 - 42,454.35 44,664.00 2,209.65 95.05% Total Professional Services 1,620.14 66,751.15 - 66,751.15 76,402.04 9,650.89 87.37% Communication & Transportation 432003 - Travel 526.65 4,094.91 - 4,094.91 6,145.50 2,050.59 66.63% 432004 - Telecommunications 156.46 1,439.90 - 1,439.90 4,123.00 2,683.10 34.92% Total Communication & Transportation 683.11 5,534.81 - 5,534.81 10,268.50 4,733.69 53.90% Printing & Advertising 433001 - Outside Printing Services - 500.00 - 500.00 2,000.00 1,500.00 25.00% 433002 - Publication of Legal Notice 429.18 1,425.28 - 1,425.28 1,430.28 5.00 99.65% Total Printing & Advertising 429.18 1,925.28 - 1,925.28 3,430.28 1,505.00 56.13% Utilties 435001 - Electric 40,640.88 444,608.79 - 444,608.79 452,810.00 8,201.21 98.19% 435002 - Natural Gas 20,916.04 166,945.80 - 166,945.80 169,020.00 2,074.20 98.77% 435004 - Water 7,551.88 246,245.68 - 246,245.68 252,920.00 6,674.32 97.36% Total Utilities 69,108.80 857,800.27 - 857,800.27 874,750.00 16,949.73 98.06% Repairs & Maintenance 436000 - Other R&M 891.00 36,518.71 - 36,518.71 40,151.00 3,632.29 90.95% 436001 - Building R&M 10,059.50 203,745.68 - 203,745.68 229,887.22 26,141.54 88.63% 436002 - Office Equip R&M - 28.88 - 28.88 32.00 3.12 90.25% 436003 - Auto Equip R&M 28,603.18 324,822.89 - 324,822.89 324,823.00 0.11 100.00% 436005 - Other Equip R&M - 1,419.21 - 1,419.21 1,807.90 388.69 78.50% 436006 - Radio Equip R&M 117.25 16,214.63 - 16,214.63 17,561.00 1,346.37 92.33% 436011 - Exterminating 613.00 5,345.00 - 5,345.00 6,017.00 672.00 88.83% Total Repairs & Maintenance 40,283.93 588,095.00 - 588,095.00 620,279.12 32,184.12 94.81% Rentals 437002 - Equipment Rental - 560.00 - 560.00 611.00 51.00 91.65% Total Rentals - 560.00 - 560.00 611.00 51.00 91.65% 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 2,228.00 463,316.97 2,918.95 466,235.92 485,665.27 19,429.35 96.00% 439001 - Other Contractual Services 3,500.00 11,873.96 - 11,873.96 14,000.00 2,126.04 84.81% 439002 - Licenses & Permits - 1,374.36 - 1,374.36 1,450.00 75.64 94.78% 439003 - Subscriptions - 2,217.79 - 2,217.79 2,320.00 102.21 95.59% 439004 - Dues & Memberships - 390.00 - 390.00 1,675.00 1,285.00 23.28% 439006 - Education & Training - 9,919.06 - 9,919.06 10,821.00 901.94 91.66% 439009 - Trash Removal 6,148.42 41,640.35 - 41,640.35 42,751.60 1,111.25 97.40% 439012 - Uniform Services 1,936.35 16,218.41 - 16,218.41 16,219.00 0.59 100.00% 439100 - Refunds/Awards/Indemnities - 120.13 - 120.13 200.00 79.87 60.07% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,449.00 449.00 97.09% Total Other Services & Charges 13,812.77 562,071.03 2,918.95 564,989.98 590,550.87 25,560.89 95.67% Total Services & Charges Expenses 125,937.93 2,218,948.64 2,918.95 2,221,867.59 2,323,860.81 101,993.22 95.61% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment - 121,482.50 - 121,482.50 121,482.50 - 100.00% 445100 - Lease Purchase/Motor Equip - 242,136.70 - 242,136.70 242,136.70 - 100.00% Total Machinery & Equipment - 374,486.15 - 374,486.15 374,486.06 (0.09) 100.00% Total Capital Expenses - 374,486.15 - 374,486.15 374,486.06 (0.09) 100.00% Other Uses 452002 - Allocations-Admin Cost 63,284.50 379,707.00 - 379,707.00 379,707.00 - 100.00% 452003 - Allocations-IT 25,611.34 153,668.00 - 153,668.00 153,668.00 - 100.00% 452004 - Allocations-Liability Insurance 22,026.16 132,157.00 - 132,157.00 132,157.00 - 100.00% 452009 - Allocations-Facilities Mgmt 4,002.00 24,012.00 - 24,012.00 24,012.00 - 100.00% Total Other Uses 114,924.00 689,544.00 - 689,544.00 689,544.00 - 100.00% Total Expenses 583,625.04 7,955,420.63 2,918.95 7,958,339.58 8,203,816.25 245,476.67 97.01%