This paper circulates around the core theme of Bloomington Publishers wants to find a production plan that maximizes total profit. Formulate and solve an integer programming model in .xlsx to help this publisher identify the best production plan. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Bloomington Publishers is considering publishing five different
textbooks. The maximum number of copies of each textbook that can be
sold, the variable cost of producing each textbook, the sales price of
each textbook, and the fixed cost of a production run for each textbook
are given in the file GS 4.xlsx. For example, producing and selling 2000
copies of book 1 yields a revenue of $80(2000) = $160,000 but costs
$80,000 + $44(2000) = $168,000. This company can produce at most 20,000
copies in total. Furthermore, it can publish no more than three
different types of textbooks. Also, it knows that it cannot publish book
1 if it chooses to publish book 2. Finally, if this company publishes
book 4 it must also publish book 5. Bloomington Publishers wants to find
a production plan that maximizes total profit. Formulate and solve an
integer programming model in .xlsx to help this publisher identify the
best production plan.