ABC Calculation Based on:
Manually Assigned |
If this radio is selected, the ABC codes are assigned when parts are created based on their class and type and must be updated manually as needed. But MUST be setup in the Inventory Part Type Setup
|
$ Estimated Annual Usage |
If this radio is selected, the ABC codes are assigned based on the value of the estimated annual usage and/or component lead time. Users must run the "Calc EAU" and Calc ABC Codes" programs to refresh EAU and ABC codes.
EAU Calculation: inventory part EAU*(1-EAU%)+total issued qty*12*EAU%. Please note the "total issued qty" get from past one month
After inventory EAU values are update
Get each BUY part number standard cost multiply EAU and divided by the total standard cost multiply EAU of all BUY parts
(qty_oh*EAU) of one BUY part/qty_oh*EAU for all BUY parts
Get each MAKE part number standard cost multiply EAU and divided by the total standard cost multiply EAU of all MAKE parts
(qty_oh*EAU) of one MAKE part/qty_oh*EAU for all MAKE parts
Sort the records by the values from highest to lowest. And then use the rank based on % of values set up for each ABC type, to assign the part to each type. For example, type ‘A’ has 85%, ‘B’ has 10% and ‘C’ has 5%. The program will get the 85% of parts rank from highest to lowest and assign those part number ABC code “A”, etc.
|
$ On Hand |
If this radio is selected, then ABC codes are assigned based on the value of inventory on hand and/or the component lead time. Users must run the "Calc ABC Codes" program to update and refresh the component ABC codes.
Get each BUY part number standard cost multiply qty OH and divided by the total cost of all BUY parts
(qty_oh*stdcost) of one BUY part/qty_oh*stdcost for all BUY parts
Get each MAKE part number cost multiply qty OH and divided by the total cost of all MAKE parts
(qty_oh*stdcost) of one MAKE part/qty_oh*stdcost for all MAKE parts
Sort the records by the values from highest to lowest. And then use the rank based on % of values set up for each ABC type, to assign the part to each type. For example, type ‘A’ has 85%, ‘B’ has 10% and ‘C’ has 5%. The program will get the 85% of parts rank from highest to lowest and assign those part number ABC code “A”, etc.
If lead time is set up in ABC type, and the part has lead time bigger than the set up lead time, the ABC type will be updated to upper level. For example, a part is type ‘C’, but it’s lead time is bigger than the lead time set up for type ‘A”, the part will be updated to type ‘A’
|
EAU Factor % |
If the user selects $ Estimated Annual Usage, Enter in the EAU factor.
|
| Last EAU |
The date that the Last EAU was calculated. |
Ignore In Store |
Check this box only if you do NOT want the In-Store warehouses to be included in the Cycle Counts, regardless of which Calculation Based on is selected.
|
| Exclude Issues Older than __ Days from EAU Calculation |
Enter the number of days you want to exclude older issues from the EAU Calculations. The number of days entered in this field will override the standard 30 days. The default is set to 180 days, but can be changed. |
ABC Types:
| ABC Type |
The ABC code identifies a part source for inventory parts. A = Highest value, B = Medium value and C = Lowest value (Manex allows up to 36 (0-9 and A-Z) alphanumeric ABC designations). ABC codes are applied to Buy and Make part separately.
NOTE: An ABC code needs to be specifically setup for Make parts, if Make parts are to be included in the cycle count. If an ABC code is setup for a buy part and that ABC code is assigned to a Make part the make part will not be included in the cycle count and vice versa.
|
| Description |
Definition of ABC parameters |
| Part Source |
This identifies if a part is a Make or Buy part. Select the desired part Source radio. |
| Dock to Stock |
A Dock to Stock period may be included in each ABC code. Dock to Stock is the number of days a part is expected to take to be delivered to the stock room after the part is received on the user’s dock. This duration may include the amount of time it takes to organize the shipment, count the parts, log the receipt into the inventory system, perform incoming inspection, and physically move the parts to stores. Intuitively, the higher dollar parts may have longer dock to stock times because of increased inspection. And the lesser valued parts may not require inspection. NOTE: ManEx provides for PO Receiving Inspection and for Discrepant Material Returns (Return to Vendor).
The Dock to Stock value is taken into consideration for MRP leadtime calculations in the projected requirement of the receipt of purchased parts. For Example: if the Dock to Stock time is 3 days, and the kit start date is 8/22/08, then the due date for the buy components would be 8/19/08, and the order date would be based on the purchasing leadtime to receive the parts by 8/19/08. So the Dock to Stock time is used to move back the due dates of items purchased in time for kitting
|
| Cycle Count Days |
Users enter the Cycle Count Days of each ABC code. This is used to determine the number of parts to count each day. This is based on calendar days and may need to be adjusted for work days if you will not be cycle counting seven days a week. This field assists in counting all inventory over a period of time. The “A” items might be counted completely within each month. Therefore, a list of all of the “A” items (the highest dollar value) is generated, and randomly divided into 20 days, and each day 1/20th of the list counted and checked. The “B” items might be checked every quarter, and the “C” items checked once a year. This is a way to verify the accuracy of stockroom transactions, and to take measures necessary to keep the counts accurate. Type the ABC Types into the appropriate boxes. NOTE: This field MUST be populated with a number other than "0". If "0" is entered these parts will NOT be included in the Cycle Count.
Example: This is the number of days that you will re-count part numbers for the one of the ABC type, and this is calendar day. Let's say, you have entered 30 days for type "A" part. In inventory you have total of 1,000 type "A" parts. When you run cycle count, it will find how many working days from current day to current day +30, it finds you only have 20 working days, so the program will get 1,000/20 = 50 that the users need to count 50 "A" parts each day. The cycle count will randomly get 50 "A" parts that have not been counted yet. |
| % of Value |
The "% of Value" determines which components will be included in the ABC code based on where their value falls within the total value Pareto (i.e. if A parts have a value of 80%, then all components comprising the top 80% of value will be included, if B parts have a "% of Value" of 15, then all components comprising the next 15% of value will be included, etc). A full 100% must be assigned to both Buy and Make parts. The "ABC calculation based on:" affect the meaning of this field. If Manual has been selected then it does not apply. If $ Estimated Annual Usage (EAU) has been selected, then it is EAU x STD cost and % of that value (top 80%, 15-80%, etc) If $ On-Hand has been selected, then it is On-Hand x STD cost and % of that value (top 80%, 15-80%, etc). Entering data in this field will NOT affect the cycle counting or include any of the parts in the cycle count until the "Calc ABC Codes" button is depressed.
|
| Lead Time > |
The "LT>" determines which components will be included in the ABC code based on their purchasing lead time. This will include all components with an applicable lead time regardless of the on-hand or EAU value. |
| Dollar Amount |
The dollar amount tolerance used in Cycle Count. For each ABC code, ManEx provides a cycle count tolerance, which, if exceeded, will result in reporting unfavorable results during cycle counting. These tolerances may be an absolute dollar value, or a percentage of the inventory being counted. For further information on the cycle count tolerances and what the purpose of setting them up in ManEx is see the attachment <<Cycle Count Tolerance.docx>> |
| Percentage |
The Cycle Count Tolerance Percentage. For each ABC code, ManEx provides a cycle count tolerance, which, if exceeded, will result in reporting unfavorable results during cycle counting. These tolerances may be an absolute dollar value, or a percentage of the inventory being counted. For further information on the cycle count tolerances and what the purpose of setting them up in ManEx is see the attachment <<Cycle Count Tolerance.docx>> |
 |
This button will only be available if the screen is in "EDIT" . Depressing this button will update the EAU field within the ICM screen. The term EAU, (ESTIMATED Annual USAGE) may be considered as consumption, depletion, loss, used up, etc. So the EAU calculations MUST include the In-store issues to be accurate. If a user is issuing a part out of in-store to a Sales Order to be shipped the parts still count as an issue, or usage and was consumed, so it is necessary to include them when considering plans for future usage. If a user were to deliver ALL material directly to work orders from in-house, and these transactions were not included, there would be no calculated EAU. This is why we do NOT allow in-store issues to be ignored. The only time in-store issues will NOT be calculated in the EAU is if they are being returned to the vendor through Inventory Handling.
|
 |
This button will only be available if the screen is in "EDIT" mode. Depressing this button will use the information in the % value and LT> fields are used to determine which parts should have their ABC codes automatically adjusted. After the ABC codes are updated, those parts will be included with the appropriate group for cycle counting. |
 |
This button will only be available if the screen is in "EDIT" mode. Depressing this button will use the information in the % value and LT> fields are used to determine which parts should have their ABC codes automatically adjusted. After the ABC codes are updated, those parts will be included with the appropriate group for cycle counting. |
|
