Please Show your work in excel and or a step by step process

Part 2 ACME continues to complain to your sales team about late deliveries. As any good quality engineer, you have already begun to investigate potential causes of late deliveries. Your team has collected some significant data as shown in the table below. Cause Code Frequency 20 ABC production delays Trucks not available for loading B 10 190 Truck breakdown in transit D 12 E 30 Employee absenteeism Low-skilled workers Loading forklift out of service Incorrect packaging material F 110 G 15 Questions 1. Choose an appropriate quality management problem-solving tools to identify the root cause of the late deliveries. You must show a visual solution and provide a description of the root cause of late deliveries for full credit. 2. Using the data provided, construct the most appropriate quality problem-solving tool to identify which variable(s) have the most influence on the ability of ABC to provide gears to ACME