Sample Cover Letter and Summary Report

Click here for the associated Excel attachment
Dear Customer,

The table below is a brief summary of your shipping activity for September. The attached spreadsheet has 6 tabs. Each tab has detailed information about the type of package or problem indicated by the tab name. Refunds totaling $89.45 have been credited by UPS to your account.

In addition you incurred $16.00 in address correction charges and $41.24 in charges for oversize, overweight or incorrect packaging . You also paid a $51.03 premium to ship packages by air when they would have arrived the same day (perhaps not at the same time of day) if shipped by ground.

Not all of these charges are avoidable, but some are. It is most likely worthwhile to look at the details and see if your processes could be improved.

Our fee for September is $44.73. It will appear on your credit card as Shipper's Advocate, Inc.

We appreciate your business,
Douglas S. Carnes
Shipper's Advocate, Inc.
609-792-6397


Your Company

Summary Report for UPS Performance for Packages with Ship Dates

Starting on: 8/22/2009 Ending on: 9/12/2009
As Reported on: 11/18/2009


Package Status
Number of Packages
% of Pkgs
Total Shipping Charges
% of Shipping Charges
Total Packages this Period
908
100.0
$7,392.12
100.0
Late Package Refunds
7
0.8
$40.22
0.5
Manifested but not Shipped Refunds
6
0.7
$49.23
0.7
Non Refundable Late Packages
33
3.6
$262.75
3.6

Manageable Accessorial Fees
Address Corrections
2
0.2
$16.00
0.2
Oversize, Dimensional Weight, Incorrect Packaging
10
1.1
$41.24
0.6