Support

This gives the user the option to sort the display order of the part types when setting up parts in the Inventory Control Management module. (See the following article for further detail).

Inspection Required

This box, when checked, flags the Receiving Department that the parts must go through Receiving Inspection prior to placement in the stockroom.

Certification Required

This box, when checked, flags the Receiving Department to check that the vendor included the appropriate certification for the parts, and/or that the Shipping Department included certification. The types of certificates are Receiving, Shipping, or Both.

Unit of Measure

The unit of measure for both stocking and purchasing must have already been entered in the “Unit of Measure” setup.

Package

The packaging description for the parts must have already been entered in the “Part Package” setup.

ABC

The ABC codes for the parts must have already been entered in the “ABC Types” setup.

Run Scrap %

This is the amount (in percentage of the parts issued to a Work Order) that will be added to the kit to compensate for materials normally lost in the production processes. It is typical to have some floor losses associated with very small and inexpensive parts that may have to be replaced in the kit. This percentage will be used to issue additional parts to a kit for a Work Order, and by Material Requirements Planning when generating requirements for un-kitted Work Orders and forecasts. This number should be at a minimum to avoid ordering excess material, but should be practical enough to avoid shortages when needed for Work Orders in production.  

Setup Scrap Qty

This is the amount (in fixed quantity) of parts that, on the average, are consumed in the setup of the parts when tape leaders are used. Sometimes a user knows that there may be several setups from one reel of parts, and that for each setup there are a fixed number of parts on the tape that will be lost when the lot runs. This number may be used to ensure that sufficient parts are ordered and available for kitting. Material Requirements Planning uses this number based on the number of work orders required to meet demand. 

Order Policy (frequency)

This value determines how often an order action is created for a part. If the part is used in many different assemblies with many different Work Orders, the Material Requirements Planning module may create many purchasing actions for the same part. In order to reduce the work load in purchasing, the user is offered a choice of order conditions, which accumulates the orders into one action. These choices are: lot for lot, daily, weekly, semi-monthly, monthly, and quarterly.

Lot for Lot

This means that each Work Order will create a demand and separate purchasing order action. The order action will be initiated based on the due date for each of the intended Work Orders.
 

Daily    

Instead of creating an order action for each and every work order, all of the Work Orders with actions due on the same day will be grouped together. The order action is created once per day, with the total quantity needed for the day included in the order action.
 

Weekly    

This works the same way as Daily, except that all order actions due within a week period are pulled forward to a specific day and all actions combined for that day. Part of selecting this option includes selecting the day of the week that the order action is to be effective. Once the day is established, the Materials Requirements Planning module will move all order actions in the interval to the beginning of the interval and combine them. The user may wish to use different days for different part classes and types, so that the buyer’s workload is distributed throughout the week.
 

Semi Monthly

With this option, the user may select the days of the month in which the order action takes place. For example, the 1st and the 15th may be chosen, or the 10th and the 25th. Again, these dates may be arranged for different part types to spread the load in purchasing.
 

Monthly

Only one day of the month is requested, and all order actions will be moved forward to that date.
 

Quarterly

Only one month of the quarter is requested, and all order actions will be moved forward to that date.
 

Order Multiple Quantity

This value is used by the Material Requirements Planning module to determine how to order parts over and above the minimum quantity. If a part comes in 5000 unit reels (and only in 5000 unit reels), the order multiple would be entered as 5000. If the Material Requirements Planning module determines that a quantity of 5010 is needed, it will create an order action for the full 10,000 parts.

Minimum Order Quantity

This value is used by MRP to determine how to order parts. Although this may be less than the order quantity, it is more likely that the vendor will not sell (for the price) less than a certain quantity, with order multiples beyond that quantity. For example, there may be an order minimum of 50,000 parts, but order multiples of 5,000 are offered beyond that quantity.

It is especially important to watch this value in connection with the order frequency, as a part with an order frequency of lot-for-lot and a minimum order quantity may result in purchasing actions of multiple requirements at the minimum, instead of combining the requirements to meet the minimum.

Reorder Point

This is the safety stock quantity. It is established so that whenever the inventory drops below this point, order actions are initiated to purchase additional parts. This feature might be used to maintain free stock items, such as nuts and bolts, and may be set at the approximate usage experienced in the time it takes to replace the parts.

Reorder Quantity

The is the number of parts to be ordered whenever a reorder point is encountered. The Materials Requirement Planning module will use this quantity in the order action.

Buyer

The buyer code for the parts must have already been entered in the Inventory Buyer setup.

Lead-times

All lead times are calculated with the Production Calendar. There are three types of lead-times available in manexSQL to describe the duration required for an operation: purchasing, kitting, and production. 

Purchasing

This is the amount of time that the vendor needs to have the parts delivered to the user’s dock. It begins when the order is placed with the vendor and ends when the part arrives at the user’s dock. The Materials Requirements Planning module uses this value to determine when the order action dates should occur in order to have the parts in stock when the kit is due to be pulled.

Kitting   

This is the amount of time that the stockroom needs to pull a kit for the product. It is used only in assemblies and is not available for purchased parts. The Materials Requirements Planning module uses this value to add to the production lead-time and determine when the kitting should begin.

Production  

This is the amount of time that it takes to manufacture or assemble the product. It includes the duration from the time the kit is released to production to the time the product is shipped. The Materials Requirements Planning module uses this value to determine when all parts must be in stock and the Work Order initiated in order to meet the delivery date.
 

Push-out / Pull-in

These values, in days, determine the sensitivity of the Materials Requirements Planning module to changes in demand. If the due date for an order moves within these values, no order action is initiated to modify Purchase Orders or Work Orders in progress. If the due date falls outside of these parameters, order actions to move the Purchase Orders or Work Orders will be initiated. 

The values used here should be influenced by the part cost (the more expensive, the tighter the control), the order frequency (about one-half the order frequency is recommended), and the user’s policy regarding the cost of purchasing versus the cost of inventory. The lead-time and part availability may also be a consideration, with difficult to obtain parts having tighter sensitivity. The Materials Requirements Planning module takes these parameters into account for changes in scheduled dates, but not for changes in quantities, since it is assumed that changes in quantity should be addressed regardless of the push-out/pull-in days.

Material Cost

In systems with manexSQL's Accounting module installed, the amount entered in this field is used for cost accounting functions. If cost accounting is not being used, the field can show actual, target, or user-defined cost. The Material Cost field adds into the Standard Cost total. 

Note: (If Accounting is installed.) For all BUY parts, the material cost field must have data entered. If this data is missing or incorrect, the Raw Materials Inventory and the Work In Process (WIP) will be incorrect for the accounting records. 

All MAKE parts which are not labor only (the customer provides the kit and you apply the labor) must have data entered in the Material Cost field. Additionally, the data entered in the Material Cost field for the MAKE part must equal the sum of the Bill of Materials components. (Please refer to Bill of Materials Reports - Bill of Material With Standard Cost.) 

If data is missing or incorrect on a MAKE part, the Work In Process, Cost of Goods Sold, and Finished Goods Inventory will be incorrect in the accounting records. If the sum of the Bill of Materials components does not equal the standard cost per the Item Master, a configuration variance will generate.

Labor Cost

This is the cost of the labor associated with the part. The Labor Cost field will add into the Standard Cost total.
 

Overhead Cost

This is the overhead burden if the user wants to capture the overhead at the assembly level. The Overhead Cost field will add into the Standard Cost total.
 

Other Costs

This encompasses any other costs associated with the part. The Other Costs field will add into the Standard Cost total.
 

User Defined Costs

This includes any additional costs associated with the part, as defined by the user. The User Defined Costs field will add into the Standard Cost total.
 

Standard Cost

This is the total of the following costs: Material, Labor, Overhead, Other Costs, and User Defined.
 

Target Price

This field is currently only a data entry field and will be reflected in the Purchase Order module for BUY or MAKE/BUY parts. 
 

Tracking by Lot number / Date code

If this box is checked, the user will be required to enter the lot number, date code, expiration date (optional), and internal lot number information whenever performing a transaction for the part. If the user wishes to maintain inventory to this level, then they must enter information each time a part is moved. This will allow complete traceability by date and lot code for products assembled. 

The user will be able to determine all Work Orders or Sales Orders in which a certain date code was used. 

Note: This field cannot be edited once the part type record has been saved. 

Auto-date for Internal Lot Code 

When using lot tracking, this feature will automatically assign the current date as the internal lot code. This field may be appended or overwritten by the user during the transaction, if desired.

Product Expiration Days

When using lot tracking, this feature will automatically assign the current date plus the product expiration days as the expiration date on completed products moved to Finished Goods. This field may be appended or overwritten by the user during the transaction if desired.