Reference: Question: Formulate the integer programming model for freight forwarding consolidated(Current and proposed) program on weekly basis
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
The integer programming model for the freight forwarding consolidated program on a weekly basis for ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
1. Which of the following is true of the relationship between the value of the optimal integer solution and the value of the optimal solution to the LP Relaxation? a. For integer linear programs...
-
You work as an operations consultant for a textile company. Your client has a well-established distribution system in the US market. The company has hundreds of stores and four distribution centers....
-
You work as an operations consultant for a textile company. Your client has a well-established distribution system in the US market. The company has hundreds of stores and four distribution centers....
-
State the density property of a barometer liquid and explain its effects. Explain in detailed.
-
Fill in the spaces in the accompanying table associated with the firm William Perry, Inc., that delivers refrigerators in the Chicago area, using the two inputs of labor andtrucks. Number Amount of T...
-
The theory that specific and moderately difficult goals may increase motivation is called the _____- _____ theory.
-
An investor purchased $\$ 20,000$ of U.S. Treasury bonds at face value. These bonds have a 25 -year maturity period, and they pay $1.25 \%$ interest every three months. Unfortunately, interest rates...
-
Describe some important uses of electronic commerce and explain why it is important to accountants.
-
3 Define the following (10) terms: 1. Augmented Reality 2. Mixed Reality 3. Digital Disruption 4. Value Proposition 5. Digital Transformation 6. Cloud Computing 7. Virtual Reality (VI) 8. Artificial...
-
I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 25,000 lamps @ $45.00 @ $30.00 Sales Cost of Goods Sold 750.000.00 Gross Profit $ 375.000.00 Selling...
-
Analyze the statement and comply of what is being asked. 1. Ms. Melissa, a public school teacher, is married to a farmer. Her gross compensation income for the taxable year amounted to P340,000.00....
-
Outlined the benefits and challenges to organizations implementing work-life policies. An organization can create policies, but cultural change requires more than just a change in policy. As your...
-
Come up with a programming idea. This can be an educational or social activity. Explain your goal, the steps you would take to plan an inclusive event, what resources would you use, how would you...
-
A number of rapes and car break-ins have taken place in the nearby low-come housing project. You are tasked with conducting a new risk assessment and selecting countermeasures for a suburban college...
-
Reflect on resistance to change in different stakeholder groups, what strategies would you use to address the change with each group. Explain why these strategies are considered best practices?...
-
Forthis assignment,take some time to reflect on the following questions. Consider a learning experience - either recent or further back - that was successful for you.Thinking back to the experience...
-
Explain in your own words why the cash flow takes precedence over the Income Statement and Balance sheet as the primary measurement tool in financial management and analysis. 2. If cash flow is so...
-
In Exercises 516, find the focus and directrix of the parabola with the given equation. Then graph the parabola. y 2 = 4x
-
The Jersey Dairy Products Company produces cheese, which it sells to supermarkets and food processing companies. Because of concerns about cholesterol and fat in cheese, the company has seen demand...
-
Blue Mountain Coffee Company produces various blends of Free Trade, organic specialty coffees that it sells to wholesale customers. The company imports 25 million pounds of coffee beans annually from...
-
Kathleen Taylor is a high school student who has been investigating the possibility of mowing lawns for a summer job. She has a couple of friends she thinks she could hire on an hourly basis per job....
-
1. Describe the bases of power held by Dr. Jamie Thompson. Describe the bases of power held by Dr. Elizabeth Clarke. 2. What activities and people have contributed to Jaime Thompsons power? What...
-
What is the current in the wire in Figure Q22.1? 1.0 VR + 1.0-1.0V + FIGURE Q22.1
-
Electroconvulsive therapy is a last-line treatment for certain mental disorders. In this treatment, an electric current is passed directly through the brain, inducing seizures. The total charge that...
Study smarter with the SolutionInn App