Assortment Planning the term Retailers use to describe the processes they use to determine what items in a range of products the would place in clusters or individual stores.
How does GIS help?
Level 1
Use demographic and lifestyle data to identify segments of customers in a market.
Create trade areas/catchment areas around locations to understand existing and potential customers in market.
Data enrichment around stores using segmentaiton and demographics provides attributes for store clustering activities
Level 2
Find correlations between sales performance at the category and item level, and store location centric attributes.
Mapping in competitive locations and analyzing the proximity to stores, create a better understanding of how the competition can impact category and item performance.
Use location attributes and geoenrichment to describe stores that are have simular selling attributes.
Crate mode advanced trade areas based on customer movement, drive times and geographic characteristics
Level 3
Use category sales and CRM/Location data to create category specific trade areas for stores with multiple departments.
Build sales models that incorporate geographic and product data to forecast sales.
Leverage ML and AI to find subtle correlations between large geographic data sets and store performance to feed models with more precise data.
What are the value statements?
I want to know who the customers that shop my stores are so I can curate the mix of products in my stores to be what they want.
I want to have curated assortments in my stores so I optimize my inventory reducing expenses and improving instocks
I want to have a better balance of inventory in my stores so I can grow sales on my best items.
I want to have adjust the facings on my planograms in my stores to match forecast demand so I can optimize inventory and drive sales.
I want to find the variables around my stores that are driving the correlations I find how my stores are selling items in an assortment.
I want to know how my competition is changing the way items are selling in my stores so I can create more precise forecasts.
I want to understand how my customers are interacting with my brand across all channels; digital and brick and mortar.
I want to better understand under-performing stores and what assortmetn changes might be needed to improve their performance.
Purchasing
Level 1
Visualize supplier locations
Calculate shipping time and costs
Product Design and Development
Level 1
Mine social media for trends
Visualize sales by location
Identify areas where trends emerge based on early sales
Sourcing and Raw Materials
Level 1
Visualize the source for raw materials
Visualize factory locations and routes from source to manufacturing
Level 2
Routing from source to factory to port/FOB destination
Live tracking of materials and product movement
Forecast ETAs
Model costs from specific locations
Model costing application?
Sales Planning
Level 1
Visualize sales
Temporal sales results to identify seasonal selling trends across the country
Use the data to plan seasonal rollouts
Sales trends by location- find geographic trends
Comp store sales by location
Sell through by location
Level 2
Model sales based on geographic characteristics
Weather
Trends
Competition
Move
Inventory Planning
Key Usage Patterns with GIS
Level 1
Visualize forecast demand my location- see patterns
Visualise inventory in the supply chain
Level 2
Forcast and update real time leadtimes
Preclear inventory through customs- scheduling and routing
Fulfillment
Key Usage Patterns with GIS
Level 1
Find inventory in the enterprise and route to a give location (Home, store etc)
Level 2
Home Delivery
Key Usage Patterns
Level 1
Routing drivers
Simple order prioritization (Store specific)
Destination based order optimization
Manage delivery windows
Simple Asset Tracking - where are my trucks?
Geocoding addresses
Level 2
Territory management
Recommend delivery windows
Manage field workforce
Enterprise order prioritization - Managed fulfillment locations
Advanced asset tracking- updated and forecasted delivery windows
Replenishment
Level 1
Calculate most efficient shipping methodology
Cost
Time
Supply chain management
Level 1
Manage and forecast supply chain disruption
Asset Tracking- Trucks, containers, items
Level 2
Create updated ETA Forecasts
Track products in route- amount and location
Forecast arrival dates and times
Optimize supply chain - connect stores and Distribution centers
Support for Customs clearance- pre-clearance
Marketing
Level 1
Creating market area maps with demographic and segmentation data
Campaign effectiveness reporting
Geocoding addresses
Customer relationship management
Level 2
Targeted campaign activities based on customer profiles
Level 3
Tracking mobile interactions- correlate with locations
Sell
Pricing
Level 1
Visualize pricing by item across a geography
Where did I price high/low
Location of competition relative to store locations
What stores are in more competitive areas than others?
Correlate pricing with proximity to stores
Level 2
Correlation of sales with pricing by location
Probably not a realistic use case given the capabilities of category killers in teh market place
Presentation (Store Space Management)
Level 1
Find target customers based on demographic and lifestyle attributes
Create trade areas and understand the population with in a trade area
Enrich locations with population/lifestyle data
Level 2
Indoor Mapping- Store hot spot analysis- where is my valuable space
Subtopic 2
Promotion management
Level 1
Sales/Promotion performance visualzation
Where did the promotion work/not work
Sales price visualization
Ad patch visualzation
Level 2
Correlation between ad performance and promotional activity and geography
Where did ads preform well? Are there geographic patterns that can be correlated to ad performance?
Enable
Business Intelligence
Level 1
Pesonalization
Segmentation
Target customer identification
Geographic correlation analysis
Level 2
Modeling store performance
Building user facing apps for the organization
Level 3
Advanced modeling and forecasting
Indoor Mapping
No Level
Aggregate and visualize customer movement over time
Locate product in a store, route people to the product
Location based engagement of customers and employees (Geofencing)
Proximity Marketing- Offers based on location
Task management- routing employees in store
Item Management
CRM Management
Level 1
Visualization of CRM- where do my customers live
Connect Customer home/work/shopping locations to develop path to purchase stories
Understand customer density in trade areas
Geocoding addresses
Site Selection
Level 2
Personalized data management
Market Planing/Site Selection
Level 1
Create a trade area and aggregate exiting data in the area
Find target customers in a market/number of markets
Visualize competitive presence in a market
Level 2
Analyze proprietary data in analysis
Incorporate field data (Photos, broker data)
Correlate store performance with geographic attributes to predict outcomes
Subtopic 1
Level 3
Modeling to forecast sales based on multiple attributes
Real Estate
Level 1
Create market analysis for new stores
Competition locations
Customer Density from CRM
Traffic patterns
Potential Customers- demographic and lifestyle profiles
Lease Management
Evaluating lease renewals
Level 2
Store Fleet optimization
Model impact of store closings on total market performance
Transfer sales to remaining stores
Cost Savings
Store Closing Criteria
Field data gathering
Collector to gather and record data from the field
Segmentation
Level 1
Find patterns in demographic data
Find targeted concentrations of people
Level 2
Correlate attributes and sales/product performance