RE: Monthly Amazon Spend Report

From
<andreas.kozak@thekey.com>
To
"'Angie Markwell'" <angie.markwell@thekey.com>, "'Melissa Reyes'" <melissa.reyes@thekey.com>, "'Chen Xie'" <chen@thekey.com>, <regionaldirectors@thekey.com>, <northeastcanada-regional-operation-directors@thekey.com>
CC
"'Schneider, Bobby'" <bschneider@summitpartners.com>, "'Paul Kahn'" <paul.kahn@thekey.com>
Date
Fri, 11 Aug 2023 17:41:04 -0400
Folder
INBOX
📎 image001.png; Amazon Monthly Report 2306.xlsx
Hi All,

 

After a few weeks of "tweaking" the data I would like to share with you the
total Amazon spend for the month of June (and prior 12 months as a
reference).  I'm finalizing July data and will send out early next week.
Please let me know of any questions, concerns, or suggestions.

 

Thx,

 

Andy  

 

Andreas Kozak

Procurement

(631) 400-4409

 

 <https://homecareassistance.com/> 

 

 <https://thekey.com/> https://thekey.com/

 

From: andreas.kozak@thekey.com <andreas.kozak@thekey.com> 
Sent: Tuesday, June 20, 2023 16:56
To: 'Angie Markwell' <angie.markwell@thekey.com>; 'Melissa Reyes'
<melissa.reyes@thekey.com>; 'Chen Xie' <chen@thekey.com>;
regionaldirectors@thekey.com;
northeastcanada-regional-operation-directors@thekey.com
Cc: 'Schneider, Bobby' <bschneider@summitpartners.com>; 'Paul Kahn'
<paul.kahn@thekey.com>
Subject: NEW: Monthly Amazon Spend Report
Importance: High

 

Hello Team,

 

Similar to the weekly Uber report, I was able to collect the past 13 months
of spend on Amazon (month 13 is for reference) to give you more visibility
on our spending habits.  Since our Amazon business account is fairly new,
and we previously used individual credit cards to pay for Amazon orders, the
data is less reliable the further you go back in time.  I expect that the
number of entries in the "unknown" category will drastically decrease over
next few months.

 

We can use this report to implement spend controls on certain categories,
i.e. groceries, or we can create spending benchmarks on all categories based
on revenue by location, or number of clients, etc.

 

Lastly, this initial file is very large as it contains 13 months' worth of
data.  Subsequent report files will be smaller as I will only send 1 months'
worth of actual transactions and previous months data as a trend reference.
Please expect previous months' reports to be sent out in week 2 of the
following month.

 

Please review and let me know if you would like me to add data points,
create additional summaries, or how I can otherwise improve the report.

 

Thx,

 

Andy

 

Andreas Kozak

Procurement

 

(631) 400-4409

 

 <https://homecareassistance.com/> 

 

https://thekey.com/

 

From: andreas.kozak@thekey.com <mailto:andreas.kozak@thekey.com>
<andreas.kozak@thekey.com <mailto:andreas.kozak@thekey.com> > 
Sent: Tuesday, June 20, 2023 10:41
To: 'Angie Markwell' <angie.markwell@thekey.com
<mailto:angie.markwell@thekey.com> >; 'Melissa Reyes'
<melissa.reyes@thekey.com <mailto:melissa.reyes@thekey.com> >; 'Chen Xie'
<chen@thekey.com <mailto:chen@thekey.com> >; regionaldirectors@thekey.com
<mailto:regionaldirectors@thekey.com> ;
northeastcanada-regional-operation-directors@thekey.com
<mailto:northeastcanada-regional-operation-directors@thekey.com> 
Cc: 'Schneider, Bobby' <bschneider@summitpartners.com
<mailto:bschneider@summitpartners.com> >; 'Paul Kahn' <paul.kahn@thekey.com
<mailto:paul.kahn@thekey.com> >
Subject: Weekly Uber Report

 

 

 

Andreas Kozak

Procurement

 

(631) 400-4409

 

 <https://homecareassistance.com/> 

 

https://thekey.com/