|
The Challenge
The company's unique parts inventory, product offerings, vendors and customers, and service contracts have grown significantly in number and complexity over the years and the methods the company had in place for tracking key business data became outdated and inefficient.
Over the years, ICE had developed and modified individual FileMaker databases for its various operations (i.e. purchase orders, tracking parts, tracking services numbers), but realized that to efficiently manage this growth it needed to streamline its processes with one database.
"In addition to streamlining processes in the office, we also needed to become more efficient in our shop," said Sue Hughes, managing director at ICE. "By streamlining processes, we hope to better control costs by being able to identify trends and effectively plan for the future."
If ICE knows how much it actually costs to repair each product that comes into its shop, the costs of its light manufacturing processes, and has a better handle on its inventory, the company will be better able to improve its bottom line. Having worked with FileMaker Pro for a number of years, ICE was very familiar with its ease of use and customization capabilities. However, with no in-house developer available, the company had not been able to utilize FileMaker's fully relational and dynamic functionality for easy and accurate data storage and tracking.
> The Solution |