Cost of Quality Exercise: A) Open a new tab and rename to Santos Quality Costs. On this tab you are going to create: 1) Data table 2) Pie Chart 3) Recommendation Block. The three elements should be laid out to fit on a single landscape sheet of paper. The end product should fit the role of aone-page handout for you to lead a discussion with Santos Pharmacutical Management. B) Create a labeled table using the four major categories the category spend totals. Using the data in your table create a Pie Chart to show the breakdown of the Total Quality costs into the four major categories. Ensure that you show category labels, the percentage of each of the four quality costs along with the dollar amount. Include a proper heading for the chart, table and page. C) Add a textbox. In the textbox a) Discuss your thoughts on the Quality spending at Santos Pharmacutical in 2020. b) State at least two recommendations would you make for changes in spending in 2021? Explain the reasoning behind each recommendation. (No more than 200 BS o TableCostofQuality Exercise_bb (1) [Protected View] - Excel Tell me what you want to do... File Home Insert Page Layout Formulas Data Review View Sign in & Share PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A34 fic A D E F H 1 J K L M N 9 Clipboard Clear All Click an Item to Paste: B Cost of Quality Report Year end December 31, 2020 Paste All 10 11 12 Quality Costs Percent of Sales (%) 65,200 48,300 44,900 76,200 234,600 1.2 One practical problem which I face would like to share. I bought Ac... 108,200 99,500 101,200 308,900 1.6 You or a family member may have purchased a product that you wer... 13 Prevention costs: 14 Quality Training 15 Process planning 16 Quality Audits 17 Machine Maintenance 18 Appraisal Costs: 19 Inbound Inspection 20 Inprocess Inspection 21 Process Acceptance 22 Internal Failure Costs: 23 Rework 24 Scrap 25 External Failure Costs: 26 Warranty costs 27 Service & Retrofit Costs 28 Product replacement 29 Product Repairs and expedited shipping 30 Total Quality costs 31 32 * Annual sales 33 2,447,500/19,250,000 = 12.5% 34 Sheet1 + 485,000 390,000 875,000 4.5 Share your experience You or a family member may have purchased a product that you wer... 185,000 195.000 394,000 255,000 5.3 1,029,000 2,447,500 12.7 You or a family member may have purchased a product that you wer... 19,250,000 Options Ready 9 of 24 - Clipboard Item not Collected: Delete items to increase available space 2:19 PM Ma ENG 7/7/2021 Search the web and Windows e W x] A 4x Cost of Quality Exercise: A) Open a new tab and rename to Santos Quality Costs. On this tab you are going to create: 1) Data table 2) Pie Chart 3) Recommendation Block. The three elements should be laid out to fit on a single landscape sheet of paper. The end product should fit the role of aone-page handout for you to lead a discussion with Santos Pharmacutical Management. B) Create a labeled table using the four major categories the category spend totals. Using the data in your table create a Pie Chart to show the breakdown of the Total Quality costs into the four major categories. Ensure that you show category labels, the percentage of each of the four quality costs along with the dollar amount. Include a proper heading for the chart, table and page. C) Add a textbox. In the textbox a) Discuss your thoughts on the Quality spending at Santos Pharmacutical in 2020. b) State at least two recommendations would you make for changes in spending in 2021? Explain the reasoning behind each recommendation. (No more than 200 BS o TableCostofQuality Exercise_bb (1) [Protected View] - Excel Tell me what you want to do... File Home Insert Page Layout Formulas Data Review View Sign in & Share PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A34 fic A D E F H 1 J K L M N 9 Clipboard Clear All Click an Item to Paste: B Cost of Quality Report Year end December 31, 2020 Paste All 10 11 12 Quality Costs Percent of Sales (%) 65,200 48,300 44,900 76,200 234,600 1.2 One practical problem which I face would like to share. I bought Ac... 108,200 99,500 101,200 308,900 1.6 You or a family member may have purchased a product that you wer... 13 Prevention costs: 14 Quality Training 15 Process planning 16 Quality Audits 17 Machine Maintenance 18 Appraisal Costs: 19 Inbound Inspection 20 Inprocess Inspection 21 Process Acceptance 22 Internal Failure Costs: 23 Rework 24 Scrap 25 External Failure Costs: 26 Warranty costs 27 Service & Retrofit Costs 28 Product replacement 29 Product Repairs and expedited shipping 30 Total Quality costs 31 32 * Annual sales 33 2,447,500/19,250,000 = 12.5% 34 Sheet1 + 485,000 390,000 875,000 4.5 Share your experience You or a family member may have purchased a product that you wer... 185,000 195.000 394,000 255,000 5.3 1,029,000 2,447,500 12.7 You or a family member may have purchased a product that you wer... 19,250,000 Options Ready 9 of 24 - Clipboard Item not Collected: Delete items to increase available space 2:19 PM Ma ENG 7/7/2021 Search the web and Windows e W x] A 4x