Shipment Summary Report

Purpose: This report shows you the number and percentage of orders with single and multiple shipments during a particular date range (during the offer). This information helps you identify where you are losing money on multiple shipments, which may indicate a problem forecasting demand for items advertised in an offer.

For example, if you ship 92 pick slips in week 1, 73.01% of the orders have had just one shipment. The calculation is:

92 / (92 + 12 + 18 + 1 + 1 + 0 + 2)

 

Note: This report presents totals for all orders with shipments in the selected period, regardless of status. Of the 92 orders for which you made single shipments in the sample report, an unknown percentage may still be open due to backorders.

How to print: Enter Y in the Shipment Summary Report field on the Submit Fill Rate Reports Screen.

CWDirect Rel 1.2 Shipment Summary Report LEE_H FRR0002 3/08/96 14:06:11 Page 1 Mail Order Company Offer: Date Range: 1/01/95 - 3/08/96 1 % 2 % 3 % 4 % 5 % 6 % 7+ % Total ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ Shipments: 92 73.01 12 9.52 18 14.28 1 .79 1 .79 0 .00 2 1.58 126

Contents:

• Date range: The dates you want to review for backorder/fulfillment status. This date range is associated with the effective dates for the offer, as defined in the Offer date range fields in the Offer file. Only offers effective during this date range are included on these reports.

• Offer: The code for the catalog, space or television advertisement you want to report on. The report reflects the backorder/fulfillment status for this offer only. Offer codes are defined in and validated against the Offer file.

• Shipments: The number and percentage of shipments on orders during the specified date range. This report provides totals for orders that have generated one shipment, plus orders that have required 2, 3, 4, 5, 6, 7 or more shipments. Multiple shipments indicates that the order contained items that were not in stock and had to be backordered.

Note: If you pre-bill items: Pre-billing an item increments the total number of shipments. As a result, an order that includes a single item that you pre-bill and ship updates the totals on this report as a two-shipment order. See Pre Billed Amount Item (J72) for a discussion.