The Optimum Operational Forecasting Solution
FUTURCAST is the sales forecasting and assumption reporting software geared towards managing value of an organization. As displayed in Figure 1, it is designed to provide a unique, transparent forecast, to accurately drive product provisioning and determine financial expectations.

An artificial intelligent system, It is based on a tradition of academic knowledge. Its statistical engine is founded on data filtering and pattern recognition principles. It has evolved from a PC application package to a fully integrated enterprise solution making use of the Oracle database environment for assumption-based forecasting. FUTURCAST has been continuously upgraded over the last 25 years in close collaboration with world leaders in the life sciences, consumer package goods, and high technology industries.
Key Characteristics of the FUTURCAST Forecasting Process and System
Figure 2 provides an information flow diagram presenting the FUTURCAST Forecasting Process and its components. In Figure 2, we see that FUTURCAST forecast activities are not performed in isolation of the ERP solution. New data are required on a periodical basis (daily, weekly, or monthly) and forecasts need to be transferred in order to become the driving inputs to manufacturing, budgeting and other planning activities.

The four key characteristics of the FUTURCAST forecasting process and system are:
Marketing Led Assumption/Event-Based Forecasts
FUTURCAST’s principal objective is to provide management with fact-based information to improve planning accuracy. Senior managers are eager to find out what happens to product sales at various locations, countries and markets in order to better assess underlying risks and opportunities. They wish to learn the reasons behind the forecasts and their impact on the future growth of product sales.
FUTURCAST delivers, through standard and custom designed web-enabled tools, the sales demand forecast and the associated market driven assumptions. It offers to marketing and sales managers the ability to elaborate, from a unique planning base, the sales, financial, supply chain and strategic plans; each plan representing a different set of assumptions and/or impacts. The assumption/event database stores, in a structured way, the explanations on the key forecast changes for all core products as they relate to the different plans. Organizations can therefore gain a more in-depth understanding of their past performance and projected future growth.
Expert Forecasting Engine
The forecasting engine is the motor of a forecasting system. Its main purpose is to generate the planning base forecast from the analysis of past historical data. The planning base is the benchmark or point of reference from which all forecast modifications are made. The more accurate the planning base, the fewer manual overrides are required to correct it.
Five dimensions can be used to rate the performance of a forecast engine. They are:
| 1. | Type | objective vs. subjective |
| 2. | Horsepower | statistical vs. non-statistical |
| 3. | Class | extrapolative vs. causal |
| 4. | Method | single vs. multiple |
| 5. | Selection | best fit vs. expert system |
FUTURCAST’s engine attains the highest THCMS rating. It is classified as objective, statistical and extrapolative; it uses multiple methods and incorporates an expert system selection process. By definition, an expert system will reproduce how a person with great knowledge and skills in statistical forecasting would go about making his decision as to which method to use. An expert will first look at the data after having filtered outliers, then identify the first observation to be used, and depending on the trend-cycle pattern visually observed, it will then choose among a small select set of methods the most appropriate one to apply. This process corresponds to the automatic expert system which has been refined over the last 20 years and is incorporated in the FUTURCAST multiple method forecast engine.
Bird's Eye View Executive Analysis and Enterprise Application Integration
Reporting is an essential function of a forecasting system. The purpose is to deliver to senior managers, a “bird’s eye view” of business performances for both historical and forecast data and to provide drill-down and slice-and-dice functionalities to identify and assess “best” and “worst” performances, risks and opportunities.
FUTURCAST EASY on the Web OLAP reporting tool allows to easily query the database, slice-and-dice, drill down or up, and produce “on the go,” top-line macro, detailed micro, budget gap, year-to-date performance, perspective, and price/volume/exchange rate reports and analyses.
FUTURCAST Oracle nCUBE makes easily accessible to the enterprise reporting platform all forecast and assumption data. It delivers the capability to perform custom analysis of forecasting and assumption data from any point of view and to integrate and compare this information with other internal or external data sources. The nCUBE archives all previous forecast submissions, stores all the forecasting and assumption data at the lowest granularity for all dimensions, and contains consolidated data across pre-configured dimensions. Business intelligence reporting tools of choice, including but not limited to Cognos, SAP BW, Business Objects or TM1 can easily connect to the nCUBE and report data from them.
On-going Accuracy Monitoring
The FUTURCAST’s method of monitoring accuracy represents the evaluation function of the system. It consists of several user-customized and pre-defined reports computing key performance process indicators. Its purpose is to measure forecast accuracy and stability and to provide, to the owners of the forecast, the necessary feedback for assessing and reviewing their future assumptions.
FUTURCAST Advantages
FUTURCAST delivers:
FUTURCAST Business Analysis Solutions
To improve planning accuracy, FUTURCAST business analysis solutions rely on the most commercially sound technology platforms and employ market forecasting and planning methodologies that are grounded in proven academic principles. With more than 20 years of recognized international forecasting experience and expertise in the life sciences and other industries, you can rest assured that FUTURCAST’s risk-free solutions will exceed your expectations, on time and within budget.
“Global” in nature, these solutions think global while acting on the local forecasting needs. This ability to configure the client’s applications in line with the characteristics of local market dynamics and the available information data is one of the key success factors in rolling out globally a forecasting solution. As a result, the reliance and need for Excel spreadsheets are significantly reduced.
These custom configured enterprise solutions may be grouped into 2 methodological classes:
By definition, a product forecasting solution pre-supposes that products evolve in an open, undefined market space. Assumptions, events or forecast adjustments are therefore applied independently of their impact on the market. Market growth is therefore unrestricted.
Three types of solutions may be configured depending on completeness and forecast horizons.
FUTURCAST Assumption-based Forecasting Solution

FUTURCAST Assumption-based forecasting offers the technology and Oracle infrastructure to harmonize the various operational forecasting activities and databases into a single environment. It is the ultimate of product forecasting solutions. For an organization, it provides a common database and transparent forecasting process driving both operations and budgeting functions for the short and long term. Moreover, it lays the foundation to integrate new product and in-line product forecasting within the same platform. The methodology truly delivers an up to 72 month “one number” forecast.
This new and proven methodology has been developed in close collaboration with global leaders in the healthcare industry. These companies are characterized by long production lead-times for the active ingredients of the medicinal products and a global manufacturing structure with highly efficient single-product factories producing for a global demand.
Simply speaking, assumption-based forecasting focuses on explaining the sales growth of a product through a structured system of qualitative reasoning. It is a structured approach to classifying quantitative impacts on a historical trend and the qualitative chain of reasoning behind the impacts.
The FUTURCAST Assumption-based forecasting methodology forces the review of assumptions on an on-going basis and is technically built on three components which are:

As illustrated in Figure 3, Assumption-based forecasting defines the final demand forecast as the sum of the fixed planning base and the structured assumptions. Because of its principal focus on the consolidation of the reasons behind the forecast, senior managers have turned to this solution since the explanations of what may happen strongly influence capacity planning accuracy and investment decisions.
FUTURCAST Special Events and Actions Forecasting Solutions

Special Events and Actions forecasting focuses on the short term. Often, statistical forecasting methodologies ignore a number of factors which might impact the short term product sales of a company. For instance, when a company launches a promotional campaign for one of its products, the sales will undoubtedly be above average for the month(s) during the campaign and most likely fall below average for the months that follow, before returning back to an average level. The same is true if there are temporary reductions or increases in prices, advertising campaigns, and other special events or actions taken by a company.
The FUTURCAST Special Events and Actions solution recognizes the importance and uniqueness of such events and actions.
This solution:
Special Events and Actions forecasting is particularly well-suited for fast moving consumer packaged goods companies. In such companies, having the “right” products at the “right” time is of critical importance. Special Events and Actions forecasting managed by key account managers delivers the right solution for short term forecasting of promotionally driven products.
FUTURCAST Collaborative Forecasting Solutions

Collaborative forecasting solutions are best suited for companies selling products that are driven by a remote sales force. For such companies, it is of critical importance to capture the changes that may affect product sales in the near term (the next 6 months) from sources that are closest to the customer (i.e. distributors, remote sales persons, agents, etc.). For these companies, not only is it important to have the right products at the right time, but also critical that they be at the right place. Collaborative forecasting tends to put a greater emphasis on the “right place” since, from a technical standpoint the forecasts are generally established at a “ship-to” location level. The main objective of collaborative forecasting is to integrate a remote sales force or distributors into a formal forecasting process in order to reduce short term customer inventory levels and improve distribution efficiency.
Without a collaborative process, forecasting would be analogous to driving a car with both eyes looking into the rear-view mirror.
FUTURCAST Total Market Forecasting Solutions
The primary function of Total Market Forecasting (TMF) is to develop a comprehensive picture of the future market including the forecasted shares of your own product and that of your competitors. In contrast to the product forecasting models, the market is clearly defined and close. It represents the sum of those products which have been assigned to constitute a specific market. The focus is on market share. Assumptions may grow the market, gain shares from others in the market, or act as a combination of both.
FUTURCAST Total Market Forecasting solution applies the principles of assumption-based forecasting in order to allow for the systematic and detailed accounting of projected changes in the marketplace. Individual product assumptions become group product assumptions. These are automatically reversed to allow for shift in sales “to” and “from” products. What one gains must, in part, be lost by others. In doing so, the effects from the changes on both your own products and those of your competitors, and the overall market, are captured and clearly mapped.

Total Market Forecasting is the key to full operational forecasting integration. It creates, for healthcare companies, as represented in Figure 4, a common language between the functional areas which is linked to future assumptions or events.
Monthly market shares are converted to gross monthly revenue dollars. These in turn, are then transformed into monthly ex-factory sales units. The derived ex-factory sales forecasts are then compared to the financial numbers in the budget and the later revisions having factored in rebates and discounts.
Total Market Forecasting delivers clear advantages over Product Forecasting Solutions.
FUTURCAST Total Market Forecasting:
The diagram displayed in Figure 5 presents the local forecasting landscape under a FUTURCAST Total Market Forecasting solution.
