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 visit an existing customer of the vendor. The customer allowed you to collect data for further analysis. You performed a time study and collected data about pick, pack ship duration of 25 shipments. Given, the data in the attached excel sheet (Q1) perform a hypothesis testing by Use alpha=0.05 for hypothesis testing.
a. Stating your null and alternate hypotheses
b. Perform the proper hypothesis test and discuss your assessment of the vendor's claim.

a

     The null hypothesis  is  

      The alternative hypothesis is  

b

The decision rule is  fail to reject the null hypothesis

The conclusion

There no sufficient evidence to support the vendor claim  that the warehouse management system reduces the average pick, pack, and ship time to below 3 minutes(180 seconds) per order through bin location and routing optimization

Step-by-step explanation:

From the question we are told that

     The population mean is  

     The sample  size is  n =  25

     The excel sheet is show on the first uploaded image

     The level of significance is  

     The null hypothesis  is  

      The alternative hypothesis is  

Generally the sample mean is mathematically represented as

=>      

Generally the standard deviation is mathematically represented as

=>    

=>    

Generally the test statistics is mathematically represented as

=>  

=>      

Generally p-value is mathematically represented as

=>  

From the z-table  

=>  

From the obtained value we that  

The decision rule is  fail to reject the null hypothesis

The conclusion

There no sufficient evidence to support the vendor claim  that the warehouse management system reduces the average pick, pack, and ship time to below 3 minutes(180 seconds) per order through bin location and routing optimization