The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014.YearPeriod (t)Revenue ($ billions)2009123.8201029.2201137.92012450.3201359.82014666.6(a) Construct a time series plot.808070707070606050505030303030-20202020101010 -10-4.6746456712.467PeriodPeriodPeriodPeriodWhat type of pattern exists in the data?O The time series plot shows an upward linear trend.O The time series plot shows a downward curvilinear trend.O The time series plot shows a downward linear trend.O The time series plot shows an upward curvilinear trend.(b) Develop a linear trend equation for this time series to forecast revenue (in billions of dollars). (Round your numerical values to three decimal places.)T =(c) What is the average revenue increase per year (in billions of dollars) that this company has been realizing? (Round your answer to three decimal places.)billionRevenue ($ billions)Revenue ($ billions)Revenue ($ billions)Revenue ($ billions) What type of pattern exists in the data?O The time series plot shows an upward linear trend.O The time series plot shows a downward curvilinear trend.O The time series plot shows a downward linear trend.O The time series plot shows an upward curvilinear trend.(b) Develop a linear trend equation for this time series to forecast revenue (in billions of dollars). (Round your numerical values to three decimal places.)T =(c) What is the average revenue increase per year (in billions of dollars) that this company has been realizing? (Round your answer to three decimal places.)2$billion(d) Compute an estimate of this company's revenue (in billions of dollars) for 2015. (Round your answer to two decimal places.)24billion

Answered: Image /qna-images/answer/e86114c6-99e0-4648-8122-becef93e1528.jpg

Answered: What type of pattern exists in the…

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

The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as follows: CASES OF MERLOT WINE 276 362 YEAR 2005 2006 2007 2008 2009 2010 2011 2012 404 462 364 506 416 382 Using an exponential smoothing model with an alpha value of 0.30, estimate the smoothed value calculated as of the end of 2012. Use the average demand for 2005 through 2007 as your initial forecast for 2008, and then smooth the forecast forward to 2012. (Round your intermediate calculations and final answer to the nearest whole number.) Answer is complete but not entirely correct. Forecast for 2012 372
The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as follows: YEAR CASES OFMERLOT WINE 2005 321 2006 407 2007 449 2008 507 2009 409 2010 551 2011 461 2012 427 Using an exponential smoothing model with an alpha value of 0.30, estimate the smoothed value calculated as of the end of 2012. Use the average demand for 2005 through 2007 as your initial forecast for 2008, and then smooth the forecast forward to 2012.
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances Demand for Guitars Y = This exercise contains only parts b, c, and d. b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): + 4 2 X 5 7 5 9 7 6 7 6 10 7
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?
Sales for the past 6 months at Dalworth Company are given in the following table: Month Sales July 52 August 61 September 53 October 35 November 31 December 28 What is the Mean Absolute Deviation (MAD) for August through December forecasts produced by using exponential smoothing with α = 0.4? (Note: Do not round the forecasts, and choose the closest answer.) Multiple Choice 39.64 8.75 15.28 11.94
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. Use time series decomposition to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number.) Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Over one year, a company sold the following numbers of lawn mowers. Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Sales 238 220 195 245 345 380 270 220 280 120 110 85 Compute the one-step-ahead 3-month and 6-month moving-average forecasts for July through December. Compute the MAD for the forecasts obtained in part (a). What effect does increasing N from 3 to 6 have on the forecasts? Use the arithmetic average of the first six months of data as a baseline to initialize the exponential smoothing. Compute the one-step-ahead exponential smoothing forecasts for July through December, assuming α = 0.20. Compare the accuracy of the forecasts obtained in part (c) with the one-step ahead six-month moving-average forecasts obtained in part (a).
Please do not give solution in image formate thanku. Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with α = 0.5 Forecast the number of calls for week 6, which is next week. WEEK ACTUAL SERVICE CALLS 1 28 2 32 3 40 4 27 5 30
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 30 48 70 90 Part 2 Using the least-squares regression LOADING... method, the trend equation for forecasting is (round your responses to two decimal places): y = enter your response here + enter your response here x Y=?+?x
Let's say you are playing the stock market and below period 2020 data was provided. For "stock A" you use a 2 month moving average. For "stock B" you use exponential smoothing with (a = 0.3). What is the Forecast in Stock B for January 2021? Stock A Stock B ... Jan 0.11 Jan 14 Feb 0.20 Feb 11 Mar 0.03 Mar Apr May 1.20 Apr May 6. 0.50 9 Jun 0.03 Jun 12 Jul 0.10 Jul 16 Aug 0.11 Aug Sep 14 Sep 0.56 8 Oct 0.78 Oct Nov 0.44 Nov 4 Dec 0.10 Dec
A company wants to generate a forecast for unit demand for year 2017 using exponential smoothing. The actual demand in year 2016 was 120. The forecast demand in year 2016 was 110. Using this data and a smoothing constant alpha of 0.1, which of the following is the resulting year 2017 forecast value?
After graduation, you take a position at Top-Slice, a well-known manufacturer of golf balls. One of your duties is to forecast monthly demand for golf balls. Using the following data, you developed a regression model that expresses monthly sales as a function of average temperature for the month: Monthly sales=-202.2+86.5x (average temperature) Click the icon to view the additional data. a. Show how the a and 6 values of -202.2 and 86.5 were calculated. Calculate the slope coefficient, b (enter your responses as whole numbers). (745) 12 12 2 =86.5 More Info March 2017 April May June July August September October November December January 2018 February Monthly Sales 5,300 3,990 5,700 6,520 7,600 7,420 Print 6,710 4,870 3,990 3,900 3,320 2,670 Temperature 51 56 Done 64 80 79 87 83 67 58 41 39 40 X

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