Part II: Solution A pproach
5.4. The Two Phased Solution Approach
5.5.6. Cost of serving each route
In order to calculate the total cost of serving each route for the demand side of the three- layer dairy SC, formulas 5-7, 5-8 and 5-9 have been used. Average price of fuel in April/May 2012 has been 1.53€/lit and the average wage of a HGV drive at the same period of time has been 11.50 €/hr (Part II, Chapter Three). Tables 5.9, 5.10 and C.3 (Appendix C) depict the average Cost of serving routes and transporting products from plants to DCs, DCs to retailers, and in between retailers respectively. CO2 and cost estimations account for one refrigerated HGV in each route.
Chapter Five
115
Table 5.9 CO2 emission estimations and costs of serving route from DCs to retailers
DC to Customer
1.Drogheda 2.Dundalk 3.Navan 4.Tullamore 5.Naas 6.Newbridge 7.Leixlip 8.Port Laoise 9.Bray 10.Arklow 11.Wicklow 12.Greystones 13.Clonmel 14.Waterford 15.Tramore 16.Kilkenny 17.Wexford 18.Enniscorthy 19.Dublin City 20.Dun Laogh
a-
rire/Rathdawn 21.Fingal 22.South Dublin
a.
Dundalk
Average CO2 Emission from Fuel Burnt
jk p 30 2 47 116 99 118 83 153 108 153 145 116 236 229 241 200 209 197 75 85 64 92 Cost of Serving Path (€) jk c 26 2 33 86 58 83 53 108 76 108 98 82 166 161 168 140 147 129 53 60 45 65 b. Drogheda CO2 Emission from Fuel Burnt
jk p 2 31 24 102 79 83 44 132 68 118 112 76 209 202 214 155 182 137 46 58 27 57 Cost of Serving Path (€) jk c 2 26 20 72 56 61 32 93 48 74 79 54 147 143 151 100 128 125 28 41 22 47 c. Dublin City CO2 Emission from Fuel Burnt
jk p 46 75 47 92 33 46 16 87 20 65 58 28 164 151 163 113 121 109 2 13 19 19 Cost of Serving Path (€) jk c 28 53 28 65 25 32 12 61 14 48 48 21 21 115 97 105 71 72 80 2 10 14 14 d. Tullamore CO2 Emission from Fuel Burnt
jk p 101 116 77 2 59 52 80 31 108 122 108 115 114 128 140 76 134 114 92 103 106 79 Cost of Serving Path (€) jk c 72 86 54 2 49 43 56 23 79 90 79 85 84 80 74 56 99 84 65 75 75 50 e. Bray CO2 Emission from Fuel Burnt
jk p 68 108 70 108 44 56 34 96 2 47 40 6 173 167 157 123 102 90 20 9 39 28 Cost of Serving Path (€) jk c 48 76 49 79 26 37 24 68 2 34 33 5 122 118 115 60 78 55 14 7 29 17 f. Waterford CO2 Emission from Fuel Burnt
jk p 202 229 177 128 123 116 147 98 167 96 113 101 43 2 11 48 56 51 151 150 173 139 Cost of Serving Path (€) jk c 143 161 105 80 86 82 103 61 118 71 93 71 31 2 9 34 41 38 97 94 122 88
5.5.7. Green constraint data
The AHP constraint considers three types of trucks as preferred by the DM for trans- porting the products. Different levels of CO2 emission and costs are considered for each type of truck. DMs have been asked to compare these trucks types based on two attrib- utes: CO2 emission and cost. The outcome of this comparison is a pair-wise comparison matrix which is not related or dependant on the number of layers in the SC network.
Chapter Five 116 Phase -I Phase -II
Therefore, Tables 4.6, 4.7 and 4.8 depict all the data needed for the AHP constraint in the three-layer MO-LRP.
5.6. Solution Steps
Considering the efficiency of modeFRONTIER® in implementing the two-layer MO- LRP, the same platform is considered for implementing the three-layer MO-LRP. The two-phased solution method is developed using modeFRONTIER®. A schematic illus- tration of the consecutive steps of the solution approach is presented in Figure 5.8:
Transforming Phase-II into modeFRONTIER® workflow
and connecting the components of the model Results of Phase-I
Deploying of the optimisers, setting up the chosen optimisers and executing the Phase-I
Results of Phase-II
Transforming the quantified Phase-I into
modeFRONTIER® workflow and connecting the
components of the model
Introducing DoE to guide the chosen optimiser
- Open/Clo se DCs - Routes connectin g plants to open DCs - Routes connectin g open DCs to retailers
Deployment of the optimisers, setting up the chosen optimisers, and executing the model Introducing DoE to the guide the chosen optimiser
Analysing results of Phase-I
- Un-served retailers in Phase-I are served through served retailers in Phase-I
Implementing Phase-II based on Phase-I results
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
117
Figure 5.8 The process of implementing the three-layer MO-LRP using mode-
FRONTIER®
5.6.1. Transforming the three-layer MO-LRP into modeFRONTIER®
Phase-I and Phase-II of the three-layer MO-LRP are transformed into modeFRON- TIER®’s workflow. The logical designs of the two phases in modeFRONTIER® are presented disparately in Figures 5.9 and 5.10.
Figure 5.9 Phase-I of the three-layer MO-LRP design in modeFRONTIER®
Interpretation of results
- - Scenario analysis
- - Schematic presentation of results
Final results of the three-layer MO-LRP
- Open/close DCs
- Routes connecting plants to open DCs - Routes connecting open DCs to retailers
Chapter Five
118
Figure 5.10 Phase-II of the three-layer MO-LRP design in modeFRONTIER®
The design shown in Figure 5.10 is a general presentation of Phase-II. Based on each result from Phase-I, Phase-II is modified and solved. Graphically the design looks the same for all optimisers in both phases. The mathematical details of Phase-I and Phase-II are all satisfied in this designed workflow using modeFRONTIER®. The setting of each optimiser in modeFRONTIER® for both phases of the solution approach is identical. Hence, in the next two sections the details of DoE setting, and then the optimiser set- tings are explained for both phases.