Overtime Analysis
Previous Topic  Next Topic 

Overtime Analysis enables you to answer the questions "What do we need to do to bring late jobs in on time and what is the cost?"  


Select the Overtime Analysis by either File | Graphs | Overtime Analysis or by using Graphs | Overtime Analysis.  The example below shows the Overtime Analysis after the Calculate Overtime button has been clicked.  The Overtime Schedule by Resource grid has been scrolled to the last line and the Total by Departments has been selected thus total overtime hours and costs by departments is shown along with grand totals for the selected date range:  



For the Overtime Schedule by Resource grid:


  1. To determine if a resource is working overtime, the Standard Hours profile for the resource is used.  If the loaded hours are greater than the standard hours profile, then the difference between the standard hours profile and the loaded hours is assumed to be overtime.  
  2. To display the overtime by resource, click the Calculate Overtime button on top of the grid.  
  3. The default for the date range is 30 days out from the start date.  You can enter any date range you want.  After entering new dates, press the Calculate Overtime button to recalculate the grid.
  4. The Resource Selections button can be used to select which resources you want to see in the grid.  After making the resource selections, press the Calculate Overtime button to recalculate the grid.
  5. The Job Selections affects the pie charts and job load bar on the capacity graph only.  The job selections do not affect the overtime analysis grid.
  6. When you double click on the grid, the corresponding resource is shown in the capacity graph.  If you double click on a bar in the capacity graph, the Dispatch Display is shown.
  7. Select View | Total by Departments or View | Total by Pools to display the totals at the end of the overtime grid for Department totals or Pool totals.
  8. To calculate costs, the Standard Cost/Hr and the Overtime Cost/Hr defined on the Resources tab is used.


For the pie charts:


  1. The Apply to Pie Charts selection enables you to select All Final Assembly and Regular Jobs, Job Selections to select only those jobs selected using the Job Selections button, or Mfg Orders Job Grid Selections which selects all jobs in the Mfg Orders Job Grid.  Whatever is selected applies to the four pie charts only.
  2. The first pie chart shows the schedule completion date compared to either the baseline completion date or the previous schedule end date.  Select View | Pie Job Options to select either the baseline completion date or previous schedule end date for the calculation.
  3. The second pie chart shows jobs late by number of days categories.  The schedule completion date is compared to either the baseline completion date or the previous schedule end date.  Select View | Pie Job Options to select either the baseline completion date or previous schedule end date for the calculation.
  4. The third pie chart shows schedule completion date compared to the due date.
  5. The fourth pie chart shows jobs late by number of days categories.  The schedule completion date is compared to the due date.
  6. The pie charts can be rotated by clicking on the background using the left and right mouse keys.
  7. A larger view of the pie charts can be displayed by clicking on the title of one of the pie chart.
  8. You can click on a pie slice to see what jobs makeup that slice.


The following commands are available:


  1. Print Report Selecting File | Print Report or clicking on the print icon   to print a Crystal Report as setup by Module Report Settings.
  2. Print Grid  Selecting File | Print Grid or clicking on the print grid icon to print the current Overtime Schedule by Resource grid. 
  3. Pie Chart Option Selecting View | Pie options will display the example window below.  You can select:
    1. 3D pie displays
    2. Pie chart late jobs by days late settings for the three categories
    3. The Date selection for the first two pie charts to compare the schedule end date with either the baseline end date or the previous schedule end date

Once you have selected the settings click the OK button to save the settings



  1. Capacity Graph Options Sets the bar options for the capacity  graph.  For more information, see Capacity Graph Set Bar Options.
  2. Bar Chart Options Sets the bar on the capacity graph to either display ore not display Labels, Overlay bars, and Percent load
  3. Capacity Graph Themes The View | Capacity Graph Themes enables you to change the appearance of the graph.  Various themes and colors can be selected.
  4. Set Date Range The View | Set Date Range enables you to set the default date range for the Overtime Schedule by Resource.  The "From" date defaults to he start date of the last schedule run and the "to" date is the schedule start date plus the number of days for date range.  In the example below, the "to" date will be he schedule start date plus 90 days:



  5. Totals by Departments  The View | Totals by Departments will instruct the Overtime Schedule by Resource grid to total the overtime by departments.  Either Total by Departments or Totals by Pools can be selected, but not both.
  6. Totals by Pools  The View | Totals by Pools will instruct the Overtime Schedule by Resource grid to total the overtime by pools.  Either Total by Departments or Totals by Pools can be selected, but not both.
  7. Time Scale Time scale enables you to select the grid overtime totals for the Overtime Schedule by Resource grid by either Shifts, Days, Weeks, Months, or Quarters.
  8. Export Overtime Grid  The Export | Export Overtime Grid enables you to export the data in the Overtime Schedule by Resource grid to either a CVS text file,  in Word DOC format, or in Excel file format.
  9. Zoom In/Zoom Out buttons on the capacity graph enable you to zoom in or out for bar totals by shifts, days, weeks, months or quarters.