What is the target area’s center of gravity for the Health-Watch medical facility?

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

The new Health-Watch facility is targeted to serve seven census tracts in Erie, Pennsylvania, whose lati-
tudes and longitudes are shown in Table 13.1, along with the population in each census tract (in thou-
sands). Customers will travel from the seven census-tract centers to the new facility when they need
health care. What is the target area’s center of gravity for the Health-Watch medical facility?

TABLE 13.1 LOCATION DATA AND CALCULATIONS FOR HEALTH-WATCH
Census Tract Population
Latitude
Longitude Population x Latitude Population x Longitude
15
2,711
42.134
-80.041
114,225.27
-216,991.15
16
4,161
42.129
-80.023
175,298.77
-332,975.70
17
2,988
42.122
-80.055
125,860.54
-239,204.34
25
2,512
42.112
-80.066
105,785.34
-201,125.79
26
4,342
42.117
-80.052
182,872.01
-347,585.78
27
6,687
42.116
-80.023
281,629.69
-535,113.80
28
6,789
42.107
-80.051
285,864.42
-543,466.24
Total
30,190
1,271,536.04
-2,416,462.80
Transcribed Image Text:TABLE 13.1 LOCATION DATA AND CALCULATIONS FOR HEALTH-WATCH Census Tract Population Latitude Longitude Population x Latitude Population x Longitude 15 2,711 42.134 -80.041 114,225.27 -216,991.15 16 4,161 42.129 -80.023 175,298.77 -332,975.70 17 2,988 42.122 -80.055 125,860.54 -239,204.34 25 2,512 42.112 -80.066 105,785.34 -201,125.79 26 4,342 42.117 -80.052 182,872.01 -347,585.78 27 6,687 42.116 -80.023 281,629.69 -535,113.80 28 6,789 42.107 -80.051 285,864.42 -543,466.24 Total 30,190 1,271,536.04 -2,416,462.80
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE 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.