VISUAL FACTORY FOR EXCEL Aaron Evans October 11, 2012

VISUAL FACTORY FOR EXCEL
Aaron Evans
October 11, 2012
Louisville ASQ Section 912 – Mini Session
WHAT IS VISUAL CONTROL?
• means, devices, or mechanisms that were designed to
manage or control our operations (process) so as to meet the
following purposes:
• make the problems, abnormalities, or deviation from standards visible to
everyone and thus corrective action can be taken immediately,
• display the operating or progress status in a easy to see format.
• provide instruction.
• convey information.
• provide immediate feedback to people.
SOME EXAMPLES
SOME EXAMPLES
SOME EXAMPLES
WHAT IF YOU WORK JUST IN EXCEL …
Start
End
Change
Overall
100
90
10
Area 1
Area 2
Area 3
Area 4
30
40
25
5
20
50
15
5
10
-10
10
0
ADDING VISUAL CONTROL …
Start
End
Change
Overall
100
90
10
Area 1
Area 2
Area 3
Area 4
30
40
25
5
20
50
15
5
10
-10
10
0
0
0
0
ADDING VISUAL CONTROL …
Start
End
Change
Overall
100
90
10
Area 1
Area 2
Area 3
Area 4
30
35
25
5
20
50
15
5
10
-15
10
0
-5
0
-5