Promotions Module is a versatile, configurable add-on to any TimeTrends Forecast Warehouse installation. With it, you can easily track and calculate the effects of sales promotions with input obtained from anywhere in the world via the Internet.
The Promotions Module allows users to combine the lift from promotional activities with the baseline statistical forecast generated and managed using the TimeTrends Forecast Warehouse.
The Promotions Module stores a complete history of your promotional information in a way that conforms to your corporate promotional style. This generally includes type, value and date range of the customer promotions.
The stored promotional information is always available for analysis and use as a baseline for future product promotions.
When defining a promotion, you may choose to use either the promotion’s historical lift or override it with your own lift value.
Promotions can be updated either directly on the server, over a local network, or from anywhere in the world over the Internet when the optional TimeTrends e-Forecasting module is installed.
Promotional information can also be automatically updated from your corporate data warehouse where applicable, saving you from much of the effort and all of the errors associated with manual re-keying of data.
In designing the Promotions Module we recognized that data security is also an important concern. The module can be configured to limit who can view or who can modify promotional information, by customer or customer group or by product or product group.
As with all other TimeTrends products, promotional reports can be generated using standard report writing tools for on-screen viewing purposes, or for later delivery via e-mail.
Forecast Warehouse provides users the ability to author and execute SQL queries in the database. Create custom views of the data, manipulate and sort fields, do multi-parameter searches, and execute custom calculations into user-defined fields. System Administrators can create additional user-defined fields to store non-forecasted data or attributes such as inventory, open order status, standard costs or other financial data. Users can create custom calculations such as weeks’ supply, inventory stock-turns, standard cost of forecast error, pro-forma revenue change, and so on.
Straightforward database navigation is provided via intuitive drag and drop hierarchy structures. Multi-dimensional views of the data can be shown graphically at the click of the mouse. Users can create unlimited hierarchical aggregate tables and perform batch re-forecasts.
In addition to forecasting, the system’s data can be used in a DRP/replenishment mode in order to provide suggested re-order dates, suggested re-order quantities, projected out-of stock dates, minimum/maximum inventory levels and more.
The system can utilize data entry forms for forecast updating by non-specialized end-users who do not require statistical forecasting, or by remote users, using MS-Access, Lotus Notes or Visual Basic forms. A form can be designed to contain as much or as little data as you wish, whether Marketing Intelligence or Sales Force opportunities for additional analysis. A separate module is available for Internet access.
Data types supported are weekly, monthly, 13-period, quarterly or annually. The data can be viewed graphically or in spreadsheet-like tables, which include historical data, trend, fitted and seasonal information. The user can annotate the table on a period by period basis and up to 8 tables at once.
A sophisticated mathematical engine offers 15 forecast methods encompassing all phases of the product life cycle. Trend extrapolation and curve fitting methods are included. For novice users or erratic data, four simple or naïve approaches are available, including a new item forecast. The auto-select option automatically suggests the method and parameters that offer the best fit.
Seasonal forecasts are calculated automatically and can be used with any of the above mentioned methods. Standard statistical measures are calculated on all forecasts to allow more sophisticated users to judge the validity of their assumptions. These measures include r-squared, MAD, standard deviation and other standard measures.
Once a forecast has been generated, you can override the forecast, either entirely or period by period and explain exceptional historical demand. The forecast is delivered as a visually effective presentation with reports using high quality graphics.
Several data manipulation techniques enable you to transform the data format in various ways. A goal seek function lets you adjust forecasts in order to meet quotas, by forcing the forecasts.
Allows remote users to interact with the TimeTrends® forecasting database using a dial-up connection over the Internet. Its features include:
Access from anywhere via Internet
Designed for Sales Force Automation environments, to allow Sales and Marketing users and other remote users to interact with the Forecast Database from the field or Customer site. It is a standard browser interface designed to work with most hardware, no software is required on the client machine other than the Windows operating system and a browser to log onto the user company’s corporate Intranet Web server address (FTP, IP, etc.).