{"id":866,"date":"2023-08-31T10:11:46","date_gmt":"2023-08-31T10:11:46","guid":{"rendered":"https:\/\/www.projectpro365.com\/user-guide\/?p=866"},"modified":"2025-04-14T08:00:00","modified_gmt":"2025-04-14T08:00:00","slug":"job-forecast-worksheet","status":"publish","type":"post","link":"https:\/\/www.projectpro365.com\/user-guide\/standard\/projectpro-basic\/job-forecast-worksheet\/","title":{"rendered":"Ch 11 – Project Forecast Worksheet"},"content":{"rendered":"

job_forecast_worksheet-01<\/p>\n

Contents<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
INTRODUCTION<\/a><\/td>\n<\/tr>\n
PROJECTS SETUP<\/a><\/td>\n<\/tr>\n
PROJECT FORECAST WORKSHEET<\/a><\/td>\n<\/tr>\n
1. Statistics<\/a><\/td>\n<\/tr>\n
2. PM Statistics<\/a><\/td>\n<\/tr>\n
3. Print<\/a><\/td>\n<\/tr>\n
4. Project Summary Details<\/a><\/td>\n<\/tr>\n
5. Project Profit Analysis Report<\/a><\/td>\n<\/tr>\n
6. Percentage of Completion<\/a><\/td>\n<\/tr>\n
ESTIMATED COST TO COMPLETE AND NEW TOTAL PERCENT COMPLETE<\/a><\/td>\n<\/tr>\n
BATCH POSTING FOR PROJECT FORECAST WORKSHEET<\/a><\/td>\n<\/tr>\n
PROJECT FORECAST DELETION BATCH<\/a><\/td>\n<\/tr>\n
FORECASTED COMPLETED COST OVERRIDE<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

INTRODUCTION<\/b> <\/p>\n

Forecast Worksheet \u2013 It is the area in your Project that you can enter Estimated Costs to Complete on Task-by-Task basis. This projects what the “Expected Cost at Completion” will be as compared to the initial Estimate when you started the projects. Some tasks you may anticipate more costs than expected while other tasks you expect less costs therefore a cost savings. The overall “Estimated Cost at Completion” becomes the value that we divide the “Actual Costs to Date” for given month end to determine “Percentage of Completion” to be applied to your contract value for what Project Revenue has been earned.<\/p>\n

Estimated Cost to Complete is a detailed analysis of the current, in-progress projects status of an ongoing construction project, combined with a detailed evaluation of the remaining work and budget to complete it. Usually at the Project Task Code Level.<\/p>\n

PROJECTS SETUP<\/b> <\/p>\n

On the Projects Setup, under the tab \u201cProject Forecast Worksheet\u201d there are setups related to Project Forecast Worksheet.<\/p>\n

\"null\"<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
FIELDS<\/strong><\/td>\nDESCRIPTION<\/strong><\/td>\n<\/tr>\n
GBPG for Sub-Level Project Forecast<\/strong><\/td>\nThis field is recommended to be left blank. Only enter a General Business Posting Group (GBPG) if you wish to require all Sub-Level Projects to have this GBPG code to be included during Project Forecasting.<\/td>\n<\/tr>\n
Allow Posting Date on JFW As of Date Filter<\/strong><\/td>\nf a date is entered, this date becomes the only “As of Date” for the Project Forecast Worksheet. This will require the Construction Manager to change the date before the next Forecast period. Typically, this is a monthly process. If left blank, there’s no restriction for the PM Forecasting date.<\/td>\n<\/tr>\n
Forecast Amount Rounding<\/strong><\/td>\nThis allows you to identify to what decimal you would like forecasts rounded to. ProjectPro suggests 0.01 as the setting.<\/td>\n<\/tr>\n
Required GM% Var. for JFW Comments<\/strong><\/td>\nEnter the GM% that will trigger a notification that a comment must be entered to explain the variance in month-to-month GM%<\/td>\n<\/tr>\n
Use Contract Forecast Date<\/strong><\/td>\nSpecifies if you want to use the \u201cContract Forecast Date\u201d available on the projects planning lines, as a date filter for Project Forecasting. When disabled, the standard \u201cPlanning Date\u201d from the projects planning lines is applied. This Contract Forecast Date features become more valuable when you are making additional forecast changed directly in the Master Project\u2019s planning lines. Becomes more important as to what date changes to forecast where made.<\/td>\n<\/tr>\n
Forecast By Task Total<\/strong><\/td>\nThe user can prepare Project Forecast by using summarized Project Task Type ‘End-Total’ instead of Forecasting by each individual Project Task lines that is ‘Posting’.<\/td>\n<\/tr>\n
Budgeted Cost on Projection<\/strong><\/td>\nEnabling this Boolean will check the Project Planning Lines with Line Type not equal to Billable and picks the Total Cost LCY on Projections fast tab into the field Budget Total Cost under Actual column on Project Card.<\/td>\n<\/tr>\n
Force Forecast Lines to be Completed<\/strong><\/td>\nSpecify if you want to force the forecast worksheet to be set as \u201cCompleted\u201d. This feature is used only when an upgrade\/implementation is performed along with the import of historical data and there is a case where the Percentage Complete exceeds 100%. If this Boolean is true during the import, the system will auto-set those forecast lines to \u201cCompleted\u201d.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

PROJECT FORECAST WORKSHEET<\/b> <\/p>\n

To generate the forecast, open the Project card then click on Process \u00e0 Project Forecast Worksheet<\/p>\n

\"null\"<\/p>\n

On the Project Forecast Worksheet page, enter the date on field \u201cAs of Date Filter\u201d. The system will display the tasks present on the Project card with the calculations as per the date entered in the field \u201cAs of Date Filter\u201d.<\/p>\n

\"null\"<\/p>\n

The fields on the header of the Project Forecast Worksheet with their description are mentioned below:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
FIELDS<\/strong><\/td>\nDESCRIPTION<\/strong><\/td>\n<\/tr>\n
Project No.<\/strong><\/td>\nThis field shows the Project no. for which the forecast is generated<\/td>\n<\/tr>\n
Manager<\/strong><\/td>\nThe available filter can be used to generate values according to the Manager<\/td>\n<\/tr>\n
As of Date Filter<\/strong><\/td>\nEnter the date till which the forecast values need to be calculated<\/td>\n<\/tr>\n
Next Bill Date<\/strong><\/td>\nThe value on this field is auto generated<\/td>\n<\/tr>\n
View Open Task only<\/strong><\/td>\nOn checking this as True, all the tasks which do not have a budget cost and no estimated cost to complete will be filtered out<\/td>\n<\/tr>\n
Project Description<\/strong><\/td>\nThe Project description mentioned on the Project card will flow on this field<\/td>\n<\/tr>\n
Task Manager Name<\/strong><\/td>\nThis is the Manager Name<\/td>\n<\/tr>\n
Hide 100% Completed Tasks<\/strong><\/td>\nThe tasks which are marked as “Completed” will be filtered out from the Project Forecast Worksheet<\/td>\n<\/tr>\n
Set Task to Completed<\/strong><\/td>\nSetting enabled this field to make all the \u201cProject Task\u201d to completed and will freeze the values on \u201cProject Forecast lines<\/td>\n<\/tr>\n

\"null\"<\/p>\n

Each column of the Project Forecast Worksheet is explained below:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
FIELDS<\/strong><\/td>\nDESCRIPTION<\/strong><\/td>\n<\/tr>\n
Budgeted Costs<\/strong><\/td>\nBudgeted Total Cost for a Task from planning lines (any line type)<\/td>\n<\/tr>\n
Total Costs Used<\/strong><\/td>\nTotal Usage posted to project ledger (Actual Usage Cost)<\/td>\n<\/tr>\n
Budget Remaining<\/strong><\/td>\n(Budgeted Costs – Total Costs Used)<\/td>\n<\/tr>\n
Budget Percentage Used<\/strong><\/td>\n(Total Cost Used \/ Budgeted Cost) *100<\/td>\n<\/tr>\n
New Status Date<\/strong><\/td>\nAs of Date Filter (when new total percent complete is entered)<\/td>\n<\/tr>\n
New Total Units Complete<\/strong><\/td>\nManual entry (when no actual work units are posted but no. of units complete for a task is entered)<\/td>\n<\/tr>\n
New Total Percent Complete<\/strong><\/td>\nManual Entry (when no actual cost is used but project percent completion is entered)<\/td>\n<\/tr>\n
Estimated Cost to Complete<\/strong><\/td>\nIf Previous Status Date = 0D => Budgeted Cost – Total Costs Used If above value is negative then, it is set to 0<\/td>\n<\/tr>\n
Forecasted Completed Cost<\/strong><\/td>\nTotal Cost Used + Estimated Cost to Complete<\/td>\n<\/tr>\n
Hours To Finish<\/strong><\/td>\nBudgeted Resource Quantity from JPL<\/td>\n<\/tr>\n
Forecasted Variance<\/strong><\/td>\n(Budgeted Cost – Forecasted Completed Cost)<\/td>\n<\/tr>\n
Po Expected Receipt Cost<\/strong><\/td>\nThe value of Expected Receipt of items within the “As of Date” of the forecast<\/td>\n<\/tr>\n
Outstanding Orders<\/strong><\/td>\nOutstanding Pos (Open Purchase Orders line items)<\/td>\n<\/tr>\n
Amt. Rcd. Not Invoiced<\/strong><\/td>\nPOs that have been received but not yet invoiced<\/td>\n<\/tr>\n
Budgeted Hours<\/strong><\/td>\nTotal Quantities for a Task from budget planning lines for Resources with UOM as HOURS\/HR<\/td>\n<\/tr>\n
Actual Hours<\/strong><\/td>\nTotal Usage Quantities posted to project ledger for Resources with UOM as HOURS\/HR<\/td>\n<\/tr>\n
Remaining Hours<\/strong><\/td>\n(Budgeted Hours – Actual Hours)<\/td>\n<\/tr>\n
Budgeted Hours Percent Complete<\/strong><\/td>\n(Actual Hours \/ Budgeted Hours) *100<\/td>\n<\/tr>\n
Labor Rate<\/strong><\/td>\nAuto updated from “Labor Rate by Task” List<\/td>\n<\/tr>\n
Work Units<\/strong><\/td>\nwork unit defined on the task line (Work units come from the planning line)<\/td>\n<\/tr>\n
Work Unit of Measure<\/strong><\/td>\nWork unit of measure selected on the task line. (UOM selected from the planning lines)<\/td>\n<\/tr>\n
Previous Status Date<\/strong><\/td>\nPrevious posting date of forecast worksheet<\/td>\n<\/tr>\n
Previous Units Complete<\/strong><\/td>\nPrevious units posted to worksheet<\/td>\n<\/tr>\n
Previous Percent Complete<\/strong><\/td>\nPrevious task total percent posted to worksheet<\/td>\n<\/tr>\n
Previous Forecasted Completed Cost<\/strong><\/td>\nPrevious forecasted completed cost posted to worksheet<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Note1: The \u201cBudget Remaining\u201d will have equal value on field \u201cEstimated Cost to Complete\u201d when the Project Forecast is generated for the first time. When the forecast is generated for the second time the user will have to manually enter the Estimated Cost to Complete for each task.<\/p>\n

Note 2: If the Budget Remaining is supposed to be equal to Estimated Cost to Complete for all the tasks, then we can run the batch \u201cUpdate Estimated Cost to Complete\u201d. In the below tab we can see the calculations for the whole project.<\/p>\n

\"null\"<\/p>\n

1. Statistics<\/b> <\/p>\n

Clicking on the \u201cStatistics\u201d button we can see the overview of the whole project based on the \u201cAs of Date Filter\u201d. <\/p>\n

\"null\"<\/p>\n

\"null\"<\/p>\n

2. PM Statistics<\/b> <\/p>\n

On the Project Forecast Worksheet page click on \u201cPM Statistics\u201d <\/p>\n

\"null\"<\/p>\n

\"null\"<\/p>\n

3. Print<\/b> <\/p>\n

On clicking on Print, it will give provide a preview of overall project calculation that will be recorded when we click on Post. Click on three dots and then click on \u201cPrint\u201d. A new window will open, click on \u201cPreview & Close\u201d. <\/p>\n

\"null\"<\/p>\n

\"null\"<\/p>\n

After checking all the details, we can post the forecast. To post the forecast click \u201cPost\u201d as per the below screenshot. <\/p>\n

\"null\"<\/p>\n

After posting the forecast the values will flow in the other reports like Project Summary Details, Project Profit Analysis Report and Percentage of Completion. <\/p>\n

4. Project Summary Details<\/b> <\/p>\n

After posting the forecast, the details can be viewed on the \u201cProject Summary Details\u201d page. <\/p>\n

To view the report, click on \u201cProject Summary Details\u201d as per the screenshot mentioned below: <\/p>\n

\"null\"<\/p>\n

Project Summary Details page will open.<\/p>\n

\"null\"<\/p>\n

Calculation for Project Summary Details are mentioned below: <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
FIELDS<\/strong><\/td>\nDESCRIPTION<\/strong><\/td>\n<\/tr>\n
Posting Date <\/strong><\/td>\nThe As on date on which the Project Forecast is posted <\/td>\n<\/tr>\n
Total Forecasted Completed Cost <\/strong><\/td>\nTotal of Forecasted Completed Cost (JFW) (Actual cost + Estimated cost to complete) (Of all the tasks) <\/td>\n<\/tr>\n
Total Budgeted Costs <\/strong><\/td>\nTotal of Budgeted Costs <\/td>\n<\/tr>\n
Total Forecasted Variance <\/strong><\/td>\nTotal Budgeted Cost – Total Forecasted Completed Cost <\/td>\n<\/tr>\n
Total Contract Revenue <\/strong><\/td>\nTotal Billable Price <\/td>\n<\/tr>\n
Total Cost to Date <\/strong><\/td>\nTotal Costs Used <\/td>\n<\/tr>\n
Total Budget Remaining <\/strong><\/td>\nTotal Budgeted Cost – Total Cost to Date<\/td>\n<\/tr>\n
Forecasted Cost Remaining <\/strong><\/td>\nTotal of Forecasted Completed Cost – Total Cost to Date <\/td>\n<\/tr>\n
Net Cost Variance <\/strong><\/td>\nTotal Budget Remaining – Forecasted Cost Remaining<\/td>\n<\/tr>\n
Project Percent Complete <\/strong><\/td>\n(Total Cost to Date \/ Total Forecasted Completed Cost) * 100<\/td>\n<\/tr>\n
Revenue Earned <\/strong><\/td>\n(Project Percent Complete * Total Contract Revenue) \/ 100 <\/td>\n<\/tr>\n
Recognized Profit <\/strong><\/td>\nRevenue Earned – Total Cost to Date<\/td>\n<\/tr>\n
Recognized Profit % <\/strong><\/td>\n(Recognized Profit \/ Revenue Earned) *100<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

5. Project Profit Analysis Report<\/b> <\/p>\n

To access the report, click on the three dots then click on \u201cProject Profit Analysis Report\u201d. <\/p>\n

\"null\"<\/p>\n

A new window will open check the field \u201cUse Project Forecast Worksheet\u201d then click on \u201cPreview & Close\u201d. <\/p>\n

\"null\"<\/p>\n

\"null\"<\/p>\n

The field details of Project Profit Analysis Report are mentioned below: <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
FIELDS<\/strong><\/td>\nDESCRIPTION<\/strong><\/td>\n<\/tr>\n
Contract Price <\/strong><\/td>\nBillable (Total Price) <\/td>\n<\/tr>\n
To Date Billings <\/strong><\/td>\nTotal Billable (Invoiced Price) <\/td>\n<\/tr>\n
To Date Costs <\/strong><\/td>\nTotal Costs Used <\/td>\n<\/tr>\n
Total Cost Estimate <\/strong><\/td>\nOn report request page:
\nUse Project Forecast Worksheet = True
\n=>Total Forecasted Completed Cost
\nUse Project Forecast Worksheet = False
\n=> Total Budgeted Cost <\/td>\n<\/tr>\n
Pct Done <\/strong><\/td>\n(To Date Costs\/ Total Forecasted Completed Cost) *100 <\/td>\n<\/tr>\n
Recognized Revenue <\/strong><\/td>\n(Pct Done* Contract Price) \/100 <\/td>\n<\/tr>\n
Recognized Profit (Loss) <\/strong><\/td>\nRecognized Revenue – To Date Cost <\/td>\n<\/tr>\n
Change % In Completion <\/strong><\/td>\nDelta of Project % Complete from table <\/td>\n<\/tr>\n
Change In Recognized Profit <\/strong><\/td>\nDelta of Recognized Profit from table <\/td>\n<\/tr>\n
Change In % Of Profit <\/strong><\/td>\nDelta of Recognized Profit % from table <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

6. Percentage of Completion<\/b> <\/p>\n

In the search type \u201cPercentage of Completion\u201d and select the highlighted link as per the below screenshot: <\/p>\n

\"null\"<\/p>\n

A new window will open, under the \u201cOptions\u201d tab enable the Boolean of \u201cUse Project Forecast Worksheet\u201d. Under the Project tab enter the Project no in the \u201cNo.\u201d field. <\/p>\n

\"null\"<\/p>\n

Under the \u201cFilter Total by\u201d tab in the \u201cDate Filter\u201d field enter the date preceded by \u201c..\u201d. After entering all the details click on \u201cPreview\u201d. <\/p>\n

\"null\"<\/p>\n

\"null\"<\/p>\n

The calculation for Percentage of Completion report is mentioned below: <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
FIELDS<\/strong><\/td>\nDESCRIPTION<\/strong><\/td>\n<\/tr>\n
Contract Price <\/strong><\/td>\nBillable (Total Price) <\/td>\n<\/tr>\n
To Date Billings <\/strong><\/td>\nTotal Billable (Invoiced Price) <\/td>\n<\/tr>\n
To Date Costs <\/strong><\/td>\nTotal Costs Used <\/td>\n<\/tr>\n
Total Cost Estimate <\/strong><\/td>\nOn report request page:
\nUse Project Forecast Worksheet = True
\n=>Total Forecasted Completed Cost
\nUse Project Forecast Worksheet = False
\n=> Total Budgeted Cost <\/td>\n<\/tr>\n
Pct Done <\/strong><\/td>\n(To Date Costs\/ Total Forecasted Completed Cost) *100 <\/td>\n<\/tr>\n
Recognized Revenue <\/strong><\/td>\n(Pct Done* Contract Price) \/100 <\/td>\n<\/tr>\n
Recognized Profit (Loss) <\/strong><\/td>\nRecognized Revenue – To Date Cost <\/td>\n<\/tr>\n
Change % In Completion <\/strong><\/td>\nDelta of Project % Complete from table <\/td>\n<\/tr>\n
Change In Recognized Profit <\/strong><\/td>\nDelta of Recognized Profit from table <\/td>\n<\/tr>\n
Change In % Of Profit <\/strong><\/td>\nDelta of Recognized Profit % from table <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

ESTIMATED COST TO COMPLETE AND NEW TOTAL PERCENT COMPLETE<\/b> <\/p>\n

When generating the Project Forecast for the month of February, the user will have to open the Project forecast Worksheet page and enter the date on field \u201cAs of Date Filter\u201d. <\/p>\n

According to PM analysis the value of Concrete task which still needs to be completed for Task \u201c04-22\u201d is $130,000.00 and for Task \u201c06-12\u201d 19% is completed as on July 28th, 2023. <\/p>\n

As per the above-mentioned case the user will have to enter $130,000 on field \u201cEstimated Cost to Complete\u201d for task \u201c04-22\u201d and 19 on field \u201cNew Total Percent Complete\u201d. <\/p>\n

In task 04-22 as per the estimates the Budget Remaining was $175,000 and as per the PM analysis $130,000 would be incurred to complete this task. The user manually entered $175,000 on field \u201cEstimated Cost to Complete\u201d this resulted in a saving of $45,000 which is reflected on field and reduced the \u201cForecasted Completed Cost\u201d from $250,000 to $205,000. As per these changes the system calculated New Total Percent Complete. <\/p>\n

Similarly, when the user enters \u201cNew Total Percent Complete\u201d the system auto calculates New Status date, Estimated Cost to Complete, Forecasted Completed Cost, Forecasted Variance. <\/p>\n

\"null\"<\/p>\n

1) New Status Date: The As of date filter gets updated in this field. <\/p>\n

2) Estimated Cost to Complete- Either the user manually enters it or it gets updated based on a value entered by the user on field “New Total Percent Complete” <\/p>\n

3) Forecasted Completed Cost: Since the Estimated Cost to Complete changes, it has a direct impact on Forecasted Completed Cost <\/p>\n

4) New Total Percent Complete: It gets updated if the user has manually put in percentage or it gets auto updated when user puts a value on field “Estimated Cost to Complete” <\/p>\n

5) Forecasted Variance: This value gets updated when there is a change in Estimated Cost to Complete or a new Total percent is put in by the user. <\/p>\n

Note: When updating a value in \u201cEstimated Cost to Complete\u201d or \u201cNew Total Percent Complete\u201d it is recommended to click on down key or click on another line, so the values are refreshed. Refer the below screenshot for understanding. <\/p>\n

\"null\"<\/p>\n

There is a positive Forecasted Variance of $16,052.32 (A positive Forecasted Revenue signifies a cost saving) which will increase the Recognized Revenue and Recognized Profit. <\/p>\n

Note: When a value is entered on Estimated Cost to Complete or on New Total Percent Complete following fields are also updated after posting the forecast <\/p>\n

1) Previous Status Date <\/p>\n

2) Previous Forecasted Completed Cost <\/p>\n

3) Previous Percent Complete <\/p>\n

The values in the above fields remain unchanged when the forecast is generated for the next period. <\/p>\n

BATCH POSTING FOR PROJECT FORECAST WORKSHEET<\/b> <\/p>\n

In ProjectPro the user can directly post the Project Forecast for a Project. In the search option type \u201cBatch Posting of Project Forecast Worksheets\u201d <\/p>\n

On this window enter the \u201cAs of Date\u201d, \u201cDocument No.\u201d and enable the method in our case we are selecting the default method which is \u201cProject Forecast\u201d. <\/p>\n

Note: If there are multiple methods then user can select them, If all the methods are applicable then user can click on select all. <\/p>\n

\"null\"<\/p>\n

Note 2: In case the user wants to auto-generate the document no. on the Batch posting of Project Forecast Worksheet page the user can check the field of \u201cJFW Batch Document No.\u201d and a number will populate on field \u201cDocument No.\u201d. To use this feature the user needs to enter the No. Series under the Numbering tab on the Project Setup. <\/p>\n

\"null\"<\/p>\n

Under the Project filter, on the \u201cNo.\u201d field the user can enter the Project no. then click on \u201cok\u201d. <\/p>\n

Note: In case if the batch needs to be run for all the projects, then the user can leave the Project No. field as blank. <\/p>\n

\"null\"<\/p>\n

PROJECT FORECAST DELETION BATCH<\/b> <\/p>\n

In case the user wants to delete the Project Forecast posted entries the \u201cProject Forecast Entry Deletion\u201d can be used. To run the batch type Project Forecast Entry Deletion on the search and select the highlighted link. <\/p>\n

\"null\"<\/p>\n

On this page enter Project no. on the \u201cNo.\u201d field. Then click on \u201cOk.\u201d <\/p>\n

\"null\"<\/p>\n

Note 1: The batch will not delete the entries from the \u201cRevenue Recognition\u201d page. <\/p>\n

Note 2: In case Over\/Under Billings are posted it will not be reversed when the forecast entries are deleted. <\/p>\n

FORECASTED COMPLETED COST OVERRIDE<\/b> <\/p>\n

On the Project task page, If the Forecasted Completed cost for a task is fixed the user can enter the Total Cost for a task on field \u201cForecasted Completed Cost Over- ride.\u201d <\/p>\n

In our example mentioned below we have entered a value of $620,000 on field Forecasted Completed Cost Over-ride the total cost $520,000 <\/p>\n

\"null\"<\/p>\n

When the Project Forecast Worksheet is generated the value entered on the Forecast Completed Cost Over-ride on Project task page will flow to the Project Forecast Worksheet.
\nNote 1: The Estimated Cost to Complete will get auto calculated, The value from \u201cTotal Cost used\u201d will be deducted from \u201cForecasted Completed Cost Over-ride\u201d resulting in a value of Estimated Cost to Complete. <\/p>\n

Note 2: The Forecasted Completed Cost will remain Fixed for the task against which there is a value in \u201cForecasted Completed Cost Over-ride\u201d. <\/p>\n

Note 3: The Estimated Cost to Complete will not be revised when the batch of \u201cUpdate Est. cost. To Compl.\u201d Is run. <\/p>\n

Note 4: The Forecasted Completed Cost Over-ride cannot be entered on the task page of Sub-Levels. <\/p>\n

\"null\"<\/p>\n

Update Estimated Cost to Complete Batch <\/p>\n

When the \u201cEstimated Cost to Complete\u201d is not equal to \u201cBudget Remaining\u201d the \u201cUpdate Est. Cost. To Compl.\u201d can be executed used. <\/p>\n

\"null\"<\/p>\n

To run the batch, click on three dots and then click on \u201cUpdate Est. Cost to Complete.\u201d <\/p>\n

\"null\"<\/p>\n

When we click on the option the system will display the message \u201cThe field “Estimated Cost to Complete” becomes the value of “Budget Remaining” for all the open task lines. Would you like to proceed?\u201d click on Yes. <\/p>\n

\"null\"<\/p>\n

The system will equate the Budget Remaining with \u201cEst. Cost to Complete.\u201d <\/p>\n

\"null\"<\/p>\n