SportGear International is a designer, manufacturer and distributor of sport gear. While most of their sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
SportGear International is a designer, manufacturer and distributor of sport gear. While most of their sales occur in the United States, SportGear International has managed to establish itself as a significant player in the selling of premium quality soccer jersey shirts. Those jerseys are produced in the USA and shipped in containers to three major seaports in Europe: Genoa (Italy), Barcelona (Spain) and Marseilles (France). After reaching the destination seaports, the containers are loaded on trucks for final delivery at one of their four warehouse locations: Madrid (Spain), Lyon (France), Munich (Germany) and Milano (Italy). Plant: Madrid Demand at Each Warehouse Lyon Munich Milano Total Barcelona Marseilles SportGear International has negotiated contracts for a set maximum number of containers at each seaport: Max # of Containers Seaport: Genoa Barcelona Marseilles Total Origin Seaport Madrid Genoa $240 # containers 240 540 120 300 1,200 $122 $205 The containers are transported by common carrier and charges are on a per-container basis. Ground Transportation Costs Seaport to Warehouse # containers 300 420 480 1,200 Destination Warehouse Munich $82 $200 $244 Lyon $260 S80 $180 Milano $124 $220 $84 1) SportGear International must decide how many containers to send from each seaport to each warehouse. Using Solver, identify the solution that would minimize overall ground transportation costs for SportGear International. What would be the total ground transportation costs? Realizing that an extra entry point in Europe would provide more flexibility in their network, SportGear International negotiated an agreement with a fourth seaport. Piraeus (Greece). The shipping costs from Piraeus are provided below. They can ship up to 300 containers through Piraeus, on top of the capacity already available at other seaports. Would this solution save money for SportGear International? If so, how much? If not, how much more expensive is it? Origin Seaport Piraeus Madrid $260 Destination Warehouse Munich $70 Lyon $230 Milano $150 Note: Use the Simplex IP algorithm when conducting your computations in Solver. Please answer questions 1 and 2 into two separate worksheets. Submit your Excel file. SportGear International is a designer, manufacturer and distributor of sport gear. While most of their sales occur in the United States, SportGear International has managed to establish itself as a significant player in the selling of premium quality soccer jersey shirts. Those jerseys are produced in the USA and shipped in containers to three major seaports in Europe: Genoa (Italy), Barcelona (Spain) and Marseilles (France). After reaching the destination seaports, the containers are loaded on trucks for final delivery at one of their four warehouse locations: Madrid (Spain), Lyon (France), Munich (Germany) and Milano (Italy). Plant: Madrid Demand at Each Warehouse Lyon Munich Milano Total Barcelona Marseilles SportGear International has negotiated contracts for a set maximum number of containers at each seaport: Max # of Containers Seaport: Genoa Barcelona Marseilles Total Origin Seaport Madrid Genoa $240 # containers 240 540 120 300 1,200 $122 $205 The containers are transported by common carrier and charges are on a per-container basis. Ground Transportation Costs Seaport to Warehouse # containers 300 420 480 1,200 Destination Warehouse Munich $82 $200 $244 Lyon $260 S80 $180 Milano $124 $220 $84 1) SportGear International must decide how many containers to send from each seaport to each warehouse. Using Solver, identify the solution that would minimize overall ground transportation costs for SportGear International. What would be the total ground transportation costs? Realizing that an extra entry point in Europe would provide more flexibility in their network, SportGear International negotiated an agreement with a fourth seaport. Piraeus (Greece). The shipping costs from Piraeus are provided below. They can ship up to 300 containers through Piraeus, on top of the capacity already available at other seaports. Would this solution save money for SportGear International? If so, how much? If not, how much more expensive is it? Origin Seaport Piraeus Madrid $260 Destination Warehouse Munich $70 Lyon $230 Milano $150 Note: Use the Simplex IP algorithm when conducting your computations in Solver. Please answer questions 1 and 2 into two separate worksheets. Submit your Excel file.
Expert Answer:
Answer rating: 100% (QA)
SportGear International Supply Chain Management Objective To minimize the total transportation costs ... View the full answer
Related Book For
Pricing Strategies A Marketing approach
ISBN: 978-1412964746
1st edition
Authors: Robert M. Schindler
Posted Date:
Students also viewed these marketing questions
-
One of the most popular candies in the United States is M&Ms, which are produced by the Mars Company. In the beginning M&Ms were all brown; more recently they were produced in red, green, blue,...
-
The demand curve for spark plugs in the United States is given by Q = 100 - P, where Q indicates the number of spark plugs purchased and P is the price. Suppose that there are no spark plugs produced...
-
A major steel producer in the United States uses a matrix structure for R&D. Once the product is developed, the product organizational structure is used. Are there any advantages to this setup?
-
c++. error: array must be initialized with a brace enclosed initializer main.cpp X 10 11 ii 12 13 14 4567 15 16 17 18 19 287288285 20 21 23 24 25 26 27 28 25285922223288 30 31 33 34 36 37 40 41 42 43...
-
Summarize the procedure that may be followed by the Human Resources Department in hiring new employees.
-
Ozarch Ltd is in the process of preparing direct labour and factory overhead budgets for the year ending 30 June 2025. Relevant data are set out below. Required (a) Prepare the direct labour budget...
-
During an audit engagement Harper, CPA, has satisfactorily completed an examination of accounts payable and other liabilities and now plans to determine whether there are any loss contingencies...
-
Use the CAFR information for the City of Salem (Illustrations 22 through 216) to find the following items. In your answer, both indicate which financial statement contained the information and the...
-
Land improvements As of December 31 2022 : Beginning balance - P5,000,000 Estimated useful life - 10 years Depreciation method - 150% declining balance method Accumulated Depreciation - P2,781,473 a....
-
Midwestern Hardware must decide how many snow shovels to order for the coming snow season. Each shovel costs $ 15.00 and is sold for $ 29.95. No inventory is carried from one snow season to the next....
-
During August 2021, Ms. Anita Smith sells a capital asset with an adjusted cost base of $100,000, for proceeds of $200,000. She receives $50,000 of this amount in cash, with the remaining balance due...
-
When a lift is descending with acceleration ams - 2 , the tension in the lift cable is 1 1 6 2 5 N . The total mass of the lift and its contents is 1 2 5 0 kg . ( a ) Find the value of a . ( b ) A...
-
2. A sky diver jumps from a plane at an altitude of 20km, where the temperature is around -20 C. After an initial acceleration period (which you can ignore), they fall through the air at a constant...
-
If the engine fails, a typical single - prop airplane will descend at an angle of - 4 . 7 5 \ deg below horizontal. If the engine fails at an altitude of 1 0 0 0 . 0 ft . , how far can the plane...
-
Consider a long, cylindrical charge distribution of radius R with a uniform charge density p. Find the electric field at distance r from the axis, where r < R. (Use any variable or symbol stated...
-
when Judy adds 1 . 0 kg of unknown liquid at a temperature of 2 5 \ deg c to 2 . 0 kg of water at a temperature of 4 5 \ deg c , the final temperature of the mixture is 4 0 \ deg c , assuming no loss...
-
a) What is a basic block? b) Convert the following C code to assembly code. Then find out (1) basic blocks, (2) data dependence, (3) antidependence, (4) output dependence, and (5) control dependence....
-
Suppose that the electrical potential at the point (x, y, z) is E(x, y, z) = x + y - 2z. What is the direction of the acceleration at the point (1,3,2)?
-
Describe a meaning that consumers draw from a prices ending digits that is favorable to a seller. Describe one that is unfavorable to a seller.
-
Describe a situation when the incremental fixed costs used in a breakeven calculation would be a negative amount.
-
What do image interactions and product interactions have in common? What makes them different?
-
It has been stated that to lead people through the complex changes facing the health care industry, transformational leadership is required (i.e., leaders creating an environment in which staff can...
-
Deliberate the need for transformational or collaborative leadership in the next 5 years as the health care environment transforms as a result of industry reform.
-
If you were the director of a major department in a health care company, how important would each of the following activities be to you? Answer yes or no to indicate whether you would strive to...
Study smarter with the SolutionInn App