CONSTRUCTION SUBCONTRACT ENGINEERTECHNICAL OFFICER Presentation CSE_Prism.pptx

CSE Introduction and Definition of Scope
Organizational Structure & Interfaces
CSE/technical officer - project construction requisitioning/management of construction contracts
CSE/technical officer – monitoring and control of construction budget changes
DATAS ANALYSIS- REPORTING
PRISM

1. Construction Subcontracts Engineering

2. BACKGROUND, OBJECTIVES & INTRODUCTION OF CONSTRUCTION SUBCONTRACT ENGINEER/TECHNICAL OFFICER

3. CONSTRUCTION PROCUREMENT MANAGEMENT FOR CSE/TECHNICAL OFFICER INTRODUCTION OF CONSTRUCTION SUBCONTRACT ENGINEER/TECHNICAL OFFICER CSE Introduction and Definition of Scope Organizational Structure & Interfaces CSE/technical officer - project construction requisitioning/management of construction contracts CSE/technical officer – monitoring and control of construction budget changes DATAS ANALYSIS- REPORTING PRISM COURSE OUTLINE

4. CSE Introduction and Definition of Scope Directly under CONSTRUCTION DEPARTMENT will be responsible for the implementation and management of the below main activities: Manage and follow-up the process of CONSTRUCTION PURCHASE REQUISITION inclusive of the accounting process for CONSTRUCTION CONTRACTS. Ensure the Management of Change of Construction works and contracts, in terms of New Prices, Change Work Orders, Back-charges, assessment of cost impact determined by change, technical and preliminary commercial alignment vis à vis Subcontractors. Assist the CONSTRUCTION Manager in monitoring and control of Construction Budget and Forecast CONSTRUCTION SUBCONTRACT ENGINEER (CSE)/Technical Officer

5. Construction Procurement Plan Management Improve the processes of development of Construction Procurement Plan to guarantee the provision of material , equipment , works and services required for Construction execution . Improve the management of Construction requisitioning from Material Requisition to Technical Bid Evaluation. Subcontracts Monitoring & Reporting Set up of Construction Cost monitoring system (Prism Costruction modules). Set up of Construction costs reporting (Power BI). Subcontracts Management of Change Monitoring of Subcontracts cost deviations based on work volume variation along with design development and work changes . E nsure cost segregation and management of change capitalization in accordance with Company standards CSE Introduction and Definition of Scope

6. CSE/Technical Officer Tools SAP (v. 740) Knowledge in available SAP Shortcuts Microsoft Excel List of Frame Agreements/Blanket Orders List of WBS Codes List of Commodity Codes (also available in the List of Vendors) List of Vendors (downloaded per Country) List of SAP Unit of Measurements Extra Price Codes List for SAP List of Unloading Points SAP Commands for Work Order/Delivery Order Clauses

7. Work Progress Verification Additional scope/ descoping management Monitoring & Reporting PO/Contract Estimate to Complete/Forecast PO/Contract Scope of Work Progress Payment/SES Management Construction Budget Forecast Update Construction Procurement Plan Management Accounting Services and Direct Hiring Works Change Orders, Claims and Back-charge management

8. ORGANIZATION AND INTERFACES FOR THE CONSTRUCTION SUBCONTRACT ENGINEER/TECHNICAL OFFICER

9. Tiziana Marziano CONSTRUCTION SUBCONTRACTS ENGINEERING PROJECT STAFF PROJECT COORDINATION SUBCONTRACTS AND REQUISITIONING Lucrezia Traverso SUBCONTRACTS MANAGEMENT OF CHANGE Saltanat Tilembulova CONSTRUCTION COSTS MONITORING & REPORTING Claudia Porzio STAFFING CSE INTERNATIONAL Kakuko Sugawara Ensure Requisitioning process for construction works, subcontracted and in Direct Hiring, construction supplies and services. Ensure Accounting process of Direct Hring works , Construction supplies and services Ensure the set up of Construction Cost monitoring system into Prism suite (modules Project, Contracts, Invoices and Change Management) Ensure the set up of Construction costs reporting ( Power BI) Interface with Construction Performance Indicators and Monitoring (Pascarelli). Ensure cost estimates of Construction scope of work changes including New Prices and Change Work Orders Ensure cost classification and capitalization in accordance with Company standards Interface with QUMAN (Cannea) Ensure Staffing Plan of international construction subcontracts engineers for ONSHORE projects CSE Introduction and Definition of Scope-Organizational Structure & Interfaces – HOME OFFICE

10. CONSTRUCTION PROJECT MANAGEMENT CONSTRUCTION SUBCONTRACT ENGINEER (CSE) PROCUREMENT DEPARTMENT POSE DEPARTMENT FINANCE DEPARTMENT PROJECT CONTROL PROJECT CONTRACTS DEPARTMENT END-USERS, REQUESTORS, PROJECT TEAM MEMBERS (PTM) PROJECT PROJECT NEEDS AND CONSTRUCTION PROGRESS FEED CSE ACTIVITIES CSE Introduction and Definition of Scope-INTERFACES

11. CONSTRUCTION SUBCONTRACT ENGINEER/TECHNICAL OFFICER - PROJECT CONSTRUCTION REQUISITIONING/MANAGEMENT OF CONSTRUCTION CONTRACTS

12. CSE/Technical Officer Responsibilities Reports to CONSTRUCTION MANAGER Assist the CONSTRUCTION MANAGEMENT in: Implementation and management of a clear and consistent CONSTRUCTION REQUISITIONING WORKFLOW Implementation, management and control of REQUISITIONING MONITORING REPORT Monitoring and control of CONSTRUCTION SUBCONTRACTS relevant to SAP Accounting Coordinate all activities related to CONSTRUCTION REQUISITIONING including interfacing with other DEPARTMENTS/FUNCTIONAL LINKS Monitor and ensure that all tasks on CONSTRUCTION REQUISITIONING are properly executed and within reasonable timeframe Prepare, update and send out (PERIODIC or SITUATIONAL) report/s informing stakeholders regarding the status of their material or service request/s. Specific to this requirement, the CSE shall use the REQUISITIONING MONITORING REPORT (RMR) as a standard. Create reports based on the requirements of the CONSTRUCTION MANAGEMENT A Qualified Expert in SAP able not only to raise PR, SES, WO/DO, etc. but also: Recognize the necessary documentations and technical data required to proceed with every SAP transaction (PR, SE, WO/DO, etc.) Able to discern which SAP document to issue per requirement of the CONSTRUCTION/PROJECT (i.e. PR for Contract/PO vs. PR for Blanket Order/Frame Agreement, PR for Contract vs. Work Order, etc.) Resolve SAP and REQUISITIONING issues/offer solutions on navigational concerns of the SAP system BUILD and ENSURE that a proper/organized documentation of all activities relevant to CONSTRUCTION REQUISITIONING/CONSTRUCTION CONTRACTS MANAGEMENT is being undertaken, maintained and updated Ensure that the COMPANY STANDARDS relevant to CONSTRUCTION REQUISITIONING/MANAGEMENT OF CONSTRUCTION CONTRACTS are properly adhered to Shall liaise with Third Parties for the transmission of released and approved Work Order, Delivery Order, if required the CSE will provide the accepted SES including the approved documentation to the person in charge for transmission to the Vendor/Subcontractor. In the absence of specific indication by the Project, the CSE may transmit to the Vendor/Contractor. Train and develop Technical Officer. Ensure adequate and proper TRANSFER OF INFORMATION CONSTRUCTION SUBCONTRACT ENGINEER (CSE)/TECHNICAL OFFICER Scope: PROJECT CONSTRUCTION REQUISITIONING/MANAGEMENT OF CONSTRUCTION CONTRACTS

13. CSE Definition of Scope INTERVENTION OF CSE/TECHNICAL OFFICER PROCUREMENT PHASE REQUISITIONING PHASE POST AWARD PHASE PROCUREMENT DEPARTMENT POST ORDER DEPARTMENT IMPLEMENTATION, MANAGEMENT & CONTROL OF CONSTRUCTION REQUISITIONING PROCESS MONITORING, FOLLOW-UP AND REPORTING SYSTEMATIC DOCUMENTATION, DATA ARCHIVING AND STORAGE OF REQUISITIONING INFORMATION INTERFACE WITH OTHER DEPARTMENTS/WORK UNITS/FUNCTIONAL LINKS IN RELATION TO CONSTRUCTION PROCUREMENT SAP ACCOUNTING MONITORING, FOLLOW-UP AND REPORTING SYSTEMATIC DOCUMENTATION, DATA ARCHIVING AND STORAGE OF SERVICE ENTRY INFORMATION SCOPE AND FOCUS OF CSE/TECHNICAL OFFICER

14. Supply Chain activities breakdown Saipem Supply Chain process

15. Construction Procurement Workflow MATERIAL & SERVICE CONSTRUCTION PROCUREMENT WORKFLOW MATERIALS PURCHASE REQUISITION FORM (PRF) PURCHASE REQUEST CREATED INSIDE SAP PURCHASE ORDER RECEIPT OF GOODS MATERIAL ENTRY IN SAP (ASO) VENDOR PAYMENT PROCUREMENT or POST ORDER or END USER or ORIGINAL REQUESTOR or PROJECT MANAGEMENT or CONSTRUCTION MANAGEMENT CSE/TECHNICAL OFFICER PROCUREMENT END-USER/ REQUESTOR/ WAREHOUSE POST ORDER DEPARTMENT FINANCE DEPARTMENT * Presence of Construction Subcontracts Engineer/Technical Officer in Procurement Cycle * SERVICES PURCHASE REQUISITION FORM (PRF) PURCHASE REQUEST CREATED INSIDE SAP CONTRACT COMPLETION OF SERVICES SERVICE ENTRY IN SAP (SES) VENDOR PAYMENT PROCUREMENT or POST ORDER or END USER or ORIGINAL REQUESTOR or PROJECT MANAGEMENT or CONSTRUCTION MANAGEMENT Subcontractor jointly with END-USER/REQUESTOR/ Management of the Project CSE/TECHNICAL OFFICER * PROCUREMENT CSE/TECHNICAL OFFICER * FINANCE DEPARTMENT POST AWARD PHASE POST AWARD PHASE

16. CSE – post award phase C se is in charge to monitoring and control subcontractor scope of work. important point for this purpose in the managment of quantyties that are monitored trought 2 systems . SAP PMIS PMIS QUANTITY FLOW

17. SAP ACCOUNTING Work Progress Verification Additional scope/descoping assessment Monitoring & Reporting PO/Contract Estimate to Complete/Forecast PO/Subcontract Progress Payment/SE Management Construction Budget Forecast Update Change Orders, Claims and Back-charge assessment CSE – post award phase MANAGEMENT & CONTROL OF POST AWARD PHASE

18. CONSTRUCTION SUBCONTRACT ENGINEER/TECHNICAL OFFICER – MONITORING AND CONTROLL OF CONSTRUCTION BUDGET CHANGES

19. CSE/Technical Officer Responsibilities Construction Cost Estimation is relevant part of Project Status Report (PSR). The main purpose of Project Status Report (PSR Forecast) is to analyze and monitor the total overall project cost expenditure if in line with the initial contract value. The Project Status Report (PSR Forecast) is under the responsibility of Project Services Management Department (PSM). The Construction Cost Estimation is under the responsibility of CONSTRUCTION Department to analyses the budget cost related to all construction activities agreement with Subcontractor by estimating the overall scope of works based on the contractual documents (i.e. BOQ, IFC drawings, Site Instruction, Site Technical Query, vendor drawings, packing list and engineering data (i.e. MED, CITEL, BOM, etc.). As per above, CSE is in charge to: Assist the CONSTRUCTION MANAGEMENT TEAM in: In the monitoring and control of CONSTRUCTION BUDGET and FORECASTING Coordinate all activities related to CONSTRUCTION CHANGES in term of COST IMPACT Monitor, control and ensure that task as SITE INSTRUCTION /TECHNICAL QUERY /FIELD DESIGN CHANGE have been properly accounted and assessed in term of project cost impact. Monitor, control and ensure that all changes in quantities (CWO) , originated from engineering development or construction purposes, have been properly accounted and assessed in term of project cost impact. Prepare, update and send out (PERIODIC or SITUATIONAL) report/s informing stakeholders regarding the status of CONSTRUCTION BUDGET – ORIGINAL/ REVISED/ACTUAL/FORECAST Assessment on Construction New prices CONSTRUCTION SUBCONTRACT ENGINEER (CSE)/TECHNICAL OFFICER Scope : MANAGEMENT OF CONSTRUCTION BUDGET CHANGES CWO includes, but it is not limited to, the following types of work:   operations already completed but requiring further action because of revisions to drawings; specifications or written instructions directly from the Contractor; operations additional to those initially provided for in the project; operations arising from any non-conformity in construction; operations following damage caused by third parties.   CWO’s are recognized in the accounts using by either of, or combinations of, the following methods:   Use of existing prices and/or new prices agreed previously; Recognition of a lump sum; Amount based on time rate, or in terms of price list articles measured in hours ( labour /equipment)

20. CSE is in charge of monitoring and control SOW deviations in order to provide the Project Management team with Construction costs forecast analysis SOW Subcontracts Management of Change

21. Cost changes cluster application Monitoring & Reporting Subcontract Estimate to Complete/Forecast Subcontract Scope of Work SOW monitoring (as per BOFF, FDC, SI, etc ) Construction Budget Forecast Subcontracts Management of Change Subcontract additional scope/ descoping management Change Orders, Claims and Back-charge management

22. SITE INSTRUCTION The SITE INSTRUCTION is a document that the PROJECT is required to use when the CONTRACTOR needs to raise an instruction for its SUBCONTRACTOR based, but not limited to, the following site condition : Additional instructions Particular construction sequence activities New or additional material procurement EXAMPLE OF SI ENGINEERING/CONSTRUCTION CSE/TECHNICAL OFFICER DOCUMENT CONTROLER Refere to the attached Excel Report- SITE INSTRUCTION LOG- here reported for reference to note down COST VARIATION due to SI * * Cost impact relevant for construction activities/ portion

23. SITE TECHNICAL QUERY The SITE TECHNICAL QUERY is a document that the SUBCONTRACT raise in order to require additional clarification related to engineering or construction outstanding issues. EXAMPLE OF STQ ENGINEERING/CONSTRUCTION CSE/TECHNICAL OFFICER DOCUMENT CONTROLER Refer to the attached "SI log" here reported for reference and customizable for note down COST VARIATION REGISTER - STQ * Cost impact relevant for construction activities/ portion *

24. FIELD DESIGN CHANGE With Field Design Change it is means any modifications including revisions, additions and deletions initiated at Contractors Site Office to the engineering documents prepared by the Contractor and its Subcontractor. It does not include cosmetic changes or correction of typographical errors in the engineering documents, for which technical judgment is not required. FDC are classified as: Major field design changes : that may be subject to a Contract Change Order. Minor field design changes : that are those that do not affect the basic design requirements, such as dimensional, positional or directional changes to solve/avoid interferences or to adjust distance between structures and facilities. Or are classified as per types of « initiations » they have : (1) Field design changes from Company (2) Field design changes from Contractor’s Site Office: field design changes proposed by the Contractor’s organization at Contractor’s Site Office to solve conflicts between organizations or to rectify incorrect or incompatible design output found during the construction stage. (3) Field design changes from Subcontractor : field design changes proposed by Subcontractor to solve conflicts found at Site during construction . (4) Where quick action is required , design changes initiated at Contractor’s Home Office on drawings already issued for construction shall be handled as field design changes and / or advance revision notice

25. FIELD DESIGN CHANGE- TYPE (1) ENGINEERING CSE/TECHNICAL OFFICER DOCUMENT CONTROLER Refer to the attached "SI log" here reported for reference and customizable for note down COST VARIATION REGISTER - FDC * Cost impact relevant for construction activities/ portion * COMPANY Same approch taken for FDC type (1) has to be adopted for CLIENT REQUEST OF CHANGE - Request of Change in Sow or additional Scope.

26. FIELD DESIGN CHANGE- TYPE (2)-(3)-(4) ENGINEERING/CONSTRUCTION CSE/TECHNICAL OFFICER DOCUMENT CONTROLER Refer to the attached "SI log" here reported for reference and customizable for note down COST VARIATION REGISTER - FDC * Cost impact relevant for construction activities/ portion *

27. Typical CHANGE WORK MANAGEMENT Responsibility Matrix

28. CWO REQUEST SAMPLES

29. MANAGEMENT OF CONSTRUCTION BUDGET CHANGES Trasmittal to the SUBCONTRACT for relevant action Site Instruction , Site Tecnical Query, Field Design Change and Change work order , can entail a CONTRACT SUBCONTRACTOR REVISION in which CSE is deeply involved CSE/TECNICAL OFFICER PROCUREMENT CSE Ensure that revised PO with relevant quantities are properly aquire by SAIPEM System and update CSE monitoring of budget analisys

30. SOW Change SOW CHANGE WORKFLOW ( additional scope / de- scoping ) PCON/ PM ENGINEERING MSQM/CSE CSE CSE ENGINEERING QUANTITY UPDATE BOFF REVISION ESTIMATION / PRICED BOQ/NEW PRICES SUBCONTRACTS FORECAST ANALYSIS CONSTRUCTION BUDGET FORECAST Legend : Responsible Subject/Department Start-End action/output Action/ Authorization Bill of Quantities are estimated and periodically reviewed by technical depts. Quantities are estimated for each main item and for each bill item in order to enable a detailed definition of the work scope Sub-contractor packages are based on BOQ and defined by construction dept. to fit subcontractor capabilities.

31. Input Quantities from Technical Dept WBS review if required BOFF new revision release Process Receive quantities from Technical Dept * Interface with Techical Dept Import quantities in BOFF Extract Overall BOQ for the whole project BOQ review and check Format Format available from BOFF (i.e. BOQ, data export) Deliverables/Output BOQ in BOFF format Quantities export from BOFF SOW Change QUANTITIES in BOFF/BOQ - REVISION Note: * Civil quantity is uploaded into Sioc , a dedicated application managed by the civ dept., for the transmission of the civil quantities according to the bill items. Mechanical quantity is imported into Mechanical Qty dedicated tool Electrical quantity is managed via Arcobase , a format pre-defined excel sheet. Painting and Insulation quantities are imported via Coiver , a format pre-defined excel sheet.

32. Input Export data from BOFF Subcontractor contract contractual price lists and Preambles ( Contract documentatation ) Standard SAIPEM library GENANAG QMR ( Quantity Management Report) updated (URANIA REPORTS/STARGATE) Process Set up the BOQ extraction by WBS/discipline/ subcontractor scope or specific activities defined by project requirements ( e.g Demolitions , de- scoping BoQ , etc ) Populate the priced BOQ with appropriate labour and material unit prices/ lump sum prices listed in the Subcontractor contract /price lists, and where required interpolate/extrapolate New Price * for bill items not covered in the contract . Add efficiency and productivity factors Calculate SMH and EMH in excel export data from BOFF Adjust mechanical quantity for EMH as per QMR report Format Format available from BOFF (i.e. BOQ, data export) Deliverables/Output Priced BOQs customized / adjusted SOW Change E STIMATION / PRICED BOQ / NEW PRICES Note: * NEW PRICE is a price related to an activity already included in the Scope of Work which : is not covered by any unit prices and/or lump sum prices provided in the Work Conctract Documents is covered by unit prices and/or lump sum prices provided in the Work Contract Documents but Contractor desire such activity to be split for separate accounting.

33. SOW Change BOQ / WBS STRUCTURE / PRICED BOQ / STANDARD PRICE LISTS SAMPLES Quantities are estimated per each WBS & BILL ITEM , based on Saipem standard libraries GENANAG , and periodically updated by Engineering depts. in order to guarantee full reliability of scheduled budget and timing. Standard & Expected man hours are calculated based on STANDARD EFFICIENCY RATES and PERFORMANCE FACTORS (K1) . The Price List is a listing of Bill Items grouped by discipline and organized by related works. Description — U.M. — Efficiency — SubCMC / CMC / Discipline — K SCMC (Factor to convert Bill Item quantities in SCMC quantities). PRICE LIST

34. SOW Change The Preamble is a contractual document with exclusions and inclusions considered when a Bill Item is priced (both Direct and Indirect Charges). It also includes the Method of Measurement used for accounting of activities. There is a specific Preamble for every DISCIPLINE Price List. PREAMBLE SAMPLES

35. SOW Change BILL OF QUANTITIES represent the project scope of work (entire or partial). BOQ is a list of STANDARD BILL ITEMS and the related QUANTITIES. BILL ITEMS are PRICED by the relevant sub-contractors prices in order to have the precise estimation as per Subcontractor scope of work. BILL ITEM CODES are same for all projects managed by PMIS, enabling to make cross-checks between different quotation. BOQ progressive updates enable to TRACK quantities, man hours and cost TRENDING based on different BOFF revisions. PRICED BILL OF QUANTITIES (BOQ) SAMPLE

36. SOW Change NEW PRICE MANAGEMENT WORKFLOW NP APROVAL CYCLE PM CSE/SUBCON CM/SCM/CSE SUBCON REQUEST FOR NP ESTIMATION NP ESTIMATION ( internal / subcon ) NP EVALUATION NP FORM SUBMITTAL NP INPUT INTO COLAV SUBCON/CSE/PM/CM/SCM MSQM CONTRACTOR, SUBCONTRACTOR might be required to carry out work for which there are no applicable rates and prices in the contractual price list. Prior to issuing an instruction or authorizing any NEW PRICE, the Subcontractor is required to submit an estimate of the NEW PRICE. Any New Price shall be governed by all the provisions of the Work Contract Documents, and shall be inclusive of all Subcontractor’s costs, including Direct Costs, Indirect Costs, Overhead, Home Office costs and Profit. The estimate of the NEW PRICE shall be prepared in accordance with one of the methods/principles as per the following order of precedence: The estimates shall be valued at the appropriate unit rates/lump sum prices of the Work Contract and with possible coefficients already provided in the Work Contract Documents. The estimates shall be valued by reference to and consistent to the existing unit rates/lump sum prices listed in the Contract. The estimates shall be valued on unit rates/lump sum price basis providing a detailed breakdown and back up documentation of the proposal along with execution statement, the list of resources (personnel and equipment) and a time schedule. The estimate of the New Price shall, if possible, include also an estimate of the quantity accounted with the New Price. When possible, the proposal shall be base on comparison, analogies and interpolations with the original Work Contract breakdowns of prices If the New Price proposal gets the CM approval, then such new rate or price shall be named as “New Price” and incorporated into the Contract. The NP shall be numbered as follow: NP CIV 001 Civil Works NP MEC 001 Mechanical Works NP ELE 001 Electrical Works NP SMT 001 Instrumentation and Telecommunication Works NP INS 001 Insulation Works NP PNT 001 Painting Works

37. SOW Change NEW PRICE REQUEST FORM Features of New Price to be specified are: Date of New price issued / approved. New Price code attribute; UoM (unit of measurement); Total Price (composed by Labour Price and Material Price); Estimated quantity; Approvals signature by Contractor and Subcontractor

38. SOW Change SUBCONTRACTS FORECAST ANALYSIS To prepare the first Forecast analysis, all data available at the Award Stage of the Contract shall be taken as an initial estimation (BOQ quantities and Prices, SOW, schedule, contract documentation, bid clarifications, etc ). Sometimes the data prepared at the Bid Phase can be utilized to identify the original quantities or SOW passed to the Subcontractor at the Award stage. P eriodical updates by Engineering depts in BOFF shall be reflected via updated current forecast analysis, including internal estimation for the scope of provisional New Prices in order to guarantee full reliability of scheduled budget and timing. BOQ progressive updates enable to TRACK quantities, man hours and cost TRENDING based on different BOFF revisions versus the Original Control Budget/Revised Control Budget and/or Previous Forecast.

39. ORGANIZATION AND INTERFACES FOR THE CONSTRUCTION SUBCONTRACT ENGINEER/TECHNICAL OFFICER

40. DATAS ANALYSIS- REPORTING

41. COURSE OUTLINE 1) CONTRACT (PO) ANALYSIS: SAP 1.1) ZMR0 Display Purchasing Documents 1.2) CJ03 WBS Element Overview 1.3) ZJMU28 PMIS 2.1) BOFF 2.2) COLAV 2.3) QLIK DATA PROCESSING PRISM 4.1) Introduction to software 4.2) Contracts 4.2.1) Introduction 4.2.2) 4.3) Invoice 4.3.1) Introduction 4.3.2)

42. 24_84 33_84 38_84 18_84 2064_84 30_84 55_84 ANALYSIS REPORTS (DASHBOARD BI) CSE STUDY OF PO STUDY OF DOCUMENTS ATTACHMENT AND EXPORT CONTRACT CSE (INTERFACE WITH MSQM) CHANGE WORK ORDER NEW PRICE EXPORT FROM: - BOFF COLAV/QLIK REPORT Δ QUANTITIES 1) 2) DATA PROCESSING FROM USER 3) UPLOAD IN PRISM 4)

43. The Main SAP transactions for analysis and collection data for input in Prism are : 1.1) ZMR0 Display Purchasing Documents 1.2) CJ03 WBS Element Overview 1.3 ) ZJMU28 (PR/PO Positions List) CONTRACT ANALYSIS STUDY OF PO The initial Step is to retrieve the history of all contracts from SAP ( starting from Revision 0 to the last revision ) and collect all the necessary information interfacing with the whole project : - Contractor - SOW and Deviation - Base Amount - Price List - Documentation Attached - NP and CWO ( see slide … ) REV x REV 1 REV 0 1) FOR ALL SAP TRANSACTIONS YOU MUST REFER TO SAP GUIDE All information about Change SOW , Initial Boq , WBS etc. must be implemented at this early phase to have an overall view of the single Contract

44. SAP TRANSACTIONS FOR DATA ANALYSIS 1.1) ZMR0 Display Purchasing Documents Research parameter : Order Number (Purchase Order or Contract) The transaction permit to visualize details related to a specific Order as: 1. Document Type 2. Revision n° 3. Vendor/Subcontract SAP CODE n° 4. Incoterms condition 5. Current order Amount and Original Order Amount 6. Exchange utilized for PO emission 7. Order Validity period 1 5 7 4 2 6 3 PAY ATTENTION AT THE INCREASE OF CONTRACT AMOUNT FOR ALL REVISION. Contract annexes and Price Lists can be downloaded from SAP for analysis and uploaded into Prism . 1) CONTRACT ANALYSIS

45. The report provides the following details: Work Breakdown Structure Overall list of Project WBS organized per WBS hierarchy and able to be copied in an Excel file (using Ctrl+Y ) Graph of Project WBS R esearch parameter : Job Number SAP TRANSACTIONS FOR DATA ANALYSIS 1.2) CJ03 WBS Element Overview Choose only CONSTRUCTION WBS for Export 1) CONTRACT ANALYSIS

46. PR list PR emission date Item(s) full descriptions Item(s) value Currency Research parameter : Company Code and Job number or Consolidate Project The report provides the list of committed amounts and actuals amounts including details of: JOB NUMBER COMPANY CODE PO list PO emission date Item(s) full descriptions Item(s) consolidated value Vendor name Vendor SAP code SAP TRANSACTIONS FOR DATA ANALYSIS 1.3) ZJMU28 (PR/PO Positions List) Orders issued by the Branch as per default are not included _ to be flagged √ √ √ Including Invoicing Info To be flagged in order to run the report in background mode STEP 1 Background Report download-Excel file 1) CONTRACT ANALYSIS

47. STEP 2 √ √ √ After Click on «Immediate», «Save» button as to be pressed 1 3 Background Report download-Excel file 2 Excel file can be downloaded by the transaction ZJMU28D after a “background Run Process” (F9) Select the file to be downloaded 2 Click here to download the Excel file 3 1 First to click here in order to visualize the file in the export part SAP TRANSACTIONS FOR DATA ANALYSIS 1.3) ZJMU28 (PR/PO Positions List) 1) CONTRACT ANALYSIS

48. 1.3) ZJMU28 (PR/PO Positions List) OUTPUT ZJMU28 FILE : excel format All Columns highlighted in YELLOW are the most important for data processing ABOUT PO ABOUT PR COMPANY CODE PROJECT JOB NUMBER WBE PO TYPE: S= SERVICE; M= MATERIAL PO DESCRIPTION PO NUMBER 1) COST ELEMENT CONTRACT ANALYSIS PO REVISION PO APPROVED DATE

49. 1.3) ZJMU28 (PR/PO Positions List) OUTPUT ZJMU28 FILE : excel format All Columns highlighted in YELLOW are the most important for data processing ABOUT PO PO LINE ITEM PO LINE ITEM DESCRIPTION SES: SERVICE ENTRY NUMBER ABOUT PO 1) CONTRACT ANALYSIS PO QUANTITY PO AMOUNT PO CURRENCY GR: GOOD RECEIPT NUMBER SES/GR DESCRIPTION GR/SES UNIT OF MEASURES GOOD RECEIPT QUANTITY SE/GR AMOUNT SES/GR ACCEPTED DATE SERVICE ENTRY QUANTITY

50. 1.3) ZJMU28 (PR/PO Positions List) The report provides the list of GR/SES Number associated for each PO: CSE/TECHNICAL OFFICER END USER or ORIGINAL REQUESTOR or PROJECT MANAGEMENT or CONSTRUCTION MANAGEMENT PROJECT MANAGER TECHNICAL OFFICER Verify and validate progress payment report submitted by Subcontractor Approve Service Entry Sheet in SAP Transmit SES to Subcontractor (in copy Requestor , End User, Project Control, Finance, Project Manager, etc.) Create Service Entry Sheet and attach relevant documentation To permit Contracts payments, each invoice has to be linked to a SES. Legend : Responsible Subject /Department Start-End action/output Action/ Authorization CONTRACTS OUTSIDE PMIS SES shall be prepared in agreement with the official Work Progress and the Certificate of Payment given by COLAV that has to be attached to the SES SES shall be prepared in agreement with the Progress of the activities certified by Subcontractor and Saipem representative in charge for the activities. All documentation in support to the authentication of the execution of the activities has to be attached in SES INSIDE PMIS A list of services performed by a vendor on the basis of a purchase order, containing service descriptions and details of quantities and values A goods receipt document listing delivered goods that have not been billed yet. SES Number ( Service Entry Number ) GR Number (Good receipt number ) 1) CONTRACT ANALYSIS

51. The tools are all automated software integrated together within the suite PMIS needed to manage the information generated during Project estimation, planning, execution and handover activities. PMIS is based on standard methodologies, the aim of the suite is represented by the conjunction of information through Engineering, Procurement and Construction departments, ensure the full control of work activities such as, projects materials, construction quantities, man-hour and costs, full traceability of quality documents needed for mechanical completion and plants handover. PMIS provides standard output, like data and reports, necessary to analyze the performance of the various project activities and to satisfy Company requirements. The management of information, its elaboration and sharing are considered essential activities for the project execution because they put in connection different projects functions, such as internal departments, Company, vendors and subcontractors. It ensure the full control of construction quantities and man-hour estimated from bid phase up to project handover to final user, share full knowledge of project progress by WBS / WorkClass / Item / Systems and performance analysis and manage all the activities related to the project execution.   PMIS 2) PMIS (Project Management Information Systems) Introduction

52. PMIS (Project Management Information Systems) Tools PMIS 2)

53. PMIS PMIS ACCESS Step 1.1 Step 1 Go to the CITRIX Shortcut on your desktop and click it Go to PMIS (Prod new release) and click it Open the LOGON SCREEN and enter your USERNAME and PASSWORD Click on BOFF or COLAV icon 2)

54. BOFF 2.1) Evaluate and assess the projects magnitude in terms of quantities , hours and costs from bid to execution phase . The quantities estimated by each Engineering Department shall be collected and analyses by TM before send to construction to manage into BOFF . BOFF Introduction 2.1.a) Export Total Quantities 2.1.b) Export BOQ Quantities It returns all quantities for Project for single Revision divided in to WBS, all disciplines, Bill Item, Subcmc , Cmc , Efficiency It returns all quantities for single discipline, area, Bill Item. * The new feature that will be implemented is the Boff setting of unit prices (labor + material) from BoQ   Home Office Proposal project Home Office Execution project Site Execution project Form Resp. Actions Resp. Actions Resp. Actions n.a. n.a. MSQM With the support of the CSE must guarantee the correct implementation of several function of BOFF in order to ensure full traceability of any variation of quantities and Cost. MSQM Must updates the BOFF, at the periods specified for the project, based on the quantities submitted by the PSLs / FEM n.a. n.a. CSE Forecast cost analysis based on updated quantities CSE BOFF update as per IFC drawings issued by Engineering. Forecast cost analysis based on updated quantities including site modifications, extra works and consistently with engineering quantities

55. EXPORT QUANTITIES Click Utility Step 2.2.a 2.1.a ) EXPORT TOTAL QUANTITIES Click Quantities Step 2.1.a BOFF 2.1) Click Export Quantity Step 2.3.a Choose the Project through JOB Number or ID nr. (F7+write Job/Id nr. + F8) Step 2.4.a

56. EXPORT QUANTITIES Choose BOFF Revision and click to Pick-up a Bid Rev. Step 2.5.a Note: BOFF Rev. -the updated Boff Rev. to be confirmed by QUMAN and Project. - Good practice is to use the frozen Rev., ( this flag indicates that the BOQ is protected from changes ) but sometimes for especially situations can use the Rev not officially frozen. Locate the file in the folder : “V:\temp” Step 2.6.a 2.1.a ) EXPORT TOTAL QUANTITIES Job Type : V : Official Job O : Bid Job Step 2.7.a Save files divided by folder with the name of revision : “Job Id_n ° Rev” BOFF 2.1)

57. 2.1.a ) EXPORT TOTAL QUANTITIES BOFF OUTPUT BOFF FILE : excel format All Columns highlighted in YELLOW are the most important for data processing BOFF REV. NUMBER JOB NUMBER WBS LIV.1 AND DESCRPTION LIV.1 WBS LIV.2 AND DESCRPTION LIV.2 WBS LIV.3 AND DESCRPTION LIV.3 WBS LIV.4 AND DESCRPTION LIV.4 WBS LIV. x AND DESCRPTION LIV.x For each WBS level the description contains the most important information about BOQ, disciplines DESCRIPTION LIV 1 BILLITEM LIV. 1 BASE BILL ITEM BILLITEM LIV. 2 BILLITEM LIV. x DESCRIPTION LIV.2 DESCRIPTION LIV.x DESCRPTION BASE BILL ITEM UNIT MISURE CMC SUB CMC BOFF QUANTITY EFFICIENCY 2.1)

58. 2.1.b ) EXPORT BOQ QUANTITIES Click on Prices Step 2.1.b Click Transfer Boqs to Excel Step 2.2.b Before start the export must always click on Refresh to Before Trasfer Step 2.3.b BOFF 2.1)

59. This pane lists the disciplines activated for the job and have to be selected individually. 2.1.b ) EXPORT BOQ QUANTITIES Step 2.4.b Before start the export must always click on Refresh to Before Trasfer Locate the file in the folder : “V:\temp” Step 2.5.b CMC BOFF 2.1)

60. OUTPUT BOFF FILE : excel format All Columns highlighted in YELLOW are the most important for data processing JOB NUMBER DATA EXPORT BASE BILL ITEM DESCRPTION BASE BILL ITEM UNIT MISURE BOFF QUANTITY 2.1.b ) EXPORT BOQ QUANTITIES BOFF REV. NUMBER COUNTRY PROJECT ID NR. PROJECT CURRENCY UNIT LABOUR/ MATERIAL PRICE TOTAL AMOUNT BOFF 2.1) WBS DESCRIPTION

61. COLAV 2.2) COLAV Introduction COLAV is part of PMIS suite and has been developed by Contractor to ensure the correct management of accounting works related to the Sub-contracts issued for services and for construction works. COLAV allows the complete management of the accounting for single contract and bill items, in accordance with the cost classes within the Project Breakdown Structure, via user entry of basic data, measurements, Change Work Orders, material supplies, etc.     Home Office Proposal project Home Office Execution project Site Execution project Form Resp. Actions Resp. Actions Resp. Actions COLAV n.a CSE           Processes the estimate forecast data on the basis of the quantities from BOFF, the subcontracting plan and the contracts actually issued. MSQM Initialises the subcontracting actually issued, and updates contacts entered when necessary. With the support of CSE organize the subcontract on several aggregation of cost to ensure traceability and forecast Construction Cost Checks with the support of CSE the correct interpretation of the contractual deduction clauses. Checks the correctness of the contract summary. Registers the work done (measurements and costs), on the basis of the measurements provided by the QSC, shared with the subcontractor and approved by DS. Issues the bookkeeping for approval by PM/CM. Compares the accounting with preventive bookkeeping and submits the resulting reports to the project departments, PM/CM/PCM. CSE Processes the BOFF changes, as per QSC indication, in order to remeasure the cost forecast.

62. COLAV Introduction The main COLAV functions that will use for our analysis are :   Export excel file Printout in Pdf file Type of Export : 2.2.a ) Export All Bill Item: It returns all quantities of all Projects in Colav divided for single Contract with Bill Item, Subcmc , Cmc,TW , STW and with ORIGINAL BOQ. 2.2.b ) Export Bill Item complete : it returns the quantities of the selected PO for single Project with Bill Item, description, Contractor, Subcmc , Cmc,TW , STW, Efficiency. 2.2.c ) Export WP History: it returns the payments for each Contract of selected Project with issue date. Type of printout: - Printout of contract Price Lists; - Printout of estimated and actual measurements; - Printout of Bookkeeping, Accounting, Accounting Summary, Work Progress and Certificate of Payments; - Printout of Change Work Orders, New Prices; COLAV 2.2)

63. COLAV Introduction Note: BOFF / COLAV Until now the BoQs that generate the construction subcontracts (in Boff ) were not linked to the contractual BoQ in Colav . This configuration required that the users modify manually the bill item code (prefixes and suffixes) to bypass the system constraints that did not allow to manage different prices for the same bill item per subcontractor. The cases above described are frequent, for example, if the same subcontractor is in charge to carry out his activities in BF and GF with relative different prices. (example in slide Step. 3.1 in Data Analysis) The new functionalities will be implemented for the future to connect Boff to Colav are : Set-up in Boff of the BoQs by WBS / Discipline / Bill Item 2nd Level to manage, for example, the subcontractors' scope of work split for piping prefabrication and piping erection Set-up in Boff of the unit prices (Labor + Material) by BoQ / Sub-Contractor at the time of construction subcontract assignment; the constraint is the return of the priced BoQ as soon as per SAP contract Formalization Automatic transfer of the contractual BoQs (Quantity-Prices) from Boff to Colav , avoiding the manual data entry of the subcontracts in Colav . The contractual bill items will be linked with ALL the attributes ( SubCmc / Um/K to SubCmc / Efficiency) received automatically from the Price list sett-up in BOFF project Introduction in Colav in the Bill Item section of the BoQ key field that will avoid the adoption of the suffixes / prefixes for the bill item COLAV 2.2)

64. 2.2. EXPORT COLAV Click COLAVNEW Step 2.1 Click Contract and Choose the Project Step 2.3 COLAV 2.2) Step 2.2 Click Contract

65. 2.2.a ) EXPORT ALL BILL ITEM Click Export Account Data Step 2.2.a Locate the file in the folder : “V:\temp” Step 2.3.a Click Export All Bill Item COLAV 2.2) Step 2.4.a Step 2.5.a Save files in folder named: EXPORT BILLITEMS_Colav in FILE EXPORT

66. 2.2.b ) EXPORT BILL ITEM COMPLETE From export account data, click Bill Items Complete Export Step 2.1.b Locate the file in the folder : “V:\temp” Step 2.2.b COLAV 2.2) Step 2.3.b Save files in folder named: EXPORT BILLITEMS_Colav in FILE EXPORT

67. 2.2.c ) EXPORT WP HISTORY Click Export WP History Step 2.1.c Click Export with Deduction Details Step 2.3.c COLAV 2.2) Step 2.4.c Save files in folder named: WP EXPORT in FILE EXPORT Step 2.2. c Locate the file in the folder : “V:\temp”

68. 2.2.a ) EXPORT ALL BILL ITEM OUTPUT BOFF FILE : excel format COLAV 2.2) JOB NUMBER PROJECT STATUS CONTRACT NUMBER CONTRACT DESCRIPTION CONTRACTOR UNIT OF MEASURES CURRENCY SUBCMC BOQ INITIAL TW-SUBTW LABOUR/ MATERIAL PRICE BILL ITEM OUTPUT BOFF FILE : excel format 2.2.c ) EXPORT WP HISTORY JOB NUMBER CONTRACT CONTRACT DESCRIPTION CURRENCY AMOUNT COMMITTED CONTRACTUAL MAXIMUM AMOUNT N° OF WORK PAYMENT CONTRACTOR OFFICIAL/NOT OFFICIAL ISSUE DATE

69. 2.2.) PRINTOUT FROM COLAV EXAMPLE : PRINTOUT OF PRICELIST There Pricelist report shows all Contractual Bill Item with Original Quantities and Unit Price. Pricelist divided for SubCMC with: Description Unit rate Quantities Amount Efficiency General Pricelist divided for Bill Item with: Description Unit rate Quantities Amount EXAMPLE COLAV 2.2)

70. 2.2.) PRINTOUT FROM COLAV EXAMPLE : PRINTOUT OF bookkeeping The Bookkeeping report shows all the data related to the WP, including work progress both in the scope of work of the SUBCONTRACTOR and CWOs, submitted by the SUBCONTRACTOR and approved by QS/DS/MSQM. Relevant quantities of single Tag Item are linked to applicable bill items for their payments. BILL Item divided for discipline with: TW and STW Item tag Quantities Unit Measures COLAV 2.2) EXAMPLE

71. 2.2.) PRINTOUT FROM COLAV EXAMPLE: PRINTOUT OF ACCOUNTING The accounting register shall give the amounts and quantities referred to of all measurements entered, cumulatively against such bill items relating to the period. Each measurement and quantity is valued on the basis of the prices applied and any coefficients. The amount indicated in the accounting register is the amount due to the Subcontractor from the relevant period, before any deduction in accordance with the contract. Accounting divided for Bill Item for each Disciplines with: Description Unit rate Quantities Amount COLAV 2.2)

72. 2.2.) PRINTOUT FROM COLAV EXAMPLE: PRINTOUT OF certificate of payment The certificate of payment is the final accounting document for works carried out up to the end of the period, and shows the cumulative amount, if any contractual deduction in both current and before certified payments. Amount must either be broken down by the type of work, or (as a minimum) into measure works, lump sum works, new prices, CWOs and Provisional. Maximum Amount Allowed divided for SAP Aggregation corresponding with the contract in SAP. Gross Amount divide for SAP Aggregation COLAV 2.2)

73. INTRODUCTION 2.3) QLIK REPORT Go to URANIA-Saipem Reporting and click Accounting PROD Step 2.1.a Click Overall Price List Quantities Step 2.2.a Qlik is another report which allows to analyze data for all Projects and to export: 2.3.a) Export Price List: it returns Unit Price for each Bill Item divided for Contract and its Contractor 2.3.b) Export Accounting: it returns the accounting of each Bill Item divided for Item 2.3.a ) EXPORT PRICE LIST

74. 2.3.a ) EXPORT PRICE LIST Choose the Project Step 2.3.a You can choose just single Contract or all Contracts for Project Step 2.4.a You can choose also for CMC- SubCmc Step 2.6.a You can choose for Bill Item Step 2.5.a 2.3) QLIK REPORT Save the files in folder named: PRICE LIST in QLIK: PRICE LIST Step 2.7.a Divide the Export Price List in folders updating it. Step 2.8.a

75. 2.3) QLIK REPORT 2.3.a ) EXPORT PRICE LIST OUTPUT qlik FILE : excel price list Contract Contractor Contractor Descr Curr . Bill item 1st Code 1st Code Descr 2nd Code 2nd Code Descr 3rd Code Description T.of Work TW Description Sub T. of Work STW Description 1210649 PETR01 PETROJET SAR BC 54 03 A BC C I V I L W O R K S 54 EXCAVATION 03 in earth 010B Measure Works Brown field AA CIVIL WORKS 1210649 PETR01 PETROJET SAR BC 54 05 A BC C I V I L W O R K S 54 EXCAVATION 05 in earth 010B Measure Works Brown field AA CIVIL WORKS 1210649 PETR01 PETROJET SAR BC 54 06 A BC C I V I L W O R K S 54 EXCAVATION 006 in earth 010B Measure Works Brown field AA CIVIL WORKS 1210649 PETR01 PETROJET SAR BC 54 06 B BC C I V I L W O R K S 54 EXCAVATION 006 in soft rock ( sismic velocity Vp <1530 m/s as per table 1, SAES-A-114) 010B Measure Works Brown field AA CIVIL WORKS 1210649 PETR01 PETROJET SAR BC 54 09 A BC C I V I L W O R K S 54 EXCAVATION 09 in earth 010B Measure Works Brown field AA CIVIL WORKS 1210649 PETR01 PETROJET SAR BC 54 10 A BC C I V I L W O R K S 54 EXCAVATION 10 in earth 010B Measure Works Brown field AA CIVIL WORKS 1210649 PETR01 PETROJET SAR BC 54 10 B BC C I V I L W O R K S 54 EXCAVATION 10 in soft rock ( sismic velocity Vp <1530 m/s as per table 1, SAES-A-114) 010B Measure Works Brown field AA CIVIL WORKS 1210649 PETR01 PETROJET SAR BC 54 11 C BC C I V I L W O R K S 54 EXCAVATION 11 BNP-CIV-001 in hard rock ( sismic velocity Vp >1530 m/s as per table 1, SAES-A-114) 030B New price (NP) Brownfield CA New Price CIVIL Sap Aggregation Um Eff . Cmc Cmc Descr . Subcmc Subcmc Descr K Cmc K Subcmc Unit Price Initial Qty Initial Value Committed Qty Committed Amount Delta Qty Delta Value 003 M3 15 LC01 Earth movement LC0130 General excavations 1 1 17,43 9142,48 159353,4264 -9142,48 -159353,4264 003 M3 2,5 LC02 Excavation & backfill LC0211 EXCAV./BACKFILL for foundation 1 1 32,2 11016,21 354721,962 -11016,21 -354721,962 003 M3 1,9 LC02 Excavation & backfill LC0211 EXCAV./BACKFILL for foundation 1 1 44,24 3775,64 167034,3136 -3775,64 -167034,3136 003 M3 1,15 LC02 Excavation & backfill LC0211 EXCAV./BACKFILL for foundation 1 1 103,91 422,15 43865,6065 -422,15 -43865,6065 003 M3 2,5 LC02 Excavation & backfill LC0221 EXCAV/BACKFILL for trench & UG 1 1 109,12 2860,56 312144,3072 -2860,56 -312144,3072 003 M3 1,9 LC02 Excavation & backfill LC0221 EXCAV/BACKFILL for trench & UG 1 1 54,39 988,59 53769,4101 -988,59 -53769,4101 003 M3 1,15 LC02 Excavation & backfill LC0221 EXCAV/BACKFILL for trench & UG 1 1 121,6 988,59 120212,544 -988,59 -120212,544 003 M3 0,4 LC02 Excavation & backfill LC0221 EXCAV/BACKFILL for trench & UG 1 1 3153,91 32,244 101694,674 -32,244 -101694,674 JOB NUMBER CONTRACTOR DESCRIPTION CONTRACTOR CURRENCY BILL ITEM TW-SUBTW TW-SUBTW DECSRIPTION DECSRIPTION UNIT OF MEASURES SUBCMC SUBCMC DESCRIPTION CMC DESCRIPTION SAP AGGREGATION EFFICIENCY CMC UNIT PRICE COMMITTED QTY INITIAL QUANTITY ( CONTRACTUAL QUANTITY) COMMITTED AMOUNT

76. 2.3.b ) EXPORT ACCOUNTING Click Detail of Committed Amounts Step 2.1.b 2.3) QLIK REPORT Choose the Project Step 2.2.b Step 2.3.b You can choose just single work payment or all work payments Step 2.4.b You can choose just single Contract or all Contracts for Project

77. 2.3.b ) EXPORT ACCOUNTING OUTPUT qlik FILE : excel export accounting Corrispondence for each Item between Colav and SAP Contract 2.3) QLIK REPORT ITEM: identifies an “element” for which a quantity is attributed, with a measurement and a price. Each item will be identified by a univocal code which can in turn be sub-divided in five levels. The item can be defined at any level apart from the first. The level identifying the item will be indicated by a field containing the letter “A”. Intermediate level codes, which are mandatory down to the first level, will be identified by a field containing the letter “L” This sub-section allows the user to define the positions used in SAP for payment for the types of work done. For each position, the maximum SAP amount is entered for the purposes of monitoring payment status. N.B. The folders following the “SAP Aggregation” will only be active if at least one SAP aggregation has been defined . ITEM DESCRIPTION WORK PAYMENT UNIT PRICE OF BILL ITEM COMMITTED QUANTITY COMMITTED AMOUNT

78. DATA PROCESSING DATA ANALYSIS Data Analysis from different Export Step 3.1 3) Manual process that allow to reconcile original data from Boff in data Colav Step 3.2 BILL ITEM TW - STW PRICE * * Note: In case if there are no applicable rates and prices in the Contractual price list, New Prices Procedure shall apply. ( See corrispondence slide n xxx ). CONTRACT-CONTRACTOR Step 3.4 Step 3.3 Step 3.5 * * *

79. DATA ANALYSI S STEP 3.1 After PO analysis (Phase 1) and export from different system begins the most important phase which consists in reworking the data to make templates to import in Prism. From Rev 0 to last Revision We must « rebuilt » Maximum Amount of each Po from Rev 0 to last Rev. in SAP divided for Bill Item The updated Boff Rev. to be confirmed by QUMAN and Project. Subcontracting Strategy explains disciplines for each Contractor and makes us understand area of wbs and the billitem that belongs to him. DATA PROCESSING 3)

80. Step 3.2 BILL ITEM BOFF TO BILL ITEM COLAV This phase is to identify base bill Items from Boff Export files (Export total quantities or Boq Quantities ) and corresponding Colav Bill Items that may have additional prefixes assigned either per WBS areas or other Specific project needs. DATA ANALYSIS As we can read in note, BASE BILL ITEM in Boff were not always linked with Bill Item in Colav with prefix and suffixes . From Boff Export Total Quantities ( Tab …) , for example , we have BASE BILL ITEM that must be reconciled with Colav ( tab ---) step by step. This process must be done through study nof WBS: Example : Base Bill Item BOFF : BLALA Base Bill Item COLAV : 01 BLALA Note: BOFF / COLAV Until now the BoQs that generate the construction subcontracts (in Boff ) were not linked to the contractual BoQ in Colav . This configuration required that the users modify manually the bill item code (prefixes and suffixes) to bypass the system constraints that did not allow to manage different prices for the same bill item per subcontractor. The cases above described are frequent, for example, if the same subcontractor is in charge to carry out his activities in BF and GF with relative different prices. (example in slide Step. 3.1 in Data Analysis) Code1 Descr1 Code Quantity Subcmc BL BUILDINGS - LUMP SUM - 13,8KV AREASS(GT4) BLALA 1 BL00 BL BUILDINGS - LUMP SUM - 13,8KV MAINSS(MS5) BLCLA 1 BL00 BL BUILDINGS - LUMP SUM - PROCESS INTERFACE BLDG (BLDG-705) BLCLB 1 BL00 BL BUILDINGS - LUMP SUM OME/TEAMBUILDING(GT7) BLCLC 1 BL00 BL BUILDINGS - LUMP SUM - OME/TEAMBUILDING(GTC) BLCLD 1 BL00 Bill Item BASE BILL ITEM Code_1 Code_1 Description 01 BLA L A BLALA 01BL BUILDINGS - LUMP SUM - 13,8KV AREASS(GT4) 02 BLC L A BLCLA 01BL BUILDINGS - LUMP SUM - 13,8KV MAINSS(MS5) 03 BLC L B BLCLB 01BL BUILDINGS - LUMP SUM - PROCESS INTERFACE BLDG (BLDG-705) 04 BLC L C BLCLC 01BL BUILDINGS - LUMP SUM OME/TEAMBUILDING(GT7) 05 BLC L D BLCLD 01BL BUILDINGS - LUMP SUM - OME/TEAMBUILDING(GTC) DATA PROCESSING 3) EXPORT TOTAL QUANTITIES BOFF EXPORT COLAV

81. step 3.2 : ExAmple OF MANUAL PROCESS BASE BILL ITEM BOFF : C 53 03 A SUFFIXES : G = GREENFIELD B = BROWNFIELD O = OFFSITE D = DISMANTLING AND DEMOLITION WBS AREA : A10 = COMMON GREEN FIELD C02 = COMMON GREEN FIELD B08 = DISMANTLING AND DEMOLITION WBS C 53 03 A G C5303A O C5303A D C5303A BILL ITEM COLAV * Note: Please note that prefixes are not standard and may vary from one project to another. PAY ATTENTION to Wbs Area and description DATA ANALYSIS DATA PROCESSING 3)

82. DATA ANALYSIS Step 3.3 : CONTRACT- CONTRACTOR While identifing Bill Itmes in Colav you have also to check a Contractor and Contract assigned to perform this scope. DATA PROCESSING 3) Table 1 . Sub Contracting Strategy for EPC Package - 3 Sl. No   Status of Bid Package Sub Contractor Remarks A PACKAGE - A       1 Piling Works Awarded SWISSBORING PO issued 1272453_rev.0 2 Civil Works - Tank Foundation Awarded  AL TURKI PO issued 1275440_rev.0 3 Civil Works – Balance Awarded PETROJET PO issued 1276614_rev.0 Civil Works – CP  System Awarded Civil Works UG Piping Works Awarded C PACKAGE – C       1 Site Preparation works Awarded GALFAR PO issued 1251399_rev.1 Civil Works - Tank Foundation Civil Works CP System under Tanks 2 Civil Works - Balance Awarded AL TURKI PO issued 1265406_rev.0 Civil Works - CP System  Balance Civil Works – UG Piping works STEP 3. : ExAmple BASE BILL ITEM BOFF : CIVIL WORKS : C 54 26 b Code DescrLiv2 DescrLiv3 Descr1 C 54 26 B DUQM - PCK A TANK AREA C I V I L W O R K S C 54 26 B DUQM - PCK A TANK AREA C I V I L W O R K S C 54 26 B DUQM - PCK A TANK AREA C I V I L W O R K S C 54 26 B DUQM - PCK A TANK AREA C I V I L W O R K S C 54 26 B DUQM (Ras Markaz ) - PCK C 501-TANK AREA & PUMPING STATION C I V I L W O R K S C 54 26 B DUQM (Ras Markaz) - PCK C 501-TANK AREA & PUMPING STATION C I V I L W O R K S C 54 26 B DUQM (Ras Markaz ) - PCK C 502-TANK AREA & PUMPING STATION C I V I L W O R K S C 54 26 B DUQM (Ras Markaz ) - PCK C 502-TANK AREA & PUMPING STATION C I V I L W O R K S For example we have BOFF BASE BILL ITEM for Civil Works : TANK AREA which can be assigned to two Contractor: 1- Galfar PO: 1251399 2- AL TURKI PO : 1275440 We can make the distinction based on WBS description.

83. DATA ANALYSIS * STEP 3.4 :TYPE AND SUBTYPE OF WORK DEFINITION   The Types of Works and Sub Type of Works definition represents one of the minimum requirement required by the methodologyused for accounting management to be applied during the works execution for the control of the construction subcontracts. In accordance to Sap aggregations breakdown, the Subcontracts set-up is prepared through the below levels: - Type of work TW - Sub type of work STW The Subcontract Management System shall utilize these standard codes to identify corrective actions well in advance and the detailed breakdown of TW and STW shall be defined depending on the structure of the Subcontract. Every Subcontract has its own Sap aggregation breakdown and should be evaluated its own corresponding set of TW and STW to be applied for accounting purpose. The Types of Works and Sub Type of Works structure represents the minimum required level that must be included in the Subcontract . For some closed or ongoing projects we can find not standard TW and STW assigned for specific needs. We must identify and corresponding to standard (as can be seen in the table below). Note: In future all projects must use Standard Tw- STw DATA PROCESSING 3)

84. DATA PROCESSING 3) DATA ANALYSIS STEP 3.4 :TYPE AND SUBTYPE OF WORK DEFINITION Type of Work Sub Type of Work Description Type of Work Sub Type of Work TW   MEASURE WORKS 0010     STW Unit Price, CIVIL 0010 AA   STW Unit Price, BUILDINGS 0010 AB   STW Unit Price, STEEL STRUCTURES 0010 AC   STW Unit Price, PIPING FABRICATION 0010 AD   STW Unit Price, PIPING ERECTION 0010 AE   STW Unit Price, PAINTING 0010 AF   STW Unit Price, INSULATION 0010 AG   STW Unit Price, PIPING SUPPORTS FABRICATION 0010 AH   STW Unit Price, PIPING SUPPORTS ERECTION 0010 AI   STW Unit Price, EQUIPMENT ERECTION 0010 AJ   STW Unit Price, ELECTRICAL 0010 AL   STW Unit Price, INSTRUMENTATION 0010 AM   STW Unit Price, TELECOMMUNICATION 0010 AN   STW Unit Price, OTHER DISCIPLINES 0010 AO   STW Unit Price, HEAVY LIFT 0010 AP   STW Unit Price, SCAFFOLDING 0010 AQ   STW Unit Price, MODULARIZATION 0010 AR   STW Unit Price, MARINE WORKS 0010 AS Type of Work Sub Type of Work Description Type of Work Sub Type of Work TW   LUMP SUM WORKS AND CONTRACTUAL MILESTONES 0020     STW Lump Sum works, CIVIL 0020 BA   STW Lump Sum works, BUILDINGS 0020 BB   STW Lump Sum works, STEEL STRUCTURES 0020 BC   STW Lump Sum works, PIPING FABRICATION 0020 BD   STW Lump Sum works, PIPING ERECTION 0020 BE   STW Lump Sum works, PAINTING 0020 BF   STW Lump Sum works, INSULATION 0020 BG   STW Lump Sum works, PIPING SUPPORTS FABRICATION 0020 BH   STW Lump Sum works, PIPING SUPPORTS ERECTION 0020 BI   STW Lump Sum works, EQUIPMENT ERECTION 0020 BJ   STW Lump Sum works, ELECTRICAL 0020 BL   STW Lump Sum works, INSTRUMENTATION 0020 BM   STW Lump Sum works, TELECOMMUNICATION 0020 BN   STW Lump Sum works, OTHER DISCIPLINES 0020 BO   STW Lump Sum works, HEAVY LIFT 0020 BP   STW Lump Sum works, SCAFFOLDING 0020 BQ   STW Lump Sum works, MODULARIZATION 0020 BR   STW Lump Sum works, MARINE WORKS 0020 BS   STW Contractual Milestones 0020 BX   STW Mobilization costs 0020 BZ

85. DATA PROCESSING 3) DATA ANALYSIS STEP 3.4 :TYPE AND SUBTYPE OF WORK DEFINITION Type of Work Sub Type of Work Description Type of Work Sub Type of Work TW   NEW PRICES (NP) 0030     STW New Prices, CIVIL 0030 CA   STW New Prices, BUILDINGS 0030 CB   STW New Prices, STEEL STRUCTURES 0030 CC   STW New Prices, PIPING FABRICATION 0030 CD   STW New Prices, PIPING ERECTION 0030 CE   STW New Prices, PAINTING 0030 CF   STW New Prices, INSULATION 0030 CG   STW New Prices, PIPING SUPPORTS FABRICATION 0030 CH   STW New Prices, PIPING SUPPORTS ERECTION 0030 CI   STW New Prices, EQUIPMENT ERECTION 0030 CJ   STW New Prices, ELECTRICAL 0030 CL   STW New Prices, INSTRUMENTATION 0030 CM   STW New Prices, TELECOMMUNICATION 0030 CN   STW New Prices, OTHER DISCIPLINES 0030 CO   STW New Prices, HEAVY LIFT 0030 CP   STW New Prices, SCAFFOLDING 0030 CQ   STW New Prices, MODULARIZATION 0030 CR   STW New Prices, MARINE WORKS 0030 CS Only NP approved by Contract revision Type of Work Sub Type of Work Description Type of Work Sub Type of Work TW   EXTRA WORKS (LUMP SUM WORKS) (CWO) 0040     STW Lump sum works, CIVIL 0040 DA   STW Lump sum works, BUILDINGS 0040 DB   STW Lump Sum works, STEEL STRUCTURES 0040 DC   STW Lump Sum works, PIPING FABRICATION 0040 DD   STW Lump Sum works, PIPING ERECTION 0040 DE   STW Lump Sum works, PAINTING 0040 DF   STW Lump Sum works, INSULATION 0040 DG   STW Lump Sum works, PIPING SUPPORTS FABRICATION 0040 DH   STW Lump Sum works, PIPING SUPPORTS ERECTION 0040 DI   STW Lump Sum works, EQUIPMENT ERECTION 0040 DJ   STW Lump Sum works, ELECTRICAL 0040 DL   STW Lump Sum works, INSTRUMENTATION 0040 DM   STW Lump Sum works, TELECOMMUNICATION 0040 DN   STW Lump Sum works, OTHER DISCIPLINES 0040 DO   STW Lump Sum works, HEAVY LIFT 0040 DP   STW Lump Sum works, SCAFFOLDING 0040 DQ   STW Lump Sum works, MODULARIZATION 0040 DR   STW Lump Sum works, MARINE WORKS 0040 DS Only Extra Works approved by Contract revision

86. DATA PROCESSING 3) DATA ANALYSIS STEP 3.4 :TYPE AND SUBTYPE OF WORK DEFINITION Type of Work Sub Type of Work Description Type of Work Sub Type of Work TW   EXTRA WORKS (MEASURED WORKS) (CWO) 0050     STW Unit Price, CIVIL 0050 EA   STW Unit Price, BUILDINGS 0050 EB   STW Unit Price, STEEL STRUCTURES 0050 EC   STW Unit Price, PIPING FABRICATION 0050 ED   STW Unit Price, PIPING ERECTION 0050 EE   STW Unit Price, PAINTING 0050 EF   STW Unit Price, INSULATION 0050 EG   STW Unit Price, PIPING SUPPORTS FABRICATION 0050 EH   STW Unit Price, PIPING SUPPORTS ERECTION 0050 EI   STW Unit Price, EQUIPMENT ERECTION 0050 EJ   STW Unit Price, ELECTRICAL 0050 EL   STW Unit Price, INSTRUMENTATION 0050 EM   STW Unit Price, TELECOMMUNICATION 0050 EN   STW Unit Price, OTHER DISCIPLINES 0050 EO   STW Unit Price, HEAVY LIFT 0050 EP   STW Unit Price, SCAFFOLDING 0050 EQ   STW Unit Price, MODULARIZATION 0050 ER   STW Unit Price, MARINE WORKS 0050 ES Only NP approved by Contract revision Type of Work Sub Type of Work Description Type of Work Sub Type of Work TW   MATERIAL SUPPLY AND RELATED SERVICES 0060     STW Material Supply and related Services 0060 FA TW   DAILY RATES 0070     STW Labour 0070 GA   STW Plant & Equipment 0070 GB   STW Services 0070 GC   STW Commissioning 0070 GD TW   PROVISIONAL AND DISPUTED ITEMS 0080     STW NP Provisional 0080 HA   STW Extra Works - Lump Sum works (CWO provisional) 0080 HB   STW Extra Works - Measured works (CWO provisional) 0080 HC   STW Disputed Items 0080 HD   STW NP Provisional - Unit Price, CIVIL 0080 IA1   STW NP Provisional- Unit Price, BUILDINGS 0080 IA2   STW NP Provisional- Unit Price, STEEL STRUCTURES 0080 IA3   STW NP Provisional - PIPING FABRICATION 0080 IA4   STW NP Provisional- PIPING ERECTION 0080 IA5   STW Extra Works Provisional - Unit Price, CIVIL 0080 IB1   STW Extra Works Provisional - Unit Price, BUILDINGS 0080 IB2   STW Extra Works Provisional - Unit Price, STEEL STRUC 0080 IB3   STW Extra Works Provisional - PIPING FABRICATION 0080 IB4   STW Extra Works Provisional - PIPING ERECTION 0080 IB5   STW Provisional payment - Unit Price, CIVIL 0080 IC1   STW Provisional payment- Unit Price, BUILDINGS 0080 IC2   STW Provisional payment- Unit Price, STEEL STRUCTURES 0080 IC3   STW Provisional payment- PIPING FABRICATION 0080 IC4   STW Provisional payment- PIPING ERECTION 0080 IC5 TW   CLAIMS AND OTHER COSTS 0090     STW Claims 0090 IA   STW Backcharges 0090 IB   STW Incentives (Bonus, Acceleration cost) 0090 JC TW   TCF 0100     STW Camp & Site Facilities Installation 0100 TA   STW Camp & Site Facilities Operation and Maintenance 0100 TB

87. DATA ANALYSIS * STEP 3.4 :TYPE AND SUBTYPE OF WORK DEFINITION EXAMPLE Note: In future all projects must use Standard Tw- SubTw DATA PROCESSING 3) Bill item 1st Code Descr T.of Work TW Description Sub T. of Work STW Description BSF 01 AN 01 A MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION BSF 01 AN 01 B MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION BSF 01 AN 03 B MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION BSF 01 AN 05 MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION BSF 01 BN 01 B MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION BSF 01 BN 02 B MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION BSF 01 BN 03 MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION BSF 01 C 02 MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION BSF 01 C 04 MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION BSF 01 D 01 A MEASURING INSTRUMENTS 010B Measure Works Brown field AO INSTRUMENTATION Type of Work Sub Type of Work Description Type of Work Sub Type of Work TW   MEASURE WORKS 0010     STW Unit Price, CIVIL 0010 AA   STW Unit Price, BUILDINGS 0010 AB   STW Unit Price, STEEL STRUCTURES 0010 AC   STW Unit Price, PIPING FABRICATION 0010 AD   STW Unit Price, PIPING ERECTION 0010 AE   STW Unit Price, PAINTING 0010 AF   STW Unit Price, INSULATION 0010 AG   STW Unit Price, PIPING SUPPORTS FABRICATION 0010 AH   STW Unit Price, PIPING SUPPORTS ERECTION 0010 AI   STW Unit Price, EQUIPMENT ERECTION 0010 AJ   STW Unit Price, ELECTRICAL 0010 AL   STW Unit Price, INSTRUMENTATION 0010 AM   STW Unit Price, TELECOMMUNICATION 0010 AN   STW Unit Price, OTHER DISCIPLINES 0010 AO   STW Unit Price, HEAVY LIFT 0010 AP   STW Unit Price, SCAFFOLDING 0010 AQ   STW Unit Price, MODULARIZATION 0010 AR   STW Unit Price, MARINE WORKS 0010 AS For some closed or ongoing projects we can find not standard TW and STW assigned for specific needs. For example for BILL ITEM: BSF 01 AN 03 B it has been associated: TW: 010B STW: AO From procedure Standard TW and STW to be assigned to Measure Works, instrumentale are: TW: 0010 STW: AM

88. DATA ANALYSIS * STEP 3.5 : PRICE   The last Step is to associate Contractual Unit price to each Bill Items. From Sap we can export the Contractual Price list and associate the corresponding price. We can also do this process through different export From STARGATE and QLIK but always checking with Contractual unit Price. N.B For some new project if we use Export Boq Quantities (2.1.b) we already have Labour and Material Price and this Step is not necessary. DATA PROCESSING 3) PROJECT Job HAWIYAHPROJECT Location HawiyahSite CLIENT SaudiArabianOilCompany -SAUDIARAMCO PRICE LIST ScopeofWork CIVILWORKS-GREENFIELD Revision 1 Date 10-apr-19 Currency SaudiArabianRiyal (SAR) Bill Item Description U.M. Quantity Total Unit Price C C I V I L W O R K S       C 53 DEMOLITIONS       C 53 01 Demolitions of structures by any appropriate means:       C 53 01 A3 for buried structures made in reinforced concrete M3 17,85 847,10 C 53 01 C1 for any kind and height of fencing including foundations, walls, wire net, posts, etc. M 502,10 80,15 C 53 03 Demolitions of road foundations, sub bases and wearing courses by any appropriate means:     0,00 C 53 03 A for an entire road section M3 15.505,89 52,11 C 53 03 B for a limited road section M3 378,00 64,15 C 53 05 Demolition of buildings of any type (on a full volume basis), by any appropriate means up to 1.00 m below ground level. M3 2.396,63 847,10 C 53 07 Loading/unloading for trasporting inside or outside the site area of demolished material:     0,00 C 53 07 A for any kind of material M3 378,00 7,17 C 53 10 Allow for the use of tips located beyond the boundaries of the site and/or factory, as directed in writing by the Employer for the disposal of demolished materials; transporting excluded. M3 15.901,74 5,63 CONTRACT NR ID CONTRACT BILL IT_COLAV CONTRACT BILL_IT _BOFF Description Um Quantity PRICE 1210649 GC5301A3 C5301A3 for buried structures made in reinforced concrete M3 17,85 847,1 1210649 GC5301C1 C5301C1 for any kind and height of fencing including foundations, walls, wire net, posts, etc. M 470,4 80,15 1210649 GC5305 C5305 Demolition of buildings of any type (on a full volume basis), by any appropriate means up to 1.00 m below ground level. M3 2396,63 847,1 1210649 GC5307A C5307A for any kind of material M3 378 7,17 1210649 GC5310 C5310 Allow for the use of tips located beyond the boundaries of the site and/or factory, as directed in writing by the Employer for the disposal of demolished materials transporting excluded. M3 17,85 5,63 1210649 GC5310 C5310 Allow for the use of tips located beyond the boundaries of the site and/or factory, as directed in writing by the Employer for the disposal of demolished materials transporting excluded. M3 1262,04 5,63

89. DATA ANALYSIS example DATA PROCESSING 3)   All the abovementioned date processing steps are summarized and reported in the template below to demonstrate the correct sequence of analysis. You can find it in the folder : PRISM: DATA ANALYSIS

90. DATA ANALYSIS example DATA PROCESSING 3)   For data analysis you must consider the file called : DATA ANALYSIS BOFF To facilitate the data processing the Template is already set with the formulas. First line: Data Analysis from Users / Original Export a Second line: Checks to be made with different System and export b Third line: formulas to use to fill in the template c During the whole data analysis process the worksheets were always set using the yellow for the original data coming from different exports and the green for users manual analysis.

91. DATA ANALYSIS example DATA PROCESSING 3) A C D E F G H I J K L P Q T U DATA ANALYSIS           CHECK TO EXPORT COLAV/QLIK CHECK TO EXPORT COLAV/QLIK CHECK TO EXPORT COLAV/QLIK CHECK TO EXPORT COLAV/QLIK CHECK WITH STANDARD CHECK WITH STANDARD CHECK WITH CONTRACTUAL PRICE LIST (SAP) FORMULE =CONCATENATE (AB4;AD4;AH4;AJ4) MANUAL MANUAL =SUBSTITUTE (BD3;" ";"") MANUAL =CONCATENATE (G5;F5) VLOOKUP with price List VLOOKUP with price List MANUAL MANUAL =BG4 =BH3 VLOOKUP with price List   =(T4*Q3) CONTRACT NR_ID WBS CONTRACTOR CONTRACT NR ID CONTRACT_BILL IT_BOFF SUFFIXES AND PREFIXES CONTRACT_BILL IT_COLAV CONTRACT_ToW COLAV CONTRACT_SToW COLAV CONTRACT ToW_CSE CONTRACT_SToW_CSE Um Quantity BOFF TOTAL UNIT PRICE COST H02755 01011003 PETROJET 1210649 BLALA 01 01BLALA 0020 BB 0020 BB LS 1 400000 400000 H02755 01011001 PETROJET 1210649 BLALA 02 02BLALA 0020 BB 0020 BB LS 1 324448 324448 H02755 01010906 PETROJET 1210649 BLALA 03 03BLALA 0020 BB 0020 BB LS 1 392000 392000 H02755 01010903 PETROJET 1210649 BLALA 04 04BLALA 0020 BB 0020 BB LS 1 238580 238580 WBS: Concatenate : Level of WBS: (Column AB; Column AD; Column AG; Column AI) Z AA AB AC AD AE AF AG AH AI BD BF BG EXPORT QUANTITIES FROM BOFF                                         Job Rev. Liv1 DescrLiv1 Liv2 check DescrLiv2 Liv3 DescrLiv3 Liv4 Code Um Quantity H02755 6 01 HAWIYAH GAS PLANT HGP EXPANSION PROJECT 01 G A - GREENFIELD 10 A09 - ELE SUBSTATIONS (macroarea U/G) 03 BL A L A H02755 6 01 HAWIYAH GAS PLANT HGP EXPANSION PROJECT 01 G A - GREENFIELD 10 A09 - ELE SUBSTATIONS (macroarea U/G) 01 BL A L A H02755 6 01 HAWIYAH GAS PLANT HGP EXPANSION PROJECT 01 G A - GREENFIELD 09 A08 - BUILDINGS 06 BL A L A H02755 6 01 HAWIYAH GAS PLANT HGP EXPANSION PROJECT 01 G A - GREENFIELD 09 A08 - BUILDINGS 03 BL A L A Yellow : Export from Boff Green: Users manual analysis Step 3.2: Concatenate: Suffixes and Prefixes ( Column G) with Base Bill item Boff (Column F ) Step 3.4: Associate: TW/STW from system to TW/STW Standard from Procedure. Step 3.3: Associate: Contract/ Contractor Step 3.5: Associate:

92. note * DATA ANALYSIS DATA PROCESSING 3) The procedure described is a good practice for data analysis , but each Project have some specific For each Contract we have Measure Works, but also you can have Lump Sum Work;these quantities must be managed differently than the others . You will show an example below of an analyzed project with some quantities that must be monitored offline and not uploaded in Prism. In this example you have an EPC Contract with Measure and Lump Sum Works: EXAMPLE Description GREENFIELD BROWNFIELD OFFSITE Mechanical Works Measure Works Painting Works at site Measure Works Insulation Works Measure Works Electrical & Instrumentation & Telecom Works Measure Works Piping Prefabrication Measure Works Early Works Measure Works Demolitions Measure Works Civil Works Measure Works Painting Works at prefab.shop Measure Works Buildings Works (civil + buildings + existing buildings) Lump Sum Works EPC Tanks Works Construction Lump Sum Works √ √ √ √ √ √ √ √ √ √ √ √ √ √ √ √ √ √ √ QUANTITIES UPLOADED IN BOFF QUANTITIES MONITORED OFFLINE AND NOT UPLOADED IN BOFF

93. note * DATA ANALYSIS DATA PROCESSING 3) Whenever you have lump sum quantities , you have to pay attention , analyzing and monitoring them separately offline. In the previous example you have BUILDING and Tank Installation lump sum quantities . To be more detailed , after all Step (3.2;3.3;3.4) you analyze the quantities of the first Contract revision for upload the Maximum Amount , but after that you will not monitor the deviation of the quantities in Prism.

94. DATA ANALYSIS DATA PROCESSING 3)

95. PRISM

96. PRISM PRISM Prism G2 is the new official tool for cost control. In these guidelines we will introduce the main functionalities of Prism, explain how to create a new project in Prism and Import data. Prism G2 is used with the idea of 4) 4.1 Introduction Objectives The intention is to identify and collecting data coming from different tools to interact and “return a homogeneous data”

97. Access to software Once you get authorization you can access Prism G2 through Citrix Milan Portal inside Intranet website: Application & Solution  Tools  Citrix Portal  Citrix Portal Milan. O nce you get inside Citrix Portal you will be asked to insert your network credentials, here you will need to use the same user id and password you use to access your computer. Citrix Portal: all Prism applications will be installed in Citrix Portal. There are three different applications for Prism: - PrismG2 v4_3: this is production environment application, all live projects must be handled in production. - PrismG2 v4_6 – Test : this environment will be used for training and to make personal exercise PRISM 4) To add Prism application to your Citrix desktop select the “+” icon, select “All Apps” and then click on all “ PrismG2 v4_6 – Test ” applications. 4.1 Introduction

98. User IDs: are created as the personal badge number. Password: the same of user Id PRISM 4) Access to software 4.1 Introduction For access to software and technical support you can refer to Alessandro Giannelli.

99. Every time you open a project an automatic window is opened to set project authorization: By selecting “Yes” the project creator is requesting exclusive use of the project, this means that other users cannot open that project until the creator closes the project. When selecting “No”, other cost controllers can work at the same time on that project. If another user has exclusive use on a project you will see this message when trying to open; this means you cannot open the project. If another user has not exclusive use you will see this message instead, in this case you can open the project but you can’t have Exclusive use. PRISM 4) 4.1 Introduction Open Project N.B.: Certain activities require exclusive use, we will see them in following chapters. Click Open Project Prism structure is organized within one Start Menu and five different Main Folders. Open Project will open list of projects you are authorized to open Close Project will close the project you are currently using New Project is used as previously discussed to create new Prism Projects Remove Projects will delete specific Prism Project Recent Projects shows last Prism Projects opened with your User ID

100. 4.1 Introduction New Project To start working in Prism the first activity is to create a new project. From prism start menu on top left corner, select “New Project”. This will open the project creation window, here we have three fields and three panels that need to be filled to create a project. PRISM 4) Click New Project Step 4.1 Project ID : all prism projects will be related to a single job number , a single cutoff and a single version of a project; project ID must be with these three data: Job Nr._CSO_TEST Project Title: here we will repeat the job number to sort and then we will specify detail description for the three codes of Project ID: Job Nr._ CSO_Project Name Restore File: this field is to use back up files to recover previous project data Step 4.2 You must to tick on Modules below Step 4.3 You must to tick on Project Option : Enterprise Project : is for access to enterprise environment inside your project; Multi-Currency: is to have the possibility to work with both original currency and equivalent converted amounts, N.B. Both these fields shall always be selected Step 4.4 You must to tick on Restore Option : These option will always be selected automatically only when using Restore File and they shall not be modified.

101. 4.1 Introduction Main Folders and tables PRISM 4) FILE BOTTON DATA FRAME QUICK ACCESS TOOL BAR ACTION ITEMS RIBBON GROUP RIBBON TABS NAVIGATION TOOLBAR SUB PANE DATA PANE NAVIGATION PANE SUB PANE TABS DATA PANE TAB HEL P INFO BUTTON TITLE BAR

102. PRISM 4) 4.1 Introduction Navigation Tool Bar Most Panes and some Forms have a Navigation Toolbar located at the top of the Pane or Form. This is where several of the commands associated with manipulating records and Grids are found. Below are some of the common commands found on the toolbar. From Left to Right : RECORD MODE / GRID MODE ADD RECORD RECORD NUMBER PREVIOUSLY SELECTED RECORD LAST RECORD NEXT RECORD PREVIOUS RECORD FIRST RECORD DELETE RECORD UNDO RECORD SAVE RECORD REFRESH DATA FILTER DATA TOOLS DROP DOWN COLUMN CHOOSER: You may choose to never utilize a Column and hide it, or you may want to temporarily hide a Column; the Column chooser feature can be used to choose which columns are to be displayed. DATA LAYOUTS: Data Layout allows the User to customize the layout and save it or to modify an existing layout under a new name. SUBPANE CHOOSER : allows the User to decide which Subpanes will be available at the bottom of the Data Pane Tab . ENABLE ROW PINNING : locks the row to the top of the list. This allows User to more quickly access frequently used records and perform visual comparisons more easily between records. PRINT GRID : You can Print the contents of a Grid in the exact way the Grid is organized and displayed. EXPORT TO EXCEL: You can export the contents of a Grid to Microsoft Excel. The data are exported in the exact way the Grid is organized. For instance, if you have applied a filter to the Grid, hidden and rearranged some columns, sorted and grouped the data, the Grid visually displays these changes on screen. The data are exported to the spreadsheet as shown on screen RESET PANE CONFIGURATION: allows you to reset just the active Pane from its current position back to its default position.

103. PRISM 4) 4.1 Introduction Main Folders and tables The PRISM G2 application is structured in three distinct components. Administration is used to manage the PRISM G2 application. It is the component where database management occurs, new Users are added and permission rights are assigned, and other administrative functions occur. Enterprise is used to set up and manage common structures and definitions that can be used across all Projects. It is the component where Project permissions and groupings are administered, Enterprise codes and lists are defined, Enterprise reporting periods are set, and employees and resource categories are defined. It is also where Enterprise Reports are printed, combining data from multiple Projects. Projects are used to manage Projects and Project data. This is where all Project-specific functions and processes are conducted. There are various Forms, Data Panes, Calculations, and Utilities that are available depending on which of the PRISM G2 Modules are purchased.

104. PRISM 4) 4.1 Introduction Main Folders and tables Main Folders Each Folder is dedicated to specific function and contains different tables: Main Folders are: Tables D B A C For all main folders and table you can find file bottom. Refresh All Panes : allows Users to reset all changes they have made to the layout of the PRISM G2 Interface Refresh All Data: allows you to refresh the Data of every opened Pane at one time. This ensures that changes others have made to the database are reflected in the current Panes

105. PRISM 4) 4.1 Introduction Main Folders and tables A Enterprise This folder contains general anagraphics shared to all Saipem projects, such as cost centers, company codes. The table allows to organize groups which will be the same for all projects. In Project groups we have project master data: Geographic Area, Country, Business Line etc. It must be ordered as follows below and cannot be changed . Project Groups are assigned at the Project level. They are used to categorize Projects. You can define up to 26 different Project Groups and each group contains a list of Project Group IDs and Descriptions. Multiple Projects can be grouped, sorted, summarized, and filtered in Enterprise Reports using Project Groups. These Fields are also made available to the Users / Viewers of PRISM Dashboards.

106. PRISM 4) 4.1 Introduction Main Folders and tables Step A.1 To update data we must use IMPORT/EXPORT. Choose Project Groups to update Choose File from folder (see slide---) Select : Group Id; Group Description and Sort Code; Click START IMPORT Note: The procedure is the same for all groups A Enterprise

107. PRISM 4) 4.1 Introduction Main Folders and tables Note: The procedure is the same for all groups A Enterprise Template for Import are in: PRISM: IMPORT Here we have: All Project interested for update in Prism divided in folder; PROCEDURES: procedures used for data analysis; FILE_PRISM : general file useful for data analysis. In 0-IMPORT PRISM we have: Module Groups :Project master data template for Import in Prism; Project Groups: Template for Enterprise Groups; Archive Module : General Archive of Module Groups; Template : General template with formulas for data processing; PROJECT GROUPS : For Import we must utilize the template in folder sorted with the letters of the alphabet corresponding in PRISM.

108. PRISM 4) 4.1 Introduction Main Folders and tables A Enterprise In ENTERPRISE Change Order Status you must verify that the Status Id are ticked in the same order.

109. PRISM 4) 4.1 Introduction Main Folders and tables This folder contains the main project custom anagraphics : CBS, Calendar, Cost Elements… here we can also find Archive and Restore functions which are used to extract and to reload back up files. B Project IF click on a Group in table below you can see all the imported data Module Groups are identified and named at the Project Level. The behavior, masking formats and the acceptable values are also defined at the Project Level. If the Group forms part of the main Record ID the group code can be automatically masked. If the code isn’t masked it can be updated manually for each record. Rules can also be applied to allow for modification of the assigned code and whether the Code should be used to generate the description of the main record.

110. PRISM 4) 4.1 Introduction Main Folders and tables Template for Import are in: G:\CSO\SUBCONTRACTS ENGINEERING\ Prism_Test

111. PRISM 4) 4.1 Introduction Main Folders and tables B Project Once imported the first time all Template, for all later project you can use the File Menu to Archive, Restore and Purge data. Archive is taking a snapshot of your Project at any given time. It can happen multiple times a day if desired. It is also recommended to Archive a Project before importing a large amount of Data and before any major updates processes are run or the reporting Period is closed. Click the Browse button and Save In Archive Module in Prism Import for General Archive of Module Groups, while for Single Project you can create a similar folders

112. PRISM 4) 4.1 Introduction Main Folders and tables B Project You may need to restore a Project for the following reasons: •To replace compromised Data. •To create a training Project using existing Project Data. •To create a new Project based on a template Project archive. Click in the browse Field for the File Name and navigate to the location where the archive is stored. After click RESTORE Note: To restore a Project you need to have Exclusive access for the Project.

113. PRISM 4) 4.1 Introduction Main Folders and tables B Project You may need to Purge a Project for clean up any system errors. Click PURGE

114. PRISM 4) 4.1 Introduction Main Folders and tables C Contract The Contracts Module is where a Contract Administrator can develop Bid Packages, perform Bid Analysis, Generate and Award Contracts, track Instructed and Executed Changes. Contracts are linked to Control Accounts to provide a Commitment values and / or Progress information The Data Entry menu in the Contracts tab is where screens for entering Data associated with Request For Proposal, Contracts and Contract Change are performed. It is also where data settings are defined for the Contract Module The Contracts Settings Form establishes the settings and options specific to the Contracts module. These settings are usually defined once, at the beginning of the Project. The Calculate Totals process ensures that the Total Values in the Contracts Data Pane are correct, including any Pending and Change values from Instructed and Executed Changes Contract Change Instructions an Executed are used to process a Contract change The Reports menu in the Contracts tab provides access to the Reports for Contracts as well as the Lists associated with the Contracts module. The Utilities menu in the Contracts tab is where routines associated with performing updates on the Contracts Data can be found as well as routines to Validate the data in the Contracts Module.

115. PRISM 4) 4.1 Introduction Main Folders and tables D Invoice The Invoices module is where Invoices for Purchase Orders, Contracts are entered and tracked. Once Invoices are approved, Payment Requests are generated and sent to the accounts payable department. Each Payment on Purchase Orders, Contracts is also entered and tracked. Invoices and Payment details are linked with Contracts from the Contracts module. This allows Invoices to be paid on specific Line Items and Pay Items. It also displays total invoiced and paid amounts to be viewed on Contract in their perspective modules. In Definition click INVOICE STATUS You can add STATUS ID: APPR = stands for Approved PAID = stands for Paid

116. PRISM 4) 4.2 Contracts 4.2.1 Introduction Once the bids are analyzed and a winning Bidder is selected, the Award Contract feature is utilized. This opens the Award Contract Form which requires the winning Contractor to be identified and a Contract ID can be entered if it is different from the Request for Proposal ID. It then makes the following updates Development phase for the Request for Proposal. RFP ( Request for Proposal ) During the life of the Request for Proposal and Contract, the Status codes are periodically modified to reflect the current status. The Status will automatically be set to RFP when a Request for Proposal is first created. It will be updated to Award when the Contract is awarded. Other updates must be manually selected. Bidders are assigned to the Request for Proposal. CANCEL Contract is awarded to a Bidder BID AWARD COMPLETE CLOSED HOLD Work is complete Contract is Closed Request for Proposal or Contract is put on hold. The Request for Proposal or Contract is canceled WORK Contract is in Progress

117. PRISM 4) 4.2 Contracts 4.2.1 Introduction C B A D

118. PRISM 4) 4.2 Contracts 4.2.1 Introduction : A CONTRACT_ ID This is the main code which connects all the different tables inside Prism database. The construction of this code requires different data which will identify and group all the details of single Contract from Control Budget to Invoice creating the Cost Control Report structure . Click on Contract ID in Prism you can found all information about it through Module Group, Project Group and all tables so far described . * Creation of control accounts will be explained after this chapter . Data analysis is guided by:

119. PRISM 4) 4.2 Contracts 4.2.1 Introduction : A All the major information about CONTRACT ID can be read in Groups Fields displayed in the Groups Subpane ,( bottom right). Some of the Groups may not be available for each of the Master Tables. Selecting a Contract_ id in Contract Navigation and click on Groups/Breakdown Structure. In this Subpane you have all information for each Contract Id about Module Groups: Bill Item, description, TW- STW,Contractor . In Pay Items and Pay Item Change Subpane you have all information about Quantity, Quantity Change and Cost for each Contract Id, divided for Item and WBS from BOFF

120. PRISM 4) 4.2 Contracts 4.2.1 Introduction : B The Navigation Pane, by default, is displayed in Record Mode. This is indicated by the Grid Mode icon in the left-hand corner of the Navigation Toolbar To change the data displayed click GRID MODE in pane and drag the required Groups in the upper space of table named : Contract Navigation.

121. PRISM 4) 4.2 Contracts 4.2.1 Introduction : B In Contracts-Data you can found the following information of each Contract Id : - Description Blanket Contract Id Currency Id Exchange Rate : Fixed Exchange Rate of Project ( from PSR)

122. PRISM 4) 4.2 Contracts 4.2.1 Introduction : C In this pane we have the complete view of the costs (and Hours) of all Contracts updated in Prism for each Contract ID. There are several read-only calculations displayed in the Contract Totals box. This Data is summarized from the Pay Items assigned in the Lines Items Subpane . Original Cost: Original Control Budget of Contract (Rev. 0) Approved Changes Cost: Cost Change of different Contract revision caused by change of SOW, New Price etc.. Value as defined in the Pay Item Changes Subpane . The Pay Items Changes must be assigned to a Change where the Change Status is set to Approved. Approved Cost: sum of the Original Cost plus any Approved Changes. Pending Changes : value as defined in the Pay Item Changes Subpane . The Pay Items Changes must be assigned to a Change where the Change Status is set to Pending. Forecast Final: sum of the Original Cost Plus Approved and/or Pending changes. The Change values that are added to the Estimate at Completion are determined if the Change Status is defined to affect the Estimate at Completion. Percent Complete : composite weighted percent complete of each Pay Item's percent complete. It is calculated as: S (Percent Complete x Approved Cost) / S Approved Cost Earned Value: calculated earned value using the Percent Complete and the Approved Cost. It is calculated as: Percent Complete X Approved Cost Invoiced: total of Invoices entered into the Invoices Data Pane from the Invoices module. Retention: total of retention withheld as entered into the Invoices Data Pane from the Invoices module. Remaining Invoice: difference of the Approved Cost minus the Amount Invoiced and Retention. Percent Invoiced: product of the Amount Invoiced plus Retention divided by the Approved Cost. It is calculated as: (Amount Invoiced + Retention) / Approved Cost Paid: total of payments made to the Supplier and entered into the Invoices Data Pane from the Invoices module.

123. PRISM 4) 4.2 Contracts 4.2.1 Introduction D In Status Details you can found the following information of each Contract Id : - Status = Awarded Contractor ID Contyractor Name

124. PRISM 4) 4.2 Contracts 4.2.1 Introduction D In Status Details you can found the following information of each Contract Id : - Status = Awarded Contractor ID Contyractor Name

125. CONTRACT PAYITEMS CONTRACTS GENERAL DATA CONTRACTS QUANTITIES AND COSTS PAYITEMS CHANGES QUANTITIES CHANGES INVOICE ITEMS ACCOUNTING QUANTITIES INVOICE ACCOUNTING GENERAL DATA CONTRACTS CHANGES CONTRACT REVISION CHANGE GENERAL DATA QUANTITIES CHANGES ORIGINAL CONTROL BUDGET (CONTRACT ) ORIGINAL CONTROL BUDGET (CONTRACT) BOFF REVISION x BOFF REVISION x REVISED CONTROL BUDGET (CONTRACT ) REVISED CONTROL BUDGET (CONTRACT ) BOFF REVISION x BOFF REVISION x BOFF REVISION x PRISM 4) 4.2 Contracts 4.2.2 Workflow Step 4.2.a Step 4.2.a

126. PRISM 4) 4.2 Contracts 4.2. The first Step is to upload the Maximum amount Allowed from Revision 0 of all Contracts in Sap . .. no need to make associations because you have already all information about Contractor, Unit Price etc.. So, from the SAP Price List must be elaborate for Template. 3 CONTRACT QUANITIES AND COSTS CONTRACT_ IMPORT of new Bill Items ( not present in Rev.0 and 01) PAYITEM_IMPORT of new Bill Items ( not present in Rev.0 and 01) CONTRACT_CHANGE of new Bill Items that have increased Maximun Amount from Rev 01 to Rev x. PAYITEM_ CHANGE of quantities of new Bill Items

127. PRISM 4) 4.2 Contracts 4.2. CONTRACT QUANITIES AND COSTS

128. PRISM 4) 4.2 Contracts Step 4.2.a COLUMN PRISM System Export type Field Rule A CONTRACT_ID MANUAL Contract / Bill_Item COLAV / TypeofWork COLAV / SubTypeofWork COLAV; CONCATENATE: Contract;Bill_Item COLAV(without space); TypeofWork COLAV;SubTypeofWork COLAV (without space); B DESCRIPTION SAP Price List Description Related to bill item code C REFERENCE_CODE QLIK PRICE LIST Sap Aggregation (COLUMN V ) Sap aggregation for each BILL ITEM D OBS_ID SAP ZJMU28 WBE   E COPR_CONTRACTOR ID QLIK/SAP Price List Contractor   F COPR_DISCIPLINE ID GENANAG SCMC Discipline_Code Find DISCIPLINE CODE in GENANAG in according to SUBCMC G COPR_SCMC ID COLAV Price List Subcmc   H COPR_CMC ID GENENAG SCMC Cmc_Code Find CMC CODE in GENANAG in according to SUBCMC I CONTRACT_ToW_COLAV ID COLAV Price List TypeofWork   J CONTRACT_SToW_COLAV ID COLAV Price List SubTypeofWork   K CONTRACT_ToW_CSE ID MANUAL     Identified by CSE as per TW Procedure L CONTRACT_SToW_CSE ID MANUAL     Identified by CSE as per STW Procedure M CONTRACT_NR ID SAP Price List Contract PO NUMBER N DATA_SOURCE ID SAP       O CONTRACT_BILL_IT_COLAV ID COLAV Price List P CONTRACT_BILL_IT_BOFF ID SAP PO   Contract Bill Item BASE BILL ITEM Q CONTRACT_BILL_IT_BOFF_LEV1 ID MANUAL       R CONTRACT_BILL_IT_BOFF_LEV2 ID MANUAL       S CONTRACT_BILL_IT_BOFF_LEV3 ID MANUAL       T EVENT_ID SAP PO n° REV PO Revision U CONTRACT_STATUS       Default = "A" V VENDOR_ID MANUAL       W VENDOR_COMPANY MANUAL       X PRICE_TYPE SAP Price List LumpSum Y= LUMPSUM; N= NOT LUMPSUM Y CURRENCY_ID GENANAG Estrai_Contrattori Currency   Z COMMIT_X_RATE MANUAL     Utilize the Project Currency Exchange Rate AA BLANKET_ID MANUAL     PO NUMBER AB NOTES MANUAL

129. PRISM 4) 4.2 Contracts Step 4.2.a You have to organize the import file as indicated in the excel file: To Import (COLAV) Contract Price List: Price List attached in Sap QLIK_Price List : Export Price list from Qlik ( see slide ---------) Export_All_Billitem : ( see slide ---------) Export_Billitem_Complete : ( see slide ---------) Genang : ( see slide ---------) In Yellow you have All export file You have to COPY AND PASTE all the Export explained before in the same order.

130. PRISM 4) 4.2 Contracts Step 4.2.a USERS CONTRACT PRICE LIST FROM SAP VLOOK UP WITH EXPORT BILL ITEM COMPLETE   BASE BILLIEM BILL ITEM COLAV REV. PO CONTRACT CONTRACTOR BASE BILLIEM Bill Item Description U.M. Quantity Labour Price Material Price Labour Amount Material Amount C5403A A1C5403A 1276614 PETROJET C5403A C 54 03 A in earth M3 107.046,80 3,70 1,00 396.073,16 107.046,80 C5405A A1C5405A 1276614 PETROJET C5405A C 54 05 A in earth M3 29.384,00 5,50 1,40 161.612,00 41.137,60 C5406A A1C5406A 1276614 PETROJET C5406A C 54 06 A in earth M3 1.205,11 6,50 1,70 7.833,22 2.048,69 C5407A A1C5407A 1276614 PETROJET C5407A C 54 07 A in earth M3 35,35 7,80 2,00 275,73 70,70 C5409A A1C5409A 1276614 PETROJET C5409A C 54 09 A in earth M3 42.822,84 7,00 1,70 299.759,88 72.798,83 C5410A A1C5410A 1276614 PETROJET C5410A C 54 10 A in earth M3 7.315,72 9,50 2,50 69.499,34 18.289,30 C5411A A1C5411A 1276614 PETROJET C5411A C 54 11 A in earth M3 21,90 13,00 3,70 284,70 81,03 C5416A A1C5416A 1276614 PETROJET C5416A C 54 16 A for depth up to and including 1.50 m M3 50,23 96,00 24,00 4.822,08 1.205,52 C5418A A1C5418A 1276614 PETROJET C5418A C 54 18 A in presence of foundation piles of any type and diameter, only for the height concerned by the piles M3 8.229,00 3,50 1,00 28.801,50 8.229,00 C5420 A1C5420 1276614 PETROJET C5420 C 54 20 Allow for the use of tips located beyond the boundaries of the site and/or factory, as directed in writing by the Employer for the disposal of surplus excavated materials; transporting excluded. M3 134.728,00 1,30 0,30 175.146,40 40.418,40 C5426B A1C5426B 1276614 PETROJET C5426B C 54 26 B beyond the boundaries of site and/or factory for any kind of material within 20 Km M3 134.728,00 2,80 0,70 377.238,40 94.309,60 C5502A A1C5502A 1276614 PETROJET C5502A C 55 02 A 90% of the modified max. dry unit weight M3 15.979,23 4,60 1,20 73.504,46 19.175,08 C5503B A1C5503B 1276614 PETROJET C5503B C 55 03 B 95% of the modified max. dry unit weight M3 5.347,01 5,00 12,00 26.735,05 64.164,12 - SHEET: CONTRACT PRICE LIST This sheet must be organized as explained below: - Yellow: Export from SAP ( Copy and paste) - Green: Manual analysis from users Vlook up with Export Colav to associate Base Bill Item with Bill Item with prefixes and suffixes. COPY AND PASTE : Contractual price list

131. PRISM 4) 4.2 Contracts Step 4.2.a     SAP     Genanag   Genanag Colav Colav     SAP     CONCATENATE VLOOKUP VLOOKUP MANUAL VLOOKUP VLOOKUP VLOOKUP VLOOKUP VLOOKUP VLOOKUP MANUAL MANUAL VLOOKUP       Description from PO SAP Aggregation SAP WBE Contractor Code Discipline Scmc Cmc Tow by System StoW by System Tow Standard by CSE STow Standard by CSE PO Number Bill Item By Colav /Qlik Base BILL ITEM CONTRACT_ID DESCRIPTION REFERENCE_ CODE OBS_ID COPR_ CONTRACTOR ID COPR_ DISCIPLINE ID COPR_ SCMC ID COPR_ CMC ID CONTRACT_ ToW_COLAV ID CONTRACT_ SToW_COLAV ID CONTRACT_ ToW_CSE ID CONTRACT_ SToW_CSE ID CONTRACT_ NR ID CONTRACT_ BILL_IT_COLAV ID CONTRACT_ BILL_IT_BOFF ID 1276614A1C5405A0010AA in earth SP1 SAROOJ BB LC0211 LC02 0010 AA 0010 AA 1276614 A1C5405A C5405A 1276614A1C5406A0010AA in earth SP1 SAROOJ BB LC0211 LC02 0010 AA 0010 AA 1276614 A1C5406A C5406A 1276614A1C5407A0010AA in earth SP1 SAROOJ BB LC0211 LC02 0010 AA 0010 AA 1276614 A1C5407A C5407A 1276614A1C5409A0010AA in earth SP1 SAROOJ BB LC0221 LC02 0010 AA 0010 AA 1276614 A1C5409A C5409A 1276614A1C5410A0010AA in earth SP1 SAROOJ BB LC0221 LC02 0010 AA 0010 AA 1276614 A1C5410A C5410A 1276614A1C5411A0010AA in earth SP1 SAROOJ BB LC0221 LC02 0010 AA 0010 AA 1276614 A1C5411A C5411A 1276614A1C5416A0010AA for depth up to and inclu SP1 SAROOJ BB LC0230 LC02 0010 AA 0010 AA 1276614 A1C5416A C5416A 1276614A1C5418A0010AA the height concerned by SP1 SAROOJ BB LC0211 LC02 0010 AA 0010 AA 1276614 A1C5418A C5418A 1276614A1C54200010AA Allow for the use of tips lo SP1 SAROOJ BB LC0295 LC02 0010 AA 0010 AA 1276614 A1C5420 C5420 1276614A1C5426B0010AA beyond the boundaries of SP1 SAROOJ BB LC0295 LC02 0010 AA 0010 AA 1276614 A1C5426B C5426B 1276614A1C5502A0010AA 90% of the modified max. SP1 SAROOJ BB LC0140 LC01 0010 AA 0010 AA 1276614 A1C5502A C5502A First line: System a Second line: Formule or manual b Third line: short description of analysis processing c 1) SHEET: TO IMPORT (COLAV) After organizing DATA ANALYSIS file go to first sheet. and copy and paste the formulas already entered in all the Excel cells. As you can read in second line for some field you have the formulas already entered and you have just copy and paste them into all the cells; for other fields, instead, it’s a manual process.

132. PRISM 4) 4.2 Contracts Step 4.2.a CONTRACT_ ID: it is create as CONCATENATION of : Contract_NR_ID (Po Number) Contract Bill_It_Colav (Bill Item From System) Contract_ToW_Colav (Tow From System) Contract_SToW_Colav CONTRACT_ToW_Colav / Stow_Colav : VLOOK UP from different Export ( Colav /Qlik) with Contract Bill Item CONTRACT_ToW_Colav / StoW_Colav : VLOOK UP with Base Bill Item from LIBRERIA BILLITEM CONTRACT_SMCM_ID: VLOOK UP with Base Bill Item from LIBRERIA BILLITEM REFERENCE_CODE: VLOOK UP with Base Bill Item from QLIK Price list

133. DATA ANALYSIS example DATA PROCESSING 3) A C D E F G H I J K L P Q T U DATA ANALYSIS           CHECK TO EXPORT COLAV/QLIK CHECK TO EXPORT COLAV/QLIK CHECK TO EXPORT COLAV/QLIK CHECK TO EXPORT COLAV/QLIK CHECK WITH STANDARD CHECK WITH STANDARD CHECK WITH CONTRACTUAL PRICE LIST (SAP) FORMULE =CONCATENATE (AB4;AD4;AH4;AJ4) MANUAL MANUAL =SUBSTITUTE (BD3;" ";"") MANUAL =CONCATENATE (G5;F5) VLOOKUP with price List VLOOKUP with price List MANUAL MANUAL =BG4 =BH3 VLOOKUP with price List   =(T4*Q3) CONTRACT NR_ID WBS CONTRACTOR CONTRACT NR ID CONTRACT_BILL IT_BOFF SUFFIXES AND PREFIXES CONTRACT_BILL IT_COLAV CONTRACT_ToW COLAV CONTRACT_SToW COLAV CONTRACT ToW_CSE CONTRACT_SToW_CSE Um Quantity BOFF TOTAL UNIT PRICE COST H02755 01011003 PETROJET 1210649 BLALA 01 01BLALA 0020 BB 0020 BB LS 1 400000 400000 H02755 01011001 PETROJET 1210649 BLALA 02 02BLALA 0020 BB 0020 BB LS 1 324448 324448 H02755 01010906 PETROJET 1210649 BLALA 03 03BLALA 0020 BB 0020 BB LS 1 392000 392000 H02755 01010903 PETROJET 1210649 BLALA 04 04BLALA 0020 BB 0020 BB LS 1 238580 238580 WBS: Concatenate : Level of WBS: (Column AB; Column AD; Column AG; Column AI) Z AA AB AC AD AE AF AG AH AI BD BF BG EXPORT QUANTITIES FROM BOFF                                         Job Rev. Liv1 DescrLiv1 Liv2 check DescrLiv2 Liv3 DescrLiv3 Liv4 Code Um Quantity H02755 6 01 HAWIYAH GAS PLANT HGP EXPANSION PROJECT 01 G A - GREENFIELD 10 A09 - ELE SUBSTATIONS (macroarea U/G) 03 BL A L A H02755 6 01 HAWIYAH GAS PLANT HGP EXPANSION PROJECT 01 G A - GREENFIELD 10 A09 - ELE SUBSTATIONS (macroarea U/G) 01 BL A L A H02755 6 01 HAWIYAH GAS PLANT HGP EXPANSION PROJECT 01 G A - GREENFIELD 09 A08 - BUILDINGS 06 BL A L A H02755 6 01 HAWIYAH GAS PLANT HGP EXPANSION PROJECT 01 G A - GREENFIELD 09 A08 - BUILDINGS 03 BL A L A Yellow : Export from Boff Green: Users manual analysis Step 3.2: Concatenate: Suffixes and Prefixes ( Column G) with Base Bill item Boff (Column F ) Step 3.4: Associate: TW/STW from system to TW/STW Standard from Procedure. Step 3.3: Associate: Contract/ Contractor Step 3.5: Associate:

134. PRISM 4) 4.2 Contracts Step 4.2.a

135. PRISM 4) 4.3 Contracts 4.3.1 For each Bill Item you have SCMC you can recover from Colav /Qlik export. COPR_SCMC ID- COPR_CMC_ID SCMC: (Sub Construction Management Class) : Homogeneous construction work class that aggregates several BILL ITEMS. CMC: (Construction Management Class) : Aggregates multiple Sub- CMCs,and represents a homogeneous work activities.

136. PRISM 4) 4.3 Contracts 4.3.1 COPR_DISCIPLINE ID - COPR_CMC ID GENANAG - Subcmc SubCmc _ Code SubCmc _ Description Cmc _ Code Discipline_ Code Discipline_ Description Scmc Unit Of Measure Scmc _ Efficiency BL00 BUILDING DESIGN BL00 BL BUILDINGS LUMP SUM LS 999,0 BL0000 BUILDING DESIGN BL00 BL BUILDINGS LUMP SUM LS 999,0 BL0010 BUILDING CONSTRUCTION BL00 BL BUILDINGS LUMP SUM HOUR 1,0 BL02 Earthworks BL02 BL BUILDINGS LUMP SUM LS 999,0 BL0211 EXCAVATION BL02 BL BUILDINGS LUMP SUM M3 1,80 BL0212 FILLS BL02 BL BUILDINGS LUMP SUM M3 3,0 BL0290 Other earth movement BL02 BL BUILDINGS LUMP SUM M3 2,40 BL03 Piling BL03 BL BUILDINGS LUMP SUM LS 999,0 BL0320 Small diameter piles BL03 BL BUILDINGS LUMP SUM M 1,70 BL0350 Cast-in-situ piles BL03 BL BUILDINGS LUMP SUM M 1,30 BL0360 Driven piles BL03 BL BUILDINGS LUMP SUM M 3,50 BL0370 OTHER PILES BL03 BL BUILDINGS LUMP SUM M 2,0 BL06 LANDSCAPING BL06 BL BUILDINGS LUMP SUM LS 999,0 BL0620 LANDSCAPING BL06 BL BUILDINGS LUMP SUM M2 8,0 BL09 Demolition works BL09 BL BUILDINGS LUMP SUM LS 999,0 BL0910 Demolit.rein.concr.(real vol.) BL09 BL BUILDINGS LUMP SUM M3 ,60 BL0914 Demolition furnirure / signs BL09 BL BUILDINGS LUMP SUM NR 1,0 BL0920 Demolit.civ.buildings(tot.vol) BL09 BL BUILDINGS LUMP SUM M3 5,0 BL0930 Demolition wall and partition BL09 BL BUILDINGS LUMP SUM M3 1,30 BL0940 Demolition steel cladding BL09 BL BUILDINGS LUMP SUM M2 5,0 BL0950 Other demolition BL09 BL BUILDINGS LUMP SUM M3 ,60 BL0960 Demolition steel structures BL09 BL BUILDINGS LUMP SUM KG 87,0 BL0970 Demolition of Flooring BL09 BL BUILDINGS LUMP SUM M2 1,80 BL0980 Demolition of Ceiling BL09 BL BUILDINGS LUMP SUM M2 1,0 BL0990 Demolition of doors & windows BL09 BL BUILDINGS LUMP SUM M2 ,50 You can associate CMC and Discipline Code for each Bill Item through VLOOKUP in Excel from GENANAG Export.

137. PRISM 4) 4.2 Contracts 4.2.

138. PRISM 4) 4.2 Contracts 4.2. COLUMN PRISM System Export type Field Rule A CONTRACT_ID COLAV Price List Contract / Bill_Item COLAV / TypeofWork COLAV / SubTypeofWork COLAV; CONCATENATE: Contract;Bill_Item COLAV(without space); TypeofWork COLAV;SubTypeofWork COLAV (without space); B ITEM COLAV Price List   COLAV BILL ITEM C DESCRIPTION SAP Price List Description   D QUANTITY_UNIT SAP Contract Price List UM   E QTY_ELEMENT_ID COLAV Price List Subcmc   F QUANTITY SAP Contract Price List QUANTITY   G HOUR_ELEMENT_ID CALCULATED     Always = STDMHR H HOUR_RATE GENANAG RESA 1/RESA I ORIGINAL HOURS CALCULATED     Quantity x Hour Rate J COST_ELEMENT_ID SAP ZJMU28 COST ELEMENT   K PRICE_UNIT Q     Q = QUANTITY L PRICE SAP Price List UNIT PRICE*   M ORIGINAL COST CALCULATED     Quantity x Price N CURRENCY_ID SAP      

139. PRISM 4) 4.3 Contracts 4.3. After different Export (from SAP,BOFF,PMIS,QLIK) described above the phase of Data Processing begins ( Item 3). In this phase you have already associated : Bill Item Boff to Bill Item Colav Contract and Contractor Tw-Stw by Colav to TW- StW Standard by CSE Unit Price From Contract Price List If you have used Export 2.1.a ( Total quantities ) you can utili

140. PRISM 4) 4.2 Contracts 4.2. Example PROJECT Job HAWIYAHPROJECT Location HawiyahSite CLIENT SaudiArabianOilCompany -SAUDIARAMCO PRICE LIST ScopeofWork CIVILWORKS-GREENFIELD Revision 1 Date 10-apr-19 Currency SaudiArabianRiyal (SAR) Bill Item Description U.M. Quantity Total Unit Price C C I V I L W O R K S       C 53 DEMOLITIONS       C 53 01 Demolitions of structures by any appropriate means:       C 53 01 A3 for buried structures made in reinforced concrete M3 17,85 847,10 C 53 01 C1 for any kind and height of fencing including foundations, walls, wire net, posts, etc. M 502,10 80,15 C 53 10 Allow for the use of tips located beyond the boundaries of the site and/or factory, as directed in writing by the Employer for the disposal of demolished materials; transporting excluded. M3 15.901,74 5,63 Contract Bill Item BASE BILL ITEM Code_1 Description Code_2 Description T.W. S.T.W Qty TOTAL PRICE 1210649 DC 53 01 A3 C5301A3 C I V I L W O R K S DEMOLITIONS 010B AQ 171,23 495,94 1210649 DC 53 01 C1 C5301C1 C I V I L W O R K S DEMOLITIONS 010B AQ 91,35 80,18 1210649 DC 53 03 A C5303A C I V I L W O R K S DEMOLITIONS 010B AQ 6.645,49 75,23 1210649 DC 53 03 B C5303B C I V I L W O R K S DEMOLITIONS 010B AQ 3.124,22 92,59 1210649 EC 53 01 A3 C5301A3 C I V I L W O R K S DEMOLITIONS 0010 AV 105,00 757,67 1210649 EC 53 01 C1 C5301C1 C I V I L W O R K S DEMOLITIONS 0010 AV 3.134,25 151,54 1210649 EC 53 15 B C5315B C I V I L W O R K S DEMOLITIONS 0010 AV 105,00 5,90 1210649 GC 53 01 A3 C5301A3 C I V I L W O R K S DEMOLITIONS 010G AA 17,85 847,10 1210649 GC 53 01 C1 C5301C1 C I V I L W O R K S DEMOLITIONS 010G AA 1.136,10 80,15 1210649 GC 53 03 A C5303A C I V I L W O R K S DEMOLITIONS 010G AA 17.336,39 52,11 1210649 GC 53 03 B C5303B C I V I L W O R K S DEMOLITIONS 010G AA 378,00 64,15 1210649 OC 53 01 C1 C5301C1 C I V I L W O R K S DEMOLITIONS 010S AA 747,60 72,64 1210649 OC 53 03 A C5303A C I V I L W O R K S DEMOLITIONS 010S AA 3.830,40 47,23 1210649 OC 53 15 B C5315B C I V I L W O R K S DEMOLITIONS 010S AA 3.830,40 4,88 1210649 GC5301A3 AA 010G CONTRACT_ ID

141. PAYITEMS 1. Select Payitems Import 2. Select fields in according to PayitemsTemplate 3. Select browse button to choose where to save the template and to change its name into “ Payitems Import” 4. Select Group Titles Export Option in order to have the correct Header texts 5. Select “Start Import” 6. In the export preview select Complete Export 7. You can open exported template from the Excel icon, otherwise you can open by searching it in the folder you selected for the export 1 2 3 4 6 7 5 PRISM PAYITEMS IMPORT

142. PAYITEMS CHANGES 1. Select Payitems Changes Import 2. Select fields in according to Payitems Changes Template 3. Select browse button to choose where to save the template and to change its name into “ Payitems changes Import” 4. Select Group Titles Export Option in order to have the correct Header texts 5. Select “Start Import” 6. In the export preview select Complete Export 7. You can open exported template from the Excel icon, otherwise you can open by searching it in the folder you selected for the export 1 2 3 4 6 7 5 PRISM PAYITEMS IMPORT CHANGES

143. INVOICE 1. Select Invoice Import 2. Select fields in according to Invoice Template 3. Select browse button to choose where to save the template and to change its name into “Invoice Import” 4. Select Group Titles Export Option in order to have the correct Header texts 5. Select “Start Import” 6. In the export preview select Complete Export 7. You can open exported template from the Excel icon, otherwise you can open by searching it in the folder you selected for the export 1 2 3 4 6 7 5 PRISM INVOICE IMPORT

144. INVOICE 1. Select Invoice Item Import 2. Select fields in according to Invoice Item Template 3. Select browse button to choose where to save the template and to change its name into “ Invoice Import” 4. Select Group Titles Export Option in order to have the correct Header texts 5. Select “Start Import” 6. In the export preview select Complete Export 7. You can open exported template from the Excel icon, otherwise you can open by searching it in the folder you selected for the export 1 2 3 4 6 7 5 PRISM INVOICE ITEM IMPORT

145. 4.3 Invoice 4.3.1 Introduction PRISM 4) Invoices are associated with a Contract and Invoice Data Pane includes information about the Invoice creation, as well as the services acquired or services rendered, commitments, exchange rates and totals. When the Invoice record is created, the Status ID is blank and should be updated depending on the current status of the Invoice. Once an Invoice is approved for a Contract, it can be paid and information regarding the Payment is entered in the Invoices Data Pane. The most important fields used are: Invoice ID: an alphanumeric code connected to Contract Id OBS ID: (Organization Breakdown Structure Code) is WBE from Sap Description: Title or Description of the Invoice Invoice Type: We have 5 type: -Advanced Payment (Optional) -Progress Payment -Retention Release ( Oprional ) -Completed -Terminated Vendor: Vendor Commitment: approved Cost of a Contract Unapproved Invoices : summarized Invoice Amount of all unapproved Invoices assigned to a Contract. Remaining: Commitment minus the Approved Invoices and the Unapproved Invoices Approved Invoices : summarized Invoice Amount of all approved Invoices assigned to a Contract.

146. 4.3 Invoice 4.3.1 Introduction PRISM 4) WARNINGS: Duplicate items. In case of duplicate items you will see warning and both codes will not be imported. File has to be fixed before you can Complete Import.

147. PRISM PRISM WORKFLOW When you select “Complete Import” the import process will start and the system will tell you how many lines will be imported Once the process is completed the system will give you a quick log about how many lines have been imported: these two numbers must be the same.

148. “Baseline Budget” = Original Control Budget “Approved Budget” = Revised Control Budget “Control Budget” = Fabrication Target “Estimate At Completion”/“EAC” = Forecast “ETC” = Estimate To Complete “Budget Details” = Table file for OCB detailed informations “Staffing Plan” = Table for Man-hours analysis “TM_RATE_NUMBER” this is a column contained in Staffing Plan template where we have to indicate a number referred to TM_RATE to be used for each employee ID. “Employee ID” = code for hours monitoring: Cost Center + Activity ID (939000IM01) / Badge ID “Category ID” = Code identifying single rate: Cost Center + Cost Element (939000-PIM010) “Period” = progressive number for months identification starting from 1 for first project month. “Control Account” = is the system main code; each information inserted in Prism has to be linked with one Control Account. “Control Element” = three different types of element regarding Costs, Hours or Quantities . Glossary