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.
