Jay Arthur Blog

Improvement Insights Blog

Latest "Jay Arthur Blog" Posts

QI Macros Version 2018.10

We’re excited! From adding Menu Icons to make things easier to find (and easier to add to your Excel Quick Access Toolbar), to adding a Search function to answer those “Where is that one chart…” questions, to the Control Chart Template Wizard… we think this is the most powerful, easiest to use version of QI Macros that there is.

This version is compatible with:

  • PC operating systems Windows 10, Windows 8.1, Windows 7
  • PCs running Excel 365, Excel 2019, Excel 2016, Excel 2013 and Excel 2010
  • Mac operating systems Mojave (MacOS 10.14), High Sierra(MacOS 10.13), Sierra (MacOS 10.12), El Capitan (MacOS 10.11) or Yosemite (MacOS 10.10)
  • Mac machines running Excel for Mac 365 or Excel for Mac 2016

 

If you’d like to upgrade to QI Macros 2018.10, you can purchase a new license by clicking HERE.

Posted by Jay Arthur in Jay Arthur Blog, QI Macros.

Electrical Outages Improvement Story

Jeremy Singer-Vine publishes a Data Is Plural newsletter about available data sets. I took the U.S. & Canada power outage data from 2018 and used it with QI Macros Data Mining Wizard to create an improvement project.

I used a g Chart of time between power outages. Averaging a little over 3 days between outages.

days between power outages

Then, the Data Mining Wizard found the most common cause of outages to be weather. But look at number two: operations. That’s something that could be fixed. Vandalism could also be prevented.

power outages by event

Next, where are outages most likely to occur:

power outages by region

And what month? Readiness months: March-July.

Posted by Jay Arthur in Data Mining, Jay Arthur Blog, QI Macros, Six Sigma.

Hunter Pro-C Controller Problem

My water bill recently doubled. Turns out it’s a design flaw in my Hunter Pro-C controller.

A while back, I set some of my zones to zero minutes.

hunter zero image

But, if I accidentally hit the minus sign one more time, the controller goes to SIX HOURS:

hunter zero image six

It was a royal hassle, but I managed to submit an improvement suggestion to Hunter:
There should be no run times below ZERO! Duh!

I had  Denver Water come out to show me how to read the meter.

  1. Meter reader basically said: “Meter’s correct. Fix your controller” and left.
    What if they spent 5 minutes helping homeowners check their controller to find the problem?

Posted by Jay Arthur in Jay Arthur Blog, Six Sigma.

Well, shoot! Looks like we missed each other!

It looks like you’ve clicked on a link to learn about signing up for a webinar that’s already happened.

 

No worries, you can click HERE to find out about the next live webinar…

or you can click HERE to view a webinar that’s been recorded.

Posted by Jay Arthur in Jay Arthur Blog, QI Macros.

Shift from Manufacturing to Supply Chain

The July-August, 2018 Inc. magazine has an article (pg. 22) about manufacturing vs supply chain service jobs. From 1999-2015:

  • Manufacturing jobs declined from 12.5 million to 8.2. Supply chain jobs increased from 13.4 million to 20.0.
  • Manufacturing salaries climbed only slightly from $54,800 to 59,800 while supply chain jobs rose from $72,600 to $85,200.

With increasing manufacturing automation, more jobs are being created around supporting production than actual production. Something to think about.

Posted by Jay Arthur in Jay Arthur Blog, Lean, Manufacturing.

Team Communication Costs

People often ask me, how big should an improvement team be? My answer: as small as possible.

In Fred Brooks’ Mythical Man Month, he points out that communication pathways increase in a nonlinear fashion. The formula is simple:

(n2-n)/2

Where n is the number of people on a team.

  • 2 people = 1 connection (4-2)/2
  • 3 people = 3 connections (9-3)/2
  • 4 people = 6 connections (16-4)/2
  • 5 people = 10 connections (25-5)/2
  • 6 people = 15 connections (36-6)/2
  • 7 people = 21 connections (49-7)/2

The bigger the team, the more time is spent on discussion and communication, not progress.

Posted by Jay Arthur in Jay Arthur Blog, Lean, Six Sigma.

Forgetting The Control Phase?

Are you making one of the most common mistakes in Six Sigma? Are you forgetting the control phase?

If you do forget to implement a control plan and control charts to monitor and corrective actions, you might just as well have not wasted everyone’s time.



Join my Agile Quality Improvement Movement. Sign up to receive Weekly Agile Six Sigma emails right in your inbox! Click HERE to subscribe.

Posted by Jay Arthur in Improvement Insights, Jay Arthur Blog, QI Macros, Six Sigma.

Lean Graduation Ceremonies

Last week, our grandson graduated from Colorado College and our granddaughter graduated from Rock Canyon High School.

Jake’s graduating class of 500 went single file to the podium to receive their diploma.

Rachel’s graduating class of 500 came from four directions simultaneously. Four name callers, four people handing out diplomas.

Which one do you think went faster?

Posted by Jay Arthur in Jay Arthur Blog, Lean, QI Macros, Service.

Quality 4.0 – Blog entry regarding the current trend of automation and data exchange

ASQ World 2018, there were a lot of sessions about “Industry 4.0” and the transformation required by quality improvement professionals (Quality 4.0).

Wikipedia describes Industry 4.0 as:  “the current trend of automation and data exchange in manufacturing technologies.”

If I can read the writing on the wall, this means that more manufacturing jobs will be automated out of existence, including quality improvement.  In the next few years, AI will embody the quality improvement disciplines, and automate detection and autocorrection of performance problems. No human required.

But manufacturing is only 11% of U.S. employment. 80% is service industries. While quality in manufacturing is still important, the rise of service quality improvement is desperately needed in everything from healthcare to fast food.

Posted by Jay Arthur in Jay Arthur Blog, Manufacturing, Service, Six Sigma.

ASQ World 2018 – Team Case Studies

Here’s a Pareto chart of case studies by country at ASQ World 2018. Notice any trends?

 

asq team case studies 2018

Posted by Jay Arthur in Jay Arthur Blog, QI Macros, Six Sigma.