LinearProgrammingAssignmentv$3$

Bookco Publishers is considering publishing five textbooks. The the selling price of each textbook, the variable cost of producing each textbook, and the maximum number of copies of each textbook that can be sold are given in the above table.

Bookco is limited by two resources. One is capacity. They can produce at most $10,000$ books in total. Second is budget. They have $$170,000$ to spend on producing the books. The cost of producing the books is equal to the sum of the number produced of each book multiplied by the respective variable cost. For example, if they produce $2000$ copies of Book $2$ and $1000$ copies of Book $5,$ then the total cost is ${2000}^{**}$$$20+1000**$$$22=$$$62000.$

Bookco wants to maximize its profit. Profit is calculated by the sum of the profit for each book. For example, if they produce $2000$ copies of Book $2$ and $1000$ copies of Book $5,$ then the profit is $2000**($$$40-$$$20)+1000**($$$40-$$$22)=$$$58000$

Formulate a linear program mathematically to determine how Bookco can maximize its profit. Create a spreadsheet model and solve using Solver. Turn in your spreadsheet model, Answer Report and your answers to the following questions $($put your answers below$).$

Questions:

What is the optimal solution $($ that js the optimal produced of each type of book$)?$

How many books are produced in total?

What is the optimal profit?

Does the optimal solution spend all the budget? If not, how much is left over?