Creating Cash Flow Curve -- P6 Schedule & Unifier Cost Data

welcome to another tech tip from the Army Nattie and Associates today's tech tip is creating a unified cash flow curve using a p6 duration only schedule and unify Cauchy data I'm just going to move over to p6 there's three things that need to have been set up in order to get the data from p6 to unify firstly we had in administer menu the application settings so that you can create the p6 the unifier Association secondly within the EPS screen and off the Actions menu for the particular p6 schedule in project preferences you would create the link between that schedule and the unifier project lastly you would have the cost code from the unifier cost sheet assigned to all the appropriate activities in the p6 schedule you can see here that we have the CBS column and I had already assigned cost codes to every activity in this example pcs schedule so in order to get the data into unifier you would just simply click the Actions menu go to the import/export menu item and click send to Primavera unifier doing this we're going to get a confirmation confirmation message they'll pop up just confirm that data has been sent across just gonna click OK and now I'm actually going to move over to the unifier environment so this is the unifier project that has been linked to the p6 schedule I'm just going to quickly show you the cost sheet for this project going into the cost manager cost sheet sub node and I'm just going to open up the project cost sheet as you can see when it comes up there is a number of cost codes that have been set up to this cost sheet the two that we will be looking at in particular are the ones with cos theta associated so that's the site design and site excavation cost codes and they have been assigned cost data through the budget approval business process that is one of the out-of-the-box business processes that comes with the cost controls application just going to close this now the other thing I'd like to show you is the the schedule sheet for this unifier project I'm just going to open up the master schedule sheet you can see that it's in bold and you can see the p6 data is now populated with in this unifier schedule sheet and you can see the corresponding p6 CBS is the cost codes so I'm just going to close that down so now we're going to create the cash flow curve so within the cost manager I'm going to go to the cash flow sub node I'm going to click new I'm going to select detail curves this will bring up a another window and the key thing to change here for this particular example is the detail level I'm just going to change that to WBS so this means the grouping is going to be by cost code level I'm just going to add a name and now I'm gonna move to the curves tab so now I'm going to add one of the curves and I'm actually going to use a baseline curve again this is one of the three curves that come with the cost controls application baseline actuals and forecast I'm gonna use the baseline one just going to select it the three areas that we need to set here are the distribution profile the cost data and where the dates are coming from so in the distribution section I'm going to select Auto by default profile per WBS which is the cost codes gonna select the details button I'm now going to use the bulk edit feature to set distribution profiles for all of these cost codes simply select all the rows click bulk edit this comes up with the distribution profiles are available there are four by default I'm going to select the S curve and click select what this will do once this window closes is it automatically populate all the rows all the cost code rows with a default profile being the S curve I'm just going to click Save now we need to select what data the curve is going to use so in this case within the cross section I'm gonna select this will be amount from cost sheet column you probably saw from akashi we only had cos theta that was with the budget approvals business process so that's the only item we're gonna see within the drop-down list so I'm gonna select ma'am within the scheduler section so these are the dates that are going to be used all rather than the date range that the curve is going to use I'm going to select the use date from a schedule sheet I'm gonna click select this will show me all the schedule sheets that are available to be used with this curve I'm going to select the master schedule sheet one that's the one in bold you can see that you can create cash flow curves with non master schedule sheets as well I'm gonna click open and then the from date and two dates I'm just gonna simply select a start date for the from date and finish date for the two dates so what that's going to do is remember this cash flow curve is by cost is that cost code level so for all activities that are grouped by specific cost code is going to look at the earliest start date and the latest finish date and used those dates for the date ranges within the in the curve okay so I'm going to click OK and this will actually bring the curve up and there you can see here is our cash flow curve using the dates from the schedule sheet using the cost data from the budget approvals business process that was in the cost sheet in the bottom pane you've got the overall summary level for the curve I'll double click to bring up the details so this can give you the the details at that the WBS ie the cost code level remember we had the two cost codes that had cost data which was site design and site excavation and their amount which was the 250,000 for each was distributed based on the from and to dates that we had set up for this curve thank you for watching this tech tip on creating a cash flow curve with p6 gyration only schedule and cost sheet data for more tips or information and/or other services please visit dr McNasty comm thank you very much bye-bye

Channel: DRMcNattyAssociates

Views: 8,876

Rating: 4.826087 out of 5

Keywords: Oracle, Cash Flow, P6, Primavera, creating cash flow curve, unifier cost data, p6 schedule and unifier cost data

Id: oBU6Cp4Ipyw

Length: 8min 35sec (515 seconds)

Published: Fri May 16 2014