MRP Excel Spreadsheets: Noah Labor Scheduling - for Job Shops, Fabricators, Service/Repair Shops...

Noah is a high performance planning and scheduling offering for Job Shops, Fabricators, Service/Repair Shops, and others where customer service and shipping on time is vital. Noah will enhance the effectiveness, efficiency and consistency of your Workcenter based planning and scheduling, including cycle time reduction. Noah features an easy-to-use method to enter resource definitions, then to build/define jobs, or projects, with additional considerations such as labor and workcenter operations and routings. Next, Noah allows you to perform 'what-ifs' with different plans -- resulting in feasible and effective production schedules.

Noah Resource Manager

Simple, familiar interface
One step menus, on-screen buttons, or sheet tabs make navigation a snap.
Easy to configure and run
Quick, intuitive layout and prompts allows you to focus on your business, instead of learning another software product.
Finite capacity planning and forward scheduling
Global and/or detailed workcenter configuration can be made and applied instantly.
Integrates with virtually all systems
Easy cut-n-paste or direct file linking (DDE, ODBC, SQL, etc.) to exchange data with any system.
Powerful and Extensive Reports include:
- Routing
- WIP
- ERD (Estimated Release Date)
- ThroughPut
- Backlog
- Exception based tracking
- Shipping

What Noah does, better than any other system on the market today, is enable you to more effectively plan and execute your company's production requirements. Quickly define all of your labor and workcenter resources and build jobs. Easily include time estimates and sequence of operations. Print out reports summarizing what needs to happen, when, and what quantity.

Is there a problem meeting the schedule date? If so, delay the Job with a click. Need to change priority and reschedule? Simply reschedule in new order and let Noah take care of the details.

Noah: How dows it work

The most common processing of the Noah system works in three simple stages:

Default & System Definition
The first stage consists of default definition., including: Global daily defaults, Holidays, Workcenters defined, and exceptions list (for automatic reporting on delays at workcenters).

Build & Schedule Jobs

Then Jobs are 'Built' with Customer name, Job Number, start date, and a super easy method for sequencing workcenters. Next, the newly built Jobs are sequenced and schedules are created.

The user has the freedom to try various quantities, with alternate start dates, and view the resultant summaries of resource requirements and schedule dates. It is in this phase that capacity constraints are revealed -- as well as when labor and machine resources should be scheduled.

Each schedule can either be viewed on screen or printed. The result of this second phase is an accurate production plan start and stop dates, and critical time path to successfully meet due dates.

Execution

The third and final stage consists of using and reporting on the schedules created in stage two.

By design, Noah does not require updates to actual schedule - but allows you 'by exception' to flag jobs that are delayed and report on the cumulative effects of all delays.

When the exceptions (or any other event) warrant that some Jobs need to be rescheduled, Noah features an easy single click method to remove one or more Jobs from existing schedule, arrange new priority, and reschedule. Easy shipping and comprehensive reporting round out the Noah system.

Noah Reports

The dynamic screens that display the visual schedule in Gantt Chart format, along with the Resource Loading Chart that shows a color coded key to hours loaded and hours available by Workcenter by Day, are the key interfaces for daily interaction with the Noah system. These two screens are automatically updated by the Noah system anytime a schedule is generated or changed.

In addition to the live schedule and resource loading, Noah contains several easy-to-use and intuitive reports to convey important management and system information.

The reports are run from the menu bar, and once run, can be accessed directly and instantly by worksheet tabs. All reports feature an easy to read standard layout, printing, and graphing. In addition, the user has full access to perform any custom formatting on cells, rows and columns using the standard options off Excel Format menu.

Defaults Report

This report shows the Capacity Defaults for each workcenter per each new configuration date.

Routing Report

This report may be run for either a single Job, or a batch of Jobs as indicated on the Menu. This easy to read report can include a custom graphic and displays the job sequence, time at each workcenter, and estimated Job completion date.

WIP Report

This report, with a default of today's date, generates a listing of Jobs by workcenter including, date in, hours remaining, date out, and the previous workcenter. Any 'delayed' Jobs will be displayed. The WIP Report can be run for any day.

Projected ERD Report

This report shows the estimated ship date for all jobs, which have not yet shipped.

Pareto Charts: A Pareto chart showing the names of Exceptions cited for delays in start dates of jobs is available on the ERD Report sheet.

Workcenter Throughput Report

This report shows the number of Jobs which pass through each workstation each day.

Utilization Report

This report, uses the same format as the Throughput Report and shows performance data of utilization combined with backlogs per workcenter by day.

Exceptions Report

This report compiles a list of exceptions, the time delayed of each, and the total number of occurrences and average time delay for each exception type.

Backlog Report

This report shows performance data on Jobs which have been shipped. A Pareto chart, showing the frequency of standard Exceptions cited in shipping delays, is available on the Shipping Report sheet.

Job Interruption

The sheet includes a chart of five columns labeled, Job ID, Workcenter, Interrupt Date, Resume Date, and Comments. During scheduling, any Job that is interrupted at a work center (because a higher priority Job has already been scheduled there in the midst of its multi-day processing period) will be listed on this chart.

Freezing a Job at a Workcenter during Rescheduling

To allow for an accurate, up-to-date schedule, the user can now call up any Job and update when complete. This new feature, called 'freezing a Job at a Workcenter' enables the user to track exactly when a workcenter has completed a job and then is able to reschedule Noah.

To freeze the job at a workcenter select a workcenter in the sequenced workcenter list and click on the Freeze button. The calendar form will appear, with the workcenters current end date selected. The user may select another date and the change will immediately be written to file; it is not necessary to save the form afterwards. The selected workcenter name now appears in the textbox under the freeze button.

Rescheduling Noah containing jobs with a frozen workcenters locks in the hour assignments in the resource calendar for workcenters previous to and including the frozen one. Then, the remaining workcenters are rescheduled according to priority order, capacity available, etc. The user can also unfreeze the job by clicking on the freeze button which is now titled "unfreeze" when the job has been unscheduled.

In summary, with the new Priority List, Advanced Workcenter Tracking, and ability to Unschedule and\or Reschedule any Jobs with a click of the mouse, Noah WS will exceed your expectations for a planning and scheduling system that is powerful, accurate, and easy-to-use.

Noah WS now combines the quick planning capabilities with the ability to track actual Jobs, define priority lists, and reschedule as necessary to adjust to actual day-to-day interruptions to planned schedules.

Spreadsheet Scheduler includes a simple approach to Project Management and a quick method to generate Gantt Charts. It can be thought of as a ‘lower end Microsoft Project".

Resource Manager for Excel is User Solutions’ most popular package, offering a general purpose, flexible and adaptable approach to manage materials, workcenters, and labor for most manufacturers. It includes BOMs, MRP, Finite Capacity planning and scheduling, inventory, purchasing and receiving, costing, really just about everything for manufacturing management EXCEPT accounting,

Noah 2000 is a customized version of Resource Manager for Excel and focuses on forward scheduling, finite capacity, for jobs configured to run with a estimated number of hours per step. Noah 2000 allows the user to define independent workcenter calaendars, manages queue time, and is geared toward generating a realistic completion date and managing Jobs to meet the completion date.

In looking at you info on the web, it appears that each task can be scheduled, and Estimated hours entered for each function, and actual hours then placed against each function. If this is true then reports can be generated as to remaining time for each function for each task. Is this the capability of the system? Also can data easily be extracted to excel format to create our own reports?

This is Excel based application. Actually -- you can do all that with our Resource Manager for Excel product. Noah does not allow an update (actaul hours) and balance. Just scheduled with original estimate only.

For over 12 years User Solutions, Inc. has been the easy choice for thousands of companies worldwide!

Buy User Solutions Noah Workcenter Scheduling for Excel - flexible scheduling tool. New generation is choosing Excel based solutions! We are one of the world leading Excel based software developers. In addition, our technical support is the best you will find anywhere.

We offer full credit on any upgrade. For example, you may purchase now single user license and upgrade it later up to multi user license. Also you may now purchase the Noah Workcenter Scheduling and upgrade it up to Resource Manager for MS Excel (if you will need this upgrade, we have customers that fully satisfied with Noah Workcenter Scheduling).

Please note that Noah Workcenter Scheduling is complex system, and the price includes intensive email and phone support.

Additional Information: Noah Workcenter Scheduling
Requires : Excel 97 or above or MS 8 (97) or above	Buy Online
	$490 single user. Multi user License available for $980