Quality cost report
Excel Analytics 12-1 (Static) Quality Cost Report (LO12-2] [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 Metode $ 270 51200 3600 O se 500 5 150000 500S 3100 3100 SOS 30 S100 12 Sim W The company's sales were $95 million in Quarter 1 and 5100 million in Quarter 2. Cilick here to download the Exseitemolate which you will use 10 answer the questions that follow Click here for a brief tutorial on Pivottables in Excel Click here for a brief tutorial on PivotCharts in Excel Click here for a brief tutorial on the Subtotal function in Excel Click here for a brief tutorial.on VLOOKUP in Excel References Sector 1. 100 Excel Analytics 12-1 (Static) Part 1 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 (i.e., prevention, appraisal, internal failure, or external failure) 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 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. 1. Award: 1.00 point Excel Analytics 12-1 (Static) Part 1 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 (i.e., prevention, appraisal, internal failure, or external failure) 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 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. RA Reg 13 Reg 1C What is the correct quality cost classification for each of the following quality costs? Customer returns of defective goods Netcost of scrap Quality engineering Statistical process control Supplies used in testing Warranty repairs 1. Award 1.00 point Excel Analytics 12-1 (Static) Part 1 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 (i.e., prevention, appraisal, internal failure, or external failure) 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 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. Req1A Reg 16 Rea 1 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.) Show less Quarter 1 (5) Quarter 2 Cost of testing equipment Inspection Netcost of scrap Product recalls Systems development Warranty repairs 1. Award: 1.00 point Excel Analytics 12-1 (Static) Part 1 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 (i.e., prevention, appraisal, internal failure, or external failure) 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 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. Req1A Ree 18 Req 1C 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.) Show less Quarter 1 (%) Quarter 2 (%) % % Customer retums of detective goods Downtime due to quality problems Quality engineering Rework labor Statistical process control Warranty repair 1. Award: 1.00 point Excel Analytics 12-1 (Static) Part 1 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 (i.e., prevention, appraisal, internal failure, or external failure) 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 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. Req1A Ree 18 Req 1C 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.) Show less Quarter 1 (%) Quarter 2 (%) % % Customer retums of detective goods Downtime due to quality problems Quality engineering Rework labor Statistical process control Warranty repair
