FICO
FICO Xpress Optimization Examples Repository
FICO Optimization Community FICO Xpress Optimization Home
Back to examples browserPrevious example

Overview of Mosel examples for 'Business Optimization' book

Description

List of FICO Xpress Mosel implementations of examples discussed in the book 'J. Kallrath: Business Optimization Using Mathematical Programming - An Introduction with Case Studies and Solutions in Various Algebraic Modeling Languages' (2nd edition, Springer, Cham, 2021, DOI 10.1007/978-3-030-73237-0).

List of provided model files

(Examples marked with * are newly introduced in the 2nd edition, all other models have been converted from the mp-model versions that were provided with the 1st edition of the book in 1997.)
FilenameDescriptionSection
absval.mos Modeling absolute value terms (linearization) 6.5
*absval2.mos, absval2a.mos Modeling absolute value as general constraints 6.5
bench101.mos Parkbench production planning problem (solution to Exercise 10.1) 10.9
bench102.mos Parkbench production planning problem, MIP problem (solution to Exercise 10.2) 10.9
blend, blend_graph Ore blending problem 2.7.1
*boat.mos Boat renting problem (solution for Exercise 3.3) 1.4.1, 3.7
*boat2.mos Multi-period Boat renting problem 1.6
boatdual.mos Dual of the Boat renting problem (solution for Exercise 3.3) 3.7
brewery.mos Brewery production planning (data files: brewery.xlsx, brewdata.dat) 8.3
burgap.mos Generalized assignment problem (solution for Exercise 7.3) 7.10
burglar Small knapsack problem 7.1.1
buscrew.mos Bus crew scheduling 7.8.4
calves.mos Calves and pigs problem 3.3.1
carton.mos Carton production scheduling problem (data file: carton.dat) 10.3
*ch-2tri.mos Minimal perimeter convex hull for two triangles 10.3
*contract.mos, contract_graph Contract allocation problem with semi-continuous variables 10.2.1
couples.mos Feasibility puzzle problem (solution for Exercise 6.5) 6.11
dea.mos Data envelopment analysis (solution for Exercise 5.2) 5.3
dual.mos Dual problem for a small LP (solution for Exercise 3.1b) 3.5.1
*dynbigm.mos Dynamic computation of big-M coefficients for production planning 14.1.2.1
*dynbigm2.mos Production planning problem formulation using indicator constraints 14.1.2.1
*ea_smpld.mos Evolutionary algorithm for supply management 14.1.3.3
euro.mos Choosing investment projects (solution for Exercise 7.5) 7.10
flowshop.mos, flowshop_graph Flowshop scheduling problem (solution for Exercise 7.7) 7.10
*fracprog.mos Fractional programming example 11.1
gap.mos Generalized assignment problem (solution for Exercise 7.2) 7.10
*goalprog.mos Lexicographic Goal Programming 5.4.3
*lagrel.mos Lagrange relaxation applied to the GAP 14.1.3.3
lim1.mos, coco Multi-period, multi-site production planning, LP model (solution for Exercise 5.1) 5.3
lim2.mos, coco_fixbv Multi-period, multi-site production planning, MIP model (solution for Exercise 6.7) 6.11
*manufact.mos Production scheduling problem with SOS formulation (solution for Exercise 6.9) 6.11
multk.mos Multi-knapsack problem (solution for Exercise 7.4) 7.10
network.mos Network flow problem (solution for Exercise 4.3) 4.7
network2.mos Generic formulation of network flow problem (Exercise 4.3) 4.7
*newsvendor.mos Newsvendor problem: 2-stage stochastic programming 11.3.2.1
npv.mos Net present value problem (solution for Exercise 6.8) 6.11
*optgrid.mos, optgrid2.mos Optimal breakpoints for piecewise linear approximation 14.2.3
*portfolio.mos Multi-stage stochastic portfolio investment model 11.3.2.5
primal.mos Primal problem for a small LP (solution for Exercise 3.1a) 3.7
prodx.mos Simple production planning example 2.5.2
projschd.mos, projplan_graph Project scheduling case study 10.2.3
quadrat.mos Linearized quadratic programming example 11.4
*quadrat2.mos Quadratic programming example solved as NLP 11.4
set.mos Set covering problem (solution for Exercise 7.6) 7.10
simple1.mos Simple LP problem (solution for Exercise 2.2) 2.13
simple2.mos Simple LP problem (solution for Exercise 2.3) 2.13
slab.mos Lifting slabs (solution for Exercise 6.6) 6.11
sludge.mos Sludge production planning example illustrating recursion 11.2.1
*sludge2.mos Recursion example solved as NLP 11.2.1
*teams.mos (solution for Exercise 6.4) 6.11
trim1.mos Trimloss problem LP formulation (solution for Exercise 4.1) 4.1.1
trim2.mos Trimloss problem MIP formulation (solution for Exercise 4.2) 4.1.2
*trimminlp.mos Trimloss problem formulated as a MINLP problem 13.3
*trimminlp2.mos Alternative NLP solver choice for trimloss problem 13.3
tsp.mos Traveling salesman problem (solution for Exercise 7.1) 7.10
*vrp, vrp_graph Vehicle routing - heating oil delivery problem 7.2.3
*woods.mos (solution for Exercise 2.1) 2.13
yldmgmt.mos Yield management, financial modeling 8.4.2

bsnsoptbook_ovw.zip[download all files]

Source Files

Data Files





bench102.mos

(!*********************************************************************
   Mosel Example Problems
   ======================

   file bench102.mos
   `````````````````
   ParkBench production problem - MIP version 
   Assumption: stock charged for at end of quarter
   
     Solution to exercise 10.2 in section 10.9 of
     J. Kallrath: Business Optimization Using Mathematical Programming -
     An Introduction with Case Studies and Solutions in Various Algebraic 
     Modeling Languages. 2nd edition, Springer Nature, Cham, 2021 

   author: S. Heipcke, June 2018

   (c) Copyright 2020 Fair Isaac Corporation
  
    Licensed under the Apache License, Version 2.0 (the "License");
    you may not use this file except in compliance with the License.
    You may obtain a copy of the License at
 
       http://www.apache.org/licenses/LICENSE-2.0
 
    Unless required by applicable law or agreed to in writing, software
    distributed under the License is distributed on an "AS IS" BASIS,
    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    See the License for the specific language governing permissions and
    limitations under the License.

*********************************************************************!)

model 'bench102'
  uses "mmxprs", "mmsystem"
  parameters
    PART2= 1          ! Set this to 1 if part2, else 0
  end-parameters

  declarations
    NB= 2             ! Number of benches
    NQ= 4             ! Number of time periods
    RQ=1..NQ          ! Time periods
    RB=1..NB          ! Benches
    RR={"beech", "steel", "labour"}  ! Raw materials

    revenue: mpvar   ! Revenue from selling benches
    cost: mpvar      ! Cost of making benches, assuming all beech at high price
    make: array(RB,RQ) of mpvar   ! Number of b made in quarter q
    sell: array(RB,RQ) of mpvar   ! Number of b sold in quarter q
    stck: array(RB,RQ) of mpvar   ! Number of b in stock at end of quarter q
 
    saving: mpvar                 ! Savings made from buying cheap beech
    bchhi: array(RQ) of mpvar     ! Amount of beech bought in quarter q at high price
    bchlo: array(RQ) of mpvar     ! amount of beech bought in quarter q at low price
    iflo: array(RQ) of mpvar      ! =1 if some beech bought at low price
  end-declarations

  declarations
    SP: array(RB,RQ) of real      ! Selling price of b in quarter q
    RMCOST: array(RR,RQ) of real  ! Raw material cost of r in quarter q
    AVAILL: array(RQ) of real     ! Availability of labour (raw material 3) in quarter q
    REQ: array(RB,RR) of real     ! Requirement of b for raw material r
    DMND: array(RB,RQ) of real    ! Maximum number of b that can be sold in q
    OSTOCK: array(RB) of real     ! Opening stock
    MFGCOST: array(RB,RQ) of real ! Cost of making b in quarter q at high beech price
 
    BREAKP: array(RQ) of real     ! Breakpoint from high to low beech price
    BCOSTLO: array(RQ) of real    ! Lower beech price
    MXB: array(RQ) of real        ! Maximum beechwood that could be bought
  end-declarations

  SP::(1..2,1..4)[850, 890, 860, 750,
                 1050,1200, 900, 810]

  RMCOST::("beech",1..4)[ 28, 34, 22, 18]   
  RMCOST::("steel",1..4)[100,100,100,100] 
  RMCOST::("labour",1..4)[90, 90, 90, 90]     

  AVAILL::(1..4)[48, 42, 23, 46]

  REQ::(1..2,["beech", "steel", "labour"])[14.2, 1.83, 1,
                                           22.4, 1.94, 1.26]
  DMND::(1..2,1..4)[10, 20, 30, 10,
                     8, 25, 30, 5]
  OSTOCK::(1..2)[2, 4]

  if PART2 > 0 then
    BREAKP::(1..4)[300, 500, 350, 250]
    BCOSTLO::(1..4)[20, 25, 20, 15]
  end-if

  forall(b in RB,q in RQ)
    MFGCOST(b,q):= sum(r in RR) RMCOST(r,b)*REQ(b,r)

  if PART2 > 0 then
    forall(q in RQ) MXB(q):= 4000               ! Lazy BOB
  end-if

 ! Objective function: total profit
  if PART2 > 0 then
    Saving:= saving = sum(q in RQ)(RMCOST("beech",q) - BCOSTLO(q))*bchlo(q)
    Profit:= revenue - cost + saving
  else
    Profit:= revenue - cost
  end-if

  Rev:= revenue = sum(b in RB,q in RQ) SP(b,q)*sell(b,q)

  Cost:= cost = sum(b in RB,q in RQ) MFGCOST(b,q)*make(b,q) +
                   sum(b in RB,q in RQ) 82*stck(b,q)

 ! Stock balance
  forall(b in RB,q in 2..NQ)
    Bal(b,q):= stck(b,q) = stck(b,q-1) + make(b,q) - sell(b,q)
  forall(b in RB,q=1)
    Bl1(b,q):= stck(b,q) = OSTOCK(b) + make(b,q) - sell(b,q)

 ! Maximum stock one can have is 10 units
  forall(q in RQ)
    Mxstock(q):= sum(b in RB) stck(b,q)<= 10

 ! Labour availability
  forall(q in RQ)
    Lab(q):= sum(b in RB) REQ(b,"labour") * make(b,q)<= AVAILL(q)

 ! The tricky stuff:  bchhi+bchlo = total beech used.
 ! If we get some at cheap price (iflo==1) we must have bchhi=BREAK.
 ! If iflo==0 then bchlo must be 0.
  if PART2 > 0 then
    forall(q in RQ)
      Bch(q):= bchlo(q) + bchhi(q) = sum(b in RB) REQ(b,"beech")*make(b,q)
    forall(q in RQ) BUp(q):= bchhi(q)>= BREAKP(q)*iflo(q)
    forall(q in RQ) BLo(q):= bchlo(q)<= MXB(q)*iflo(q)

    forall(q in RQ) bchhi(q)<= BREAKP(q)
    forall(q in RQ) iflo(q) is_binary
  end-if

 ! Cannot sell more than demand
  forall(b in RB,q in RQ) sell(b,q)<= DMND(b,q)

 ! Closing stock = opening stock
  forall(b in RB) stck(b,NQ) = OSTOCK(b)

 ! Solve the problem
  maximise(Profit)
  writeln("Solution: Profit=", getobjval)

  writeln("Production plan: make/sell (stock)")
  forall(b in RB) do
    write("Bench ", b, ":    (", OSTOCK(b),")  ")
    forall(q in RQ)
      write(formattext("%4.1f/%4.1f (%4.1f)  ", 
            make(b,q).sol, sell(b,q).sol, stck(b,q).sol))
    writeln
  end-do

  if PART2 > 0 then
    writeln("Amounts of beech wood bought:")
    write("high price: ")
    forall(q in RQ) write(strfmt( bchhi(q).sol,8,1))
    write("\nlow price:  ")
    forall(q in RQ) write(strfmt( bchlo(q).sol,8,1))
    write("\nsaving:     ")
    forall(q in RQ) write(strfmt( getsol((RMCOST("beech",q)-BCOSTLO(q))*bchlo(q)),8,1))
    writeln
  end-if
end-model

Back to examples browserPrevious example