Loading...
HomeMy WebLinkAboutDec 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 - 75,000.00 75,000.00 - 100.00% 347021 - Tree Maintenance 2,245.42 36,632.76 - (36,632.76) 0.00% 347023 - Graffiti Removal - - 2,000.00 2,000.00 0.00% Total Culture & Recreation 2,245.42 111,632.76 77,000.00 (34,632.76) 144.98% Total Charges for Services 2,245.42 111,632.76 77,000.00 (34,632.76) 144.98% Miscellaneous Revenue 360000 - Miscellaneous - 2,000.00 - (2,000.00) 0.00% 360001 - Sale of Scrap Metal 182.50 1,501.92 - (1,501.92) 0.00% 360011 - Settlement Fees - 50,450.00 - (50,450.00) 0.00% Total Miscellaneous Revenue 182.50 53,951.92 - (53,951.92) 0.00% Refunds & Reimbursements 380000 - Misc Reimbursements - 45,364.79 45,000.00 (364.79) 100.81% 396000 - Refunds - 2,487.42 - (2,487.42) 0.00% Total Refunds & Reimbursements - 47,852.21 45,000.00 (2,852.21) 106.34% Other Sources 392000 - Gain/Loss on Sale of Asset - 37,352.00 - (37,352.00) 0.00% 392005 - Sale of Non-Capital Assets - 8,418.00 - (8,418.00) 0.00% Total Other Sources - 45,770.00 - (45,770.00) 0.00% Total Revenue 2,427.92 259,206.89 122,000.00 (137,206.89) 212.46% 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 116,807.51 959,989.30 - 959,989.30 959,992.00 2.70 100.00% 410002 - Teamster Wages 91,174.28 1,286,046.33 - 1,286,046.33 1,347,281.00 61,234.67 95.45% 410003 - Permanent Part Time 17,632.47 413,412.54 - 413,412.54 425,000.00 11,587.46 97.27% 410004 - Extra & Overtime 5,444.42 101,063.36 - 101,063.36 121,300.00 20,236.64 83.32% 410005 - Seasonal & Interns 21,751.59 378,149.63 - 378,149.63 378,150.00 0.37 100.00% 410007 - Longevity Pay 350.00 5,887.50 - 5,887.50 8,589.00 2,701.50 68.55% 410017 - Stand By Pay - 2,513.66 - 2,513.66 5,000.00 2,486.34 50.27% Total Salaries & Wages 253,160.27 3,147,062.32 - 3,147,062.32 3,245,312.00 98,249.68 96.97% Employee Benefits 411001 - FICA Regular 19,148.44 234,215.60 - 234,215.60 234,219.00 3.40 100.00% 411004 - PERF Regular 22,916.67 256,094.16 - 256,094.16 263,192.00 7,097.84 97.30% 411005 - PERF Union 1,130.54 13,015.50 - 13,015.50 21,452.00 8,436.50 60.67% 411007 - Unemployment Comp 22.65 251.70 - 251.70 2,793.00 2,541.30 9.01% 411008 - Health Insurance 43,551.90 550,014.88 - 550,014.88 552,223.00 2,208.12 99.60% 411009 - Life Insurance 410.00 5,120.00 - 5,120.00 5,280.00 160.00 96.97% 411010 - Med/Surgical/Dental 477.21 6,178.27 - 6,178.27 6,200.00 21.73 99.65% 411014 - Parental Leave 747.53 8,172.47 - 8,172.47 8,175.00 2.53 99.97% 411015 - Other Fringe Benefits - 1,200.00 - 1,200.00 1,200.00 - 100.00% 411200 - Clothing Allowance 172.26 675.14 - 675.14 676.00 0.86 99.87% 411201 - Tool Allowance 780.46 4,945.13 - 4,945.13 5,644.00 698.87 87.62% 411203 - Job Readiness Allow. - (1,381.25) - (1,381.25) 4,550.00 5,931.25 (30.36%) 411206 - Cell Phone Allowance 440.00 5,280.00 - 5,280.00 5,940.00 660.00 88.89% Total Employee Benefits 89,797.66 1,083,781.60 - 1,083,781.60 1,111,544.00 27,762.40 97.50% December 31, 2023 Total Personnel Expenses 342,957.93 4,230,843.92 - 4,230,843.92 4,356,856.00 126,012.08 97.11% Supplies Expenses Office Supplies 421000 - General Office Supplies 219.31 1,924.65 - 1,924.65 5,200.02 3,275.37 37.01% Total Office Supplies 219.31 1,924.65 - 1,924.65 5,200.02 3,275.37 37.01% Operating Supplies 422000 - Other Operating Supplies 18,120.12 175,881.10 - 175,881.10 198,627.78 22,746.68 88.55% 422001 - C.S. Gasoline 10,996.64 209,857.16 - 209,857.16 220,000.00 10,142.84 95.39% 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 - 4,010.94 - 4,010.94 4,011.00 0.06 100.00% 422007 - Cleaning Supplies - 3,222.85 - 3,222.85 3,600.00 377.15 89.52% 422008 - Medical/Safety Supplies 340.03 13,290.82 - 13,290.82 13,304.00 13.18 99.90% 422010 - Plants Chemicals Seed & Fertilizer - 104,302.05 - 104,302.05 115,762.87 11,460.82 90.10% Total Operating Supplies 29,456.79 512,713.86 - 512,713.86 558,108.90 45,395.04 91.87% Repair & Maintenance Supplies 423000 - Other R&M Supplies 6,203.50 178,061.97 - 178,061.97 197,634.88 19,572.91 90.10% 423001 - Building Materials 3,849.80 89,973.53 - 89,973.53 105,719.45 15,745.92 85.11% 423006 - Small Tools & Equipment 1,571.40 58,127.03 - 58,127.03 58,127.20 0.17 100.00% 423009 - Repair Parts 12,238.12 103,086.70 - 103,086.70 111,077.99 7,991.29 92.81% Total Repair & Maintenance Supplies 23,862.82 429,249.23 - 429,249.23 472,559.52 43,310.29 90.83% Total Supplies Expenses 53,538.92 943,887.74 - 943,887.74 1,035,868.44 91,980.70 91.12% Services & Charges Expenses Professional Services 431000 - Other Professional Services - 118,274.43 - 118,274.43 135,183.96 16,909.53 87.49% 431001 - Legal Services - 18,116.50 - 18,116.50 18,436.00 319.50 98.27% 431009 - Computer & Technology - 7,789.95 - 7,789.95 8,275.00 485.05 94.14% 431014 - Collection Costs 75.00 189.50 - 189.50 190.00 0.50 99.74% 431019 - Security Services 7,755.00 57,882.00 - 57,882.00 63,474.00 5,592.00 91.19% Total Professional Services 7,830.00 202,252.38 - 202,252.38 225,558.96 23,306.58 89.67% Communication & Transportation 432002 - Mailing - 9.67 - 9.67 104.00 94.33 9.30% 432003 - Travel - 2,251.85 - 2,251.85 5,617.50 3,365.65 40.09% 432004 - Telecommunications 58.48 1,168.27 - 1,168.27 4,774.88 3,606.61 24.47% Total Communication & Transportation 58.48 3,429.79 - 3,429.79 10,496.38 7,066.59 32.68% Printing & Advertising 433001 - Outside Printing Services 205.00 685.33 - 685.33 2,100.00 1,414.67 32.63% 433002 - Publication of Legal Notice - 1,352.50 - 1,352.50 2,998.00 1,645.50 45.11% Total Printing & Advertising 205.00 2,037.83 - 2,037.83 5,098.00 3,060.17 39.97% Utilties 435001 - Electric 35,909.32 437,002.54 - 437,002.54 470,143.00 33,140.46 92.95% 435002 - Natural Gas 17,767.57 145,044.83 - 145,044.83 231,623.00 86,578.17 62.62% 435004 - Water 6,427.31 245,282.68 - 245,282.68 300,000.00 54,717.32 81.76% Total Utilities 60,104.20 827,330.05 - 827,330.05 1,001,766.00 174,435.95 82.59% Repairs & Maintenance 436000 - Other R&M 17,959.31 127,139.13 - 127,139.13 150,545.95 23,406.82 84.45% 436001 - Building R&M 43,928.64 481,823.76 - 481,823.76 492,378.61 10,554.85 97.86% 436003 - Auto Equip R&M 16,900.50 273,171.68 - 273,171.68 305,250.00 32,078.32 89.49% 436005 - Other Equip R&M - 6,916.42 - 6,916.42 6,992.10 75.68 98.92% 436006 - Radio Equip R&M 2,040.67 41,371.60 - 41,371.60 48,814.00 7,442.40 84.75% 436011 - Exterminating 3,256.00 10,351.00 - 10,351.00 13,306.00 2,955.00 77.79% Total Repairs & Maintenance 84,085.12 940,773.59 - 940,773.59 1,017,286.66 76,513.07 92.48% Rentals 437002 - Equipment Rental 215.00 215.00 - 215.00 215.00 - 100.00% Total Rentals 215.00 215.00 - 215.00 215.00 - 100.00% 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,736.00 0.55 100.00% Total Debt Service - 272,422.22 - 272,422.22 272,423.00 0.78 100.00% Other Charges & Services 439000 - Misc Charges & Svcs 15,291.14 107,018.81 (2,918.95) 104,099.86 130,307.23 26,207.37 79.89% 439001 - Other Contractual Services 3,441.58 152,131.90 - 152,131.90 204,656.00 52,524.10 74.34% 439002 - Licenses & Permits - 1,200.00 - 1,200.00 1,208.00 8.00 99.34% 439003 - Subscriptions 24.99 2,119.03 - 2,119.03 2,281.00 161.97 92.90% 439004 - Dues & Memberships 230.00 2,076.00 - 2,076.00 2,494.00 418.00 83.24% 439006 - Education & Training 7,849.25 20,567.70 - 20,567.70 23,764.95 3,197.25 86.55% 439009 - Trash Removal 6,770.69 43,738.63 - 43,738.63 46,926.90 3,188.27 93.21% 439012 - Uniform Services 1,841.38 21,007.83 - 21,007.83 21,941.00 933.17 95.75% 439300 - Grants & Subsidies - 15,000.00 - 15,000.00 15,000.00 - 100.00% Total Other Services & Charges 35,449.03 364,859.90 (2,918.95) 361,940.95 448,579.08 86,638.13 80.69% Total Services & Charges Expenses 187,946.83 2,613,320.76 (2,918.95) 2,610,401.81 2,981,423.08 371,021.27 87.56% Capital Outlay Machinery & Equipment 445000 - Motor Equipment - - - - 67,496.00 67,496.00 0.00% 445003 - Park Equipment - 65,015.29 - 65,015.29 65,015.29 - 100.00% 445100 - Lease Purchase/Motor Equip - 904,362.49 - 904,362.49 904,362.49 - 100.00% Total Machinery & Equipment - 969,377.78 - 969,377.78 1,036,873.78 67,496.00 93.49% Total Capital Expenses - 969,377.78 - 969,377.78 1,036,873.78 67,496.00 93.49% Other Uses 452002 - Allocations-Admin Cost 30,633.42 367,601.04 - 367,601.04 367,601.00 (0.04) 100.00% 452003 - Allocations-IT 13,815.75 165,789.00 - 165,789.00 165,789.00 - 100.00% 452004 - Allocations-Liability Insurance 14,832.08 177,984.96 - 177,984.96 177,985.00 0.04 100.00% 452009 - Allocations-Facilities Mgmt 2,136.75 25,641.00 - 25,641.00 25,641.00 - 100.00% Total Other Uses 61,418.00 737,016.00 - 737,016.00 737,016.00 - 100.00% Total Expenses 645,861.68 9,494,446.20 (2,918.95) 9,491,527.25 10,148,037.30 656,510.05 93.53%