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.