Loading...
HomeMy WebLinkAbout[07] 2019 Enterprise Budget Council Agenda Item CITY OF ST.JOSEPH MEETING DATE: November 5, 2018 AGENDA ITEM: Enterprise Budget and Equipment Plan SUBMITTED BY: Finance/Administration/Public Works BOARD/COMMISSION/COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: City Council passed preliminary general fund budget and capital equipment plan on September 17,2018. BACKGROUND INFORMATION: The enterprise funds include services for water, sewer, refuse/compost, storm water and street light utilities. The funds operate similar to a commercial business where fees charged for the service typically cover all expenses of the funds, including depreciation. Fees collected for the refuse/compost and street light utility funds cover the expenses incurred for the funds. The water, sewer and storm water fees charged do not fully cover depreciation. Expenses for long-term debts and capital projects are partially covered by the funds' reserve accounts and connection fees reported in separate funds(as required by Minnesota law). A couple comments: 1. Staff will meet with the area cities to review current and upcoming projects under SCAWAC on Nov. 8th. New projects are not anticipated for the next couple years. Budgeted operational sewer treatment rates will be reviewed at this meeting. 2. The refuse contract with Republic Services continues through 2020. Staff is reviewing spring and fall clean up options. 3. C&L Excavating will continue contracting with the City for composting. 4. Union contracts end Dec. 31,2019. Implementation of the Organizational Study will be reviewed with the council soon. The operational budget is set to allow for the implementation estimates. 5. Water and Sewer rates were anticipated to increase per the Rate Analysis completed by Carl Brown Consulting. Staffs preliminary analysis of the rates shows no increase is necessary for water, and sewer may see less than 1%increase. Between the development rates and current usage fees,the increases are expected to be less than anticipated in the last comprehensive rate study. 6. Annexation area services will continue to be minimal service areas. The Enterprise equipment plans were included in the budget books handed out earlier this budget cycle. Please reference your budget books for discussion on the enterprise capital budget. A summary of capital purchases are listed in the table on the next page. 2019 2020 2021 at/� 1000 gal diesel fuel tank �Wr Televising/root foaming Televising/root foaming Televising/root foaming er'/Se*er Public Works facility Sewage Sampler er _ _ Lift Station pumps Lift Station pumps Lift Station pumps Storm Street sweeper g' ter e! r` � Utility truck Utility truck t t14 t '. ..: . Millstream lights rsto ," Millstream ponding The Engineer's capital plan includes a couple potential projects with partial enterprise funding shown in the table below. 2019 2020 2021 SevierCIPP 1st Ave NE CR121 Lift Station Generator �VVa r t n,cr/ tp Industrial Park Phase I « CBD Alleys Phase II :tfp CSAH2 Trunk Water* *depends upon DC project BUDGET/FISCAL IMPACT: $4,183,295 expense budget ATTACHMENTS: Request for Council Action—Enterprise Budget and Equipment Plan 2019 Proposed Enterprise Expense Budget REQUESTED COUNCIL ACTION: Review the Enterprise draft budget and capital equipment plans. City of St. Joseph 11/02/18 11:07 AM Page 1 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OBJ OBJ Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget FUND 601 Water Fund DEPART 47100 Bond Payment(P&I) 413 Lease Payments $4,350.00 $4,350.00 $4,350.00 $4,350.00 $5,800.00 $5,800.00 $5,800.00 600 Debt Service-Principal $545,000.00 $0.00 $490,000.00 $0.00 $576,000.00 $505,000.00 $581,000.00 611 Bond Interest $142,195.00 $140,645.50 $123,625.00 $125,481.50 $124,085.00 $107,949.31 $110,070.00 620 Agent Fees $800.00 $631.36 $800.00 $821.10 $650.00 $495.00 $825.00 621 Financing Fees $0.00 $0.00 $0.00 $7,651.53 $0.00 $0.00 $0.00 DEPART 47100 Bond Payment(P&I) $692,345.00 $145,626.86 $618,775.00 $138,304.13 $706,535.00 $619,244.31 $697,695.00 DEPART 49300 Other Financing Uses 710 Loss on Disposal of Assets $0.00 $0.00 $0.00 $1,457.79 $0.00 $0.00 $0.00 720 Transfers to Other Funds $38,215.00 $88,715.00 $36,770.00 $41,770.00 $41,500.00 $500.00 $12,725.00 DEPART 49300 Other Financing Uses $38,215.00 $88,715.00 $36,770.00 $43,227.79 $41,500.00 $500.00 $12,725.00 DEPART 49410 Power and Pumping 220 Repair and Maintenance $15,000.00 $24,197.00 $15,000.00 $934.00 $15,000.00 $2,062.24 $15,000.00 381 Electric Utilities $4,455.00 $2,821.30 $1,515.00 $3,986.82 $2,955.00 $2,390.56 $1,215.00 383 Gas Utilities $1,650.00 $928.52 $925.00 $956.10 $970.00 $750.20 $1,205.00 530 Improvements Other than Bldgs $0.00 $0.00 $1,250.00 $0.00 $10,000.00 $0.00 $0.00 DEPART 49410 Power and Pumping $21,105.00 $27,946.82 $18,690.00 $5,876.92 $28,925.00 $5,203.00 $17,420.00 DEPART 49420 Purification-Plant 1 210 Operating Supplies $4,500.00 $1,895.07 $4,500.00 $5,745.21 $4,500.00 $1,130.50 $5,750.00 220 Repair and Maintenance $5,000.00 $2,937.59 $5,000.00 $1,975.82 $5,000.00 $3,427.19 $10,000.00 300 Professional Services $500.00 $48.26 $500.00 $366.67 $500.00 $938.00 $500.00 303 Engineering Fee $0.00 $0.00 $0.00 $0.00 $0.00 $31,149.00 $0.00 312 Tests $1,750.00 $1,957.00 $1,750.00 $1,978.00 $1,750.00 $1,805.00 $1,950.00 321 Telephone $3,300.00 $3,305.00 $3,300.00 $3,320.00 $3,300.00 $2,050.00 $2,460.00 381 Electric Utilities $10,350.00 $8,486.36 $7,980.00 $9,050.00 $9,015.00 $6,253.82 $8,570.00 383 Gas Utilities $6,035.00 $1,989.96 $1,955.00 $2,111.18 $2,105.00 $1,744.44 $3,725.00 530 Improvements Other than Bldgs $0.00 $0.00 $305,650.00 $0.00 $0.00 $227,637.32 $0.00 580 Other Equipment $12,500.00 $0.00 $5,000.00 $0.00 $5,000.00 $0.00 $5,000.00 DEPART 49420 Purification-Plant 1 $43,935.00 $20,619.24 $335,635.00 $24,546.88 $31,170.00 $276,135.27 $37,955.00 DEPART 49421 Purification-Plant 2 210 Operating Supplies $18,500.00 $11,948.92 $18,500.00 $17,953.96 $18,500.00 $23,150.79 $18,500.00 215 Software Support $395.00 $859.23 $395.00 $495.00 $395.00 $0.00 $495.00 220 Repair and Maintenance $13,000.00 $14,880.05 $17,000.00 $9,136.16 $15,000.00 $9,833.76 $15,000.00 240 Small Tool&Minor Equipment $500.00 $0.00 $500.00 $76.06 $500.00 $0.00 $500.00 300 Professional Services $2,400.00 $1,719.99 $2,400.00 $2,730.05 $2,400.00 $2,053.85 $2,400.00 City of St. Joseph 11/02/18 11:07 AM Page 2 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OBJ OBJ Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget 303 Engineering Fee $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 321 Telephone $4,605.00 $3,902.17 $4,670.00 $4,126.63 $4,655.00 $3,715.61 $5,340.00 381 Electric Utilities $23,355.00 $31,863.60 $31,900.00 $33,719.06 $32,265.00 $27,368.49 $32,200.00 383 Gas Utilities $12,520.00 $5,927.58 $5,845.00 $6,284.17 $6,585.00 $4,353.74 $7,850.00 580 Other Equipment $5,000.00 $0.00 $5,000.00 $0.00 $5,000.00 $0.00 $5,000.00 DEPART 49421 Purification-Plant 2 $80,275.00 $71,101.54 $86,210.00 $74,521.09 $85,300.00 $70,476.24 $87,285.00 DEPART 49430 Distribution 210 Operating Supplies $5,000.00 $18,540.81 $5,000.00 $23,121.10 $5,000.00 $17,030.57 $5,000.00 220 Repair and Maintenance $5,000.00 $12.99 $5,000.00 $0.00 $5,000.00 $0.00 $5,000.00 530 Improvements Other than Bldgs $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 DEPART 49430 Distribution $10,000.00 $18,553.80 $10,000.00 $23,121.10 $10,000.00 $17,030.57 $10,000.00 DEPART 49434 Wellhead Protection 303 Engineering Fee $2,000.00 $0.00 $2,000.00 $0.00 $2,000.00 $0.00 $5,000.00 340 Advertising $1,000.00 $0.00 $1,000.00 $0.00 $1,000.00 $0.00 $500.00 DEPART 49434 Wellhead Protection $3,000.00 $0.00 $3,000.00 $0.00 $3,000.00 $0.00 $5,500.00 DEPART 49435 Storage-Tower 1 220 Repair and Maintenance $2,000.00 $27.82 $2,000.00 $2,596.46 $2,000.00 $32.00 $2,000.00 300 Professional Services $300.00 $303.70 $300.00 $250.00 $300.00 $250.00 $300.00 303 Engineering Fee $0.00 $2,234.24 $0.00 $174.00 $0.00 $0.00 $0.00 304 Legal Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 321 Telephone $0.00 $0.00 $0.00 $307.50 $0.00 $2,050.00 $2,460.00 381 Electric Utilities $3,845.00 $3,427.17 $3,330.00 $3,227.84 $3,590.00 $2,718.74 $3,535.00 530 Improvements Other than Bldgs $10,000.00 $2,306.30 $10,000.00 $0.00 $10,000.00 $0.00 $10,000.00 DEPART 49435 Storage-Tower 1 $16,145.00 $8,299.23 $15,630.00 $6,555.80 $15,890.00 $5,050.74 $18,295.00 DEPART 49440 Water Maintenance 101 Salaries $104,950.00 $105,035.66 $106,570.00 $111,581.10 $106,860.00 $88,857.65 $107,395.00 111 OPEB Liability $3,000.00 $1,659.52 $3,000.00 -$26,095.90 $3,000.00 $26,095.90 $0.00 112 Pension Expense $0.00 -$7,678.00 $0.00 $21,706.00 $0.00 -$21,706.00 $0.00 121 PERA Contributions $7,710.00 $7,684.37 $7,825.00 $8,175.73 $7,845.00 $6,664.38 $8,055.00 122 FICA Contributions $5,405.00 $6,040.32 $5,845.00 $6,323.45 $5,885.00 $4,908.88 $6,030.00 123 Deferred Comp-Employer $260.00 $261.00 $260.00 $261.40 $390.00 $345.93 $595.00 125 Medicare Contributions $1,265.00 $1,412.50 $1,365.00 $1,478.97 $1,375.00 $1,148.21 $1,410.00 130 H S A-Employer Contribution $3,645.00 $3,122.63 $3,600.00 $2,347.47 $3,490.00 $4,180.93 $6,310.00 131 Health Insurance $19,385.00 $15,967.04 $19,145.00 $15,509.29 $19,190.00 $16,792.47 $22,320.00 132 Dental Insurance $3,490.00 $2,729.40 $2,110.00 $1,788.30 $1,855.00 $1,507.76 $1,830.00 133 Life Insurance $265.00 $182.91 $125.00 $119.32 $120.00 $108.18 $120.00 134 Disabilty Insurance $710.00 $712.70 $715.00 $869.82 $855.00 $813.36 $870.00 City of St. Joseph 11/02/18 11:07 AM Page 3 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OBJ OW Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget 151 Workers Comp. Insur. Prem. $3,360.00 $3,841.17 $4,235.00 $3,112.14 $3,055.00 $3,354.17 $3,345.00 171 Clothing Allowance $570.00 $659.75 $570.00 $628.62 $650.00 $529.96 $650.00 200 Office Supplies $150.00 $0.00 $150.00 $50.90 $150.00 $0.00 $150.00 210 Operating Supplies $1,750.00 $2,793.92 $1,750.00 $2,997.70 $1,750.00 $4,970.33 $2,500.00 212 Safety Program $1,250.00 $1,181.54 $1,250.00 $1,086.43 $1,250.00 $613.06 $1,500.00 215 Software Support $25.00 $24.37 $25.00 $24.37 $25.00 $24.37 $25.00 220 Repair and Maintenance $2,000.00 $6,581.94 $7,000.00 $10,004.59 $10,000.00 $8,430.20 $15,000.00 230 Vehicle Repair&Maintenance $1,500.00 $1,180.38 $1,500.00 $1,727.42 $1,500.00 $2,728.30 $1,500.00 235 Motor Fuel $9,000.00 $5,656.50 $9,000.00 $5,997.73 $9,000.00 $6,788.42 $9,000.00 240 Small Tool&Minor Equipment $200.00 $299.76 $200.00 $522.09 $300.00 $273.95 $300.00 300 Professional Services $500.00 $789.65 $13,850.00 $10,018.00 $500.00 $3,907.50 $8,165.00 303 Engineering Fee $30,000.00 $1,236.00 $30,000.00 $190.80 $30,000.00 $252.60 $500.00 317 Other fees $0.00 $3.16 $0.00 $0.00 $0.00 $0.00 $250.00 319 Gopher State Notification $1,200.00 $689.85 $1,200.00 $664.95 $1,200.00 $376.54 $1,200.00 322 Postage $100.00 $327.13 $100.00 $82.68 $100.00 $25.15 $100.00 331 Travel&Conference Expense $600.00 $219.34 $1,200.00 $668.07 $1,200.00 $1,346.51 $1,200.00 361 General Liability Insurance $12,390.00 $11,925.96 $12,000.00 $11,689.97 $12,500.00 $11,324.74 $11,805.00 433 Dues&Memberships $605.00 $448.50 $820.00 $454.75 $605.00 $689.00 $1,375.00 437 Real Estate Taxes $875.00 $858.00 $875.00 $894.00 $875.00 $690.00 $875.00 442 Water Permit $2,000.00 $1,307.18 $2,000.00 $1,644.86 $2,000.00 $0.00 $2,000.00 444 Annual Water Connection Fee $11,000.00 $10,839.67 $11,000.00 $10,909.00 $11,000.00 $8,290.00 $11,000.00 446 License $300.00 $121.50 $300.00 $55.06 $300.00 $74.50 $300.00 520 Buildings&Structures $0.00 $0.00 $0.00 $0.00 $20,000.00 $0.00 $20,000.00 530 Improvements Other than Bldgs $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 550 Motor Vehicles $2,750.00 $0.00 $2,000.00 $0.00 $3,000.00 $7,750.00 $3,500.00 580 Other Equipment $0.00 $0.00 $0.00 $0.00 $500.00 $0.00 $1,465.00 DEPART 49440 Water Maintenance $232,210.00 $188,115.32 $251,585.00 $207,489.08 $262,325.00 $192,156.95 $252,640.00 DEPART 49490 Administration and General 101 Salaries $14,975.00 $15,103.72 $14,930.00 $15,301.53 $12,075.00 $14,069.93 $11,705.00 111 OPEB Liability $425.00 $231.56 $425.00 -$3,558.53 $425.00 $3,558.53 $0.00 121 PERA Contributions $1,075.00 $1,076.38 $1,070.00 $1,099.10 $865.00 $1,055.33 $880.00 122 FICA Contributions $780.00 $822.86 $730.00 $810.12 $590.00 $721.06 $645.00 125 Medicare Contributions $180.00 $192.49 $170.00 $189.44 $140.00 $168.74 $150.00 130 H S A-Employer Contribution $565.00 $562.50 $565.00 $562.50 $450.00 $886.86 $980.00 131 Health Insurance $2,990.00 $2,991.36 $2,990.00 $2,991.36 $2,475.00 $3,107.50 $2,880.00 132 Dental Insurance $540.00 $428.99 $330.00 $228.90 $240.00 $203.40 $235.00 133 Life Insurance $40.00 $29.89 $20.00 $18.96 $15.00 $15.80 $15.00 134 Disabilty Insurance $105.00 $106.50 $105.00 $126.13 $95.00 $106.60 $100.00 City of St. Joseph 11/02/18 11:07 AM Page 4 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OW OBJ Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget 151 Workers Comp.Insur. Prem. $75.00 $101.26 $95.00 $32.51 $55.00 $61.60 $25.00 200 Office Supplies $700.00 $437.85 $700.00 $688.08 $700.00 $494.79 $700.00 210 Operating Supplies $1,200.00 $501.42 $1,200.00 $576.29 $1,200.00 $570.09 $1,200.00 215 Software Support $3,240.00 $4,436.54 $3,575.00 $4,550.44 $3,575.00 $5,883.73 $5,520.00 220 Repair and Maintenance $150.00 $0.00 $150.00 $0.00 $0.00 $0.00 $0.00 300 Professional Services $250.00 $0.00 $250.00 $0.00 $250.00 $0.00 $2,250.00 317 Other fees $150.00 $140.00 $150.00 $176.00 $150.00 $100.00 $150.00 321 Telephone $870.00 $1,348.05 $915.00 $1,523.13 $915.00 $1,061.83 $740.00 322 Postage $1,900.00 $1,261.21 $1,900.00 $1,612.15 $1,900.00 $1,339.75 $1,900.00 331 Travel&Conference Expense $100.00 $0.00 $100.00 $0.00 $100.00 $20.95 $80.00 340 Advertising $25.00 $0.00 $25.00 $0.00 $25.00 $0.00 $25.00 410 Rentals $1,105.00 $828.13 $1,105.00 $1,380.24 $1,105.00 $552.10 $1,105.00 441 Sales&Use Tax $0.00 $9.50 $0.00 $0.00 $0.00 $0.00 $0.00 580 Other Equipment $1,250.00 $0.00 $500.00 $0.00 $500.00 $0.00 $500.00 582 Computer Software $4,500.00 $0.00 $60.00 $0.00 $60.00 $0.00 $0.00 DEPART 49490 Administration and Gener $37,190.00 $30,610.21 $32,060.00 $28,308.35 $27,905.00 $33,978.59 $31,785.00 DEPART 49970 Depreciation Expense 420 Depreciation $400,000.00 $412,264.61 $400,000.00 $417,011.62 $400,000.00 $0.00 $400,000.00 DEPART 49970 Depredation Expense $400,000.00 $412,264.61 $400,000.00 $417,011.62 $400,000.00 $0.00 $400,000.00 FUND 601 Water Fund $1,574,420.00 $1,011,852.63 $1,808,355.00 $968,962.76 $1,612,550.00 $1,219,775.67 $1,571,300.00 FUND 602 Sewer Fund DEPART 47100 Bond Payment(P&I) 600 Debt Service-Principal $165,000.00 $0.00 $180,000.00 $0.00 $180,000.00 $180,000.00 $190,000.00 611 Bond Interest $57,670.00 $155,153.00 $54,020.00 $150,853.50 $50,060.00 $7,436.00 $45,720.00 620 Agent Fees $300.00 $272.61 $300.00 $434.70 $300.00 $0.00 $450.00 DEPART 47100 Bond Payment(P&I) $222,970.00 $155,425.61 $234,320.00 $151,288.20 $230,360.00 $187,436.00 $236,170.00 DEPART 49300 Other Financing Uses 710 Loss on Disposal of Assets $0.00 $0.00 $0.00 $208.27 $0.00 $0.00 $0.00 720 Transfers to Other Funds $45,935.00 $43,435.00 $37,540.00 $44,540.00 $7,500.00 $500.00 $19,570.00 DEPART 49300 Other Financing Uses $45,935.00 $43,435.00 $37,540.00 $44,748.27 $7,500.00 $500.00 $19,570.00 DEPART 49450 Sanitary Sewer Maintenance 101 Salaries $106,275.00 $82,542.93 $107,305.00 $96,858.47 $101,640.00 $48,375.50 $102,165.00 111 OPEB Liability $2,400.00 $1,312.18 $2,400.00 -$20,576.58 $2,400.00 $20,576.58 $0.00 112 Pension Expense $0.00 -$7,445.00 $0.00 $17,662.00 $0.00 -$17,662.00 $0.00 121 PERA Contributions $7,825.00 $6,057.59 $7,895.00 $7,127.09 $7,475.00 $3,628.19 $7,665.00 122 FICA Contributions $5,545.00 $4,745.30 $5,780.00 $5,516.59 $5,615.00 $2,619.14 $5,715.00 City of St. Joseph 11/02/18 11:07 AM Page 5 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OW OBJ Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget 123 Deferred Comp-Employer $260.00 $261.00 $260.00 $261.40 $390.00 $242.96 $395.00 125 Medicare Contributions $1,295.00 $1,109.80 $1,375.00 $715.82 $1,315.00 $1,187.07 $1,335.00 130 H S A-Employer Contribution $3,670.00 $1,988.21 $3,600.00 $2,035.35 $3,265.00 $3,014.21 $5,795.00 131 Health Insurance $19,505.00 $11,297.78 $19,145.00 $11,251.81 $17,950.00 $9,750.93 $20,880.00 132 Dental Insurance $3,510.00 $1,816.09 $2,045.00 $1,245.32 $1,740.00 $841.31 $1,710.00 133 Life Insurance $270.00 $153.31 $120.00 $94.78 $110.00 $68.54 $110.00 134 DisabiltyInsurance $720.00 $598.45 $725.00 $698.33 $815.00 $556.75 $830.00 151 Workers Comp. Insur. Prem. $3,675.00 $3,051.58 $4,610.00 $2,476.52 $3,215.00 $4,314.60 $3,515.00 171 Clothing Allowance $540.00 $610.16 $540.00 $601.67 $580.00 $488.54 $580.00 210 Operating Supplies $1,600.00 $1,302.73 $1,600.00 $1,494.69 $1,600.00 $997.88 $1,600.00 215 Software Support $25.00 $24.37 $25.00 $24.37 $25.00 $24.37 $25.00 220 Repair and Maintenance $8,000.00 $1,391.86 $8,000.00 $15,933.88 $8,000.00 $6,135.92 $10,000.00 230 Vehicle Repair&Maintenance $4,000.00 $2,472.93 $7,000.00 $10,825.26 $7,000.00 $5,228.82 $7,000.00 235 Motor Fuel $8,000.00 $3,963.73 $8,000.00 $4,642.66 $5,500.00 $5,610.40 $5,500.00 240 Small Tool&Minor Equipment $200.00 $0.00 $200.00 $522.09 $500.00 $125.00 $500.00 300 Professional Services $7,000.00 $15,682.81 $7,000.00 $562.20 $10,000.00 $7,433.56 $11,665.00 303 Engineering Fee $500.00 $0.00 $500.00 $34.80 $500.00 $121.80 $500.00 331 Travel&Conference Expense $600.00 $30.21 $1,000.00 $0.00 $600.00 $4.50 $600.00 361 General Liability Insurance $10,120.00 $10,232.39 $10,400.00 $10,097.57 $10,500.00 $8,396.12 $8,875.00 433 Dues&Memberships $75.00 $471.50 $65.00 $454.75 $410.00 $237.00 $1,175.00 446 License $200.00 $109.50 $200.00 $9.06 $200.00 $67.50 $200.00 520 Buildings&Structures $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 530 Improvements Other than Bldgs $0.00 $0.00 $0.00 $1,351.50 $15,000.00 $0.00 $15,000.00 550 Motor Vehicles $2,750.00 $0.00 $2,000.00 $0.00 $3,000.00 $7,856.95 $3,500.00 580 Other Equipment $0.00 $0.00 $13,000.00 $0.00 $500.00 $0.00 $1,465.00 DEPART 49450 Sanitary Sewer Maintenan $198,560.00 $143,781.41 $214,790.00 $171,921.40 $209,845.00 $120,242.14 $218,300.00 DEPART 49470 Lift Station-Baker Street 220 Repair and Maintenance $1,200.00 $127.27 $1,200.00 $1,922.28 $1,200.00 $1,046.39 $1,200.00 300 Professional Services $50.00 $51.45 $50.00 $60.00 $50.00 $100.00 $50.00 321 Telephone $0.00 $579.47 $0.00 $586.91 $0.00 -$7.61 $0.00 361 General Liability Insurance $115.00 $107.00 $110.00 $78.00 $100.00 $108.00 $110.00 381 Electric Utilities $2,220.00 $2,101.66 $2,030.00 $2,334.80 $2,215.00 $1,832.29 $2,530.00 530 Improvements Other than Bldgs $2,300.00 $0.00 $89,000.00 $0.00 $2,300.00 $0.00 $2,300.00 DEPART 49470 Lift Station-Baker Street $5,885.00 $2,966.85 $92,390.00 $4,981.99 $5,865.00 $3,079.07 $6,190.00 DEPART 49471 Lift Station-Ridgewood/DBL 220 Repair and Maintenance $1,200.00 $9,267.30 $1,200.00 $84.57 $1,200.00 $222.29 $1,200.00 300 Professional Services $225.00 $220.35 $225.00 $100.00 $225.00 $60.00 $225.00 321 Telephone $0.00 $579.46 $0.00 $586.91 $0.00 $13.45 $0.00 City of St. Joseph 11/02/18 11:07 AM Page 6 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OW OBJ Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget 361 General Liability Insurance $60.00 $55.00 $60.00 $47.00 $60.00 $54.00 $55.00 381 Electric Utilities $785.00 $772.76 $775.00 $703.30 $680.00 $623.50 $730.00 383 Gas Utilities $710.00 $542.98 $550.00 $455.37 $530.00 $347.76 $545.00 530 Improvements Other than Bldgs $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 DEPART 49471 Lift Station-Ridgewood/D $2,980.00 $11,437.85 $2,810.00 $1,977.15 $2,695.00 $1,321.00 $2,755.00 DEPART 49472 Lift Station-Northland 220 Repair and Maintenance $1,200.00 $72.81 $1,200.00 $17.48 $1,200.00 $0.00 $1,200.00 321 Telephone $0.00 $579.47 $0.00 $600.91 $0.00 -$8.74 $0.00 361 General Liability Insurance $65.00 $62.00 $65.00 $118.00 $120.00 $63.00 $65.00 381 Electric Utilities $800.00 $885.85 $860.00 $904.28 $1,045.00 $746.37 $1,100.00 530 Improvements Other than Bldgs $2,300.00 $0.00 $2,300.00 $0.00 $2,300.00 $0.00 $2,300.00 DEPART 49472 Lift Station-Northland $4,365.00 $1,600.13 $4,425.00 $1,640.67 $4,665.00 $800.63 $4,665.00 DEPART 49473 Lift Station-CR 121 220 Repair and Maintenance $1,200.00 $171.13 $1,200.00 $408.85 $1,200.00 $56.90 $11,200.00 321 Telephone $0.00 $603.46 $0.00 $610.91 $0.00 -$5.42 $0.00 361 General Liability Insurance $120.00 $112.00 $115.00 $0.00 $60.00 $146.00 $150.00 381 Electric Utilities $1,090.00 $1,344.86 $1,135.00 $1,383.62 $1,880.00 $1,132.19 $1,750.00 530 Improvements Other than Bldgs $2,200.00 $0.00 $2,200.00 $0.00 $2,200.00 $42,148.00 $2,200.00 DEPART 49473 Lift Station-CR 121 $4,610.00 $2,231.45 $4,650.00 $2,403.38 $5,340.00 $43,477.67 $15,300.00 DEPART 49480 Lift Station-Main 210 Operating Supplies $22,000.00 $21,225.45 $20,000.00 $24,932.81 $22,000.00 $24,634.06 $25,000.00 220 Repair and Maintenance $6,000.00 $3,613.98 $8,000.00 $2,592.69 $6,000.00 $2,320.79 $6,000.00 240 Small Tool&Minor Equipment $800.00 $0.00 $800.00 $0.00 $400.00 $0.00 $400.00 300 Professional Services $1,500.00 $1,605.35 $1,500.00 $1,800.00 $1,500.00 $1,788.00 $1,500.00 303 Engineering Fee $500.00 $2,084.32 $500.00 $1,795.08 $500.00 $0.00 $500.00 312 Tests $5,500.00 $6,263.00 $5,500.00 $7,585.50 $5,500.00 $4,608.00 $7,500.00 321 Telephone $0.00 $0.00 $0.00 $355.33 $0.00 $2,400.00 $2,880.00 322 Postage $550.00 $608.43 $550.00 $778.93 $550.00 $516.71 $550.00 361 General Liability Insurance $340.00 $318.00 $320.00 $312.00 $320.00 $385.00 $395.00 381 Electric Utilities $5,975.00 $6,337.35 $5,920.00 $7,321.14 $6,720.00 $5,367.63 $6,145.00 383 Gas Utilities $1,245.00 $624.50 $605.00 $647.01 $665.00 $510.45 $915.00 418 St.Cloud Debt Service $460,430.00 $0.00 $501,905.00 $0.00 $544,275.00 $378,208.44 $608,670.00 419 Sewer Use Rental $315,050.00 $197,039.12 $205,000.00 $220,527.90 $205,000.00 $172,009.01 $205,000.00 530 Improvements Other than Bldgs $0.00 $0.00 $0.00 $4,800.00 $0.00 $0.00 $0.00 580 Other Equipment $42,500.00 $0.00 $20,500.00 $0.00 $20,500.00 $0.00 $7,400.00 DEPART 49480 Lift Station-Main $862,390.00 $239,719.50 $771,100.00 $273,448.39 $813,930.00 $592,748.09 $872,855.00 DEPART 49490 Administration and General City of St. Joseph 11/02/18 11:07 AM Page 7 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OBJ OBJ Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget 101 Salaries $14,975.00 $15,103.73 $14,930.00 $7,717.86 $12,075.00 $17,545.04 $11,705.00 111 OPEB Liability $425.00 $231.56 $425.00 -$3,631.16 $425.00 $3,631.16 $0.00 121 PERA Contributions $1,075.00 $1,076.38 $1,070.00 $530.33 $865.00 $1,315.95 $880.00 122 FICA Contributions $780.00 $822.86 $730.00 $342.29 $590.00 $958.07 $645.00 125 Medicare Contributions $180.00 $192.50 $170.00 $654.42 $140.00 -$350.23 $150.00 130 H S A-Employer Contribution $565.00 $562.50 $565.00 $562.50 $450.00 $886.86 $980.00 131 Health Insurance $2,990.00 $2,991.36 $2,990.00 $2,991.36 $2,475.00 $2,612.50 $2,880.00 132 Dental Insurance $540.00 $428.99 $330.00 $228.90 $240.00 $171.00 $235.00 133 Life Insurance $40.00 $29.89 $20.00 $18.96 $15.00 $15.80 $15.00 134 Disabilty Insurance $105.00 $106.50 $105.00 $126.13 $95.00 $106.60 $100.00 151 Workers Comp.Insur. Prem. $75.00 $101.26 $95.00 $32.51 $55.00 $61.60 $25.00 200 Office Supplies $700.00 $437.86 $700.00 $688.07 $700.00 $494.79 $700.00 210 Operating Supplies $1,500.00 $501.41 $1,500.00 $622.71 $1,500.00 $570.09 $1,500.00 212 Safety Program $1,250.00 $1,266.01 $1,250.00 $1,238.97 $1,250.00 $1,867.70 $1,500.00 215 Software Support $2,945.00 $4,141.54 $3,280.00 $4,255.45 $3,280.00 $5,588.71 $4,830.00 220 Repair and Maintenance $100.00 $0.00 $100.00 $0.00 $0.00 $0.00 $0.00 300 Professional Services $250.00 $0.00 $250.00 $0.00 $250.00 $0.00 $2,250.00 303 Engineering Fee $2,000.00 $101.40 $2,000.00 $0.00 $2,000.00 $0.00 $2,000.00 319 Gopher State Notification $1,200.00 $689.85 $1,200.00 $664.90 $1,200.00 $376.51 $1,200.00 321 Telephone $1,215.00 $1,083.91 $1,285.00 $1,120.20 $1,265.00 $796.36 $1,100.00 322 Postage $1,900.00 $1,463.80 $1,900.00 $1,596.50 $1,900.00 $1,339.76 $1,900.00 331 Travel&Conference Expense $100.00 $0.00 $100.00 $230.00 $100.00 $20.94 $80.00 340 Advertising $25.00 $0.00 $25.00 $0.00 $25.00 $0.00 $25.00 410 Rentals $1,105.00 $828.12 $1,105.00 $1,380.21 $1,105.00 $552.08 $1,105.00 581 Computer Hardware $0.00 $0.00 $60.00 $0.00 $60.00 $0.00 $0.00 582 Computer Software $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 DEPART 49490 Administration and Gener $36,040.00 $32,161.43 $36,185.00 $21,371.11 $32,060.00 $38,561.29 $35,805.00 DEPART 49970 Depreciation Expense 420 Depreciation $375,000.00 $452,913.52 $450,000.00 $481,405.69 $500,000.00 $0.00 $500,000.00 DEPART 49970 Depreciation Expense $375,000.00 $452,913.52 $450,000.00 $481,405.69 $500,000.00 $0.00 $500,000.00 FUND 602 Sewer Fund $1,758,735.00 $1,085,672.75 $1,848,210.00 $1,155,186.25 $1,812,260.00 $988,165.89 $1,911,610.00 FUND 603 Refuse Collection DEPART 43230 Waste Collection 101 Salaries $20,560.00 $17,947.48 $21,665.00 $18,586.23 $17,985.00 $12,361.23 $17,800.00 111 OPEB Liability $425.00 $231.56 $425.00 -$3,631.17 $425.00 $3,631.17 $0.00 112 Pension Expense $0.00 -$2,746.00 $0.00 -$1,884.00 $0.00 $1,884.00 $0.00 121 PERA Contributions $1,495.00 $1,286.37 $1,500.00 $1,338.78 $1,310.00 $920.05 $1,335.00 City of St. Joseph 11/02/18 11:07 AM Page 8 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OBJ OBJ Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget 122 FICA Contributions $1,065.00 $953.62 $1,045.00 $1,016.98 $920.00 $620.97 $985.00 125 Medicare Contributions $250.00 $229.61 $245.00 $231.27 $215.00 $145.39 $230.00 130 H S A-Employer Contribution $790.00 $684.35 $790.00 $797.96 $675.00 $890.77 $1,205.00 131 Health Insurance $4,190.00 $3,410.39 $4,190.00 $3,491.74 $3,715.00 $2,981.87 $4,320.00 132 Dental Insurance $755.00 $481.03 $465.00 $281.86 $360.00 $200.84 $355.00 133 Life Insurance $60.00 $34.54 $30.00 $23.74 $25.00 $17.75 $25.00 134 Disabilty Insurance $145.00 $124.02 $145.00 $157.56 $145.00 $118.19 $145.00 151 Workers Comp.Insur.Prem. $425.00 $262.68 $570.00 $170.75 $435.00 $481.34 $445.00 171 Clothing Allowance $0.00 $36.96 $0.00 $37.17 $0.00 $26.74 $0.00 200 Office Supplies $600.00 $437.86 $600.00 $688.06 $600.00 $494.78 $600.00 210 Operating Supplies $450.00 $489.17 $500.00 $504.53 $500.00 $579.46 $505.00 215 Software Support $2,350.00 $3,619.22 $2,685.00 $3,672.48 $2,685.00 $4,906.88 $3,835.00 300 Professional Services $14,250.00 $14,330.00 $14,375.00 $14,722.00 $14,375.00 $21,965.00 $23,385.00 302 Maintenance Reimbursement $2,140.00 $2,140.00 $2,225.00 $2,225.00 $2,225.00 $2,225.00 $3,135.00 304 Legal Fees $0.00 $0.00 $0.00 $256.67 $0.00 $26.25 $0.00 321 Telephone $495.00 $502.88 $515.00 $577.98 $505.00 $355.93 $500.00 322 Postage $1,930.00 $1,481.15 $1,930.00 $1,596.50 $1,930.00 $1,339.77 $1,930.00 331 Travel&Conference Expense $100.00 $0.00 $100.00 $0.00 $0.00 $20.94 $0.00 340 Advertising $50.00 $0.00 $50.00 $199.20 $50.00 $0.00 $50.00 384 Refuse Disposal $223,625.00 $228,897.63 $234,765.00 $236,509.89 $234,765.00 $182,391.83 $258,015.00 410 Rentals $1,105.00 $828.14 $1,105.00 $1,380.21 $1,105.00 $552.08 $1,190.00 580 Other Equipment $1,000.00 $0.00 $1,000.00 $0.00 $1,000.00 $0.00 $2,000.00 581 Computer Hardware $0.00 $0.00 $60.00 $0.00 $60.00 $0.00 $0.00 DEPART 43230 Waste Collection $278,255.00 $275,662.66 $290,980.00 $282,951.39 $286,010.00 $239,138.23 $321,990.00 DEPART 49300 Other Financing Uses 720 Transfers to Other Funds $1,435.00 $715.00 $770.00 $770.00 $500.00 $500.00 $1,600.00 DEPART 49300 Other Financing Uses $1,435.00 $715.00 $770.00 $770.00 $500.00 $500.00 $1,600.00 DEPART 49970 Depreciation Expense 420 Depreciation $6,500.00 $6,606.24 $6,675.00 $6,606.24 $6,675.00 $0.00 $6,675.00 DEPART 49970 Depreciation Expense $6,500.00 $6,606.24 $6,675.00 $6,606.24 $6,675.00 $0.00 $6,675.00 FUND 603 Refuse Collection $286,190.00 $282,983.90 $298,425.00 $290,327.63 $293,185.00 $239,638.23 $330,265.00 FUND 651 Storm Water Utility DEPART 49300 Other Financing Uses 710 Loss on Disposal of Assets $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 720 Transfers to Other Funds $18,965.00 $18,250.00 $19,250.00 $19,250.00 $19,250.00 $0.00 $24,230.00 DEPART 49300 Other Financing Uses $18,965.00 $18,250.00 $19,250.00 $19,250.00 $19,250.00 $0.00 $24,230.00 City of St. Joseph 11/02/18 11:07 AM Page 9 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OW OW Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget DEPART 49490 Administration and General 101 Salaries $8,985.00 $9,110.23 $8,960.00 $9,067.45 $7,245.00 $6,140.35 $7,025.00 111 OPEB Liability $140.00 $77.19 $140.00 -$1,198.28 $140.00 $1,198.28 $0.00 121 PERA Contributions $645.00 $648.90 $645.00 $650.43 $520.00 $460.22 $525.00 122 FICA Contributions $465.00 $496.64 $435.00 $480.53 $355.00 $303.01 $385.00 125 Medicare Contributions $110.00 $115.98 $105.00 $112.32 $85.00 $70.66 $90.00 130 H S A-Employer Contribution $340.00 $337.50 $340.00 $337.50 $270.00 $532.12 $590.00 131 Health Insurance $1,795.00 $1,794.72 $1,795.00 $1,794.72 $1,485.00 $1,567.50 $1,730.00 132 Dental Insurance $325.00 $257.32 $200.00 $137.30 $145.00 $102.60 $145.00 133 Life Insurance $25.00 $17.84 $15.00 $11.51 $10.00 $9.60 $10.00 134 Disabilty Insurance $65.00 $63.68 $65.00 $75.70 $60.00 $64.00 $60.00 151 Workers Comp.Insur.Prem. $45.00 $33.76 $55.00 $13.50 $35.00 $36.97 $15.00 200 Office Supplies $200.00 $25.99 $200.00 $251.69 $200.00 $195.85 $200.00 215 Software Support $2,945.00 $3,876.55 $3,280.00 $3,990.43 $3,280.00 $5,323.64 $4,830.00 220 Repair and Maintenance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 300 Professional Services $225.00 $0.00 $225.00 $0.00 $225.00 $0.00 $225.00 331 Travel&Conference Expense $60.00 $0.00 $60.00 $0.00 $50.00 $20.94 $50.00 582 Computer Software $0.00 $0.00 $60.00 $0.00 $60.00 $0.00 $0.00 DEPART 49490 Administration and Gener $16,370.00 $16,856.30 $16,580.00 $15,724.80 $14,165.00 $16,025.74 $15,880.00 DEPART 49900 Storm Water Maintenance 101 Salaries $28,425.00 $26,324.74 $25,680.00 $25,730.94 $26,460.00 $25,032.83 $26,755.00 111 OPEB Liability $275.00 $154.37 $275.00 -$2,432.88 $275.00 $2,432.88 $0.00 112 Pension Expense $0.00 $810.00 $0.00 -$6,007.00 $0.00 $6,007.00 $0.00 121 PERA Contributions $2,100.00 $1,974.39 $1,905.00 $1,930.17 $1,965.00 $1,878.01 $2,005.00 122 FICA Contributions $1,525.00 $1,573.21 $1,475.00 $1,548.94 $1,525.00 $1,438.59 $1,560.00 123 Deferred Comp-Employer $260.00 $261.00 $260.00 $261.40 $390.00 $208.60 $260.00 125 Medicare Contributions $355.00 $368.15 $345.00 $361.92 $355.00 $336.24 $365.00 130 H S A-Employer Contribution $790.00 $83.55 $675.00 $13.73 $675.00 $486.88 $985.00 131 Health Insurance $4,190.00 $1,325.46 $3,590.00 $850.82 $3,715.00 $2,514.99 $4,320.00 132 Dental Insurance $755.00 $559.84 $400.00 $329.08 $360.00 $319.76 $355.00 133 Life Insurance $60.00 $39.03 $25.00 $27.26 $25.00 $28.97 $25.00 134 Disabilty Insurance $170.00 $177.51 $145.00 $233.88 $220.00 $247.02 $225.00 151 Workers Comp.Insur.Prem. $985.00 $268.50 $2,005.00 $183.53 $835.00 $132.59 $910.00 171 Clothing Allowance $105.00 $40.84 $90.00 $64.21 $105.00 $62.78 $105.00 215 Software Support $1,025.00 $509.37 $1,025.00 $24.37 $1,025.00 $24.37 $3,025.00 220 Repair and Maintenance $7,000.00 $1,322.93 $7,000.00 $3,041.71 $15,000.00 $4,072.36 $7,000.00 300 Professional Services $0.00 $0.00 $31,000.00 $400.00 $23,000.00 $1,000.00 $28,335.00 302 Maintenance Reimbursement $14,000.00 $14,000.00 $14,000.00 $14,000.00 $14,000.00 $14,000.00 $14,000.00 City of St. Joseph 11/02/18 11:07 AM Page 10 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OBJ OBJ Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget 303 Engineering Fee $1,500.00 $7,023.94 $1,500.00 $6,280.80 $1,500.00 $11,399.60 $2,000.00 304 Legal Fees $0.00 $0.00 $0.00 $0.00 $0.00 $148.75 $0.00 308 Community Programs $1,625.00 $1,606.00 $1,625.00 $1,609.00 $1,610.00 $2,650.00 $1,650.00 321 Telephone $240.00 $0.00 $240.00 $0.00 $240.00 $0.00 $240.00 331 Travel&Conference Expense $100.00 $0.00 $100.00 $0.00 $100.00 $90.00 $100.00 340 Advertising $50.00 $144.31 $50.00 $0.00 $50.00 $0.00 $50.00 510 Land and Land Improvements $1,000.00 $0.00 $1,000.00 $0.00 $1,000.00 $0.00 $1,000.00 530 Improvements Other than Bldgs $2,500.00 $0.00 $3,500.00 $0.00 $2,500.00 $0.00 $26,500.00 580 Other Equipment $10,000.00 $0.00 $12,000.00 $0.00 $11,000.00 $0.00 $11,000.00 DEPART 49900 Storm Water Maintenance $79,035.00 $58,567.14 $109,910.00 $48,451.88 $107,930.00 $74,512.22 $132,770.00 DEPART 49970 Depreciation Expense 420 Depreciation $100,000.00 $102,763.68 $115,000.00 $105,212.11 $115,000.00 $0.00 $115,000.00 DEPART 49970 Depreciation Expense $100,000.00 $102,763.68 $115,000.00 $105,212.11 $115,000.00 $0.00 $115,000.00 FUND 651 Storm Water Utility $214,370.00 $196,437.12 $260,740.00 $188,638.79 $256,345.00 $90,537.96 $287,880.00 FUND 652 Street Light Utility DEPART 43160 Street Lighting 101 Salaries $5,990.00 $6,200.10 $9,500.00 $6,023.08 $8,460.00 $4,093.53 $8,265.00 112 Pension Expense $0.00 $4,713.00 $0.00 $74.00 $0.00 -$74.00 $0.00 121 PERA Contributions $430.00 $442.45 $685.00 $432.29 $610.00 $307.05 $620.00 122 FICA Contributions $310.00 $337.57 $470.00 $318.62 $420.00 $201.96 $455.00 125 Medicare Contributions $75.00 $78.96 $110.00 $74.56 $100.00 $47.16 $105.00 130 H S A-Employer Contribution $225.00 $250.44 $340.00 $225.00 $295.00 $354.74 $660.00 131 Health Insurance $1,200.00 $1,236.71 $1,800.00 $1,208.04 $1,610.00 $1,045.00 $1,875.00 132 Dental Insurance $215.00 $176.72 $200.00 $92.42 $155.00 $68.40 $155.00 133 Life Insurance $15.00 $12.48 $15.00 $7.57 $10.00 $6.30 $10.00 134 Disabilty Insurance $45.00 $44.85 $70.00 $50.41 $65.00 $42.60 $70.00 151 Workers Comp. Insur. Prem. $30.00 $31.08 $315.00 $243.06 $250.00 $273.34 $250.00 220 Repair and Maintenance $5,000.00 $910.31 $5,000.00 $10,996.22 $5,000.00 $5,880.40 $6,000.00 303 Engineering Fee $0.00 $0.00 $0.00 $0.00 $0.00 $87.00 $0.00 386 Street Lighting $50,015.00 $45,740.39 $45,425.00 $44,770.64 $55,000.00 $34,452.81 $47,175.00 387 Holiday Decorations $1,000.00 $3,152.59 $2,000.00 $352.07 $2,000.00 $9,700.00 $2,000.00 530 Improvements Other than Bldgs $5,000.00 $0.00 $6,000.00 $0.00 $7,000.00 $0.00 $14,600.00 DEPART 43160 Street Lighting $69,550.00 $63,327.65 $71,930.00 $64,867.98 $80,975.00 $56,486.29 $82,240.00 FUND 652 Street Light Utility $69,550.00 $63,327.65 $71,930.00 $64,867.98 $80,975.00 $56,486.29 $82,240.00 City of St. Joseph 11/02/18 11:07 AM Page 11 2019 Enterprise Expense Budget Preliminary As of November 5,2018 2016 2017 2017 2018 2018 2019 OBJ OBJ Descr Budget 2016 Amt Budget Amt Budget YTD Amt Budget $3,903,265.00 $2,640,274.05 $4,287,660.00 $2,667,983.41 $4,055,315.00 $2,594,604.04 $4,183,295.00