Case Studies:

Jaguar have recently introduced a new car: the XF. MW Data had a small part to play in ensuring the launch event in Monaco ran smoothly. Journalists from all over the world came to Monaco as guests to try out the car.

An MW database helped to make sure each journalist was properly looked after.

Daily lists of all travel requirements, including airport transfer, were provided to taxi firms who could then efficiently organise their work.

Summary lists of all guests’ arrival dates, departure dates, room types, dietry requirements were provided to the participating hotels.

Once at the track, the organisers could check their lists to make sure each guest’s special driving requirements were met.

Lead-In Research
This company is a leading provider of specialist business leads and public sector tenders in the UK. The company has, at its heart, a database, developed in Access by MW Data. The database performs the following functions:

- Gathering of business lead data

- Tailoring of client requirements to make sure that only the right sort of business leads are delivered each month.

- Monthly delivery of business leads either by printed report or automatically as an attached report to an email.

- Monthly invoicing and statements, again either by post or automatically by email.

- Reconcilliation of client invoicing/payments.

- Providing the data to drive the company’s WEB site.

Back in 1998 MW Data began a 2 year project to produce a system which Woolworths could use to plan the flow of seasonal product from supplier through distribution centres to the stores. Now what does this mean?

Well, first of all a good example of seasonal product is Christmas Cards. The ideal situation being there should be enough to supply all customers, with the last one being sold on Christmas Eve.

The system would start its calculations at store level. It would look at weekly sales in previous years; it would apply factors like growth in a particular market or special promotions to estimate weekly sales in the coming year. Knowing that, it would look at the modus operandi of the distribution centres in order to calculate the deliveries to store and quantities. Finally it would look at the suppliers, using lead times and minimum order quantities to calculate when orders should be placed with suppliers.

The finished system worked very well and although only ever intended as a model, to ultimately prototype a module of a much bigger computer system, it was, in fact, never bettered and was used for many years.

|: Home : About Us : Clients : Case Studies : Contact :|