Question: 2. Duling Milerovoft Excel or Microsoft Project, ante Gumttchet wing the information provided. Project 8: Maximize Profit Books, Books, Boolo is a wholesale distributor of

2. Duling Milerovoft Excel or Microsoft Project, ante Gumttchet wing the information provided. Project 8: Maximize Profit Books, Books, Boolo 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 are bookstores. The owner of the company, B. K. Kane, would like to determine the best approach to boxing books so he an make the most profit possible. The local bookstores accept all shipments from Books, Boola, Books because of B. Kis incredibly low prices, B. K. can order as many overstocked books as he requires, and this week's options include: Sale Title I Weight Cost Price 516 59 $17 Harry Potter and the Deathly Hallows, J. K. Rowling The Children of Hirin, J.R.R. Tolkien 41b $8 $13 The Time Traveler's Wife, Audrey Niffenegger 3.5lb $7 $11 820 The Dark River, John Twelve Hawks 311 $6 $9 The Road, Cormac McCarthy 2.5 lb $5 $7 111 Slaughterhouse-Five, Kurt Vonnegut $4 $5 When packing a single box, B.K must adhere to the following: 20 books or fewer. DLL Tu par unt Price SI $9 $17 Harry Potter and the Deathly Hallows, J. K. Rowling The Children of Hirin, J. R. R. Tollden 41b $8 $13 The Time Travelers Wife, Audrey Niffenegger 3. tb $7 $11 820 I 31 The Dark Risver, John Twelve Hawks $6 $9 The Road, Cormac McCarthy 25 I $5 $7 1 Slaughterbouse-Five, Kurt Vonnegut $4 $5 When packing a single bax, B.K. must adhere to the following: 20 books or fewer. Books by three 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 this information. Using the AYK8_Data.xkx data file, determine the optimal book order for a single box ofbooks. Data file: AYKS_Data.xlsx page AYK.6 Droiect Up AYK EN - Maximize Profits E F Apply Your Knowledge Project 8 - Maximize Profits Input boxes inti Output boxes in yollow Given data in blue Answers in red FOX Shape Media Cominent AYK 8 Colla Mimize Profits Book Boxes Tita Weight Cost Sale Price Number of Books Profit per Book Total Profit per Box Total Weight 9 8 Harry Potter, JK Rowling The Lord of the Rings JRR Tolkien Chronicles of Nami, CS Lewis A Series of Unfortunate Events Lamon Snicket Charlie and the Chocolate Factory Roald Dahl A Win in Time Madeleine L'Engle TO 1 35 3 25 1 17 13 11 9 0 5 4 0 ***20 books or less per box wthree different authors must be in the box Between 4 and from each author trust be in the box ***Total weight must be equal to or less than 50 pounds

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The Thomas Company is in the process of developing a revolutionary new product. A new division of the company was formed to develop, manufacture, and market this product. As of yearend (December 31,...

(1) The Quality of Financial Information Referencing this week?s readings and lecture, describe the quality issues related to reporting revenue. What is the importance of understanding various...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

It was 3 a.m. when the wake-up call startled Steve McKenzie out of deep sleep. McKenzie, a management consultant from New Jersey, was glad to be finally leaving the Bon Star Hotel, a three-star hotel...

Please answer all of the following questions. Chapter 4 questions Question 1 The Accounting Cycle - How do the different steps affect the financial statements? What is the effect on the financial...

Case 11 Equal Exchange: Doing Well by Doing Good1 Rev. Dr. Benita W. Harris Asbury United Methodist Church Frank Shipper, PhD Perdue School of Business, Salisbury University Karen P. Manz Author and...

I've attached the assignment as a word file, thanks! You can use the class readings for this week's assignments. c05MerchandisingOperationsandtheMultiple-StepIncomeStatement.qxd 8/14/10 2:14 PM Page...

I've attached the question as a word file as well as the class text to help with the assignment. Thanks! c05MerchandisingOperationsandtheMultiple-StepIncomeStatement.qxd 8/14/10 2:14 PM Page 226...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

Why would a company use an inventory estimation method?

An important input into the required return on equity in the security market line is the market risk premium. How much is the market risk premium?

Why is important time value of money when opening a new business

What is an example of constructive feedback? provide reference