MPL Model Library

   {  Exmpl12.4-2b_TVSpots.mpl  }

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

   {  Chapter 12.4,  Example 2b, Marketing (MIP), Size 7x12, Page 595  }


TITLE
   TVSpots;

OPTIONS
   ExcelWorkbook="Ch_12_Integer_Programming.xls"
   ExcelSheetName="Supersuds 2"

INDEX
   product:= EXCELRANGE("Product2");
   spots := EXCELRANGE("spots1");

DATA
   Slope[product, spots] := EXCELRANGE("Slope");                    
  
BINARY VARIABLE
   y[product, spots]
      EXPORT TO EXCELRANGE("yVar");   

MODEL
   MAX TotProfit 
     EXPORT TO EXCELRANGE("TotProfit1")
     = SUM(product, spots: Slope * y);

SUBJECT TO
   Cnst [product, spots=2..3] : y[product, spots] - y[product, spots-1] <=0;
   Tot : SUM(product>0, spots>0: y) =5;

END

Return to MPL Model Library