Purpose: Use this menu option to review a forecast projection for a specified offer and optionally drop.
In this topic:
• Display Forecast by Offer Screen (across drops)
• Display Forecast Screen (by drop)
• Display Actual Data by Day Screen (across drops)
• Display Actual Data By Day Screen (by drop)
• Display Forecast Summary Screen (across drops)
• Display Forecast Summary Screen (by drop)
Use this screen to define the offer and drop whose forecast you wish to review.
You must select an offer and drop combination that exists in the Forecast table, or an error message indicates Forecast not found.
• If you define an offer and no drop, the system advances you to the Display Forecast by Offer Screen (across drops), where you can review forecast projections for the offer across all drops.
• If you define an offer and drop, the system advance you to the Display Forecast Screen (by drop), where you can review forecast projections for the offer and drop.
How to display this screen: Enter DFCS in the Fast path field or select Display Forecast from a menu.
Field |
Description |
Offer |
The offer whose forecast you wish to review. Offer codes 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 whose forecast you wish to review. Alphanumeric, 2 positions; optional. |
Display Forecast by Offer Screen (across drops)
Purpose: Use this screen to review forecast projection information for the specified offer, across all drops defined for the offer.
For each period in the forecast, the system displays:
• the projected:
• number of orders and total order dollars for forecasting order category 1
• the number of orders and total order dollars for forecasting order category 2
• the number of orders and total order dollars across forecasting order categories 1 and 2
• the actual:
• number of orders and total order dollars for forecasting order category 1
• the number of orders and total order dollars for forecasting order category 2
• the number of orders and total order dollars across forecasting order categories 1 and 2
• the difference between the projected number of orders and total order dollars and the actual number of orders and total order dollars
Forecast order category names: The names that display for forecasting order categories 1 and 2 are defined in the following system control values:
• Forecasting Order Category #1 (B94)
• Forecasting Order Category #2 (B95)
How to display this screen: Select OK at the Forecast Inquiry Screen.
Field |
Description |
Offer |
The offer whose forecast information you are reviewing; this is the offer you defined at the Forecast Inquiry Screen. Offer codes are defined in and validated against the Offer table; see Working with Offers (WOFR). Alphanumeric, 3 positions; display-only. |
Period |
The start date and end date of a period in the forecast projection. The days in a forecast period are determined by the # of Days in Forecasting Period (B96) and First Day of a Forecasting Period (B99) system control values. For each forecast period, the system displays: • the projected and actual number of orders for forecast order category 1, forecast order category 2, and combined. • the projected and actual total order dollars for forecast order category 1, forecast order category 2, and combined. • the variance between the projected numbers and dollars and the actual numbers and dollars. Numeric, 6 positions (MM/DD/YY format); display-only. |
Proj ords (forecast order category 1) |
The projected number of orders for forecast order category 1. This is the number of orders defined in the Orders - Category 1 field in the Forecast Detail table. Numeric, 5 positions; display-only. |
Proj $ total (forecast order category 1) |
The projected merchandise order total for forecast order category 1. This is the dollar amount defined in the $ - Category 1 field in the Forecast Detail table. Numeric, 9 positions; display-only. |
Proj ords (forecast order category 2) |
The projected number of orders for forecast order category 2. This is the number of orders defined in the Orders - Category 2 field in the Forecast Detail table. Numeric, 5 positions; display-only. |
Proj $ total (forecast order category 2) |
The projected merchandise order total for forecast order category 2. This is the dollar amount defined in the $ - Category 2 field in the Forecast Detail table. Numeric, 9 positions; display-only. |
Proj ords (combined) |
The total projected number of orders across forecast order categories 1 and 2. This is the number of orders defined in the Orders - Combined field in the Forecast Detail table. Numeric, 5 positions; display-only. |
Proj $ total (combined) |
The total projected merchandise order total across forecast order categories 1 and 2. This is the dollar amount defined in the $ - Combined field in the Forecast Detail table. Numeric, 9 positions; display-only. |
Act ords (forecast order category 1) |
The actual number of orders for forecast order category 1. This is the number of orders defined in the # orders/cat 1 field in the Offer/Drop/Period/Day table. Numeric, 5 positions; display-only. |
Act $ total (forecast order category 1) |
The actual merchandise order total for forecast order category 1. This is the dollar amount defined in the $ orders/cat 1 field in the Offer/Drop/Period/Day table. Numeric, 9 positions; display-only. |
Act ords (forecast order category 2) |
The actual number of orders for forecast order category 2. This is the number of orders defined in the # orders/cat 2 field in the Offer/Drop/Period/Day table. Numeric, 5 positions; display-only. |
Act $ total (forecast order category 2) |
The actual merchandise order total for forecast order category 2. This is the dollar amount defined in the $ orders/cat 2 field in the Offer/Drop/Period/Day table. Numeric, 9 positions; display-only. |
Act ords (combined) |
The actual number of orders across forecast order categories 1 and 2. Numeric, 5 positions; display-only. |
Act $ total (combined) |
The actual merchandise order total across forecast order categories 1 and 2. Numeric, 9 positions; display-only. |
Variance ord |
The difference between the projected number of orders and the actual number of orders for the period. A value of 100.00 indicates no variance exists between the projected number of orders and the actual number of orders. Calculation The system uses the following calculation to determine the variance between the projected number of orders and actual number of orders: actual orders combined / projected orders combined x 100 = variance orders for the period Example: actual orders = 2 projected orders = 10 (10 / 2) x 100 = 20 Numeric, 5 positions; display-only. |
Variance $ |
The difference between the projected merchandise order total and the actual merchandise order total. A value of 100.00 indicates no variance exists between the projected order dollars and actual order dollars. Calculation The system uses the following calculation to determine the variance between the project order total and the actual order total: (actual $ total combined / projected $ total) x 100 = total variance $ for the period Example: actual $ total combined = 20 projected $ total combined = 25 (25 / 20) x 100 = 80 variance dollars Numeric, 9 positions; display-only. |
Screen Option |
Procedure |
Display the actual number of orders and total order dollars for forecast order category 1, forecast order category 2, and combined, for each day in the forecast period |
Select Actual by Day for a forecast period to advance to the Display Actual Data by Day Screen (across drops). |
Review a summary of the forecast |
Select Summary to advance to the Display Forecast Summary Screen (across drops). |
Display Forecast Screen (by drop)
Purpose: Use this screen to review forecast projection information for the specified offer and drop.
For each period in the forecast, the system displays:
• the projected:
• number of orders and total order dollars for forecasting order category 1
• the number of orders and total order dollars for forecasting order category 2
• the number of orders and total order dollars across forecasting order categories 1 and 2
• the actual:
• number of orders and total order dollars for forecasting order category 1
• the number of orders and total order dollars for forecasting order category 2
• the number of orders and total order dollars across forecasting order categories 1 and 2
• the percentage of variance between the projected number of orders and total order dollars and the actual number of orders and total order dollars
Forecast order category names: The names that displays for forecasting order categories 1 and 2 are defined in the following system control values:
• Forecasting Order Category #1 (B94)
• Forecasting Order Category #2 (B95)
How to display this screen: Select OK at the Forecast Inquiry Screen.
Field |
Description |
Offer |
The offer whose forecast information you are reviewing; this is the offer you defined at the Forecast Inquiry Screen. Offer codes are defined in and validated against the Offer table; see Working with Offers (WOFR). Alphanumeric, 3 positions; display-only. |
Drop |
The drop whose forecasting information you are reviewing; this is the drop you defined at the Forecast Inquiry Screen. Alphanumeric, 2 positions; display-only. |
Period |
The start date and end date of a period in the forecast. The days in a forecast period are determined by the # of Days in Forecasting Period (B96) and First Day of a Forecasting Period (B99) system control values. For each forecast period, the system displays: • the projected and actual number of orders for forecast order category 1, forecast order category 2, and combined. • the projected and actual total order dollars for forecast order category 1, forecast order category 2, and combined. • the variance between the projected numbers and dollars and the actual numbers and dollars. Numeric, 6 positions (MM/DD/YY format); display-only. |
Proj ords (forecast order category 1) |
The projected number of orders in a forecast period for forecast order category 1. This is the number of orders defined in the Orders - Category 1 field in the Forecast Detail table. Numeric, 5 positions; display-only. |
Proj $ total (forecast order category 1) |
The projected merchandise order total in a forecast period for forecast order category 1. This is the dollar amount defined in the $ - Category 1 field in the Forecast Detail table. Numeric, 9 positions; display-only. |
Proj ords (forecast order category 2) |
The projected number of orders in a forecast period for forecast order category 2. This is the number of orders defined in the Orders - Category 2 field in the Forecast Detail table. Numeric, 5 positions; display-only. |
Proj $ total (forecast order category 2) |
The projected merchandise order total in a forecast period for forecast order category 2. This is the dollar amount defined in the $ - Category 2 field in the Forecast Detail table. Numeric, 9 positions; display-only. |
Proj ords (combined) |
The projected number of orders in a forecast period across forecast order categories 1 and 2. This is the number of orders defined in the Orders - Combined field in the Forecast Detail table. Numeric, 5 positions; display-only. |
Proj $ total (combined) |
The projected merchandise order total in a forecast period across forecast order categories 1 and 2. This is the dollar amount defined in the $ - Combined field in the Forecast Detail table. Numeric, 9 positions; display-only. |
Act ords (forecast order category 1) |
The actual number of orders in a forecast period for forecast order category 1. This is the number of orders defined in the # orders/cat 1 field in the Offer/Drop/Period/Day table. Numeric, 5 positions; display-only. |
Act $ total (forecast order category 1) |
The actual merchandise order total in a forecast period for forecast order category 1. This is the dollar amount defined in the $ orders/cat 1 field in the Offer/Drop/Period/Day table. Numeric, 9 positions; display-only. |
Act ords (forecast order category 2) |
The actual number of orders in a forecast period for forecast order category 2. This is the number of orders defined in the # orders/cat 2 field in the Offer/Drop/Period/Day table. Numeric, 5 positions; display-only. |
Act $ total (forecast order category 2) |
The actual merchandise order total in a forecast period for forecast order category 2. This is the dollar amount defined in the $ orders/cat 2 field in the Offer/Drop/Period/Day table. Numeric, 9 positions; display-only. |
Act ords (combined) |
The actual number of orders in a forecast period across forecast order categories 1 and 2. Numeric, 5 positions; display-only. |
Act $ total (combined) |
The actual merchandise order total in a forecast period across forecast order categories 1 and 2. Numeric, 9 positions; display-only. |
Variance ord |
The difference between the projected number of orders and the actual number of orders for the period. A value of 100.00 indicates no variance exists between the projected number of orders and the actual number of orders. Calculation The system uses the following calculation to determine the variance between the projected number of orders and actual number of orders: actual orders combined / projected orders combined x 100 = variance orders for the period Example: actual orders = 2 projected orders = 10 10 / 2 = .2 x 100 = 20 Numeric, 5 positions; display-only. |
Variance $ |
The difference between the projected merchandise order total and the actual merchandise order total. A value of 100.00 indicates no variance exists between the projected order dollars and actual order dollars. Calculation The system uses the following calculation to determine the variance between the project order total and the actual order total: (actual $ total combined / projected $ total) x 100 = total variance $ for the period Example: actual $ total combined = 20 projected $ total combined = 25 25 / 20 = .8 .8 x 100 = 80 variance dollars Numeric, 9 positions; display-only. |
Screen Option |
Procedure |
Display the actual number of orders and total order dollars for forecast order category 1, forecast order category 2, and combined, for each day in the forecast period |
Select Actual by Day for a forecast period to advance to the Display Actual Data By Day Screen (by drop). |
Review a summary of the forecast |
Select Summary to advance to the Display Forecast Summary Screen (by drop). |
Display Actual Data by Day Screen (across drops)
Purpose: Use this screen to review the actual number of orders and total order dollars for each day in the forecasting period.
For each day, the system displays the actual number of orders and total order dollars for forecast order category 1, forecast order category 2, and combined.
How to display this screen: Select Actual by Day for a forecasting period at the Display Forecast by Offer Screen (across drops).
Field |
Description |
Offer |
The offer whose forecast information you are reviewing; this is the offer you defined at the Forecast Inquiry Screen. Offer codes are defined in and validated against the Offer table; see Working with Offers (WOFR). Alphanumeric, 3 positions; display-only. |
Date |
The date when the order activity for this forecast period occurred. Numeric, 6 positions (MM/DD/YY format); display-only. |
Orders (forecast order category 1) |
The number of orders entered on this date in the forecast period for forecast order category 1. This is the number of orders defined in the # orders/cat 1 field in the Offer/Drop/Period/Day table. Numeric, 7 positions; display-only. |
Dollars (forecast order category 1) |
The dollar total for the orders entered on this date in the forecast period for forecast order category 1. This is the dollar amount defined in the $ orders/cat 1 field in the Offer/Drop/Period/Day table. Numeric, 11 positions with a 2-place decimal; display-only. |
Orders (forecast order category 2) |
The number of orders entered on this date in the forecast period for forecast order category 2. This is the number of orders defined in the # orders/cat 2 field in the Offer/Drop/Period/Day table. Numeric, 7 positions; display-only. |
Dollars (forecast order category 2) |
The dollar total for the orders entered on this date in the forecast period for forecast order category 2. This is the dollar amount defined in the $ orders/cat 2 field in the Offer/Drop/Period/Day table. Numeric, 11 positions with a 2-place decimal; display-only. |
Orders (combined) |
The number of orders entered on this date in the forecast period across forecast order categories 1 and 2. Numeric, 7 positions; display-only. |
Dollars (combined) |
The dollar total for the orders entered on this date in the forecast period across forecast order categories 1 and 2. Numeric, 11 positions with a 2-place decimal; display-only. |
Display Actual Data By Day Screen (by drop)
Purpose: Use this screen to review the actual number of orders and total order dollars for each day in the forecasting period.
For each day, the system displays the actual number of orders and total order dollars for forecast order category 1, forecast order category 2, and combined.
How to display this screen: Select Actual by Day for a forecasting period at the Display Forecast Screen (by drop).
Field |
Description |
Offer |
The offer whose forecast information you are reviewing; this is the offer you defined at the Forecast Inquiry Screen. Offer codes are defined in and validated against the Offer table; see Working with Offers (WOFR). Alphanumeric, 3 positions; display-only. |
Drop |
The drop whose forecasting information you are reviewing; this is the drop you defined at the Forecast Inquiry Screen. Alphanumeric, 2 positions; display-only. |
Date |
The date when the order activity for this forecast period occurred. Numeric, 6 positions (MM/DD/YY format); display-only. |
Orders (forecast order category 1) |
The number of orders entered on this date in the forecast period for forecast order category 1. This is the number of orders defined in the # orders/cat 1 field in the Offer/Drop/Period/Day table. Numeric, 7 positions; display-only. |
Dollars (forecast order category 1) |
The dollar total for the orders entered on this date in the forecast period for forecast order category 1. This is the dollar amount defined in the $ orders/cat 1 field in the Offer/Drop/Period/Day table. Numeric, 11 positions with a 2-place decimal; display-only. |
Orders (forecast order category 2) |
The number of orders entered on this date in the forecast period for forecast order category 2. This is the number of orders defined in the # orders/cat 2 field in the Offer/Drop/Period/Day table. Numeric, 7 positions; display-only. |
Dollars (forecast order category 2) |
The dollar total for the orders entered on this date in the forecast period for forecast order category 2. This is the dollar amount defined in the $ orders/cat 2 field in the Offer/Drop/Period/Day table. Numeric, 11 positions with a 2-place decimal; display-only. |
Orders (combined) |
The number of orders entered on this date in the forecast period across forecast order categories 1 and 2. Numeric, 7 positions; display-only. |
Dollars (combined) |
The dollar total for the orders entered on this date in the forecast period across forecast order categories 1 and 2. Numeric, 11 positions with a 2-place decimal; display-only. |
Display Forecast Summary Screen (across drops)
Purpose: Use this screen to review the budget and sales plan for the projected forecast, across all drops.
How to display this screen: Select Summary at the Display Forecast by Offer Screen (across drops).
Field |
Description |
Offer |
The offer whose forecast information you are reviewing; this is the offer you defined at the Forecast Inquiry Screen. Offer codes are defined in and validated against the Offer table; see Working with Offers (WOFR). Alphanumeric, 3 positions; display-only. |
Drop |
The number of drops associated with the offer. Alphanumeric, 2 positions; display-only. |
Budget ords (forecast order category 1) |
The number of orders that have been budgeted for the forecast for forecast order category 1. This is the number of orders defined in the Budget ords cat 1 field in the Forecast table. Numeric, 7 positions; display-only. |
Budget $ total (forecast order category 1) |
The dollar total that has been budgeted for the forecast for forecast order category 1. This is the dollar total defined in the Budget $ cat 1 field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Budget ords (forecast order category 2) |
The number of orders that have been budgeted for the forecast for forecast order category 2. This is the number of orders defined in the Budget ords cat 2 field in the Forecast table. Numeric, 7 positions; display-only. |
Budget $ total (forecast order category 2) |
The dollar total that has been budgeted for the forecast for forecast order category 2. This is the dollar total defined in the Budget $ cat 2 field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Budget ords (combined) |
The number of orders that have been budgeted for the forecast across forecast order categories 1 and 2. This is the number of orders defined in the Budget ords combined field in the Forecast table. Numeric, 7 positions; display-only. |
Budget $ total (combined) |
The dollar total that has been budgeted for the forecast across forecast order categories 1 and 2. This is the dollar total defined in the Budget $ combined field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Sales plan ords (forecast order category 1) |
The number of orders that are included in the sales plan for the forecast for forecast order category 1. This is the number of orders defined in the Sales plan ord cat 1 field in the Forecast table. Numeric, 7 positions; display-only. |
Sales plan $ total (forecast order category 1) |
The dollar total that is included in the sales plan for the forecast for forecast order category 1. This is the dollar total defined in the Sales plan $ cat 1 field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Sales plan ords (forecast order category 2) |
The number of orders that are included in the sales plan for the forecast for forecast order category 2. This is the number of orders defined in the Sales plan ord cat 2 field in the Forecast table. Numeric, 7 positions; display-only. |
Sales plan $ total (forecast order category 2) |
The dollar total that is included in the sales plan for the forecast for forecast order category 2. This is the dollar total defined in the Sales plan $ cat 2 field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Sales plan ords (combined) |
The number of orders that are included in the sales plan for the forecast across forecast order categories 1 and 2. This is the number of orders defined in the Sales plan ord combined field in the Forecast table. Numeric, 7 positions; display-only. |
Sales plan $ total (combined) |
The dollar total that is included in the sales plan for the forecast across forecast order categories 1 and 2. This is the dollar total defined in the Sales plan $ combined field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Projections current ords (forecast order category 1) |
The current projected number of orders for the forecast for forecast order category 1. This is the sum of the Orders - category 1 field in the Forecast Detail table across all periods in the forecast. Numeric, 7 positions; display-only. |
Projections current $ total (forecast order category 1) |
The current projected dollar total for the forecast for forecast order category 1. This is the sum of the $ - category 1 field in the Forecast Detail table across all periods in the forecast. Numeric, 11 positions with a 2-place decimal; display-only. |
Projections current ords (forecast order category 2) |
The current projected number of orders for the forecast for forecast order category 2. This is the sum of the Orders - category 2 field in the Forecast Detail table across all periods in the forecast. Numeric, 7 positions; display-only. |
Projections current $ total (forecast order category 2) |
The current projected dollar total for the forecast for forecast order category 2. This is the sum of the $ - category 2 field in the Forecast Detail table across all periods in the forecast. Numeric, 11 positions with a 2-place decimal; display-only. |
Projections current ords (combined) |
The current projected number of orders for the forecast across forecast order categories 1 and 2. This is the sum of the Orders - combined field in the Forecast Detail table across all periods in the forecast. Numeric, 7 positions; display-only. |
Projections current $ total (combined) |
The current projected dollar total for the forecast for forecast order category 2. This is the sum of the $ - combined field in the Forecast Detail table across all periods in the forecast. Numeric, 11 positions with a 2-place decimal; display-only. |
Projections: revised ords (forecast order category 1) |
The revised projected orders for forecast order category 1. This is based on the actual orders for forecast order category 1 and the current % complete. For example, if the actual orders for forecast order category 1 is 1 and the % complete is 50.00, the revised projected orders would be 2. Numeric, 7 positions; display-only. |
Projections: revised $ total (forecast order category 1) |
The revised projected dollar total for forecast order category 1. This is based on the actual dollar total for forecast order category 1 and the current % complete. For example, if the actual dollar total for forecast order category 1 is 5 and the % complete is 50.00, the revised projected orders would be 10. Numeric, 7 positions; display-only. |
Projections: revised ords (forecast order category 2) |
The revised projected orders for forecast order category 2. This is based on the actual orders for forecast order category 2 and the current % complete. For example, if the actual orders for forecast order category 2 is 1 and the % complete is 50.00, the revised projected orders would be 2. Numeric, 7 positions; display-only. |
Projections: revised $ total (forecast order category 2) |
The revised projected dollar total for forecast order category 2. This is based on the actual dollar total for forecast order category 2 and the current % complete. For example, if the actual dollar total for forecast order category 2 is 5 and the % complete is 50.00, the revised projected orders would be 10. Numeric, 7 positions; display-only. |
Projections: revised ords (combined) |
The revised projected orders across forecast order categories 1 and 2. This is based on the actual orders combined and the current % complete. For example, if the actual orders combined is 1 and the % complete is 50.00, the revised projected orders would be 2. Numeric, 7 positions; display-only. |
Projections: revised $ total (combined) |
The revised projected dollar total across forecast order categories 1 and 2. This is based on the actual dollar total combined and the current % complete. For example, if the actual dollar total combined is 5 and the % complete is 50.00, the revised projected orders would be 10. Numeric, 7 positions; display-only. |
Variances: current ords (forecast order category 1) |
The difference between the current number of orders and the revised number of orders for forecast order category 1. Calculation The system uses the following calculation to determine the variance current orders for forecast order category 1: current ords forecast order category 1 / revised ords forecast order category 1 x 100 = variance current orders for forecast order category 1. Example: current orders = 30 revised orders = 4 30 / 4 x 100 = 13.33 Numeric, 7 positions; display-only. |
Variances: current $ total (forecast order category 1) |
The difference between the current dollar total and the revised dollar total for forecast order category 1. Calculation The system uses the following calculation to determine the variance current dollar total for forecast order category 1: current $ total forecast order category 1 / revised $ total forecast order category 1 x 100 = variance current $ total for forecast order category 1. Example: current $ total = 1800 revised orders = 30 1800 / 30 x 100 = 1.66 Numeric, 11 positions with a 2-place decimal; display-only. |
Variances: current ords (forecast order category 2) |
The difference between the current number of orders and the revised number of orders for forecast order category 2. Calculation The system uses the following calculation to determine the variance current orders for forecast order category 2: current ords forecast order category 2 / revised ords forecast order category 2 x 100 = variance current orders for forecast order category 2. Example: current orders = 30 revised orders = 4 30 / 4 x 100 = 13.33 Numeric, 7 positions; display-only. |
Variances: current $ total (forecast order category 2) |
The difference between the current dollar total and the revised dollar total for forecast order category 2. Calculation The system uses the following calculation to determine the variance current dollar total for forecast order category 2: current $ total forecast order category 2 / revised $ total forecast order category 2 x 100 = variance current $ total for forecast order category 2. Example: current $ total = 1800 revised orders = 30 1800 / 30 x 100 = 1.66 Numeric, 11 positions with a 2-place decimal; display-only. |
Variances: current ords (combined) |
The difference between the current number of orders and the revised number of orders across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance current orders for forecast order categories 1 and 2: current ords combined / revised ords combined x 100 = variance current orders combined. Example: current orders = 30 revised orders = 4 30 / 4 x 100 = 13.33 Numeric, 7 positions; display-only. |
Variances: current $ total (combined) |
The difference between the current dollar total and the revised dollar total across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance current dollar total for forecast order categories 1 and 2: current $ total combined / revised $ total combined x 100 = variance current $ total combined. Example: current $ total = 1800 revised orders = 30 1800 / 30 x 100 = 1.66 Numeric, 11 positions with a 2-place decimal; display-only. |
Variances: sales plan ords (forecast order category 1) |
The difference between the sales plan orders and the revised orders for forecast order category 1. Calculation The system uses the following calculation to determine the variance sales plan orders for forecast order category 1: (sales plan orders forecast order category 1 / revised orders forecast order category 1) x 100 = variance sales plan orders forecast order category 1. Example: sales plan orders = 6 revised orders = 4 6 / 4 x 100 = 66.66 Numeric, 7 positions; display-only. |
Variances: sales plan $ total (forecast order category 1) |
The difference between the sales plan dollar total and the revised dollar total for forecast order category 1. Calculation The system uses the following calculation to determine the variance sales plan dollar total for forecast order category 1: (sales plan $ total forecast order category 1 / revised $ total forecast order category 1) x 100 = variance sales plan $ total forecast order category 1. Example: sales plan $ total = 300.00 revised $ total = 30 300 / 30 x 100 = 10.00 Numeric, 7 positions; display-only. |
Variances: sales plan ords (forecast order category 2) |
The difference between the sales plan orders and the revised orders for forecast order category 2. Calculation The system uses the following calculation to determine the variance sales plan orders for forecast order category 2: (sales plan orders forecast order category 2 / revised orders forecast order category 2) x 100 = variance sales plan orders forecast order category 2. Example: sales plan orders = 6 revised orders = 4 6 / 4 x 100 = 66.66 Numeric, 7 positions; display-only. |
Variances: sales plan $ total (forecast order category 2) |
The difference between the sales plan dollar total and the revised dollar total for forecast order category 2. Calculation The system uses the following calculation to determine the variance sales plan dollar total for forecast order category 2: (sales plan $ total forecast order category 2 / revised $ total forecast order category 2) x 100 = variance sales plan $ total forecast order category 2. Example: sales plan $ total = 300.00 revised $ total = 30 300 / 30 x 100 = 10.00 Numeric, 7 positions; display-only. |
Variances: sales plan ords (combined) |
The difference between the sales plan orders and the revised orders across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance sales plan orders combined: (sales plan orders combined / revised orders combined) x 100 = variance sales plan orders combined. Example: sales plan orders = 6 revised orders = 4 6 / 4 x 100 = 66.66 Numeric, 7 positions; display-only. |
Variances: sales plan $ total (combined) |
The difference between the sales plan dollar total and the revised dollar total across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance sales plan dollar total for forecast order categories 1 and 2: (sales plan $ total combined / revised $ total combined) x 100 = variance sales plan $ total combined. Example: sales plan $ total = 300.00 revised $ total = 30 300 / 30 x 100 = 10.00 Numeric, 7 positions; display-only. |
Variances: budget ords (forecast order category 1) |
The difference between the budget orders and the revised orders for forecast order category 1. Calculation The system uses the following calculation to determine the variance budget orders for forecast order category 1: (budget orders forecast order category 1 / revised orders forecast order category 1) x 100 = variance budget orders forecast order category 1. Example: budget orders = 4 revised orders = 2 4 / 2 x 100 = 50 Numeric, 7 positions; display-only. |
Variances: budget $ total (forecast order category 1) |
The difference between the budget dollar total and the revised dollar total for forecast order category 1. Calculation The system uses the following calculation to determine the variance budget dollar total for forecast order category 1: (budget $ total forecast order category 1 / revised $ total forecast order category 1) x 100 = variance budget $ total forecast order category 1. Example: budget $ total = 200.00 revised $ total = 10 200 / 10 x 100 = 5.00 Numeric, 7 positions; display-only. |
Variances: budget ords (forecast order category 2) |
The difference between the budget orders and the revised orders for forecast order category 2. Calculation The system uses the following calculation to determine the variance budget orders for forecast order category 2: (budget orders forecast order category 2 / revised orders forecast order category 2) x 100 = variance budget orders forecast order category 2. Example: budget orders = 4 revised orders = 2 4 / 2 x 100 = 50 Numeric, 7 positions; display-only. |
Variances: budget $ total (forecast order category 2) |
The difference between the budget dollar total and the revised dollar total for forecast order category 2. Calculation The system uses the following calculation to determine the variance budget dollar total for forecast order category 2: (budget $ total forecast order category 2 / revised $ total forecast order category 2) x 100 = variance budget $ total forecast order category 2. Example: budget $ total = 200.00 revised $ total = 10 200 / 10 x 100 = 5.00 Numeric, 7 positions; display-only. |
Variances: budget ords (combined) |
The difference between the budget orders and the revised orders across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance budget orders across forecast order categories 1 and 2: (budget orders combined / revised orders combined) x 100 = variance budget orders combined. Example: budget orders = 4 revised orders = 2 4 / 2 x 100 = 50 Numeric, 7 positions; display-only. |
Variances: budget $ total (combined) |
The difference between the budget dollar total and the revised dollar total across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance budget dollar total across forecast order categories 1 and 2: (budget $ total combined / revised $ total combined) x 100 = variance budget $ total combined. Example: budget $ total = 200.00 revised $ total = 10 200 / 10 x 100 = 5.00 Numeric, 7 positions; display-only. |
% complete (forecast order category 1) |
The completion percentage for the curve used in the forecast for forecast order category 1. The completion percentage for forecast order category 1 is the sum of the % comp - category 1 field in the Forecast Detail table up to the current period, based on system date. For example, if the current date falls in forecast period 3, the system sums the % comp - category 1 field for periods 1, 2, and 3. Numeric, 5 positions with a 2-place decimal; display-only. |
% complete (forecast order category 2) |
The completion percentage for the curve used in the forecast for forecast order category 2. The completion percentage for forecast order category 1 is the sum of the % comp - category 2 field in the Forecast Detail table up to the current period, based on system date. For example, if the current date falls in forecast period 3, the system sums the % comp - category 1 field for periods 1, 2, and 3. Numeric, 5 positions with a 2-place decimal; display-only. |
% complete (combined) |
The completion percentage for the curve used in the forecast across forecast order categories 1 and 2. Calculation: The system uses the following calculation to determine the % complete across forecast order categories 1 and 2: (% complete forecast order category 1 + % complete forecast order category 2) / 2 = % complete combined. Example: % complete forecast order category 1 = 75.00 % complete forecast order category 2 = 50.00 (75.00 + 50.00) / 2 = 62.50 Numeric, 5 positions with a 2-place decimal; display-only. |
Display Forecast Summary Screen (by drop)
Purpose: Use this screen to review the budget and sales plan for the projected forecast and drop.
How to display this screen: Select Summary at the Display Forecast Screen (by drop).
Field |
Description |
Offer |
The offer whose forecast information you are reviewing; this is the offer you defined at the Forecast Inquiry Screen. Offer codes are defined in and validated against the Offer table; see Working with Offers (WOFR). Alphanumeric, 3 positions; display-only. |
Drop |
The code and description of the drop whose forecasting information you are reviewing; this is the drop you defined at the Forecast Inquiry Screen. Alphanumeric, 2 positions; display-only. |
Budget ords (forecast order category 1) |
The number of orders that have been budgeted for the forecast and drop for forecast order category 1. This is the number of orders defined in the Budget ords cat 1 field in the Forecast table. Numeric, 7 positions; display-only. |
Budget $ total (forecast order category 1) |
The dollar total that has been budgeted for the forecast and drop for forecast order category 1. This is the dollar total defined in the Budget $ cat 1 field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Budget ords (forecast order category 2) |
The number of orders that have been budgeted for the forecast and drop for forecast order category 2. This is the number of orders defined in the Budget ords cat 2 field in the Forecast table. Numeric, 7 positions; display-only. |
Budget $ total (forecast order category 2) |
The dollar total that has been budgeted for the forecast and drop for forecast order category 2. This is the dollar total defined in the Budget $ cat 2 field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Budget ords (combined) |
The number of orders that have been budgeted for the forecast and drop across forecast order categories 1 and 2. This is the number of orders defined in the Budget ords combined field in the Forecast table. Numeric, 7 positions; display-only. |
Budget $ total (combined) |
The dollar total that has been budgeted for the forecast and drop across forecast order categories 1 and 2. This is the dollar total defined in the Budget $ combined field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Sales plan ords (forecast order category 1) |
The number of orders that are included in the sales plan for the forecast and drop for forecast order category 1. This is the number of orders defined in the Sales plan ord cat 1 field in the Forecast table. Numeric, 7 positions; display-only. |
Sales plan $ total (forecast order category 1) |
The dollar total that is included in the sales plan for the forecast and drop for forecast order category 1. This is the dollar total defined in the Sales plan $ cat 1 field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Sales plan ords (forecast order category 2) |
The number of orders that are included in the sales plan for the forecast and drop for forecast order category 2. This is the number of orders defined in the Sales plan ord cat 2 field in the Forecast table. Numeric, 7 positions; display-only. |
Sales plan $ total (forecast order category 2) |
The dollar total that is included in the sales plan for the forecast and drop for forecast order category 2. This is the dollar total defined in the Sales plan $ cat 2 field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Sales plan ords (combined) |
The number of orders that are included in the sales plan for the forecast and drop across forecast order categories 1 and 2. This is the number of orders defined in the Sales plan ord combined field in the Forecast table. Numeric, 7 positions; display-only. |
Sales plan $ total (combined) |
The dollar total that is included in the sales plan for the forecast and drop across forecast order categories 1 and 2. This is the dollar total defined in the Sales plan $ combined field in the Forecast table. Numeric, 11 positions with a 2-place decimal; display-only. |
Projections current ords (forecast order category 1) |
The current projected number of orders for the forecast and drop for forecast order category 1. This is the sum of the Orders - category 1 field in the Forecast Detail table across all periods in the forecast. Numeric, 7 positions; display-only. |
Projections current $ total (forecast order category 1) |
The current projected dollar total for the forecast and drop for forecast order category 1. This is the sum of the $ - category 1 field in the Forecast Detail table across all periods in the forecast. Numeric, 11 positions with a 2-place decimal; display-only. |
Projections current ords (forecast order category 2) |
The current projected number of orders for the forecast and drop for forecast order category 2. This is the sum of the Orders - category 2 field in the Forecast Detail table across all periods in the forecast. Numeric, 7 positions; display-only. |
Projections current $ total (forecast order category 2) |
The current projected dollar total for the forecast and drop for forecast order category 2. This is the sum of the $ - category 2 field in the Forecast Detail table across all periods in the forecast. Numeric, 11 positions with a 2-place decimal; display-only. |
Projections current ords (combined) |
The current projected number of orders for the forecast and drop across forecast order categories 1 and 2. This is the sum of the Orders - combined field in the Forecast Detail table across all periods in the forecast. Numeric, 7 positions; display-only. |
Projections current $ total (combined) |
The current projected dollar total for the forecast and drop for forecast order category 2. This is the sum of the $ - combined field in the Forecast Detail table across all periods in the forecast. Numeric, 11 positions with a 2-place decimal; display-only. |
Projections: revised ords (forecast order category 1) |
The revised projected orders for forecast order category 1. This is based on the actual orders for forecast order category 1 and the current % complete. For example, if the actual orders for forecast order category 1 is 1 and the % complete is 50.00, the revised projected orders would be 2. Numeric, 7 positions; display-only. |
Projections: revised $ total (forecast order category 1) |
The revised projected dollar total for forecast order category 1. This is based on the actual dollar total for forecast order category 1 and the current % complete. For example, if the actual dollar total for forecast order category 1 is 5 and the % complete is 50.00, the revised projected orders would be 10. Numeric, 7 positions; display-only. |
Projections: revised ords (forecast order category 2) |
The revised projected orders for forecast order category 2. This is based on the actual orders for forecast order category 2 and the current % complete. For example, if the actual orders for forecast order category 2 is 1 and the % complete is 50.00, the revised projected orders would be 2. Numeric, 7 positions; display-only. |
Projections: revised $ total (forecast order category 2) |
The revised projected dollar total for forecast order category 2. This is based on the actual dollar total for forecast order category 2 and the current % complete. For example, if the actual dollar total for forecast order category 2 is 5 and the % complete is 50.00, the revised projected orders would be 10. Numeric, 7 positions; display-only. |
Projections: revised ords (combined) |
The revised projected orders across forecast order categories 1 and 2. This is based on the actual orders combined and the current % complete. For example, if the actual orders combined is 1 and the % complete is 50.00, the revised projected orders would be 2. Numeric, 7 positions; display-only. |
Projections: revised $ total (combined) |
The revised projected dollar total across forecast order categories 1 and 2. This is based on the actual dollar total combined and the current % complete. For example, if the actual dollar total combined is 5 and the % complete is 50.00, the revised projected orders would be 10. Numeric, 7 positions; display-only. |
Variances: current ords (forecast order category 1) |
The difference between the current number of orders and the revised number of orders for forecast order category 1. Calculation The system uses the following calculation to determine the variance current orders for forecast order category 1: current ords forecast order category 1 / revised ords forecast order category 1 x 100 = variance current orders for forecast order category 1. Example: current orders = 30 revised orders = 4 30 / 4 x 100 = 13.33 Numeric, 7 positions; display-only. |
Variances: current $ total (forecast order category 1) |
The difference between the current dollar total and the revised dollar total for forecast order category 1. Calculation The system uses the following calculation to determine the variance current dollar total for forecast order category 1: current $ total forecast order category 1 / revised $ total forecast order category 1 x 100 = variance current $ total for forecast order category 1. Example: current $ total = 1800 revised orders = 30 1800 / 30 x 100 = 1.66 Numeric, 11 positions with a 2-place decimal; display-only. |
Variances: current ords (forecast order category 2) |
The difference between the current number of orders and the revised number of orders for forecast order category 2. Calculation The system uses the following calculation to determine the variance current orders for forecast order category 2: current ords forecast order category 2 / revised ords forecast order category 2 x 100 = variance current orders for forecast order category 2. Example: current orders = 30 revised orders = 4 30 / 4 x 100 = 13.33 Numeric, 7 positions; display-only. |
Variances: current $ total (forecast order category 2) |
The difference between the current dollar total and the revised dollar total for forecast order category 2. Calculation The system uses the following calculation to determine the variance current dollar total for forecast order category 2: current $ total forecast order category 2 / revised $ total forecast order category 2 x 100 = variance current $ total for forecast order category 2. Example: current $ total = 1800 revised orders = 30 1800 / 30 x 100 = 1.66 Numeric, 11 positions with a 2-place decimal; display-only. |
Variances: current ords (combined) |
The difference between the current number of orders and the revised number of orders across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance current orders for forecast order categories 1 and 2: current ords combined / revised ords combined x 100 = variance current orders combined. Example: current orders = 30 revised orders = 4 30 / 4 x 100 = 13.33 Numeric, 7 positions; display-only. |
Variances: current $ total (combined) |
The difference between the current dollar total and the revised dollar total across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance current dollar total for forecast order categories 1 and 2: current $ total combined / revised $ total combined x 100 = variance current $ total combined. Example: current $ total = 1800 revised orders = 30 1800 / 30 x 100 = 1.66 Numeric, 11 positions with a 2-place decimal; display-only. |
Variances: sales plan ords (forecast order category 1) |
The difference between the sales plan orders and the revised orders for forecast order category 1. Calculation The system uses the following calculation to determine the variance sales plan orders for forecast order category 1: (sales plan orders forecast order category 1 / revised orders forecast order category 1) x 100 = variance sales plan orders forecast order category 1. Example: sales plan orders = 6 revised orders = 4 6 / 4 x 100 = 66.66 Numeric, 7 positions; display-only. |
Variances: sales plan $ total (forecast order category 1) |
The difference between the sales plan dollar total and the revised dollar total for forecast order category 1. Calculation The system uses the following calculation to determine the variance sales plan dollar total for forecast order category 1: (sales plan $ total forecast order category 1 / revised $ total forecast order category 1) x 100 = variance sales plan $ total forecast order category 1. Example: sales plan $ total = 300.00 revised $ total = 30 300 / 30 x 100 = 10.00 Numeric, 7 positions; display-only. |
Variances: sales plan ords (forecast order category 2) |
The difference between the sales plan orders and the revised orders for forecast order category 2. Calculation The system uses the following calculation to determine the variance sales plan orders for forecast order category 2: (sales plan orders forecast order category 2 / revised orders forecast order category 2) x 100 = variance sales plan orders forecast order category 2. Example: sales plan orders = 6 revised orders = 4 6 / 4 x 100 = 66.66 Numeric, 7 positions; display-only. |
Variances: sales plan $ total (forecast order category 2) |
The difference between the sales plan dollar total and the revised dollar total for forecast order category 2. Calculation The system uses the following calculation to determine the variance sales plan dollar total for forecast order category 2: (sales plan $ total forecast order category 2 / revised $ total forecast order category 2) x 100 = variance sales plan $ total forecast order category 2. Example: sales plan $ total = 300.00 revised $ total = 30 300 / 30 x 100 = 10.00 Numeric, 7 positions; display-only. |
Variances: sales plan ords (combined) |
The difference between the sales plan orders and the revised orders across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance sales plan orders combined: (sales plan orders combined / revised orders combined) x 100 = variance sales plan orders combined. Example: sales plan orders = 6 revised orders = 4 6 / 4 x 100 = 66.66 Numeric, 7 positions; display-only. |
Variances: sales plan $ total (combined) |
The difference between the sales plan dollar total and the revised dollar total across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance sales plan dollar total for forecast order categories 1 and 2: (sales plan $ total combined / revised $ total combined) x 100 = variance sales plan $ total combined. Example: sales plan $ total = 300.00 revised $ total = 30 300 / 30 x 100 = 10.00 Numeric, 7 positions; display-only. |
Variances: budget ords (forecast order category 1) |
The difference between the budget orders and the revised orders for forecast order category 1. Calculation The system uses the following calculation to determine the variance budget orders for forecast order category 1: (budget orders forecast order category 1 / revised orders forecast order category 1) x 100 = variance budget orders forecast order category 1. Example: budget orders = 4 revised orders = 2 4 / 2 x 100 = 50 Numeric, 7 positions; display-only. |
Variances: budget $ total (forecast order category 1) |
The difference between the budget dollar total and the revised dollar total for forecast order category 1. Calculation The system uses the following calculation to determine the variance budget dollar total for forecast order category 1: (budget $ total forecast order category 1 / revised $ total forecast order category 1) x 100 = variance budget $ total forecast order category 1. Example: budget $ total = 200.00 revised $ total = 10 200 / 10 x 100 = 5.00 Numeric, 7 positions; display-only. |
Variances: budget ords (forecast order category 2) |
The difference between the budget orders and the revised orders for forecast order category 2. Calculation The system uses the following calculation to determine the variance budget orders for forecast order category 2: (budget orders forecast order category 2 / revised orders forecast order category 2) x 100 = variance budget orders forecast order category 2. Example: budget orders = 4 revised orders = 2 4 / 2 x 100 = 50 Numeric, 7 positions; display-only. |
Variances: budget $ total (forecast order category 2) |
The difference between the budget dollar total and the revised dollar total for forecast order category 2. Calculation The system uses the following calculation to determine the variance budget dollar total for forecast order category 2: (budget $ total forecast order category 2 / revised $ total forecast order category 2) x 100 = variance budget $ total forecast order category 2. Example: budget $ total = 200.00 revised $ total = 10 200 / 10 x 100 = 5.00 Numeric, 7 positions; display-only. |
Variances: budget ords (combined) |
The difference between the budget orders and the revised orders across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance budget orders across forecast order categories 1 and 2: (budget orders combined / revised orders combined) x 100 = variance budget orders combined. Example: budget orders = 4 revised orders = 2 4 / 2 x 100 = 50 Numeric, 7 positions; display-only. |
Variances: budget $ total (combined) |
The difference between the budget dollar total and the revised dollar total across forecast order categories 1 and 2. Calculation The system uses the following calculation to determine the variance budget dollar total across forecast order categories 1 and 2: (budget $ total combined / revised $ total combined) x 100 = variance budget $ total combined. Example: budget $ total = 200.00 revised $ total = 10 200 / 10 x 100 = 5.00 Numeric, 7 positions; display-only. |
% complete (forecast order category 1) |
The completion percentage for the curve used in the forecast and drop for forecast order category 1. The completion percentage for forecast order category 1 is the sum of the % comp - category 1 field in the Forecast Detail table up to the current period, based on system date. For example, if the current date falls in forecast period 3, the system sums the % comp - category 1 field for periods 1, 2, and 3. Numeric, 5 positions with a 2-place decimal; display-only. |
% complete (forecast order category 2) |
The completion percentage for the curve used in the forecast and drop for forecast order category 2. The completion percentage for forecast order category 1 is the sum of the % comp - category 2 field in the Forecast Detail table up to the current period, based on system date. For example, if the current date falls in forecast period 3, the system sums the % comp - category 1 field for periods 1, 2, and 3. Numeric, 5 positions with a 2-place decimal; display-only. |
% complete (combined) |
The completion percentage for the curve used in the forecast and drop across forecast order categories 1 and 2. Calculation: The system uses the following calculation to determine the % complete across forecast order categories 1 and 2: (% complete forecast order category 1 + % complete forecast order category 2) / 2 = % complete combined. Example: % complete forecast order category 1 = 75.00 % complete forecast order category 2 = 50.00 (75.00 + 50.00) / 2 = 62.50 Numeric, 5 positions with a 2-place decimal; display-only. |
| Forecasting PO Error Listing | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Using House List Options |
DFCS OROMS 5.0 2018 OTN