Part II: Problem-Solving Questions (25 points)

Question 1 (5 points):

Hindustan Aeronautics Ltd. supplied aircraft doors to a leading aircraft manufacturer. In 2013, it made a total of 120 deliveries. The following table presents a summary of lead time performance for all the 120 delivery cycles. Based on the information provided in the table, calculate the mean lead time and its coefficient of variation.

 Lead time (in days) Number of deliveries 36 70 40 30 33 20

Question 2 (10 points):

The following table provides the historical world air freight traffic and world GDP from 2001 through 2010.

 Year World Air Freight Traffic (RTK in million) World GDP (in constant 2000 US \$) 2001 110,869 \$32,046,348,810,620.30 2002 117,510 \$33,304,640,616,151.20 2003 124,207 \$37,465,967,921,629.80 2004 139,037 \$42,228,984,476,590.60 2005 142,579 \$45,658,316,886,272.40 2006 152,305 \$49,506,293,314,880.40 2007 159,519 \$55,848,896,227,304.20 2008 157,006 \$61,304,541,579,435.60 2009 140,356 \$58,088,277,293,607.50 2010 172,177 \$63,123,887,517,709.30

Based on the information provided in the above table, answer the following two questions.

(1)   Develop one graph to display the historical annual world air freight traffic and world GDP from 2001 to 2010, using 2001 as the baseline year.

(2)   Based on the historical world air freight traffic and world GDP data during 2001 and 2010, do you find the support for the argument that the world air freight grows about twice as fast as world GDP in the time period concerned? Explain how you prove whether this argument holds true

Question 3 (10 points):

Using the same information provided in the class simulation exercise “DHL Supply Chain (02/27/14)” and the corresponding SOLVER template available on Blackboard, calculate the minimum carbon emission associated with having a budget of CNY 3.63 billion for the total production and shipping costs.

Based on the optimization solutions derived from SOLVER, put the results into the corresponding blanks to complete the following supply chain matrix.

 Supply Chain Matrix Select (0/1) Air Express Road Road LTL Road-Network Rail Water LCD 42 ODM1 LCD 42 ODM2 LCD 42 ODM3 LCD 42 ODM4 LCD42 ODM5 LCD42 ODM6 LCD 42 OMD7 LCD 32 ODM1 LCD 32 ODM2