312
3 DEVELOPMENT OF THE COST SIMULATOR
This paper presents a simulator of internal and ex-
ternal costs which also allows updating data. In or-
der to design the simulation model, the behavior of
freight distribution systems must be known. Road
haulage, port operation and maritime leg must be
modeled to assign costs derived from each of the
parts or components of the logistic chain.
The calculation method of overall costs (in €)
have been calculated considering a single variable
(Gross Tonnage) for all transport modes.
Figure 1.Example of logarithmical ratio between fuel costs and
gross tonnage (GT). Source: Own
Time (in hours) spent by the modes of transport
to move freight between an origin and a destination
will strongly depend upon the physical and operation
speed of the modes employed. Calculations consider
European road transport regulations on driving times
and costs of road freight transport.
Data of truck internal costs will be obtained by
analyzing a set of model trucks specified by the
Ministry of Public Works and for vessels, Short Sea
Shipping Ro-Ro ships are ships employed in Medi-
terranean maritime routes.
All required data is computed by an engine gen-
erated by an Excel spreadsheet and a computer pro-
gram complied in Visual Basic, and then presented
in tables and graphs.
After we have introduced all required data, the
methodology used by de simulator can be summa-
rized by the following steps:
1 Choose data from the destination matrix and find
out whether there is a destination for the selected
route.
2 Choose data from the origin matrix and find out
whether there is an origin for the selected route.
3 Choose data from the maritime distance matrix.
4 Introduce ship occupancy rate (σ).
5 Introduce type of freight (σ).
6 Introduce the number of stops made by the ship in
each trip (ρ).
7 Introduce specific company profits as a payment
for ship services (β).
8 Print and display all solutions for the selected
ship (calculation of Short Sea Shipping and only
road transport costs and pollutant emission costs).
9 Choose the three best ships for the selected route
from the simulator’s database and provide their
particulars (ship’s name, year of building, length,
breath, tonnage, lane meters, power, speed and
number of platforms).
10 Perform routines under the established formula-
tion.
All data are interpreted by means of tables, charts
and mask designed for the presentation of simulator
data.
Figure 2. Example of the mask showing parameters to be se-
lected before the calculation process and results of external and
internal costs. Source: Own
4 PRELIMINARY RESULTS EXAMPLE FROM
THE COSTS SIMULATOR
Once we have designed the costs simulator, we have
analyzed routes between Spain and the Black Sea
region, considering the imminent entrance of candi-
date East and Middle European countries into the
European Union. Trade operations with all these
countries open the door to two big markets: Central
Asia and the Middle East. The number of volumes
exchanged between Spain and the Black Sea Region
shows and upward trend. The total volume of ex-
ports and imports between Spain and the Black Sea
region is approximately 3,941,806.1 and
24,898,406.1 tons, respectively, value that justifies
the management of a trade route between both re-
gions. The data were obtained from figures regard-
ing Spanish import and export operations with Bul-
garia, Georgia, Romania, Russia, Turkey and
Ukraine, although the countries with the highest
number of exchanges with Spain are Greece, Tur-
key, Russia and Ukraine.