ADVANCED MATHUse LINDO, LINGO, or Excel Solver to find the optimal solution to the following IP: Bookco Publishers is considering publishing five textbooks. The maximum number of copies of each textbook that can be sold, the variable cost of producing each textbook, the sales price of each textbook, and the fixed cost of a production run for each book are given in Table 16 Thus, for example, producing 2,000 copies of book 1 brings in a revenue of 2,000(50) = $100,000 but costs 80,000 + 25(2,000) =$130,000. Bookco can produce at most 10,000 books if it wants to maximize profit. TABLE 16:
$$
\begin{matrix} \text{Book}\\\text{ } & \text{1} & \text{2} & \text{3} & \text{4} & \text{5}\\ \text{Maximum Demand} & \text{5,000} & \text{4,000} & \text{3,000} & \text{4,000} & \text{3,000}\\ \text{Variable Cost (\$)} & \text{25} & \text{20} & \text{15} & \text{18} & \text{22}\\ \text{Sales Price (\$)} & \text{50} & \text{40} & \text{38} & \text{32} & \text{40}\\ \text{Fixed Cost (\$ Thousands)} & \text{80} & \text{50} & \text{60} & \text{30} & \text{40}\\ \end{matrix}
$$