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

Bulgaria
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
 | 7 | 4 | 0.15 | 1 | 0.5 | 280.1098179297169 | 10955.40621236226
Average Personnel Costs | 1691.358835273585
Average gross salary p.p | 3734.797572396226
Severance Payments | 26174.70631987689
1.Expenses
 |  |  | 1.a. Severance Payments | 321 Petrom
 | 321 Petrom |  | BU |  |  |  |  |  | Displacements | Act. reduced by Displacement | Total | Savings | Severance Payments 321
Average Severance Payments | 26174.70631987689 |  |  | Actual FTE | Untaken holiday |  |  |  |  |  | Target FTE | FTE | EUR
Target FTE for Commercial | 14 |  | Commercial | 6 | 17 |  |  |  | 1 | 5 | 14 | -9 | -235572.356878892
Target FTE for Finace | 34 |  | Finance | 14 | 24 |  |  |  | 1 | 13 | 34 | -21 | -549668.8327174147
Target FTE for Retail | 39 |  | Retail | 29 | 25 |  |  |  | 1 | 28 | 39 | -11 | -287921.7695186458
Target FTE for Supply & Logistics | 9 |  | Supply & Logistics | 4 | 22 |  |  |  | 1 | 3 | 9 | -6 | -157048.2379192613
 |  |  | Total | 53 | 88 |  |  |  | 4 | 49 | 96 | -47 | -1230211.197034214
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 |  |  |  |  |  |  |  |  |  | -2799896.706357623
 |  |  | Commercial |  | -8 | 0 | 65113.87689203773 | 0 | -520911.0151363019 |  |  |  | -520911.0151363019
 |  |  | Finance |  | -20 | 0 | 65113.87689203773 | 0 | -1302277.537840755 |  |  |  | -1302277.537840755
 |  |  | Retail |  | -10 | 0 | 65113.87689203773 | 0 | -651138.7689203774 |  |  |  | -651138.7689203774
 |  |  | Supply & Logistics |  | -5 | 0 | 65113.87689203773 | 0 | -325569.3844601887 |  |  |  | -325569.3844601887
 |  |  | Additional Benefits | Average p.a. 321 in K EUR | Reduced FTE 321 |  |  |  |  |  |  |  | Total 321  Petrom
 |  |  | 2.b. Average IT costs p.a. (per employee) | 2247.840349471698 | -47 |  |  |  |  |  |  |  | -105648.4964251698
 |  |  | 2.c. Average office costs p.a. (per employee)
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 | 3734.797572396226 |  |  |  |  | 5378.108504250567
% 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 |  |  |  |  |  |  |  | -28150.09280524528
 |  |  | Telecommunications | 598.9381447924528 | -47 |  |  |  |  |  |  |  | -28150.09280524528
 |  |  | Company Cars
 |  |  | Other
 |  |  | 3. Relocation Savings