Resource Manager for Excel
The Production Calendar, which is located on the Production sheet, summarizes inventory tracking when the schedule is run through PLAN. The Resource Calendar is located on the Resources Sheet, and provides a dynamic view of all Workcenter hours, summarized by day, required for active schedule. In addition, the Resource Calendar allows for individual workcenter calendar edits, secondary constraint definition, as well as other valuable load reports.
Action Step: Click on Resource Sheet Tab and scroll to the right until you see data. If you are at the Home Position, click the Resource Calendar1 GO Button.
Cells in the Resource Calendar which are "full" (no more processing can be added for that resource on that day) will be formatted with the total in red. This makes it very easy to visually spot bottlenecks.
Action Step: View the resulting load, and when capacity is maxed out (red). See the string of red cells, indicating a bottleneck in O#Inspection!
Let’s try to alleviate our problem bottlenecks.
Action Steps: press [F4 - Holiday and Day Chart - Go]. Increase the hours per day from 8 to 12 and add 8 hours for Saturday.
Action Step: press [F4 - Master Operations List - Go], and change the Resource Mult. for Inspection, from 1 to 2.
Any time that you make changes to the Day Chart, or to the Master Items Lists, you MUST reinitialize the Production/Resource Calendars, in order to reflect the updates in the schedule.
Action Step: press [F4 – Resource Calendar - Do It] answer [Yes] for start date prompt, Then, [YES] to Clear existing resource loading from Resource Calendar, and [YES] for refresh availability prompt, and [OK].
Action Step: [F4 - Master Scheduling - Go] press [Clear] to clear existing schedule [Yes] [OK].
Action Step: Press [F4 - Master Scheduling - Do It], [No] to print BORs, [OK]. Now, we have generated new schedule.
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.
Notice new, earlier, finish dates!
Compare this report with the one previously run. Notice how we have shaved a week off the delivery on several Jobs.
Now, imagine how valuable this kind of 'what-if' and reporting will be to help your operation get better control of managing key resources.
We look forward to working with you and helping you succeed with Resource Manager for Excel.
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