CASE STUDY: 3 Read the following scenario and answer all the questions given below. A new manager of TNTB Courier Service would like to investigate why customers keep on complaining in social media on poor service. Data was retrieved from TNTB system on Feedback of courier service experienced by the customers. Data on category/causes and number of customer complaint/count is shown in the following table: 4 Sr. Nr. Category Cause Count Competitive Pricing 10 2 Poor customer service 3 Goods Delivered in an unacceptable condition 9 Late deliveries 126 5 Late Custom clearance 8 6 Loss during delivery 20 7 quotation being received inaccurately 5 pickup not happening as expected 4 9 Delivery being sent out to the wrong address 3 10 Inexperienced staff 1 TOTALS 300 8 Answer the following questions based on the above table: Prepare a table shows cumulative percentage (2Marks) b) Draw Pareto chart with pareto line. (2+2 Marks) Find out which 20% causes creating 80% of the problem. Prove with Calculation and diagram. (2+1 Marks) a) Find out what is the percentage of short late custom clearance. (1Mark) S.NO CATEGORY COUNT PERCENTAGE CUMULATIVE PERCENTAGE 1 2 3 4 S 7 9 10