Before Coins ERP+ v11.10, the options To Complete or At Completion could be selected in the Enter By field in the JC Input Budget Workbench. This was expanded to include a new % Complete option, which allows users to enter Cost/Hrs/Qty At Completion values from Actual by % Complete.
In addition, you can now apply % Complete to different sources on the Value rows, such as Actual Cost or Budgets (Initial, Current, Approved) according to the Rate Source options on the Cost Code.
Standard Cost Types and Job Cost Code Maintenance
% Complete Option
A Budget Input Enter By option labelled % Complete is available on Job Status screens for Standard Cost Types in Setup > Setup Maintenance > Standard Cost Types > Forecasting tab and for Job Cost Codes in Administration > Job Cost Codes > Cost Code Maintenance option > Forecasting tab. A code P is used for this % Complete option.
The % Complete option is used to recalculate Forecast At Completion (followed by a Forecast To Complete recalculation completing a new set of values on the row).
For Value rows set to % Complete, the percentage entered is applied to different costs (Actual Costs, Current, or Other Budget Cost).
Standard Cost Types Maintenance
Job Cost Code Maintenance
Rate Option
The Rate option is not disabled if the Budget Input Method is set to Value. When the Enter By % Complete option is selected, the Rate becomes available for updating.
Input Budget Workbench
Browse Screen
This section discusses the Input Budget Workbench browse screen found in Job Status > Input > Memos,Budgets,Allowance, as shown in Input Budget Workbench Browse. The browse fields highlighted below can be included on this Workbench and are explained in more detail below.
Input Budget Workbench Browse
The following information applies to the Input Budget Workbench:
The % Complete field is used as the % Complete Cost for the Cost completion percentage.
A Budget % Complete field is used as an input field on rows of all types. The entered percentage is used.
If parameter JC/USECCAC is set to Y, the Estimated Cost At Completion (ECAC) is used in forecasting, and two additional % Complete fields are available for this: CCAC % Complete and ECAC % Complete.
The Enter By filter option now includes a % Complete option.
Browse Action
An Enter % Complete browse action is found on the Input Budget Workbench, as shown below.
When you select a row and click this action, a Budget Input Enter By field for that row is automatically changed to % Complete, as shown in Enter By Field Changed to % Complete.
Enter By Field Changed to % Complete
The following also occurs when using this action:
If Enter % Complete is set on the Value row, the Rate Source is set to Actual Cost.
If Enter At Complete (To Complete) is set on the Value row, the Rate Source is set to blank (None). This is required if the original Enter By was % Complete.
Include Page Section
An Include Page section is used in the Input Budget Workbench column fields. The fields listed below are found on this section.
Section.
Section Description.
Activity.
Activity Description.
Cost Type.
Cost Type Description.
Units.
Open.
Short Desc.
Start Date.
End Date.
Include Page Fields
Enter By % Complete Rows Recalculation
Enter By % Complete Option
If the Enter By % Complete option is set on the Cost Code/Category row, the Budget Input % Complete field is enabled. Depending on how the Budget Input Method is set, the input fields are enabled/disabled, and user input causes the recalculation shown in the table below.
Table 1: Budget Input Field Recalculation
Input Method | Enter By | Enabled Fields | Recalculation |
Value | % Complete | fcPctComp (Forecast Percent Complete) | As specified in Section Browse Screen |
Hours Input | % Complete | Rate, fcPctComp (Forecast Percent Complete) | FHAC = costHrsTD * 100 / fcPctComp Rest as per usual processing |
Qty Input | % Complete | Rate, fcPctComp (Forecast Percent Complete) | FQAC = costQtyTD * 100 / fcPctComp Rest as per usual processing |
Hours Based | % Complete | Rate | As for Hours Based – At Completion |
Qty Based | % Complete | Rate | As for Qty Based – At Completion |
Value Input By % Complete
If a Cost Code is configured for Value Input By % Complete, you can select a Rate Source option. This selected option is used in the recalculation of the Input Budget Workbench row.
Forecast Cost at Completion is calculated as shown in the table below (user input is shown in italics).
Rate Source | Forecast Cost at Completion |
Actual Cost | Total Cost * 100 / %Complete |
Initial Budget* | Total Cost + (100 – %Complete) * Initial Budget Cost TD / 100 |
Current Budget | Total Cost + (100 – %Complete) * Current Budget Cost TD / 100 |
Approved Budget | Total Cost + (100 – %Complete) * Approved Budget Cost TD / 100 |
Forecast At Completion* | Total Cost + (100 – %Complete) * Approved Budget Cost TD / 100 |
*If the Budget is being edited, Actual Cost calculation is used.
The Forecast Cost At Completion is used for calculating Forecast to Complete as follows:
FCTC = FCAC – FC Base
FC Base depends on the Contract forecasting setup:
Cost Based: FC Base = Total Cost TD
Commitment Based = Total Commitment TD
Total Cost is calculated using the JC/PCMMETHOD setting:
COSTACC: Total Cost = Actual Cost + Accruals
Otherwise: Total Cost = Actual Cost
Total Commitment is calculated as follows:
Total Commitment = Actual Cost + Accruals + Remaining Commitments
Hours/Qty Input by % Complete
Hours Input/Qty Input rows use the entered % Complete for recalculating the Forecast At Completion Hrs/Qty (regardless of the Rate Source).
FHAC = Actual Hours * 100% / %Complete
FQAC = Actual Qty * 100% / %Complete
Actual Qty depends on the JC/BUDQTY parameter:
A: Actual Qty
Otherwise: Qty Installed
Hours (Qty) At Completion is then used to calculate Hours (Qty) to Complete:
FHTC = FHAC - Actual Hours
FQTC = FQAC - Actual Qty
The remaining calculations are used as per Enter By At Completion:
FCTC = FHTC * Rate
FCAC = FC Base + FCTC
Hours/Qty Based Rows Set Enter by % Complete
The Hours/Qty Based Rows use a mixed approach: the % Complete input field is disabled, and a Rate is available for the update. Below is an example of an Hours Based row:
New FCTC = FHTC * New Rate
New FCAC = FC Base + New FCTC
% Complete Cost Recalculation
The read-only % Complete Cost field is calculated on all rows as per the % Complete calculation set up in JC Configuration:
% Complete Cost = Total Cost / New FCAC
The recalculated % Complete Cost is repopulated dynamically after the user changes Budget % Complete.
Enter By At/To Complete Rows
After the At/To Complete Value is changed, the Hours or Qty, Budget % Complete, and % Complete Cost fields are recalculated and repopulated.