Enter into SQLSYSSETTING.EXE located within the manexSQL root directory.

Enter password when prompted.

Select Production > Production Work Centers & Activities from the drop-down menu.






The following screen will be displayed:

 

For the highlighted work center (WC), enter in the hourly charge rate.


To add a work shift, highlight the WC, then depress the "Add Work Shift" button.


 

To add a work shift, highlight the WC, then depress the "Add Work Shift" button.

The following popup screen will appear, to indicate that the work shifts listed on the popup screen have been setup in the Work Shift Setup module.  

Highlight the work shift(s) and depress the "OK" button.
 

 


To assign work centers (WCs) to workstations, highlight the name of the WC and depress the button at the bottom of the screen called, "Assign work center to workstations." See note at the end of article for more information on the "Assign work center for workstations"  button. 

The following assignment screen will appear: 

 


To enter a new assignment, depress the Add button.  



When setting up a workstation, the user must enter the full computer name in the "Workstation Name" field and the computer description in the "Workstation Description" field. See Example below:


 




Depress the Activity tab.

 

The user may add work center activities by selecting the Add icon from the main tool bar. 

 

To add an activity ID and related description, choose the applicable work center from the drop down menu:

Enter the act ID and activity description. 

Click on the "cap totaling" box to elect calculating capacity.

Lastly, Save changes or Abandon Changes.



 





To attach a cost rate to an activity, click on the Edit button, then click on the Add button (bottom of screen) in the Activity Costing Section.





 
Select the activity from the pull down. (The activity costing descriptions are defaulted in from the Activity Costing & Setup Type Setup module) 


 





Enter in the Cost/hr and the Charge/hr. 

 




Lastly, Save changes or Abandon Changes. 

   

Once the activity ID and description, cap totaling election, and hourly charge rate have been entered, depress the Activity Setup & Run tab.

 
 

Depress the Edit button.  

For the Setup Type Description section. Depress the Add button (on screen).

 

Enter the time in hours and minutes.

Select the Setup Type Description from the menu (these are defaulted in from the Activity Costing & Setup Type Setup module).


 

This button allows the user to enter instructions for setting up the setup type. 

This button allows the user to load a photo for an instruction. The photo file should be in the manexSQL directory, and should be in BMP or TIF format.


For Component Package Configuration, depress the Add button (on screen)

Select the Component Package Configuration from the menu (the Component Package Configuration(s) are defaulted in from the Package Configuration module).


Enter in the Volume per hour, and then the yield factor percentage.

Volume is the number of units per hour. This may be boards per hour, units per hour, connections per hour, etc.

The Yield factor affects the volume such that a lower yield means it will take longer to make the same number of quality parts. For example, if the standard volume is 100 parts per hour, and the total yield is 80%, then the effective yield would be 80 parts per hour.




Once all changes are complete, either Save or Abandon changes.





Note: The "Assign work center to workstations" button provides the ability to limit a work station (specific computer) to be able to only transfer material “FROM” a certain work center (WC). So, when a user first opens the "SFT by WO" or "Shop Floor Tracking by Bar Code" module, the module will use the default WC assigned for this workstation. But if the user chooses to use a different WC, then this can only occur with supervisor approval or when a user that has the option, "Allow Changing Default Work Center for Serial Number Transfer" box checked within the Security module. After a supervisor or user with this option’s password is entered, the default WC will be changed to the one that the supervisor entered the password for. 

Here is an example to illustrate the above paragraph: Suppose the workstation is assigned to use “TU” as the default WC. If a user chooses to use “AI” to transfer, then the system will ask for the supervisor’s password. But if a user chooses to cancel entering in the password, then the default WC will still be “TU.” Moreover, if the supervisor enters their password on this machine, the default WC will be changed to “AI.” Also, If a user tried to transfer from “TU,” again, the system will still ask for the supervisor’s password. Lastly. If a user exits the module and returns to the module, then the default WC will be “TU.” 


Where Used:  In all shop floor related Activities.