1
Download User's Manual
Transcript
SAMPLE MODELS 315 Objective of Optimization The objective of optimization is to maximize total profits. The total profit is the sum of individual plant profits, minus the sum of the shipping costs from the individual steel mills. The Worksheet Let’s look at the BLOCK sample file. The BLOCK worksheet was built by directly combining the SHIPPING and PRODMIX worksheets. After combining one copy of the Shipping Cost Reduction model with three copies of the Product Mix model, we performed only slight modifications to link the four individual problems into one comprehensive model. The model is laid out in a 3D workbook on four separate worksheets—a shipping sheet and three separate manufacturing sheets.
