Resource Manager DB: In Depth

Overview

Resource Manager-DB (RMDB) is an affordable, flexible and quick-to-implement approach to help with your planning, scheduling and tracking challenges. Designed by customers just like yourself, Resource Manager-DB features a single, simple menu combined with minimal transactions required to keep system accurate. RMDB allows you to start very simply, focusing on one area at a time, allowing you to provide the minimal information in order to recognize immediate benefits.

With Better Production Scheduling!

With Better Production Scheduling!

If you find you are still using manual white boards and/or Excel for trying to manage your production scheduling, you will find RMDB a refreshing option.  Intuitive and flexible, with easy data integration, we even offer a no-risk, pre-implementation walk-through to demonstrate exactly how the system can benefit your operations.

Since 1991, our vision has been to help you solve common manufacturing and operations management problems in a familiar Microsoft Office environment. We let your requests drive our product line development and the result is the current version of RMDB.rmusman

Resource Manager DB (RM-DB), utilizes a run-time version of Microsoft Access Database or is also available with SQL Server compatibility. Featuring easy integration with Excel, or other systems (ERP, Accounting, Custom, …), plus instant output in Excel, RMDB will provide you unsurpassed flexibility for leveraging Excel on local PCs, and sharing data across a network. Finally, you can achieve your goals of an affordable planning and scheduling solution that quickly adapts to your needs.

By combining ease-of-use for small to medium sized manufacturing operations with powerful reporting and open integration for larger operations, Resource Manager-DB guarantees the power and productivity of high-end systems without the complications and failure rate.

 

Works The Way You Do

Resource Manager-DB is the only solution that is designed to adapt to your specific needs, addressing the key issues facing your operation.

Features

  • Finite Capacity Planning & Scheduling
  • Routings and Priority Scheduling
  • Easy “what-if” analysis
  • Purchasing and Receiving
  • Supply Chain Management
  • Job Costing
  • Costing and Estimating
  • Integrates with ALL systems
  • MRP and Inventory Management
  • Advanced Planning and Scheduling Options
  • Lean Manufacturing
  • Run stand alone or networked
  • Production Planning
  • Lot Management

Fill’er Up

Data Integration with Excel plus ERP Systems

Data Integration with Excel plus ERP Systems

Resource Manager-DB lets you easily work with your current data. Do you have a product list somewhere? How about bills-of-material and/or routings? Sales orders, inventory levels, even work-in-process data. Import directly into Resource Manager-DB and let us automatically fill in the details. You can even maintain this data in other systems, with refresh on demand. Starting from scratch? Resource Manager-DB features a clean and simple way to create master item lists and dynamically create bills-of-resources.

Resource Manager-DB is designed to work seamlessly with Excel.  This provides great flexibility in rapid implementation options as you can load, edit, reload, entire data sets at a click of a button.  Not only for importing data, Resource Manager-DB also provides easy Excel output for reporting.  These output reports can then be round tripped right back into Resource Manager-DB for updating system!

Here is such an example where the user gets a custom report, all in Excel, uses it to easily track production, and its imported back in to update system.

Manufacturing_Excel_Dashboard

Manufacturing_Excel_Dashboard

 

 usmapCheck the “MAP”

Production Scheduling all from one simple menu

Production Scheduling all from one simple menu

Where do you need to go? Which orders need to be shipped when? Resource Manager-DB features a simple, single, menu to control your whole operation.

Enter (or link with outside system), the quantities and due dates. Optionally add detailed customer or order information. Now schedule and view standard plus custom reports.

Resource Manager-DB delivers quick and easy top level control for recognizing the immediate benefits of an integrated manufacturing system.

Relax, Cruise Control is on

Production Scheduling Made Easy!

Production Scheduling Made Easy!

That’s it! You are in the driver’s seat and cruise control is on. Enjoy the view. Check the production calendar for a quick view of finite – capacity loading on work centers and time-phased inventory levels. Double click on any cell to view job details for that day. Bottlenecks are easy to spot by the red flags. Run your favorite report to view schedule data the way you like it.

Production Capacity Loading

Production Capacity Loading

Need to correct a schedule? Quickly adjust working calendar, shift available resources, and click to reschedule. For effortless cruise control of your business, simply make the top level changes and regenerate the master schedule with a click of the mouse. Change delivery due dates, split up quantities, combine forward and reverse scheduling; all the options for a quick adjustment are under your immediate control.

Resource Manager-DB will allow you to run your operation the way you want, with screens and reports designed to provide maximum information with minimal effort.  Here we see an example of a schedule by workcenter, containing all orders, setup times, drag and drop to adjust, even downtime tracking and reporting — all on one screen.

Workcenter Gantt with Downtime

Workcenter Gantt with Downtime

Fine Tuning

Beyond the top-level cruise control, Resource Manager-DB allows the user to implement detailed execution plans at their own pace. At any time, you can:

  • Prioritize job sequence
  • Make inventory adjustments
  • Track receipts
  • Generate purchase orders
  • Regenerate schedule with new priority
    sequence any time
  • Complete inventory management
  • Feedback actual mfg. data
  • Run adjusted net plan
  • Instantly reconfigure and reschedule
    BOMs and Routings to reflect reality

Reporting Overview

With quick, powerful, and intuitive reporting, Resource Manager-DB stands above the crowd in its ability to present

Gantt-Reports by Job, Workcenter, Detail, and more.

Gantt-Reports by Job, Workcenter, Detail, and more.

the important data in an easy and meaningful way. In addition to the robust reports that are included with Resource Manager-DB, the user can easily configure canned, custom reports that become a permanent part of the system. In addition, you can work with the schedule database directly and use all the power of Access and Excel to sort, graph, view, print and export, to meet your unique requirements.

Gantt Report

A great top-level view of all activity with details only a click away. Instantly check the due dates of all jobs in schedule, drill down to find bottlenecks, adjust capacity and schedule to meet critical dates.

Excel-Gantt-Chart

Excel-Gantt-Chart

Summary Report

The report will tell you what you need to buy or make, how much, and when – all consolidated on a single sheet. An instant, top level MRP Report for all products and workcenter loading. View over any time horizon – by day, week, or month.

Production Summary Report

Production Summary Report

Item Report

This sheet summarizes all requirements per part number. Ideal for WorkCenter Loading, the system lists each job, when to start, when complete, and how much is required.

sumrpt

Calendar Report

View and print the schedule in familiar “wall calendar” format.

itemWorkcenter Report

Instant, real-time views of all critical workcenter activity by: daily loading, backlog, % utilization, hours available and bottlenecks. Allows for quick overtime scheduling and other detailed adjustments for any workcenter on any day. Also features a daily workcenter “to-do” list.

 

tree

Routing & Tree Report

Intuitive reports for visual bill-or-resource verification, process flow and schedule feedback.

 

prodrpt

 

Production Report

Perfect for traveler or work order printout. Automatically reconciles inventory and capacity for a job and lists sequence of operations and products to fulfill order on time. Includes space for check off and actual feedback as well as job costing and variance reporting.

porptPurchasing & Receiving

Resource Manager-DB excels with its integrated purchasing and receiving module. Designed to meet meet the tough requirements for Lean Manufacturing, you won’t find any muda here.
With a single click, the user can generate purchase orders per Kanban and\or standard schedule requirements. The system tracks each received quantity, open or closed status, and adjusts inventory – simply and automatically. Automatically e-mail RFQs and POs to vendors.

Special Services & Partners

User Solutions offers a variety of direct services to meet any special needs, including: automatic data integration with other systems, customized reports, on site training and configuration and much more. In addition, User Solutions has partnered with a number of complementary product and service companies to provide complete solutions focused on unique needs.

Back To Top

Celebrating 25 Years of Award Winning Software!