Reference no: EM133838241
Portfolio Session
Project 1: 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. 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 B. K.'s incredibly low prices. B.
K. can order as many overstocked books as he requires, and this week's options include:
When packing a single box, 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.
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. Get assignment help services from verified experts!
Project 2: Adequate Acquisitions
XMark.com is a major Internet company specializing in organic food. XMark.com is thinking of purchasing GoodGrow, another organic food Internet company. GoodGrow has current revenues of $100 million with expenses of $150 million. Current projections indicate that GoodGrow's revenues are increasing at 35 percent per year and its expenses are increasing by 10 percent per year. XMark.com understands that projections can be erroneous, however; the company must determine the number of years before GoodGrow will return a profit.
You need to help XMark.com determine the number of years required to break even, using annual growth rates in revenue between 20 percent and 60 percent and annual expense growth rates between 10 percent and 30 percent. You have been provided with a template, AYK13_Data.xlsx, to assist with your analysis.
Record your video (must show your face) performing this lab using an appropriate tool (e.g. Zoom), upload the video as private video on YouTube, and share the link alongside excel sheet to Moodle.