A captain of cricket team has to allot five middle order batting positions to five batsmen. The

average runs scored by each batsman at these positions are given in the following table.

Positions

Batsman

III IV V VI VII

A 40 40 35 25 50

B 42 30 16 25 27

C 50 48 40 60 50

D 20 19 20 18 25

E 58 60 59 55 53

Make the assignment so that the expected total average runs scored by these batsmen are

maximum. Also write linear programming model for above problem. Use solver function in excel.