個案總覽

In April 2014, the accounts receivable exceeding 90 days were causing a cash-flow problem for Wolf Distributing, which distributes the Berserker Rage energy drink in the Chicagoland area. Christine Taylor, the company's chief operating officer, had tried a number of traditional methods to monitor and address this problem, but she had made little progress. She decided to use three basic statistical analysis tools-Pareto diagrams, scatter plots, and run charts-to help her better grasp the problem.

Spreadsheet for KEL904.

Spreadsheet supplement for KEL740.

Spreadsheet supplement for KEL740.

Spreadsheet supplement for KEL740.

Spreadsheet supplement for KEL738.

In late 2012 Adeline Herzog Memorial Hospital in Castle Rock, Colorado, was facing a problem with patient satisfaction. The Press-Ganey scores for the third-floor nursing unit-the primary destination (70 percent) for patients admitted through the emergency department-were at the 15th percentile, and the key HCAHPS score for inpatients was well below the Colorado average. Over the past six months Jeri Tinsley, director of medical, surgical, and intensive care services, had made various changes to try to improve the patient satisfaction scores for her 32-bed unit, but the scores seemed stuck at an unacceptably low level. Tinsley worried that if improvements were not made soon, patients would start "voting with their feet" and take their business to competing hospitals. As a registered nurse, Tinsley's expertise was helping people heal; it was not analyzing data. In particular, she was overwhelmed by the patient comments included in the surveys; she had no idea how to analyze them and could not decide which issues to address first.

Samsung Electronics had experienced a series of quality-related problems, including the recall of one of its LCD TV models. Unfortunately for quality director Kevin Sarni, there was no single root cause behind these problems: Samsung's supply chain management, product design, and testing/quality assurance functions all played a role. Sarni regularly worked with quantitative data from Samsung's customer complaint database, but recently he had been shown comments about Samsung products posted on the website ConsumerAffairs.com. The number and emotional tone of the website postings concerned him; he worried these kinds of complaints might touch off a social media-fueled public relations firestorm that would make his job more difficult. He wanted to analyze this feedback, but had no experience with qualitative data. An internal Six Sigma Black Belt consultant suggested he start by creating an affinity diagram and use that to create a Pareto chart to determine which issues to address first. Once Sarni completed the unfamiliar diagrams he had still another task ahead of him: examining the results to see if they justified taking short-term action to address the quality problems raised in the complaints.