could you please show the excel solution clearly. Thanks

Case Study 2: Quality Management Your line manager has become increasingly concerned about the product and service quality. This results from a surge in the number of customers who have contacted he highlight problems they have encountered while shopping at the Pet Kingdom store. complains seem to focus on two areas; billing errors being made at the checkout and variations in the weight of Pet Kingdom branded dried dog food bags. To better under the situation, Ms Lionheart has requested detailed data to be collected. Table 3 shows data from the audit of 50 random bills per day issued over the past 30 days. Table 4 presents the weight sampling data (mean and range in kg ) for 27 random samples of fi observations each taken from the daily dog food deliveries. Ms Lionheart noticed that the number of billing errors increased in the last third of the month. She knows that the company wants high quality standards and wonders if both processes meet 3 sigma standards. She wants you to analyse the available data and pro a short report (1,000 words 10% ) with all relevant tables and figures, to address the highlighted issues. 1. Analyse and explain the data. 2. Set up appropriate 3 -sigma control limits and generate the control charts. Explain your approach. What does 3 -sigma indicate about the acceptable quality? Table 3: Number of incorrect bills issued at checkout ( 50 observations) Table 4: Doe food weieht (kg) samoles (5 observations)