please post the excel sheet as well in the answer! need the excel sheet of the answer

Part B Analytical Problems (Open book) Time Limit 2.5 horrs Question 1(10 points): a) Ten samples of sire 6 were taken for a machine as abown below: Find eontrol limits for the sample meas and range charts. Show a rough sketch of each chart. Is process under controf Why? Find control limits for the proportion of defective items. Draw the chart. Is the process under control? Why? 2. (10 points): a) A company used 6 sales people working 160 hours each month for 12 months to sell 800 tables and 6000 chais during the year 2019. In 2020, the company used 4 sales people working 210 hours each month for 12 months to sell 700 tables and s000 chairs: The compary eams revenue of $200 for each table and $50 for each chair. Find the sales force productivity in $ per bour for each year and then calculate the percentage change in productivity. b) In 2019, the company us described in part a) leased one car for each sales person at a cost of $2,000 per month and paid werage compensation of $20 per bour. In 2020 , the leasing cost was $2,150 per car per month and average compensation was $22 per hour for the first 160 hours during any month with $33 per hour for additional (overtime) hours during any menth. Find the multi-factor productivity for each year and the percent change in multi-factor productivity