Purchase Solution

Integer Linear Regression

Not what you're looking for?

Ask Custom Question

ASW Publishing Inc., a small publisher of 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 (1000's)
Business Calculus New 20
Finite Math 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 ASW already has under contract; these texts are being considered for publications as new editions. The books that are listed as new have been reviewed by the company, but contract 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; 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 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 Math 16 24 X
General Statistics 24 X 30
Math 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 decided that one of the mathematics textbooks (business calculus or finite math) must be published, but not both.

Managerial Report
Prepare a report for the managing editor 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 sales revenue per unit are approximately equal for all books; management is interested primarily in maximizing 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, 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.
Formulate a integer linear program, use Lindo to determine optimal levels and provide an analysis.

Purchase this Solution

Solution Summary

ASW Publishing Inc., a small publisher of 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 (1000's)
Business Calculus New 20
Finite Math 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 ASW already has under contract; these texts are being considered for publications as new editions. The books that are listed as new have been reviewed by the company, but contract 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; 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 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 Math 16 24 X
General Statistics 24 X 30
Math 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 decided that one of the mathematics textbooks (business calculus or finite math) must be published, but not both.

Managerial Report
Prepare a report for the managing editor 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 sales revenue per unit are approximately equal for all books; management is interested primarily in maximizing 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, 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.
Formulate a integer linear program, use Lindo to determine optimal levels and provide an analysis.

Solution provided by:
Education
  • BSc , Wuhan Univ. China
  • MA, Shandong Univ.
Recent Feedback
  • "Your solution, looks excellent. I recognize things from previous chapters. I have seen the standard deviation formula you used to get 5.154. I do understand the Central Limit Theorem needs the sample size (n) to be greater than 30, we have 100. I do understand the sample mean(s) of the population will follow a normal distribution, and that CLT states the sample mean of population is the population (mean), we have 143.74. But when and WHY do we use the standard deviation formula where you got 5.154. WHEN & Why use standard deviation of the sample mean. I don't understand, why don't we simply use the "100" I understand that standard deviation is the square root of variance. I do understand that the variance is the square of the differences of each sample data value minus the mean. But somehow, why not use 100, why use standard deviation of sample mean? Please help explain."
  • "excellent work"
  • "Thank you so much for all of your help!!! I will be posting another assignment. Please let me know (once posted), if the credits I'm offering is enough or you ! Thanks again!"
  • "Thank you"
  • "Thank you very much for your valuable time and assistance!"
Purchase this Solution


Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.