ABS Technical Bulletin #3

Processing Unit Weight Materials

(tubs, bins, sows, etc.)

(originally released May 3, 1993 / revised June 11, 2003)

The Alloy Blending System computes the optimal solution for a charge design, then reviews the solution to determine if any unit weight materials were selected. If none were selected, the process is complete and a least cost charge design report is displayed.

If unit weight materials are selected, ABS has three different options available for processing them. These options all assume the material name is the same for the various pieces and that more than one piece is available for use.

Key information such as Material Name, Optimal Weight, Class Code Index*, and Location will be written to a temporary work file and then sorted. If Directory Editor Special Option #58 (Optimize Materials by Row/Column) is set to NO, the file is sorted by Material Name, Location, and Unit Weight (in descending order). If Special Option #58 is set to YES, the file is sorted by Class Code Index and Material Name.

At this point, the actual processing of the unit weight materials begins.

MASTER DIRECTORY SPECIAL OPTION #58 = NO (DEFAULT)

When Special Option #58 is set to NO, each unit weight material record is read and processed as follows.

If the Optimal Weight is less than the Optimal Unit Percentage**, the minimum and maximum value for the material is set to zero.

If the Optimal Weight is greater than the Optimal Unit Percentage, the minimum and maximum value for the material is set to the material’s unit weight or to an amount that is a multiple of the unit weight.

The next unit weight record is then read. If the next material name is different from that of the last record, the program then sets the maximum value to zero for all unit weight materials with the last record’s name (that were not selected as candidates) before processing the next material. This procedure is repeated until the material name changes or until all unit weight materials with the same name have been processed.

* The Class Code Index is determined by the class code’s position in the Master Directory’s Material Class section (i.e., the first class code entered is regarded as Index 1, the second class code is regarded as Index 2, etc.).

** The Optimal Unit Percentage is derived from the setting established for Master Directory System Default #1.

For example, Figure 1 displays key information about five different unit weights:

UNIT CONSTRAINTS REPORT

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.

UNIT CONSTRAINTS REPORT

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.

MASTER DIRECTORY SPECIAL OPTION #58 = YES

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:

UNIT CONSTRAINTS REPORT

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