Business Driven Technology 6th Edition by Paige Baltzan

Exercise 128

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, BK Kane, 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 BK's incredibly low prices. BK can order as many overstocked books as he requires, and this week's options include:

Project Focus
When packing a single box, BK must adhere to the following:
20 books or less.
Books by three different authors.
Between four and eight books from each author.
Weight equal to or less than 50 pounds.
BK has come to you to help him determine which books he should order to maximize his profit based on the above information. Using the data file AYK8_Data.xlsx, determine the optimal book order for a single box of books.
Data File: AYK8_Data.xlsx