8. Pareto Analysis (6 marks) a. Research into causes production line stoppages at Solstella Energy over the past four months has revealed the following data on the most common causes. Prepare a Pareto Analysis (chart and graph) of the following data: (3 marks) Cause Employees call in sick Production software frozen Machine breakdown Shortage of silicon Details Not enough employees available to run production line Production software unavailable to provide customer orders to work on The machine that cuts the cell to desired thickness seizes due to low hydraulic fluid # of occurrences 18 3 7 Ran out of silicon so unable to produce cells 15 No customer orders All customer orders have been produced and there are no new orders 1 Tip: in Excel, first create a 2D column chart, then "change series chart type" on the cumulative percentage to be "line", then "Format data series" and choose "Plot on...secondary axis". b. What are some suggestions that could help address the three most common causes? (3 marks)