The URL can be used to link to this page

Home My WebLink About2014 Audit Management Report CITY OF OAK PARK HEIGHTS, MINNESOTA AUDIT MANAGEMENT LETTER December 31, 2014 To the Honorable Mayor and Members of the City Council City of Oak Park Heights, Minnesota We have completed the 2014 audit of the City of Oak Park Heights, Minnesota and have issued our report thereon. Our Independent Auditor’s Report is included in the City’s Annual Financial Report. This Management Letter provides a summary of audit results along with comparisons and trend analysis of financial results. Thank you for the opportunity to serve the City. We are available to discuss this report with you. REDPATH AND COMPANY, LTD. St. Paul, Minnesota April 13, 2015 City of Oak Park Heights, Minnesota Audit Management Letter Report Summary Report Summary Several reports are issued in conjunction with the audit. A very brief summary is as follows: Report Name Elements of Report Overview Annual Financial Report (AFR) Financial statements Unmodified (“clean”) opinion on the Financial Footnotes Statements Required supplementary information Statistical information Report on Internal Control and on Results of testing No findings of Compliance and Other Matters Internal controls over financial noncompliance reporting Internal control finding Compliance with laws, resulting in a prior period regulations, contracts and adjustment. grants State Legal Compliance Report Results of testing certain No findings of provisions of Minnesota noncompliance Statutes Audit Management LetterIntended to be a working tool for City Council Comparisons and trend analysis Outside factors influencing City financial reporting Policies and procedures 2 City of Oak Park Heights, Minnesota Audit Management Letter Analysis of Selected Accounts A NALYSIS OF S ELECTED A CCOUNTS Summary of Financial Activity The schedule below presents a condensed financial summary of all funds: Increase (Decrease) inFund Balance/ Revenue ExpendituresFund Balance/Net and Otherand OtherTransfersNetPosition FundSourcesUses(Net)Position12/31/14 1General$5,225,915$3,496,073($1,341,406)$388,436$3,902,807 Special Revenue Funds: 2Forfeiture and Seizure6,480506 - 5,97413,304 3Economic Development695 - - 69532,019 4TIF District #1126,129100,6495,04930,52949,860 5TIF District #212372,229(5,049)(377,266)(377,266) Debt Service Funds: 6Bonds of 20082,282422,018420,00026495,495 7Bonds of 2009586138,560139,0001,02620,272 8G.O. CIP Refunding Bonds of 2012A43,380104,758 - (61,378)5,016,684 9Bonds of 2014307,11645,859 - 261,257261,257 Capital Project Funds: 10Capital Revolving378,519598,655(220,136)95,740 11Budgeted Projects and Equipment Revolving36,53385,504469,134420,1631,961,872 12Street Reconstruction3,865,8633,647,8242,660,7962,878,8355,390,440 13City Hall Improvements2,128 - - 2,12897,912 14Park Development15,40654,192 - (38,786)659,673 15Moelter Park13,1735,065(91,500)(83,392)508,221 16Renewal and Replacement98,4045,508(1,576,612)(1,483,716)3,028,138 17Storm Sewer Renewal/Replacement11,024 - (318,063)(307,039)175,946 18Sanitary Sewer Connection 9,139 - - 9,139420,607 19Water Connection9,769 - - 9,769449,596 20Storm Sewer Connection21,016 - - 21,016967,224 21Water Tower Rehabilitation39,176 - 40,47979,655279,168 22Well Rehabilitation2,487 - 9,00611,493132,500 23Sewer Rehabilitation1,035 - 1,9382,97350,872 Enterprise Funds: 24Water1,070,338477,771(242,630)349,9375,401,020 25Sanitary Sewer942,324694,406(166,725)81,1932,963,051 26Storm Sewer85,72446,393(3,417)35,914156,275 27 Total$12,314,653$10,295,970$0$2,018,683$31,752,687 3 City of Oak Park Heights, Minnesota Audit Management Letter Analysis of Selected Accounts Property Taxes A summary of property tax activity for the past five years is as follows: 20102011201220132014 Tax levy certified$3,754,704$3,964,704$4,228,062$4,538,193$4,784,896 Less market value homestead credit deduction(92,249)(93,934) - - - Net levy3,662,4553,870,7704,228,0624,538,1934,784,896 Receipts: Current property taxes3,584,0273,819,2204,176,1254,515,2024,730,342 Delinquent property taxes74,11892,2695,82033,252(176,758) Total receipts3,658,1453,911,4894,181,9454,548,4544,553,584 Adjustments(9,992)(9,361)(28,494)($11,238)($269,979) Increase (decrease) in delinquent taxes receivable(5,682)(50,080)17,623(21,499)(38,667) Delinquent taxes - January 1138,496132,81482,734100,357101,334 Delinquent taxes - December 31$132,814$82,734$100,357$78,858$62,667 Current collection as a percent of current levy97.9%98.7%98.8%99.5%98.9% Total collections as a percent of current levy99.9%101.1%98.9%100.2%95.2% During 2014, the City was notified of property tax abatements. These abatements reduced 2014 property revenue as follows: Current and delinquent tax collections$4,836,243 Payment in lieu of tax73,245 Non-levy collections75 Reduction for property tax abatements(289,042) Total property tax revenue reported in the financial statements$4,620,521 4 City of Oak Park Heights, Minnesota Audit Management Letter Analysis of Selected Accounts Tax Levies, Tax Rates and Tax Capacity A comparison of values for taxes payable in 2011 through 2015 is as follows: 20112012201320142015 Taxable market value$669,938,700$643,608,300$663,496,300$640,880,000$689,680,000 Tax capacity values: Real estate$10,335,277$10,095,639$10,257,139$10,165,672$10,715,786 Personal property92,02390,84095,16895,59089,896 Subtotal10,427,30010,186,47910,352,30710,261,26210,805,682 Tax increment - - (108,254)(126,677)(185,870) Fiscal disparity contribution(2,117,456)(2,336,411)(2,346,765)(2,467,230)(2,214,196) Fiscal disparity distribution508,498405,806392,002386,218415,839 Total$8,818,342$8,255,874$8,289,290$8,053,573$8,821,455 Tax capacity rates45.027 51.710 54.898 59.400 56.803 Tax levy$3,964,704$4,228,062$4,538,193$4,784,896$5,022,731 5 City of Oak Park Heights, Minnesota Audit Management Letter Analysis of Selected Accounts A schedule of tax capacity by classification is as follows: CITY OF OAK PARK HEIGHTS 20132014 Percent ofPercent of AmountCity TotalAmountCity Total Real estate: Agricultural$9360.0% $1,0690.0% Seasonal1,2540.0% 1,2350.0% Residential homestead1,622,04115.7% 1,660,30216.2% Residential nonhomestead1,113,68210.8% 1,173,27811.4% Commercial/industrial3,522,05834.0% 3,418,90233.3% Public utility3,990,89638.6% 3,904,92038.1% Railroad6,2720.1% 5,9660.1% Total real estate10,257,13999.2% 10,165,67299.1% Personal property95,1680.8% 95,5900.9% Total tax capacity$10,352,307100.0% $10,261,262100.0% As shown above, the City’s major tax payer (Xcel Energy) is 40.43% of total tax capacity. Tax Capacity by Property Class -2014 Personal Property 0.9% Public Utility 38.1% Residential Homestead 16.2% Residential Nonhomestead 11.4% Commercial/Industrial 33.4% 6 City of Oak Park Heights, Minnesota Audit Management Letter General Fund G ENERAL F UND The General Fund of the City is maintained to account for expenditures common to all cities (general government, public safety, public works, and parks and recreation). A ten- year history of major revenue sources that support the General Fund are as follows: (1) Property TaxesState AidsAll OtherTotal Revenue YearAmountPercentAmountPercentAmountPercentAmountPercent 20052,218,213 71%78,137 3%819,616 26%3,115,966 100% 20062,423,246 77%92,370 3%633,057 20%3,148,673 100% 20072,687,730 79%181,233 5%547,531 16%3,416,494 100% 20083,156,807 82%120,701 3%592,538 15%3,870,046 100% 20093,134,378 82%249,822 7%439,143 11%3,823,343 100% 20103,305,004 79%180,174 4%673,969 17%4,159,147 100% 20113,583,487 87%75,860 2%468,768 11%4,128,115 100% 20124,245,360 90%69,677 1%423,580 9%4,738,617 100% 20134,433,202 87%86,775 2%568,367 11%5,088,344 100% 20144,620,521 89%79,354 2%481,640 9%5,181,515 100% (1) Since 2010, the General Fund has levied property taxes which have been transferred out to Debt Service Funds. Those levies were $559,000, $548,000, and $536,000 for the years ended December 31, 2014, 2013, and 2012, respectively. Major Revenue Sources -2014 State Aids 2% All Other 11% Property Taxes 87% 7 City of Oak Park Heights, Minnesota Audit Management Letter General Fund A graph of property taxes, state aids, and other revenue for the General Fund is as follows: 4,800,000 4,600,000 4,400,000 General Fund 4,200,000 Revenue by Source 4,000,000 3,800,000 3,600,000 State Aids 3,400,000 3,200,000 All Other 3,000,000 Property Taxes 2,800,000 Property Taxes without Debt 2,600,000 Levy 2,400,000 2,200,000 2,000,000 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400,000 200,000 0 2005200620072008200920102011201220132014 State Aids State aids of the General Fund have consisted of the following for the past seven years: State Aid2008200920102011201220132014 Market value homestead credit$40,625$ - $ - $ - $ - $ - $ - LGA14,028 - - - - - - Police aid60,40469,39258,93063,27861,24270,03176,839 Utility valuation transition aid - 178,390102,947 - - - - Other state revenue5,6442,04018,29712,5828,43516,7442,515 Totals$120,701$249,822$180,174$75,860$69,677$86,775$79,354 Change$129,121($69,648)($104,314)($6,183)$17,098$7,421 % Change107% (28%)(58%)(8%)25% 9% 8 City of Oak Park Heights, Minnesota Audit Management Letter General Fund Other General Fund Revenue Other revenue of the General Fund has consisted of the following for the past seven years: Description2008200920102011201220132104 Licenses and permits$203,041$100,074$197,181$131,081$163,986$90,910$137,543 Charges for services: (2) Enterprise62,04064,40066,42069,4253,8304,1804,248 (3) Construction/engineering fee 2,602 - - - - - Other15,6789,89077,38618,12713,698300,22380,618 Inspections - - - - - - Fines and forfeits63,60270,10258,36557,86255,02351,36056,537 (4) Earnings on investments 90,00455,43950,67541,37836,791(23,982)73,412 (1) Other155,571139,238223,942150,895140,940135,864105,353 Total$592,538$439,143$673,969$468,768$414,268$558,555$457,711 (1) The significant increase in other revenue from 2009 to 2010 occurred because the City received a $73,895 Federal Energy Efficiency and Conservation Block Grant in 2010, which is classified in this category. (2) Beginning in 2012, an administrative fee is charged only to the Storm Sewer Fund. As a result, the transfers from Water and Sewer to the Renewal and Replacement Fund were increased $64,047. Transfers were made in 2014 that were similar to 2013 and 2012. (3) The significant increase in construction/engineering fees from 2012 to 2013 occurred because the City received a $207,600 closing fee when Presbyterian Homes refinanced their conduit debt agreement (4) Earnings on investments is negative in 2013 due to a market value adjustment. Although the City holds its investments to maturity and will receive par value at maturity, accounting standards require the City to report its investments at market value at year-end. The change in market value for 2013 resulted in an adjustment of $185,738. 9 City of Oak Park Heights, Minnesota Audit Management Letter General Fund Budget Versus Actual Comparison The General Fund balance increased by $388,000. Charges for services revenue exceeding budget resulted in higher than anticipated revenue. Expenditures in most City departments were also less than budgeted. A summary is as follows: BudgetActualVariance Revenue$5,177,809$5,181,515$3,706 Expenditures3,833,9363,496,073(337,863) Revenue over expenditures1,343,8731,685,442341,569 Other financing sources (uses): Sale of property - 44,40044,400 Transfers in - 2,4672,467 Transfers out(1,343,873)(1,343,873) - Total other financing sources (uses)(1,343,873)(1,297,006)46,867 Net change in fund balance$0$388,436$388,436 Transfers to other funds for 2014 included the following amounts: FundAmount Capital Revolving Fund$ - Budgeted Projects Fund359,950 Debt Service - 2008 Bonds420,000 Debt Service - 2009 Bonds139,000 Street Reconstruction343,295 Storm Sewer Renewal/Replacement81,628 $1,343,873 10 City of Oak Park Heights, Minnesota Audit Management Letter General Fund General Fund Reserves The fund balance of the General Fund decreased in 2014. The schedule below reflects the General Fund balance for the past fifteen years: Year EndedFundIncrease December 31,Balance(Decrease) 2000$1,280,101$1,280,101 20011,173,118(106,983) 20021,329,229156,111 20031,694,611365,382 20041,847,608152,997 20052,103,743256,135 20062,302,502198,759 20072,515,620213,118 20082,616,370100,750 20092,720,012103,642 20102,973,797253,785 20113,261,561287,764 20123,669,633408,072 20133,514,371(155,262) 20143,902,807388,436 11 City of Oak Park Heights, Minnesota Audit Management Letter General Fund $4,500,000 $4,000,000 $3,500,000 $3,000,000 Actual Fund Balance Minimum Fund $2,500,000 Balance per policy $2,000,000 $1,500,000 $1,000,000 $500,000 $0 200020012002200320042005200620072008200920102011201220132014 Reserve balances are an important component of City financial management. When evaluating the adequacy of reserve balances, there are a number of important factors that must be considered. Several areas to consider are illustrated as follows: Need for Reserve Balances Benefits of Reserve Balances Cash Flow Timing Favorable bond rating Supplements revenues Difference indicatorwith investment income Intergovernmental Capital Outlay Revenue Cutbacks Replacement Avoids temporary Provides resources for overdrafts prior to major minor projects or receipts feasibility reports Avoids overburdening Provides the City of annual budgets for greater options to deal Emergency or certain capital outlay Special with unexpected events Unanticipated Projects Expenditures 12 City of Oak Park Heights, Minnesota Audit Management Letter General Fund The City’s current fund balance policy was adopted on November 15, 2011. The purpose of the policy is to establish appropriate fund balance levels for each fund that is primarily supported by property tax revenues or user fees. The City’s fund balance policy states the City will maintain funds for the following: Compensated absences Cash flow Contingencies The compensated absences reserve is an amount equal to 50% of accumulated vacation leave and 100% of that portion of sick leave that would be payable under the City’s severance pay policy. Assigned Fund Balance For Employee Benefits December 31, Employee Benefit20132014 Vacation leave carryover (50%)$42,206$48,174 Severance130,507110,423 Total$172,713$158,597 Rounded amount$159,000 13 City of Oak Park Heights, Minnesota Audit Management Letter General Fund Cash Flow Reserve Property taxes and related state aids have accounted for 80% to 85% of the revenue of the General Fund in recent years. Property taxes and the majority of state aid are not received until July and December of each year (i.e., the second half of the year). As a result, the City is required to have sufficient reserves at the beginning of the year to fund operations of the first half of the year. The City’s fund balance policy states that its cash flow reserve should be equal to 45-55% of the subsequent year’s budgeted operating expenditures. The recommended cash flow reserve is $2,293,000, computed as follows: Cash Flow Reserve 2014 tax levy $5,022,731 Less transfers out which occur after taxes are received(437,600) $4,585,131 Reserve amount @ 50%$2,293,000 14 City of Oak Park Heights, Minnesota Audit Management Letter General Fund The following graph of monthly General Fund cash balances illustrates the impact of receiving property taxes and state aids in the second half of the year: $3,800,000 General Fund Monthly Cash Balances $3,600,000 $3,400,000 $3,200,000 $3,000,000 $2,800,000 $2,122,000 $2,600,000 decrease $2,400,000 $2,200,000 $2,000,000 $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 12/31/20131/31/20142/28/20143/31/20144/30/20145/31/20146/30/20147/31/20148/31/20149/30/201410/31/201411/30/201412/31/2014 Cash$3,643,812$3,525,620$3,166,575$2,881,463$2,635,502$2,384,541$1,522,155$3,009,558$2,783,340$2,590,328$2,407,195$2,144,213$3,455,566 As shown above, the cash balance decreased $2,122,000 between January 1 and June 30, illustrating the need for the cash flow reserve. 15 City of Oak Park Heights, Minnesota Audit Management Letter General Fund General Contingency Reserve The amount of General Fund reserve required to meet emergency and/or unanticipated expenditures is not readily quantifiable. Rather, the level of this requirement must be established by the City based on the history of the City and the philosophy of "adequate" reserve coverage. The City’s fund balance policy states this amount should be 10-15% of the subsequent year’s General Fund budgeted expenditures, computed as follows: General Contingency Reserve December 31, Description20132014 Ensuing year's budget$5,177,809$5,401,999 Reserve amount @ 15%$777,000$810,000 16 City of Oak Park Heights, Minnesota Audit Management Letter General Fund General Fund Balance Summary In summary, the fund balance of the General Fund at December 31, 2014, was as follows: General Fund Balance ConstraintDecember 31, 20132014 Nonspendable: Prepaid items$5,201$80,806 Assigned for: Employee benefits173,000159,000 Unassigned: Cash flow reserve2,125,0002,293,000 General contingency reserve777,000810,000 Remaining balance434,170560,001 Subtotal - unassigned3,336,1703,663,001 Total fund balance$3,514,371$3,902,807 17 City of Oak Park Heights, Minnesota Audit Management Letter Special Revenue Funds S PECIAL R EVENUE F UNDS Special Revenue Funds are a classification of funds to account for revenues (and expenditures related thereto) segregated by City policy, Federal or State statutes for specific purposes. The City maintained three Special Revenue Funds during 2014. Forfeiture and Seizure Fund This fund was established in 1991 to account for property forfeited pursuant to MS 609.531. A summary of the financial activity of this fund from inception is as follows: Prior Years2014Total Revenue: Intergovernmental - bulletproof vests$9,825$ - $9,825 Earnings on investments16,23413216,366 Reimbursements8,601 - 8,601 Confiscated property173,1906,348179,538 Sale of municipal property5,046 - 5,046 Total revenue$212,896$6,480219,376 Expenditures: Public safety: Materials and supplies$76,604$ - $76,604 Contractual services27,84650628,352 Capital outlay101,116 - 101,116 Total expenditures$205,566$506206,072 Fund balance - December 31, 2014$13,304 The use of these funds is restricted by MS 609.531 subd. 5 to "supplement the agency's operating fund or similar fund for use in law enforcement." 18 City of Oak Park Heights, Minnesota Audit Management Letter Special Revenue Funds Economic Development Fund This fund was established in 1998 to account for the activity of the Oak Park Heights Economic Development Authority. A summary of the financial activity of this fund is as follows: Prior Years2014Total Revenue: Earnings on investments$35,294$695$35,989 Interfund loan interest1,113 - 1,113 Refunds and reimbursements2,531 - 2,531 Sale of municipal property76 - 76 Transfer from Capital Revolving Fund410,000 - 410,000 Total revenue$449,014$695449,709 Expenditures: Community development: Materials and supplies$645$ - 645 Contractual services45,914 - 45,914 Interfund loan interest70,000 - 70,000 Capital outlay290,018 - 290,018 Transfer to Capital Revolving Fund11,113 - 11,113 Total expenditures$417,690$0417,690 Fund balance - December 31, 2014$32,019 During 1998, the City purchased the Bell property and demolished the building in 1999. In prior years, this fund had a deficit that was funded by a $260,000 interfund loan from the Capital Revolving Fund. This fund did not have the resources to repay the interfund loan. Therefore, the interfund loan was forgiven. If a sale of the Bell property occurs, the proceeds should be receipted in the Capital Revolving Fund. During 2010, the City purchased property on Osgood Avenue, with the intent to resell the property. The purchase was funded by a $150,000 transfer from the Capital Revolving Fund. 19 City of Oak Park Heights, Minnesota Audit Management Letter Special Revenue Funds This was not a loan from the Capital Revolving Fund, but the intent is to transfer back sales proceeds to the Capital Revolving Fund once the property is sold. TIF District #1 Fund This fund was established in 2012 to account for Tax Increment District 1-1 (Oakgreen Commons). A summary of the financial activity of this fund from inception is as follows: Prior Years2014Total Revenue: Tax increment$133,507$125,120$258,627 Investment income(720)1,009289 Total revenue$132,787$126,129258,916 Expenditures: General government: TIF note payment$112,371$100,399212,770 Other 1,0852501,335 Total expenditures$113,456$100,649214,105 Other financing sources Transfers in$0$5,0495,049 Fund balance - December 31, 2014$49,860 The City issued a TIF Note in the principal sum of $1,200,000. The TIF Note is payable solely from “available” tax increment revenue. Available tax increment revenue is an amount equal to 80% of tax increment revenue received by the City. The City has no obligation on the note after February 21, 2026. 20 City of Oak Park Heights, Minnesota Audit Management Letter Special Revenue Funds TIF District #2 Fund This fund was established in 2014. A summary of the financial activity is as follows: Total Revenue: Investment income$12 Expenditures: Land purchase341,710 Other 30,519 Total expenditures372,229 Other financing uses: Transfer to TIF #1(5,049) Fund balance - December 31, 2014($377,266) The fund deficit was financed by an internal loan form the General Fund. 21 City of Oak Park Heights, Minnesota Audit Management Letter Debt Service Funds D EBT S ERVICE F UNDS Debt Service Funds are a type of governmental fund to account for the accumulation of resources for the payment of interest and principal on debt (other than Enterprise Fund debt). The City maintained three Debt Service Funds during 2014. 22 City of Oak Park Heights, Minnesota Audit Management Letter Debt Service Funds Capital Improvement Bonds of 2008/2012A The bond was issued to finance construction of City Hall. The repayment of the bond issue is being funded by property tax levies. Taxes for 2009-2011 were levied in the Debt Service Fund. A $410,000 property tax was levied in the General Fund for 2013 and was transferred into the Debt Service Fund. In 2012, the Crossover Refunding Bonds of 2012A were issued to refund the 2008 Bonds on December 15, 2016. The refunding resulted in a debt service savings of $404,000. A schedule of actual and projected tax levies (per the bond resolution) and debt payments are as follows: Cash and CurrentTotalCash and Current Assets BalancePropertyBondInvestmentProjectedDebtAssets Balance YearJanuary 1TaxesProceedsInterestReceiptsPaymentsDecember 31 2008$ - $ - $242,303$7,457$249,760$122,513$127,247 2009127,247336,292 - 3,250339,542380,02586,764 201086,764392,805 - 1,656394,461391,65089,575 201189,575400,902 - 1,556402,458392,52599,508 201299,508400,0005,191,2835,1975,596,480403,0305,292,958 20135,292,958410,000 - (7,988)402,012521,6775,173,293 20145,173,293420,000 - 45,662465,662526,7765,112,179 20155,112,179430,000 - 25,475455,475535,1765,032,478 20165,032,478440,000 - 23,070463,0705,402,75892,790 201792,790410,000 - 675410,675409,75893,707 201893,707420,000 - 696420,696418,65895,745 201995,745430,000 - 721430,721432,25894,208 202094,208440,000 - 735440,735445,45889,485 202189,485460,000 - 734460,734458,25891,961 202291,961475,000 - 763475,763470,65897,066 202397,066490,000 - 814490,814492,65895,222 202495,222505,000 - 833505,833509,05891,997 202591,997520,000 - 853520,853539,95872,892 202672,892535,000 - 787535,787560,05848,621 202748,621550,000 - 687550,687569,29430,014 202830,014575,000 - 632575,632597,5768,070 Total$9,039,999$5,433,586$114,265$14,587,850$14,579,780 Assumptions Property tax collection rate.....................................100% Investment interest rate...........................................0.50% Negative interest charged to funds?.....................no 23 City of Oak Park Heights, Minnesota Audit Management Letter Debt Service Funds Capital Improvement Bonds of 2009 The bond was issued as additional financing for construction of City Hall. The repayment of the bond is being funded by property tax levies. Taxes are levied in the General Fund and then transferred into the Debt Service Fund. A schedule of actual and projected tax levies (per the bond resolution) and debt payments are as follows: Cash and CurrentTransfers/TotalCash and Current Assets BalancePropertyBondInvestmentProjectedDebtAssets Balance YearJanuary 1TaxesProceedsInterestReceiptsPaymentsDecember 31 2009$ - $ - $21,582$1,357$22,939$7,588$15,351 201015,351122,000 - 720122,720130,3507,721 20117,721134,000 - 492134,492129,15013,063 201213,063136,000 - 460136,460132,65016,873 201316,873138,000 - 133138,133135,76019,246 201419,246139,000 - 586139,586138,56020,272 201520,272140,000 - 383140,383140,85819,797 201619,797142,000 - 390142,390142,67819,509 201719,509143,000 - 397143,397144,11418,792 201818,792144,000 - 398144,398150,08413,106 201913,106145,000 - 351145,351155,3263,131 Total$1,383,000$21,582$6,130$1,410,712$1,407,118 Assumptions Property tax collection rate................................100% Investment interest rate....................................1.00% Negative interest charged to funds?..................no 24 City of Oak Park Heights, Minnesota Audit Management Letter Capital Project Funds C APITAL P ROJECT F UNDS A summary of the financial activity of the Capital Project Funds for the year ended December 31, 2014 is as follows: Increase inFund InterfundFundBalance FundRevenuesExpendituresTransfersBalance12/31/2014Comments Expenditures relate to Hwy 36 Bridge Project. Capital Revolving$378,519$598,655$ - ($220,136)$95,740 Received transfers from General, Water, Sewer, and Budgeted Projects and Equipment Revolving36,53385,504469,134420,1631,961,872Storm Sewer funds. Received majority of transfers from Renewal and Replacement fund. Expenditures relate to 2014-2015 Street Reconstruction Street Reconstruction3,865,8633,647,8242,660,7962,878,8355,390,440 City Hall Improvements2,128 - - 2,12897,912Accounted for construction of city hall. Park Development15,40654,192 - (38,786)659,673 Moelter Park13,1735,065(91,500)(83,392)508,221Transfer to Street Reconstruction fund. Receives annual transfer from Water and Sewer. Majority of transfers out were to the Street Reconstruction fund. Renewal and Replacement98,4045,508(1,576,612)(1,483,716)3,028,138 Received transfer from General Fund. Transfers Storm Sewer Renewal/Replacement11,024 - (318,063)(307,039)175,946made to Street Reconstruction fund. Sanitary Sewer Connection 9,139 - - 9,139420,607 Water Connection9,769 - - 9,769449,596 Storm Sewer Connection21,016 - - 21,016967,224 Received transfer from Water fund. Water Tower Rehabilitation39,176 - 40,47979,655279,168 Well Rehabilitation2,487 - 9,00611,493132,500Received transfer from Water fund. Received transfer from Sewer fund. Sewer Rehabilitation1,035 - 1,9382,97350,872 Totals$4,503,672$4,396,748$1,195,178$1,302,102$14,217,909 25 City of Oak Park Heights, Minnesota Audit Management Letter Capital Project Funds Budgeted Projects and Equipment Revolving Fund The Budgeted Projects and Equipment Revolving Fund (formerly Capital Improvements Fund) was established in 1978 to account for monies set aside for various capital improvements. This fund is budgeted annually by the City Council in conjunction with the City's budget process. As part of such process, the City allocates the monies in this fund to specific projects and/or programs. Such allocation/designations were as follows at December 31, 2014: FundRevenuesFund BalanceandBalance Purpose12/31/13TransfersExpenditures12/31/14 1Sealcoat/crack seal$144,650$100,000$63,048$181,602 2Outdoor storage - - - - 3Municipal building241,61215,000 - 256,612 4Recreation: - - 5 Park and trail improvements104,57670,000 - 174,576 6 Trail maintenance74,30010,000 - 84,300 7 Park building maintenance67,00050,000 - 117,000 8 Brekke Park memorial fund394 - 394 9Computers42,38521,70011,71952,366 10Document imaging - - - - 11Vehicles: 12 Police93,38332,500 - 125,883 13 Public works124,58328,334 - 152,917 14 Building official238 - - 238 15Furniture and equipment: - 16 General - - - 17 Building inspections - - - - 18 Police 346 - - 346 19Trees95,70910,73784,972 20Emerald ash borer80,00040,000 - 120,000 21Public works equipment166,13553,000 - 219,135 22Police radio equipment35,0803,000 - 38,080 23Police computer equipment10,1265,000 - 15,126 24Police in-squad video systems - - - - 25Computer software - 7,500 - 7,500 26Comprehensive plan - - - - 27Coalition of utility cities16,000 - - 16,000 28Civil defense16,000 - - 16,000 29Software - - - - 30Meter change out66,10026,100 - 92,200 31Generator replacement - 7,000 - 7,000 32Unallocated163,09236,533 - 199,625 33Totals$1,541,709$505,667$85,504$1,961,872 26 City of Oak Park Heights, Minnesota Audit Management Letter Enterprise Funds E NTERPRISE F UNDS Enterprise funds account for water, sanitary sewer and storm sewer operations. Water Utility Fund A chart of income from operations for the past seven years is as follows: $800,000 Water Operating Revenue & Expense $700,000 $600,000 $500,000 Depreciation Transfer Out All Other Expenses $400,000 Contractual Services Personal Services Operating Revenue $300,000 $200,000 $100,000 $0 2008200920102011201220132014 27 City of Oak Park Heights, Minnesota Audit Management Letter Enterprise Funds Sewer Utility Fund A chart of income from operations for the past seven years is as follows: $1,000,000 Sewer Operating Revenue & Expense $900,000 $800,000 $700,000 Depreciation $600,000 Transfer Out Personal Services $500,000 All Other Expenses MCES $400,000 Operating Revenue $300,000 $200,000 $100,000 $0 2008200920102011201220132014 28 City of Oak Park Heights, Minnesota Audit Management Letter Enterprise Funds The City’s water and sewer rates for the past seven years are as follows: Monthly RateQuarterly Rate EffectiveEffectiveEffectiveEffectiveEffectiveEffectiveEffectiveEffective Type of Charge01/01/0801/01/0907/01/0901/01/1001/01/1101/01/1201/01/1301/01/14 Water: Base fee$24.35$26.24$28.31$28.31$29.91$30.70$30.70$30.70 Charge per 1,000 gallons for: Usage between 15,000 and 50,000 gallons$1.62$1.78$1.96$1.96$2.48$2.55$2.55$2.55 Usage between 50,000 and 99,000 gallons$2.22$2.44$2.68$2.68$2.97$3.05$3.05$3.05 Usage between 99,000 and 200,000 gallons$2.67$2.94$3.23$3.23$3.81$3.92$3.92$3.92 Usage in excess of 200,000 gallons$2.67$2.94$3.23$3.91$4.61$4.74$4.74$4.74 Sewer: Base fee$49.95$51.70$54.28$56.99$60.41$62.10$66.00$66.00 Charge per 1,000 gallons for: Usage between 15,000 and 50,000 gallons$3.40$3.52$3.70$4.07$4.31$4.43$4.60$4.80 Usage in excess of 50,000 gallons$3.40$3.52$3.70$4.50$4.77$4.90$4.90$5.20 29 City of Oak Park Heights, Minnesota Audit Management Letter Enterprise Funds Storm Sewer Utility Fund The City created the stormwater utility during 1999. A monthly fee (effective October 1, 1999) was established at $1 per household and $10 per acre for commercial properties. The fee for vacant residential property is 50 cents per month and undeveloped commercial property is $1.50 an acre per month. A chart of income from operation for the past seven years is as follows: $100,000 Storm Sewer Operating Revenue & Expense $90,000 $80,000 $70,000 $60,000 Transfer Out All Other Expenses Contractual Services $50,000 Personal Services Operating Revenue $40,000 $30,000 $20,000 $10,000 $0 2008200920102011201220132014 30 City of Oak Park Heights, Minnesota Audit Management Letter Communication With Those Charged With Governance C OMMUNICATION W ITH T HOSE C HARGED W ITH G OVERNANCE We have audited the financial statements of the governmental activities, the business- type activities, each major fund, and the aggregate remaining fund information of the City of Oak Park Heights, Minnesota (the City) for the year ended December 31, 2014. Professional standards require that we provide you with information about our responsibilities under generally accepted auditing standards and the standards applicable to financial audits contained in Government Auditing Standards, as well as certain information related to the planned scope and timing of our audit. We have communicated such information in our letter to you dated December 11, 2014. Professional standards also require that we communicate to you the following information related to our audit. Qualitative Aspects of Accounting Practices Management is responsible for the selection and use of appropriate accounting policies. The significant accounting policies used by the City are described in Note 1 to the financial statements. No new accounting policies were adopted and the application of existing policies were changed to reflect the reporting of prepaid insurance. We noted no transactions entered into by the City during the year for which there is a lack of authoritative guidance or consensus. All significant transactions have been recognized in the financial statements in the proper period. Accounting estimates are an integral part of the financial statements prepared by management and are based on management’s knowledge and experience about past and current events and assumptions about future events. Certain accounting estimates are particularly sensitive because of their significance to the financial statements and because of the possibility that future events affecting them may differ significantly from those expected. 31 City of Oak Park Heights, Minnesota Audit Management Letter Communication With Those Charged With Governance The most sensitive estimates affecting the financial statements were management’s estimation of 1) the market value of the City’s land held for resale; 2) the factors relating to the net OPEB obligation and, 3) the revenue recognition of MNDOT assistance relating to the bridge project. We evaluated the key factors and assumptions used to develop these estimates in determining that they are reasonable in relation to the financial statements taken as a whole. The City has several agreements with the State that details the financial assistance to be provided to the City of Oak Park Heights relating to the Bridge Project. The revenue recognition of this financial assistance has been delayed pending receipt of revenue. Certain financial statement disclosures are particularly sensitive because of their significance to financial statement users. The most sensitive disclosure affecting the financial statements pertained to the City’s commitment to relocate portions of its utility infrastructure along Highway 36 (Note 10A). The disclosures in the financial statements are neutral, consistent, and clear. Difficulties Encountered in Performing the Audit We encountered no difficulties in dealing with management in performing and completing our audit. Corrected and Uncorrected Misstatements Professional standards require us to accumulate all known and likely misstatements identified during the audit, other than those that are clearly trivial, and communicate them to the appropriate level of management. There were no uncorrected misstatements that have an effect on our opinion on the financial statements. In addition, none of the misstatements detected as a result of audit procedures were material, either individually or in the aggregate, to each opinion unit’s financial statements taken as a whole. 32 City of Oak Park Heights, Minnesota Audit Management Letter Communication With Those Charged With Governance Disagreements with Management For purposes of this letter, a disagreement with management is a financial accounting, reporting, or auditing matter, whether or not resolved to our satisfaction, that could be significant to the financial statements or the auditor’s report. We are pleased to report that no such disagreements arose during the course of our audit. Management Representations We have requested certain representations from management that are included in the management representation letter dated April 13, 2015. Management Consultations with Other Independent Accountants In some cases, management may decide to consult with other accountants about auditing and accounting matters, similar to obtaining a “second opinion” on certain situations. If a consultation involves application of an accounting principle to the governmental unit’s financial statements or a determination of the type of auditor’s opinion that may be expressed on those statements, our professional standards require the consulting accountant to check with us to determine that the consultant has all the relevant facts. To our knowledge, there were no such consultations with other accountants. Other Audit Findings or Issues We generally discuss a variety of matters, including the application of accounting principles and auditing standards, with management each year prior to retention as the governmental unit’s auditors. However, these discussions occurred in the normal course of our professional relationship and our responses were not a condition to our retention. 33 City of Oak Park Heights, Minnesota Audit Management Letter Communication With Those Charged With Governance Other Information in Documents Containing Audited Financial Statements With respect to the supplementary information accompanying the financial statements, we made certain inquiries of management and evaluated the form, content, and methods of preparing the information to determine that the information complies with accounting principles generally accepted in the United States of America, the method of preparing it has not changed from the prior period, and the information is appropriate and complete in relation to our audit of the financial statements. We compared and reconciled the supplementary information to the underlying accounting records used to prepare the financial statements or to the financial statements themselves. Closing This information is intended solely for the information and use of the City Council and Management of the City of Oak Park Heights, Minnesota and is not intended to be, and should not be, used by anyone other than these specified parties. 34