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

Related questions

Q: From To W Y Z Demand A $4 $6 $8 30 B $3 $7 $2 65 с $3 $6 $5 40 Capacity 35 50 50 135

A: Using any of the methods, such as the North-West Corner, Least Cost Method, or Vogel's Approximation…

Q: 1. a) Consider the following maximization transportation problem. Find the optimal solution and…

A: Given data is

Q: Peaches are to be transported from three orchard regions to two canneries. Intermediate stops at a…

A: Find the Given details below: Given details: Riverside Sunnyside Old Farm Waterford Northside…

Q: A minimum-cost flow problem has 8 supply nodes, O transshipment nodes, and 7 demand nodes. If each…

A: The detailed solution is given in Step 2.

Q: In June, Bearcat City purchased materials costing $26,100 and incurred direct labor cost of $20,200.…

A: 1-Jun30-JunMaterial$6,820$7,810Work in process8801450Finished goods36302970Material cost…

Q: Stepping-Stone Method Store A Plant 1 Plant 2 Plant 3 Demand 200 3 5 Сл 3 Store B 300 5 9 8 Store C…

A: The stepping stone method is an iterative technique used in operations research and linear…

Q: As a hotel manager with area should i mainly focus regular reservation pe rugby dans

A: Employees are one most essential aspects of any business. Skilled and motivated employees can act as…

Q: Referring to the above problem, solve it by the vogel approximation method

A: The transportation model is used to calculate the minimum cost of the route by selecting different…

Q: Explain how to determine the number and location of warehouses?

A: The most important aspect of supply chain and distribution management is warehousing. The quantity…

Q: 4.- A building materials company with production facilities in Reno, Spokane and Tacoma ships boxes…

A: One of the simplest ways to come up with a workable solution to a transportation issue is to use the…

Q: According to Adam Smith, labour specialisation is constrained by the size of the market, and…

A: Statement: Person A claimed that the labour specialisation is restricted by the market size and…

Q: We have four major customers, and want to find the location that minimizes the average distance…

A: The Center of Gravity Method is a technique for calculating geographic coordinates for a prospective…

Q: Solve the following transportation problem using Excel. Factory A E K Demand B 6 5 8 35 Warehouse C…

A: The transportation problem is stated below:

Q: Under what conditions could it make sense to combine private and public warehouses in a logistical…

A: Companies stored inventory of resources or commodities in warehouses to ensure that enough inventory…

Q: Imagine you are in charge of making the decision to lease orbuy a fleet of trucks for the moving…

A: The significance of a make or buy decision in an organization are: 1. When a company makes its…

Concept explainers

Optimization Models

Optimization models are mathematical models that help organizations determine the best way to allocate scarce resources to achieve specific objectives. These models can be used to solve a wide variety of problems, from finding the most efficient route for a delivery truck to determining the optimal mix of products to stock in a store.

Question

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. You must decide
where 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 decision
variables. (Note: you do not have to solve this linear programming problem.)

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

Relocation costs have slowed the use of easy-transfers of employees from one locale to another. State True or False.
Given the following table solve by vogel approximation method
Plz expert don't Use chat gpt Give detailed explanation
19. A company has four factories manufacturing the same commodity, which are required to be trans- ported to meet the demands in four warehouses. The supplies and demands as also the cost per trans- portation from factory to warehouse in rupees per unit of product are given in the following table: Warehouses Supply (units) Factory Y W A 25 55 40 60 60 Joqob l ta B 35 30 50 40 140 C 36 45 26 66 150 lo'to D 35 30 41 50 50 Demand (units) 90 100 120 140 (a) Derive an optimal strategy of transportation of goods from factories to warehouses and assess the optimal cost. (b) If a new transporter agrees to transport goods from factory C to warehouse W at a unit cost of ? 50, analyse the impact of this on your current optimal solution. (DMS, Mumbai, 1998)
(Use an excel file to show formulas used)
For a certain company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 84, 84, 85, 84, 82, 83, 84, and 83. (a) Construct a time series plot. Monthly Percentage Monthly Percentage 86 85 84 83 82 81 80 79 78 77 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month 86 85 84 81 80 79 78 77 + 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month @ 83 IM 82 81 Monthly Percentage 86 Monthly Percentage 85 84 80 79 78 77 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month 86 85 84 83 82 81 80 79 78 77 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month What type of pattern exists in the data? O Overall, the time series plot exhibits a consistent trend pattern. O The first two points may be an indication of a shift to a new level, but overall the time series plot exhibits a seasonal pattern. O The first two points may be an indication of a shift to a new level, but overall the time series plot exhibits a cyclical pattern. O The last two points may be an indication of a shift to a new level, but…
Please do not give solution in image formate thanku.
15. The chief advantage of shipping by truck is A. lower cost. B. the ability to consolidate shipments. C. location flexibility. D. the ability to ship less-than-truckload amounts.
Which of the following is the purpose of a warehouse? A. Break-bulk point B. Storage point C. Consolidation point D. All of the above
The Superior Manufacturing Company wants to make two shipments from Dallas, Texas to Los Angeles, California. The first shipment weighs 10,000 pounds and the second shipment weighs 15,000 pounds. The carrier charges $10 per hundredweight (cwt) if the goods are shipped separately and they arrive in two days. If the goods can be consolidated into one shipment the cost would be $8 per cwt to ship them in a truckload lot, but it would cost $500 to consolidate the shipments at the carrier’s warehouse and it would take three days. Which is the lowest cost approach and which approach would you select?
The Transportation Simplex Method Using Minimum Cost From Plant 1 Plant 2 Plant 3 Demand (Million kwh) City 1 $8 $9 $14 45 City 2 $6 $12 $9 20 City 3 $10 $13 $16 30 To City 4 $9 $7 $5 30 Supply (Million kwh) 35 50 40
True or False If the term of the sale is FOB destination point, the Seller will shoulder the cost of the transportation in delivering the goods to the buyer.