Resource Manager For Excel

Resource Manager for Excel (RMX) offers MRP and Shop Scheduling on a flexible and powerful platform. Ambitious Operations Management students can use RMX to gain valuable hands-on experience in mastering important skills in many areas of Manufacturing Planning, Scheduling, and Execution.
With RMX supporting up to a million rows of data, and with Excel 360 fully cloud compatible, you can even tackle big data applications and share results on the web. A fully functional free trial is available for immediate download with access to user manual, quick start tutorial, and a full set of training videos.
Keep US in mind when you are fully engaged at work and looking for tools to improve your production scheduling. Resource Manager-DB is a wonderful upgrade of RMX and is a strategic complement to other plant systems for APS and MES applications.

RESOURCE MANAGER FOR EXCEL: SUMMARY

Resource Manager for Excel (RMX) features a Bill Of Resource (BOR) that allows any combination of Workcenters and/or Products.   RMX is ideal for companies who have no formal systems (ERP, MRP, etc.) as tool to plan for and implement those systems, or to use to fill in any existing gaps for production scheduling.  With the BOR concept,  you can manage both Material Requirements Planning as well as Production Planning and Scheduling considering Finite Capacity..  For those applications that have a need for multiple concurrent users, improved security (over Excel),  seamless integration with other systems, and advanced planning and scheduling options, Resource Manager-DB (RMDB) is the best choice. 

“Adaptable and Flexible”Resource Manager for Excel is a great solution for manufacturers who are not ready for a full-blown MRPII, ERP, or Shop Management System but realize the value of effective scheduling and planning.  Resource Manager for Excel is unique in that it easily adapts to the way people are running their business today”.  Mike Parks, Director of Georgia Tech’s CMIT, an affiliate of the NIST Manufacturing Extension Partnership.

Features

  • Excel add-On
  • Routings and Job Scheduling
  • Finite Capacity Scheduling
  • Forward & Reverse Scheduling
  • Bills-Of-Material
  • Robust Routings
  • Basic MRP (Material Requirements Planning)
  • Large data model support
  • Powerful and fast scheduling engine

Student Free Trial

Resource Manager for Excel: In Depth

Overview

Resource Manager is the only low-cost, planning and scheduling solution that works for all manufacturing enterprises. There are two versions available, depending on your needs:

Resource Manager for Excel (RM-X) RM-X is an add-on to Excel (version 97 and greater) and is designed for single concurrent users who are familiar with Excel. A fully functional trial is available for immediate download.

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

Also, Resource Manager -DB (RMDB), an elegant upgrade from RMX, written in Visual Basic, utilizes and includes a run-time version of Microsoft Access database and is also available with SQL Server compatibility. Resource Manager DB (RMDB) contains all the functionality of RM-X. Just like RM-X, Resource Manager DB leverages Excel for reporting.

These combined offerings 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 guarantees the power and productivity of high-end systems without the complications and failure rate.

Works The Way You Do

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

Immediate, Guaranteed Benefits

Resource Manager delivers the help you need to effectively plan and schedule your company’s resources, without the time, money and upkeep of traditional options.

Finally, you can quit struggling with time consuming decisions such as what to buy, what to make, when to buy it, and when to make it.

Resource Manager adds powerful MRP scheduling, planning and/or tracking capabilities to your existing system (be it manual or other), for less than any other option – satisfaction guaranteed.

Best of All

Resource Manager runs with Microsoft Office, so you are already familiar with entering data, printing reports, graphing, and more!

Features

  • Finite Planning & Scheduling
  • MRP and Inventory Management
  • Routings and Priority Scheduling
  • Easy “what-if” analysis
  • Purchasing and Receiving
  • Forecasting
  • Costing and Estimating
  • Integrates with ALL systems
  • APS and Lean Manufacturing
  • Ideal for Lean Manufacturing
  • Run stand alone or networked
  • Production Planning

Fill’er Up

Resource Manager for Excel offers basic copy and paste for loading data, or form driven data entry.

Check the “MAP”

Where do you need to go? Which orders need to be shipped when? Resource Manager features a simple, single, screen 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.

Only Resource Manager gives you quick and easy top level control for recognizing the immediate benefits of an integrated manufacturing system

Relax, Cruise Control is on

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. Bottlenecks are easy to spot by the red flags. Run your favorite report to view schedule data the way you like it.

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.

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

Overview

With quick, powerful, and intuitive reporting, Resource Manager-DB stands above the crowd in its ability to present 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 permantent 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.

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.

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.

Calendar Report

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

Workcenter 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.

Routing & Tree Reporttree

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

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.

Purchasing & Receiving

Resource Manager-DB excels with its integrated purchasing and receiving module. Designed to porptmeet meet the tough requirements for Lean Manufacturing, you won’t find any muda here. With a single click, the user can generatepurchase orders per Kanban andor 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.

Celebrating 25 Years of Award Winning Software!