Software : MRP Systems : Resource Manager - Overview 1/3

User Solutions, Inc

five_stars.gif (379 bytes)

Resource Manager for Excel - integrated solution allowing critical resources such as manpower, materials and work centers to be effectively managed in near real-time. Works with bills-of-material, routings, sales orders, inventory levels, work-in-process data, and more.


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 (if you are not familiar, please see the full Microsoft Excel Courses).

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 include: 

Fill'er up!

Resource Manager is the only system that lets you start with your current data. Do you have a product list somewhere? How about bills-of-material and routings? Sales orders, inventory levels, even work-in-process data. Plug directly into Resource Manager and let us automatically fill in the details. Starting from scratch? Resource Manager features a clean and simple way to create master item lists and dynamically create bills-of-resources.

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 allows the user to implement detailed execution plans at their own pace. The PLAN module uses schedule data to:

With quick, powerful, and intuitive reporting, Resource Manager for Excel 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 for Excel, 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.

Resource Manager Reporting

Gantt Report

The Gantt Report is the perfect, top-level report.  It shows all of the Jobs in the schedule, when they started, how many were scheduled, and when finished.   The Gantt chart is helpful to spot bottlenecks – as you can glance at the overall cycle time for any Job and then drill down to discover which workcenters are causing the delays.

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 organizes the schedule and lays out all transactions, by Product and Operation, in an easy-to-read block format.   A simple report for time-phased purchasing or for Workcenter to-do reports.  Read as is, paging down to find product\operation of interest or click on the ITEM Button and print out, graph, and or view instantly. Each block lists item requirements, Job number, dates (including time-of-day start times and end times) for all entries in the schedule.  The Item button allows you to view, graph, or print out data on any one of the products shown in the item report.

Calendar Report

This report, which is on same sheet as Item Report, is a popular tool to display the schedules in the familiar 'Wall Calendar' format.  It is easy to highlight a single day or week and print.

Routing Forecasting Report

This reports on any one or more Jobs with Routings (Operations steps).  When run from PLAN SCHEDULE (described later – now our schedule is in FORECAST) the report also contains easy update-to-actual fields for all operations – including piece counts and hours.  This report is easy to export over network, then updated directly, and imported back in. 

Tree Forecasting Report

This reports on any one or more Jobs with Routings (Operations steps).  When run from PLAN SCHEDULE (described later – now our schedule is in FORECAST) the report also contains easy update-to-actual fields for all operations – including piece counts and hours.  This report is easy to export over network, then updated directly, and imported back in. 

Production Forecasting 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.

More Reports

Resource Manager for Excel also allows to create Sales Report, Shipping Report & Invoice.

New: Advanced Planning and Scheduling (APS) Module

   Resource Manager for Excel new APS Module features detailed workcenter calendars that can be adjusted at any time. Now, inevitable labor fluctuations, workcenter downtime, and unexpected material shortages can be immediately accounted for, allowing the user to regenerate a schedule with new priorities - on demand. A secondary constraint has also been added, which permits Finite Capacity Scheduling, in either forward or reverse mode, subject to both machine and labor constraints. In addition, a Flow Manufacturing option has been added, allowing for variable transfer sizes for workcenter processing. New reports, which can be generated, sent, and received via e-mail, Palm-Pilots, and over networks, are ideal for communicating key portions of the master schedule, as well as receiving feedback directly to the main program.

New: Data Integration Wizard

To facilitate seamless integration with other systems, Resource Manager for Excel offers a new Data Integration Wizard to assist clients with reading in Bills-Of-Materials, Routings, Orders, Inventory Levels, and more from a variety of ERP Systems, including: MAPICS, JD Edwards, SAP, Macola, and many more.

Press Realeses


What is the difference between Spreadsheet Scheduler, Resource Manager for Excel, and Noah 2000?

Spreadsheet Scheduler includes a simple approach to Project Management and a quick method to generate Gantt Charts. It can be thought of as a ‘lower end Microsoft Project".

Resource Manager for Excel is User Solutions’ most popular package, offering a general purpose, flexible and adaptable approach to manage materials, workcenters, and labor for most manufacturers. It includes BOMs, MRP, Finite Capacity planning and scheduling, inventory, purchasing and receiving, costing, really just about everything for manufacturing management EXCEPT accounting,

Noah 2000 is a customized version of Resource Manager for Excel and focuses on forward scheduling, finite capacity, for jobs configured to run with a estimated number of hours per step. Noah 2000 allows the user to define independent workcenter calaendars, manages queue time, and is geared toward generating a realistic completion date and managing Jobs to meet the completion date.


Resource Manager for Excel was selected by NIST (National Institute of Standards and Technology) MEPs (Manufacturing Extension Partnerships) as an ideal planning and scheduling solution for manufacturers just getting started with computerizing their operations.

Readers of New Equipment Digest voted Resource Manager the Winner for Software in the Excellence Innovation.

Only Several Success Stories

ORMS Today "Quick and Easy Excel-based MRP"
Central Gardens "A flexible tool for planning and scheduling."
A.G. Raymond & Co. "Perfect complement to traditional MRP and Shop Control systems"
Assembled Products Group "Phasing out a proprietary, rigid MRP System in favor of the Excel MRP"
Fitzgerald Railcar Services "helpful and resourceful"

Resource Manager Editions Comparison

FULL - All the features

PLAN : RM Full Edition without Orders Sheet

FORECASTING  : RM Full Edition without Planning Sheet, Orders Sheet

BOR (bill of resources) : RM Full Edition without Forecasting Sheet, Planning Sheet, Orders Sheet

Note: Some reports are based on Resource Manager forecasting tools ( forecasting end products, subcomponents, forecast calendar) or planning tools - job planning, inventory, end products, subcomponents planning ( e.g., the production, tree or routing reports are  based on forecasting or planning tools). If you purchase the Resource Manager for Excel without forecasting or planning tool, the report builder can't use the disabled one.

System Requirements

MS Excel 2000 or greater installed and working on stand alone PC or Network (recommend a minimum of a Pentium 200 MHZ with 32 MEG RAM).


For over 12 years User Solutions, Inc. has been the easy choice for thousands of companies worldwide! We are proud to be the partner of world leading software companies - Lotus Development Corporation, Novell, Microsoft.

Buy User Solutions Resource Manager for Excel - flexible Resource Management tool designed for any manufacturing enterprise - and no longer do you have to be a slave to a rigid manufacturing system.  RM - the full MRP system except an accounting.

No any risk! We offer free 30-day money-back guarantee!  

We offer full credit on any upgrade. For example, you may purchase now single user license and upgrade it later up to multi user license. Also you may now purchase the NOAH Workcenter Scheduling or Spredsheet Scheduler and upgrade it up to Resource Manager for MS Excel & MS Access later. Also you may now purchase the Resource Manager for Excel and upgrade it up to Resource Manager for MS Excel & MS Access - our best MRP solution - later ( if you will need this upgrade).

Additional Information: Resource Manager for Excel
FULL edition - $2,400+

Buy Online

bbuy.gif (1202 bytes)
BOR edition (without forecasting and planning) - $600+ Buy Online bbuy.gif (1202 bytes)
FORECASTING edition - $1,200+ Buy Online bbuy.gif (1202 bytes)
PLAN edition - $1,800+ Buy Online bbuy.gif (1202 bytes)

More Info

More Business & Finance Software

font>MRP Systems

Accounting   Business    Finance    Info Managers   Legal   Planners/Schedulers  Business Plan Automation   Project Management    Presentation Tools

Software for MS Excel (Accounting   Analysis    Budgeting    Calculators   Cars   Charting   Checks   Converters   E-Books   Finance    Forecasting    Employment     Inventory      Investment      Management    Planners     Project Management    Quality Control         Schedulers )

Contact Us    Index of Software       Refund Policy       Privacy Policy


Copyright (c) IovSoft 1996-2004 All Rights Reserved