VSR Optimizer Cost and Constraints Calculations

[oscarmzvzz]

Planning costs using  VSR optimizer using Transportation Cockpit

In transportation Management planning and optimizing your resources is a crucial activity to make me most out of the VSR Optimizer functionality that SAP TM offers. In this particular post I would like to walk you to a very simple example of VSR planning optimization and most important which are the most important components that you need to configure in the system to get the correct cost estimations from the system.

First thing first, prior executing any planning, as usual, you will need certain Master data already created and maintained in the system. We will need at least the following

• Planning Profile


• VSR Opt Profile


• Means of Transports (In this case I will use FTL and LTL)


• Vehicle Resources


• Transportation Cockpit layout

(If you are unfamiliar with this last one, check out my previous blog of how to create this one Planning Cockpit in Transportation Management Design | SAP Blogs)

I will break this process into three steps:

1.- Define Cost and Constraints Settings  in SAP TM

2.-  Assign cost and Constraints into the Planning Profile in SAP TM

3.- Execute Planning in SAP TM

4.- Analyze planning result in Back End System

For the purpose of this exercise I will already have a few Freight units ready to be planned,  needless to say, all the following Screenshots were taken from my testing sandbox

For the reference Means of Transports will be referred as MoT

With this, we are good to go!

1.- Define Costs and Constrains settings

To kick off we need to define our cost and constraints settings, for this we use the SAP defined for that purpose:

1. 

Create Constraints

In this case I will give the following name S4TM2-COST-19.

After giving a header and a description to the Cost and Constraints settings we need to add our means of transports, in this case I am using:

• FTL and LTL

1. Fixed cost based on capacity documents and vehicles


2. Variable costs based on quantity and distance

For this example I want to set the following cost structure for my two means of transports:

a) Based on this I will add the fix costs according to my table:

b)  After this, we need to go to the detail of each Means of Transports to add the variable costs

1.1 Configure FTL MoT

It is very important to define my FTL line as No Quantity cost relevant, I'm interested about the distance not really the weight of the goods transported

FTL Settings

To make this last statement we define FTL  as distance relevant,charging1 EUR for each KM, likewise we define a max of 4 stops allowed (in case we want to do a consolidation for many customers) and an additional cost of 50 EUR per stop

1.2  Configure LTL MoT

Equally, as FTL we have defined already our fix cost, therefore, we need to add our variable costs

In this case we do define Quantity cost relevancy (0,05 EUR per KG)

Alike FTL, LTL will have no option for extra stops, and no price based on distance

LTL Settings

With this, we concluded our most complex step and we can move forward

2.- Assign costs and constrains to our planning profile

In order for our already defined cost constraints setting to be taken into account during planning we need to assign them to our planning profile as follows:

Fiory Tile for Planning profile

The place to store this will be in the lowest part of the screen

Edit Planning Profile

After completing this, we are ready to execute the planning.

3.- Execute planning on the Transportation Cockpit

For the planning we will always use the transportation cockpit fiory tile

It is very important to verify that we are choosing a cockpit layout wo which we assigned our cost and constraints settings. After doing this we can continue with our planning

For this example. I already created 6 SO with 6 FU ready to be planned with VSR Optimized

On the left you will see all my SO and FU, o  the right all my resources and lastly my created FO at the bottom, in this case I have no FO created yet.

Cockpit Data

TO start planning I will choose one single FU to be planned selecting that particular FU line and then running the VSR optimizer with all resources. Keep in mind that this FU has a total weight of 2055 KG we will use that for the analysis

VSR Running

After VSR finishes compiling we will se the result with a temporary FO number assigned, most importantly the system decided to use LTL resource for this option.

We will proceed to analyze this result in the back end system

4.- Analyze Planning Result

To analyze what happened during this calculation we use the following transaction in SAP back end system RCC_LOG

Once we open this we check the last run that we executed with our planning profile based on date

If we open that specific line we will be able to find our cost calculation

Can you relate where do these figures come from?

Here the analysis:

Total Costs are 106.75 EUR ( 102,75 EUR Qty costs and 4 Fixed cost) But why?

Cost analysis overview

If we look back at our LTL cost structure defined at the step 1

The fixed costs are 3 + 1= 4 EUR per capacity document and vehicle, in this case we only have 1 FO

To this amount we will ad the result of 0.05 EUR x KG remember what was our FU weight? That's right! 2055 kg therefore  we will get the amount of 102,75 EUR as QTY costs.

These calculation make sense, but what happen if we make it a bit more challenging and we optimize all out freight documents at once?

Let's check,!

Now in my optimizer I select all my documents:

VSR Optimizer

In this case 1 FO is created but for this time FTL resource is chosen

If we analyze again the cost strategy in the back end system we will get the following:

As you can see on the VSR optimizer calculations, it estimated the cost for both available resources LTL and FTL being FTL (the line above)

• LTL:729,33 EUR


• FTL:505,97 EUR.

FTL is then the chosen one because of the price being the most affordable with 505,97 EUR. Then again, where does this calculation comes from?

Let's check once more the original financial structure defined for FTL

We need to take as a departure point that FTL is based on distance, therefore the total distance that a vehicle needs to travel to visit all the scheduled stops is 390,97 KM

These is what VSR optimizer calculates in the background:

Fix Costs

Capacity Doc 10 EUR + Vehicle 5 EUR = 15 EUR

Variable Costs

390,97 x 1 EUR= 390,97 EUR

Two additional stops to visit all schedule stops:

50 EUR X 2= 100 EUR

Therefore 15+390,97+100= 505,97 EUR

5.- Wrap up and conclusions

As stated from the beginning, SAP TM provides a very powerful tool in VSR optimizer, this nevertheless needs to be feed with proper master data to work more efficiently. It's worth to be mentioned that this was a very simple example of how SAP TM calculates costs and constraints, in real life tough, there are multiple other variants that need to be taken into account, and the most important is to having them identified and defined in the system.

If you are keen or interested in further information about SAP TM planning functionalities I personally recommend consulting the SAP Learning journeys for Transportation Management Planning as well as joining the Learning room for further content.

SAP S/4HANA for Transportation Management Learning Room - Overview (sapjam.com)

I would really encourage you to share your thoughts about this post, any feedback or contribution is more than welcome. Happy to read your experiences with planning with VSR Optimizer