RM-DB - the full MRP system except an accounting
Resource Manager-DB 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.
We are pleased to offer two versions of Resource Manager for your consideration:
RM-X is an add-on to Excel (version 97 and greater) and is designed for single concurrent users who are familiar with Excel.
Resource Manager-DB (RM-DB),
An elegant rewrite & upgrade, written in Visual Basic, utilizes a runtime version of Microsoft Access Database (MS Access not required). Resource Manager-DB contains the functionality of RM-X, plus many more enhancements. Resource Manager-DB features a special version of RM-X for a report output option.
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-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.
Immediate, GUARANTEED Benefits
Resource Manager-DB delivers the help you need to effectively plan, schedule, and track 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-DB adds powerful 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-DB runs with Microsoft Office, so you are already familiar with entering data, printing reports, graphing, and more!
Note item 1 on the Scheduling (1) Tab - Schedule according to Forward or Reverse Order. Forward Order indicates that when scheduling your products, jobs, etc. you will be providing a start date, and RM-DB will calculate the finish dates (subject to capacity restraints, inventory levels, job priority, etc.). Reverse Order indicates that you will provide a finish date, and RM-DB will calculate the start dates. All of these options may be adjusted as you find necessary; the defaults are just initial global settings.These options can be changed at any time, even on a per Job\Order basis. This allows for virtually any combination (i.e. estimated Jobs entered as Forward, firm orders as Reverse) to co-exist in the system.
For capacity planning and scheduling according to workcenter/operation hours, you can tell the system what hours you normally work per day and a list of holidays.These global settings are done in the Daily Hours and Holiday sections.
In a later section [View Resources Calendar] the user can configure detailed calendars. Each Workcenter can have its own, unique, working day calendar that can be adjusted upon demand.
The Daily Chart, like the rest of the configuration options throughout Resource Manager-DB, may be changed at any time, with the updates being applied to the NEXT scheduling event (new or reschedule). This enables you to schedule a mix of options (hours available, forward or reverse, resources available, etc.) for different Jobs.
The Product List contains raw materials, other vendor related items, sub-assembly and end product listings. All Products, with a Bill-Of-Resource associated with it, are denoted with asterick * and listed on top. The Add/Edit Products form also contains Inventory Parameters and allows direct inventory transactions.
Side note regarding Data Import: Normally, the VERY FIRST step in configuring Resource Manager-DB is to determine if ANY needed data exists in ANY system.
Check out the Data Import Function for a summary list of just some of the data we can automatically import. Then, call us and/or send samples of your existing data and we will be glad to show you how to easily integrate Resource Manager-DB with most any system.
The possibilities are tremendous. We can import BOMs and add routings on the fly, import open sales orders and WIP data, run what-if reports, even closing the loop by writing back (to other system) to adjust schedule dates.
General workcenters, labor, resources, machines, work cells, etc., are maintained here. Workcenters / Operation descriptions can be defined here, or made specific in the BOR.
This list contains resources that consume hours and will be scheduled subject to the hours per day available, and hours required. The Number Available (also referred to as RESOURCE MULT) is how many of that resource you have. This number (which can be less than one) is multiplied by the hours in the day chart, to configure the initial available capacity for each Workcenter. It also can defined per Job/BOR. In our example, we have 16 hours (Res. Mult. = 2 X 8 hrs. /day) available for Assembly and 8 hours for Inspection. The initial available capacity is displayed in the Resources Calendar and can be edited directly for individual Workcenter calendar definition.
The Bill-of-Resource (BOR) is the configuration of the Products and Operations that make up your finished product, Job, or project. To create a BOR simply select components off of the Products & Operations lists, however you wish, allowing for concurrent scheduling of Workcenters and Materials. Building a BOR for your particular product configuration is easily done with the complete production version of Resource Manager-DB. We recommend that you call US today to answer any questions that you may have about constructing a BOR that accurately models your processes. For this tour, we will just view an existing Bill-Of-Resource (BOR) for a Ball Point Pen.
The Header area contains important summary information about the current BOR. Choose Existing Products allows user to view/edit existing BOR (as in our example, denoted by asterisk), or to choose a Product for Building a New BOR. The Lead Time, for the End Item, is extra days added for final processing (shipping, etc.) once all sub components are done. The Cost (for one unit) is a total of all sub component costs. Estimated Days to Complete is how many days it will take to manufacture the End Item. This will be adjusted by all capacity restraints when scheduled. Revision Level, Freeform Notes, and Flow Transfer Size complete the top-level fields.
GREAT FEATURE: Throughout RMDB, you may notice a gray RUN button. This feature, configured initially under options, allows the user to call an external program and automatically pass information. For example, you can include a path and file name, for an Autocad Drawing, and click on it to automatically run Autocad and pull up drawing. Or, use it to connect to Vendors Website.
GREAT FEATURE: If you need to build a new Job, Product, etc., and you haven't listed the End Item in Product List yet, simply press the Add New and add it on the fly! You can use any existing BOR as a template for the new, or quickly add sub component products, sub assemblies, and operations from scratch.
The Subcomponent Grid contains a list of all the products and operations that go into making the End Item. The Next In Sequence Number is what the Product goes into, or what follows after an Operation.
For example, in the diagram, all the products on the left have Assembly as the Next In Sequence, while Assembly has Inspection as Next In Sequence, and finally, Inspection has the end product/end item Ball Point Pen as the Next In Sequence.
As Products and Workcenters/Operations are added to BOR, default data as defined in Product and Workcenters /Operations lists will fill in automatically. These can be edited directly for setting BOR specific parameters.
Required entries are formatted in Red. Editable fields include: Set-Up and cycle times for Operations, Lead times, Quantity required, and Vendors for Products, Costs and User Fields.
Advanced options are included under the [Configure] button for each line item.
The options for Auto Connect BOR items and Prompt for Num Required are further tools to help automate the building BOR process.
Action Step: To add items to a BOR, simply double click or F2 on first cell of blank row. Choose existing Product (ABC-123), or Operation or ADD (new Product or Operation) ON THE FLY! Enter Number Required (1), and press [Save]. Congratulations!
To delete a row, click arrow on left, to highlight entire row, and press Delete Key on keyboard, or Delete button.
To change visual sequence, edit Sequence Number and double click on Sequence Number Header. GREAT FEATURE: Most Grids in Resource Manager-DB can be instantly sorted by clicking header. Left click is ascending, right descending.
Well Done! We have now reviewed Initialization up to Build/Edit BORs and are ready to deliver the core benefits scheduling, tracking, and reporting.
There are several options available to enter demand (orders) and schedule.
Thetop section of the Order Entry/Sales Order form contains various filters to view orders.
All orders found are listed by Reference Number, which allows you schedule multiple line items all tied to a common reference number.
The line items, for an Order, are displayed for edit (or new entries).
Great Feature! The Order Entry area is an excellent place from which to run Resource Manager-DB. You can manage all of your forecasted demand, actual orders, when due or when to start, etc. You can also enter a custom Job Number, Work Order Number, or Sales Order Number, etc. You can even import in the demand schedule from outside systems (import button). Finally, you can view and edit the details of any BOR, even adding new Jobs, Products, and Operations, on the fly -- all from Sales Orders.
Printing Sales Orders offers the same features as printing BORs, Purchase Orders, etc. That is, you can customize the format and fields to be included and send to Rmrpt.xls, and/or print a hard copy.
In the Rmrpt.xls, you can further customize adding logos, user defined fields, on-the-fly calculations, freeform notes, etc.
In addition to the Job specific schedule feedback option, the user can adjust any one or more of the following parameters, before Rescheduling.
Daily Chart to change hours available across all workcenters.
Resource Calendar to adjust hours for specific workcenters for specified dates.
Resource Multiplier for how many resources are available.
Inventory adjustments and corrections.
Purging schedule of some Jobs (which then can be edited as necessary at the sales order level).
GREAT FEATURE! Many of these options are inclusive on the Master Scheduling Grid for a single screen, cruise control, operation of the entire schedule.
Great Feature! Resource ManagerDB features MS Excel as its report writer. There is no better environment for quick and powerful customized reports than what is possible in Excel. Please see Resource Manager for Excel for a list of reports generated and more details.
Hopefully, you see good potential for Resource Manager-DB to help you with your planning and scheduling needs.
User Solutions, Inc., has announced beta availability of Resource Manager-SQL. Now, users have a choice between database platforms for the popular Resource Manager product. The standard offering includes a Jet Engine run time database (same format as Microsoft Access). The new version runs with Microsoft SQL Server 7 is designed for companies with more than 10 concurrent users and / or extensive data processing requirements.
Requires Windows XP / 2000 / 2003 Server / NT / ME / 98
and Microsoft Office 2000 or above
Resource Manager DB is supplied as an upgrade to Resource Manager for Excel.
Please note that the price includes intensive email consultations as any MRP - complex system.
No any risk! We offer free 30-day money-back guarantee!
Additional Information: Resource Manager DB
|RM-DB ranges from $4,900 - $7,400. The multi-user version is 2 times single user cost. Reports require Excel 97 or greater.|
We offer full credit on any upgrade.You may purchase any edition of Resource Manager for Excel now and upgrade it up to Resource Manager DB later ( if you will need this upgrade).
Note: Resource Manager for Excel allows only one concurrent user. Resource ManagerDB - up to 4.
Additional Information: Resource Manager for Excel
|FULL edition - $2400+|
|BOR edition (without forecasting and planning) - $600+||Buy Online|
|FORECASTING edition - $1,200+||Buy Online|
|PLAN edition - $1,800+||Buy Online|
More Business & Finance Software
Software for MS Excel (Accounting Analysis Budgeting Calculators Cars Charting Checks Converters E-Books Finance Forecasting Employment Inventory Investment Management Marketing Planners Project Management Quality Control Schedulers )
MS Excel Add-ins, Spreadsheets, Templates
Copyright © Millennium Software All Rights Reserved