sales_performance_and_return_analysis

𝗦𝗔𝗟𝗘𝗦 𝗣𝗘𝗥𝗙𝗢𝗥𝗠𝗔𝗡𝗖𝗘 𝗔𝗡𝗗 𝗥𝗘𝗧𝗨𝗥𝗡𝗦 𝗔𝗡𝗔𝗟𝗬𝗦𝗜𝗦

hanson-lu-sq5P00L7lXc-unsplash

𝗜𝗡𝗧𝗥𝗢𝗗𝗨𝗖𝗧𝗜𝗢𝗡

The objective of this project is to conduct a thorough evaluation of Eastnat Limited’s sales and profitability data, covering the years 2016 to 2021, to uncover key business insights. This analysis goes beyond simple top-line revenue to 𝗶𝗻𝘃𝗲𝘀𝘁𝗶𝗴𝗮𝘁𝗲 𝘁𝗵𝗲 𝘂𝗻𝗱𝗲𝗿𝗹𝘆𝗶𝗻𝗴 𝗳𝗮𝗰𝘁𝗼𝗿𝘀 𝘁𝗵𝗮𝘁 𝗲𝗿𝗼𝗱𝗲 𝗺𝗮𝗿𝗴𝗶𝗻𝘀, with a specific focus on geographic profit pockets and 𝘁𝗵𝗲 𝗶𝗺𝗽𝗮𝗰𝘁 𝗼𝗳 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗰𝗼𝘀𝘁𝘀 𝗼𝗻 𝗿𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲. By integrating multi-year sales data with return and representative records, 𝘁𝗵𝗲 𝗽𝗿𝗼𝗷𝗲𝗰𝘁 𝗮𝗶𝗺𝘀 𝘁𝗼 𝗲𝘀𝘁𝗮𝗯𝗹𝗶𝘀𝗵 𝗮 “𝘀𝗼𝘂𝗿𝗰𝗲 𝗼𝗳 𝘁𝗿𝘂𝘁𝗵” 𝗳𝗼𝗿 𝗶𝗱𝗲𝗻𝘁𝗶𝗳𝘆𝗶𝗻𝗴 𝗼𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗶𝗻𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝗰𝗶𝗲𝘀 𝗮𝗻𝗱 𝘀𝗰𝗮𝗹𝗶𝗻𝗴 𝘁𝗵𝗲 𝗯𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝘁𝗵𝗿𝗼𝘂𝗴𝗵 𝗱𝗮𝘁𝗮-𝗱𝗿𝗶𝘃𝗲𝗻 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻𝘀.

𝗠𝗔𝗡𝗔𝗚𝗘𝗠𝗘𝗡𝗧 𝗧𝗔𝗦𝗞

𝗧𝗮𝘀𝗸 𝟭. 𝗥𝗲𝘁𝘂𝗿𝗻 𝗜𝗺𝗽𝗮𝗰𝘁

✔️ 𝗧𝗵𝗲 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻: Which Sub-Categories have a return rate higher than 10%, and what is the total “Burned Profit” (Profit from orders that were eventually returned) for these items?

𝗧𝗮𝘀𝗸 𝟮. 𝗗𝗶𝘀𝗰𝗼𝘂𝗻𝘁 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗠𝗮𝗿𝗴𝗶𝗻 𝗛𝗲𝗮𝗹𝘁𝗵

✔️ 𝗧𝗵𝗲 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻: At what specific discount threshold (0%, 20%, 50%) does the Profit Margin consistently turn negative? We need to find the “Danger Zone” where sales are high but profits are nonexistent.

𝗧𝗮𝘀𝗸 𝟯. 𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗕𝗼𝘁𝘁𝗹𝗲𝗻𝗲𝗰𝗸 𝗜𝗱𝗲𝗻𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻

✔️ 𝗧𝗵𝗲 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻: Which Regional Manager has the highest Average Shipping Duration, and is there a correlation between long shipping times and high return rates?

𝗧𝗮𝘀𝗸 𝟰. 𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗣𝗿𝗼𝗳𝗶𝗹𝗶𝗻𝗴

✔️ 𝗧𝗵𝗲 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻: Who are the top 5% of customers in terms of Lifetime Value (LTV) who have a Return Rate of 0%?

𝗧𝗮𝘀𝗸 𝟱. 𝗜𝗻𝘃𝗲𝗻𝘁𝗼𝗿𝘆 𝗥𝗶𝘀𝗸 𝗮𝗻𝗱 𝗢𝘃𝗲𝗿𝘀𝘁𝗼𝗰𝗸 𝗠𝗶𝘁𝗶𝗴𝗮𝘁𝗶𝗼𝗻

✔️ 𝗧𝗵𝗲 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻: Which products have high Quantity sold but fall into the bottom 10% of Total Profit? This identifies high-effort, low-reward inventory.

𝗞𝗘𝗬 𝗣𝗘𝗥𝗙𝗢𝗥𝗠𝗔𝗡𝗖𝗘 𝗠𝗘𝗧𝗥𝗜𝗖𝗦

1️⃣ 𝗚𝗹𝗼𝗯𝗮𝗹 𝗦𝗮𝗹𝗲𝘀

✅ 𝗧𝗵𝗲 “𝗛𝗶𝗴𝗵 𝗩𝗼𝗹𝘂𝗺𝗲, 𝗟𝗼𝘄 𝗩𝗮𝗹𝘂𝗲” 𝗧𝗿𝗮𝗽

While global sales are robust ($2.7M against a $3.12M target), the growth is being undermined by “𝗼𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝘃𝗮𝗺𝗽𝗶𝗿𝗲𝘀”. These are 𝗵𝗶𝗴𝗵-𝘃𝗼𝗹𝘂𝗺𝗲 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝘀 (primarily in the 𝗠𝗮𝗰𝗵𝗶𝗻𝗲𝘀 and 𝗧𝗮𝗯𝗹𝗲𝘀 𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀) and are 𝘀𝗼𝗹𝗱 𝗯𝘆 𝘀𝗽𝗲𝗰𝗶𝗳𝗶𝗰 𝘀𝗮𝗹𝗲𝘀 𝗿𝗲𝗽𝗿𝗲𝘀𝗲𝗻𝘁𝗮𝘁𝗶𝘃𝗲𝘀 who 𝗴𝗲𝗻𝗲𝗿𝗮𝘁𝗲 𝘀𝗶𝗴𝗻𝗶𝗳𝗶𝗰𝗮𝗻𝘁 𝗿𝗲𝘃𝗲𝗻𝘂𝗲 but fall into 𝘁𝗵𝗲 𝗯𝗼𝘁𝘁𝗼𝗺 𝟭𝟬% 𝗶𝗻 𝗽𝗿𝗼𝗳𝗶𝘁. This is often driven by 𝗱𝗲𝗲𝗽 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁𝘀 (>𝟯𝟬%) that attract “𝗦𝗲𝗿𝗶𝗮𝗹 𝗥𝗲𝘁𝘂𝗿𝗻𝗲𝗿𝘀”.

✅ 𝗙𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗜𝗺𝗽𝗮𝗰𝘁: 𝗣𝗿𝗼𝗳𝗶𝘁 𝗕𝗹𝗲𝗲𝗱

𝗥𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗖𝗼𝗻𝗰𝗲𝗻𝘁𝗿𝗮𝘁𝗶𝗼𝗻: 100% of the identified “Serial Returners” (𝘁𝗵𝗲 𝟭% 𝗼𝗳 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿𝘀 𝗿𝗲𝘀𝗽𝗼𝗻𝘀𝗶𝗯𝗹𝗲 𝗳𝗼𝗿 𝘁𝗵𝗲 𝗵𝗶𝗴𝗵𝗲𝘀𝘁 𝗿𝗲𝘁𝘂𝗿𝗻 𝘃𝗼𝗹𝘂𝗺𝗲) are in the 𝗪𝗲𝘀𝘁 𝗥𝗲𝗴𝗶𝗼𝗻.
𝗥𝗲𝗰𝗼𝘃𝗲𝗿𝗮𝗯𝗹𝗲 𝗣𝗿𝗼𝗳𝗶𝘁: By neutralizing the 𝘁𝗼𝗽 𝟭𝟬 “𝗩𝗮𝗺𝗽𝗶𝗿𝗲” 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝘀 in the West Region alone, there is a projected 𝟭𝟱–𝟮𝟬% 𝗿𝗲𝗰𝗼𝘃𝗲𝗿𝘆 𝗶𝗻 𝗿𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗻𝗲𝘁 𝗽𝗿𝗼𝗳𝗶𝘁.
𝗠𝗮𝗿𝗴𝗶𝗻 𝗘𝗿𝗼𝘀𝗶𝗼𝗻: High-volume sales with thin margins (e.g., Storage) are at 𝗿𝗶𝘀𝗸 𝗼𝗳 𝗳𝗹𝗶𝗽𝗽𝗶𝗻𝗴 𝗶𝗻𝘁𝗼 𝗮 𝗻𝗲𝘁 𝗹𝗼𝘀𝘀 with a single return incident.

✅ 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁

𝗜𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁 𝗗𝗶𝘀𝗰𝗼𝘂𝗻𝘁 𝗚𝘂𝗮𝗿𝗱𝗿𝗮𝗶𝗹𝘀: Cap regional manager discounting at 𝟮𝟬% 𝗳𝗼𝗿 𝗵𝗶𝗴𝗵-𝗿𝗲𝘁𝘂𝗿𝗻 𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀 (Machines/Tables) to 𝗱𝗶𝘀𝗰𝗼𝘂𝗿𝗮𝗴𝗲 “𝗯𝗿𝗮𝗰𝗸𝗲𝘁 𝘀𝗵𝗼𝗽𝗽𝗶𝗻𝗴” and 𝗹𝗼𝘄-𝗺𝗮𝗿𝗴𝗶𝗻 𝘃𝗼𝗹𝘂𝗺𝗲.
𝗦𝗵𝗶𝗳𝘁 𝗞𝗣𝗜 𝗜𝗻𝗰𝗲𝗻𝘁𝗶𝘃𝗲𝘀: Transition sales performance metrics from “Total Revenue” to “𝗡𝗲𝘁 𝗣𝗿𝗼𝗳𝗶𝘁 𝗮𝗳𝘁𝗲𝗿 𝗥𝗲𝘁𝘂𝗿𝗻𝘀” to 𝗮𝗹𝗶𝗴𝗻 𝘀𝗮𝗹𝗲𝘀𝗽𝗲𝗿𝘀𝗼𝗻 𝗯𝗲𝗵𝗮𝘃𝗶𝗼𝗿 𝘄𝗶𝘁𝗵 𝗯𝗼𝘁𝘁𝗼𝗺-𝗹𝗶𝗻𝗲 𝗵𝗲𝗮𝗹𝘁𝗵.
𝗥𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗣𝗼𝗹𝗶𝗰𝘆 𝗔𝘂𝗱𝗶𝘁: Conduct a targeted review of the 𝗪𝗲𝘀𝘁 𝗥𝗲𝗴𝗶𝗼𝗻’𝘀 𝗿𝗲𝘁𝘂𝗿𝗻 𝗽𝗼𝗹𝗶𝗰𝗶𝗲𝘀 and 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗽𝗮𝗿𝘁𝗻𝗲𝗿𝘀 to 𝗮𝗱𝗱𝗿𝗲𝘀𝘀 𝘄𝗵𝘆 𝟭𝟬𝟬% 𝗼𝗳 𝘀𝗲𝗿𝗶𝗮𝗹 𝗿𝗲𝘁𝘂𝗿𝗻𝘀 𝗮𝗿𝗲 𝗰𝗼𝗻𝗰𝗲𝗻𝘁𝗿𝗮𝘁𝗲𝗱 𝘁𝗵𝗲𝗿𝗲.
𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗥𝗲𝗰𝗼𝘃𝗲𝗿𝘆: Aim for a 𝟭𝟱% 𝗿𝗲𝗱𝘂𝗰𝘁𝗶𝗼𝗻 𝗶𝗻 𝗿𝗲𝘁𝘂𝗿𝗻-𝗿𝗲𝗹𝗮𝘁𝗲𝗱 𝗹𝗼𝘀𝘀𝗲𝘀 to hit the “return impact target,” which will 𝗿𝗲𝗰𝗹𝗮𝗶𝗺 𝗶𝗺𝗺𝗲𝗱𝗶𝗮𝘁𝗲 𝗰𝗮𝗽𝗶𝘁𝗮𝗹 𝘄𝗶𝘁𝗵𝗼𝘂𝘁 𝗿𝗲𝗾𝘂𝗶𝗿𝗶𝗻𝗴 𝗻𝗲𝘄 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗮𝗰𝗾𝘂𝗶𝘀𝗶𝘁𝗶𝗼𝗻.

2️⃣ 𝗦𝗮𝗹𝗲𝘀 𝗖𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗼𝗻

✅ 𝗧𝗵𝗲 𝗚𝗿𝗼𝘄𝘁𝗵 𝗚𝗮𝗽

Every region is 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗶𝗻𝗴 𝗯𝗲𝗹𝗼𝘄 𝗶𝘁𝘀 𝗮𝘀𝘀𝗶𝗴𝗻𝗲𝗱 𝗦𝗮𝗹𝗲𝘀 𝗖𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗼𝗻 𝗧𝗮𝗿𝗴𝗲𝘁. These targets represent the 𝟭𝟭𝟱% 𝘃𝗼𝗹𝘂𝗺𝗲 𝗿𝗲𝗾𝘂𝗶𝗿𝗲𝗱 𝘁𝗼 𝗺𝗲𝗲𝘁 𝗼𝘂𝗿 𝗴𝗹𝗼𝗯𝗮𝗹 $𝟯.𝟭𝟮𝗠 𝗴𝗼𝗮𝗹.

𝗧𝗼𝗽 𝗖𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗼𝗿: The 𝗪𝗲𝘀𝘁 𝗿𝗲𝗴𝗶𝗼𝗻 leads with 𝟯𝟭.𝟰𝟭% 𝗼𝗳 𝘁𝗼𝘁𝗮𝗹 𝘀𝗮𝗹𝗲𝘀 but faces the 𝗹𝗮𝗿𝗴𝗲𝘀𝘁 𝗴𝗿𝗼𝘄𝘁𝗵 𝗱𝗲𝗳𝗶𝗰𝗶𝘁 (𝟰.𝟳𝟮% 𝗴𝗮𝗽 𝗳𝗿𝗼𝗺 𝗶𝘁𝘀 𝟯𝟲.𝟭𝟯% 𝘁𝗮𝗿𝗴𝗲𝘁).
𝗦𝗲𝗰𝗼𝗻𝗱𝗮𝗿𝘆 𝗘𝗻𝗴𝗶𝗻𝗲: The 𝗘𝗮𝘀𝘁 𝗿𝗲𝗴𝗶𝗼𝗻 follows at 𝟮𝟵.𝟬𝟮% (𝟰.𝟯𝟱% 𝗴𝗮𝗽).
𝗨𝗻𝗱𝗲𝗿𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗲𝗿𝘀: The 𝗖𝗲𝗻𝘁𝗿𝗮𝗹 𝗮𝗻𝗱 𝗦𝗼𝘂𝘁𝗵 𝗿𝗲𝗴𝗶𝗼𝗻𝘀 combined contribute less than the West alone, totaling 𝟯𝟵.𝟱𝟳% 𝗰𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗼𝗻.

✅ 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗺𝗽𝗮𝗰𝘁: 𝗛𝗶𝗴𝗵 𝗦𝘁𝗮𝗸𝗲𝘀 𝗶𝗻 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁

The global sales target of $𝟯.𝟭𝟮𝗠 𝗱𝗲𝗽𝗲𝗻𝗱𝘀 𝗼𝗻 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝗿𝗲𝗴𝗶𝗼𝗻 𝗿𝗲𝗮𝗰𝗵𝗶𝗻𝗴 𝗶𝘁𝘀 𝟯𝟲% 𝗰𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗼𝗻 𝘁𝗮𝗿𝗴𝗲𝘁. However, since 100% of our “Serial Returners” are concentrated in the West, 𝗽𝘂𝘀𝗵𝗶𝗻𝗴 𝗳𝗼𝗿 𝗺𝗼𝗿𝗲 𝘃𝗼𝗹𝘂𝗺𝗲 𝘁𝗵𝗲𝗿𝗲 𝘄𝗶𝘁𝗵𝗼𝘂𝘁 𝗳𝗶𝘅𝗶𝗻𝗴 𝘁𝗵𝗲 𝗿𝗲𝘁𝘂𝗿𝗻 𝗶𝘀𝘀𝘂𝗲 𝘄𝗶𝗹𝗹 𝗹𝗶𝗸𝗲𝗹𝘆 𝗶𝗻𝗰𝗿𝗲𝗮𝘀𝗲 𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗩𝗮𝗺𝗽𝗶𝗿𝗲 𝗮𝗰𝘁𝗶𝘃𝗶𝘁𝘆 rather than healthy profit.

✅ 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁

𝗤𝘂𝗮𝗹𝗶𝘁𝘆 𝗼𝘃𝗲𝗿 𝗤𝘂𝗮𝗻𝘁𝗶𝘁𝘆 𝗶𝗻 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁: We should not attempt to 𝗰𝗹𝗼𝘀𝗲 𝘁𝗵𝗲 𝟰.𝟳𝟮% 𝗴𝗮𝗽 𝗶𝗻 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝘁𝗵𝗿𝗼𝘂𝗴𝗵 𝗱𝗲𝗲𝗽 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁𝗶𝗻𝗴. This will only attract more “Serial Returners.” 𝗪𝗲 𝘀𝗵𝗼𝘂𝗹𝗱 𝗳𝗼𝗰𝘂𝘀 𝗼𝗻 𝗺𝗮𝗿𝗴𝗶𝗻 𝗿𝗲𝗰𝗼𝘃𝗲𝗿𝘆 𝗳𝗶𝗿𝘀𝘁.
𝗔𝗴𝗴𝗿𝗲𝘀𝘀𝗶𝘃𝗲 𝗘𝘅𝗽𝗮𝗻𝘀𝗶𝗼𝗻 𝗶𝗻 𝘁𝗵𝗲 𝗘𝗮𝘀𝘁: Prioritize 𝗺𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝗮𝗻𝗱 𝘀𝗮𝗹𝗲𝘀 𝗶𝗻𝗰𝗲𝗻𝘁𝗶𝘃𝗲𝘀 𝗶𝗻 𝘁𝗵𝗲 𝗘𝗮𝘀𝘁 𝗥𝗲𝗴𝗶𝗼𝗻. It is a high-volume contributor (𝟮𝟵%) without the severe return profile of the West, making it 𝘁𝗵𝗲 𝘀𝗮𝗳𝗲𝘀𝘁 𝗽𝗮𝘁𝗵 𝘁𝗼 𝗰𝗹𝗼𝘀𝗶𝗻𝗴 𝘁𝗵𝗲 𝗴𝗹𝗼𝗯𝗮𝗹 𝗿𝗲𝘃𝗲𝗻𝘂𝗲 𝗴𝗮𝗽.
𝗧𝗮𝗿𝗴𝗲𝘁 𝗔𝗹𝗶𝗴𝗻𝗺𝗲𝗻𝘁: Update 𝗥𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗠𝗮𝗻𝗮𝗴𝗲𝗿 𝗞𝗣𝗜𝘀 𝘁𝗼 𝗿𝗲𝗳𝗹𝗲𝗰𝘁 𝘁𝗵𝗲𝘀𝗲 𝘀𝗽𝗲𝗰𝗶𝗳𝗶𝗰 𝗦𝗮𝗹𝗲𝘀 𝗖𝗼𝗻𝘁𝗿𝗶𝗯𝘂𝘁𝗶𝗼𝗻 𝗧𝗮𝗿𝗴𝗲𝘁𝘀 rather than historical performance, ensuring all regions are pulling toward the 𝟭𝟱% 𝗴𝗿𝗼𝘄𝘁𝗵 𝗼𝗯𝗷𝗲𝗰𝘁𝗶𝘃𝗲.

3️⃣ 𝗔𝘃𝗲𝗿𝗮𝗴𝗲 𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗟𝗶𝗳𝗲𝘁𝗶𝗺𝗲 𝗩𝗮𝗹𝘂𝗲 (𝗟𝗧𝗩)

✅ 𝗨𝗻𝗶𝗳𝗼𝗿𝗺 𝗨𝗻𝗱𝗲𝗿𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲

All regions are currently 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗶𝗻𝗴 𝗮𝘁 𝗮𝗽𝗽𝗿𝗼𝘅𝗶𝗺𝗮𝘁𝗲𝗹𝘆 𝟴𝟳% 𝗼𝗳 𝘁𝗵𝗲𝗶𝗿 𝗲𝘀𝘁𝗮𝗯𝗹𝗶𝘀𝗵𝗲𝗱 𝗟𝗧𝗩 𝘁𝗮𝗿𝗴𝗲𝘁𝘀. While the 𝗪𝗲𝘀𝘁 region 𝗯𝗼𝗮𝘀𝘁𝘀 𝘁𝗵𝗲 𝗵𝗶𝗴𝗵𝗲𝘀𝘁 𝗮𝗯𝘀𝗼𝗹𝘂𝘁𝗲 𝘃𝗮𝗹𝘂𝗲 ($𝟭𝟴𝟳.𝟮𝟳), it also c𝗮𝗿𝗿𝗶𝗲𝘀 𝘁𝗵𝗲 𝗹𝗮𝗿𝗴𝗲𝘀𝘁 𝗻𝗼𝗺𝗶𝗻𝗮𝗹 𝗴𝗮𝗽 ($𝟮𝟴.𝟭𝟬) compared to its target.

𝗛𝗶𝗴𝗵𝗲𝘀𝘁 𝗩𝗮𝗹𝘂𝗲: West ($187.27)
𝗟𝗼𝘄𝗲𝘀𝘁 𝗩𝗮𝗹𝘂𝗲: Central ($63.98)
𝗧𝗮𝗿𝗴𝗲𝘁 𝗚𝗮𝗽: A consistent 13% deficit across the board.

✅ 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗺𝗽𝗮𝗰𝘁: 𝗧𝗵𝗲 𝗥𝗲𝘁𝗲𝗻𝘁𝗶𝗼𝗻-𝗥𝗲𝘁𝘂𝗿𝗻 𝗧𝗲𝗻𝘀𝗶𝗼𝗻

The 𝗱𝗲𝗽𝗿𝗲𝘀𝘀𝗲𝗱 𝗟𝗧𝗩 𝗶𝗻 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 is particularly concerning because 𝘁𝗵𝗶𝘀 𝗿𝗲𝗴𝗶𝗼𝗻 𝗵𝗮𝗻𝗱𝗹𝗲𝘀 𝘁𝗵𝗲 𝗵𝗶𝗴𝗵𝗲𝘀𝘁 𝘀𝗮𝗹𝗲𝘀 𝘃𝗼𝗹𝘂𝗺𝗲. The existence of “Serial Returners” in the West (as identified in the return analysis) is likely 𝗰𝗮𝗽𝗽𝗶𝗻𝗴 𝗟𝗧𝗩 𝗯𝘆 𝗶𝗻𝗰𝗿𝗲𝗮𝘀𝗶𝗻𝗴 𝘁𝗵𝗲 “𝗰𝗼𝘀𝘁 𝘁𝗼 𝘀𝗲𝗿𝘃𝗲” and 𝗿𝗲𝘃𝗲𝗿𝘀𝗶𝗻𝗴 𝘁𝗵𝗲 𝗿𝗲𝘃𝗲𝗻𝘂𝗲 𝗼𝗳 𝗿𝗲𝗽𝗲𝗮𝘁 𝗽𝘂𝗿𝗰𝗵𝗮𝘀𝗲𝘀. High volume without a corresponding increase in LTV indicates that 𝘄𝗲 𝗮𝗿𝗲 𝗮𝗰𝗾𝘂𝗶𝗿𝗶𝗻𝗴 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿𝘀 𝘄𝗵𝗼 𝗱𝗼 𝗻𝗼𝘁 𝗽𝗿𝗼𝘃𝗶𝗱𝗲 𝘀𝘂𝘀𝘁𝗮𝗶𝗻𝗮𝗯𝗹𝗲, 𝗹𝗼𝗻𝗴-𝘁𝗲𝗿𝗺 𝗽𝗿𝗼𝗳𝗶𝘁.

✅ 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁

𝗡𝗲𝘂𝘁𝗿𝗮𝗹𝗶𝘇𝗲 𝘁𝗵𝗲 “𝗩𝗮𝗺𝗽𝗶𝗿𝗲𝘀”: Focus on the West and East regions to 𝗰𝗹𝗼𝘀𝗲 𝘁𝗵𝗲 𝗹𝗮𝗿𝗴𝗲𝘀𝘁 𝗱𝗼𝗹𝗹𝗮𝗿 𝗴𝗮𝗽𝘀 ($𝟮𝟴.𝟭𝟬 𝗮𝗻𝗱 $𝟮𝟰.𝟭𝟯, 𝗿𝗲𝘀𝗽𝗲𝗰𝘁𝗶𝘃𝗲𝗹𝘆). This should be done by 𝗽𝗿𝗶𝗼𝗿𝗶𝘁𝗶𝘇𝗶𝗻𝗴 𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀 𝗹𝗶𝗸𝗲 𝗖𝗼𝗽𝗶𝗲𝗿𝘀 and 𝗔𝗰𝗰𝗲𝘀𝘀𝗼𝗿𝗶𝗲𝘀 𝘄𝗵𝗶𝗰𝗵 𝗻𝗮𝘁𝘂𝗿𝗮𝗹𝗹𝘆 𝗱𝗿𝗶𝘃𝗲 𝗵𝗶𝗴𝗵𝗲𝗿 𝗟𝗧𝗩.
𝗥𝗲𝘁𝗲𝗻𝘁𝗶𝗼𝗻 𝗼𝘃𝗲𝗿 𝗔𝗰𝗾𝘂𝗶𝘀𝗶𝘁𝗶𝗼𝗻: Since all regions are missing targets by the same percentage, 𝗶𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁 𝗮 𝗴𝗹𝗼𝗯𝗮𝗹 𝗹𝗼𝘆𝗮𝗹𝘁𝘆 𝗽𝗿𝗼𝗴𝗿𝗮𝗺 specifically targeting the Corporate and Home Office segments 𝘁𝗼 𝗶𝗻𝗰𝗿𝗲𝗮𝘀𝗲 𝗽𝘂𝗿𝗰𝗵𝗮𝘀𝗲 𝗳𝗿𝗲𝗾𝘂𝗲𝗻𝗰𝘆.
𝗥𝗲𝘁𝘂𝗿𝗻 𝗠𝗶𝘁𝗶𝗴𝗮𝘁𝗶𝗼𝗻: In the West, 𝗹𝗼𝘄𝗲𝗿𝗶𝗻𝗴 𝘁𝗵𝗲 𝗿𝗲𝘁𝘂𝗿𝗻 𝗿𝗮𝘁𝗲 𝗯𝘆 𝘁𝗵𝗲 𝘁𝗮𝗿𝗴𝗲𝘁𝗲𝗱 𝟭𝟱% will automatically uplift LTV by 𝗿𝗲𝘁𝗮𝗶𝗻𝗶𝗻𝗴 𝗺𝗼𝗿𝗲 𝗺𝗼𝗻𝗲𝘁𝗮𝗿𝘆 𝘃𝗮𝗹𝘂𝗲 𝗽𝗲𝗿 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿.

4️⃣ 𝗔𝘃𝗲𝗿𝗮𝗴𝗲 𝗢𝗿𝗱𝗲𝗿 𝗩𝗮𝗹𝘂𝗲 (𝗔𝗢𝗩)

✅ 𝗨𝗻𝗶𝗳𝗼𝗿𝗺 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗗𝗲𝗳𝗶𝗰𝗶𝘁

Across all regions, there is 𝗮 𝗰𝗼𝗻𝘀𝗶𝘀𝘁𝗲𝗻𝘁 𝟭𝟯% 𝘀𝗵𝗼𝗿𝘁𝗳𝗮𝗹𝗹 𝗿𝗲𝗹𝗮𝘁𝗶𝘃𝗲 𝘁𝗼 𝘁𝗵𝗲 𝗲𝘀𝘁𝗮𝗯𝗹𝗶𝘀𝗵𝗲𝗱 𝗔𝗢𝗩 𝘁𝗮𝗿𝗴𝗲𝘁𝘀. While the absolute dollar values vary, every region is currently operating at 𝗮𝗽𝗽𝗿𝗼𝘅𝗶𝗺𝗮𝘁𝗲𝗹𝘆 𝟴𝟳% 𝗼𝗳 𝗶𝘁𝘀 𝘁𝗮𝗿𝗴𝗲𝘁 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝗰𝘆.

𝗧𝗼𝗽 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗲𝗿: The South region leads with 𝘁𝗵𝗲 𝗵𝗶𝗴𝗵𝗲𝘀𝘁 𝗔𝗢𝗩 ($𝟱𝟬𝟭.𝟯𝟳), yet faces 𝘁𝗵𝗲 𝗹𝗮𝗿𝗴𝗲𝘀𝘁 𝗻𝗼𝗺𝗶𝗻𝗮𝗹 𝗴𝗮𝗽 ($𝟳𝟱.𝟮𝟭).
𝗕𝗼𝘁𝘁𝗼𝗺 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗲𝗿: The Central region has 𝘁𝗵𝗲 𝗹𝗼𝘄𝗲𝘀𝘁 𝗔𝗢𝗩 ($𝟰𝟯𝟬.𝟲𝟲), falling $𝟲𝟰.𝟲𝟬 𝘀𝗵𝗼𝗿𝘁 𝗼𝗳 𝗶𝘁𝘀 𝘁𝗮𝗿𝗴𝗲𝘁.
𝗧𝗵𝗲 𝗪𝗲𝘀𝘁 𝗣𝗮𝗿𝗮𝗱𝗼𝘅: Despite being 𝘁𝗵𝗲 𝗵𝗶𝗴𝗵𝗲𝘀𝘁 𝘃𝗼𝗹𝘂𝗺𝗲 𝗿𝗲𝗴𝗶𝗼𝗻, the 𝗪𝗲𝘀𝘁’𝘀 𝗔𝗢𝗩 ($𝟰𝟱𝟯.𝟴𝟳$) 𝗿𝗲𝗺𝗮𝗶𝗻𝘀 𝘀𝘁𝗮𝗴𝗻𝗮𝗻𝘁, indicating that 𝗵𝗶𝗴𝗵 𝘀𝗮𝗹𝗲𝘀 𝘃𝗼𝗹𝘂𝗺𝗲 𝗶𝘀 𝗻𝗼𝘁 𝘁𝗿𝗮𝗻𝘀𝗹𝗮𝘁𝗶𝗻𝗴 𝗶𝗻𝘁𝗼 𝗵𝗶𝗴𝗵𝗲𝗿-𝘃𝗮𝗹𝘂𝗲 𝗶𝗻𝗱𝗶𝘃𝗶𝗱𝘂𝗮𝗹 𝘁𝗿𝗮𝗻𝘀𝗮𝗰𝘁𝗶𝗼𝗻𝘀.

✅ 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗺𝗽𝗮𝗰𝘁: 𝗧𝗵𝗲 “𝗕𝗿𝗮𝗰𝗸𝗲𝘁 𝗦𝗵𝗼𝗽𝗽𝗶𝗻𝗴” 𝗥𝗶𝘀𝗸

The 𝘀𝘁𝗮𝗹𝗹𝗲𝗱 𝗔𝗢𝗩 𝗶𝗻 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝗿𝗲𝗴𝗶𝗼𝗻 is particularly 𝗰𝗼𝗻𝗰𝗲𝗿𝗻𝗶𝗻𝗴 𝘄𝗵𝗲𝗻 𝗽𝗮𝗶𝗿𝗲𝗱 𝘄𝗶𝘁𝗵 𝗼𝘂𝗿 “𝗦𝗲𝗿𝗶𝗮𝗹 𝗥𝗲𝘁𝘂𝗿𝗻𝗲𝗿” 𝗳𝗶𝗻𝗱𝗶𝗻𝗴𝘀.

𝗤𝘂𝗮𝗹𝗶𝘁𝘆 𝘃𝘀. 𝗩𝗼𝗹𝘂𝗺𝗲: A mid-range AOV in a high-volume region 𝘀𝘂𝗴𝗴𝗲𝘀𝘁𝘀 𝘁𝗵𝗮𝘁 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿𝘀 𝗮𝗿𝗲 𝗽𝗹𝗮𝗰𝗶𝗻𝗴 𝗺𝗮𝗻𝘆 𝘀𝗺𝗮𝗹𝗹𝗲𝗿 𝗼𝗿𝗱𝗲𝗿𝘀 or, more dangerously, 𝗲𝗻𝗴𝗮𝗴𝗶𝗻𝗴 𝗶𝗻 “𝗯𝗿𝗮𝗰𝗸𝗲𝘁 𝘀𝗵𝗼𝗽𝗽𝗶𝗻𝗴” - 𝘱𝘶𝘳𝘤𝘩𝘢𝘴𝘪𝘯𝘨 𝘮𝘶𝘭𝘵𝘪𝘱𝘭𝘦 𝘪𝘵𝘦𝘮𝘴 𝘸𝘪𝘵𝘩 𝘵𝘩𝘦 𝘪𝘯𝘵𝘦𝘯𝘵 𝘵𝘰 𝘳𝘦𝘵𝘶𝘳𝘯 𝘮𝘰𝘴𝘵.
𝗠𝗮𝗿𝗴𝗶𝗻 𝗘𝗿𝗼𝘀𝗶𝗼𝗻: Because AOV is below target, 𝘁𝗵𝗲 𝗳𝗶𝘅𝗲𝗱 𝗰𝗼𝘀𝘁 𝗼𝗳 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗮𝗻𝗱 𝗽𝗿𝗼𝗰𝗲𝘀𝘀𝗶𝗻𝗴 𝗲𝗮𝗰𝗵 𝗼𝗿𝗱𝗲𝗿 𝗶𝘀 𝗲𝗮𝘁𝗶𝗻𝗴 𝗮 𝗹𝗮𝗿𝗴𝗲𝗿 𝗽𝗲𝗿𝗰𝗲𝗻𝘁𝗮𝗴𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗴𝗿𝗼𝘀𝘀 𝗺𝗮𝗿𝗴𝗶𝗻, especially for high-volume “Operational Vampires” (Machines/Tables).

✅ 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁

𝗜𝗻𝗰𝗲𝗻𝘁𝗶𝘃𝗶𝘇𝗲 “𝗛𝗲𝗮𝗹𝘁𝗵𝘆” 𝗕𝘂𝗻𝗱𝗹𝗶𝗻𝗴: Implement “𝗰𝗼𝗺𝗽𝗹𝗲𝘁𝗲 𝘁𝗵𝗲 𝗹𝗼𝗼𝗸” or “𝗳𝗿𝗲𝗾𝘂𝗲𝗻𝘁𝗹𝘆 𝗯𝗼𝘂𝗴𝗵𝘁 𝘁𝗼𝗴𝗲𝘁𝗵𝗲𝗿” 𝗽𝗿𝗼𝗺𝗽𝘁𝘀 𝗳𝗼𝗿 𝗵𝗶𝗴𝗵-𝗺𝗮𝗿𝗴𝗶𝗻 𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀 like 𝗔𝗰𝗰𝗲𝘀𝘀𝗼𝗿𝗶𝗲𝘀 and 𝗖𝗼𝗽𝗶𝗲𝗿𝘀 to drive AOV 𝘄𝗶𝘁𝗵𝗼𝘂𝘁 𝗮𝘁𝘁𝗿𝗮𝗰𝘁𝗶𝗻𝗴 𝘀𝗲𝗿𝗶𝗮𝗹 𝗿𝗲𝘁𝘂𝗿𝗻𝗲𝗿𝘀.
𝗧𝗵𝗿𝗲𝘀𝗵𝗼𝗹𝗱-𝗕𝗮𝘀𝗲𝗱 𝗦𝗵𝗶𝗽𝗽𝗶𝗻𝗴: Review the 𝗳𝗿𝗲𝗲 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝘁𝗵𝗿𝗲𝘀𝗵𝗼𝗹𝗱. Increasing 𝘁𝗵𝗲 𝗺𝗶𝗻𝗶𝗺𝘂𝗺 𝗼𝗿𝗱𝗲𝗿 𝘃𝗮𝗹𝘂𝗲 (𝗠𝗢𝗤) 𝗳𝗼𝗿 𝗳𝗿𝗲𝗲 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴 can organically lift AOV by e𝗻𝗰𝗼𝘂𝗿𝗮𝗴𝗶𝗻𝗴 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿𝘀 𝘁𝗼 𝗮𝗱𝗱 𝗼𝗻𝗲 𝗺𝗼𝗿𝗲 𝗶𝘁𝗲𝗺 𝘁𝗼 𝘁𝗵𝗲𝗶𝗿 𝗰𝗮𝗿𝘁.
𝗧𝗮𝗿𝗴𝗲𝘁 𝘁𝗵𝗲 𝗦𝗼𝘂𝘁𝗵 𝗳𝗼𝗿 𝗚𝗿𝗼𝘄𝘁𝗵: Since the South already has the highest natural AOV, 𝗽𝗿𝗶𝗼𝗿𝗶𝘁𝗶𝘇𝗲 𝗶𝘁 𝗳𝗼𝗿 “𝗣𝗿𝗲𝗺𝗶𝘂𝗺” 𝗽𝗿𝗼𝗱𝘂𝗰𝘁 𝗺𝗮𝗿𝗸𝗲𝘁𝗶𝗻𝗴 𝗰𝗮𝗺𝗽𝗮𝗶𝗴𝗻𝘀. Closing 𝘁𝗵𝗲 $𝟳𝟱 𝗴𝗮𝗽 will have the most significant impact on the bottom line.
𝗠𝗼𝗻𝗶𝘁𝗼𝗿 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝗳𝗼𝗿 “𝗩𝗮𝗺𝗽𝗶𝗿𝗲” 𝗢𝗿𝗱𝗲𝗿𝘀: Flag 𝗵𝗶𝗴𝗵-𝘃𝗮𝗹𝘂𝗲 𝗼𝗿𝗱𝗲𝗿𝘀 𝗶𝗻 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝘁𝗵𝗮𝘁 𝗰𝗼𝗻𝘀𝗶𝘀𝘁 𝗽𝘂𝗿𝗲𝗹𝘆 𝗼𝗳 𝗵𝗶𝗴𝗵-𝗿𝗲𝘁𝘂𝗿𝗻 𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀. These inflated AOVs are often “false positives” that 𝗿𝗲𝘀𝘂𝗹𝘁 𝗶𝗻 𝗮 𝗻𝗲𝘁 𝗹𝗼𝘀𝘀 𝗮𝗳𝘁𝗲𝗿 𝘁𝗵𝗲 𝗿𝗲𝘁𝘂𝗿𝗻 𝗶𝘀 𝗽𝗿𝗼𝗰𝗲𝘀𝘀𝗲𝗱.

𝗥𝗘𝗧𝗨𝗥𝗡 𝗜𝗠𝗣𝗔𝗖𝗧

While the overall store performance is strong, 𝗰𝗲𝗿𝘁𝗮𝗶𝗻 𝘀𝘂𝗯-𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀 𝗮𝗿𝗲 𝗲𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗶𝗻𝗴 𝗵𝗶𝗴𝗵 𝗿𝗲𝘁𝘂𝗿𝗻 𝗳𝗿𝗲𝗾𝘂𝗲𝗻𝗰𝗶𝗲𝘀 𝘁𝗵𝗮𝘁 𝘀𝗶𝗴𝗻𝗶𝗳𝗶𝗰𝗮𝗻𝘁𝗹𝘆 𝗶𝗺𝗽𝗮𝗰𝘁 𝗻𝗲𝘁 𝗽𝗿𝗼𝗳𝗶𝘁𝗮𝗯𝗶𝗹𝗶𝘁𝘆. Specifically, the 𝗠𝗮𝗰𝗵𝗶𝗻𝗲𝘀 sub-category has emerged as 𝘁𝗵𝗲 𝗵𝗶𝗴𝗵𝗲𝘀𝘁 𝗿𝗶𝘀𝗸 𝗮𝗿𝗲𝗮 𝘄𝗶𝘁𝗵 𝗮 𝗿𝗲𝘁𝘂𝗿𝗻 𝗿𝗮𝘁𝗲 𝗼𝗳 𝟭𝟭.𝟯𝟱%, followed closely by 𝗧𝗮𝗯𝗹𝗲𝘀 (𝟵.𝟰𝟵%) and 𝗣𝗮𝗽𝗲𝗿 (𝟵.𝟮𝟬%).

1️⃣ 𝗛𝗶𝗴𝗵-𝗥𝗲𝘁𝘂𝗿𝗻 𝗦𝘂𝗯-𝗖𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀 𝗮𝗻𝗱 𝗣𝗿𝗼𝗳𝗶𝘁 𝗘𝗿𝗼𝘀𝗶𝗼𝗻

✅ 𝗛𝗶𝗴𝗵-𝗙𝗿𝗲𝗾𝘂𝗲𝗻𝗰𝘆 𝗥𝗲𝘁𝘂𝗿𝗻𝘀: 𝗧𝗵𝗲 “𝗠𝗮𝗰𝗵𝗶𝗻𝗲𝘀” 𝗧𝗵𝗿𝗲𝘀𝗵𝗼𝗹𝗱

The Machines sub-category is currently the only segment exceeding the 10% management threshold.

𝗙𝗶𝗻𝗱𝗶𝗻𝗴: 𝟭𝟭.𝟯𝟱% of all Machine orders are returned.
𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗺𝗽𝗮𝗰𝘁: This represents $𝟭,𝟯𝟮𝟱.𝟴𝟰 𝗶𝗻 𝗽𝗿𝗼𝗳𝗶𝘁 𝘁𝗵𝗮𝘁 𝘄𝗮𝘀 𝗿𝗲𝗰𝗼𝗿𝗱𝗲𝗱 𝗯𝘂𝘁 𝗻𝗲𝘃𝗲𝗿 𝗿𝗲𝗮𝗹𝗶𝘇𝗲𝗱. Beyond the lost profit, there are 𝘂𝗻𝗾𝘂𝗮𝗻𝘁𝗶𝗳𝗶𝗲𝗱 𝗰𝗼𝘀𝘁𝘀 𝗿𝗲𝗹𝗮𝘁𝗲𝗱 𝘁𝗼 𝗿𝗲𝘀𝘁𝗼𝗰𝗸𝗶𝗻𝗴 𝗳𝗲𝗲𝘀, 𝘁𝗲𝗰𝗵𝗻𝗶𝗰𝗶𝗮𝗻 𝘁𝗶𝗺𝗲 𝗳𝗼𝗿 𝘁𝗲𝘀𝘁𝗶𝗻𝗴 𝗿𝗲𝘁𝘂𝗿𝗻𝗲𝗱 𝗵𝗮𝗿𝗱𝘄𝗮𝗿𝗲, and 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗹𝗼𝗴𝗶𝘀𝘁𝗶𝗰𝘀.

✅ 𝗧𝗵𝗲 𝗗𝗼𝘂𝗯𝗹𝗲-𝗟𝗼𝘀𝘀 𝗖𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀: 𝗕𝗶𝗻𝗱𝗲𝗿𝘀 𝗮𝗻𝗱 𝗧𝗮𝗯𝗹𝗲𝘀

A critical discovery in the data is that 𝘀𝗼𝗺𝗲 𝗿𝗲𝘁𝘂𝗿𝗻𝗲𝗱 𝗶𝘁𝗲𝗺𝘀 𝗵𝗮𝗱 𝗻𝗲𝗴𝗮𝘁𝗶𝘃𝗲 𝗽𝗿𝗼𝗳𝗶𝘁 𝗺𝗮𝗿𝗴𝗶𝗻𝘀 𝗲𝘃𝗲𝗻 𝗯𝗲𝗳𝗼𝗿𝗲 𝘁𝗵𝗲𝘆 𝘄𝗲𝗿𝗲 𝗿𝗲𝘁𝘂𝗿𝗻𝗲𝗱.

𝗙𝗶𝗻𝗱𝗶𝗻𝗴: Returns for 𝗕𝗶𝗻𝗱𝗲𝗿𝘀 and 𝗧𝗮𝗯𝗹𝗲𝘀 show 𝗮 𝗻𝗲𝗴𝗮𝘁𝗶𝘃𝗲 𝗽𝗿𝗼𝗳𝗶𝘁 𝗶𝗺𝗽𝗮𝗰𝘁 (-$𝟱,𝟰𝟱𝟰.𝟵𝟭 𝗮𝗻𝗱 -$𝟭,𝟳𝟱𝟳.𝟳𝟳, 𝗿𝗲𝘀𝗽𝗲𝗰𝘁𝗶𝘃𝗲𝗹𝘆).
𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗺𝗽𝗮𝗰𝘁: This indicates 𝗮 𝗱𝗼𝘂𝗯𝗹𝗲 𝗹𝗼𝘀𝘀 𝘀𝗰𝗲𝗻𝗮𝗿𝗶𝗼. The store is likely 𝘂𝘀𝗶𝗻𝗴 𝗵𝗲𝗮𝘃𝘆 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁𝘀 (𝗹𝗼𝘀𝘀-𝗹𝗲𝗮𝗱𝗲𝗿𝘀) 𝘁𝗼 𝗺𝗼𝘃𝗲 𝘁𝗵𝗲𝘀𝗲 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝘀, but when they are returned, 𝘁𝗵𝗲 𝘀𝘁𝗼𝗿𝗲 𝗮𝗯𝘀𝗼𝗿𝗯𝘀 𝘁𝗵𝗲 𝗶𝗻𝗶𝘁𝗶𝗮𝗹 𝗹𝗼𝘀𝘀 𝗽𝗹𝘂𝘀 𝘁𝗵𝗲 𝗼𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗰𝗼𝘀𝘁 𝗼𝗳 𝘁𝗵𝗲 𝗿𝗲𝘁𝘂𝗿𝗻. This suggests these sub-categories are currently 𝗮 𝗱𝗿𝗮𝗶𝗻 𝗼𝗻 𝗿𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗿𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀.

✅ 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁

𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗤𝘂𝗮𝗹𝗶𝘁𝘆 𝗔𝘂𝗱𝗶𝘁 (𝗠𝗮𝗰𝗵𝗶𝗻𝗲𝘀): Conduct 𝗮 𝗱𝗲𝗲𝗽-𝗱𝗶𝘃𝗲 𝗿𝗲𝘃𝗶𝗲𝘄 𝗼𝗳 𝘁𝗵𝗲 𝗠𝗮𝗰𝗵𝗶𝗻𝗲𝘀 𝘀𝘂𝗯-𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝘆. 𝘈𝘳𝘦 𝘵𝘩𝘦𝘴𝘦 𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘥𝘶𝘦 𝘵𝘰 𝘵𝘦𝘤𝘩𝘯𝘪𝘤𝘢𝘭 𝘥𝘦𝘧𝘦𝘤𝘵𝘴, or 𝘢𝘳𝘦 𝘵𝘩𝘦𝘺 “𝘣𝘶𝘺𝘦𝘳’𝘴 𝘳𝘦𝘮𝘰𝘳𝘴𝘦” 𝘤𝘢𝘶𝘴𝘦𝘥 𝘣𝘺 𝘩𝘪𝘨𝘩 𝘱𝘳𝘪𝘤𝘦 𝘱𝘰𝘪𝘯𝘵𝘴?
𝗗𝗶𝘀𝗰𝗼𝘂𝗻𝘁 𝗣𝗼𝗹𝗶𝗰𝘆 𝗥𝗲𝘃𝗶𝘀𝗶𝗼𝗻 (𝗕𝗶𝗻𝗱𝗲𝗿𝘀 & 𝗧𝗮𝗯𝗹𝗲𝘀): Since Binders and Tables are being returned at high rates while already losing money, we recommend 𝗿𝗲𝗱𝘂𝗰𝗶𝗻𝗴 𝘁𝗵𝗲 𝗺𝗮𝘅𝗶𝗺𝘂𝗺 𝗮𝗹𝗹𝗼𝘄𝗮𝗯𝗹𝗲 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁 𝗳𝗼𝗿 𝘁𝗵𝗲𝘀𝗲 𝗶𝘁𝗲𝗺𝘀. There is a high probability that “𝗱𝗲𝗲𝗽-𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁 𝗵𝘂𝗻𝘁𝗲𝗿𝘀” 𝗵𝗮𝘃𝗲 𝗮 𝗹𝗼𝘄𝗲𝗿 𝗰𝗼𝗺𝗺𝗶𝘁𝗺𝗲𝗻𝘁 𝘁𝗼 𝘁𝗵𝗲 𝗽𝘂𝗿𝗰𝗵𝗮𝘀𝗲.
𝗘𝗻𝗵𝗮𝗻𝗰𝗲𝗱 𝗗𝗲𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻/𝗣𝗿𝗲-𝗦𝗮𝗹𝗲𝘀 (𝗖𝗼𝗽𝗶𝗲𝗿𝘀): Given the $𝟴.𝟲𝗸 𝗶𝗺𝗽𝗮𝗰𝘁, we should 𝗶𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁 𝗮 “𝗵𝗶𝗴𝗵-𝘁𝗼𝘂𝗰𝗵” 𝗽𝗿𝗲-𝘀𝗮𝗹𝗲𝘀 𝗰𝗵𝗲𝗰𝗸 𝗳𝗼𝗿 𝗖𝗼𝗽𝗶𝗲𝗿𝘀 𝘁𝗼 𝗲𝗻𝘀𝘂𝗿𝗲 𝘁𝗵𝗲 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗶𝘀 𝗼𝗿𝗱𝗲𝗿𝗶𝗻𝗴 𝘁𝗵𝗲 𝗰𝗼𝗿𝗿𝗲𝗰𝘁 𝘀𝗽𝗲𝗰𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀, reducing “incorrect item” returns.

2️⃣ 𝗥𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗩𝗮𝗿𝗶𝗮𝗻𝗰𝗲 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀

✅ 𝗦𝗲𝘃𝗲𝗿𝗲 𝗥𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗗𝗶𝘀𝗽𝗮𝗿𝗶𝘁𝘆 (𝗧𝗵𝗲 𝗪𝗲𝘀𝘁 𝗥𝗲𝗴𝗶𝗼𝗻)

The West region, 𝗺𝗮𝗻𝗮𝗴𝗲𝗱 𝗯𝘆 𝗔𝗻𝗻𝗮 𝗔𝗻𝗱𝗿𝗲𝗮𝗱𝗶, is currently 𝗳𝗮𝗰𝗶𝗻𝗴 𝗮 𝗰𝗿𝗶𝘁𝗶𝗰𝗮𝗹 𝗿𝗲𝘁𝘂𝗿𝗻 𝗰𝗿𝗶𝘀𝗶𝘀.

𝗙𝗶𝗻𝗱𝗶𝗻𝗴: The return rate in the West stands at 𝟮𝟬.𝟬𝟬%, which is 𝗺𝗼𝗿𝗲 𝘁𝗵𝗮𝗻 𝗱𝗼𝘂𝗯𝗹𝗲 𝘁𝗵𝗲 𝗰𝗼𝗺𝗽𝗮𝗻𝘆-𝘄𝗶𝗱𝗲 𝗮𝘃𝗲𝗿𝗮𝗴𝗲 and 𝘀𝗶𝗴𝗻𝗶𝗳𝗶𝗰𝗮𝗻𝘁𝗹𝘆 𝗵𝗶𝗴𝗵𝗲𝗿 𝘁𝗵𝗮𝗻 𝘁𝗵𝗲 𝟭𝟬% 𝗺𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 𝘁𝗵𝗿𝗲𝘀𝗵𝗼𝗹𝗱.
𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗺𝗽𝗮𝗰𝘁: 𝗢𝗻𝗲 𝗼𝘂𝘁 𝗼𝗳 𝗲𝘃𝗲𝗿𝘆 𝗳𝗶𝘃𝗲 𝗶𝘁𝗲𝗺𝘀 𝘀𝗼𝗹𝗱 𝗶𝗻 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝗶𝘀 𝗯𝗲𝗶𝗻𝗴 𝗿𝗲𝘁𝘂𝗿𝗻𝗲𝗱. This suggests 𝗮 𝗺𝗮𝘀𝘀𝗶𝘃𝗲 𝗼𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗹𝗲𝗮𝗸𝗮𝗴𝗲. Not only is 𝗽𝗿𝗼𝗳𝗶𝘁 𝗯𝗲𝗶𝗻𝗴 𝗹𝗼𝘀𝘁, but the 𝗰𝗼𝘀𝘁 𝗼𝗳 𝗿𝗲𝘃𝗲𝗿𝘀𝗲 𝗹𝗼𝗴𝗶𝘀𝘁𝗶𝗰𝘀 (𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴, 𝗽𝗿𝗼𝗰𝗲𝘀𝘀𝗶𝗻𝗴, 𝗮𝗻𝗱 𝗿𝗲𝘀𝘁𝗼𝗰𝗸𝗶𝗻𝗴) in the West is likely 𝘁𝗵𝗲 𝗵𝗶𝗴𝗵𝗲𝘀𝘁 𝗶𝗻 𝘁𝗵𝗲 𝗰𝗼𝗺𝗽𝗮𝗻𝘆.

✅ 𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗘𝘅𝗰𝗲𝗹𝗹𝗲𝗻𝗰𝗲 (𝗧𝗵𝗲 𝗖𝗲𝗻𝘁𝗿𝗮𝗹 𝗥𝗲𝗴𝗶𝗼𝗻)

𝗞𝗲𝗹𝗹𝘆 𝗪𝗶𝗹𝗹𝗶𝗮𝗺𝘀 in the Central Region is currently 𝘁𝗵𝗲 𝘁𝗼𝗽 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗲𝗿 𝗿𝗲𝗴𝗮𝗿𝗱𝗶𝗻𝗴 𝗿𝗲𝘁𝘂𝗿𝗻 𝗺𝗶𝘁𝗶𝗴𝗮𝘁𝗶𝗼𝗻.

𝗙𝗶𝗻𝗱𝗶𝗻𝗴: An exceptionally 𝗹𝗼𝘄 𝗿𝗲𝘁𝘂𝗿𝗻 𝗿𝗮𝘁𝗲 𝗼𝗳 𝟯.𝟱𝟳%.
𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗺𝗽𝗮𝗰𝘁: The Central region 𝗽𝗿𝗼𝘃𝗶𝗱𝗲𝘀 𝗮 𝗯𝗲𝗻𝗰𝗵𝗺𝗮𝗿𝗸 𝗳𝗼𝗿 𝘁𝗵𝗲 𝗿𝗲𝘀𝘁 𝗼𝗳 𝘁𝗵𝗲 𝗰𝗼𝗺𝗽𝗮𝗻𝘆. Low returns mean 𝘀𝘁𝗮𝗯𝗹𝗲 𝗿𝗲𝘃𝗲𝗻𝘂𝗲, 𝗽𝗿𝗲𝗱𝗶𝗰𝘁𝗮𝗯𝗹𝗲 𝗶𝗻𝘃𝗲𝗻𝘁𝗼𝗿𝘆 𝗹𝗲𝘃𝗲𝗹𝘀, 𝗮𝗻𝗱 𝗵𝗶𝗴𝗵𝗲𝗿 𝗰𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝘀𝗮𝘁𝗶𝘀𝗳𝗮𝗰𝘁𝗶𝗼𝗻.

✅ 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁

𝗣𝗿𝗼𝗰𝗲𝘀𝘀 𝗥𝗲𝘃𝗶𝗲𝘄 𝗳𝗼𝗿 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝗥𝗲𝗴𝗶𝗼𝗻: A mandatory 𝗼𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗮𝘂𝗱𝗶𝘁 𝗶𝘀 𝗿𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗲𝗱 𝗳𝗼𝗿 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝗿𝗲𝗴𝗶𝗼𝗻. We need to 𝗶𝗻𝘃𝗲𝘀𝘁𝗶𝗴𝗮𝘁𝗲 𝗶𝗳 𝘁𝗵𝗲 𝗵𝗶𝗴𝗵 𝗿𝗲𝘁𝘂𝗿𝗻 𝗿𝗮𝘁𝗲 𝗶𝘀 𝗱𝘂𝗲 𝘁𝗼 𝗮 𝘀𝗽𝗲𝗰𝗶𝗳𝗶𝗰 𝘄𝗮𝗿𝗲𝗵𝗼𝘂𝘀𝗲’𝘀 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗲𝗿𝗿𝗼𝗿𝘀, an 𝗮𝗴𝗴𝗿𝗲𝘀𝘀𝗶𝘃𝗲 𝘀𝗮𝗹𝗲𝘀 𝗰𝘂𝗹𝘁𝘂𝗿𝗲 𝘁𝗵𝗮𝘁 𝗼𝘃𝗲𝗿-𝗽𝗿𝗼𝗺𝗶𝘀𝗲𝘀 𝗼𝗻 𝗽𝗿𝗼𝗱𝘂𝗰𝘁 𝗰𝗮𝗽𝗮𝗯𝗶𝗹𝗶𝘁𝗶𝗲𝘀, or 𝗮 𝗵𝗶𝗴𝗵 𝗰𝗼𝗻𝗰𝗲𝗻𝘁𝗿𝗮𝘁𝗶𝗼𝗻 𝗼𝗳 𝘁𝗵𝗲 “𝗠𝗮𝗰𝗵𝗶𝗻𝗲𝘀” 𝘀𝘂𝗯-𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝘆 𝗿𝗲𝘁𝘂𝗿𝗻𝘀 𝗶𝗻 𝘁𝗵𝗮𝘁 𝗮𝗿𝗲𝗮.
𝗠𝗲𝗻𝘁𝗼𝗿𝘀𝗵𝗶𝗽 𝗣𝗿𝗼𝗴𝗿𝗮𝗺: Implement 𝗮 𝗸𝗻𝗼𝘄𝗹𝗲𝗱𝗴𝗲-𝘀𝗵𝗮𝗿𝗶𝗻𝗴 𝗶𝗻𝗶𝘁𝗶𝗮𝘁𝗶𝘃𝗲 𝘄𝗵𝗲𝗿𝗲 𝗞𝗲𝗹𝗹𝘆 𝗪𝗶𝗹𝗹𝗶𝗮𝗺𝘀 (𝗖𝗲𝗻𝘁𝗿𝗮𝗹) 𝘀𝗵𝗮𝗿𝗲𝘀 𝗿𝗲𝗴𝗶𝗼𝗻𝗮𝗹 𝗯𝗲𝘀𝘁 𝗽𝗿𝗮𝗰𝘁𝗶𝗰𝗲𝘀 for order accuracy and customer follow-up 𝘄𝗶𝘁𝗵 𝗔𝗻𝗻𝗮 𝗔𝗻𝗱𝗿𝗲𝗮𝗱𝗶 and 𝗖𝗵𝘂𝗰𝗸 𝗠𝗮𝗴𝗲𝗲.

𝗗𝗜𝗦𝗖𝗢𝗨𝗡𝗧 𝗢𝗣𝗧𝗜𝗠𝗜𝗭𝗔𝗧𝗜𝗢𝗡 𝗔𝗡𝗗 𝗠𝗔𝗥𝗚𝗜𝗡 𝗛𝗘𝗔𝗟𝗧𝗛

1️⃣ 𝗙𝗶𝗻𝗱𝗶𝗻𝗴 𝘁𝗵𝗲 “𝗗𝗮𝗻𝗴𝗲𝗿 𝗭𝗼𝗻𝗲”

The data reveals 𝗮 𝘀𝘁𝗮𝗿𝗸 “𝗣𝗿𝗼𝗳𝗶𝘁 𝗖𝗹𝗶𝗳𝗳” 𝗮𝘀 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁𝘀 𝗶𝗻𝗰𝗿𝗲𝗮𝘀𝗲. Here is how the margins shift across the thresholds the analysis identified:

✅ 𝗞𝗲𝘆 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀 𝗮𝗻𝗱 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗜𝗺𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀

𝗧𝗵𝗲 𝟮𝟬% 𝗦𝗮𝗳𝗲 𝗛𝗮𝗿𝗯𝗼𝗿:

𝗔𝘁 𝗮 𝟮𝟬% 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁, the store still maintains 𝗮 𝗱𝗼𝘂𝗯𝗹𝗲-𝗱𝗶𝗴𝗶𝘁 𝗽𝗿𝗼𝗳𝗶𝘁 𝗺𝗮𝗿𝗴𝗶𝗻 (𝟭𝟭.𝟳𝟴%). While this is lower than the 29% baseline, 𝗶𝘁 𝗿𝗲𝗽𝗿𝗲𝘀𝗲𝗻𝘁𝘀 𝗮 𝗺𝗮𝘀𝘀𝗶𝘃𝗲 𝘃𝗼𝗹𝘂𝗺𝗲 𝗼𝗳 𝘀𝗮𝗹𝗲𝘀 ($𝟵𝟭𝟱𝗸) that is still contributing positively to the bottom line.

𝗧𝗵𝗲 𝟯𝟬% 𝗣𝗿𝗼𝗳𝗶𝘁 𝗖𝗹𝗶𝗳𝗳:

𝗧𝗵𝗲 𝟯𝟬% 𝘁𝗵𝗿𝗲𝘀𝗵𝗼𝗹𝗱 𝗶𝘀 𝘁𝗵𝗲 𝗱𝗲𝗳𝗶𝗻𝗶𝘁𝗶𝘃𝗲 “𝗗𝗮𝗻𝗴𝗲𝗿 𝗭𝗼𝗻𝗲”. At this level, 𝗲𝘃𝗲𝗿𝘆 𝗱𝗼𝗹𝗹𝗮𝗿 𝗼𝗳 𝘀𝗮𝗹𝗲𝘀 𝗮𝗰𝘁𝘂𝗮𝗹𝗹𝘆 𝘀𝘂𝗯𝘁𝗿𝗮𝗰𝘁𝘀 𝗻𝗲𝗮𝗿𝗹𝘆 𝟭𝟬 𝗰𝗲𝗻𝘁𝘀 𝗳𝗿𝗼𝗺 𝘁𝗵𝗲 𝗰𝗼𝗺𝗽𝗮𝗻𝘆’𝘀 𝗿𝗲𝘃𝗲𝗻𝘂𝗲.

𝗧𝗵𝗲 𝗥𝗲𝗮𝗹𝗶𝘁𝘆: Any promotion or manager-override that exceeds 25% is likely actively destroying value.

𝗧𝗵𝗲 “𝗛𝗶𝗴𝗵-𝗩𝗼𝗹𝘂𝗺𝗲, 𝗡𝗼-𝗣𝗿𝗼𝗳𝗶𝘁” 𝗧𝗿𝗮𝗽:

At 𝟱𝟬% 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁, the store still generates $𝟵𝟬,𝟬𝟬𝟬 𝗶𝗻 𝘀𝗮𝗹𝗲𝘀.

𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗺𝗽𝗮𝗰𝘁: On paper, a manager like 𝗔𝗻𝗻𝗮 𝗔𝗻𝗱𝗿𝗲𝗮𝗱𝗶 (𝗪𝗲𝘀𝘁) 𝗺𝗶𝗴𝗵𝘁 𝗹𝗼𝗼𝗸 𝘀𝘂𝗰𝗰𝗲𝘀𝘀𝗳𝘂𝗹 because she is “𝗺𝗼𝘃𝗶𝗻𝗴 𝗶𝗻𝘃𝗲𝗻𝘁𝗼𝗿𝘆” and 𝗴𝗲𝗻𝗲𝗿𝗮𝘁𝗶𝗻𝗴 𝗵𝗶𝗴𝗵 𝘀𝗮𝗹𝗲𝘀 𝗳𝗶𝗴𝘂𝗿𝗲𝘀. However, 𝘁𝗵𝗲𝘀𝗲 𝘀𝗮𝗹𝗲𝘀 𝗿𝗲𝘀𝘂𝗹𝘁𝗲𝗱 𝗶𝗻 𝗮 $𝟮𝟲,𝟬𝟬𝟬 𝗹𝗼𝘀𝘀. This 𝗰𝗼𝗻𝗳𝗶𝗿𝗺𝘀 𝘁𝗵𝗮𝘁 “𝘀𝗮𝗹𝗲𝘀 𝘃𝗼𝗹𝘂𝗺𝗲” 𝗶𝘀 𝗮 𝘃𝗮𝗻𝗶𝘁𝘆 𝗺𝗲𝘁𝗿𝗶𝗰 in the West 𝗶𝗳 𝗶𝘁 𝗶𝘀 𝗯𝗲𝗶𝗻𝗴 𝗮𝗰𝗵𝗶𝗲𝘃𝗲𝗱 𝘁𝗵𝗿𝗼𝘂𝗴𝗵 𝘁𝗵𝗲𝘀𝗲 𝗱𝗲𝗲𝗽 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁𝘀.

✅ 𝗦𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗰 𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁

We should 𝗶𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁 𝗮 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁 𝗰𝗲𝗶𝗹𝗶𝗻𝗴 𝗼𝗳 𝟮𝟬% 𝗳𝗼𝗿 𝗮𝗹𝗹 𝘀𝘁𝗮𝗻𝗱𝗮𝗿𝗱 𝘀𝗮𝗹𝗲𝘀.

Any discount reaching 𝟯𝟬% 𝗼𝗿 𝗵𝗶𝗴𝗵𝗲𝗿 𝘀𝗵𝗼𝘂𝗹𝗱 𝗿𝗲𝗾𝘂𝗶𝗿𝗲 𝗮 𝘀𝗲𝗰𝗼𝗻𝗱𝗮𝗿𝘆 𝗮𝗽𝗽𝗿𝗼𝘃𝗮𝗹 𝗳𝗿𝗼𝗺 𝗮 𝘀𝗲𝗻𝗶𝗼𝗿 𝗱𝗶𝗿𝗲𝗰𝘁𝗼𝗿, as our data proves these transactions are mathematically 𝗴𝘂𝗮𝗿𝗮𝗻𝘁𝗲𝗲𝗱 𝘁𝗼 𝗯𝗲 𝘂𝗻𝗽𝗿𝗼𝗳𝗶𝘁𝗮𝗯𝗹𝗲.
We should also 𝗰𝗿𝗼𝘀𝘀-𝗿𝗲𝗳𝗲𝗿𝗲𝗻𝗰𝗲 𝘁𝗵𝗶𝘀 𝘄𝗶𝘁𝗵 𝗼𝘂𝗿 𝗦𝗲𝗿𝗶𝗮𝗹 𝗥𝗲𝘁𝘂𝗿𝗻𝗲𝗿 𝗹𝗶𝘀𝘁. If customers are 𝗯𝘂𝘆𝗶𝗻𝗴 𝗮𝘁 𝟱𝟬% 𝗼𝗳𝗳 𝗮𝗻𝗱 𝘁𝗵𝗲𝗻 𝗿𝗲𝘁𝘂𝗿𝗻𝗶𝗻𝗴 𝘁𝗵𝗲 𝗶𝘁𝗲𝗺𝘀, the store is 𝗹𝗼𝘀𝗶𝗻𝗴 𝗺𝗼𝗻𝗲𝘆 𝘁𝘄𝗶𝗰𝗲: once on the 𝗻𝗲𝗴𝗮𝘁𝗶𝘃𝗲 𝗺𝗮𝗿𝗴𝗶𝗻 and once on the 𝗿𝗲𝘁𝘂𝗿𝗻 𝗹𝗼𝗴𝗶𝘀𝘁𝗶𝗰𝘀.

2️⃣ 𝗧𝗵𝗲 “𝗗𝗮𝗻𝗴𝗲𝗿 𝗭𝗼𝗻𝗲” 𝗢𝗿𝗱𝗲𝗿 𝗣𝗿𝗼𝗳𝗶𝗹𝗲: 𝗪𝗲𝘀𝘁 𝗥𝗲𝗴𝗶𝗼𝗻

The analysis processed the transaction logs for the West region and 𝗶𝗱𝗲𝗻𝘁𝗶𝗳𝗶𝗲𝗱 𝘁𝗵𝗲 𝘀𝗽𝗲𝗰𝗶𝗳𝗶𝗰 𝗢𝗿𝗱𝗲𝗿 𝗜𝗗𝘀 𝘁𝗵𝗮𝘁 𝗳𝗮𝗹𝗹 𝗶𝗻𝘁𝗼 𝘁𝗵𝗲 “𝗗𝗮𝗻𝗴𝗲𝗿 𝗭𝗼𝗻𝗲” (𝗗𝗶𝘀𝗰𝗼𝘂𝗻𝘁 ≥ 𝟯𝟬%). These orders 𝗿𝗲𝗽𝗿𝗲𝘀𝗲𝗻𝘁 𝘁𝗵𝗲 𝗺𝗼𝘀𝘁 𝘀𝗶𝗴𝗻𝗶𝗳𝗶𝗰𝗮𝗻𝘁 𝗽𝗿𝗼𝗳𝗶𝘁 𝗱𝗿𝗮𝗶𝗻𝘀 𝘂𝗻𝗱𝗲𝗿 𝗔𝗻𝗻𝗮 𝗔𝗻𝗱𝗿𝗲𝗮𝗱𝗶’𝘀 𝗺𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁.

✅ 𝗧𝗼𝗽 𝟱 “𝗣𝗿𝗼𝗳𝗶𝘁 𝗕𝗹𝗲𝗲𝗱” 𝗢𝗿𝗱𝗲𝗿𝘀 (𝗛𝗶𝗴𝗵𝗲𝘀𝘁 𝗟𝗼𝘀𝘀𝗲𝘀)

These specific orders are critical because 𝘁𝗵𝗲𝘆 𝗰𝗼𝗺𝗯𝗶𝗻𝗲 𝗱𝗲𝗲𝗽 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁𝘀 (𝟱𝟬–𝟳𝟬%) 𝘄𝗶𝘁𝗵 𝗵𝗶𝗴𝗵-𝘃𝗮𝗹𝘂𝗲 𝘀𝘂𝗯-𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝗶𝗲𝘀. They are effectively 𝘀𝗲𝗹𝗹𝗶𝗻𝗴 𝗮𝘁 𝗮 𝗹𝗼𝘀𝘀.

3️⃣ 𝗔𝘂𝗱𝗶𝘁 𝗮𝗻𝗱 𝗔𝗰𝘁𝗶𝗼𝗻 𝗣𝗹𝗮𝗻 𝗳𝗼𝗿 𝗔𝗻𝗻𝗮 𝗔𝗻𝗱𝗿𝗲𝗮𝗱𝗶

We recommend using this list to 𝗶𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁 𝘁𝗵𝗿𝗲𝗲 𝗶𝗺𝗺𝗲𝗱𝗶𝗮𝘁𝗲 “𝗵𝗮𝗿𝗱 𝘀𝘁𝗼𝗽𝘀” 𝗶𝗻 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝗿𝗲𝗴𝗶𝗼𝗻’𝘀 𝗳𝘂𝗹𝗳𝗶𝗹𝗹𝗺𝗲𝗻𝘁 𝘀𝘆𝘀𝘁𝗲𝗺:

𝗗𝗶𝘀𝗰𝗼𝘂𝗻𝘁 𝗖𝗲𝗶𝗹𝗶𝗻𝗴: Immediately 𝗱𝗶𝘀𝗮𝗯𝗹𝗲 𝘁𝗵𝗲 𝗮𝗯𝗶𝗹𝗶𝘁𝘆 𝘁𝗼 𝗮𝗽𝗽𝗹𝘆 𝗮 𝟳𝟬% 𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁 on 𝗠𝗮𝗰𝗵𝗶𝗻𝗲𝘀 and 𝗕𝗼𝗼𝗸𝗰𝗮𝘀𝗲𝘀 without 𝗩𝗣-𝗹𝗲𝘃𝗲𝗹 𝗮𝘂𝘁𝗵𝗼𝗿𝗶𝘇𝗮𝘁𝗶𝗼𝗻. The data shows these are 𝟭𝟬𝟬% 𝗴𝘂𝗮𝗿𝗮𝗻𝘁𝗲𝗲𝗱 𝘁𝗼 𝗯𝗲 𝗱𝗲𝗲𝗽-𝗹𝗼𝘀𝘀 𝘁𝗿𝗮𝗻𝘀𝗮𝗰𝘁𝗶𝗼𝗻𝘀.
𝗢𝗿𝗱𝗲𝗿 𝗜𝗗 𝗥𝗲𝗰𝗹𝗮𝗺𝗮𝘁𝗶𝗼𝗻: For the specific Order IDs listed above (especially the 2020 orders), 𝗮𝘂𝗱𝗶𝘁 𝘄𝗵𝗲𝘁𝗵𝗲𝗿 𝘁𝗵𝗲𝘀𝗲 𝘄𝗲𝗿𝗲 𝗲𝘃𝗲𝗿 𝗿𝗲𝘁𝘂𝗿𝗻𝗲𝗱. If they were kept, 𝘄𝗲 𝗹𝗼𝘀𝘁 𝗰𝗮𝘀𝗵 𝗼𝗻 𝘁𝗵𝗲 𝗺𝗮𝗿𝗴𝗶𝗻; if they were returned, 𝘄𝗲 𝗹𝗼𝘀𝘁 𝗲𝘃𝗲𝗻 𝗺𝗼𝗿𝗲 𝗼𝗻 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝗮𝗻𝗱 𝗽𝗿𝗼𝗰𝗲𝘀𝘀𝗶𝗻𝗴.
𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗣𝗿𝗼𝗳𝗶𝗹𝗶𝗻𝗴: Customers like 𝗥𝗲𝘀𝗶 𝗣𝗼̈𝗹𝗸𝗶𝗻𝗴 and 𝗔𝗿𝘁𝗵𝘂𝗿 𝗚𝗮𝗶𝗻𝗲𝗿 𝗮𝗽𝗽𝗲𝗮𝗿 𝗺𝘂𝗹𝘁𝗶𝗽𝗹𝗲 𝘁𝗶𝗺𝗲𝘀 𝗶𝗻 𝘁𝗵𝗲 𝗵𝗶𝗴𝗵-𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁/𝗵𝗶𝗴𝗵-𝗹𝗼𝘀𝘀 𝗱𝗮𝘁𝗮. They should be 𝗳𝗹𝗮𝗴𝗴𝗲𝗱 𝗮𝘀 “𝗟𝗼𝘄-𝗩𝗮𝗹𝘂𝗲/𝗛𝗶𝗴𝗵-𝗥𝗶𝘀𝗸” 𝗮𝗰𝗰𝗼𝘂𝗻𝘁𝘀 for future promotions.

𝗢𝗣𝗘𝗥𝗔𝗧𝗜𝗢𝗡𝗔𝗟 𝗕𝗢𝗧𝗧𝗟𝗘𝗡𝗘𝗖𝗞 𝗜𝗗𝗘𝗡𝗧𝗜𝗙𝗜𝗖𝗔𝗧𝗜𝗢𝗡

1️⃣ 𝗠𝗮𝗻𝗮𝗴𝗲𝗿𝗶𝗮𝗹 𝗘𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝗰𝘆 𝗮𝗻𝗱 𝗥𝗲𝘁𝘂𝗿𝗻𝘀

𝗖𝗮𝘀𝘀𝗮𝗻𝗱𝗿𝗮 𝗕𝗿𝗮𝗻𝗱𝗼𝘄 (𝗦𝗼𝘂𝘁𝗵) is 𝗹𝗲𝗮𝗱𝗶𝗻𝗴 𝗶𝗻 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝗰𝘆 𝗮𝗰𝗿𝗼𝘀𝘀 𝗯𝗼𝘁𝗵 𝗺𝗲𝘁𝗿𝗶𝗰𝘀 and 𝗞𝗲𝗹𝗹𝘆 𝗪𝗶𝗹𝗹𝗶𝗮𝗺𝘀 (𝗖𝗲𝗻𝘁𝗿𝗮𝗹) 𝘀𝗵𝗼𝘄𝗶𝗻𝗴 𝘁𝗵𝗮𝘁 𝗹𝗼𝗻𝗴 𝘄𝗮𝗶𝘁 𝘁𝗶𝗺𝗲𝘀 𝗱𝗼𝗻’𝘁 𝗮𝗹𝘄𝗮𝘆𝘀 𝘁𝗿𝗮𝗻𝘀𝗹𝗮𝘁𝗲 𝘁𝗼 𝗵𝗶𝗴𝗵 𝗿𝗲𝘁𝘂𝗿𝗻𝘀, we have a fascinating “Efficiency vs. Loyalty” case study.
The data from managerial efficiency and returns analysis 𝗿𝗲𝘃𝗲𝗮𝗹 𝗮 𝘀𝘁𝗿𝗶𝗸𝗶𝗻𝗴 𝗼𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗱𝗶𝘃𝗶𝗱𝗲. While 𝘀𝗵𝗶𝗽𝗽𝗶𝗻𝗴 𝘀𝗽𝗲𝗲𝗱𝘀 𝗮𝗿𝗲 𝗿𝗲𝗺𝗮𝗿𝗸𝗮𝗯𝗹𝘆 𝘀𝗶𝗺𝗶𝗹𝗮𝗿 𝗮𝗰𝗿𝗼𝘀𝘀 𝘁𝗵𝗲 𝗯𝗼𝗮𝗿𝗱, the 𝗿𝗲𝘁𝘂𝗿𝗻 𝗿𝗮𝘁𝗲 𝘃𝗮𝗿𝗶𝗲𝘀 𝘄𝗶𝗹𝗱𝗹𝘆, suggesting that 𝘁𝗵𝗲 𝗪𝗲𝘀𝘁 𝗿𝗲𝗴𝗶𝗼𝗻 𝗶𝘀 𝗳𝗮𝗰𝗶𝗻𝗴 𝗮 𝘀𝘆𝘀𝘁𝗲𝗺𝗶𝗰 𝗰𝗿𝗶𝘀𝗶𝘀 𝘁𝗵𝗮𝘁 𝘀𝗽𝗲𝗲𝗱 𝗮𝗹𝗼𝗻𝗲 𝗰𝗮𝗻𝗻𝗼𝘁 𝗳𝗶𝘅.

To 𝗶𝗻𝘁𝗲𝗿𝗿𝗼𝗴𝗮𝘁𝗲 𝘄𝗵𝘆 𝗖𝗮𝘀𝘀𝗮𝗻𝗱𝗿𝗮’𝘀 𝗦𝗼𝘂𝘁𝗵 𝗿𝗲𝗴𝗶𝗼𝗻 𝗶𝘀 𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗶𝗻𝗴 𝗮𝘁 𝘁𝗵𝗶𝘀 𝗴𝗼𝗹𝗱-𝘀𝘁𝗮𝗻𝗱𝗮𝗿𝗱 𝗹𝗲𝘃𝗲𝗹, we built a 𝗗𝗿𝗶𝘃𝗲𝗿 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱.

Cassandra’s success is not 𝗮 𝗿𝗲𝘀𝘂𝗹𝘁 𝗼𝗳 𝗮 “𝗹𝘂𝗰𝗸𝘆” 𝗶𝗻𝘃𝗲𝗻𝘁𝗼𝗿𝘆 𝗺𝗶𝘅. The evidence shows that 𝗖𝗮𝘀𝘀𝗮𝗻𝗱𝗿𝗮 𝗕𝗿𝗮𝗻𝗱𝗼𝘄 (𝗦𝗼𝘂𝘁𝗵) and 𝗞𝗲𝗹𝗹𝘆 𝗪𝗶𝗹𝗹𝗶𝗮𝗺𝘀 (𝗖𝗲𝗻𝘁𝗿𝗮𝗹) are 𝗼𝘂𝘁𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗶𝗻𝗴 𝗔𝗻𝗻𝗮 𝗔𝗻𝗱𝗿𝗲𝗮𝗱𝗶 (𝗪𝗲𝘀𝘁) across almost 𝗲𝘃𝗲𝗿𝘆 𝘀𝗶𝗻𝗴𝗹𝗲 𝗰𝗮𝘁𝗲𝗴𝗼𝗿𝘆, 𝗶𝗻𝗰𝗹𝘂𝗱𝗶𝗻𝗴 𝘁𝗵𝗲 𝗺𝗼𝘀𝘁 𝗵𝗶𝗴𝗵-𝗿𝗶𝘀𝗸 𝗼𝗻𝗲𝘀.

In the 𝗠𝗮𝗰𝗵𝗶𝗻𝗲𝘀 category (high-risk), 𝗔𝗻𝗻𝗮 𝗶𝘀 𝗹𝗼𝘀𝗶𝗻𝗴 𝟭 𝗼𝘂𝘁 𝗼𝗳 𝗲𝘃𝗲𝗿𝘆 𝟱 𝘂𝗻𝗶𝘁𝘀 𝘀𝗵𝗶𝗽𝗽𝗲𝗱. In contrast, 𝗞𝗲𝗹𝗹𝘆 𝗪𝗶𝗹𝗹𝗶𝗮𝗺𝘀 (𝗖𝗲𝗻𝘁𝗿𝗮𝗹) 𝗶𝘀 𝗹𝗼𝘀𝗶𝗻𝗴 𝗼𝗻𝗹𝘆 𝟮.𝟱%. Since the products are the same, 𝘁𝗵𝗲 𝗱𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝗰𝗲 𝗺𝘂𝘀𝘁 𝗹𝗶𝗲 𝗶𝗻:

𝗙𝘂𝗹𝗳𝗶𝗹𝗹𝗺𝗲𝗻𝘁 𝗤𝘂𝗮𝗹𝗶𝘁𝘆: 𝗕𝗲𝘁𝘁𝗲𝗿 𝗽𝗮𝗰𝗸𝗮𝗴𝗶𝗻𝗴 𝗼𝗿 𝗮𝘀𝘀𝗲𝗺𝗯𝗹𝘆 in the South and Central hubs.
𝗖𝘂𝘀𝘁𝗼𝗺𝗲𝗿 𝗘𝘅𝗽𝗲𝗰𝘁𝗮𝘁𝗶𝗼𝗻: Anna is likely 𝗼𝘃𝗲𝗿-𝗱𝗶𝘀𝗰𝗼𝘂𝗻𝘁𝗶𝗻𝗴 𝘁𝗵𝗲𝘀𝗲 𝗶𝘁𝗲𝗺𝘀 𝘁𝗼 𝘁𝗵𝗲 𝗖𝗼𝗻𝘀𝘂𝗺𝗲𝗿 𝘀𝗲𝗴𝗺𝗲𝗻𝘁, whereas Cassandra and Kelly 𝗺𝗮𝘆 𝗯𝗲 𝘀𝗲𝗹𝗹𝗶𝗻𝗴 𝘁𝗵𝗲𝗺 𝘁𝗼 𝗖𝗼𝗿𝗽𝗼𝗿𝗮𝘁𝗲 𝗰𝗹𝗶𝗲𝗻𝘁𝘀 𝘄𝗶𝘁𝗵 𝗺𝗼𝗿𝗲 𝘀𝘁𝗮𝗯𝗹𝗲 𝗿𝗲𝗾𝘂𝗶𝗿𝗲𝗺𝗲𝗻𝘁𝘀.