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

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.

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 3 images

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.Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.