(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?

Answered: Develop a linear regression model…

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...

Related questions

Question

(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 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?