Archives

1 CHAPTER 1 Introduction to Quality Teaching Notes In the first class session, we typically provide a few introductory remarks about the importance Chapter 1 Overview and Key Objective The first chapter provides an overview of the importance of quality […]

Introduction to Quality 16 7. This approach by PCWorld Magazine particularly impacts, and seems to down-play, the value-based definition of quality. Price is a quality characteristic which most consumers consider. If price is held constant, while other characteristics are compared, […]

Case: Is Quality Good Marketing or Is Good Marketing Quality 1 Vignettes show the different styles (country, traditional, contemporary, and transitional) that are available. The vignettes are intended to provide the customer with an “impression of quality” upon entering the […]

have the authority to do whatever it takes to satisfy the customer. When a complaint is raised, the employee should act immediately to solve to the problem, listen attentively to the customer, and apologize. No matter what, the customer should […]

ANS: F PTS: 1 DIF: Difficulty: Moderate NAT: BUSPROG: Analytic TOP: A-head: Defining Quality KEY: Bloom’s: Comprehension ANS: T PTS: 1 DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-head: Defining Quality KEY: Bloom’s: Knowledge ANS: T PTS: 1 DIF: Difficulty: […]

management meetings and quarterly planning sessions. • Make teams the central focus of all jobs and allow all staff to process customer requests; for example, a busser can order an additional beverage without first getting a server to process the […]

1 CHAPTER 10 The Baldrige Framework for Performance Excellence Teaching Notes This chapter focuses on the Malcolm Baldrige National Quality Improvement Act which was signed into law (Public Law 100-107) on August 20, 1987, and on the quality award which […]

The Baldrige Framework for Performance Excellence 20 four dimensions implied in these comments are addressed below. a. The applicant presents limited evidence of systematic evaluation and refinement of several key leadership approaches that may support operational excellence and enhance b. […]

ANS: F DIF: Difficulty: Moderate NAT: BUSPROG: Analytic TOP: A-head: The Criteria for Performance Excellence KEY: Bloom’s: Knowledge ANS: T DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-head: The Criteria for Performance Excellence KEY: Bloom’s: Knowledge ANS: F DIF: Difficulty: […]

TecSmart Electronics 1 • Senior leaders participate in quarterly communication meetings with all employees to discuss company issues and answer questions. All employees receive full financial information from their managers each month. • Senior leaders teach courses in TecSmart University […]

Case – The Graduation Party Part 1 “Let’s plan a graduation party for our seniors,” suggested Jim Teacher, president of the Delta Mu Zeta fraternity at State U. Everyone on the fraternity council thought that it was a good idea, […]

ANS: F DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-head: The Scope of Strategic Planning KEY: Bloom’s: Knowledge ANS: T DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-head: The Scope of Strategic Planning KEY: Bloom’s: Knowledge ANS: T DIF: Difficulty: […]

CHAPTER 11 Strategy and Performance Excellence Teaching Notes This chapter centers on strategic management as the basis of all managerial activities relating to total quality management. Leadership is acknowledged as the “driver” for an effective TQ focus, but this chapter […]

Strategy and Performance Excellence 16 It began with the development of an order fulfillment process psyche that transcended departmental thinking regarding purchasing, forming, selection and shipping. Management and union leadership were engaged to explain and communicate this new II. Clifton […]

consultation with each client. A casual dress code and work policies, and a number of perks for workers, such as health insurance, flextime, generous vacation and sick leave benefits, a 401(k) retirement plan, and competitive wages have, in the past, […]

ANS: T DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: The Value and Scope of Performance Measurement KEY: Bloom’s: Knowledge ANS: F DIF: Difficulty: Moderate NAT: BUSPROG: Analytic TOP: A-Head: The Value and Scope of Performance Measurement KEY: Bloom’s: Comprehension […]

1 CHAPTER 12 Measurement and Knowledge Management For Performance Excellence Teaching Notes This chapter develops facets of measurement and knowledge management. These concepts may be somewhat difficult for students to grasp, at first. This may especially be true if there […]

Measurement and Knowledge Management for Performance Excellence 16 philosophy. The departments and areas submit an annual report to the Leadership Team that summarizes its performance, including relevant LEARNing Board measures, during the previous academic year. Measures developed by Coyote for […]

I. Westerfield Construction 1 time, and other resources were also provided to her by the executive team. The CSLC team used the tools prior to developing an action plan for implementation. They developed measures to monitor the effectiveness of the […]

ANS: T DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: Leadership Competencies and Practices KEY: Bloom’s: Knowledge ANS: F DIF: Difficulty: Moderate NAT: BUSPROG: Analytic TOP: A-Head: Leadership Competencies and Practices KEY: Bloom’s: Comprehension ANS: F DIF: Difficulty: Easy NAT: […]

Leadership for Performance Excellence 13 ANSWERS TO DISCUSSION QUESTIONS 1. By saying that leadership is the “driver,” we try to emphasize the critical nature of leadership at every level for successful TQ. The answer to Review Question 3, above, elaborates […]

1 CHAPTER 13 Leadership for Performance Excellence Teaching Notes The keys to attaining an in-depth understanding of total quality organizations as integrated systems are to have basic knowledge of organizing principles and organizational cultures and to develop and use a […]

Quality in Banking: Los Alamos National Bank i By William M. Lindsay, Ph.D., P.E An earlier version was presented at: 3er. Congreso Internacional de Ingeniería Industrial y de Sistemas ITESM-Morelia Campus Morelia, Mexico September 17-21, 2008 excellence in an organization. […]

Building, and Sustaining Quality and Performance Excellence 13 understanding of purposes and goals and use of complementary measures and information for planning, tracking, analysis, and improvement at each of the three levels 6. Amazingly, many colleges and universities would not […]

1 CHAPTER 14 Building, and Sustaining Quality and Performance Excellence Teaching Notes The keys to attaining an in-depth understanding of total quality organizations as integrated systems are to have basic knowledge of organizing principles and organizational cultures and to develop […]

Can Six Sigma Work in Health Care? Colin David is the CEO of a Southwest Louisiana Regional Medical Center (SLRMC), a small nonprofit hospital with 150 beds and 825 employees, offering a wide range of outpatient and inpatient services. Colin […]

Case – Equipto, Inc. Equipto, Inc., a division of a Fortune 500 corporation, is located in the Midwest. The Industrial Motor Division (IMD) makes motor units that are part of the installation package for large-scale industrial systems. The company has […]

ANS: F DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: Organizational Culture and Change KEY: Bloom’s: Knowledge ANS: F DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: Organizational Culture and Change KEY: Bloom’s: Knowledge ANS: T DIF: Difficulty: Easy NAT: […]

Child Focus, Inc. i Child Focus, Inc. (CFI), whose mission is to join with communities in strengthening families and improving the quality of life for children, offers a wide variety of programs in Clermont, Hamilton, and Brown counties in Ohio. […]

U.S. Water Resource Agency – Flagstaff District i navigation, flood-damage reduction, environmental protection, recreation, water supply, and other public benefits • protection of the region’s waterways and wetlands • support for emergency preparedness, natural-disaster relief, and recovery work worldwide • […]

Error Data Chapter 2 The Disciplinary Citation Case Data for Scatter Diagram for Package Errors 33 11 7 34 19 7 35 11 7 36 3 7 37 6 7 38 13 7 39 4 7 40 0 7 280 […]

Total Quality in Organizations 20 3. Deming’s 14 points may be put into the six categories listed, but it should be realized that some of his 14 points apply to more than one category. a. Organizational purpose and mission: Points […]

1 CHAPTER 2 Total Quality In Organizations Teaching Notes This chapter introduces the concept of quality in production and service systems and develops the idea that quality is central to effective operation of these systems. Students should be encouraged to […]

boxes and weigh the packages as well as checking them for defects such as rips, leaks, and pinholes. Weights of packages near the bottom, mid and top of each skid (pallet) are inspected. If these packages conform to weight specifications, […]

cartons, physical counts, sorting, and manual ticketing. Advance shipping notice capability provided the means of knowing exactly what was coming and when. Shipments arrived preticketed by suppliers with external shipping container marking. Entire containers were scanned for contents and matched […]

The Nightmare on Telecom Street i H. James Harrington, a noted quality consultant, related the following story in Quality Digest magazine: I called to make a flight reservation just an hour ago. The telephone rang five times before a recorded […]

ANS: F DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: The Deming Philosophy KEY: Bloom’s: Knowledge ANS: F DIF: Difficulty: Moderate NAT: BUSPROG: Analytic TOP: A-Head: The Deming Philosophy KEY: Bloom’s: Knowledge ANS: T DIF: Difficulty: Easy NAT: BUSPROG: Analytic […]

Problem 3-06 Versele Sporting Goods Months Survey attribute 12345678910 11 12 1. Friendliness of employees 6.9 6.2 5.4 5.5 6.0 5.2 6.8 6.5 4.9 4.1 5.0 6.6 2. Knowledge of products 6.9 6.6 6.2 5.4 4.8 6.3 5.7 6.8 6.7 […]

Focusing on Customers 34 Relative Relative Attribute Importance Computer A Computer B Performance CPV- A CPV- B Speed 20% 7.5 7.8 -0.3 1.50 1.56 SUGGESTIONS FOR PROJECTS, ETC. 1. The ACSI uses a proprietary survey technique, where fee-paying subscribers provide […]

Problem 3-08 NPS’s for Angelina’s Bea uty Emporium WEEK NPS Score 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 […]

Problem 3-09 Premier Computer Designs Relative Relative Attribute Importance Computer A Computer B Performance CPV-A CPV-B Speed 20% 7.5 7.8 -0.3 1.50 1.56 Active memory 25% 8.5 8.0 0.5 2.13 2.00 Portability 15% 6.5 5.3 1.2 0.98 0.80 Reliability 30% […]

1 CHAPTER 3 Focusing on Customers Teaching Notes This chapter focuses on customer satisfaction. Until a few years ago, this was a topic that was thought to be only a “marketing” activity and out of the area of responsibility of […]

24 9132 6 25 10 133 6 26 10 134 6 27 9135 7 28 10 136 8 29 9137 7 30 10 138 8 31 10 139 8 32 10 140 7 33 10 141 8 34 10 142 […]

Focusing on Customers 21 22. A customer survey for a pharmacy asks customers to rate the pharmacy according to the following: • Friendly pharmacist • Knowledgeable pharmacist • Friendly pharmacy technician • Knowledgeable pharmacy technician • Quick checkout They use […]

ANS: F PTS: 1 DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-head: Customer Satisfaction and Engagement KEY: Bloom’s: Knowledge ANS: F PTS: 1 DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-head: Identifying Customers KEY: Bloom’s: Knowledge ANS: T PTS: 1 […]

Case: American Parkinson’s Disease Association Center i • To establish fundraising chapters in strategic areas throughout the country. • To publish and distribute a quarterly newsletter, educational booklets, audio- visual and other educational and supportive materials about PD. • To […]

restaurant manager received your letter and asked me to respond as Total Quality Lead. Looking back at our records, we did not show a reservation on the books for your family. I have addressed your comments with the appropriate department […]

Case: Cincinnati Veterans Administration Medical Center i such areas as urology, orthopedics, vascular surgery and neurosurgery. The Mental Health Service provides psychiatric and psychological support care for patients with a variety of programs including care for patients with post-traumatic stress […]

16 23. 360-degree feedback is a method whereby a group of individuals who frequently interact with an employee or team participate in both the goal setting process and the performance appraisal process. The group may include suppliers, clients, peers, internal […]

1 CHAPTER 4 Workforce Focus Teaching Notes This chapter provides an overview of one of the most important sub-systems in TQ – Workforce Focus – which is called the human resources area in many organizations. The workforce area continues to […]

ANS: T PTS: 1 DIF: Difficulty: Easy NAT: BUSPROG: Analytic STA: DISC: HRM TOP: A-head: The Evolution of Workforce Management KEY: Bloom’s: Knowledge ANS: F PTS: 1 DIF: Difficulty: Easy NAT: BUSPROG: Analytic STA: DISC: HRM TOP: A-head: High Performance […]

ANS: F PTS: 1 DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-head: Process Management KEY: Bloom’s: Knowledge ANS: T PTS: 1 DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-head: Process Management KEY: Bloom’s: Knowledge ANS: F PTS: 1 DIF: Difficulty: […]

Process Management 20 improved;” “The boss won’t let us change it;” “Government regulations prohibit that from being changed (maybe they do, but no one has ever looked up the regulation!)” PROBLEMS 1. The process of making a batch of paint […]

Supply Chain for Banana Production Test samples Monitor growth & quality Cut banana stalks from trees Cut bananas into bunches of 5–6 bananas Quality OK? Color? Wash & inspect banana clusters Place sticker & package bunches Load into containers & […]

1 CHAPTER 5 Process Management Teaching Notes This chapter investigates the concept of process and techniques used to design and manage processes. It emphasizes the fact that it is essential to design products and services to meet customer Key objectives […]

Stuart Injection Molding Company 1 conducts market research to understand customer needs and handles customer complaints; the project engineering department performs design reviews; the manufacturing department conducts in-process inspection for the purpose of maintaining control and coordinates continuous improvement processes. […]

P6-11 Statistics Problem 6-11 Twenty First Century Laundry Summary Statistics Using Excel Data Analysis Tool – “Descriptive Statistics” Note that the data must be put into a unidimensional array in order to run the summary statistics Summary Data in Original […]

19 13 20 17 21 9 22 18 23 12 24 11 25 14 26 15 27 9 28 12 29 8 30 15 Example 6.9 Mean 13.133 Observation Value Median 13 116 Mode 12 915 10 17 11 13 […]

Problem 6-5 Los Alamos Green Tea Probability Calculations Using the Normal Distribution – Template Enter data only in the shaded cells This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value, […]

Problem 6-8 Piedra Cretebuilders Probability Calculations Using the Normal Distribution – Template Enter data only in the shaded cells This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value, given the […]

Problem 6-4 Fruitayuda, Inc Probability Calculations Using the Normal Distribution – Template Enter data only in the shaded cells This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value, given the […]

1 CHAPTER 6 Statistical Methods in Quality Management Teaching Notes This chapter describes concepts of statistics, statistical thinking, statistical methodology, sampling, experimental design, and process capability. Students should be encouraged to take a “big picture” perspective on this framework, rather […]

Problem 6-20 Rabbitfoot Bank, Inc. Rabbitfoot Industry Data 33.9 40.0 34.8 39.6 Industry Data Rabbitfoot Bank 35.0 38.5 39.1 40.0 Mean 39.4750 Mean 38.0967 40.1 42.4 Standard Error 0.4134 Standard Error 0.4701 37.7 38.6 Median 40.1000 Median 38.2500 39.0 42.3 […]

Problem 6-2 Numeros Verdes Partners, P.S.C. COUNTIF FUNCTION Answers the question: Is the bill overdue? TRUE FALSE COUNTIF (RANGE, CRITERIA) –> COUNTED ITEMS 50 150 PERCENT OF TOTAL 25% 75% FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE TRUE FALSE […]

Problem 6-7 Wayback Cleaning Co. Probability Calculations Using the Normal Distribution – Template Enter data only in the shaded cells This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value, given […]

Problem 6-24 Paintfast Manufacturing Co. 22 Factorial Experiment Enter data ONLY in yellow-shaded cells. Description Name Low level High level Treatment Factor 1 Factor 2 Response=Dryability A Low Low 78 B High Low 91 C Low High 85 D High […]

Problem 6-25 Sival Electronics 23 Factorial Experiment Enter data only in yellow-shaded cells. Interaction Charts Calculations Base Case Factor 1 Factor 2 Average Description Name Level 1 Level 2 L L 10.5 Factor 1 Signal Low High H L 13 […]

Chapter 6 – Problems 15-19 Confidence Intervals Problem 6-15 (a) T.INV.2T for t-value, 2-tailed distribution, 95% conf. 2.131 CONFIDENCE.T interval for Students t-distribution 1.4920 Problem 6-15 (b) T.INV.2T for t-value, 2-tailed distribution, 99% conf. 2.947 CONFIDENCE.T interval for Students t-distribution […]

Problem 6-9 Machined Part Probability Calculations Using the Normal Distribution – Template Enter data only in the shaded cells This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value, given the […]

Problem 6-21 Softswift Software Developers Sub 1 Sub 2 Sub 3 Anova: Single Factor 86 90 89 73 85 82 SUMMARY 69 77 74 Groups Count Sum Average Variance 77 80 70 Sub 1 10 767 76.7 75.5667 86 92 […]

Problem 6-23 Sival Electronics One-Way ANOVA Supplier 1 Supplier 2 Supplier 3 Finish 1 11.9 6.8 13.5 Finish 2 10.3 5.9 10.9 Anova: Single Factor SUMMARY Groups Count Sum Average Variance Supplier 1 5 54.6 10.92 4.762 Supplier 2 5 […]

Problem 6-22 Rockglass, Inc. 600 3.2 650 1.8 Regression Statistics 700 3.9 Multiple R 0.96085 900 4.7 Observations 15.00000 950 5.3 1000 5.5 ANOVA 1050 5.4 df SS MS F Significance F 1100 6.3 Regression 1 42.66603571 42.666 156.361 1.27331E-08 […]

Problem 6-6 Kiwi Oil, Inc Probability Calculations Using the Normal Distribution – Template Enter data only in the shaded cells This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value, given […]

Problem 6-14 Wherehousing, Inc. Normal Distribution Probability Template Enter data only in yellow-shaded cells Mean, m50 Standard deviation, s0.5 x -value 48.50 Calculated z-value -3.0 F(x) = P(X ≤ x)0.00135 x z F(x) 48.50 -3.00 0.00135 48.55 -2.90 0.00187 48.65 […]

Statistical Methods in Quality Management 21 15. The distribution center manager at internet distributor CyberAuto Warehouse wants to find a confidence interval for the average time required for an associate to fill an order for shipment. A sample of 16 […]

ANS: F DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: Basic Probability Concepts KEY: Bloom’s: Knowledge ANS: T DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: Basic Probability Concepts KEY: Bloom’s: Knowledge ANS: F DIF: Difficulty: Easy NAT: BUSPROG: Analytic […]

The HMO Pharmacy Crisis i series,’ whatever that means. But get this, he will only identify the change points and send me a list. He says it’s my job to figure out what they mean and how to respond. I […]

ANS: F DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: Product Development KEY: Bloom’s: Knowledge ANS: F DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: Product Development KEY: Bloom’s: Knowledge ANS: T DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: […]

Ch 7 – Quality in Practice Applying QFD in in Managed Healthcare Direction of Rate of Co. Rate of Absol. % Font Use of Gloss. Q&A Tbl. of Lang. Improvement Import. Now Plan Improv. Wgt. Improve. size Update Photos colors […]

Problem 7-20 Widetred Tire Co. Enter data only in the shaded cells This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value, given the mean and standard deviation of a normally […]

Problem 7-21 Livelong, Inc. Computer Monitors Exponential Probability Distribution Template Enter data only in yellow-shaded cells. Failure rate per hour (λ) = 0.00095 Hours 5000 Calculated probability 0.991348 T = x Cum. Failure Hours Probability F(x) 0 0.000000 250 0.211403 […]

Problem 7-22 Satellite Radio Reliability Exponential Probability Distribution Enter data only in yellow-shaded cells. Failure rate per hour (λ) = 0.000015 Hours 12000 Calculated probability 0.164730 T = x Cumulative Failure Reliability Hours Probability F(x) 1-F(x) 0 0.000000 1.00000 137500 […]

Problem 7-13 MicroKeeb Co. Computer Chip Design Descriptive Statistics Original Data Sorted Data 2.001 1.998 Descriptive Statistics 2.000 1.998 2.001 1.999 Mean 2.00008 1.998 1.999 Standard Error 0.00021 1.999 1.999 Median 2.00000 2.000 1.999 Mode 2.00000 2.000 2.000 Standard Deviation […]

Example 7.4 Process A Process B Nominal 0.5 Nominal 0.5 k125000 k125000 Dimension, x Probability, f(x) (x – E[X])^2 Dimension, x Probability, f(x) (x – E[X])^2 0.47 0 0.0009 0.47 0.02 0.0009 0.48 0.2 0.0004 0.48 0.03 0.0004 0.49 0.2 […]

1 CHAPTER 7 Design for Quality and Product Excellence Teaching Notes The precise manner in which a person or team approaches product design, solving problems to achieve product excellence, or developing product reliability is not as critical as doing it […]

Problem 7-17 Call-Nowait handling time Descriptive Statistics Using Excel Functions Data Sorted data 16.5 4.3 Mean 6.0160 27.3 4.6 Median 6.2 By inspection of sorted data 10 7.1 5.9 11 6.5 6.0 12 6.2 6.1 13 7.2 6.2 14 7.4 […]

Problem 7-12 AutoCM, Inc. Descriptive Statistics Original Data Sorted Data Descriptive Statistics Bin Frequency 24.9349 24.8672 24.850 0 25.0666 24.8824 Mean 25.0056 24.875 1 25.0323 24.9180 Standard Error 0.0080 24.900 1 25.0666 24.9196 Median 25.0123 24.925 3 24.9842 24.9210 Mode […]

Problem 07 – 30 National Partamiento Co. Months in Service Number Installed Number Failed Number Not Failed Cumulative Failures Month x Failures Months in Service Monthly Failure Rate Cumulative Failure Rate 1 24440 1 24439 1 1 1 0.00004092 0.00004092 […]

Problem 7-19 Supercelluar Battery Life-Reliability Enter data only in the shaded cells This spreadsheet is designed to calculate the probability of values equal to, or less than, a desired x value, given the mean and standard deviation of a normally […]

Design for Quality and Product Excellence 32 26. Bestronics has a three-step process for processing customer sales. First, the cashier must look up the customer’s loyalty card on the company’s information system. Second, the cashier enters the transaction on the […]

Kingyro $0.567 85.3 124.0 23 Antonio’s $0.542 90.0 158.3 16 Georgio’s Targets $0.51/oz. 70/oz 110/ oz. 13% Total Sodium = 605 mg. Kingyro 35 4 5 2 3 4 Antonio’s 4 4 3 3 4 5 3 Speedy svc. – […]

Problem 7-16 BearingPort Airplane Co. Calculation of Taguchi Loss Values Value Loss ($) Process P Probability Weighted Loss ($) Process Q Probability Weighted Loss ($) 0.20 96.00 00.00 0.02 1.92 0.21 54.00 0.12 6.48 0.03 1.62 0.22 24.00 0.12 2.88 […]

Design for Quality and Product Excellence 21 ANSWER – CONTINUED 5. The Importance and Competitive Evaluation of customer requirements can be read from the survey results in the data tables in spreadsheet Prob07-05.xlsx that are provided, and placed under their […]

QIP – Applying SPC to Pharmaceutical Product Manufacturing Descriptive Statistics for Capability Study Original Data 4.959 4.955 4.943 4.954 4.967 4.945 4.958 4.957 Sorted Data 4.943 Median 4.9555 4.945 Mode #N/A 4.945 Standard Deviation 0.0083 4.946 Sample Variance 0.0001 4.948 […]

Bloomfield Tool Co. Gauge Repeatability and Reproducibility This spreadsheet is designed for up to three operators, three trials, and ten parts. Enter data ONLY in yellow shaded cells. Number of operators 2Upper specification limit 0.10 Average range 0.0072 Number of […]

Chapter 8 Knight Industries 26 69 62.9 13.2 27 74 62.6 13.2 28 72 63.4 13.2 29 77 63.2 13.3 30 73 63.0 13.3 31 77 62.6 13.2 37 79 62.7 13.2 Spec. Limits 60-80 60-65 12.6-13.5 38 79 62.6 […]

Bloomfield Tool Co. Gauge R&R Data Sample Operator 1 Operator 2 1 0.0650 0.0600 0.0650 0.0550 2 0.1000 0.1050 0.1050 0.0950 6 0.0850 0.0800 0.0750 0.0700 7 0.0600 0.0700 0.0550 0.0640 8 0.0680 0.0750 0.0670 0.0720 9 0.0800 0.0910 0.0870 […]

Case – Hydraulic Lift Co. The Hydraulic Lift Company (HLC) manufactures freight elevators and automotive lifts used in garages and service stations. Figure 1 shows a simplified diagram of a hydraulic lift. The check valve is an important component in […]

Knight Industries Viscosity Measures X and Moving Range Chart This spreadsheet is designed for up to 50 observations and a moving range from 2 to 5. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 […]

CBT Company Packing Slip Errors This spreadsheet is designed for up to 75 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control chart (some rescaling may be needed). Sample Number of Unit Defects […]

60 Cpl 0.586070683 60 Cpk 0.586070683 60 60 60 60 70 70 70 70 75 75 75 75 75 75 80 80 80 80 80 Hydraulic Lift Company Situation 1 Original Data Column1 85 45 80 60 85 70 80 […]

5. Define each of the following control chart patterns. Include a sketch of each pattern with your definition. a. One point outside the control limits b. Sudden shift in the process average c. Cycles d. Trends e. Hugging the center […]

22 74 62.7 13.3 23 70 62.9 13.3 24 75 62.9 13.2 25 65 62.8 13.2 26 69 62.9 13.2 27 74 62.6 13.2 28 72 63.4 13.2 29 77 63.2 13.3 30 73 63.0 13.3 31 77 62.6 13.2 […]

CHAPTER 08—MEASURING AND CONTROLLING QUALITY TRUE/FALSE 1. A nonconforming unit of work is one that has no defects or errors. 2. Attribute measurement requires a much larger sample size than variable measurement to obtain the same amount of statistical information. […]

Chapter 8 Hallenvale Hospital Case Fraction Nonconforming (p) Chart This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control chart (some rescaling may be needed). Average […]

Problem 8-16 Precision Parts, Inc. Gauge Repeatability and Reproducibility This spreadsheet is designed for up to three operators, three trials, and ten parts. Enter data ONLY in yellow shaded cells. Number of operators 3 Upper specification limit 1.8 Average range […]

Chapter 8 – Measuring and Controlling Quality 101 ANSWERS TO CASE QUESTIONS I. CONTROL OF TFE’S AT HALLENVALE HOSPITAL 1. A control chart constructed from these data is shown in Figure 8.7. (Note that if the control limits are removed, […]

Chapter 8 – Measuring and Controlling Quality 41 Variance Ratios EV% of Total Variance = 100 𝐸𝑉2 𝑇𝑉2 = 100 0.1012 01362 = 55.15% [54.17% – rounding error] AV% of Total Variance = = 100 𝐴𝑉2 𝑇𝑉2 = 100 0.0122 […]

Problem 8-33 Constant Hope Hospital This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 and the […]

Problem 8-35 El Toro Grande Restaurante This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 and […]

Prob. 8-19 Statistics 23.996 23.995 24.004 23.994 24.001 24.006 23.986 24.001 Problem 8-19 Kermit Theatrical Productions Data Column1 24.029 24.003 Mean 24.0014 24.020 Standard Error 0.0009671 23.991 Median 24.001 24.002 23.998 23.993 24.016 24.010 23.991 24.008 24.015 23.990 24.013 24.010 […]

Chapter 8 – Measuring and Controlling Quality 61 Minimum –1.310 Maximum 1.290 Sum 2.710 Count 250 Bin Frequency –1.35 0 –0.95 13 The values appear to be slightly skewed to the left, so the mean is smaller than the median […]

Quality Measurements Bin Sample 1 2 3 4 5 Mean 0.55 Bin Frequency 10.682 0.689 0.776 0.798 0.714 0.732 0.60 0.55 1 20.787 0.860 0.601 0.746 0.779 0.755 0.65 0.60 1 16 0.816 0.817 0.768 0.716 0.649 0.753 17 0.826 […]

Chapter 8- Problem 13a Aussieburgers, Ltd. Descriptive Statistics and Frequency Chart This spreadsheet is designed for up to 100 pieces of data Enter data ONLY in yellow-shaded cells. Note: The data and cell boundaries below were sorted in ascending order […]

Problem 8-34 Fujiyama Electronics This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 and the sample […]

Chapter 8- Problem 12a Genetic Research Thermometers Descriptive Statistics and Frequency Chart This spreadsheet is designed for up to 100 pieces of data Enter data ONLY in yellow-shaded cells. Note: The data and cell boundaries below were sorted in ascending […]

Problem 8-38 Gotham City Police Department X and Moving Range Chart This spreadsheet is designed for up to 75 observations and a moving range from 2 to 5. Enter data ONLY in yellow-shaded cells. Enter the number of samples in […]

Prob. 8-29 Hawkeye Magnetronics This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 and the sample […]

Problem 8-24 Hawkeye Magnetronics Run Chart – Showing Sample Means Over a Time Period See Run Chart Tab for this chart Number of observations 90 Grand Average Sample Mean Observation Values DATA 22 0.36 20 0.35 0.39 0.37 0.37 23 […]

Problem 8-28 Hermitage DNA Labs, LLC Sample Observations -1.31 -1.29 1 0.23 -0.04 0.44 -0.79 -0.07 -1.29 Descriptive Statistics Bin Frequency 2 -0.14 -0.83 0.81 0.21 -1.31 -1.21 -1.35 0 3 0.16 -1.29 0.77 -0.28 -0.11 -1.18 Mean 0.011 -0.95 […]

Prob08-06.xlsx Problem 8-06 Great Press Printing Company Cost Quality Cost Total $000’s QUALITY COSTS Prevention 5.31 Total Quality Cost 100.00 Costs by Category Customer complaint remakes $27,000 Ext. Fail. Printing plate revisions 28,000 Int. Fail. Other waste 38,000 Int. Fail. […]

Problem 8-26 J. McWilliams Swim Club This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 and […]

Prob. 8-18 Statistics 0.578 0.579 0.579 Problem 8-18 Mach4 Tool Co. 0.573 Column1 0.573 0.573 Mean 0.5755 0.574 Standard Error 0.0003 0.576 0.576 0.577 0.577 0.577 Page 1 0.574 Median 0.5750 0.574 Mode 0.5750 0.574 Standard Deviation 0.00169 0.575 Sample […]

Chapter 8 – Measuring and Controlling Quality 81 37. Calculate the process capability statistics for the outside diameters of the bottles made on the injection molding machine at the Moby Molding Co. (from Prob. 8-36). Use 0.12 as the upper […]

Problem 8-36 Moby Molding Company This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 and the […]

Problem 8-15 Frankford Brake Systems Gauge Repeatability and Reproducibility This spreadsheet is designed for up to three operators, three trials, and ten parts. Enter data ONLY in yellow shaded cells. NOTE: 0’s were filled into the template for the third […]

Prob08-08.xlsx Problem 8-08 Repack Solutions Inc. Quality Costs and Percentages Customer complaint rework 40,000 Error correction 43,000 Int. Fail. Correcting erroneous orders before shipping 43,000 Other waste 42,500 Int. Fail. Quality training of associates 30,500 Typo corrrections 13,500 Int. Fail. […]

Problem 8-20 River City Parts Co. Sample Means and Standard Deviations 1.75134 2.00100 1.24558 1.71195 1.99752 1.24992 1.74831 2.00100 1.25209 1.77861 2.00100 1.24992 1.75740 1.98708 1.24992 1.73619 1.99404 1.24558 1.74225 1.98708 1.24992 Part 1 Part 2 Part 3 1.74831 2.01144 […]

Prob. 8-17 Statistics Problem 8-17 Mach4 Tool Co – Machining Process Original Data 0.575 Range 0.0300 0.574 Minimum 0.5560 0.575 Maximum 0.5860 0.575 Sum 14.3500 0.577 Count 25 0.577 0.577 0.577 0.556 Column1 0.556 0.562 0.564 0.564 0.572 0.562 0.572 […]

Prob08-05.xlsx Problem 8-2 SALES AND QUALITY COSTS Problem 8-05 Costcutin Company Total Sales $1,537,280 $933,600 $1,397,120 Costs as % of Sales 0.21 0.18 0.12 $ 000’s % of Quality Costs by Product $Qual. Cost – A $Qual. Cost – B […]

Problem 8-30A Rapid Check Kiters Calculation of control limits with 20 samples. This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number […]

Problem 8-25 River Bottom Fire Department This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 and […]

Problem 8-22 River Bottom Fire Department Histogram and Run Charts See Histogram and Run Chart Tabs for Results Number of observations 180 Grand Average Sorted DATA Observation Values 1 3.81 Sample 1 2 3 4 5 6 Means Descriptive Statistics […]

Chapter 8 – Measuring and Controlling Quality 112 IV. Skyhigh Airlines The solution to this case involves a fairly straight-forward sequential analysis of the system that can be obtained by using the following model (note each X = 1 person […]

Prob08-11.xlsx Problem 8-11 Beechmount Software Corporation Quality Costs and Percentage Percent Cumulative % Cost Returns 38.92% 38.92% 360,000 Inspection costs (extra)–outgoing 65,000 Customer returns 360,000 Training and system improvement costs 28,000 System downtime 88,000 Total Quality Costs $925,000 Total Costs […]

Problem 8-14 NEW Gauge, Inc. Gauge Repeatability and Reproducibility This spreadsheet is designed for up to three operators, three trials, and ten parts. Enter data ONLY in yellow shaded cells. Number of operators 3Upper specification limit 1.6 Average range 0.028 […]

1 CHAPTER 8 Measuring and Controlling Quality Teaching Note This chapter presents the basic concepts of statistical process control. These include purposes, control charting techniques, design and analysis of charts, managerial requirements for implementation of SPC, and SPC considerations within […]

Prob08-10.xlsx Problem 8-10 Stateside Metrology Repairs, Inc. Quality Costs and Percentage Percent Cumulative % Cost Customer returns 36.36% 36.36% $120,000 Workstation downtime 18.18% 54.55% 60,000 Rework costs 16.67% 71.21% 55,000 Original Data Inspection costs — incoming 20,000 Workstation downtime 60,000 […]

Chapter 8 – Measuring and Controlling Quality 21 Answer 6. Original Data: Cost Element Amount Customer complaint remakes $ 27,000 Printing plate revisions 28,000 The spreadsheet data and pie chart (see spreadsheet Prob08-06.xlsx in the Instructor materials for details) for […]

Prob08-07.xlsx Problem 8-07 Miami Valley Aircraft Service Co. $000’s QUARTERLY QUALITY COSTS External failure 4.76 4.62 3.88 3.54 Internal failure 16.67 16.67 11.84 10.73 Appraisal 4.29 6.15 6.33 3.90 Prevention 1.90 2.56 2.65 3.90 Total Quality/Labor Cost 27.62 30.00 24.69 […]

Prob08-09.xlsx Problem 8-9 Nosoco Paper Company Quality Costs and Percentages Rejected paper 375,000 Odd lot 66,000 Inspection 25,000 Customer complaints 103,000 Wasted materials 31,000 Quality improvement training 10,000 Total Quality Cost $655,000 Percent Cumulative % Cost Rejected paper 57.25% 57.25% […]

Problem 8-23 Palma State Bank Run Chart – Showing Sample Means Over Time Number of observations 125 Grand Average Sample Mean DATA Observation Values Sample 1 12.09 1 2 3 4 5 Means 2 12.20 1 11.86 12.09 12.05 12.25 […]

Problem 8-32 PCDrives Process Capability Analysis – X-Bar and R-charts Note: This spreadsheet has been modified to use the sample statistics, without requiring the sample data. The process capability calculations relied upon the estimated standard deviation = R-bar/d 2 This […]

Hydraulic Lift Company Situation 1 85 45 80 60 85 70 80 50 60 80 50 100 80 60 85 90 75 50 60 90 85 80 60 85 65 80 45 60 70 70 70 90 80 60 70 […]

Montvalley Short-Haul Lines, Inc. Billing Study II Average Number of Defects Per Unit (u) Chart This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control chart […]

Montvalley Short-Haul Lines, Inc. Initial U-Chart (Base Case) Average Number of Defects Per Unit (u) Chart This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control […]

Data Montvalley Short-Haul Lines, Inc. Error Category % of Total Cumulative Errors Errors Percent 0 2300 24.35% 24.35% Page 1 8264 21.43% 45.78% 1159 12.91% 58.69% 6151 12.26% 70.94% 4147 11.93% 82.87% 587 7.06% 89.94% 762 5.03% 94.97% 362 5.03% […]

Knight Industries Solids Process Capability Analysis This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells. 363.700 62.900 62.900 62.500 463.600 63.400 62.900 62.500 562.400 62.600 62.800 62.300 663.400 63.300 62.900 63.200 763.200 64.100 […]

Chapter 8 Morelia Mortgage Co. – Remove outliers This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell […]

wanted to be sure that it was needed. He decided to do a gauge R&R test and selected two experienced inspectors to perform the test using 15 identical parts, whose dimensions had been verified. Table 1 shows data provided by […]

Chapter 8 Morelia Mortgage Co. – Additional samples added This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in […]

Knight Industries i Weight solids: 60–65 percent Weight per gallon: 12.6–13.5 The Excel file C08 KnightIndData.xlsx (available in the Instructor Reserve case folder) contains data for a series of batches that were produced. Using appropriate SPC charts or other statistical […]

1 2 3 4 5 9 14 15 16 17 18 19 20 21 22 23 24 385.000 80.000 60.000 85.000 65.000 80.000 45.000 60.000 70.000 70.000 470.000 90.000 80.000 60.000 70.000 70.000 90.000 100.000 70.000 70.000 575.000 45.000 60.000 […]

Knight Industries Solids Measures X and Moving Range Chart This spreadsheet is designed for up to 50 observations and a moving range from 2 to 5. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 […]

Chapter 8 Morelia Mortgage Co. – Original data This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell […]

Montvalley Short-Haul Lines, Inc. Billing Study Part II Fraction Nonconforming (p) Chart This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control chart (some rescaling may […]

Montvalley Short-Haul Lines, Inc. Base Case Table 1 MVSH Defective Billing Data Table 2 MVSH Distribution of Billing Errors No. of Error Category Day No. Defective Bills Day Bills 1 2 3 4 5 6 7 8 110 154 463326210 […]

Montvalley Short-Haul Lines, Inc. Initial p-chart (Base case) Fraction Nonconforming (p) Chart This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control chart (some rescaling may […]

Chapter 9 – Case Freadilunch 1 Vacant Tables Day During the Freadilunch Restaurant “Rush Hours” 11:00 11:15 11:30 11:45 12:00 12:15 12:30 12:45 1:00 1:15 1:30 1:45 2:00 Mon. -Wk. 1 10 124301182659 Wk. 29322110353447 Wk. 36441020433368 Wk. 4 11 […]

Case: The PIVOT Initiative at Midwest Bank – Part II 1 1 Appreciation is expressed to one of the author’s students, Michael Wolf, who wrote the paper on which this case is based, as part of the requirements for MGT […]

Aircraft Parts order Flowchart New or refurbished? On-hand? Aircraft parts order needing to be filled Call to order Refurbished No Yes Phone, fax, or e- mail order by customer Check for in-stock info. ? Assigned to picker? Place label & […]

Problem 9-10 Aircraft Parts Distributors EMPLOYEES PROCESSING METHOD Experience Number of orders per time period COMPUTER ENTRY PROCEDURES Empowerment to contact client Sequencing of work Training on the equipment Error check method Training on how to handle errors in orders […]

Prob09-19.xlsx Problem 9-19 Lauren Elizabeth Apparel Company QUALITY ERRORS AND PERCENTAGES Percent Cumulative % Frequency Electronic charge errors 52.20% 52.20% 5220 Shipping errors 23.10% 75.30% 2310 Billing errors 9.95% 85.25% 995 Delivery errors 7.95% 93.20% 795 Long delays 6.80% 100.00% […]

Prob09-13.xlsx Problem 9-13 ElecktronTech Student Trainees in Electronics Time (minutes) Times Percent Cumulative % Freq Sorted Values 92.17% 2.00% 1 9 10 6.52% 8.00% 310 11 10.87% 18.00% 510 811 15 918 16 10 10 16 11 10 16 12 […]

Process Improvement and Six Sigma 21 3.5 22750.1 5.1 159.1 3.6 17864.4 5.2 107.8 3.7 13903.4 5.3 72.3 5. Nanospark Electronics manufactures 100,000 circuit boards per month. A random sample of 1,000 boards is inspected every week for three characteristics. […]

Prob09-16.xlsx Lack of press time 245 Design department delays 80 Paper not in stock 70 Lack of proper order information 49 Lost order 26 Press setup delays 205 Problem 9-16 Deuce Printing Company QUALITY ERRORS AND PERCENTAGES Percent Cumulative % […]

Problem 9-15 Plastic Gear for PrintHeads, Inc. 3.76 3.76 3.75 3.78 3.79 3.71 3.76 3.76 3.75 3.78 3.79 3.71 3.76 3.76 3.81 3.78 3.79 3.72 3.76 3.76 3.73 3.78 3.79 3.72 3.76 3.77 3.81 3.78 3.79 3.72 3.76 3.77 3.81 […]

Process Improvement and Six Sigma 41 • Average amount in accounts receivable divided by average number of sales. • Percentage of accounts received past due. • Sum of the dollar amount in accounts receivable, multiplied by the number of days […]

Problem 9-20 Monterey Fiesta Mexican Restaurant Raw Data Breadstick Week Orders Margaritas 1860 1330 Correlation Matrix 2850 1350 Week Orders Margaritas 3800 1290 Week 1 4850 1350 Orders 0.071102 1 5880 1360 Margaritas -0.06291 0.968071 1 6780 1250 7815 1275 […]

Input Data Problem 9-12 Lakerside United Bank Cash Bank Cash Strapping Errors Errors vs. Weeks of Employment Average Weeks Weekly on Job Errors 314.7 616.3 917.1 12 17.0 13 11.1 16 13.7 21 16.7 Page 1 23 14.4 25 10.8 […]

Raw Data Problem 9-17 DeltaWidgets, Inc. Production Rate vs. Defects Production Rate Defects 13 9 16 10 Page 1 20 16 25 17 28 18 32 22 36 25 38 20 41 20 43 12 48 12 50 16 53 […]

Problems 9-02 and 9-03 Calculations for dpmo and sigma levels Prob. 9-2 NORM.S.INV(1 – Number of Defects/Number of Opportunities) + SHIFT For a probability of 98.7% good items, we find NORM.S.INV(0.987) + SHIFT = 3.226212 Prob. 9-3 Alpha Beta Gamma […]

Problem 9-14 Packman Shipping – Packing Times Scatter Diagram This spreadsheet is designed for up to 40 single values. Enter data ONLY in yellow-shaded cells. Enter the number of values in cell E6. Then enter your data below. To recalculate […]

Problem 9-18 Buenosdientes Candy Company Scatter Diagram This spreadsheet is designed for up to 25 single values. Enter data ONLY in yellow-shaded cells. Enter the number of values in cell E6. Then enter your data below. If X-axis value differ […]

Problem 9-9 Placewrite, Inc. EMPLOYEES PROCESSING METHOD Experience Number of clients per processor Empowerment to contact client Sequencing of work Training on the equipment Error check method Training on how to handle errors in copy Instruction on resume writing Format […]

Problem 9-04 Calculations for dpmo levels Sigma Level dpmo Sigma Level dpmo 3.0 66807.2 4.6 967.6 Use the formula: = (1 – NORM.DIST(4,1.5,1,TRUE))*1000000 = 6209.7 dpmo 3.1 54799.3 4.7 687.1 3.2 44565.5 4.8 483.4 3.3 35930.3 4.9 336.9 3.4 28716.6 […]

1 CHAPTER 9 Process Improvement and Six Sigma Teaching Notes This chapter brings process improvement and the Six Sigma concept into a sharp focus, and builds on the need to integrate a performance management framework with operational requirements in managing […]

ANS: T DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: Process Improvement Methodologies KEY: Bloom’s: Knowledge ANS: T DIF: Difficulty: Easy NAT: BUSPROG: Analytic TOP: A-Head: Process Improvement Methodologies KEY: Bloom’s: Knowledge ANS: F DIF: Difficulty: Moderate NAT: BUSPROG: Analytic […]

National Furniture Store C-E Diagram for Special Order Errors SALES ASSOCIATE ORDER PREPARATION Lack of complete information from customer Incorrect FAX bin Lack of additional customer info to office No request for office to re-FAX order Lost or misplaced order […]

Raw data Freadilunch Case – Sheet 2 Checksheet Data for Customer Concerns During the Readilunch Restaurant “Rush Hours” Day Mon. 11:00 11:30 12:00 12:30 1:00 1:30 2:00 Total Take-out probs. 2 4 3 5 4 1 2 21 Long table […]

Janson Medical Clinic Analysis of Complaint Data Wait for doctor 18.06% 18.06% 13 Ease of appointment 16.67% 34.72% 12 Ease of phoning 13.89% 48.61% 10 Convenient hours 9.72% 58.33% 7 Courtesy of receptionist 9.72% 68.06% 7 Friendliness of phone receptionist […]

At the regional office, the special order department receives the fax from the store, reviews it, and informs the store if additional information is needed. When all the information is complete, they process the order. Sometimes they lose or misplace […]

financial impact analysis and equipment purchasing. The assistant vice president and team supervisor, were subject matter experts from within CPD. Another project coordinator was brought on board for her bank wide knowledge and overall project support. The project analyst for […]

Case – Implementing Six Sigma at GE Fanuc i to see a lot of good data driving decision making. . . . We have ingrained our tool sets within our people, so Six Sigma is a philosophy and an outlook […]

Fraction Nonconforming (p) Chart This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control chart (some rescaling may be needed). Average (p-bar) Avg. sample size Approximate […]

This spreadsheet is designed for up to 75 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control chart (some rescaling may be needed). Average (u-bar) Sample Number of Unit Defects Standard Sample Nonconformances […]

Binomial Probability Distribution Enter data only in yellow-shaded cells. Number of successes, x3 x f(x) F(x) 00.10737 0.10737 10.26844 0.37581 20.30199 0.67780 30.20133 0.87913 40.08808 0.96721 50.02642 0.99363 60.00551 0.99914 70.00079 0.99992 80.00007 1.00000 90.00000 1.00000 10 0.00000 1.00000 11 […]

Number Nonconforming (np) Chart This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. Each sample must have a constant sample size; enter this in cell C6. Click on the sheet tab to display the […]

Confidence Interval for Population Mean, Standard Deviation Known Alpha 0.05 Standard deviation 0.5 Upper 100.4633 Sample size 36 Sample average 100.3 Confidence Interval 95% Error 0.1633 Lower 100.1367 Confidence Interval for Population Mean, Standard Deviation Unknown Alpha 0.05 Sample standard […]

Process A Process B Nominal 0.5 Nominal 0.5 k125000 k125000 Dimension, x Probability, f(x) (x – E[X])^2 Dimension, x Probability, f(x) (x – E[X])^2 0.47 0 0.0009 0.47 0.02 0.0009 0.48 0.2 0.0004 0.48 0.03 0.0004 0.49 0.2 0.0001 0.49 […]

Copyright 2000: James R. Evans. For use exclusively with The Management and Control of Quality, 5th Edition or higher. This software may not be used for any commercial purpose, modified, or or otherwise distributed without written permission from the author. […]

22 Factorial Experiment Copyright © 2013 Cengage Learning Interaction Charts Calculations Enter data only in yellow-shaded cells. Factor 1 Factor 2 Average Description Name Low level High level L L #DIV/0! Factor 1 H L #DIV/0! Factor 2 L H […]

22 Factorial Experiment Enter data ONLY in yellow-shaded cells. Description Name Low level High level Treatment Factor 1 Factor 2 Response ALow Low 84 B High Low 90.5 CLow High 88.5 D High High 81 Main Effects Factor 1 -0.50 […]

This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control chart (some rescaling may be needed). Average (c-bar) Standard deviation Number of Sample Nonconformances LCLc CL […]

SUMMARY OUTPUT Regression Statistics Multiple R 0.999967043 R Square 0.999934087 Adjusted R Square 0.999925848 Standard Error 0.027282724 Observations 10 ANOVA df SS MS F Significance F 4 4.071249331 0.018750669 5 5.092354294 0.017645706 6 6.044063774 0.035936226 7 7.194046063 0.005953937 8 8.294460149 […]

This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 and the sample size in cell E7. […]

This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. Enter data ONLY in yellow-shaded cells. Enter the number of samples in cell E6 and the sample size in cell E7. […]

1 2 3 4 5 6 7 8 9 10 11 12 13 40 A B C D E F G H I J K L M N O P Q R S T U V W Process Capability Analysis […]

U-Bolt Data 10.80 10.80 10.70 10.70 10.65 10.60 10.55 10.65 10.75 10.75 10.65 10.60 10.50 10.80 10.65 10.65 10.70 10.85 10.80 10.70 10.75 10.75 10.80 10.80 10.80 10.70 10.75 10.75 10.70 10.70 10.65 10.60 10.70 10.65 10.75 10.80 10.60 10.70 […]

1 2 3 4 5 6 7 34 A B C D E F G H I J K L M N O P Q R S T U V W X Y Frequency Distribution and Histogram This template is […]

Fraction Nonconforming (p) Chart This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. Click on the sheet tab to display the control chart (some rescaling may be needed). Average (p-bar) Avg. sample size Approximate […]

Gauge Repeatability and Reproducibility This spreadsheet is designed for up to three operators, three trials, and ten parts. Enter data ONLY in yellow shaded cells. Number of operators 3 Upper specification limit 1Average range 0.029 Number of trials 2 Lower […]