Change a CPFF Revenue Formula to an LLR Revenue Formula

Although both the cost-type and loaded-labor type revenue formulas are transaction-based, it is slightly more complicated to change from a cost-type to a loaded-labor type.

The loaded-labor type of revenue formula uses PLCs and their related billing rates as the major component of revenue.

A PLC must be associated with every labor entry in the LAB_HS table for Costpoint to accurately compute revenue. If you plan to recompute revenue for each period of the current fiscal year, remember that PLCs must be in the LAB_HS table for all the labor lines.

If you are making this modification prospectively, you can change the formula first to Do Not Compute and then to the loaded-labor formula. This eliminates the warning about modifying revenue formulas. After you have saved the Do Not Compute formula, modify it again to a loaded-labor type. This method prevents you from having to clear the allowable columns. You probably need an inception-to-date revenue adjustment when using this method. The loaded-labor revenue formulas are period-to-date formulas, so no year-to-date adjustments are shown in the table.

If you are making the modification retroactively, PLCs must be listed on each line of the Labor Summary table for this project. You must clear the allowable columns if you want to modify the revenue for all periods of the fiscal year. You must recalculate revenue for each period of the fiscal year, but you must post only the revenue in the current period. When you use this method, there is no evidence that the previous formula was used.