Loading...
HomeMy WebLinkAboutNov 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 - 117,974.10 222,839.00 104,864.90 52.94% 347021 - Tree Maintenance 1,038.49 148,208.77 120,000.00 (28,208.77) 123.51% 347023 - Graffiti Removal - 4,930.26 - (4,930.26) 0.00% Total Culture & Recreation 1,038.49 346,113.13 417,839.00 71,725.87 82.83% Total Charges for Services 1,038.49 346,113.13 417,839.00 71,725.87 82.83% Miscellaneous Revenue 360000 - Miscellaneous - - 2,000.00 2,000.00 0.00% 360001 - Sale of Scrap Metal 81.25 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 81.25 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 1,119.74 1,834,863.59 1,993,692.00 158,828.41 92.03% 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.45 724,334.66 - 724,334.66 820,100.00 95,765.34 88.32% 410002 - Teamster Wages 99,562.33 1,108,975.34 - 1,108,975.34 1,271,200.00 162,224.66 87.24% 410003 - Permanent Part Time 32,831.81 332,184.90 - 332,184.90 255,000.00 (77,184.90) 130.27% 410004 - Extra & Overtime 4,661.58 94,268.14 - 94,268.14 66,300.00 (27,968.14) 142.18% 410005 - Seasonal & Interns 19,910.42 304,285.58 - 304,285.58 300,000.00 (4,285.58) 101.43% 410007 - Longevity Pay 350.00 5,983.32 - 5,983.32 7,450.00 1,466.68 80.31% 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 217,906.59 2,572,406.57 - 2,572,406.57 2,723,550.00 151,143.43 94.45% Employee Benefits 411001 - FICA Regular 16,028.19 199,148.15 - 199,148.15 210,409.00 11,260.85 94.65% 411004 - PERF Regular 17,450.42 216,502.93 - 216,502.93 245,889.00 29,386.07 88.05% 411005 - PERF Union 1,078.34 14,110.86 - 14,110.86 20,541.00 6,430.14 68.70% 411007 - Unemployment Comp 17.71 2,273.21 - 2,273.21 3,472.00 1,198.79 65.47% 411008 - Health Insurance 49,437.36 487,549.76 - 487,549.76 582,882.00 95,332.24 83.64% 411009 - Life Insurance 450.00 4,520.00 - 4,520.00 5,160.00 640.00 87.60% 411014 - Parental Leave 577.37 6,723.53 - 6,723.53 7,594.00 870.47 88.54% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411200 - Clothing Allowance - - 90.91 90.91 - (90.91) 0.00% November 30, 2022 411201 - Tool Allowance - 3,980.24 500.00 4,480.24 4,481.00 0.76 99.98% 411203 - Job Readiness Allow. - 12,325.00 197.94 12,522.94 15,269.00 2,746.06 82.02% 411206 - Cell Phone Allowance 440.00 4,840.00 - 4,840.00 5,940.00 1,100.00 81.48% Total Employee Benefits 85,479.39 953,173.68 788.85 953,962.53 1,102,837.00 148,874.47 86.50% Total Personnel Expenses 303,385.98 3,525,580.25 788.85 3,526,369.10 3,826,387.00 300,017.90 92.16% Supplies Expenses Office Supplies 421000 - General Office Supplies 1,040.80 4,534.90 172.43 4,707.33 5,000.00 292.67 94.15% Total Office Supplies 1,040.80 4,534.90 172.43 4,707.33 5,000.00 292.67 94.15% Operating Supplies 422000 - Other Operating Supplies 13,157.13 181,304.23 11,798.81 193,103.04 197,213.45 4,110.41 97.92% 422001 - C.S. Gasoline 16,567.32 220,288.51 - 220,288.51 165,000.00 (55,288.51) 133.51% 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 745.78 1,130.60 - 1,130.60 500.00 (630.60) 226.12% 422007 - Cleaning Supplies - 4,024.06 - 4,024.06 4,550.00 525.94 88.44% 422008 - Medical/Safety Supplies 1,112.21 15,974.40 - 15,974.40 12,980.00 (2,994.40) 123.07% 422010 - Plants Chemicals Seed & Fertilizer 5,334.94 65,832.23 455.00 66,287.23 85,975.00 19,687.77 77.10% Total Operating Supplies 36,917.38 488,589.33 13,522.06 502,111.39 471,673.45 (30,437.94) 106.45% Repair & Maintenance Supplies 423000 - Other R&M Supplies 10,561.91 165,339.64 19,348.50 184,688.14 184,174.41 (513.73) 100.28% 423001 - Building Materials 2,986.81 63,699.03 669.45 64,368.48 68,868.00 4,499.52 93.47% 423006 - Small Tools & Equipment 1,942.84 24,530.60 231.99 24,762.59 25,573.00 810.41 96.83% 423009 - Repair Parts 8,499.73 57,404.98 10,015.61 67,420.59 79,729.03 12,308.44 84.56% Total Repair & Maintenance Supplies 23,991.29 310,974.25 30,265.55 341,239.80 358,344.44 17,104.64 95.23% Total Supplies Expenses 61,949.47 804,098.48 43,960.04 848,058.52 835,017.89 (13,040.63) 101.56% Services & Charges Expenses Professional Services 431000 - Other Professional Services 12,286.33 23,212.33 57,538.96 80,751.29 78,000.00 (2,751.29) 103.53% 431009 - Computer & Technology - 31.83 7,750.00 7,781.83 500.00 (7,281.83) 1556.37% 431014 - Collection Costs 6.25 62.50 - 62.50 100.00 37.50 62.50% 431015 - Laboratory Water Testing - 250.00 - 250.00 300.00 50.00 83.33% 431019 - Security Services 3,564.00 41,574.35 1,856.00 43,430.35 46,640.00 3,209.65 93.12% Total Professional Services 15,856.58 65,131.01 67,144.96 132,275.97 125,540.00 (6,735.97) 105.37% Communication & Transportation 432003 - Travel - 3,568.26 254.50 3,822.76 6,400.00 2,577.24 59.73% 432004 - Telecommunications - 1,283.44 2,417.41 3,700.85 6,360.41 2,659.56 58.19% Total Communication & Transportation - 4,851.70 2,671.91 7,523.61 12,760.41 5,236.80 58.96% Printing & Advertising 433001 - Outside Printing Services - 500.00 - 500.00 2,000.00 1,500.00 25.00% 433002 - Publication of Legal Notice - 996.10 1,611.30 2,607.40 2,200.00 (407.40) 118.52% Total Printing & Advertising - 1,496.10 1,611.30 3,107.40 4,200.00 1,092.60 73.99% Utilties 435001 - Electric 30,538.17 403,967.91 - 403,967.91 403,180.00 (787.91) 100.20% 435002 - Natural Gas 11,150.02 146,029.76 - 146,029.76 90,938.00 (55,091.76) 160.58% 435004 - Water 9,050.10 238,693.80 - 238,693.80 214,000.00 (24,693.80) 111.54% Total Utilities 50,738.29 788,691.47 - 788,691.47 708,118.00 (80,573.47) 111.38% Repairs & Maintenance 436000 - Other R&M 2,013.17 35,627.71 5,465.43 41,093.14 39,278.99 (1,814.15) 104.62% 436001 - Building R&M 13,018.02 193,686.18 68,281.60 261,967.78 262,031.82 64.04 99.98% 436002 - Office Equip R&M - 28.88 - 28.88 - (28.88) 0.00% 436003 - Auto Equip R&M 21,421.12 296,219.71 - 296,219.71 251,000.00 (45,219.71) 118.02% 436005 - Other Equip R&M - 1,419.21 2,992.10 4,411.31 4,800.00 388.69 91.90% 436006 - Radio Equip R&M 1,418.76 16,097.38 - 16,097.38 10,500.00 (5,597.38) 153.31% 436011 - Exterminating 613.00 4,732.00 2,930.00 7,662.00 8,334.00 672.00 91.94% Total Repairs & Maintenance 38,484.07 547,811.07 79,669.13 627,480.20 575,944.81 (51,535.39) 108.95% Rentals 437002 - Equipment Rental - 560.00 - 560.00 600.00 40.00 93.33% Total Rentals - 560.00 - 560.00 600.00 40.00 93.33% 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 6,719.00 461,088.97 30,774.18 491,863.15 489,139.50 (2,723.65) 100.56% 439001 - Other Contractual Services 5,930.00 8,373.96 3,500.00 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 92.00 2,217.79 - 2,217.79 1,820.00 (397.79) 121.86% 439004 - Dues & Memberships - 390.00 - 390.00 1,675.00 1,285.00 23.28% 439006 - Education & Training 338.26 9,919.06 479.00 10,398.06 11,300.00 901.94 92.02% 439009 - Trash Removal 488.54 35,491.93 7,928.24 43,420.17 43,920.75 500.58 98.86% 439012 - Uniform Services 1,541.87 14,282.06 - 14,282.06 11,200.00 (3,082.06) 127.52% 439100 - Refunds/Awards/Indemnities - 120.13 - 120.13 200.00 79.87 60.07% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 15,109.67 548,258.26 42,681.42 590,939.68 589,705.25 (1,234.43) 100.21% Total Services & Charges Expenses 120,188.61 2,093,010.71 193,778.72 2,286,789.43 2,164,437.47 (122,351.96) 105.65% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - 10,866.95 - 10,866.95 10,866.86 (0.09) 100.00% 445003 - Park Equipment 29,116.24 121,482.50 9,045.00 130,527.50 386,027.50 255,500.00 33.81% 445100 - Lease Purchase/Motor Equip - 242,136.70 460,253.83 702,390.53 1,290,000.00 587,609.47 54.45% Total Machinery & Equipment 29,116.24 374,486.15 469,298.83 843,784.98 1,686,894.36 843,109.38 50.02% Total Capital Expenses 29,116.24 374,486.15 469,298.83 843,784.98 1,686,894.36 843,109.38 50.02% Other Uses 452002 - Allocations-Admin Cost - 316,422.50 - 316,422.50 379,707.00 63,284.50 83.33% 452003 - Allocations-IT - 128,056.66 - 128,056.66 153,668.00 25,611.34 83.33% 452004 - Allocations-Liability Insurance - 110,130.84 - 110,130.84 132,157.00 22,026.16 83.33% 452009 - Allocations-Facilities Mgmt - 20,010.00 - 20,010.00 24,012.00 4,002.00 83.33% Total Other Uses - 574,620.00 - 574,620.00 689,544.00 114,924.00 83.33% Total Expenses 514,640.30 7,371,795.59 707,826.44 8,079,622.03 9,202,280.72 1,122,658.69 87.80%