expand icon
book An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin cover

An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin

النسخة 13الرقم المعياري الدولي: 978-1439043271
book An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin cover

An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin

النسخة 13الرقم المعياري الدولي: 978-1439043271
تمرين 16
Automobile unit sales at B.J. Scott Motors, Inc., provided the following 10-year time series: Automobile unit sales at B.J. Scott Motors, Inc., provided the following 10-year time series:    a. Construct a time series plot. Comment on the appropriateness of a linear trend. b. Use Excel Solver or LINGO, develop a quadratic trend equation that can be used to forecast sales. c. Using the trend equation developed in part (b), forecast sales in year 11. d. Suggest an alternative to using a quadratic trend equation to forecast sales. Explain.
a. Construct a time series plot. Comment on the appropriateness of a linear trend.
b. Use Excel Solver or LINGO, develop a quadratic trend equation that can be used to forecast sales.
c. Using the trend equation developed in part (b), forecast sales in year 11.
d. Suggest an alternative to using a quadratic trend equation to forecast sales. Explain.
التوضيح
موثّق
like image
like image

Construct a time series plot using excel...

close menu
An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin
cross icon