Cash Flow Display Settings

Cost Items and Cost Categories

The Cash Flow Display Settings allow you to control what information displays on the Cash Flow graph. To open the Display Settings click on the Actions > Display Settings icon in the Tools section.

Overview – Cash Flow Display Settings – Cost Items and Cost Categories

Section

Description

1

You can save your display settings for future use.

2

Select how the graph measures the timing of your cash flow. Options include:  Day, Week, Month, Quarter, and Year.

3

Under the Cost Items section, you can select:

  • Total Cost (Forecast):  The total cost of your scheduled cost items, based on when your costs are accrued (when your cost items are scheduled). This is displayed as a dashed line on the graph

  • Total Price (current):  The total revenue of your pay items, based on when the revenue is earned (when your cost items are scheduled). This is displayed as a dashed line on the graph

  • Total Cost (Forecast) – Cash:  The total cost of your scheduled cost items, reflecting the cost timing you specify in the Cash Flow Options. This is displayed as a solid line on the graph

  • Total Price (current) – Cash:  The total revenue of the pay items, reflecting the revenue timing you specify in the Cash Flow Options. This is displayed as a solid line on the graph

  • Cash Flow:  Displays the difference between your Total Cost – Cash and Total Price – Cash values, so you can see if you are making or losing money

  • Finance Cost:  Displays the Cost of Money amount calculated from the settings you specify in the Cash Flow Options

4

You can check the Estimated box for any specific cost categories you need to display.

  • The other check boxes are used for InEight Estimate Performance

Cash Flow Display Set Up

The following steps walk you through setting up your Cash Flow Display Settings.

Step by Step — Cash Flow Display Settings Set Up

  1. In the E101 – Training Job, from the Estimate tab, select Cash Flow from the Schedule section.

  2. On the Actions tab, select Display Settings to open the Display Settings window.

  3. From the Period drop-down list, select Week.

  4. Under the Cost Items section, make sure the following are selected:

    • Total Cost (Forecast)

    • Total Price (Forecast)

    • Total Cost (Forecast) – Cash

    • Total Price (Forecast) – Cash

    • Cash Flow

    • Finance Cost

  5. Under the Cost Categories section, check the Estimated checkbox for the Labor and Owned Equipment categories.

  6. Click OK to close the Display Settings window.

    • Your Total Cost (Forecast) displays as a dashed red line, indicating your accrued costs based on when your cost items are scheduled and the assigned cost curves for each cost item.

    • Your Total Price (current) displays as a dashed green line, indicating the revenue you’ve earned, based on the timing of your pay items

    • Your Total Cost (Forecast) – Cash displays as a solid red line, indicating your costs, based on when your cost items are scheduled and the cost timing defined in Cash Flow Options

    • Your Total Price (current) – Cash displays as a solid green line, indicating your revenue, based on the timing of your pay items and the revenue timing defined in Cash Flow Options

    • Your Cash Flow displays grey bars indicating when your cash flow is negative or positive

    • Your Finance Cost displays as a blue line on the graph

  7. To filter your graph by date range, click on the Start drop-down arrow and select a start date of your date range filter.

  8. Click on the End drop-down arrow and select an end date of your date range filter.

    • Your graph now only includes your cost items that fall within the specified date range

  9. To remove the filter, click in the Start field and press the Backspace key.

  10. Do the same for the End field.

Resource Utilization

You can also use the Cash Flow graph to report on resource utilization. For example, you may want to run a report that displays a work hours curve for a particular labor trade or to see the peak usage times for a particular piece of heavy equipment.

You can run resource utilization graphs based off of any of the following:

  • Resource Type

  • Resource Code

  • Description

  • Organizational Category

  • Tag 1, 2, and 3

  • Quote Group

  • Account Code and Cost Item Account Code

  • Fuel Type

You set up your resource utilization settings from the same Display Settings window you use for setting up Cash Flow, Display Settings in the Tools section of the Actions menu.

Resource Utilization Display Set Up

The following steps walk you through setting up your Cash Flow graph to report on Resource Utilization.

Step by Step — Resource Utilization Display Setup

  1. In the E101 – Training Job, from the Estimate tab, select CashFlow from the Schedule section.

  2. On the Actions tab, select Display Settings to open the Display Settings window.

  3. Make sure the all checkboxes are unchecked under the Cost Items and Cost Categories sections.

  4. Under the Resources section, check the Resource Utilization checkbox.

  5. From the Summarize resources by drop-down list, select Description.

  6. From the resulting list of Values, select Laborer.

  7. Click in the Qty field for the selected value and select a color of your choice.

    • In this case the Qty represents the work hours for your Laborer resource

  8. Click in the Cost field for the selected value and select a different color of your choice.

  9. From the Quantity and Cost drop down lists, you can select how your quantities and costs will display on the graph. In this case select the Quantity to display as a Bar and Cost to display as a Line.

  10. Click OK to close the Display Settings window.

    • The graph now displays the utilization of your Laborer resource, showing the work hours and costs used over time

      The graphs displayed on the Cash Flow form are based on the estimated cost of each cost item and its resource employments (in the case of resource utilization).