Required information [The following information applies to the questions displayed below.) Harvey Company designs and produces surgical lasers. Its product is brilliantly designed, but the manufacturing process has been plagued by chronic quality control problems. To help address the situation, Harvey formed a cross-functional team of managers that quantified its costs of quality over the last two quarters as follows: Cont of testing equipment Customer return of defective goods Downtime due to quality problems Inspection Net cost of scrap Product recalls Quality engineering Rework labor Statistical process control Supplies uned in testing Systems development Warranty repairs Coats in thousands Quarter 1 Quarter 2 $ 270 $ 390 $3,200 $ 200 $ 600 $1,100 $1,700 $2,770 $ 800 $1,300 $3,500 $ 600 $1,080 $1,650 $1,400 $1,600 $ 0 $ 270 $ 30 $ 40 $ 120 $ 680 $3,300 $2,800 The company's sales were $95 million in Quarter 1 and $100 million in Quarter 2 Click here to download the Excel template, which you will use to answer the questions that follow Required: 1. Go to the tab titled Template A: a. For each cost described in cells A6 through A17, choose the correct quality cost classification (.e., prevention, appraisal, internal fallure, or external failure) from the drop-down list that appears when you put the cursor in each of cells 86 through B17. b. Create formulas in cells D6 through D17 that state each individual cost from Quarter 1 (as shown in cells C6 through C17) as a percent of the first quarter's total cost of quality (as shown in cell C18). Repeat this process in column G for quarter 2. c. Create formulas in cells E6 through E17 that state each individual cost from Quarter 1 (as shown in cells C6 through C17) as a percent of the first quarter's total sales (as shown in cell C20). Repeat this process in column H for quarter 2. Complete this question by entering your answers in the tabs below. Req 1A Reg 1B Req 1C For each of the quality costs shown below, what is the amount of the cost as a percent of the total cost of quality? The first column of answers relates the first quarter and the second column relates to the second quarter. (Round your answers to 1 decimal place.) Quarter 1 Quarter 2 (%) (%) Cost of testing equipment % Inspection % Net cost of scrap % % Product recalls % % Systems development % % Warranty repairs % Required: 1. Go to the tab titled Template A: a. For each cost described in cells A6 through A17, choose the correct quality cost classification (.e., prevention, appraisal, Internal fallure, or external fallure) from the drop-down list that appears when you put the cursor in each of cells B6 through B17. b. Create formulas in cells D6 through D17 that state each individual cost from Quarter 1 (as shown in cells C6 through C17) as a percent of the first quarter's total cost of quality (as shown in cell C18). Repeat this process in column G for quarter 2. c. Create formulas in cells E6 through E17 that state each individual cost from Quarter 1 (as shown in cells C6 through C17) as a a percent of the first quarter's total sales (as shown in cell C20). Repeat this process in column H for quarter 2. Complete this question by entering your answers in the tabs below. agic Req 1A Reg 1B For each of the quality costs shown below, what is the amount of the cost as a percent of the total sales? The first column of answers relates the first quarter and the second column relates to the second quarter. (Round your answers to 1 decimal place.) Quarter 1 Quarter 2 1%) Customer returns of defective goods Downtime due to quality problems Quality engineering Rework labor Statistical process control Warranty repairs % % % % % % % % % % %
