CHANGING A CPFF REVENUE FORMULA TO AN ETC REVENUE FORMULA

The Cost Plus Fee on Cost or Cost Plus Fee on Hours formulas are transaction-based formulas that store their revenue primarily on the rows in the PROJ_SUM table that have a direct cost account in the ACCT_ID column. Costpoint calculates the revenue for these formulas by adding the direct and indirect costs and a percentage fee or hourly fee. The Estimate to Complete (ETC) or Estimate at Completion (EAC) formulas multiply the project's contract value by a percent-complete percentage. Revenue for these formulas is stored on the cost lines to the extent of costs incurred and the difference is stored on the revenue lines of the PROJ_SUM table (revenue plug).

To change your revenue formula from a "Cost Plus" type formula to a "ETC/EAC" type formula, complete the following steps:

  1. Manually calculate your inception-to-date revenue using the ETC or EAC formula. After changing the revenue formula, you need this amount to determine whether you have the correct revenue. 

  2. Modify the revenue formula. As soon as you enter a new revenue formula, Costpoint displays a message stating that, if you modify the revenue formula, all of the allowable columns for the current fiscal year are deleted. Answer Yes if you are modifying the revenue for the entire fiscal year. If you wish to modify only the revenue amounts for the current period, first change the revenue formula to Do Not Compute and then to the ETC/EC formula

  3. Make any necessary modifications to the ETC amounts in Costpoint Budgeting and ETC. Refer to "Estimate to Complete" for more help in this area.

  4. On the Manage Revenue Information screen, enter the ETC or EAC amount in the field provided.

  5. Recompute the revenue for your project. 

  6. Compare the revenue that Costpoint computed to the revenue that you calculated manually in Step 1.