Edc Br030_hyperion_planning_v1.3.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
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 7More Documents from ""
Edc Br030_hyperion_planning_v1.3.pdf
May 2020 2
Crm System Brainstorming.docx
May 2020 0
Create Soa Application (hello World).docx
May 2020 0
