Loading...
Exhibit MSD 102 - Exhibit Index 2019 as of July 24, 2019As of 7/24/19 - Exhibit MSD 102 All documents will be posted on MSD Website unless noted 7/24/2019 14:37 Distribution Recipient(s) MSD 1 MSD Rate Change Proposal Document 3/4/2019 Hard Copy of Proposal & USB Flash Drive w/Exhibits provided to Rate Commissioners (15), Lashly & Baer (2) Black & Veatch (2); Hard Copy of Proposal to Board of Trustees (6) & MSD Executive Management MSD 1A Rate Change Notice Cover Memo to Rate Commission - Rate Change Proposal Submission || MSD 2 Rate Change Public Notice || Direct Testimony:|| MSD 3 Cover Memo to Rate Commission Secretary - Direct Testimony Submission || MSD 3A Direct Testimony: Brian Hoelscher, MSD || MSD 3B Direct Testimony: Susan Myers, MSD || MSD 3C Direct Testimony: Richard Unverferth, MSD || MSD 3D Direct Testimony: Bret Berthold, MSD || MSD 3E Direct Testimony: Marion Gee, MSD || MSD 3F Direct Testimony: Tim Snoke, MSD || MSD 3G Direct Testimony: Bethany Pugh, PFM || MSD 3H Direct Testimony: William Stannard, RFC || MSD 3I Direct Testimony: Tom Beckley, RFC || MSD 4 || MSD 5 2015 Rate Proposal || MSD 6 2015 Rate Commission Recommendation Report || MSD 7 FY 2019 Operating Budget Document || MSD 8 FY 2019 CIRP Budget Document || MSD 9 2015 Comprehensive Annual Financial Report (CAFR)|| MSD 10 2016 Comprehensive Annual Financial Report (CAFR)|| MSD 11 2017 Comprehensive Annual Financial Report (CAFR)|| MSD 12 2018 Comprehensive Annual Financial Report (CAFR)|| MSD 13 2018 Popular Annual Financial Report (PAFR) || MSD 14 Bond Master Ordinance 11713 || MSD 15 Supplemental Bond Ordinance 11736 || MSD 16 Supplemental Bond Ordinance 11986 || MSD 17 Supplemental Bond Ordinance 12179 || MSD 18 Supplemental Bond Ordinance 12332 || MSD 19 Supplemental Bond Ordinance 12755 || MSD 20 Supplemental Bond Ordinance 12937 || MSD 21 Supplemental Bond Ordinance 13024 || MSD 22 Supplemental Bond Ordinance 13025 || MSD 23 Supplemental Bond Ordinance 13183 || MSD 24 Supplemental Bond Ordinance 13327 || MSD 25 Supplemental Bond Ordinance 13465 || MSD 26 Supplemental Bond Ordinance 13521 || MSD 27 Supplemental Bond Ordinance 13731 || MSD 28 Supplemental Bond Ordinance 13763 || MSD 29 Supplemental Bond Ordinance 14225 || MSD 30 Supplemental Bond Ordinance 14312 || MSD 31 Supplemental Bond Ordinance 14567 || 2019 Wastewater Rate Change Proposal Civil Service Rules and Regulation June 2017 Rate Commission Exhibit Index Rate Commission Exhibit Index All documents will be posted on MSD Website unless noted 7/24/2019 14:37 Distribution Recipient(s) 2019 Wastewater Rate Change Proposal Rate Commission Exhibit Index Rate Commission Exhibit Index MSD 32 Supplemental Bond Ordinance 14571 || MSD 33 Supplemental Bond Ordinance 14572 || MSD 34 Supplemental Bond Ordinance 14835 || MSD 35 Supplemental Bond Ordinance 15077 || MSD 36 Supplemental Bond Ordinance 15098 || MSD 37 MSD Consent Decree || MSD 37A Second Material Amendment to Consent Decree (June 22, 2018)|| MSD 37B MSD Combined Sewer Overflow Long-Term Control Plan (LTCP) || MSD 37B1 2013 Update (LTCP) - Supplement 1 || MSD 37B2 2013 Update (LTCP) - Supplement 2 || MSD 37B3 2015 Update (LTCP) - Modifications A and B || MSD 37B4 2015 Update (LTCP) - DNR Approval Letter || MSD 37B5 2018 Update (LTCP) - Supplement 3 || MSD 37C MSD Sanitary Sewer Overflow Control Master Plan Executive Summary || MSD 38 Standard & Poor's Rating Report 2017 || MSD 39 Moody's Rating Report 2017 || MSD 40 Fitch Rating Report 2017 || MSD 41 Ordinance 14395 - Wastewater User Charge || MSD 42 || MSD 43 CIRP Project Listing FY2017-FY2020 || MSD 44 Map of Constructed SSO & CSO || MSD 45 FY 2018 MSD Annual Diversity Report || MSD 45A FY 2018 MSD Annual Diversity Report Presentation September 13, 2018 || MSD 46 || MSD 47 || MSD 48 || MSD 49 || MSD 50 Ordinance 13795 - Defined Contribution Plan || MSD 51 NACWA 2017 Survey | MSD 52 Rate Model (Excel File)| Emailed Excel File to Rate Commissioners, Lashly & Baer, Black & Veatch, Brandon N., MSD Ex. Mgmt. Not posted on MSD Website - Available Upon Request MSD 53 Rate Model Guide  RC 54 Resolution to Request 45-Day Extension from the District Board of Trustees 3/6/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management RC 55 Restated Rate Commission Operational Rules-2019 (As Adopted March 4, 2019)| RC 56 Rate Commission's First Discovery Request to MSD March 8, 2019 3/8/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management MSD 56A MSD's Response to First Discovery Request of the Rate Commission 3/13/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 56B Appendix 7.2.2 Detailed WW CIRP Project List (Excel File)| Emailed Excel File to RC, L&B, B&V, MSD Ex. Mgmt., Intervener Not posted on MSD Website - Available Upon Request MSD 56C Appendix 7.2.3 Detailed WW CIRP Project List – Not Regulatory or CD |Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 56D Appendix 7.2.4 Detailed WW CIRP Project List – Regulatory but not CD || Liberty Mutual - Long-Term Disability Ordinance 13796 & 14776 - Pension Plan Cigna - Life Cigna - Medical & Dental Ordinance 15048 - Sewer Use Ordinance All documents will be posted on MSD Website unless noted 7/24/2019 14:37 Distribution Recipient(s) 2019 Wastewater Rate Change Proposal Rate Commission Exhibit Index Rate Commission Exhibit Index MSD 56E 4-CIRP Adjustments November 5, 2018 || MSD 56F 4a-WW CIRP3 FY17 October 23, 2017 || MSD 56G 4b-WW CIRP RC FY16 to FY18 Report Construction Engineering August 21, 2018 || MSD 56H 4c-WW CIRP RC Report Construction Engineering November 2, 2018  MSD 57 Rate Commission Orientation and Summary 3/4/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 58 Intergovernmental Cooperation Agreement between MSD & City of Arnold || MSD 59 MSD Energy Saving Projects  RC 60 Resolution Adopting Procedural Schedule and Public Notice 3/12/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener RC 61 Rate Commission's Second Discovery Request to MSD March 11, 2019  MSD 61A MSD's Response to Second Discovery Request of the Rate Commission 3/20/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 61B MSD Combined Sewer Projects Prioritization System Worksheet || MSD 61C Sample Green Infrastructure (GI) Grant Worksheet || MSD 61D Review of Construction Projects in Progress, December 2018 || MSD 61E Process Review - Construction Change Orders, February 2016 || MSD 61F Review of the Capacity, Management, Operations, and Maintenance (CMOM) Program, July 2015 || MSD 61G Emergency Contracts, February 2018 || MSD 61H Review of Engineering Design and Construction Management Contracts/Invoices, May 2015 || MSD 61I Review of the Fleet Management Process, August 2016 || MSD 61J Review of the Inventory Management Process-Maintenance Repairs Operations (MRO), April 2017 || MSD 61K Overhead Rate Review, October 2014 || MSD 61L Review of Project Accounting, August 2014 || MSD 61M Review of Electric Utilities, February 2015 || MSD 61N Summary of Overhead Procedures  MIEC 62 Application to Intervene - Missouri Industrial Energy Consumers (MIEC)3/12/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener RC 63 Rate Commission's Third Discovery Request to MSD March 25, 2019 3/26/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 63A MSD's Response to the Third Discovery Request of the Rate Commission 4/2/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, IntervenerMSD 63B Project Justification and ID Form || MSD 63C Project Risk Quantification Monetization Tool || MSD 63D Project Monetized Prioritization Rulebook || MSD 63E Large Wastewater Revenue Bond Issuer Statistics || MSD 63F MSD 2018 Rating Agency Presentation || MSD 63G MSD Preliminary FY2020 Operating Budget || MSD 63H Ordinance 14854 - Connection Fees  MSD 64 MSD Opening Statement 4/9/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MIEC 65 MIEC's First Discovery Request to MSD April 8, 2019  MSD 65A MSD's Response to First Discovery Request of Interveners MIEC 4/18/2019 | MSD 65B 2005 CDM Wet Weather Flow Cost Allocation Study || MSD 65C Page 3-32 of 2007 Rate Proposal  RC 66 Rate Commission's Fourth Discovery Request to MSD April 11, 2019 4/11/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener All documents will be posted on MSD Website unless noted 7/24/2019 14:37 Distribution Recipient(s) 2019 Wastewater Rate Change Proposal Rate Commission Exhibit Index Rate Commission Exhibit Index MSD 66A MSD's Response to Fourth Discovery Request of the Rate Commission 4/22/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 66B Wastewater System Improvement and Refunding Revenue Bonds | MSD 66C Rate Model (Exhibit MSD 52) Unlocked (Excel File)| Emailed Excel File to Rate Commissioners, Lashly & Baer, Black & Veatch, Brandon N., MSD Ex. Mgmt. Not posted on MSD Website - Available Upon Request MSD 66D MSD Tunnel Projects |Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 66E 25 Year History of 20 Year MMD || MSD 66F MSD Insurance Summary 2017 || MSD 66G Current Projections Compared to 2015 Rate Model  MIEC 67 MIEC's Second Discovery Request to MSD April 11, 2019 4/11/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 67A MSD's Response to Second Discovery Request of Interveners MIEC 4/22/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 67B Moody's Water and Sewer Utilities 2019 Outlook Report || MSD 67C Comparison of FY19 Base Budget to FY18 Actual Expenses || MSD 67D Cost of Service and Financial Planning Model | MSD 67E Employment Cost Index FY21-FY24 (Excel File) Emailed Excel File to Rate Commissioners, Lashly & Baer, Black & Veatch, Brandon N., MSD Ex. Mgmt. Not posted on MSD Website - Available Upon Request MSD 68 Transcript of Technical Conference for District Testimony April 8, 2019 4/16/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 69 Transcript of Technical Conference for District Testimony April 9, 2019  RC 70 Rebuttal Testimony, Pamela Lemoine 4/23/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener RC 70A Summary of Wastewater Utility Bills || RC 70B Memo Summary of CIRP Development || RC 71 Rebuttal Testimony, Prabha Kumar || RC 72 Rebuttal Testimony, Nicole Young  MIEC 73 Rebuttal Testimony, Michael P. Gorman 4/24/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 74 MSD's First Discovery Request to Intervener MIEC April 26, 2019 4/26/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MIEC 75 MIEC'S Response to MSD's First Discovery Request 5/7/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MIEC 75A Treasury and Water - Sewer Bond Yields || MIEC 75B Accuracy of Interest Rate Forecasts || MIEC 75C Rate Model Used to Support Mr. Gorman's Rebuttal Testimony (Excel File)|| MIEC 75D Rate Model Using 3.5% Rate and Supporting Table 1 of Discovery Response No. 1 (Excel File)|| MIEC 75E Schedule MPG-3 (Excel File)|| MIEC 75F Schedules MPG-5 and MPG-6 (Excel File) MSD 76 MSD's Second Discovery Request to Intervener MIEC May 14, 2019 5/14/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MIEC 76A MIEC'S Response to MSD's Second Discovery Request 5/24/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener All documents will be posted on MSD Website unless noted 7/24/2019 14:37 Distribution Recipient(s) 2019 Wastewater Rate Change Proposal Rate Commission Exhibit Index Rate Commission Exhibit Index RC 77 Rate Commission's Fifth Discovery Request to MSD May 14, 2019 5/14/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 77A MSD's Response to the Fifth Discovery Request of the Rate Commission 5/24/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 77B BMP4 - Cost Estimating || MSD 77C BMP12 - Preliminary Studies || MSD 77D MSD Unit Costs Summary Item Listing || MSD 77E 12106 Cost Estimate || MSD 77F 12472 Cost Estimate || MSD 77G 13033 Cost Estimate || MSD 77H 12248 Cost Estimate || MSD 77I 12255 Cost Estimate  MIEC 78 MIEC's Third Discovery Request to MSD May 16, 2019 5/16/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 78A MSD'S Response to the Third Discovery Request of MIEC 5/28/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 78B Wastewater CIRP Project List FY21-24 Amended May 21, 2019 || MSD 78C Wastewater CIRP Project List FY21-24 Amended May 21, 2019 Projects Not Regulatory or CD related || MSD 78D Wastewater CIRP Project List FY21-24 Amended May 21, 2019 Regulatory related projects that are not CD related || MSD 78E MSD Coupon and Yield Debt Assumptions (Excel File)| Emailed Excel File to Rate Commissioners, Lashly & Baer, Black & Veatch, Intervener, MSD Ex. Mgmt. Not posted on MSD Website - Available Upon Request MSD 78F Bond Calculation Model (Excel File)|| MSD 78G Debt Scenario Results (Excel File) MSD 79 Transcript of Technical Conference for Rebuttal Testimony - May 9, 2019 5/23/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 80 Cover Memo to Rate Commission Secretary - Surrebuttal Testimony Submission 6/3/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 80A Surrbuttal Testimony: Richard Unverferth, MSD || MSD 80B Surrebuttal Testimony: Tom Beckley, RFC || MSD 80C Surrebuttal Testimony: William Stannard, RFC || MSD 80D Surrebuttal Testimony: Marion Gee, MSD || MSD 80E Surrebuttal Testimony: Bethany Pugh, PFM || MSD 80F Surrebuttal Testimony: Tim Snoke, MSD || MSD 80F1 Range of MMD over last 15 Years with Current Yield Percentile || MSD 80F2 Historical Rate Volatility by Fiscal Year  RC 81 Surrebuttal Testimony: Pam Lemoine, B&V 6/3/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener RC 82 Surrebuttal Testimony, Nicole Young, B&V || MIEC 83 Surrebuttal Testimony, Michael Gorman | MIEC 83A MIEC Surrebuttal Testimony Rate Model (Excel File) Emailed Excel File to Rate Commissioners, Lashly & Baer, Black & Veatch, Intervener, MSD Ex. Mgmt. Not posted on MSD Website - Available Upon Request MSD 84 Transcript of Public Hearing - May 14, 2019 6/12/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 85 Rate Impact - 50%/50% Infiltration and Inflow Allocation 6/21/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 86 Transcript of Public Hearing - June 4, 2019  All documents will be posted on MSD Website unless noted 7/24/2019 14:37 Distribution Recipient(s) 2019 Wastewater Rate Change Proposal Rate Commission Exhibit Index Rate Commission Exhibit Index MIEC 87 MIEC's First Discovery Request to the Rate Commission June 24, 2019 6/25/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener RC 87A Rate Commission's Response to First Discovery Request of MIEC 7/5/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener RC 87B Analysis based on 4.5% Premium (Excel File) Emailed Excel File to Rate Commissioners, Lashly & Baer, Black & Veatch, Intervener, MSD Ex. Mgmt. Not posted on MSD Website - Available Upon Request MIEC 88 MIEC's Fourth Discovery Request to MSD June 24, 2019 6/25/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 88A MSD's Response to MIEC's Fourth Discovery Request 7/3/2019 Emailed notification and Excel Files to Rate Commissioners, Lashly & Baer, Black & Veatch, Intervener, MSD Ex. Mgmt. Excel files not posted on MSD Website - Available Upon Request MSD 88B 70-30 CIRP Funding St. Louis MSD Rate Financial Plan Model FY21-24 (Excel File)|| MSD 88C CIRP Delay St. Louis MSD Rate Financial Plan Model FY21-24 (Excel File)|| MSD 88D Requested Model Changes || MSD 88E 70-30 CIRP Funding and CIRP Delay (Excel File) RC 89 Rate Commission's Sixth Discovery Request to MSD June 25, 2019 6/25/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 89A MSD's Response to the Rate Commission's Sixth Discovery Request 7/3/2019 Emailed notification and Excel Files to Rate Commissioners, Lashly & Baer, Black & Veatch, Intervener, MSD Ex. Mgmt. Excel files not posted on MSD Website - Available Upon Request MSD 89B Bissell Air Permit || MSD 89C Lemay Air Permit || MSD 89D Declaration of Jodi M. Bruno, EPA || MSD 89E Unopposed Motion to Enter Proposed Second Material Amendment to Consent Decree || MSD 89F Solids Handling Master Plan Executive Summary || MSD 89G Solids Handling Master Plan Phase 1 Technical Memorandum || MSD 89H Solids Handling Master Plan Phase 2 Technical Memorandum || MSD 89I Solids Handling Master Plan Phase Technical Memorandum Update || MSD 89J Rate Impact at Various Usage Levels for 50% Customer 50% Volume II (Excel File)|| MSD 89K Rating Change History || MSD 89L St Louis MSD Rate Financial Plan Model FY21-24 Extra 25 Per Year (Excel File)|| MSD 89M Plant Asset Comparison 2019 2015 (Excel File)|| MSD 89N CIRP Discretionary Spending FY16 - FY19  RC 90 Rate Commission's First Discovery Request to MIEC June 25, 2019 6/25/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MIEC 90A MIEC'S Response to the Rate Commission's First Discovery Request 7/3/2019 Emailed notification and Excel Files to Rate Commissioners, Lashly & Baer, Black & Veatch, Intervener, MSD Ex. Mgmt. Excel files not posted on MSD Website - Available Upon Request MIEC 90B Citizens-Indianapolis Infiltration-Inflow Analysis-v1 || MIEC 90C Comparison of Typical Wastewater Bills-v1 (Excel File) All documents will be posted on MSD Website unless noted 7/24/2019 14:37 Distribution Recipient(s) 2019 Wastewater Rate Change Proposal Rate Commission Exhibit Index Rate Commission Exhibit Index MSD 91 Transcript of Surrebuttal Testimony June 20, 2019 7/9/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 92 Prehearing Conference Summary of MSD 7/12/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 93 Transcript of Public Hearing June 27, 2019 7/17/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 94 Transcript of Public Hearing May 22, 2019  MSD 95 MSD Prehearing Conference Report 7/19/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener MSD 96 Transcript of Prehearing Conference July 12, 2019 || RC 97 Rate Commission Prehearing Conference Report || MIEC 98 MIEC Prehearing Conference Report  MIEC 98A MIEC Submittal of Revised Appendix B to Prehearing Conference 7/23/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener RC 99 Customer Comments submitted to Consumers Council of Missouri 7/24/2019 Email notification sent to RC, L&B, B&V, RFC, MSD Executive Management, Intervener RC 100 District Response to Inquiry from Robert Schuetz || RC 101 Letter from Kevin Morris regarding Non-metered Charges || MSD 102 Submittal of Exhibit Index as of July 24, 2019 