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. Stateside Metrology Repairs Quality costs Cost Element Quality costs Inspection costs -- incoming R20 000 Customer returns 120 000 Rework costs 55 000 Training/system improvement 35 000 Workstation downtime 60 000 Inspection costs -- outgoing 40 000 (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