08. (20 points) PART ONE OF TWO PARTS Student Tech is a computer retailer that sells computers, printers and software in

[answerhappygod]

08 20 Points Part One Of Two Parts Student Tech Is A Computer Retailer That Sells Computers Printers And Software In 1 (60.24 KiB) Viewed 39 times

08. (20 points) PART ONE OF TWO PARTS Student Tech is a computer retailer that sells computers, printers and software in a convenient location near Algoma University @ Brampton. The sales manager of Student Tech had historical data on sales of computers and printers at this location for the past ten (10) years, as follows: 478 Year Computers Sold Printers Sold 1045 326 2 1610 $10 860 296 4 1211 $ 975 305 6 1117 506 7 1066 612 8 1310 360 9 1517 590 10 1246 676 a) In Exce, develop a linear trend line demand forecast for printers in year 11. b) Develop a linear regression model relating printer sales demand to computer sales demand to forecast printer sales demand in year 11. if 1300 computers are sold. c) Compare your demand forecasts developed in (a) and (b) above and indicate which one appears to be accurate d) Develop an exponential smoothing model with alpha = 30 for the data above to forecast printer demand in year 11 and compare its accuracy to the lineal trend line forecast developed above in part (a).