salesplansuccess

This package helps estimate the probability of achieving the annual sales plan for a specific product based on historical monthly sales data with the help of ARIMA modeling and Monte Carlo simulation


Keywords
sales, forecast, arima, simulation, pharma, medications, pharmacy, pharmaceutical, ics, offtake
License
MIT
Install
pip install salesplansuccess==0.0.9

Documentation

Python package salesplansuccess

This Python package helps estimate the probability of achieving the annual sales plan in the middle of the year for the current year or at the end of the year for the next year for a specific product based on its historical monthly sales data with the help of ARIMA modeling and Monte Carlo simulation.

Installation

This Python package is uploaded to the PyPI repository and therefore can be installed with pip install salesplansuccess command line instruction and updated (this is critical at this early stage of development) with pip install salesplansuccess --upgrade.

Historical data format to feed

The only class SalesPlanSuccess() of this package accepts for its data parameter only pandas.DataFrame with three columns with the names Year, Month, and Sales. The columns Year and Month must be of the dtype numpy.int64 and the column Sales must be either of the dtype numpy.int64 or numpy.float64. All monthly sales data must be consecutive and positive (must not be zeros or omitted).

Assumptions

The model behind the forecast assumes that the monthly sales changes' residuals are lognormally distributed and the logarithmic monthly sales time series is subject to an ARIMA(2,1,0) process with one external regressor, which is the end of a quarter (March, June, September or December). This lognormal assumption cannot accomodate the historical sales data with 'no sales' months. So, please, do not use this package for historical sales time series with zeros.
This model also apparently assumes that the sales dynamics was subject to the same non-changing process in the past and will continue to follow it in the future (no new promo interventions are assumed).

How to use it

Very easy. The package has only one class SalesPlanSuccess(), which is initiated with the historical sales pandas DataFrame, the current annual plan number, and optionally with the product name (for the plot). This class has only 4 'public' methods: .fit(), .summary(), .simulate(), .plot(), which are expected to be called in this order.
The illustration of how to use this package can be found in the attached file salesplansuccess_illustration.ipybn .
Briefly this can be expressed like this:

import pandas as pd
from salesplansuccess.api import SalesPlanSuccess
myHistoricalData = pd.read_excel('myfile.xlsx')
myAnnualPlan = 1000
sps = SalesPlanSuccess(data=myHistoricalData, plan=myAnnualPlan)
sps.fit()
sps.simulate()
sps.plot()