|
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Pass No. |
Material Name |
Lot Number |
Minimum Weight |
Optimum Weight |
Unit Weight |
Opt Unit % 85 |
Action Taken by ABS System |
|
1 |
360 M/S |
100 |
0.0 |
911.4 |
1500.0 |
60 |
Min & Max=Zero |
|
1 |
360 M/S |
200 |
0.0 |
0.0 |
700.0 |
0 |
Min & Max=Zero |
|
1 |
360 M/S |
300 |
0.0 |
0.0 |
300.0 |
0 |
Min & Max=Zero |
|
1 |
360 M/S |
400 |
0.0 |
0.0 |
900.0 |
0 |
Min & Max=Zero |
|
1 |
360 M/S |
500 |
0.0 |
0.0 |
600.0 |
0 |
Min & Max=Zero |
Figure 1
The materials are always read and processed by name and lot number order. If all materials in Figure 1 had the same chemistry and same cost, and if the optimum solution was 911 lbs., the 911 would be for lot 100. Since 911 is 60% of the unit weight, this material would be rejected by ABS since the optimal unit percentage is set to 85%.
It is at this point that the processing of unit weight materials varies by company. Most clients have multiple lots with the same name and same chemistry. Therefore, if one tub/bin doesn’t fit (because of unit weight constraints), we can substitute another one. In Figure 1 we could use lots 300 and 500 (total of 900 lbs.) or lot 400 (900 lbs.) to satisfy the 911 lb. optimal weight desired.
If custom option #17 in the CUSTOM.KSI file is activated (set to YES), the program will sort all of the lots in descending order (see Figure 2) and try to get the 911 optimal weight. The program would, therefore, select lot 400 to satisfy the 911 lbs. required and set the min and max weight to zero for all other lots.
|
Pass No. |
Material Name |
Lot Number |
Minimum Weight |
Optimum Weight |
Unit Weight |
Opt Unit % 85 |
Action Taken by ABS System |
|
1 |
360 M/S |
100 |
0.0 |
911.4 |
1500.0 |
60 |
Min & Max=Zero |
|
1 |
360 M/S |
400 |
0.0 |
900.0 |
900.0 |
100 |
Min & Max=900 |
|
1 |
360 M/S |
200 |
0.0 |
11.4 |
700.0 |
1 |
Min & Max=Zero |
|
1 |
360 M/S |
500 |
0.0 |
11.4 |
600.0 |
1 |
Min & Max=Zero |
|
1 |
360 M/S |
300 |
0.0 |
11.4 |
300.0 |
3 |
Min & Max=Zero |
Figure 2
Some clients use the material name to indicate the material supplier or vendor. If this method is used, then each material may have a very different chemistry and cost, and we shouldn’t attempt to reassign the optimal weight to the other group in descending or ascending order. We need to process each material as a unique item. This is done automatically by ABS — no option needs to be set to force ABS to operate in this mode.
When Special Option #58 is set to YES, each unit weight material record is read and processed as follows.
The sorted work file contains one record for each unit weight material selected. If the Class Code Index is greater than 3, the lot number is assigned as "(All Lots)". For example:
|
Class Code Index |
Material Name |
Lot Number |
Optimal Weight |
Unit Weight |
Location Row/Column |
|
1 |
SEC |
1 |
800 |
1000 |
|
|
1 |
SEC |
2 |
950 |
1000 |
|
|
4 |
MG2 |
(All Lots) |
5,263 |
|
20-A |
|
4 |
MG2 |
(All Lots) |
3,000 |
|
14-B |
|
4 |
MG2 |
(All Lots) |
4,000 |
|
16-A |
Since this file was sorted by Class Code Index, if any Index 1, 2, or 3 materials were selected, they will appear first and be processed first. If the unit weight record has a Class Code Index of 1, 2, or 3 then it is processed exactly as if Special Option #58 were set to NO. See the earlier explanation.
NOTE: All sub-classes of Class Codes 1, 2 and 3 will also be assigned Index 1.
If the unit weight record has a Class Code Index greater than 3, the optimal weight will be the "total" optimal weight for all unit weight materials with the same name. The program then begins to assign the total optimal weight to these materials by Row and Column. The material’s Row and Column identifier is derived from the Location Field. When Special Option #58 is set to YES, the Location Field is redefined as:
ROW = Position 1-3 of location
COLUMN = Position 4-8 of location
When the program processes Special Option #58 materials (those with a Class Code Index greater than 3), the following procedure is performed. Following is the true optimal solution based upon cost for item MG2:
|
Material Name |
Lot Number |
Optimal Weight |
Unit Weight |
Location Row/Column |
|
MG2 |
029013 |
896 |
896 |
20-A |
|
MG2 |
028720 |
678 |
678 |
20-A |
|
MG2 |
028864 |
1,780 |
1,780 |
20-B |
|
MG2 |
029004 |
1,264 |
1,264 |
20-B |
| MG2 | 028186 |
0 |
1,100 |
20-C |
| MG2 | 029001 |
0 |
700 |
20-D |
| MG2 | 027123 |
0 |
950 |
20-D |
| MG2 | 028501 |
645 |
645 |
20-E |
|
Total for MG2 (All Lots) |
5,263 |
|||
After the total weight is determined for the material, the program starts with the first material in the row and attempts to set the minimum and maximum weight to the unit weight. If successful, the weight assigned is subtracted from the total optimal weight, and the program proceeds to the next material in the row. For example:
|
Material Name |
Lot Number |
Unit Weight |
Location Row/Column |
Total Weight Assigned |
Weight Remaining |
|
MG2 |
029013 |
896 |
20-A |
896 |
4,367 |
|
MG2 |
028720 |
678 |
20-A |
1,574 |
3,689 |
|
MG2 |
028864 |
1,780 |
20-B |
3,354 |
1,909 |
|
MG2 |
029004 |
1,264 |
20-B |
4,618 |
645 |
| MG2 | 028186 |
1,100 |
20-C | ||
| MG2 | 029001 |
700 |
20-D | ||
| MG2 | 027123 |
950 |
20-D | ||
| MG2 | 028501 |
645 |
20-E |
When Lot # 028186 is reached at Row 20-Column C the unit weight is 1,100. The weight remaining is 645. This is 58% of the unit weight. If this percentage is less than the optimum unit weight percentage established in the Master Directory, the material cannot be used. The minimum and maximum values are automatically set to zero by ABS, and ABS looks at the next material. If the next material in the list is in the same column, it will be evaluated for use. If the next material is in another column, then all remaining materials in the row are also excluded.
In our example, the Unit Constraints Report would show the following:
|
Pass No. |
Material Name |
Lot Number |
Location Row-Colm |
Minimum Weight |
Optimum Weight (A) |
Unit Weight |
Opt Unit % 85 (C) |
Action Taken by ABS System |
|
1 |
MG2 |
029013 |
20-A |
0.0 |
5263.0 |
896.0 |
100 |
Min & Max=896 |
|
1 |
MG2 |
028720 |
20-A |
0.0 |
4367.0 (R) |
678.0 |
100 |
Min & Max=678 |
|
1 |
MG2 |
028864 |
20-B |
0.0 |
3689.0 (R) |
1780.0 |
100 |
Min & Max=1780 |
|
1 |
MG2 |
029004 |
20-B |
0.0 |
1909.0 (R) |
1264.0 |
100 |
Min & Max=1264 |
| 1 | MG2 | 028186 | 20-C | 0.0 |
645.0 (R) |
1100.0 | 58 | Min & Max=Zero |
| 1 | MG2 | 029001 | 20-D | 0.0 |
645.0 (R) |
700.0 | 0 | Min & Max=Zero |
| 1 | MG2 | 027123 | 20-E | 0.0 |
645.0 (R) |
1950.0 | 0 | Min & Max=Zero |
|
1 |
MG2 |
028501 |
20-E |
0.0 |
645.0 |
645.0 |
0 |
Min & Max=Zero |
The report shows the total optimal weight (A). The (R) weight is the remaining weight that needs to be assigned.
When the program attempts to assign the remaining weight to Lot # 028186, because the remaining weight (645) percent (58%) of the material’s unit weight (1,100) is less than the optimal unit % (C), the material cannot be used and the minimum and maximum values are set to zero. The next material is in the same row, but in another column, so all materials remaining in the row will be set to zero.
Previous Technical Bulletin | Next Technical Bulletin | Technical Bulletin Listing