please do solve this Optimization case study.

Company and Background DGF was a division of Deutsche Post DHL group, and was the top forwarding agent worldwide. DGF's recent global growth had been momentous, with the introduction of a new multi-modal service between china and japan. In 2015, DGF had accumulate revenue of 14.89 billion euros and operating profit of 181 , million euros. DGF was the market leader among the many forwarders operating in India, which includes companies such as Kuehne + Nagel, DB Schenker, Agility, Nippon Express, Ceva logistic and some more. DGF's operations in South India mainly catered to the states of Tamil Nadu, Karnataka, Kerala, Andhra, Pradesh, and Telangana. The firm received batches of consignments in its warehouses, located at Hyderabad, Bengaluru, and Chennai. These goods where then consolidated, repackaged, and dispatched to Europe- the most common destination being Frankfurt, Germany. The Current Consolidation Program DGF (DHL GLOBAL FORWARDING) has 3 warehouses in 3 different cities Hyderabad, Bangalore, and Chennai in India. All client's requirements must be shipped to Frankfurt (Germany), it takes approximately 48 hours using cargo space available in passenger airlines. The availability of different flights options from all the three cities to Frankfurt is given in the below table. AIRI INF SCHFDIII F TO FRANKFIIRT And the rates offered by airlines based on the weight of shipments are represented below. Weekly Schedule:- After aggregation data regarding client's necessities for the approaching months, every warehouse has 1400kg2500kg and 3500kg per day for severally Hyderabad, Bangalore, and Chennai. The Total Cost for this Consolidation Program is equal to 4,196,000/. However, in reaching economies of scale, the shipments accumulated at one of the three locations on certain days were not beneficial. DGF's Trend of revenue and operating Profit (2009-2015) shows us from 2012 to 2015 the revenue is constant, and the operating revenue is decreasing dramatically. This Data provides us the bargaining power with the different airlines because Amit Datta is aware of precisely the quantity of kilograms, he needs to transport every day from each city. The airlines care too much about the information they can gather from their clients, and if they can reduce the uncertainty of the demand, they will forecast and plan their flights with more accuracy. Even though we know that this data may vary, on average these are the shipments sizes for the different cities to Frankfurt. Identifying the most affordable airline per day per city according to the shipment size. As given details, there are four various airlines which will offer flights from Hyderabad, Bangalore and Chennai to the Frankfurt and knowing the kilograms DHL must move from each city, the total cost per day can be obtained from every airline multiplying the total kilograms by the tariff the airline is offering, this gives us as a result that some of them are cheaper than others as follows: Highlighted Days i.e. - Tuesday, Thursday and Saturday are cheaper than Mon, Wed, Fri, Sun. In the tables above, according to some constraints and the combination of road transportations costs and air transportation costs, everyday has different suggestions depending on the city where the products must be shipped. It indicates that the Shipments should be moved from Hyderabad to Bangalore on Tuesday and then shipped to Frankfurt together with the products from Bangalore and the products from Chennai should be sent directly to Frankfurt. For Thursday, the Solver indicates that the Shipments must be sent directly to Frankfurt from the city of origin. For Saturday, the Solver suggest that it will ship the product directly to Frankfurt from Hyderabad, and the products from Chennai are to be shipped to Bangalore and then to Bangalore and Chennai shipment will move together to Frankfurt. According to the this, the total cost would have a reduction from 4,196,000 to 4,148,400 India Rupee. It is cheaper to ship on Tuesday with the different combination. This means Amit Datta must send all the products according to the schedule of this day. In this point we must consider then one more constraint which is the lead time DHL promises to its clients which is a maximum time of 5 days after they deliver the product in the Destination city. This constraint makes the consolidation program better because it requires that to meet the 5 days lead time goal. DHL must ship more than one day a week, not just one day can be used to ship. The affordable day is always Tuesday, followed by Saturday and Thursday, so our advice is to ship as many as possible on Tuesday, then what is left on Saturday, then at least the last products on Thursday. Company and Background DGF was a division of Deutsche Post DHL group, and was the top forwarding agent worldwide. DGF's recent global growth had been momentous, with the introduction of a new multi-modal service between china and japan. In 2015, DGF had accumulate revenue of 14.89 billion euros and operating profit of 181 , million euros. DGF was the market leader among the many forwarders operating in India, which includes companies such as Kuehne + Nagel, DB Schenker, Agility, Nippon Express, Ceva logistic and some more. DGF's operations in South India mainly catered to the states of Tamil Nadu, Karnataka, Kerala, Andhra, Pradesh, and Telangana. The firm received batches of consignments in its warehouses, located at Hyderabad, Bengaluru, and Chennai. These goods where then consolidated, repackaged, and dispatched to Europe- the most common destination being Frankfurt, Germany. The Current Consolidation Program DGF (DHL GLOBAL FORWARDING) has 3 warehouses in 3 different cities Hyderabad, Bangalore, and Chennai in India. All client's requirements must be shipped to Frankfurt (Germany), it takes approximately 48 hours using cargo space available in passenger airlines. The availability of different flights options from all the three cities to Frankfurt is given in the below table. AIRI INF SCHFDIII F TO FRANKFIIRT And the rates offered by airlines based on the weight of shipments are represented below. Weekly Schedule:- After aggregation data regarding client's necessities for the approaching months, every warehouse has 1400kg2500kg and 3500kg per day for severally Hyderabad, Bangalore, and Chennai. The Total Cost for this Consolidation Program is equal to 4,196,000/. However, in reaching economies of scale, the shipments accumulated at one of the three locations on certain days were not beneficial. DGF's Trend of revenue and operating Profit (2009-2015) shows us from 2012 to 2015 the revenue is constant, and the operating revenue is decreasing dramatically. This Data provides us the bargaining power with the different airlines because Amit Datta is aware of precisely the quantity of kilograms, he needs to transport every day from each city. The airlines care too much about the information they can gather from their clients, and if they can reduce the uncertainty of the demand, they will forecast and plan their flights with more accuracy. Even though we know that this data may vary, on average these are the shipments sizes for the different cities to Frankfurt. Identifying the most affordable airline per day per city according to the shipment size. As given details, there are four various airlines which will offer flights from Hyderabad, Bangalore and Chennai to the Frankfurt and knowing the kilograms DHL must move from each city, the total cost per day can be obtained from every airline multiplying the total kilograms by the tariff the airline is offering, this gives us as a result that some of them are cheaper than others as follows: Highlighted Days i.e. - Tuesday, Thursday and Saturday are cheaper than Mon, Wed, Fri, Sun. In the tables above, according to some constraints and the combination of road transportations costs and air transportation costs, everyday has different suggestions depending on the city where the products must be shipped. It indicates that the Shipments should be moved from Hyderabad to Bangalore on Tuesday and then shipped to Frankfurt together with the products from Bangalore and the products from Chennai should be sent directly to Frankfurt. For Thursday, the Solver indicates that the Shipments must be sent directly to Frankfurt from the city of origin. For Saturday, the Solver suggest that it will ship the product directly to Frankfurt from Hyderabad, and the products from Chennai are to be shipped to Bangalore and then to Bangalore and Chennai shipment will move together to Frankfurt. According to the this, the total cost would have a reduction from 4,196,000 to 4,148,400 India Rupee. It is cheaper to ship on Tuesday with the different combination. This means Amit Datta must send all the products according to the schedule of this day. In this point we must consider then one more constraint which is the lead time DHL promises to its clients which is a maximum time of 5 days after they deliver the product in the Destination city. This constraint makes the consolidation program better because it requires that to meet the 5 days lead time goal. DHL must ship more than one day a week, not just one day can be used to ship. The affordable day is always Tuesday, followed by Saturday and Thursday, so our advice is to ship as many as possible on Tuesday, then what is left on Saturday, then at least the last products on Thursday