Bookco Publishers is considering publishing five textbooks. The maximum number of copies of each 334 Chapter 6 Optimization Models with Integer Variables textbook that can be sold, the variable cost...

Bookco Publishers is considering publishing five textbooks. The maximum number of copies of each 334 Chapter 6 Optimization Models with Integer Variables textbook that can be sold, the variable cost of producing each textbook, the selling price of each textbook, and the fixed cost of a production run for each book are given in the file P06_55.xlsx. For example, producing 2000 copies of book 1 brings in a revenue of (2000)(50)= $100,000 but costs 80,000 + 25(2000)= $130,000.

a. Determine how Bookco can maximize its profit if it can produce at most 10,000 books.

 b. Use SolverTable to analyze the effect on the optimal solution of a change in the demand for book 1. Repeat for the demands for the other books.