TABLE LOCATION DATA AND CALCULATIONS FOR HEALTH-WATCH Census Tract Population Latitude Longitude Population × Latitude Population × 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

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 latitudes and longitudes are shown in Table, along with the population in each census tract (in thousands). 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
LOCATION DATA AND CALCULATIONS FOR HEALTH-WATCH
Census Tract Population
Latitude
Longitude Population × Latitude
Population × 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 LOCATION DATA AND CALCULATIONS FOR HEALTH-WATCH Census Tract Population Latitude Longitude Population × Latitude Population × 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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Introduction to Service marketing
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
  • 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.