Docstoc

COO_ROI_-_working_model

Document Sample
COO_ROI_-_working_model Powered By Docstoc
					                          A                          B                       C      D       E      F      G       H       I        J
                                                                                        MULTI-
                                           DATA CATEGORY                  UNITS   Value                LEI Tool       Other Tool
 1                                                                                       Plier
 2


     Cost of Ownership Calculations (Comparison/Saving $)
 3
 4
 5 VOLUME/THROUGHPUT DATA
 6 TOTAL TIME BASIS                                                    HOURS
 7
 8 MACHINE TIME NOT AVAILABLE
 9                                   SCHED. REPAIRS/MAINTENANCE        HRS/WK
10                                   ENGINEERING USAGE                 HRS/WK
11                                   OTHER NON-PRODUCT USAGE           HRS/WK
12                                   MTBF (mean time before failure)   HOURS
13                                   MTTR (mean time to repair)        HOURS
                                     TOTAL TIME LOST DUE TO
14                                   UNRELIABILITY

15                                   MTBA (Mean Time Between Assists) HOURS
16                                   MTTA (Mean Time To Assist)       HOURS

17                                   TOTAL TIME LOST DUE TO ASSIST
18
19   TOTAL AVAILABLE TIME                                              HOURS
20   THRUPUT AT CAPACITY             Howmany sites/wafer               WFRS/HR
21   TOTAL WAFERS PROCESSED                                            UNITS
22   YIELD LOSS                                                        WFRS/WK
23   LOADING FACTOR                                                    FRACTION
24   WAFERS PROCESSED/LIFETIME                                         UNITS
25
26
27
28   TOTAL SAVINGS                                                                                        0               0
29
                                                                                          MULTI-
     EQUIPMENT DATA (Cost $)               DATA CATEGORY                  UNITS   Value
                                                                                           Plier
                                                                                                       LEI Tool       Other Tool
30
31
32   ORIGINAL COST OF EQUIPMENT
33                                   CAPITAL COST /UNIT                DOLLARS                           $0              $0
34                                   TRANSPORTATION COST               DOLLARS                           $0              $0
35                                   INSTALLATION COST                 DOLLARS                           $0              $0
36                                   OTHER DEPRECIABLE COSTS           DOLLARS                           $0              $0
37
38   EQUIPMENT QUALIFICATION COSTS
39                                   TIME REQUIRED                     MAN-HRS                           $0              $0
40                                   CONSUMABLES                       DOLLARS                           $0              $0
41                                   MATERIAL ( WAFERS ETC.)           DOLLARS                           $0              $0
42                                   OTHER COSTS                       DOLLARS                           $0              $0
43
44   FLOOR SPACE REQUIREMENTS
45                                   CLASS 1                           SQ. FT.                           $0              $0
46                                   CLASS 10                          SQ. FT.                           $0              $0
47                                   OTHER                             SQ. FT.                           $0              $0
48
49   TRAINING REQUIREMENTS
50                                   TIME REQUIRED                     MAN-HRS                           $0              $0
51
52   OPERATING COSTS
53                                   OPERATORS PER SYSTEM              FRACTION                          $0              $0
54                                   ENGINEERING OVERHEAD              FRACTION                          $0              $0
55                                   OTHER CONSUMABLES                 $/WEEK                            $0              $0
56
57   MAINTENANCE COSTS
58                                   SPARE PARTS                       $/YEAR                            $0              $0
59   PM's? time/cost, downtime       VENDOR SERVICE CONTRACT           $/YEAR                            $0              $0
60   MTTF, avg repair time           VENDOR TRAINING                   DOLLARS                           $0              $0
61                                   MAINTENANCE PERSONNEL             FRACTION                          $0              $0
62
63   Total Cost                                                                                           0              $0
64
 65 Savings -         Cost =                                                                              0               0
TSE231.XLS, 9/14/94
                        A                               B                   C           D       E      F         G         H     I      J
                                                                                            MULTI-
                                                DATA CATEGORY           UNITS         Value                intial/1 year       5 YEAR
 1                                                                                           Plier
 2
     Return Of Investment
 3   Calculations (Saving $)
 4
 5   Labor Reduction
 6                                         Labor Rate                full person                                $0              $0
 7                                                                   partial person                             $0              $0
 8
 9   Scrap wafer Reduction
10           Savings at Equipment          Wafer Cost                per run                                    $0              $0
11             or later in process?                                  per wafer                                  $0              $0
12       material/process cost on wafer?
13               substarte cost?
14                Lost runs/day?
15
16   Yield Improvement
17             Yield % from - to?          Wafer Cost                per wafer                                  $0              $0
18              Reduce labor?                                        within wafer                               $0              $0
19      Less capacity needed per wafer?
20
21 Capacity Improvement
22                                      Wafer Cost                   % of increase                              $0              $0
          Wafer output increase?
23
   reduce amount of process equipment ?
24
              reduce labor?
25
         Reduce operations time?
26
27
28   TOTAL SAVINGS                                                                                              0                0
29
                                                                                              MULTI-
                                                DATA CATEGORY           UNITS         Value                intial/1 year       5 YEAR
30   EQUIPMENT DATA (Cost $)                                                                   Plier
31
32   ORIGINAL COST OF EQUIPMENT
33                                         CAPITAL COST /UNIT        DOLLARS                                    $0              $0
34                                         TRANSPORTATION COST       DOLLARS                                    $0              $0
35                                         INSTALLATION COST         DOLLARS                                    $0              $0
36                                         OTHER DEPRECIABLE COSTS   DOLLARS                                    $0              $0
37
38   EQUIPMENT QUALIFICATION COSTS
39                                         TIME REQUIRED             MAN-HRS                                    $0              $0
40                                         CONSUMABLES               DOLLARS                                    $0              $0
41                                         MATERIAL ( WAFERS ETC.)   DOLLARS                                    $0              $0
42                                         OTHER COSTS               DOLLARS                                    $0              $0
43
44   FLOOR SPACE REQUIREMENTS
45                                         CLASS 1                   SQ. FT.                                    $0              $0
46                                         CLASS 10                  SQ. FT.                                    $0              $0
47                                         OTHER                     SQ. FT.                                    $0              $0
48
49   TRAINING REQUIREMENTS
50                                         TIME REQUIRED             MAN-HRS                                    $0              $0
51
52   OPERATING COSTS
53                                         OPERATORS PER SYSTEM      FRACTION                                   $0              $0
54                                         ENGINEERING OVERHEAD      FRACTION                                   $0              $0
55                                         OTHER CONSUMABLES         $/WEEK                                     $0              $0
56
57   MAINTENANCE COSTS
58                                         SPARE PARTS               $/YEAR                                     $0              $0
59   PM's? time/cost, downtime             VENDOR SERVICE CONTRACT   $/YEAR                                     $0              $0
60   MTTF, avg repair time                 VENDOR TRAINING           DOLLARS                                    $0              $0
61                                         MAINTENANCE PERSONNEL     FRACTION                                   $0              $0
62
63   Total Cost                                                                                                 0               $0
64
65   Savings - Cost =                                                                                           0                0
TSE231.XLS, 9/14/94
                      A                             B                       C        D      E      F      G            H
 1                                            DATA CATEGORY               UNITS     YRS   MULTI-                    DATA
 2                                                                                        PLIER         LEI 1      LEI - 2
 3   VOLUME/THROUGHPUT DATA                                                                             RS300      RS300
 4   TOTAL TIME BASIS                                                    HOURS                     w/o mini en    mini env
 5                                                                                                     w/o foup     foup
 6   MACHINE TIME NOT AVAILABLE                                                                        3 ranges   3 ranges
 7                                SCHED. REPAIRS/MAINTENANCE             HRS/WK      5     260             0           2
 8                                ENGINEERING USAGE                      HRS/WK      5     260             2           2
 9                                OTHER NON-PRODUCT USAGE                HRS/WK      5     260             2           2
10                                MTBF                                   HOURS              1            5000       1500
11                                MTTR                                   HOURS              1             24          24
12                                TOTAL TIME LOST DUE TO UNRELIABILITY
13                                MTBA                                   HOURS              1            100        100
14                                MTTA                                   HOURS              1            0.1        0.1
15                                TOTAL TIME LOST DUE TO ASSIST
16
17   TOTAL AVAILABLE TIME                                                HOURS
18   THRUPUT AT CAPACITY, 9 SITES/WFR                                    WFRS/HR            1            147        147
19   TOTAL WAFERS PROCESSED                                              UNITS
20   YIELD LOSS                                                          WFRS/WK     5     260            0          1
21   LOADING FACTOR                                                      FRACTION                         1          1
22   WAFERS PROCESSED/LIFETIME                                           UNITS
23




TSE231.XLS, 9/14/94
                  A                              B             C     D       E        F     G        H
24   EQUIPMENT DATA
25   ORIGINAL COST OF EQUIPMENT
26                              CAPITAL COST /UNIT        DOLLARS            1            396457   693800
27                              TRANSPORTATION COST       DOLLARS            1               0        0
28                              INSTALLATION COST         DOLLARS            1               0      20000
29                              OTHER DEPRECIABLE COSTS   DOLLARS            1               0      10000
30   EQUIPMENT QUALIFICATION COSTS
31                              TIME REQUIRED             MAN-HRS          $100            100      100
32                              CONSUMABLES               DOLLARS            1              0      2000
33                              MATERIAL ( WAFERS ETC.)   DOLLARS            1              0      1000
34                              OTHER COSTS               DOLLARS            1              0      1000
35   FLOOR SPACE REQUIREMENTS
36                              CLASS 1                   SQ. FT.          $510            24       30
37                              CLASS 10                  SQ. FT.          $330
38                              OTHER                     SQ. FT.          $250             0        0
39   TRAINING REQUIREMENTS
40                              TIME REQUIRED             MAN-HRS          $100             4       200
41   OPERATING COSTS
42                              OPERATORS PER SYSTEM      FRACTION   5    $600,000          0.1      0.3
43                              ENGINEERING OVERHEAD      FRACTION   5   $1,500,000        0.05     0.05
44                              OTHER CONSUMABLES         $/WEEK     5       260             0      100
45   MAINTENANCE COSTS
46                              SPARE PARTS               $/YEAR     5       5            1000     25000
47                              VENDOR SERVICE CONTRACT   $/YEAR     5       4              0      25000
48                              VENDOR TRAINING           DOLLARS            1
49                              MAINTENANCE PERSONNEL     FRACTION   5   $675,000           0       0.1
50
51   TOTAL COST DURING LIFETIME
52
53   COST/WAFER MEASURED/LEVEL




TSE231.XLS, 9/14/94
        I    J      K            L        M
 1                       5 YEAR TOTALS
 2 ThermaW       LEI - 1      LEI 2   ThermaW
 3 Optiprobe    RS300        RS300    Optiprobe
 4 w/o mini     43,800       43,800    43,800
 5 w/o foup
 6
 7      2           0          520       520
 8      2         520          520       520
 9      2         520          520       520
10   1500
11     24
12                209          682       682
13    100
14    0.1
15                 44           43        43
16
17              42,507       41,515    41,515
18     33
19             6,248,530    6,102,733 1,370,001
20      1           0          260       260
21      1
22             6,248,530    6,102,473 1,369,741
23




TSE231.XLS, 9/14/94
          I     J        K          L           M
24
25
26    318000        $396,457    $693,800     $318,000
27       0             $0          $0           $0
28     20000           $0        $20,000      $20,000
29     10000           $0        $10,000      $10,000
30
31      100           $10,000    $10,000     $10,000
32     2000             $0        $2,000      $2,000
33     1000             $0        $1,000      $1,000
34     1000             $0        $1,000      $1,000
35
36       55           $12,240    $15,300     $28,050
37                      $0         $0          $0
38       0              $0         $0          $0
39
40      200            $400      $20,000     $20,000
41
42       0.3          $60,000   $180,000     $180,000
43      0.05          $75,000    $75,000      $75,000
44      100             $0       $26,000      $26,000
45
46     25000          $5,000    $125,000     $125,000
47     25000            $0      $100,000     $100,000
48                      $0         $0           $0
49      0.1             $0       $67,500      $67,500
50
51                  $559,097    $1,346,600   $983,550
52
53                     $0.09      $0.22       $0.72




TSE231.XLS, 9/14/94
                  A                           B               C       D      E      F     G           H       I      J             K
 1                                      DATA CATEGORY       UNITS    YRS   MULTI-              DATA                   5 YEAR TOTALS
 2                                                                         PLIER        LEI tool   Vendor X       LEI tool      Vendor X
3    VOLUME/THROUGHPUT DATA
4
5
6
7    TOTAL AVAILABLE TIME                                 HOURS                                                    #REF!         #REF!
8    THRUPUT AT CAPACITY, 9 SITES/WFR                     WFRS/HR            1           147         33
9    TOTAL WAFERS PROCESSED                               UNITS                                                    #REF!         #REF!
10   YIELD LOSS                                           WFRS/WK #REF!    #REF!          1           1            #REF!         #REF!
11   LOADING FACTOR                                       FRACTION                        1           1
12   WAFERS PROCESSED/LIFETIME                            UNITS                                                    #REF!         #REF!
13
14   EQUIPMENT DATA
15   ORIGINAL COST OF EQUIPMENT
16                              CAPITAL COST /UNIT        DOLLARS            1          693800     318000         $693,800     $318,000
17                              TRANSPORTATION COST       DOLLARS            1             0          0              $0           $0
18                              INSTALLATION COST         DOLLARS            1           20000      20000          $20,000     $20,000
19                              OTHER DEPRECIABLE COSTS   DOLLARS            1           10000      10000          $10,000     $10,000
20   EQUIPMENT QUALIFICATION COSTS
21                              TIME REQUIRED             MAN-HRS          $100           100        100          $10,000       $10,000
22                              CONSUMABLES               DOLLARS            1           2000       2000          $2,000         $2,000
23                              MATERIAL ( WAFERS ETC.)   DOLLARS            1           1000       1000          $1,000         $1,000
24                              OTHER COSTS               DOLLARS            1           1000       1000          $1,000         $1,000
25   FLOOR SPACE REQUIREMENTS
26                              CLASS 1                   SQ. FT.          $510           30         55           $15,300       $28,050
27                              CLASS 10                  SQ. FT.          $330                                     $0            $0
28                              OTHER                     SQ. FT.          $250           0           0             $0            $0
29   TRAINING REQUIREMENTS
30                              TIME REQUIRED             MAN-HRS          $100          200         200          $20,000       $20,000
31   OPERATING COSTS
32                              OPERATORS PER SYSTEM      FRACTION          $0           0.3         0.3            $0            $0
33                              ENGINEERING OVERHEAD      FRACTION          $0           0.05        0.05           $0            $0
34                              OTHER CONSUMABLES         $/WEEK             0           100         100            $0            $0
35   MAINTENANCE COSTS
36                              SPARE PARTS               $/YEAR   #REF!   #REF!        25000       25000          #REF!         #REF!
37                              VENDOR SERVICE CONTRACT   $/YEAR   #REF!   #REF!        25000       25000          #REF!         #REF!
38                              VENDOR TRAINING           DOLLARS            1                                      $0            $0
39                              MAINTENANCE PERSONNEL     FRACTION #REF!   #REF!          0.1        0.1           #REF!         #REF!
40
41   TOTAL COST DURING LIFETIME                                                                                    #REF!         #REF!
42
 43 COST/WAFER
TSE231.XLS, 9/14/94   MEASURED/LEVEL                                                                               #REF!         #REF!

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:10/24/2012
language:Unknown
pages:7