Scenario building for logistic services: the fuel prize shock
DESIGNATION -Β Data Design with Business Relevance
Procurement Analytics Β· Scenario Planning
Contract volume scenario planner
250 trucks Β· Germany Β· contracted tonnes/month per customer group
Scenario A
Base case
1.75 β¬/L
Scenario B
Price shock
2.25 β¬/L
Retail
Supermarkets, discounters, food & beverage
Metric: tours / month
Scenario A
Est. tonnes
β
Trucks req.
β
Fuel cost/mo
β
Scenario B
Est. tonnes
β
Trucks req.
β
Fuel cost/mo
β
Industry
Manufacturing, automotive, chemicals, machinery
Metric: tonnes / month
Scenario A
Trucks req.
β
Fleet share
β
Fuel cost/mo
β
Scenario B
Trucks req.
β
Fleet share
β
Fuel cost/mo
β
Construction
Building materials, aggregates, steel, site logistics
Metric: tonnes / month
Scenario A
Trucks req.
β
Fleet share
β
Fuel cost/mo
β
Scenario B
Trucks req.
β
Fleet share
β
Fuel cost/mo
β
Scenario A β fleet summary
Total trucks req.
β
Fleet utilisation
β
Total fuel OPEX
β
Scenario B β fleet summary
Total trucks req.
β
Fleet utilisation
β
Total fuel OPEX
β
Scenario comparison β visual diff
Trucks required by group
A vs. B Β· out of 250 fleet
Scenario A
Scenario B
Fuel OPEX by group
Monthly cost Β· A vs. B Β· Kβ¬
Scenario A
Scenario B
Fleet capacity allocation
Trucks used per group Β· ceiling 250
Retail
Industry
Construction
Spare
This scenario planner is build within a website. You can get this inΒ specific applications (f.e. Power BI) as well.Β
Get in touch, if this sounds relevant.
We are glad to hear about your project.
Let us know if we can help and we come back how your project would look like. No long intake forms.
Mail to office @designation.eu
Β
