Offer Projection Summary Report (OPSR)

How to print: Use the Print Offer Projection Summary (OPSR) menu option.

CWDirect Offer Projection Summary

Mail Order Company

Offer 1 OFFER INITIALIZED

- - - - - - - - - P R O J E C T E D - - - - - - - - - - - - - - - - - - - - A C T U A L - - - - - - - - - - - - - - - -

Start End External Internal TOTALS External Internal TOTALS Curve % Curve % %Act Cum%

Date Date Orders Dollars Orders Dollars Orders Dollars Orders Dollars Orders Dollars Orders Dollars $ Proj $ Act Proj A/P

1/17/94 1/23/94 0 .00 0 .00 0 .00 3 7200.00 3 4800.00 6 2400.00 .00 18.58 .00 9.60

2/14/94 2/20/94 0 .00 0 .00 0 .00 1 166.00 1 .00 2 166.00 .00 1.28 .00 10.26

2/28/94 3/06/94 0 .00 0 .00 0 .00 15 4976.85 0 .00 15 4976.85 .00 38.54 .00 30.17

3/07/94 3/13/94 0 .00 0 .00 0 .00 7 2669.00 2 132.00 9 2357.00 .00 19.64 .00 40.31

3/14/94 3/20/94 0 .00 62 3125.00 62 3125.00 0 .00 0 .00 0 .00 12.50 .00 .00 40.31

3/21/94 3/27/94 0 .00 62 3125.00 62 3125.00 0 .00 0 .00 0 .00 12.50 .00 .00 40.31

4/18/94 4/24/94 37 1875.00 0 .00 37 1875.00 0 .00 0 .00 0 .00 7.50 .00 .00 51.46

4/25/94 5/01/94 55 2750.00 0 .00 55 2750.00 0 .00 0 .00 0 .00 11.00 .00 .00 51.46

5/02/94 5/08/94 62 3125.00 0 .00 62 3125.00 0 .00 0 .00 0 .00 12.50 .00 .00 51.46

5/09/94 5/15/94 65 3250.00 0 .00 65 3250.00 0 .00 0 .00 0 .00 13.00 .00 .00 51.46

5/16/94 5/22/94 0 .00 0 .00 0 .00 5 30.00 0 .00 5 30.00 .00 .23 .00 51.58

5/23/94 5/29/94 0 .00 0 .00 0 .00 0 .00 0 .00 0 .00 .00 .00 .00 51.58

5/30/94 6/05/94 0 .00 0 .00 0 .00 0 .00 0 .00 0 .00 .00 .00 .00 51.58

6/06/94 6/12/94 0 .00 0 .00 0 .00 0 .00 0 .00 0 .00 .00 .00 .00 51.58

6/11/94 6/10/94 0 .00 0 .00 0 .00 3 12.00 0 .00 3 12.00 .00 .09 .00 51.63

6/13/94 6/19/94 0 .00 0 .00 0 .00 0 .00 0 .00 0 .00 .00 .00 .00 51.63

Final totals: 249 12500.00 248 12500.00 497 25000.00 44 17843.55 6 4932.00 50 12911.55 100.00 100.00 51.64

Contents:

• Offer code

• Offer description

• Start date: the first day of the forecasting week

• End date: the last day of the forecasting week

• Projected orders forecasting order category #1: the number of orders projected in the forecast for order category #1

• Projected dollars forecasting order category #1: the dollar amount projected in the forecast for order category #1

• Projected orders forecasting order category #2: the number of orders projected in the forecast for order category #2

• Projected dollars forecasting order category #2: the dollar amount projected in the forecast for order category #2

• Projected order totals forecasting order category #1 and #2: the number of orders for both order categories, as projected in the forecast

• Projected dollar totals forecasting order category #1 and #2: the dollars for both order categories, as projected in the forecast

• Actual orders forecasting order category #1: the actual number of orders received for this order category

• Actual dollars forecasting order category #1: the actual dollars received for this order category

• Actual orders forecasting order category #2: the actual number of orders received for this order category

• Actual dollars forecasting order category #2: the actual dollars received for this order category

• Actual order totals forecasting order category #1 and #2: the cumulative number of orders received for both order categories

• Actual dollar totals forecasting order category #1 and #2: the cumulative dollars actually received on orders for both order categories

• Curve percent $ projected: the projected percentage complete in dollars for this week of the forecast

• Curve percent dollars actual: the actual percentage complete in dollars for this week of the forecast, as calculated by the system

• Percent actual projected: the actual percent complete in dollars divided by the projected percent complete dollars

• Cumulative percentage actual vs. projected: the cumulative percent complete of the forecast

• Final totals

MK03_08r CWDirect 18.0 August 2015 OTN