Using historical data, the country estimates the annual volume of the recyclable garbage for each sector in the coming year shown in the table below (in mega-tonnes):Estimated Recyclable Garbage123456789101041520785.58.563It will cost approximately $115,989 to move one mega-tonne of recycling garbage for one kilometer.
The management would like to maximize the amount of recycled garbage and minimize the transportation cost.
a. Formulate a multiple-objective linear programming (MOLP) model for this problem in a Word file with a brief description of an equation, and implement it in an Excel spreadsheet.
RMIT Classification: Trusted
b. Determine the optimal value for each objective in the problem.
c. Suppose the management considers maximizing the amount of recycled garbage to be two times as important as minimizing the transportation cost.
Formulate a GP model to optimize both objectives simultaneously with a brief description of an equation in a Word file, and implement the MOLP model in an Excel spreadsheet. What do the results suggest?
