Loading...
HomeMy WebLinkAbout[04c] Financial ReportCouncil Agenda Item 4C MEETING DATE: April 17, 2014 AGENDA ITEM: Financial Report - 1st Quarter 2014 & March 2014 Financial Reports SUBMITTED BY: Finance BOARD /COMMISSION /COMMITTEE RECOMMENDATION: N/A PREVIOUS COUNCIL ACTION: Council accepted the January and February Financial Reports. BACKGROUND INFORMATION: Quarterly and monthly reconciled cash/investment and budget to actual position are provided for Council review. The numbers presented are the cash balances as of March 31, 2014. There are a couple points to highlight from the reports. CASH POSITION: - The market rate of return is approximately 1.44% with an average maturity of two years. On March 28"' the 10 -year Treasuries were 2.72 %, 2 -year Treasury is 0.46 %. The City tiers the maturity dates within the boundaries of the Investment Policy. The City has purchased some 5- year CDs in the past at 4 -5% interest rates. A few of these CDs are still owned by the City. The tiered maturity dates has helped the City maintain a higher rate of return than the current market. - Interest earnings for 2014 have rebounded in comparison to 2013. The City's policy is to hold investments until maturity. GASB 31 requires the City to mark investments at the current market value as of the close of each month. In doing this, earnings will show great fluctuations. Since the City holds investments until maturity, investment earnings over the life of a security will be healthy. The alternative would be for the City to invest in money market funds. The money market funds are earning interest similar to the Treasury rates and would equate to much lower returns than the securities we hold. - Overall, the cash and investments balance decreased $806,520 from the beginning of the year. FUNDS REPORT: - The General fund spent 27% of the 2014 budget and received 2% of the revenue budget. Expenditures are operational in nature. Significant revenues will be received in June /July with the first half state aids and property taxes are received. - The Enterprise Funds show expenses more than revenues. The reports show 3 months of expenses and 1.5 months utility revenue received. The negative revenue in the storm water fund is the result of reversing 2013 audit entries. The revenues will show positive as the year goes on. The amounts include debt interest payments and operational activity for the year. Water fund analysis (fund 601/501) — The enclosed spreadsheet shows an analysis of the water fund, including the Water fund (601) and the Water Access fund (WAC -501). The City has not received WAC funds in the first quarter of 2014. Construction has been slow with the harsh winter. Spring usually spurs development. In addition to new development, the City passed a resolution to require all residents be on city water service by 2016. As of July 2013, 24 homes were on well service. One home connected in 2013; two homes paid a WAC down payment with intention to connect in 2014; three homes prepaid WAC services, but need to connect; the remaining 18 homes will need to connect and pay a WAC charge when they do. The City invoiced Millstream Villages the remaining WAC /SAC bill that was deferred and now due for the 8 -plex units. The bill includes $18,000 WAC and $9,200 SAC. Y2 ¢ Sales Tax (fund 200): The sales tax fund has a balance of 51,229,287.41 at the end of March. The City anticipates collecting $3,000,000 in sales tax revenue through 2017; $2,165,818 was collected to date. Collections the past couple of years has been higher. The distribution formula is reviewed annually between the area cities. St. Joseph has gained a higher percentage of the distribution each year. Population and sales taxes paid increased St. Joseph's share of the distribution. Also, the economy is showing improvements where people are spending more. The anticipated expenditures total $2,163,591 leaving approximately $879,687 remaining for future projects. The balance includes transfers from the General and Recreational Center funds. CIP REPORTS: - The 2014 CIP summary is included to show the capital expenditures through March 31s`. Very little has been spent on capital purchases. The EDA funds the economic development program throughout the year. Public Works purchased a line tracer to accurately deduct utility lines with Gopher State One Call. BUDGET /FISCAL IMPACT: Information Only ATTACHMENTS: Request for Council Action — Quarterly and March Financial Reports 1 sr Quarter Reports: Cash Position as of 3/31/14 Cash and Investment Holdings Chart Cash Balances by Fund /Remaining Budget General & Fire Budget to Actual Expenditures & Revenues Enterprise Funds Activity Graph Quarterly Water Fund Analysis Half Cent Sales Tax Fund Summary March Treasurer's ReTorts: Cash and Investment — Council Report Council Month End Revenue Summary Council Month End Revenue — General Fund Council Month End Revenue — Enterprise Funds Council Month End Expenditure Summary Council Month End Expenditure — General Fund Council Month End Expenses - Enterprise Funds Capital Summary ReTorts: General Fund Capital Improvement Plan — Summary Fire Fund Capital Improvement Plan Park Board Capital Improvement Plan — Summary Capital Improvement Plan — Enterprise REQUESTED COUNCIL ACTION: Accept the financial reports as presented. City of St. Joseph, Minnesota Cash Position As of 3/31/14 Sentry Bank Maturity Date Interest Current Balance # Securities % of Total Checking Account (Reconciled) N/A 0.15% $ 141,129 N/A Money Market Savings N/A 0.50% 2,294,922 N/A Bank Certificates of Deposit 7 months 2.00% avg 250,000 1 averages 7 months 0.88% Total Sentry Bank $ 2,686,051 33% Central MN Credit Union Share Savings Account N/A 0.00% $ 35 N/A Money Market Savings N/A 0.75% 1,261,730 N/A Power Money Market Checking N/A 0.70% 333,225 N/A Jumbo Bank Certificates of Deposit 22-46 months 1.15% avg 810,708 2 averages 34 months 0.94% Total CMCU $ 2,405,698 30% Total Deposits $ 5,091,749 Morgan Stanley Smith Barney Brokered Money Market Savings N/A 0.01% $ 50,160 N/A Government Securities /Notes 76 -106 months 2.19% avg 959,806 2 Brokered Certificates of Deposit Tiered 5 -71 months 2.57% avg 1,988,673 15 averages 32 months 2.52% Total SB $ 2,998,639 37% Total Investments $ 2,998,639 Total Deposits and Investments $ 8,090,388 Average Interest APY 24 months 1.45% 2014 YTD Cash Held With Fiscal Agent - Northland Securities (2012A Crossover Refunding Bonds) Interest Earned Brokered Money Market Savings N/A 0.39% avg 4,682,985 $50,493 Total Cash Held With Fiscal Agent $ 4,682,985 Total Deposits, Investments & Cash w /Fiscal Agent $ 12,773,373 Cash and Investment Balance Petty Cash Administration N/A N/A $ 200 Police Department N/A N/A 75 Total Petty Cash $ 275 Custodial Credit Risk: All deposits and investments insured by FDIC /SPIC /NCUA or secured by perfected pledged collateral. Interest Rate Risk: The City is not exposed to interest rate risk because the City does not invest in highly sensitive, interest fluctuating investments. The City attempts to purchase longer termed investments when the interest rates are favorable and depending on cash flow needs to lock into a favorable rate. Credit Risk: There are no instruments exposed to credit risk. Maturity Concentration of Credit Risk: The City invests in various instruments and several financial institutions. % Securities Averages Brokered Money Markets $ 50,160 1% N/A Brokered Certificates of Deposit $ 1,988,673 24.58% 2.1 years Government Bonds /Notes $ 959,806 11.86% 7.6 years State /Local Government Securities $ 4,682,985 37% 9 months Foreign Currency Risk: The City only invests in USA and USA territories 959,806, 12% Cash and Investment Holdings 141.129.2% 1,060,708, 13% 3,889,912, 48% Checking Money Market Savings Bank CDs Brokered Money Market Government Securities Brokered CDs City of St. Joseph, Minnesota Cash Balances by Fund /Remaining Budget As of 3/31/14 FUND CASH BALANCE 14 EXP BUD 14 SPENT 14 LEFT 14 BUD REV 14 RECEIVED 14 LEFT General Fund $ 624,240 $ 2,332,540 $ 619,449 $ 1,713,091 $ 2,428,070 $ 39,370 $ 2,388,700 531,466 296,980 22,2 281,980 60, EDA Fund 96,170 130,595 99,887 $ 30,708 130,595 84,071 $ 46,524 - - 98 $ M M State Collected Sales Tax 1,229,287 - 42,636 $ (42,636) - (844) $ 844 50 4 $ 4,316 (4,316) $ _ - (22) Revolving Loan Fund 33,056 - - $ - 8,380 2,194 $ 6,186 47,019 Capital Project Funds 605,969 84,080 (10,624) $ 94,704 - 84,080 $ (84,080) 823 - 260 Sewer Access Fund 589,401 - - $ - - 3,346 $ (3,346) T%r Fun 77,247 �70 68,676 1� 58,393 $ - Sewer Fund 1,723,338 1,529,055 138,664 $ 1,390,391 1,322,920 31,878 $ 1,291,042 Refuse /Compost Fund 242,520 336,185 , 56,194 287,025 11,415 $ 275,610 Storm Sewer 214,998 257,865 15,599 $ 242,266 119,130 (16,277) $ 135,407 Street Light Utility 827 53,025 9,519 $ 53,025 2,371 $ 50,654 TOTALS $ 8,090,387 is 1,110,119 $ 390,224 12/31/13 Cash Balance $ 8,896,907 1.6 months of cash balance 2014 cash increase (806,520) $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 a General & Fire Budget to Actual Expenditures & Revenues General Fund Fire Fund 27% Spent 2% Received 8% Spent 21% Received • Exp Budget • Exp Actual 11 Rev Budget NI Rev Actua I $(40,000) $(20,000) $- $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 $160,000 Storm Water Refuse Sewer Water Street Lights % Revenue to Expenses -104% 20% 23% 85% 25% Utilities represents 1.5 months revenue collected with 3 months expended. City of St. Joseph Quarterly Water Fund Analysis As of March 31, 2014 Fund 601 +501, Water/WAC Fund Balance as of December 31, 2013 (audited) $ 88,093.51 Year to Date Revenue: Interest Earnings 9,535.45 WAC fees collected for: Water Usage Charge 29,609.12 None in 1st quarter Water Line Charge 13,913.72 Penalties /Other Usage Fees (2,665.79) WAC /Trunk Fees Antenna Lease Revenue 8,260.71 Bulk Water Sales - Transfers from other Funds Total Revenue 58,653.21 4.98% budget collected 2014 Revenue Budget 1,178,170.00 (includes fund 501) Year to Date Expenses by Department: Debt Payments 28,852.00 Transfers to Other Funds - Power and Pumping (2,152.90) Water Treatment Plant 1 (4,444.75) Water Treatment Plant 2 (14,973.43) Distribution (169.17) Wellhead Protection (382.30) Water Tower (13,316.66) Water Maintenance (53,250.03) Water Administration (8,838.35) Total Expenses (68,675.59) 6.34% budget expensed 2014 Expense Budget (1,082,770.00) (excludes depreciation) Fund Summary as of March 31, 2014: Water Fund Cash Balance - Fund 601 +501 - unaudited $ 78,071.13 Fund 501 $ 823.86 Fund 601 $ 77,247.27 " Amounts exclude activity recorded in the bond escrow fund The balances represent the cash balance as of 3131114. St. Joseph 1/2 Cent Sales Tax Committee Summary Treasurer's Report - Fund 200 As of March 31, 2014 Opening Fund 2006 2006 Interest Earnings 2,696.64 43,278.08 General Fund /Rec Center Fund Transfer 2006 Sales Tax Receipts Collected 190,471.22 2,165,817.51 Sales Tax Collected Balance as of December 31, 2006 (audited) 193,167.86 (983,090.65) Sales Tax Spent 2007 Interest Earnings 12,081.68 2007 Sales Tax Receipts Collected 237,927.00 3,000,000.00 Projected Sales Tax 2007 Transfer from the General Fund 24,003.73 (2,165,817.51) Sales Tax received Balance as of December 31, 2007 (audited) 467,180.27 834,182.49 Remaining Sales Tax through 2017 2008 Interest Earnings 21,468.30 2008 Sales Tax Receipts Collected 251,015.22 3,000,000.00 Projected Sales Tax 2008 Meeting Stipends (420.00) 43,278.08 General Fund /Rec Center Fund Transfer 2008 Parks and Recreation Survey (1,279.26) (983,090.65) Spent as of March 31, 2014 2008 Park and Trail System Plan (42,079.24) 2008 Parks Boundary Survey (8,272.75) (25,000.00) Est. Remaining CR2 /3 Trail, Phase I Balance as of December 31, 2008 (audited) 687,612.54 (840,000.00) Est. Remaining Government Center /Community Room 2009 Interest Earnings 33,184.40 (315,000.00) Est. Remaining CR2 Trail, Phase 11 2009 Sales Tax Receipts Collected 242,011.63 (500.00) Est. Remaining CR133 /College Ave Sidewalks 2009 Meeting Stipends (165.80) Balance as of December 31, 2009 (audited) 962,642.77 879,687.43 Remaining Unallocated Sales Tax through 2017 2010 Sales Tax Receipts Collected 270,108.80 2010 Interest Earnings 20,287.65 2010 Transfer Interest Earnings to Water Fund (86,436.20) Protects funded (includes estimated remaining): 2010 Centennial Park Swingset (33,284.14) Parks and Rec survey /system plan 43,358.50 Balance as of December 31, 2010 (audited) 1,133,318.88 Board Stipends 585.80 2011 Sales Tax Receipts Collected 299,571.59 Parks Boundary Survey 8,272.75 2011 CMCU Building Purchase (110,935.71) Centennial Park Swingset 33,284.14 2011 CR 2/3 trail extension (21,463.82) CR2 /3 Trail Extension Phase 1 435,959.31 2011 CR133 /College Ave trail extension (2,878.30) CR2 Trail Extension Phase 11 316,538.15 Balance as of December 31, 2011 (audited 1,297,612.64 CR2 Trail Extension Phase I 1,757.7° 2012 Sales Tax Receipts Collected 314,646.75 CR133 /College Ave Sidewalk Project 192,805.72 2012 CR 2/3 trail extension (330,603.68) Government Center /Community Room 1,117,142.35 2012 CR133 /College Ave trail extension (16,831.32) Wobegon Center Upgrades 13,886.18 Balance as of December 31, 2012 (audited) 1,264,824.39 2,163,590.65 2013 Sales Tax Receipts Collected 360,909.00 2013 Transfer from Rec Center Fund - Gov't Center 19,274.35 2013 CR 2/3 trail extension -Phase 1 (80,237.25) 2013 CR 2 Trail Extension - Phase 11 (1,538.15) 2013 CR2 Trail Extension - Phase 111 (566.10) 2013 Wobegon Center Upgrades (13,886.18) 2013 Government Center (104,427.23) 2013 CR133 /College Ave Sidewalk (171,585.40) Balance as of December 31, 2013 (audited) 1,272,767.43 2014 Sales Tax Receipts Collected (843.70) 2014 CR 2/3 trail extension -Phase 1 21,345.44 2014 CR2 Trail Extension - Phase 111 (1,191.65) 2014 CR133 /College Ave Sidewalks (1,010.70) 2014 Government Center (61,779.41) Balance as of March 14, 2014 (Unaudited) 1,229,287.41 CITY OF ST. JOSEPH Cash Balances Only Current Period: March 2014 MTD MTD Current FUND Descr Account Beqin Yr Debit Credit Balance Last Dim 10100 General G 101 -10100 $1,214,534.57 $16,726.72 $225,021.17 $615,932.49 Fire Fund G 105 -10100 $487,027.32 $2,318.29 $12,288.51 $531,466.35 Cable Access Fee G 108 -10100 $6,152.02 $720.76 $0.00 $8,307.54 Economic Development G 150 -10100 $116,317.66 $70,623.51 $78,808.52 $96,169.96 TIF 2 -1 Millstream G 157 -10100 $14,115.17 $16.30 $0.00 $14,215.83 TIF 2 -2 Meat Market G 158 -10100 $34.13 $0.05 $0.00 $36.58 State Collected Sales Tax G 200 -10100 $1,340,119.29 $2,156.30 $55,243.46 $1,229,287.41 Park Dedication G 205 -10100 $54,660.10 $78.18 $419.00 $58,153.70 Charitable Gambling G 215 -10100 $3,947.46 $4.55 $0.00 $3,970.87 Revolving Loan Fund G 250 -10100 $30,853.05 $709.92 $0.00 $33,055.52 2009A CrossoverRefunding Bo G 318 -10100 $378,931.21 $453.93 $0.00 $403,020.07 2007 Refunding (98/99 St Bon G 320 -10100 $90,198.50 $104.77 $0.00 $91,646.36 City Hall Refunded, 2005 G 322 -10100 $3,801.11 $4.72 $0.00 $4,274.64 2011A Refunding Fire Hall G 331 -10100 $96,884.08 $115.77 $0.00 $101,212.25 2010B Refundin (Hill /Clover) G 333 -10100 $279,471.00 $322.54 $0.00 $281,263.71 2011A CO Refund (Interior Sts G 338 -10100 $149,631.78 $170.06 $0.00 $141,747.53 2007 St Impry -E Side /3ade /8 A G 341 -10100 $451,442.33 $520.87 $0.00 $454,142.15 2009B GO CIP Bonds G 343 -10100 $5,161.41 $6.18 $0.00 $5,490.97 2010 Equipment Certificates G 344 -10100 $3,597.49 $4.24 $0.00 $3,735.20 2010B Street Impr (16th Ave) G 345 -10100 $215,136.47 $248.21 $0.00 $216,406.16 2011A Pumper Truck Certificat G 346 -10100 $1,559.67 $4.65 $0.00 $3,629.38 2011A GO CIP Bonds G 347 -10100 $12,286.67 $214.36 $0.00 $11,761.47 2013 Street Improve Bonds G 348 -10100 $85,292.99 $219.34 $0.00 $86,383.97 2013 Equipment Certificates G 349 -10100 $5,190.81 $115.17 $0.00 $6,184.84 Debt Service Relief G 390 -10100 $288,442.46 $0.00 $19,017.00 $233,768.85 2011A GO CIP Bonds G 447 -10100 $174,042.45 $0.00 $0.00 $174,042.45 2013 Imp Cedar /Baker /Ridgew G 448 -10100 $105,698.76 $0.00 $174.50 $103,919.86 2013 Equipment Certificates G 449 -10100 $200,495.55 $0.00 $0.00 $50,174.69 Capital Outlay G 490 -10100 $202,751.95 $0.00 $0.00 $277,831.95 Water Extension G 501 -10100 $44.48 $0.65 $0.00 $823.86 Sewer Extension G 502 -10100 $585,859.32 $675.98 $0.00 $589,401.04 Water Fund G 601 -10100 $3,590.04 $81,832.60 $69,702.53 $77,247.27 Sewer Fund G 602 -10100 $1,829,479.67 $43,334.97 $149,622.74 $1,723,337.60 Refuse Collection G 603 -10100 $254,336.58 $21,322.59 $25,361.98 $242,519.58 Storm Water Utility G 651 -10100 $205,799.32 $7,602.97 $6,917.75 $214,998.47 Street Light Utility G 652 -10100 $20.14 $3,645.60 $4,435.40 $827.35 Last Dim 10100 $8,896,907.01 $254,274.75 $647,012.56 $8,090,387.92 Last Dim 10200 General G 101 -10200 $275.00 $0.00 $0.00 $275.00 Last Dim 10200 $275.00 $0.00 $0.00 $275.00 Last Dim 10300 Water Fund G 601 -10300 $4,682,985.00 $0.00 $0.00 $4,682,985.00 Last Dim 10300 $4,682,985.00 $0.00 $0.00 $4,682,985.00 $13,580,167.01 $254,274.75 $647,012.56 $12,773,647.92 CITY OF ST. JOSEPH 04/07/14 1:59 PM Council Month End Revenue Summary Page 1 Current Period: March 2014 $6,695,150.00 $231,394.73 $390,224.04 2014 March 2014 FUND FUND Descr YTD Budqet 2014 Amt YTD Amt 101 General $2,420,620.00 $15,638.68 $37,932.96 105 Fire Fund $281,980.00 $2,306.09 $60,175.93 108 Cable Access Fee $7,450.00 $720.76 $1,437.20 150 Economic Development $130,595.00 $70,623.51 $84,070.96 157 TIF 2 -1 Millstream $0.00 $16.30 $96.10 158 TIF 2 -2 Meat Market $0.00 $0.05 $2.38 200 State Collected Sales Tax $0.00 $2,156.30 - $843.70 205 Park Dedication $0.00 $78.18 $4,316.19 215 Charitable Gambling $0.00 $4.55 $21.90 250 Revolving Loan Fund $8,380.00 $709.92 $2,193.71 318 2009A CrossoverRefunding Bonds $219,545.00 $453.93 $2,347.89 320 2007 Refunding (98/99 St Bond) $30,340.00 $104.77 $649.74 322 City Hall Refunded, 2005 $94,100.00 $4.72 $71.27 331 2011A Refunding Fire Hall $52,445.00 $115.77 $7,127.83 333 2010B Refundin (Hill /Clover) $101,630.00 $322.54 $1,686.14 338 2011A CO Refund (Interior Sts) $53,860.00 $170.06 $957.40 341 2007 St Impry -E Side /3ade /8 Av $54,250.00 $520.87 $2,594.00 343 2009B GO CIP Bonds $66,800.00 $6.18 $63.99 344 2010 Equipment Certificates $33,500.00 $4.24 $39.23 345 2010B Street Impr (16th Ave) $37,830.00 $248.21 $1,232.97 346 2011A Pumper Truck Certificate $43,935.00 $4.65 $5,372.39 347 2011A GO CIP Bonds $22,240.00 $214.36 $1,037.42 348 2013 Street Improve Bonds $21,130.00 $219.34 $1,134.55 349 2013 Equipment Certificates $54,250.00 $115.17 $1,038.71 390 Debt Service Relief $0.00 $0.00 $0.00 447 2011A GO CIP Bonds $0.00 $0.00 $0.00 448 2013 Imp Cedar /Baker /Ridgewood $0.00 $0.00 $0.00 449 2013 Equipment Certificates $0.00 $0.00 $0.00 490 Capital Outlay $0.00 $0.00 $84,080.00 501 Water Extension $0.00 $0.65 $260.25 502 Sewer Extension $0.00 $675.98 $3,346.29 601 Water Fund $1,178,170.00 $64,210.42 $58,392.96 602 Sewer Fund $1,322,920.00 $42,039.96 $31,878.21 603 Refuse Collection $287,025.00 $18,460.00 $11,415.17 651 Storm Water Utility $119,130.00 $7,602.97 - $16,276.65 652 Street Light Utility $53,025.00 $3,645.60 $2,370.65 $6,695,150.00 $231,394.73 $390,224.04 CITY OF ST. JOSEPH 04/07/14 1:59 PM Council Month End Revenue - General Fund Page 1 Current Period: March 2014 2014 March 2014 FUND FUND Descr SOURCE Descr YTD Budqet 2014 Amt YTD Amt FUND 101 General 101 General Current Ad Valorem Taxes $1,087,245.00 $0.00 $0.01 101 General Special Levy- City St. Joe $0.00 $0.00 $0.00 101 General State Sales Tax $0.00 $23.61 $50.90 101 General Gas Franchise $28,000.00 $0.00 $0.00 101 General Electric Franchise $52,000.00 $3,578.39 $3,560.28 101 General Beer $375.00 $5.00 $15.00 101 General Liquor $24,000.00 $0.00 $0.00 101 General Outdoor Liquor Permit $2,500.00 $0.00 $0.00 101 General Gambling Permits $120.00 $115.00 $115.00 101 General Amusement /Hunting Permit $1,000.00 $0.00 $0.00 101 General Excavation Permit $300.00 $50.00 $350.00 101 General Cigarette License $525.00 $0.00 $0.00 101 General Cable Franchise Fee $30,000.00 $1,129.28 $2,246.85 101 General Building Permits $45,000.00 $953.64 $2,322.76 101 General Animal License $3,150.00 $1,580.00 $1,620.00 101 General Rental Housing Registration $22,000.00 $0.00 $0.00 101 General Federal Grants - Other $5,000.00 $962.51 $435.01 101 General State Grants and Aids $0.00 $0.00 $0.00 101 General Local Government Aid $873,160.00 $0.00 $0.00 101 General PERA Rate Increase Aid $1,540.00 $0.00 $0.00 101 General Police Training Reim $3,500.00 $0.00 $0.00 101 General State Municipal Funds Aid $6,180.00 $0.00 $3,772.50 101 General State Police Aid $48,000.00 $0.00 $0.00 101 General Other Grants /Aids $250.00 $0.00 $0.00 101 General Other Governmental Unit $10,000.00 $0.00 $5,000.00 101 General County Grants - Road Maint. $7,750.00 $0.00 $0.00 101 General Zoning and Subdivision Fee $1,000.00 $0.00 $0.00 101 General Land Use Deposit Fee $4,000.00 $0.00 $0.00 101 General Sale of Maps and Publications $50.00 $1.00 $18.25 101 General Assessments Search $2,500.00 $30.00 $150.00 101 General Special Hearing $4,500.00 $0.00 $400.00 101 General Administration Reimb $11,600.00 $0.00 $75.00 101 General Weed Cutting $1,000.00 $100.00 - $100.00 101 General Park Fees $5,500.00 $820.00 $2,420.00 101 General Ball Field Donation $500.00 $0.00 $0.00 101 General Schneider Field Rental $2,700.00 $0.00 $0.00 101 General Kennel Fees $500.00 $194.00 $194.00 101 General County Fines $27,000.00 $1,419.77 $2,359.49 101 General Policy Fines $35,000.00 $1,025.00 $3,420.00 101 General Accident Report Fee $1,000.00 $60.75 $162.25 CITY OF ST. JOSEPH Council Month End Revenue - General Fund Current Period: March 2014 04/07/14 1:59 PM Page 2 2014 March 2014 FUND FUND Descr SOURCE Descr YTD Budqet 2014 Amt YTD Amt 101 General Seized Property $500.00 $0.00 $0.00 101 General Special Assessments $1,500.00 $0.00 $0.00 101 General Interest Earnings $15,000.00 $1,445.77 $6,778.10 101 General Interest Charges $100.00 $3.23 - $28.06 101 General Co -op Dividend - LMCIT $15,000.00 $0.00 $0.00 101 General Water Tower Antenna Lease $3,550.00 $305.96 $917.88 101 General Advertising $2,000.00 $0.00 $230.00 101 General Contributions - General $1,500.00 $0.00 $0.00 101 General Contribution - Health Ins Div $0.00 $0.00 $0.00 101 General Contributions - Parks $1,000.00 $0.00 $0.00 101 General Surplus Property $0.00 $0.00 $0.00 101 General Reimbursement $32,025.00 $1,835.77 $1,447.74 101 General Street Access Fee $0.00 $0.00 $0.00 101 General Transfers from Other Funds $0.00 $0.00 $0.00 FUND 101 General $2,420,620.00 $15,638.68 $37,932.96 FUND 108 Cable Access Fee 108 Cable Access Fee Cable Franchise Fee $7,450.00 $720.76 $1,437.20 108 Cable Access Fee Transfers from Other Funds $0.00 $0.00 $0.00 FUND 108 Cable Access Fee $7,450.00 $720.76 $1,437.20 FUND 150 Economic Development 150 Economic Development Current Ad Valorem Taxes $130,095.00 $0.00 $0.00 150 Economic Development Federal Grants - Other $0.00 $70,498.00 $83,358.00 150 Economic Development TIF /MIF Deposit $0.00 $0.00 $0.00 150 Economic Development DEED Housing Reimbursement $0.00 $0.00 $0.00 150 Economic Development Interest Earnings $500.00 $125.51 $712.96 150 Economic Development Transfers from Other Funds $0.00 $0.00 $0.00 FUND 150 Economic Development $130,595.00 $70,623.51 $84,070.96 $2,558,665.00 $86,982.95 $123,441.12 CITY OF ST. JOSEPH 04/07/14 1:58 PM Council Month End Revenue - Enterprise Funds Page 1 Current Period: March 2014 FUND 2014 March 2014 FUND Descr SOURCE Descr YTD Budqet 2014 Amt YTD Amt FUND 601 Water Fund 601 Water Fund Water Meter $5,000.00 $4,855.56 $0.00 601 Water Fund State Sales Tax $225.00 $291.31 - $2,640.26 601 Water Fund Transfers from Other Funds $337,500.00 $0.00 $0.00 601 Water Fund Contributed Revenue $0.00 $0.00 $0.00 601 Water Fund Water Line Charge $239,785.00 $18,981.02 $13,913.72 601 Water Fund Penalties and Forfeited Disc $7,190.00 $864.05 $2,920.55 601 Water Fund Connection /Reconnection fees $500.00 $0.00 $0.00 601 Water Fund Undesignated Funds $0.00 $160.26 $1,477.84 601 Water Fund Interest Earnings $35,990.00 $1,840.70 $9,275.20 601 Water Fund Rate Class One $505,530.00 $32,048.22 $29,609.12 601 Water Fund Reimbursement $0.00 $0.00 $74.80 601 Water Fund Surplus Property $0.00 $0.00 $0.00 601 Water Fund Special Assessments $800.00 $0.00 - $5,037.22 601 Water Fund Water Tower Antenna Lease $33,005.00 $2,753.57 $8,260.71 601 Water Fund Amortization of Bond Premium $0.00 $0.00 $0.00 601 Water Fund Bulk Water $1,000.00 $1,615.60 $0.00 601 Water Fund MDS Test Fee $11,645.00 $800.13 $538.50 FUND 601 Water Fund $1,178,170.00 $64,210.42 $58,392.96 FUND 602 Sewer Fund 602 Sewer Fund Reimbursement $3,000.00 $0.00 $0.00 602 Sewer Fund Surplus Property $0.00 $0.00 $0.00 602 Sewer Fund Contributions - General $0.00 $0.00 $0.00 602 Sewer Fund Amortization of Bond Premium $0.00 $0.00 $0.00 602 Sewer Fund Interest Earnings $5,075.00 $2,097.21 $10,684.86 602 Sewer Fund Other Governmental Unit $0.00 $0.00 $0.00 602 Sewer Fund Sanitary Sewer Service $433,200.00 $22,722.96 $12,364.64 602 Sewer Fund Penalties and Forfeited Disc $4,145.00 $537.11 $1,701.25 602 Sewer Fund Special Assessments $350.00 $0.00 - $3,895.87 602 Sewer Fund Sewer Line Charge $269,400.00 $16,682.68 $11,023.33 602 Sewer Fund Transfers from Other Funds $607,750.00 $0.00 $0.00 602 Sewer Fund General Oblig. Bond Proceeds $0.00 $0.00 $0.00 602 Sewer Fund Bond Premium Proceeds $0.00 $0.00 $0.00 602 Sewer Fund Contributed Revenue $0.00 $0.00 $0.00 FUND 602 Sewer Fund $1,322,920.00 $42,039.96 $31,878.21 FUND 603 Refuse Collection 603 Refuse Collec Refuse Collection Charges $258,150.00 $18,592.76 $11,971.91 603 Refuse Collec Contributions - General $0.00 $0.00 $0.00 603 Refuse Collec Interest Earnings $4,000.00 $283.57 $1,402.72 603 Refuse Collec Penalties and Forfeifted Disc $5,500.00 $633.56 $1,914.68 603 Refuse Collec Contributed Revenue $0.00 $0.00 $0.00 603 Refuse Collec Licenses & Permits $18,875.00 $0.00 $0.00 603 Refuse Collec State Sales Tax $0.00 - $1,049.89 - $3,431.73 603 Refuse Collec Special Assessments $500.00 $0.00 - $442.41 FUND 603 Refuse Collection $287,025.00 $18,460.00 $11,415.17 FUND 651 Storm Water Utility 651 Storm Water Development Fee $20,000.00 $0.00 $0.00 651 Storm Water Transfers from Other Funds $0.00 $0.00 $0.00 651 Storm Water Penalties and Forfeifted Disc $2,000.00 $166.79 $507.25 CITY OF ST. JOSEPH Council Month End Revenue - Enterprise Funds Current Period: March 2014 04/07/14 1:58 PM Page 2 FUND 652 Street Light Utility 652 FUND Transfers from Other Funds 2014 March 2014 FUND Descr SOURCE Descr YTD Budqet 2014 Amt YTD Amt 651 Storm Water Rate Class One $96,230.00 $7,195.29 $4,768.51 651 Storm Water Contributed Revenue $0.00 $0.00 $0.00 651 Storm Water Reimbursement $0.00 $0.00 $0.00 651 Storm Water Special Assessments $350.00 $0.00 - $22,736.90 651 Storm Water Interest Earnings $550.00 $240.89 $1,184.49 FUND 651 Storm Water Utility $119,130.00 $7,602.97 - $16,276.65 FUND 652 Street Light Utility 652 Street Light U Transfers from Other Funds $0.00 $0.00 $0.00 652 Street Light U Special Assessments $25.00 $0.00 - $25.59 652 Street Light U Interest Earnings $100.00 $0.75 - $17.96 652 Street Light U Rate Class One $52,700.00 $3,644.85 $2,414.20 652 Street Light U Penalties and Forfeited Disc $200.00 $0.00 $0.00 FUND 652 Street Light Utility $53,025.00 $3,645.60 $2,370.65 $2,960,270.00 $135,958.95 $87,780.34 CITY OF ST. JOSEPH 04/07/14 1:58 PM Council Month End Expenditure - Summary Page 1 Current Period: March 2014 2014 March 2014 Description YTD Budqet 2014 Amt YTD Amt General $2,332,540.00 $223,056.93 $619,448.68 Fire Fund $296,980.00 $12,276.31 $22,275.96 Cable Access Fee $8,500.00 $0.00 $0.00 Economic Development $130,595.00 $78,808.52 $99,886.64 TIF 2 -1 Millstream $0.00 $0.00 $0.00 TIF 2 -2 Meat Market $0.00 $0.00 $0.00 State Collected Sales Tax $0.00 $55,243.46 $42,636.32 Park Dedication $50,400.00 $419.00 $823.82 Charitable Gambling $0.00 $0.00 $0.00 Revolving Loan Fund $0.00 $0.00 $0.00 2009A CrossoverRefunding Bon $354,900.00 $0.00 $0.00 2007 Refunding (98/99 St Bond $120,170.00 $0.00 $0.00 City Hall Refunded, 2005 $97,985.00 $0.00 $0.00 2011A Refunding Fire Hall $76,150.00 $0.00 $2,900.00 2010B Refundin (Hill /Clover) $139,550.00 $0.00 $0.00 2011A CO Refund (Interior Sts) $141,980.00 $0.00 $10,815.00 2007 St Impry -E Side /3ade /8 A $291,670.00 $0.00 $0.00 2009B GO CIP Bonds $64,800.00 $0.00 $0.00 2010 Equipment Certificates $31,850.00 $0.00 $0.00 2010B Street Impr (16th Ave) $66,855.00 $0.00 $0.00 2011A Pumper Truck Certificate $42,010.00 $0.00 $3,330.00 2011A GO CIP Bonds $23,670.00 $0.00 $1,660.00 2013 Street Improve Bonds $9,870.00 $0.00 $0.00 2013 Equipment Certificates $55,500.00 $0.00 $0.00 Debt Service Relief $0.00 $19,017.00 $28,314.45 2011A GO CIP Bonds $0.00 $0.00 $0.00 2013 Imp Cedar /Baker /Ridgew $0.00 $174.50 - $10,623.91 2013 Equipment Certificates $0.00 $0.00 $0.00 Capital Outlay $84,080.00 $0.00 $0.00 Water Extension $0.00 $0.00 $0.00 Sewer Extension $0.00 $0.00 $0.00 Water Fund $1,442,770.00 $52,080.35 $68,675.59 Sewer Fund $1,529,055.00 $148,327.73 $138,664.34 Refuse Collection $336,185.00 $22,499.39 $56,194.25 Storm Water Utility $257,865.00 $6,917.75 $15,599.40 Street Light Utility $53,025.00 $4,435.40 $9,518.66 $8,038,955.00 $623,256.34 $1,110,119.20 CITY OF ST. JOSEPH 04/07/14 1:58 PM Council Month End Expenditure - General Fund Page 1 Current Period: March 2014 FUND 108 Cable Access Fee Cable Access Fee Cable Access FUND 108 Cable Access Fee FUND 150 Economic Development $8,500.00 $0.00 $8,500.00 $0.00 $0.00 $0.00 2014 March 2014 Description DEPART Descr YTD Budqet 2014 Amt YTD Amt FUND 101 General General Council $49,550.00 $2,590.33 $7,495.71 General Legislative Committees $6,020.00 $1,552.49 - $197.51 General Ordinance & Proceedings $1,350.00 $0.00 $181.62 General Mayor $10,995.00 $994.08 $1,742.08 General Elections $3,000.00 $0.00 $1,356.24 General General Adminstration $221,425.00 $16,062.70 $44,714.64 General Finance $118,970.00 $8,246.13 $26,458.29 General Audit Service $25,950.00 $17,500.00 $17,500.00 General Assessing $23,500.00 $0.00 $0.00 General City Attorney $17,000.00 $4,366.40 $5,318.64 General Planning and Zoning $7,400.00 $1,121.32 $1,582.48 General General Government $19,080.00 $3,495.98 $5,994.47 General City Offices $28,945.00 $4,006.05 $7,911.14 General Facilites and Planning $0.00 $0.00 $0.00 General Cable Access $11,065.00 $830.60 $2,061.20 General Crime Control & Investigation $908,340.00 $75,971.16 $181,651.24 General Police Training $7,650.00 $375.00 $650.00 General Communication Service $11,185.00 $807.06 $2,051.95 General Automotive Services $51,100.00 $4,300.11 $10,370.93 General Building Inspec. Admistration $92,000.00 $7,500.00 $15,000.00 General Emergency Management $1,280.00 $657.54 $665.86 General Signal Lights CSAH 75 $0.00 $0.00 $0.00 General Animal Control $950.00 $255.50 $450.50 General Street Maintanence $239,205.00 $21,775.03 $42,194.29 General Ice & Snow Removal $97,570.00 $17,734.22 $75,833.18 General Engineering Fee $30,000.00 $1,659.29 $5,579.68 General Street Cleaning $15,660.00 $0.00 $0.00 General Skate Park and Ice Rink $3,345.00 $386.48 $1,551.30 General Ball Park $1,750.00 $0.00 $9.98 General Maintenance Shop $18,085.00 $3,235.06 $5,769.50 General Park Areas $213,270.00 $27,634.40 $42,307.41 General Community Support $0.00 $0.00 $0.00 General Other Financing Uses $0.00 $0.00 $88,080.00 General Fire Protection $96,900.00 $0.00 $25,163.86 FUND 101 General $2,332,540.00 $223,056.93 $619,448.68 FUND 108 Cable Access Fee Cable Access Fee Cable Access FUND 108 Cable Access Fee FUND 150 Economic Development $8,500.00 $0.00 $8,500.00 $0.00 $0.00 $0.00 CITY OF ST. JOSEPH Council Month End Expenditure - General Fund Current Period: March 2014 04/07/14 1:58 PM Page 2 FUND 490 Capital Outlay Capital Outlay 2014 March 2014 Description DEPART Descr YTD Budqet 2014 Amt YTD Amt Economic Development Economic Development Authority $130,595.00 $78,808.52 $99,886.64 Economic Development Other Financing Uses $0.00 $0.00 $0.00 FUND 150 Economic Development $130,595.00 $78,808.52 $99,886.64 FUND 490 Capital Outlay Capital Outlay Elections $0.00 $0.00 $0.00 Capital Outlay General Adminstration $4,750.00 $0.00 $0.00 Capital Outlay General Government $0.00 $0.00 $0.00 Capital Outlay City Offices $0.00 $0.00 $0.00 Capital Outlay Cable Access $0.00 $0.00 $0.00 Capital Outlay Crime Control & Investigation $4,400.00 $0.00 $0.00 Capital Outlay Communication Service $6,275.00 $0.00 $0.00 Capital Outlay Automotive Services $17,150.00 $0.00 $0.00 Capital Outlay Emergency Management $2,000.00 $0.00 $0.00 Capital Outlay Street Maintanence $15,500.00 $0.00 $0.00 Capital Outlay Ice & Snow Removal $7,000.00 $0.00 $0.00 Capital Outlay Street Lighting $0.00 $0.00 $0.00 Capital Outlay Street Cleaning $0.00 $0.00 $0.00 Capital Outlay Skate Park and Ice Rink $0.00 $0.00 $0.00 Capital Outlay Maintenance Shop $6,690.00 $0.00 $0.00 Capital Outlay Park Areas $20,315.00 $0.00 $0.00 Capital Outlay Other Financing Uses $0.00 $0.00 $0.00 FUND 490 Capital Outlay $84,080.00 $0.00 $0.00 $2,555,715.00 $301,865.45 $719,335.32 CITY OF ST. JOSEPH 04/07/14 1:58 PM Council Month End Expense - Enterprise Funds Page 1 Current Period: March 2014 2014 March 2014 Description DEPART Descr YTD Budqet 2014 Amt YTD Amt FUND 601 Water Fund Water Fund Bond Payment (P & I) $664,090.00 $0.00 - $28,852.00 Water Fund Other Financing Uses $45,000.00 $0.00 $0.00 Water Fund Power and Pumping $21,790.00 $382.20 $2,152.90 Water Fund Purification -Plant 1 $35,100.00 $1,754.33 $4,444.75 Water Fund Purification -Plant 2 $82,465.00 $6,832.14 $14,973.43 Water Fund Distribution $10,000.00 $339.17 $169.17 Water Fund Wellhead Protection $2,000.00 $0.00 $382.30 Water Fund Storage -Tower 1 $5,120.00 $11,738.82 $13,316.66 Water Fund Storage -Tower 2 $0.00 $0.00 $0.00 Water Fund Water Maintenance $179,915.00 $28,834.33 $53,250.03 Water Fund Administration and General $37,290.00 $2,199.36 $8,838.35 Water Fund Depreciation Expense $360,000.00 $0.00 $0.00 FUND 601 Water Fund $1,442,770.00 $52,080.35 $68,675.59 FUND 602 Sewer Fund Sewer Fund Bond Payment (P & I) $230,620.00 $0.00 - $13,275.00 Sewer Fund Other Financing Uses $45,000.00 $0.00 $0.00 Sewer Fund Sanitary Sewer Maintenanc $228,165.00 $19,996.04 $36,551.38 Sewer Fund Lift Station -Baker Street $85,780.00 $323.19 $632.37 Sewer Fund Lift Station -DBL Labs Area $2,915.00 $238.03 $471.78 Sewer Fund Lift Station - Northland $4,995.00 $224.77 $404.90 Sewer Fund Lift Station -CR 121 $5,295.00 $321.82 $581.97 Sewer Fund Lift Station -Main $673,270.00 $124,279.61 $103,661.12 Sewer Fund Administration and General $38,015.00 $2,944.27 $9,635.82 Sewer Fund Depreciation Expense $215,000.00 $0.00 $0.00 FUND 602 Sewer Fund $1,529,055.00 $148,327.73 $138,664.34 FUND 603 Refuse Collection Refuse Collectio Waste Collection $336,185.00 $22,499.39 $56,194.25 Refuse Collectio Other Financing Uses $0.00 $0.00 $0.00 Refuse Collectio Depreciation Expense $0.00 $0.00 $0.00 FUND 603 Refuse Collection $336,185.00 $22,499.39 $56,194.25 FUND 651 Storm Water Utility Storm Water Uti Other Financing Uses $18,250.00 $0.00 $0.00 Storm Water Uti Administration and General $12,785.00 $607.64 $4,014.44 Storm Water Uti Storm Water Maintenance $126,830.00 $6,310.11 $11,584.96 Storm Water Uti Depreciation Expense $100,000.00 $0.00 $0.00 FUND 651 Storm Water Utility $257,865.00 $6,917.75 $15,599.40 FUND 652 Street Light Utility Street Light Utili Street Lighting $53,025.00 $4,435.40 $9,518.66 FUND 652 Street Light Utility $53,025.00 $4,435.40 $9,518.66 CITY OF ST. JOSEPH 04/07/14 1:58 PM Page 2 Council Month End Expense - Enterprise Funds Current Period: March 2014 2014 March 2014 Description DEPART Descr YTD Budqet 2014 Amt YTD Amt $3,618,900.00 $234,260.62 $288,652.24 2013 Capital Expenditures General Fund Capital Improvement Plan - Summary 2014 CIP Budget - Final adopted December 5, 2013 As of March 31, 2014 ADMA Available through 3/31 through 3/31 Project Budget Reserve Transferred/ Spent Budget Remaining Department Account Code Equipment Balance Grant 2014 2014 2014 Balance Election 101-41410-530 Election Equipment 27,264.91 - 1,356.24 3,000.00 28,908.67 Administration 490- 41430 -570 Administration Equipment 15,871.89 - 1,750.00 17,621.89 Administration 490- 41430 -581 Computer Replacement 10,782.71 2,000.00 12,782.71 Administration 490- 41430 -582 Computer Software 7,399.68 1,000.00 8,399.68 Administration 101-41910-300 Planning Document Updates - - 5,000.00 5,000.00 Cable Access 108- 41950 -580 Cable Equipment 6,870.34 1,437.20 8,500.00 16,807.54 Total Administration CIP 68,189.53 1,437.20 1,356.24 21,250.00 89,520.49 Police - General 490 - 42120 -580 Police Equipment 6,689.82 - - 4,400.00 11,089.82 Police- Communications 490 - 42151 -580 Communication Equipment 20,929.38 6,275.00 27,204.38 Police - Automotive 490 - 42152 -550 Police Squads (370.00) 4,000.00 3,630.00 Police - Automotive 490 - 42152 -580 Vehicle /Equipment 13,400.42 6,350.00 19,750.42 Police - Automotive 490 - 42152 -581 Squad Laptops 1,204.95 6,800.00 8,004.95 Emergency Services 490 - 42500 -580 Emergency Services 2,412.61 2,000.00 4,412.61 Total Police CIP 44,267.18 29,825.00 74,092.18 Streets 101 - 43120 -530 Street Improvements 29,334.96 30,000.00 59,334.96 Streets 490 - 43120 -550 Street Motor Vehicles - 1,750.00 1,750.00 Streets 490- 43120 -580 Street Equipment 16,598.51 3,750.00 20,348.51 Streets 490 - 43120 -530 Street Improvements - 10,000.00 10,000.00 Streets 101 - 43120 -530 Street Improvements - 5,000.00 5,000.00 Street Sweeping 490 - 43220 -580 Street Sweeping Equipment 1,500.00 - 1,500.00 Snow Removal 490 - 43125 -580 Snow Removal Equipment 7,250.00 7,000.00 14,250.00 Maintenance 490- 45201 -580 Maintenance Shop Equipment 46,846.86 6,690.00 53,536.86 Parks 490- 45202 -580 Parks Equipment 45,235.23 22,565.00 67,800.23 Parks 490 - 45202 -550 Parks Motor Vehicles 999.89 1,750.00 2,749.89 Total Public Works CIP 147,765.45 88,505.00 236,270.45 EDA Software 150 - 46500 -582 Computer Software 1,200.00 500.00 1,700.00 EDA Projects 150- 46500 -588 EDA Programs 35,951.57 (6,978.00) 33,000.00 61,973.57 Total EDA CIP 37,151.57 - (6,978.00) 33,500.00 63,673.57 Total General Capital Improvements 173,080.00 463,556.69 297,373.73 1,437.20 (5,621.76) ADMA St. Joseph Fire Department Capital Improvement Plan - for Payable 2014 Fire Board Final 2014 Capital Budget Adopted December 5, 2013 12/31/2013 as of 3/31 Available Grants/ as of 3/31 Available Purchased Reserve Budget Adjustments Spent Reserve CIP # Account Code Department Object Year Description Funds 2014 2014 2014 Funds FD -1401 105 - 42210 - 581/582 Fire Administration Computer Hardware /Software 2010/2011 3 Computers 1,000.001 1,000.00 Total Fire Administration Computer Hardware /Software 1,000.001 1,000.00 FD -1402 105 - 42220 -580 Fire Fighting Other Equipment n/a Turnout Gear 9,893.14 500.00 10,393.14 Total Fire Fighting Other Equipment 9,893.14 500.00 10,393.14 FD -1404 105 - 42220 -584 Fire Fighting Equipment Reserve 1996/2005 Extrication Equip 13,562.40 2,000.00 15,562.40 Total Fire Fighting Equipment Reserve 15,562.40 13,562.40 2,000.00 FD -1403 105 - 42220 -585 Fire Fighting Firefighter Equipment 2012 6 Wheeler (1,296.05) 500.00 (796.05) FD -1405 105 - 42220 -585 Fire Fighting Firefighter Equipment 2012 Rescue Van 26,259.58 3,000.00 29,259.58 FD -1406 105 - 42220 -585 Fire Fighting Firefighter Equipment 2012 Pumper Truck 44,323.77 5,000.00 49,323.77 FD -1407 105 - 42220 -585 Fire Fighting Firefighter Equipment 2001 Ladder Truck #2 29,750.00 7,500.00 37,250.00 FD -1408 105 - 42220 -585 Fire Fighting Firefighter Equipment 1997 Grass Rig #3 30,000.00 8,000.00 38,000.00 FD -1409 105 - 42220 -585 Fire Fighting Firefighter Equipment 1999 Tanker #4 34,250.00 5,000.00 39,250.00 FD -1417 105 - 42220 -585 Fire Fighting Firefighter Equipment 2013 Air Packs - 2,000.00 2,000.00 FD -1410 105 - 42220 -585 Fire Fighting Firefighter Equipment n/a Replacement 19,517.77 5,000.00 2,000.00 26,517.77 Total Fire Fighting Equipment 182,805.07 1 32,500.00 2,000.00 220,805.07 FD -1411 105 - 42250 -580 Fire Communication Other Equipment 2007 800 MHz Radios 24,008.25 10,000.00 34,008.25 FD -1412 105 - 42250 -580 Fire Communication Other Equipment n/a Replacement 1,665.15 500.00 2,165.15 Total Fire Communications Equipment 25,673.40 10,500.00 - 36,173.40 FD -1413 105 - 42270 -580 Medical Services Other Equipment n/a Replacement 1,127.57 200.00 1,327.57 Total Medical Services Equipment 1,127.57 200.00 1,327.57 FD -1414 105 - 42280 -530 Fire Station & Buildinc Equipment Reserve n/a Building Repairs 28,776.92 1,500.00 30,276.92 FD -1415 105 - 42280 -530 Fire Station & Buildinc Equipment Reserve 2011 Sealcoating 18,491.92 500.00 18,991.92 FD -1416 105 - 42280 -530 Fire Station & Buildinc Improvements other than Buildin 2008 Painting 6,450.00 1,000.00 7,450.00 Total Fire Station & Building Improvements other than Building 53,718.84 3,000.00 - 56,718.84 Total Capital Improvement- Fire Fund 341,980.42 286,780.42 1 49,700.00 1 2,000.00 City of St. Joseph Park Board Capital Improvement Budget Summary 2014 Final Capital Budget Adopted December 5, 2013 General Funds Balance Park Dedication Cash March 31, 2014 $ 58,154 (Unaudited) Adjustments Starting Balance $ 58,154 Legacy Grant $ - Potential Projects: Potential Proposed Millstream Cottages -phase 2 $ 23,400 Ending Balance for 2014 1 $ 58,154 Projects - Budget Spent 2013 2014 2013 $ 2014 PTR -02 (Northland) 2015 $ 2016 $ 2017 PTR -04 (Wobegon) 2018 Total 14 -18 PTR -01 (Millstream) $ - $ - $ - $ 25,000 $ - $ - $ 25,000 PTR -02 (Northland) $ - $ - $ - $ - $ - $ - $ - PTR -03 (Klinefelter) $ - $ 4,000 $ 71,000 $ - $ - $ - $ 75,000 PTR -04 (Wobegon) $ - $ - $ - $ - $ - $ - $ - PTR -05 (Memorial) $ - $ - $ - $ - $ - $ - $ - PTR -06 (Centennial) $ - $ - $ - $ - $ - $ - $ - PTR -07 (Monument) $ 400 $ 400 $ 400 $ 400 $ 400 $ 400 $ 2,000 PTR -08 (Hollow) $ - $ - $ - $ - $ - $ - $ - PTR -09 (Cloverdale) $ 25,000 $ 10,000 $ - $ - $ - $ - $ 10,000 PTR -10 (East Park) $ - $ - $ - $ - $ - $ - $ - PTR -11 (West Park) $ - $ - $ - $ - $ - $ - $ - PTR -12 (Trails) $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000 PTR -13 (Trees) $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 7,500 Total $ 35,400 $ 25,900 $ 82,900 $ 36,900 $ 11,900 $ 11,900 $ 169,500 Projects - Actual Spent 2013 2014 PTR -01 (Millstream) $ $ PTR -02 (Northland) $ $ PTR -03 (Klinefelter) $ $ PTR -04 (Wobegon) $ $ PTR -05 (Memorial) $ $ PTR -06 (Centennial) $ $ PTR -07 (Monument) $ (122) $ PTR -08 (Hollow) $ - $ - PTR -09 (Cloverdale) $ (32,684) $ (186) PTR -10 (East Park) $ $ - PTR -11 (West Park) $ $ PTR -12 (Trails) $ $ PTR -13 (Trees) $ $ Total $ (32,806) $ (186) 14 Snow Town Expenses: I Avail. Rev $ $ 905 Other 14 Expenses: 1 2013 YTD Dog Baggies $ 269 A -1 Toilets $ 369 1 $ - $ 2,155 2014 Revenue: 2013 YTD Interest $ 306 $ 20 Round Up $ 10 $ 134 GF Transfer $ 4,000 $ 3,000 Donation $ - $ 15,625 Park Dedic. $ $ - Millstream 5k EM. Available Rev. $ $ 3,024 Project Project apartment Account Code Number nt 2014 Capital Expenditures Enterprise Capital Improvement Plan - Public Works Enterprise Final 2014 CIP Budget Adopted December 5, 2013 12/31/2013 Grants/ as of 3/31 2014 Reserve Budget Transfers Spent Available Balance 2014 2014 2014 Balance Water- 601 - 49440 -550 PW -1403 Truck (1/4) 1,750.00 1,750.00 601 - 49440 -580 WT -1405 Line Tracer 1,250.00 (2,255.14) (1,005.14) 601 - 49490 -580 WT -1401 Handheld Meter Programmer - 2,500.00 2,500.00 601 - 49410 -220 WT -1402 Well #4/5 Roof Replacement 6,250.00 - 6,250.00 601 - 49420 -580 WT -1403 WTP 1 Repairs 5,000.00 3,750.00 8,750.00 601 - 49420 -580 WT -1404 WTP 1 Filter Media Replacement 12,500.00 7,500.00 20,000.00 601 - 49421 -580 WT -1403 WTP 2 Repairs 4,680.44 3,750.00 (1,457.00) 6,973.44 20,500.00 - (3,712.14) 45,218.30 28,430.44 Sewer- 602 - 49450 -580 WW -1407 Communications System (1/2) 25,475.00 - 25,475.00 602 - 49450 -580 WW -1405 Line Tracer - 1,250.00 (2,255.14) (1,005.14) 602 - 49450 -550 PW -1403 Truck (1/4) - 1,750.00 1,750.00 602 - 49450 -530 WW -1401 Sewer Lining 85,999.18 20,000.00 105,999.18 602 - 49450 -300 WW -1408 Sewer Televising/Root Foaming 15,196.61 10,000.00 258.75 (1,371.07) 24,084.29 602 - 49480 -580 WW -1402 Sewer Sampler 6,000.00 500.00 6,500.00 602 - 49471 -580 WW -1403 Submersible pumps - Ridgewood LS 14,000.00 - 14,000.00 602 - 49470 -580 WW -1403 Submersible pumps - Baker St LS - 2,300.00 2,300.00 602 - 49472 -580 WW -1403 Submersible pumps - Northland LS - 2,300.00 2,300.00 602 - 49473 -580 WW -1403 Submersible pumps - CR121 LS 3,000.00 2,200.00 5,200.00 40,300.00 258.75 (3,626.21) 186,603.33 149,670.79 Stormwater- 651 - 49900 -300 SS -1401 Storm Water Management Plan 42,410.19 - (1,570.00) 40,840.19 651 - 49900 -530 SS -1404 Aerial Mapping 10,550.00 1,000.00 11,550.00 651 - 49900 -530 SS -1405 Water Quality Improvements 76,000.00 1,000.00 77,000.00 651 - 49900 -580 PW -1407 Street Sweeper 4,000.00 8,000.00 12,000.00 651 - 49900 -510 SS -1406 Property Easements /Acquire 70,000.00 5,000.00 75,000.00 202,960.19 15,000.00 (1,570.00) 216,390.19 Refuse- 603 - 43230 -580 PW -1425 Front End Loader (1/4) 1,500.00 1,500.00 3,000.00 603 - 43230 -510 RF -1401 Compost Site Land - - - 1,500.00 1,500.00 3,000.00 St. Lighting 652 - 43160 -580 SL -1410 Street Lighting 1,000.00 1,000.00 2,000.00 1,000.00 2,000.00 1,000.00 2015/2018 Equipment Certificates Streets- 449 - 43120 -580 WT -1407 Communications System (1/2) 30,000.00 30,000.00 Projects Included in the Engineer's Capital Budget: Water- 601 - 49440 -530 ENG -1409 Jasmine Lane Extension Sewer- 602 - 49480 -530 ENG -1409 Jasmine Lane Extension 602 - 49470 -530 ENG -1443 Baker Street Lift Station Generator 602 - 49473 -530 ENG -1422 CR121 Lift Station Generator Stormwater- 651 - 49900 -300 ENG -1449 MS4SWPPP /Permit Compliance 651 - 49900 -530 ENG -1409 Jasmine Lane Extension Long -Term Debt in Engineer's Budget Water- 601 - 49440 -530 ENG -1436 16th Ave Improvements [2017] 601 - 49430 -530 ENG -1415 SW Trunk Water 601 - 49436 -530 ENG -1410 New Water Tower Sewer- 602 - 49450 -530 602 - 49450 -530 602 - 49480 -418 602 - 49480 -418 602 - 49480 -418 602 - 49480 -530 ENG -1436 16th Ave Improvements [2017] ENG -1445 CBD Alley Improvements 30" Forcemain Repairs - St. Cloud Main Lift Station Improvements - St. Cloud Biosolids Improvements - St. Cloud ENG -1414 SW Trunk Sewer Stormwater- 651 - 49900 -530 ENG -1436 16th Ave Improvements [2017] 80,000.00 80,000.00 47,000.00 47,000.00 1,387,000.00 1,387,000.00 25,000.00 25,225.00 458,545.74 508,770.74 1,387,000.00 1,387,000.00 (3,654.26) 25,000.00 25,225.00 462,200.00 (3,654.26)1 512,425.00 80,000.00 80,000.00 47,000.00 47,000.00 1,387,000.00 1,387,000.00 25,000.00 25,225.00 458,545.74 508,770.74 THIS PAGE INTENTIONALLY LEFT BLANK