QUESTION 1 [25] - GA2 (25 theory in engineering problems). Stateside Metrology Repairs, Inc. has a thriving business repairing and upgrading high technology measuring instruments. The costs of quality that they have collected over the past year can be found in the table below. Statesirle Metrolnou Renaire Nialitu coete (a) Construct a Pareto chart with the cumulative percentage trend line showing the different quality cost elements and percentages for the company's quality costs (Cost; Cumulative cost; % Cost & Cumulative % Cost). Show all your calculations. (7) (b) Use MS Excel or hand neatly draw the Pareto graph in part (a). (6) (c) Fully interpret your results from part (a) and (b). (4) (d) Classify the costs by aggregating them into the four categories of quality costs as studied under Chapter 3 , section 3.6 of your reference textbook. Arrange the costs in order of highest category to the least. (3) (e) Use Excel to draw a bar chart of cost categories on the horizontal axis versus total costs on the vertical axis in answer to part (d). Comment on your chart