Sonte Burk Omnichannel Transportation Analyst Big Wins for Big Lots In Transportation Logistics and Ecommerce Shipping MINGDA XU ALTERYX USER SINCE 2016 When I use Alteryx I feel like Allen Iverson when he crossed Michael Jordan ID: 1045771
Download Presentation The PPT/PDF document "Mingda Xu, Transportation Analyst" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
1. Mingda Xu, Transportation AnalystSonte Burk, Omni-channel Transportation AnalystBig Wins for Big Lots In Transportation Logistics and E-commerce Shipping
2. MINGDA XUALTERYX USER SINCE 2016When I use Alteryx, I feel like Allen Iverson when he crossed Michael JordanWith Alteryx, I can fulfill all my creative ideas and still be analyticalSONTE BURKALTERYX USER SINCE 2017
3. Company Overview & Strategy ShiftInbound Logistics Use CaseGoal & ObstaclesPre-Alteryx StruggleAlteryx Workflow Solution & GainsE-commerce Shipping Use CaseBusiness Problem from Free Shipping EraTraditional Routing MethodAlteryx Workflow SolutionsFuture Opportunities
4. Company OverviewFURNITURE | SEASONAL | HOME | FOOD | CONSUMABLES | TOYS | ELECTRONICS1,400+ stores47 states35,000 associates$5.3 billion sales in 2017Never-out, in-and-out and close-out merchandiseBiglots.com in April 2016
5. Re-evaluationJenniferPreferenceValueCommunity
6. Strategy: Value stores in the communityModern designFriendly environment and staffComfortable shopping experienceClose-out to consistencyContinue to create valueServe Big Save Lots!STORE RENOVATIONASSORTMENT
7. Opportunities for LogisticsMust pick up nowNo question about how merchants orderNo pick up location selectionStrategic sourcingOptimize transportation modeBetter forecast and ordering patternCLOSE-OUTSCONSISTENCYREACTIVEPROACTIVE
8. GoalS & ObstaclesGOALSOBSTACLESVisibility of vendors’ transportation related performance and characteristics YoY comparison & root causeMultiple data sources from outsource partnersIncompatible dataFreight data (Shipment level)PO receipt data from internal SAP (PO level)
9. Pre-Alteryx Struggle2days4hours4hoursTime consumingHuman errorsMight crash computerAuto-save & delicateHard to trouble shootHuman errors
10. Alteryx Workflow!
11. Alteryx outputTrans. Metrics & Mode utilization
12. Gains From ALteryx2016 identified inbound frt. savings of11%3 days10 mins2017 identified inbound frt. savings of5%
13. FREE SHIPPINGrewardsFree shipping increase sales revenueBoost the average order valueCustomer LoyaltyLow cost per unitShipping parcel is expensiveMargin is squeezedDimensional weight factorPack size corrugateObstacles
14. Business opportunityCalculator - Input SKU Dimensions and review resultsSKUL (in)W (in)H (in)W (lbs)Length + GirthBilled Weight 210000003020153010030
15. Pre-alteryx parcel routingManual review of routing waves in Excel Transportation Preview RptIf Statements + Excel FiltersRe-route to SmartPostLocks Applied4-10%Reduced cost by.5%Time in Hours2-3Re-route to Home Delivery
16. Gains From ALteryxEfficiency & Cost Locks-28%Cost-1%minutes98.5% On Time 201699.4% On Time 2017ServiceInaccurate carton size2-3 hours654 locksNo est. costRouting Before AlteryxAccurate carton size30 mins472 locksEst. costRouting After Alteryx
17. Future Opportunities
18. Mingda Xumxu@biglots.com Sonte Burksburk@biglots.comPlease complete a feedback survey!