(8 points) Infoworks is a large computer discount store that sells computers and ancillary equipment and software in the town where a State University is located. Infoworks has collected historical data on computer sales and printer sales for the past 10 years, as follows: Develop a linear regression model relating printer sales to computer sales in order to forecast printer demand in year 11 if 1,300 computers are sold. Develop a moving-average model with n = 3 to forecast printer demand in year 11 Develop an exponential smoothing model with α = .30 to forecast printer demand in year 11.Compare your result in a, b, c. Which model would you choose and why? 1. (8 points) Infoworks is a large computer discount store that sells computers and ancillaryequipment and software in the town where a State University is located. Infoworks hascollected historical data on computer sales and printer sales for the past 10 years, as follows:Year Personal Computers Printers SoldSold11,04532621,610510386029641,21147897530561,11750671,06661281,31056091,517590101,246676a) Develop a linear regression model relating printer sales to computer sales in order toforecast printer demand in year 11 if 1,300 computers are sold.b) Develop a moving-average model with n= 3 to forecast printer demand in year 11c) Develop an exponential smoothing model with a = .30 to forecast printer demand in year11.d) Compare your result in a, b, c. Which model would you choose and why?

Develop a linear regression model relating printer sales to computer sales in order to forecast printer demand in year 11 if 1,300 computers are sold. Develop a moving-average model with n = 3 to forecast printer demand in year 11 Develop an exponential smoothing model with α = .30 to forecast printer demand in year 11. Compare your result in a, b, c. Which model would you choose and why?

Develop a linear regression model relating printer sales to computer sales in order to forecast printer demand in year 11 if 1,300 computers are sold. Develop a moving-average model with n = 3 to forecast printer demand in year 11 Develop an exponential smoothing model with α = .30 to forecast printer demand in year 11. Compare your result in a, b, c. Which model would you choose and why?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 40P: The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels....

See similar textbooks