back to top

RPMES MANUAL
OF OPERATION

PROJECT
MONITORING
REPORTS

PROCEDURES FOR COMPUTING ACCOMPLISHMENTS

   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 (%).

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

Expenditure 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 (%).

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

   Physical Accomplishment

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 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 

          OVERALL WEIGHTED PERFORMANCE =         B         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 difference between actual and scheduled accomplishment
A = overall weighted project target in percent
B = overall weighted project accomplishment in percent 

   PHYSICAL ACCOMPLISHMENT OF AGENCY

1. Identify all on-going projects of the agency and their costs.

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

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

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 

          OVERALL WEIGHTED PERFORMANCE =         BT         x 100 = (percent)
                                                                                           AT  

          OVERALL PROJECT SLIPPAGE = BT - AT = (percent)

    Where:

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

   PHYSICAL ACCOMPLISHMENT OF AREA COVERED

1. Identify the agencies implementing projects in the region, province, city or municipality and compute for the total cost of all projects scheduled for implementation during the year per agency.

2. Compute for relative weight of each agency to total cost (area) by taking the ratio of total cost of each agency's projects to total cost of all projects in the area.

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

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

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

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

Mathematical Format for Area Accomplishment 

          OVERALL WEIGHTED PERFORMANCE =         BT         x 100 = (percent)
                                                                                           AT  

          OVERALL PROJECT SLIPPAGE = BT - AT = (percent)

    Where:

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

   SAMPLE CASE FOR COMPUTING PERFORMANCE AND SLIPPAGE

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

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

3. Compute for the weighted project performance

OVERALL WEIGHTED ACTUAL ACCOMPLISHMENT = 46.40%
OVERALL PROJECT SLIPPAGE = 46.40% - 64.80% = (18.40%)