Finding the cheapest carrier using the “Low Cost Baseline” scenario
Talking about how sourcing optimization will make your life easier sounds fantastic in theory. But what does this look like in practice? Let’s find out by looking at a simple, real-world, example using the Keelvar Sourcing Optimizer.
Imagine that we are running an ocean freight event, and that we want to find the cheapest carrier, using merely the prices that they quoted. In other words, we will use sourcing software to find the cheapest carrier per lane, without any additional restrictions.
Our example assumes a standard ocean freight event design which has already been entered into the Keelvar platform.
The event consists of the following columns:
- A lane identifier column that uniquely identifies a given lane.
- A business unit column, which identifies the business unit that will be served by the given lane.
- An origin and destination column, which indicates the country from which the shipment originates, and the country to which the shipment is destined.
- An equipment type column which indicates the type of equipment to be shipped.
- Two columns which indicate shipment requirements: Direct Required (i.e. whether a direct or indirect shipment is required) and Max Transit Time (the maximum permissible time that it can take for the cargo to be shipped).
- 7 columns whose cells are to be completed by the carriers. These are our bidder input columns.
Carriers have already submitted their bids, so all that is left for you to do is use the sourcing optimizer to find the lowest-cost supplier. To do so, you need to use something called a “scenario” - basically a grouping of rules that the optimizer will use to translate and calculate the optimal results.
One of the major advantages of using a modern optimization esourcing software solution is that it lets you build and evaluate many different supplier awarding scenarios in minutes.
This scenario is called the “Low cost baseline” scenario, and its sole purpose is to calculate the cheapest supplier per lane. Let’s go ahead and “evaluate” this scenario. Pressing “evaluate” basically tells the optimizer to calculate a result. And that’s it! Once evaluated, all you need to do is click on the scenario and you will be able to see exactly which carrier won which lane below.
Too easy? How about limiting the total number of suppliers?
Granted, the previous example of finding the cheapest carrier was fairly straight-forward. The Keelvar Sourcing Optimizer had already created the low-cost baseline scenario for you, and all you had to do was press “evaluate”. You will argue that the “real world” isn’t that simple, that you have constraints and restrictions to consider and that just finding the cheapest supplier per lane can still be done fairly easily in Microsoft Excel. And you’re right! So that’s why we should create a second scenario, in which we take your constraints into account.
In this second scenario will assume that you have certain limits as to how many carriers you can service at a given time. For example, your ports or loading bays, may have a capacity restriction that makes it impossible for you to support more than two carriers. We may therefore want to find the cheapest carrier, but under the condition that we can support at most two carriers at a given moment in time.
Returning to the Keelvar platform, we must therefore add a new scenario to our ocean freight event. After having created a new scenario by simply pressing the “Add a scenario” button, we want to add a “Limit winners” rule.
This “limit winners rule” presents you with three primary choices:
- Which bidders to apply the rule to,
- Which lots to apply the rule to, and
- The number of permitted winners.
The rule may be applied to all bidders, or you may choose specific bidders, or bidders from a pre-defined bidder group. Next you must select which lots the rule will apply to, which may be all lots, a specific subset, or a pre-defined lot-group. Finally, you may limit the award to be at least, at most, or exactly a specific value. Within the context of this example, we want to configure the rule to “limit the number of winner for all bidders on all lots to at most 2”.
And once again, that's it. Once the rule has been added, your new scenario is ready for evaluation. All that you need to do next is press “evaluate” and observe the results.