Insights on Spend Analysis and Cost Optimization
Y
o
u
r
l
o
g
o
h
e
r
e
A
A
I
-
C
h
a
l
l
e
n
g
e
3
9
7
P
r
e
s
e
n
t
e
d
b
y
G
a
r
y
G
r
u
c
c
i
o
1
U
n
d
e
r
s
t
a
n
d
i
n
g
t
h
e
O
c
t
o
b
e
r
S
p
e
n
d
I
n
c
r
e
a
s
e
•
Spend increased by $263,929 in October
2022
•
Number of Contract ID decreased by 11
•
For every 1 increase in Contract ID, Spend
increased by $117,517
•
Recommendation: Investigate causes behind
this change and explore cost-saving
opportunities
Source:
Alteryx Auto Insights
2
A
n
a
l
y
z
i
n
g
t
h
e
N
o
v
e
m
b
e
r
S
p
e
n
d
R
e
d
u
c
t
i
o
n
•
Spend decreased by $1.66m in November
2022
•
Boral - Construction Materials contributed the
most to the spend decrease
•
Carpet Warehouse - Finishes and Bondor -
Construction Materials saw a large increase
•
Recommendation: Review contracts with
Boral and explore potential savings from
other suppliers
Source:
Alteryx Auto Insights
3
I
m
p
a
c
t
o
f
O
r
d
e
r
e
r
N
a
m
e
o
n
N
o
v
e
m
b
e
r
S
p
e
n
d
•
Dominic Russell contributed the most to the
spend decrease
•
Andrea Forth saw a large increase in
spending
•
Fiona Goodman saw a significant decrease
•
Recommendation: Look into the order
patterns of Dominic Russell and Fiona
Goodman for potential savings
Source:
Alteryx Auto Insights
4
R
o
l
e
o
f
C
o
n
t
r
a
c
t
M
a
n
a
g
e
r
i
n
N
o
v
e
m
b
e
r
S
p
e
n
d
•
Kimberly Stevens saw a significant decline in
spend
•
Maxwell Dillon saw a large increase in
spending
•
Most Contract Managers saw a decrease in
spend
•
Recommendation: Evaluate the performance
of Kimberly Stevens and Maxwell Dillon for
potential cost optimization
Source:
Alteryx Auto Insights
5
S
p
e
n
d
A
n
a
l
y
s
i
s
b
y
S
i
t
e
L
o
c
a
t
i
o
n
i
n
N
o
v
e
m
b
e
r
•
Chicago, New York, and Cleveland saw the
most significant decrease in spend
•
Austin saw a large increase in spending
•
6 out of 14 site locations saw a decrease in
spend
•
Recommendation: Investigate spend patterns
at each site location for potential budget
adjustments
Source:
Alteryx Auto Insights
6
I
m
p
a
c
t
o
f
E
n
t
i
t
y
o
n
N
o
v
e
m
b
e
r
S
p
e
n
d
•
Foundation Engineering & Construction saw
a significant decrease in spend
•
Quality Construction saw a large increase in
spending
•
Most entities saw a decrease in spend
•
Recommendation: Review contracts with
Foundation Engineering & Construction and
Quality Construction for cost-saving
opportunities
Source:
Alteryx Auto Insights
7
N
o
v
e
m
b
e
r
S
p
e
n
d
A
n
a
l
y
s
i
s
b
y
P
r
o
d
u
c
t
S
u
b
D
e
s
c
r
i
p
t
i
o
n
•
Concrete products contributed the most to
the spend decrease
•
Carpeting saw a large increase in spending
•
13 out of 21 Product Sub Descriptions saw a
decrease in spend
•
Recommendation: Analyze the purchase of
concrete products and carpeting for cost-
saving opportunities
Source:
Alteryx Auto Insights
8
Understanding and analyzing changes in spend patterns including increases and decreases, identifying key contributors, and providing recommendations for cost-saving opportunities. Recommendations include investigating causes behind spend changes, reviewing contracts with suppliers, evaluating performance of contract managers, and investigating spend patterns at different site locations for potential budget adjustments.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Your logo here AAI - Challenge397 Presented by Gary Gruccio 1
Understanding the October Spend Increase Spend increased by $263,929 in October 2022 Number of Contract ID decreased by 11 For every 1 increase in Contract ID, Spend increased by $117,517 Recommendation: Investigate causes behind this change and explore cost-saving opportunities Source: Alteryx Auto Insights 2
Analyzing the November Spend Reduction Spend decreased by $1.66m in November 2022 Boral - Construction Materials contributed the most to the spend decrease Carpet Warehouse - Finishes and Bondor - Construction Materials saw a large increase Recommendation: Review contracts with Boral and explore potential savings from other suppliers Source: Alteryx Auto Insights 3
Impact of Orderer Name on November Spend Dominic Russell contributed the most to the spend decrease Andrea Forth saw a large increase in spending Fiona Goodman saw a significant decrease Recommendation: Look into the order patterns of Dominic Russell and Fiona Goodman for potential savings Source: Alteryx Auto Insights 4
Role of Contract Manager in November Spend Kimberly Stevens saw a significant decline in spend Maxwell Dillon saw a large increase in spending Most Contract Managers saw a decrease in spend Recommendation: Evaluate the performance of Kimberly Stevens and Maxwell Dillon for potential cost optimization Source: Alteryx Auto Insights 5
Spend Analysis by Site Location in November Chicago, New York, and Cleveland saw the most significant decrease in spend Austin saw a large increase in spending 6 out of 14 site locations saw a decrease in spend Recommendation: Investigate spend patterns at each site location for potential budget adjustments Source: Alteryx Auto Insights 6
Impact of Entity on November Spend Foundation Engineering & Construction saw a significant decrease in spend Quality Construction saw a large increase in spending Most entities saw a decrease in spend Recommendation: Review contracts with Foundation Engineering & Construction and Quality Construction for cost-saving opportunities Source: Alteryx Auto Insights 7
November Spend Analysis by Product Sub Description Concrete products contributed the most to the spend decrease Carpeting saw a large increase in spending 13 out of 21 Product Sub Descriptions saw a decrease in spend Recommendation: Analyze the purchase of concrete products and carpeting for cost- saving opportunities Source: Alteryx Auto Insights 8
