Software : MRP Systems : MRP Excel Spreadsheets: Resource Manager for Excel
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.
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.
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.
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.
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.
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.
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.
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, and more.
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" |
System Requirements
MS 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).
Order
For over 12 years User Solutions, Inc. has been the easy choice for thousands of companies worldwide!
30-day money-back guarantee!
Please note that the price includes intensive email consultations as any MRP - complex system.
Additional Information: Resource Manager |
||
| FULL version - $2,400+ |
Buy Online |
 |
| BOR version (without forecasting and planning) - $600+ |
Buy Online |
|
| FORECASTING version - $1,200+ |
Buy Online |
|
| PLAN version - $1,800+ |
Buy Online |
|
MS Excel Add-ins, Spreadsheets, Templates
Copyright © 1996-2005 IovSoft All Rights Reserved