Consider a problem whereby limited quantities of three types of merchandise are available to be loaded into
Question:
Consider a problem whereby limited quantities of three types of merchandise are available to be loaded into two decks of a ship. Relevant data are provided below. SHIP CAPACITIES: Deck (j)___ Weight(tons) Lower (1) 280 Upper (2) 360 CARGO DATA: Merchandise (i) Available Merchandise (tons) Revenue (dollar per ton) Paper (1) 130 8,000 Metal (2) 400 7,800 Glass (3) 270 9,900 How much weight of each type of merchandise is to be loaded in each hold such that total revenue is maximized without violating weight constraints. Develop an LP model and solve it using Solver. Your variable definition will have the form of Lower 1 Upper 2 Let Xij = Tons of merchandise i loaded in deck j. Paper (1) Metal (2) Glass (3)
Horngrens Financial and Managerial Accounting
ISBN: 978-0133866292
5th edition
Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura