Quorso_UseCase_DataRequest_Meijer.xlsx

	B	C	D	E	F
1
2	Sample Use Cases for Meijer RFI
3	Quorso Use Cases for Retailers - Confidential - Do Not Share
4
7
8	Category	Name	Task/Alert/Opportunity	Tell me if a store has...	Logic (Baseline)
9	Sales
10		Sales Performance	Opportunity	…underperformed in sales in a specific subcategory relative to comparable stores	If store is underperforming in [sales value] to [peer baseline] in [sub-category X]
11		POG sales	Alert	…underperformed in sales relating to a specific POG relative to comparable stores	If store has sold [0] in [SKU] associated with [POG X]
12		Top Performing SKUs	Opportunity	...underperformed in sales relating to a specific SKU relative to comparable stores	if store is underperforming in [sales value] to [peer baseline] in [top selling SKU]
13		Promotion Sales	Alert	…underperformed in sales relating to a specific promotion relative to comparable stores	If store has sold [0] in [SKU] associated with [Promotion X]
14		Attachment (maximiser)	Opportunity	...underperformed in certain top selling, high margin SKUs relative to comparable stores, where there is an option to cross-promote with another high margin top selling category	if store is underperforming to [peer baseline] in [top selling, high margin SKU] AND [top selling, high margin SKU] has strong LIFT with [sub-category]
15		Market share	Opportunity	...underperformed in market share relative to comparable stores	If store is underperforming in [market share] to [peer baseline] in [sub-category x]
16		Footfall	Opportunity	...underperformed in footfall relative to comparable stores	If store is underperforming in [footfall] to [peer baseline]
17		Conversion	Opportunity	...underperformed in conversion rate (transactions / footfall) relative to comparable stores	If store is underperforming in [conversion rate] to [peer baseline]
18		Refunds and exchanges	Opportunity	...outperformed in refunds and exchanges as a share of sales relative to comparable stores	If store is outperforming in [refunds and exchanges] to [peer baseline]
19	Product and pricing
20		New product launch	Task	...an upcoming new product launch to prepare for	If store is on [upcoming new product launch list]
21		New product launch: no sales	Alert	...no sales on certain focus SKUs in a product launch	If store has sold [0] in [SKU] associated with [Focus SKU list for product launch]
22		New planogram launch	Task	...an upcoming new planogram update to launch	If store is on [upcoming new planogram launch]
23		Pricing refresh	Task	...an upcoming pricing refresh on certain product lines	If store is on [upcoming new pricing refresh]
24		New promotional launch	Task	...an upcoming promotion to prepare for	If store is [on upcoming promotion]
25	Inventory Management
26		Known Loss	Opportunity	...has greater loss or damages in a specific subcategory relative to comparable stores	if store is over/underperforming in [loss or damages sales value] to [peer baseline]
27		Negative inventory	Alert	...has greater number of categories with negative inventory relative to comparable stores	If store has [<0] [on hand inventory] in [SKU X] everyday over last [7 days]
28		Phantom inventory	Alert	...has low numbers of inventory on hand which are not reducing in subcategories or SKUs which are fast selling goods at comparable stores	If store has [0] sales of [SKU X] for [>30 days] where [OH inventory] is [1-2] and [>90%] of [stores in same region] has sold [>0]
29		Inventory build	Alert	...has inventory which is growing to levels based on rate of sale, on hands and goods due that are above a certain threshold	If store has [Inventory Build Threshold X] which is less than Y, where Y is [Current inventory] + [Goods due to be received] in [Time period] - [Rate of sale] * [Days in Time Period]
30		No write offs	Alert	...has not written off a particular subcategory in the past defined period where comparable stores have (at a certain threshold)	If store has [0] in [Write-offs] in [subcategory X], where X has [Write-off Value in period] > [Threshold]
31		Cyclical out of stock	Alert	...has run out of stock in a subcategory in consecutive weeks, and is expected to continue to be out of stock	If store has [0] in [On hand inventory] in [subcategory X] for [>2] days in [3] consecutive weeks
32		Inventory audit required	Task	...an upcoming inventory audit required	If store is on [upcoming inventory audit list]
33		Stock count required	Task	...an upcoming stock count required	If store is on [upcoming stock count list]
34		Gap scan required	Task	...an upcoming gap scane required	If store is on [upcoming gap scan list]
35	Associate Relations
36		New manager training	Task	...a new manager that needs to be trained	If new store manager has [start date] in last [14] days
37		Cashier training	Task	...not completed the required cashier trainings for its cashier staff	If store has completed [0] [cashier training completions] over last [14] days
38		Associate work anniversary	Task	...an associate with a meaningful work anniversary (e.g 5, 10, 15 years...)	If store has manager/associate with [work anniversary] in next [7 days]
39		Performance reviews overdue	Alert	...a store manager or store associate for whom I have not completed the annual performance review	If store has manager or associate with [performance review date] overdue by [30 days]
40		ESAT	Alert	…employee satisfaction scores that are below target, between 1 and x times in a row, OR which is low relative to comparable stores	If store received [>5] survey response scores of [<4] over last [30 days] related to [ESAT]
41		Performance mgmt	Task	...associates who are due for a performance review	If store has manager/associate with [performance review date] due in next [7 days]
42		Churn risk	Alert	...associates who are at high churn risk based on scheduling behaviour or other labour inidcators	if store has [>0] associates who have a [churn risk score] [>5]
43	Labor
44		Associate productivity	Alert	…a ratio of scheduled hours to actual transactions that is either too high or too low at various points in the day	if store has [>3] days in last 14 days where [scheduled hours] : [transactions (or sales) volume] that is [>1.5x] average ratio across day
45		Schedule submission	Alert	...consistently submitted a late labor schedule	if store has [>3] [late labor schedule submissions] in last [60 days]
46		Overtime	Alert	...consistently staffed associates passed the accceptable overtime threshold	if store has [>3] associates with [overtime hours] [>10] in last [30 days]
47		No Shows	Alert	...associates who have had a number of no shows above a threshold within a set period	if store has [>3] associates who have [number of no shows] [>3]
48		Critical staffing	Alert	...critical open positions greater than an acceptable threshold	if store has [>5] [critical open positions] at any time
49		Budget adherence	Alert	...actual labor or scheduled labor hours above or below certain thresholds vs budget; or show repeat offence	if store has [>3] days in last 7 days where [scheduled hours] : [budgeted hours] is outside [1.1 - 0.9x] threshold
50	Operational
51		Operating Hours Violations	Alert	...a number of days with operating hours violations that is above a threshold	if store has [>3] [operating hours violations] in last [14 days]
52		Maintenance requests	Alert	...end of life assets that are disrupting critical business operations	if store has [>0] [end of life / broken assets]
53		Associate accidents	Alert	...above average associate accidents over a given time frame	If store recorded [>0] employee accident reports over last [14 days]
54		Task compliance	Alert	...a number of tasks which are past due date which is above a threshold	if store has [>5] tasks which are past [task completion date]
55		Queue length	Alert	...an average queue length which is above a certain threshold	if store has [average queue length] which is above theshold [x mins] for [x] consecutive days
56		Aging EBRs	Alert	...a number of outstanding EBR violations that had aged	if store has [>3] [aged EBR violations]
57		Missing EBRs	Alert	...a number of missing EBRs	if store has [>3] [missing EBRs]
58		Open EBRs	Alert	...a number of outstanding EBR violations that are open	if store has [>3] [aged EBR violations]
59	Omnichannel
60		BOPIS cancellations	Alert	...a ratio of BOPIS order cancellations that is above a threshold	if store has [>0] [cancelled BOPIS orders] over last [14] days
61		Pick Declines	Alert	...a ratio of declined store picks for orders that is above a threshold	if store has [X%] [declined picks for BOPIS orders]
62		Pick Rate	Opportunity	...a number of orders per hour which is low relative to comparable stores OR a threshold	if store is underperforming in [BOPIS orders] relative to [peer baseline]
63		Time to order completion	Opportunity	...a time to order completion which is high relative to comparable peer stores OR a threshold	if store is underperforming in [time to order completion] relative to [peer baseline]
64		Loyalty sign-ups	Opportunity	...a ratio of loyalty program sign-ups to transaction ratios lower than comparable stores	if store is underperforming in [loyalty sign ups] : [transactions] relative to [peer baseline]
65		Credit card program sign ups	Opportunity	...a ratio of credit card sign-ups to transaction ratios lower than comparable stores	if store is underperforming in [credit card sign ups] : [transactions] relative to [peer baseline]
66	Other Compliance Tasks
67		DM Store Walks	n/a	...a DM store walk scheduled, and show me the top priorities to review based on value	n/a
68		Safety Audit	Task	...a safety audit overdue	if store has [safety audit] past [due date]
69	Replenishment / Stock
70		Goods In Receipt	Task	....is due to receive an upcoming delivery of goods	if store has [delivery of goods date] in next [3] days
71		Store facing refresh	Task	...is due to refresh store facings	if store has [store facings refresh] in next [3] days
72		Replenishment	Task	...is due to replenish front of house	if store has [replenish front of house] in next [3] days
73	Urgent alerts
74		No sales	Alert	...has no sales for by a certain time	if store has [sales value] = [0] at [Midday]
75	Survey results
76		OSAT	Alert/Opportunity	...an OSAT score which is below target, between 1 and x times in a row OR which is low relative to comparable stores	If store received [>5] survey response scores of [<4] over last [30 days] related to [OSAT]
77		CSAT	Alert/Opportunity	...a CSAT score which is below target, between 1 and x times in a row OR which is low relative to comparable stores	If store received [>1] survey response scores of [<4] over last [30 days] related to [CSAT]
78		Store cleanliness	Alert	...a Cleanliness audit score which is below target, between 1 and x times in a row, OR which is low relative to comparable stores	If store received [>10] survey response scores of [<4] over last [30 days] related to [store cleanliness audit]
79	Other
80		New Store Project (1-10 weeks out)	Task	...an upcoming new store launch in the next 10 weeks, and show the steps required to take each 2 weeks	If store has [opening date] in [< 10 weeks]
81		New Store Soft Opening	Task	...an upcoming new store launch soft opening, and show the steps required to take	If store has [soft opening date] in [<2 weeks]
82		Relocation (1-4 weeks out)	Task	...an upcoming store relocation required in the next 4 weeks, and show the steps required to take each 2 weeks	If store has [relocation date] in [<2 weeks]
83		Remodel Project	Task	...an upcoming remodelling project in the next 4 weeks, and show necessary actions	If store has [remodelling date] in [<2 weeks]
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102