6.  SCHEDULING: Order Entry

Resource Manager for Excel

Well Done!  We have now covered the key parts of initialization and are ready to deliver the core benefits – scheduling and reporting.   

After BORs have been defined, the Forecast sheet is ideal for order entry, master planning, generating ‘what-if’ scenarios, and maintaining the master schedule.  

Action Step: Press [F4 - Initialize Forecast Calendar – DO IT].

scheduling.gif (10465 bytes)

Select [Yes] to default of today’s date as start date.

scheduling1.gif (2819 bytes)

[Days - OK] as forecasting period, and

scheduling2.gif (3005 bytes)

default of [30 - OK] as number of time periods [OK].

scheduling3.gif (2913 bytes)

 

All products, jobs, etc., that have a BOR will be listed under Product Number and Name columns.  Note the series of dates (up to 185 time periods -- days, weeks, or months) running across the top of the scheduling matrix.

forecast.gif (10672 bytes)

Action Step: Enter schedule quantities of 1000, 1500, and 2000 for the Ball Point Pen in the first few cells.  (Note that since the dates are different, the screen capture examples, from here on out, may not match exactly with your data).  

Very Important!  The Forecast Input Table is THE most important part of Resource Manager.  From this ONE screen, you can drive your complete schedule.  All your orders, when due or when to start, can be scheduled and/or rescheduled based on changing conditions, at any time.  In addition to quantities, you can also enter a custom Job Number, Work Order Number, or Sales Order Number, etc. (check general options).  You can even import in the demand schedule from outside systems (import button) and prioritize jobs (sort button). 

In addition to filling out the Forecast Calendar, as above, where all products can be scheduled in a batch, RM also supports a very powerful Order Entry function that manages multiple line items for a particular customer.  This is accessed via the Order Entry function and, in combination with the Sales Report, provides covers orders from entry to shipping.

The ability to manage your entire operation, from a simple top level approach, is what sets Resource Manager apart from all other manufacturing software offerings.  You can truly run things in Cruise Control fashion and realize the quickest benefits.    

Got changes?  Make them at the top level, on one screen. Instantly generate a new schedule.  No longer do you have to be a slave to a rigid manufacturing system.  

With Resource Manager Cruise Control Software you will always stay in control! 

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