tel 01732 833085 · e-mail david wallis
DMW integrates the Access, Excel, Word and Outlook programs of Microsoft Office to make information flow with the minimum of hassle and to the greates business advantage.
Automating operations that otherwise require boring, time-consuming, error-prone repetitive manual tasks, frees people for more productive work. Also, exploiting computers to achieve this automation increases return on investment (ROI) in IT.
A main aim of DMW is to make the information a client holds readily available from a single source to anyone in their business who needs to use it. Efficiency gains are achieved in data collection, maintenance and storage, and in information distribution and reporting.
A multi-national company, DMW's client billed their clients on the basis of time spent on projects. The client's main accouning and time-recording system converted timesheet information into invoices.
Unfortunately, many time sheets were not up-to-date and many more remained unsubmitted until purges, usually towards the end of a project, filled in the gaps. Thus billing was far from consistent, and asd likely as not was back loaded. This lead to complaints about unexpectedly high invoiced amounts at the end of projects.
The main system could not identify timesheets that were incomplete or missing. So DMW was engaged to provide an automated process for chasing timesheets.
In a Microsoft Access database, DMW linked to the main system in realt time. Algorithms determined which timesheets were incomplete or missing. Details of these were e-mailed via Microsoft Outlook to the offenders, prompting them to bring things up-to-date. Heads of departments were notified of anyone failing to respond.
Results were immediate.