Alternatives to Increase Production Through the Bottleneck Tool Worksheet Using the Pre-loaded CUBES Model/Spreadsheet below: Evaluate the following tool

Alternatives to Increase Production Through the Bottleneck Tool Worksheet Using the Pre-loaded CUBES Model/Spreadsheet below:

Evaluate the following tool improvements in terms of CUBES tool efficiency and increase and total units produced.

CUBES251-1.XLS

You are given 4 alternatives to increase production through this bottleneck tool

(HINT: after each alternative, reload the spreadsheet back to original settings).

What is the now the CUBES tool efficiency and increase, % increase and new total of units that the bottleneck can produce for each alternative:

Alternative 1) Idle time is reduced to zero = 1.5 points

Alternative 2) Non-Scheduled time is reduced to Zero =1.5 points

Alternative 3) Actual tool speed is increase by 5% from its current speed of 40 units per hour = 1.5 points

Alternative 4) Quality losses reduced from 10 to 5 % but 2 hr increase in engineering hours = 1.5 points

What is the impact of doing all 4 improvements at once? = 4 points In p u t S e c t io n
U s e r D e f in e d Var iab le N ame s
CapacityUtilization Bottleneck EfficiencySystem(CUBES)
Copyright SEMATECH1993-1996
Version 2.51
11/22/1996
C o r r e c t iv e Ac t io n L o g
PRINT CORRECTIVE ACTION
LOG
USE
USER DEFINED
NAMES
USE TESTER
SPECIFIC
NAMES
USE
STANDARD
NAMES
READ CUBES
DATA FILE
E10
TEMPLATE
OEE-TPM OPTIONAL
INPUTS
OEE TEMPLATE
ACRONYMS LIST
GLOBAL INPUTS
INPUTMAPPINGASSUMPTIONS
Total Time(Hours)
Theoretical Tool Speed (UPH)
Plan Tool Speed (UPH)
Actual Tool Speed (UPH) ***
AverageBatch Size(%Full)
QualityLosses ( %Loss)
168
45
45
40
80
10
Batch SizeAssumption (#of Units)
Last input fileread:
INPUT
INPUT
LEVEL
SUMMARY
GLOBAL
168.00
1
8.00
CALC
160.00
1
8.00
1
8.00
1
16.00
1
12.00
1
4.00
Level 1thru4 (SeeBelow)
Total Hours
Non-Scheduled Hours
Scheduled Operation Hours
Scheduled Downtime
Engineering Time
Unscheduled Downtime
Standby/ IdleTime
Other Prod. TimeLosses
5
a:example.csv
STANDARD
TESTERSPECIFIC
USERDEFINED
Theoretical Tool Speed(UPH)
PlanTool Speed(UPH)
Actual Tool Speed(UPH) ***
AverageBatchSize(%Full)
QualityLosses ( %Loss)
Theoretical Tool Speed(UPH)
PlannedTool Speed(UPH)
YieldedPlannedSpeed(UPH)
%SpeedWithRetest &QA(%)
SpeedReduction– 1HdDown(%)
A
B
C
D
E
TESTERSPECIFIC
USERDEFINED
Throughput Loss (duetoIndex Time)
Throughput Loss (duetoYield)
Throughput Losses — Retest &QA
HeadAvailabilityLosses
AVS. B
BVS. C
D
E
STANDARD
Tool SpeedLoss (Plan Vs. Theory)
Tool SpeedLoss (Act. Vs. Plan)
BatchingLosses
QualityLosses
4
16
8
8
12
8
Date
15-May-95
U s e r D e f in e d In p u t s
E10 TEMPLATE
INPUTS
LEVEL 2INPUTS

LEVEL 4 INPUTS
INPUTS
HOURS
Unscheduled Downtime
Requalification Time
MTBF=
40
0
Scheduled Downtime
Set-Up Time
Requalification Time
Engineering Time
LEVEL 2
TOTAL
HOURS
HOURS
MTTR=
5
(Hours per failure)
EVERY
EVERY
EVERY
8
”
”
HOURS
HOURS
HOURS
8
EVERY
275
HOURS
EVERY
EVERY
1
”
HOURS
HOURS
Other TimeLosses (in Hrs Loss)
8
Standby/ IdleTime
Waiting Results / Qualification
0.1
0
Non-Scheduled Hours
16
UNSCHEDULEDDOWNTIME:
17
18
19
20
22
23
24
28
30
31
32
33
34
35
36
37
38
39
40
43
44
47
48
50
53
56
57
74
78
79
82
83
86
87
88
90
93
99
41
58
20.00
1
0
0
20.00
4.65
8.00
12.80
16.00
PRINT LEVEL 2
INPUTS
LEVEL 3INPUTS
UNSCHEDULEDDOWNTIME:
HOURS
No Maint. Oper.
Equip. Failure
DataFailure
FactoryFailure
Out-of-Spec
Requal
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
SCHEDULEDDOWNTIME:
4
0
0
0
0
4
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
Total Unscheduled Dow ntime
HOURS
Requal
Prev. Maint.
Equip. Test
Process Test
Initialization
Changeover
Setup
Requal
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
OTHERLOSSESTOPRODUCTIVETIME:
2
6
3
3
2
2
2
1
0
0
0
0
0
0
0
0
0
0
0
0
21
Total Scheduled Dow ntime
HOURS
NewProduct
Rework
Scrap
Production Test
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
0
0
0
4
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
HOURS STANDBY:
HOURS
WILDCARDONE
4
5
SETUP/ STARTUP(ENGR.)
2
1
LUNCH
0
WILDCARDTWO
0
6
MACHINECLEANUP
6
2
C.F.M. IDLE- MFG
1
T.E.E. USER
0
7
QUALIFY/ DUMMYRUN
3
3
C.F.M. IDLE- MAINT/EQUIP
1
T.A.E. USER
0
27
MAINTSETUP/ CHANGEOVER
3
4
C.F.M. IDLE- PROCESS
1
DOWNFORFOREIGNMATERIAL(MANUFACTURING
0
) 45
PLANNEDMAINTENANCEBYMAINTENANCE2
8
WAITMONITORS/ SENDAHEADS
1
DOWNFORFOREIGNMATERIAL(EQUIPMENT)
4
49
SYSTEMINUSEBYMAINTENANCE
2
9
INSUFFICIENTTIMETOCOMPLETERUN 0
DOWNFORFOREIGNMATERIAL(PROCESS)0
51
RAMPUPSUPPORT
0
14
PROCESSQUALITYINSPECTION
0
TOOLUNAVAILABLETOMAINT.
0
54
VENDORPLANNEDMAINTENANCE
1
21
CHARACTERIZATION
0
DOWNFORTOOL’SCOMPUTER
0
55
PLANNEDTOOLCLEANING
0
25
TOOLUNAVAILABLETOMANUFACTURING 0
DOWNFORVERIFICATION
0
60
CALIBRATION
0
26
TOOLWAITINGFORCAL.
0
DOWNFORHOST
0
61
SETUP/ STARTUP(MFG.)
0
29
SUPPORTEQUIPMENTDOWN
0
DOWNFORFACILITIES
0
65
EXPOSUREMATRIX
0
52
GLASSSHOP
0
DOWNFORCUSTOMERENGINEER(C.E.) 0
66
CONTAMINATIONCHECK
0
59
AUTOTOOLIDLE
0
WAITINGFORMAINTENANCE
0
67
INTENSITYCHECK
0
64
WAITFOROUTSIDECONDITIONS
0
WILDCARDTHREE(MAINT)
0
68
OVERLAYCHECK
0
70
NOMANUFACTURINGOPERATOR
0
MAINTENANCEREWORK/ RE-DO
0
69
FOCUSCHECK
0
72
NOPRODUCTAVAILABLE
0
DOWNFORFOREIGNMATERIAL(MAINTENA0NCE)
80
PROFILE
0
73
PROD. PROB., NOTTOOLRELATED
0
WAITINGFORVENDORMAINTENANCE
0
89
DOWNFORPLANNEDMAINTENANCEBYMA0NUFACTURING
77
REPAIRWORKCOMPLETE, WAITFORMANUFA
0 CTURING
UNPLANNEDMAINTENANCEBYMAINTENANCE
0
98
WAITINGFORPLANNEDMAINTENANCE 0
81
DOWNFORMASK
0
STANDBY- WAITFORENGINEERING
0
User Defined
0
84
NOVENDORPRODUCTAVAILABLE
0
EQUIPMENTENGINEERING
0
User Defined
0
85
WAITINGFORM.O.S.
0
TOOLCOOLDOWN
0
User Defined
0
94
AREACLEANUP
0
UNPLANNEDMAINTENANCE/ ENGINEERING0ASSIST
User Defined
0
96
TERMINAL/ PAPERWORK
0
DOWNFORNOVENDORSPAREPARTS 0
User Defined
0
User Defined
0
VENDORUNPLANNEDMAINTENANCE
0
User Defined
0
Total Scheduled Downtime
19
HANDLERUNPLANNEDMAINTENANCE
0
User Defined
0
QUALIFICATIONRUN
0
User Defined
0
STOPPRODUCTIONNOTICE(SPN)
0
PRODUCTIVETIME
HOURS
User Defined
0
WILDCARDFOUR(PROCESS)
0
Total Standby/Idle Time
4
DOWNFORI.S. (INFORMATIONSERVICES) 0
10
OPERATORTRAINEEPRODUCTION
0
DOWNFORPROCESSENGINEERING
0
11
REGULARPRODUCTION
0
DOWNFORQUALITYENGINEERING
0
12
REWORK
0
NON-SCHEDULED
HOURS
DOWNFORNOSPAREPARTS
0
13
MONITORPRODUCTION
0
WAITINGFORMANUFACTURINGMAINTENANCE
0
15
PARALLELTESTING
0
46
ELECTRO/MECHANICALE.C.
0
DOWNFORUNPLANNEDMAINTENANCEBY0MANUFACTURING
16
EXPERIMENTALWORK
0
71
NONSCHEDULEDTIME(WEEKENDS)
0
DOWNFORPRODUCTENGINEERING
0
62
STANDARDS
0
75
NOSCHEDULEDACTIVITY
0
DOWNFORCHEMICALSUPPLY
0
63
REDUCEDTHRUPUT
0
76
POWEREDDOWN
0
OTHER/ MISCELLANEOUS
0
User Defined
0
User Defined
0
SECONDMAINTENANCEWILDCARD
0
User Defined
0
User Defined
0
SECONDMANUFACTURINGWILDCARD 0
User Defined
0
User Defined
0
User Defined
0
User Defined
0
User Defined
0
User Defined
0
User Defined
0
User Defined
0
User Defined
0
Total Productiv e Time:
Total Unscheduled Dow ntime
4
Total Other Losses to Productiv e Time:
HOURS SCHEDULEDDOWNTIME:
0
Total Non-Scheduled Time
0
8
MaintenanceDelay
11 hours
Process Engineering Delay
Equipment Engineering Delay
16 hours
Manufacturing Delay
0 hours
0 hours
PRINT LEVEL 4
INPUTS
STANDBY:
HOURS
Waiting Results
Standby
Blocked
Starved – no WIP
Starved – not enough WIP
No Operator
No Tool
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
ENGINEERING:
1
1
1
1
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
6
Total Standby/Idle Time
HOURS
Engineering
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
NON-SCHEDULED
33
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
33
Total Engineering Time
HOURS
Non-Scheduled
To BeDelivered
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
User Defined
5
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
5
Total Non-Scheduled Time
PRINT LEVEL 3
INPUTS
OEE TEMPLATE
PLEASENOTE: Adjustments tothis sectionwill alter theOEEvaluecalculatedusing theOEE-TPMTemplateONLY.
Nochangewill beincurredbytheE10Template. If nochanges aremadeinPart 1or Part 2, andPlanTool
Speed= Theoretical Tool Speed, values calculatedbybothtemplates will beidentical.
INPUTS
OEE-TPMOPTIONAL INPUTS
OEEtemplateis defaultedtousethesameINPUTSas E10Template.
Use[PART1- AvailabilityAdjustment] toadjust OEEAvailabilityEfficiencyCalculation(DEFAULTis Total Time).
Use[PART2- ProductionAdjustment] if “ACTUAL” productioninformationis available.
PRINT
ACRONYMS
INPUTS
Use[PART3- Rateof QualityAdjustment] toadjust allocationof Rateof Qualitypercentages.
Acronyms List
PART1- AvailabilityAdjustment
ACRONYM
CUBES
MTBF
MTTR
QA
TPM
UPH
INCLUDE IN OEE AVAILABILITY CALCULATION: (Default is YES in Both)
Nonscheduled Hours: (Yes or No)
YES
Planned Downtime: (Yes or No)
YES
PART2- Production Adjustment
Overrideanyassumptionbelowbyentering YESandenter requireddatabelowentry(DEFAULTis NO)
DoyouwishtoOverrideInputs andCalculateOEEwith “Gross Production” ?
Pleaseenter “Gross Production” if answered YESabove
NO
4500
DoyouwishtoOverrideInputs andCalculateOEEwith”Net Production” ?
Pleaseenter “Net Production” if answered YESabove
NO
4100
DoyouwishtoOverrideInputs andCalculateRateof Qualitywithactual “ProductionRejects”?
(Insteadof Percentageof other losses)
Pleaseenter “Production Rejects” if answered YESabove
NO
125
PART3- Rateof QualityAdjustment
Doyouwishtospecifyallocationof Rateof QualityLoss basedonpercentages (P) or #of wafers (W)?
Percentages Must Total to 100%.
Qualityloss duetoDefect &Rework
Qualityloss duetoYield/ Scrap
W
OVERRIDE
OEEINPUTSUMMARY
FALSE (TRUEOverrideis on. FALSEOverrideis not used.)
(IFFALSEall overridevalues set toZERO)
0 Gross Production
TRUE
33
67
PART4- PerformanceEfficiencyAdjustment
Doyouwant tousePlanTool Speed(P) or Theoretical Tool Speed(T) inOEEcalculation?
0
Net Production
0
ProductionRejects
#of Wafers
2
4
DEFINITION
CapacityUtilizationBottleneckEfficiencySystem
MeanTimeBetweenFailures
MeanTimeToRepair
QualityAssurance
Total ProductiveMaintenance
Units Per Hour
Percent
50
50
P
PRINT BUTTONS
PRINT GLOBAL INPUTS
PRINT OEE TEMPLATE
PRINT E10 TEMPLATE
PRINT LEVEL 1 INPUTS
PRINT E10 LEVERAGE
ANALYSIS CHART
PRINT OEE LEVERAGE
ANALYSIS CHART
PRINT LEVEL 2 INPUTS
PRINT E10 TOOL EFFICIENCY
ANALYSIS CHART
PRINT OEE TOOL EFFICIENCY
CHART
PRINT LEVEL 3 INPUTS
PRINT E10 BENCHMARK
CHART
PRINT OEE BENCHMARK
CHART
PRINT LEVEL 4 INPUTS
PRINT E10 BENCHMARK
CHART WITH DATA
PRINT OEE BENCHMARK
CHART WITH DATA
PRINT CORRECTIVE ACTION
LOG
PRINT ACRONYMS
PRINT USER
DEFINED INPUTS
OUTPUT – CUBES (E10 TEMPLATE) EFFICIENCY ANALYSIS TOOL
PRINT E10
TEMPLATE
E10 BENCHMARK DATA
OEE TEMPLATE
CUBES v. 2.51 (E10 TEMPLATE) EFFICIENCY ANALYSIS TOOL
TOOL 1
SUPPLIER:
MODEL:
SOURCEDATADATE:
5
SOURCEDATAFROM:
INPUT SUMMARIZEDOUTPUTS
CUBESEFFICIENCY(%)
CHECKS Actual Production
42.67
TOOL:
TOOLID:
BATCH SIZE:
#######
SUMMARIZEDINPUTS
45
168
Theoretical Tool Speed(UPH)
Total Time
45
40
80
10
4.00
12.00
8.00
16.00
8.00
8.00
PlanTool Speed(UPH)
Actual Tool Speed(UPH) ***
AverageBatchSize(%Full)
QualityLosses ( %Loss)
Other TimeLosses (ie. Prod. Test etc.)
Standby/IdleTime
EngineeringTime
UnscheduledDowntime
Scheduled Downtime
Non-ScheduledTime
64.00
66.67
SpeedEfficiency(%)
TimeEfficiency(%)
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
THRUPUT
3226
OVERALL INDIVIDUAL
EFFECT
EFFECT
(%)
(%)
0.00
0.00
7.41
11.11
11.85
20.00
4.74
10.00
2.38
3.45
7.14
9.38
4.76
5.88
9.52
10.53
4.76
5.00
4.76
4.76
Tool SpeedLoss (Plan Vs. Theory)
Tool SpeedLoss (Act. Vs. Plan)
BatchingLosses
QualityLosses
Other TimeLosses (ie. Prod. Test etc.)
Standby/IdleTime
EngineeringTime
UnscheduledDowntime
Scheduled Downtime
Non-ScheduledTime
PRINT E10 LEVERAGE
ANALYSIS CHART
THRUPUT
INCREASE
ANALYSIS
INUNITS
MODEL:
T OOL:
CURRENT DAT E:
4/27/2020
T OOL ID:
BAT CH SIZE: 5
Production UNITS
Engineering Time
Standby/Idle Time
Other Time Losses
1000
Tool Speed Loss (Act. Vs. Plan)
Scheduled Downtime
Batching Losses
20.00
Quality Losses
Engineering Time
Standby /Idle Time
Other Time Losses
60.00
Quality Losses
Batching Losses
Tool Speed Loss (Act. Vs. Plan)
40.00
Tool Speed Loss (Plan Vs. Theory)
CUBES EFF. (%)
Other Time Losses
2%
20.00
Quality Losses
5%
0.00
CVD08
96
91
86
81
76
71
66
61
56
51
46
41
36
31
26
21
6
1
16
11
Non-Scheduled Time
Scheduled Downtime
Unscheduled Downtime
80.00
CUBES EFF. (%)
43%
Engineering Time
5%
Standby /Idle Time
7%
Non-Scheduled Time
500
CUBES EFF. (%)
0.00
MODEL:
CURRENT DAT E:
4/27/2020
100.00
Standby /Idle Time
Engineering Time
E10 TEMPLATE
SUPPLIER:
SOURCE DAT A DAT E:
SOURCE DAT A FROM:
CUBES (E10) BENCHMARK ANALYSIS
120.00
Quality Losses
1500
T OOL 1
T OOL ID:
BAT CH SIZE: 5
Unscheduled Downtime
Tool Speed Loss (Plan Vs. Theory)
40.00
T OOL:
4/27/2020
Batching Losses
2000
Other Time Losses (ie. Prod. Test etc.)
PRINT E10 BENCHMARK
CHART WITH DATA
CUBES v. 2.51 (E10 TEMPLATE) EFFICIENCY ANALYSIS TOOL
MODEL:
CURRENT DAT E:
Time
Unscheduled
Downtime
9%
Tool Speed Loss (Act. Vs.
Plan)
Scheduled Downtime
Unscheduled Downtime
60.00
SUPPLIER:
SOURCE DAT A DAT E:
SOURCE DAT A FROM:
CUBES (E10 ) TOOL EFFICIENCY ANALYSIS
THROUGHPUT
2500
Non-Scheduled Time
80.00
T OOL 1
Non-Scheduled
5%
Scheduled Downtime
5%
3000
PRINT E10 BENCHMARK
CHART
E10 TEMPLATE
CUBES v. 2.51 (E10 TEMPLATE) EFFICIENCY ANALYSIS TOOL
SUPPLIER:
SOURCE DAT A DAT E:
SOURCE DAT A FROM:
3500
CUBES (E10 TEMPLATE) EFFICIENCY ANALYSIS GRAPH
Percentage of Theoretical Tool Speed
T OOL 1
CUBES THROUGHPUT LEVERAGE ANALYSIS
120.00
100.00
PRINT E10 TOOL EFFICIENCY
ANALYSIS CHART
E10 TEMPLATE
CUBES v. 2.51 (E10 TEMPLATE) EFFICIENCY ANALYSIS TOOL
T OOL:
T OOL ID:
BAT CH SIZE: 5
403
806
358
115
346
230
461
230
230
PERCENTAGE
INPUTS
PERCENTAGE OF HOURS OF OPERATION (OF TOTAL TIME)
TYPE OF THROUGHPUT LOSS
DATE OF ANALYSIS or TOOL NAME
Tool Speed Loss
Tool Speed(Plan
Loss (Act.
Vs. Theory)
Vs. Plan)
0%
7%
Batching Losses
12%
0
Note: Theo. Tool Speedwas increasedfrom
sinceTheoretical Tool Speed< PlanTool Speed. Note: PlanTool Speedwas increasedfrom sincePlannedTool Speed< Actual Tool Speed. UseTool name(T) or Date(D) inplot? Tool Date INPUTSfor StackedBAR CUBESEFF. (%) Tool SpeedLoss (Plan Vs. Theory) Tool SpeedLoss (Act. Vs. Plan) BatchingLosses QualityLosses Other TimeLosses Standby/IdleTime EngineeringTime UnscheduledDowntime Scheduled Downtime Non-ScheduledTime TODAY'S CALCULATIONS 42.67 0.00 7.41 11.85 4.74 2.38 7.14 4.76 9.52 4.76 4.76 Note: PlanandTheoretical Tool Speeds were increasedsincePlannedTool Speed< Actual Tool SpeedandTheoretical Tool Speed< Actual Tool Speed. UPDATE WITH TODAY'S DATA T CVD08 CVD08 42.67 0.00 7.41 11.85 4.74 2.38 7.14 4.76 9.52 4.76 4.76 VIEW E10 BENCHMARK CHART CORRECTIVE ACTION LOG OUTPUT - CUBES (OEE) EFFICIENCY ANALYSIS TOOL PRINT OEE TEMPLATE OEE BENCHMARK DATA CUBES v. 2.51 (OEE) EFFICIENCY ANALYSIS TOOL OEE & TPM'S 6 BIG LOSSES Non-ScheduledTime Scheduled Downtime EngineeringTime UnscheduledDowntime Standby/IdleTime Other TimeLosses (ie. Prod. Test etc.) 8.00 8.00 8.00 16.00 12.00 4.00 Ideal Tool Speed(UPH) Actual Tool Speed(UPH) 45.00 32.00 T OOL: T OOL 1 T OOL ID: BAT CH SIZE: 5 PRINT OEE TOOL EFFICIENCY CHART OEE TEMPLATE 42.67 OVERALL EFFECT (%) TRUE TRUE EFFICIENCY RATINGS TRUE AvailabilityEfficiency(dueto losses 1&2below) TRUE PerformanceEfficiency(dueto losses 3&4) TRUE QualityEfficiency(dueto losses 5&6)(Rateof Quality) TRUE LOSSES DUE TO: 1) Setups/Adjustments TRUE 2) Breakdowns 3) Idling/Minor Stoppages 4) Reduced Speed 5) Defects/Rework 6) Yield/Scrap 9.52 9.52 14.29 19.26 1.58 3.16 INDIVIDUAL EFFECT (%) 3226 THRUPUT INCREASE ANALYSIS INUNITS 80.95 58.56 90.00 922 2282 358 9.52 10.53 17.65 28.89 3.33 6.90 461 461 691 1310 111 239 CUBES ( OEE TEMPLATE) EFFICIENCY ANALYSIS GRAPH PRINT OEE BENCHMARK CHART OEE TEMPLATE CUBES v. 2.51 (OEE) EFFICIENCY ANALYSIS TOOL SUPPLIER: MODEL: T OOL: SOURCE DAT A DAT E: SOURCE DAT A FROM: CURRENT DAT E: 4/27/2020 T OOL ID: BAT CH SIZE: 5 T OOL 1 SUPPLIER: MODEL: SOURCE DAT A DAT E: SOURCE DAT A FROM: CURRENT DAT E: T OOL 1 T OOL ID: BAT CH SIZE: 5 OEE TEMPLATE SUPPLIER: MODEL: SOURCE DAT A DAT E: SOURCE DAT A FROM: CURRENT DAT E: 4/27/2020 CUBES (OEE) BENCHMARK ANALYSIS Defects/Rework Yield 3% 2% 3500 PRINT OEE BENCHMARK CHART WITH DATA CUBES v. 2.51 (OEE) EFFICIENCY ANALYSIS TOOL T OOL: 4/27/2020 CUBES (OEE) TOOL EFFICIENCY ANALYSIS CUBES (OEE) THROUGHPUT LEVERAGE ANALYSIS THRUPUT 168.00 168.00 Total Time Gross Time PRINT OEE LEVERAGE ANALYSIS CHART CUBES v. 2.51 (OEE) EFFICIENCY ANALYSIS TOOL 4/27/2020 SUPPLIER: MODEL: SOURCEDATADATE: SOURCEDATAFROM: INPUT SUMMARIZEDOUTPUTS CHECKS OVERALL EQUIPMENT EFFECTIVENESS OEE(%) 100% 90% 3000 Reduced Speed 19% 80% 2500 70% Yield THROUGHPUT OEE 43% Setups/Adjustments 2000 PERCENTAGE OEE-TPM OPTIONAL INPUTS E10 TEMPLATE Production UNITS INPUTS TOOL 1 TOOL: TOOLID: BATCHSIZE: 5 SUMMARIZEDINPUTS Breakdowns Idling/Minor Stoppages Reduced Speed 1500 Defects/Rework 60% Defects/Rework Reduced Speed 50% Idling/Minor Stoppages Breakdowns Setups/Adjustments 40% OEE Yield 1000 30% Idling/Minor Stoppages 14% 20% 500 Setups/Adjustments Breakdowns Idling/Minor Stoppages 0 0% TOOL 1 TYPE OF THROUGHPUT LOSS Breakdowns 10% CVD08 Setups/Adjustments 9% DATE OF ANALYSIS or TOOL NAME Reduced Speed UseTool name(T) or Date(D) inplot? Defects/Rework T Yield Tool Date Percentage of Hours of Operation (Of Gross Time) Note: Ideal Tool Speedwas increasedfrom sincePlannedTool Speed< Actual Tool Speed. Note: Ideal Tool Speedwas increasedfrom sinceTheoretical Tool Speed< Actual Tool Speed. 97 93 89 85 81 77 73 69 65 61 57 53 49 45 41 37 33 29 25 21 17 13 9 5 OEE 1 Percentage of Ideal Tool Speed 10% 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% TODAY'S CALCULATIONS 42.67 9.52 9.52 14.29 19.26 1.58 3.16 INPUTSfor StackedBAR OEE Setups/Adjustments Breakdowns Idling/Minor Stoppages ReducedSpeed Defects/Rework Yield UPDATE WITH TODAY'S DATA CVD08 CVD08 42.67 9.52 9.52 14.29 19.26 1.58 3.16 VIEW OEE BENCHMARK CHART CORRECTIVE ACTION LOG INPUTS OEE TEMPLATE E10 TEMPLATE Target Date ResponsiblePerson 21-May Konopka DISCLAIMER: User definedvariables needtomaptovariables usedinCUBES. PRINT LEVEL 1 INPUTS PRINT USER DEFINED INPUTS OEE TEMPLATE OEE BENCHMARK DATA CorrectiveAction Taken RecalibratedTool SUMMARIZEDOUTPUTS: PRINT GLOBAL INPUTS *** Actual Tool Speed= Total Wafers / [Total Processing TimeXBatch%Full] LEVEL 1INPUTS Other Production TimeLosses Unscheduled Downtime Scheduled Downtime Engineering Time Standby/ IdleTime Non-Scheduled Hours INPUTS E10 BENCHMARK DATA SUMMARIZEDINPUTS: WRITE CUBES DATA FILE RESET DATA Completion Date 16-May Field # 270 271 272 273 274 281 282 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 Field Name Gross Production Net Production ProductionRejects %of QualityLoss DuetoDefects andRework %of QualityLoss DuetoYield/ Scrap BatchSize(#of units) Rockwell OEE Comments User Defined Input 4500 4100 125 33 67 5 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 Capacity Utilization Bottleneck Efficiency System (CUBES) Copyright SEMATECH 1993-1996 JOHN KONOPKA - SEMATECH OPERATIONAL MODELING PHONE (512)356-3396 EMAIL FAX(512)356-3083 JOHN.KONOPKA@SEMATECH.ORG Purchase answer to see full attachment