I have been writing occasional blog posts regarding Quickbase and have also appeared at their annual user conference and on a podcast.* I first heard of the company at the beginning of the year. The customers who spoke at the user conference gave examples of the simplicity and speed of the nocode application development. The product is operations management software without the extensive overhead of many competitors.
I picked up this case study to show the application.
Managing complex engineered orders across the globe requires a high degree of synchronization across teams and technologies. It also presents many challenges like: how can employees track workloads and problems across facilities? How easily can facilities communicate with one another? How can disparate datasets be converted and accessible across the organization when silos exist?
Metso, a leading process performance provider in the oil and gas, mining and aggregates industry, has found a solution to these challenges by building a suite of Quickbase applications. The applications have not only streamlined processes, and provided insights across their systems, but have helped Metso save more than $1 million annually while boosting efficiencies, saving time, enhancing visibility and transparency, and standardizing its order management practices.
Challenge
- Order management processes not standardized which made employee training and sharing workloads difficult
- Difficulty tracking complex orders through the planning, engineering, procurement, and manufacturing processes
- Employees used to have to dig through emails to track down orders or related actions
- At-risk critical order paths and inventory data stored in ERP and other systems were difficult to track and identify
- During the coronavirus outbreak office-based staff suddenly needed to work from home and lacked the equipment to efficiently keep up with daily tasks
Solution
- A suite of applications built on Quickbase for managing orders, engineering, and inventory
- Data from ERP, inventory, and data warehouses updated regularly to Quickbase applications
- Easy creation, distribution, and management of action items to mitigate potential delays or issues
- Custom reporting for tracking high-priority orders, inventory, and critical path issues
- Automated time-critical Engineering Change Notices rather than manually
- Rapid development of Quickbase applications to adapt an office-based workflow to an off-site system where engineering can continue to support manufacturing without being physically present at the plant
Benefits
- Annual cost savings of $1 million from improvements to order management, engineering, and inventory processes
- Improved training, increased effectiveness, and ability to share workload through order management process standardization
- Enhanced visibility and customized applications to quickly view order history and activities
- Automated tracking and notifications of Engineering Change Notices saves about 6 engineering man months per year
- Time savings of up to 500 hours thanks to the easy visibility of impacted supply chains and the quick investigation of affected orders
- Efficient customer service that is able to track orders for clients and keep them informed of deliveries
Metso Flow Control division, a leading provider of flow control solutions to the energy and other industries, is responsible for engineering and manufacturing valves and valve automation.
Controlling its own engineering and manufacturing processes was very resource intensive for Metso as information was stored across its ERP, order management and planning, engineering, and manufacturing processes. To solve these problems Metso built a suite of Quickbase applications focused on streamlining the order management process. The custom applications offered flexibility and transparency by providing all team members easy access to critical information.
Like many companies that handle complex orders, Metso struggled to coordinate its order management processes with its engineering, purchasing, and planning processes. Order managers had to dig deep into the data for order history and status of open issues. Email was the primary tool used to assign order tasks as well as communicate between departments meaning assignments were easily missed and problems became difficult to track.
If there was an issue, employees would often have to walk to other workers’ desks to try to collect signatures, taking time away from their actual jobs. It became time consuming to proactively identify issues and ensure that orders would be delivered on time.
While orders are still collected and stored in the ERP system, order-related data is exported regularly and entered into a Quickbase application for order management. Information from Metso’s promising logic tool is also loaded into Quickbase so order managers have quick insights into whether their orders will be delivered on schedule.
Inside the workflow, order managers can review each order and ensure that all the necessary engineering, purchasing, and manufacturing activities will be completed in time to match. If the order manager spots an issue, he or she can assign activities within the application to resolve it.
Custom reports enable order managers, their managers, and others to quickly drill down into orders to find any information they need to keep the process moving forward.
Metso’s Quickbase suite, Metso Global Operations Data Center, is now operational at its Helsinki, Shanghai, and Shrewsbury, MA manufacturing centers.
The combination of Quickbase suites covering order management, engineering, and inventory have actual cost savings in excess of $1 million annually. Metso’s development of these tools has given them greater control over the local and global execution of complex engineered orders.
“If we get an order that takes 40 weeks to manufacture, we need to pay close attention to the first two or three weeks. If we don’t get our materials driving in the first month or so, we’re going to have problems,” Rich Buckley, VP Global Operations Engineering and Order Management, Metso.
Order managers can “flag” high-priority orders for special tracking, utilizing the flexible reporting capabilities built into Quickbase.
The order management workflow in Quickbase has enabled Metso to standardize the order management process. This makes it easier to train employees and share workload.
Greater process efficiency and improved management tools have led to cost savings for Metso. For example, Metso automated their Engineering Change Notice process, so engineers were no longer physically collecting signatures from various departments. By eliminating manual processes, Metso has saved six engineering man months per year, according to Buckley.
* I am sometimes compensated for work for Quickbase.