Books Number of Books Title Total Profit Total Weight per Box Harry Potter and The Sorcerer's Stone, JK Rowling The Lord of the Rings, JRR Tolkien The Chronicles of Narnia, CS Lewis The Golden Compass, Phillip Pullman The Lightning Thief, Rick Riordan A Wrinkle in Time, Madeleine L'Engle Weight per Book 2.5 2 1.5 3 1.8 1.3 Cost Sale per Book Price $ 9.00 $ 15.00 $ 18.00 $ 29.00 $ 16.00 $ 25.00 $ 8.00 $ 17.00 $ 12.00 $ 21.00 $ 10.00 $ 18.00 Box Total $ $ $ $ cole 0 0 0 0 0 0 0 0 0 Instructions: Use Solver to find the mix of books that will maximize total profit based on the following constraints. Constraints: Every box must contain no more than 25 books TOTAL ***Total weight must be equal to or less than 30 pounds ***At least two, but no more than 5 of each book title needs to be in the box ***No partial books and no "negative" books can be shipped Hint: Click on the red triangles for help. cells in red require a formula for Solver to work properly Questions: What is the total weight for all books together? What is the total profit for all books together? Which book title had exactly three books added to the box? What is the total number of books per box