Adding Work Orders

Select Location to enter or change the default location for all lotted finished goods items on the work order. The default location is defined in the Default Location in Work Orders setting in Inventory Options. This option will only appear if there are lotted finished goods items found on the work order. The option will no longer appear once a default location is entered.

Press Enter to accept the default location or enter the location id or press F3 for a list of locations. A Select A Location window will appear with a list of Locations. Scroll to the location and press Enter to select. The selected location will be assigned to each lotted finished goods item on the work order.

To change the location on a single line item select Change. See Changing a Single Finished Goods Line item below for more information.

Select FG to enter the quantity of the finished goods items based on the stocking unit of measure to produce on the work order.

The on hand balance for the item including this work order will be displayed in the On hand column. Enter the quantity to produce or press F10 to determine the quantity to produce based on entering the actual on hand balance for the item. The on hand quantity entered must be greater than or equal to the current on hand balance. If a finished goods item was added to the work order based on a BOM and the current on hand balance is negative, the quantity needed to make the on hand balance zero will automatically default as the quantity to produce.

Use the up and down arrows to scroll through all the finished goods items on the work order regardless of how many items are to be produced. When you scroll to the first or last item or enter the production quantity for the last item, the system exits the finished goods production plan option and the command line above will appear. The following information will be added to the work order:

 

Header;

ORM next Lot will appear in RED in the header if the finished goods items were added via a Bill of Material that included Other Raw Material items.

 

Raw Material:

• From - The raw material Item Id.
• Raw Material - The raw material item name.
• Production - The actual quantity of the raw material item assigned to the work order in the stocking unit of measure. The standard quantity will default as the production quantity until the actual production amount is entered. See Adding/Changing Raw Material Lots below for more information.
• Standards - The Standards column display the standard quantity needed to produce the finished good line items and the average standard yield for the work order. Quantity - The standard quantity of the raw material item needed to produce the finished goods items is based on either the actual or standard yield assigned to the finished goods item. The yield used in the calculation is based on the Calculate Demand Using Standard Yield setting in Inventory Options. Standard cost finished goods items are not included in the calculation of the raw material standard quantity. Yield - The average standard yield is calculated based on the total weight of the finished goods item to be produced / the standard raw material quantity. Standard cost finished goods items are not included in the finished goods weight produced when calculating the standard yield.
• Lot - Next lot will appear in Red to indicate the raw material needed has not been assigned to lots. The location and lot number if a single lot was selected, or "Multiple" to indicate more than one lot was selected will display if lots were selected. When the finished goods production plan is entered , the raw material is automatically assign to the Next Lot. See Adding/Changing Raw Material Lots below for more information.
• COOL - The COOL level for the raw material item, Loose or Strict if lots have not been assigned or the COOL identity for the item selected if a single lot was selected or the word "Multiple" to indicate more than one lot was selected and the COOL identity was not the same on each lot selected.
• Info - The Info field will be blank until lots are assigned to the work order. If lots are assigned to the work order, the remaining item info attributes if a single lot was selected or multiple lots were selected and the item lot info attributes are the same. If more than one lot was selected and the item info lot attributes were not the same, the Info field will be blank,
• The actual production yield for the work order based on the total weight of the finished goods item / total weight of the raw material item

 

Finished Goods:

• To - The Item Id for each finished goods item on the work order.
• Finished Goods - The Item name for each finished goods item on the work order.
• Production - The total quantity of each finished goods item to be produced in stocking unit of measure of the item.
• On hand - the current on hand balance including the amount to produce in the stocking unit of measure
• Yield - Based on the Yielding method used to allocate the raw material cost to the finished goods items, this column will display the Actual yield used to allocate the raw material cost for each finished goods item produced or the standard yield used to calculate the raw material quantity needed. See Yield below for more information.
• Lot - Missing will appear in Red to indicate the finished goods lot number has not been assigned to the finished goods item. The location and lot number will display if the lot has been assigned to the finished goods item.
• COOL - The COOL level for the finished goods item, Loose or Strict if raw material lots have not been assigned or the COOL identity for the item selected if a single raw material lot was selected or the word "Multiple" to indicate more than one lot was selected and the COOL identity was not the same on each lot selected. The COOL identity will default from the item if the item has a default or the lot selected if the item does not have a default COOL identity.
• Info - The Info field will be blank if the finished goods item has a Lot Info standard, the standard for the item will default. An "*" will appear to indicate an Induction Note was entered for the lotted item.

 

The system will calculate and display the standard raw material quantity in the stocking unit of measure needed to produce the planned production in the Raw Material Standard column based on either the Actual Yield or Standard yield assigned to the finished goods items, depending on the Calculate Demand Using Standard Yields setting in Inventory Options. The standard quantity needed will automatically be assigned to the NEXT Lot. The average standard yield will display next to the standard quantity. See Adding/Changing Raw Material Lots below for information on how to assign the lots used to the work order.

The actual average yield for all finished good items to be produced will display in RED under the raw material production quantity in the raw material section of the display.

If the finished goods items was added to the work order from a BOM that also included Other Raw Material, the system will calculate the standard quantity needed for each other raw material item and automatically assign the quantity needed to the Next Lot. See Adding/Changing Other Raw Material Lots to Work Orders for more information.

The current on hand balance, item yield, location, lot number,Cool Identify and standard item info attributes will appear for each finished goods item.

The Location id will appear based on the location assigned to the finished goods items in Location Above. To change the location select Change. See Change below for more information.

The Lot number entered will appear or "Missing" will appear in RED to indicate a lot number is missing. See Info or Change below for information on entering the lot number.

The COOL identity will default based on the default assigned to the item. The COOL identity for items with a COOL level of Loose or strict cool that do not have a default at the item level will default from the raw material item or assigned manually by selecting Info. See COOL Rules for more information.

The item info lot attributes will default based on the standard for the items created in Lot Info. See Adding/Changing Lot Info in Work Orders for more information.

Note: If the quantity to produce is changed, the standard raw material and other raw material quantity will automatically be reset to the new standard quantity. The lots and quantity for the raw material item previously entered will not be updated. The lots and quantities must be manually adjusted. If the new standard for the other raw material items is greater than the original standard the difference between the new and old standard quantity will be assigned to the Next Lot. if the new standard quantity is less than the original standard, the new standard quantity will be assigned to the Next Lot even if lots were previously selected.

 

Select RM to assign the raw material lot(s) to the work order. This option will only appear after the finished goods production plan is entered. See FG above for more info.

•  The Lot selection window will display with the following information:

  Header:

  • The raw material item name.
    • A list of "F" function keys to quickly tag the raw material quantity to work order.
      • F2 Standard - Press F2 to reset the raw material quantity to the standard quantity based on the yield of each finished goods item to produce.
      • F3 Unit - Press F3 to toggle between the stocking unit of measure and pounds.
      • F4 Tag Lot - Press F4 to tag or assign the available lot balance for the lot selected to the work order.
      • F5 All Lots - Press F5 to tag the total available lot balance of all lots to the work order.
      • F6 Next Lot - Press F6 to assign the Standard quantity to the first available lot.
      • F7 Available (Unlotted items only) - Press F7 to tag the item available balance to the work order. The item available balance is the total lot available balance for all lots less the total quantity on unshipped sales orders and not assigned a lot number.
      • F8 On Hand (Unlotted items only) - Press F8 to tag the total on hand balance of all lots for the item.
      • F10 Exit - Press F10 to exit from the lot selection screen.

Lot Section:

• Next Lot - Select Next Lot to assign the total standard quantity or a portion of the quantity to the next available lot.
• A listing of all lots for the item and if lotted for the location selected.
  • Date - The date the lot was created.
  • Lot - The lot number.
  • S - For unlotted items, the Status of the lot , H=Hold
  • The quantity to assign to the work order based on the stocking unit of the item. Use the F3 key to toggle between the stocking unit and pounds.
  • Slot - If the item is lotted and the location is slotted, the slot id in which the lot is stored.
  • Available - The Available column indicates the total quantity available in the lot that may be assigned to the work order. The quantity that is not available to include on the work order includes any quantity that has been committed on an sales order, open work order, or open planned transfer.
  • Vendor - The vendor id of the vendor that supplied the product. If lots from multiple vendors were combined, "//////" will appear in the vendor column.
  • The remaining columns will display the COOL Identity and item info lot attributes based on the sort order of the item info template assigned to the item.

Footer:

• Item Name.
• The Total Quantity entered for the work order in the unit of measure selected for the work order.
• Item Available Quantity - The item available balance is the total of the lot available balances less the total quantity on unshipped sales orders that have not been assigned a lot.
• On Hand -The current on hand balance for the item before commitments and open orders.
• The standard quantity required for the item.

Use the arrow keys to highlight the appropriate lot and enter the total weight to be assigned to the work order in the Unit column or use one of the "F" function keys above to quickly assign the proper lot balance. Use the F3 key to toggle between the stocking unit of measure and pounds. As weights and quantities are entered, the sum of units or pounds selected is displayed in the message line.

Use Next Lot to assign the raw material quantity needed for the work order to the next available lot for the item and if the item is lotted, the next available lot for the location. The total quantity can be tagged to both Next Lot and any available lot. The work order cannot be completed until the balance of the Next Lot is zero.

 

After selecting the lots to transfer, press F10 to close the window.

 

The Screen will display the following information for the Raw Material item:

• From - The Item Id.
• Raw Material - The Item name.
• Production - The actual quantity of the raw material item assigned to the work order in the stocking unit of measure. If the raw material lot(s) selected are on Hold, an "H" will appear in Red on the finished goods item line.
• Standards - The standard quantity based on the yield of the finished goods items produced and the average standard yield for all finished goods items on the work order
• Lot - Next lot will appear in Red to indicate the raw material needed has not been assigned to lots. The location and lot number if a single lot was selected, or "Multiple" to indicate more than one lot was selected will display if lots were selected
• COOL - The COOL level for the raw material item, Loose or Strict if lots have not been assigned or the COOL identity for the item selected if a single lot was selected or the word "Multiple" to indicate more than one lot was selected and the COOL identity was not the same on each lot selected.
• Info - The Info field will be blank until lots are assigned to the work order. If lots are assigned to the work order, the remaining item info attributes if a single lot was selected or multiple lots were selected and the item lot info attributes are the same. If more than one lot was selected and the item info lot attributes were not the same, the Info field will be blank,
• The actual production yield for the work order based on the total weight of the finished goods item / total weight of the raw material item

Finished Goods:

• To - The Item Id for each finished goods item on the work order.
• Finished Goods - The Item name for each finished goods item on the work order.
• Production - The total quantity of each finished goods item to be produced in stocking unit of measure of the item.
• On hand - the current on hand balance including the amount to produce in the stocking unit of measure
• Yield - The Actual yield used to allocate the allocate the raw material cost for each finished goods item produced or the standard yield used to calculate the raw material quantity needed. See Yield below for more information.
• Lot - Missing will appear in Red to indicate the finished goods lot number has not been assigned to the finished goods item. The location and lot number will display if the lot has been assigned to the finished goods item.
• COOL - The COOL level for the finished goods item, Loose or Strict if raw material lots have not been assigned or the COOL identity for the item selected if a single raw material lot was selected or the word "Multiple" to indicate more than one lot was selected and the COOL identity was not the same on each lot selected. The COOL identity will default from the item if the item has a default or the lot selected if the item does not have a default COOL identity.
• Info - The Info field will be blank. If the finished goods item has a Lot Info standard, the standard for the item will default. An "*" will appear to indicate an Induction Note was entered for the lotted item.

Select ORM to enter the actual quantities of the other raw materials (ORM) that are associated with the finished goods on this work order. These items must have been designated as other raw material actual or other raw material standard on the bill of material. The standard quantity shown is calculated based on the ORM setup provided in the bill of materials for each finished good. The following command line options will appear:

• Location - Select Location to assign the default location to assign to all lotted ORM items. This option will assign the location entered and assign the quantity entered to the Next Lot automatically if lots are not assigned.
• Exit - Select Exit to return to the main Work Order Screen and continue entering information for the Work Order.
• The following options will appear after the Location has been assigned to each lotted other raw material item.
• Next Lot - Select Next Lot to assign the actual lot and quantity to the other raw material actual items and the lot to the other raw material standard items. The Next Lot option will not be available after all other raw materials have been assigned a lot number.
• Change - Select Change to enter the Actual Quantity of the Other Raw Material Actual Items used for a single ORM line item on the work order. Scroll to the item to change and press enter to select the item. Select the Location where the ORM item is stored by entering the Location id or pressing F3 for a list of locations ( lotted items only) Scroll to select which lot to use on the work order and enter the quantity or use one of the "F" function keys to quickly assign the quantity. The quantity for other raw material -Standard items cannot be changed . The message line " Must tag only standard quantity of xx.xx !!! Space bar to Continue" will appear to indicate the item is an other raw material - standard item and the quantity cannot be changed. Press the space bar and then F2 to reset the quantity to the standard amount. Select the lot and enter the standard quantity or press F6 to assign the standard quantity to the next lot with an available balance. See Selecting Lots for more information.
• Delete - Select delete to delete an Other raw material item from the work order. Scroll up or down the list and press enter to delete the item.
• Actual - Select Actual to enter the Actual quantity used for the Other Raw Material - Actual Items. The system will select each ORM - Actual item line item by Item. ORM- Standard items will not be included. Enter the Actual Quantity the same way as in the Change option above.
• Standard - Select Standard to enter the Standard quantity used for the Other Raw Material - Standard Items. The system will select each ORM - Standard Item line by line. ORM - Actual Items will not be included. Enter the Standard qunatity the same way as in Change above.

 

The following lot selection window will appear:

• Header:

  • The other raw material item name.
    • A list of "F" function keys to quickly tag the raw material quantity to work order.
      • F2 Standard - Press F2 to reset the raw material quantity to the standard quantity based on the standard yield of each finished goods item to produce.
      • F3 Unit - Press F3 to toggle between the stocking unit of measure and pounds.
      • F4 Tag Lot - Press F4 to tag or assign the available lot balance for the lot selected to the work order.
      • F5 All Lots - Press F5 to tag the total available lot balance of all lots to the work order.
      • F6 Next Lot - Press F6 to assign the Standard quantity to the first available lot.
      • F7 Available (Unlotted items only) - Press F7 to tag the item available balance to the work order. The item available balance is the total lot available balance for all lots less the total quantity on unshipped sales orders and not assigned a lot number.
      • F8 On Hand (Unlotted items only) - Press F8 to tag the total on hand balance of all lots for the item.
      • F10 Exit - Press F10 to exit from the lot selection screen.

Lot Section:

• Next Lot - Select Next Lot to assign the total standard quantity or a portion of the quantity to the next available lot.
• A listing of all lots for the item and if lotted for the location selected.
  • Date - The date the lot was created.
  • Lot - The lot number.
  • S - For unlotted items, the Status of the lot , H=Hold
  • The quantity to assign to the work order based on the stocking unit of the item. Use the F3 key to toggle between the stocking unit and pounds.
  • Slot - If the item is lotted and the location is slotted, the slot id in which the lot is stored.
  • Available - The Available column indicates the total quantity available in the lot that may be assigned to the work order. The quantity that is not available to include on the work order includes any quantity that has been committed on an sales order, open work order, or open planned transfer.
  • Vendor - The vendor id of the vendor that supplied the product. If lots from multiple vendors were combined, "//////" will appear in the vendor column.
  • The remaining columns will display the COOL Identity and item info lot attributes based on the sort order of the item info template assigned to the item.

Footer:

• Item Name.
• The Total Quantity entered for the work order in the unit of measure selected for the work order.
• Item Available Quantity - The item available balance is the total of the lot available balances less the total quantity on unshipped sales orders that have not been assigned a lot.
• On Hand -The current on hand balance for the item before commitments and open orders.
• The standard quantity required for the item.

Use the arrow keys to highlight the appropriate lot and enter the total weight to be assigned to the work order in the Unit column or use one of the "F" function keys above to quickly assign the proper lot balance. Use the F3 key to toggle between the stocking unit of measure and pounds. As weights and quantities are entered, the sum of units or pounds selected is displayed in the message line.

Use Next Lot to assign the raw material quantity needed for the work order to the next available lot for the item and if the item is lotted, the next available lot for the location. The quantity can be tagged to both Next Lot and any available lot. The work order cannot be completed until the balance of the Next Lot is zero.

After selecting the lots to transfer, press F10 to close the window.

 

Note: The Other RM command option will only appear if other raw materials were assigned to a finished good through a bill of material and a planned production quantity for each finished goods item.

Select Change to change the quantity to produce, location, lot number,COOL identify and/or item info attributes for a single finished goods line item.

Select Change

Scroll up or down the list of finished goods items and press Enter to select.

The current production amount and on hand balance will display. Enter the quantity to produce, press enter to accept the current production quantity or press F10 to determine the quantity to produce based on entering the actual on hand balance for the item. The on hand quantity entered must be greater than or equal to the current on hand balance.

If the finished goods item is lotted, enter the Location Id to assign the lotted item or press F3 and select a location from the Select a Location window. Scroll to the location and press enter or press Enter to keep the current location.

Select one of the following choices below relating to item info lot attributes or press Enter to accept the system default or N, no changes. See Item Info Lot Attributes for more information.

• C – Change. Select Change to enter or change the item info lot attributes and/or Trace Source product attributes .
• B – Blank. Select Blank to Leave the item info lot attributes and/or Trace Source product attributes blank.
• L – Last used. Select Last Used to copy the tem info lot attributes and/or Trace Source product attributes from the previously entered purchase order line .
• N – No Changes. Select to use the standard item info attributes entered in Lot info or the previously entered item info lot attributes and/or Trace Source product attributes .

 

Enter the item info lot attributes in the item info fields as set in Item Info. See Item Info Lot Attributes for more information.

If the location is Slotted, Enter the slot information. See Entering Slot Information.

Note: If the quantity to produce is changed, the standard raw material and other raw material quantity will automatically be reset to the new standard quantity. The lots and quantity for the raw material item previously entered will not be updated. The lots and quantities must be manually adjusted. If the new standard for the other raw material items is greater than the original standard the difference between the new and old standard quantity will be assigned to the Next Lot. if the new standard quantity is less than the original standard, the new standard quantity will be assigned to the Next Lot even if lots were previously selected.

Select Info to enter/change the lot information and item info lot attributes of the finished goods item. This includes COOL identity, lot number, lot opened date, and the other lot attributes assigned to the item. The lot attributes may be different on the finished goods items because they use different item info types with different lot attributes assigned. If the finished goods item has standard item info attributes defined in Lot Info, the standards for the item will default in automatically. See Item Info Lot Attributes for more information.

If the item is lotted , enter the lot number . If the location is slotted enter the slot

Enter the COOL identity for the item if it did not default from the raw material item or finished goods item default

Enter the Remaining Item Info Lot attributes.

The following Command Line options will appear:

• Next - Select Next to move to the next finished goods item line.
• Change - Select Change to change the lot number, lot opened date, COOL identify and item info attributes.
• Last - Select Last to default the item info attributes from the previously entered finished goods item. The lot number, opened date and COOL Identify do not default from the last finished goods item.
• Blank - Select Blank to set the item info lot attributes to a blank field and enter the Item Info Lot Attributes.
• Exit - Select Exit to exit from the item info option.
• Previous - Select Previous to move back to the previous finished goods item.

Select one of the options above relating to item info lot attributes or press Exit to Exit from the lot info option.

Enter the item info lot attributes in the item info fields as set in Item Info. See Item Info Lot Attributes for more information.

Select Header to enter or change the optional Note, Opened Date, and/or Expected Date.

Enter the optional work order note in the note field.

Enter the Opened Date or press enter to accept the current system date as the work order open date.

Enter the Expected Completed date or accept the current system date as the work order expected complete date.

Select Add to add additional finished goods items to the work order by entering the item id..

Enter the item group for the finished goods item or press Enter to return to the Select An Open Work Order window. A Select A Raw Material Item window will appear displaying a list of all items in the item group. Use the arrow keys to select the appropriate raw material item from the window and press Enter.

If you are uncertain of the Item code, see Navigating Net Yield - Selecting an Item Code.

If the raw material item is already associated with the finished goods return to FG - Adding/Changing the Finished Goods Production Plan to enter the planned production quantity for the item.

If the finished goods items is not associated with the raw material on the bill of material, the following command line option will appear "Add to BOM? Yes/NO.

• Select No to add the item to the work order without creating or modifying the BOM for the finished goods item.
• Select Yes to add or modify the BOM for the finished goods item.
  • Modify Bill of Material? No/Yes
    • Select No to add the item to the work order without creating or modifying the BOM for the finished goods item.
    • Select yes to create or modify a BOM. See Bills of Materials for more information.

Select FG - Adding/Changing the Finished Goods Production Plan to enter the planned production quantity for the item.

Select BOM to add finished goods items to the work order via the finished goods F10 selection box.

The Finished Goods F10 selection window will display. See Step 2 above for more information.

Select Update to save the work order as an open work order that can be completed based on actual raw material and other raw material lots and quantities used and the actual finished goods item quantities and lots produced.

Based on the Print Work Order and Print Production Plans setting in User Options, the following command prompts will appear:

• Print Work Order No/Yes
  • Select No to update the work order without printing the Work Order
  • Select Yes to update the work order and print the Work Order. Command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Work Order report.

 

• Print Production Plan No/Yes
• Select No to update the work order without printing the Production Plan.
• Select Yes to update the work order and print the Production Plan. Command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Work Order report.

 

If Inventory Labels are set to Y (Y=yes) in Inventory Options the following message will display: "Print Inventory Labels? No/Yes?"

• Select no if you do not need to print inventory labels.
• Select yes to print inventory labels. For more information on printing labels, see Labels.

If all raw material and other raw material lots have been selected and all required COOL Identities, location, lot numbers and item info attributes have been entered for the finished goods items, the Yield Button will appear to the left of the command line. Select Yield to change the yielding method used to allocate the raw material cost to the finished goods items and/or Update and Complete the work order. . See Yield below for more information.

A finished goods production plan must be entered to Update the work order. See FG - Adding/Changing the Finished Goods Production Plan for more information.

If the lots for the raw material or other raw material items have not been assigned to the work order, they will be assigned to the Next Lot when updating the work order at the standard quantity.

Select Yield to change the yielding method used to allocate the raw material cost to the finished goods items produced and to save the open work and/ or Complete the Work Order. The Yield button will appear only if all raw material and other raw material lots have been selected and all required COOL Identities, location, lot numbers and item info attributes have been entered for the finished goods items.

The following screen will be displayed:

Header:

• Work Order - The work order number
• The optional work order header note
• Opened - the date the work order was opened.
• Expected - the expected completion date for the work order.
• Uncosted will appear in RED to indicate that the work order has been closed but not yet costed.
• Inventory on Hold will appear in RED to indicate that the work order there are raw material and/or other raw material lots on hold assigned to the work order.

 

Raw Material

• From - The Item Id.
• Raw Material - The Item name.
• Production - The actual quantity of the raw material item assigned to the work order in the stocking unit of measure.
• Standards - The standard quantity based on the yield of the finished goods items produced and the average standard yield for all finished goods items on the work order.
• Cost - The average cost per pound of all raw material lots selected.
• The actual yield based on the total weight of the finished goods items / total raw material weight.

 

Finished Goods

• To - The Item Id for each finished goods item on the work order.
• Finished Goods - The Item name for each finished goods item on the work order.
• Production - The total quantity of each finished goods item to be produced in stocking unit of measure of the item.
• FG Cost - The total unit cost in the stocking unit of measure which includes the raw material cost allocation, total manufacturing cost if applicable and the total other raw material if applicable.
• Standard - The standard item yield for the item.
• FG Yield - The actual finished goods yield used to allocate the raw material cost to the finished goods items if the Use Standard Yields not Actual setting in Inventory Options is set to Y in Inventory Options. If set to N, the Actual historical yield will be displayed.
• The current Yielding Method selected and the value used to allocate the raw material cost to the finished goods items.
• RM - The per unit raw material cost allocated to the finished goods item in the stocking unit of measure
• MFG - The total per unit manufacturing cost standard added to the finished goods item if applicable.
• ORM - The total per unit cost of the other raw material and other cost added to the finished goods item if applicable.

 

The yielding method used to allocate the raw material cost to the finished goods items will default into the work order based on the Default Yielding used in Work order setting in Inventory Options. The available options are :

• Average – Select Average to distribute the raw material weight and cost proportionately to all non-by-product (standard cost) finished goods on the work order. This will cause all finished goods to have the same yield and the same raw material cost.
• Item Specific – Select Item Specific to use the either the item specific or actual historical item yields to distribute the raw material weight to all non-by-product (standard cost) finished goods or to use an item specific cost or selling price to allocate the raw material cost to the finished goods items.
• Selling Price – Select Selling Price to use the base selling price 1-8 for the finished goods item less the total manufacturing cost and other raw material cost to distribute the raw material weight to all non-by-product (standard cost) finished goods. The cost will be distributed based on the percentage change in the selling price for each finished good item. The base selling price can be overridden and the selling price entered manually. Each item will have a different yield and cost.

 

The total raw material cost will be allocated to the finished goods items based on the yielding method selected. Finished Goods Item with a costing method of standard will have the raw material calculated based on the standard cost for the item less the manufacturing cost standard and other raw material costs as defined in the bill of materials for the finished goods item. If the total manufacturing cost and other raw material costs exceed the standard cost for the item, a Standard Cost adjustment will be made for the difference based on the standard cost adjustment type assigned to the sales category of the finished goods items. If the total manufacturing and other raw material cost exceeds the standard cost, the command line will display the following message: "Standards Cost Variance / Exit." Select Standard Cost Variance to adjust the cost of the finished goods item to the standard cost and create an inventory adjustment based on the standard cost adjustment type for the sales category of the finished goods item. Select Exit to return to the main work order screen and modify the work order.

 

Settings in Inventory Options control which of the yielding methods can be used in work orders. The sort order for the buttons are based on the Display Yield or Cost in Work Orders, and which methods to use are set to Yes in Inventory Control. If the Display Yield or Cost in Work Orders is set to Yield - the Cost button will appear after the Back button first. If set to Cost, the Yield button will appear first after the back button. If the Average Yielding, Item Yielding and Price Yielding are set to No, the buttons will not appear.

If the Default Yielding used in Work orders is set to "I"= Item specific, the cost allocation will be based on Item specific yield. The options to change the Cost, Price or Reset to Average yield will only appear if the Average Yielding used in Work Orders is set to Yes, if the Item Yielding used in Work order is set to Yes and the Price Yielding used in Work Orders is set one of the eight base selling prices. If any of these are set to N=Not Using, that option will not be available to allocate the raw material cost.

 

If the Default Yielding used in Work orders is set to A= Average, the average raw material cost and yield will be allocated to the finished goods items. The options to change the Yield, Cost, or Price or if the Item Yielding used in Work order is set to Yes and the Price Yielding used in Work Orders is set one of the eight base selling prices. If any of these are set to N=Not Using, that option will not be available to allocate the raw material cost.

 

Select Yield. The following command line will appear based on the default and method used setting in Inventory options.

 

• Exit - Select Exit to return to the work order line detail screen.
• Cost - Select Cost to manually assign the raw material cost to each finished goods item, The total cost allocated to each finished goods item cannot exceed the total raw material cost. The system will adjust the raw material cost proportionally to equal the total raw material cost entered
• Yield - Select Yield to manually enter the finished goods item yields to be used to allocate the raw material cost. The total yield of all items must equal the average yield. The system will adjust the manual yields entered proportionally to equal the total average yield.
• Price - Select Price to use the default base selling price or user assigned selling price less the total manufacturing and other raw material allocate the raw material cost to the finished goods items. The system will adjust the raw material cost proportionally to equal the total raw material cost.
• Average - Select Average to reset the yield on each finished goods item to the total average yield for the work order.
• MFG - Select MFG to view or change the manufacturing cost standards on each finished goods item. Enter Y to enter the Manufacturing Cost detail selection box. Enter N to skip to the next item. See Bill of Material for more information
• Update - Select Update to save and/or complete the work order and create the finished goods inventory quantity and remove the raw material and other raw material lots and quantities from inventory. See Completing the Work for more information.

 

Changing the Yield

 

Select Yield to change the yield on each finished goods item.

In the FG Yield column, enter the item specific yield for each finished goods item. The system will reallocate the raw material cost to the finished goods items based on the item specific yield for each item.

 

Changing the Raw Material Cost allocation

 

Select Cost to change the raw material cost allocation for each finished goods item.

In the RM Cost field enter the item specific raw material cost to be used to allocate the raw material cost to the finished goods items. The system will reallocate the cost for each item so the total cost distribution equals the total cost of the raw material based on the percentage change in the item specific cost entered. The finished goods cost will be recalculated based on the item specific cost entered. The finished goods yield will be adjusted to reflect the change in the finished goods cost.

 

Changing the Price

 

Select Price to allocate the raw material cost to the finished goods item based on the base selling price for the item less the total manufacturing and other raw material cost.

In the FG Price Column enter the selling price for each finished goods item. The system will default the base Selling price 1- 8 for the item based on the Price Yielding used in Work Orders setting in Inventory Options The system will deduct the total manufacturing cost standard and other raw material cost from the selling price and reallocate the raw material cost to each finished goods item based on the percentage change of the net selling price. The finished goods cost will be recalculated based on the new raw material cost. The finished goods yield will be recalculated to reflect the change in raw material cost

 

Resetting the Yield to the Average Yield

 

Select Average to reset the yield to the average yield.

The average yield and raw material cost for each finished goods item will be recalculate to the average yield for the work order. The raw material cost will be recalculated to equal the average raw material cost.

 

Viewing/Changing the Manufacturing Cost

 

The MFG button will only appear if a finished goods item was added to the work order using a Bill of Material and there are manufacturing cost standards included on the BOM.

Select MFG.

The system will complete the work order and create the journal entry, for the manufacturing costs added to the work order, update the finished goods items produced and remove the quantity used for raw material and other raw material items from inventory. The Update button will appear only if all raw material and other raw material lots have been selected and all required COOL Identities, location, lot numbers and item info attributes have been entered for the finished goods items.

Select Update.

The Adjust MFG Costs window will appear based on the Review MFG Cost In Work Orders setting is set to Yes in Inventory options.

• Type – The cost adjustment type ID
• Adjustment Type – The adjustment type name
• Computed - The total manufacturing cost to be added by cost adjustment type at the Standard rates from the Bill of Materials for each finished goods item on the work order.
• Override – The actual value added for each cos
• t adjustment type. To adjust the manufacturing cost to actual use the arrow keys to highlight the cost adjustment type and enter the new total actual cost.
• A – This column is the adjust standard to actual column. A "Y" in this column indicates that the standard can be updated to reflect actual costs. The standard can be changed based on the adjust to actual setting for the cost adjustment type.

• Item Name– The finished goods item the cost was added to
• Weight – The quantity of finished goods produced
• Adjustment – The cost adjustment standard amount and the calculation method used on a per pound , per each , or total charge
• Extended – The total cost .

• Select no to abort updating this work order and return to the command options.
• Select yes to continue with updating the work order.

 

The following command line option will appear " Complete Work Order ? No / Yes

 

• Select No and the system will save the work order without completing it.
• Select Yes the system will complete the work order and create the journal entry, for the manufacturing costs added to the work order, update the finished goods items produced and remove the quantity used for raw material and other raw material items from inventory. If the work order cannot be completed, the system will warn you that it cannot be completed.

 

Note: If any of the raw material or other raw material lots selected for processing comes from lots on inventory hold, all of the finished good lots created upon completing the work order will automatically be placed on hold and the work order will be uncosted. Work orders can only be costed when the cost of all component raw material lots is known – in other words, when these lots have been removed from inventory hold status in Purchasing or completed in Complete Purchase Orders. Closed Uncosted Work Orders will automatically be costed during the Cost of Goods Sold process from either the menu or the Close End of Day process or by selecting the uncosted work order and updating and completing the work order after the raw material or other raw material lots have been costed.

Note: Standard cost finished goods items are considered a by-product. The cost is assigned to the item first based on the standard cost of the item less the manufacturing and other raw material cost and is deducted from the total raw material cost. The new raw material cost is then allocated to the remaining finished good item based on the allocation method selected.

Select Find to Find an Open or Completed Work Order by Closed Date, Number, Raw Material Item or Finished Goods Item.

Select Find. The following options will appear:

• Date Closed - Select Date Closed to find a completed work order based on the completed date of the work order. Work Orders completed on the current date can be viewed and changed. Work order closed on a different date can only be viewed.
  • Enter the Work Order Closed Date or press Enter to accept the system default date.
  • A Select A Completed Work Order window will appear with the following information:
    • Exit - Select exit to return to the Find option window.
    • Completed = The Work order is closed and costed, Uncosted = the work order is closed and uncosted
    • The completed date for the work order.
    • The raw material item id and name.
    • The total quantity and unit of measure of the raw material assigned to the work order.
    • Yield - The average finished goods yield for the work order.
  • Scroll up or down to select the work order and press enter. See Viewing Work Orders for more information.
• Work Order Number - Select Work Order Number to find an open or completed work order based on the work order reference number.
  • Enter the work order number. See Viewing Work Orders for more information.
• Raw Material Items - Select Raw Material to find completed work orders by the raw material item.
  • A Select A Raw Material Item window will appear displaying a list of all items in the item group. Use the arrow keys to select the appropriate raw material item from the window and press Enter. If you are uncertain of the Item code, see Navigating Net Yield - Selecting an Item Code.
• A Select A Completed Work Order window will appear with the following information:
  • Completed = The Work order is closed and costed, Uncosted = the work order is closed and uncosted
  • The completed date for the work order.
  • The raw material item id and name.
  • The total quantity and unit of measure of the raw material assigned to the work order.
  • Yield - The average finished goods yield for the work order.
• Scroll up or down to select the work order and press enter. See Viewing Work Orders for more information.
• Finished Good Item - Select Finished Good Item to find completed work orders for a specific finished goods item.
• A Select A Finished Good Item window will appear displaying a list of all items in the item group. Use the arrow keys to select the appropriate finished good item from the window and press Enter. If you are uncertain of the Item code, see Navigating Net Yield - Selecting an Item Code.
A Select A Completed Work Order window will appear with the following information:
• Completed = The Work order is closed and costed, Uncosted = the work order is closed and uncosted
• The completed date for the work order.
• The raw material item id and name.
• The total quantity and unit of measure of the raw material assigned to the work order.
• Yield - The average finished goods yield for the work order.
• Scroll up or down to select the work order and press enter. See Viewing Work Orders for more information.