Menu

11.0 Procedures for Computing Accomplishments

11.1 FINANCIAL ACCOMPLISHMENT

Funding Support (%)

1. Get the sum of releases
2. Compute for the total programmed amount
3. Divide total releases by total programmed amount and multiply by 100 to get financial support (%)

Total Releases
Financial Support (%) = ——————————————- x 100
Total Programmed Amount

Expenditures Rate (%)

1. Get the sum of expenditures by adding unpaid obligation and cash disbursement
2. Compute for the total programmed amount
3. Divide total expenditures by total programmed amount and multiply by 100 to get expenditure rate (%)

Total Expenditures
Expenditure Rate (%) = ————————————— x 100
Total Programmed Amount

11.2 PHYSICAL ACCOMPLISHMENT OF PROJECT

1. Identify the components of the project and its costs
2. Compute for the relative weight of each component by taking the ratio of the cost of each component to the total project cost
3. Compute for the cumulative percent accomplishment (target and actual) of each component by taking the ratios of the target and actual accomplishment to the total component target
4. Multiply the percent accomplishment by the relative weight of the project component to get the weighted accomplishment of each component.
5. Add up the weighted accomplishment of each project component to get the overall weighted project accomplishments.
6. Subtract target accomplishment from actual accomplishment to get project component slippage.

MATHEMATICAL FORMAT FOR COMPUTING PROJECT
ACCOMPLISHMENT:

ProjectComponent(1) Cost(2) RelativeWeight(3) Accomplishment (%) Weighted Slippage(8)=(5)-(4)
Target(4) Actual(5) Target(6) Actual(7)
PC1 c1 c1w1 = — ct t1 a1 w1 x t1 w1 x a1 S1
PC2 c2 c2w2 = — ct t2 a2 w2 x t2 w2 x a2 S2
· · · · · · · ·
· · · · · · · ·
· · · · · · · ·
PCn cn cnwn = — ct tn An wn x tn wn x an Sn

N n n n n
å ci = ct å ci/ct = å wi =1.0 å wi x ti = A å wi x ai = B
i=1 i=1 i=1 i =1 i =1

B
OVERALL WEIGHTED PERFORMANCE = —- X 100 = (percent)
A

OVERALL PROJECT SLIPPAGE = B – A = (percent)

Where:
i = 1,2,3,….n (as component of project)
t = target in terms of equivalent percent for each component of project
a = actual accomplishment in equivalent percent for each component of project
w = relative weight of a component to total project based on cost
c = cost of each component
s = slippage or difference between actual and scheduled accomplishment
A = overall weighted project target in percent
B = overall weighted project accomplishment in percent

11.3 PHYSICAL ACCOMPLISHMENT OF AGENCY

1. Identify all ongoing projects of the agency and their costs.

2. Compute for the relative weight of each project by taking the ratio of the cost f each project to the total cost of all projects of the agency scheduled for the year.

3. Compute for the cumulative percent accomplishment (target and actual) of each project by taking the ratios of the target and actual accomplishment to the total project target.

4. Multiply the percent accomplishment by the relative weight of the project to get the weighted accomplishment of each project.

5. Add up the weighted accomplishment of each project to get the overall weighted agency accomplishments.

6. Subtract target accomplishment from actual accomplishment to get project slippage.

MATHEMATICAL FORMAT FOR AGENCY ACCOMPLISHMENT

Agency(1) Cost(2) RelativeWeight(3) Accomplishment (%) Weighted Slippage(8)=(5)-(4)
Target(4) Actual(5) Target(6) Actual(7)
AGENCY1 C1 W1 T1 A1 W1 x T1 W1 x A1 S1
AGENCY2 C2 W2 T2 A2 W2 x T2 W2 x A2 S2
· · · · · · · ·
· · · · · · · ·
· · · · · · · ·
AGENCYn Cn Wn Tn An Wn x Tn Wn x An Sn
CT WT AT BT

n n n n
å Ci = Ct å Wi = WT = 1.0 å Wi x Ti = AT å Wi x Ai = BT
i=1 i=1 i =1 i =1

BT
OVERALL WEIGHTED PERFORMANCE = —- X 100 = (percent)
AT

OVERALL AREA SLIPPAGE = BT – AT = (percent)

Where:
i = 1,2,3,….n (as component of project)
C = cost of agency projects
W = relative weight of agency project to total area based on cost
T = target of agency in percent
A = actual accomplishment of agency in percent
S = slippage of agency or difference between actual and scheduled
AT = overall weighted area target in percent
BT = overall weighted area accomplishment in percent

11.5 A SAMPLE CASE FOR COMPUTING PERFORMANCE AND SLIPPAGE

1. Compute for the relative weight of each project component/project/ agency:

Component Cost Relative
Project/Agency (in P000) Weight

A 500 500/1000 = 0.5
B 300 300/1000 = 0.3
C 200 200/1000 = 0.2
—– ———————
TOTAL 1000 1.0

2. Compute for the percent accomplishment (performance) as of reporting period:

Component/Project OverallTarget(whole yr) Accomplishment Percent Accomplishment
Schedule Actual Schedule Actual
A 6 km. 3 km. 2 km. 3/6×100=50% 2/6×100=33%
B 3 km. 2 km. 1 km. 66% 33%
C 1 ha. 1 ha. 1 km. 100% 100%

3. Compute for the weighted project performance:

Component/Project Weight Percent Accomplishment Weighted Accomplishment
Schedule Actual Schedule Actual
A 0.5 50 33 50(.5)=25.0 33(.5)=16.5
B 0.3 66 33 66(.3)=19.8 33(.3)=9.9
C 0.2 100 100 100(.2)=20.0 100(.2)=20.0
TOTAL 1.0 64.8% 46.4%

OVERALL WEIGHTED ACTUAL ACCOMPLISHMENT = 46.4%
OVERALL PROJECT SLIPPAGE = 46.4 – 64.8 = -18.4%