The top table contains various phase-out models; The lower table contains a record of the actual phase-out.                    
   
 
  Model Name Standard Optimistic Zero Test AS            
  Disk phased out after 3 years 10% 10% 0% 0% 0%    
   4 years 50% 40% 0% 0% 10%    
  5 years 100% 100% 0% 100% 100%          
  CPU phased out after 3 years 10% 10% 0% 0% 0%          
   4 years 50% 25% 0% 0% 5%    
  5 years 100% 100% 0% 100% 100%          
  Tape phased out after 3 years 10% 0% 0% 0% 0%          
   4 years 50% 10% 0% 0% 0%    
  5 years 100% 100% 0% 100% 100%          
       
  Red Cell?   Cells go red if entry is invalid: Year 4 numbers must be greater or equal to Year 3 etc.  
  Note: Phase-out is assumed not to be continuous. That is, exactly 3/4/5 years after the purchase date a block of hardware is removed.  
  This can give rise to some boundary effects if the status date in the Tier-1 Capacity Worksheet is moved one side or other of a phase-out date.  
 
    Quantity Phased-Out Cumulative Totals  
  Date Disk CPU Tape Disk CPU Tape  
    [TB] [KSI2K] [TB] [TB] [KSI2K] [TB]  
  01-Apr-01 0 0 0 0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
          0 0 0  
 
 
 
 
     
  Standard C  
  Optimistic D  
  Zero E  
  Test F  
  AS G  
    H  
    I  
    J  
    K