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 t on a single landscape sheet of paper. The end product should fit the role of aonepage handout for you to lead a discussion with Santos Pharmacutical Management. 8) Create a labeled table using the four major categories the category spend totals. Using the data in your table create aPie Chart to show the breakdown of the Total Quality oosts into the four major categories. Ensurethat 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 textboxa] 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 TableCostofQualityExercise_bb (1) [Protected View] - Excel X File Home Insert Page Layout Formulas Data Review View Tell me what you want to do. Sign in Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X i A34 X V A B C D E F G H K M N Clipboard X 9 Cost of Quality Report 10 Year end December 31, 2020 Paste All Clear All 11 Click an Item to Paste 12 Quality Costs Percent of Sales (%) 13 Prevention costs: 14 Quality Training 65,200 15 Process planning 48,300 16 Quality Audits 44,900 17 Machine Maintenance 76,200 234,600 1.2 18 Appraisal Costs: $3 One practical problem 19 Inbound Inspection 108,200 which I face would like to share. I bought Ac... 20 Inprocess Inspection 99,500 21 Process Acceptance 101,200 308,900 1.6 You or a family member 22 Internal Failure Costs: may have purchased a product that you wer... 23 Rework 485,000 24 Scrap 390,000 875,000 4.5 Share your experience 25 External Failure Costs: 26 Warranty costs 185,000 27 Service & Retrofit Costs 195,000 You or a family member 28 Product replacement 394,000 may have purchased a Product Repairs and expedited shipping 255,000 1,029,000 5.3 product that you wer... 30 Total Quality costs 2,447,500 12.7 You or a family member 31 may have purchased a 19,250,000 product that you wer... 32 * Annual sales 33 2,447,500/19,250,000 = 12.5% 34 Options 9 of 24 - Clipboard Sheet1 + Item not Collected: Delete items Ready to increase available space 2:19 PM H Search the web and Windows Dem EM XI A x D = ENG 7/7/2021