Loading...
9.a) Uptown Sewer System Master Plan, Part 3 � � � � � � � • Mr. Brian Malm, P.E. June 23, 2011 � Page 4 � Abandoned Drain Field Adjacent to Community Buildin�.= � � One soil boring(SB-12)was partially completed on the south side of a drain field that is no longer being used. The upper 14 inches is asswned to be fill material based on mixed textures � and colors of the soil material. The soil boring ended at 29 inches due to cobbles or rocks. � Redoximarphic features began at about tlle 23 inch depth. Slope was nearly flat. The soils map of this area indicates this area was a gravel pit, at least at the time of mapping. The area has been � reclaimed and consequently the limited-depth soil profile observed may not reflect a natural soil � profile. � The following table provides a overview of the soil properties observed at the 12 soil boring sites � and highlights depth to redoximorphic features and other soil properties. � Table 1 —Summary of'Soil Properties Observed � Soil Depth to Notes � 13oring Redoximorphic � Features (inches) � SB-1 32 Saturation in 32-36"zone. SB-2 34 Very wct pro(ilc from 34 to 62". � SB-3 18 Band of clay loam at 22 to 30". � SB-4 26 Wet profile starting at 24"with water in bore hole at � 55"; silty& clayey sediments below 55"(lacustrine). SB-5 15 Very fine textured sediments below 31"(lacustrine). � SB-6 22 Clay loam, sandy clay loain band at 26 to 36". � SB-7 12 Upper 23" is fill material—landscaping? � SB-8 16 Claycy textures begin at l5"; wet profile from 32-36"; clay band from 36 to 38"w/stratified sands below 38". � SB-9 30 Clay bands at 15-25"and below 36"; saturation � between 25-36". SB-10 30 Clay bands at I 5-25"and below 36"; saturated, � stratified sand, clay& silt bands between 25-62". � SB-1 I 13 Sediments are stratified below 20"witll some � saturation within bands. SB-12 23 Up}�er 14"appears to be fill. Old reclaimed gravel pit? � � � ` � � � � � � � I � I � I � I� � � ' • Mr. Brian Malm, P.E. ', • June 23,2011 Page 5 � • Conclusions and Recommendations � The soils observed on June 1,2011 indicate a zone of seasonal saturation nearer to the soil � surface than indicated by the description of Demontreville soils in the Washington County soil survey. Redoximorphic features in the soils observed ranged i�l depth from about 13 to 34 inches � below the soil surface. Minnesota subsurface sewage treatment rules require specific separation � distances from the bottom of the distribution system to redoximorphic features. Combining a precursory observation of the depth to the bottom of soine drain field pipes (approximately 12 to � 24 inches deep)and measured depths to redoxi�norphic features in the soils, it is my opinion that � the required separation distance for this type of sewage treatment system cannot be met at the existing drain field site. Final detern�ination of compliance to all required rules will be based on � this soils report and other data about the existing septic system that you have collected and � analyzed. � The potential expansion area has indications of seasonal wemess in the soil profile that could � present a challenge to using the area for a larger-sized soil absorption treatment site. The � presence of clay bands of varying thickness are likely infltiencing the downward�novement of soil water and creating the redoxi�norphic features obseived. Overcoining these limitations of • periodic saturation and very high clay content soils would likely require a pressurized mound design with very narrow rock beds (low loading rates per sqL�are foot) which would require a � larger area than that investigated. Using hand tools was somewhat limiting in gathering soils � data to 4 or 5 feet in depth in the Scandia acea due to tl�e nature of the soil materials. Therefore, � additional soil investigations utilizing a backhoe are recommended to fully characterize the soils to a greater depth within any area proposed for any new soil absorption system serving t17e Town � of Scandia. � Thank you for the opportunity to provide you with soils data for this project. Please contact me � if you have any questions. � Sincerely, i ���,.{�,� � Terry L. Bovee, P.S.S. � MN Soil Scientist License#30269 � MN SSTS License#L3043 620 Ridge Road � Hendei-son, MN 56044 � 507-248-9626 � Attachment � � � � � � � � � � � � � � � � � � � + � � � � � i ! i • • � • • • • • • • • a i • • • • � • • • • • . � i • • • ! • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • • SOILS LOG DATE: June 1, 2011 JOB: Scandia Municipal Drainfield LOCATION: Sec 23, T.32 N., R.20 W., Washington County Site, Stake or Pit# : SB-1 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-10 10YR3/2 Sandy loam 2fsbk vfr Thin gravelly band from 9 to 10" 10-20 7.SYR3/4 Loamy lfsbk vfr sand 2-32 7.SYR4/4 Sandy loam lmsbk vfr Thin gravelly band from 19 to 20" 32-36 7.SYR4/4 Sandy loam 1 msbk fr fl d 7.SYR4/2 & 32" Soil is saturated in portions of this SYR4/4 horizon 36-57 SYR4/4 Sandy loam lmsbk fr fZd 7.SYR4/2 Dense till — slight stratification of Sandy clay textures loam 57-62 SYR4/4 Sandy clay Massive fi c2d 7.SYR4/2 Dense till loam nll colors are mois[Munscll notation unlcss odierwisc stated 11I notation,u�ed are found in"Field 13ook for Sampline and Describin<_Soils,Version?0"—USDA-NRCS,2002 Remarks: 1. Clearsky 2. Used a 3" dia. bucket auger for all soil borings due to gravelly bands. 3. Slope shape = linear/linear, �2% slope TERRY L. BOVEE, PROFESSIONAL SOIL SC[ENT[ST: I hereby certify that this plan,document,or report was prepared by me or unde r my direct supervision and that I am a duly licensed Professional Soil Scientist under the laws of thc State of Minnesota. Print name: Terrv L. Bovee Signature: �� � Date:June 10,201 1 License#30269 � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � DATE: June 1, 2011 JOB: Scandia Municipal Drainfield LOCATION: Sec 23, T.32 N., R.20 W., Washington County Site, Stake or Pit# : SB-2 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-3 10YR3/2 Loan1 lfsbk vfr 3-10 IOYR3/3 Sandy loam lfsbk vfr 10-18 10YR4/3 Sandy loam 2fsbk vfr 18-34 7.SYR3/4 Loamy sand 1 fsbk vfr 34-36 7.SYR4/4 Loamy sand lcsbk fr fld 7.SYR4/2 34" see Note 2 36-42 7.SYR4/4 Sandy loam lcsbk fr fld 7.SYR4/2 see Note 2 42-48 SYR4/4 Sandy clay massive fi fld 7.SYR4/2 see Note 2 loam 48-62 SYR4/4 Sand, loamy Single loose fld 7.SYR4/2 see Note 2 sand grained :AIl colors are muist Mun;ell notation unless othern�isc stated All notations used are fbund in"Field[3ook for Sampline and Describin�Soils.Version 2.0"—USDA-NRCS,3002 Remarks: 1. Slope shape = linear/linear, �2-3% slope 2. Soil is nearly saturated; perform `pat' test and free water comes to surface of sample. TERRY L. BOVEE, PROFESSIONAL SOIL SCIENTIST: I hereby certify that this plan,document,or report was prepared by me or unde r my direct super�ision and that I am a duly licensed Professional Soil Scientist under the laws of the State of Minnesota. Print name: Terrv L. BoveeSignature_ ��., -- Date: June 10,2011 License#30269 � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � i • • • • • • # • � � � � � � � � � � � � � � � ` � � � � � � � � � � � � � � � � � � ` � � � � � � � � � DATE: June l, 20ll JOB: Scandia Municipal Drainfield LOCAT[ON: Sec 23, T.32 N., R.20 W., Washington County Site, Stake or Pit# : SB-3 Depth Matrix Texture Structure Consist. Redox or otller Depth to Notes (inches) Color features Redox 0-5 l 0YR3/2 Loam 1 fsbk vfr 5-10 10YR3/3 Sandy loam lmsbk vfr 10-18 IOYR4/3 Sandy loam 2msbk fr 18-22 7.SYR3/4 Loani lfpl vfr fld 7.SYR4/2 18" 22-30 7.�YR4/4 Clay loam lcsbk fi f2d 7.SYR4/2 Saturated through this horizon; till has >18% clay content 30-36 �YR4/4 Sandy clay Massive fi f2d 7.SYR4/2 Dense till loam 36-60 SYR4/4 Sand, Single loose fld 7.SYR4/2 Loamy sand component contains loamy sand grained >10% gravel & cobble-sized coarse fragments all colors are moist Munsell notation unless othen��ise stated 111 nutations used�re found in"Ficld Book for Samplim,and Describine Soils,Version 2.0"—USDA-NRCS,3002 Remarks: 1. Slope shape= linear/linear,�3-4% TERRY L. BOVEE, PROFESSIONAL SOI L SCIENTIST: I hereby certify that this plan,document,or report was prepared by me or unde r my direct supervision and that I am a duly licensed Professional Soil Scicntist under the laws of the State of Minnesota. Print name: Tercv L. Bovee �lJ.�✓'l���J�� Signature: � � Date: June 10,2011 License#30269 � l � a • • • • • • • • • • • • ! • • S • � � • • • • • • i • • • • • • • r • i � • i • DATE: June 1, 2011 JOB: Scandia Municipal Draintield LOC�TION: Sec 23, T.32 N., R.20 W., Washington County Site, Stake or Pit# : SB-4 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-5 10YR3/2 Sandy loam lfsbk vfr 5-10 10YR3/3 Loamy sand 1 fsbk vfr 10-17 10YR4/3 Gravelly lfsbk vfr loamy sand 17-24 10YR4/3 Sandy Ioa1n 2msbk vfr 24-38 7.SYR3/4 Loam, sandy lcsbk fr fld 7.SYR4/2 26" Wetness in pores and on ped faces I loam I 38-55 7.SYR4/4 Loamy sand lesbk vfr c2d 7.SYR4/2 & Wetness in pores and on ped faces; '� 7.SYR5/6 Water in bore hole at 55" �� ��-62 7.�YR4/4 Silt loam, silty massive fi fld 7.�YR4/2 Lacustrine sediments �'� cla loam \II colors are moi,t Ntun,ell notation wiless othencise s[ated 111 notations used are found in"Field[3ook for Sampline and Describino Soil,,Version 2.0" -USDA-NRCS 3002 Remarks: 1. Slope shape = convex vertically, linear horizontally; �3-4% slope TERRY L. BOVEE, PROFESSIONAL SOIL SCIENTIST: I hereby certify that this plan,document,or report was prepa red by me or under my direct supervision and that 1 am a duly licensed Professional Soil Scientist under the laws of the State of Minnesota. Print name: Terrv L. Bovee ��1�J t Signature: Date:June 10,201 1 License#30269 � i • • • ! • • • • • • • • � • • • • • � � • • i • • r • • • • • • • • • • • • � • • • � � • • • • • • � • • • • • • • • a • • • • • • • i • • • • • • • • • • • • • • � • s • DATE: June 1, 2011 JOB: Scandia Municipal Drainfield LOCATION: Sec 23, T.32 N., R.20 W., Washington County Site, Stake or Pit# : SB-5 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-8 l 0YR3/2 Sandy loam 1 fsbk vfr 8-13 10YR4/3 Loam 2msbk fr 13-18 7.SYR3/4 Loam, sandy Imsbk fr fld 7.SYR4/2 15" clay loam 18-22 7.5YR4/4 Sandy clay Icsbk fr fld 7.SYR4/2 loam 22-31 SYR3/4 Loau�, sandy lcsbk fr fld 7.SYR4/2 clay loam 31-42 �YR4/4 silty clay massive fi fld 7.SYR4/2 & Lacustrine sediments loam, cla 7.SYR5/6 VI colors are moi;t�7unsell not3tion unless otherwise stated VI notations used are found in"Field[3ook for Samnline and Describin�Soils,Version 2.0"—USDA-NRCS,2002 Remarks: L Slope shape =convex vertically, linear horizontally; �3-4% slope 2. No pore water evident in this profile. 3. End of boring at 42". TERRY L. BOVEE, PROFESSIONAL SOIL SC[ENTIST: I hereby ccrtify that this plan,document,or report was prepared by me or under my direct supervision and that I am a duly licensed Professional Soil Scientist under the laws of the State of Minnesota. Print name: Terrv L. Bovee '`�C.a.._,�._.6�.>-- Signaturc: Date:June l0,201 1 License#30269 � � � � � � � � � � � � � � � � � � � � � � � � � � � � � , � � � � � � � � � � � � � � D�TE: June 1, 2011 JOB: Scandia Municipal Drainfield LOCATION: Sec 23, T.32 N., R.20 W., Washington County Site, Stake or Pit# : SB-6 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-4 10YR4/3 Loamy sand lfsbk vfr 4-12 10YR4/4 Loamy sand 1 fsbk vfr 12-I S l 0YR4/4 Gravelly l fsbk vfr �I S% coarse fragments loamy sand 15-22 7.SYR3/4 Sandy loam lmsbk fr 22-26 7.SYR3/4 Loam lcsbk fr fld 7.SYR4/2 22" 26-36 7.SYR4/4 Clay loam, massive fi c2d 7.�YR4/2 & sandy clay SYR4/4 loam 36-40 7.�YR4/4 Sandy loam massive fr fld 7.SYR4/2 nll colors�re moist Munsell notation unless otherti�ise stated � ;AII notations used are(ound in"Field E3ook for Samnline and Describine Soils,Version 2.0"- USUA-NRCS,2002 � Remarks: I 1. Slope shape =convex vertically, linear horizontally; �4-5% slope. '�, 2. Boring ended at 40" due to gravel layer TERRY L. BOVEE, PROFESSIONAL SOIL SCIENTIST: I hereby certify that this plan,document,or report was prepared by me or unde r my direct supervision and that [am a duly licensed Professional Soil Scientist under the laws of the Statc of Minnesota. Print name: Terrv L. Bovee - \ �(�( ... �rl\J�"' Signature: � Date: June 10,201 1 License#30269 � � • • • • • • • • • • • • • • • • i • • • • • • i • • • • • • • • • • • • • • • • ! • DATE: June 1, 2011 JOB: Scandia :VIunicipal Drainfield LOCATION: Sec 23, T.32 N., R.20 W., Washington County Site, Stake or Pit# : SB-7 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-9 10YR3/3 Loamy sand lfsbk vfr Fill 9-12 10YR4/3 Coarse sand Single loose Fill grained 12-17 10YR4/4 Sand, loamy lcsbk vfr C2d 7.SYR5/6 & 12" Fill, mixed materials; see note#3 sand 10YR4/2 17-23 IOYRS/4 Clay loam Massive fi Fill, variegated colors 23-27 IOYR3/2 Sandy loam lfsbk fr � Original surface? 27-34 10YR4/3 Loanry sand lcsbk vfr Boring ended at 34" due to cobble \II color,are moi;t hiunsell notation unle�s uthenci,e stated ,AII notations used are�i�und in"Field Book for Samplin�and De�cribine Soils,�'ersion 2.0"—USDA-i�RCS,2002 Remarks: 1. Slope sllape = linear vertically, linear horizontally. 2. North side of drainfield, appears to have 20" to 24"over original soils surface —possibly due to landscaping? 3. Redox at 12" may not be due to soil wetness at this site but likely transported to site via fill. TERRY L. BOVEE, PROFESSIONAL SOIL SCIENTIST: [ hereby certify that this plan,document,or report was prepared by me or unde r my direct super��ision and that I am a dulv licensed Professional Soil Scientist under the laws of the Statc of Minnesota. Print name: Terrv L. Bovee ��..._�.�., �d Signature: Date:June 10,2011 License#30269 I � � � ` � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � • � • • • • • • • • • • • • • ! • • � • • i • • • • • • • � • • • • • • • • � • • ! • • � DATE: June 1, 2011 JOB: Scandia Municipal Drainfield Expansion Area LOCAT[ON: Sec 23, T32 N., R.20 W., Washington County Site, Stake or Pit# : SB-8 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-9 10YR3/3 Loaln 2fsbk vfr <18%clay content 9-15 7.SYR3/4 Loan� 2msbk fr � Near a clay loam, >18% clay � content? 15-25 7.SYR4/4 Sai�dy clay 2msbk fr fld 7.5YR4/2 16" Consistence gets firmer with depth; loam � >18%clay content 2�-32 �YR3/4 Clay loam lmsbk fi Till-like, no redox 32-36 SYR3/4 Loam, sandy massive fr I fld 7.SYR4/2 Wetness in pores and on ped faces clay loam 36-38 �YR4/4 Clay massive fi c2d 7.SYR4/2 & Lacustrine sediments � 7.SYR5/6 38-62 SYR4/4 Sandy clay Massive Fr & fld 7.SYR4/2 Stratified, water sorted sediments loam. Sand, or loose loamy sand single grained All color�are moisi Munscll notation unless otherwise statcd all notation,used arc found in"Ficld Book for Samplin�and Describin�Soils.Version ?.0"—USDA-NRCS,2002 Remarks: 1. Slope shape = linear vertically, linear horizontally; �0-1°/o slope. 2. Sediments from 36"- 62" appear to be lacustrine and/or water sorted with saturation in the 34"-36" zone. TERRY L. BOVEE, PROFESSIONAL SOIL SCIENT[ST: I hereby certify that this plan,document,or report was prepared by me or under my direct supervision and that[ am a duly licensed Professional Soil Scientist under the laws of the State of Minnesota. Print name: Terry L. Bovee '"``�i— C�.,�- Sienature: � Date:.lunc 1Q 201 1 License#30269 r • � • • • • • • • • • • • • i • � • • • � • • � • � • • � � • � • • • • • � • • • • • DATE: June 1, 20ll JOB: Scandia Municipal Drainfield Expansion Area I LOCATION: Sec 23, T.32 N., R.20 W., Washington County ' Site, Stake or Pit# : SB-9 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-7 l 0YR3/3 Fine sandy 1 fsbk fr loam 7-10 l 0YR4/3 Fine sandy 1 fpl vfr E horizon loam 10-15 7.SYR3/4 Clay loan� 2msbk fr 15-25 7.SYR4/4 Clay 2csbk fi Lacustrine sediments; clay films 25-36 7.SYR4/4 Sandy clay lmsbk fr fld 7.SYR4/2 & 30" Wetness in pores and on ped faces; loam 7.SYR5/6 clay films 36+ 7.SYR4/4 clay massive fi c2d 7.SYR4/2 & Lacustrine sediments VI colurs are moist h1unsell notation unlc,s odier�cise stated �II notations wed are(ound in"Ficld f3ook for Sampline and Dcscribin,�Soils Version 3.0"—USDA-hRCS,_'002 Remarks: 1. Slope shape = linear vertically, convex horizontally; �2-3°/o slope TERRY L. BOVEE, PROFESSIONAL SOIL SCIENTIST: I hereby certify that this plan,document,or report was prepared by me or unde r my direct super��ision and that I am a duly licensed Professional Soil Scientist under the laws of the State of Minnesota. Print name: Terry L. Bovee ---'�6�,".d Sianature: Datc: June l0,201 1 License#30269 � � � � � � � � � � � � � � ` � � � � s • • • � • • � • • • • • • • • • � • • • � � � • � • • • • • i • • ! • • • • • • • • • • • • • • • � • • • • • • • • • • • • • • • • • • DATE: June 1, 2011 �, JOB: Scandia Municipal Drainfield Expansion Area �� LOCATIO!��: Sec 23, T.32 N., R20 W., Washington County ' Site, Stake or Pit# : SB-10 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-7 10YR3/3 Fine sandy lfsbk fr loam 7-10 10YR4/3 Fine sandy lfpl vfr E horizon loam 10-1� 7.SYR3/4 Clay loam 2msbk fr 15-25 7.SYR4/4 Clay 2csbk fi Lacustrine sediments; clay films 25-32 7.SYR4/4 Sandy clay lmsbk fr fld 7.SYR4/2 & 30" Wetness in pores and on ped faces; loam 7.SYR5/6 clay films 32-34 7.SYR4/4 Coarse sand Single Loose C2d 7.SYR4/2 & Saturated grained SYRS/4 34-62 5YR4/4 Clay, silt Massive Fi to C2d 7.SYR4/2 & Saturated bands of water-sorted loam, very loose SYRS/4 sediments fine sand All colors are moist Munsell notation unlcss otherwise stated ��II notations u.ed are found in"field f3ook�br Samnlin��nd Describine Soils,Version 2.0"—USDA-NRCS,2002 Remarks: l. Slope shape= linear vertically, linear horizontally; �1-2% slope TERRY L. BOVEE, PROFESSIONAL SOIL SCIENTIST: [ hereby certify that this plan,docwnent,or report was prepared by me or unde r my direct supervision and that I am a duly licensed Professional Soil Scientist under the laws of the State of Minnesota. Print namc: Terrv L. Bovee `_-- �., �� Signaturc: Date:June 10,201 1 License#30269 � • • • • • • • • • • • • • • • ! • � • • • • • • • i • • • • • • • • • • • • • • • • • n�TE: Jun� i, 2oi1 JOB: Scandia Municipal Drainfield Expansion Area LOCATION: Sec 23, T.32 N., R.20 W., Washington County Site, Stake or Pit# : SB-11 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-6 10YR3/3 Loam lfsbk vfr 6-10 10YR4/3 Loam 2fsbk vfr 10-12 10YR4/4 Loamy coarse 1 csbk vfr sand 12-15 7.SYR3/4 Loamy sand lcsbk vfr fld 7.SYR4/2 13" 15-20 7.SYR4/4 Sandy clay lcsbk fr fld 7.SYR4/2 5 to 15% coarse fragments loam 20-29 7.SYR4/4 Loamy coarse lcsbk vfr c2d 7.SYR4/2 & Stratified sediments; Wemess in some sand, sandy 7.SYR�/6 pores and on ped faces; end of boring clay loam, at 29" due to cobbles loam sand All colors are moist!�tunsell notation unless othenvise stated 111 notations used are found in"Field Book for Sampline and De�cribin�_Soils,Version 2.0"—USDA-NRCS.200? Remarks: 1. Slope shape = convex vertically, linear horizontally; �2-3% slope TERRY L. BOVEE, PROFESSIONAL SOIL SC[ENTIST: I hereby certify that this plan,document,or report was prepared by me or under my direct supervision and that I am a duly licensed Professional Soil Scientist under the laws of the State of Minnesota. Print name: Terrv L. Bovee r�,�,�._C?�., �a Signature: Date: June 10,2011 License#30269 � � � � � � � � � � � � � � � � � S � � � � � � � � � r � � � � � � � � � � � � � � � � � • • • � • � s � � �� • � � • • • �� • • ` • • • • • • • � • • • � • • • • • � • • �� DATE: June 1, 20ll JOB: Scandia Abandoned Municipal Drainfield, adjacent to Community Building LOCATION: Sec 23, T.32 N., R.20 W., Washington County Site, Stake or Pit# : SB-12 Depth Matrix Texture Structure Consist. Redox or other Depth to Notes (inches) Color features Redox 0-14 l 0YR3/2, Sandy loan� & 1 fsbk fr Mixed materials—fill? I OYR4/3 loam 14-20 1 OYR4/3 Loam 1 msbk fr 20-29 7.�YR3/4 Sandy loam lfsbk vfr fld 10YR4/2 & 23" Boring ended due to large rock SYR4/4 111 color�ure moist�9unsc1l notation unless othcrwise stated :111 not��tions uscd t�re(ound in"Field Book tor Samolinc and Describine Soils.Vcrsion 2.0"—USDA-NRCS,2002 Remarks: 1. Slope shape = linear vertically,linear horizontally; �0% slope 2. This is on south side of old drainfield. 3. Tlie Washington County Soil Survey mapped this area as a gravel pit(entire area of Community Building,parking lots,rink, etc.) TERRY L. BOVEE, PROFESSIONAL SO[L SCIENTIST: I hereby certify that this plan,document,or report was prepared by me or unde r my direct supervision and that 1 am a duly licensed Professional Soil Scientist under the laws of the State of Minnesota. Print name: Terrv L. Bovee ������ Signature: Date:June 10,201 1 License#30269 � � � ` � � � � � � � � � � � � � � � � � i • • • • • • • • • • i • � • • • • • • • • • � � � � � � � � � � � � � � S � � � � � � RATE CALCULATIONS • • • • • • � • • • • • • i • • • • • � Ciry of Scandia—Nl I.103386 Appendix � Uptown Wastewater System Master Plan Prepared by Bolton &Menk, Inc. � � � � � � � � � � � � � � � � � � � � � � � � i • • • • • • • • • • • • • • • • • • • • • � � � � � � � � � � � � � � ` � � � � � � � � � � � � � � � � � � � � � � � � � � � � � SEWER UTILITY O&M COSTS UPTOWN WW SYSTEM MASTER PLAN CITY OF SCANDIA BMI PROJECT NO.N11.103386 7/11/2011 Item Amount Salaries,Payroll Taxes and Employee Benefits $ 4,427.00 -5%of Steve's Time Professional Fees 5 500.00 -Engineering,assumed Office Expense $ 100.00 -Utility Billings,assumed Utilities $ 175.00 -Electrical for pumps,based on historical Testing $ 600.00 -Tank sampling(4 tanks per year,$150/tank) Licenses $ 500.00 -SSTS Continuing Education Class,1 Class/year @$500(includes class,plus travel and lodging) Septic Tank Pumping $ 3,250.00 -$325/tank x 10 tanks/year Pump Replacement $ 500.00 -$1000/pump,7 pumps in system,replace 1 pump every 2 years Control Panel Replacement $ 450.00 -$1500/panel-3 panels in system,replace all panels every 10 years Misc.Supplies $ 100.00 Repairs,Maintenance,&Supplies $ 4,300.00 Miscellaneous $ 100.00 Insurance $ 150.00 -Lift station insurance Total $ 10,852.00 Fixed Costs $ 7,427.00 Variable Costs $ 3,425.00 Total $ 10,852.00 � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � s • • • • • • • • • • • � � � � SEWER UTILITY RATE CALCULATIONS • EXISTING SYSTEM-HIGH BASE RATE, LOW USE RATE UPTOWN WW SYSTEM MASTER PLAN • CITY OF SCANOIA BMI PROJECT NO.N11.103386 7/11/2011 • • System Information Proiect Capital Costs-Source of Funds Bond Issuance Information • No.of Current Customers 7 $ Loan Amount $ • Additfonal Customers/Year 0 Interest 2.00% Base Charge Per Month-Existing $ 78.00 Term(years) 20 • Rate per 1000 Gallon-Existing $ 5.00 Annual Payment $ - ' • Connection Charge/Unit $ - Current O&M $ 10,852.00 • Proposed O&M $ 10,852.00 Tota) $ - Proposed O&M Increase Per Year 3% • Current Sewer Fund Cash Reserve $ • • Expenditures Useage and Billing Data Revenue Cash Position • Monthly Annual Base Monthly Annual Use Interest on Annual Cumulative • Existing New Annual Total No.of Billable Base Rate I�crease Rate Per Rate Increase Connection Base Rate Useage Assessment Cash Reserve Total Surplus/ Cash Year Debt Debt Service O&M Expenditures Users Water(gal) Rate % 1000 Gal % Charge Revenue Revenue Revenue 0.00% Revenue Deficit Reserve • 2012 $ - $ - $ 10,852.00 $ 10,852.00 8 687420 $ 78.00 0% $ 5.00 0.0% $ - $ 7,488.00 $ 3,437.10 $ - $ - $ 10,92510 $ 73.10 $ 7310 2013 $ - $ - $ 11,177.56 $ 11,177.56 8 687420 $ 80.34 3% $ 5.15 3.0% $ - $ 7,712.64 $ 3,540.21 $ - $ - $ 11,252.85 $ 75.29 $ 148.39 • 2014 $ - $ - $ 11,512.89 $ 11,512.89 8 687420 $ 82.75 3% $ 5.30 3.0% $ - $ 7,944.02 $ 3,646.42 $ - $ - $ 11,590.44 $ 77.55 $ 225.94 • 2015 $ _ $ _ $ 11,858.27 $ 11,858.27 8 687420 $ 85.23 3% $ 5.46 3.0% $ - $ 8,182.34 $ 3,755.81 $ _ $ _ $ 11,938.15 $ 79.88 $ 305.82 2016 $ $ $ 12,214.02 $ 12,214.02 8 687420 $ 87.79 3% $ 5.63 3.0% $ $ 8,427.81 $ 3,868.49 $ $ $ 12,296.30 $ 82.27 $ 388.10 • 2017 $ _ $ _ $ 12,580.44 $ 12,580.44 8 687420 $ 90.42 3% $ 5.80 3.0% $ _ $ 8,680.64 $ 3,984.54 $ _ $ _ $ 12,665.19 $ 84.74 $ 472.84 2018 $ $ $ 12,957.86 $ 12,957.86 8 687420 $ 93.14 3% $ 5.97 3.0% $ $ 8,941.06 $ 4,104.08 $ $ $ 13,045.14 $ 87.29 $ 560.13 • 2019 $ - $ - $ 13,346.59 $ 13,346.59 8 687420 $ 95.93 3% $ 6.15 3.0% $ _ $ 9,209.30 $ 4,227.20 $ _ $ _ $ 13,436.49 $ 89.90 $ 650.03 2020 $ - $ - $ 13,746.99 $ 13,746.99 8 687420 $ 98.81 3% $ 6.33 3.0% $ $ 9,485.57 $ 4,354.02 $ $ $ 13,839.59 $ 92.60 $ 742.63 • 2021 $ - $ - $ 14,159.40 $ 14,159.40 8 687420 $ 101.77 3% $ 6.52 3.0°0 $ - $ 9,770.14 $ 4,484.64 $ - $ $ 14,254.78 $ 95.38 $ 838.01 2022 $ - $ - 5 14,584.18 $ 14,584.18 8 687420 $ 104.83 3% $ 6.72 3.0% $ - 5 10,063.25 5 4,619.17 5 $ - $ 14,682.42 $ 98.24 $ 936.25 • 2023 $ - $ - $ 15,021.71 $ 15,021.71 8 687420 $ 107.97 3% $ 6.92 3.0% $ - $ 10,365.14 $ 4,757J5 $ - $ - $ 15,122.89 $ 101.19 $ 1,037.44 • 2024 $ _ $ _ $ 15,47236 $ 15,472.36 8 687420 $ 111.21 3% $ 7.13 3.0% $ _ $ 10,676.10 $ 4,900.48 $ _ $ _ $ 15,576.58 $ 104.22 $ 1,141.66 2025 $ $ $ 15,936.53 $ 15,936.53 8 687420 $ 114.55 3% $ 7.34 3.0% $ $ 10,996.38 $ 5,047.50 $ $ $ 16,043.88 $ 107.35 $ 1,249.01 � 2026 $ - $ _ $ 16,414.62 $ 16,414.62 8 687420 $ 117.98 3% $ 7.56 3.0% $ _ $ 11,326.27 $ 5,198.92 $ _ $ _ � 16,525.19 $ 110.57 $ 1,359.58 2027 $ $ $ 16,907.06 $ 16,907.06 8 687420 $ 121.52 3% $ 7.79 3.0% $ $ 11,666.06 $ 5,354.89 $ $ $ 17,020.95 $ 113.89 $ 1,473.47 • 2028 $ - $ - $ 17,414.27 $ 17,414.27 8 687420 $ 125.17 3% $ 8.02 3.0% $ _ $ 12,016.04 $ 5,515.54 $ _ $ _ $ 17,531.58 $ 117.30 $ 1,590.77 2029 $ - $ - $ 17,936.70 $ 17,936.70 8 687420 $ 128.92 3% $ 8.26 3.0% $ $ 12,376.52 $ 5,681.00 $ $ $ 18,057.53 $ 120.82 $ 1,711.60 • 2030 $ - $ - $ 18,474.80 $ 18,474.80 8 687420 $ 132.79 3% $ 8.51 3.0% $ - $ 12,747.82 $ 5,851.43 $ - $ - ; 18,599.25 $ 124.45 $ 1,836.04 • 2031 $ - $ _ $ 19,029.05 $ 19,029.05 8 687420 $ 136.77 3% $ 8.77 3.0% $ $ 13,130.25 $ 6,026.98 $ _ $ _ $ 19,157.23 $ 128.18 $ 1,964.22 2032 $ $ $ 19,599.92 $ 19,599.92 8 687420 $ 140.88 3% $ 9.03 3.0% $ $ 13,524.16 $ 6,207.78 $ $ $ 19,731.95 $ 132.03 $ 2,096.25 • 2033 $ - $ - $ 20,187.92 $ 20,187.92 8 687420 $ 145.10 3% $ 9.30 3.0% $ - $ 13,929.89 $ 6,394.02 $ - $ - � 20,323.90 $ 135.99 $ 2,232.24 • • Estimated Sewer CharRes • • Avg Monthly Avg Annual Avg Monthly Avg Annual User Water Use(gal) Water Use(gal) Sewer Bill Sewer Bill • Schmitt Mall 7,513 90,156 $115.57 $1,386.78 Yoga Hus 327 3,924 $79.64 $955.62 • R&B Auto 5,564 66,768 $105.82 $1,269.84 Scandia Store/Deli/Cafe,etc. 19,955 239,460 $177.78 $2,13330 � Elim Church&Parsonage 12,600 151,200 $141.00 $1,692.00 Community Center 5,490 65,880 $105.45 $1,265.40 • Warming House 4,?66 51,192 $99.33 $1,191.96 • Gammelgarden 1,570 18,840 $85.85 $1,030.20 7otal 57,285 687,420 $910.43 $10,925.30 • • • - � � � � SEWER UTILITY RATE CALCULATIONS • EXISTING SYSTEM-LOW BASE RATE,HIGH USE RATE UPTOWN WW SYSTEM MASTER PLAN • CITY OF SCANDIA BMI PROJECT NO.N11.103386 7/11/2011 • • Svstem Information Proiect Capital Costs-Source of Funds Bond Issuance Information • No.of Current Customers 8 $ Loan Amount $ - • Additional Customers/Year 0 Interest 2.00% Base Charge Per Month-Existing $ 13.00 Term(years) 20 � Rate per 1000 Gallon-Existing $ 14.00 Annual Payment $ - • Connection Charge/Unit 5 - Current O&M $ 10,852.00 • Proposed O&M $ 10,852.00 Total $ - Proposed O&M Increase Per Year 3% • Current Sewer Fund Cash Reserve $ - � • Expenditures Useage and Billing Data Revenue Cash Position • Monthly Annual Base Monthly Annual Use Interest on Annual Cumulative • Existing New Annual Total No.of Billable Base Rate Increase Rate Per Rate Increase Connection Base Rate Useage Assessment Cash Reserve Total Surplus/ Cash Year Debt Debt Service O&M Expenditures Users Water(gal) Rate % 1000 Gal % Charge Revenue Revenue Revenue 0.00% Revenue Deficit Reserve • 2012 $ - $ $ 10,852.00 $ 10,852.00 8 687420 $ 13.00 0% $ 14.00 0.0% $ - $ 1,248.00 $ 9,623.88 $ - $ - $ 10,871.88 $ 19.88 $ 19.88 2013 $ - $ - $ 11,177.56 $ 11,177.56 8 687420 $ 13.39 3% $ 14.42 3.0% $ - $ 1,285.44 $ 9,912.60 $ - $ - $ 11,198.04 $ 20.48 $ 40.36 • 2014 $ - $ - $ 11,512.89 $ 11,512.89 8 687420 $ 13.79 3% $ 14.85 3.0% $ - S 1,324.00 $ 10,209.97 $ - $ - $ 11,533.98 $ 21.09 S 61.45 • 2015 $ = 5 � $ 11,858.27 $ 11,858.27 8 687420 5 14.21 3% S 15.30 3.0% $ _ $ 1,363.72 $ 10,516.27 $ = 5 = $ 11,880.00 $ 21.72 $ 83.17 2016 $ $ $ 12,214.02 $ 12,214.02 8 687420 $ 14.63 3% $ 15.76 3.0% $ $ 1,404.63 $ 10,831.76 $ $ $ 12,236.40 $ 22.38 $ 105.55 • 2017 $ _ $ _ $ 12,580.44 $ 12,580.44 8 687420 $ 15.07 3% $ 16.23 3.0% $ _ $ 1,446J7 $ 11,156.71 $ - $ = S 12,603.49 $ 23.05 $ 128.59 2018 $ $ $ 12,957.86 $ 12,957.86 8 687420 $ 15.52 3% $ 16.72 3.0% $ $ 1,490.18 $ 11,491.42 $ $ S 12,981.59 $ 23.74 $ 152.33 � 2019 $ - $ - $ 13,346.59 $ 13,346.59 8 687420 $ 15.99 3% $ ll.22 3.0% $ _ $ 1,534.88 $ 11,836.16 $ _ $ _ $ 13,371.04 $ 24.45 $ 176J8 2020 $ - $ - $ 13,746.99 $ 13,746.99 8 687420 $ 16.47 3% $ 17.73 3.0% $ $ 1,580.93 $ 12,191.24 $ $ $ 13,772.17 $ 25.18 $ 201.96 • 2021 $ - $ - $ 14,159.40 $ 14,159.40 8 687420 $ 16.96 3% $ 18.27 3.0% $ $ 1,628.36 $ 12,556.98 $ - $ - $ 14,18534 $ 25.94 $ 227.90 2022 $ - $ - $ 14,584.18 $ 14,584.18 8 687420 $ 17.47 3% $ 18.81 3.0% $ - $ 1,677.21 $ 12,933.69 $ - $ - $ 14,610.90 $ 26J2 $ 254.62 • 2023 $ - $ - 5 15,021.71 5 15,021.71 8 687420 $ 18.00 3% $ 19.38 3.0% 5 - S 1,727.52 S 13,321.70 $ - 5 - $ 15,049.22 $ 27.52 $ 282.14 • 2024 $ - $ - $ 15,47236 $ 15,472.36 8 687420 $ 18.53 3% $ 19.96 3.0% $ _ $ 1,779.35 $ 13,721.35 $ _ $ = J 15,SOOJO $ 28.34 $ 310.48 2025 $ $ $ 15,936.53 $ 15,936.53 8 687420 $ 19.09 3% $ 20.56 3.0% $ 5 1,832.73 $ 14,132.99 $ 5 $ 15,965.72 $ 29.19 5 339.68 • 2026 $ � $ _ $ 16,414.62 $ 16,414.62 8 687420 $ 19.66 3% $ 2L18 3.0% $ _ $ 1,887J1 $ 14,556.98 $ _ $ _ > 16,444.69 $ 30.07 $ 369J5 2027 $ $ $ 16,907.06 $ 16,907.06 8 687420 $ 20.25 3% $ 21.81 3.0% $ $ 1,94434 $ 14,993.69 $ $ $ 16,938.03 $ 30.97 $ 400J2 � 2028 $ - $ - $ 17,414.27 $ 17,414.27 8 687420 $ 20.86 3% $ 22.47 3.0% $ - $ 2,002.67 $ 15,443.50 $ - $ - � 17,446.18 $ 31.90 $ 432.62 2029 $ - $ - $ 17,936.70 $ 17,936.70 8 687420 $ 21.49 3% $ 23.14 3.0% $ - $ 2,062.75 $ 15,906.81 $ $ - $ 17,969.56 $ 32.86 $ 465.48 • 2030 $ - $ - $ 18,474.80 $ 18,474.80 8 687420 $ 22.13 3% $ 23.83 3.0% $ - $ 2,124.64 $ 16,384.01 $ - $ - S 18,508.65 $ 33.84 $ 499.32 � 2031 $ _ $ - $ 19,029.05 $ 19,029.05 8 687420 $ 22.80 3% $ 24.55 3.0% $ _ $ 2,188.38 $ 16,875.53 $ $ _ $ 19,063.91 $ 34.86 $ 534.18 2032 $ $ $ 19,599.92 $ 19,599.92 8 687420 $ 23.48 3% $ 25.29 3.0% $ $ 2,254.03 $ 17,381.80 $ $ $ 19,635.82 $ 35.91 $ 570.09 • 2033 $ - $ $ 20,187.92 $ 20,187.92 8 687420 $ 24.18 3% $ 26.04 3.0% $ - $ 2,321.65 $ 17,903.25 $ - $ - > 20,224.90 $ 36.98 $ 607.07 • � Estimated Sewer Charaes • Avg Monthly Avg Annual Avg Monthly Avg Annual . User Water Use(gal) Water Use(gal) Sewer Bill Sewer Bill • Schmitt Mall 7,513 90,156 $118.18 $1,418.18 Yoga Hus 327 3,924 $17.58 $210.94 • R&B Auto 5,564 66,768 $90.90 $1,090.75 Scandia Store/Deli/Cafe,etc. 19,955 239,460 $292.37 $3,508.44 � Elim Church&Parsonage 12,600 151,200 $189.40 $2,272.80 • Community Center 5,490 65,880 $89.86 $1,07832 Warming House 4,266 51,192 $72.72 $872.69 • Gammelgarden 1,570 18,840 $34.98 $419.76 Total 57,285 687,420 $905.99 $10,871.88 • • • • • • • ! • • • • • • ! • • • � i • • • • • • ! • • • • • • ! • • ! • • • • • • • • • • � � � � � SEWER UTILITY RATE CALCULATIONS • ALL PROPOSED IMPROVEMENTS-HIGH BASE RATE, LOW USE RATE UPTOWN WW SYSTEM MASTER PLAN • CITY OF SCANDIA BMI PROJECT NO.N11.103386 7/11/2011 • Svstem Information Proiect Capital Costs-Source of Funds Bond Issuance Information � • Sewer Revenue Bond $ 112,000.00 No.of Current Customers 8 $ Loan Amount $ 112,000.00 • Additional Customers/Year 0 Interest 4.00% Base Charge Per Month-Exis[ing $ 220.00 Term(years) 10 • Rate per 1000 Gallon-Existing $ 4.75 Annual Payment $ (13,808.59) Connection Charge/Unit $ • Current0&M $ 10,852.00 Proposed 0&M $ 10,852.00 Total $ 112,000.00 II • Proposed 0&M Increase Per Year 3% Current Sewer Fund Cash Reserve $ - I • • • Expenditures Useage and Billing Data Revenue Cash Position • Monthly Annual ease Monthly Annual Use Interest on Annual Cumulative Existing New Annual Total No.of Billable Base Ratelncrease Rate Per Rat�lncrease Connection Base Rate Useage Assessment Cash Reserve Total Surplus/ Cash • Year Debt Debt Service O&M Expenditures Users Water(gal) Rate % 1000 Gal % Charge Revenue Revenue Revenue 0.00% Revenue Deficit Reserve 2012 $ - $ - $ 10,852.00 $ 10,852.00 8 687420 $ 220.00 0% $ 4.75 0.0% $ $ 21,120.00 $ 3,265.25 $ $ $ 24,385.25 $ 13,533.25 $ 13,533.25 • 2013 $ - $ 13,808.59 $ 11,177.56 $ 24,986.15 8 687420 $ 226.60 3% $ 4.89 3.0% $ - $ 21,753.60 $ 3,363.20 $ - $ - $ 25,116.80 $ 130.66 $ 13,663.90 2014 $ - $ 13,808.59 $ 11,512.89 $ 25,321.47 8 687420 $ 233.40 3% $ 5.04 3.0% $ - $ 22,406.21 $ 3,464.10 $ - $ - $ 25,87031 $ 548.83 $ 14,212J4 . 2015 $ - $ 13,808.59 $ 11,858.27 $ 25,666.86 8 687420 $ 240.40 3% $ 5.19 3.0% $ - $ 23,078.39 $ 3,568.02 $ - $ - j 26,646.42 $ 979.56 $ 15,192.29 . 2016 $ - $ 13,808.59 $ 12,214.02 $ 26,022.61 8 687420 $ 247.61 3% $ 5.35 3.0% $ - $ 23,770.75 $ 3,675.06 $ _ $ _ > 27,445.81 $ 1,423.20 $ 16,615.49 2017 $ $ 13,808.59 $ 12,580.44 $ 26,389.03 8 687420 $ 255.04 3% $ 5.51 3.0% $ $ 24,483.87 $ 3,785.31 $ $ S 28,269.18 $ 1,880.15 $ 18,495.65 • 2018 $ - $ 13,808.59 $ 12,957.86 $ 26,766.44 8 687420 $ 262.69 3% $ 5.67 3.0% $ � $ 25,218.38 $ 3,898.87 $ _ $ - $ 29,117.26 $ 2,350.82 $ 20,846.46 2019 $ $ 13,808.59 $ 13,346.59 $ 27,155.18 8 687420 $ 270.57 3% $ 5.84 3.0% $ $ 25,974.94 $ 4,015.84 $ $ $ 29,990.78 $ 2,835.60 $ 23,682.06 • 2020 $ � $ 13,808.59 $ 13,746.99 $ 27,555.57 8 687420 $ 278.69 3% $ 6.02 3.0% $ _ $ 26,754.18 $ 4,136.31 $ = S = > 30,890.50 $ 3,334.92 $ 27,016.99 2021 $ $ 13,808.59 $ 14,159.40 $ 27,967.98 8 687420 $ 287A5 3% $ 6.20 3.0% $ $ 27,556.81 $ 4,260.40 $ $ y 31,817.21 $ 3,849.23 $ 30,866.22 • 2022 $ - $ 13,808.59 $ 14,584.18 $ 28,392.77 8 687420 $ 295.66 3% $ 6.38 3.0% $ - $ 28,383.51 $ 4,388.22 $ _ $ - S 32,771.73 $ 4,378.96 $ 35,245.18 2023 $ $ $ 15,021.71 $ 15,021.71 8 687420 $ 304.53 3% $ 6.58 3.0% $ $ 29,235.02 $ 4,519.86 $ $ � 33,754.88 $ 18,733.18 $ 53,978.36 � 2024 $ - $ - $ 15,472.36 $ 15,472.36 8 687420 $ 313.67 3% $ 6J7 3.0% $ - $ 30,112.07 $ 4,655.46 $ - $ - � 34,767.53 $ 19,295.17 $ 73,273.53 2025 $ - $ - $ 15,936.53 $ 15,936.53 8 687420 $ 323.08 3% $ 6.98 3.0% $ - $ 31,015.43 $ 4,795.12 $ $ $ 35,810.55 $ 19,874.03 $ 93,147.55 • 2026 $ - $ - $ 16,414.62 $ 16,414.62 8 687420 $ 332.77 3% $ 7.18 3.0% $ - $ 31,945.89 $ 4,938.98 $ - $ - $ 36,884.87 $ 20,470.25 $ 113,617.80 2027 $ - $ - $ 16,907.06 $ 16,907.06 8 687420 $ 342.75 3% $ 7.40 3.0% $ - $ 32,904.27 $ 5,087.15 $ - $ - j 37,991.42 $ 21,084.35 $ 134,702.16 • 2028 $ - $ - $ 17,414.27 $ 17,414.27 8 687420 $ 353.04 3% $ 7.62 3.0% $ - $ 33,891.40 $ 5,239.76 $ - $ - j 39,131.16 $ 21,716.89 $ 156,419.04 • 2029 $ - $ - $ 17,936.70 $ 17,936.70 8 687420 $ 363.63 3% $ 7.85 3.0% $ _ $ 34,908.14 $ 5,396.95 $ _ $ _ $ 40,305.09 $ 22,368.39 $ 178,787.43 2030 $ $ $ 18,474.80 $ 18,474.80 8 687420 $ 374.54 3% $ 8.09 3.0% $ $ 35,955.39 $ 5,558.86 $ $ $ 41,514.25 $ 23,039.44 $ 201,826.88 • 2031 $ _ $ - $ 19,029.05 $ 19,029.05 8 687420 $ 385.77 3% $ 8.33 3.0% $ - $ 37,034.05 $ 5,725.63 $ _ $ _ $ 42,759.67 $ 23,730.63 $ 225,557.50 2032 $ $ $ 19,599.92 $ 19,599.92 8 687420 $ 397.34 3% $ 8.58 3.0% $ $ 38,145.07 $ 5,897.40 $ $ $ 44,042.46 $ 24,442.55 $ 250,000.05 • 2033 $ _ $ - $ 20,187.92 $ 20,187.92 8 687420 $ 409.26 3% $ 8.84 3.0% $ _ $ 39,289.42 $ 6,074.32 $ _ $ = j 45,363.74 $ 25,175.82 $ 275,175.87 2034 $ $ $ 20,793.55 $ 20,793.55 8 687420 $ 421.54 3% $ 9.10 3.0% $ $ 40,468.10 $ 6,256.55 $ $ $ 46,724.65 $ 25,931.10 $ 301,106.97 • • Estimated Sewer CharRes • • Avg Monthly Avg Annual Avg Monthly Avg Annual • User Water Use(gal) Water Use(gal) Sewer Bill Sewer Bill Schmitt Mall 7,513 90,156 $255.69 $3,068.24 • Yoga Hus 327 3,924 $221.55 $2,658.64 R&B Auto 5,564 66,768 $246.43 $2,957.15 • Scandia Store/Deli/Cafe,etc. 19,955 239,460 $314.79 $3,777.44 Elim Church&Parsonage 12,600 151,200 $279.85 $3,358.20 • Community Center 5,490 65,880 $246.08 $2,952.93 Warming House 4,266 51,192 $240.26 $2,883.16 • Gammelgarden 1,570 18,840 $227.46 $2,729.49 Total 57,285 687,420 $2,032.10 $24,385.25 • • • • • � � � � SEWER UTILITY RATE CALCULATIONS • ALL PROPOSED IMPROVEMENTS-LOW BASE RATE,HIGH USE RATE UPTOWN WW SYSTEM MASTER PLAN • CITY OF SCANDIA BMI PROJECT NO.N11.103386 7/11/2011 • Svstem Information Proiect Capital Costs-Source of Funds Bond Issuance Information ' • • Sewer Revenue Bond $ 112,000.00 No.of Current Customers 8 $ Loan Amount $ 112,000.00 '� • Additional Customers/Year 0 Interest 4.00% Base Charge Per Month-Existing S 15.00 Term(years) 10 • Rate per 1000 Gallon-Existing $ 33-25 Annual Payment $ (13,808.59) Connection Charge/Unit $ • Current0&M $ 10,852.00 Proposed O&M 5 10,852.00 Total $ 112,000.00 • Proposed O&M Increase Per Year 3% Current Sewer Fund Cash Reserve 5 - • • • Expenditures Useage and Billing Data Revenue Cash Position • Monthly Annual Base Monthly Annual Use Interest on Annual Cumulative Existing New Annual Total No.of Billable Base Rate Increase Rate Per Rate Increase Connection Base Rate Useage Assessment Cash Reserve Total Surplus/ Cash � Year Debt Debt Service O&M Expenditures Users Water(gal) Rate % 1000 Gal % Charge Revenue Revenue Revenue 0.00% Revenue Deficit Reserve 2012 $ - $ - $ 10,852.00 $ 10,852.00 8 687420 $ 15.00 0% $ 33.25 0.0% $ $ 1,440.00 $ 22,856.72 $ $ $ 24,296.72 $ 13,444.72 $ 13,444.72 • 2013 $ - $ 13,808.59 $ 11,177.56 $ 24,986.15 8 687420 $ 15.45 3% $ 34.25 3.0% $ - $ 1,483.20 $ 23,542.42 $ - $ - $ 25,025.62 $ 39.47 $ 13,484.19 2014 $ - $ 13,808.59 $ 11,512.89 $ 25,321.47 8 687420 $ 15.91 3% $ 35.27 3.0% $ - $ 1,527.70 $ 24,248.69 $ - $ - $ 25,77638 $ 45491 $ 13,939.10 • 2015 $ - $ 13,808.59 $ 11,858.27 $ 25,666.86 8 687420 $ 16.39 3% $ 36.33 3.0% $ - $ 1,573.53 $ 24,976.15 $ - $ - $ 26,549.68 $ 882.82 $ 14,821.92 • 2016 $ _ $ 13,808.59 $ 12,214.02 $ 26,022.61 8 687420 $ 16.88 3% $ 37.42 3.0% $ _ $ 1,620.73 $ 25,725.43 $ - $ - $ 27,346.17 $ 1,323.56 $ 16,145.47 2017 $ $ 13,808.59 $ 12,580.44 $ 26,389.03 8 687420 $ 17.39 3% $ 38.55 3.0% $ $ 1,669.35 $ 26,497.20 $ $ � 28,166.55 $ 1,777.52 $ 17,923.00 2018 $ - $ 13,808.59 $ 12,957.86 $ 26,766.44 8 687420 $ 17.91 3% $ 39J0 3.0% $ - $ 1,719.44 $ 27,292.11 $ - $ - $ 29,011.55 $ 2,245.11 $ 20,168.11 • 2019 $ - $ 13,808.59 $ 13,346.59 $ 27,155.18 8 687420 $ 18.45 3% $ 40.89 3.0% $ - $ 1,771.02 $ 28,110.88 $ - $ - � 29,881.89 $ 2,726.72 $ 22,894.82 • 2020 $ _ $ 13,808.59 $ 13,746.99 $ 27,555.57 8 687420 $ 19.00 3% $ 42.12 3.0% $ - $ 1,824.15 $ 28,954.20 $ _ $ - $ 30,778.35 $ 3,222.78 5 26,117.60 2021 $ $ 13,808.59 $ 14,159.40 $ 27,967.98 8 687420 $ 19.57 3% $ 43.38 3.0% $ $ 1,878.87 $ 29,822.83 $ $ $ 31,701.70 $ 3,733.72 $ 29,851.32 • 2022 $ _ $ 13,808.59 $ 14,584.18 $ 28,392.77 8 687420 $ 20.16 3% $ 44,69 3.0% $ _ $ 1,935.24 $ 30,717.51 $ - $ - $ 32,652.75 $ 4,259.99 $ 34,111.31 2023 $ $ $ 15,021.71 $ 15,021.71 8 687420 $ 20.76 3% $ 46.03 3.0% $ $ 1,993.30 $ 31,639.04 $ $ $ 33,632.34 $ 18,610.63 $ 52,721.94 • 2024 $ - $ - $ 15,472.36 $ 15,472.36 8 687420 $ 21.39 3% $ 47.41 3.0% $ - $ 2,053.10 $ 32,588.21 $ _ $ _ $ 34,641.31 $ 19,168.95 $ 71,890.88 2025 $ - $ - $ 15,936.53 $ 15,936.53 8 687420 $ 22.03 3% $ 48.83 3.0% $ $ 2,114.69 $ 33,565.86 $ $ $ 35,680.55 $ 19,744.02 $ 91,634.90 • 2026 $ - $ - $ 16,414.62 $ 16,414.62 8 687420 $ 22.69 3% $ 50.29 3.0% $ - $ 2,178.13 $ 34,572.83 $ - $ - � 36,750.96 $ 20,336.34 $ 111,971.24 2027 $ - $ - $ 16,907.06 $ 16,907.06 8 687420 $ 23.37 3% $ 51.80 3.0% $ - $ 2,243.47 $ 35,610.02 $ - $ - $ 37,853.49 $ 20,946.43 $ 132,917.67 • 2028 $ - $ - $ 17,414.27 $ 17,414.27 8 687420 $ 24.07 3% $ 5336 3.0% $ - $ 2,310J8 $ 36,678.32 $ - $ - $ 38,989.10 $ 21,574.82 $ 154,492.49 • 2029 $ _ $ _ $ 17,936.70 $ 17,936.70 8 687420 $ 24.79 3% $ 54.96 3.0% $ _ $ 2,380.10 $ 37,778.67 $ _ $ _ � 40,158.77 $ 22,222.07 $ 176,714.55 2030 $ $ $ 18,474.80 $ 18,474,80 8 687420 $ 25.54 3% $ 56.61 3.0% $ $ 2,451.50 $ 38,912.03 $ $ � 41,363.53 $ 22,888.73 $ 199,603.28 • 2031 $ - $ _ $ 19,029.05 $ 19,029.05 8 687420 $ 26.30 3% $ 58.30 3.0% $ _ $ 2,525.05 $ 40,079.39 $ - $ - $ 42,604.44 $ 23,575.39 $ 223,178.67 2032 $ $ $ 19,599.92 $ 19,59992 8 687420 $ 27.09 3% $ 60.05 3.0% $ $ 2,600.80 $ 41,281.77 $ $ S 43,882.57 $ 24,282.65 $ 247,461.32 • 2033 $ - $ _ $ 20,187.92 $ 20,187.92 8 687420 $ 27.90 3% $ 61.85 3.0% $ _ $ 2,678.82 $ 42,520.22 $ - $ - $ 45,199.05 $ 25,011.13 $ 272,472.45 2034 $ $ $ 20,793.55 $ 20,793.55 8 687420 $ 28.74 3% $ 63.71 3.0% $ $ 2,759.19 $ 43,795.83 $ $ $ 46,555.02 $ 25,761.46 $ 298,233.91 • • Estimated Sewer Char�es • • Avg Monthly Avg Annual Avg Monthly Avg Annual • User Water Use(gal) Water Use(gal) Sewer Bill Sewer Bill Schmitt Mall 7,513 90,156 $264.81 $3,177.69 • Yoga Hus 327 3,924 $25.87 $310.47 R&B Auto 5,564 66,768 $200.00 $2,400.04 • Scandia Store/Deli/Cafe,etc 19,955 239,460 $678.50 58,142.05 Elim Church&Parsonage 12,600 151,200 $433.95 $5,207.40 � Community Center 5,490 65,880 $197.54 $2,370.51 Warming House 4,266 51,192 $156.84 $1,882.13 • Gammelgarden 1,570 18,840 $67.20 $806.43 Total 57,285 687,420 $2,024.73 $24,296.72 . • • • • • • • • • • • • • • • • • • • • • • • • • i � • • • • • • • • • • • • • • S • • • • • �