Management

Exercises

 Linear

 Programming

 with

 Excel

  Exercise

 1

  Gran

 Club

 de

 Jugadores

 offers

 trips

 from

 Cartagena

 to

 the

 casinos

 located

 in

 the

  Cote

  d’Azur.

  The

  Club’s

  weekly

  budget

  for

  promoting

  these

  trips

  is

  800

  Euros.

  This

  money

  can

  be

  spent

  in

  four

  types

  of

  advertisements:

  local

  TV,

  newspaper,

  and

 in

 two

 types

 of

 radio

 spots

 (short

 and

 long).

 The

 company’s

 target

 is

 to

 reach

  the

 maximum

 potential

 audience

 through

 the

 different

 media.

  The

 following

 table

 shows

 the

 number

 of

 potential

 players

 the

 company

 expects

  to

 gain

 by

 placing

 an

 advertisement

 in

 each

 of

 the

 four

 mediums

 as

 well

 as

 the

  cost

 per

 ad

 and

 the

 maximum

 number

 of

 ads

 that

 each

 medium

 allows

 per

 week.

  Media

  Audience

 /

 ad

  Cost

 per

 ad

  Max

 #

 ads

 /

 week

  TV

 (1

 min)

  5.000

  80€

  12

  Newspaper

 (1

 page)

  8.500

  92€

  5

  Radio

 (short)

  2.400

  30€

  25

  Radio

 (long)

  2.800

  38€

  20

  A

  minimum

  of

  5

  spots,

  between

  short

  and

  long,

  is

  required

  by

  the

  radio

  stations.

  Moreover,

  to

  diversify

  its

  campaign,

  the

  company

  decides

  not

  to

  spend

  more

  than

 180

 Euros

 in

 radio

 spots.

 Pose

 a

 linear

 problem

 for

 this

 situation.

  Exercise

 2

  A

 vendor

 at

 indoor

 soccer

 games...