You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »



Macro-Package Team

Macro-Package Owner: Claudia Clark
Global Fleet Manager: Sander Ripmeester

Procurement Partner: Frederico Henriques

Finance Partner: Maryse Persehaie


Car Fleet dashboard is owned by Procurement

Target Users

  • ELT members
    Procurement (Car Fleet Buyers)
    Macro-Package core team
    Global controlling
    Fleet Management team
    HR country managers


  • GBU/F Head, GBU/F Finance Director, GBU/F Global Controller
    GBU LT upon request
    GBU MP co-owner

Authorization & Rights

Accesses must be approved by the Macro-Package Team (Procurement)

Click here for the Access request form.

 

General Description

Objectives:

This dashboard is result of a Fuel for Growth initiative and therefore has been built to increase transparency on Car Fleet Operational KPIs.

The objective of this Dashboard is to allow concerned stakeholders (GBU/Functions, Controlling, Finance, Procurement, HR, Fleet Management, Macro Package Team) to find relevant information about the latest state and evolution of their car fleet to:

  • Manage fleet
  • Control cost
  • Monitor policy compliance
  • Benchmark KPIs between Solvay entities & locations
  • Monitor sustainability impact against Solvay One Planet goals
  • Identify and size improvement and savings opportunities


It has been built using 3 different data sources:

  • Costa (cost)
  • Fleet Mgt Companies: ARI and Dragintra for NAM and EMEA (op & compliance KPIs)
  • Manual data inputs for smaller fleet countries (operational & compliance KPIs)
A Quick Start Guide is available here


Structure & Content:

4 pages for users + 1 page (data checking) for dashboard management team



Content of each page: 







Data Sources

3 sources of data are feeding the dashboard:
  1. Vendors data (Fleet Management Companies)
    • ARI for USA and Canada
    • Dragintra for Belgium, France, Italy, Germany, UK, Spain, Portugal
  2. Costa dashboard (query BW xxxx)
  3. Manual imput from different local sources for countries not covered by ARI or Dragintra.


Useful information about data:

  • data is refreshed monthly (D10-15)
  • dashboard data is in EUR currency
  • There are some access restrictions to employee level information in accordance to GDPR regulation: pages view is restricted to your GBU/F except the executive summary page
  • The Macro-Package team is working on improving the quality of the source data displayed in the dashboard will improve month after month in consequence, thank  you for your patience and understanding

Period of Analysis

  • Current year to date
  • Year - 1
  • Current month mapping
  • By month, by quarter


Dimensions

Dimension Description
Finance -Controlling (BW)
Expenses
(Concur)
Booking
(AmexGBT)
Comments
GBU / Function
X
X
X

Sub GBU/Function
X
X


Company (name - code)
X
X


Region
X
X
X
Origin region of expense
Country
(country of employee)
X
(Company Country)
X
(Country of Employee)
X
(Country Point of Sale)

Hotel/Car rental Country


X

Hotel/Car rental City


X

Cost Center
X
X

No cost center for Cytec Concur
Year
X
X
X

Quarter
X
X
X

Month
X
X
X

Reference date
Posting Date
Send for Payment date
Booking date

Vendor Name
X

X
Airline or Railway company
Expense Type (Cluster)

X


Trip Purpose


X

Trip Duration


X

Employee Name

X
X (Traveler Name)

Booking Channel (Online/Offline)


X
Online or Offline
Compliance on advance purchase (Yes/No)


X

Lowest Logical Fare Adoption (Yes/No)


X

Primary Product Code


X
Air- Rail - Car - Hotel
Domestic or Regional/International


X

Class of Service


X
Booking class (Explain FIRST vs FIRST US & others) for Air/Rail
Car type for Rental
Frequent traveler


X
travelers with an average of more than 2 bookings per month (air and/or rail)
SLT

X
X
travelers part of Solvay Leadership Team (to Do)
O&D Net Amount


X
allow to filter above certain ticket amount



Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels