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

Serbia
General Assumptions
 | Average years  of service | Applicable % | 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
 | 10 | 0.3 | 0.15 | 1 | 0.5 | 192.03358543875 | 9729.701662230002
Average Personnel Costs | 567.7451246571428
Average gross salary p.p | 2560.44780585
Severance Payments | 17603.07866521875
1.Expenses
 |  |  | 1.a. Severance Payments | 321 Petrom
 | 321 Petrom |  | BU |  |  |  |  |  | Displacements | Act. reduced by Displacement | Total | Savings | Severance Payments 321
Average Severance Payments | 17603.07866521875 |  |  | Actual FTE | Untaken holiday |  |  |  |  |  | Target FTE | FTE | EUR
Target FTE for Commercial | 14 |  | Commercial | 6 | 29 |  |  |  | 1 | 5 | 14 | -9 | -158427.7079869688
Target FTE for Finace | 34 |  | Finance | 14 | 26 |  |  |  | 1 | 13 | 34 | -21 | -369664.6519695938
Target FTE for Retail | 39 |  | Retail | 18 | 29 |  |  |  | 1 | 17 | 39 | -22 | -387267.7306348126
Target FTE for Supply & Logistics | 9 |  | Supply & Logistics | 4 | 30 |  |  |  | 1 | 3 | 9 | -6 | -105618.4719913125
 |  |  | Total | 42 | 114 |  |  |  | 4 | 38 | 96 | -58 | -1020978.562582688
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
1.d. 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 |  |  |  |  |  |  |  |  |  | -2027069.018968629
 |  |  | Commercial |  | -8 | 0 | 37538.31516608572 | 0 | -300306.5213286857 |  |  |  | -300306.5213286857
 |  |  | Finance |  | -20 | 0 | 37538.31516608572 | 0 | -750766.3033217144 |  |  |  | -750766.3033217144
 |  |  | Retail |  | -21 | 0 | 37538.31516608572 | 0 | -788304.6184878001 |  |  |  | -788304.6184878001
 |  |  | Supply & Logistics |  | -5 | 0 | 37538.31516608572 | 0 | -187691.5758304286 |  |  |  | -187691.5758304286
 |  |  | Additional Benefits | Average p.a. 321 Petrom  in K EUR | Reduced FTE  321 Petrom |  |  |  |  |  |  |  | Total 321  Petrom
 |  |  | 2.b. Average IT costs p.a. (per employee) | 1369.113944142857 | -58 |  |  |  |  |  |  |  | -79408.60876028572
 |  |  | 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 | 2560.44780585 |  |  |  |  | 3687.044840424001
% 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 |  |  |  |  |  |  |  | -34711.67249061429
 |  |  | Telecommunications | 598.477111907143 | -58 |  |  |  |  |  |  |  | -34711.67249061429
 |  |  | Company Cars
 |  |  | Other
 |  |  | 3. Relocation Savings