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)

Python Assignment 2 Data File Q Search Shoot Home Page Layout Formulas Review View 2+ Share Insert X. Cui Cut Calibri Body) Ataun- - 11 A- A hopTust Geroral Bad Good -X 49. Cany Fil Posts B UL u A = MER Cher - $ Conditional Formu Formatting Table Natal Calculation Check Cell Insert Format FI Clear Sans Fler G7 3: Y 1 1 Current warehouse in Sunde formance with twowe 2 Shipment me to Sri lincconds Time to San Second 1 225 179 4 26 216 5 245 211 3 155 915 7 5 11n G 193 19 2 7 225 221 10 8 246 11 2:0 12 158 1:1 11 236 2201 14 12 719 15 13 150 16 256 262 17 15 245 232 18 26 158 243 - 21 22 23 16 10 20 21 22 25 24 25 16. 150 752 LEG 152 220 248 279 229 29 1:8 1:0 147 178 145 257 153 248 111 27 28 22 30 11 12 15 *TZ 301 273 -23 224 3. 32 242 36 37 35 26 1 127 251 158 2:1 115 112 115 261 270 2 20 40 18 19 Ar 10 217 23 24 45 27 29 50 51 52 53 5 01 Q2 + Ready BE 1058 Python Assignment 2 Data File Q Search Shoot Home Page Layout Formulas Review View 2+ Share Insert X. Cui Cut Calibri Body) Ataun- - 11 A- A hopTust Geroral Bad Good -X 49. Cany Fil Posts B UL u A = MER Cher - $ Conditional Formu Formatting Table Natal Calculation Check Cell Insert Format FI Clear Sans Fler G7 3: Y 1 1 Current warehouse in Sunde formance with twowe 2 Shipment me to Sri lincconds Time to San Second 1 225 179 4 26 216 5 245 211 3 155 915 7 5 11n G 193 19 2 7 225 221 10 8 246 11 2:0 12 158 1:1 11 236 2201 14 12 719 15 13 150 16 256 262 17 15 245 232 18 26 158 243 - 21 22 23 16 10 20 21 22 25 24 25 16. 150 752 LEG 152 220 248 279 229 29 1:8 1:0 147 178 145 257 153 248 111 27 28 22 30 11 12 15 *TZ 301 273 -23 224 3. 32 242 36 37 35 26 1 127 251 158 2:1 115 112 115 261 270 2 20 40 18 19 Ar 10 217 23 24 45 27 29 50 51 52 53 5 01 Q2 + Ready BE 1058