RoadyMayhem
2015-06-28 10:06:58 UTC
Hi all,
I been puzzling for quite some time now on the following problem, but I
can't find a correct solution. I hope anyone in this group can help.
my problem:
1: A truck collects goods from a plant (A) and delivers the goods at a
destination (Z). The route the truck takes is called a 'lane'.
A lane has a cost.
So, in a table I would have a record for LaneID, Start, End, Cost
2: However, it is also possible that a truck goes from A to (second
plant) B, before it delivers the goods at destination Z.
The lane is now A --> B --> Z.
The cost for this lane is of course less than the sum of lanes A--> B +
B --> Z.
3: To make is even more complicated, it is also possible that a truck
collects the goods at A, collects more goods at B, delivers a group of
goods at Y and delevers the rest at Z.
This lane would consist of A --> B, B --> Y, Y --> Z.
4: Three destinations is also possible in different ways:
A --> X, X --> Y, Y --> Z.
A --> B, B --> X, X --> Y, Y --> Z.
All described lanes have different prices, other than the sum of the
'sublanes'. In my table (and probable related table) each lane should
have a unique identifier and a price, to make it possible to refer to a
lane when a truck takes the same route.
In the reporting I want to be able to calculate the cost for each
ordered and delivered good as a percentage of the lane cost.
I hope you understand my problem and am open to any suggestions or help.
Thanks in advance,
Sybolt
I been puzzling for quite some time now on the following problem, but I
can't find a correct solution. I hope anyone in this group can help.
my problem:
1: A truck collects goods from a plant (A) and delivers the goods at a
destination (Z). The route the truck takes is called a 'lane'.
A lane has a cost.
So, in a table I would have a record for LaneID, Start, End, Cost
2: However, it is also possible that a truck goes from A to (second
plant) B, before it delivers the goods at destination Z.
The lane is now A --> B --> Z.
The cost for this lane is of course less than the sum of lanes A--> B +
B --> Z.
3: To make is even more complicated, it is also possible that a truck
collects the goods at A, collects more goods at B, delivers a group of
goods at Y and delevers the rest at Z.
This lane would consist of A --> B, B --> Y, Y --> Z.
4: Three destinations is also possible in different ways:
A --> X, X --> Y, Y --> Z.
A --> B, B --> X, X --> Y, Y --> Z.
All described lanes have different prices, other than the sum of the
'sublanes'. In my table (and probable related table) each lane should
have a unique identifier and a price, to make it possible to refer to a
lane when a truck takes the same route.
In the reporting I want to be able to calculate the cost for each
ordered and delivered good as a percentage of the lane cost.
I hope you understand my problem and am open to any suggestions or help.
Thanks in advance,
Sybolt