MPL Model Library

   {  Exmpl_8.3-2b_BetterProdCo.mpl  }

   {  Hillier and Lieberman, Introduction to Operations Research, 7th ed.  }

   {  Chapter 8.3,  Example 2b, Assignment, Size 10x25, Page 386  }


TITLE
   BetterProdCo_Option2;

OPTIONS
   ExcelWorkbook="Exmpl_8.3-2b_BetterProdCo.xls"
   ExcelSheetName="Better Products 2"

INDEX   
   plant :=  EXCELRANGE("Plant");
   product := EXCELRANGE("Product");

DATA
   M := 99999;
   Cost[plant, product] := EXCELRANGE("Cost");

BINARY VARIABLE  
   Assign[plant, product] -> x
       EXPORT TO EXCELRANGE("Assign");

MODEL
   MIN TotalCost 
     EXPORT TO EXCELRANGE("TotalCost")
     = SUM(plant, product: Cost * Assign);

SUBJECT TO
   Assignee[plant] : SUM(product: Assign) = 1;
   Task[product] : SUM(plant: Assign) = 1;

END

Return to MPL Model Library