1. Transportation of Hard Disk Drives. A hard disk drive (HDD) manufacturer is loo- king to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Transportation of Hard Disk Drives. A hard disk drive (HDD) manufacturer is loo- king to solve a logistics problem for its North American market. The HDD manufacturer has 3 production centres in Sunnyvale (California), Dublin (Ireland) and Bangkok (Thai- land) respectively. The manufacturer serves its North American demand of HDD through 4 warehouses in Amarillo (Texas), Teaneck (New Jersey), Chicago (Illinois) and Sioux Falls (South Dakota) respectively. The capacity of production centres, the demand served by warehouses and the transportation cost (in USD per thousand HDDs) are given in the table below. The manufacturer wants to find how many HDDs should be supplied from each production center to each warehouse so as to minimize its transportation cost? Transport cost USD per 1000 from Sunnyvale from Dublin 1280 from Bangkok 1510 Demand (in 000s) 80 to to Amarillo Teaneck 260 420 990 1420 78 to to Chicago Sioux Fall 380 1440 1630 47 490 1520 1680 55 Capacity (in 000s) 45 120 95 a) Formulate the transportation problem of the manufacturer as an LP. Clearly mention what each variable and what each index represents. 5 marks b) Find the solution using MS-Excel solver. 5 marks c) Find a feasible solution to the transportation problem using Houtthaker's method. 3 marks d) Now find the optimal solution (obtained above) by using the Stepping Stone method. 7 marks 1. Transportation of Hard Disk Drives. A hard disk drive (HDD) manufacturer is loo- king to solve a logistics problem for its North American market. The HDD manufacturer has 3 production centres in Sunnyvale (California), Dublin (Ireland) and Bangkok (Thai- land) respectively. The manufacturer serves its North American demand of HDD through 4 warehouses in Amarillo (Texas), Teaneck (New Jersey), Chicago (Illinois) and Sioux Falls (South Dakota) respectively. The capacity of production centres, the demand served by warehouses and the transportation cost (in USD per thousand HDDs) are given in the table below. The manufacturer wants to find how many HDDs should be supplied from each production center to each warehouse so as to minimize its transportation cost? Transport cost USD per 1000 from Sunnyvale from Dublin 1280 from Bangkok 1510 Demand (in 000s) 80 to to Amarillo Teaneck 260 420 990 1420 78 to to Chicago Sioux Fall 380 1440 1630 47 490 1520 1680 55 Capacity (in 000s) 45 120 95 a) Formulate the transportation problem of the manufacturer as an LP. Clearly mention what each variable and what each index represents. 5 marks b) Find the solution using MS-Excel solver. 5 marks c) Find a feasible solution to the transportation problem using Houtthaker's method. 3 marks d) Now find the optimal solution (obtained above) by using the Stepping Stone method. 7 marks
Expert Answer:
Answer rating: 100% (QA)
a Formulation of the transportation problem as an LP Let Xij be the number of HDDs transported from production center i i 123 to warehouse j j 1234 Th... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The Euro Watch Company assembles expensive wristwatches and then sells them to retailers throughout Europe. The watches are assembled at a plant with two assembly lines. These lines are intended to...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Solve preceding Problem 17.19, except that the probability that a defective part will jam the automated station is m = 0.5 for all stations. Problem 17.19 A manual assembly line has six stations. The...
-
What is the output of the following program: #include using namespace std; void Push(int x[], int y[], int n) { int i = 0, j = n - 1; while (i
-
You have just been hired as a loan officer at Slippery Rock State Bank. Your supervisor has given you a file containing a request from Lydex Company, a manufacturer of safety helmets. For a...
-
A permanent dipole consists of a particle carrying a charge \(+q_{\mathrm{p}}\) at \(x=0, y=+\frac{1}{2} d\) and another particle carrying a charge \(-q_{\mathrm{p}}\) at \(x=0, y=-\frac{1}{2} d\)....
-
Little People Learning Center (LPLC) has assembled the following data for the year ended June 30, 2005. Prepare the operating activities section of LPLC's statement of cash flows for the year ended...
-
A rod of diameter D = 25 mm and thermal conductivity k = 60 W/m. K protrudes normally from a furnace wall that is at Tw = 200C and is covered by insulation of thickness L ins = 200 mm. The rod is...
-
On January 1 , 2 0 1 9 , Aspen Company acquired 8 0 percent of Birch Company\'s voting stock for $ 3 2 8 , 0 0 0 . Birch reported a $ 3 3 5 , 0 0 0 book value, and the fair value of the...
-
Red's Furniture Manufacturing produces a line of tables and chairs from specialty hardwoods. It makes three different styles of chairs, and each chair takes about the same amount of direct labour...
-
Spotted Singer sells karaoke machines to businesses and consumers via the Internet. On January 1, 2013, Spotted Singer Inc has an Accounts Receivable balance of $997,000 and a credit balance in its...
-
Outback Outfitters sells a small camp stove for $ 1 5 0 per unit. Variable expenses are $ 1 0 5 per unit, and fixed expenses total $ 1 8 4 , 5 0 0 per month. Required: What is the break - even point...
-
Warner Corporation purchased a machine 7 years ago for $ 3 7 6 , 0 0 0 when it launched product P 5 0 . Unfortunately, this machine has broken down and cannot be repaired. The machine could be...
-
Jasper Company has sales on account and for cash. Specifically, 6 4 % of its sales are on account and 3 6 % are for cash. Credit sales are collected in full in the month following the sale. The...
-
A study reports that only 12% of people stick to their New Year's resolutions. Suppose you sample 100 people about whether they stuck to their resolutions. What is the standard error of the...
-
Nishi Limited has non-current assets of 622.481, non-current liabilities of 235.148, current assets of 359,727 and equity of 327,138. Using the accounting equation, calculate the figure for current...
-
If you have a CIDR block of 1024 addresses and you evenly break it into 64 addresses per sub-block answer the following questions: How many sub-blocks will you have? How many valid host ids do you...
-
The first law of thermodynamics is sometimes whimsically stated as, You cant get something for nothing, and the second law as, You cant even break even. Explain how these statements could be...
-
Carlos has a utility function that depends on the number of musicals and the number of operas seen each month. His utility function is given by U = xy2, where x is the number of movies seen per month...
-
There are two consumers on the market: Jim and Donna. Jim's utility function is U(x, y) = xy, with associated marginal utility functions MUx = y and MUy = x. Donna's utility function is U(x,y) = x2y,...
-
Suppose the demand curve in a particular market is given by Q = 5 0.5P. a) Plot this curve in a graph. b) At what price will demand be unitary elastic?
-
Why is communications management so important during project execution? What is the difference between formal and informal communications? Why are nonverbal communications so important?
-
What is involved in managing quality, and how does it affect project execution? What are tools and techniques used in performing quality assurance? How did Kristins team use one of these tools to...
-
Find an example of a large project that took more than a year to complete. Describe some of the planning work completed for the project as part of project integration and scope management. Summarize...
Study smarter with the SolutionInn App