tel 01732 833085 · e-mail david wallis
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.
A systematic approach to forecasting sales and production levels:
Subsidiary of an international PLC supplying products to the pharmaceutical industry and health services.
Microsoft Access and VBA. Custom product volume profiling functions devised by DMW.