3. Scheduling in Excel : Holiday and day chart

Resource Manager for Excel

For capacity planning and scheduling according to workcenter hours, you need to tell the system what hours you normally work per day and a list of holidays when no work will be performed.  This is done in the Holiday & Day Chart portion of the program. 

mainholiday.gif (10344 bytes)

Action Step: Press [F4 - Holiday & Day Chart - GO] to review/edit Holiday & Day Chart.   Click in the cells and directly edit Sat-Sun hours to equal 0.

This chart, like the rest of the configuration options throughout Resource Manager, may be changed at any time,  with the updates being applied to the NEXT schedule processed.  This enables you to schedule a mix of options (hours available, forward or reverse, resources available, etc.) for different Jobs. 

holiday1.gif (9125 bytes)

Note to Job Shops, Make-to-order manufacturers, contract manufacturers, etc.  The remainder of this 12 Steps to Success uses sample data for a standard product (a  common ball point pen).  This is just for an example of how to touch on each part of the system – and not how you would necessarily set-up and run Resource Manager for your operation.  For example, you can start directly with your existing custom spreadsheet, or data from any other system, and paste directly into Resource Manager.  

Order

No any risk! We offer free 30-day money-back guarantee!   

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+

Buy Online

bbuy.gif (1202 bytes)

BOR edition (without forecasting and planning) - $600+

Buy Online bbuy.gif (1202 bytes)
FORECASTING edition - $1,200+ Buy Online bbuy.gif (1202 bytes)
PLAN edition - $1,800+ Buy Online bbuy.gif (1202 bytes)

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

6. Scheduling of Orders

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

Business Software

MS Excel Add-ins, Spreadsheets, Templates