Results 1 to 1 of 1

Math Help - Linear Programming Maximizing

  1. #1
    Newbie
    Joined
    Dec 2009
    Posts
    1

    Linear Programming Maximizing

    Hi All,

    I need help on the Linear programming in excel solver. Question as follow

    The amt of radiation delivered to each region by each type of beam is shown below.

    If each region of normal tissue can handle at most 60 units of ratiation, which beams should be used to maximize the total amount of radiation received by the tumors?

    Beam Normal 1 Normal 2 Normal 3 Tumor 1 Tumor 2 Tumor 3
    1 24 18 12 30 18 9
    2 18 15 9 27 23 12
    3 14 12 20 20 15 26
    4 6 18 18 9 27 24
    5 14 6 17 20 8 21
    6 12 11 11 15 15 15




    How to prepare the model and how to used excel solver to maximise this problem.

    Thanks.
    Last edited by engsiang28; December 14th 2009 at 08:32 PM.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Linear Programming
    Posted in the Pre-Calculus Forum
    Replies: 1
    Last Post: December 20th 2008, 12:53 AM
  2. Replies: 1
    Last Post: November 17th 2008, 03:18 AM
  3. Linear programming
    Posted in the Pre-Calculus Forum
    Replies: 3
    Last Post: May 24th 2008, 01:47 AM
  4. Linear Programming
    Posted in the Calculus Forum
    Replies: 0
    Last Post: May 6th 2008, 08:52 PM
  5. Linear Programming
    Posted in the Pre-Calculus Forum
    Replies: 0
    Last Post: September 20th 2007, 11:42 AM

Search Tags


/mathhelpforum @mathhelpforum