dmw | consultancy
tel 01732 833085
tonbridge · kent · UK

Supply Chain Management

Product Production and Sales Forecasting

The database DMW Consultancy created for its client 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.

DMW understands 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:


Client

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


Platform

Microsoft Access and VBA. Custom product volume profiling algorithms devised by DMW.

“The supply chain stuff is really tricky.”

Elon Musk