photo credit: Gettyimages.com/Andre_Vogelaere
Organizations of all sizes are involved in business planning. This includes setting ambitious targets on sales and other KPIs to drive growth and efficiencies. This post covers how using data on future events can help your businesses improve month-on-month planning accuracy through leveraging Demand Sensing Analytics & Machine Learning.
Challenges with planning for Events
The retail industry is a leading example of how events can impact sales and supply chain dynamics. For example, sporting goods companies need to plan their sales around World Cup and the Olympics. Such events have a drastic impact on customer behavior, and companies need to find a way to take this into account when taking supply chain decisions.
The diversity of events is also large. There are numerous events both outside and inside the organization that affect your P&L:
- Promotional campaigns
- New product launches and releases
- Public events (e.g. Thanksgiving day)
- Price increases
- Discount periods
- Extreme events, such as Covid-19 outbreak
The diversity of events creates challenges for the planners to come up with accurate financial forecasts that take events into account. It is difficult to estimate how much impact a certain event will on future sales. For that reason, automated systems leveraging Machine Learning emerge to help planners take the relevant events into account.
Specifically, 2 types of events are important to business planning:
- Regular events that have a moving date. These events include Chinese New Year, Black Friday, and Easter
- Irregular events, such as discount campaigns, new product launches, or economic distortions.
In both cases, having a system that is able to automatically take into account the relevant future events allows planners to increase the accuracy of the future sales targets.
Machine learning approach
Recently, Agnicio completed a project for a large retail client that involved identifying events’ impact on sales planning. The goal was to find out how can we successfully leverage events data for our overall Demand Sensing solution.
This exploration resulted in the development of a new “events driver” which became the latest addition to Agnicio’s framework of demand sensing algorithms. In the remainder of the blog post, we cover how we approached this task.
Our data science team followed a 3-step approach to improve the forecasting accuracy of our Demand Sensing Solution that can forecast sales 18-24 months ahead on the country, store location, product category, and product line levels.
Steps involved:
- identifying relevant events via business workshops
- estimating event windows on daily sales data
- testing optimal event combinations in our Demand Sensing solution
Step 1. Business Workshops
The first step was to come up with a list of public and company-specific events that could be relevant to the organization. We overlayed event dates with daily sales data to match against the observed peaks or drops in sales.
This allowed us to have a conversation with the business planners and identify which of the fluctuations in sales are due to the events. The key metric we optimized for is the percentage of the peaks/drops in sales that we can match to our events list on a given year. The outcome of the workshop was a list of events per country that can be leveraged by the data science models.
Step 2. Choosing event windows
The next step after that was to identify for how long a certain event has an impact on sales. When doing monthly planning, it is not enough to say that an event happens on a certain month. If customers start shopping 3 weeks before a giveaway campaign that falls on March 1st, should the sales be allocated to March or April? In that case, using event weights allowed us to split the event impact between multiple months around the event.
To find the event windows we used a Neural Prophet model released in 2020 by the Facebook research team. While we do overall planning on a monthly level, daily data allows us to see on a day-by-day basis when a certain event starts and stops having an impact on sales.
Here is a simple example from Facebook how Super Bowl has a stronger effect on the day before compared to the day after the event:
With this approach, it becomes clear when an event impact starts and ends.
Step 3. Testing month-on-month accuracy
To arrive at the final result we integrated events in the Agnicio Demand Sensing framework. Then we used multiple event combinations to test accuracy at different forecast periods up to 18 months forward.
In reality, we saw that reducing the number of events to only key relevant events gave us the best accuracy improvements. The model showed up to a 5% improvement in accuracy, which is very good given the overall model accuracy ranges between 80-95%.
Covid-19 impact
Adding events to our Demand Sensing solution also allowed us to isolate the negative impact of certain extreme events such as Covid-19. As you know, Machine Learning models learn how to predict the future by looking at the past. In the case of the 2021-2022 forecast, using 2020 as a learning period makes the model biased due to covid lockdown measures.
To correct this issue we added a ‘covid’ event into the model, which allowed the model to learn that what happened in the past is abnormal.
Interactivity
In case you’re wondering if the planning team can add their own events to the events driver, the short answer is yes. We’ve been able to successfully demo that approach in the new SupplyFocus tool in collaboration with our partner Cubewise.
This approach has several advantages. First, planners can mark certain dates in the past as events, so the driver learns their impact. Then it only needs future event dates to extrapolate the effect. In case an event has never happened before, a manual indication of expected impact can be provided. After the event has passed, the driver will look at actuals and learn its true effect. Then the planner can decide to apply the event again or mark it as a one-off event.
Using events interactively requires some data management on the client side, but brings additional benefits in terms of improved planning accuracy and agility.
Learn more about Demand Sensing Analytics
Is your business impacted by events? Do you have a large planners team involved in business planning which creates a large overhead and costs? Would you like to use the latest AI technology to improve business planning?
Book a Demand Sensing demo today by reaching out to info@agnicio.com or by connecting on LinkedIn to the CEO of Agnicio: https://www.linkedin.com/in/hichamelarfaoui/
Let machine learning help your company re-imagine business planning to drive growth and achieve operational excellence
fantastic post well done thank you
viagra pill
How to use events' data for effective business planning – Agnicio
college application essay writers
How to use events' data for effective business planning – Agnicio
essay writing services usa
How to use events' data for effective business planning – Agnicio
good essay writing company
How to use events' data for effective business planning – Agnicio
customer service essays
How to use events' data for effective business planning – Agnicio
help me to write an essay
How to use events' data for effective business planning – Agnicio
best essay writer company
How to use events' data for effective business planning – Agnicio
write my essay canada
How to use events' data for effective business planning – Agnicio
best online essay writing service
How to use events' data for effective business planning – Agnicio
good essay writing service
How to use events' data for effective business planning – Agnicio
write my essay for money
How to use events' data for effective business planning – Agnicio
help writing an essay
How to use events' data for effective business planning – Agnicio
premium essay writing service
How to use events' data for effective business planning – Agnicio
custom essays writing service
How to use events' data for effective business planning – Agnicio
custom essay meister review
How to use events' data for effective business planning – Agnicio
write my essay cheap
How to use events' data for effective business planning – Agnicio
Top Avana
How to use events' data for effective business planning – Agnicio
rx america pharmacy help desk
How to use events' data for effective business planning – Agnicio
tramadol cod online pharmacy
How to use events' data for effective business planning – Agnicio
avandia pharmacy
How to use events' data for effective business planning – Agnicio
national pharmacies
national pharmacies
buy viagra toronto
buy viagra toronto
cialis dosage 40 mg
cialis dosage 40 mg
tadalafil and sildenafil taken together
tadalafil and sildenafil taken together
cialis black pills
cialis black pills
teva generic cialis
teva generic cialis
female viagra sale in singapore
female viagra sale in singapore
viagra price pharmacy
viagra price pharmacy
buy viagra in india online
buy viagra in india online
daily viagra
daily viagra
paypal cialis
paypal cialis
tadalafil in usa
tadalafil in usa
hydroxyzine liquid pharmacy
hydroxyzine liquid pharmacy
overseas pharmacy cialis
overseas pharmacy cialis
cheap viagra pills canada
cheap viagra pills canada
printable cialis coupon
printable cialis coupon
viagra 100mg tablet price in india
viagra 100mg tablet price in india
cialis canada no prescription
cialis canada no prescription
cheapest order pharmacy viagra
cheapest order pharmacy viagra
tadalafil liquid fda approval date
tadalafil liquid fda approval date
how to purchase viagra online in india
how to purchase viagra online in india
pfizer viagra 100mg price
pfizer viagra 100mg price
can i buy viagra in mexico
can i buy viagra in mexico
sildenafil coupon 50 mg
sildenafil coupon 50 mg
viagra pills
viagra pills
generic viagra uk pharmacy
generic viagra uk pharmacy
overnight cialis delivery usa
overnight cialis delivery usa
how to enhance cialis effect
how to enhance cialis effect
canadian pharmacy cialis no prescription
canadian pharmacy cialis no prescription
cialis prices in mexico
cialis prices in mexico
flagyl+mjölkprodukter
flagyl+mjölkprodukter
gabapentin smertebehandling
gabapentin smertebehandling
bactrim uveite
bactrim uveite
nolvadex finasteride
nolvadex finasteride
maximum dose of pregabalin for neuropathic pain
maximum dose of pregabalin for neuropathic pain
valacyclovir xanax
valacyclovir xanax
farmakodinamika furosemide
farmakodinamika furosemide
metformina orlistat
metformina orlistat
lisinopril viagra
lisinopril viagra
rybelsus commercial
rybelsus commercial
rybelsus name
rybelsus name
what is cymbalta best used for
what is cymbalta best used for
why does zoloft cause weight gain
why does zoloft cause weight gain
flagyl empirically
flagyl empirically
zoloft and lexapro
zoloft and lexapro
keflex side effects tiredness
keflex side effects tiredness
purchasing viagra in mexico
purchasing viagra in mexico
fluoxetine blue and white capsule
fluoxetine blue and white capsule
is keflex same as cephalexin
is keflex same as cephalexin
escitalopram pill identification
escitalopram pill identification
gabapentin conjunctivitis
gabapentin conjunctivitis
difference between duloxetine and fluoxetine
difference between duloxetine and fluoxetine
cephalexin 250 mg/5ml susp dosage for child
cephalexin 250 mg/5ml susp dosage for child
how to calculate bactrim dose
how to calculate bactrim dose
ciprofloxacin ear infection
ciprofloxacin ear infection
uti bactrim
uti bactrim
amoxicillin-clav
amoxicillin-clav
contrave 8-90 mg tablet extended release
contrave 8-90 mg tablet extended release
ddavp+pharmacokinetics
ddavp+pharmacokinetics
headache after stopping flomax
headache after stopping flomax
gabapentin and flexeril
gabapentin and flexeril
depakote 250 milligrams
depakote 250 milligrams
medication cozaar
medication cozaar
diclofenac sodium 75 mg tablet
diclofenac sodium 75 mg tablet
diltiazem drug class
diltiazem drug class
citalopram 10mg high
citalopram 10mg high
augmentin 500mg
augmentin 500mg
ezetimibe lcmsms
ezetimibe lcmsms
effexor and adderall
effexor and adderall
aripiprazole injection
aripiprazole injection
a nurse will instruct a patient taking allopurinol to take each dose
a nurse will instruct a patient taking allopurinol to take each dose
molar mass of aspirin
molar mass of aspirin
amitriptyline 25mg for pain
amitriptyline 25mg for pain
ashwagandha for hair
ashwagandha for hair
celecoxib what is it used for
celecoxib what is it used for
celexa dosage
celexa dosage
side effects of bupropion
side effects of bupropion
drinking on augmentin
drinking on augmentin
is celebrex safe for long term use
is celebrex safe for long term use
baclofen erowid
baclofen erowid
buspar wiki
buspar wiki
protonix side effects long term use
protonix side effects long term use
actos epistemológicos
actos epistemológicos
rexulti vs abilify
rexulti vs abilify
acarbose powder
acarbose powder
semaglutide 4 week results
semaglutide 4 week results
remeron mirtazapine
remeron mirtazapine
repaglinide diabetes
repaglinide diabetes
can you take robaxin with tylenol
can you take robaxin with tylenol
ivermectin 3mg dose
ivermectin 3mg dose
synthroid licorice
synthroid licorice
sitagliptin xelevia price philippines
sitagliptin xelevia price philippines
lowest dose of spironolactone
lowest dose of spironolactone
tizanidine 4mg capsules
tizanidine 4mg capsules
tamsulosin hcl image
tamsulosin hcl image
venlafaxine hcl er 75 mg
venlafaxine hcl er 75 mg
voltaren 1% gel
voltaren 1% gel