Download - P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley
![Page 1: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/1.jpg)
Pan American Advanced Studies InstituteSimulation and Optimization of Globalized Physical Distribution Systems
Santiago, Chile August, 2013
Pan American Alliance for Supply Improvement: Beverly Kris Jaeger
Alejandro MacCawley Marie-Eve Rancourt
Carlos Solorio-Magana Shanthi Muthuswamy
PASI Project: Case #2
![Page 2: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/2.jpg)
There’s a challenge to be met …
Agenda Introduction
Current State The Mission
Methods Models & Paths Calculations & Computations
Solution Options Implications Further considerations
PASI Objectives
Interpretations & Assumptions
![Page 3: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/3.jpg)
Problem Overview: Case 2
What do we ‘know’?Introduction
![Page 4: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/4.jpg)
Problem Overview
6 Manufacturing Plants Newark NJ, St Louis MO, Springfield MO Memphis TN, Fort Worth TX , & Mexicali
5 Current Distribution Centers Canada: Toronto USA: Salt Lake, Tulsa OK Allentown PA, Atlantic City, NJ
2 Candidate DCs• Oakland CA• Los Angeles
DC
Introduction
?
![Page 5: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/5.jpg)
Problem Overview
DC Leases Expiring in 18 months:• Toronto• Salt Lake City
Customers • Retailers across US and Canada• US Customers must be serviced
by a US-based Distribution Center
Introduction
DC
![Page 6: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/6.jpg)
Mfg Loc
DC Ex
DC Poss.
Cust. Base
Mfg
DC
To
Tu
SL
AT
NWAL
SL
SP
MC
MP
FW
O
LA
?
C
CC
CU
Introduction
![Page 7: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/7.jpg)
Problem Formulation
Decisions
Active/open DC (yj)
Size of new DC (S)
Outbound flows (xjk)
• Inbound flows given (% from each plant)
Objective
Minimize: Fixed & variables costs
for the active DC(s)• The fixed cost of new
DC is a function of S Transportation costs
• Inbound and outbound
Introduction
![Page 8: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/8.jpg)
What is our mission?
Measurable challenges• Reduce total supply chain costs • Reduce delivery times
Introduction Solution(s)Solution(s)
![Page 9: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/9.jpg)
The Challenges, Q1 & Q2
Q1: ID optimal location in Western NA Salt Lake City (SL) Los Angeles (LA) Oakland (O)
Q2: ID optimal location serving Western CAN• Salt Lake City• Toronto (T)• LA or O
Introduction
![Page 10: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/10.jpg)
Q1 & Q2: Global Approach
Salt Lake City USA (as is currently) CAN
Oakland USA (candidate) CAN
Los Angeles USA (candidate) CAN
Introduction
O
LA
SL
![Page 11: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/11.jpg)
Salt Lake City USA Toronto CAN
Oakland USA Toronto CAN
Los Angeles USA Toronto CAN
Introduction
O
LA
SL T
T
T
Q1 & Q2: Global Approach
![Page 12: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/12.jpg)
The Challenges, Specific
For location serving Western North America: Sizing of DC for peak inventory Impact to inventory, freight, transit time, & DC costs
For location serving Western CAN:• Sizing of DC to support customer demand• Associated costs for DC
Introduction
![Page 13: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/13.jpg)
Our Approach as a Team
Method
![Page 14: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/14.jpg)
Fundamental Phases
Plant to DC
Within DC
DC to Customer
Method
DC
DC
DC
![Page 15: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/15.jpg)
Fundamental Phases
Plant to DC
Within DC
DC to Customer
Method
DC
![Page 16: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/16.jpg)
Plant to DC
Method
DC
![Page 17: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/17.jpg)
Plant to DC
Method
DC
Shipping distance & rates/mile
![Page 18: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/18.jpg)
Plant to DC
Given factors:• Truck can drive 500
miles/day• Average of 40K
lbs/shipment• Ship combination of TL &
LTL• 100% of freight paid by
Plant
Assumptions:• Only ground freight usedMethod
DC
![Page 19: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/19.jpg)
Plant to DC: Inbound Trans.
Method & Model
![Page 20: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/20.jpg)
Fundamental Phases
Plant to DC
Within DC
DC to Customer
Method
DC
DC
DC
![Page 21: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/21.jpg)
Fundamental Phases
Plant to DC
Within DC
DC to CustomerDC
Method
![Page 22: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/22.jpg)
DC to Customer
Method
DC
![Page 23: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/23.jpg)
DC to Customer
Method
DC
![Page 24: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/24.jpg)
DC to Customer
Given factors:• Truck can drive 500 miles/day• Average of 25,000 lbs/shipment• Ship combination of LTL &TL• 100% OB freight paid by Plant• US DC serves US customer
Assumptions• No stop charges• Pallet weight includes tare & product
Method & Model
DC
![Page 25: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/25.jpg)
DC to Customer Model:
Method & Model
![Page 26: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/26.jpg)
Fundamental Phases
Plant to DC
Within DC
DC to Customer
DC
DC
DC
Method & Model
![Page 27: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/27.jpg)
Fundamental Phases
Plant to DC
Within DC
DC to Customer
DC
Method & Model
![Page 28: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/28.jpg)
Existing DC Costs
Method
DC
Size and costs for the two new candidates, LA and Oakland???
![Page 29: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/29.jpg)
DC “Costs”
Given factors:• Average 11 sq ft /pallet stored• Averages 1,500 lbs of product
per pallet in DC inventory• Average 9 turns/year for the
network ~40 days of Supply• Peak Inventory levels up to 12%
over the average level• Toronto is 100% utilized now• Candidate DC space costs for
LA & Oakland are given
Method & Model
DC
{ $6.25 per square foot for fixed{ $0.095 per lb for variable cost
![Page 30: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/30.jpg)
Size for the new DC inventory DC
![Page 31: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/31.jpg)
Modeling warehouse capacity
![Page 32: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/32.jpg)
Warehouse capacity (fast movers)
Convert in squared feet: Sf = 11/1,500 qf
![Page 33: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/33.jpg)
Warehouse capacity (s l o w m o v e r s)
Convert in squared feet: Ss = 11/1,500 qs
![Page 34: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/34.jpg)
DC Design & Justification
Unknowns, affecting stacking height:• Height of packed goods• Fragility of packed goods Stack a max of 3 high with block stacking
Unknowns, affecting configuration• Perishable items• ABC Control Breakdown • Slow vs. fast mover profile Block stacking for fast, Pallet rack for slow
Method & Model
![Page 35: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/35.jpg)
DC Facility Sizing Convention
40% Bulk/Reserve + Fast Pick • Fast movers – block stacking; Slow movers – pallet racks
60% Other storage support• Clearance, Aisles, Shipping/Receiving, Pallet & Vehicle Stow
Method & Model
Slow movers
Fast movers 3
3
S* = 246,000
![Page 36: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/36.jpg)
Toronto Extra Capacity Calculation
Method Options
Toronto is currently at full capacity Extra DC size calculated in sq ft: 44,554
DC fixed and variable costs calculated using only the extra space added to serve West CAN
![Page 37: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/37.jpg)
Salt Lake City New Option
Current DC size at SLC in sq ft: 500,000 New DC size calculated in sq ft: 246,000
Lease expires in 18 months SLC new option: Rent only ½ the current space
Advantages• No new hiring, training• No new scoping required• CODB known, unchanged• Laws and regulations known
Method Options
![Page 38: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/38.jpg)
OutcomesMethod & Model
Outcomes: Total Landed Costs
![Page 39: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/39.jpg)
Outcomes
Outcomes: Total Landed Costs
![Page 40: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/40.jpg)
Outcomes: Total Landed Costs by number of DCs
Outcomes
![Page 41: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/41.jpg)
Outcomes for Service Time
Outcomes
Computed Demand: 84% from US customers, 16% from Canadian customers
![Page 42: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/42.jpg)
Outcomes for ROI
Outcomes
![Page 43: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/43.jpg)
Summary
Computed Landed Costs Computed Service Times Two Options:
• LA US, Toronto Canada• SLC New US, Toronto Canada
“Solutions”
![Page 44: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/44.jpg)
Mfg Loc
DC Ex
DC Poss.
Cust. Base
Mfg
DC
To
Tu
SL
AT
NWAL
SL
SP
MC
MP
FW
O
LA
?
C
CC
CU
Introduction
![Page 45: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/45.jpg)
Mfg Loc
DC Ex
DC Poss.
Cust. Base
Mfg
DC
To
Tu
SL
AT
NWAL
SL
SP
MC
MP
FW
O
LA
?
C
CC
CU
Introduction
SL
![Page 46: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/46.jpg)
Considerations & Recommendations
Product life cycles and turnover Safety stock and demand variability
Load consolidation opportunities Other transportation alternatives
Opportunities for DCs in other locations Investigation into additional landed cost factors
External factors: workforce, unions, government, political unrest, regulations, CODB …
![Page 47: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/47.jpg)
Considerations & Recommendations
Size and orientation of racks and shelving Storage configuration profile: Selective racks,
push-backs, drive-through, block stacks, combo
Number and width and orientation of aisles Clearance height available within the building
Fast-pick areas, Storage and retrieval systems Special support areas, regional consideration
![Page 48: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/48.jpg)
PASI & Project Objectives
Apply concepts practically• Real-world problem• With interpretations assumptions & considerations
Collaborate across:• Cultures & Universities• Backgrounds & Perspectives
Experience & Enjoy!
![Page 49: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/49.jpg)
PASI & Project Objectives
Apply concepts practically• Real-world problem• With interpretations assumptions & considerations
Collaborate across:• Cultures & Universities• Backgrounds & Perspectives
+ Experience & Enjoy!
Thank You
Alice, Jorge
& PASI!!
![Page 50: P an American A lliance for S upply I mprovement: Beverly Kris Jaeger Alejandro MacCawley](https://reader034.vdocuments.us/reader034/viewer/2022051700/568162db550346895dd361f0/html5/thumbnails/50.jpg)
PASI Case 2 Data by PASIs