B-15.2 Completing the PIR Worksheet

Header Section

The name of the losing and gaining facilities, the PIR type and the date range of data will populate from the information recorded on the PIR Data Entry Page.

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 quarters and correspond to the dates reflected in the date range of data.

Column instructions are the same for both the losing and gaining facilities. Columns 1 through 5 apply to losing facility. Columns 6 through 10 apply to gaining facility.

1. Pre-AMP Costs: Data comes from column labeled “Current Cost” in AMP Maintenance.

2. Proposed Costs: Data comes from column labeled “Proposed Cost” in AMP Maintenance.

3. PIR Costs: Data for the identified LDC workhour activity will come from the PIR electronic spreadsheet tab titled “Losing LURS Summary”. Data for parts and supplies comes from the financial performance reports in the Accounting Data Mart (ADM). Data for the First PIR is annualized.

4. Variance PIR to Pre AMP: Formula calculates the difference between the PIR and Pre AMP costs.

5. Variance PIR to Proposed: Formula calculates the difference between the PIR and Proposed costs.

Data for columns 6 through 10 are developed using the same column instructions for columns 1 through 5.