Analyzing Strategic Freight Usage

As you work to continually evaluate your freight costs, use the Freight Recovery Analysis Report to evaluate your company's freight charges and the gap between what you are charging and what you are shipping for no charge.

Analyze the freight recovery rate performance using the following views. Each view contains sales information from the date range you selected when you built the analysis file.

• Overall Summary - Use this view to compare strategic freight as a whole by branch. This is the default view.

• Customer - Use this view to compare strategic freight usage by customer.

• Ship Via - Use this view to compare strategic freight usage by shipping method, such as Our Truck or UPS.

Depending on the view you select, specific columns display with information for that view. For example, if you select the Overall view, the data in each column is for all transactions at a branch for the dates you selected when you build the analysis file. If you change the view to Customer, the data in each column is for all transactions for each customer, and the view contains a customer ID and customer name. Use the different views to refine what you see to better analyze the benefits you are receiving from using strategic freight on your orders.

If you are using Eterm, the analysis displays as a report viewable in your Hold file. You can download the report from their to use in a different program, if necessary.

To analyze strategic freight:

1. Build the analysis file, if necessary.

2. From the Files > Price Maintenance > Strategic Pricing > Strategic Pricing Analysis menu, select Freight Analysis to display the Strategic Pricing Freight Analysis screen.

3. Enter the information you want to include in your analysis.

   Field	Description
   Br/Tr/All	Select the branch or territory for which you want to analyze freight usage. To enter multiple branches or territories, press F10 and select Multiple Branches. To include all your branches and territories in the analysis, type All.
   Report View	Select the view that you want to include in the report. The view determines which data within the analysis displays. For a description of each view and what it displays, see the explanations above. To change the view at any time, select a new view in this field and regenerate the report.

4. Set options, if needed, and generate the report.

5. If you selected to include cost and profit information, select whether to include the generic cost, COGS, or none and press Enter.

See Also:

Strategic Pricing Analysis Tools Overview