AC165 - Percent Complete Calculation
**Form Purpose
Run Percent Complete Calculation (AC165) to calculate percentage complete for
activity groups, activities, and account categories. You can measure activity
progress by calculating the percentage of budget completed to date. Using
AC65.1 (Activity Percentage of Completion), you can store the percentage of
completion and revise it when actual conditions deviate from the plan.
Revising the percentage of completion also revises the completion amount, or
cost to complete. Information entered in this form is used by AC170 (Revenue
Calculation) to determine the revenue amount for the Percent Complete revenue
method.
You can also use this form to calculate gross margin for AC170 (Revenue
Calculation) if the revenue parameters on AC14.1 (Activity Revenue) indicate
revenue calculation method B. In the Activity field, you can enter either a
summary-level activity or a posting-level activity. Summary level activities
use consolidated actual amounts and budgets. Enter the budget number you want
to use for the calculation. If you leave the Budget Number field blank, the
active budget defaults for posting-level activities.
Use the Edit Revenue Definition flag to determine how to calculate percentage
of completion.
**Processing Effect
No means do not use the revenue parameters. Calculate percent complete as an
informational measurement of activity progress. When running this program to
measure activity progress, enter a posting-level activity. The program
calculates percent complete based on the total budgeted amount for the
activity compared to actual costs to date.
Yes means use the revenue parameters established in AC14.1 (Activity
Revenue). Calculate percent complete or gross margin to be used for revenue
calculation. When running this program to calculate activity percentage of
completion or gross margin, enter the activity for which the revenue
parameters were established. This program uses the revenue parameters
established in AC14.1 to determine which method to use for the calculation:
percent complete, gross margin, segment, non-segment, account category group
or total costs.
Percent complete is calculated as follows:
Percent Complete = Cost to Date / Life to Date Budget
Gross Margin is calculated as follows:
Gross Margin = Gross Profit / Contract Amount
The program stores this percentage to use with AC170 (Revenue Calculation).
Updated Files
ACPERCCMPL - This is the primary file maintained by this program. Maintains
percent complete records by activity.
ACPERCMPLX - This is the primary file maintained by this program. Maintains
percent complete records by account category.
CKPOINT - Used for restart capability.
MXLISTHDR - Updates the Last Build Time and Last Build Date fields on this
file.
MXLISTMBR - Updates the new activities included in the list.
Referenced Files
ACACCTCAT - References this file to validate the account category.
ACACCTCATX - References this file to validate that the account category is
assigned to the activity group or activity.
ACACTGRP - References this file to validate the activity group.
ACACTIVITY - References this file to validate the activity.
ACACTMXVAL - References this file to validate activity attributes and
values.
ACAMCODE - References this file to validate the activity asset.
ACASSIGN - References this file to validate resources assigned to an
activity.
ACBUDDTL - References this file to retrieve annual budget and future
years budget balances for activity budgets.
ACBUDHDR - References this file to retrieve the total budget balance for
the activity budget.
ACCATGRP -
ACCATGRPX -
ACCOLGRP -
ACCOLGRPX -
ACCONSOL - References this file to retrieve year-to-date budget and
actual amounts and calculate life-to-date budget and actual
amounts for summary-level activities in activity group
currency.
ACCONSOLX - References this file to retrieve period-to-date budget and
actual amounts for summary-level activities in activity group
currency.
ACLEVEL - References this file to determine if the activity is summary
level or posting.
ACMASTER - References this file to retrieve year-to-date actual amounts
and calculate life-to-date actual amounts for posting-level
activities in activity group currency.
ACMASTERX - References this file to retrieve period-to-date actual amounts
for posting-level activities in activity group currency.
ACSTATUS - References this file to validate the processing status for the
activity.
MXCATDEF - This file is used by a common routine that is used by this
program.
MXELEMENT - This file is used by a common routine that is used by this
program.
MXLISTDTL - References this file to validate list parameters.
MXOBJCAT - This file is used by a common routine that is used by this
program.
WFSETUP -
INVOKED Programs
ACCL
ACSR
|
