This is a two-part question. Please answer using Excel and using Excel functions (show functions as well)

Schumacher & Company's Distribution and Transportation Division, called SPI Services, has a short-haul household furniture delivery service. SPI's labor force, selected from the local community college rugby team, is temporary and part-time. SPI is concerned with recent complaints, reported in the following table. a) Draw a Pareto chart to identify potential causes of complaints. b) Use a cause-and-effect diagram to identify potential causes of the most frequent complaint. (Note: For the cause-and-effect diagram, use the following major categories - Materials, Personnel, Equipment, Procedures, and Other.) Number 19 9 15 Complaint Broken glass Delivered to wrong address Furniture rubbed together while on truck Late delivery Late arrival for pickup Missing items Nicks and scratches from rough handling Soiled upholstery 21 17 8 28 10 Schumacher & Company recently introduced a new ATM system. The Company's MoneyMatic Division assembles these systems from purchased hardware, using its in-house developed software. It just completed assembling the first batch of 15 units. The last unit (#15) produced required 50 hours of labor, and the learning rate was estimated to be 94 percent for these systems. Another order for 25 units (#16 - #40) of the same system has just arrived. 1) What is the estimated time for the 40th unit? 2) How many total labor hours will be needed to satisfy this second batch (#16 - #40) ? 3) What is the average time to produce this second batch