Showing by using excel format, please solve the following: 1. The quarterly sales data (number of copies sold) for a college textbook over thepast 3 years are as follows in the Table below:QUARTERLY SALESYear 1QuarterYear 2Year 31618189.9.113262929252326a) Compute seasonal indexes for the 4 quarters.b) When does the textbook publisher experience the largest change in sales?Does this result appear to be reasonable? Explain.c) Using the information on seasonality, compare a 4-quarter moving average totrend projection model and an exponential smoothing with a smoothingconstant of 0.2.d) Use the selected model to generate a forecast for sales for the first quarter ofYear 4.

Name: Showing by using excel format, please solve the following: 1. The qua
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Showing by using excel format, please solve the following: 1. The quarterly sales data (number of copies sold) for a college textbook over thepast 3 years are as follows in the Table below:QUARTERLY SALESYear 1QuarterYear 2Year 31618189.9.1132629292