Shipping and Handling Analysis Report

How to print: Use the Shipping and Handling Analysis Report (PSHI) menu option.

CWDirect Rel 2.0 Shipping and Handling Analysis ELISE_K OER0962 4/09/97 16:16:15 Page 1

Ship Via : 1 Large Thumb Inc.

Invoice Order Merchandise S&H |------------ Shipping $ --------------| |---- Handling $ ----| Additional Total

Number Number Total Charged From Table Allocated Actual Variance Table Actual Variance Charges Variance

------ ------- --------- -------- --------- --------- ------- -------- ------- -------- -------- -------- --------

1918 104 10000.00 10.00 250.00 10.00 143.00 133.00- 133.00-

1919 1136 60.00 12.00 9.00 9.00 7.50 1.50 3.00 3.00 1.50

1920 1138 90.00 10.00 10.00 10.00 5.00 5.00 5.00

1921 1139 60.00 6.00 9.00 6.00 5.00 1.00 4.00 5.00

1922 1700 33.90 11.25 4.25 4.25 9.00 4.75- 4.00 .75-

Tot Ship Via: 1 10243.90 49.25 13.00 39.25 169.50 130.25- 3.00 3.00 8.00 122.25-

Ship Via : 2 East Coast Shippers, Inc.

Invoice Order Merchandise S&H |------------ Shipping $ -------------| |---- Handling $ -----| Additional Total

Number Number Total Charged From Table Allocated Actual Variance Table Actual Variance Charges Variance

------ ------- --------- -------- --------- --------- ------- -------- ------- -------- -------- -------- --------

1929 2085 200.00 6.00 12.00 6.00 11.00 5.00- 6.00 6.00 5.00

1930 2403 15.00 3.00 3.95 3.00 2.00 1.00 1.00

1931 2429 30.00 3.95 3.50 3.50- 3.50-

1932 2430 29.95 3.95 3.00 3.00- 3.00-

1933 2439 31.00 7.95 3.95 3.95 2.00 1.95 4.00 5.95

1934 2442 95.00 16.00 10.00 10.00 6.00 4.00 6.00 6.00 2.00 6.00

1935 2456 19.95 3.95 3.95 3.95 3.00 .95 .95

1936 2458 200.00 9.95 6.95 6.95 1.50 4.45 3.00 3.00 7.45

Tot Ship Via: 2 620.90 46.85 48.70 33.85 32.00 .85 12.00 15.00 3.00 11.00 14.85

Grand Total : 10864.80 96.10 61.70 73.10 201.50 129.40- 15.00 18.00 3.00 19.00 107.40-

Contents:

• ship via code: this is the ship via code from the order line if it differs from the ship via on the order header

• ship via description

• invoice number (Note: This report does not include customer returns)

• order number

The following fields are totaled for each ship via or ship via combination (if more than one ship via was used on the order); grand totals appear at the end of the report.

• merchandise total

• shipping and handling charged: the total including freight, handling, and additional freight

• shipping dollar total from table: the total amount of freight only that would be charged using standard freight calculation. This total is prorated for partial shipments.

• allocated shipping dollar total: the dollar total of the shipping and handling charges allocated to shipping to determine profitability. The lesser of the shipping and handling charged or the shipping dollar total from table is used.

• actual shipping dollar total: the actual meter charge from the manifest station. Unless you use an Actual freight method, any pick slips you confirm through Manual Confirmation will distort the results of this report, since freight charges from these pick slips will not be included.

• dollar total. In cases where the meter charge exceeded the allocated amount, the variance is expressed as a negative number.

• handling dollar total from table: the special handling charge specified in the Item Offer file.

• handling actual dollar total: this amount is calculated by subtracting the shipping dollar total from the shipping and handling charged.

• handling variance: this amount is calculated by subtracting the handling dollar total from table from the handling actual dollar total.

• additional charges: the total or net additional charges on the order. Only additional charges assigned to the Additional Charge Group Code for Shipping and Handling Analysis Report (E54) system control value are included. If the invoice represents a partial shipment, the additional charges are included only if this was the first shipment on the order.

• total variance: this amount is calculated by adding the shipping variance, the handling variance, and the additional charges.

CS06_01r CWDirect 18.0 August 2015 OTN