The U.S. Cable Company uses a distribution system with five distribution centers and eightcustomer zones. Each customer zone is assigned a sole source supplier; each customer zonereceives all of its cable products from the same distribution center. In an effort to balancedemand and workload at the distribution centers, the company's vice president of logisticsspecified that distribution centers may not be assigned more than three customer zones. Thefollowing table shows the five distribution centers and cost of supplying each customer zone(in thousands of dollars):Customer ZonesDistributionCentersLosKansasCityAngeles Chicago Columbus Atlanta NewarkDenverDallasPlanoNashvilleFlagstaffSpringfieldBoulder7075152219375358822134402740132632479838789011129604523408.2939758286362532114537Determine the assignment of customer zones to distribution centers that will minimize cost.Write the complete Linear Programming formulation in your answer page.

The assignment issue is a sort of linear programming problem that deals with the one-to-one…

Answered: Determine the assignment of customer…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

(2) Find an optimal solution for the following transportation problem. Town To Valley FROM Madison (M) Yonkers (1) Pittsburgh (P) Demand FROM Madison (M) Yonkers Pittsburgh FROM 3.50 Madison (M) Yonkers FROM $8 350 Madison (M) Yonkers (1) Pittsburgh $5 SIS 350 Valley (5) $8 $5 $15 Using the Stepping-Stone method to find an optimal plan. Tol Valley Town Junction (7) $8 Pittsburgh Demand 350 Part (a) Find the new TC= $5 $15 50 350 The above feasible plan is obtained by applying the Northwest Corner Rule (e.g., 300 from M to V, etc.), and its total cost = 350($8) +50($10)+150($12) +250($4)+200($11) +250($14) = $11.800, 150 $8 200 $5 The improvement indices below are determined as follows: Supply row M first, then sows Y and P) MJ: 9-4+12-10-2 400 MB: 6-11+12-10=-3 rv: 5-12+10-8-5 600 PP: 15-14+11-12-10-8-2 PT: 6-14+11-12- PA 11-14+11-4-4 Demand 350 200 the "most negative index" We focus on cell PT (index=-9). Its closed path is: PT to PB to YB to YT, and back to PT. To increase the…
solve the following LP MODELS
Answer correctly on excel and show workings
The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?
a company's business model was to operate through its facilities- Vancouver, Calgary, Winnipeg, Toronto(ontario), ottawa, Montreal and Halifax. Supply comes from South America, southeast Asia, and Florida. the company was shipping first to Toronto and then to each facility at a total cost of $23095.5 per week. The company is considering the possibility of opening a logistics facility in Miami. Toronto and Vancouver were already available as transshipment centres. What would be the cost savings if Miami centre was opened and what would be the optimal shipment plan?
The Acme Company operates four factories that ship products to five warehouses. The shipping costs, requirements capacities, and optimal allocations are shown in Figure. What is the total cost of the optimal solution?
What drove Amazon to have their own air transportation services in house is: A- Number of hubs B- Prices and availability during high seasons C. Maintenance schedules D. Crew schedules.
Explain along with examples related to Freight Traffic Assignment Problems and vehicle routing problem in the logistics activities of manufacturing and service companies! Solve the following case study using the transportation method: Suppose there is a manufacturing company that produces and distributes its products to various customer locations across the country. This company has three production plants (Plant A, Plant B, and Plant C) located in different locations, and there are also five distribution centers (DC 1, DC 2, DC 3, DC 4, and DC 5) scattered across various regions. The company's goal is to determine the most efficient transportation routes for delivering products from the plants to the distribution centers, considering transportation costs and available capacities.
Please help me with part b
2.) Your business provides technical support for very complex and specialized machinery used by companies throughout the country, and you currently have support centers at 5 locations. However, due to a poor market, you have been forced to close your centers in Houston and San Diego. You will have to relocate all of your technicians in these two centers to your other three centers in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, and travel and retraining times, the cost for relocating an employee varies depending on where the employee is moving. These costs are given in the following table: To: From: Cleveland Seattle Charlotte $5,000 | $7,000 $7,000 $4,000 $6,000 $8,000 Houston San Diego You currently have 40 employees in Houston and 55 employees in San Diego, which all need to be relocated. Cleveland is able to take in at most 35 relocated employees, Seattle can take in at most 32 employees, and Charlotte is able to take in at most 50 employees.…
Please answer and solve with solution & illustration for the attached problem. Thanks
An auto compant currently maintains plants in Cincinnati and Tulsa to supply two distributioncenters in Boston and Phoenix. The production and distribution costs, distribution demands aswell as facility capacities are given in the table attached Using the northwest-corner method, determine the initial allocated quantity for eachshipping route as well as the overall cost.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Determine the assignment of customer zones to distribution centers that will minimize cost. Write the complete Linear Programming formulation in your answer page.