Archives: Solution Manual
Management Chapter 8 Homework Palma State Bank Run Chart
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 […]
Management Chapter 8 Homework See Histogram and Run Chart Tabs for Results
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 […]
Management Chapter 8 Homework Problem 820 River City Parts Co Sample
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 […]
Management Chapter 8 Homework Enter Number Cells Below 10 Less Number
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 […]
Management Chapter 8 Homework Lower Limit Upper Limit Cell Width Process
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 […]
Management Chapter 8 Homework Process Capability Index Calculations Average 05740 Standard
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 […]
Management Chapter 8 Homework Average Range Operator Averages Range Part
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 […]
Management Chapter 8 Homework Operator Trial Range 0020
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 […]
Management Chapter 8 Homework Trials operators Parts 327
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 […]
Management Chapter 8 Homework Frequency Distribution Problem 813a Frequency Upper
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 […]
Management Chapter 8 Homework Genetic Research Thermometers Descriptive Statistics And Frequency
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 […]
Management Chapter 8 Homework Training And System Improvement Costs System Downtime
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 […]
Management Chapter 8 Homework Workstation Downtime Training system Improvement Rework Costs Total
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 […]
Management Chapter 8 Homework Original Data Category Downtime Testing costs
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% […]
Management Chapter 8 Homework Other Waste Correction Typographical Errorspick Tickets Defects
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. […]
Management Chapter 8 Homework External Failure Internal Failure Appraisal Prevention
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 […]
Management Chapter 8 Homework Int Fail Appraisal Prevent Int Fail Int
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. […]
Management Chapter 8 Homework Quality Costs Product 30
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 […]
Management Chapter 8 Company Packing Slip Errors Average Number
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 […]
Management Chapter 8 Applying Spc Pharmaceutical Product Manufacturing Bin
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 […]
Management Chapter 8 This spreadsheet was modified to calculate the control
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 […]
Management Chapter 8 Specification limits may be entered in cells N7 and N8
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 […]
Management Chapter 8 X-bar and R-Chart
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 […]
Management Chapter 8 Attribute Chart p Values Lower Control Limit
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 […]
Management Chapter 8 Value Size Nonconforming LCLp
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 […]
Management Chapter 8 Lines Inc Billing Study Average
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 […]
Management Chapter 8 Mont valley Short haul Lines Inc Initial Uchart Base
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 […]
Management Chapter 8 Short haul Lines Inc Part Billing Data Table
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 […]
Management Chapter 8 Page Chart Frequency Billing Errors Mont valley Short haul
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% […]
Management Chapter 8 Hallen vale Hospital Case Fraction Nonconforming P
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 […]
Management Chapter 8 Homework Example 810 Quality Measurements 0682
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 […]
Management Chapter 8 cell E6 and the sample size in cell E7
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 […]
Management Chapter 8 X and Moving Range Chart
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 […]
Management Chapter 8 Batch Viscosity Percent Solids
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 […]
Management Chapter 8 Solids Process Capability Analysis This
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 […]
Management Chapter 8 Data From Chemical Batches Batch
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 […]
Management Chapter 8 What fraction of tires is expected to survive beyond
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 […]
Management Chapter 8 Company Situation Column 1 Data 15
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 […]
Management Chapter 8 Hydraulic Lift Company Situation 15
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 […]
Management Chapter 8 Viscosity Percent Weight Solids And Weight Per
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 […]
Management Chapter 8 Case Hydraulic Lift Co The Hydraulic Lift
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 […]
Management Chapter 8 They Were Given The Following Formulas For
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 […]
Management Chapter 8 Average Range Operator Averages Range Part
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 […]
Management Chapter 8 Bloomfield Tool Co Gauge Ramp Data Sample
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 […]
Management Chapter 7 Homework The Cumulative Percentage Failure For The
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 […]
Management Chapter 7 Homework What fraction of tires is expected to survive beyond
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 […]
Management Chapter 7 Homework For The Case Which Specific Target Value
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 […]
Management Chapter 7 Excel Quality Practice Applying Managed Healthcare Direction
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 […]
Management Chapter 7 Homework Projected Failures Using Lambda Cumulative Failures
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 […]
Management Chapter 7 Homework Cumulative Failure Probability 1200 Probability Tx
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 […]