PLEASE KINDLY INCLUDE THE EXCEL SOLUTIONS. THANK YOU!

Ferozsons Publishing, Ltd. (FPL) must decide regarding the books to publish next year. The books under consideration are listed in the following table, along with the projected three-year sales expected from each book: Book Subject Type of Book Projected Sales ($1000s) Business calculus New 20 Finite mathematics Revision 30 General statistics New 15 Mathematical statistics New 10 Business statistics Revision 25 Finance New 18 Financial accounting New 25 Managerial accounting Revision 50 English literature New 20 German New 30 The books listed as revisions are texts that FPL already has under contract; these texts are being considered for publication as new editions. The books that are listed as new have been reviewed by the company, but contracts have not yet been signed. Three individuals in the company can be assigned to these projects, all of whom have varying amounts of time available; Hashim has 60 days available, and Rukhsana and Mehwish both have 40 days available. The days required by each person to complete each project are shown in the following table. For instance, if the business calculus book is published, it will require 30 days of Hashim's time and 40 days of Rukhsana's time. An "X" indicates that the person will not be used on the project. Note that at least two staff members will be assigned to each project except the finance book. Book Subject Business calculus Finite mathematics General statistics Mathematical statistics Business statistics Finance Financial accounting Managerial accounting English literature German Hashim 30 16 24 20 10 X 40 Rukhsana 40 24 X X X 24 28 34 50 Mehwish X 30 24 16 14 26 30 30 36 FPL will not publish more than two statistics books or more than one accounting text in a single year. In addition, management decided that one of the mathematics books (business calculus or finite math) must be published, but not both. Managerial Report Prepare a report for the managing editor of FPL that describes your findings and recommendations regarding the best publication strategy for next year. In carrying out your analysis, assume that the fixed costs and the sales revenues per unit are approximately equal for all books; management is interested primarily in maximizing the total unit sales volume. The managing editor also asked that you include recommendations regarding the following possible changes: 1. If it would be advantageous to do so, Rukhsana can be moved off another project to allow her to work 12 more days. 2. If it would be advantageous to do so, Mehwish can also be made available for another 10 days. 3. If one or more of the revisions could be postponed for another year, should they be? Clearly the company will risk losing market share by postponing a revision. Include details of your analysis in an appendix to your report. Ferozsons Publishing, Ltd. (FPL) must decide regarding the books to publish next year. The books under consideration are listed in the following table, along with the projected three-year sales expected from each book: Book Subject Type of Book Projected Sales ($1000s) Business calculus New 20 Finite mathematics Revision 30 General statistics New 15 Mathematical statistics New 10 Business statistics Revision 25 Finance New 18 Financial accounting New 25 Managerial accounting Revision 50 English literature New 20 German New 30 The books listed as revisions are texts that FPL already has under contract; these texts are being considered for publication as new editions. The books that are listed as new have been reviewed by the company, but contracts have not yet been signed. Three individuals in the company can be assigned to these projects, all of whom have varying amounts of time available; Hashim has 60 days available, and Rukhsana and Mehwish both have 40 days available. The days required by each person to complete each project are shown in the following table. For instance, if the business calculus book is published, it will require 30 days of Hashim's time and 40 days of Rukhsana's time. An "X" indicates that the person will not be used on the project. Note that at least two staff members will be assigned to each project except the finance book. Book Subject Business calculus Finite mathematics General statistics Mathematical statistics Business statistics Finance Financial accounting Managerial accounting English literature German Hashim 30 16 24 20 10 X 40 Rukhsana 40 24 X X X 24 28 34 50 Mehwish X 30 24 16 14 26 30 30 36 FPL will not publish more than two statistics books or more than one accounting text in a single year. In addition, management decided that one of the mathematics books (business calculus or finite math) must be published, but not both. Managerial Report Prepare a report for the managing editor of FPL that describes your findings and recommendations regarding the best publication strategy for next year. In carrying out your analysis, assume that the fixed costs and the sales revenues per unit are approximately equal for all books; management is interested primarily in maximizing the total unit sales volume. The managing editor also asked that you include recommendations regarding the following possible changes: 1. If it would be advantageous to do so, Rukhsana can be moved off another project to allow her to work 12 more days. 2. If it would be advantageous to do so, Mehwish can also be made available for another 10 days. 3. If one or more of the revisions could be postponed for another year, should they be? Clearly the company will risk losing market share by postponing a revision. Include details of your analysis in an appendix to your report