I need step-by-step so I know how to work this problem in the future.

Project 8: Maximize Profit Books, Books, Books is a wholesale distributor of popular books. The business buys overstocked books and sells them for a discount of more than 50 percent to local area bookstores. The owner of the company, B. K. Kanc, would like to determine the best approach to boxing books so he can make the most profit possible. The local bookstores accept all shipments from Books, Books, Books because of B. K's incredibly low prices. B. K can order as many overstocked books as he requires and this week's options include Title Cost Sale Price Weight 5 lb $9 512 Harry Potter and the Deathly Hallows, J. K. Rowling The Children of Hurin, J.R.R. Tolkien 4 lb $8 $13 The Time Traveler's Wife, Audrey Niffenegger 3.5 lb $7 511 The Dark River, John Twelve Hawks 3 lb $6 $9 , 2.5 lb $5 $7 The Road, Cormac McCarthy Slaughterhouse-Five, Kurt Vonnegut 11b $4 $ 5 When packing a single box B. K must adhere to the following 20 books or fewer Books by the authors . Between fout and eight books from each author Weight equal to or less than 50 pounds B. K has come to you to help him determine which books he should order to maximize his profit based on this information. Using the AYK8 Data.xlsx data file, determine the optimal book order for a single box of books. Date AVS Databas