To use the Operation Resources form, firstly position your cursor on the row you wish to contain the routing data. Then double-click in one of the cells in the Operation Resources section and the form will automatically load. Alternatively click on the ‘Forms’ icon and select ‘Operation Resources’ on the Routing Wizard ribbon.
Prerequisites
Organization and Item information must exist in the spreadsheet.
Routing Alternate information must exist in the spreadsheet.
Operation Sequence, Effective From, and Department information must exist in the spreadsheet.
The following is an example of the Engineering Operation Resources form:
Operation Resources Tab
Resource Action – The list of values contains the upload actions available for the Operation Resources section. (Refer to section: Upload Routings).
Resource Sequence - Enter the sequence number for the resource. Valid values for Resource Sequence range from 1 to 9999 and must be unique for the Operation.
Resource - The list of values contains all Resources assigned to the Department.
Basis - The list of values contains ‘Item’, and ‘Lot’. Select a basis type by which to charge and schedule the resource. The default is the basis.
Usage, Inverse Usage – Enter a value in either field. The other field will be completed by Oracle on upload.
Resource ECO - Displays the ECO (if any) acting on the Operation Resource - Not on the Manufacturing Operations Resource form.
Resource ECO Status- Displays the status of the ECO (if any) acting on the Operation Resource - Not on the Manufacturing Operations Resource form.
Operation Resource Details Tab
Schedule Resource – The list of values contains the scheduling options.
Schedule Sequence - Enter the schedule sequence number to specify the actual sequence of each resource used in the operation. Two or more resources can be scheduled to be working concurrently.
Substitute Group Number – Enter the group number of any Alternate Resources
Assigned Units - Enter the number of Resource units to be assigned.
Resource Offset – Enter the Resource offset percent.
Principal Flag – A Yes/No flag. Indicate which resource is the principal resource, within a group of simultaneous resources.
Setup Type – The list of values contains all Setup Types for the Resource.
Activity – The list of values contains all predefined activities.
Standard Rate – A Yes/No flag. If the resource is costed, indicate whether to charge jobs and repetitive schedules based on a predefined standard rate.
Charge Type - The list of values contains all Charge Types.
Operation Resource Costs Tab
The fields on this are display-only fields and cannot be changed. The form is for information only.
Once you have entered your data click the:
‘OK’ button to transfer the information back to Excel.
‘Cancel’ button if you wish to revert to the values at the time you opened the form.
Refer to section:
