supply chain management
sales and product production forecasting

A database that accumulates sales data about several thousand products that are sold in over 100 countries. To forecast patterns of future sales, the database projects these data forward by combining a product lifetime profile and a seasonal weighting profile with a statistical weighting factor.

The forecasts are presented for each regional marketing manager to make their adjustments.

The final projections are used as the basis for determining the manufacturing schedules of the client's three factories in the UK, Sweden and The Netherlands.

We understand that our client sees the database as a cost-effective prototype for key elements of a fully-fledged manufacturing supply chain management system.

value to client

A systematic approach to forecasting sales and production levels:

• Sensitive to seasonal and product lifetime profiles
• Time savings preparing forecasts
• Rapid revision of any forecast
• Complete record of forecasts submitted
• Comparisons of forecasts against actual sales
• Continuous refinement of lifetime profile of products
• Continuous refinement of seasonal sales profiles
• Improved control of manufacturing volumes
• Prototype supply chain management system.

client

Subsidiary of an international PLC supplying products to the pharmaceutical industry and health services.

platform

Microsoft Access and VBA.