Archives

BALDRIGE APPLICATION REVIEW AND SCORING PROCESS The Baldrige Award Evaluation Process The Baldrige evaluation process is rigorous, and designed to be objective and tamper proof against political pressures. In the first stage, each application is thoroughly reviewed by approximately 7 […]

Applying SPC to Pharmaceutical Product Manufacturing Original Data Bins Average 4.954 4.959 4.955 4.943 4.954 4.967 4.945 4.958 4.957 4.970 Standard deviation 4.955 7 4.960 9 4.965 7 4.970 3 More 0 0 1 2 3 4 5 4.935 4.940 […]

Name: Class: Date: chapter 1 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. According to the manufacturing perspective of quality, quality is based on consistency in goods and services. a. True […]

Introduction to Quality 16 ‘look and feel’ of the Apple watch. When you look at it, it’s obvious that it’s a quality product.” In speaking of product-and value-based quality, the student might point out that the watch has a lot […]

Quality in Practice: Building Trust Through Quality at Gerberi The Gerber baby picture — which accompanies everything from strained carrots and banana cookies to teething rings and diapers — has developed into one of the most recognizable brand images in […]

1 CHAPTER 1 Introduction to Quality ANSWERS TO INSTRUCTOR RESERVE MATERIALS Instructor Reserve materials are older Quality in Practice features and Cases from previous editions that may be used by the instructor to give the students additional experiences. These are […]

1 CHAPTER 1 Introduction to Quality Teaching Notes In the first class session, we typically provide a few introductory remarks about the importance of quality. A good way to start is to make students read the opener to Part 1 […]

Name: Class: Date: chapter 10 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. A key role of strategic planning is to align work processes and learning initiatives with an organization’s strategic […]

Six Sigma process began in late 1999 and early 2000 with training for SEC’s management, champions, and other employees responsible for planning and deployment. Within three years, 1 Adapted from Jong-Yong Yun and Richard C.H. Chua, “Samsung Uses Six Sigma […]

1 Instructor Reserve Case Solutions Quality in Practice Building Business Excellence in Hungary Latent needs are one of the challenging issues that Westel, and other telecommunications companies, in general, must address. Customers and other stakeholders are often not aware of […]

The Baldrige Framework for Performance Excellence 17 • Traditional management practices • Growing awareness of the importance of quality • Development of a solid quality management system • Outstanding, world-class management practice In each cell of the matrix, list two […]

TecSmart Electronics1 TecSmart Electronics designs, manufactures, and repairs electronic power supplies for a variety of original equipment manufacturers in the computer, medical, and office products field. The company’s focus is summed up by three simple words: quality, service, and value. […]

1 CHAPTER 10 The Baldrige Framework for Performance Excellence Teaching Notes This chapter introduces the Malcolm Baldrige National Quality Award and Excellence Framework, which is the basis for Part III of this book. It also discusses other international quality and […]

Quality in Practice: Building Business Excellence in Hungary1 One of Europe’s major success stories since the fall of the Iron Curtain is Hungary, whose economy grew even during the recent worldwide recession. Quality improvement is credited by many as the […]

Name: Class: Date: chapter 11 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. Core competencies may involve technology expertise, unique service offerings, a marketplace niche, or a particular business acumen. a. […]

1 Instructor Reserve Case Solutions Case: The Creative Design Group 1. See the Affinity Diagram, below. It is constructed similar to Figure 11.4. The diagram for CDG shows categories that include customer service, team environment, facilities/technology, design goals, worker amenities, […]

1 CHAPTER 11 Strategy and Performance Excellence Teaching Notes This chapter centers on strategic management for quality and performance excellence. While leadership is acknowledged as the driver for an effective TQ focus, strategic planning makes it happen. Thus, leaders must […]

Strategy and Performance Excellence 14 3. Try to match the following companies with their actual mission statement in question 2. Could you think of more appropriate mission statements for any of these organizations? a. Volvo b. AT&T c. The International […]

Performance Measurement and Strategic Information Management 19 10. A large hospital identified the following strategic priorities: Patient accessibility Patient safety Clinical excellence Few hassles for patients and families Workforce well-being Family-centered care Operational efficiency Suggest some measures that align to […]

1 CHAPTER 12 Measurement and Knowledge Management For Performance Excellence Teaching Notes This chapter develops concepts of measurement and knowledge management from an organizational perspective (in contrast to quality control measurement discussed in Chapter 8). Much of this chapter is […]

Name: Class: Date: chapter 12 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. Leading indicators of a balanced scorecard represent long-term results. a. True b. False 2. A useful approach to […]

Name: Class: Date: chapter 13 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. In the context of transactional leadership theory, contingent reward behavior includes clarification of the work required to obtain […]

Leadership for Performance Excellence 13 quality ethic — which means having a deep belief that what you do to make quality better makes everything in the organization better.” 4. State some examples in which leaders you have worked for exhibited […]

Leadership for Performance Excellence 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 […]

Leadership for Performance Excellence 1 Instructor Reserve Case Solutions Cases I. Westerfield Construction 1. Deters fostered cultural change at Westerfield Construction by essentially following the suggestions of Juran and others for effective change, including: a. It must create and maintain […]

Name: Class: Date: chapter 14 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. An example of a dysfunctional culture is a high-tech company that stresses team rewards while innovation depends on […]

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 […]

1 5. The company should stay with its TQ focus. Frequently, corporations that institute a TQ process quit too early, thus damaging employee morale and losing momentum in quality efforts. Rather than a sudden, wrenching change, Harry Rule should introduce […]

Building, and Sustaining Quality and Performance Excellence 12 15. Why have small businesses and not-for-profits been slow to adopt quality initiatives? Small organizations and nonprofits have generally been slow to adopt quality initiatives because of a lack of understanding and […]

planning system, including Key Performance Indicator (KPI) goal sets, the Educational Testing Service and Educational Benchmarking, Inc. survey feedback, and the integration of a Malcolm Baldrige-based assessment system. Also included in this framework is the development of a student-centered process, […]

Error Data Chapter 2 The Disciplinary Citation Case Data Operator 6 0 7 721 7 8 0 7 9 8 7 10 12 7 11 3 7 12 4 7 13 8 7 14 4 7 Errors Average (used for […]

Bachelor of Science in business administration. Future business students would declare business as a major and choose from six emphasis areas: accounting, computer information systems, finance, management, marketing, or general business. Quality in Practice: Kenneth W. Monfort College of Businessi […]

Sales Data Chapter 2 The Quarterly Sales Report Case Large Regions with Sales Jump Region 1Q – 12 2Q – 12 3Q – 12 4Q – 12 1Q – 13 2Q – 13 3Q – 13 4Q – 13 1Q […]

1 CHAPTER 2 Foundations of Quality Management 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 […]

French plant is connected by a broadband system to the head office, enabling it to transmit video, audio, and facility performance data. Engineers in Japan can monitor the data of the plant’s operation in real time, check machinery utilization rates, […]

Error Data Chapter 2 The Disciplinary Citation Case Data Operator 24 3 7 25 5 7 26 20 7 27 6 7 28 8 7 29 5 7 30 6 7 Errors Average (used for center line of run chart) […]

Total Quality in Organizations 18 integrated their QMS with enterprise resource planning (ERP), less than 30% with manufacturing execution systems (MES), and only about 25% with supply chain management (SCM). ANSWERS TO DISCUSSION QUESTIONS 1. Compare the Deming Chain Reaction […]

Name: Class: Date: chapter 2 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. Setting simple goals is one of the practices that is used for implementing leadership as a quality management […]

Focusing on Customers 35 a. What total percent of the dissatisfied customers who complained and who did not complain were retained? (Hint: draw a decision tree diagram to illustrate this information.) Outcomes Retained (90%) 16 Left (10%) 2 Resolved quickly(75%) […]

Audrey’s Beauty Boutique 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 30 31 32 33 34 […]

Personal Use Business Use Performance Importance Quadrant Performance Importance Quadrant Data Personal use Business use Mechanical condition of car 4.8 4.95 Strength Mechanical condition of car 4.71 4.95 Strength Mechanical condition of car 4.8 4.71 Getting nonsmoking car 3.88 4.87 […]

• Studying which goods and services are purchased together, leading to good ways to bundle them, and • Studying and predicting what Web characteristics are most attractive to customers and how the Web site might be improved, 1 CHAPTER 3 […]

Versailles Sporting Goods Months Survey attribute 1 2 3 4 5 6 7 8 9 10 11 12 1. Friendliness of employees 6.9 6.2 5.4 5.5 6.0 5.9 6.8 6.5 4.9 4.1 5.0 5.4 2. Knowledge of products 7.0 6.3 […]

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 […]

Personal Use Business Use Performance Importance Quadrant Performance Importance Quadrant Data Personal use Business use Mechanical condition of car 4.8 4.95 Strength Mechanical condition of car 4.71 4.95 Strength Mechanical condition of car 4.8 4.71 Getting nonsmoking car 3.88 4.87 […]

Performance Importance Quality 3 5 Ease of doing business 2 4 Friendly staff 4 5 Average 3.6 3.8 3 4 0 1 2 5 6 0 1 2 3 4 5 6 Importance Performance Importance Price 5 3 Offerings 4 […]

Performance Importance Quality 3 5 Ease of doing business 2 4 Price 5 3 Offerings 4 2 Friendly staff 4 5 Average 3.6 3.8 0 1 5 6 0 1 2 3 4 5 6 Performance Importance 2 3 4 […]

Easy Quality Solutions 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% 9.1 8.8 […]

hassle of opening stores and warehouses and dealing with inventory. However, Bezos quickly discovered that the only way to make sure customers get a good experience and that Amazon gets inventory at good prices was to operate his own warehouses […]

Focusing on Customers 21 18. How has the Zero Moment of Truth affected your shopping experiences? Provide some examples. Students will have different stories to relate in how the Zero moment of truth affects their shopping experiences. For example, one […]

Net Promoter Score Data for Richard’s Radical Reservations Customer Number 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 NPS Rating 997867976879689510 10 10 […]

how they arrive at a decision because the process by which decisions are made is mostly intuitive. Although incidents of help line support do not ordinarily qualify as emergencies, the company assumed that this use of intuition was the reason […]

Versailles Sporting Goods Months Survey attribute 12345678910 11 12 1. Friendliness of employees 6.9 6.2 5.4 5.5 6.0 5.9 6.8 6.5 4.9 4.1 5.0 5.4 2. Knowledge of products 7.0 6.3 5.4 4.8 5.8 6.3 6.0 6.8 6.7 6.5 6.0 […]

Name: Class: Date: chapter 3 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. The effectiveness of the field intelligence method of gathering customer information depends upon a culture that encourages open […]

Changing business needs are assessed by reviewing the annual reports of competing restaurants, and an annual market research study that permits benchmarking against the restaurant/convenience food industry in general. Gold Star Chili Customer Market Focus! Gold Star Chili, Inc., based […]

Name: Class: Date: chapter 4 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. Creating a culture for high performance begins with senior leadership’s commitment to the workforce. a. True b. False […]

17 25. Outline the characteristics of the Gallup Q12 survey instrument for employee engagement and explain the management uses for three categories in the resulting “engagement index.” The characteristics of the Gallup Q12 survey instrument for employee engagement include: 12 […]

1 CHAPTER 4 Workforce Focus ANSWERS TO INSTRUCTOR RESERVE MATERIALS Instructor Reserve materials are older Quality in Practice features and Cases from previous editions that may be used by the instructor to give the students additional experiences. These are available […]

when the company was formed. Approval of the revised policies will be done by the managing director and the Head of Support Services. A systematic process is also being set up to review all HR policies annually. management. With a […]

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 undergo […]

Name: Class: Date: chapter 5 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. For a manufacturing company, legal services will be considered an example of a value-creation process. a. True b. […]

1 CHAPTER 5 Process Focus Teaching Notes This chapter delves into the fundamental concepts of processes and process management: process design, control, and improvement. We also discuss quality aspects of supply chain management. Key objectives for this chapter should include: […]

8.5.1 Planning for continual improvement 8.5.2 Corrective action 8.5.3 Preventive action CHAPTER 5 Process Focus ANSWERS TO INSTRUCTOR RESERVE MATERIALS Instructor Reserve materials are older Quality in Practice features and Cases from previous editions that may be used by the […]

identified. The hazard could be biological, such as a microbe; chemical, such as a toxin; or physical, such as ground glass or metal fragments. Process Control in the Food Industry: The FDA’s HACCP Approach1 The 1993 outbreak of food borne […]

Process Focus 21 components of any control system are a standard or goal, a means of measurement of accomplishment, and a way to compare actual results with the standard, along with an appropriate method of feedback of results to form […]

Rabbitfoot Community Bank Processing Times Rabbitfoot Competitor 33.9 40.0 34.8 39.6 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 Mode 40.0000 Mode […]

10.70 10.75 10.75 10.80 10.80 10.80 U-Bolt Data 10.65 10.75 10.75 10.60 10.70 10.60 10.70 10.65 10.75 10.90 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.70 10.70 10.80 10.80 10.70 10.70 10.65 10.60 […]

Binomial Probability Distribution Enter data only in yellow-shaded cells. Number of successes, x3 Sample size, n (up to 50) 10 Probability of a success, p0.2 f(x) = P(X = x)0.2013 x f(x) F(x) 00.10737 0.10737 10.26844 0.37581 20.30199 0.67780 30.20133 […]

17 38.6 0.002916 Range 2.3000 18 38.6 0.002916 Minimum 37.3000 19 38.6 0.002916 Maximum 39.6000 20 38.6 0.002916 Sum 3865.4000 21 38.3 0.125316 Count 100.0000 22 38.6 0.002916 Largest(1) 39.6000 23 38.8 0.021316 Smallest(1) 37.3000 43 38.7 0.002116 44 38.7 […]

10.80 10.70 10.70 10.65 10.60 10.55 U-Bolt Data 10.65 10.75 10.75 10.60 10.70 10.60 10.70 10.65 10.75 10.90 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 […]

Problem 6-11 – Instructor Reserve Durarubb, Inc Temperature Hardness Temperature vs. Hardness 35 97 Temperature 1 40 94 Hardness -0.938581842 1 100 52 ANOVA 105 42 df SS MS F Significance F Regression 1 3367.289 3367.289 96.185 0.000 Residual 13 […]

Rabbitfoot Community Bank Processing Times Rabbitfoot Competitor 36.6 41.1 Hypothesized Mean Difference 0.0000 38.5 34.4 df 64.0000 38.3 37.0 t Stat -2.2092 39.5 41.4 P(T<=t) one-tail 0.0154 41.4 t Critical one-tail 1.6690 41.2 P(T<=t) two-tail 0.0307 37.8 t Critical two-tail […]

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

Sival Electronics One-Way ANOVA Supplier 1 Supplier 2 Supplier 2 5 35.6 7.12 0.697 Supplier 3 5 64.1 12.82 1.812 Within Groups 29.084 12 2.424 Total 113.317 14 Supplier 3 Finish 1 11.9 6.8 13.5 Finish 2 10.3 5.9 10.9 […]

Problem 6-8-Instructor Reserve SelCells, Inc. Exponential Probability Distribution Enter data only in yellow-shaded cells. Failure Rate = 1/MTTF 0.000128 T = x Cum. Failure Hours Probability F(x) 7000 0.591801 8000 0.640845 9000 0.683996 10000 0.721963 0.400 0.600 0.800 Probability Cum. […]

Problem 3-Instructor Reserve Evansrode Marine Engine Co. Sorted Data 36.26 35.91 36.12 36.10 35.44 Range 1.990 35.58 35.59 35.98 36.49 35.45 Minimum 35.090 35.77 35.64 35.87 36.15 35.46 Maximum 37.080 37.08 36.19 36.00 35.78 35.48 Sum 3604.250 36.22 36.55 35.70 […]

Frackly Oil 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 mean and standard […]

Statistical Methods in Quality Management 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 […]

Dockhousing, Inc. Normal Distribution Probability Template Enter data only in yellow-shaded cells Mean, m50 Standard deviation, s0.5 x z F(x) 48.75 -2.50 0.00621 48.80 -2.40 0.00820 48.85 -2.30 0.01072 48.90 -2.20 0.01390 48.95 -2.10 0.01786 49.00 -2.00 0.02275 49.05 -1.90 […]

Filmore Metal-work foundry Data Descriptive Statistics and Frequency Chart 38.1 38.5 38.3 37.3 38.4 39.2 38.9 38.5 39.0 38.6 DATA (x – x-bar)^2 38.1 38.8 38.6 38.6 38.6 38.6 38.9 38.8 39.0 38.6 138.1 0.306916 Calculation of mean & Sample […]

White Clay Pottery Temperature-deg C Temp-deg C 0.00826 0.00052 15.84992 0.00000 0.00713 0.00938 0.00713 0.00938 6 4.114285714 0.585714286 7 4.527142857 -0.427142857 8 4.94 0.06 9 5.352857143 0.347142857 10 5.765714286 -0.665714286 11 6.178571429 -0.178571429 12 6.591428571 0.008571429 13 7.004285714 -0.204285714 14 […]

Valles Verdes Partners Paid Overdue 32 118 PERCENT OF TOTAL 21% 79% Overdue Paid Paid Overdue Overdue Paid Paid Overdue Overdue Paid Overdue Overdue Paid Overdue Paid Overdue Overdue Overdue Overdue Overdue Overdue Overdue Paid Overdue Overdue Overdue Overdue Overdue […]

1 2 3 4 5 6 7 8 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 71.13 1.16 20 81.16 1.19 15 91.19 1.22 2 10 1.22 1.25 0 […]

El Grande 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, given the mean […]

Genjeteye, Inc. Table for chart construction Exponential Probability Distribution Enter data only in yellow-shaded cells. T = x Cum. Failure Hours Probability Part b 00.000000 Hours Probability F(x) 4000 0.039211 205000 0.871265 4500 0.044003 Part c 220000 0.889197 5000 0.048771 […]

4 High 1150 High 1000 High 800 5 Low 1000 Low 900 Low 765 6 High 1150 Low 900 Low 765 7 Low 1000 High 1000 Low 765 8 High 1150 High 1000 Low 765 Berton Card Company Roughness Readings […]

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 Treatment Signal […]

Problem 6-12 Ins Rsv RocketSci 22 Factorial Experiment Enter data ONLY in yellow-shaded cells. Factor 2 0.50 Interaction Factor 1 x Factor 2 -14.50 Factor 2 Aluminum powder 75 g. 95 g. Description Name Low level High level Factor 1 […]

P6-11 Statistics 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 Data Ascending Order […]

El Grande 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, given the mean […]

Paintfast Manufacturing 22 Factorial Experiment Enter data ONLY in yellow-shaded cells. CLow High 85 D High High 87 Factor 2 1.50 Interaction Factor 1 x Factor 2 -5.50 Description Name Low level High level Factor 1 Drying agent 10 mg. […]

b) What is the probability of finding 1 or fewer defects in a panel? capability of the process to perform within specification limits. 100 shafts taken from the process were measured (see the worksheet Prob 06-03). Determine the mean, median, […]

Voltmeter Calibration Data Actual (Y) Source (X) 1.09 1.05 2.12 2.15 3.08 3.12 4.09 4.08 5.11 5.11 6.08 6.07 7.2 7.23 8.3 8.34 9.59 9.66 10.41 10.49 Total 9 90.34321 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% […]

22 Factorial Experiment Enter data ONLY in yellow-shaded cells. Factor 2 -2.50 Description Name Low level High level Factor 1 Temperature 100 degrees 120 degrees Main Effects Factor 1 -0.50 Interaction Factor 1 x Factor 2 -7.00 80 82 84 […]

1 2 3 4 5 6 7 8 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 710.83 10.89 14 810.89 10.95 2 910.95 11.01 0 10 11.01 11.08 0 0 […]

Maggie’s French Fry Study Location Fry Number Container Number Order Size Length Visual Inspection Results Conforming/Nonconforming 1 1 1 L 7.6 0 1 2 1 L 6.4 0 Total Sample – Lengths Bin Range Bin Frequency 1 3 1 L […]

Maggie’s French Fry Study Location Fry Number Container Number Order Size Length Visual Inspection Results Conforming/Nonconforming 1 1 1 L 7.6 0 1 2 1 L 6.4 0 Total Sample – Lengths Bin Range Bin Frequency 1 3 1 L […]

213 Range 10 312 Sample variance 8.257 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 414 Sample standard deviation […]

Supplier Order Date Arrival Date BP Lead Time Supplier Order Date Arrival Date EM Lead Time Bryant Products 10/15/12 10/20/12 5 Elgin Metals 10/01/12 10/06/12 5 Bryant Products 10/20/12 10/27/12 7 Elgin Metals 10/03/12 10/08/12 5 Bryant Products 08/08/12 08/14/12 […]

Ohio Valley Construction 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 mean and […]

Problem 6-1-Instructor Reserve SelCells, Inc. COUNTIF FUNCTION Answers the question: Is the CELLPHONE DEFECTIVE? TRUE FALSE 6244 PERCENT OF TOTAL 2.40% 97.60% FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE […]

Genjeteye, Inc. Table for chart construction Exponential Probability Distribution Enter data only in yellow-shaded cells. T = x Cum. Failure Hours Probability Part b 0 0.000000 40000 0.329680 T = x Cum. Failure P(10000 ≤ x ≤ 15000) = P(x […]

Plastik Parts, Inc. Confidence Interval for Population Mean, Standard Deviation Unknown Alpha 0.05 Sample standard deviation Sample size 25 Sample average 9 2.9 Confidence Interval 95% t-value 2.0639 Error 1.1971 Lower 7.8029 Upper 10.1971 Plastik Parts, Inc. Confidence Interval for […]

Perfection Machining 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 mean and standard […]

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 Treatment Signal […]

Prob 6-12 Statistics Rivercereek Labs 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 Data Ascending Order […]

Problem 6-01-Instructor Reserve SelCells, Inc. FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE […]

Problem 6-07 – Instructor Reserve Cheez-D-Lites This spreadsheet is designed to calculate the X-value based on probability of values equal to, or less than a desired x value, of a normally distributed variable. It requires input of a known mean […]

Problem 5 – Instructor Reserve Tio Anciano Z and X-value Calculations Given Probabilites, Using the Inverse Normal Distribution – Template This spreadsheet is designed to calculate the z-value based on probability of values equal to, or less than, an equivalent […]

Statistical Methods in Quality Management 32 Value for price paid 3.92 1.19 Overall satisfaction 3.80 0.87 2. If you average the responses to the first seven questions by customer, how closely are those averages correlated to the satisfaction score? Include […]

Rainbow Punch 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 mean and […]

Prob 6-12 Statistics Rivercereek Labs 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 Data Ascending Order […]

Burrito Brothers Customer survey Results Customer Number Customer survey responses 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 Avg Std. dev. Avg Std. […]

Example 6.10 Good Good Good Defective Good Defective Good Good Good Defective Good Good Defective Good Defective Defective Good Good Good Good Defective Defective Good Good Good Good Good Defective Good Defective Good Good Defective Good Good Good Good Good […]

Sparkly Cleaning 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 mean and standard […]

Standard error 0.0179 Lower 0.1206 Upper 0.1794 Confidence Interval for a Proportion Alpha 0.1 Sample proportion 0.15 Confidence Interval 90% z-value 1.6449 Sample size 400

Softswell Contractor 1 Contractor 2 Within Groups 1876.2 27 69.4889 Total 2286.8 29 Contractor 3 Anova: Single Factor 86 90 89 73 85 82 SUMMARY 69 77 74 Groups Count Sum Average Variance 67 78 72 65 98 78 ANOVA […]

White Clay Pottery Temperature-deg C Brittleness 700 2.5 SUMMARY OUTPUT 750 1.9 800 3.4 Regression Statistics 850 2.7 Multiple R 0.97509 900 3.8 R Square 0.95080 1400 8.1 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% […]

Berton Card Company Roughness Readings Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample Experiment PPS Experiment PPS Experiment PPS Experiment PPS Experiment 5 Low 1000 Low 900 Low 765 6 High 1150 Low 900 Low 765 7 […]

P6-11 Statistics 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 Data Ascending Order […]

Turkalike Rug Company a. Using the Poisson Probability Distribution Template: b. Find F(2) in the table 0.67668 Enter data only in yellow-shaded cells. Desired number 6 4 0.09022 0.94735 5 0.03609 0.98344 6 0.01203 0.99547 7 0.00344 0.99890 8 0.00086 […]

Example 6.20 Anova: Single Factor Process A Process B Process C SUMMARY Within Groups 3.936 12 0.328 Total 5.644 14 8.4 8.8 8.0 Groups Count Sum Average Variance 8.3 8.0 8.0 ANOVA Source of Variation SS df MS F P-value […]

Rainbow Punch 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 mean and […]

Ohio Valley Construction 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 mean and […]

2489 7 L 9 broken 1 2490 7 L 14.8 wilty 1 2491 7 L 10.7 wilty 1 2492 7 L 11.8 broken 1 2493 7 L 7.2 0 2494 7 L 12 wilty 1 2495 7 L 5.6 transparent […]

The Battery Experiment Case 23 Factorial Experiment Enter data only in yellow-shaded cells. Interaction Charts Base Case Factor 1 Factor 2 Average Description Name Level 1 Level 2 L L 82.5 Factor 1 Battery Low cost High Cost H L […]

Dockhousing, Inc. Normal Distribution Probability Template Enter data only in yellow-shaded cells Mean, m50 Standard deviation, s0.5 x z F(x) 48.90 -2.20 0.01390 48.95 -2.10 0.01786 49.00 -2.00 0.02275 49.05 -1.90 0.02872 49.10 -1.80 0.03593 49.15 -1.70 0.04457 49.20 -1.60 […]

Burrito Brothers Customer survey Results Customer Number Customer survey responses 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 Avg Std. dev. Avg Std. […]

1 2 3 4 5 6 7 8 9 10 11 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 81.16 1.19 15 91.19 1.22 2 10 1.22 1.25 […]

Problem 6-2 – Instructor Reserve Panlmastr Poisson Probability Distribution Template Enter data only in yellow-shaded cells. Desired number 4 3 0.03834 0.99092 4 0.00767 0.99859 5 0.00123 0.99982 8 0.00000 1.00000 9 0.00000 1.00000 10 0.00000 1.00000 x f(x) F(x) […]

Chapter 6 – Instructor Reserve Problem Solutions See the Excel solution files in the Instructor Reserve Materials folder for Chapter 6. 1. Receiving inspection technicians at SelCells, Inc., a cellphone retailer took a sample of 250 incoming phones, as shown […]

2571 7 L 7.3 burnt skin 1 2572 7 L 8.1 wilty 1 2573 7 L 7.2 0 2574 7 L 5.9 brown 1 2575 7 L 6.5 0 2576 7 L 1.9 transparent 1 2577 8 M 3.6 piece […]

The Battery Experiment Case 23 Factorial Experiment Enter data only in yellow-shaded cells. Interaction Charts Base Case Factor 1 Factor 2 Average Description Name Level 1 Level 2 L L 82.5 Factor 1 Battery Low cost High Cost H L […]

Binomial Probability Distribution Enter data only in yellow-shaded cells. Number of successes, x3 Sample size, n (up to 50) 10 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 12 00.10737 0.10737 10.26844 0.37581 20.30199 […]

Statistical Methods in Quality Management 21 The sample proportion is p = 60/400 = 0.15 17. Tessler Electric utility requires service operators to answer telephone calls from customers in an average time of 0.1 minute or less. A sample of […]

Problem 6 – Instructor Reserve Piedra Salt Co. Z and X-value Calculations Given Probabilites, Using the Inverse Normal Distribution – Template This spreadsheet is designed to calculate the z-value based on probability of values equal to, or less than, an […]

Name: Class: Date: chapter 6 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. The Histogram tool provides the basic statistical measures of location, dispersion, and shape. a. True b. False 2. […]

Name: Class: Date: chapter 7 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. A typical scheme of the House of Quality uses the symbol Δ to denote a strong relationship between […]

Problem 7-12 Instructor Reserve Flatplane, Inc. Computers Exponential Probability Distribution Template Enter data only in yellow-shaded cells. Failure rate per hour (λ) = 0.000072 T = x Cum. Failure Hours Probability F(x) 1250 0.086069 1500 0.102372 1750 0.118385 2000 0.134112 […]

Georgio’s Giant Gyros Competitors’ Product Information Company Price Size (oz.) Calories * Sodium (mg) * Fat (%) * Georgio’s 3.00 5.5 440 875 13 Kingyro 4.25 7.5 640 930 23 * Lower is better Per ounce comparision Company Price/Oz. Calories/Oz.* […]

Georgio’s Giant Gyros Competitors’ Product Information Company Price Size (oz.) Calories * Sodium (mg) * Fat (%) * Georgio’s 3.00 5.5 440 875 13 Kingyro 4.25 7.5 640 930 23 Per ounce comparision Company Price/Oz. Calories/Oz.* Sodium/Oz.* Kingyro $0.567 85.3 […]

BearingPort Airplane Co. Calculation of expected loss values Value Loss ($) Process P Probabilit y Weighted Loss ($) Process Q Probability Weighted Loss ($) 0.20 $96.00 0 $0.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 […]

 L(0.05) = 1500 (0.05)2 = $3.75 $6.40 = k (0.08)2 k = 1000  L(x) = k (x – T)2 = 1000 (x – T)2 Chapter 7 – Instructor Reserve Problem Solutions 1. Management at Cirquelectra Corp. is concerned […]

Cellurific 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 distributed variable. […]

Ampcomp Taguchi Loss Function Enter data only in yellow cells. Calculation of k for the Loss Function Deviation from target 0.4 Loss Calculation for a Specific x Dimensional value, x 0 k$0.00 Loss $0.00 Target specification, T 0.00 Expected Loss […]

Problem 7-13 Instructor Reserve Sabiophono, Ltd. Exponential Probability Distribution Template Enter data only in yellow-shaded cells. Failure rate per hour (λ) = 0.00005 T = x Cum. Failure Hours Probability F(x) 750 0.036806 1000 0.048771 1250 0.060587 1500 0.072257 1750 […]

Problem 7-05 Instructor Reserve Oomworks Taguchi Loss Function Enter data only in yellow cells. Calculation of k for the Loss Function Deviation from target 0.80 Loss Calculation for a Specific x Target specification, T 0.00 Dimensional value, x 0 k$0.00 […]

Adams Metal Fabricating Taguchi Loss Function Enter data only in yellow cells. Calculation of k for the Loss Function Deviation from target 1.75 Loss Calculation for a Specific x Target specification, T 0.00 Dimensional value, x 0 k$0.00 Loss $0.00 […]

Cool Food, Inc. Taguchi Loss Function Enter data only in yellow cells. Calculation of k for the Loss Function Deviation from target 0.04 Loss Calculation for a Specific x Target specification, T 0.00 Dimensional value, x 0 k$0.00 Loss $0.00 […]

Instructor Reserve Problem 7-6 2.483487 2.496657 2.493230 2.496658 2.488419 2.482097 2.493662 2.491698 2.495009 2.486834 2.493900 2.491144 2.493690 2.498943 2.492194 2.489616 2.478238 2.499055 2.490107 2.491714 2.491315 2.496540 2.487317 2.487579 2.481801 2.487231 2.476721 2.486850 2.487882 2.494160 2.495593 2.496417 2.492054 2.491975 2.494200 2.488777 […]

ACM, Inc. Taguchi Loss Function Average 25.0988 Enter data only in yellow cells. 25.7660 24.4550 25.5250 26.0340 24.6960 Standard Deviation 0.507477779 23.5730 25.0160 25.5160 25.1240 24.7830 Calculation of k for the Loss Function 25.0420 25.8750 25.8910 25.3810 24.6040 Deviation from […]

Example 7.8 Mean 50000 Standard deviation 51500 0.84134 0.15866 52000 0.90879 0.09121 52500 0.95221 0.04779 53000 0.97725 0.02275 Miles 1500 Tire Life, x P(failure) P(Survival) 45000 0.00043 0.99957 45500 0.00135 0.99865 46000 0.00383 0.99617 48500 0.15866 0.84134 49000 0.25249 0.74751 […]

Variance, Var[X] 0.0002 Variance, Var[X] 0.00009 Expected Loss 25.00 Expected Loss 11.25 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 […]

Problem 7-10 Instructor Reserve Lapstrake Battery Co. – 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 […]

Ch 7 – Quality in Practice Applying QFD in in Managed Healthcare Direction of Rate of Company Rate of Absolute % Font Use of Glossary Q&A Table of Language Improvement Importance Now Plan Improvement Weight Improvement size Update Photos colors […]

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 124440 124439 1 1 1 0.00004092 0.00004092 Regression on number of units failed […]

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 124440 124439 1 1 1 0.00004092 0.00004092 Regression on number of units failed […]

Spacescope, Inc. Reliability Exponential Probability Distribution Enter data only in yellow-shaded cells. Failure rate per hour (λ) = 0.0000165 35000 0.438700 0.56130 40000 0.483149 0.51685 45000 0.524077 0.47592 50000 0.561765 0.43823 55000 0.596468 0.40353 60000 0.628423 0.37158 Hours to Failure […]

Call-Nowait handling time Taguchi Loss Function Enter data only in yellow cells. 6.5 6.0 6.5 5.0 5.5 Average 6.016 7.3 6.6 6.2 4.3 6.7 Standard deviation 0.8957 Calculation of k for the Loss Function 5.5 4.8 7.2 6.9 6.4 Deviation […]

MicroKeeb Co. Taguchi Loss Function 2.001 2.000 2.001 1.998 1.999 Average 2.00008 Enter data only in yellow cells. 2.000 2.000 2.002 1.999 2.000 Standard Deviation 0.00104 k1000000.0000 Loss Calculation for a Specific x Target specification, T 0.00 Dimensional value, x […]

MicroKeeb Co. Taguchi Loss Function 2.001 2.000 2.001 1.998 1.999 Average 2.00008 Enter data only in yellow cells. 2.000 2.000 2.002 1.999 2.000 Standard Deviation 0.00104 1.998 1.999 2.001 2.000 2.000 Calculation of k for the Loss Function Loss Calculation […]

Cool Food, Inc. Taguchi Loss Function Enter data only in yellow cells. Calculation of k for the Loss Function Deviation from target 0.04 Loss Calculation for a Specific x Target specification, T 0.06 Dimensional value, x 0.075 k$21,875.00 Loss $4.92 […]

Ruido, Unlimited Taguchi Loss Function Enter data only in yellow cells. Calculation of k for the Loss Function Deviation from target 0.5 Loss Calculation for a Specific x Dimensional value, x 0 k$0.00 Loss $0.00 Target specification, T 0.00 Expected […]

Livelong, Inc. Computer Monitors Exponential Probability Distribution Template Enter data only in yellow-shaded cells. Failure rate per hour (λ) = 0.00095 T = x Cum. Failure Hours Probability F(x) 1500 0.759492 1750 0.810336 2000 0.850431 2250 0.882051 2500 0.906986 2750 […]

Elproparts Manufacturers Taguchi Loss Function Enter data only in yellow cells. Calculation of k for the Loss Function Deviation from target 3.50 Loss Calculation for a Specific x Target specification, T 0.00 Dimensional value, x 0 k$0.00 Loss $0.00 Expected […]

Problem 7-7 Instructor Reserve HeetJet Enterprises Descriptive Statistics Using Excel Functions Descriptive Statistics Using Data Analysis Excel Add-In Data Sorted data 1 15.008 14.985 Mean 15.0005 Column1 2 15.000 14.985 Median 15 By inspection of sorted data 8 14.993 14.993 […]

Design for Quality and Product Excellence 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 […]

Broadtred 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 distributed variable. […]

Rembrandt Transformers Taguchi Loss Function Enter data only in yellow cells. Calculation of k for the Loss Function Deviation from target 10.0000 Loss Calculation for a Specific x Target specification, T 0.00 Dimensional value, x 0 k$0.00 Loss $0.00 Expected […]

Spacescope, Inc. Reliability Exponential Probability Distribution Enter data only in yellow-shaded cells. 30000 0.390429 0.60957 35000 0.438700 0.56130 40000 0.483149 0.51685 45000 0.524077 0.47592 50000 0.561765 0.43823 55000 0.596468 0.40353 60000 0.628423 0.37158 65000 0.657848 0.34215 70000 0.684942 0.31506 0 […]

Problem 7-11 Instructor Reserve Airponents, Inc. 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 […]

Livelong, Inc. Computer Monitors Exponential Probability Distribution Template Enter data only in yellow-shaded cells. Failure rate per hour (λ) = 0.00095 T = x Cum. Failure Hours Probability F(x) 1500 0.759492 1750 0.810336 2000 0.850431 2250 0.882051 2500 0.906986 0.200 […]

Problem 7-06 Instructor Reserve Microfarmosutica, Inc. Descriptive Statistics Original Data Sorted Data 2.483 2.477 Mean 2.4906 Descriptive Statistics 2.482 2.478 Median 15 By inspection of sorted data 2.494 2.482 Mode 15 By inspection of sorted data Mean 2.490559091 2.490 2.482 […]

Example 7.8 Mean 50000 Standard deviation 1500 Tire Life, x P(failure) P(Survival) 45000 0.00043 0.99957 45500 0.00135 0.99865 46000 0.00383 0.99617 46500 0.00982 0.99018 47000 0.02275 0.97725 47500 0.04779 0.95221 48000 0.09121 0.90879 0.50000 0.60000 0.70000 0.80000 0.90000 1.00000 Reliability […]

Adams Metal Fabricating Taguchi Loss Function Enter data only in yellow cells. Calculation of k for the Loss Function Deviation from target 1.75 b) Loss Calculation for a Specific x Dimensional value, x 17 k$14.69 Loss $58.76 Target specification, T […]

Variance, Var[X] 0.0002 Variance, Var[X] 0.00009 Expected Loss 25.00 Expected Loss 11.25 Example 7.3 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 […]

Example 7.9 Exponential Reliability Failure rat e 0.0003 TR(T) 0 1.000 1000 0.741 0.800 1.000 1.200 ReliabilityFunction 2000 0.549 3000 0.407 4000 0.301 5000 0.223 6000 0.165 7000 0.122 8000 0.091 9000 0.067 10000 0.050 0.000 0.200 0.400 0.600 0 […]

Example 7.9 Exponential Reliability Failure rate 0.0003 T R(T) 0 1.000 1000 0.741 2000 0.549 3000 0.407 4000 0.301 0.400 0.600 0.800 1.000 1.200 Reliability Function 5000 0.223 6000 0.165 7000 0.122 8000 0.091 9000 0.067 10000 0.050 0.000 0.200 […]

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 […]

Broadtred 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 distributed variable. […]

Autosys, Inc. Reliability System Reliability Enter data only in yellow cells Part a) Part b) Probability Component Reliability Component Failure Rate Component Reliability Component Failure Rate of Survival Component 1 Robot 0.006 Component 1 Grinder 1 0.001 0.1130796 Component 2 […]

Design for Quality and Product Excellence 34 The components that can be purchased from three different suppliers. The reliabilities of the components are as follows: Component Supplier 1 Supplier 2 Supplier 3 A 0.99 0.99 0.98 B 0.95 0.96 0.98 […]

Cellurific Battery Life-Reliability X-value Calculations Given Probabilities Using the Inverse Normal Distribution This spreadsheet is designed to calculate the X-value based on probability of values equal to, or less than a desired x value, of a normally distributed variable. It […]

Design for Quality and Product Excellence 21 9. A team was formed to study the auto part at Adams Metal Fabricating described in Problem 8. While continuing to work to find the root cause of scrap, the team found a […]

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 […]

Name: Class: Date: chapter 8 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. Control limits for the s-chart are given by: LCLs = B3s and UCLs = B4s, where B3 and […]

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 […]

Using a u-Chart in a Receiving Process 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 […]

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. Center 15 15 15 15 15 15 15 15 15 15 15 […]

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 cell E6 […]

El Grande Toro 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 the sample […]

Chapter 8 – Instructor Reserve Problems 1. Reboard Electronics, Inc. is a reprocessor of electronic boards used in computers. The quality manager is trying to determine the non-conformances per unit (NPU) and the throughput yield. The quality manager has requested […]

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 1Average range 0.029 Number of trials 2Lower specification limit […]

Audubon Book Co. 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 […]

Problem 8-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 to more […]

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 Standard Sample Nonconformances Size per […]

Problem 8-03 – Instructor Reserve TenGage, 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.45 […]

Problem 8-08-Instructor Reserve Metropole Hospital Waiting Room 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 […]

Call Center Sample size limits within 25% of the average sample size Upper 656.458 Max sample size 620 Fraction Nonconforming (p) Chart Lower 393.875 Min sample size 382 This spreadsheet is designed for up to 50 samples. Enter data ONLY […]

River Bottom Fire Department min 3.81 Bin Frequency Sample Sample mean max 5.13 3.50 0 13.81 3.93 3.89 3.91 4.08 4.01 3.94 3.75 0 24.38 4.82 3.98 4.21 4.41 4.36 4.36 Bins 4.00 27 34.19 4.30 4.17 4.23 4.12 4.15 […]

Kirkland 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 (p-bar) Sample […]

Problem 8.5.xlsx Costcutin Company Total Sales $1,537,280 $933,600 $1,397,120 % of Quality Costs by Product Quality Cost – A Quality Cost – B Quality Cost – C Product A. Product B Appraisal $35,511.17 $65,538.72 $60,355.58 11% 39% 36% Prevention $12,913.15 […]

Example 8.18 Data These data may be copied and pasted into the p-chart Excel template 2100 5100 2100 3100 4100 1100 0100 1100 Sample Value Size 3100 1100 0100 0100 0100 2100 1100 3100 4100 1100 1100 2100 5100 3100 […]

Dennis Manufacturing Company 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 […]

Morelia Mortgage Co. – Revised chart 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-23 Palma State Bank min 11.28 Bin Frequency Sample max 14.01 11.25 0 Day 1 2 3 4 5 Sample mean 11.50 2 111.86 12.09 12.05 12.25 12.18 12.09 Bins 11.75 5 211.57 13.21 12.24 11.95 12.02 12.20 11.25 […]

Birdseye 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 size in […]

Example 8.16 Data These data may be copied and pasted into the Xbar&S Excel template 1-2 0 1 -3 -6 -3 0 2 0 -3 -1 -1 -3 -1 -1 -2 0 0 1 1 -1 0 1 2 -3 […]

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 sample size […]

Problem 8-14 A-Instructor Reserve Ellswater Hospital 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 […]

1 2 3 4 5 6 10 11 12 13 14 15 16 17 18 19 40.03 0.02 0.03 0.07 0.07 0.07 0.02 0.05 0.03 0.07 0.06 0.04 0.00 0.04 0.02 Lower limit -0.120 5-0.04 -0.03 -0.04 -0.05 -0.03 0.04 […]

Quality Measurements Bin Sample 1 2 3 4 5 Mean 0.55 Bin Frequency 18 0.828 0.829 0.865 0.778 0.872 0.834 19 0.805 0.719 0.612 0.938 0.807 0.776 20 0.802 0.756 0.786 0.815 0.801 0.792 21 0.876 0.803 0.701 0.789 0.672 […]

Problem 8-09B Babbage Chips Note: Formulas were altered to allow calculation of control limits based on the first 30 samples and plotting of 50 samples. This spreadsheet is designed for up to 50 samples, each of a constant sample size […]

PCDrives Sample x-bar R Percent below 45: 0.6197% 1 77.4 18.3 2 60.2 20.1 Percent above 95: 0.2516% 3 63.5 22.6 4 64.0 27.5 Percent outside specs: 0.8713% 5 58.4 15.3 6 74.4 17.9 7 70.8 26.8 8 74.6 30.6 […]

9101 892 270 954 583 Example 8.23 Data These data may be copied and pasted into the u-Chart Excel template Number of Sample Nonconformances Size 892 15 69 686 13 85 5123 587 480 270 11 73 13 89 6129 […]

Federal Scanline 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 […]

Copyright 2000: James R. Evans. For use exclusively with Managing for Quality and Performance Excellence , 11th Edition or higher. This software may not be used for any commercial purpose, modified, or or otherwise distributed without written permission from the […]

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

9. The Excel workbook C08 Problem Data provides data on quality losses at Nosoco Paper Mill. Find the percentage of cost for each category, and the cumulative percentages when the categories are sorted by decreasing costs. Construct an appropriate Excel […]

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) Approximate Control Limits Using […]

Full Life Insurance Co. 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) […]

Full Life Insurance Company 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 […]

Accurate 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 3Upper specification limit 1.8 Average range 0.014 Data Operator […]

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 operator and […]

Problem 8.11.xlsx Beechware Software Corp. Sorted by cost: Category Annual Loss Percent Cumulative % Customer returns $275,400 38.92% 38.92% Rework 153,000 21.62% 60.54% $200,000 $250,000 $300,000 Quality Costs Inspection costs (extra)–incoming 104,040 14.70% 75.24% System downtime 67,320 9.51% 84.76% Inspection […]

3 2 1 4 Example 8.22 Data These data may be copied and pasted into the c-Chart.xlsx template 2 3 0 1 2 0 1 0 2 4 1 2 0 0 0 3 3 5 3 1 2

Altodiez Package Co. 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) Sample […]

Problem 8-13-Instructor Reserve Precision Piston Company 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). […]

GenLab Ltd. Bins -0.00251 Thermometer A Readings Thermometer B Readings -0.003 0.00246 -0.002 0.00071 -0.00040 0.00246 0.00130 0.00018 0.00126 -0.00221 -0.00011 -0.00071 -0.00032 -0.001 0.00025 0.00245 0.00141 0.00142 0.00015 0.00180 -0.00135 0.00210 0.00027 -0.00076 0 -0.001 3-0.001 5 0 6 […]

Problem 8-16-Instructor Reserve Rob’s Pizza Palaces This spreadsheet is designed for up to 50 samples. Enter data ONLY in yellow-shaded cells. 9 2 0 3.36 8.86 10 4 0 3.36 8.86 11 1 0 3.36 8.86 12 2 0 3.36 […]

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 cell E6 and the sample size […]

Saramit Theatrical Productions Frequency Distribution and Histogram This spreadsheet is designed to handle up to 150 observations. Enter data ONLY in yellow-shaded cells. Data Minimum 21.973 Nominal specification 22 Data Maximum 22.027 Upper specification limit 22.03 Lower specification limit 21.97 […]

9 10 Upper specification limit 4.8 Lower specification limit 4.6 Enter number of cells below (10 or less) 29 30 31 32 33 74.70 4.71 8 84.71 4.72 7 Cp 1.618 94.72 4.73 3 Cpl 1.401 10 4.73 4.74 0 […]

Prob. 8-18A Statistics Mach4 Tool Co – Machining Process – Part A Sample Number 1 2 3 4 5 0.556 0.562 0.564 0.564 0.572 0.572 0.572 0.572 0.573 0.575 Page 1 0.575 0.574 0.575 0.575 0.577 0.577 0.577 0.577 0.577 […]

c. There is a lot of variability of the sample mean values on the run chart; however. no patterns exist that would indicate a lack of control. As long as the process remains centered near the middle of the specifications, […]

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 the sample […]

IR Problem 8.6.xlsx Problem 8-06 – Instructor Reserve Worldwide Measursys Repairs, Inc. Quality Costs and Percentage Percent Cumulative % Cost Customer returns 40.00% 40.00% $120,000 Workstation downtime 16.67% 56.67% 50,000 Rework costs 16.67% 73.33% 50,000 Inspection – out 11.67% 85.00% […]

Problem 8.7.xlsx Miami Valley Aircraft Service Co. 1 2 3 4 Total labor Cost $21,000 $19,500 $24,500 $20,500 % Total Labor/Base (Qtr. 1) 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% 22.07% […]

IR Problem 8.5.xlsx Problem 8-05 – Instructor Reserve Oakton Paper Company Quality Costs and Percentage Percent Cumulative % Cost Rejected paper 56.82% 56.82% $375,000 Customer complaints 15.91% 72.73% 105,000 Odd lot 10.61% 83.33% 70,000 Wasted materials 5.91% 89.24% 39,000 Downtime […]

PharmaExpress 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 20 […]

Problem 8-03 Instructor Reserve TenGage, Inc Data Operator 1 Operator 2 Operator 3 Trial Trial Trial Part # 1 2 3 1 2 3 1 2 3 1 1.272 1.312 1.376 1.240 1.264 1.440 1.280 1.320 1.296 2 1.328 1.328 […]

27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 772.80 73.35 18 873.35 73.90 12 Cp 1.051 973.90 74.45 8 Cpl 1.070 10 74.45 75.00 5 Cpu 1.033 Cpk 1.033 Standard deviation 1.268 0 […]

Problem 8.10.xlsx Stateside Metrology Repairs, Inc. Cost Percent Cumulative % Customer returns $120,000 36.36% 36.36% Workstation downtime $60,000 18.18% 54.55% $120,000 $140,000 Quality Costs Rework costs $55,000 16.67% 71.21% Inspection costs — outgoing $40,000 12.12% 83.33% Training/improvement $35,000 10.61% 93.94% […]

Problem 8.6.xlsx Impressive Printing Company Quality Cost Cost Element Amount Category Total Quality Costs by Category Percent of Total Quality Cost Customer complaint remakes $24,300 Ext. Fail. External failure $24,300.00 2.08% Costs by Category External Failure Customer complaint remakes $24,300 […]

16 0.816 0.817 0.768 0.716 0.649 0.753 17 0.826 0.777 0.721 0.770 0.809 0.781 18 0.828 0.829 0.865 0.778 0.872 0.834 19 0.805 0.719 0.612 0.938 0.807 0.776 26 0.748 0.686 0.856 0.811 0.838 0.788 27 0.826 0.803 0.764 0.823 […]

1.77861 2.00100 1.24992 1.75740 1.98708 1.24992 1.73619 1.99404 1.24558 1.74225 1.98708 1.24992 1.74528 1.98360 1.24775 1.73922 2.00100 1.24775 Mean 1.7446 1.9999 1.2485 StDev 0.0163 0.0078 0.0052 River City Parts Co. Part 1 Part 2 Part 3 1.74831 2.01144 1.25426 1.75740 […]

3.55 3.65 3.45 3.3 3.75 3.5 3.4 Example 8.17 Data These data may be copied and pasted into the X&MR Excel template 3.75 3.8 3.7 3.2 3.5 3.1 4 4 3.5 3 3.8 3.4 3.6 3.1 3.05 3.5 3.25 3.6

Process Capability Calculations Six sigma 6.815 Upper specification 12.4 Cp 0.939 Capability indexes are Cpu = 0.948, Cpl = 0.930, Cpk = 0.930 and Cp = 0.939. All the indexes are unsatisfactory, since they fall below 1. The Cpu = […]

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 size in […]

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 the sample […]

Snowblower Flowchart Decide that driveway must be cleared of snow Fill fuel tank No Open garage Take out snowblower Needs fuel? Yes Get fuel Put in garage Blow snow from driveway Needs cleaning ? Get broom & cleaning materials Clean […]

Rapid Check Kiters Calculation of control limits with initial 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 of […]

X and Moving Range Chart Copyright © 2013 Cengage Learning 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 cell […]

Problem 8-17-Instructor Reserve Small u-Chart Sample 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 […]

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Cp 1.370 95.06 5.08 7 Cpl 1.170 10 […]

Birdseye Magnetronics min 0.279 Bin Frequency max 0.396 0.28 1 Sample Sample means 0.30 6 18 0.324 0.369 0.342 0.345 19 0.369 0.360 0.378 0.369 20 0.315 0.351 0.333 0.333 21 0.360 0.333 0.333 0.342 22 0.315 0.342 0.315 0.324 […]

Problem 8-11-Instructor Reserve Ricardo’s Widgets 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 cell […]

5 2 3 4 Example 8.21 Data These data may be copied and pasted into the np-Chart Excel template 3 1 0 0 2 2 1 3 4 1 1 2 1 0 1 5 3 6 1 4 0

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). Number of Sample Nonconformances 7 3 0 1.8 5.82492 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 E6 and […]

NewGauge, 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 Number of parts […]

6 7 8 Upper specification limit 10.90 Lower specification limit 10.55 Enter number of cells below (10 or less) Number of Cells 10 30 31 Cpu 0.7021 Cpk 0.6413 15 23 24 25 Process Capability Index Calculations 4 10.60 10.65 […]

Example 8.11 Data These data may be copied and pasted into the Process Capability Excel template 10.650 10.800 10.500 10.800 10.700 10.800 10.750 10.650 10.850 10.650 10.800 10.650 10.750 10.850 10.800 10.800 10.700 10.700 10.850 10.700 10.800 10.550 10.700 10.850 […]

Top Billers 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 […]

processing (correct temperature) • Evaluate the control of foreign objects embedded or hidden within candy such as wooden splinters, glass or otherwise dangerous articles (scan percentage of foreign objects) • Molding starch is often contaminated. Determine how long it has […]

24 90 4 25 92 7 26 80 4 27 81 5 28 105 8 29 80 8 Using a u-Chart in a receiving Process Table 8.6 Packing Slip Errors Sample Packing Slips Errors 187 15 279 13 392 23 […]

13-1 Juanita 25 25.502 25.496 25.507 25.491 25.504 25.500 0.016 13-2 Tex 26 25.504 25.498 25.506 25.503 25.503 25.503 0.008 14-1 Juanita 27 25.498 25.497 25.511 25.494 25.487 25.497 0.024 14-2 Tex 28 25.500 25.506 25.494 25.497 25.506 25.501 0.012 […]

Problem 8.9.xlsx Nosoco Paper Company Sorted by cost: Category Cost Percent Cumulative % Rejected paper $375,000 57.25% 57.25% Customer complaints $103,000 15.73% 72.98% $350,000 $400,000 Quality Cost Categories Odd lot $66,000 10.08% 83.05% Wasted materials $31,000 4.73% 87.79% Downtime $30,000 […]

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 […]

Problem 8.8.xlsx Reship Solutions Inc. Sorted by cost: Cost element Cost Qual. Cost Category Correcting erroneous orders before shipping $36,550 Other waste $36,125 Correction of typographical errors–pick tickets $11,475 Appraisal Checking outbound boxes for errors $607,750 Incoming product inspection $51,000 […]

Nickel Experiment Case Nickle Experiment Case Data Set 1 Data Set 1 Nickles Weights – Total Observatio n Mint Year 1 P 2001 Sorted Data 2 P 1999 Weight (grams) Mint Year Weight (grams) Bin Values Descriptive Statistics 3 D […]

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) Sample Fraction Standard Average […]

We can see that the process appears to be “hugging the centerline” in the x – chart. The cause for this condition may be judged from the structure of the data. The chart below shows a run chart for -0.08 […]

Morelia Mortgage Co. – with additional data NOTE THE MODIFICATIONS TO CELLS C12 AND C13 AS EXPLAINED IN THE TEXT SIDEBAR This spreadsheet is designed for up to 50 samples, each of a constant sample size from 2 to 10. […]

CHAPTER 8 Measuring and Controlling Quality Teaching Notes This chapter presents the basic concepts of quality measurement and statistical process control. These include key types of measures, measurement system evaluation process capability, control charting techniques, design and analysis of charts, […]

Hermitage DNA Labs, LLC 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 […]

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 […]

Name: Class: Date: chapter 8 Copyright Cengage Learning. Powered by Cognero. Page 14 5 23 21 25 6 39 22 21 7 18 23 23 8 24 24 20 9 20 25 24 10 22 26 28 11 19 27 […]

Montvalley Short-Haul Lines, Inc. Billing Study Part II No. of Error Category Total Day Bills 1 2 3 4 5 6 7 8 Errors Average Number of Defects Per Unit (u) Chart 156 22311315 18 This spreadsheet is designed for […]

Name: Class: Date: chapter 9 Copyright Cengage Learning. Powered by Cognero. Page 1 Indicate whether the statement is true or false. 1. Data sheets are special types of data collection forms in which the results may be interpreted on the […]

Process Improvement and Six Sigma 36 SUGGESTIONS FOR PROJECTS, ETC. 1. Three popular websites for Six Sigma are http://www.ge.com/sixsigma, http://www.isixsigma.com, and http://asq.org/sixsigma. Explore these sites and consider the following questions. a. How does GE use Six Sigma to enhance customer […]

Santucci’s Restaurant Customer Wait Time (min.) Satisfaction (1-5; 5 being best) 110 4 2 8 4 3 6 5 415 3 525 2 6 6 5 712 4 8 8 3 4 5 6 Scatter Chart 910 3 10 11 […]

Customer Concerns Freadilunch Case Checksheet Data for Customer Concerns 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 wait 0 5 7 6 3 2 1 24 Inefficient […]

Problem 9.20.xlsx Billing errors 995 9.95% 85.25% Delivery errors 795 7.95% 93.20% Long delays 680 6.80% 100.00% 0 Electronic charge errors Shipping errors Billing errors Delivery errors Long delays Lauren Elizabeth Apparel Company Errors Frequency Billing errors 995 Shipping errors […]

Process Improvement and Six Sigma 21 3. During one month, Invoco processed 25,000 invoices for Alpha Corp, 23,000 for Beta Corp, and 8,000 for Gamma Corp. Of these, 205 of the Alpha, 175 of the Beta, and 103 of the […]

14 16 15 10 16 9 13 12 ElecktronTech Student Process Times Time (minutes) Min 9Bin Frequency 16 11 Max 21 9 1 12 18 10 2 13 13 Bins 11 5 12 11 912 6 13 17 10 13 […]

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 […]

Freadilunch Case Vacant Tables Day 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. 2 9 3 2 2 1 1 0 3 5 3 4 4 7 Wk. 3 […]

Chapter 9 Janson Medical Clinic Case 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 […]

Plastic Gear for Printwright, Inc. Min 3.5150 Bin Frequency 3.6150 3.5530 3.5530 3.5530 3.6290 Max 3.6920 3.50 0 3.5815 3.5530 3.6290 3.5530 3.5530 Average 3.5625 3.6850 3.5625 3.5910 3.6005 3.5625 3.6720 3.5625 3.5910 3.6005 3.5720 3.5720 3.5625 3.5910 3.6405 3.6490 […]

Problem 9.18.xlsx Deuce Printing Company Error/Delay Cause Frequency Customer change delays 30 Lack of press time 245 Design department delays 80 Paper not in stock 70 Sorted Data Error/Delay Cause Frequency Design department delays 80 11.35% 75.18% Paper not in […]

IR Problem 9.7.xlsx Problem 9-08 Instructor Reserve DOT.COM Apparel Company QUALITY ERRORS AND PERCENTAGES Percent Cumulative % Frequency Electronic charge errors 42.80% 42.80% 6420 Shipping errors 23.40% 66.20% 3510 Billing errors 11.97% 78.17% 1795 Delivery errors 11.30% 89.47% 1695 Long […]

Problem 9-4 Instructor Reserve Circuitus Board Co. Process Times Time (minutes) Observation (hourly) Day 1 Day 2 Day 3 Day 4 Day 5 11.0 1.3 1.2 1 1.4 21.2 1.1 1.6 1.2 1.6 31.3 1.5 1.3 1.1 1.3 41.5 1.8 […]

4.9 336.9 5.0 232.6 5.1 159.1 5.2 107.8 5.3 72.3 5.4 48.1 5.5 31.7 5.6 20.7 5.7 13.3 5.8 8.5 5.9 5.4 6.0 3.4 Sigma Chart Sigma Level dpmo 3.0 66807.2 3.1 54799.3 3.2 44565.5 3.3 35930.3 4.1 4661.2 4.2 […]

Snowblower Flowchart Decide that driveway must be cleared of snow Fill fuel tank No Open garage Take out snowblower Needs fuel? Yes Get fuel Needs oil? Get oil Fill oil Yes Put in garage Blow snow from driveway Needs cleaning? […]

NORM.S.INV calculation in the Excel® spreadsheet, we get: NORM.S.INV (0.99) + 1.5 = 3.826 sigma Chapter 9 – Instructor Reserve Problem Solutions 1. Ultraprecision Corp. has historically had processes which operate above the five sigma level. They have a new […]

Raw Data DeltaWidgets Production Data Production Rate No. of Defectives 13 9 16 10 20 16 25 17 28 18 32 22 20 25 30 Scatter Chart Page 1 36 25 38 20 41 20 43 12 48 12 50 […]

Problem 9-4 Instructor Reserve Circuitus Corp. Average Assembly Times Frequency Distribution and Histogram This template is designed to handle up to 150 observations. Enter data only in yellow cells. Data Minimum 1.000 DATA 1 2 3 4 5 6 7 […]

Problem 9-06 Instructor Reserve WeightBgone Container Weights Frequency Distribution and Histogram This template is designed to handle up to 150 observations. Enter data only in yellow cells. Data Minimum 372.400 DATA 12345678910 11 12 13 14 15 Data Maximum 430.200 […]

Chapter 9 Instructor Reserve Problems The following problems may be used for in-class illustrations, workshops, or additional homework assignments to supplement those in the text. 1. Ultraprecision Corp. has historically had processes which operate above the five sigma level. They […]

Problem 9-10 RiosDeLibros Raw Data Advertising Sales Week Advertising Sales Advertising 1 1700 1595 Sales 0.9845 1 7590 1440 8540 1340 Sorted Data 9575 1390 10 580 1400 Advertising Sales 11 515 1290 515 1290 12 520 1310 520 1310 […]

Lakerio United Bank – Counting & Strapping Errors Weeks on Job Average Weekly Errors 214.8 613.0 10 13.7 14 13.6 18 12.3 22 11.0 26 13.4 12.0 14.0 16.0 Average Weekly Errors 30 11.5 34 8.6 38 9.0 42 5.4 […]

2. Collect customer data 3. Analyze customer data 4. Determine critical customer requirements C. Business results 1. Process performance metrics 2. Benchmarking 3. Financial benefits Six Sigma Body of Knowledge I. Enterprise-Wide Deployment A. Enterprise view 1. Value of Six […]

defective item, in others, a good item. The probability of success in each trial is a con- stant value p. The binomial probability function is given by the following formula: f(x) =  px(1 – p)n – x = px(1 […]

Measuring Instruments Gauges can generally be divided into two basic categories: variable gauges and fixed gauges. Variable gauges, used for variables inspection, are adjusted to measure each individual part or dimension being inspected. Fixed gauges, used for attribute inspection, are […]

4 1750 If the first quarter is the base period, the cost relative indexes expressed as percentages are computed as Quarter Cost Relative Index % 1 (1500/1500)(100) = 100 2 (1700/1500)(100) = 120 3 (1700/1500)(100) = 113.33 4 (1750/1500)(100) = […]

First, consider the sample size when using `x to provide a point estimate of the population mean for variables data. A 100(1 – a) percent confidence interval on`x is given by Sample Size Determination Simple random sampling is generally used […]

provides people with opportunities for personal growth and development. People take joy and pride through learning and accomplishment, and enhance the capability of the enterprise to succeed. People are active contributors, valued for their creativity and intelligence. Every person is […]

• They may prepare their own budgets and coordinate their work with other departments. • They usually order materials, keep inventories, and deal with suppliers. • They frequently are responsible for acquiring any new training they might need. • They […]

When a process is in control, the distribution of individual measurements for variables data is assumed to have a mean µand a variance σ2 x. If a sample of size nis chosen, the sampling distribution of x –will also have […]

Traditional Leadership Theories Leadership theory can be studied from at least five perspectives: the trait approach, the behavioral approach, contingency (situational) approaches, the role approach, and emerging theories.1 The first four represent traditional theories that we discuss in this section. […]

construction firms in Japan and has entered the U.S. market by developing golf courses and condominium communities. Kansai Electric helped to bring recognition of total quality management into the service sector. Kansai offers electrical service at consistently low rates and […]

work. Four of the best-known content models are those developed by Frederick Herzberg (discussed in the text), Abraham Maslow, Douglas McGregor, and David McClelland.1 Content theories provide for a static “snapshot” of how people are motivated to perform certain activities. […]

Supplier Order Date Arrival Date BP Lead Time Supplier Order Date Arrival Date EM Lead Time Bryant Products 10/15/12 10/20/12 5 Elgin Metals 10/01/12 10/06/12 5 Bryant Products 10/20/12 10/27/12 7 Elgin Metals 10/03/12 10/08/12 5 Bryant Products 08/08/12 08/14/12 […]

Supplier Order Date Arrival Date BP Lead Time Supplier Order Date Arrival Date EM Lead Time Bryant Products 10/15/12 10/20/12 5 Elgin Metals 10/01/12 10/06/12 5 Bryant Products 10/20/12 10/27/12 7 Elgin Metals 10/03/12 10/08/12 5 Bryant Products 08/08/12 08/14/12 […]