The ETC Hours Display (Estimate to Complete) shows the work assign to resources, pools, or departments from the current schedule start date out 12 months.  When the ETC Hours Display appears, information is not displayed until the Search button is pressed.  The display can be dependent of the selections made in Manufacturing Orders Job Grid if the Use Mfg Orders Job Grid Selections is checked, or selections can be made using the Job Selections button.

Job Selections are made to get a subset of work (projects) using the Job Identification and/or the Part Number.  The entered job identification and/or part number to search for are displayed above the grid after the Search button is pressed. 

When the ETC Hours Display is selected, an empty grid appears as in the example below.  The first month in the column is the month of the last schedule start date.  In the example below, the schedule was run with a schedule start in the month of August:

After Job Selections have been made or the Use Mfg Orders Job Grid Selections is checked, click on the Search button to perform the search.  It may take several minutes for the SQL search to be performed and the mouse cursor is changed to let you know the SQL search is taking place.  During the SQL search the system may appear to be not responding as DMS needs to wait for the search to be completed.  Once the search has been completed, the information is displayed as in the example below:

The following tabs and commands are available:

File

1. Jobs  Select Selections | Jobs to select jobs based on the job header information.  If selected, the Mfg Orders Job Grid is automatically toggles off.
2. Clear Selections  To clear your current search criteria, click on the Clear Selections button.  DMS will confirm the clearing of selections.
3. Search  Click on Search to perform the job search.Print Menu Select File | Print Menu to print a DMS Report as setup by Module Report Settings.
4. Print Grid  Select File | Print Grid to print the current Grid graph. 
5. Export Grid Contents 

 

View

1. Job Columns Reset Select this command to reset all the ETC grid columns widths to the default.
2. Default menu tab

Selections

1. Jobs  Select Selections | Jobs to select jobs based on the job header information.  If selected, the Mfg Orders Job Grid is automatically toggles off.
2. Search  Click on Search to perform the job search.
3. Mfg Orders Job Grid  Select Selections | Mfg Orders Job Grid to toggle on the option to include all jobs that were selected in the Mfg Orders Job Grid in the pie count.
4. Clear Selections  To clear your current search criteria, click on the Clear Selections button.  DMS will confirm the clearing of selections.
5. Group  the Group menu item enables you to group resources into individual resources, Pools or Departments.

Manufacturing

1. New Job to add a new job.
2. Edit Job to edit the first job in the Manufacturing Order job tree.
3. Calendar/Capacity Changes are changes you want to make to the manufacturing calendar such as holidays, planned overtime, planned shut downs, etc.
4. Resources  is used to add, edit, delete resource settings.
5. Schedule Run  Run a global schedule.
6. Job Updating  is used to manually enter detailed time updates to a job.

Other commands include:

Certain types of resources can excluded from the report.  If the drop down menu of Exclude by resource type is selected, the following list appears:

One or more resource types to exclude can be entered.  For example, to exclude all resource types except Labor and Resource the following would be selected:

If resource type of exclude are selected, the selection is saved by DMS between ETC Hours Display sessions.

The second to last column on the right displays displays the resource totals past 1 year ("> 1 year"),  the last column on the right displays the total hours ("Total Hrs") for the resource (both the first 12 months and beyond to the end of the schedule horizon), and at the bottom the total hours per month and total heads per month are also displayed.  The total heads per month is not calculated for the hours past the first year and the total hours columns.  The Resource Description displays the first 40 characters of the description.

The total heads per month is calculated by:

       Total Hrs Per Month / Total Man Hours Per Month

where the Total Man Hours Per Month is the number of week days x 8 hours. The Total Man Hours Per Month does not include Saturdays or Sundays. 

If the Search button is pressed without making any jobs selections or if the Use Mfg Orders Job Grid Selections was not selected, DMS will warn the users with the following message:

You may continue with the search by selecting Yes or click No to abort the search.  The above message will only appear once per session so subsequent searches without search criteria will not display this message.