Customer Demand

Demand is a filtered forecast of products being sold to the customers. The calculation of demand answers this question: "How much of the product is being demanded by customers?"

The system uses demand calculation to set order points, line points, and transfer points. In addition, demand determines surplus for the Suggested Purchase Order Queue and the Suggested Auto Transfer program.

For more information on order and line points, see the following topics:

Demand is calculated when the Update Demand program runs. You can audit the Update Demand program by accessing an individual product in the Product Maintenance screen.

This topic provides information about the following:

Demand History Period

To determine the amount of sales history to use to calculate demand, the Update Demand program first determines the number of hits for each product in each branch.

Then, the following rules apply to establish the amount of sales history appropriate to a product's rate of sale.

If a product has...

then..

25 or more hits in the past 91 days

the system uses the sales of the last 91 days to determine usage.

less than 25 hits in 91 days but more than 25 hits in the past year

the system totals the sales back to the occurrence on the day of the 25th hit.

If more than one hit occurred on the day of the 25th hit, all sales on that day are included.

less than 25 hits in the past year

the sales for the past year are totaled together.

Items that sell frequently are more predictable over short periods of time. By setting the Seasonal field to using Mass Load, you can identify items that have a seasonal sales character. The same rules apply to seasonal items, except that the system starts from a date beginning one year previous and moving forward to the present date.

Using the Add Demand Screen

Use the Add Demand screen to add the demand history of one or more discontinued products to its replacement product or add a product's demand history in one branch to another branch. For example, you receive notice from your vendor that the furnace Model 721A is being replaced with Model 721B. You do not want to lose the sale history for the furnace. Transfer the demand history from the discontinued model to the new model.

Use the Customer Demand hot key on the Add Demand screen to add a customer's demand history for one product to another. You can also subtract a customer's demand from a product. If the Customer Demand hot key on the Add Demand screen is highlighted, this indicates a customer name has been entered on the Add Demand Customer Information screen.

Note: The Days Out calculation remains the same even if the customer is a Subtract Demand Customer as set up in the Add Demand program.

For more information, see Adding Demand History to Products and Adding Demand from Dependent Selling Branches to Purchasing Branches.

Using Branch Demand Override

The Assign Demand Forecast To Price/Ship Branch Or By Zip Code control maintenance record defines where the demand should flow. For example, if you have an order that is a pricing branch 1 and a shipping branch 2, you need to decided if  the replenishment of that product goes to branch 1 or 2.

You can override this setting at the customer level. Use the Miscellaneous Customer Information screen to change the Branch Demand Override field to the selected branch. If this field is not set, the system uses the setting at the control maintenance level.

To change the Branch Demand Override:

  1. From the Files menu, select Customer to display the Customer Maintenance screen.

  2. In the Customer/New field, enter the customer name for which you want to override the branch demand and press Enter to display the customer record .

  3. Use the Add'l Info hot key to display the Addl Info screen selections.

  4. Use the Misc Cust Info hot key to display the Miscellaneous Customer Information screen.

  5. In the Branch Demand Override field, enter the branch number you want to use.

  6. Press Esc to save the changes and exit the screen.

  7. Press Esc to exit the customer record.

See Also:

How Eclipse Calculates Monthly Demand

Exceptional Sales

Lost Sales

How Eclipse Calculates Seasonal Products

Economic Order Quantity Overview

Forecasting Demand Overview