Skip to content

Displays demand day weight throughout a week with a bar chart.

Notifications You must be signed in to change notification settings

fedinb/Demand_Day_Weight

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

30 Commits
 
 
 
 
 
 

Repository files navigation

Demand Day Weight

This code is meant to display the ratio of demand within a week. The point is that some products may have bigger demand on a specific weekday: for example, on Tuesdays. This information can be taken into account for replenishment planning. It will help specialists from supply planning or customer service departments to prepare for days with either low or high demand.

First part of code is taken from Service Level and Coverage KPIs script. Dataframe created with this script helps to build a bar chart for a specific product throughout a set number of weeks.

Bar chart screenshot

This bar chart can be helpful in at least 2 cases.

With VMI-driven replenishment this chart can help supply planners or customer service specialists to plan deliveries for retailers. Based on the chart they can decide that it's better not to deliver product above on Thursday (day with lowest sales). However, they need to prepare for Saturday - day with biggest sales. That's why, delivery by the end of Friday would be the best option.

If retailer deals with replenishment tasks on their own, they can also use this bar chart to track sales throughout the week and place orders with a more suitable delivery date.

In both cases such a data-driven replenishment can help responsible specialists to improve stock coverage.

About

Displays demand day weight throughout a week with a bar chart.

Topics

Resources

Stars

Watchers

Forks