Job/Project Forecast

This feature enables you to forecast fees and resources (hours) for a period estimated in the Tasks/Stages/Phases screen. When you provide the estimated Start date and End date of a Task, Job Forecast will disperse the estimated fees and hours within the given period on a monthly basis. You can then edit them and forecast the resources in a way that suits your cash flow.  You can even forecast the Subtask resources for each Task.

Creating your Forecast Step 1:

Go to a Job page and open the Tasks/Stages/Phases screen

Specify the start dates and end dates of your Tasks and make sure you have estimated your Fees for each Task. You can include the Disbursement estimate also with the fees here. To forecast Subtasks, make sure you have Subtasks defined under each Task.

001_Tasks.png

Step 2:

Click the Forecast button as shown below and you will be redirected to Forecast Page where you can see three options to base the forecast on.

003_Forecast_Fees

 

Option 1: Forecast based on Fees and Disbursements

This option will disperse the given estimated fees and disbursements for the period of the task. Below you can see the task named Building, which has an estimated Fee of $25,000 in the task page. It is now visible in the cash flow for seven months from Sept to March.

003_Forecast_Fees.png

Option 2: Forecast based on Resources (Hours)

This option relates to forecasting based on the estimated hours. The sample task Building, with 250 hours has been allocated to each month from Sept to March.

004_Forecast_Hours

Option 3: Forecast based on Resources by Sub Task

This option allows you to drill down further into sub-tasks and forecast the estimated hours for employees over the given period.

005_Forecast_Subtasks_02.png

How to: Recreate Forecast for All Tasks

This button will discard all of your changes and allows you to recreate the forecast for all the Tasks based on the selected option.

Recreate Forecast for all tasks

How to: Recreate Forecast for one Task

The button provided on each row of the grid can recreate the forecast for each task.

Recreate Forecast for one Task.png

Exporting the Forecast to CSV

The button below will export the grid to a CSV file which you can open in MS-Excel.

For options 1 and 2 (ie Fees and Disbursements; Resource Requirements), the format of the CSV is a raw file type so that when you open it in MS-Excel, you can further modify the columns and formula.

For option 3, Resources by Sub-Task, the CSV export is based on WYSIWYG format (What You See IS What You Get)  because of the complexity of presenting it in raw format.

Exporting the forecast to CSV.png

Print the Report for Reconciliation

When you edit values, the forecasts are not reconciled with the actual estimated values of the Task. This can be reconciled with this report.

Print the report for reconciliation.png

 

Available reports

The following report are available in the Reports section.

Reports Available.png

Forecast Fees and Disbursements Report

This report will show all the forecasts for Fees and Disbursements for all Jobs. Note that the data will be shown only for the past year based on the date chosen in the Date From option.

Forecast Resource Requirement

This report will show all the forecasts for Resource Requirement for all Jobs. Note that the data will be shown only for the past year based on the date chosen in the Date From option. There is a popup to give an option to show the SubTask forecast if you have defined any.

Forecast Reconciliation Report

This is the same report that you can open from the Forecast Page itself.