Cassette tapes are still used in some handheld recording devices and in less expensive portable musical instrument recording devices. the desired speed of a cassette tape is 1.900 inches per second. any deviation from this value causes a change in pitch and tempo and thus poor sound quality. suppose that adjusting the tape speed under warranty when a customer complains and returns a device costs a manufacturer $25. based on past information, the company knows the average customer will return a device if the tape speed is off the target by at least 0.200 inch per second; in other words, when the speed is either 2.100 or 1.700. suppose that a technician tests the tape speed prior to packaging and can adjust the speed to the target of 1.900 at a cost of $7. what should the economic specification limits be? the data has been collected in the microsoft excel online file below. open the spreadsheet and perform the required analysis to answer the questions below.

File Home Insert Formulas Data Review Vie Arial 10 EE B I U D ab Paste > AA A Clipboard Font Alignme ndo 18 B C D Taguchi Loss Function Formulas Calculation of k for the Loss Function Deviation from target Loss associated with deviation k 02 $25.00 #N/A 1.900 1.950 $0.00 #NA Loss Calculation for a Specific x Target specification, T 7 Dimensional value, X 2. 3 Loss 4 5 Economic Design Specifications 6 Target specification, T 7 k Cost of inspection and adjustment 9 Break-Even Tolerance 20 Lower specification limit 1 Upper specification limit 1.900 $0.00 $7.00 8 #NA #NA #N/A Sheet1 Calculation Mode: Automatic Workbook Statistics File Home Insert Formulas Data Review View Arial 10 = = 5 B ab Paste IU D AA w A Undo Clipboard Font Alignmer L18 B C Formulas OWN 0.2 $25.00 #N/A 1 Taguchi Loss Function 2 3 Calculation of k for the Loss Function Deviation from target Loss associated with deviation 7 k 8 9 Loss Calculation for a Specific x 10 Target specification, T 11 Dimensional value, X 12 k 13 Loss 14 15 Economic Design Specifications 16 Target specification, T 17 k 18 Cost of inspection and adjustment 19 Break-Even Tolerance 20 Lower specification limit 21 Upper specification limit 1.900 1.950 $0.00 #N/A 1.900 $0.00 $7.00 #N/A #NA #N/A Sheet1 Calculation Mode: Automatic Workbook Statistics File Home Insert Formulas Data Review Vie Arial 10 EE B I U D ab Paste > AA A Clipboard Font Alignme ndo 18 B C D Taguchi Loss Function Formulas Calculation of k for the Loss Function Deviation from target Loss associated with deviation k 02 $25.00 #N/A 1.900 1.950 $0.00 #NA Loss Calculation for a Specific x Target specification, T 7 Dimensional value, X 2. 3 Loss 4 5 Economic Design Specifications 6 Target specification, T 7 k Cost of inspection and adjustment 9 Break-Even Tolerance 20 Lower specification limit 1 Upper specification limit 1.900 $0.00 $7.00 8 #NA #NA #N/A Sheet1 Calculation Mode: Automatic Workbook Statistics File Home Insert Formulas Data Review View Arial 10 = = 5 B ab Paste IU D AA w A Undo Clipboard Font Alignmer L18 B C Formulas OWN 0.2 $25.00 #N/A 1 Taguchi Loss Function 2 3 Calculation of k for the Loss Function Deviation from target Loss associated with deviation 7 k 8 9 Loss Calculation for a Specific x 10 Target specification, T 11 Dimensional value, X 12 k 13 Loss 14 15 Economic Design Specifications 16 Target specification, T 17 k 18 Cost of inspection and adjustment 19 Break-Even Tolerance 20 Lower specification limit 21 Upper specification limit 1.900 1.950 $0.00 #N/A 1.900 $0.00 $7.00 #N/A #NA #N/A Sheet1 Calculation Mode: Automatic Workbook Statistics