A-7.2 Completing the AMP Worksheet

Header Section

The following information is populated from the information recorded on the AMP Data Entry Page: name of losing facility, name of gaining facility and date range of data.

In the electronic workbook, the current workhour rate by LDC for both the losing and gaining facilities is populated by data from the Enterprise Data Warehouse (EDW) Labor Utilization Reporting System (LURS). The downloaded data is available in the spreadsheet tab titled “Losing LURS Data” for the losing facility and “Gaining LURS Data” for the gaining facility. The LURS data populating this worksheet is the average of data period shown in the header.

A download of EDW Management Operating Data System (MODS) data for the same data period is available in the spreadsheet tab titled “Losing MODS Data” for the losing facility and “Gaining MODS Data” for the gaining facility. The volume and workhour data from this download are used to populate the fields for both the losing and gaining facilities.

AMP Worksheet Columns

1. Current Operation Numbers: Shows all current operations with volume and workhours. The data come from the electronic spreadsheet tab titled “Losing MODS Summary” which includes all MODS data for the reported data range. The “Losing MODS Summary” tab provides the means to determine the operations that will transfer to the gaining facility and those that will remain.

2. % Moved to Gaining: Shows the percentage of volume and/or workhours that will move to the gaining facility. Data are entered in the “Losing MODS Summary.” In cases where only partial volume or workhours may be transferred, such as allied and support operations, the estimated percentage that will be moved to the gaining facility is entered.

3. Current Annual FHP Volume: This column is populated based on the operation numbers listed in Column 1 and the data downloaded from EDW MODS.

4. Current Annual TPH or NATPH Volumes: This column is populated based on the operation numbers in Column 1 and the data downloaded from EDW MODS.

5. Current Annual Workhours: This column is populated based on the operation numbers in Column 1 and the data downloaded from EDW MODS.

6. Current Productivity (TPH or NATPH): This column is calculated based on volume and workhours.

7. Current Annual Workhour Costs: This column is calculated based on workhours and current local workhour rates by LDC for the losing facility.

8. Current Operation Numbers: This shows all current operations with volume and workhours. The data comes from the spreadsheet tab titled “Gaining MODS Summary” which includes all MODS data for the reported date range.

9. % Moved to Losing: If any operations will transfer to the losing facility, use the “Gaining MODS Summary” tab to enter the percentage of mail that will be moved.

10. Current Annual FHP Volume: This column is populated based on the operation numbers listed in Column 8.

11. Current Annual TPH or NATPH Volumes: This column is populated based on the operation numbers listed in Column 8.

12. Current Annual Workhours: This column is populated based on the operation numbers listed in Column 8.

13. Current Productivity (TPH or NATPH): This column is calculated based on volume and workhours.

14. Current Annual Workhour Costs: This column is calculated based on workhours and current local workhour rates by LDC for the gaining facility.

Column Totals Losing Facility

  • Moved to Gain (Moved to Gaining Facility): Volume and workhours moved from the losing facility to the gaining facility. Note that 100% of volume and workhours are shown on this worksheet. The actual volume and workhours moved is reflected on Workhour Costs Proposed.
  • Impact to Lose (Impacted Operations at Losing Facility): Reflects data for operations that are common to both facilities. The volume and/or workhours for the operations are impacted at the losing facility. The information shown in these columns reflect mail that stays in the losing facility but will be impacted after the consolidation.
  • Total Impact (Total Impacted Operations): Equals sum of operations moved to gaining and those operations that are impacted at the losing facility.
  • Non-impacted: These operations are not impacted by the consolidation.
  • All: Equals sum of total impacted plus non-impacted.

Column Totals Gaining Facility

  • Impact to Gain (Impacted Operations at Gaining Facility): Reflects data for operations that are common to both facilities. The volume and/or workhours for the operations are impacted at the gaining facility. The information shown in these columns reflect mail that stays in the gaining facility but will be impacted after the consolidation.
  • Moved to Lose (Moved to Losing Facility): Volume and workhours moved from the gaining facility to the losing facility. Note that 100% of volume and workhours are shown on this worksheet. The actual volume and workhours moved is reflected on the worksheet for the proposed workhour costs.
  • Total Impact (Total Impacted Operations): Equals sum of operations moved to losing and those operations that are impacted at the gaining facility.
  • Non-impacted: These operations are not impacted by the consolidation.
  • Gain Only: Volume and workhours for operations that only exist at the gaining site and are not impacted by the consolidation.
  • All: Equals sum of total impacted plus non-impacted plus gain only.

Comb Totals (Combined Totals)