Tom plans to open its first outlet in Mobile, Alabama After he examines the three census tracts in Mobile, he plots the coordinates of the center of cach from a map and looks up the population based in each to use as a weighting. The infomation collected presents in the following table. What is the y-coordinate if we use center-of-gravity method? (Spts) Census Tract 101 102 Population in Census Tract 2000 5000 10,000 XY) Map Coordinates (25,84) (50 20) (90,25) 103 Please keep 3 decimals in your final answer

Tom plans to open its first outlet in Mobile, Alabama After he examines the three census tracts in Mobile, he plots the coordinates of the center of cach from a map and looks up the population based in each to use as a weighting. The infomation collected presents in the following table. What is the y-coordinate if we use center-of-gravity method? (Spts) Census Tract 101 102 Population in Census Tract 2000 5000 10,000 XY) Map Coordinates (25,84) (50 20) (90,25) 103 Please keep 3 decimals in your final answer

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

Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows: Quarter Quarter Guests (in thousands) Guests (in thousands) Winter Year 1 68 Summer Year 2 120 Spring Year 1 99 Fall Year 2 51 Summer Year 1 155 Winter Year 3 99 Fall Year 1 75 Winter Year 2 65 Spring Year 3 Summer Year 3 151 207 Spring Year 2 84 Fall Year 3 98 Based on the given attendance, the seasonal indices for each of the seasons are (round your responses to three decimal places): Season Index Winter
10 Dr. Lillian Fok, a New Orleans psychologist, specializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fokh each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year: ! 1 F1 A 1 option Year Number of Patients Robbery Rate per 1,000 Population The simple linear regression equation that shows the best relationship between the number of patients and the robbery rate is (round your responses to three decimal places): ŷ=0+0x N @ 2 W S X command A where y Number of Patients and x = Robbery Rate. In year 11, if the robbery rate increases to 133.40, using trend analysis, the number of patients Dr. Fok will see = patients (round your response to two decimal places). In year 11, if the robbery rate decreases to 90.6, using trend analysis, the number of patients Dr. Fok will see = patients (round your response to two decimal places). #3 80 F3 E D $ 4 C 888…
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: Price $2.50 $3.40 $1.90 $4.10 $3.20 $4.00 Number Sold 770 510 975 240 315 475 Using simple linear regression and given that the price per cup is $1.75, the forecasted demand for mocha latte coffees will be (enter your response rounded to one decimal place). cups
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: Price $2.60 $3.50 $1.90 $4.10 $3.00 $4.00 Number Sold 760 515 990 245 320 480 D Using simple linear regression and given that the price per cup is $1.80, the forecasted demand for mocha latte coffees will be to one decimal place). cups (enter your response rounded
A company hires you to develop a linear regression forecasting model. Based on the company's historical sales information, you determine the intercept value of the model to be 1,500. You also find the slope value is -25. If after developing the model you are given a value of X = 8, which of the following is the resulting forecast error using this model if the actual sales is 1250?
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: Price $2.70 $3.50 $2.10 $4.10 $3.10 $4.05 Number Sold 765 515 990 245 320 480 Using simple linear regression and given that the price per cup is $1.85, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place).
(8 points) Infoworks is a large computer discount store that sells computers and ancillary equipment and software in the town where a State University is located. Infoworks has collected historical data on computer sales and printer sales for the past 10 years, as follows: Develop a linear regression model relating printer sales to computer sales in order to forecast printer demand in year 11 if 1,300 computers are sold. Develop a moving-average model with n = 3 to forecast printer demand in year 11 Develop an exponential smoothing model with α = .30 to forecast printer demand in year 11. Compare your result in a, b, c. Which model would you choose and why?
N
Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: IT Price Number Sold $2.60 $3.60 $2.00 $4.20 $3.10 $4.00 770 505 975 250 315 490 Using simple linear regression and given that the price per cup is $1.85, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place).
Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows: Quarter Winter Year 1 Spring Year 1 Summer Year 11 Fall Year 1 Guests (in thousands) 68 99 149 75 65 84 Quarter Summer Year 2 Fall Year 2 Winter Winter Year 3 Spring Year 3 Summer Year 3 Fall Year 3 Guests (in thousands) 120 51 99 151 Winter Year 2 207 Spring Year 2 97 Based on the given attendance, the seasonal indices for each of the seasons are (round your responses to three decimal places): Season Index
(Use an excel file to show formulas used)
Eurotronics manufactures components for use in small electronic products such as computers, CD players, and radios at plants in Belgium, Germany, and France. The parts are transported by truck to Hamburg, where they are shipped overseas to customers in Mexico, South America, the United States, and the Pacific Rim. The company has to reserve space on ships months and sometimes years in advance. This requires an accurate forecasting model. Following are the number of cubic feet of container space the company has used in each of the past 18 months: Month Space (1,000s ft.3) 1 10.6 2 12.7 3 9.8 4 11.3 5 13.6 6 14.4 7 12.2 8 16.7 9 18.1 10 19.2 11 16.3 12 14.7 13 18.2 14 19.6 15 21.4 16…