Finding the cheapest carrier using the “Low Cost Baseline” scenario
What does sourcing optimization with Keelvar’s Sourcing Optimizer look like in practice? Let’s find out by going back to our example of running an ocean freight event. In this instance, you want to find the cheapest carrier based only on the prices submitted, without any additional restrictions.
The event has already been set up in Sourcing Optimizer and will consist 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’s left for you to do is use the sourcing optimizer to find the lowest-cost supplier. To do so, you use something called a “scenario”: a grouping of rules that the optimizer uses 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. Its only purpose is to calculate the cheapest supplier for each lane. Once you press “evaluate”, the Sourcing Optimizer calculates a result and you’ll be able to see exactly which carrier won which lane.
When comparing carrier bids, the analysis can include more than a single freight rate. Supplier submissions may contain freight charges, handling charges, documentation fees, transit times and other relevant commercial or service information. These bid-side inputs can then be evaluated alongside the buyer’s own award rules and constraints when modelling scenarios.
Sourcing optimization with real-world constraints
The first example is straightforward. Finding the cheapest carrier per lane could still be managed in Excel. However, the real world gets more complicated when you introduce constraints.
In this scenario, let’s assume your ports or loading bays have a capacity restriction and can’t support more than two carriers at a time. You still want the cheapest carrier, but under the condition that two carriers can be supported at a given moment in time.
Returning to the Keelvar Sourcing Optimizer platform, you can meet this challenge by adding a new scenario to your ocean freight event. To do this, create a new scenario by simply pressing the “Add a scenario” button. As a next step, you can 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. In this example, your procurement team would configure the rule to “limit the number of winners for all bidders on all lots to at most 2”.
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.