Question

In: Operations Management

Wildcat Gym, with its 3 branches located in Central New York, wants to assign three recently...

Wildcat Gym, with its 3 branches located in Central New York, wants to assign three recently hired health consultants - Todd, Josh, and Nina - to its 3 branches in Cortland, Auburn, and Oneonta. It is clearly indicated from its Headquarters that none of these three consultants will be assigned to the same locations.

The relocate costs are shown here in the table.

Consultant/Location Cortland Auburn Oneonta
Todd $720 $680 $550
Josh $700 $710 $588
Nina $655 $635 $495

Part a) The Headquarters is trying to find the optimal assignment of personnel to these 3 branches with a minimal relocate cost. Use the network concept and create a network program for the above problem. Make sure you define the variables used and clearly list the objective function and constraints. You do not need to solve the program.

Part b) Later the Headquarters received an update that Todd has left Wildcat Gym and now works for a different company. How will you modify your above program to reflect this update?

Solutions

Expert Solution

Answer A)

A Variables
Location Cortland Auburn Onetona
Todd X1 X2 X3
Josh X4 X5 X6
NINA X7 X8 X9
B Constraints
a) X1+x2+x3 = 1
X3+X4+X5 = 1
X6+X7+X8 = 1
b) X1+X3+X6 = 1
X2+X4+X7 = 1
X3+X5+X8 = 1
c) X1 to X9 All to be Integer
d) X1 to X9 all to be binary
C Objective function is = 720 * X1 + 680 * X2 + 550 * X3
+ 700 * X4 + 710 * X5 + 588 * X6
+ 655 * X7 + 635 * X8 + 495 * X9

The objective fucntion has to be minimized

Solution is attached

------------------------------------

Answer b

A Variables
Location Cortland Auburn Onetona
Josh X4 X5 X6
NINA X7 X8 X9
B Constraints
a) X3+X4+X5 = 1
X6+X7+X8 = 1
b) X4+X7 <= 1
X5+X8 <= 1
X6+X9 <= 1
b) X4+X7 >= 0
X5+X8 >= 0
X6+X9 >= 0
d) X3 to X9 All to be Integer
e) X3 to X9 all to be binary
C Objective function is = 700 * X4 + 710 * X5 + 588 * X6
+ 655 * X7 + 635 * X8 + 495 * X9

The objective fucntion has to be minimized

Solution is attached


Related Solutions

3. A bank with branches located in a commercial area in Jakarta wants to improve the...
3. A bank with branches located in a commercial area in Jakarta wants to improve the process for serving customers during the lunch time period. Waiting time data was collected from a random sample of 15 customers in Bank branch 1, as follows: 4.21 5.55 3.02 5.13 4.77 2.34 3.54 3.20 4.50 6.10 0.38 5.12 6.46 6.19 3.79 Data was also collected from a random sample of 15 customers in Bank branch 2, as follows: 9.66 5.90 8.02 5.79 8.73...
X Corporation exchanged a warehouse located in New York for a warehouse located in New Jersey....
X Corporation exchanged a warehouse located in New York for a warehouse located in New Jersey. The adjusted basis of the New York warehouse was $30,000. The fair market value of the New Jersey warehouse just prior to the exchange was $25,000. In addition to the warehouse, X Corporation also received $8,000 in cash. 54.     The amount realized by X Corporation is: a. $8,000 b. $33,000 c. $25,000 d. Zero e. None of the above The gain realized by X...
Jacque Co. is a French company located in Paris. Yankee Corp., located in New York City,...
Jacque Co. is a French company located in Paris. Yankee Corp., located in New York City, acquires Jacque Co. Jacque has the Euro as its local currency and the Swiss Franc as its functional currency. Yankee has the U.S. dollar as its local currency and the U.S. dollar as its functional currency. Required: a) The year-end consolidated financial statements will be prepared in which currency? b) Explain which method is appropriate to use to use at year-end: Translation or Remeasurement?
The three-month dollar interest rate in New York is 3% per annum. Alternatively, the three-month euro...
The three-month dollar interest rate in New York is 3% per annum. Alternatively, the three-month euro interest rate in Frankfort is 5% p.a. The current $/€ spot exchange rate is $1.1340/€. The euro three-month forward rate is quoted at $1.1326/€. Show how a U.S. arbitrageur would exploit a possible covered interest arbitrage opportunity with a nominal $80,000,000. Don’t start with the formula. Explain in your own words the transactions the arbitrageur would execute and calculate the profit/loss the arbitrager would...
Barbour Corporation, located in Buffalo, New York, is a retailer of hightech products and is known...
Barbour Corporation, located in Buffalo, New York, is a retailer of hightech products and is known for its excellent quality and innovation. Recently the firm conducted a relevant cost analysis of one of its product that has only two products, T-1 and T-2. The sales for T-2 are decreasing and the purchase costs are increasing. The firm might drop T-2 and sell only T-1.      Barbour allocates fixed costs to products on the basis of sales revenue. When the president of...
Barbour Corporation, located in Buffalo, New York, is a retailer of high-tech products and is known...
Barbour Corporation, located in Buffalo, New York, is a retailer of high-tech products and is known for its excellent quality and innovation. Recently, the firm conducted a relevant cost analysis of one of its product lines that has only two products, T-1 and T-2. The sales for T-2 are decreasing and the purchase costs are increasing. The firm might drop T-2 and sell only T-1. Barbour allocates fixed costs to products on the basis of sales revenue. When the president of...
Barbour Corporation, located in Buffalo, New York, is a retailer of high-tech products and is known...
Barbour Corporation, located in Buffalo, New York, is a retailer of high-tech products and is known for its excellent quality and innovation. Recently, the firm conducted a relevant cost analysis of one of its product lines that has only two products, T-1 and T-2. The sales for T-2 are decreasing and the purchase costs are increasing. The firm might drop T-2 and sell only T-1. Barbour allocates fixed costs to products on the basis of sales revenue. When the president...
Creamy Dairy is a family-owned dairy located in upstate New York. They are trying to decide...
Creamy Dairy is a family-owned dairy located in upstate New York. They are trying to decide how to process their corn into feed for their livestock. Because they are dairy farmers (and good ones at that), financial choices have a mystical quality about them, so they could use your help. The farm is currently earning $300,000 per year, and an improvement could provide additional revenue. Each of the options will result in an additional (above the current dairy earnings) yearly...
Barbour Corporation, located in Buffalo, New York, is a retailer of high-tech products and is known...
Barbour Corporation, located in Buffalo, New York, is a retailer of high-tech products and is known for its excellent quality and innovation. Recently, the firm conducted a relevant cost analysis of one of its product lines that has only two products, T-1 and T-2. The sales for T-2 are decreasing and the purchase costs are increasing. The firm might drop T-2 and sell only T-1. Barbour allocates fixed costs to products on the basis of sales revenue. When the president...
Barbour Corporation, located in Buffalo, New York, is a retailer of high-tech products and is known...
Barbour Corporation, located in Buffalo, New York, is a retailer of high-tech products and is known for its excellent quality and innovation. Recently, the firm conducted a relevant cost analysis of one of its product lines that has only two products, T-1 and T-2. The sales for T-2 are decreasing and the purchase costs are increasing. The firm might drop T-2 and sell only T-1. Barbour allocates fixed costs to products on the basis of sales revenue. When the president...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT