1. A manager has received an analysis of several cities being considered for a new office complex. The data are: Factor Location Transpo Таx COLA C REC cs BS wwwww A 4 3 7 В 7 7 6 5 8 8 7 5 2 If the manager weighs the factor equally, how would the locations *stack up? * loed pile, pack b. If Construction cost and business services are given weights that are double the weights of the other factors, how would the locations stack up?

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...
icon
Related questions
Question

 

 

3. PLBT is attempting to determine the optimal location for training facility for its operators. The
operators are located in 4 centers and training facility to serve these centers. The coordinates
are given as follows:
Center
Coordinates
1
2
3
4
11
42
32
28
Y
69
31
58
45
no. of operators
in thousand
3.4
6.8
4.5
Determine the optimal coordinates of the training facility.
4.Your company is planning to move to a new location, and have asked your 200 employees, what
factors are the most important to them in the new location. For each of the factors given below, the
number next to the factor is the number of employees that put the factors first, or second in
importance. After this evaluation, you asked each person to rank the location first for the given factor.
Location
Factors
A
B
Personal Safety (150)
80
70
50
Proximity to the Day Care (100)
50
80
70
Access to public transportation (100)
Parking (150)
100
40
60
90
60
50
The above ratings were then used to develop a score from 0 to 1 for each location with 1 being the best.
On this scale determine the best location.
Transcribed Image Text:3. PLBT is attempting to determine the optimal location for training facility for its operators. The operators are located in 4 centers and training facility to serve these centers. The coordinates are given as follows: Center Coordinates 1 2 3 4 11 42 32 28 Y 69 31 58 45 no. of operators in thousand 3.4 6.8 4.5 Determine the optimal coordinates of the training facility. 4.Your company is planning to move to a new location, and have asked your 200 employees, what factors are the most important to them in the new location. For each of the factors given below, the number next to the factor is the number of employees that put the factors first, or second in importance. After this evaluation, you asked each person to rank the location first for the given factor. Location Factors A B Personal Safety (150) 80 70 50 Proximity to the Day Care (100) 50 80 70 Access to public transportation (100) Parking (150) 100 40 60 90 60 50 The above ratings were then used to develop a score from 0 to 1 for each location with 1 being the best. On this scale determine the best location.
1. A manager has received an analysis of several cities being considered for a new office complex.
The data are:
Factor
Location
Transpo
Тах
COLA
C
REC
CS
BS
A
4
3
7
В
7
7
8.
6.
8.
4
8
7
7
If the manager weighs the factor equally, how would the locations *stack up? * load.eile, pack
a.
b. If Construction cost and business services are given weights that are double the weights of the
other factors, how would the locations stack up?
2. MFA hopes to open a rust proofing shop. Customer would be local new car dealers. Two
I new
locations are being considered, one in the center of the city and one outside. The central city
location would involve a monthly fixed cost of $7000 and labor, material and transportation cost
of $30 per car. The outside location would have fixed monthly cost of $4700 and labor,
materials and transportation costs of $40 per car. Dealer price at either location will be $90 per
car.
a. Which location will yield the greatest profit if demand is A) 200 cars B) 300 cars.
b. At what volume of output will these two sites yield the same monthly profit?
Transcribed Image Text:1. A manager has received an analysis of several cities being considered for a new office complex. The data are: Factor Location Transpo Тах COLA C REC CS BS A 4 3 7 В 7 7 8. 6. 8. 4 8 7 7 If the manager weighs the factor equally, how would the locations *stack up? * load.eile, pack a. b. If Construction cost and business services are given weights that are double the weights of the other factors, how would the locations stack up? 2. MFA hopes to open a rust proofing shop. Customer would be local new car dealers. Two I new locations are being considered, one in the center of the city and one outside. The central city location would involve a monthly fixed cost of $7000 and labor, material and transportation cost of $30 per car. The outside location would have fixed monthly cost of $4700 and labor, materials and transportation costs of $40 per car. Dealer price at either location will be $90 per car. a. Which location will yield the greatest profit if demand is A) 200 cars B) 300 cars. b. At what volume of output will these two sites yield the same monthly profit?
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Location planning
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
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.