billing design project - new...
TRANSCRIPT
![Page 1: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/1.jpg)
Billing Design Project
NEW Water Kick-Off Meeting
April 2, 2015
NEW Water - Green Bay Metropolitan Sewerage District
![Page 2: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/2.jpg)
Todays Agenda
• Introductions
• Project Background
• Billing Design Approach
• Project Plan and QA/QC
• Key Considerations
• Next Steps
• Questions/Discussion
2
![Page 3: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/3.jpg)
Introductions - The Project Team
3
Project Manager
Isabella Schroeder
QA/QC and Technical
Resources
Michael Rotuno
Ertan Akbas
Lead Analyst
Aditya Ramamurthy
Support Analysts
A. Corrigan; B. Chenevy
Design
Tom Sinning
NEW Water Staff
Advisory and Testing
![Page 4: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/4.jpg)
NEW Water
• Brian Vander Loop, Project Manager
• Bill Oldenburg, Pretreatment Coordinator/Assist. Project Manager
• Nathan Qualls, Director of Technical Services
• Mike Peroutka, IT Systems Administrator
• Eric Hepp - LIMS administer
• Holly Blazer - Analytical Chemist
• Timely respond to requests for information
• Provide critical direction
• Conduct testing
Key Participants
Responsibilities
![Page 5: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/5.jpg)
Todays Agenda
• Introductions
• Project Background
• Billing Design Approach
• Project Plan and QA/QC Process
• Key Considerations
• Next Steps
• Questions/Discussion
5
![Page 6: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/6.jpg)
Project Background
• NEW Water Current System:
• Owns and operates 2 Treatment Plants (Green Bay and De
Pere) with average daily flows of 35 mgd
• 18 wholesale customers, 2 contract customers
• 29 permanent metering stations
• Access/SQL based billing program
• Mission Communications M-800 units and web-based servers
for flow data
• MS SQL database for loading data
6
![Page 7: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/7.jpg)
Project Background
• Billing Design Project:
• This project is the next step having completed the 2014
Billing Methodology Study which identified the preferred
billing framework for quantifying flow and loadings for
invoicing purposes.
• Project requires development and deployment of a billing
system to implement the preferred billing methodology and
simultaneously meet other objectives of NEW Water:
• Move to current technology
• Reduce manual entry of data
• Ease of use and maintenance
• New billing program in place for calendar year 2016.
7
![Page 8: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/8.jpg)
Key Billing Methodology Changes
• Mass loading vs. concentration basis
• Smoothing of loadings – Year-to-date Actuals
and Remaining Month Estimates (budgeted)
• December end-of-year True-Up non-metered /
non-sampled areas
• Annual review of “proxy” stations and updates
as required to approved unmetered/unsampled
flows/loadings.
• Approved fixed loadings based on mass units
vs. concentration.
• No I/I Distribution Credit/Charge Allocation
![Page 9: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/9.jpg)
Todays Agenda
• Introductions
• Project Background
• Billing Design Approach
• Project Plan and QA/QC Process
• Key Considerations
• Next Steps
• Questions/Discussion
9
![Page 10: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/10.jpg)
Billing Design Approach
Provide a collaborative team
approach for development and
deployment of the customer
billing system that incorporates
frequent feedback from end
users, while optimizing the
system development time with
value-added activities.
10
Based on New Technology
Easy to Maintain Minimizes Manual Entry
Billing Design
![Page 11: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/11.jpg)
System Development Life-Cycle (SDLC)
11
![Page 12: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/12.jpg)
Todays Agenda
• Introductions
• Project Background
• Billing Design Approach
• Project Plan and QA/QC Process
• Key Considerations
• Next Steps
• Questions/Discussion
12
![Page 13: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/13.jpg)
Project Plan Document
Scope of Services
Communications Management
Quality Management and Control
13
Project Budget
Project Schedule
![Page 14: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/14.jpg)
Meeting Dates
14
Key Meeting Dates Date
#1: NEW Water Kick-off Meeting April 2, 2015
#2: Functional/Technical Design (20%) May 20, 2015
#3: Application Development Progress (40%) July 2, 2015
#4: On Site Alpha Testing (60%) August 13, 2015
#5: Beta Testing (90%) October 9, 2015
#6: On Site Program Training November 24, 2015
#7: Final Acceptance Meeting January 29, 2016
![Page 15: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/15.jpg)
Data Access and QA/QC
SharePoint Site [Still in Progress] Remote Access: • NEW Water VPN (requires software and credentials on the
remote user’s PC) • LogMeIn Account
NEW Water Remote Testing/Development Environment: • complete with Access 2013 • snapshot copies of Billing, Starlims, and Rockwell SQL
Server databases • standalone copy of the current Access application
15
![Page 16: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/16.jpg)
Todays Agenda
• Introductions
• Project Background
• Billing Methodology Approach
• Project Plan
• Key Considerations
• Next Steps
• Questions/Discussion
16
![Page 17: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/17.jpg)
17
Meets Objectives of Billing
Methodology Study Based on New Technology
East to Maintain Minimizes Manual Entry
Key Considerations
Billing Methodology Alternatives
![Page 18: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/18.jpg)
Bad Input
Data
Other Objectives
18
Potential
Future
Requirements
Statistical
Analysis
Other
Changes in
Sampling
Data and
Frequency
![Page 19: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/19.jpg)
Todays Agenda
• Introductions
• Project Background
• Billing Methodology Approach
• Stakeholder Process
• Key Considerations
• Next Steps
• Questions/Discussion
19
![Page 20: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/20.jpg)
Next Steps
20
Task Date
ARCADIS Activities:
• On-Site Interviews
• SharePoint Site
• Updated Project Plan
April 2 and 3
Week of April 6th
NEW Water Activities:
• Participate in Interviews
• Provide Requested Data
April 2 and 3
Next Meeting (20% Complete) May 20, 2015
![Page 21: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/21.jpg)
Questions/Discussion
![Page 22: Billing Design Project - NEW Waternewwater.us/media/146940/billingmethodologykickoffppt4022015.pdf · • Billing Design Project: •This project is the next step having completed](https://reader031.vdocuments.us/reader031/viewer/2022022807/5cdcb65088c993b15e8c8c9e/html5/thumbnails/22.jpg)
22