Clarity Toolbox - Financial Forecasting User Manual
Contents
1. Description will default to the fiscal period name Value will be the value found in the sales forecast for that fiscal period Issue Period and Due Date will be calculated by the tool lf the sales forecast for a period is zero no invoice forecast will be generated for the fiscal period El Project Data 3150634 CG 3150634 T amp E MANAGED B Message Centre Project Total Order Value CAD 6 397 837 Initial Order Value CAD 6 397 837 For T amp E projects the tool will phase the backlog in the same proportion that the period Project Sales to Date CAD 739 717 Sales Complete By 2015 11 by period ETC cost is proportioned to the total remaining ETC for the cost category Project Backlog CAD 5 658 120 Sales Recognition Type TRE When there are no cost forecast values in a period for a cost category no sales will be calculated The remaining GP will be calculated in the same proportion as the Sales Last Updated 12 18 2012 By Laird Sandra SEN d To create forecast invoices forT amp E projects click on the Create T amp E Invoices button This will create invoices based on the sales forecast for each fiscal month This action will delete all forecast invoices in the invoicing tab and replace them with those created by the tool Do not use the button if you have created milestone invoices in the invoicing tab Invoicing Costing WI Create T amp E Invoices Cost Category re To Date Backlog 2013 03 2013 04 2013 05 2013 06 2013 072. COMT Mark Marlin 1 21 Project Material Management PMMT Financial Forecasting FFT Sandy Laird 40 Project Survey PST Resource Forecasting RF MSP Schedule Converter MSP Amit Nabar 1 0 0 Toolbox Projects Project Material Management PMMT Olga Wieczorek 1 9 5 Utilisation Planning UM Project Survey PST Kathy Bakken 1 4 MSP Schedule Converter MSP Resource Forecasting RF Amit Nabar 25 Toolbox Projects Oscar Alting 1 0 0 PMO Support Utilisation Planning UM Patrick Becker n k PMO Support Call Status Contact PMO Support Toolbox questions should be directed to PMO Support Second level support will be provided by the individual tool owner To exit the Toolbox click on the Logout icon on the top right of the browser do this as opposed to simply closing the browser window as Logout will automatically free up system resources ck Links ty Toolbox User Interface Help Manual EMERSON Emerson Process Management 2015 Confidential and Proprietary aia lal Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 8 of 35 23 Feb 15 FFT Single Launch The User can access a Project in FFI using the Single Launch option through the Project Properties Page by clicking on the Actions drop down and then Launch FFT see image below Once in rest of the layouts functionalities and actions remain the same as when user goes via the Toolbox option with one exception The user will n
3. Invoicing Costing Sales Validate Issue Issue Date Period Issue Payment Currency Terms a Status Invoice Number Description Customer PO Value CZ 3 15 2012 2012 06 6015815 117 337 18 CAD 30 NETFCST 4 14 2012 20 3 16 2012 2012 06 6015818 117 337 18 CAD CU of 3 16 2012 2012 06 6015819 117 337 18 CAD 30 NET FCST 4 15 2012 20 In the Sales Tab a button labelled Create T amp E Invoices is used to generate the T amp E invoices based on the data on the Sales tab The Project Manager must click on the button to create the invoices if the button is not pressed the forecast invoices will not be created This action will delete any forecast invoices in the Invoicing tab It will not delete the invoices that have been issued in the business system Note The PM should copy the Description and or Customer PO from the forecast invoices against the issued invoices prior to using the button to create the T amp E new invoices The details on the forecast invoices are not copied to the issued invoices or newly created T amp E invoices EMERSON Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 21 of 35 23 Feb 15 4 3 Emerson Process Management 2015 Confidential and Proprietary Note Pressing the button will delete all forecast invoices previously created by this action and those created manually by the Project Manager Issue Date will default to the last date of the fiscal period
4. e For all project types except the T amp E project type the Project Manager would enter the forecast invoices or update the existing forecast invoices up to the business system Order Value e For T amp E projects the Project Manager will move directly to the Costing tab after the invoice payment terms and invoicing currency are entered and saved o If the Project Manager chooses to enter the invoices manually they can be added now or after the sales forecast is complete to validate the project forecast Note If the invoices are manually entered the Create T amp E Invoices option should not be selected in the Sales tab e For all projects if invoices have been issued in the business system the PM can match the issued invoices to the forecast invoices to move details from the forecast invoice to the issued invoice and automatically delete the matched forecast invoice 4 1 2 Cost Forecasting e The Project Manager will follow the instructions in the Cost Forecasting section to enter cost forecasts for each line of backlog and save the forecast This process is the same for all project types e For the T amp E project type the Project Manager has no other action in the Costing Tab e For all other project types the Project Manager would click on the Validate button to validate the costs and take a snapshot of the current cost forecast in the tool This snapshot data is used to 1 drive the Sales Forecast and 2 con
5. FIXED PRICE LLLP FIXED PRICE AE MANAGED BY EMERSON GAN TIME amp MATERIAL SERVICE MAINTAINANCE CONTRACTS TIME amp MATERIAL ERVICE MAINTAINANCE CONTRACTS TIME amp MATERIAL SERVICE MAINTAINANCE CONTRACTS TIME amp MATERIAL GE MANAGED BY EMERSON ON CUSTOMER PROJECT ON CUSTOMER PROJECT Note that only Customer projects that have a financial location setup in Clarity will show up on the project list EMERSON P i Emerson Process Management 2015 Confidential and Proprietary deet ee alee Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 11 of 35 23 Feb 15 4 1 Emerson Process Management 2015 Confidential and Proprietary Once inside a particular project the user will see the main forecasting screen with three tabs labelled Invoicing Costing amp Sales see below The first two tabs are data entry screens for customer invoice and project cost data respectively whilst the third tab is a sales projection based on the data provided The contents of the Project Data area at the top left of the screen is dependent on the selected tab on the Invoicing tab it shows the balance of forecasted invoices and the current project business system Order Value On the Costing tab it shows the current Revised Cost Budgets and EAC s and on the Sales tab it shows current Project Order value Sales and Backlog The displayed budgets are dependent on the project s busines
6. PO Description Pagmen Due Date issue alue Paid Paid Open Invoice Notes Date eri D ems Currenc Date 2000004 1o20 1130 2009 2010 03 92 052 1 nasizoos 8 00 it2t212 2000006 mee 1 SSES EES E nzo meos lee mee SR cater FOS approved E 272072010 2010 06 erg eme amoo oo id 000223 WEI EE 1212010 2010 04 SET re nemo O00 creak dueto wong amount 1000228 Dog Dan LC Poet 80 321972010 2010 08 40 524 787 40 524 78 2nei2o0f 000 SES BEE E e a 3111000231 zem Long 342042010 2010 06 40 524 78 40 524 78 vam D n 000222 EE CERS ER E Net 30 zwee Ce S E ous ide CALE E E A ml S C ____ aon 0e E A E E ET E A E S Cis qm ERRECHEN RR REENEN E S GEN DEER ER RUE EE GE acm _____ aon oe ct eweesomw A E E Eun seaato0fseat00 E S s zwee KEREN EE EE 2 mme EE CTT S 3111000591 EE C S E EE E a 500007 E EE cool SSC C Coe mme neon Tele ies eegne Eet Eat Et e200 19 GH FEE EC CS RE I fsawoe a E E _ irequreates E Iewen Reen LR DEER ERR REESEN beog Iesele Israel Iaeneaen _aanf ment Deag Tele TI leapeieh E Iemeaner van Ent eeng Tee lheapeieg EEE Sk a S E eg Tele a e E E E E E CCS eg Tea required E E E E __ Total EUR 1 161 362 57 355 598 3 0 00 4 2 1 Fixed Price Emerson Product Only or Service Contract Project Types For Fixed Price Emerson Product Only or Service Contract project types add invoices based on p
7. Project Operations by Cost Category Forecast Values Prior Current ETC By Period 5 Periods Period TEn EAC Method Cost Category EAC ETC sl Actual Actual 2013 03 2013 04 5 a F i 4 yee J ECA Deltav Hardware M Se 208 542 103 000 75 000 28 000 105 542 O 105 542 221 728 18 208 542 3 75 000 28 000 3 12 18 2012 208 542 103 000 75 000 28 000 ETC Ee eege ST Ei ECB DeltaV Software M ser 106 986 106 616 51 616 55 000 370 0 370 145 653 EE 12 18 2012 106 986 105 515 51 616 55 000 ETC by P d a Ff ECC DeltaV Buyouts Mater 33 926 30 000 25 000 25 000 3 926 o 3 926 63 158 y Perio 12 18 2012 53 926 50 000 25 000 25 000 IA ECK DeltaV Engr Svcs 515 745 a 450 745 0 450 745 518 857 bal zpread ant EI 12 18 2012 aude ege IA ECX DeltaV Expenses 5 569 gt SS R SS 5 925 a SpreadaneTC WM mi SEH 5 000 2 222 2 778 EXA DeltaV Engr Svcs Ris 12 650 3 i o 12 650 fa Spreadan eTC M C SE 12 650 5 622 7 028 3 0 0 0 o 8 i z R ETC by Period a mi JAA RMD Base Pressure 12 18 2012 0 0 0 0 In the Project Data and information area the current Cost Budget and EAC values from the business system are displayed as is the value of the latest cost forecast that was made with the tool The last updated date shows the date that at least one of the project cost categories had its forecast updated The current financial period is shown as is the expected financial com
8. be Go E Safety Verification Plan Review Not Applicable w Status A EMERSON Emerson Process Management 2015 Confidential and Proprietary il all Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 9 of 35 23 Feb 15 4 USING THE FINANCIAL FORECASTING TOOL Once in the Financial Forecasting tool the user will see a list of active projects that are on the My Projects list on the Overview page these are the projects to which he or she has Clarity access right User has the option of viewing All Projects instead of My Projects only By clicking on the My Projects button this will change into Show all projects Only Customer projects that have a financial location setup in Clarity will show up on the project list Project List Project List Project Filter Project Filter Project Id Project Id Manager Manager Active Yes Active Yes Fiter LU Showan f oe Fiter _ Clear My Projects All Projects The Project list may run into many pages so to assist in locating a specific project some filters have been provided Project List A Project Filter Did you Know O Projectid 310 Project Name Accessing the right FFT version With the new release of FFT two versions of FFT v 3 7 and v 4 0 will run in parallel in the Toolbox FFT will access the correct version for your Manager H Project Financial Location E project based on
9. the same dropdown menu or by selecting the appropriate You can retum to this page at any time by clicking the Home icon All the Clarity Toolbox tools will be migrated to the new style UI by end of Q2 FY15 PMO Toolbox Team Toolbox Name Abbreviation Tool Owner Cabinet Configuration CCT Oscar Alting Change Order Management COMT Mark Marlin Financial Forecasting FFT Sandy Laird Placing the cursor over the Toolbox Home will display a list of Tools to which the user has access Click on the Financial Forecasting link to enter the Project Financial Forecasting Tool In case the link is not present contact PMO Support for access rights validation Main Menu Resource Management General UM New UI Contact PMO Support Quick Link Material Menagement Utilisation Planning S LN Clarity Toolbox User Interface Help Manual e Material Manag E e Cary Toolbox tools whether they have the old style User Interface or the new style e Material Management Hu 5 want PMO Newsletter i MSP Schedule Converter ting tHE appropriate link from the left hand navigation bar for the old style UI PMO Process World Project Survey User Access Rights Guide PMO Toolbox Team Toolbox Roadmaps Toolbox Name Abbreviation Tool Owner Current Version Cabinet Configuration CCT Change Order Management COMT Cabinet Configuration CCT Oscar Alting 22 Financial Forecasting FFT Change Order Management
10. will sum the two parts when considering costs for the monthly sales calculation and cash flow When the user is finished he or she selects the save H icon and the data is stored to the database The user can cancel the operation at anytime with the cancel icon Upon saving the date of the save will be displayed in a column beside the appropriate cost categories This date will also be reflected in the Project Data section of the form A notes icon LF allows the user to enter notes against a particular line Click the icon and enter the relevant text As the line by line forecasts are built or revised the new total EAC for the cost category will update A new total EAC is displayed at the bottom and top of the page in the project information box once the icon is pressed lf the forecasting tool is being implemented for the first time during the project closing phase it is important that any cost categories with a zero ETC are opened and saved as this will pull in the current EAC figures The tool does not automatically update the business system with the newly calculated EAC values however it provides a warning that the user must update the business system when the new EAC is different to the current value therein and provides a warning message if the user attempts to exit the project without validation Since actual costs incurred on a project can increase on a daily basis the time phased ETC is only valid on the day it is ente
11. 00 000 PF di a PPO we Vd AA ob HP PD AA e dk e d d LPH a HS ANSAN A A D 2 amp 2 2 2 amp PP of SPP PPP PS oh PPP P Pos FF SPP The project invoicing portlet has been modified to add forecasted invoices as well as issued invoices The future forecasted invoices can be identified easily as they have neither a Paid value nor an Open value Description Type Status Issue Date Issue Period Value Due Date Due Period Date Paid Paid Open Value 24081499 SI P 02 10 07 POLFYOS 190 808 16 11 07 PO2FY08 02 10 07 190 808 0 24084701 SI P 03 12 07 POSFYOS 184 159 17 01 08 PO4FY08 03 12 07 184 159 0 24085118 SI P 11 12 07 POSFYOS 115 021 25 01 08 PO4FY08 11 12 07 115 021 0 24086033 SI P 02 01 08 PO4FY08 629 364 16 02 08 POSFYOS 02 01 08 629 364 0 24086240 SI P 08 01 08 PO4FY08 78 514 22 02 08 POSFYOS 08 01 08 78 514 0 24102822 SI P 23 10 08 POLFYOS 181 041 07 12 08 POSFYOS 23 10 08 181 041 0 24107200 SI 4 22 01 09 PO4FY09 90 045 08 03 09 PO6FYOS 0 90 045 Site Work Packs 12 02 09 POSFYOS 13 640 29 03 09 PO FFYOS 0 test 22 02 09 PO6FYOS 679 08 04 09 PO FFYOS 0 0 Credit 25 02 09 PO6FYOS 270 000 11 04 09 PO FFYOS 0 0 2 yrs Spares CR294 29 06 09 P10Fv09 36 709 13 08 09 P1iiFYOo9 0 0 Total 1 249 980 1 378 907 90 045 5 2 Clarity Reports Clarity reports have been added to support the tool they are e EPT SPR9 Project Forecast Costs Audit e EPT CFR7 POR Backlog Phasing Location Level e EPT CFR8 Finance Tracking e EPT CFR10 For
12. 2 2013 03 1 11 2013 2013 04 2 9 2013 2013 05 Paid 7 009 500 00 7 009 500 00 7 009 500 00 1 168 250 00 1 001 356 00 1 869 200 00 584 250 00 992 950 00 700 950 00 500 682 00 2 586 500 00 1 200 000 00 1 502 034 00 450 000 00 700 950 00 2 487 678 00 610 700 00 23 365 000 00 The issued invoices are taken directly from the business system Important Forecast invoices can only be added when the filter is set to Project currency and always entered in the Project currency regardless of the Issue Currency An optional notes icon Ei allows the user to enter notes against a particular invoice Click the icon and enter the relevant text Invoice Description and Customer PO fields are available to enter more details about the issued invoice When the Match functionality is used the issue date for the forecast invoice will appear in the Forecast Date column The Match function will be explained below in the next section of the manual The Forecast Invoices must be entered by the user in accordance with the project contractual agreement or created by the tool in the case of the T amp E project type The Issue Currency and Payment Terms will default from the Project Data section Note that as time elapses on a project manually created forecast invoices are can be automatically removed from the forecast as actual invoices are raised using the Match function or by system created invoices on T amp E proj
13. 2013 08 2013 Hourly Service SALES 6 174 921 732 982 5 441 939 152 222 190 278 152 222 152 222 190 278 152 222 152 ECK GP 772 675 72 164 700 511 19 595 24 493 19 595 19 595 24 493 19 595 19 Expenses SALES 222 916 6 735 216 181 6 453 0 0 6 453 8 066 6 453 6 ECX GP 23 504 699 24 202 722 0 0 722 903 722 S D E 9 Hourly Service SALES 6 397 837 739 717 5 658 120 158 675 190 278 152 222 158 675 198 344 158 675 158 3 GP 796 179 71 465 724 713 20 317 24 493 19 595 20 317 25 396 20 317 20 3 SALES 6 397 837 739 717 5 658 120 158 675 190 278 152 222 158 675 198 344 158 675 158 Z Total Project GP 796 179 71 465 724 713 20 317 24 493 19 595 20 317 25 396 20 317 20 The user can edit the forecast invoices in the Invoicing tab to add the Customer PO or change issue date value and due date if this is required See instructions above to edit an existing forecast invoice or add a new forecast invoice Cost Forecasting The project cost forecast tab is where the project manager is able to provide a time phased forecast of remaining project estimated to complete ETC costs by cost category by period This data is used to calculate the future cash flow and the future sales This tab is divided in to 3 main areas firstly the Project Data amp Information Area at the top of the tab secondly the Current Actual Cost Data Area and finally the Forecasting Area see below e EMERSON Process Management Clarity Toolbox Financial Forecasting User Man
14. 4 4 4 Service nd E 31 5 REPORTING AND PROFILING 32 5 1 Cany ale 32 5 2 cany RODO E 33 5 2 1 EPT SPR9 Project Forecast Cost Audn 34 5 2 2 EPT CFR7 POR Backlog Phasing 000000nnnnnnnnnnnnnnnenaaannnnnnnnrnnnnnsnnnnnnnnrrnrrrrrnnnnsnnnnnnnrrrrrreeenne 34 5 2 3 EPT CFR8 Finance Tracking REENEN EEN 34 5 2 4 EPT CFR10 Asset Managementlnventorn cccccccecssseeeeeeseeeeeeeeeeeeeeeeesaeeeeessaaeeeeeeeas 34 5 2 5 EPT CFR11 INVOICING Status 0 cceccccc cee eeeeeeeeeeeeeeessaeeeeeesaeeeeeeeesaeeeeeeseaeeeeeseeeeeeeeas 34 5 2 6 EPT CFR12 Project Forecasted Cost Details cccccccccccccseeeeseeeeeeeeeeeeeeeeeeeeeessaaeeees 34 5 2 7 EPT AGR7 POR Backlog bhasing 34 5 2 8 EPT AGRQ Invoice Schedule 00000nnnnn0000nnnnnnnnnnnnnnnnnnsennnnnrennsnnnrrrrnnsrnnrrrrensrnnrrrrenssnnnrrrennne 35 s EMERSON Emerson Process Management 2015 Confidential and Proprietary Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 4 of 35 23 Feb 15 1 INTRODUCTION 1 1 Scope This document is applicable only to Financial Forecasting Tool FFT for Clarity Locations using the JDE business system Refer to the document Financial Forecasting User Manual for Oracle if your Clarity Locations uses the Oracle business system 1 2 Purpose This document sets out the method for use of the Financial Forecasting tools that are part
15. 43 10 23 2021 AMY bro HI Interum invoice bes 20 000 00 CAD wel 5 15 2012 2012 08 Total USD 1 171 708 74 1 134 508 46 17 200 28 A L R Match Generate invoice Log If the values do not match a message is displayed to confirm you want to match them anyways Important The tool will ask for confirmation prior to Message from webpage matching invoices that are not the same value J The values are not equal Do you want to match these invoices and merge the details When matched the forecast invoice is deleted and the invoice notes description and customer PO are moved to the business system invoices OCP 4 28 2011 2011 08 6014900 K BPR 09 03440 st 2801 117 703 65 USD Net 30 5 28 2011 2011 09 117 703 14 0 51 6 ai OOM s 30 2011 2011 09 6014986 Nae invoice mITED 27 658 88 USO Net 30 6 29 2011 2011 10 27 659 23 0 35 7 22 2011 59 0 35 7 22 2011 5 10 2012 CD 7 8 2011 2011 10 6015118 Invoice for Julll Feb12 BPR 09 03440 dt 28 Or 17 202 02 USO Net 30 8 7 2011 2011 11 0 00 17 202 02 3 30 2012 og 9 7 2011 2011 12 6015319 28 121 30 USO Net 30 10 7 2011 2012 01 28 121 73 0 43 10 13 2011 Total USD 1 151 708 74 1 134 508 46 17 200 28 A R Match Generate invoice Log The issue date on the forecast invoice is displayed in the Forecast Date field to show when the forecast invoice was expected to be issued This field is not available for entry and will only be populated when the Match button is used To manu
16. Clarity Toolbox Financial Forecasting Tool User Manual Global Project Management Office End Customer End Customer Reference Number Document File Name Clarity Toolbox Financial Forecasting User Manual Document Status Eighth Issue Authorizations Name Function Signature Roger Freeman VP Project Management Office Developed By Distribution As Required Company Company EMERSON Emerson Process Management 2015 Confidential and Proprietary Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 2 of 35 23 Feb 15 Revision History Rev Status Description Date Developed By Reviewed By Internal review document 4 Jan 2009 Released Consistent with V3 1 V3 2 V3 3 27 Jun 2011 Sandy Laird V3 4 and UI changes Consistent with V3 5 Release 1 01 Dec 2011 Sandy Laird SS Drafted Consistent with V3 5 Release II 30 Apr 2012 Sandy Laird a Released Consistent with COMT 1 0 and 18 Dec 2012 Sandy Laird removal of the Change Order tab For Review Applicable to JDE Locations 04 Feb 2015 Shailaja Kedari Sandy Laird only new UM for FFT v4 will be released separately for Oracle sites Consistent with COMT 1 0 05 Dec 2012 Sandy Laird Emerson Process Management 2015 All rights reserved Unauthorized duplication in whole or in part is prohibited Trademarks identified in this document are owned by one of the Emerson Process Management group of companies Unles
17. Period This report can be run by Division END OF DOCUMENT EMERSON l P MI Emerson Process Management 2015 Confidential and Proprietary dt ie all
18. To create a new forecas the dropdown box and enter the values in the se Last Updated 11 10 2012 By Laird Sandra k icon to cancel any changes in the row Use the prewiouslhy forecasted line Edit all lines and use The date will refresh on the line and the total wa net been updated within the current fiscal perior Please make sure that any new EAC s calculate system To walidate the forecast is ready for fut Walidate butten This will ensure the Invoice C complete Validation for TRE projects is done o BEE Beu Sales Validate Tp2 last validation was performed on 8 23 2012 Current Cost Values in Oracle Project Operations by Cost Category Oracle Prior Current Total 5 Task Periods Period Acted EAC Method Cost Category Number Actual Actual 2 5 E Ti NAD PWS Owation Power In Ho EI o100 406 946 109 O 406 946 109 416 771 723 Spread an ETC 8 23 20 z NAX PWS Trawel Expense 0191 14 747 945 O 14 747 949 17 149 552 Le Spread an ETC bi Ej 823 20 421 694 058 D 421 694 058 433 921 285 POC 01 MDO1 Main System E If the cost forecast lines have not changed since the prior month then user can simply click the Validate button and does not have to open each line in order to confirm the forecast A new snapshot will be taken and dated to be used for the Sales Forecast For T amp E projects this validation is done when the T amp E project invoices are created in the Sales Tab The Validate button is not available for T amp E proj
19. ally delete an existing invoice from the forecast simply click in the box beside the invoice s to be deleted and click on the LA delete icon at the bottom of the list and confirm with the dialog box This is the same checkbox that is used for the Match functionality As an aid to communication a tick mark Vv is provided to indicate that the conditions for raising an invoice have been met clicking the tick mark in the left most column will EMERSON Emerson Process Management 2015 Confidential and Proprietary il all Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 20 of 35 23 Feb 15 4 2 2 Emerson Process Management 2015 Confidential and Proprietary set the mark indicating that the invoice can be raised If the invoice is tick marked this will determine how the invoice is treated on the EPT CFR11 Invoicing Status report Invoicing values have sufficient precision to enable the exact values that are to be invoiced to be entered Invoices that have their issue dates forecast in the past or invoices that are past due for payment will have the issue dates shown in red text Projects that have a different invoicing currency to the local functional currency will display a drop down box that allows the user to change the display between these two currencies However in this case data entry and editing will only be allowed in the project Currency once set Conversions are done using the GAAP rate in ef
20. ca Projects gt 1 POC Latin America Projects gt 250k POC Projects lt 250k Completed Contract Europe Projects gt 500k POC Projects lt 500k Completed Contract Middle East amp Africa Projects gt 500k POC Projects lt 500k Completed Contract Asia Pacific Projects gt 500k POC Projects lt 500k Completed Contract To be considered as POC in RAS a project must have duration of more than 6 months and the Initial Order Value must be over 500k USD in all World Areas as shown in the table below World Area Description Method North America POC m O O Latin America POC eme Europe Projects gt 500k POC Projects lt 500k Completed Contract Middle East amp Africa Projects gt 500k POC Projects lt 500k Completed Contract Asia Pacific Projects gt 500k POC Projects lt 500k Completed Contract For CC projects all the sales is forecasted in the month when the project is forecasted to be complete This is driven by the project completion period from the costing tab For POC projects the tool will phase the backlog in the same proportion that the period by period ETC cost is to the total remaining ETC by cost category When there are no ETC values all the sales will be assigned to the finishing period as prior method In both cases the remaining GP will be apportioned in the same proportion as the Sales The bottom of the page shows totals of columns by division For loss making POC projects ei
21. dy invoiced and not generated by the tool to forecast up to the business system Order Value Final Steps for T amp E projects e Once the invoice cost and sales forecast are complete and saved the Project Manager clicks on the Validate button in the invoicing tab to confirm the forecast making the information is available for reports and interfaces Since the validation for other projects was done in the Costing tab no action is required for these project types e Finance will provide a schedule for the confirmation of the timing which the Project Manager will adhere to each month This step is critical for providing accurate data for the financial POR submitted to Emerson monthly Reports Clarity e The confirmed data is available for Clarity reports once the Validate button is pressed either in the Costing Tab or in the Invoices tab e For Clarity reports the information is used from the confirmed project forecasts Forecast Reports Run by Finance Finance will run the Clarity reports to access the data for the forecasts These reports include actual and forecast invoices cost and revenue The reports can be run for an individual project or for projects in a location broken down by product group or division Invoice Forecasting The first time that a project is opened in the Financial Forecasting tool the user will be forced to enter the customer invoice payment terms in number of days and the invoicing currency T
22. e zero however it is possible to have a situation where the total value of the actual and forecasted invoices is more than the project business system Order Value This can happen when an invoice has been issued and the user has not removed it from the forecast or when we have been able to invoice for work outside the current contract and the official PO has not yet been received However the forecast value should never be less than the business system Order Value except in the case of T amp E projects where the order value is greater than the expected invoice value In order to prevent user frustration a tolerance of 2 currency units is allowed in the reconciliation of invoices to the project business system Order value For projects that will be invoiced in a currency different to the local functional currency the balance will not be accurate this is due to the complex nature of re valuing foreign currency projects Because of this a warning will be shown in the message centre Future releases may resolve this problem Example E Project Data 32500247 Polyol SIL conf LUMP SUM FIXED LC Revised Order ValueSEUR 484 518 Payment Terms 30 days Total Invoices Issued to Date EUR 478 728 of which EUR 461 961 is paid Total Invoices Forecast EUR 22 356 Completion Date 5 24 2012 Imbalance EUR 16 766 Last Updated 4 23 2012 By Hiremath Kiran The main invoice list shows two types of invoices Issued Invoices and Foreca
23. ecast Asset Management Inventory e EPT CFR11 Invoicing Status Report e EPT CFR12 Forecast Costs by Location Project Division EMERSON Emerson Process Management 2015 Confidential and Proprietary ial Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 34 of 35 23 Feb 15 5 2 1 5 2 2 5 2 3 5 2 4 5 2 5 5 2 6 5 2 7 Emerson Process Management 2015 Confidential and Proprietary e EPT AGR7 POR Backlog Phasing World Area Level e EPT AGRQ Invoice Schedule by World Area Location EPT SPR9Q Project Forecast Cost Audit This report provides an audit trail for a particular project that allows the user to review the history of all the cost forecast changes that have been made to a specific project EPT CFR7 POR Backlog Phasing This report is a location level report that takes all the forecast data from all the projects in a specific location and produces a phased backlog sales forecast based on the appropriate Sales forecasting methodology as described above An option to report in Fixed USD is also provided EPT CFR8 Finance Tracking This report provides Finance with control data to enable them to review how up to date EAC values are in the business system with respect to the last forecast made in the tool It is a location level report for financial controls that looks at all the forecasts made for the projects in the tool and provides data on when the forecast was la
24. ects The forecast invoices can also be manually deleted if this option is preferred It is in the role of the Project Manager to make sure the invoice register balances each month A sum for the Value Paid and Open columns will total the invoice list to include the issued and forecast invoice values The currency of the total is shown beside the word Total beside the Value column total The issue currency for the invoices does not change with a change in the currency filter The Project Manager can generate an invoice log from the Invoicing tab The invoice log allows the PM to have a listing of all invoices on the project including forecast invoices The log includes all fields shown on the invoice list including the invoice notes The log can be created in either the invoice project or local currency For JDE projects invoice Emerson Process Management 2015 Confidential and Proprietary 7 s EMERSON Process Management Ope Dt Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 18 of 35 23 Feb 15 statuses A and P are displayed as OP and CL respectively payment terms and issue Currency columns will be blank on the log Invoice Log PM lnb Project Title Shell CYP Rigids Revision A1 3 29 2012 Page 3 of 3 Emerson Project Number 31001316 Invoice Log Invoice No ssue Date recas nvoice Statu Customer
25. ects and will not be displayed in the Costing Tab Users must check their cost forecasts and validate once per month as normal Sales Forecast The Sales Forecast tab displays the calculated sales forecast period by period for each cost category No additional data is required to be entered to obtain the forecast The forecast calculation method is dependent on Project Type set in Clarity and the Initial Order Value with the cost forecast and project schedule used as base data On entering the tab the user will be presented with the current sales forecast this will be split down by the current Order Value Sales recognised to date and the Backlog All these parameters will be read from the appropriate business system by cost category The tool will display a phased view of the current backlog by period driven by the appropriate method and uses the new EAC forecast on the project to calculate sales and GP See below EMERSON Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 27 of 35 23 Feb 15 El Project Data 31001316 Project Total Order Value EUR 1 227 241 Project Sales to Date EUR 711 530 Project Backlog EUR 515 711 Cost Category Emerson PSS Pricebook Products SALES ECA GP Emerson PSS Pricebook Products SALES ECB GP Buyouts and Subcontracts SALES Ecc GP Hourly Service SALES ECI GP Hourly Service SALES ECK GP Expenses SALES ECX GP Hourly Service SALES EXA GP Em
26. erson Other Products SALES JAA GP Hourly Service SALES GP Emerson Other Products SALES GP marsen Shell CVP Rigid LUMP SUM FIXED Initial Order Value EUR Sales Complete By Sales Recognition Type POC 1 153 802 Last Updated 12 18 2012 By Laird Sandra Message Centre This type of contract is termed either POC Percentage of Cost or CC Completed Contract The decision is taken once at the start of the project based on the Initial Order Value and the GAAP USD FX rate in effect at that time together with Project Duration Once the decision is taken then the project remains in that mode until completion irrespective of the changes in exchange rates or variation orders For CC projects all the sales are forecasted in the month when the project is forecasted to be complete This is driven by the Completion Period which is maintained on the Costing tab For POC projects the tool will phase the backlog in the same proportion that the period by period ETC cost is proportioned to the total remaining ETC by cost category When there are no ETC values all the sales will be assigned to the finishing period as prior method In both cases the remaining GP will be calculated in the same proportion as the Sales The bottom of the page shows totals of columns by division Note that division product costs will be treated as CC unless the world area allows sales to be treated as POC Therefore some projects will use a mix o
27. f CC and POC methods Invoicing Costing Ea Order Value To Date Backlog 2013 03 2013 04 185 923 22 619 85 042 21 944 74 809 20 883 1 1 875 640 359 895 5 825 256 1 12 649 0 0 1 227 241 323 823 0 0 a ans mae 107 794 20 759 49 306 35 141 43 373 6 755 1 1 507 678 206 856 3 377 0 4 7 336 0 0 711 530 150 376 0 0 aa rnn 78 129 1 860 35 736 13 197 31 436 14 128 0 0 367 962 153 040 2 448 256 0 5 313 0 0 515 711 173 448 0 0 rar sae 46 453 1 994 21 247 16 936 18 691 10 570 0 0 218 777 91 724 1 456 212 0 3 158 0 0 306 624 118 278 31 676 3 854 14 489 3 739 12 745 3 558 0 0 149 185 61 316 992 44 0 2 155 0 0 209 087 55 170 nnn ans For T amp E projects the tab will appear slightly different as it includes a button to create T amp E project invoices based on the calculated sales forecast This functionality is explained in the section for T amp E Time and Material Projects below E Project Data 3150634 CG 3150634 T amp E MANAGED B Message Centre Project Total Order Value CAD Project Sales to Date CAD Project Backlog CAD Invoicing Costing Cost Category Hourly Service ECK 6 397 837 739 717 5 658 120 Initial Order Value CAD 6 597 837 Sales Complete By 2015 11 Sales Recognition Type TRE For T amp E project
28. fect at the time an invoice was issued or for future forecast invoices at the current GAAP rate Regardless of the filter setting the Issue Currency will not change based on the filter it will display the business system currency or for forecast invoices default from the Project Data section setting unless the PM has changed the setting manually T amp E Project Type For T amp E type projects invoices can be generated based on the sales forecast for the fiscal period For T amp E type projects move to the Costing Tab to forecast costs as the invoices will be created from the Sales Tab The user can manually enter the invoices in the tool if this method is desired Financial Forecasting El Project Data 3150634 CG 3150634 T amp E MANAGED B Message Centre Approved Order Value CAD 6 397 837 Payment Terms 30 days Invoices without edit icons are already issued to customer Total Invoices Issued to Date CAD 702 188 of which CAD 407 532 is paid Issued invoices shown in red are past due Forecasted invoices in the past show the date in Total Invoices Forecast CAD 0 Completion Date 7 31 2015 red and need correcting Imbalance CAD 5 695 649 The total value of all invoices must be at least as much as the Total Order Value To validate the forecast is ready for future POR reporting click on the Validate button This Last Updated 12 18 2012 By Laird Sandra will ensure the Invoice Cost and Sales forecast are complete
29. financial information and project schedule data EMERSON Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 6 of 35 23 Feb 15 3 HOW TO ACCESS THE CLARITY TOOLBOX Access to the Clarity toolbox will be granted on request by the PMO Support group It is dependent on the users role and business needs Once access rights have been granted an additional Clarity Toolbox tab will appear on your Clarity Overview screen as shown below View Action Items Assigned to Me a New Selecting this tab will bring up the Clarity Toolbox access button see below click on this button to launch the toolbox The toolbox will launch in a separate browser window however the new Window will be aware of the user s current rights and profile Clarity Toolbox Report Updates Personal Assignments When the Toolbox launches the user will see the Toolbox Home page see below This page provides an overview of the Toolbox and lists out the PMO Toolbox team EMERSON Emerson Process Management 2015 Confidential and Proprietary aaa llell Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 7 of 35 23 Feb 15 Overview ten Welcome to the new Clarity Toolbox homepage From this page you can access all the Clarity Toolbox to To access a Toolbox tool dropdown the Toolbox Home menu and select the tool you want You can navigate directly between tools using
30. firm the forecast and make the data available for reports and interfaces and 4 1 3 Sales Forecasting e Sales forecasts are calculated using logic in the FF tool based on project type The Project Manager will review the forecast e For all project types except T amp E project type the Project Manager has no other action in the Sales tab e For T amp E projects the Project Manager would create the T amp E invoices by clicking on the Create T amp E Invoices button This action will create T amp E invoices for each financial period in the sales forecast o Invoices created using this option can be fine tuned if required o If the Project Manager has chosen to create the invoices manually then the Create T amp E Invoices button should not be pressed as this button first removes manually entered invoices before automatically creating invoices to match the sales forecast EMERSON Pi Emerson Process Management 2015 Confidential and Proprietary ieee alee Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 15 of 35 23 Feb 15 4 1 4 4 2 Emerson Process Management 2015 Confidential and Proprietary Invoice Forecasting for T amp E projects e For T amp E projects the Project Manager reviews the invoices created by the FF tool and updates the description or invoice date if applicable e The Project Manager will add any additional invoices that may be required on actual costs not alrea
31. his is to enable invoice forecasting in a different currency to the local functional currency however the default is always the local functional currency The payment terms value is used by the tool to calculate when invoices are due and to draw the project cash flow portlet in the main Clarity application Select the correct currency and enter the number of days E g 30 45 60 days and click on the save icon H note that these values can only be entered once In the event that these data fields are set wrongly then PMO Support group can assist in resetting them e EMERSON Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 16 of 35 23 Feb 15 OOIDOX Financial Forecasting Project Data 3133045 SC 3133045 LUMP SUM FIXED Invoicing Currency Payment Terms days Completion Date 3 7 2013 Tee em Costing Sales When the selections are saved the tool will initialize the project setup determining the type of project The criteria used to determine this setup will be displayed in a message after the save icon is pressed Once this step is complete the project data will show up for the invoicing context and the invoice list will be available to work with The invoicing project data area shows the current business system Order Value the value of invoices already issued and the value of invoices forecast See below Ideally the net balance of these three items will b
32. lue over the remaining periods note that this method takes account of the number of days in each period which results in values which will not be uniform by period ETC by Period This method is entirely manual and allows the user to manually enter the expected data as an ETC per period Data is presented to the user in accordance with the prior forecast which can be edited cell by cell by the user The new values for ETC and EAC are calculated and displayed as above When entering values for Buy Out or Product by this method it is important to remember that the dating and phasing is determined from when the costs are expected to occur not when the purchase order is placed This is normally when the goods or services are booked in As a line forecast is built or revised the new total ETC and EAC is displayed for the line Each column has a total at the bottom that reflects the total costs expected in that period from all cost categories EMERSON Fi WM Emerson Process Management 2015 Confidential and Proprietary ill Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 25 of 35 23 Feb 15 The tool treats the current period in two parts actual costs up to the current date and remaining costs in period these two parts of the same period are highlighted in yellow So when making a forecast during a period do not include the current periods actuals into the current periods forecasted value field the tool
33. ntre and world area level in order to collect and review current project financial status having erroneous data in the tool at these times will only create additional work and inquiries A ei EMERSON Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 12 of 35 23 Feb 15 The monthly process flow is detailed below for the user The steps to be done per tab Invoicing Costing and Sales are described in the monthly process after the process flow For Time and Expense T amp E projects the tool can create the invoices based on the sales forecast but this is not a requirement Important The project type in Clarity should match the project type in the business system There may be unexpected results in the tool if these two are not aligned EMERSON F WM Emerson Process Management 2015 Confidential and Proprietary dt ie all Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 13 of 35 23 Feb 15 Invoicing Tab Costing Tab Sales Tab Enter Payment Tems and Invoice A Ge hy wn gr EMERSON Emerson Process Management 2015 Confidential and Proprietary il all Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 14 of 35 23 Feb 15 4 1 1 Invoice Forecasting e The first time the Project Manager accesses the project in the Financial Forecasting tool the invoice payment terms and invoicing currency must be entered and saved
34. of a set of tools known collectively as the Clarity Toolbox These tools support the business requirements of PSG in the management and execution of its projects The Toolbox will support the PMO Processes in areas where a tool has been identified as needed but is not necessarily covered by core Clarity functionality 1 3 Reference documents Clarity User Manuals Data Dictionary EMERSON Emerson Process Management 2015 Confidential and Proprietary il all Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 5 of 35 23 Feb 15 2 Emerson Process Management 2015 Confidential and Proprietary FINANCIAL FORECASTING Enterprise level financial forecasting tools are required to assist the Project Managers in the production of accurate and reliable project financial forecasts These forecasts include e The forecasting of Customer Invoice dates and values e Forecasting of Customer Payment dates and values e Forecasting of Project Estimate to Completion ETC costs by financial period As a result of the above the tools will calculate and report on e Future project cash position by period aka Cash Flow e Future project Sales by period e Future project Work In Progress The Clarity Toolbox tools assist the PM in development of the above and enable the collection of location level data through standard Clarity reports The toolbox leverages existing data within Clarity including existing current
35. olbox EAC out of Balance Project Manager Artur Pfeffer GP Tracking Balance Lead Engineer Heidrun Renner Risk Allowance Balance Project Last Baselined 21 Jul 2010 EET Proposal Number PATT ID 0 Total Results o 9909F Project Accounts EET As Sold Values out of Sync Total Results 6 The Key Financials portlet has been modified to include the current values that are held as Project Accounts EAC and Toolbox Forecast EAC See below Actions Revised Cost Budget 311 096 93 2 Current Cost Status Actual Cost 311 537 93 4 Commited Cost 220 0 1 Actual Committed Cost 311 317 93 3 Cost Estimates ETC Cost 22 390 6 7 D Latest EAC from Forecasting Tool 319 957 Estimated Variances Estimated Cost Variance 22 612 7 3 EAC Cost Index 1 07 Risks Risk Allowance from Project Accounts 0 Risk Allowance from Clarity 0 Total Results 16 The Cash Flow portlet has been modified to include the future project cash flow based on the latest current invoice and cost forecast This portlet now includes a vertical line centred on the current date to the left is the historic cash flow too the right is the forecasted cash flow See Below e EMERSON P hi Emerson Process Management 2015 Confidential and Proprietary Pe Sessa eres Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 33 of 35 23 Feb 15 2 000 000 E Receipt LI Payment E Balance 1 000 000 1 0
36. ot be able to access another project in FFT via the window and must either access a project in the Project Properties Page or access through the Toolbox Home page The User should close the window before proceeding to a new project Project CH Novartis BioPharmOps Singapore Project Properties Main Main Properties ee Openin Scheduler v Genera I Clarity Toolbox Reports Project Definition Add to My Projects Launch PMM SPR1 Report EB Froject Name CH Novartis BioPharmOps Singar EiProject Manager Portalier Alexandre KR Copy Project from Template SPR3 Report Redirect Go to Links Page Launch COMT SPR4 Report Redirect Project ID 41550065 Lead Project Engineer Dombe Shrinivas Go to Notes page Launch PST SPR7 Report Ei Project Contract Type Lump Sum Fixed Price SIS Lead Engi SPR10 Report This setting drives the calculation method used to forecast project sales see Financial Forecasting tool in the 9 E SPR13 Report Redirect Clarity Toolbox for details Project Administrator rn EiProject Phases Execution Only w Indicate what phases are included in this project to determine the Project Satisfaction Survey requirements Planner Soman Vidish m B industry Code Life Sciences X Sales Representative Thomas Steiner Active Active El This project uses the PMO Description o Configuration Standard for DeltaV Yes e PCSD EX This project includes a SIS No v EDMS URL
37. pletion date This date is initially taken from the Clarity schedule either the last activity date or the Financial Completion Milestone but can be overridden by the user with the date picker Once the completion date is manually overridden it cannot be returned to be driven by the Clarity schedule The Current Actual Cost Data Area displays values from the business system by cost category these include Prior Periods Actual Cost Current Period Actual Cost and EAC The current period actual costs will be up to date as of the close of the prior day Current Period Actual Cost is highlighted in yellow such that the user will be aware of how much cost remains to be allocated for the current period given that it is unlikely that forecasts will be made exactly at period end None of the data in this area is editable by the user The Forecasting Area is the area where the user interacts most with the tool Normally this data is presented as black text however if a forecast has not been updated for more than one financial period then the data will be displayed in red text A tooltip is displayed for any row or fiscal period that shows the row details to assist in forecasting values when there are a large number of periods e EMERSON Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 23 of 35 23 Feb 15 In order to make a forecast the user selects a forecasting method from the dropdown list for the app
38. pt the CC method defined above 4 4 4 Service Contracts The sales forecasted in each period assume that the sales are equally spread throughout the periods over the duration of the project e EMERSON P WM Emerson Process Management 2015 Confidential and Proprietary ial managemen Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 32 of 35 23 Feb 15 3 REPORTING AND PROFILING A number of reports and portlets are available to provide data output from the tool these include e Core Clarity Portlets e Core Clarity Reports 5 1 Clarity Portlets The Clarity Dashboard financial portlets have been modified to accommodate data from the Financial Forecasting tool The Project Information portlet has been modified to include two new stoplights These are the Forecasted Invoices Imbalance stoplight which indicates how complete the Invoice Forecast is and the Project Accounts EAC and Toolbox or Forecast EAC out of Balance which indicates that business system has not been updated with the latest calculated EAC Detailed information on the values that drive these stop lights are to be found under Stoplight Help on the portlet page See below Project Key Information Value Stoplights Status Project ID 49500894 Cost Budget Overru o Project Name Cognis Ablasung HD6 orecasted Invoices Imbalance e Description Customer COGNIS PATT ID 72417 Proposal Number 8 HaaNnio010032 Project Accounts EAC and To
39. red This means that any Sales Forecast driven form a cost forecast could be wrong unless the Sales forecasting report is run at exactly the right time For project types other than the T amp E project type a Validate button has been provided see below on the costs page such that once the user is ready to take a snapshot of the current cost forecast in the tool and the associated current financial status from the business system This snapshot data is then used to drive the Sales Forecast and means that a Sales forecast can be displayed Sales tab or Report at anytime and it will always be calculated based on the last set of validated or snapshot data e EMERSON l Fi Mi Emerson Process Management 2015 Confidential and Proprietary dt ie all Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 26 of 35 23 Feb 15 4 4 Emerson Process Management 2015 Confidential and Proprietary Financial Forecasting El Project Data SIXMOSES SE PWS Sarir LUMP SUM FIXED Current Total Revised Cost Budget in Oracle KRW 829 147 381 Current Period 2013 03 The current walues in the business system are product group code the last forecast sawed int Current Total EAC in Oracle KRW 824 339 301 Completion Period 2013 06 hand panel by product group cede and future fir Prior Forecast Total EAC KRW 797 956 121 Operations column Periods that were saved In the past are not shown
40. roject milestones Follow the directions below to add edit or delete previously forecasted invoices To add a new invoice to the list select the a icon and complete all the data requested a date picker enables the selection of the date that the invoice will be issued to the customer Using this date the tool will determine the financial periods when the invoice is both issued and due to be paid The Description field is mandatory for forecast invoices Additional invoices can be added by selecting the _ dicon again Click the H icon at the bottom of the list to save the new invoices to the register or the b icon to cancel the operation It is not necessary to save each invoice individually The H icon will save all invoices that have been created All invoices which have editing icons beside them are available to update delete or mark the status To edit an existing invoice change the data fields as required and either save using the 41 icon at the bottom of the invoice list or cancel using the k icon beside the invoice The Match button can be used to match a business system invoice to a previously forecast milestone invoice This allows the user to select one issued invoice and one forecast invoice to match them using the checkbox to the right of the invoice Issue Date The Match function will delete the forecast invoice and move the description and customer PO to the business system invoice The invoice amounts should be equal b
41. ropriate cost category The tool will refresh and provide input boxes to be completed or reviewed depending on the message All lines can be updated and then saved using the save Bi icon at the bottom of the list The cancel l l icon will be displayed beside each edited row to cancel individual row activity If a previous forecast has been done on the project the rows using the ETC by Period method will display the input row in red upon entering the tab with the previously forecast values in the row Any row previously forecast using the Spread by Period Read from Clarity or Read from PMM will display a La icon to open and view the updated details The types of methodology that are available and appropriate depend on the cost category as follows Services choose from o Spread an ETC o ETC by period o Read from Clarity e Product chose from o ETC by Period o Read from PMM e Buy Out choose from o ETC by Period o Read from PMM e Expenses choose from o Spread an ETC o ETC by period e Risk Allowance choose from o Spread an ETC o ETC by period e Non PSS Product o ETC by Period e EMERSON F WM Emerson Process Management 2015 Confidential and Proprietary ial managemen Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 24 of 35 23 Feb 15 e Installed Base o ETC by Period When a methodology has been selected the forecast line will refresh with the old or prior forecast being displa
42. s th by period ETC cost When there are no calculated The rem Last Updated 12 18 2012 By Laird Sandra Create T amp E Invoices SALES GF Order Value 6 174 921 772 675 To Date To create forecast will create invoices delete all forecast ir the tool Do not use tab Backlog 2013 03 2013 04 732 982 5 441 939 152 222 190 278 72 164 700 511 19 595 24 493 In the project information area the user sees the total project order value sales recognised to date and the backlog also shown is the calculation methodology and the Sales Complete By date this is driven from either the delivery date or financial completion date dependent on methodology The methodology used to calculate Sales along with a brief explanation of that methodology are to be found in the Project Data area and message centres respectively Emerson Process Management 2015 Confidential and Proprietary A e EMERSON Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 28 of 35 23 Feb 15 The Project Type field in the Clarity financial module is used in combination with project value and duration to determine which methodology is used for the sales projection Important If the project type in Clarity does not match the project type used in the business system unexpected results may occur See screen shot from Clarity below EJ Project Mame juk BNFG EPMF PHS SE Li Please s
43. s otherwise agreed to in writing by the parties any information provided in this document is confidential or proprietary and may not be used or disclosed without the expressed written permission of Emerson Process Management Emerson Process Management Process Systems and Solutions e www Emersoncom EMERSON Emerson Process Management 2008 Confidential and Proprietary DEER Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 3 of 35 23 Feb 15 Contents 1 INTRODUCTION 4 1 1 SEENEN 4 1 2 FUTO SO aeree tapestry sip eb siren pete aires seb EEES 4 1 3 Reference documents 4 2 FINANCIAL FORECASTING 5 3 HOW TO ACCESS THE CLARITY TOOLBOX 6 4 USING THE FINANCIAL FORECASTING TOOL 9 4 1 MOMAY ee 11 4 1 1 Invoice FOP CCASUUAG ME 14 4 1 2 COST FOCI SUG EEN 14 4 1 3 Sales Gr e cer EE EE eee nee ee 14 4 1 4 Invoice Forecasting for TSEorolecs ccc ccccccsseeecceeeeeeeeeeeeseeeeeeseaeeeeseeeesaaeeeesseeeeesaeeeeens 15 4 1 5 Final Steps for TSEoroiecs 15 4 1 6 Reports Cart 15 4 1 7 Forecast Reports Run by Finance a annaennnnennnnennenennnenrrnenrrnrrrrnsrrrnsrrrnsrrrnsrrrnnrrrnnrrrennrrennnne 15 4 2 INVOICE TOF CCASUNG EE 15 4 2 1 Fixed Price Emerson Product Only or Service Contract Project Types 001 0000nnn000000nnai 18 4 2 2 T amp E Project Type 20 4 3 ROS Oe Cel SWING E 21 4 4 Sales ORC d EE 26 4 4 1 Lump Sum Fixed Price Project 28 4 4 2 E Ce 30 4 4 3 Emerson Product Only 31
44. s system The Message Centre area is function dependant and always provides the user with a prompt as to what actions are required Toolbox Financial Forecasting El Project Data 82531104 SE DEP HHI My LUMP SUM FIXED Approved Order Value USD 4 725 825 Payment Terms 30 days Total Invoices Issued to Date USD 3 700 000 of which USD 3 330 000 is paid Total Invoices Forecast USD 1 Completion Date 12 12 2012 Imbalance USD 1 025 824 Last Updated 4 25 2012 By Laird Sandra _ Invoicing Costing Sales Currency Issue Issue Date Period Status Invoice Number Description Pi 11 30 2011 2012 03 70000234 90 of contract value E Df 12 1 2011 2012 03 70000235 bus zg mE Lenz 2012 07 Festinvoice S The Invoicing tab is the default tab and is the normal point of entry Monthly Process It is intended that the Financial Forecasting tool should be used during normal project management operations to keep an accurate and up to date forecast of invoices and costs by period These should be updated as soon as the PM is aware of them However there are also specific times in the monthly financial cycle at which the data in the tool will be accessed by others and consequently must be accurate and current best forecast These times are by the end of the third day of the new period in time for preparation of the monthly POR and immediately prior to a project review At these times data reports will be run at the ce
45. st Invoices See below EMERSON Emerson Process Management 2015 Confidential and Proprietary aoa lel Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 17 of 35 23 Feb 15 Invoicing Costing Sales Issue Period 2010 11 Issue Date C 8 12 2010 C 12 14 2010 O 2 4 2011 Cf 10 4 2011 2011 03 2011 05 2012 01 C 1 26 2012 2012 04 C 4 11 2012 Of 5 2 2012 C 5 29 2012 2012 07 2012 08 2012 09 Cf 5 31 2012 CF 7 2 2012 C 8 29 2012 2012 09 2012 10 2012 12 Cf 9 27 2012 2012 12 Cf 9 27 2012 2012 12 Cf 9 27 2012 2012 12 Cf 11 1 2012 2013 02 C 11 27 2012 2013 03 Ei 12 26 2012 2013 04 Status Invoice Number 96006531 96007444 96007801 96009975 96011091 96011807 96012010 96012305 96012348 96012727 96013509 96013899 96013900 96013902 96014359 96014650 96015071 Description Customer PO E EE Value 7 009 500 00 7 009 500 00 7 009 500 00 1 168 250 00 1 001 356 00 1 869 200 00 584 250 00 992 950 00 700 950 00 500 682 00 2 586 500 00 1 200 000 00 1 502 034 00 450 000 00 700 950 00 2 487 678 00 610 700 00 Total RUR 23 365 000 00 Due 9 26 2010 2010 12 1 28 2011 2011 05 3 21 2011 2011 06 11 18 2011 2012 02 3 11 2012 2012 06 5 26 2012 2012 09 6 16 2012 2012 09 7 13 2012 2012 10 7 15 2012 2012 10 8 16 2012 2012 11 10 13 2012 2013 01 11 11 2012 2013 02 11 11 2012 2013 02 11 11 2012 2013 02 12 16 201
46. st forecast is zero in a fiscal month the sales forecast will default to zero in the month A button labelled Create T amp E Invoices on the Sales tab is used to generate the T amp E invoices from the sales forecast by period in the Sales tab The Project Manager must click on the button to create the invoices if the button is not pressed the forecast invoices will not be created lf the project manager chooses to enter milestone invoices manually in the Invoicing tab the Create T amp E Invoices button should not be pressed Note Pressing the Create T amp E Invoices button will delete all forecast invoices on the Invoicing tab El project Data 3150634 CG 3150634 T amp E MANAGED B Project Total Order Value CAD 6 397 837 Initial Order Value CAD 6 397 837 For T amp E p Project Sales to Date CAD 739 717 Sales Complete By 2015 11 by period Project Backlog CAD 5 656 120 Sales Recognition Type TRE When the calculatec Last Updated 12 18 2012 By Laird Sandra To create will create delete all the tool tab Create TAE Invoices Invoicing Costing To Date Backlog 2013 03 20 Order Cost Category Value Further details on the invoices generated are included section 4 2 2 on Invoice Forecasting e EMERSON Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 31 of 35 23 Feb 15 4 4 3 Emerson Product Only These projects will ado
47. st updated Organised by project and grouped by Project Manager it provides Product Group code level data showing the date of last forecast current value of EAC forecast and current EAC value in the business system EPT CFR10 Asset Management Inventory This report is a location level report that takes all the forecast data from all the projects in a specific location and produces a phased Inventory forecast per project based on the phased sales data and phased cost data EPT CFR11 Invoicing Status This report lists either all invoices or all invoices approved for issue by project EPT CFR12 Project Forecasted Cost Details This report shows the current forecast cost profile for each project in a location broken down by product group code or division Notes can be displayed when selecting the product group code option EPT AGR7 POR Backlog Phasing This report is functionally the same as CFR7 however the data is for the world area rolled up to the location level within the specified World Area e EMERSON Process Management Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 35 of 35 23 Feb 15 5 2 8 EPT AGR9 Invoice Schedule This report by Location within World Area shows the total values of Order Sales to Date Sales to Date Invoices Issued Receipts to Date Remaining Invoicing and a Total of all Forecasted Invoices The Total Forecasted Invoices are also shown phased by Financial
48. tate End User Customer l Site f Project Mame Eo Project Ib 44101918 For customer projects enter the business system reference EJ Project Type Lump Sum Fixed Price Lump Sum Fixed Price T amp E Managed by Emerson T amp E Managed by Customer ES ndustry Code Emerson Product only Service Maintenance Contracts Active Service General Site Services Non Customer Project DNFL Graphic Migration Typical Phase as per QT Description For Customer projects only the calculation of forecasted sales is dependent on the Contract type Project Type as follows 4 4 1 Lump Sum Fixed Price Projects This type of contract is termed either POC Percentage of Cost or CC Completed Contract The decision is taken once at the start of the project based on the Initial Order Value and the GAAP USD FX rate in effect at that time Once the decision is taken then the project remains in that mode until completion irrespective of the changes in exchange rates or variation orders To be considered as POC in PSG with the exception of RAS a project must have duration of more than 6 months and the Initial Order Value must be over a certain threshold which varies by World Area as shown in the table below EMERSON Emerson Process Management 2015 Confidential and Proprietary all Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 29 of 35 23 Feb 15 World Area Description Method North Ameri
49. ters by clicking on the icon appearing beside these fields and selecting the name location There is an additional section to the right on this page The Did You Know section which provides information about FFT Version 4 the new features added etc The information constantly scrolls by and stops only when user places cursor over it Alternatively user can click on the Gear Icon on right hand upper corner to view all tips Did you Know Accessing the right FFT wersion With the new release of FFT two versions of FFT v 3 7 and v 4 0 will run in parallel in the Toolbox FFT will access the correct version for your project based on your location s Business System setting in Clarity This displays in the General Inquiry gt Location Details portlet in Clarity Currency filter display v3 7 In FFT 3 7 the currency filter will display in the invoicing tab if invoice currency is different fram functional currency When the filter is set to Project it displays the invoice currency values A particular project from the list displayed can be accessed by clicking on the ID or Project Name Column Clarity Project Type displays the Project type assigned to the project in Clarity Column Oracle Project Type is applicable to Oracle Projects and remains blank for JDE projects Clarity Project Type Oracle Project Type UMP SUM FIXED PRICE PERCENT COMPLETE MERSON PRODUCT ONLY UMP SUM FIXED PRICE UMP SUM
50. ther in total or by divisional components the explanation of the sales forecast is beyond the scope of this manual A EMERSON Emerson Process Management 2015 Confidential and Proprietary iia alee Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 30 of 35 23 Feb 15 4 4 2 Emerson Process Management 2015 Confidential and Proprietary Note that in some Locations as determined by a setting against the Location in Clarity only the Daniel PSS and PWS Division s product costs will be treated as POC provided the above criteria is met and all lines associated with other divisions will be treated as CC Therefore some projects will use a mix of CC and POC methods T amp E Projects The sales forecasted in each period on each line will phase the sales backlog in the same proportion that the period by period ETC cost is to the total remaining ETC by product group When there is no ETC value the sales will be assigned as zero In both cases the remaining GP will be apportioned in the same proportion as the sales The sales forecast uses the data in the costing tab and the backlog on the project to determine sales forecast for the product group The backlog is calculated by subtracting the Approved Financial Plan sales from the ITD values by product group for the project Sales forecast is calculated using the same ratio of backlog sales to ETC for that product group in the backlog calculation If the co
51. ual Revision A8 Page 22 of 35 23 Feb 15 Emerson Process Management 2015 Confidential and Proprietary Financial Forecasting El Project Data 31001316 Shell CVP Rigid LUMP SUM FIXED Current Total Revised Cost Budget in Oracle EUR 1 017 212 Current Period 2013 03 The current values in the business system are shown in the Iq S e product group code the last forecast saved in the database ig Current Total EAC in Oracle EUR 967 871 Completion Period 2013 04 hand panel by product group code and future financial period Prior Forecast Total EAC EUR 903 418 Fe Operations column Periods that were saved in the last foreca the past are not shown To create a new forecast select a fo from the dropdown box and enter the values in the second lir Last Updated 12 18 2012 By Laird Sandra the L icon to cancel any changes in the row Use the La ico data on a previously forecasted line Edit all lines and use the the changes The date will refresh on the line and the total va the forecast has not been updated within the current fiscal pe be displayed in red Please make sure that any new EAC s calculated are also ent business system To validate the forecast is ready for future P on the Validate button This will ensure the Invoice Cost and are complete Validation for T amp E projects is done on the Invoh Invoicing Rem Sales Validate The last validation was performed on 12 18 2012 Current Cost Values in Oracle
52. ut A Ce EMERSON Emerson Process Management 2015 Confidential and Proprietary all Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 19 of 35 23 Feb 15 it is possible to match invoices with different amounts together If more than one invoice was forecast for the issued invoice it will need to be deleted manually Once an invoice Is issued by the business system review the invoices in the invoicing tab and match them to the forecast Invoices CD 4 28 2011 2011 08 l dees 6014900 8 03440 st 280 117 703 65 Net 30 5 28 2011 2011 09 117 703 1 H DD 5 30 2011 2011 09 6014986 BPR 09 03440 st 28 Ox 8 88 Net OM 7 8 2011 2011 10 6015118 Invoice for Jul11 Feb12 BPR 09 03440 dt 280 17 202 02 Net 30 8 7 2011 2011 11 0 00 17 202 02 DD 9 7 2011 2011 12 6018319 p aD N 4 omy is Interum T 20 000 00 CAD Net 012 08 Total USD 1 171 708 74 1 134 508 46 17 200 28 L i L LO f Match Generate Invoice Log Match the invoices by checking the box and clicking on the Match button MCP 4 20 2011 2011 08 6014900 BPR 09 03440 st 280 117 703 65 SO Net 30 5 26 2011 2 14 WE 5 30 2011 2011 09 6014986 BPR 09 03440 st 28 Ox 27 658 88 USD Net 30 6 29 2011 2011 10 659 23 2 2011 OM 7 8 2011 2011 10 6015118 Invoice for Jul11 Feb12 BPR 09 03440 dt 28 O 17 202 02 USD Net 30 8 7 2011 2011 11 0 00 17 202 02 3 30 2012 og 9 7 2011 2011 12 6015319 28 121 30 USO Net 30 10 7 2011 2012 01 28 121 73 0
53. yed above the new forecast being entered The user behaviour now depends on the selected methodology Read from Clarity The tool reads the future time phased cost profile from Clarity as determined by resource assignments on the project This is totalled by period and presented in the row underneath the prior forecast in red text New values for ETC and EAC are calculated and also displayed The user may make edits to the time phased data each time a cell is changed the ETC and EAC in total and by line are updated Read from PMM The tool reads the future time phased cost profile from the Project Materials Management tool as determined by the timing and value of the product and buyout forecasts This is totalled by period and presented in the row underneath the prior forecast in red text New values for ETC and EAC are calculated and also displayed The user may make edits to the time phased data each time a cell is changed the ETC and EAC in total and by line are updated Spread an ETC When selecting this method the system will default with a calculated value by subtracting the Actual cost from the EAC value If the PGC has never been forecast then the ETC value is calculated as the business system EAC less the Actual Cost If the PGC has been forecast previously then the ETC value is calculated as the last saved forecast EAC less Actual Cost The user can override the value manually On confirmation the tool then spreads the va
54. your location s Business System setting in Clarity This displays in the General Inquiry gt Location Details portlet in Clarity Active Yes D Currency filter display v3 7 In FFT 3 7 the currency filter will display in the invoicing tab if invoice e e currency is different from functional currency When the filter is set to Filter My Projects Clear Project it displays the invoice currency values All Projects ID Project Name Project Manager Clarity Project Type Oracle Project Type 31001319 Vopak Terminal Westpoort Amsterdam Closed van Gulick Peter LUMP SUM FIXED PRICE PERCENT COMPLETE 3101757 Barking Power Trn Droszcz Andrzej EMERSON PRODUCT ONLY 3104127 MX 3104127 COBRA TERMINAL ATOTONILCO POC TO CLOSE Rangel Silvia LUMP SUM FIXED PRICE 3106145 AO US 3106145 Duke Eneray Schools Todd LUMP SUM FIXED PRICE LLLP FIXED PRICE Use the filters to type in the Project Name or the Project ID These fields will also accept partial start values For example type in 310 in the Project ID field and hit enter click the Filter button The result will filter to show all project IDs beginning with 310 The Project Name filter works in a similar way User can also search based on EMERSON Emerson Process Management 2015 Confidential and Proprietary deet o ale Clarity Toolbox Financial Forecasting User Manual Revision A8 Page 10 of 35 23 Feb 15 Hi Project Manager or Project Financial Location fil
Download Pdf Manuals
Related Search