Mr. Smith, an avid reader, must decide on which books to take with him during a long flight. Mr. Smith will use his carry-on bag, which can hold a maximum of 20 pounds. Mr. Smith has attached a satisfaction index for each book, based on a 5-point scale (1 = low satisfaction, 5 =high satisfaction), as shown below.

Book Satisfaction Index Weight (lbs.)

Marketing 4 4

History 5 3

Statistics 1 3

Management 3 5

Finance 3 4

Economics 2 3

Excel 5 4

Access 4 5

Which books should Mr. Smith take with him on the flight to maximize his satisfaction index?

Use Excel's Solver to solve this problem.

Please include Excel screen shots showing the formulas being used and the Solver inputs.