3) ($0 points) FedEx Ground needs to build new package sorting facilities in order to meet U.S. demand for parcel shipping during the next 10 years. The total additional daily inbound and putbound package handling capacity needed (1.c., the total number of packages needing to be handled each day in the new facilities) by the end of each of the next 10 years is shown below End of year requirements Outbound Inbound 1 2 3 62. 243 67,223 72,265 63.748 68.848 74,012 Year 4 5 6 7 79.492 85,057 90,756 56,565 81.414 87,11392.950 98,899 8 9 10 102,456 108,399 114,361 104932 111019 117,126 Five types of facilities-A, B, C, D, and E-can be built. The construction cost, annual operating cost, daily outbound package handling capacity, and daily inbound package handling capacity of each type of facility is shown in the table below. Facility Construction Annual Operating Daily OB Package Daily IB Package type Cost (S) Cost (S) Handling Capacity Handling Capacity A $17,300,000 $2,345,058 45,000 30,000 B $12,200,000 $1,694,213 20,000 30,000 $11,200,000 $1,586,400 25,000 20,000 D $8,800,000 $1,439,370 15,000 20,000 E $6,130,000 $1,034,000 12,000 12,000 Assume the following: The construction of a new facility takes place within a single calendar year No more than one of any type of facility may be built during any year The construction cost is the only cost incurred during the year of construction The annual operating cost is incurred every year after the year of construction The discount rate (i.e., inflation rate) is 0% during the next 10 years Use Microsoft Excel Solver to identify the capacity expansion plan that satisfies the above requirements at minimum total cost (construction cost + operating cost) over the next ten years. What facility type(s) should be built during which year(s)? How much total outbound and inbound package handling capacity will this plan generate during each of the next ten years? What is the total facility construction cost associated with this plan? What is the total facility operating cost associated with this plan? What is the total cost of this plan? You are about to finalize the above plan when a colleague informs you that the annual operating cost of facility type D has just been reduced by S100,000 (due to improved facilities planning). Does this new information change the best plan? If so, what is the new least cost capacity expansion plan? What facility type(s) should be built during which year(s)? How much total outbound and inbound package handling capacity will this plan generate during each of the next ten years? What is the total facility construction cost associated with this plan? What is the total facility operating cost associated with this plan? What is the total cost of this plan? 3) ($0 points) FedEx Ground needs to build new package sorting facilities in order to meet U.S. demand for parcel shipping during the next 10 years. The total additional daily inbound and putbound package handling capacity needed (1.c., the total number of packages needing to be handled each day in the new facilities) by the end of each of the next 10 years is shown below End of year requirements Outbound Inbound 1 2 3 62. 243 67,223 72,265 63.748 68.848 74,012 Year 4 5 6 7 79.492 85,057 90,756 56,565 81.414 87,11392.950 98,899 8 9 10 102,456 108,399 114,361 104932 111019 117,126 Five types of facilities-A, B, C, D, and E-can be built. The construction cost, annual operating cost, daily outbound package handling capacity, and daily inbound package handling capacity of each type of facility is shown in the table below. Facility Construction Annual Operating Daily OB Package Daily IB Package type Cost (S) Cost (S) Handling Capacity Handling Capacity A $17,300,000 $2,345,058 45,000 30,000 B $12,200,000 $1,694,213 20,000 30,000 $11,200,000 $1,586,400 25,000 20,000 D $8,800,000 $1,439,370 15,000 20,000 E $6,130,000 $1,034,000 12,000 12,000 Assume the following: The construction of a new facility takes place within a single calendar year No more than one of any type of facility may be built during any year The construction cost is the only cost incurred during the year of construction The annual operating cost is incurred every year after the year of construction The discount rate (i.e., inflation rate) is 0% during the next 10 years Use Microsoft Excel Solver to identify the capacity expansion plan that satisfies the above requirements at minimum total cost (construction cost + operating cost) over the next ten years. What facility type(s) should be built during which year(s)? How much total outbound and inbound package handling capacity will this plan generate during each of the next ten years? What is the total facility construction cost associated with this plan? What is the total facility operating cost associated with this plan? What is the total cost of this plan? You are about to finalize the above plan when a colleague informs you that the annual operating cost of facility type D has just been reduced by S100,000 (due to improved facilities planning). Does this new information change the best plan? If so, what is the new least cost capacity expansion plan? What facility type(s) should be built during which year(s)? How much total outbound and inbound package handling capacity will this plan generate during each of the next ten years? What is the total facility construction cost associated with this plan? What is the total facility operating cost associated with this plan? What is the total cost of this plan