Jupyter Notebook must be used for this assignment.

1. A company is approached by a new warehouse management systems vendor to adopt a new system. The vendor claims that the warehouse management system reduces the average pick, pack, and ship time to below 3 minutes per order through bin location and routing optimization. You are given an opportunity to visit an existing customer of the vendor. The customer allowed you to collect data for further analysis. During the day you performed a time study and collected data about the pick, pack ship duration of 25 shipments. Given, the data in the attached excel sheet (Q1) perform a hypothesis testing. Use alpha=0.05 for hypothesis testing.

1. Stating your null and alternate hypotheses
2. Perform the proper hypothesis test and discuss your assessment of the vendors claim.

2. After the initial analysis, the management team would like to consider the vendor for further assessment. The vendor is given data to create a virtual warehouse, simulate and compare existing product bin placement and routing policies for picking with the systems outcome. As an analyst, you are involved in the study to validate the results and provide an unbiased assessment of the software. You simulated 40 picks and collected the results in the excel file (Q2). Use alpha=0.025 for both parts a and b

1. Does the software reduce the average time compared to the original situation? (Please make sure that you type your hypothesis)
2. The management team told you they would consider adopting the software if it reduces the average time at least 30 seconds per order, what is your final suggestion? (Please make sure that you type your hypothesis)

*To submit your Jupyter Notebook file go to the File menu, then click to Download as, and then download the file as notebook (.ipynb). You need to submit this word document with answers and Jupyter notebook files to complete the assignment.