Case Problem: Textbook Publishing ASW Publishing, Inc., a small publisher of college textbooks, must make a decision regarding which 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 (000s) 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 that are listed as revisions are texts that ASW 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.The company has three individuals who can be assigned to these projects, all of whom have varying amounts of time available; John has 60 days available, and Susan and Monica 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 John's time and 40 days of Susan'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                     John               Susan               Monica Business calculus                30                    40                      X Finite mathematics              16                    24                      X General statistics                 24                    X                       30 Mathematical statistics        20                     X                       24 Business statistics               10                     X                       16 Finance                                 X                      X                       14 Financial accounting             X                      24                       26 Managerial accounting          X                      28                       30 English literature                   40                     34                      30 German                                 X                       50                       36 ASW will not publish more than two statistics books or more than one accounting text in a single year. In addition, management has 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 editorial director of ASW 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 editorial director has also asked that you include recommendations regarding the following possible changes. 1. If it would be advantageous to do so, Susan can be moved off another project to allow her to work 12 more days. 2. If it would be advantageous to do so, Monica 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.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
100%

Case Problem:

Textbook Publishing

ASW Publishing, Inc., a small publisher of college textbooks, must make a decision regarding which 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 (000s)

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 that are listed as revisions are texts that ASW 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.The company has three individuals who can be assigned to these projects, all of whom have varying amounts of time available; John has 60 days available, and Susan and Monica 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 John's time and 40 days of Susan'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                     John               Susan               Monica

Business calculus                30                    40                      X

Finite mathematics              16                    24                      X

General statistics                 24                    X                       30

Mathematical statistics        20                     X                       24

Business statistics               10                     X                       16

Finance                                 X                      X                       14

Financial accounting             X                      24                       26

Managerial accounting          X                      28                       30

English literature                   40                     34                      30

German                                 X                       50                       36


ASW will not publish more than two statistics books or more than one accounting text in a single year. In addition, management has 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 editorial director of ASW 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 editorial director has also asked that you include recommendations regarding the following possible changes.

1. If it would be advantageous to do so, Susan can be moved off another project to allow her to work 12 more days.

2. If it would be advantageous to do so, Monica 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.


Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 7 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.