2.) Your business provides technical support for very complex and specialized machinery usedby 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 SanDiego. You will have to relocate all of your technicians in these two centers to your other threecenters in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, andtravel and retraining times, the cost for relocating an employee varies depending on where theemployee is moving. These costs are given in the following table:To:From:ClevelandSeattleCharlotte$5,000| $7,000$7,000$4,000$6,000$8,000HoustonSan DiegoYou currently have 40 employees in Houston and 55 employees in San Diego, which all need tobe relocated. Cleveland is able to take in at most 35 relocated employees, Seattle can take in atmost 32 employees, and Charlotte is able to take in at most 50 employees. You must decidewhere you should relocate each of your employees to minimize your total costs.Formulate the problem, giving the decision variables, objective function, and constraints (i.e.,give the mathematical model). Important Note: Begin by clearly defining the decisionvariables. (Note: you do not have to solve this linear programming problem.)

Decision Variable: Let Xij be the number of employees moved from location i to location j. where i…

ompanies throughout the country, and you currently have support centers at 5 locations ever, due to a poor market, you have been forced to close your centers in Houston and o. You will have to relocate all of your technicians in these two centers to your other thr ers in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, an el and retraining times, the cost for relocating an employee varies depending on where t loyee is moving. These costs are given in the following table: To:

ompanies throughout the country, and you currently have support centers at 5 locations ever, due to a poor market, you have been forced to close your centers in Houston and o. You will have to relocate all of your technicians in these two centers to your other thr ers in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, an el and retraining times, the cost for relocating an employee varies depending on where t loyee is moving. These costs are given in the following table: To:

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

The Bright Company wants to figure out the best way to ship their new product, Flying Widgets, from their factories through their warehouses to their retail outlets. They would like to set up a Transhipment table so they can use POM to find the least cost shipping routes. They have hired you to set up the Transhipment table based on the information below. You will be paid handsomely if you can come up with the correct table. Shipping Costs Shipping Costs 01 02 03 04 Wi W2 W3 W1 4. 2 F1 4 W2 4 F2 4 2 W3 4. 3. 4. Also, Flying Widgets can be shipped from Factory 1 to Factory 2 for $3 per unit. Factory 1 can produce 300 units and factory 2 can produce 100 units. Outlet 1 demand is 50 units, Outlet 2 is 150 units, Outlet 3 is 100 units, and Outlet 4 is 100 units.
how many warehouses and DCs are operated by Best Buy, Target, or another large retailer. What is the ratio of DCs and warehouses to the number of retail stores for each of these? What factors affect this ratio?
After graduating from University, Jerry and Samantha decide to go into business for themselves. They both love cooking, so they opened a mobile food truck. The new business is called SweetHand™ Almost immediately, their business takes off and there are long lines throughout the day and into the night. Five years have passed, and SweetHand™ has grown to over 100 locations spread across the Caribbean. For the most part, these locations operate independently. This results in coordination problems and inefficient supplies procurement. As a remedy, the IT manager has proposed linking all locations in telecommunications network. Question: What network topology choices are available, and which would you recommend? Remember to justify your recommendation.
In each of the following, name the term defined. Answers are listed at the bottom.1. This is the art and science of obtaining, producing, and distributing material and products in the proper place and in the proper quantities.2. A company that is hired to handle logistics functions.3. A mode of transportation that is the most flexible relative to cost, volume, and speed of delivery.4. When large shipments are broken down directly into smaller shipments for local delivery.5. Sorting goods is the main purpose of this type of warehouse.6. A place where foreign goods can be brought into the United States without being subject to normal customs requirements.
Dr. Vicki Belya is traveling from Yangoon to Los Angeles. She needs to change planes in Bangkok and board another airline’s flight in Tokyo. However, the ariline she is flying does not have interline agreements. Provide a basic explanation of what she can expect at every point of her journey.
Your regular trucking company that you use to move LTL freight from Winnipeg to Duluth, Minnesota, 1s suddenly on strike. You call other trucking companies but cannot get space What could you have done to avoid this situation? 1. Regularly use more than one carrier to create a bank of possible carriers to handle your business 2. Always book space with your truckers in advance 3. Use a pool car operator and hope they have next-day service to Duluth 4. Nothing can be done
what are the steps of handling daily transactions and requirements with banks for a logistics company
Transportation is mainly used for goods which have a long life. Select one : a . Rail b . Road c . Water d . Air
Mr. Delfino is traveling from Bangkok to London via Dubai on a single airline. He is confused about his journey. Provide a basic explanation of what he can expect along the way to his final destination.
company is amazon Describe the warehouse: company, type, size, products, level of automation ... etc. What features of this warehouse help serve its purpose? Describe the flow of operations inside the warehouse. How is packaging handled in the warehouse? How are/ can unit loads be applied to improve efficiency in handling products at this warehouse? How does/ can automation help in the warehouse? What mode of transportation is used to transport goods to/ from the warehouse? Justify this choice, or another one you see more appropriate. What are/ would be the implications of international operations on transportation for this company? Include cost considerations in your analysis
company is amazon Describe the warehouse: company, type, size, products, level of automation ... etc. What features of this warehouse help serve its purpose? Describe the flow of operations inside the warehouse. How is packaging handled in the warehouse? How are/ can unit loads be applied to improve efficiency in handling products at this warehouse? How does/ can automation help in the warehouse? What mode of transportation is used to transport goods to/ from the warehouse? Justify this choice, or another one you see more appropriate. What are/ would be the implications of international operations on transportation for this company? Include cost considerations in your analysis What are the implications of reverse logistics on this warehouse's operations and on transportation? Construct a flow diagram to illustrate your answer. Comment on the interrelationship within this logistics system: material handling, transportation and other functions. What are some improvements you recommend…
Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From To A B C 8 Demand 65 60 D $11 10 13 From/To Candidate solution A B с Total Shipped Cost A B E $5 4 с Total Costs F $9 8 12 75 Find the solution that minimizes moving costs using Microsoft Excel. Note: Leave no cells blank, whenever zero (0) is required. D $7 13 D 12 80 0 0 65 65 Supply 95 75 110 280 280 0 0 845 Answer is complete but not entirely correct. E F G 15 X 0 X 0 15 75 X 0X 0 0 X 75 X 45 120 F 80 0 > Answer is complete but not entirely correct. E G 0 X 600 X 540 0 80 560 0 Supply 0 95 75 110 280 2,620