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
© Copyright 2024