The following cost information is given for company XYZ. pictureClick here for the Excel Data File Calculate the following

Problem 6-1 (Algo) The following cost information is given for company XYZ. Total for the year Cost Item Quality assurance $700,000 Equipment maintenance $330,000 Product redesign $335,000 Product warranty and repair $800,000 Product testing and inspection $397,000 Training $375,000 Process improvement/ Kaizen $370,000 Material scrap $480,000 $451,000 Rework labor Incoming materials inspection $348,000 $275,000 Customer support (after sales ) Travel to suppliers/ process certification $100,000 Travel to customers/ problem solving $105,000 ;pictureClick here for the Excel Data File Calculate the following: a. Total appraisal cost b. Total prevention cost c. Total cost of internal failures d. Total cost of external failures e. Total cost of quality