Archives: Solution Manual

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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