Fill Rate Report

Purpose: This report shows the number and percentage of orders that you have stock for on the first shipment (therefore, shipping the order complete), plus the number and percentage of orders with backordered items.

The column on the left of the report lists up to 8 weeks in the specified date range for the specified offer or all offers effective during these dates.

For example, in week 1, you have the ability to ship 7 orders complete, or 58.33% of all orders to ship in week 1. The calculation is:

7 / (7 + 3 + 2 + 0 + 0)

 

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

CWDirect Rel 1.2 Fill Rate Report LEE_H FRR0001 3/08/96 14:06:11 Page 1 Mail Order Company Date Range: 1/01/95 - 3/08/96 Offer:   INSTOCK RATE: Orders Orders Orders Orders Orders 100% instock 1-2 lines B/O 3-5 lines B/O 6-8 lines 8+ lines B/O # % # % # % # % # % WEEK 1 OF DATE RANGE 7 58.33 3 25.00 2 16.66 0 .00 0 .00 WEEK 2 OF DATE RANGE 40 80.00 7 14.00 3 6.00 0 .00 0 .00 WEEK 3 OF DATE RANGE 21 84.00 4 16.00 0 .00 0 .00 0 .00 WEEK 4 OF DATE RANGE 15 83.33 3 16.66 0 .00 0 .00 0 .00 WEEK 5 OF DATE RANGE 5 71.42 2 28.57 0 .00 0 .00 0 .00 WEEK 6 OF DATE RANGE 10 83.33 2 16.66 0 .00 0 .00 0 .00 WEEK 7+ OF DATE RANGE 550 71.15 201 26.00 11 1.42 4 .51 7 .90 WEEK 7+ OF DATE RANGE 31 60.78 19 37.25 1 1.96 0 .00 0 .00 Totals 679 71.62 241 25.42 17 1.79 4 .42 7 .73

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.

Instock rate:

• Orders 100%: The number and percentage of orders with stock for all items on the first shipment.

• Orders xx: lines backordered. The number and percentage of orders with one or more items were backordered.

• Week x of date range: The fill rate for each week in the offer, indicating how well you forecasted demand for items in the offer.

• Totals: The number and percentage of orders completely in stock or with varying degrees of backordered items.