B D E F G Analyze the cost data in the Excel workbook C08 Problem Data for the Costcutin Co. What percent of sales are represented by each category of cost? What are the implications of these data for management? Create a table and chart (histogram) below show the quality costs by category and product $1,397,120 12% e Costcutin Co. 0 1 Product 2 B 3 Total sales $1,537,280 $933,600 14 Total quality costs 15 as % of sales 21% 18% 16 17 External failure 30% 19% 18 Internal failure 55% 31% 19 Appraisal 11% 39% 20 Prevention 4% 11% 21 22 (Bold figures represent percentages of quality costs by product.) 23 10% 28% 36% 26% 19. The Excel workbook C08 Problem Data provides data on quality losses at Nosoco Paper Mill. Find the percentage of cost for each category, and the cumulative percentages when the categories are sorted sorted by decreasing costs. Construct an appropriate Excel chart to analyze the data. What conclusions do you reach? Sorted by cost 4 3 Nosoco Paper Mini Category 10 Downtime 11 Testing costs 12 Rejected paper 13 Odd lot 14 Inspection 15 Customer complaints 10 Wasted materials 17 Quality Improvement training 18 19 Total Quality Cost Annual Loss $30,000 $15,000 $375,000 $66,000 $25,000 $103,000 $31.000 $10,000 $655,000 C D E G H J K 13. Two scales were at Aussieburgers, Ltd. used to weigh the same 25 samples of hamburger patties for a fast-food restaurant in Australia. Results are shown in the C08 Problem Data workbook. The samples were weighed in grams, and the supplier has ensured that each patty weighs 114 grams. Compute, for each scale, the average and variance of the data, the relative error, and construct a histogram of the data. Which scale is more accurate? Which is more precise? Which is the better scale? Aussieburgers, Ltd. Scale A 116 112 118 114 115 117 117 116 115 116 116 116 118 116 116 117 115 117 116 116 117 116 117 116 117 113 114 115 114 113 Scale B 115 114 111 113 115 113 114 115 115 116 112 114 115 116 114 113 114 114 118 115