Date
                           
    Economic Value of Produced Water Management   QuickStart Guide  
                       
    Name*            
    Email*            
   
I Accept the Terms of the License Agreement contained in the QuickStart Guide.*    
* required field to use the model
    Economic Value Proposition Matrix® Release 2.1.1      
      Standard Version 2.0              
                         
                           
    Disclaimer: This model is  to be used for Modeling Purposes ONLY, and should not be used       
for any investment purpose or assessment of the company's financial condition or business model.
Blue Font Input Cells can be changed to generate "What If" Scenarios.
Black Font Cells are Calculated or Linked and CANNOT be changed directly
        EVPM Solution Tabs            
        Start                  
        Economic Input              
        TCO (Total Costs of Ownership)            
        Economic Value Assessment            
        Dashboard                
        For more information            
          Contact Us              
          +1.281.414.6958            
          www.theRRInstitute.com          
          EVPM Website              
Copyright © 2016-20 The Rapid Response Institute LLC.  All Rights Reserved.
↑ Top of Page
  Economic Input -- Same currency throughout unless otherwise noted  
  The Numbers in Blue Font are Provided for Convenience, Please Change Accordingly.  Each Tab is Constructed the Same Way.  
    Production Revenue*      
    Type Well
 
      Average Unit Sales Price  
Units / Day Revenue
    Daily  
Weekly
Annually (365 days)
    Operational Cost*    
    Process Average Cost / Day  
    Possible Damages (avoided)    
    Select 0    
Regulatory Fines
Legal Action
Public Relations
Other
Total
Caveat: This is a representative list and NOT meant to be all inclusive.
    Personnel Costs/Hour    
  Fully Burdened Cost includes salary, benefits and other costs    
   
   
  Blended Cost (Average)    
↑ Top of Page
                     
  Total Cost of Ownership Overview   
                     
        Initial Year 1 Year 2 Year 3 Year 4 Year 5  
   
   
   
    Sub-Total  
   
     
    Sub-Total  
   
     
    Sub-Total  
  Internal Cost Components  
     
    Sub-Total  
    Note: Not necessary cash flow but fully burdened cost          
    Total Cash Investment  
    Total Internal & External  
↑ Top of Page
  Risk Mitigation                
  Select from the following lists or enter your own risk exposure from produced water.  Note that some items are similar so be careful not to double count.          
  Expected Costs from Incidents/Unplanned Downtime/Other Produced Water Issues              
  Risk Variable  Description    Likelihood   Percentage Dollar Value Expected Cost  
        Very Low            Very High        
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
Total Expected Cost
↑ Top of Page
  Economic Value Assessment       Operations Utilization Rate (uptime)      
  Type of Operations   Daily Ops Cost    
 
 
 
 
     
  NPV Discount Rate       Percentage                
  Components of Value                            
  Item No. Division/Group   Category Description    Assumptions   Year 1   Year 2   Year 3   Year 4   Year 5   Total   
  Directly Measurable                                
    Impact on Revenue                              
    Note:  These Components of Value are a function of Production such as increased facilities output.  These data are not directly entered independently.                      
              Slider Percentage                          
  1
 
 
             
  2
 
 
             
  3
 
 
             
              Subtotal              
    Achieving Operational Excellence Savings                              
    Note:  These Components of Value are a function of the direct cost of daily operations such as reduced process cycle time.  These data are not directly entered independently.                  
              Slider Percentage                          
  4
 
 
             
  5
 
 
             
  6
 
 
             
  7
 
 
             
              Subtotal              
    Additional Cost Savings                                
    Note:  These Components of Value are additional direct costs such as replacing older less efficient equipment--often one time events.  These data can be directly entered independently.                            
  8
 
                 
            Likelihood                
              Expected Impact              
  9
 
                 
            Likelihood                
              Expected Impact              
  10
 
                 
            Likelihood                
              Expected Impact              
              Subtotal              
              Total Directly Measurable              
                                         
                                     
  Item No. Division/Group   Category Description    Assumptions   Year 1   Year 2   Year 3   Year 4   Year 5   Total   
  Not Directly Measurable                              
    Impact on Revenue                              
    Note:  These Components of Value are a function of Production such as increased efficiency.  These data are not directly entered independently.                                    
              Slider Percentage                          
  1
 
 
             
  2
 
 
             
  3
 
 
             
              Subtotal              
    Achieving Operational Excellence Savings                              
    Note:  These Components of Value are a function of the direct cost of daily operations such as increased efficiency.  These data are not directly entered independently.                  
              Slider Percentage                          
  4
 
 
             
  5
 
 
             
  6
 
 
             
  7
 
 
             
              Subtotal              
    Additional Cost Savings                                
    Note:  These Components of Value are additional direct costs not doing something.  These data can be directly entered independently.                            
  8
 
                 
              Likelihood                
              Expected Impact              
  9
 
                 
              Likelihood                
              Expected Impact              
  10
 
                 
              Likelihood                
              Expected Impact              
              Subtotal              
    Expected Costs from Incidents/Unplanned Downtime/Other                          
    Note:  These Components of Value are additional direct costs resulting from HSE incidents.  This is indirect in this model because the actual impact is unknown until all aspects of the incident are closed.              
  1
 
               
        Likelihood is determined on Risk Assessment Tab but you can change if think risk goes up  or down by year.                
              Expected Impact              
              Subtotal              
                                         
              Total Not Directly Measurable              
Note:  Soft numbers are generally not used in the (base) value proposition calculation.  They can provide management with visibility into the possible.
                                         
  Item No. Division/Group   Category Description    Assumptions   Year 1   Year 2   Year 3   Year 4   Year 5   Total   
  Possible Damages (avoided)                          
              Use Slider for Percentage   Expected Damages      
1
Likelihood
  2
 
                 
Likelihood
  3
 
                 
Likelihood
  4
 
                 
Likelihood
          Total Damages              
                                         
  Item No. Division/Group   Category Description    Assumptions   Year 1   Year 2   Year 3   Year 4   Year 5   Total   
  Personnel Cost (Direct & Indirect) Reduction                          
              Slider Percentage   Personnel Impact Rate      
(Number of Personnel)
    Directly Measurable                      
  1
 
 
             
              Subtotal              
    Not Directly Measurable                                
  2
 
 
             
              Subtotal              
        Total Personnel Costs              
                                         
  Economic Value Summary                              
        Initial                    
   Investment in Solution                       
   Total Economic Value                                     
                         
                         
    Personnel Cost                        
    Total Value                        
     Net Total                       
                                         
                  Net Present Value @                  
Notes: Positive impact begins at Year 1 making the model conservative.  Value can logically be expected to be attained earlier as the project is most likely less than one year duration.
Not Directly Measurable also includes Possible Damages.
↑ Top of Page
  Outcome Dashboard    
 
                   
2
2
2
2
  Summary Overview   Incidents/Unplanned Downtime/Other  
  Item     Total   Item     Cost  
     
     
     
     
               
                 
↑ Top of Page