Operational Procedures:  Sales Analysis

DAILY

         8.12.1  SALES ANALYSIS - REVENUE HISTORY ROUTINE
                 - UPDATE FILE

MONTHLY

NOTE: Reports may be printed at any time through out the month, however, these reports are required at the end of the month for accurate sales information before files are cleared.

*** DO NOT UPDATE (8.10.1, 8.10.2 and 8.17) UNTIL the following reports have been printed at Month End. Month End is determined by printing and updating Freight Bill Sales Registers and Cartage Sheet Sales Registers for the current month, but before the next month Freight Bill Sales Register and Cartage Sheet Sales Register is printed and updated.

        8.4.3    SALES ANALYSIS - CUSTOMER SALES REPORT
                 - PRINT FULL REPORT

        8.5      SALES ANALYSIS - INTERLINE SALES REPORT
        8.6      SALES ANALYSIS - CARTAGE AGENT SALES REPORT
        8.7.3    SALES ANALYSIS - CUSTOMER SALES ANALYSIS
                 REPORT - PRINT FULL REPORT

        8.8      SALES ANALYSIS - INTERLINE SALES ANALYSIS
                 REPORT

        8.9      SALES ANALYSIS -CARTAGE AGENT SALES ANALYSIS
                 REPORT

        8.12.2   SALES ANALYSIS - REVENUE HISTORY ROUTINE
                 - PRINT REPORT
        8.13     SALES ANALYSIS - DESCENDING YTD SALES REPORT
        8.14     SALES ANALYSIS - NEW CUSTOMER SALES REPORT
        8.15     SALES ANALYSIS - INACTIVE CUSTOMER SALES
                 REPORT

NOTE: ALL OF THE ABOVE MONTHLY REPORTS SHOULD BE
COMPLETED BEFORE  DOING THE FOLLOWING UPDATE.

        
        8.17     SALES ANALYSIS - MONTH END SALES UPDATE

AS REQUIRED

        8.1      SALES ANALYSIS - CUSTOMER SALES INQUIRY
        8.2      SALES ANALYSIS - INTERLINE SALES INQUIRY
        8.3      SALES ANALYSIS - CARTAGE AGENT SALES INQUIRY
        8.4.1    SALES ANALYSIS - CUSTOMER SALES REPORT
                 - PRINT IN CUSTOMER NAME RANGE

        8.4.2    SALES ANALYSIS - CUSTOMER SALES REPORT
                 - PRINT IN CUSTOMER CODE RANGE

        8.7.1    SALES ANALYSIS - CUSTOMER SALES ANALYSIS
                 REPORT - PRINT IN CUSTOMER NAME RANGE

        8.7.2    SALES ANALYSIS - CUSTOMER SALES ANALYSIS
                 - PRINT IN CUSTOMER CODE RANGE

        8.11     SALES ANALYSIS - CUSTOMER LIST BY CITY/STATE
        8.12.3   SALES ANALYSIS - REVENUE HISTORY ROUTINE
                 - GRAPHIC DISPLAY

        8.16     SALES ANALYSIS - INTERLINE SETTLEMENT REPORT
        8.18.1   SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - CUSTOMER INBOUND HISTORY FILE

        8.18.2   SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - CUSTOMER OUTBOUND HISTORY FILE

        8.18.3   SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - INTERLINE INBOUND HISTORY FILE

        8.18.4   SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - INTERLINE OUTBOUND HISTORY FILE

        8.18.5   SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - CARTAGE AGENT INBOUND HISTORY FILE

        8.18.6   SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - CARTAGE AGENT OUTBOUND HISTORY FILE

        8.18.8   SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - BILL TO HISTORY FILE

        8.18.9   SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - SHIPPER HISTORY FILE

        8.18.10  SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - CONSIGNEE HISTORY FILE

        8.18.11  SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - BILL TO ZIP HISTORY FILE

        8.18.12  SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - SHIPPER ZIP HISTORY FILE

        8.18.13  SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - CONSIGNEE ZIP HISTORY FILE

        8.18.14  SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - REGION MASTER FILE

        8.18.15  SALES ANALYSIS -SALES SYSTEM FILE MAINTENANCE
                 - ZIPS IN REGION FILE

        8.19.1   SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO SALES HISTORY INQUIRY

        8.19.2.1 SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO SALES REPORT - PRINT FULL REPORT

        8.19.2.2 SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO SALES REPORT
                 - PRINT BILL TO NAME RANGE

        8.19.2.3 SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO SALES REPORT
                 - PRINT BILL TO CODE RANGE

        8.19.3.1 SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO SALES ANALYSIS REPORT
                 - PRINT FULL ANALYSIS REPORT

        8.19.3.2 SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO SALES ANALYSIS REPORT
                 - PRINT IN BILL TO NAME RANGE

        8.19.3.3 SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO SALES ANALYSIS REPORT
                 - PRINT IN BILL TO CODE RANGE

        8.19.4   SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO DESCENDING REVENUE REPORT

        8.19 5   SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO ACTIVE SALES REPORT

        8.19.6   SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - BILL TO ADDED SALES REPORT

        8.19.7   SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - SHIPPER SALES HISTORY INQUIRY

        8.19.8.1 SALES ANALYSIS - DETAIL SALES ANALYSIS
                 - SHIPPER SALES REPORT -PRINT FULL REPORT

AS REQUIRED (continued)

        8.19.8.2   SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - SHIPPER SALES REPORT
                   - PRINT IN SHIPPER NAME RANGE

        8.19.8.3   SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - SHIPPER SALES REPORT
                   - PRINT IN SHIPPER CODE RANGE

        8.19.9.1   SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - SHIPPER SALES ANALYSIS REPORT
                   - PRINT FULL ANALYSIS REPORT

        8.19.9.2   SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - SHIPPER SALES ANALYSIS REPORT
                   - PRINT IN SHIPPER NAME RANGE

        8.19.9.3   SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - SHIPPER SALES ANALYSIS REPORT
                   - PRINT IN SHIPPER CODE RANGE

        8.19.10    SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - SHIPPER DESCENDING REVENUE REPORT

        8.19.11    SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - SHIPPER INACTIVE SALES REPORT

        8.19.12    SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - SHIPPER ADDED SALES REPORT

        8.19.13    SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE SALES HISTORY INQUIRY

        8.19.14.1  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE SALES REPORT -PRINT FULL REPORT

        8.19.14.2  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE SALES REPORT
                   - PRINT IN CONSIGNEE NAME RANGE

        8.19.14.3  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE SALES REPORT
                   - PRINT IN CONSIGNEE CODE RANGE

        8.19.15.1  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE ANALYSIS REPORT
                   - PRINT FULL ANALYSIS REPORT

        8.19.15.2  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE SALES ANALYSIS
                   - PRINT IN CONSIGNEE NAME RANGE

        8.19.15.3  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE SALES ANALYSIS
                   - PRINT IN CONSIGNEE CODE RANGE

        8.19.16    SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE DESCENDING REVENUE REPORT

        8.19.17    SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE INACTIVE SALES REPORT

        8.19.18    SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - CONSIGNEE ADDED SALES REPORT

        8.19.19.1  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA SALES HISTORY INQUIRY
                   - USE BILL TO DATA

        8.19.19.2  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA SALES HISTORY INQUIRY
                   - USE SHIPPER DATA

        8.19.19.3  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA SALES HISTORY INQUIRY
                   - USE CONSIGNEE DATA

        8.19.20.1  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA SALES REPORT - USE BILL TO DATA

        8.19.20.2  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA SALES REPORT - USE SHIPPER DATA

        8.19.20.3  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA SALES REPORT - USE CONSIGNEE DATA

        8.19.21.1  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA SALES ANALYSIS REPORT
                   - USE BILL TO DATA

        8.19.21.2  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA SALES ANALYSIS REPORT
                   - USE SHIPPER DATA

        8.19.21.3  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA SALES ANALYSIS REPORT
                   - USE CONSIGNEE DATA

        8.19.22.1  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA DESCENDING REVENUE REPORT
                   - USE BILL TO DATA

        8.19.22.2  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA DESCENDING REVENUE REPORT
                   - USE SHIPPER DATA

        8.19.22.3  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA DESCENDING REVENUE REPORT
                   - USE CONSIGNEE DATA

        8.19.23.1  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA INACTIVE SALES REPORT
                   - USE BILL TO DATA

        8.19.23.2  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA INACTIVE SALES REPORT
                   - USE SHIPPER DATA

        8.19.23.3  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA INACTIVE SALES REPORT
                   - USE CONSIGNEE DATA

        8.19.24.1  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA ADDED SALES REPORT -USE BILL TO DATA

        8.19.24.2  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA ADDED SALES REPORT -USE SHIPPER DATA

        8.19.24.3  SALES ANALYSIS - DETAIL SALES ANALYSIS
                   - AREA ADDED SALES REPORT
                   - USE CONSIGNEE DATA

YEAR END UPDATE
NOTE: ALL MONTH END UPDATES AND REPORTS SHOULD BE COMPLETED BEFORE YEAR END UPDATES !!!

        12.7.8.1   SPECIAL REPORTS -YEAR END UPDATE SELECTOR
                   - SALES ANALYSIS
                   - CLEAR YEAR TO DATE SALES HISTORY

        12.7.8.2   SPECIAL REPORTS -YEAR END UPDATE SELECTOR
                   - SALES ANALYSIS
                   - CLEAR YEAR TO DATE REVENUE HISTORY