Portfolio Problem No. 4 Download Data in Excel File BN2295 ODA Avalon Computers Depot Downsizing Problem Avalon Computers Depot is currently in the process of downsizing. They need to change the current location of their storage to a new one, which does not have enough capacity to fit all the products currently in stock. The CEO of the company has entrusted you with the task to find the best plan to reduce the current stock. You will need to determine which products should be eliminated and which products should be kept. The products to be eliminated will be sent to liquidation sale while the products to be kept will have to be restocked. You are given the estimates on both, liquidation cost and restocking cost, for each product currently carried by the company. These are given in the 4th and the 5th column in the Problem Data table. In the last column, you are also provided with the estimates on the required floor space for each product . This is important to know since the maximum capacity of the new storage location is only 140 square meters while the storage currently in use has a capacity of 400 square meters. The CEO wants you to find the solution that would minimise the liquidation cost while respecting all of the following limitations: At least 15 products will be eliminated. No more than 200,000 can be spent to restock all the products kept. The products kept should use no more than 140 square meters of space in total. If any Acer or any Asus computer is to be kept, then Epson printer will also be kept. If one product of a certain brand is eliminated than all the products of that brand should be eliminated. At least six different tablet models need to be kept. At least three different laptop models need to be kept. If any desktops are to be kept, then at least one monitor model will also be kept. PROBLEM DATA Product Code Product Type Brand Cost to Liquidate ( 1000s) Cost to Restock ( 1000s) Space Required (m2 ) 203171 Tablet Microsoft 5 9 3.2 212811 Tablet Hannspree 4 12 3.4 221352 Tablet Samsung 4.5 8 3.4 223072 Tablet Asus 1.5 15 3.2 256917 Tablet Dell 5 10 3.1 264960 Tablet Fujitsu 3 15 3.6 273406 Tablet Samsung 5.5 7 2.9 274498 Tablet Acer 6.5 12 3.5 281659 Tablet Sony 1.5 14 3.1 282597 Tablet Apple 7.5 13 2.9 289410 Tablet Microsoft 2.5 11 3.3 296450 Tablet Asus 6.5 13 3.0 318044 Laptop Asus 6.5 13 5.0 327894 Laptop Toshiba 1.5 11 5.7 351066 Laptop Lenovo 4.5 8 6.1 356769 Laptop Acer 5 8 5.7 361711 Laptop Lenovo 3.5 10 5.0 375269 Laptop HP 8 10 5.3 396633 Laptop Asus 5 8 5.3 413122 Desktop HP 6.5 9 21.6 424242 Desktop Gigabyte 2.5 9 17.1 427777 Desktop Yoyotech 5.5 15 18.7 440294 Desktop Acer 5 12 21.9 450085 Desktop Zoostorm 2 14 19.2 451548 Desktop Apple 7.5 15 20.6 469347 Desktop Viglen 7 9 20.9 492082 Desktop Intel 6.5 9 16.5 507203 Monitor AOC 3.5 8 10.4 557148 Monitor Benq 4 13 11.8 559720 Monitor LG 4.5 9 12.2 578406 Monitor Iiyama 6 13 10.1 579193 Monitor Tyco 2 12 8.8 579333 Monitor Viewsonic 5.5 10 14.4 597995 Monitor Philips 6 14 14.5 608733 Printer Brother 2 8 14.9 611489 Printer OKI 4.5 9 13.0 651631 Printer Ricoh 7 8 12.3 679473 Printer Cannon 6.5 12 12.5 680966 Printer Lexmark 5.5 10 13.5 698203 Printer Epson 6 13 12.7