Resource Manager for Excel
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.
Action Step: Press [F4 - Gantt Chart - Do It], [Yes] to start and end date defaults. Choose [Weeks] [OK] for reporting period then [NO] to split window.
Since we had forward scheduling set all of our jobs appear to start in the same time frame. They finish at different times based on the capacity restraints.
Action Step: View the report, notice how even though we scheduled all Jobs to start in the same week, the later Jobs are being pushed out. Observe the Job Number for the 1500 Ball Point Pens. Click [Expand] and select the Job where we had scheduled 1500 Ball Point Pens [OK] to drill down. [Yes] to split window for viewing.
Action Step: View Gantt Expansion, notice how the 25 hours for O#Inspection is the variable that is causing the Jobs to be pushed out farther and farther. The cross hatched format means the Workcenter is in use and can't start yet. It is taking this Workcenter over a week to fit in 25 hours.
So, by running a quick schedule, and the Gantt Chart, we can see what our reasonable finish dates can be. But what if the system-generated schedule times are not good enough?
In the next section, we will increase the hours available per day, and add a Saturday, and see what the new dates are. We can also change the number of resources that are working, change priority of how Jobs are scheduled, change from forward to reverse scheduling, all from the single forecast screen. Then generate a new schedule and report as well.
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