airbus (werner) - analyzing liquidity with treasury cash management and liquidity planner
DESCRIPTION
Analyzing Liquidity with Treasury CashManagement and Liquidity PlannerSAP International Treasury Management ConferenceTRANSCRIPT
-
The Airbus Way
Analyzing Liquidity with Treasury Cash Management and Liquidity Planner
SAP International Treasury Management ConferenceThursday, June 25th 2009
-
The Airbus Way Page 2A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
AgendaWelcome to the world of Airbus
Objectives of Treasury-Reporting
Airbus Company-Presentation
SAP-R/3: TR-CM Liquidity-Forecasting
SAP-R/3: TR-CM Financial Status
SAP-R/3: Liquidity-PlannerSAP-BW: Reporting
-
The Airbus Way Page 3A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
300
200
100
400
500
600
3000 4000 5000 6000 7000 8000 9000 nm
Evolution of the Airbus family
reach
seatsA380
A321
A320
A319A318
Last deliveryA300-600 in July 2007
A300-600
A310
A340-600
A340-500
A340-300A330-300
A330-200
A350 XWB A350 XWB --900900
A350 XWB A350 XWB --800800
A350 XWB A350 XWB --10001000
Stand 31.Mai 2007
a world of innovation
Airbus designs, sells, builds and supports the most modern and comprehensive aircraft family in the world:
9,223 orders308 customers
5,616 delivered to date483 delivered in 2008
-
The Airbus Way Page 4A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Evolution of the Airbus family
The first Airbus aircraft The first twin engine widebody The first civil aircraft with a forward-facing two man cockpitThe first civil aircraft with composites in secondary, and then primary structures The first civil aircraft to feature drag reducing wing tip devices
The A300/A310 FamilyStrong foundations from which to grow
a world of innovation
-
The Airbus Way Page 5A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
The worlds best selling aircraft familyThe widest single-aisle aircraftThe first civil aircraft with full fly-by-wire and side stick controlThe lowest operating cost and highest residual values in its classThe only business jet certified for public transport The first civil aircraft to have a composite tailplane and flaps
Evolution of the Airbus family
The A320 FamilyThe versatile answer for profitability
a world of innovation
-
The Airbus Way Page 6A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
The most technologically advanced and fuel efficient civil aircraft on the marketThe most spacious and quiet cabinsThe first civil aircraft with a composite rear pressure bulkhead and keel beam (A340)60% advanced materials (A350 XWB)
The A330/A340/A350 FamilyThe most comfortable cabin in the sky
Evolution of the Airbus familya world of innovation
-
The Airbus Way Page 7A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Evolution of the Airbus family
The A380 FamilyThe flagship of the 21st century
Airbus response to growing demands on transportThe most spacious and comfortable cabin availableThe most technologically advanced aircraft in commercial production todayThe first civil aircraft structure to incorporate 25% composites The highest level of environmental performance in its classNew hydraulic electric system
a world of innovation
-
The Airbus Way Page 8A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Toulouse
Dublin BrusselsMoscow
Dubai New Delhi
Singapore
Sydneyregional officessubsidiaries
Airbus Americas
AirbusChina
AirbusJapan
250 field service offices11 engineering centres5 spares centres 4 training centres
Airbus is a global company47600 employees worldwide, some 80 nationalities
a world of cultural diversity
FALTianjin
-
The Airbus Way Page 9A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
G E R M A N Y
S P A IN
F R A N C E
U N IT E DK IN G D O M
Illescas
Puerto Real
Madrid
ToulouseToulouse
BroughtonFilton
Final Assembly Line
12 sites in Europe
St NazaireNantes
Stade
BuxtehudeBremenHamburgHamburg
Rooted in Europea world of cultural diversity
-
The Airbus Way Page 10A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
AgendaWelcome to the world of Airbus
Objectives of Treasury-Reporting
Airbus Company-Presentation
SAP-R/3: TR-CM Liquidity-Forecasting
SAP-R/3: TR-CM Financial Status
SAP-R/3: Liquidity-PlannerSAP-BW: Reporting
-
The Airbus Way Page 11A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Objectives of Cash-Management-Project at AGE
Enhancement of treasury-reporting regarding
method (using SAP-Integration), quality (based on already existing data) transparancy (usage and sources on
controlling-level)and analysis of variances to plan pilot for european companies
-
The Airbus Way Page 12A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Data-sources for forecasting
In
At Cost
Non At Cost
others
Types
BankStatement
BankStatement
BankStatement
Plan-Position
Plan-Position
Invoice
Out
Procured
HR
Tax
others
Types
BankStatement
BankStatement
BankStatement
BankStatement
P2P ProcessPayment-
runInvoiceP/OPreReque
Plan-Position
Plan-Position
Payment-run
manuellPayment
manuellPayment
Plan-Position
-
The Airbus Way Page 13A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Treasury Applications from SAP
-
The Airbus Way Page 14A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Solutions in SAP R/3
BankStatement
P2P ProcessPayment-
runInvoiceP/OPreReque
Actual Cash Analyses G/LAccountInterim
AccountsP/O
SupplierPreRequeSupplier
Liquidity Planner(SAP-R/3-Module LQP)
is analysing backward
BankAccounts
Treasury-Cash-Management(SAP-R/3-Module TR-CM)
Liquidity Forecast
Cash Positions
SuppliersVendors
P/OSupplier
InterimAccounts
PreRequeSupplier
is looking forward
BankAccounts
-
The Airbus Way Page 15A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
AgendaWelcome to the world of Airbus
Objectives of Treasury-Reporting
Airbus Company-Presentation
SAP-R/3: TR-CM Liquidity-Forecasting
SAP-R/3: TR-CM Financial Status
SAP-R/3: Liquidity-PlannerSAP-BW: Reporting
-
The Airbus Way Page 16A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
SAP-R/3 Treasury Cash-Management Liquidity Forecast
Shows the movements of the personal accounts (customers and vendors)
Drilldown to line item (e. g. Prereques, P/O, open items)
Planned items can be add
Flexible structure
FI-base: payment terms or payment history
Blocked Invoices by blocking reason
-
The Airbus Way Page 17A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
SAP-R/3 Treasury Cash-Management Liquidity ForecastExample: Liquidity-Forecast
Example: Drill-down to P/O (MM)
Example: Liquidity-Forecast by currency
Example: Blocked invoices
-
The Airbus Way Page 18A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
AgendaWelcome to the world of Airbus
Objectives of Treasury-Reporting
Airbus Company-Presentation
SAP-R/3: TR-CM Liquidity-Forecasting
SAP-R/3: TR-CM Financial Status
SAP-R/3: Liquidity-PlannerSAP-BW: Reporting
-
The Airbus Way Page 19A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
SAP-R/3 Treasury Cash-Management Financial Status
Shows the movements of the bank accounts or other cash related G/L accounts (e. g. interim-accounts)
Drilldown to line item
Planned items can be add
Flexible structure
In local and foreign currency
-
The Airbus Way Page 20A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
SAP-R/3 Treasury Cash-Management Financial Status
Example: Daily financial status
Example: ... by currency
Example: ... by banks
-
The Airbus Way Page 21A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
AgendaWelcome to the world of Airbus
Objectives of Treasury-Reporting
Airbus Company-Presentation
SAP-R/3: TR-CM Liquidity-Forecasting
SAP-R/3: TR-CM Financial Status
SAP-R/3: Liquidity-PlannerSAP-BW: Reporting
-
The Airbus Way Page 22A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Liquidity Planner in SAP R/3
1. Mapping based on informations from bank statement Interpretation of information from (MT940)-data-fields E. g. value, posting-text, usage, applicant, etc.
2. Mapping based on informations from SAP FI Backtracking of document-chain Interpretation based on Supplier/Vendor-Accounts
3. Mapping based on informations from invoice Backtracking of document-chain Interpretation based on G/L-Accounts
Increasing level of detail
-
The Airbus Way Page 23A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Liquidity Planner in SAP R/3 cash positionsCash out Cash in
-
The Airbus Way Page 24A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Liquidity Planner in SAP R/3 allocation-basis
-
The Airbus Way Page 25A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Liquidity Planner in SAP R/3 payment-chains
LIA 3rd Dom 19231200
11610000
19231500 11844100
19212500REC 3rd Dom 1923300 19231500 11844100
LIA IC EUR 1200200 11610000
REC IC EUR 1200200 11610000Bank-StatementIntercompany-
Bank (EADS EUR)
Payment-Run
1161000019212500
Bank-StatementIntercompany-
Bank (EADS EUR)
Bank-StatementCommercial-Banks
Commercial-Bank Cashpooling
-
The Airbus Way Page 26A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Liquidity Planner in SAP R/3 payment-chains
LIA 3rd USD
REC 3rd USD
Payment-Run
LIA IC USD
REC IC USD
19230601
19233000
Bank-StatementCommercial-Banks
1200100
1200100
Bank-StatementIntercompany-
Bank (EADS USD)
11844400
11844400
Commercial-Bank Cashpooling
Bank-StatementIntercompany-
Bank (EADS USD)
19212505
19212505
Zero Balancing
11610005
11610005
11610005
11610005
11610000
11610000
11610000
11610000
Bank-StatementIntercompany-
Bank (EADS EUR)
19212100
19212100
19212100
19212100
-
The Airbus Way Page 27A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Liquidity Planner in SAP R/3 Allocation
Masterdata and customizing
Movement-data
-
The Airbus Way Page 28A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Liquidity Planner in SAP R/3 Reporting
-
The Airbus Way Page 29A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
AgendaWelcome to the world of Airbus
Objectives of Treasury-Reporting
Airbus Company-Presentation
SAP-R/3: TR-CM Liquidity-Forecasting
SAP-R/3: TR-CM Financial Status
SAP-R/3: Liquidity-PlannerSAP-BW: Reporting
-
The Airbus Way Page 30A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Back-tracking of document chain
Cash-Flows (inflows/outflows)
paymentDocument
(customer/vendor) Invoice(G/L-account)
Document line items(cost-accounting-object,
Classification)
Dividing levels of Liquidity-Planner
FI-documentfor the
bank-statement(BTC-Code)
Dividing levels of AGE-solution
-
The Airbus Way Page 31A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Reporting requirements of controlling
-
The Airbus Way Page 32A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Liquidity Planner in BW Reporting
TR-CM
Liquidity Forecast
Cash Positions
Blocked Invoices
R/3
Actual Cash Analyses
Liquidity Planner R/3
Actual Cash Analyses
8-Week-Forecast
Combi
BW
Extractor:
Master-Data-PreReques-P/Os-Invoices-Supplier-Vendor-G/L-Account-Assets-HMGs-CPN/PSP-Function-View-...
Grouping-Disposition-Group-Cash-Position-Translation
Modification-Cash-Calendar-Data recall facility(CO and Doc. Chain)
Movement-Data
-
The Airbus Way Page 33A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Thank youfor your attention
Please visit www.airbus.com for more information
Beate Werner MBA University of WalesAirbus Operations GmbHFinancial Management Information and Treasury Support GermanyE-mail: [email protected]
-
The Airbus Way Page 34A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
Time Schedule
-
The Airbus Way Page 35A
I
R
B
U
S
S
.
A
.
S
.
A
l
l
r
i
g
h
t
s
r
e
s
e
r
v
e
d
.
C
o
n
f
i
d
e
n
t
i
a
l
a
n
d
p
r
o
p
r
i
e
t
a
r
y
d
o
c
u
m
e
n
t
.
AIRBUS S.A.S. All rights reserved. Confidential and proprietary document.
This document and all information contained herein is the sole property of AIRBUS S.A.S.. No intellectual property rights are granted by the delivery of this document or the disclosure of its content. This document shall not be reproduced or disclosed to a third party without the express written consent of AIRBUS S.A.S. This document and its content shall not be used for any purpose other than that for which it is supplied.
The statements made herein do not constitute an offer. They are based on the mentioned assumptions and are expressed in good faith. Where the supporting grounds for these statements are not shown, AIRBUS S.A.S. will be pleased to explain the basis thereof.
AIRBUS, its logo, A300, A310, A318, A319, A320, A321, A330, A340, A350, A380, A400M are registered trademarks.