101112131415161718192021222324A252627282930Bс12 Based on the city distance dataset as follows:34567891 Boston2 Chicago3 Dallas4 Denver5 LA6 Miami7 Phoenix8 SeattleDPhoenixChicagoDenverDallas0983181519913036153926642612Boston Chicago DallasTotal trip miles by the traveler:IndexCitiesSeattleLAETotal trip miles9830120510502112139017292052FDistance1815120508011425133210272404GDenver LA199110508010117421008361373H3036211214251174027573981909IMiami15391390133221002757023593389JKPhoenix Seattle266417291027836398235901482A resident of Seattle is embarking on a road trip that takes her to Los Angeles,Phoenix, Chicago, Denver, Dallas, and finally go back to Seattle. How manymiles will she travel on this trip?Hint: Use INDEX and MATCH to answer the above question.26122052240413731909338914820LMN

CitiesBostonChicagoDallasDenverLAMiamiPheonixSeattle1Boston09831815199130361539266426122Chicago98301…

Answered: 3 1 5 5 . B 9 0 1 2 3 4 5 6 7 8 9 0 1 2…

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

Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) Table 2 Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Arrival (‘000) 35.5 28.0 30.3 36.0 49.5 56.0 72.4 71.0 79.3 96.0 Delayed rate 4.2 3.8 3.8 3.5 4.6 4.5 4.6 4.6 4.7 4.5 a） Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particularmodel? b) Develop the forecasting model that you suggest in (i). Briefly explain your
Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) Table 2 Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Arrival 35.5 28.0 30.3 36.0 49.5 56.0 72.4 71.0 79.3 96.0 C000) Delayed 4.2 3.8 3.8 3.5 4.6 4.5 4.6 4.6 4.7 4.5 rate (1) Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particular model? (5 marks) (ii) Develop the forecasting model that you suggest in (i). Briefly explain your model. (20 marks)
Travel Passengers 1 405 2 410 3 420 4 415 5 412 6 420 7 424 8 433 9 438 10 440 11 446 12 451 13 455 14 464 15 466 16 474 17 476 18 482 a) Using a weighted moving average with three periods, determine the sales for day 15. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively b) Find the MAD, MSE and MAPE b) Use exponential smoothing with a smoothing constant of 0.50 to forecast the sales (Assume that last period’s forecast for period 1 is equal to actual to begin the procedure (Ft1=Yt1). Which method do you think is best? Is this an improvement over the weighted average- use MAD only
Following data set indicates the annual electricity consumption of Sri Lanka in Mega Watt Hours (MWh) from 1996 to 2022 (Table). You are required to forecast the electricity demand of Sri Lanka for the year 2023 using thefollowing smoothing methods and recommend the most appropriate value. i. Three year moving average methodii. Six year moving average methodiii. Single exponential smoothing method (smoothing constant = 0.2)iv. Single exponential smoothing method (smoothing constant = 0.05) Year Electricity Consumption in MWh 1996 1,588 1997 1,558 1998 1,753 1999 1,408 2000 1,310 2001 1,424 2002 1677 2003 1937 2004 1685 2005 1488 2006 1562 2007 1619 2008 1687 2009 1841 2010 1865 2011 1637 2012 1653 2013 1699 2014 1698 2015 1523 2016 1557 2017 1795 2018 1934 2019 2125 2020 2543 2021 2616 2022 3191
The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Feb Mar Apr Number of Accidents 25 45 60 105 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): y = - 5 + 25.5 x Using least-squares regression, the forecast for the number of accidents that will occur in the month of May = 122.5 accidents (enter your response as a whole number).
Community Federal Bank in Dothan, Alabama, recently increased its fees to customers who use employees as tellers. Management is interested in whether its new fee policy has increased the number of customers now using its automatic teller machines to that point that more machines are required. The following table provides the number of automatic teller transactions by week. Use trend projection with regression to forecast usage for weeks 13–16. Week 1 2 3 4 5 6 7 8 9 10 11 12 Transactions 512 527 631 434 482 539 577 518 526 636 623 461
Freight car loadings over an 18-week period at a busy port are as follows:Weeks Loadings (lbs) Weeks Loadings (lbs) Weeks Loadings (lbs) 1 370 7 415 13 450 2 380 8 425 14 455 3 390 9 435 15 475 4 380 10 425 16 485 5 390 11 435 17 495 6 395 12 445 18 505a. Determine a linear trend line for expected freight car loadings.b. Use the above trend equation to predict expected loadings for Weeks 20 & 21.c. The manager intends to install new equipment when the volume exceeds 950 loadings per week. Assuming the current trend continues, in which week…
Which of the measure(s) of central location can be used for both numerical and categorical variables? Choose from: mean, median, mode, and trimmed mean.
Company ABC produces and sells 4 types of computer monitors of different features. The following table shows the number of products (Products 1, 2, 3, and 4) ABC sold in the past 5 weeks. Week 1 Total Product Type Product 1 20 25 50 55 45 195 Product 2 55 50 378 332 50 80 98 95 Product 3 35 75 90 82 Product 4 40 32 70 88 80 310 Total 165 142 275 331 302 1215 2.1) Use 3-period moving average method (with the general equation given below) to calculate: 2.1.1) the number of Product 1 ABC may plan to sell in Week 6. 2.1.2) the predicted number of Product 2 that ABC planned to sell in Week 5. 2.2) A local competitor, Company XYZ sells Product 5, another type of computer monitor. Product 5 of XYZ typically takes 20% of the total market and the 4 types of products of ABC together take 80% of the market. ABC would like to use its own data to estimate the number of Product 5 sold by XYZ. Use 4-period moving average method to calculate the number of Product 5 that XYZ may have sold in Week 5. To…
The sale data is shown as follows: Month 1: 11 Month 2: 52 Month 3: 95 Using Weighted Simple Moving Average method (Month 1: 0.2; Month 2: 0.3; Month 3: 0.5) to forecast the sales of Month 4: ________ (Round your answer to the nearest integer)
Match the following attributes of a city with the appropriate scale of measurements: Attribute (P) Average temperature (°C) of a city (Q) Name of a city (S) (R) Population density of a city Ranking of a city based on ease of Business Scale of Measurement (I) Interval (II) Ordinal (III) Nominal (IV) Ratio Which one of the following combinations is correct? A) (P)-(I), (Q)-(III), (R)-(IV), (S)-(II) B) (P)-(II), (Q)-(I), (R)-(IV), (S)-(III) c) (P)-(II), (Q)-(III), (R)-(IV), (S)-(I) D) (P)-(I), (Q)-(II), (R)-(III), (S)-(IV)
Please forecast the mileage (in 100) for 2013 using a 4 period moving average method. Please keep 1 decimal place.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

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

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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.

SEE MORE TEXTBOOKS