QVC Challenge DOES SPEED MATTER IN ECOMMERCE Short

Discussion Questions Does the current distribution network maximize customer penetration (spend)? If not, what

Approach Unique identifiers ◦ Telltale for customer frequency

How we approached the problem: Unique identifiers ◦ Telltale for customer frequency Warehouse ◦

Testing our hypotheses Excel ◦ Data stored in. xlx format

Testing our hypotheses Excel ◦ Data stored in. xlx format Tableau ◦ Imported. xlx

Warehouse ID Number of Orders Warehouse ID Ship to State Number of Orders 530

Party ID Day of Order Date Warehouse ID Days until Delivery 48711789 August 27,

Demographic of Purchasers Purchases are made by states spread across the map ◦ ◦

Conclusions Unique Identifiers Warehouse location

Sources Temple University Institute for Business and Information Technology. (2017, October 05). Does speed

Slides: 15

Download presentation

QVC Challenge DOES SPEED MATTER IN E-COMMERCE?

Short Answer?

Short Answer? YES

Discussion Questions Does the current distribution network maximize customer penetration (spend)? If not, what should QVC do to increase customer penetration with the current distribution network? Are there specific products or product categories that should be located in specific distribution centers? Do customers that receive their product sooner purchase more than customers with longer delivery times? (Temple University, IBIT)

Approach Unique identifiers ◦ Telltale for customer frequency

How we approached the problem: Unique identifiers ◦ Telltale for customer frequency Warehouse ◦ Location, location ◦ The closer the location, the faster the service

Testing our hypotheses Excel ◦ Data stored in. xlx format

Testing our hypotheses Excel ◦ Data stored in. xlx format Tableau ◦ Imported. xlx spreadsheets, providing seamless data visualization

Testing our hypotheses Excel ◦ Data stored in. xlx format Tableau ◦ Imported. xlx spreadsheets, providing seamless data visualization Power BI ◦ Attempted to be used in lieu of Tableau, however Tableau was more intuitive and not as overwhelming.

Warehouse ID Number of Orders Warehouse ID Ship to State Number of Orders 530 CA 2168 PA 2161 NY 2232 FL 1206 CA 2230 PA 1821 NY 1568 FL 1455 540 530 26, 197 540 24, 565 200 19, 711 150 14, 425 1, 696 9999 1, 174 674 347 . . . 1617 30 1827 27 1879 27 1689 26 1402 25

Party ID Day of Order Date Warehouse ID Days until Delivery 48711789 August 27, 2016 200 540 4 356 September 5, 2016 200 4 October 23, 2016 540 321 213902789 45111789 November 15, 2016 200 4 . . September 4, 2016 530 627 . . November 23, 2016 540 5 December 3, 2016 540 8 December 12, 2016 540 8 December 24, 2016 530 12 December 27, 2016 530 16

Demographic of Purchasers Purchases are made by states spread across the map ◦ ◦ California Pennsylvania New York Florida

Conclusions Unique Identifiers

Conclusions Unique Identifiers Warehouse location

Sources Temple University Institute for Business and Information Technology. (2017, October 05). Does speed matter in E-commerce? . Retrieved December 10, 2017, from http: //ibit. temple. edu/analytics/can-small-independent-pharmacies-compete-with-the-bigchains/