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.
-
On January 1, 2006 the Baker Corporation issued $100,000 of five-year bonds due December 31, 2010 for $103,604.79 less bond issue costs of $3,000. The bonds carry a face rate of interest of 13%...
-
For the dissociation of nitrogen tetraoxide described in problem 14-3-9 [BBO] , there is a 77.7% increase in volume when equilibrium is reached at 50oC, 125 kPa. Determine the value of the...
-
Use the T account for Cash below to record the portion of each of the following transactions, if any, that affect cash. How do these transactions affect the companys liquidity? Jan. 2 Provided...
-
Western State University had the following account balances for the year ended and as of June 30, 2012. Debits are not distinguished from credits, so assume all accounts have a normal balance....
-
Problem 1 Use Lagrange multipliers to find the extreme values of the function subject to the given constraint. f(x, y) = 3x2+ 2y'- 4y +3, + y' - 16
-
V. N. Murti and V. K. Sastri investigated the production characteristics of various Indian industries, including cotton and sugar. They specified CobbDouglas production functions for output (Q) as a...
-
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period, as if it uses a periodic...
-
You buy TEN November USX put options with a strike price of CAD 1.2456. Option premium is 1cent per USD(0.01CAD). On the settlement day the spot price of USD/CAD is 1.2859. What will be your gain or...
-
Sweden Ltd manufactures cabinets. You work in the accounting department and have been tasked with preparing the Budget for the next month. Sweden makes two products: Premium cabinets - large cabinets...
-
Name: Address Class Identification Address 10.250.1.1 150.10.15.0 192.14.2.0 148.17.9.1 193.42.1.1 126.8.156.0 220.200.23.1 230.230.45.58 177.100.18.4 119.18.45.0 249.240.80.78 199.155.77.56...
-
nominate a cruise market segment and undertake research from academic and industry sources This market you choose may be - the country the cruise passengers come from (the SOURCE market, NOT...
-
1. New From CES 2020 Imagine you have partnered with a company to develop the next best gadget to be featured at an upcoming CES. What gadget would you create? (You can be motivated by trying to...
-
SE 25 Bb 125 15 Bb https www webassign net web Student As Let p Prices will rise q Taxes will rise Translate a Prices will rise or taxes will not rise O PAq Opv q OPA q Opva O pvq Opnq O p va Opn g b...
-
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....
-
How should the general manager divide his or her time between monitoring current-year results and planning for the future?
-
What is a business model, and what are its key elements?
-
The adjusted trial balance for Phoenix Consultant Corporation at the end of its fiscal year is shown below. Prepare the required closing entries. Phoenix Consultant Corporation Trial Balance December...
Study smarter with the SolutionInn App