Skip to content
Solved Assignments

Forecasting Monthly Sales for Prescott College Bookstore: Analyzing Trends and Predicting Future Performance

Forecasting methods applied to bookstore sales data for predictive insights.

Preview 3 of 8 pages

See the first 3 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Forecasting Monthly Sales for Prescott College Bookstore: Analyzing Trends and Predicting Future Performance Using the provided historical sales data for the Prescott College Bookstore, conduct a comprehensive analysis of its sales trends and forecasting methods. Your response should include: 1. A summary of the descriptive statistical analysis of the bookstore’s monthly sales data. 2. An interpretation of graphical representations, including trends and seasonal patterns observed in the sales data. 3. A comparison of the different forecasting techniques used (Moving Average, Simple Exponential Smoothing, Holt’s Double Exponential Smoothing, and Winter’s Exponential Smoothing), along with an evaluation of their accuracy based on error metrics. 4. A discussion on the implications of the forecasted sales for the next 12 months and how this impacts the decision on whether to outsource the bookstore operations. 5. Your final recommendation on whether the college should continue operating the bookstore or contract it out. Support your response with appropriate calculations, charts, and interpretations. Your assignment should be 1,500 – 2,000 words in length.

  2. Page 2
  3. Page 3
    Read page 3 as text

    Introduction The 25 year old college has operated its own bookstore for its entire history, known as the Prescott College Bookstore, but now finds that it may have to contract out the operation of the bookstore. Dr. MaryAnn Lane, vice president, knows that the college president want to “ off - load the bookstore and use the proceeds to finance a new bell tower on the campus .” However, the president of college knows that this particular company is known for “ increasing the cost of textbooks and e - books by over 20% ” and Dr. Lane is worried that the students attending PC will not be able to afford those costly textbooks. For this purpose, Dr. Lane has gathered the last several years of monthly sales (000s of dollars) at the college bookstore for forecast the next 12 months of sales. To analyse this, I have been asked to study the prior 4 years of monthly sales at the PC book store. Data Analysis On the basis of the prior 4 years of monthly sales data of Prescott Bookstore, we will do the graphical analysis as well as the descriptive analysis. The analysis aims at forecasting the monthly sales (thousands of dollars), by using various forecasting techniques and finally see which forecasting method is the most appropriate based on the error components of each of them. We will first start with the basic statistical descriptive of the historical data using the Sales in Single Column and see what does this information tells about the sales at the bookstore. Table 1: One variable Summary Statistics One Variable Summary Monthly Sales ($000s) Mean 182.08 Variance 1201.01 Std. Dev. 34.66 Skewness 0.07 Kurtosis - 0.30 Median 188 Mode 196

5 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Business Management study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.