Working with Projection Curves (WCRV) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Inventory Status Inquiry (ISIQ) |
Purpose: Use the Work with Forecasts function to create and change a forecast. Forecasting allows you to project mail and telephone order response for a specific offer and drop.
In this topic:
• Select Offer/Drop Screen (Creating a Forecast)
• Work with Forecast-Source Category Screen
• Work with Forecast Calculations Screen
Select Offer/Drop Screen (Creating a Forecast)
How to display this screen: Enter WFCS in the Fast Path field at the top of any menu or select the Work With Forecasts option from a menu
Field |
Description |
Select offer |
Enter the code for the catalog, space, or television advertisement from which you accept orders. Offers are defined in and validated against the Offer table; see Working with Offers (WOFR). Alphanumeric, 3 positions; required. |
and drop |
The number assigned to the mailing in which this list was included. Drop codes are assigned to each mailing; some customers may be included in several drops of the same catalog to spread out circulation and encourage purchases. Alphanumeric, 2 positions; required. |
Completing this screen: You advance to the Work with Forecast Screen.
How to display this screen: Enter an offer and drop code on the Select Offer/Drop Screen (Creating a Forecast).
Field |
Description |
Offer |
The code for the catalog, space, or television advertisement from which you accept orders. Offers are defined in and validated against the Offer table. See Working with Offers (WOFR). Alphanumeric, 3 positions; required. |
Drop |
The number assigned to the mailing in which this list was included. Drop codes are assigned to each mailing; some customers may be included in several drops of the same catalog to spread out circulation and encourage purchases. Alphanumeric, 2 positions; required. |
Description |
A description of the forecast. Alphanumeric, 40 positions; required. |
For the following fields, enter curve and forecast information for each of the order categories, or enter combined curve information at the bottom of the screen. The Curve, Percent, Expected Date of 1st Order, Budget and Sales Plan Orders and Dollars fields are only explained once below. |
|
Curve |
The projection curve of response that you anticipate for this order category. Order categories are defined in the System Control table (Forecasting Order Category #1 field). In the screen sample, Phone has been defined as Forecasting Order Category #1 (B94) and Mail has been defined for Forecasting Order Category #2 (B95). Numeric, 3 positions; required if you are not entering combined curve information. |
Percent |
The percentage of response you expect to receive for this order category. The percentages you enter in both Percent fields must equal 100 percent. Numeric, 5 positions with a 2-place decimal; required if you are not entering combined curve information. |
Exp dte of 1st ord (Expected date of 1st order) |
Enter the date you expect to receive the first order from this offer/drop. The expected dates for each order category can differ. The format of this field is MMDDYY. Numeric, 6 positions; required if you are not entering combined curve information. |
Budget |
|
Orders |
Enter the number of orders that have been budgeted for this forecast. Numeric, 7 positions; optional. |
Dollars |
Enter the dollar amount that has been budgeted for this forecast. Numeric, 11 positions with a 2-place decimal; optional. |
Sales Plan |
|
Orders |
Enter the number of orders that are included in the sales plan for this forecast. Numeric, 7 positions; optional. |
Dollars |
Enter the dollar amount that has been included in the sales plan for this forecast. Numeric, 11 positions with a 2-place decimal; optional. |
Combined curve |
Enter the projection curve of response that you anticipate for both order categories. The system assumes a 50 percent response from both order categories. See Working with Projection Curves (WCRV). Numeric, 3 positions; required only if you did not enter a curve for each separate order category. |
Exp dte of 1st ord (Expected date of 1st order) |
Enter the date you expect to receive the first order from this offer/drop for this combined curve. The format of this field is MMDDYY. Numeric, 6 positions; required if you did not enter information for each separate order category. |
Budget |
|
Orders |
Enter the number of orders that have been budgeted for this forecast. Numeric, 7 positions; optional. |
Dollars |
Enter the dollar amount that has been budgeted for this forecast. Numeric, 11 positions with a 2-place decimal; optional. |
Sales Plan |
|
Orders |
Enter the number of orders that are included in the sales plan for this forecast. Numeric, 7 positions; optional. |
Dollars |
Enter the dollar amount that has been included in the sales plan for this forecast. Numeric, 11 positions with a 2-place decimal; optional. |
Instructions:
1. Enter curve and forecast information for each separate order category or enter combined curve information at the bottom of the screen.
2. If you are creating or changing a forecast, you advance to the Work with Forecast-Source Category Screen.
Work with Forecast-Source Category Screen
How to display this screen: Enter curve and forecast information on the Work with Forecast Screen.
Field |
Description |
Opt |
If you are changing forecast information previously entered, use this field if you wish to delete projection data for a source code data. Numeric, 2 positions; optional. |
Cat (Source category) |
The source code category to be included in this projection. Source code categories allow for subtotaling on various forecasting reports. They are assigned in the source code record and are validated against the Source Code Category table. See Working with Source Categories (WSCT). Alphanumeric, 2 positions; required. |
# Pcs mailed |
The number of catalogs or other advertisements expected to be mailed to this source code category. Numeric, 7 positions; required |
Sales/Book |
Enter the expected sales per catalog or advertisement. Divide the total estimated dollars anticipated for this mailing by the number of pieces mailed. Numeric, 3 positions; required. |
Avg $$/Order |
Enter the average dollar amount you expect per order. Numeric, 5 positions; required. |
Override curve |
The projection curve of response that you want to use to override the order category curves or the combined curve. Order categories are defined in the System Control table. You can define an override curve for the two order categories and the combined curve. The percent complete for source code and sales response is calculated according to this override curve. Numeric, 3 positions; optional. |
Sales |
The projected sales for this source category. This number is determined by multiplying the # of pieces mailed by the sales per book. Numeric, 9 positions; display-only. |
Orders |
The projected number of orders for this source category. This number is determined by dividing the projected sales in the Sales field by the amount in the Avg $$/Order field. Numeric, 7 positions; display-only. |
Instructions: Use the following steps to complete this screen.
1. Complete the required fields.
2. If you are creating or changing a forecast, the system updates the Sales and Orders fields based on the information you entered in the # Pcs mailed, Sales/book, and Avg $$/order fields.
3. Select Calculations to calculate the forecast and advance to the Work with Forecast Calculations Screen with information based on your entries. When you select Calculations you receive a system message informing you that the forecast is being calculated.
Work with Forecast Calculations Screen
How to display this screen: Select Calculations to on the Work with Forecast-Source Category Screen.
Field |
Description |
Offer |
The code for the catalog, space, or television advertisement from which you accept orders. Offers are defined in and validated against the Offer table. See Working with Offers (WOFR). Alphanumeric, 3 positions; display-only. |
Drop |
The number assigned to the mailing in which this list was included. Alphanumeric, 2 positions; display-only. |
Total dollars |
The combined sales dollars for the source categories you defined on the Work With Forecast - Source Category field. Numeric, 9 positions; display-only. |
Total orders |
The combined order amounts for the source categories you entered projection data for on the Work with Forecast-Source Category Screen. Numeric, 5 positions; display-only. |
Date |
Displays each date of the forecast based on the number of days (1 or 7) that you have defined for a forecast period and the number of periods you want the system to store data for. Both these values are defined in the System Control table. Numeric, 6 positions; display-only. |
% Comp |
The projection completion percentage you expect for both order category curves or the combined curve. Numeric, 5 positions with a 2-place decimal; display-only. |
Ords |
The number of orders projected for this date based on the percentages you defined for the curve being used for this order category. Numeric, 7 positions; display-only. |
Dollars |
The dollars projected for this date based on the percentages you defined for the curve being used for this order category. Numeric, 9 positions; display-only. |
Screen Option |
Procedure |
Save the forecast |
Select Save to save the forecast you are creating or to save the current version of the forecast if you are changing it. |
Delete the forecast |
Select Reject to delete the forecast if you are creating it, or delete the current version if you are changing it. |
Working with Projection Curves (WCRV) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Inventory Status Inquiry (ISIQ) |
WFCS OROMS 5.0 2018 OTN