Question 2 SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 5 states listed below. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,000, Tulsa is $131,000, Denver is $140,000, and Seattle is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown below. Each consultant is expected to take at most 40 trips each year. If at most 3 consultants are to be assigned to a home office, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network? Travel cost (S)

Question 2 SC Consulting, a supply chain consulting firm, must decide on the location of its home offices. Its clients are located primarily in the 5 states listed below. There are four potential sites for home offices: Los Angeles, Tulsa, Denver, and Seattle. The annual fixed cost of locating an office in Los Angeles is $165,000, Tulsa is $131,000, Denver is $140,000, and Seattle is $145,000. The expected number of trips to each state and the travel costs from each potential site are shown below. Each consultant is expected to take at most 40 trips each year. If at most 3 consultants are to be assigned to a home office, where should the offices be set up? How many consultants should be assigned to each office? What is the annual cost of this network? Travel cost (S)

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 university administration would like to add some additional parking locations. To make everyone happy, they would like each building to be within a 5 minute walk of one set of new parking spaces (the spaces will be added in blocks of 10 parking spaces). The university is considering six locations for the new parking spaces, but would like to minimize the overall cost of the project. In addition to the walking time requirement, the university would like to add at least 40 new parking spaces (at least 4 blocks of 10). To help with the decision, the management science department formulated the following linear programming model: Min 350x1 + 425x2 + 425x3+ 465x4 + 485x5 + 365x6 s.t. x1 + x2 + x5 + X6 2 1 (Residence Hall A constraint) x1 + x2 + X3 2 1 {Residence Hall B constraint) X4 + X5 + X6 2 1(Science building constraint) X1 + X4 + X5 2 1{Music building constraint} x2 + x3 + X4 2 1{Math building constraint} x3 + X4 + X5 2 1{Business building constraint} x2 + x5 + X6 2 1{Auditorium…
Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
Questions i. Calculate the weighted score for each alternative location. ii. Which location should be chosen?
Q Let us assume that a new medical facility, Health-care, is to be located in XYZ city. The location factors, factor rating and scores for two potential sites are shown in the following table. Which is the best location based on factor rating method? Sr Location factor Factor Rating Rating Location 1 Location 2 1 Facility utilization 10 5 4 2 Total patient per month 8 4 2 3 Average time per emergency trip 5 4 5 4 Land and construction costs 6 3 4 5 Employee preferences 7 4 4 6 Operations Facility 8 4 3
b. An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 6 8 10 14 16 18 20 0 (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
Q4: Bluestar TV Cable company is in the process of providing cable services to five new housing development areas. Figure depicts possible TV linkages among the five areas. The cable miles are shown in each arc. Determine the most economical cable network by also providing a linear programming formulation. 3 miles 9 10 6 5
Q 3 locations have been identified as suitable options for building a new factory. The fixed and variable costs for each of the 3 potential locations has been estimated. Identify the best location when a) Demand estimate is 2000 units b) Demand estimate is 3500 units and c) Identify point of indifference between B and C (Rupees) (Rupees) Location Annual Fixed Cost Unit Variable Cost A 5,00,000 300 B 7,50,000 200 C 9,00,000 100
Question 1. Identify the range of output for which each alternative is superior(has the lowest cost) 2. If the expected output at the selected location is to be 10000 units per year, which location would provide the lowest total cost? Location Fixed Cost Variable cost A $250,000 $11 B $100,000 $30 C $150,000 $20 D $200,000 $35
Given is a decision payoff table. Alternatives Small Facility Medium Facility Large Facility Low 26 18 -7 Future Demand Moderate 21 31 30 High 18 22 42 a) The best decision under uncertainty using MAXIMAX is to select Blank 1 facility b) The best decision under uncertainty using MAXIMIN is to select Blank 2 facility c) The best decision under uncertainty using LAPLACE/EQUALITY LIKELY is to select Blank 3 facility d) If the probabilities for Future Demand when it is Low-0.35, Moderate -0.30, and High-0.35, the expected monetary value (EMV) for the large facility-Blank 4.
The university administration would like to add some additional parking locations. To make everyone happy, they would like each building to be within a 5 minute walk of one set of new parking spaces (the spaces will be added in blocks of 10 parking spaces). The university is considering six locations for the new parking spaces, but would like to minimize the overall cost of the project. In addition to the walking time requirement, the university would like to add at least 40 new parking spaces (at least 4 blocks of 10). To help with the decision, the management science department formulated the following linear programming model: Min 400x1 + 375x2 + 425x3 + 350x4 +410x5 + 500x6 s.t. X1 + X2 + X5 + X6 ≥ 1 {Residence Hall A constraint} X1 + x2 + x3 ≥ 1 {Residence Hall B constraint} X4 + X5 + X6 ≥ 1 {Science building constraint} X1 + X4 + X5 ≥ 1 {Music building constraint} X2 + x3 + x4 ≥ 1 {Math building constraint} X3 + x4 + X5 ≥ 1 {Business building constraint} X2 + X5 + X6 ≥ 1…
Problem 8-4 (Algo) A company that produces pleasure boats has decided to expand one of its lines. Current facilities are insufficient to handle the increased workload, so the company is considering three alternatives, A (new location), B (subcontract), and C (expand existing facilities). Alternative A would involve substantial fixed costs but relatively low variable costs: fixed costs would be $285,000 per year, and variable costs would be $570 per boat. Subcontracting would involve a cost per boat of $2,570, and expansion would require an annual fixed cost of $59,000 and a variable cost of $1,040 per boat. a. Find the range of output for each alternative that would yield the lowest total cost. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the nearest whole number.) A B с Answer is not complete. or to to more b. Which alternative would yield the lowest total cost for an expected annual volume of 70 boats? C. What other factors might be…
In what way is the location of customer markets astrategic consideration in facility location?