15. The sales of a company for the years 2011 to 2017 are given below :201365201613220172752015201247201492YearSales (in million)Find trend values by using the equation Ye = a b and estimate the value for 2020.201132190bong

Answered: 15. The sales of a company for 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

Given the following historical data, what is the simple three-period moving average forecast for period 6? Period 1 2 3 4 5 67.67 68.2 67.3 68.4 Value 73 66 64 73 66
Sales of Volkswagens have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Q Year 1 2 3 4 5 a) Forecasted sales for year 6 using the trend projection (linear regression) method are Sales 455 510 518 575 590 sales (round your response to one decimal place).
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.
In a retail store, the actual sales of a particular product (in thousands of units) over the past few months are as follows: Month Sales 1 16 2 22 3 18 4 20 5 23 Using exponential smoothing method with α (smoothing constant) of 0.75 and the given forecast for month 1 equal to 10, what is the forecast for month 6?
Given the following historical data, what is the simple three-period moving average forecast for period 6? Period Value 1 73 2 68 3 65 4 72 5 67
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. QUARTER 1 2 5678AWN 3 4 8 SALES 219 237 208 171 169 Quarter 9 10 11 12 192 157 132 Use regression and seasonal indexes to forecast quarterly sales for the next year. Note: Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast
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. QUARTER SALES 1 215 2 240 3 205 4 190 5 160 6 195 7 150 8 140 Use regression and seasonal indexes to forecast quarterly sales for the next year. Note: Do not round intermediate calculations. Round your answers to 1 decimal place.
Using linear regression analysis, what would you estimate demand to be for each month next year? Month Forecast January February March April May June July August September October November December
After using your forecasting model for six months, you decide to test it using a tracking signal. Here are the forecast and actual demands for the six-month period: PERIOD FORECAST ACTUAL May 450 500 June 500 550 July 550 400 August 600 500 September 650 675 October 700 600 Find the tracking signal of each month
3. Quarterly sales of a car dealer exhibit an almost constant mean over time, but sales fluctuate depending on the quarter of the year (exhibits seasonality). Quarter Q1 - Spring Q2 - Summer Q3 - Fall Q4 - Winter Mean Year 1 32 74 53 22 45.25 Year 2 30 71 63 15 44.75 Year 3 35 83 45 19 45.5 (a) Using three years' worth of quarterly data that is provided, develop a set of seasonal factors that could be used to forecast car sales (b) Forecast car sales in each of the four quarters (Q1-Q4) of the following year (Year 4), using these seasonal factors.
What is the short-term retail sales forecast for 1 to 3 years? What is the mid-term retail sales forecast for 3-5 years? What is the long-range retail sales forecast for >5 years? In conclusion, what is the future forecast of the retail environment?
Make a 15-year simple linear regression forecast. Example: Railroad Products Co. RPC Sales Car Loadings Year ($millions) (millions) 1 9.5 120 2 11.0 135 3 12.0 130 4 12.5 150 5 14.0 170 6 16.0 190 7 18.0 220

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

15. The sales of a company for the years 2011 to 2017 are given below : 2013 65 2012 2017 275 2011 ear ales (in million) Find trend values by using the equation Ye= a b and estimate the value for 2020. 2014 92 2015 190 2016 132 32 47