Loading...
HomeMy WebLinkAboutAug 23 Fin 3South Bend Venues, Parks and Arts Parks Maintenance: Revenues and Expenditures REVENUES Current YTD Total Estimated Under/(Over) Percent of Account String Month Revenue Revenues Budget Budget Charges for Services Culture & Recreation 347015 - Lease of Stadium 30,000.00 75,000.00 75,000.00 - 100.00% 347021 - Tree Maintenance 1,801.00 22,328.59 - (22,328.59) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% Total Culture & Recreation 31,801.00 97,328.59 77,000.00 (20,328.59) 126.40% Total Charges for Services 31,801.00 97,328.59 77,000.00 (20,328.59) 126.40% Miscellaneous Revenue 360000 - Miscellaneous - 2,000.00 - (2,000.00) 0.00% 360001 - Sale of Scrap Metal - 964.73 - (964.73) 0.00% 360011 - Settlement Fees - 50,450.00 - (50,450.00) 0.00% Total Miscellaneous Revenue - 53,414.73 - (53,414.73) 0.00% Refunds & Reimbursements 380000 - Misc Reimbursements - 45,118.17 45,000.00 (118.17) 100.26% 396000 - Refunds - 219.12 - (219.12) 0.00% Total Refunds & Reimbursements - 45,337.29 45,000.00 (337.29) 100.75% Other Sources 392000 - Gain/Loss on Sale of Asset 37,352.00 37,352.00 - (37,352.00) 0.00% 392005 - Sale of Non-Capital Assets 8,418.00 8,418.00 - (8,418.00) 0.00% Total Other Sources 45,770.00 45,770.00 - (45,770.00) 0.00% Total Revenue 77,571.00 241,850.61 122,000.00 (119,850.61) 198.24% EXPENDITURES Current YTD Total Open YTD Total Amended Available Percent of Account String Month Expenses Encumbrances w/ Encumb. Budget Budget Budget Personnel Expenses Salaries & Wages 410001 - Salaried Wages 73,974.22 584,271.98 - 584,271.98 913,867.00 329,595.02 63.93% 410002 - Teamster Wages 102,970.87 896,533.80 - 896,533.80 1,347,281.00 450,747.20 66.54% 410003 - Permanent Part Time 42,621.02 275,751.88 - 275,751.88 260,000.00 (15,751.88) 106.06% 410004 - Extra & Overtime 12,491.47 68,393.68 - 68,393.68 56,300.00 (12,093.68) 121.48% 410005 - Seasonal & Interns 51,387.90 237,102.32 - 237,102.32 300,000.00 62,897.68 79.03% 410007 - Longevity Pay 37.50 4,537.50 - 4,537.50 8,589.00 4,051.50 52.83% 410017 - Stand By Pay 1,375.00 2,513.66 - 2,513.66 - (2,513.66) 0.00% Total Salaries & Wages 284,857.98 2,069,104.82 - 2,069,104.82 2,886,037.00 816,932.18 71.69% Employee Benefits 411001 - FICA Regular 21,687.89 153,554.40 - 153,554.40 222,609.00 69,054.60 68.98% 411004 - PERF Regular 20,831.37 168,488.68 - 168,488.68 263,192.00 94,703.32 64.02% 411005 - PERF Union 1,060.53 8,884.57 - 8,884.57 21,452.00 12,567.43 41.42% 411007 - Unemployment Comp 20.21 166.80 - 166.80 2,793.00 2,626.20 5.97% 411008 - Health Insurance 48,171.36 379,329.88 - 379,329.88 616,458.00 237,128.12 61.53% 411009 - Life Insurance 450.00 3,510.00 - 3,510.00 5,280.00 1,770.00 66.48% 411010 - Med/Surgical/Dental 541.88 4,316.51 - 4,316.51 - (4,316.51) 0.00% 411014 - Parental Leave 661.94 5,381.69 - 5,381.69 8,145.00 2,763.31 66.07% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411200 - Clothing Allowance - 353.08 - 353.08 356.00 2.92 99.18% 411201 - Tool Allowance 964.62 2,964.95 - 2,964.95 3,644.00 679.05 81.37% 411203 - Job Readiness Allow. - (850.00) - (850.00) 12,750.00 13,600.00 (6.67%) 411206 - Cell Phone Allowance 440.00 3,520.00 - 3,520.00 5,940.00 2,420.00 59.26% Total Employee Benefits 94,829.80 730,820.56 - 730,820.56 1,163,819.00 432,998.44 62.80% August 31, 2023 Total Personnel Expenses 379,687.78 2,799,925.38 - 2,799,925.38 4,049,856.00 1,249,930.62 69.14% Supplies Expenses Office Supplies 421000 - General Office Supplies - 636.00 - 636.00 2,000.00 1,364.00 31.80% Total Office Supplies - 636.00 - 636.00 2,000.00 1,364.00 31.80% Operating Supplies 422000 - Other Operating Supplies 15,232.00 124,966.05 7,792.37 132,758.42 161,387.69 28,629.27 82.26% 422001 - C.S. Gasoline 21,676.05 149,833.60 - 149,833.60 220,000.00 70,166.40 68.11% 422003 - Gasoline - 13.11 - 13.11 667.00 653.89 1.97% 422005 - Uniforms - 2,135.83 - 2,135.83 2,136.25 0.42 99.98% 422006 - Computer Supplies & Equipment 3,140.53 4,010.94 - 4,010.94 3,924.00 (86.94) 102.22% 422007 - Cleaning Supplies - 902.31 - 902.31 3,600.00 2,697.69 25.06% 422008 - Medical/Safety Supplies 395.75 9,484.33 2,260.68 11,745.01 13,104.00 1,358.99 89.63% 422010 - Plants Chemicals Seed & Fertilizer 6,917.93 73,844.45 4,683.67 78,528.12 120,455.00 41,926.88 65.19% Total Operating Supplies 47,362.26 365,190.62 14,736.72 379,927.34 525,273.94 145,346.60 72.33% Repair & Maintenance Supplies 423000 - Other R&M Supplies 19,948.42 138,156.72 6,973.11 145,129.83 232,721.88 87,592.05 62.36% 423001 - Building Materials 1,542.31 70,583.92 9,462.08 80,046.00 145,169.45 65,123.45 55.14% 423006 - Small Tools & Equipment 7,346.75 38,828.59 6,584.52 45,413.11 46,852.00 1,438.89 96.93% 423009 - Repair Parts 7,724.51 68,475.86 7,580.19 76,056.05 77,164.24 1,108.19 98.56% Total Repair & Maintenance Supplies 36,561.99 316,045.09 30,599.90 346,644.99 501,907.57 155,262.58 69.07% Total Supplies Expenses 83,924.25 681,871.71 45,336.62 727,208.33 1,029,181.51 301,973.18 70.66% Services & Charges Expenses Professional Services 431000 - Other Professional Services 7,172.77 115,335.72 9,298.38 124,634.10 135,933.96 11,299.86 91.69% 431001 - Legal Services 3,680.50 3,680.50 - 3,680.50 4,000.00 319.50 92.01% 431009 - Computer & Technology - 7,750.00 - 7,750.00 8,275.00 525.00 93.66% 431014 - Collection Costs 8.75 64.50 - 64.50 100.00 35.50 64.50% 431019 - Security Services 7,194.00 31,922.00 12,636.00 44,558.00 169,669.00 125,111.00 26.26% Total Professional Services 18,056.02 158,752.72 21,934.38 180,687.10 317,977.96 137,290.86 56.82% Communication & Transportation 432002 - Mailing 5.97 9.67 - 9.67 104.00 94.33 9.30% 432003 - Travel 1,862.58 2,251.85 3,040.32 5,292.17 3,617.50 (1,674.67) 146.29% 432004 - Telecommunications 58.48 992.83 2,001.97 2,994.80 11,587.41 8,592.61 25.85% Total Communication & Transportation 1,927.03 3,254.35 5,042.29 8,296.64 15,308.91 7,012.27 54.19% Printing & Advertising 433001 - Outside Printing Services - - - - 2,100.00 2,100.00 0.00% 433002 - Publication of Legal Notice - 1,038.00 834.69 1,872.69 3,277.72 1,405.03 57.13% Total Printing & Advertising - 1,038.00 834.69 1,872.69 5,377.72 3,505.03 34.82% Utilties 435001 - Electric 38,889.32 306,822.12 - 306,822.12 470,043.00 163,220.88 65.28% 435002 - Natural Gas 1,618.11 116,917.38 - 116,917.38 282,938.00 166,020.62 41.32% 435004 - Water 34,243.28 171,715.50 - 171,715.50 300,000.00 128,284.50 57.24% Total Utilities 74,750.71 595,455.00 - 595,455.00 1,052,981.00 457,526.00 56.55% Repairs & Maintenance 436000 - Other R&M 16,530.39 60,673.97 38,500.85 99,174.82 186,324.99 87,150.17 53.23% 436001 - Building R&M 32,417.63 346,516.63 86,857.15 433,373.78 434,902.60 1,528.82 99.65% 436003 - Auto Equip R&M 22,329.05 184,206.51 - 184,206.51 346,750.00 162,543.49 53.12% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 6,992.10 75.68 98.92% 436006 - Radio Equip R&M 1,908.30 16,714.91 - 16,714.91 16,814.00 99.09 99.41% 436011 - Exterminating 899.00 3,830.00 9,557.00 13,387.00 16,342.00 2,955.00 81.92% Total Repairs & Maintenance 74,084.37 618,858.44 134,915.00 753,773.44 1,008,125.69 254,352.25 74.77% Debt Service 438100 - Principal - 246,686.77 - 246,686.77 246,687.00 0.23 100.00% 438200 - Interest - 25,735.45 - 25,735.45 25,735.00 (0.45) 100.00% Total Debt Service - 272,422.22 - 272,422.22 272,422.00 (0.22) 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 4,490.84 39,169.40 54,444.68 93,614.08 90,627.23 (2,986.85) 103.30% 439001 - Other Contractual Services 27,875.24 102,373.18 45,309.89 147,683.07 145,900.00 (1,783.07) 101.22% 439002 - Licenses & Permits - 1,200.00 - 1,200.00 1,208.00 8.00 99.34% 439003 - Subscriptions 243.96 1,266.04 - 1,266.04 1,281.00 14.96 98.83% 439004 - Dues & Memberships - 1,671.00 - 1,671.00 2,494.00 823.00 67.00% 439006 - Education & Training 378.32 11,747.21 8,450.56 20,197.77 20,029.00 (168.77) 100.84% 439009 - Trash Removal 4,919.41 27,859.35 5,658.29 33,517.64 42,493.15 8,975.51 78.88% 439012 - Uniform Services 1,516.81 14,348.89 - 14,348.89 25,941.00 11,592.11 55.31% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 39,424.58 214,635.07 113,863.42 328,498.49 344,973.38 16,474.89 95.22% Total Services & Charges Expenses 208,242.71 1,864,415.80 276,589.78 2,141,005.58 3,017,166.66 876,161.08 70.96% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - - - 21,726.00 21,726.00 0.00% 445003 - Park Equipment 13,892.00 51,418.90 125,513.40 176,932.30 307,819.00 130,886.70 57.48% 445100 - Lease Purchase/Motor Equip 253,531.83 526,065.83 250,862.00 776,927.83 1,047,863.30 270,935.47 74.14% Total Machinery & Equipment 267,423.83 577,484.73 376,375.40 953,860.13 1,377,408.30 423,548.17 69.25% Total Capital Expenses 267,423.83 577,484.73 376,375.40 953,860.13 1,377,408.30 423,548.17 69.25% Other Uses 452002 - Allocations-Admin Cost - 183,800.52 - 183,800.52 367,601.00 183,800.48 50.00% 452003 - Allocations-IT - 82,894.50 - 82,894.50 165,789.00 82,894.50 50.00% 452004 - Allocations-Liability Insurance - 88,992.48 - 88,992.48 177,985.00 88,992.52 50.00% 452009 - Allocations-Facilities Mgmt - 12,820.50 - 12,820.50 25,641.00 12,820.50 50.00% Total Other Uses - 368,508.00 - 368,508.00 737,016.00 368,508.00 50.00% Total Expenses 939,278.57 6,292,205.62 698,301.80 6,990,507.42 10,210,628.47 3,220,121.05 68.46%