Reference:

Question:

Formulate the integer programming model for" freight forwarding consolidated(Current and proposed) program on weekly basis for DHL Global Forwarding. solve the model on excel solver. In a mathematical model, you have to clearly define Decision variables, objective function, and constraints.
 

 
 
 

On the evening of October 13, 2015, Amit Datta, regional director of DHL Global Forwarding (DGF), was gazing out the window of his office in Bengaluru, India. His day had been very hectic, and his last meeting, which was about DGF s consolidation program, had run for two hours. DGF provided air and ocean freight forwarding services. In September, Datta s team had successfully tested the consolidation program in three Indian cities: Hyderabad, Bengaluru, and Chennai. In the last meeting, three months ago, the team had suggested that Datta consolidate shipments from individual clients in the respective city. Such aggregation helped DGF to get cheaper shipment rates from airlines. While glancing through the respective consolidation teams reports, several questions occurred to Datta: Was DGF paying more to airlines on specific days of the week in these three cities? Should the company continue to run the consolidation program in these locations? How could DGF consolidate its clients requirements across these cities? Would such consolidation benefit the company? Datta looked at his calendar and realized that the next team meeting was only one day away; before that meeting, he would have to create a new consolidation program. 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 cumulative revenue of 14.89 billion and operating profit of 181 million (see Exhibit 1). Forwarding, Damco, CEVA Logistics, Jeena & Company Private Limited, Om Logistics Ltd., Express Cargo Containers, and LCL Logistix. Most of these forwarders operated worldwide, but some (e.g., Om Logistics Ltd., Express Cargo Containers, and LCL Logistix) concentrated mainly on the Indian market.* Third-party logistics (3PL) was an outsourced function that comprised transportation, warehousing, and relevant logistics service activities. Due to increasing globalization, 3PL providers started gaining traction with their state- of-the-art information technology infrastructure and excellent geographic reach. Because of this growing demand, the providers enjoyed economies of scale, which helped them achieve greater cost effectiveness. The market for 3PL was highly fragmented, with companies offering various value-added services like order management, fleet management, logistics consulting, customer support, and freight forwarding. Freight forwarders played a key part in a sector that effectively transported goods worth US$5.3 trillion every year. Freight forwarding was usually classified into four categories: rail, road, sea, and air. Due to many different factors (e.g., competition and volatility in oil prices), forwarders faced huge challenges in retaining their market share. A forwarder helped clients transport their goods to the desired destinations through a combination of various transportation modes, and charged clients according to the weight of the consignment (see Exhibit 2). To achieve economies of scale, consignments from different clients were aggregated. Thus, 3PL providers focused on reducing transportation costs through consolidation programs. DGF facilitated the transportation of packages for its clients globally. For this reason, the firm developed a number of international services dedicated to the import and export of goods. DGF met its customers logistical needs in many diverse contexts, from standardized logistics operations and multi-modal transport solutions to highly individualized industrial projects. Founded in 1970, DGF had steadily expanded its operations. By 2015, it operated in 135 different countries, particularly in Asia, Europe, and Africa. The company handled consignments for a large variety of goods-including textiles, automobile parts, high- tech products, and manufactured goods and also provided grouping and consolidation solutions to suit specific transport requirements. Depending on clients logistical requirements, DGF offered different handling services such as offloading, order picking (preparation of orders in dedicated areas), kitting (production of kits from several parts), packaging, filming, and labelling. 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 were then consolidated, repackaged, and dispatched to Europe the most common destination being Frankfurt, Germany. THE CONSOLIDATION PROGRAM Datta and his team specialized in consolidation of the orders at DGF, and assisted clients on a daily basis. A typical weekly dispatch schedule was made available to all clients (see Exhibit 3). This document depicted the company s turnaround times. For instance, if a shipment was delivered to DGF on day one, the same shipment would be dispatched on day two (the next day). However, if day two was a holiday, then the shipment would be dispatched on the subsequent business day. It took DGF approximately 48 hours to ship goods from India to Frankfurt by air. Page 3 9B17D005 Datta was responsible for collecting information about clients requirements for the upcoming month (see Exhibit 4). These requirements from individual clients in Hyderabad, Bengaluru, and/or Chennai were consolidated at DGF s warehouses in the clients respective locations. Shipments were dispatched directly to Frankfurt using cargo space available in passenger airlines. Among the four passenger airlines used by DGF, three were from the Middle East and one was from Europe. The availability of various flight options from all three points of origin (i.e., airports) in South India to the chosen destination (i.e., Frankfurt) drove the choice of day for shipping (see Exhibit 5). The airlines charged DGF based on the weight of these aggregated shipments. However, Datta knew that on certain days of the week, the shipments accumulated at one of the three locations, which was not helpful in achieving economies of scale. He wondered if DGF could achieve greater cost efficiencies by routing the goods through another airport instead, using overnight road transportation to move the shipments to DGF s warehouse in another city at an additional cost (see Exhibit 6). The industry norm was a maximum transit time of five working days between the point of origin and the destination airport. Although Datta worried somewhat about potential delays due to traffic congestion and/or accidents while moving shipments by road, he remembered a company report that estimated the possibility of such incidents at no more than 2 per cent in South India. If such delays did occur, DGF was required to pay clients a penalty equivalent to the shipping cost of the delayed consignments. Based on his ideas about road transportation, Datta hoped to formulate a plan that would help DGF save money through this modified consolidation; yet with only one day to do so before the next team meeting, he knew he would have to work late into the night. He asked his secretary for some strong coffee, and sat down at his desk to begin. Operating Profit (in million) EXHIBIT 1: DGF S TREND OF REVENUE AND OPERATING PROFIT (2009-2015) 550 500 450 400 350 300 250 200 150 100 2009 Source: Company materials. 2010 2011 -Revenue (in billion) Airline Shipment size in kilograms (kg) $100 101-500 501-1000 >1,000 Source: Company materials. Day Demand accumulated across the week Source: Company materials. 2012 Year Etihad Airways 135 125 105 95 2013 EXHIBIT 2: RATES OFFERED BY AIRLINES 2014 Operating Profit( in million) Lufthansa Emirates Rate (* per kg) 150 135 120 110 145 130 110 100 2015 EXHIBIT 3: WEEKLY CONSOLIDATION SHIPMENT SCHEDULE 15 13 9 7 5 Revenue (in billion) Qatar Airways 130 120 100 90 Monday Tuesday Wednesday Thursday Friday Saturday Sunday Thursday Holiday and Friday Saturday Tuesday and Wednesday and Monday Page 5 EXHIBIT 4: SHIPMENTS PLANNED BY VARIOUS CLIENTS FOR FRANKFURT Origin Client Shipment Size per Day (in kg) Hyderabad A 100 Hyderabad B 1,000 300 Hyderabad Bengaluru Bengaluru E D 100 1,500 Bengaluru F 400 Bengaluru G 250 50 200 700 300 500 2,000 Source: Company materials. Etihad Airways Qatar Airways Lufthansa Emirates Bengaluru H Bengaluru I Chennai J K L M Chennai Chennai Chennai Origin Hyderabad Bengaluru Chennai Hyderabad Source: Company materials. EXHIBIT 5: AIRLINE SCHEDULE TO FRANKFURT Bengaluru Chennai Source Company materials Monday Tuesday Wednesday Thursday Friday Saturday Sunday Available Available Available Available Available Hyderabad Bengaluru Chennai Available Available Available Available Available Available Available Available Available Available Available Hyderabad Bengaluru Chennai Available Available Available Available Hyderabad Available Available Available Available Available Available Available Bengaluru Available Available Available Available Available Available Available Available Available Available Available Available Available Chennai Available EXHIBIT 6: ROAD TRANSPORTATION COSTS FOR DGF (PER KG) Hyderabad Bengaluru Chennai 8 9 4 - Available Available 8 9 4 Available 9B17D005 - IVEY Publishing DHL GLOBAL FORWARDING: CONSOLIDATION PROGRAM W17196