A multi-module management system designed by ALT-C Systems.
ALT-C Systems’ TimeTrends Forecast Warehouse software provides a forecasting process that is tailored to each company’s unique needs. The solution lets you combine qualitative forecasts coming from the Web with system-generated statistical forecasts. Demand history and other information is automatically transferred from your MRP/ERP system. Forecast top-down or bottom-up with as many hierarchical views as you like, each with as many levels as needed. Efficiently manage the entire forecast process through configurable exceptions that may be defined on a user-by-product basis to focus planners on what is important to your business’ bottom line.
TimeTrends Forecast Warehouse is an open systems-compliant data management and processing environment, offering all the necessary tools to create, display and forecast time series data for your products.
Allows remote users to interact with the TimeTrends® forecasting database using a dial-up connection over the Internet. Its features include:
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.).
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.
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.
We have a very complex forecasting process that is quite unique to Molson, so our forecasting system has to comply with what we ask it to do. The TimeTrends Forecast Warehouse has the flexibility to meet the needs of a client with a different set of rules. It is an amazingly stable system with a unique hierarchical approach and an extremely ‘intelligent’ database engine that understands how to maneuver data to maximize forecast accuracy.
TimeTrends is quite unique in a number of areas including the way it chooses the data, forecasts the data and keeps it all straight. Each of our products may have a different start point and stop point. TimeTrends keeps track of it all electronically with a very good database of information. This extends not only to the volumes contained in the database, but also where those volumes start and stop, and how to maneuver them to work together.
For instance, this ‘intelligent’ and precise system looks at things and builds hierarchies automatically. Its hierarchical approach however is totally untied to the values in the hierarchy. This concept is quite novel and very different from what we were used to. Plus, TimeTrends takes everything into consideration. If we have a product that only sells 18 weeks a year, it’ll figure that out automatically and forecast the same 18 weeks in time for every year that we ask it to.
We’re extremely impressed by ALT-C’s superior service and support. Any problems have been small, dealt with quickly and effectively and usually within minutes of our call.