|
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.
**Processing Effect
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.
Percent complete is calculated as follows:
Percent Complete = Cost to Date / Life to Date Budget
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.
ACADDLCNTR -
ACAMCODE - References this file to validate the activity asset.
ACASNROLE -
ACASSIGN - References this file to validate resources assigned to an
activity.
ACBILL -
ACBILLX -
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 -
ACCATSUMX -
ACCNTRACT -
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.
ACCTRCATGX -
ACGRPMXVAL -
ACIFACTV -
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.
ACROLE -
ACSTATUS - References this file to validate the processing status for the
activity.
GMAWARD -
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
|