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

Moldova
General Assumptions
 | Average years  of service | Gross salaries to be payed | 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 | 6721.38882490738 | 0.15 | 1 | 0.5 | 106.1271919722218 | 3820.578910999985
Average Personnel Costs | 118.6773250379245
Average gross salary p.p | 1415.029226296291
Severance Payments | 10648.09492787959
1.Expenses
 |  |  | 1.a. Severance Payments | 321 Petrom
 | 321 Petrom |  | BU |  |  |  |  |  | Displacements | Act. reduced by Displacement | Total | Savings | Severance Payments 321
Average Severance Payments | 10648.09492787959 |  |  | Actual FTE | Untaken holiday |  |  |  |  |  | Target FTE | FTE | EUR
Target FTE for Commercial | 14 |  | Commercial | 6 | 0 |  |  |  | 1 | 5 | 14 | -9 | -95832.85435091628
Target FTE for Finace | 34 |  | Finance | 14 | 31 |  |  |  | 1 | 13 | 34 | -21 | -223609.9934854713
Target FTE for Retail | 39 |  | Retail | 18 | 29 |  |  |  | 1 | 17 | 39 | -22 | -234258.0884133509
Target FTE for Supply & Logistics | 9 |  | Supply & Logistics | 4 | 21 |  |  |  | 1 | 3 | 9 | -6 | -63888.56956727752
 |  |  | Total | 42 | 81 |  |  |  | 4 | 38 | 96 | -58 | -617589.5058170161
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 |  |  |  |  |  |  |  |  |  | -993841.8452645713
 |  |  | Commercial |  | -8 | 0 | 18404.47861601058 | 0 | -147235.8289280846 |  |  |  | -147235.8289280846
 |  |  | Finance |  | -20 | 0 | 18404.47861601058 | 0 | -368089.5723202116 |  |  |  | -368089.5723202116
 |  |  | Retail |  | -21 | 0 | 18404.47861601058 | 0 | -386494.0509362222 |  |  |  | -386494.0509362222
 |  |  | Supply & Logistics |  | -5 | 0 | 18404.47861601058 | 0 | -92022.39308005289 |  |  |  | -92022.39308005289
 |  |  | Additional Benefits | Average p.a. 321 Petrom in K EUR | Reduced FTE 321 |  |  |  |  |  |  |  | Total 321  Petrom
 |  |  | 2.b. Average IT costs p.a. (per employee) | 361.8437369897428 | -58 |  |  |  |  |  |  |  | -20986.93674540508
 |  |  | 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 | 1415.029226296291 |  |  |  |  | 2037.642085866659
% 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 |  |  |  |  |  |  |  | -10939.33356456957
 |  |  | Telecommunications costs | 188.6091993891305 | -58 |  |  |  |  |  |  |  | -10939.33356456957
 |  |  | Company Cars
 |  |  | Other
 |  |  | 3. Relocation Savings