Cengage is publishing the best and latest textbooks each year. However, it is too costly to produce every book to be published each year. The following are the books that are being considered for publishing. New books are currently in their first edition. The revised books are being upgraded to a new edition. Book New or Revised Edition Expected Sales ($1000s) Expected Costs ($1000s) Business Calculus New 30 Calculus for Science Revised 20 General Statistics New Management Science New 40 Business Statistics Revised 25 Finance Revised Financial Accounting New 25 Managerial Accounting New 35 Statistics for Management New Statistics for Economics Revised 32 22 2021 20 10 15 10 4 35 21 30 08 9 7 40 32 30 12 22 It takes a lot of time to review each textbook. Additionally, each textbook requires and understanding of the material provided. Different employees have different background knowledge. There are four employees that can review each of the available textbooks. However, each is available for a limited number of days over the next 6 months due to other project commitments. The four employees are Michael, Emily, Kristina, Kayla and their availability is 100,90,80, and 70 days available, respectively. Based on their knowledge in each subject, the days required by each employee to review each textbook are given below. An X represents that the employee does not have enough knowledge to review the textbook. If a book needs review, each of the three employees will need to spend the following amount of time reviewing it. Book Subject Michael Emily Kristina Business Calculus 18 26 X Kayla 20 Calculus for Science 16 24 X 18 General Statistics 20 X 30 32 Management Science 20 26 24 Business Statistics 14 X 16 22 Finance X 20 14 23 Book Subject Financial Accounting Michael Emily Managerial Accounting Statistics for Kristina Kayla TITT Management Statistics for Economics X 35 28 22 Cengage has the following rules that they want to follow when choosing their textbooks. 1. Cengage wants to publish at least two statistics books 2. Cengage doesn't want to publish more than one Calculus textbook 3. Cengage wants to publish exactly one book with management (or managerial) in the title. 4. Cengage wants to do an equal number of new and revised textbooks. 5. Because of the continuation in courses, if Managerial Accounting is published, they want to publish the Financial Accounting book as well (though Financial is okay on it's own). Managerial Report Prepare a report for Cengage that describes your recommendations for the next year. With the previous conditions met, Cengage's management goal is to maximize the sales revenue. 5. Are there any other recommendations or considerations that you would make for Cengage as they make this decision? Any other observations that you would like to share?