MPL Model Library

   {  Exmpl_3.1-1_WyndorGlass.mpl  }

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

   {  Chapter 3.1,  Example 1,  Product-mix,  Size: 2x3,  Page 25  }


TITLE
    WyndorGlass;

OPTIONS
   ExcelWorkbook="Exmpl_3.1-1_WyndorGlass.xls"
   ExcelSheetName="Wyndor"

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

DATA
    TimeAvail[plant]             := EXCELRANGE("TimeAvail"); 

    ProdTime[plant, product]     := EXCELRANGE("ProdTime");

    Profit[product]              := EXCELRANGE("Profit");
 
VARIABLES                            
    Produce[product] -> Prod
       EXPORT TO EXCELRANGE("Produce");

MODEL

    MAX TotalProfit 
      EXPORT TO EXCELRANGE("TotalProfit")
      = SUM(product: Profit * Produce);

SUBJECT TO

    TimeCapacity[plant] -> TimeCap:

        SUM(product: ProdTime * Produce) <= TimeAvail;

END

Return to MPL Model Library