Use the Excel template provided by your instructor. Cell phone sales for a firm over the last 10 weeks are shown below. Plot the data and visually check to see if a linear trend line is appropriate. Then using the trend line, predict sales for week 11. Use the Excel template provided by your instructor. The manager of a call center recorded the volume of calls recelved between 9 and 10am for 21 days and wants to obtain a seasonal Index for each day for that hour. For practical purposes, you can round the relatives (Indeces) to 2 decimal points. What is the seasonal standard index value for Monday? Day Volume Tues 67 Wed 75 Thurs 82 Frl 98 Sat 90 SunMon3655 MonTues5560 Wed 73 Thurs 85 Fri 99 SatSun8640 SunMon4052 MonTues5264 TuesWed6476 Thurs 87 Frl 96 Sat 88 SunMon4450