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.
12 Steps to Success
Thank you for your interest in Resource Manager for Excel -- the only MS Excel based low-cost, planning and scheduling software solution that works for all manufacturing enterprises.
We also have a new trail available for Resource Manager - DB, an elegant upgrade that runs with Microsoft Access Database. 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.
1. Requires Windows 95 or avobe and Excel 97 or greater installed and working on stand alone PC or Network (recommend a minimum of a Pentium 200 MHZ with 32 MEG RAM).
2. Have a Basic working knowledge of your spreadsheet:
(entering data into cells, file retrieving and saving, selecting and printing spreadsheet ranges).
In contrast to other shop control, MRP or manufacturing software offerings, Resource Manager does not have a rigid, standard procedure for every application to follow. Rather, Resource Manager is designed to adapt to your requirements. You will NOT have to change the way you work today to recognize significant benefits with Resource Manager. Since Resource Manager is based in Excel – all the flexibility for managing data in Excel is inherent in Resource Manager. Exporting, importing, formatting, graphing, custom reports -- there are no limits for customizing Resource Manager for your application.
There is a simple three-step process for basic running of Resource Manager for Excel:
The remainder of this 12 Steps to Success will give you a tour through each of these areas: Initialize, Schedule, Report. As the system diagram shows, you can exchange data with other systems at any point in the Process
Next, using Windows Explorer, double click on the RMX-???.zip file to unzip all files (xls, help, and this doc file) to directory of your choice, for example c:\usrm.
Now start Excel and click on File, Open, c:\usrm\RMX-???.xls. If you have the Resource CD, simply choose to Look In the CD drive, under the eval folder, and select the RMX-???.xls file.
If you are prompted to enable macros, click [enable macros].
Important
1. Screens are sized for 600X800 resolution. If you have a higher resolution, you will see more of the spreadsheet.
2. To move over columns use the cursor keys or mouse (Tab Key is reserved to move full screen).
3. For now, DO NOT ‘space’ or type over cells with data to edit or delete data (use Purge, add new, error checking and other standard RM commands).
4. When transferring data from outside RM to inside RM use Edit, Paste Special, Values.
5. DO NOT use the Print Icon on the main Tool-Bar. Use the RM Print Buttons, OR, File, Print, Selection.
UP AND RUNNING
There are several resources to ensure a successful start, including:
1. Call US at (248) 486-1934 for a "walkthrough" based on your requirements. Due to the flexibility of the product, there may be more than one way to address your application. This is why we encourage you to give US a call and let us summarize how to run Resource Manager to meet your specific needs.
2. Follow these 12 Steps to Success w/ Sample Data.
3. Printed manual and on line help. Note: The first time you run Resource Manager Help,(via button or from Help on Menu) you may need to tell the system where the help files are (default is c:\usrm). Call us if you can’t find any Help files and we will e-mail them to you.
4. Quick Tips: Throughout the program, a red triangle in the corner of a cell indicates a quick tip comment. Simply run your cursor over this cell to read the Quick Tip.
[ACTION STEPS]: Throughout this 12 Steps to Success, there will beAction Steps that you can use to get a feel for the system. The Action steps include actual RM commands in [bold square brackets].
Note: When you enter data into a cell – sometimes you need to click outside the cell before you can process data.
Action Step: Run your cursor over the Quick Tips (red triangle in the corner of cells).
|
I. INITIALIZATION |
II. SCHEDULING |
III. REPORTING |
| * General Options | * Schedule Single Jobs | * Gantt Chart |
| * Holiday & Day Chart | * Initialize Forecast Calendar | * Item Report |
| * Master Product \ Workcenter Lists | * Master Scheduling | * Summary Report |
| * Production Calendars | * Initialize Inventory Table | * Routing Report |
| * Vendors | * Initialize Job Planning | * Tree Report |
| * Customers | * Master Adjusted Schedule | * Production Report |
| * Build Bills-of-Resource (BOR) | * Purchase Orders | * Calendar Report |
| * Purge Menu… | * Rerun Adjusted Schedule | * Invoice |
| * Sales Report | ||
| * Shipping Report |
Order
You may purchase now single user license and upgrade it later up to multi user license. Also you may now purchase the Resource Manager for Excel and upgrade it up to Resource Manager for MS Excel & MS Access later ( if you will need this upgrade).
Please note that MRP is complex system, and the price includes intensive and fast MRP consultations from one of best MRP system developers in the world.
Additional Information: Resource Manager for Excel |
||
| FULL edition - $2,400+ |
 |
|
|
BOR edition (without forecasting and planning) - $600+ |
Buy Online |
|
| FORECASTING edition - $1,200+ | Buy Online |
|
| PLAN edition - $1,800+ | Buy Online |
|
Additional Resource Manager for Excel Information
1. Resource Manager for Excel Overview
2. Scheduling in Excel - capicity, inventory, job
3. Scheduling in Excel - holiday and day chart
4. Production Planning in Excel
5. Scheduling of Bills of Resources
7. Master Schedule - track of production and goods
8. Forward Job Scheduling - Gantt Chart Reporting
9. Production / Resource Calendar
10 Routing, Tree, Item and MRP Summary Reports
11 Profuction & Job Report, Calendar Report
12. Sales, Shipping & Invoice Reports
13. Inventory, Purchasing & Tracking
