leveraging e-commerce sites to absorb retail …traditional leveraging e-commerce lateral...
TRANSCRIPT
![Page 1: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/1.jpg)
LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL STORES’ EXCESS INVENTORY
By: Hyuk Jin Cho and Ketan LahotiAdvisor: Dr. Bruce C ArntzenSponsor: CSV Health
![Page 2: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/2.jpg)
LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL STORES’ EXCESS INVENTORY
By: Hyuk Jin Cho and Ketan LahotiAdvisor: Dr. Bruce C ArntzenSponsor: CSV Health
![Page 3: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/3.jpg)
Carries over 3,000 SKUs
9,600 Stores across US
No.1 Retail Pharmacy business in the US
Mail CenterStore
![Page 4: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/4.jpg)
![Page 5: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/5.jpg)
I DON’T FEEL GOOD…I’M GONNA PICK UP THE PRESCRIPTION DRUG THAT THE DOCTOR WROTE FOR ME FROM THE STORE.
![Page 6: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/6.jpg)
WELCOME TO CVS! WE HAVE ALL THE DRUGS YOU NEED. HOW MAY I HELP YOU?
![Page 7: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/7.jpg)
COME TO CVS AGAIN !
![Page 8: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/8.jpg)
BUT…
FORECAST ACCURACY CLIMATE CHANGES PROMOTION
![Page 9: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/9.jpg)
EXCESS INVENTORY
![Page 10: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/10.jpg)
TOO MUCH EXCESS INVENTORY !!!
BACK IN 2015…
![Page 11: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/11.jpg)
REDUCED EXCESS INVENTORY
MAIL CENTERSTORE
![Page 12: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/12.jpg)
!REDUCED EXCESS INVENTORY…BUT THE COST INVOLVED WAS HIGH…
![Page 13: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/13.jpg)
AUTOMATED PROCESS
?OBJECTIVE
![Page 14: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/14.jpg)
For each SKU at each store (non-controlled drugs):
1. Calculate Average Weekly Sales (outbound)!"#$%&# '()*+(,- = /(0 +1 2%3#2 1+$ % /45 6, % 2)+$# %7$+22 52 :##;2/52
2. Calculate Weeks of Supply (WOS)=##;2 +1 /(>>3? = @ABCADEFG EA HIAJ IDKCCL MN
OBCFIPC QRDSERAJ
3. Compare with the standard weeks of supplyTU7#22 V,"#,)+$? (:##;2) = Y($$#,) ='/ − [%$&#) 6,"#,)+$? 3#"#32
4. Convert back to units for excess weeks of supplyTU7#22 V,"#,)+$? (,6)2 = TU7#22 V,"#,)+$? :##;2 ∗ !"#$%&# '()*+(,-
5. Multiply excess units with Average Wholesale Price (AWP)TU7#22 6,"#,)+$? "%3(# = TU7#22 6,"#,)+$? (,6)2 ∗ !=]
6. Sum all excess inventory value across the system
METHODOLOGY
![Page 15: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/15.jpg)
1. Calculate Average Weekly Sales (outbound)
2. Calculate Weeks of Supply (WOS)
3. Compare with the standard weeks of supply
4. Convert back to units for excess weeks of supply
5. Multiply excess units with Average Wholesale Price (AWP)
6. Sum all excess inventory value across the system
MODEL
![Page 16: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/16.jpg)
RESULT
![Page 17: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/17.jpg)
Top X SKUs Total Savings ($M) % Savings
1 84.33 8.11%
5 208.22 20.03%
10 300.46 28.91%
20 426.16 41.00%
30 516.83 49.72%
40 588.49 56.62%
50 647.61 62.31%
60 697.71 67.13%
70 740.93 71.28%
80 778.67 74.92%
90 811.84 78.11%
100 841.08 80.92%
RESULT
![Page 18: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/18.jpg)
Traditional
![Page 19: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/19.jpg)
Leveraging E-commerce Lateral TransshipmentTraditional
FUTURE RESEARCH
![Page 20: LEVERAGING E-COMMERCE SITES TO ABSORB RETAIL …Traditional Leveraging E-commerce Lateral Transshipment FUTURE RESEARCH. Title: 43865452-Research Fest_v2.0 Created Date: 6/10/2019](https://reader033.vdocuments.us/reader033/viewer/2022050112/5f49533715e255489378cc6e/html5/thumbnails/20.jpg)