B-10.2 Completing the PIR Worksheet

Header Section

PIR Worksheet Columns

Column instructions are the same for both losing and gaining facilities. Columns 1 through 18 apply to losing facility. Columns 19 through 36 apply to gaining facility. Data for the Pre AMP and Proposed columns is from approved AMP Staffing - PCES/EAS. Data for the PIR columns is from WebCOINS.

1. Position Title: Data comes from WebCOINS and approved AMP Staffing - PCES/EAS.

2. Level: Data comes from WebCOINS and approved AMP Staffing -
PCES/EAS.

3. Authorized Staffing Pre AMP: Data comes from column labeled “Current Auth Staffing” in AMP Staffing - PCES/EAS.

4. Authorized Staffing PIR: Data comes from WebCOINS.

5. On-Rolls Pre AMP: Data comes from column labeled “Current On-Rolls” in AMP Staffing - PCES/EAS.

6. On-Rolls Proposed: Data comes from column labeled “Proposed Staffing” in AMP Staffing - PCES/EAS.

7. On-Rolls PIR: Column reports the data from WebCOINS.

8. Annual Workhours Pre AMP: Data comes from column labeled “Current” Annual Workhours in AMP Staffing - PCES/EAS.

9. Annual Workhours Proposed: Data comes from column labeled “Proposed” Annual Workhours in AMP Staffing - PCES/EAS.

10. Annual Workhours PIR: Column reports the data from WebCOINS. Data is annualized for the First PIR.

11. Workhour Rate: The workhour rate for each position is populated using the Current Fiscal Year National Average Fully Loaded Labor Rate or local rates if available.

12. Annual Costs Pre AMP: Data comes from column labeled “Current” Annual Costs in AMP Staffing - PCES/EAS.

13. Annual Costs Proposed: Data comes from column labeled “Proposed” Annual Costs in AMP Staffing - PCES/EAS.

14. Annual Costs PIR: This formula calculates the costs based on the PIR annual workhours and the workhour rate.

15. Variances Total On-Rolls PIR vs Pre AMP reflects the variance between the current data in the PIR from what was the current data in the approved AMP proposal.

16. Variances Total On-Rolls PIR vs Proposed contains the variance between the current data in the PIR from the “Proposed” figures in the approved AMP proposal.

17. Variances Total Annual Costs PIR vs Pre AMP reflects the variance between the current data in the PIR from what was the current data in the approved AMP proposal.

18. Variances Total Annual Costs PIR vs Proposed contains the variance between the current data in the PIR from the “Proposed” figures in the approved AMP proposal.

Data for the gaining facility in columns 19 through 36 are developed using the corresponding column instructions for columns 1 through 18.