B-7.2 Completing the PIR Worksheet

Header Section

  • Losing Facility: Name will populate from information entered on the PIR Data Entry Page.
  • PIR Type: This will populate based on information entered on the PIR Data Entry Page. The data for the First PIR reflects six months of data that is annualized.
  • Type of Distribution Consolidated: Field is populated from information entered on the PIR Data Entry Page.
  • Date Range of Data: This will populate based on information entered on the PIR Data Entry Page.
  • PIR Workhour Rate by LDC: This field is populated based on the date range of data and EDW LURS.

PIR Worksheet Columns

“Pre AMP” corresponds to “Current” columns in the approved AMP proposal.

“Proposed” corresponds to “Proposed” columns in the approved AMP proposal.

“PIR” columns are annualized in the First PIR and represent actual data from the most recently completed two (for First PIR) or four (for Final PIR) quarters after the implementation date.

1. Operation Numbers: The column contains operation numbers with volume and/or workhours that were affected or removed from the losing facility. (data source: AMP Workhour Costs - Current)

2. Annual FHP Volume Pre AMP: Data comes from column labeled “Current Annual FHP Volume” for the losing facility in AMP Workhour Costs - Current.

3. Annual FHP Volume Proposed: Data comes from column labeled “Proposed Annual FHP Volume” for the losing facility in AMP Workhour Costs - Proposed.

4. Annual FHP Volume PIR: Column includes current annual first handling pieces (FHP) volume by operation (data source: EDW MODS).

5. Annual TPH or NATPH Volume Pre AMP: Data comes from column labeled “Current Annual TPH or NATPH Volume” for the losing facility in AMP Workhour Costs - Current.

6. Annual TPH or NATPH Volumes Proposed: Data comes from column labeled “Proposed Annual TPH or NATPH Volume” for the losing facility in AMP Workhour Costs - Proposed.

7. Annual TPH or NATPH Volume PIR: Column includes current annual TPH or NATPH volume by operation. (data source: EDW MODS)

8. Annual Workhours Pre AMP: Data comes from column labeled “Current Annual Workhours” for the losing facility in AMP Workhour Costs - Current.

9. Annual Workhours Proposed: Data comes from column labeled “Proposed Annual Workhours” for the losing facility in AMP Workhour Costs - Proposed.

10. Annual Workhours PIR: Column includes current total workhours by operation. The data is annualized for the First PIR (data source: EDW MODS).

11. Annual Productivity Pre AMP: Data comes from column labeled “Current Productivity TPH or NATPH” for the losing facility in AMP Workhour Costs - Current.

12. Annual Productivity Proposed: Data comes from column labeled “Proposed Productivity TPH or NATPH” for the losing facility in AMP Workhour Costs - Proposed.

13. Annual Productivity PIR: Data is calculated based on volume and workhours.

14. Annual Workhour Costs Pre AMP: Data comes from column labeled “Current Annual Workhour Costs” for the losing facility in AMP Workhour Costs - Current.

15. Annual Workhour Costs Proposed: Data comes from column labeled “Proposed Annual Workhour Costs” for the losing facility in AMP Workhour Costs - Proposed.

16. Annual Workhour Costs PIR: This column is populated based on workhours and current local workhour rates by LDC.

Change Analysis

The change analysis provides variances for volumes, workhours, productivities, and workhour costs. The columns labeled “PIR vs Pre AMP” reflects differences between current data in the PIR from the current data in the approved AMP proposal. The columns labeled “PIR vs Proposed” contain the variances between current data in the PIR and “Proposed” figures from the approved AMP proposal.

Exhibit B-7 

Workhour Costs - Losing Facility

Exhibit B-7, Workhour Costs - Losing Facility