BM Medical

by Kurt Rodenhizer, MS, MBA

BM Medical provides temperature regulation equipment and disposables to Anesthesia Departments throughout the world.

Challenges:
BM Medical was using multiple files to manage contact information and to generate sales reports. The method for data entry left room for error and there was no relationship between customer contact information and sales made to the respective hospitals. In addition, the sales activity reports per region required the integration of multiple files into one and this was not being done as efficiently as the company had wanted..

Diagnosis:
Data on customers such as organization numbers, address, phone numbers, etc. was not associated to the sales data that was being entered by customer service.

Solutions

Table Architecture:
The first objective was to collect all the data from multiple files and create the minimum number of tables needed to develop the database. The table below is the organization table. Organization ID’s were assigned and regions were linked to the Sale rep regional tables. the link to the regional tables were important since sales quotas are based on sales made per region.

Product Table:
A product table was created so data did not have to be entered into the sales files. This table and others were used to create forms with drop down fields and check boxes to eliminate data entry error and spelling inconsistencies.

Report Generation:
Because all information has been stored in linked tables, hundreds of reports are possible in multiple formats.

Results:
1. The custom database was created in three days.
2. All data has been linked via assigned id numbers (database table relationships were resolved)
3. The establishment of database relationships allows for hundreds of report options which are all automatically updated as new data is entered into the system.