Question 2 UBike is a bicycle manufacturer based in Japan. Haruki, the supply chain manager at...

Transcribed Image Text:

Question 2 UBike is a bicycle manufacturer based in Japan. Haruki, the supply chain manager at UBike is designing the manufacturing network and has selected four potential sites-Tokyo, Sapporo, Fukuoka, and Sendai. The below table shows the annual fixed costs at the four locations as well as the cost of producing and shipping a bicycle to each of the four markets. Note that plants could have a capacity of either 250,000 or 500,000 units and that each open plant should have at least 60% capacity utilisation. Southwest Northeast Central East Annual fixed cost of 250,000 Annual fixed cost of 500,000 Production and Transportation Costs ($/unit) Tokyo Sapporo Fukuoka Sendai 50 80 35 52 65 35 70 30 80 55 48 $8 million $12 million 30 $6 million $10 million 42 $7 million $11 million 40 53 35 $7.4 million $11.4 million Annual Demand 210,000 150,000 160,000 170,000 (a) Formulate an integer linear programming (ILP) model for this problem. (b) Develop a spreadsheet model and solve the problem of finding the optimal location and sizing for UBike factories. Comment on your results. Question 2 UBike is a bicycle manufacturer based in Japan. Haruki, the supply chain manager at UBike is designing the manufacturing network and has selected four potential sites-Tokyo, Sapporo, Fukuoka, and Sendai. The below table shows the annual fixed costs at the four locations as well as the cost of producing and shipping a bicycle to each of the four markets. Note that plants could have a capacity of either 250,000 or 500,000 units and that each open plant should have at least 60% capacity utilisation. Southwest Northeast Central East Annual fixed cost of 250,000 Annual fixed cost of 500,000 Production and Transportation Costs ($/unit) Tokyo Sapporo Fukuoka Sendai 50 80 35 52 65 35 70 30 80 55 48 $8 million $12 million 30 $6 million $10 million 42 $7 million $11 million 40 53 35 $7.4 million $11.4 million Annual Demand 210,000 150,000 160,000 170,000 (a) Formulate an integer linear programming (ILP) model for this problem. (b) Develop a spreadsheet model and solve the problem of finding the optimal location and sizing for UBike factories. Comment on your results.