B-11.2 Completing the PIR Worksheet

Header Section

The following information will automatically populate from information entered on PIR Data Entry Page: name of the losing facility, PIR type, and type of distribution consolidated.

PIR Worksheet Columns

Refer to the columns for the losing facility in the approved AMP Transportation - HCR.

1. Route Numbers: Use data from corresponding column in AMP Transportation - HCR.

2. Annual Mileage Pre AMP: Data comes from column labeled “Current Annual Mileage” in AMP Transportation - HCR.

3. Annual Mileage Proposed: Data comes from column labeled “Proposed Annual Mileage” in AMP Transportation - HCR.

4. Annual Mileage PIR: Enter the current mileage for the contract from the HCR data file.

5. Annual Cost Pre AMP: Data comes from column labeled “Current Annual Cost” in AMP Transportation - HCR.

6. Annual Cost Proposed: Data comes from column labeled “Proposed Annual Cost” in AMP Transportation - HCR.

7. Annual Cost PIR: Enter the current estimated annual cost from the HCR data file.

8. Annual Cost/Mile Pre AMP: Data comes from column labeled “Current Cost per Mile” in AMP Transportation - HCR.

9. Annual Cost/Mile Proposed: Data comes from column labeled “Proposed Cost per Mile” in AMP Transportation - HCR.

10. Annual Cost/Mile PIR: Formula calculates the annual cost/mile based on current mileage and cost.

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

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

Exhibit B-11 

Transportation - HCR-Losing Facility

Exhibit B-11, Transportation - HCR-Losing Facility