Sunday, 5 March 2023

Python code to predict inventory stock end date

 To predict the inventory stock end date, you need to have some data about inventory levels over time. Here's an example Python code that uses historical sales data to predict the inventory stock end date:


```python

import pandas as pd

import numpy as np

from datetime import timedelta, datetime


# Load sales data

sales_data = pd.read_csv('sales_data.csv')


# Convert date column to datetime format

sales_data['date'] = pd.to_datetime(sales_data['date'])


# Calculate daily sales

daily_sales = sales_data.groupby('date').sum()['sales']


# Calculate rolling average of daily sales over the last 7 days

rolling_avg = daily_sales.rolling(window=7).mean()


# Calculate average daily sales over the last 7 days

average_daily_sales = rolling_avg.iloc[-1]


# Calculate current inventory level

current_inventory = 1000


# Calculate number of days until inventory runs out

days_until_stockout = np.floor(current_inventory / average_daily_sales)


# Calculate predicted stock end date

stock_end_date = datetime.today() + timedelta(days=days_until_stockout)


print('Predicted inventory stock end date: ', stock_end_date)

```


This code loads in sales data and calculates the daily sales, rolling average of daily sales over the last 7 days, and the average daily sales over the last 7 days. It then calculates the number of days until the inventory runs out based on the current inventory level and average daily sales, and finally predicts the inventory stock end date by adding the number of days until stockout to today's date.

No comments:

Post a Comment