Editing Comme 9 Arial 10 B A. 2 SU MX G D E G H M N 1 Taguchi Lons Function Formulas Cakulation of the Loss Function Deviation from farget Loss associated with devotion 02 3:10.00 5 7 INNIN 1900 1950 50.00 NA Lens Cakulation perife 10 Target specification, Dimensional va 12 10 Los 14 1) Economic Dion Specifications 16 Target poication 17 18 Cost of inspection and adum Buk Even Tolerance 30 Lower specification 1 Upper specification 4 sh 1500 50.00 500 NIA NA MNICA Give Me con MA W HOLO Si Video Excel Online Activity: Taguchi AZ 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 $30. 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 $8. What should the economic specification mit 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. HHHH Hospreads Questions 1. In the Taguchi loss function, what is the constant that translates the deviation into dollars Round your answer to the nearest cent Nerd Bach Questions 1. In the Taguchi loss function, what is the constant that translates the deviation into dollars? Round your answer to the nearest cent. $ 2. If the actual speed is 1.950 inches per second, what is the loss? Round your answer to the nearest cent. $ 3. What is the break-even tolerarice? Round your answer to three decimal places. 4. What are the lower and upper economic specification limits Round your answers to three decimal places. Lower specification limit: Upper specification limit: Check My Work Reset Problem Need