Entering Remaining Work Data on a Job Forecast

To enter remaining work data on a job forecast, you must first create a forecast, and then complete the following steps. See Creating Job Forecasts for instructions.

  1. On the Edit Job Forecast form, select the account (row) for which you want to enter remaining work data.

  2. Verify that the value in the MC (Method of Computation) field is Z. If it is not, enter Z in this field.

  3. From the Row menu, select Remaining Work. Note that this option is available only if you select a row with a value of Z in the MC field.

  4. At the bottom of the Remaining Work Forecast form, enter a row for each remaining work item you want to include for the account. To enter remaining work, complete at least two of the following:

    • Cost To Complete Quantity and UM (Unit of Measure) fields

    • Cost To Complete Rate

    • Cost To Complete Amount

    When adding a new line, you can enter any two of the above, and the system will calculate the other. When updating an existing line, if you update the quantity or rate, the system recalculates the amount in the Cost To Complete field. If you update the amount field, the rate is recalculated using the quantity. Entering the units of measure is optional.

    Edit Remaining Work Forecast
  5. As you complete lines in the detail area, the system updates the associated fields in the header area of the form.

  6. To save the data you enter, click OK, or tab to a new line. After each line is saved, the system updates the following fields in the header based on the data you entered:

    • Total Cost To Complete

    • Total Cost At Completion

  7. Optionally, you can update the Total Remaining Work Units field in the header. This field is used to calculate the HU ledger as follows:

    HU = Total Remaining Work Units + AU

  8. Click OK to save all changes. The system returns you to the Edit Job Forecast Details form. You must then click OK on this form to save your changes. If you click Close or Cancel on the Edit Job Forecast Details form, your remaining work updates will not be saved.

Note: If there is only a single line of remaining work to be entered, you can alternatively enter values in the Cost To Complete Rate and Total Work Units columns on the Edit Job Forecast Details form. The system will automatically generate a remaining work record that will be added to the F51F115 table when you click OK.However, if you must enter additional remaining work after entering this data, you must first clear the values you entered in the Cost To Complete Rate and Total Work Units columns and then select the Remaining Work option from the Row menu add multiple lines.