Spreadsheet: 113301d1309263437-calculate-the-discounted-cash-flow-and-net-present-value-business-case-omv-petrom-v1
Sheet: Assumptions RO

Romania
General Assumptions
 | Average years  of service | Compensation for a Length of service  of 5 to 15 years | Percentage of gross salary to  be payed as MBO | Number of gross salaries | Value of gross salary  to be  payed as MBO | MBO payments | Untaken holiday  days payments
 | 11 | 6688.97 | 0.15 | 1 | 0.5 | 879.0665387678572 | 34381.26907180953
Average Personnel Costs | 13458.68776267143
Average gross salary p.p | 11720.88718357143
Severance Payments | 41949.30561057739
1.Expenses
 |  |  | 1.a. Severance Payments | 321 Petrom
 | 321 Petrom |  | BU |  |  |  |  |  | Displacements | Act. reduced by Displacement | Total | Savings | Severance Payments 321
Average Severance Payments | 41949.30561057739 |  |  | Actual FTE | Untaken holiday |  |  |  |  |  | Target FTE | FTE | EUR
Target FTE for Commercial | 14 |  | Commercial | 6 | 23 |  |  |  | 1 | 5 | 14 | -9 | -377543.7504951965
Target FTE for Finace | 34 |  | Finance | 14 | 22 |  |  |  | 1 | 13 | 34 | -21 | -880935.4178221251
Target FTE for Retail | 39 |  | Retail | 18 | 23 |  |  |  | 1 | 17 | 39 | -22 | -922884.7234327025
Target FTE for Supply & Logistics | 9 |  | Supply & Logistics | 4 | 20 |  |  |  | 1 | 3 | 9 | -6 | -251695.8336634643
 |  |  | Total | 42 | 88 |  |  |  | 4 | 38 | 96 | -58 | -2433059.725413489
Recruiting Costs Estimations |  |  |  | Costs 321 Petrom | Replacements FTE 321 Petrom |  |  |  |  |  |  |  | Total 321  Petrom
Months of Salary (EUR) |  |  | 1.b. Recruiting Costs per Person 321 | 0 | 9.600000000000001 |  |  |  |  |  |  |  | 0
Salary Average 321 Petrom
Relocation Costs Estimations | 321 Petrom |  |  | Costs p.a. | Years | Relocated |  |  |  |  |  |  | Total 321  Petrom
Costs p.a (EUR) | 35981.34341755 |  | 1.c. Relocation Costs | 35981.34341755 | 1 | 4 |  |  |  |  |  |  | 143925.3736702
Years to pay | 1
Other costs | 321 Petrom |  |  |  |  |  |  |  |  |  |  |  | Total 321  Petrom
External Consulting Costs |  |  | 1.d. External Consulting Costs | 0 |  |  |  |  |  |  |  |  | 0
1.e. Internal Consulting Costs |  |  | 1.e. Internal Consulting Costs | 0 |  |  |  |  |  |  |  |  | 0
1.f.  Contingency Costs |  |  | 1.f.  Contingency Costs | 0 |  |  |  |  |  |  |  |  | 0
1.g  Other |  |  | 1.g  Other | 0 |  |  |  |  |  |  |  |  | 0
Years to pay |  |  | Total |  |  |  |  |  |  |  |  |  | 0
2. Benefits
 |  |  | 2.a. Salary Benefits
 |  |  | Business Unit | Mgt. Level | Employee Level | Annual Costs Mgt | Annual Costs Empl. | Savings Mgt | Savings Empl |  |  |  | Total Savings p.a.
 |  |  | Total |  |  |  |  |  |  |  |  |  | -16316364.56516537
 |  |  | Commercial |  | -8 | 0 | 302154.8993549143 | 0 | -2417239.194839315 |  |  |  | -2417239.194839315
 |  |  | Finance |  | -20 | 0 | 302154.8993549143 | 0 | -6043097.987098286 |  |  |  | -6043097.987098286
 |  |  | Retail |  | -21 | 0 | 302154.8993549143 | 0 | -6345252.886453201 |  |  |  | -6345252.886453201
 |  |  | Supply & Logistics |  | -5 | 0 | 302154.8993549143 | 0 | -1510774.496774571 |  |  |  | -1510774.496774571
 |  |  | Additional Benefits | Average p.a. 321 in K EUR | Reduced FTE 321 |  |  |  |  |  |  |  | Total 321  Petrom
 |  |  | 2.b. Average IT costs p.a. (per employee) | 20279.11719984286 | -58 |  |  |  |  |  |  |  | -1176188.797590886
 |  |  | 2.c. Average office costs p.a. (per employee) |  |  |  |  |  |  |  |  |  | 0
Savings for Replacements |  |  |  | Target Org | % of target org. to be replaced | Number of Replacement | % of Replacement Savings | Average Salary Costs
% of target org. to be replaced | 0.1 |  | 2.d. Savings for Replacements | 96 | 0.1 | 9.600000000000001 | 0.15 | 11720.88718357143 |  |  |  |  | 16878.07754434286
% of replacement savings | 0.15 |  |  | Savings 321 p.a. |  |  |  |  |  |  |  |  | Total 321  Petrom
 |  |  | 2.e. Purchasing |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Total 321  Petrom
 |  |  | 2.f. Other Savings | Average p.a. 321 Petrom in K EUR | Reduced FTE 321 Petrom |  |  |  |  |  |  |  | -74245.259556
 |  |  | Telecommunications | 1280.090682 | -58 |  |  |  |  |  |  |  | -74245.259556
 |  |  | Company Cars
 |  |  | Other
 |  |  | 3. Relocation Savings