Chapter 27: Working with Forecasts (WFCS)
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 chapter:
• 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
FCR0001 ENTER Select Offer/Drop 3/09/94 14:14:16 Company #1
Select Offer ___
and Drop . . __
F3=Exit F12=Cancel |
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 file; see Chapter 2: 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. See Chapter 36: Working with Drops (WHLS). 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).
FCR0026 ENTER Work with Forcast 3/09/94 15:00:18 Mail Order Company
Offer: 1 Drop: 1 Description: __________________________________ Phone Curve: ___ Percent: _____ Expected Date of 1st Order: ______ Budget ...: Orders: ______ Dollars: __________ Sales Plan: Orders: ______ Dollars: __________
Curve: ___ Percent: _____ Expected Date of 1st Order: ______ Budget ...: Orders: ______ Dollars: __________ Sales Plan: Orders: ______ Dollars: __________
- O R -
Combined Curve ___ Expected Date of 1st Order: ______ Budget ...: Orders: _______ Dollars: ________ Sales Plan: Orders: _______ Dollars: ________
F3=Exit F12=Cancel |
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 file. See Chapter 2: 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. See Chapter 36: Working with Drops (WHLS). 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 file (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 Chapter 26: 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. |
Step-by-step 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.
FCR0027 OPEN Work with Forecast-Source Category 3/09/94 16:13:02 Mail Order Company Offer: 1 1 CHILDREN'S WEAR Total Sales 0 Total Orders 0
Type options, press Enter. 4=Delete # Pcs Sales Avg $$ ----- Override Curve ----- Opt Cat Mailed /Book /Order Phone Mail Comb Sales Orders
__ __ _______ ___ _____ ___ ___ ___ 0 0
__ __ _______ ___ _____ ___ ___ ___ 0 0
__ __ _______ ___ _____ ___ ___ ___ 0 0
__ __ _______ ___ _____ ___ ___ ___ 0 0
F8=Calculations F11=Reject |
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 file. See Chapter 5: 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 file. 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. |
Step-by-step 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. Press F8 to calculate the forecast and advance to the Work with Forecast Calculations Screen with information based on your entries. When you press F8 you receive a system message informing you that the forecast is being calculated.
Work with Forecast Calculations Screen
How to display this screen: Press F8 to on the Work with Forecast-Source Category Screen.
FCR0029 DISPLAY Work with Forecast Calculations 4/13/94 10:42:33 Marks Mail Order Offer: 1 Drop: 1 FORECAST #1 Total Dollars: 250,000 Total Orders: 100
Phone Mail COMBINED ---------------------- ---------------------- ---------------------- Date % Comp Ords Dollars % Comp Ords Dollars % Comp Ords Dollars 3/28/94 2.00 1 3125 2.00 1 3125 .00 0 0 4/04/94 6.00 3 9375 2.00 1 3125 .00 0 0 4/11/94 6.00 3 7500 4.00 2 6250 .00 0 0 4/18/94 4.00 2 6250 6.00 3 9375 .00 0 0 4/25/94 4.00 2 6250 6.00 3 9375 .00 0 0 5/02/94 4.00 2 6250 4.00 2 6250 .00 0 0 5/09/94 4.00 2 6250 4.00 2 6250 .00 0 0 5/16/94 4.00 2 5000 4.00 2 6250 .00 0 0 5/23/94 4.00 2 5000 4.00 2 6250 .00 0 0 5/30/94 2.00 1 3750 4.00 2 6250 .00 0 +
F9=Save F11=Reject F12=Cancel |
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 file. See Chapter 2: Working with Offers (WOFR). Alphanumeric, 3 positions; display-only. |
Drop |
The number assigned to the mailing in which this list was included. See Chapter 36: Working with Drops (WHLS). 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 file. 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 |
Press F9 to save the forecast you are creating or to save the current version of the forecast if you are changing it. |
Delete the forecast |
Press F11 to delete the forecast if you are creating it, or delete the current version if you are changing it. |
| Chapter 26: Working with Projection Curves (WCRV) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 28: Inventory Status Inquiry (ISIQ) |
MK03_03 CWDirect 18.0 August 2015 OTN