East Texas Seasonings is preparing to build one processing center to serve its four sources of seasonings. The four source locationsare at coordinates shown below. Also, the volume from each source is provided. What is the center of gravity?X-coordinateY-coordinateVolumeAthens, TexasBeaumont, Texas30301502010350Carthage, TexasDenton, Texas10701005050400OX-28.125; Y = 31.25OX= 32500; Y = 35000%3DX 32.5; Y = 35X- 27.5; Y 40O center of gravity 28

Answered: Image /qna-images/answer/b813d6fe-010c-4381-82ab-b8b861ce32ba.jpg

Answered: East Texas Seasonings is preparing to…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 40P

See similar textbooks

Similar questions

Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)
4. Spears Rowbuck has recorded the following sales figures. Calculate the seasonal indices for Thursday and Friday. Week 1 Week 2 Week 3 Week 4 Monday 43 51 40 66.0 Tuesday 45 41 57 58.6 Wednesday 22 37 30 34.7 Thursday 25 22 33 36.7 Friday 31 25 37 25.0 a. Thursday = 29.18, Friday = 29.50 b. Thursday = 0.2074, Friday = 1.1632 c. None of the other options. d. Thursday = 0.7678, Friday = 0.7763 e. Thursday = 0.6142, Friday = 0.6211
A manager uses this equation to predict demand for landscaping services: Ft = 14 + 4t. Over the past eight periods, demand has been as follows: Period, t: 1 2 3 4 5 6 7 8 Demand: 20 25 25 35 35 40 45 50 Compute the tracking signals for Periods 1-8. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period t Tracking Signal 1 2 3 4 5 6 7 8
Use the information below to answer question 2x + 3y + 3z = 2 4x – 3y – 6z = 2 10x – 6y + 3z = 0 1. Given values – 144, -192, and 96 for Dx, Dy, and Dz respectively and D = 144. Then the solution to the system for x, y and z are: A. -1, -1.33, and 0.67 B. -0.47, -0.63 and 0,30 C. 0.5, 0.67 and-0.33 D. 0.73, 0.98 and -0.49
5, The total number of thousands of tons of coal produced per year over a 10-year period for a certain region is provided in the accompanying dataset. Use double exponential smoothing to determine which pairs of values for α and minimize MAD for this dataset. α=0.2, β=0.8; α=0.4, β=0.3; α=0.9, β=0.7 Which pair of values for α and β minimize MAD for this dataset? α=enter your response here and β=enter your response here (Type integers or decimals. Do not round.) Year Coal Production (thousands of tons) 1 434,325 2 420,421 3 439,039 4 477,196 5 504,186 6 526,958 7 546,817 8 564,876 9 556,711 10 570,977
Long-Life Insurance has developed a linear model that it uses to determine the amount of term life insurance a family of four should have, based on the current age of the head of the household. The equation is:y = 850 − .1xwherey = Insurance needed ($000)x = Current age of head of household a. Plot the relationship on a graph. b. Use the equation to determine the amount of term life insurance to recommend for a family of four if the head of the household is 30 years old.
The number of students enrolled in Spring Valley Elementary school has been steadily increasing over the past five years. The School Board would like to forecast enrolment for years 6 and 7 in order to better plan capacity. The past five years enrolment is indicated in table 3: Table 3 Year Enrollment 1 220 2 245 3 256 4 289 5 310 Assuming a linear trend, use the tabular method to derive values for: the slope the intercept How did you work out to get 22.4 for the slope and for the intercept how did you work it out and get 196.8
The following data relate the sales figure of the bar in Mark Kaltenbach's small bed- and -breakfast inn in portland, to the number of guest registered that week: week guests bar sales 1 16 $320 2 12 $265 3 18 $390 4 14 $315 a) the simple linear equation that relates bar sales to the number of guests ( not totime) is (round your response to one decimal place) Bar sales=[__]+[__]X guest
The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (a)Use ? = 0.4 to compute the exponential smoothing values for the time series. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (b)Use a smoothing constant of ? = 0.6 to compute the exponential smoothing forecasts. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110
#28Even though independent gasoline stations have been having a difficult time, Susan Solomon hasbeen thinking about starting her own independent gasoline station. Susan’s problem is to decide howlarge her station should be. The annual returns will depend on both the size of her station and a numberof marketing factors related to the oil industry and demand for gasoline. After a careful analysis, Susandeveloped the following table: GOOD FAIR POORSIZE OF MARKET MARKET MARKETFIRST STATION ($) ($) ($)Small 50,000 20,000 –10,000Medium 80,000 30,000 –20,000Large 100,000 30,000 –40,000Very large 300,000 25,000 –160,000For example, if Susan constructs a…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS