1 of 9

1C Company�Sales Forecasting

KHWAJA JALAL SEDIQI

2 of 9

Introduction:

​

  • This data is extracted from Kaggle website for 1C Company. 1C specializes in development, distribution, and publishing different types of software in Russia.
  • 1C is widely acknowledged as a game developer and has several internal studios.
  • The data contains 1C sales for January 2013 to October 2015 for 60 shops.

Objective:

​

  • Explore the data and explain the overall trend in it.
  • Forecast next few months sales amount based of the available historical data.

​

​

​

​

3 of 9

  • Almost all of the top 10 items are game related. However, Grand Theft Auto V has the highest number of sales.
  • 77 Percent of all the items are below 1,000 Rubles (equivalent to 14 USD).
  • The average item price is 399 Rubles(equivalent to 5.6 USD).

4 of 9

The total amount of sales increased from 2013 to 2014. However, there is no complete data for 2015’s sales. The last month for 2015 sales is October. ���

The Variety of items or the number of distinct items decreased from 2013 to 2015. 3,722 Items were collected from shelves. However, the total amount of sales did not decrease over time.

5 of 9

  • The last four months has the highest amount of sales. December is significantly high because of new year.
  • Weekend including Friday has the highest amount of sales compared to weekdays.

6 of 9

  • The last six months of data are May – October, and the sales are at the lowest during this period.

​

​

  • After running a time series forecasting model on monthly sales data, the forecasting results from the model was 70% accurate.

​

Sales Forecasting

7 of 9

  • The forecasted monthly sales data mostly follow the same pattern as historical data.

8 of 9

Recommendations

  • Replacing the discarded items with new items.
  • The forecasted sales for next two months, i.e. November and December 2015 are very promising. Adding some additional initiatives like holidays sales will increase the total sales even more.

​

Next Step

  • Optimizing the time series model to include additional factors that could impact the sales.

9 of 9

(646) 462-0092

khwajajalal@gmail.com

www.linkedin.com/in/khwajajalal

​

Thank You

​

Any Question