Edc Br030_hyperion_planning_v1.3.pdf

  • Uploaded by: Marwa Ghoz
  • 0
  • 0
  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Edc Br030_hyperion_planning_v1.3.pdf as PDF for free.

More details

  • Words: 12,241
  • Pages: 62
AIM

BR.030 BUSINESS REQUIREMENTS MAPPING FORM Egyptian Drilling Company Hyperion Planning

Author:

Oracle Hyperion Team

Creation Date:

February 20, 2012

Last Updated:

March 27, 2012

Document Ref:

EDC-HP-PLN

Version:

1.3

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Approvals:

Sherif Sameh Ali Hamed Hatem Azmy

Copy Number

Document Control

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

_____

(v.1.3) Company Confidential - For internal use only

ii

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Document Control Change Record 7

Date

Author

Version

Change Reference

20-2-2012 06-3-2012 08-3-2012 19-3-2012 27-3-2012

Mustafa Moussa Jitendra Bhadauria Mustafa Moussa Mustafa Moussa Mustafa Moussa

Draft 1a 1 1.1 1.2 1.3

No Previous Document Expenses Consolidate Reveiwed Final

Reviewers

Name

Position

Distribution

Copy No.

Name

Location

1 2 3 4

Library Master

Project Library Project Manager

Note To Holders: If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

Document Control

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

iii

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Contents

Document Control .................................................................................................................iii Introduction ............................................................................................................................vi Document Scope .............................................................................................................vi General Assumptions .....................................................................................................vi Solution Overview ........................................................................................................ vii Process Listing ......................................................................................................................... 1 Mapping - B_REV.1-Budget Preparation – Revenue ......................................................... 2 Mapping - B_OH.1-Budget Preparation – Overhead ......................................................... 4 Mapping - B_FA.1-Budget Preparation - Capital Expenditure ........................................ 6 Mapping - B_FA.2-Budget Preparation – Projects .............................................................. 8 Mapping - B_INS.1-Budget Preparation - Insurance ....................................................... 10 Mapping - B_RCI.1-Budget Preparation – Rigs Cost Input ............................................. 13 Mapping - B_HR.1-Budget Preparation - HR ................................................................... 15 Mapping - B_EXT.1-Budget Preparation – Extraordinary Income / Expenditure ...... 23 Mapping - B_INT.1-Budget Preparation - Interest ........................................................... 25 Mapping - B_CTR.1-Budget Preparation - Catering ........................................................ 27 Mapping - B_SRV.1-Budget Preparation – Service Fee ................................................... 29 Mapping - B_BBH.1-Budget Preparation – Bare Boat Hire ............................................. 31 Mapping - B_SRB.1-Budget Preparation – Shore Base .................................................... 33 Mapping - B_TBL.1-Budget Preparation - Tubulars ........................................................ 34 Mapping - B_TPT.1-Budget Preparation – Transportation ............................................. 36 Mapping - B_PRE.1-Budget Preparation – Prepayments ................................................ 38 Mapping - B_AR.1-Budget Preparation – Receivables .................................................... 39

Document Control

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

iv

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_ODB.1-Budget Preparation – Other Debtors ............................................. 40 Mapping - B_WHT.1-Budget Preparation – Withholding Tax ....................................... 41 Mapping - B_STK.1-Budget Preparation – Stock .............................................................. 42 Mapping - B_AP.1-Budget Preparation – Payables .......................................................... 43 Mapping - B_OCR.1-Budget Preparation – Other Creditors .......................................... 44 Mapping - B_LN.1-Budget Preparation – Loans .............................................................. 45 Mapping - B_TOP.1-Budget Preparation – Tax & Other Provisions.............................. 46 Mapping - B_TX.1-Budget Preparation – Deferred Taxes ............................................... 47 Mapping - B_CAP.1-Budget Preparation - Capital .......................................................... 49 Mapping - B_EST.1-Budget Preparation – EDC Budget Final Revision ........................ 50 Mapping - B_EST.1-Budget Preparation – Estimates ....................................................... 51 Requirement Essay ............................................................................................................... 52 Current versus Proposed ..................................................................................................... 53 Practices .......................................................................................................................... 53 Policies ............................................................................................................................. 53 Procedures ...................................................................................................................... 53 Mapping Solution ................................................................................................................. 54 Solution Components .................................................................................................... 54 Open and Closed Issues for this Deliverable .................................................................... 55 Open Issues ..................................................................................................................... 55 Closed Issues .................................................................................................................. 55

Document Control

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

v

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Introduction This document outlines the proposed solution for the TO BE process model discussed for the Budgeting Cycle business flow for the Egyptian Drilling Company. The TO BE process model has been developed by OCS.

Document Scope The proposed solution uses the standard Oracle Hyperion Planning (Release 11.1.2). Those business requirements identified as not sufficiently catered by the standard Hyperion Planning features will be highlighted and documented. Where possible changes to the business practices or workarounds that can be fulfilled using standard Hyperion Planning, would be proposed. In the event that both these options are not able to meet the requirements of Egyptian Drilling Company, the possibility of customizing the functionality and features of the standard modules would be looked into. However, this would be used as the last resort as the priority and intention would be to retain the standard functionalities of the application where possible. It is important that all relevant functional and IT key users go through this document and identify any areas that may not have been addressed or not likely to be implemented. Such items need to be addressed at this stage to ensure smooth deployment of the system. Such items need to be mentioned under the “Open Issues’ section of this document.

General Assumptions 1.

All budgeted amounts will be entered in USD only same as EDC’s GL functional currency.

2.

DPS (EDC’s Saudi subsidiary) budget items will be prepared using the same EDC’s Budget processes mentioned in this document or directly on EDC’s Chart of Accounts with no special treatments, calculations or separate processes.

3.

EDC FY starts at Jan to Dec.

4.

EDC budget process starts at July of every year for the next FY.

5.

EDC wants to keep every version of monthly estimates done during the FY.

6.

FY2013 is the first FY to be budgeted through the system.

7.

EDC wants to upload 3 FYs actual before FY2013.

8.

EDC will estimate for 4 FYs after the budgeted FY.

Introduction

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

vi

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Solution Overview Oracle implementation for Hyperion planning will cover the following EDC account types: 1.

2.

Capital Budget: •

Fixed Assets.



Projects.

Operating Budget: •

Revenues.



Expenses.

Introduction

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

vii

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Listing

Process ID

Process Name

Description

B_REV.1 B_OH.1 B_FA.1 B_FA.2 B_INS.1 B.RCI.1 B_HR.1 B_EXT.1

Revenue Budget Overhead Budget Capital Expenditure Budget Projects Budget Insurance Rigs Cost Input Budget HR Extraordinary Income/Expenditure Interest Catering Service Fee Bare Boat Hire Shore Base Tubulars Transportation Prepayments Budget Receivables Budget Other Debtors Budget Withholding Tax Budget Stock Budget Payables Budget Other Creditors Budget Loans Budget Tax & Other Provisions Budget Deferred Taxes Budget Capital Budget Final Revision Estimate Monthly Revision

Preparation of EDC Revenue Budget for the next FY. Preparation of EDC Overhead Budget for the next FY. Preparation of EDC Capital Expenditure Budget for the next FY. Preparation of EDC Projects Budget for the next FY. Preparation of EDC Insurance Budget for the next FY. Preparation of EDC Rigs Cost Input Budget for the next FY. Preparation of EDC HR budget for the next FY. Preparation of EDC Extraordinary Income & Expenditure budget for the next FY.

B_INT.1 B_CTR.1 B_SRV.1 B_BBH.1 B_SRB.1 B_TBL.1 B_TPT.1 B_PRE.1 B_AR.1 B_ODB.1 B_WHT.1 B_STK.1 B_AP.1 B_OCR.1 B_LN.1 B_TOP.1 B_DTX.1 B_C.1 B_FRV.1 B_EST.1

Preparation of EDC Interest budget for the next FY. Preparation of EDC Catering budget for the next FY. Preparation of EDC Service Fee budget for the next FY. Preparation of EDC Bare Boat Hire budget for the next FY. Preparation of EDC Shore Base budget for the next FY. Preparation of EDC Tubulars budget for the next FY. Preparation of EDC Transportation budget for the next FY. Preparation of EDC Prepayments Budget for the next FY. Preparation of EDC Receivables Budget for the next FY. Preparation of EDC Other Debtors Budget for the next FY. Preparation of EDC Withholding Tax Budget for the next FY. Preparation of EDC Stock Budget for the next FY. Preparation of EDC Payables Budget for the next FY. Preparation of EDC Other Creditors Budget for the next FY. Preparation of EDC Loans Budget for the next FY. Preparation of EDC Tax & Other Provisions Budget for the next FY. Preparation of EDC Taxes Budget for the next FY. Preparation of EDC Capital Budget for the next FY. Final EDC Budget Revision EDC Budget Estimate during the current FY.

Process Listing

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

1 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_REV.1-Budget Preparation – Revenue Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_REV.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Operations

Revenue

H

Author: Oracle Consulting

Sales & Contracts Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_REV.1-Budget Preparation – Revenue

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

2 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_REV.1/1

EDC Revenue is derived on the basis of Rigs usage during the budgeted FY according to EDC’s contracts with operators as follows:

Every team will have his own Task List which includes its required tasks.

Engineering Operations Sales & Contracts Budget Team

Instructions can be published for the Utility Assumptions Data Form with guidelines.

Comment

1. Utility Estimate: Engineering unit prepares next FY utility days/rig & submits it to Operations. 2. Move Estimate: Operations unit will complete the same info by adding the number & duration of moves then submits it to Sales & Contracts.

Involved teams will use a data forms as follows: 1. Utility /Days drivers. 2. Revenue related GL accounts. 3. Budgeted amount per month. Supporting details can be attached to the Data Form for more details if required. System security will be used to block the access for specific items.

3. Revenue assumptions:

B_REV.1/2

The security can either be configured to Sales & Contracts unit calculates Revenue hide the item or to show it as read only budget based on the previous assumptions such as last year actual. after reviewing Operating & Move rates from respective contracts terms. Other Revenue Accounts as integrated services & location preparation will be System will direct the complete Data Form budgeted directly on the GL level. after submission to the next owner (Approver) as per EDC Budgeting Planning Salas & Contracts unit submit Revenue Units Hierarchy. budget. Budget team reviews the Revenue Budget Budget team will have write access to the & may apply adjustments if required. Revenue Data Form. Budget Manager approves the Revenue Budget.

Budget Team Budget Manager

Budget will copy the “First Proposed” version to the “Reviewed” version & apply the required changes. Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one. Mapping - B_REV.1-Budget Preparation – Revenue

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

3 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_OH.1-Budget Preparation – Overhead Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_OH.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Overhead

Overhead

H

Author: Oracle Consulting

Departments’ Managers Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_OH.1-Budget Preparation – Overhead

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

4 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

Comment

B_OH.1/1

Departments’ Managers prepare next FY Overhead Budget based on the following EDC’s account categories:

Instructions can be published for the Input Data Form with guidelines.

Departments’ Managers

Superintendents will use a data form as follows: 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16.

B_OH.1/2

Housing Cost Public Relations Expenses Other Office Expenses Office Supplies Communication Transportation Insurance Professional Services Welfare & Other Expenses Board Expenses Local Training Training Abroad Special Training Cost Center Overtime Casuals Medical Expense

1. 2.

Overhead related GLs. Budgeted amount per month.

Freight % can be changed through the system variables. Supporting details can be attached to the Data Form for more details if required.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy.

Superintendents submit the Rigs Cost Input Budget to the Budget Team Budget Team reviews the Overhead Budget.

Budget Team will have write access to the Overhead Form.

Budget Team may apply some adjustments if required.

Approval will be acquired using the system workflow.

Budget Manager approves the Overhead Budget.

Budget team will make any required modifications on the “Reviewed” version copied from the “First Proposed” one.

Budget Team Budget Manager

Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one.

Mapping - B_OH.1-Budget Preparation – Overhead

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

5 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_FA.1-Budget Preparation - Capital Expenditure Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_FA.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Finance

CAPEX Budget

H

Author: Oracle Consulting

Assets Team Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_FA.1-Budget Preparation - Capital Expenditure

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

6 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_FA.1/1

Starting the CAPEX budget Process:

Budget Administrator

B_FA.1/2

Superintendents, Base Maintenance, Engineering, IT & Transportation units are provided with a CAPEX request form to enter their needs. Entering the CAPEX Request form:

Upon a request from the mentioned Departments, Budget Administrator will start the CAPEX process by initiating the workflow allowing the 4 Units to start entering their CAPEX budget. Instructions can be published for every Data Form with guidelines. Unit managers will use the data forms to budget for their CAPEX needs on quarters.

Base Maintenance Engineering IT Transportation Superintendents

Every manager enters his unit needs based on the item level per quarter after consulting the Purchasing team for item prices. Rigs & Overhead Units managers submit their requests to the Budget Team for approval

B_FA.1/3

If Budget Team approves the proposed budget by unit managers, Assets team will start preparing the budgeted amounts for requested items to the relevant Fixed Assets Categories Additions, estimating the Write-offs as per the current FY then submit the result to the Budget Team. If Budget Team rejects the proposed budget it will be directed back to the mentioned Unit Manager (Preparer) to adjust it along with required comments/justifications for rejection.

The form will show the following information: 1. Item Description. 2. Budgeted amount per quarter with year total. System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Assets team will use the Assets Budget Data form to enter their assumptions after system consolidates the total budgeted amounts for FA additions from the previous step approved CAPEX budget.

Comment

Assets Team Budget Team

Opening Balance will be equal to previous month. Budget Balance will be equal to: Opening Bal. + Addition – Write Off (Estimated as per current FY) – Accumulated Depreciation (as per EDC Depreciation method). Supporting details can be attached to the Data Form for more details if required.

EDC assumes that any new asset will be treated as an Asset under construction until it is acquired.

B_FA.1/4

Budget team reviews the CAPEX Budget & may apply adjustments if required. Budget Manager approves the CAPEX Budget.

Budget Team can also include their comments during the workflow process to send specific comments for rejected requests. Assets under construction will have a “Transfer To” Asset budget item reflects the actual additions to original FA category for each month. Budget team will have write access to the CAPEX Data Forms.

Budget Team Budget Manager

Budget team will copy the “First Proposed” version to the “Reviewed” version & apply the required changes. Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one. Mapping - B_FA.1-Budget Preparation - Capital Expenditure

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

7 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_FA.2-Budget Preparation – Projects Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_FA.2

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Finance

Projects Budget

H

Author: Oracle Consulting

Assets Team Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_FA.2-Budget Preparation – Projects

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

8 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_FA.2/1

Upon a request from the Assets team, Superintendents will provide their needs for the next FY regarding projects (AFE, PA) to be implemented for their respective rigs.

Superintendents will use a Data form identifying their requests as follows:

Superintendent s

Superintendents submit their requests to the Assets team.

B_FA.2/2

Assets team reviews the Projects requests & adds it to their consolidated Assets Budget plan.

Project Description. Starting Date. End Date. Budgeted Cost.

Supporting details can be attached to the Data Form for more details if required. System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Instructions can be published for every Data Form with guidelines.

Assets Team

Assets team will use the Assets Budget Data form to enter their assumptions after system consolidates the total budgeted amounts for FA additions from the previous step Projects budget to the Assets Under Construction category.

All projects will be classified as Assets Under Construction by nature. Projects cost is divided equally on a monthly basis as per its duration. Assets team assigns every project to its respective asset category at End Date. Depreciation is calculated as per the assigned asset category after the project End Date. Assets team submits the Projects budget to the Budget team.

B_FA.2/3

1. 2. 3. 4.

Comment

Budget team reviews the Projects Budget & may apply adjustments if required.

Asset team will adjust the Projects budgeted amount to their respective Asset Category based on the item description along with its depreciation based on the project End Date submitted within the request form. Opening Balance will be equal to previous month. Budget Balance will be equal to: Opening Bal. + Addition – Write Off (Estimated as per current FY) – Accumulated Depreciation (as per EDC Depreciation methods). System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Budget team will have write access to the Projects Data Form. Budget team will copy the “First Proposed” version to the “Reviewed” version & apply the required changes.

Budget Team Budget Manager

Budget Manager approves the Projects Budget. Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one. Mapping - B_FA.2-Budget Preparation – Projects

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

9 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_INS.1-Budget Preparation - Insurance Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_INS.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Legal

Insurance

H

Author: Oracle Consulting

Legal Team Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_INS.1-Budget Preparation - Insurance

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

10 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_INS.1/1

Legal Team prepares next FY Insurance Budget based on the GL level as per EDC COA Insurance node.

Instructions can be published for the Insurance Data Form with guidelines.

Legal Team

Legal team provides the Insurance Budget to Budget Team. Budget Team requires following Insurance details per GL Account demonstrating budgeted figures: • Hull/Physical Damage (70% of premium on the total insured Value), 5% increase from July over June value • Anticipated Earnings (30% of premium on the total insured value of Rigs), 5% increase from July over June value • P & I / Removal of Wreck (only for Jack-up Rigs : total premium/no. of Rigs) • War / Political Risks (War: only for Jack-up Rigs, Insured Value x rate given by Insurance Co.) (Political Risk: only for Rigs outside Egypt, i.e. Gabon, Libya, Qatar & Syria, Insured Value x rate given by Insurance Co. of respective country) • Excess Liability (only for Jack-up Rigs : total premium/no. of Rigs), 6% increase from July over June value • Uncovered Deductibles (2 mil for Jack-up Rigs & 0.5 mil for Land & WO Rigs) • Miscellaneous – OEE (total premium/no. of Rigs) for Political Violence • Loss of Use (only for Jack-up Rigs : total premium/no. of Rigs)

Legal Team will use a data forms as follows: 1. Insurance related GL accounts 2. Budgeted amount per month.

Supporting details can be attached to the Data Form for more details if required.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy

Mapping - B_INS.1-Budget Preparation - Insurance

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Comment

(v.1.3) Company Confidential - For internal use only

11 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

B_INS.1/2

Budget team reviews the Insurance Budget & Budget team will have write access to the Stock Data Form. may apply adjustments if required. Budget Manager approves the submitted Insurance Budget.

Role

Comment

Budget Team Budget Manager

Budget team will make any required modifications on the “Reviewed” version copied from the “First Proposed” one. Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one.

Mapping - B_INS.1-Budget Preparation - Insurance

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

12 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_RCI.1-Budget Preparation – Rigs Cost Input Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_RCI.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Operations

Input

H

Author: Oracle Consulting

Superintendents Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_RCI.1-Budget Preparation – Rigs Cost Input

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

13 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_RCI.1/1

Superintendents prepare next FY Rigs Cost Input Budget based on EDC’s Chart of Accounts Repair/Maintenance, Supplies & Move – Transportation related GLs.

Instructions can be published for the Input Data Form with guidelines.

Superintendents

Superintendents will use a data form as follows: 1. 2. 3. 4.

B_RCI.1/2

Repair & Maintenance GLs Supplies GLs. Move – Transportation GLs. Budgeted amount per month.

Budget Team assign Freight Cost as % Freight % can be changed through the system of the Repair & Maintenance Budget variables. with the exception of the following: Supporting details can be attached to the Data 1. Certificates Form for more details if required. 2. Service Engineering System will direct the complete Data Form after Superintendents submit the Rigs Cost submission to the next owner (Approver) as per Input Budget to the Budget Team EDC Budgeting Planning Units Hierarchy. Budget Team will have write access to the Input Budget Team reviews the Rigs Cost Data Form. Input Budget.

Budget Manager approves the Rigs Cost Input Budget.

Comment

Budget Team Budget Manager

Approval will be acquired using the system workflow. Budget team will make any required modifications on the “Reviewed” version copied from the “First Proposed” one. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one.

Mapping - B_RCI.1-Budget Preparation – Rigs Cost Input

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

14 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_HR.1-Budget Preparation - HR Business Area:

EDC Process:

Control Number:

Mapping Team:

B_HR.1

Priority (H, M, L):



H

Author: Oracle Consulting

Jul-FY Process Owner:

Oracle Consulting

Librarian:

Source Type: Excel Sheet

Date:

Human Resources

HR Budget

HR Team Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_HR.1-Budget Preparation - HR

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

15 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

B_HR.1/1

Superintendents prepare next FY Headcounts requirement for their own rigs based on the Current FY estimate.

B_HR.1/2

Solution

Upon request from the Superintendents, Manning Section will start preparing Status Report of each employee using headcount data from Oracle EBS and Superintendents. They send this data to the Manning Section Manning Section will adjust the actual headcount data with Superintendents and for preparing headcount status report. Status Report. Instructions can be published for the Manning section review the Headcounts Headcount Data Form with guidelines. Report prepared by the Superintendent. Manning section will prepare Status Report Rig Managers and Manning Section will use the data form as follows: using this data and the headcount data 1. Rig Number extracted from Oracle EBS. 2. Headcounts Status report will have following category with payroll elements : 1. 2. 3. 4.

5.

6. 7. 8.

Sick Leave : 25% deduction from all components of salary Home : Basic+Social Allowance Chronic Disease : Basic+Social Allowance Work Accident : Basic+Incentive+Social Allowance+Special Increase+IWCF+STP Allowance+Special Remuneration Off Duty : Basic+Incentive+Social Allowance+Special Increase+IWCF+STP Allowance+Special Remuneration Absence : Full deduction from all components of salary Active : Full Salary Transfer : Full Salary

Comment

Superintendents HR Team

Superintendents Manning Section HR Team

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy.

Mapping - B_HR.1-Budget Preparation - HR

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Role

(v.1.3) Company Confidential - For internal use only

16 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

Comment

Instructions can be published for the Rig Crew Cost Data Form with guidelines.

HR Team QME-HSE Team Budget Team

Headcounts are broken down in the following components: 1. Nationals 2. Casuals 3. T.C.N (3rd Country Nationals) 4. Expatriates

B_HR.1/3

Each category of headcounts includes employees as per following : => National : Decides by Rig Managers => Casual : Per contracts => TCN : Per Country’s Norms => Expats : Per Expat Agreements HR Team will receive the above Headcount form from Manning Team. HR Team will review the above report and prepare Rig Crew Cost Budget using the above form and following increment assumptions from July : • Basic Salary 7% • Incentives 7% • Drilling Allowance 2% • Experience Allowance 7% • Social Allowance 15% • Overtime 7% • Casuals 7% • Expatriate (From Jan) 5% • Collective Policy 7% • Retirement Scheme 7%

Compensation Section will use a data form as follows: 1. Compensation Items 2. Budgeted amount per month including DEC estimate (current FY).

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy.

Above components are taken from Oracle EBS and Compensation team do some changes in above items wherever required.

Mapping - B_HR.1-Budget Preparation - HR

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

17 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

Comment

Crew cost total per month is broken down in the following components: 1.

Crew Cost : (All cost components is calculated on the basis of master payroll data from Oracle EBS (Excel file name - Budget work shop) except followings costs: • Basic Salary – sum of basic salary, basic promotion and social basic share • Incentives – 90% of above components • Residence Allowance – Actual data from Oracle EBS • Drilling Allowance - Actual data from Oracle EBS • Transport Allowance - Actual data from Oracle EBS • Experience Allowance - Actual data from Oracle EBS except Field Extra Duties (Fixed Amount for each Rig) • Social Insurance - Actual data from Oracle EBS • Taxes Paid - Actual data from Oracle EBS • Annual Leave Compensation calculated on the basis of years of service & age of the employees : It’s a Sum of – 1. Gross Salary for one month if years of service is greater than 10 yrs else Gross Salary for 21 days 2. Gross Salary for one month if employee is 50 yrs old else Gross Salary for 21 days Other Deductions – Home Leave Days, Sick Leave Days, Off Duty, Chronic and Work Accident

Mapping - B_HR.1-Budget Preparation - HR

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

18 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

2.

Social Allowance : Social Allowance (Actual data from Oracle EBS) minus Social share of basic & incentives (after July)

3.

Staff on loan to Others Currently this account is not being used

4.

Overtime : Sum of OT Extra Days – Average hours for each Rig (Hours x Basic Salary x 1.9/210) adjusted with some extra amount according to Rigs requirement OT Holidays : =(((Basic Salary x 1.9/210) x 14 days) x 12 hours)/12 months





5.

Safety Bonus : Headcounts x $100 for each Rig after every six months of time when no accidents took place. Timing for bonus may be different for each Rig

6.

Anniversaries Celebration : Currently this account is not being used

7.

Casuals : Sum of Casuals from Top Business, Casual Welders and Casual Guards Cost of Casuals from Top Business – Invoice value Casuals Guard Salary – Per contract (No. of casuals x Rate) Different rate is applied for Welders & Guards) Contractual Staff – Per contract (No. of contract employees x Rate)

• •



Comment

Mapping - B_HR.1-Budget Preparation - HR

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Role

(v.1.3) Company Confidential - For internal use only

19 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

8.

Expat Costs : Expat name, job & location data will come from Oracle EBS and his salary will be as per Expatriate Agreement. Other cost elements are calculated based on the estimates. Allocation of expat cost on the Rigs is done by Expat Section.

9. •

Rig Crew Insurance : Collective Policy – Calculation based on the basic and incentive (formula described in the File – GL available in Budget 2012 Compensation HR folder) Retirement Scheme : - Permanent Employees – Total cost of Pension Scheme Invoice/Headcounts Contract Employees – Basic+Half of Incentive x 7.5%



Role

Comment

10. Medical Expenses : Currently this account is not being used 11. Travel & Transport Expenses : • Travelling Allowance – $165 fixed for each Rig (Exceptions for Rigs outside Egypt) • Crew Change – sum of : - Accommodation (Headcount x $25) - Crew Change (calculation described in the file “Transport Price 2012” available in Budget 2012 Compensation HR folder) • Desert Pass - (Headcount x $5) Mapping - B_HR.1-Budget Preparation - HR

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

20 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

Comment

12. Welfare & Other Expenses : Work and Safety Clothes – No. of headcount x Rate+Consumption based on season i.e. winter etc This will be prepared by QME-HSE department Budget for all the above items will be prepared on the Employee or Cost Center level as indicated below: Basic Salary => Employee Level Incentives => Employee Level Representation Allowance => Employee Level • Residence Allowance => Employee Level • Drilling Allowance => Employee Level • Transport Allowance => Employee Level • Experience Allowance => Employee Level • Social Insurance => Employee Level • Taxes Paid => Employee Level • Social Allowance => Employee Level • Overtime => Cost Center Level • Safety Bonus => Employee Level • Casuals => Cost Center Level • Expat Costs => Employee Level • Collective Policy => Employee Level • Retirement Scheme => Employee Level • Other Rig Crew Insurance => Cost Center Level • Contract Social Insurance => Cost Center Level • Travelling Allowance => Cost Center Level • Crew Change => Cost Center Level • Desert Pass => Employee Level • Other Travel & Transport Exp => Cost Center Level HR Team submits the Rig Crew Cost Budget to the Budget team • • •

Mapping - B_HR.1-Budget Preparation - HR

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

21 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_HR.1/4

Training Section will prepare the Training Budget based on the requests received from Superintendents & other departments. The total training cost will be decided by the Training section & allocated to the different Rigs & Departments.

Instructions can be published for the Training Cost Data Form with guidelines.

Training Section HR Team

Training Section will submit the Training Budget to HR Team for their review.

HR team will review and submit the Training Budget to Budget Team. B_HR.1/5

Budget team reviews the HR Budget & may apply adjustments if required. Budget Manager approves the submitted HR budget.

Comment

Training Section will use the data form as follows: 1. Rig/Department Name. 2. Budgeted amount per month including DEC estimate (current year).

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Budget Team will have write access to the HR Data Forms.

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” version & apply the required changes. Approval will be acquired using the system workflow. Budget team will copy the Budget after approval from the “Reviewed” version to the “Approved” one.

Mapping - B_HR.1-Budget Preparation - HR

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

22 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_EXT.1-Budget Preparation – Extraordinary Income / Expenditure Business Area:

EDC Extraordinary Income/ Expenditure

Control Number:

Jul-FY

Mapping Team:

B_ EXT.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Finance

Process:

H

Author: Oracle Consulting

Budget Team Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_EXT.1-Budget Preparation – Extraordinary Income / Expenditure

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

23 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_EXT.1/1

Shore Team prepares year Overhead BudgetBase Team prepares nextnext FY Extraordinary Income-Expenses Budget based on the previous FYs actual figures taken into consideration the upcoming Income/Expenses.

Instructions can be published for the Extraordinary Income/Expenses Data Form with guidelines.

Budget Team

Budget Team estimates the next FY figures on EDC’s Chart of Accounts related GLs

Budget Team will use a data form as follows: 1. 2. 3. 4.

.

Comment

Extraordinary Income GLs. Extraordinary Expenses GLs. Current FY Actual. Budgeted amounts for the next FY on a quarterly basis.

Supporting details can be attached to the Data Form for more details if required.

B_EXT.1/2

Budget team reviews the Extraordinary Income/Expenses Budget. Budget Manager approves the Extraordinary Income/Expenses Budget.

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then “Approved” one.

Mapping - B_EXT.1-Budget Preparation – Extraordinary Income / Expenditure

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Approval will be acquired using the system workflow.

(v.1.3) Company Confidential - For internal use only

24 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_INT.1-Budget Preparation - Interest Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_INT.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Finance

Interest

H

Author: Oracle Consulting

Treasury Team Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_INT.1-Budget Preparation - Interest

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

25 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

Comment

B_INT.1/1

Shore Base Team prepares next Treasury Team prepares next FYyear Interest Budget based on the GL level as per EDC Chart of Accounts Interest Expense related GLs.

Instructions can be published for the Interest Data Form with guidelines.

Treasury Team

Treasury Team will use a data form as follows: 1. Interest Children GL accounts 2. Budgeted interest amount per month. Supporting details can be attached to the Data Form for more details if required.

Treasury Control team submits the Interest Budget to the Budget team.

B_INT.1/2

Budget team reviews the Interest Budget & may apply adjustments if required. Budget Manager approves the Interest Budget.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Budget team will have write access to the Interest Data Form.

Budget Team Budget Manager

Budget team will copy the “First Proposed” version to the “Reviewed” version & apply the required changes. Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one.

Mapping - B_INT.1-Budget Preparation - Interest

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

26 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_CTR.1-Budget Preparation - Catering Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_CTR.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Operations

Catering

H

Author: Oracle Consulting

Operations Team Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_CTR.1-Budget Preparation - Catering

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

27 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

B_CTR.1/1

Instructions can be published for the Operations Team prepares next FY Catering assumptions for each Rig based on Catering Assumptions Data Form with guidelines. the current FY estimate as follows: 1.

No. of Nationals & Expatriates per Rig. 2. No. of Transport Standby & EDC units. 3. No. of Casuals. 4. No. of Visitors. 5. No. of Free Meals. 6. No. of Extra Transport during moves. Operations team submits the Catering Headcount assumptions Budget team estimates next FY meal cost based on the current FY cost.

B_CTR.1/2

Comment

Operations Team Budget Team

Operations Team will use a data form as follows: 1. Rig Name. 2. Headcount Assumptions. Supporting details can be attached to the Data Form for more details if required.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy.

Catering Budget for will be calculated as follows:

Budget team will enter their estimate for the next FY Meal Cost.

[ (No. of Nationals + Expats) * 0.5 + No. of Transport Standby & EDC units + No. of Casuals + No. of Visitors + No. of Free Meals] * Meal Cost * Rig Operational days (Revenue Budget) + [Extra Transport * Rig Move days (Revenue Budget) * Meal Cost] Budget team reviews the calculated Catering Budget & may apply adjustments if required.

Budget team will use the Catering Budget data form to check the calculated budget figures.

Budget Manager approves the Catering Budget.

Role

Budget team will make any required modifications on the “Reviewed” version copied from the “First Proposed” one. Approval will be acquired using the system workflow.

Budget Team Budget Manager

Budget team will make any required modifications on the “Reviewed” version copied from the “First Proposed” one. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one. Mapping - B_CTR.1-Budget Preparation - Catering

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

28 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_SRV.1-Budget Preparation – Service Fee Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_SRV.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Finance

Service Fee

H

Author: Oracle Consulting

Budget Team Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_SRV.1-Budget Preparation – Service Fee

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

29 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_SRV.1/1

Budget Team prepares next FY Service Fee Budget for all Rigs as follows:

Instructions can be published for the Service Fee Data Form with guidelines.

Budget Team

Rig Service Rate * Operational No. of Days (Rig Utility Budget)

Budget Team will use a data form to enter the Service Fee assumptions as follows:

Service Fees Budgeted amounts calculated will be divided equally on Maersk & EGPC with some exceptions.

1. 2.

Comment

Rig Name Rig Service Daily Rate

Supporting details can be attached to the Data Form for more details if required. Budget Team may apply some adjustments if required.

Another Data Form Service Fee Budget will show the calculated figures as follows: 1. 2. 3.

Rig Name Service Fee Budgeted amounts per month. Company (Maersk & EGPC)

Budget Team will adjust Budget amounts for Rigs not owned by EDC.

B_SRV.1/2

Budget Manager approves the Service Fee Budget.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Approval will be acquired using the system workflow.

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then” Approved” one.

Mapping - B_SRV.1-Budget Preparation – Service Fee

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

30 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_BBH.1-Budget Preparation – Bare Boat Hire Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_BBH.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Finance

Bare Boat Hire

H

Author: Oracle Consulting

Budget Team Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_BBH.1-Budget Preparation – Bare Boat Hire

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

31 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

B_BBH.1/1

Instructions can be published for the Bare Budget Team prepares next FY Bare Boat Hire Budget for each Rig owned by Maersk Boat Hire Data Form with guidelines. & EGPC based as follows: Budget Team will use a data forms as Bare Boat Hire Rate * Actual Month days follows: 1. 2.

Role

Comment

Budget Team

Rig Name Bare Boat Hire Daily Rate

Supporting details can be attached to the Data Form for more details if required.

B_BBH.1/2

Budget Team reviews the Bare Boat Hire Budget & may apply adjustments if required. Budget Manager approves the Bare Boat Hire Budget.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then “Approved” one.

Mapping - B_BBH.1-Budget Preparation – Bare Boat Hire

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Budget Team Budget Manager

(v.1.3) Company Confidential - For internal use only

32 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_SRB.1-Budget Preparation – Shore Base Business Area:

EDC Process:

Date:

Shore Base

Shore Base

Control Number:

Jul-FY

Mapping Team:

B_SRB.1

Process Owner:

Oracle Consulting

Librarian:

Shore Base Teams

Priority (H, M, L):



Core? (Y/N)

H

Y

Process Step #

Description

Solution

B_SRB.1/1

Shore Base Base Budget Team prepares next year Shore is calculated based on the Budget Team will review the Shore Base Budget Data Form showing the calculated Overhead Budget provided by the Shore budget amounts as follows: Base Cost Centers (from Overhead Budget) as follows: 1. Shore Base Cost Center 2. Budget Amount per month. Total Overhead Budget + Agent Fees (Syria only)

Role

Comment

Shore Base Teams

Agent Fees is calculated as follows:

B_SRB.1/2

3% of the Rig Operating Revenue (from Revenue Budget) Budget Manager approves the Shore Base Budget

Supporting details can be attached to the Data Form for more details if required. Approval will be acquired using the system workflow.

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then “Approved” one.

Mapping - B_SRB.1-Budget Preparation – Shore Base

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

33 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_TBL.1-Budget Preparation - Tubulars Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_TBL.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Operations

Tubulars

H

Author: Oracle Consulting

POG/Tubular Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_TBL.1-Budget Preparation - Tubulars

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

34 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_TBL.1/1

Shore Base Team prepares nextnext yearFY Tubular POG/Tubular Team prepares Budget based on the number of units requested by the Superintendents’ for the following types:

Instructions can be published for the Tubular Price Data Form with guidelines. POG/Tubular Team will use a data form as follows: 1. Tubular Item Types. 2. Unit Price.

POG/Tubular Team

1. 2. 3.

Drill Pipe (DP) Heavy Weight Drill Pipe (HWDP) Drill Collar (DC)

POG/Tubular Team provided by Tubular prices. POG/Tubular Team estimates the Tubular Budget as follows: Unit Price * No of Units * 31 (DP) Unit Price * No. of Units (HWDP – DC)

Comment

POG/Tubular Team will consolidate Superintendents’ requests using the Tubular Budget data form as follows: 1. Rig Names. 2. Tubular Item Types. 3. No. of Units requested. 4. Freight (calculated). 5. Total Cost. Tubular Freight Cost % will be updated if required from the System Variables screen

Related Freight cost is 2% out of the Budgeted Supporting details can be attached to the Tubular figures to be decided every FY. Data Form for more details if required.

Budget team reviews the Tubular Budget & may apply adjustments if required.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Budget team will have write access to the Tubular Data Form.

Budget team allocates the total cost calculated from the previous step on the next FY months equally.

Budget will copy the “First Proposed” version to the “Reviewed” version & apply the required changes.

Budget Manager approves the submitted Tubular Budget.

System Calculation Rule will allocate the Tubular Cost on the next FY months/Rig.

POG/Tubular team submits the Tubular Budget to the Budget team

B_TBL.1/2

Budget Team Budget Manager

Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one. Mapping - B_TBL.1-Budget Preparation - Tubulars

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

35 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Mapping - B_TPT.1-Budget Preparation – Transportation Business Area:

EDC Process:

Control Number:

Jul-FY

Mapping Team:

B_ TPT.1

Process Owner:

Oracle Consulting

Librarian:

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Operations

Allocated Transportation

H

Author: Oracle Consulting

Transportation Core? (Y/N)

Y

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Mapping - B_TPT.1-Budget Preparation – Transportation

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

36 of 55

Doc Ref: EDC-HP-PLN

BR.030 Business Requirements Mapping Form

Process Step #

Description

Solution

Role

B_TPT.1/1

Shore Base Team next year Transportation & prepares Budget Teams prepares next FY Transportation Budget based on the GL level as per EDC Chart of Accounts “Allocated Transport Costs- Target Account” node as follows:

Instructions can be published for the Transportation assumptions data form.

Transportation Team Budget Team

1. 2. 3. 4.

B_TPT.1/2

Comment

Transportation Team will use a data form identifying their requests as follows: 1. Vehicles cost related GL EDC drivers’ HR related budgeted accounts. cost (HR Budget). 2. Budgeted amount per month Transportation Vehicles cost (Fuel, Maintenance…etc). Supporting details can be attached to the Total cost is allocated to every Data Form for more details if required. Cost Center based on its usage. Budget team has a rate for every Vehicle type.

Transportation Team submits their budget to System will direct the complete Data Form the Budget Team after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Budget team reviews the Transportation Budget Team will use a data form as Budget & may apply adjustments if required. follows: 1. Cost Center. 2. Vehicle Type (Crane, Budget Manager approves the Passenger...etc) Transportation Budget. 3. Number of units used 4. Unit share of Transportation cost.

Budget Team Budget Manager

Budget Team will review calculated Transportation Budget based on the previous assumptions. Budget will copy the “First Proposed” version to the “Reviewed” version & apply the required changes. Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one. Mapping - B_TPT.1-Budget Preparation – Transportation

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

37 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_PRE.1-Budget Preparation – Prepayments Business Area:

EDC Process:

Prepayments

Control Number:

Process Owner:

Oracle Consulting

Budget Team

Priority (H, M, L):



Source Type: Excel Sheet

Jul-FY

Mapping Team:

B_PRE.1 Librarian:

Date:

Finance

Core? (Y/N)

H

Y

Author: Oracle Consulting

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

Solution

Role

B_PRE.1/1

Budget & Cost Control Teams Instructions can be published for the Prepaid prepares next FY Prepayments Budget Data Form with guidelines. based on the GL level as per EDC Budget Team will use a data form as follows: Chart of Accounts “Deposits with others” & “Prepaid Expenses” nodes. 1. Prepayments Children GL accounts 2. Budgeted amount per month Budget Team requires prepaid details including DEC estimate (current per GL Account demonstrating FY). budgeted figures.

Comment

Cost Control Budget Team

Supporting details can be attached to the Data Form for more details if required.

B_PRE.1/2

Budget Manager approves the Prepayments Budget.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Approval will be acquired using the system workflow.

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then “Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_PRE.1-Budget Preparation – Prepayments (v.1.3) Company Confidential - For internal use only

38 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_AR.1-Budget Preparation – Receivables Business Area:

EDC Process:

Date:

Finance

Receivables

Jul-FY

Mapping Team:

Control Number:

B_AR.1

Process Owner:

Oracle Consulting

Librarian:

Budget Team

Priority (H, M, L):



Core? (Y/N)

H

Y

Author: Oracle Consulting

Source Type: Excel Sheet

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

B_AR.1/1

Instructions can be published for the Receivables Budget Team prepares next FY Receivables Budget based on 3 months Data Form with guidelines. outstanding as follows: Budget team will use a data forms as follows: 1. Revenue (3 Months Outstanding), Receivables is calculated as per EDC Provision & Intercompany Account budget assumptions as current month + previous month 2. Budgeted amount per month + another month (month before including DEC estimate (current FY). previous) - Provisions for Bad Debt (GL Level) Supporting details can be attached to the Data + Intercompany Account (GL Level) Form for more details if required.

B_AR.1/2

Solution

Budget Team reviews the Receivables Budget. Budget Manager approves the Receivables Budget.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Role

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Approval will be acquired using the system workflow.

Comment

Budget Team

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then “Approved” one.

Mapping - B_AR.1-Budget Preparation – Receivables (v.1.3) Company Confidential - For internal use only

39 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_ODB.1-Budget Preparation – Other Debtors Business Area:

EDC Process:

Date:

Finance

Other Debtors

Jul-FY

Mapping Team:

Control Number:

B_ODB.1

Process Owner:

Oracle Consulting

Librarian:

Budgeting Team

Priority (H, M, L):



Core? (Y/N)

H

Y

Author: Oracle Consulting

Source Type: Excel Sheet

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

Solution

B_ODB.1/1

Budget Team prepares next FY Other Instructions can be published for the Other Debtors Data Form with guidelines. Debtors Budget based on the GL level as per EDC Chart of Accounts Budget Team will use a data form as follows: “Other Debtors” node. 1. 2.

Role

Comment

Budget Team

Other Debtors Children GL accounts Budgeted amount per month including DEC estimate (current FY).

Supporting details can be attached to the Data Form for more details if required.

B_ODB.1/2

Budget Manager approves the Other Debtors Budget.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Approval will be acquired using the system workflow.

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then” Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_ODB.1-Budget Preparation – Other Debtors (v.1.3) Company Confidential - For internal use only

40 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_WHT.1-Budget Preparation – Withholding Tax Business Area:

EDC Process:

Date:

Finance

Withholding Tax

Jul-FY

Mapping Team:

Control Number:

B_WHT.1

Process Owner:

Oracle Consulting

Librarian:

Tax Team

Priority (H, M, L):



Core? (Y/N)

H

Y

Author: Oracle Consulting

Source Type: Excel Sheet

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step # B_WHT.1/1

Description

1.

Withheld Tax:

Tax Team prepares next FY Withholding Tax as follows:

B_WHT.1/2

Role

Instructions can be published for the Withheld Tax Data Form with guidelines.

Tax Team

Comment

Tax Team will use a data forms as follows:

2% of the budgeted revenue from Operators + Dec (Current FY) estimates for GLs “Withholding Tax” & “Payment Tax Return” - “Tax Payable Balance” Current FY 2. Other Taxes Payables: Tax Team prepares next FY Taxes Payables based on Dec (Current FY estimates) as follows: Tax Income paid on behalf of Expats based on Maersk Invoice. + Withholding Tax deducted from Suppliers + Sales Tax

B_WHT.1/3

Solution

1. Tax accounts 2. Budgeted amount per month including DEC estimate (current year).

Same data form will be used for Withheld Tax.

Tax Team

Supporting details can be attached to the Data Form for more details if required.

System will direct the complete Data Form after submission to the next owner (Approver) Tax Team will submits the Withheld as per EDC Budgeting Planning Units Tax Budget to Budget Team for review Hierarchy Budget team reviews the Withholding Approval will be acquired using the system Tax Budget & may apply adjustments if workflow. required. Budget team will make any required Budget Manager approves the modifications on the “Reviewed” version submitted Withholding Tax Budget. copied from the “First Proposed” one.

Budget Team Budget Manager

Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_WHT.1-Budget Preparation – Withholding Tax (v.1.3) Company Confidential - For internal use only

41 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_STK.1-Budget Preparation – Stock Business Area:

EDC Process:

Date:

Inventory

Stock

Jul-FY

Mapping Team:

Control Number:

B_STK.1

Process Owner:

Oracle Consulting

Librarian:

Stock Control

Priority (H, M, L):



Core? (Y/N)

H

Y

Author: Oracle Consulting

Source Type: Excel Sheet

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

Solution

Role

B_STK.1/1

Stock Control team prepares next FY Stock Budget for all Rigs owned by EDC based on the Current FY estimate.

Instructions can be published for the Stock Data Form with guidelines.

Stock Control

Comment

Budget Team will use a data form as follows: 1. 2.

Related Freight cost is 6% out of the Budgeted Stock figures to be decided every FY.

3.

Rig Number/Tabular. Budgeted amount per month including DEC estimate (current FY). Freight Budgeted amount per month calculated as per EDC Freight Cost %.

Freight Cost % will be updated if required from the System Variables screen Supporting details can be attached to the Data Form for more details if required. Stock Control team submits the Stock Budget to the Budget team.

B_STK.1/2

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Budget team reviews the Stock Budget Budget team will have write access to the Stock & may apply adjustments if required. Data Form. Budget Manager approves the submitted Stock Budget.

Budget Team Budget Manager

Budget will copy the “First Proposed” version to the “Reviewed” version & apply the required changes. Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_STK.1-Budget Preparation – Stock (v.1.3) Company Confidential - For internal use only

42 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_AP.1-Budget Preparation – Payables Business Area:

EDC Process:

Date:

Finance

Payables

Jul-FY

Mapping Team:

Control Number:

B_AP.1

Process Owner:

Oracle Consulting

Librarian:

Budget Team

Priority (H, M, L):



Core? (Y/N)

H

Y

Author: Oracle Consulting

Source Type: Excel Sheet

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

Solution

Role

B_AP.1/1

Budget Team prepares next FY Payables Budget based on the GL level as per EDC Chart of Accounts “Accounts Payables Accruals” node.

Instructions can be published for the Payables Data Form with guidelines.

Budget Team

Comment

Budget Team will use a data forms as follows: 1. 2.

Payables Children GL accounts Budgeted amount per month including DEC estimate (FY).

Supporting details can be attached to the Data Form for more details if required.

B_AP.1/2

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Budget Manager approves the Payables Approval will be acquired using the system workflow. Budget.

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then “Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_AP.1-Budget Preparation – Payables (v.1.3) Company Confidential - For internal use only

43 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_OCR.1-Budget Preparation – Other Creditors Business Area:

EDC Process:

Date:

Finance

Other Creditors

Jul-FY

Mapping Team:

Control Number:

B_OCR.1

Process Owner:

Oracle Consulting

Librarian:

Budget Team

Priority (H, M, L):



Core? (Y/N)

H

Y

Author: Oracle Consulting

Source Type: Excel Sheet

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

Solution

Role

B_OCR.1/1

Budget Team prepares next FY Other Instructions can be published for the Other Creditors (Other Account Payables) Creditors Data Form with guidelines. Budget based on the GL level as per EDC Chart of Accounts “Other Budget Team will use a data form as follows: Creditors” node. 1. Other Creditors Children GL accounts 2. Budgeted amount per month including DEC estimate (current FY).

Comment

Budget Team

Supporting details can be attached to the Data Form for more details if required.

B_OCR.1/2

Budget Manager approves the Other Creditors Budget.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Approval will be acquired using the system workflow.

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then” Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_OCR.1-Budget Preparation – Other Creditors (v.1.3) Company Confidential - For internal use only

44 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_LN.1-Budget Preparation – Loans Business Area:

EDC Loans

Finance

Control Number:

Mapping Team:

Process:

B_LN.1

Date:

Jul-FY Process Owner:

Oracle Consulting

Librarian:

Treasury Team

Priority (H, M, L):



Core? (Y/N)

H

Y

Author: Oracle Consulting

Source Type: Excel Sheet

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

Solution

Role

B_LN.1/1

Treasury Team prepares next FY Loans Budget based on Dec current FY balance as follows:

Instructions can be published for the Loans Data Form with guidelines.

Treasury Team

Comment

Treasury Team will use a data forms as follows: 1. 2.

3.

4. 5.

6.

B_LN.1/2

EDC has a GL account/loan. Treasury Team uses loans repayment schedules to get loans installments due within the next budget year along with new withdrawals. EDC is currently amortizing a syndication fees paid before till 2016. Loans are classified by due dates. Long-Term loans will equals to Loans Balance minus current month Installments. Syndication fees is deducted from the budgeted loan balances

Treasury Team submits Loans budget to the Budget Team Budget Team reviews the submitted Loans Budget. Budget Manager approves the Loans Budget.

1. Loans GL accounts & Syndication Fees 2. Budgeted amount per month including DEC (current FY). 3. Budgeted amount will be equal to Loans Balance – Syndication fees amortization. Loans installments will be entered manually using EDC’s Loans repayment sheets. Supporting details can be attached to the Data Form for more details if required.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Approval will be acquired using the system workflow.

Budget Team Budget Manager

Budget team will make any required modifications on the “Reviewed” version copied from the “First Proposed” one. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_LN.1-Budget Preparation – Loans (v.1.3) Company Confidential - For internal use only

45 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_TOP.1-Budget Preparation – Tax & Other Provisions Business Area:

EDC Process:

Date:

Finance

Tax & Other Provisions

Jul-FY

Mapping Team:

Control Number:

B_TOP.1

Process Owner:

Oracle Consulting

Librarian:

Budget Team

Priority (H, M, L):



Core? (Y/N)

H

Y

Author: Oracle Consulting

Source Type: Excel Sheet

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

Solution

Role

B_TOP.1/1

Budget Team prepares next FY Tax & Instructions can be published for the Tax and Other Provisions Budget based on Other Provisions Data Form with guidelines. the GL level as per EDC Chart of Accounts “Tax Provisions” & “Other Budget Team will use a data form as follows: Provisions” nodes. 1. Tax & Other Provisions Children GL accounts 2. Budgeted amount per month including DEC estimate (current FY).

Comment

Budget Team

Supporting details can be attached to the Data Form for more details if required.

B_TOP.1/2

Budget Manager approves the Tax & Other Provisions Budget.

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Approval will be acquired using the system workflow.

Budget Team Budget Manager

Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then “Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_TOP.1-Budget Preparation – Tax & Other Provisions (v.1.3) Company Confidential - For internal use only

46 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_TX.1-Budget Preparation – Deferred Taxes Business Area:

EDC Process:

Deferred Tax

Control Number:

B_DTX.1 Librarian:



Source Type: Excel Sheet

Date:

Finance

Jul-FY

Mapping Team:

Process Owner:

Oracle Consulting Priority (H, M, L):

Tax Team Core? (Y/N)

H

Y

Author: Oracle Consulting

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_TX.1-Budget Preparation – Deferred Taxes (v.1.3) Company Confidential - For internal use only

47 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Process Step #

Description

Solution

Role

B_TX.1/1

Deferred Tax: Tax Team prepares next FY Deferred Tax Budget based on Tax Authority’s depreciation guidelines as follows:

Instructions can be published for the Deferred Tax Data Form with guidelines.

Tax Team

1.

Tax Assets Opening Balance from Dec (Current FY) + Additions (CAPEX Budget) - Sale (Estimate) = End Balance (Budget Year)

2.

Tax authority requires the following depreciation rates: a) 5% for Buildings b) 25% for Drilling Units c) 25% for Transportation d) 25% for Furniture e) 50% for Equipment

3.

B_TX.1/2

a data form will be used by the Tax Team on a monthly basis as follows: 1. EDC asset categories 2. Net tax assets value & sale values. 3. Tax Depreciation rate with Net assets tax value calculated. 4. EDC Assets net value. 5. Taxable amount & the calculated Deferred tax.

Supporting details can be attached to the Data Form for more details if required.

Taxable amount will be the Difference between Tax & EDC net Assets book value is subject to 25% Tax.

Deferred Tax Budget will be directed to the Budget Team. Taxes Declaration: Tax Team prepares next FY EDC Tax declaration budget on a monthly basis as follows: Net Profit (P&L Budget) + Tax related GL accounts = Tax Profit - Tax Depreciation (Annuity Basis) - Carried Forward Losses = Deferred Tax assets Taxes declaration Budget will directed to the Budget Team.

B_TX.1/3

Comment

Budget team consolidates the previous two steps in one representing EDC Tax for next FY calculating the budgeted tax rate% on monthly basis as follows: Tax calculated (EDC Tax declaration) - Deferred Tax = Total Tax Tax Rate% = Net Profit (P&L)/Total Tax

System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. Instructions can be published for the Tax Declaration Data Form with guidelines.

Tax Team

Tax Team will use a data form as follows: 1. Net Profit (calculated from P&L Budget) 2. Tax related GL accounts 3. Tax Depreciation 4. Carried Forward Losses 5. Budgeted taxable amounts Supporting details can be attached to the Data Form for more details if required. System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. A consolidated Taxes Data Form will be used by Budget Team as follows: 1. 2. 3. 4.

Budget Team Budget Manager

Tax Declaration Deferred Tax Net Profit Tax Rate%

Approval will be acquired using the system workflow.

Budget Team reviews the Taxes Budget Budget team will make any required & may apply adjustments if required. modifications on the “Reviewed” version copied from the “First Proposed” one. Budget Manager approves the Taxes Budget. Budget team will copy the approved budget from the “Reviewed” version to the “Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_TX.1-Budget Preparation – Deferred Taxes (v.1.3) Company Confidential - For internal use only

48 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_CAP.1-Budget Preparation - Capital Business Area:

EDC Process:

Capital Budget

Control Number:

Process Owner:

Oracle Consulting

Budget Team

Priority (H, M, L):



Source Type: Excel Sheet

Jul-FY

Mapping Team:

B_CAP.1 Librarian:

Date:

Finance

Core? (Y/N)

H

Y

Author: Oracle Consulting

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

Solution

Role

B_CAP.1

Budget Team prepares every FY Capital Budget with the same assumption as follows:

Budget Team will use a Data Form on as follows:

Budget Team Budget Manager

Paid In Capital + Capital Increase = Total Capital + Legal Reserve + Additions = Total Legal Reserve + Retained Earnings + Transfer to Capital + Current FY Profit + (Profit Distributions) + (Employees Shares) + (Board Remuneration) + (Dividends) = Total Retained Earnings + Exchange Rate Difference = Total EDC Owners Equity

1. 2.

Comment

Capital Related GLs. Budgeted Capital amounts per month.

Supporting details can be attached to the Data Form for more details if required. Approval will be acquired using the system workflow. Budget team will copy the approved budget from the “First Proposed” version to the “Reviewed” then” Approved” one.

Net Profit is calculated as follows: EDC Net Profit (DEC Estimate) + DPS Profit (DEC Estimate) – DPS Profit Actual Budget Team may apply adjustments if required. Budget Manager reviews the Capital Budget

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_CAP.1-Budget Preparation - Capital (v.1.3) Company Confidential - For internal use only

49 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_EST.1-Budget Preparation – EDC Budget Final Revision Business Area:

EDC Process:

Oct-FY

Mapping Team:

Process Owner:

Final Revision

Control Number:

B_EST.1 Librarian:

Oracle Consulting

CFO

Priority (H, M, L):



Source Type: Excel Sheet

Date:

Finance

Core? (Y/N)

H

Y

Author: Oracle Consulting

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

B_FRV.1/1

Budget Team submits next FY EDC’s EDC’s Budgeted Financial statements will be Budget the CFO for Approval. consolidated from the previous budget processes as follows: EDC Budget process will be consolidated to produce the 1. EDC Balance Sheet. following: 2. EDC Income Statement. 3. EDC Cash Flow. 1. EDC Balance Sheet. 2. EDC Income Statement. Supporting details can be attached to the Data 3. EDC Cash Flow. Forms for more details if required.

B_FRV.1/2

Solution

Role

Budget team will make any required Budget Team may apply adjustments modifications on the “Approved” version. if required. System will direct the complete Data Form after submission to the next owner (Approver) as per EDC Budgeting Planning Units Hierarchy. CFO reviews the submitted EDC’s Budget team will copy EDC Budget from the Budget. “Approved” version to the “Final” version.

Comment

Budget Team Budget Manager

CFO

CFO approves EDC’s Budget.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_EST.1-Budget Preparation – EDC Budget Final Revision (v.1.3) Company Confidential - For internal use only

50 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping - B_EST.1-Budget Preparation – Estimates Business Area:

EDC Process:

Date:

All Business Areas

Estimates

Jul-FY

Mapping Team:

Control Number:

B_EST.1

Process Owner:

Oracle Consulting

Librarian:

All Teams

Priority (H, M, L):



Core? (Y/N)

H

Y

Author: Oracle Consulting

Source Type: Excel Sheet

Ref. Doc.: EDC-HP-PLN

BRS Reference #:

Process Step #

Description

Solution

Role

B_EST.1/1

All EDC Teams involved in the Budget preparation process will make estimates during the FY.

Same data forms used for the Budget process will be used for EDC’s estimations with the exception of pre-GL level steps.

All Teams

Estimate process will be entered on a monthly basis at the GL level.

“Estimates” will be created as a separate scenarios as follows:

Comment

Jan-Estimate (Jan-Dec). Feb-Estimate (Feb-Dec). ….etc. EDC wants to keep estimate prepared for every month till the end of the FY.

EDC can review every month estimate during the FY.

EDC teams will submit their estimates Supporting details can be attached to the Data to the Budget team. Forms for more details if required.

B_EST.1/2

No approval is needed for the estimate process. Budget team reviews the submitted estimates.

Budget team will make any required modifications on the “Reviewed” version copied from the “First Proposed” one.

Budget Team

Budget team will copy the estimate from the “Reviewed” version to the “Approved” one.

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Mapping - B_EST.1-Budget Preparation – Estimates (v.1.3) Company Confidential - For internal use only

51 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Requirement Essay

Requirement Essay

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

52 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Current versus Proposed

Practices

Policies

Procedures

Seq.

Ref./Description

Activity

Action

Cost

Time

Resource

1. 2. 3. 4. 5. 6. 7. 8. 9. 10.

.

Current versus Proposed

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

53 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Mapping Solution Solution Components

Workaround

Application Enhancement

Reengineering Opportunity

Solution/Design Document Reference

Mechanism

Interfaces 1.

Oracle GL.

2.

HR system.

3.

Fixed Assets.

Solution Technique

Mapping Solution

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

(v.1.3) Company Confidential - For internal use only

54 of 55

BR.030 Business Requirements Mapping Form

Doc Ref: EDC-HP-PLN

Open and Closed Issues for this Deliverable Open Issues

ID

Issue

Resolution

Responsibility

Target Date

Impact Date

Resolution

Responsibility

Target Date

Impact Date

Closed Issues

ID

Issue

Hyperion Planning File Ref: EDC BR030_Hyperion_Planning

Open and Closed Issues for this Deliverable (v.1.3) Company Confidential - For internal use only

55 of 55

Related Documents

Edc
November 2019 16
Edc
May 2020 15
Edc
June 2020 10
Edc Q1
June 2020 9
Edc 2009
June 2020 5
Ec1201 Edc
May 2020 7

More Documents from ""