Skip To The Main Content
Main Navigation Toggle
< Back to Listing

Fireproof Planning

  • Mike Colvin
July/August 2011
Vendor comments

User Solutions would like to thank the author for the honest review of RMDB and Technical Glass Products’ ongoing feedback on our planning, scheduling, and tracking tool. RMDB has a unique design that quickly and easily adapts to existing operations and delivers benefits without the pain of a complicated, costly, and inflexible system that’s hard to implement and maintain. It is the first tool that can be used by small companies with no formal systems in place—as well as at larger companies with existing enterprise resources planning systems.

What makes our products unique is that we solve planning, scheduling, and tracking challenges the customer’s way. Instead of forcing users to adapt business to a rigid system, our software fits the way they work right now. It’s encouraging to hear from customers, including Technical Glass Products, that a successful application can be quick, easy, and affordable—at less than $20,000 for a multiuser system, including implementation.

Another benefit for our customers is the depth of inclusive product features. When needed, customers can add functionality for materials management, master resources planning, and inventory, as well as advanced planning and scheduling features, including alternate work centers and routings, multiple constraints, and skill level scheduling.

Some of our customers start with one philosophy in mind—such as classic routing combined with bill of material—and reconfigure production to incorporate lean manufacturing. RMDB can be reconfigured to support a variety of approaches, including theory of constraints and Just-in-Time, with no additional costs.

Soon, we will release Resource Manager.NET, which will have all the flexibility of RMDB with more built-in customization options.

Product summary

Product name
Resource Manager-DB

Type of program
Production scheduling

Vendor
User Solutions
11009 Tillson Drive
South Lyon, Michigan 48178-9318
1-800-321-USER (8737)
usersolutions.com

Recommend operating environment
Windows with Microsoft Office installed. Excel 97 or greater.

Recommended server operating environment
Shared drive for multiuser database (Jet Engine/Access or SQL). Hosting options available through Go-Global or equivalent.

One manufacturer finds a cool scheduling solution

The challenge we faced at Technical Glass Products was to provide realistic shipping dates to customers. In the past, when a schedule changed and dates slipped, it became difficult to get back on track. After searching for the right tool, we came upon User Solutions’ planning, scheduling, and tracking suite Resource Manager-DB (RMDB).

Overview
RMDB provides credibility in communicating production schedules and eases frustration. It gives users the data they need to convey to others that, while some jobs might be late, schedules can be manipulated to lessen the overall impact on customers. With a single screen, production can be reprioritized and rescheduled based on critical parameters, such as number of days early or late, customer priority, and material shortages. (See Figure 1.) RMDB even can determine if jobs can be paused midstream without major ramifications.


The software suite gives us an overall view of the shop floor, answering questions about whether a shipping date is realistic for a new project. If a manager needs to be informed that shipping is going to miss a deadline, RMDB can provide the answer to the follow-up question, “how late?” This is a much better situation than explaining to the project manager and the customer, “I’ll get back to you in a week.”

With RMDB, it also is much easier to negotiate delivery dates with customers

before a project gets released. It allows us to run what-if scenarios on planned jobs and inform customers exactly when it’s possible to deliver.

Installation
The system was installed on Windows XP and Windows 7 machines running Microsoft Office and connecting to a shared database on a local server. Within a couple of weeks, installation was complete and the system was operational. RMDB integrated with many existing functions, including our enterprise resources planning system and custom tools for scanners and time clock functions. RMDB automatically receives information from the time clock system, giving us a real-time view of employee scheduling. Feedback from the production floor is combined with job creation tasks to generate realistic capacity schedules. (See Figure 2.)

The software is quick and responsive, but performance depends on the number of projects running. At Technical Glass Products, we put a fair load on the system: About 100 jobs are scheduled over four months, and each contains around 12 steps. We are pleased with the speed at which RMDB provides us needed data.

For 25 years, Technical Glass Products has manufactured fire-rated glass products, including doors, windows, and curtain walls, at our two facilities in Snoqualmie, Washington, and Milton, Ontario. Our goal is to provide a single source for fire-rated glass, framing systems, and specialty architectural glass products. The company also offers continuing education, project consultation, product specifications, computer-assisted design, and rapid-response quoting to help customers find the right materials for their construction and remodeling projects.

Recommended server operating environment

Shared drive for multiuser database (Jet Engine/Access or SQL). Hosting options available through Go-Global or equivalent.

Interface
RMDB’s interface is intuitive and easy to learn, and we have not had any trouble with navigation. While the system came with documentation and tutorials, we have not needed those resources very much. User Solutions provides free, customizable training. After only a few online meetings, our questions were answered.

While RMDB uses Microsoft Excel for reporting (see Figure 3), one of the product’s shortcomings was the difficulty in condensing long reports into one printable, readable page. And some of the error messages could be more informative; although User Solutions was very responsive in fixing our problems.

Customization
Another benefit of RMDB is the ability to make suggestions for improvements and see them implemented quickly. For example, we asked for a way to create a graphical flag for rush jobs and mark completed steps based on updates from the tracking system. User Solutions listened to our comments and made the changes at no cost in less than two weeks.

The system has built-in flexibility for many varieties of user customization. For example, either forward or reverse scheduling—or both—can be selected. We also can interact with the schedule on the fly and add steps for tracking rework, queue times, and materials. The system has many ways to adapt the software, and User Solutions has been great to work with. Their representatives are always prompt to answer questions and fix problems, and they are more than willing to take our suggestions and improve the software.

Overall, my colleagues and I at Technical Glass Products have been very pleased with RMDB. It was easy to install, easy to transfer our information into the system, and easy to navigate. It allows us to point out production bottlenecks and illustrate when we cannot get a certain amount of work done with limited time. It is a visual tool for displaying available capacity; managing current workloads; and, most of all, creating understanding.

Mike Colvin is production manager at Technical Glass Products, a manufacturer of fire-rated glass and framing systems. He may be contacted at mikec@fireglass.com.

Comment

  1. RadEditor - HTML WYSIWYG Editor. MS Word-like content editing experience thanks to a rich set of formatting tools, dropdowns, dialogs, system modules and built-in spell-check.
    RadEditor's components - toolbar, content area, modes and modules
       
    Toolbar's wrapper 
     
    Content area wrapper
    RadEditor's bottom area: Design, Html and Preview modes, Statistics module and resize handle.
    It contains RadEditor's Modes/views (HTML, Design and Preview), Statistics and Resizer
    Editor Mode buttonsStatistics moduleEditor resizer
      
    RadEditor's Modules - special tools used to provide extra information such as Tag Inspector, Real Time HTML Viewer, Tag Properties and other.