Objective and use

MTP stands for Mid Term Planning. It is the new process replacing the budget for Novecare and Special Chem.

The MTP is managed by Quarter and on a horizon until Y+4.

Link to Novecare wiki page on MTP process

Link to Special Chem wiki page on MTP process

User Models

List of the key user models to use in the Budget Process in Dynasys (for instance, to activate the exports, read only mode, etc.) → “Budget - Data Table”

MTP

The data used for the MTP are stored in the specific User Model MTP

Novecare MTP Process

The MTP Process for Novecare was modified in 2022 to enable the sales manager's to have the ability to update not only volume, but price and unit contribution margin. Previously, the sales managers only updated volume while the controllers updated price and unit contribution margin.

Key MTP Users

Controllers (Role: NOVECARE - CONTROLLING)
1. Andrea Bandeira (andrea.bandeira@solvay.com) ; IPS and COATINGS
2. Florent Bourachot (florent.bourachot@solvay.com) ; AGRO
3. Jiafen (Larissa) Wang (larissa.wang@solvay.com) ; AMINES and HPC
Sales Managers

MTP Steps

Modify the security to the xNVXX workspaces: All Novecare MTP processing takes place using the web xNVXX workspaces.
1. Prior to the start of the MTP process, the controllers will decide when to open the workspaces and how to initialize the data.
2. The sales managers will update the MTP data using the xNVXX workspaces.
3. The controllers will update the MTP data remotely using the NOVECARE - xA10 MTP Review [CONTROLLER] workspace.
Initialize the MTP volume, price, and unit contribution margin
1. There are several calculations to initialize the MTP volume:
  1. MTP | 090. [CS, Past + Current Year] Feed MTP by Actuals + Final Forecast → this automatic assignment calculation will set the Initial MTP (ETD) data field in the past and the current year to the value from the Invoiced History and Final Forecast (ETD) data field
  2. MTP | Feed Initial MTP with MTP Review → this manual assignment calculation will set the Initial MTP (ETD) data field for Y+2 and Y+3 to the value from the MTP Review data field
  3. MTP | Feed Initial MTP (ETD) [Y+4, CS] → this manual calculation uses the translation on the horizon rule base to set the Initial MTP (ETD) data field for Y+4 to the value from the MTP Review data field
  4. MTP | Initialisation [CS] Feed Initial MTP (ETD) → this manual generic multiplication calculation sets the Initial MTP (ETD) data field for the entire horizon by multiplying the Invoiced history and Final Forecast (ETD) data field by the MTP Growth Rate data field
2. The Initial MTP Price data field is calculated with the following:
  1. MTP | Initialisation -[CS] Feed Initial MTP Price & Unit iCM → this automatic assignment calculation will set the Initial MTP Price for the entire horizon with the Net price from invoiced history data field
3. The Initial MTP Unit Contribution Margin data field is calculated with the following:
  1. MTP | Initialisation -[CS] Feed Initial MTP Price & Unit iCM → this automatic assignment calculation will set the Initial MTP Unit Contribution Margin for the entire horizon with the Est. Unit iCM from history data field
Copy sales team MTP data fields to MTP Review data fields
1. Once the sales team have completed data entry, the sales team data figures are copied to the MTP Review data fields. This is done by executing the following calculation: MTP | 040. Feed MTP Review [CS, Y+1, end]
2. At this time the security of the Sales Team xNVXX web workspaces is modified. All sales team personnel should be locked out of making any further MTP changes.
The controllers now have the ability to update the MTP Review, MTP Price Review, and the MTP Review Unit Contribution Margin using the remote workspace
Validate the MTP volume, price, and unit contribution margin
1. Once the controllers have finished the MTP Review data fields are validated and sent to DiP.
2. Validation calculation is as follows: MTP | 050. Validate MTP [Y+1, end, CS]

User Models

z.Contribution Margin
z. MTP / Commerical RoadMap
Y. GBU - NOVECARE

Forcing Loops (MTP Review / MTP Price / MTP Unit CM)

MTP Review (Volume)

SBS - DynaSys Team - Techno > z. MTP Process > Screenshot 2022-09-06 2.46.10 PM.png

MTP Price

SBS - DynaSys Team - Techno > z. MTP Process > Screenshot 2022-09-06 2.42.05 PM.png

MTP Unit CM

SBS - DynaSys Team - Techno > z. MTP Process > Screenshot 2022-09-06 2.42.35 PM.png

MTP to Budget

The MTP Review and MTP is converted from Quarter by Month based on the Y-1 Actuals (Invoiced History + Final Forecast (ETD)

SBS - DynaSys Team - Techno > z. MTP Process > image2021-8-13_14-50-12.png

Budget Review Freeze

The DP Team has to check manually and block the year that will be impacted by the Budget Process for Year+1.

Budget at CommercialProduct-ShiptoKA-Country@BU [CS]

This budget is sent by the Finance Department by quarter (not by month). However, The DP Team usually works on the Budget by DFU.
So, the DP Team has to mass upload the information sent by the Finance Department. The data will be automatically calculated by month (divided by 4). Then, it will be disaggregated at the DFU level.
The disaggregation is done thanks to the coefficients (calculated automatically by Dynasys depending on the data that already exists for the statistical forecast) in the “Budget Upload Coefficient”.

For the item: The weight of each DFU in comparison to the historical data (historical percentage) is taken into account
For the horizon: The seasonality and the sales trend in comparison to the historical data is taken into account