Glassware is a high-end glass manufacturer. The company is planning to expand its sales operation to the European market. A supply chain analyst within the company picked five locations for potential warehouse sites. These locations are Barcelona- Spain, Budapest-Hungary, Helsinki-Finland, Lyon-France, and Munich-Germany. A marketing analyst divided Europe into four general regions; East, West, South, and North. In the table below, transportation costs from warehouses to regions, the fixed cost of opening warehouses, the capacity of the warehouses, and the demand of regions are provided. Transportation Cost Fixed Warehouse North Cost Capacity Barcelona $55 $43 $60 $70,000 22,000 Budapest $40 $50 $45 $50,000 18,000 Helsinki $45 $60 SSO $30 $80,000 15,000 Lyon $57 $40 $49 $95,000 13,000 Munich $43 $52 $37 $75,000 24,000 East West South $46 $55 $37 $43 East 8,000 West 7,000 South 9,000 North 5,000 Demand To increase brand loyalty, Glassware wants to match the demand for all regions. 2 3 4 5 6 Barcelona Budapest Helsinki Lyon Munich East $55 $40 $45 $57 $43 Transportation Cost West South $43 $46 $50 $45 $60 $50 $40 $37 $43 $52 North $60 $55 $30 $49 $37 Fixed Cost $70,000 $50,000 $80,000 $95,000 $75,000 Warehouse Capacity 22,000 18,000 15,000 13,000 24,000 8 9 10 East West South North 11 Demand 8,000 7,000 9,000 5,000 12 13 Decision Variables 14 Amount Shipped Warehouse/Region Total 15 Open? East West South North Shipped 16 Barcelona Barcelona 17 Budapest Budapest 18 Helsinki Helsinki 19 Lyon Lyon 20 Munich Munich 21 Amount Received 22 23 Objective 24 Fixed cost Transportation cost 26 Total cost 27 28 Subject to 29 LHS RHS 30 Effective Capacity Barcelona 31 Effective Capacity Budapest 32 Effective Capacity Helsinki 33 Effective Capacity Lyon 34 Effective Capacity Munich 35 You can download the problem statement and the excel spreadsheet by clicking here - Consider the Glassware problem statement and the excel spreadsheet screenshot above. Using dropdowns, construct the constraint related to demand. 25 LHS Relation RHS [Select Select] Select] Glassware is a high-end glass manufacturer. The company is planning to expand its sales operation to the European market. A supply chain analyst within the company picked five locations for potential warehouse sites. These locations are Barcelona- Spain, Budapest-Hungary, Helsinki-Finland, Lyon-France, and Munich-Germany. A marketing analyst divided Europe into four general regions; East, West, South, and North. In the table below, transportation costs from warehouses to regions, the fixed cost of opening warehouses, the capacity of the warehouses, and the demand of regions are provided. Transportation Cost Fixed Warehouse North Cost Capacity Barcelona $55 $43 $60 $70,000 22,000 Budapest $40 $50 $45 $50,000 18,000 Helsinki $45 $60 SSO $30 $80,000 15,000 Lyon $57 $40 $49 $95,000 13,000 Munich $43 $52 $37 $75,000 24,000 East West South $46 $55 $37 $43 East 8,000 West 7,000 South 9,000 North 5,000 Demand To increase brand loyalty, Glassware wants to match the demand for all regions. 2 3 4 5 6 Barcelona Budapest Helsinki Lyon Munich East $55 $40 $45 $57 $43 Transportation Cost West South $43 $46 $50 $45 $60 $50 $40 $37 $43 $52 North $60 $55 $30 $49 $37 Fixed Cost $70,000 $50,000 $80,000 $95,000 $75,000 Warehouse Capacity 22,000 18,000 15,000 13,000 24,000 8 9 10 East West South North 11 Demand 8,000 7,000 9,000 5,000 12 13 Decision Variables 14 Amount Shipped Warehouse/Region Total 15 Open? East West South North Shipped 16 Barcelona Barcelona 17 Budapest Budapest 18 Helsinki Helsinki 19 Lyon Lyon 20 Munich Munich 21 Amount Received 22 23 Objective 24 Fixed cost Transportation cost 26 Total cost 27 28 Subject to 29 LHS RHS 30 Effective Capacity Barcelona 31 Effective Capacity Budapest 32 Effective Capacity Helsinki 33 Effective Capacity Lyon 34 Effective Capacity Munich 35 You can download the problem statement and the excel spreadsheet by clicking here - Consider the Glassware problem statement and the excel spreadsheet screenshot above. Using dropdowns, construct the constraint related to demand. 25 LHS Relation RHS [Select Select] Select]
