1. Objective and Scope

1.1. Objective of this Operation

Working capital represents the capacity of the company's available cash flow that takes into account the combination and comparison of capital invested in Inventory, capital due to third parties (Suppliers) and Capital receivable from third parties (Customers). 

The sum of these three spheres in our Working Capital reflects the Free Capital generated from the turnover of operations.

1.2. Scope

This procedure applies to company 7523 

2. Definitions

See Finance Glossary:

• WP1
• LAM

3. Tasks description

This activity is performed every D+3

3.1. I do the extraction of the report 

On excel go the tab File

Click on the option Analysis 

Click on the Open Workbook option

Click to open options

Double click on the option "Open a workbook from the SAP Business Warehouse Platform"

Select BW - Production - WBP

Click Ok

Go to the Role tab

and open the folders:

1 -WCAP-Working CApital SOlvay Group
2- Accounting / Legal BFC view
3 - WC RCS BFC interface (Core Workbook)
(chose the query BW_WBK_CAP_0001) double click

Fill in the fields:

Calendar Day: with the last day of the month

Legal PRS Comp. Code: with the Company that is closing

get the information from 2 tabs:

1º - WC

2º FA Suppl. & Asset DP

Clique em Display 

Open the pivot

drag the BFC Activity 1 and 2 options to Columns

Before:

After:

Then click pause to not keep updating

Extract the information from the WC Tab to an excel

and do the same with the FA Suppl tab. & Asset DP.

Organize the file.

3.2. I do the updated of the file 

If in the line of activity 2 there is a column with a # and values, it will be necessary to pass those values to the column that precedes them and then exclude the column with the #

Before

After

Sum the lines using formulas

Do the same with the assets file following the topic 3.2 process

Then save the two files and send them by email to the list below:

Both, Georg <georg.both@solvay.com>

Gabriel Barreto-INTERN <gabriel.barreto-intern@solvay.com>,

Ricardo Verbitiskis <ricardo.verbitiskis@solvay.com>,

Cesar Gandolfi <cesar.gandolfi@solvay.com>,

Meri INOCENTE <meri.inocente@solvay.com>,

Eduardo Conigero <eduardo.conigero@solvay.com>,

Gabriel Varela Lino <gabriel.lino@solvay.com>,

Leandro Davanco <leandro.davanco@solvay.com>,

Bruno Sequii-EXTERNAL <bruno.sequii@solvay.com>,

Nicole Spinelli <nicole.spinelli@solvay.com>,

Douglas Machado <douglas.machado@solvay.com>,

Maria Ramos <maria.ramos@solvay.com>,

Eduardo Schubert <eduardo.schubert@solvay.com>,

Pablo Delapena <pablo.delapena@solvay.com>,

André Oliveira <andre.oliveira@solvay.com>

End of document.