Maintain Work Order Products (WO13)

The Maintain Work Order Products (WO13) program is used to assign component materials and build instructions to Work Order (WO) Products previously created in Maintain Inventory Master (IM13). WO13 also displays the cost structure for the WO Product, dynamically updated as components and planned quantities are entered and maintained. For an overview of the Work Order system, click here.

The following list defines every field on WO13:

  • Finished Product - enter or select from the query a Work Order Product previously defined in IM13. Only WO type Products can be entered in this field. Once the WO Product is entered, the Description from IM13 automatically displays to the right of this field.

  • Planned Quantity - enter a quantity in this field that represents the number of Work Order Products that can be built using the list of component Products (defined below). The default value for this field is 1, but you can enter a maximum of 9,999,999 in this field. In most cases, a value of 1 is entered in this field, that being 'x' of each component product, assembled together to build 1 Finished WO Product.

    Note: Here is an example using a planned quantity other than 1:

    Horse Shoe Tumblers are purchased plain from the supplier. The work order is to stamp a Company logo onto each tumbler, put each tumbler into a gift box and then put those into a master carton that holds 24 of the boxed tumblers. The components used are:

    • 24 Horse Shoe Tumblers (plain)
    • 24 Gift Boxes for Tumblers
    • 1 Master Carton

    A Planned Quantity of 24 makes sense for this work order because at the end of the process they are boxed into a master carton of 24. The PO quantity should be a multiple of the work order Planned Quantity. For example, a PO for 96 tumblers will be produced and packed into 4 master cartons of 24 each.

    To see a WO13 screen shot of this example, click here.

    Once the Planned Quantity is entered, the Stock Unit from IM13/Stock automatically displays to the right of this field.

  • Default Warehouse - enter or select from the query the Warehouse where component stock is to be relieved during the production of this WO Product. The Warehouse is assigned as the default Warehouse on the WO component lines, but can be overridden at the component detail line if required. This allows production to relieve stock from multiple Warehouses on a single Work Order.

  • Unit Price - the QB1 Selling Price from IM13/Pricing automatically displays for the WO Product. This field is for information purposes only and cannot be edited. The Unit Price is displayed on WO13 to assist in analyzing the final cost for the 'WO' Product and is used in the calculation of the GM% value.

  • GM% - the current GM% for the WO Finished Product as calculated by using the Unit Cost and QB1 Price in the GM% calculation. This field is for information purposes only and cannot be edited. For more information on the GM% calculations, see Useful Calculations.

  • Unit Cost - the current Unit Cost to produce the WO Finished Product is the sum of the average cost of the components you have entered PLUS any purchase price and/or Landing Factor assigned in the PO13 record. As you add more components, change the quantity of components or change the Planned Quantity, the Unit Cost dynamically updates. You cannot edit this field directly. The Unit Cost is calculated as:

    Total Extended Cost of Purchase Price + Landing Factors
    +
    Total Extended Costs of Components @ Average
    (Divided by)
    Planned Quantity

  • List Box - enter the build instructions for the WO Product in the list box on the left side of the screen. This is a free format area, and the list box allows you to enter many lines of instruction. A scroll bar appears when you have entered lines than are viewable in the list box. These instructions display in PO40 when a PO for a WO Product is created and these instructions also print on the Work Order production document.

  • In the Landing Factors section, the Purchase Price, Duty rate and the Landing Factors assigned in PO13 to the WO Product automatically display. The information in this section is for information purposes only and cannot be edited.

  • Line - line numbers are automatically generated for each new component added to the WO Product. The Line number field is also used to recall an existing line: enter the line number directly into this field and the component is recalled in the list box above for review or deletion.

  • Material - enter or select from the query the Product Code for each component used to make the finished Product. All Product Codes entered must already exist in IM13 as type 'PP' or 'WO'.

    Once the product is entered in the material field, the description of the product from IM13 automatically displays in the field directly below the material field.

    Note: The following products cannot be used as components for a work order:

    • AS - assembled set
    • MO - model
    • Products that are lot or serial controlled

  • Qty Required - enter the quantity of this component that is required to produce the Planned Quantity of the finished WO Product. For example, if the finished Product is a Stool, then 3 legs are required; if the finished Product is a Chair, then 4 legs are required.

  • SKU - the SKU associated with the current component automatically displays. The SKU is taken from IM13/Stock. This field is for information purposes only and cannot be edited.

  • Warehouse - enter or select from the query the Warehouse from which this component stock is to be relieved when the PO for the Work Order is received in Enter Receipts/In-Transits (PO60). You can modify the Warehouse as required.

    • Note: In PO40 if you are adding a component to a work order you do not get an option to assign the warehouse; it defaults to the 'Default Warehouse' assigned in WO13 for this work order product.

  • Waste - there may be situations when waste must be accounted for at the component level in the production process to obtain the desired Planned Quantity for the Work Order Product. The Waste field is unit based, and is represented by the SKU assigned to the component Product. The waste units are divided by the Per Value units to calculate a factored Waste Quantity that is then added to the Qty Required to arrive at the Production Quantity.

      For example, in the production or building process, there may be certain components that are prone to loss or waste as a by-product of the production process and handling damage. You may be using twist ties, or wrapping paper that is prone to tearing and as a result, some of your Material will be damaged in the process. You need to determine the amount of this damage in units and relate this number to the Per Value. You may have a waste of 5 wrapping sheets per 250 units produced. Five (5) is the number you enter in the Waste field.

  • Per Value - relates to the Waste amount. If you have a waste of 5 units per 250 units made, then the Per Value is 250. If, on the other hand, you want to obtain a percentage value of waste, then the Per Value should always be set to 100 and the Waste set to the percentage value, like 12, which represents a 12% waste factor.

  • Production Qty - this is the TOTAL quantity required in the production process to make the Planned Quantity of the WO Product. The Production Quantity is calculated as:

    [(Waste / Per Value) * 100] + Qty Required

    Note: This is also the quantity that is relieved from inventory during the production of the Work Order.

  • Wght Average Cost - this is the cost that is multiplied by the Production Quantity to obtain the total component line Extension for the total Work Order cost calculation.

  • Extension - this field is calculated as the Production Quantity multiplied by the Weighted Average Cost.

  • Total Cost - this is the TOTAL cost for the Planned Quantity for this Work Order Product. It is calculated by adding the Total extended Landing Factors cost to the Total Component extension cost.

The following table outlines the functionality of each button in WO13:

Button Label Icon Functionality
Submit Submit Saves the component Product Code and all its details to the Work Order.
Delete Delete Deletes the component line currently highlighted or recalled in the list box from the Work Order.
Clear Clear Clears all the fields on the screen allowing you to create a new Work Order.
Copy Copy Opens the Copy To window. Enter or select from the query a WO Product in the 'Enter a valid Finished Product' field and click OK. A Confirmation window opens with the following message: "Are you sure you want to copy Current WO Product to an Existing WO Product Code? Yes/No". Select Yes to have the current WO Product's details copied over to the existing WO Product Code.
Delete Work Order Delete Record Deletes all information related to the current Work Order. Before the information is deleted, the following message displays: "Delete Header and all its details? Yes/No". Select Yes to confirm the delete request; select No to cancel the delete request.

 Maintain Work Order Products(WO13)
Maintain Work Order Products (WO13)