1. (6 points) A harbor uses three different crgo handling systems to deal with four types of cargo consumer goods, chemical products, minerals and manufactured products. During the coming month it is estimated that it will be necessary to handle at least 1800 tons of consumer goods, 1500 tons of chemical products, 2000 tons of minerals and 1300 tons of manufactured products, The following table indicates the number of tons per hour that each cargo handling system is able to treat, the monthly availability in number of hours for each system and the operating costs (per hour) Cargo Eficiency (tons/b) Availability Cost system Consumer g. Chemicals Minerals Manufactured (hours) (euro/h) 50 100 50 20 FO 30705 2 20 20 20 50 18.30 3 20 50 50 20 100 36.06 Note that cargo system 2 cannot handle chemical products. (a) (2 points) Formulate a model to program the use of systems for the movement of cargo with minimum cost (b) 1 point) Use the Solver in Excel to obtain the optimal solution for the preceding model. (c) (1 point) The harbor management is studying ways to improve the operation of the cargo handling system. It wishes to increase the minimum required amount of cargo to be handled of each product type to 200 ton per month. Which one of the product types would imply the largest increase in costs associated to this new condition? (d) (2 points) You are given the option of increasing the capacity of one and only one) of the bw to 15 additional hours, at a unit cost of 12 euros per hour 1. (6 points) A harbor uses three different crgo handling systems to deal with four types of cargo consumer goods, chemical products, minerals and manufactured products. During the coming month it is estimated that it will be necessary to handle at least 1800 tons of consumer goods, 1500 tons of chemical products, 2000 tons of minerals and 1300 tons of manufactured products, The following table indicates the number of tons per hour that each cargo handling system is able to treat, the monthly availability in number of hours for each system and the operating costs (per hour) Cargo Eficiency (tons/b) Availability Cost system Consumer g. Chemicals Minerals Manufactured (hours) (euro/h) 50 100 50 20 FO 30705 2 20 20 20 50 18.30 3 20 50 50 20 100 36.06 Note that cargo system 2 cannot handle chemical products. (a) (2 points) Formulate a model to program the use of systems for the movement of cargo with minimum cost (b) 1 point) Use the Solver in Excel to obtain the optimal solution for the preceding model. (c) (1 point) The harbor management is studying ways to improve the operation of the cargo handling system. It wishes to increase the minimum required amount of cargo to be handled of each product type to 200 ton per month. Which one of the product types would imply the largest increase in costs associated to this new condition? (d) (2 points) You are given the option of increasing the capacity of one and only one) of the bw to 15 additional hours, at a unit cost of 12 euros per hour
