Question: Q 1 . ( 1 0 points ) PrinterWorks is a large computer discount store that sells computers and ancillary equipment and PC software in

Q1.(10 points) PrinterWorks is a large computer discount store that sells computers and ancillary equipment and PC software in the city where McMaster University is located. PrinterWorks has collected historical data on computer sales and printer sales for the past 10 years, as follows:
Year Personal Computers Sold Printers Sold
11,045326
21,610510
3860296
41,211478
5975305
61,117506
71,066612
81,310560
91,517590
101,246676
Required:
a. Develop a linear trend line forecast to forecast printer demand in year 11.
b. Develop a linear regression model relating printer sales to computer sales to forecast printer demand in year 11, if 1,300 computers are sold.
c. Compare the forecasts developed in (a) and (b) and indicate which one appears to be more accurate.
d. Develop an exponential smoothing model with \alpha =.30 for the data to forecast printer demand in year 11 and compare its accuracy to the linear trend line forecast developed in (a) above.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!