Certified Retail Analyst (CRA) — Questions and Answers

Question 1: A retailer is standardizing its inventory counting procedures. What is the best practice for conducting a physical inventory count?

Freeze inventory transactions, count systematically by location, and reconcile to system records (Correct answer)
Use last year's count as a baseline and adjust for estimated receipts and sales
Count during peak shopping hours to capture live inventory movement
Count only high-value items to save time and resources

Correct answer: Freeze inventory transactions, count systematically by location, and reconcile to system records

Freezing transactions, counting by location, and reconciling to system records ensures accuracy and allows meaningful identification of variances.

Question 2: Retail Link's CPFAR (Collaborative Planning, Forecasting, and Replenishment) module primarily facilitates:

Competitive benchmarking of category sales across retailers
Joint demand forecasting and replenishment planning between Walmart and suppliers (Correct answer)
Automated invoice reconciliation between the supplier and Walmart AP
Real-time markdown optimization for slow-moving SKUs

Correct answer: Joint demand forecasting and replenishment planning between Walmart and suppliers

CPFAR enables suppliers and Walmart to collaborate on shared sales forecasts and replenishment plans to improve supply chain efficiency.

Question 3: How can supply chain disruptions affect retail businesses?

Supply chain disruptions are beneficial for retail businesses.
Supply chain disruptions only affect manufacturers.
Supply chain disruptions have no impact on retail businesses.
Supply chain disruptions can lead to stockouts and increased costs (Correct answer)

Correct answer: Supply chain disruptions can lead to stockouts and increased costs

Supply chain disruptions, such as natural disasters, geopolitical events, or unexpected demand surges, interrupt the flow of goods from suppliers to customers. For retailers, this can result in empty shelves (stockouts), lost sales, and frustrated customers. Furthermore, businesses often incur increased costs due to expedited shipping, sourcing alternative suppliers, or managing excess inventory from delayed shipments.

Question 4: The Retail Link 'Open Purchase Order' report helps suppliers identify:

Categories where Walmart is soliciting new vendor bids
Orders placed by Walmart that have not yet been received at the DC or store (Correct answer)
Pending chargebacks that have not been disputed within the allowance window
Items that have been marked for deauthorization by the buyer

Correct answer: Orders placed by Walmart that have not yet been received at the DC or store

The Open Purchase Order report shows purchase orders Walmart has issued to the supplier that remain outstanding and have not yet been received.

Question 5: A supplier notices that Retail Link shows 'On Order' units for their item but On Hand has not increased after the expected delivery window. This discrepancy most likely indicates:

Walmart cancelled the purchase order but Retail Link has a 48-hour update delay
Retail Link rounds On Order units to the nearest case pack
The item was substituted for a different SKU during the pick process
The shipment was received but not yet processed through the DC or store receiving system (Correct answer)

Correct answer: The shipment was received but not yet processed through the DC or store receiving system

If On Order units exist but On Hand has not updated, the goods likely arrived but have not yet been scanned and processed through Walmart's receiving system.

Question 6: Which of the following is a characteristic of 'everyday low pricing' (EDLP)?

Consistently low prices with minimal reliance on temporary promotions (Correct answer)
Dynamic pricing adjusted hourly based on demand algorithms
Frequent promotional markdowns and high-low price swings
Premium pricing to reinforce a luxury brand image

Correct answer: Consistently low prices with minimal reliance on temporary promotions

EDLP strategies maintain stable, competitive prices year-round rather than cycling between regular and sale prices.

Question 7: A CRA analyst reviews a store's contribution margin. What does this metric represent?

Net profit after taxes
Total gross sales minus returns
Revenue minus all fixed costs
Revenue minus variable costs, showing profit available to cover fixed costs (Correct answer)

Correct answer: Revenue minus variable costs, showing profit available to cover fixed costs

Contribution margin is revenue minus variable costs, indicating how much each sale contributes toward covering fixed costs and generating profit.

Question 8: A retail analyst reviews a dashboard showing 'session duration' and 'bounce rate.' What type of platform generates these metrics?

Web analytics platform (e.g., Google Analytics) (Correct answer)
Supply chain visibility tool
Workforce scheduling software
Inventory management system

Correct answer: Web analytics platform (e.g., Google Analytics)

Session duration and bounce rate are website traffic metrics tracked by web analytics platforms that measure how visitors interact with e-commerce sites.

Question 9: What is 'dead stock' and why is it a financial concern for retailers?

Clearance items priced below cost; they improve cash flow
Returned merchandise; it increases processing expenses
Products discontinued by vendors; they require sourcing alternatives
Inventory that has not sold for an extended period; it ties up capital and incurs holding costs (Correct answer)

Correct answer: Inventory that has not sold for an extended period; it ties up capital and incurs holding costs

Dead stock is unsold inventory that consumes warehouse space and working capital without generating revenue, reducing overall financial performance.

Question 10: Which metric best measures how efficiently a retailer converts customer visits into purchases?

Basket size
Traffic index
Average transaction value
Conversion rate (Correct answer)

Correct answer: Conversion rate

Conversion rate is the percentage of store visitors who complete a purchase, directly measuring sales effectiveness per visit.

Question 11: A retailer's gross margin is 42% and its operating expense ratio is 38%. What is its operating margin?

6%
80%
2%
4% (Correct answer)

Correct answer: 4%

Operating margin equals gross margin minus operating expense ratio: 42% - 38% = 4%.

Question 12: A CRA professional encounters an unfamiliar situation while performing fundamentals & core concepts duties. What is the most appropriate first action?

Proceed based on general assumptions to avoid delays
Skip the task entirely and move to the next assignment
Apply a solution from an unrelated field without verification
Consult relevant standards, guidelines, or a qualified supervisor before proceeding (Correct answer)

Correct answer: Consult relevant standards, guidelines, or a qualified supervisor before proceeding

When facing unfamiliar situations in fundamentals & core concepts, the most appropriate action is to consult relevant standards, guidelines, or a qualified supervisor. This ensures safety, accuracy, and compliance while building professional knowledge.

Question 13: Which customer segmentation model divides shoppers based on Recency, Frequency, and Monetary value?

RFM analysis (Correct answer)
NPS segmentation
Cohort analysis
ABC classification

Correct answer: RFM analysis

RFM analysis segments customers by how recently they purchased, how often, and how much they spend to identify high-value shoppers.

Question 14: In heatmap analysis of store layouts, what does a 'cold zone' represent?

Refrigerated product sections
Promotional end-caps
High-velocity SKU locations
Areas with very low shopper traffic or dwell time (Correct answer)

Correct answer: Areas with very low shopper traffic or dwell time

Cold zones are store areas that receive minimal foot traffic, signaling opportunities to reposition products or improve signage.

Question 15: Which pricing strategy sets prices based on what competitors charge for similar products?

Value-based pricing
Competitive pricing (Correct answer)
Cost-plus pricing
Psychological pricing

Correct answer: Competitive pricing

Competitive pricing benchmarks prices against competitors to stay in line with or undercut the market, regardless of internal costs.

Question 16: In retail financial planning, 'comp store sales' (same-store sales) growth is used to:

Calculate the return on new store capital investment
Track promotional lift versus the prior week's baseline
Evaluate organic sales performance by comparing stores open for at least one year (Correct answer)
Measure total revenue growth including new store openings

Correct answer: Evaluate organic sales performance by comparing stores open for at least one year

Comp store sales isolate the performance of existing stores to show organic growth, excluding the distorting effect of new store openings.

Question 17: How do retailers use data to optimize customer experiences?

Customer experiences are irrelevant to data management.
Data helps retailers personalize experiences and build customer loyalty (Correct answer)
Data does not impact customer experiences.
Data only affects product pricing.

Correct answer: Data helps retailers personalize experiences and build customer loyalty

Retailers collect and analyze data on customer preferences, purchase history, and browsing behavior. This information allows them to personalize marketing messages, recommend relevant products, offer tailored promotions, and create customized shopping experiences. Personalization fosters a stronger connection with customers, enhancing satisfaction and building long-term loyalty, which is crucial for sustained business growth.

Question 18: How can real-time data improve retail decision-making?

Real-time data increases decision-making delays.
Real-time data is not useful for retail decision-making.
Real-time data enables quick, informed decisions that improve operational efficiency (Correct answer)
Real-time data only applies to digital marketing.

Correct answer: Real-time data enables quick, informed decisions that improve operational efficiency

Real-time data provides immediate insights into current sales, inventory, customer interactions, and operational performance. This instant visibility allows retailers to identify issues, capitalize on opportunities, and make agile decisions without delay. Such responsiveness significantly improves operational efficiency, enhances customer satisfaction, and contributes to overall business performance by enabling quick, informed actions.

Question 19: A retail analyst notices a high browse-to-buy ratio online. What does this indicate?

High average order value
Shoppers visit but do not complete purchases (Correct answer)
Low product return rates
Strong customer loyalty

Correct answer: Shoppers visit but do not complete purchases

A high browse-to-buy ratio signals friction in the purchase funnel, such as price, UX issues, or lack of trust signals.

Question 20: What are key factors that influence consumer buying decisions in retail?

Price, quality, brand reputation, and convenience influence buying decisions (Correct answer)
Consumer buying decisions are irrelevant to retail strategy.
Only price affects consumer buying decisions.
Consumer buying decisions are only influenced by advertising.

Correct answer: Price, quality, brand reputation, and convenience influence buying decisions

Consumer buying decisions in retail are influenced by a combination of factors. Price determines affordability and perceived value, while quality assures satisfaction and durability. Brand reputation builds trust and loyalty, and convenience, such as location or ease of purchase, significantly impacts the overall shopping experience. These elements collectively shape a consumer's choice and are crucial for retailers to consider.

Question 21: What role does supply chain management play in data management?

Supply chain management relies on data for inventory optimization and delivery efficiency (Correct answer)
Supply chain management only applies to manufacturing.
Supply chain management is not affected by data management.
Supply chain management reduces product quality.

Correct answer: Supply chain management relies on data for inventory optimization and delivery efficiency

Supply chain management heavily depends on accurate and timely data to function effectively. Data on inventory levels, order fulfillment, shipping logistics, and supplier performance is crucial for optimizing stock, minimizing lead times, and ensuring efficient delivery of products. Without robust data, supply chains would be inefficient, prone to disruptions, and unable to meet customer demands reliably.

Question 22: How can data analysis improve retail pricing strategies?

Data analysis has no impact on pricing strategies.
Data analysis helps optimize pricing strategies based on customer behavior and demand (Correct answer)
Data analysis increases operational costs.
Pricing strategies are only influenced by competition.

Correct answer: Data analysis helps optimize pricing strategies based on customer behavior and demand

Data analysis allows retailers to examine sales trends, customer purchasing patterns, competitor pricing, and market elasticity. By leveraging these insights, businesses can dynamically adjust prices to maximize revenue, offer competitive deals, and respond effectively to changes in demand or market conditions. This data-driven approach moves beyond intuition to create more effective and profitable pricing strategies.

Question 23: In retail, what does 'return on investment' (ROI) for a promotional event measure?

Total units sold during the event
Percentage increase in store traffic
Net profit generated by the promotion relative to its cost (Correct answer)
Number of new customers acquired

Correct answer: Net profit generated by the promotion relative to its cost

Promotional ROI compares the incremental net profit earned during a promotion to the cost of running it, expressed as a percentage.

Question 24: In Retail Link, 'Vendor Stock Number' (VSN) is best described as:

A temporary SKU assigned during the new item setup review process
Walmart's internal item number used across all systems
The UPC barcode number scanned at point of sale
The supplier's own item identifier mapped to Walmart's catalog (Correct answer)

Correct answer: The supplier's own item identifier mapped to Walmart's catalog

The Vendor Stock Number is the supplier's internal item code that Walmart associates with its own item number in Retail Link to facilitate data cross-referencing.

Question 25: What does 'trip mission' segmentation help retailers understand?

Why a shopper visits the store and what they intend to buy (Correct answer)
Delivery route optimization
Vendor lead times
Employee commute patterns

Correct answer: Why a shopper visits the store and what they intend to buy

Trip mission segmentation categorizes shoppers by their visit intent (e.g., quick fill-in, stock-up, browse) to tailor assortment and layout.

Question 26: A CRA analyst exports Retail Link data to Excel and notices store numbers appear as leading-zero values (e.g., 0441). Which Excel behavior should they account for?

Excel cannot import Retail Link CSV files with more than 10,000 store rows
Excel auto-sorts leading-zero store numbers alphabetically, not numerically
Excel may strip leading zeros when formatting cells as General or Number type (Correct answer)
Retail Link encrypts store numbers in exports to prevent competitive intelligence

Correct answer: Excel may strip leading zeros when formatting cells as General or Number type

Excel's default General format drops leading zeros from numeric-looking values, so store number '0441' would display as '441' unless the column is pre-formatted as Text.

Question 27: Keystone pricing in retail refers to which of the following methods?

Marking up the wholesale cost by 100% to set retail price (Correct answer)
Using psychological pricing endings such as $0.99
Pricing products below cost to drive traffic
Setting price equal to the competitor's lowest price

Correct answer: Marking up the wholesale cost by 100% to set retail price

Keystone pricing doubles the wholesale cost (100% markup), resulting in a 50% gross margin, which is a common retail baseline.

Question 28: Why is data integration important for retailers in the retail link system?

Data integration is only needed for large retailers.
Data integration is not necessary in retail management.
Data integration reduces efficiency.
Data integration ensures consistency across business systems and improves decision-making (Correct answer)

Correct answer: Data integration ensures consistency across business systems and improves decision-making

Data integration involves combining data from various disparate sources within a retail organization, such as POS systems, inventory management, and CRM. This creates a unified and consistent view of information, eliminating data silos and providing a holistic understanding of operations. Integrated data leads to more accurate analyses and better-informed strategic decisions across the entire business.

Question 29: A Retail Link user receives an 'Access Denied' error when attempting to run a report on a specific category. The most common reason is:

The user's supplier account does not have authorization for items in that category (Correct answer)
The category's data is under a 90-day embargo following a planogram reset
The report template requires a paid Retail Link Premium subscription
The category was discontinued by Walmart and archived from Retail Link

Correct answer: The user's supplier account does not have authorization for items in that category

Retail Link access is supplier-specific; users can only view data for categories and items their company is authorized to sell.

Question 30: What is 'market basket analysis' used for in retail?

Identifying products frequently purchased together (Correct answer)
Measuring store square footage efficiency
Forecasting seasonal demand peaks
Evaluating supplier performance

Correct answer: Identifying products frequently purchased together

Market basket analysis mines transaction data to find product associations, informing cross-merchandising and promotional bundling strategies.

Question 31: Which tool is commonly used by retail analysts to visualize customer journey touchpoints?

Gantt chart
Fishbone diagram
Customer journey map (Correct answer)
Kanban board

Correct answer: Customer journey map

A customer journey map visualizes all touchpoints a shopper experiences from awareness through purchase and post-sale service.

Question 32: The 'halo effect' in retail analytics describes a situation where:

A loyalty member spends more than an average customer
A promotional discount increases overall basket size
A promoted item drives incremental sales of related non-promoted items (Correct answer)
A store's layout influences dwell time

Correct answer: A promoted item drives incremental sales of related non-promoted items

The halo effect occurs when promoting one product positively impacts sales of complementary or adjacent products.

Question 33: Which metric evaluates profitability per unit of selling space?

Net present value
Gross margin return on inventory investment
Return on assets
Sales per square foot (Correct answer)

Correct answer: Sales per square foot

Sales per square foot measures revenue generated per unit of retail floor space, helping assess space productivity.

Question 34: Which of the following represents a best practice for managing the category review calendar?

Stagger category reviews across the year aligned to seasonal buying cycles and vendor negotiations (Correct answer)
Review categories only when performance issues are flagged
Conduct all category reviews in the same month to consolidate planning efforts
Assign all category reviews to a single analyst to ensure consistency

Correct answer: Stagger category reviews across the year aligned to seasonal buying cycles and vendor negotiations

Staggering reviews aligned to buying cycles and vendor negotiations ensures timely decisions and maximizes leverage in supplier discussions.

Question 35: What is the primary purpose of A/B testing in retail analytics?

Testing two versions of an experience to determine which drives better outcomes (Correct answer)
Comparing two supplier contracts
Matching SKUs across two planograms
Auditing two store locations simultaneously

Correct answer: Testing two versions of an experience to determine which drives better outcomes

A/B testing exposes two customer groups to different experiences and measures which version achieves higher conversion, revenue, or engagement.

Question 36: What is 'share of wallet' in consumer behavior analysis?

Credit card penetration among loyalty members
Percentage of category spending a customer gives to one retailer (Correct answer)
Total household income spent on groceries
Coupon redemption rate

Correct answer: Percentage of category spending a customer gives to one retailer

Share of wallet measures what portion of a customer's total category spend is captured by a specific retailer versus competitors.

Question 37: Which technology enables retailers to automatically reorder inventory when stock falls below a predefined threshold?

Periodic cycle counting
Manual purchase orders
Automated replenishment systems (Correct answer)
Vendor-managed inventory audits

Correct answer: Automated replenishment systems

Automated replenishment systems use real-time stock data to trigger purchase orders when inventory reaches reorder points.

Question 38: What are the benefits of using technology in supply chain management?

Technology increases operational costs.
Technology has no benefits in supply chain management.
Technology only applies to online retailers.
Technology improves efficiency, accuracy, and decision-making in the supply chain (Correct answer)

Correct answer: Technology improves efficiency, accuracy, and decision-making in the supply chain

Technology, such as supply chain management software, IoT, and AI, automates processes, provides real-time data, and enhances visibility across the entire supply chain. This leads to more efficient operations, reduces human error in tasks like inventory tracking and order fulfillment, and provides valuable insights for strategic decision-making. Ultimately, technology helps optimize resource allocation and respond faster to market changes.

Question 39: When conducting a workplace violence risk assessment for a retail environment, which employee group typically faces the HIGHEST exposure risk?

Loss prevention officers during office hours
Customer-facing cashiers and service desk staff (Correct answer)
District managers who travel between locations
Back-of-house stockroom associates

Correct answer: Customer-facing cashiers and service desk staff

Cashiers and service desk staff have the most frequent direct customer interaction, placing them at highest exposure to verbal and physical confrontations.

Question 40: A retailer operating with an 'everyday low price' (EDLP) strategy primarily benefits from:

Achieving higher margins during peak demand periods
Reducing operational complexity and building customer trust through price consistency (Correct answer)
Generating excitement through frequent promotional events
Driving traffic spikes on specific promotional days

Correct answer: Reducing operational complexity and building customer trust through price consistency

EDLP simplifies operations by eliminating frequent promotions, reducing inventory volatility, and building customer loyalty through predictable, stable pricing.

Question 41: In the context of retail demand forecasting, 'cannibalization' occurs when:

A vendor reduces supply to inflate prices
A competitor's promotion erodes the retailer's market share
A new product reduces sales of an existing product in the retailer's own assortment (Correct answer)
Overstocked items are sold below cost

Correct answer: A new product reduces sales of an existing product in the retailer's own assortment

Cannibalization happens when a new or promoted item takes sales away from another item the same retailer already sells.

Question 42: Which OSHA standard is most directly applicable to retail store associates who handle chemical cleaning products?

OSHA 1910.1200 – Hazard Communication (HazCom) (Correct answer)
OSHA 1910.147 – Lockout/Tagout
OSHA 1910.303 – Electrical Standards
OSHA 1910.36 – Emergency Action Plans

Correct answer: OSHA 1910.1200 – Hazard Communication (HazCom)

HazCom (the Right-to-Know standard) requires safety data sheets and proper labeling for all hazardous chemicals used in the workplace.

Question 43: A retailer's shrink rate increased from 1.2% to 2.1% of sales year-over-year. Which supply chain function is most directly responsible for investigating internal shrink at the DC?

Loss prevention / asset protection (Correct answer)
Transportation management
Demand planning
Category management

Correct answer: Loss prevention / asset protection

Loss prevention (asset protection) investigates and mitigates shrink caused by theft, damage, or administrative error at both store and DC levels.

Question 44: Which analysis technique compares purchasing behavior of customers grouped by their first purchase date?

RFM analysis
Pareto analysis
SWOT analysis
Cohort analysis (Correct answer)

Correct answer: Cohort analysis

Cohort analysis tracks groups of customers who share a common characteristic over time, such as their acquisition date.

Question 45: A retail analyst reviews 'conversion rate' data in a digital marketing dashboard. What does a 2% conversion rate indicate?

2% of email subscribers opened the message
2% of website visitors are returning customers
2% of products are out of stock
2% of website visitors completed a purchase (Correct answer)

Correct answer: 2% of website visitors completed a purchase

Conversion rate measures the percentage of website visitors who complete a desired action—typically a purchase—out of total sessions.

Question 46: A retailer's operating expense ratio increased while revenue was flat. What is the likely financial impact?

Higher inventory turnover
Improved net income
Compressed operating profit margins (Correct answer)
Reduced cost of goods sold

Correct answer: Compressed operating profit margins

When operating expenses grow as a share of flat revenue, operating profit margins shrink because costs are consuming more of each sales dollar.

Question 47: In retailing, the term 'shrinkage' refers to:

Reduction in store square footage
Seasonal markdown of slow-moving merchandise
Inventory loss from theft, damage, or administrative error (Correct answer)
Decline in customer foot traffic

Correct answer: Inventory loss from theft, damage, or administrative error

Shrinkage is the difference between recorded inventory and actual on-hand inventory, caused by shoplifting, employee theft, vendor fraud, or errors.

Question 48: When analysts refer to a retailer's 'assortment breadth,' they mean:

The number of units held per SKU
The total number of distinct product categories carried (Correct answer)
The depth of inventory for a single category
The price range from lowest to highest SKU

Correct answer: The total number of distinct product categories carried

Assortment breadth refers to the number of different product categories or lines a retailer offers, as opposed to depth which is the number of options within a category.

Question 49: A supplier's item shows high POS sales but consistently low On Hand units in Retail Link. The most likely operational cause is:

Markdown pricing has temporarily inflated unit velocity
The item's case pack size is too large for store backrooms
Replenishment orders are not being generated frequently enough to keep pace with velocity (Correct answer)
Walmart buyers have reduced the item's authorized facing count

Correct answer: Replenishment orders are not being generated frequently enough to keep pace with velocity

When sales velocity outpaces replenishment frequency, on-hand inventory depletes quickly, indicating an under-replenishment issue.

Question 50: The 'long tail' concept in retail assortment planning suggests that:

A few top-selling SKUs generate the majority of revenue
Seasonal products have a long sell-through window
Deep discounts on slow movers extend the product lifecycle
A large number of niche products can collectively rival the sales of bestsellers (Correct answer)

Correct answer: A large number of niche products can collectively rival the sales of bestsellers

The long tail theory holds that, especially in e-commerce, many low-volume niche items can collectively generate significant revenue comparable to top sellers.

Question 51: What role does product pricing play in retail strategy?

Pricing should only be based on competition.
Product pricing is irrelevant to retail strategy.
Product pricing influences demand, value, and profitability (Correct answer)
Pricing is a fixed aspect in retail strategy.

Correct answer: Product pricing influences demand, value, and profitability

Product pricing is a critical strategic lever in retail because it directly impacts consumer demand, perceived value, and the business's profitability. Setting the right price is essential for attracting customers, covering costs, and achieving desired profit margins. An effective pricing strategy considers market conditions, competitor pricing, and customer willingness to pay, making it a cornerstone of retail success.

Question 52: Which field in Retail Link identifies the specific distribution center responsible for replenishing a given store-item combination?

Fineline Number
Store Cluster Code
Vendor Stock Number
DC Number (Correct answer)

Correct answer: DC Number

The DC Number field in Retail Link identifies the Walmart distribution center that services a particular store for a given item.

Question 53: Which term describes the practice of selling a product below cost to drive store traffic?

Everyday low pricing (EDLP)
High-low pricing
Loss leader pricing (Correct answer)
Price anchoring

Correct answer: Loss leader pricing

Loss leader pricing deliberately prices an item below cost to attract shoppers who will then purchase higher-margin products.

Question 54: When implementing a new markdown strategy, what is the recommended sequence of steps?

Set objectives, model scenarios, gain cross-functional approval, then execute (Correct answer)
Execute markdowns, then set objectives, then measure results
Execute immediately to clear inventory before analysis
Seek vendor allowances first before setting any markdown objectives

Correct answer: Set objectives, model scenarios, gain cross-functional approval, then execute

Setting objectives, modeling scenarios, and gaining approval before execution ensures markdowns are strategic, budgeted, and aligned across merchandising and finance.

Question 55: Which Retail Link data source would a supplier use to monitor Walmart's demand forecast for their item over the next 12 weeks?

Replenishment Forecast Report within the Supply Chain module (Correct answer)
Item Authorization Report with a forward-looking date selector
Historical POS Sales Report filtered to future date ranges
Supplier Scorecard under the Forecast Accuracy section

Correct answer: Replenishment Forecast Report within the Supply Chain module

The Replenishment Forecast Report in Retail Link's Supply Chain module provides Walmart's system-generated demand projections for upcoming weeks.

Question 56: A retailer with a high 'days inventory outstanding' (DIO) relative to peers likely faces:

Stronger cash flow from operations
Excess inventory levels and potential markdowns risk (Correct answer)
Lower working capital requirements
Superior inventory management and faster turns

Correct answer: Excess inventory levels and potential markdowns risk

High DIO means inventory sits longer before selling, signaling potential overstocking, slow-moving merchandise, and future markdown pressure.

Question 57: What is 'shrink' in retail financial reporting?

Planned markdown on seasonal items
Inventory loss due to theft, damage, or administrative error (Correct answer)
Reduction in store headcount
Vendor deduction from invoice

Correct answer: Inventory loss due to theft, damage, or administrative error

Shrink refers to the difference between recorded inventory and actual physical inventory, caused by theft, damage, or errors.

Question 58: How is gross margin percentage calculated?

Net income / Revenue × 100
Operating expenses / Revenue × 100
COGS / Revenue × 100
(Revenue − COGS) / Revenue × 100 (Correct answer)

Correct answer: (Revenue − COGS) / Revenue × 100

Gross margin percentage is gross profit (revenue minus cost of goods sold) divided by revenue, expressed as a percentage.

Question 59: When communicating a retail category review to a buying team, which data point is MOST directly relevant to their decisions?

Category gross margin by vendor and SKU (Correct answer)
Office supply expenditure
Total corporate headcount
Number of analysts in the department

Correct answer: Category gross margin by vendor and SKU

Buyers make vendor and product decisions based on gross margin performance at the category, vendor, and SKU level.

Question 60: What challenges might arise in implementing retail link data management systems?

Challenges include data integration and employee resistance (Correct answer)
Retail link data management systems reduce data accuracy.
There are no benefits to using retail link data management systems.
There are no challenges in implementing retail data management systems.

Correct answer: Challenges include data integration and employee resistance

Implementing retail link data management systems can face several significant challenges. Data integration is often complex due to disparate systems and varying data formats, requiring substantial technical effort and resources. Additionally, employees may resist new systems due to unfamiliarity, fear of change, or perceived increased workload, necessitating thorough training and effective change management strategies for successful adoption.

Question 61: Why is accurate sales data important in Retail Link Data Management?

Sales data is only relevant for marketing efforts.
Accurate sales data ensures effective inventory management and demand forecasting (Correct answer)
Sales data only applies to online businesses.
Accurate sales data has no impact on retail operations.

Correct answer: Accurate sales data ensures effective inventory management and demand forecasting

Accurate sales data is the foundation of effective retail operations. It allows businesses to precisely track what products are selling, when, and in what quantities. This information is critical for optimizing inventory levels, preventing stockouts or overstock, and making reliable demand forecasts, which are essential for efficient supply chain management and overall profitability.

Question 62: Price bundling is a strategy where a retailer:

Sets different prices for the same item in different store zones
Raises prices on complementary items when a key item goes on promotion
Offers two or more products together at a combined price lower than buying each separately (Correct answer)
Applies a single margin percentage uniformly across all product categories

Correct answer: Offers two or more products together at a combined price lower than buying each separately

Price bundling groups products together at a combined discount to increase average transaction value and move slower-selling items.

Question 63: When a retail analyst says a promotion was 'incremental,' what does this mean?

The promotion ran over multiple weeks
Sales generated were above and beyond what would have occurred without the promotion (Correct answer)
The discount was applied incrementally at checkout
The promotion targeted a new customer segment

Correct answer: Sales generated were above and beyond what would have occurred without the promotion

Incremental sales are the additional units or revenue directly attributable to a promotional activity, excluding baseline sales that would have happened anyway.

Question 64: The 'wheel of retailing' theory suggests that new retail formats enter the market by:

Offering premium services at high price points
Targeting only online channels first
Entering as low-cost, low-margin operators and then trading up over time (Correct answer)
Copying existing successful formats exactly

Correct answer: Entering as low-cost, low-margin operators and then trading up over time

The wheel of retailing posits that entrants compete on low price and minimal service, then gradually add services and raise prices, creating space for new low-cost competitors.

Question 65: What is the purpose of a retail open-to-buy (OTB) plan?

Scheduling employee shifts
Setting promotional markdown budgets
Controlling how much inventory a buyer can purchase in a given period (Correct answer)
Planning store expansion timelines

Correct answer: Controlling how much inventory a buyer can purchase in a given period

Open-to-buy is a budget control tool that limits purchasing to what is needed based on planned sales, inventory levels, and targets.

Question 66: Which replenishment method involves ordering a variable quantity at fixed, regular time intervals to bring stock up to a target level?

Continuous review (Q-system)
Periodic review (P-system) (Correct answer)
Just-in-time (JIT) replenishment
Vendor-managed inventory (VMI)

Correct answer: Periodic review (P-system)

The periodic review (P-system) orders at set intervals and adjusts the order quantity to reach a predetermined target inventory level.

Question 67: A retail analyst uses color coding in a dashboard to flag KPIs. Red should indicate which condition?

KPI data is unavailable
KPI is significantly below target and requires attention (Correct answer)
KPI is ahead of target by more than 10%
KPI is new and untested

Correct answer: KPI is significantly below target and requires attention

Red is universally understood as a warning or alert color, signaling that a metric is underperforming and needs immediate attention.

Question 68: A retailer's loyalty program data shows 20% of customers generate 80% of revenue. This reflects which principle?

Regression to the mean
Central limit theorem
Law of large numbers
Pareto principle (Correct answer)

Correct answer: Pareto principle

The Pareto principle (80/20 rule) commonly appears in retail where a small share of customers drives the majority of sales.

Question 69: Which metric tracks the total revenue a customer generates throughout their relationship with a retailer?

Customer lifetime value (CLV) (Correct answer)
Cost per click
Churn rate
Customer acquisition cost

Correct answer: Customer lifetime value (CLV)

Customer lifetime value (CLV) estimates the total net revenue a retailer can expect from a customer over the entire relationship.

Question 70: In Retail Link, what does the metric 'On Hand Units' represent at the store level?

Units physically present in the store including backroom and sales floor (Correct answer)
Units sold to end consumers in the trailing 7 days
Units ordered but not yet received by the store
Units in transit from the distribution center to the store

Correct answer: Units physically present in the store including backroom and sales floor

On Hand Units represents all physical inventory in a store, encompassing both the sales floor and backroom stock.

Question 71: What is the primary ethical obligation of a CRA professional when a conflict of interest arises during safety protocols & risk management activities?

Resolve the conflict privately without informing stakeholders
Proceed while favoring the outcome that benefits the professional personally
Disclose the conflict to all relevant parties and recuse from the decision if necessary (Correct answer)
Ignore the conflict if it does not directly affect the current task

Correct answer: Disclose the conflict to all relevant parties and recuse from the decision if necessary

The primary ethical obligation when a conflict of interest arises in safety protocols & risk management is to disclose it to all relevant parties and, if necessary, recuse from the decision. This maintains professional integrity and stakeholder trust.

Question 72: A store's same-store sales (SSS) increased 5% year-over-year. What does this indicate?

Existing store locations grew revenue by 5% (Correct answer)
Five new store locations opened
Online sales grew 5%
Total company sales grew 5%

Correct answer: Existing store locations grew revenue by 5%

Same-store sales (also called comparable-store sales) measures revenue growth at locations open for at least one year, excluding new stores.

Question 73: Which financial document summarizes a retailer's revenues and expenses over a specific period?

Income statement (P&L) (Correct answer)
Statement of retained earnings
Cash flow statement
Balance sheet

Correct answer: Income statement (P&L)

The income statement (profit and loss statement) summarizes revenues, costs, and expenses to show net profit or loss for a reporting period.

Question 74: What does 'shopper basket size' refer to in retail analytics?

Number of loyalty members
Physical dimensions of shopping carts
Total weekly store revenue
Average number of items or dollar value per transaction (Correct answer)

Correct answer: Average number of items or dollar value per transaction

Basket size measures the average quantity or dollar value of items a shopper purchases in a single transaction.

Question 75: A CRA analyst is asked to reduce customer churn. Which leading indicator is most useful to monitor?

Purchase frequency decline among active loyalty members (Correct answer)
Total SKU count
Gross margin percentage
Vendor fill rate

Correct answer: Purchase frequency decline among active loyalty members

Declining purchase frequency among loyalty members is an early warning sign that customers are disengaging before fully churning.

Question 76: The 'bullwhip effect' in retail supply chains describes:

Seasonal inventory build-up at distribution centers
Rapid price escalation caused by supply shortages
Demand signal distortion that causes increasingly large swings in upstream order quantities (Correct answer)
The outsized impact of promotional events on customer traffic

Correct answer: Demand signal distortion that causes increasingly large swings in upstream order quantities

The bullwhip effect occurs when small fluctuations in consumer demand amplify into large order variability as they move upstream through the supply chain.

Question 77: In Retail Link, 'Shrink' as a data metric refers to:

Unsold seasonal merchandise returned to the supplier
Planned markdown reductions negotiated between the supplier and buyer
A reduction in allocated shelf space during a planogram reset
Inventory loss due to theft, damage, or administrative errors (Correct answer)

Correct answer: Inventory loss due to theft, damage, or administrative errors

Shrink in Retail Link represents inventory lost to theft, breakage, mis-scans, or other errors that reduce on-hand count without a corresponding sale.

Question 78: A retailer sees high customer acquisition but low retention. What is the most likely business impact?

Rising customer acquisition costs eroding profitability (Correct answer)
Decreasing cost of goods sold
Improved inventory turnover
Higher average transaction value

Correct answer: Rising customer acquisition costs eroding profitability

When acquisition outpaces retention, the ongoing cost to replace churned customers drives up total customer acquisition spend, squeezing margins.

Question 79: Which metric measures the percentage of shoppers who make a purchase after entering a store?

Dwell time
Conversion rate (Correct answer)
Foot traffic index
Basket size

Correct answer: Conversion rate

Conversion rate is the ratio of transactions to total store visitors, indicating how effectively traffic is turned into sales.

Question 80: When setting up a Retail Link scorecard threshold alert for in-stock percentage, the alert will trigger when:

In-stock percentage rises above the threshold, indicating overstocking risk
The item reaches 100% in-stock for three consecutive weeks
In-stock percentage falls below the defined minimum threshold value (Correct answer)
A store's in-stock percentage deviates more than 10% from the national average

Correct answer: In-stock percentage falls below the defined minimum threshold value

In-stock threshold alerts are designed to notify suppliers when their in-stock percentage drops below a defined floor value, signaling a stockout risk.

Question 81: Which financial metric shows how many times a retailer sells and replaces its inventory in a year?

Inventory turnover ratio (Correct answer)
Debt-to-equity ratio
Current ratio
Days sales outstanding

Correct answer: Inventory turnover ratio

Inventory turnover ratio equals COGS divided by average inventory and indicates how efficiently a retailer manages its stock.

Question 82: A grocery retailer uses continuous replenishment planning (CRP). What data does the retailer typically share with its supplier to enable this?

Store labor schedules
Point-of-sale data and current inventory levels (Correct answer)
Annual budget forecasts only
Supplier cost sheets and margin targets

Correct answer: Point-of-sale data and current inventory levels

CRP relies on the retailer sharing real-time or near-real-time POS and inventory data so the supplier can automatically generate replenishment orders.

Question 83: What is the primary function of the Retail Link 'Query Builder' tool?

To automate replenishment orders based on inventory thresholds
To submit new item setup forms directly to Walmart buyers
To create custom ad hoc reports by selecting specific data fields and filters (Correct answer)
To manage supplier scorecards and compliance metrics

Correct answer: To create custom ad hoc reports by selecting specific data fields and filters

Query Builder allows suppliers to construct custom reports by selecting desired data dimensions, metrics, and filters without relying on pre-built templates.

Question 84: Which KPI directly measures how efficiently a retailer uses its selling floor space?

Gross margin percentage
Sales per square foot (Correct answer)
Basket size
Stock-to-sales ratio

Correct answer: Sales per square foot

Sales per square foot (or square meter) is the standard metric for evaluating how productively a retailer monetizes its physical floor area.

Question 85: Which supply chain document formally authorizes a supplier to begin production or ship goods, and is legally binding upon acceptance?

Purchase order (PO) (Correct answer)
Request for proposal (RFP)
Bill of lading (BOL)
Packing slip

Correct answer: Purchase order (PO)

A purchase order is the retailer's legal offer to buy specific goods at agreed terms; once accepted by the supplier it forms a binding contract.

Question 86: A fashion retailer receives 500 units of a seasonal jacket but only sells 350 by season end. What is the sell-through rate?

140%
50%
30%
70% (Correct answer)

Correct answer: 70%

Sell-through = units sold ÷ units received = 350 ÷ 500 = 70%.

Question 87: A supplier wants to identify which Walmart stores are currently listed as 'Active' for their item. Where in Retail Link would they find this information most efficiently?

The Supplier Scorecard under the Distribution section
The Item Activity report filtered by store and authorization status (Correct answer)
The Replenishment Forecast report at the store-item level
The POS Sales Summary report sorted by store sales volume

Correct answer: The Item Activity report filtered by store and authorization status

The Item Activity report shows the authorization and active status of items by store, making it the most direct source for identifying active store listings.

Question 88: The 'retail life cycle' concept suggests that retail formats experience stages analogous to:

The employee career progression from entry-level to executive
The product life cycle of introduction, growth, maturity, and decline (Correct answer)
The supply chain from raw materials to end consumer
The business cycle of economic boom and recession

Correct answer: The product life cycle of introduction, growth, maturity, and decline

Like products, retail formats move through introduction, accelerated development, maturity, and decline phases over time.

Question 89: A supplier notices that Retail Link POS data is refreshed daily but shows a one-day lag. Which best explains this lag?

Walmart stores transmit POS data to headquarters only on weekends
Suppliers must manually request a data refresh through the portal
POS data is encrypted and requires a 24-hour decryption cycle
Data is uploaded at end-of-day and processed overnight before becoming available (Correct answer)

Correct answer: Data is uploaded at end-of-day and processed overnight before becoming available

Retail Link POS data is collected at end-of-day and processed overnight, resulting in a one-day lag before suppliers can view it.

Question 90: A CRA analyst wants to compare sales performance for a new item versus the same period last year. Which Retail Link feature best supports this comparison?

The Seasonal Index report under the Forecasting module
Dual time-period columns using 'Current Year' and 'Prior Year' date selectors (Correct answer)
Threshold Alerts set to trigger on year-over-year declines
Item Authorization History report filtered by launch date

Correct answer: Dual time-period columns using 'Current Year' and 'Prior Year' date selectors

Retail Link's Query Builder allows analysts to add dual time-period columns so current and prior year data appear side-by-side for direct comparison.

Question 91: In voice-of-customer (VOC) programs, which data source provides the most direct consumer sentiment?

Planogram compliance audits
Vendor scorecards
Internal sales reports
Customer surveys and reviews (Correct answer)

Correct answer: Customer surveys and reviews

Customer surveys and reviews capture first-hand shopper opinions, making them the most direct source of voice-of-customer sentiment.

Question 92: What does 'on-shelf availability' (OSA) measure in retail operations?

Store manager availability during peak hours
The number of SKUs active in a category
Vendor delivery fill rate to the distribution center
The percentage of time products are in stock and shoppable on the shelf (Correct answer)

Correct answer: The percentage of time products are in stock and shoppable on the shelf

On-shelf availability measures whether products are physically present on the shelf when a shopper wants to buy them, directly affecting sales and satisfaction.

Question 93: Which quality assurance method is most commonly applied in best practices & standard procedures to verify that CRA professional standards are being met?

Annual reviews conducted exclusively by non-technical management
Informal self-assessment without external validation
Relying on client satisfaction surveys as the sole measure of quality
Structured audits, peer reviews, and performance metrics aligned with industry benchmarks (Correct answer)

Correct answer: Structured audits, peer reviews, and performance metrics aligned with industry benchmarks

Structured audits, peer reviews, and performance metrics aligned with industry benchmarks are the most effective quality assurance methods in best practices & standard procedures, providing objective, measurable evidence that CRA standards are consistently met.

Question 94: What is GMROI and what does it evaluate?

Gross Margin Rate of Increase — year-over-year margin growth
General Merchandise Revenue On Investment — total store revenue efficiency
Gross Margin Return on Inventory Investment — profitability of inventory investment (Correct answer)
General Markup Rate of Items — average item pricing

Correct answer: Gross Margin Return on Inventory Investment — profitability of inventory investment

GMROI (Gross Margin Return on Inventory Investment) measures how much gross profit is earned for every dollar invested in inventory.

Question 95: When analyzing Retail Link data, a supplier's 'Weeks of Supply' (WOS) at the store level is calculated as:

Total Sales divided by Current Inventory
On Hand Units divided by Average Weekly Sales (Correct answer)
On Order Units divided by Average Weekly Sales
Replenishment Lead Time multiplied by Safety Stock

Correct answer: On Hand Units divided by Average Weekly Sales

Weeks of Supply equals On Hand Units divided by Average Weekly Sales, indicating how many weeks of sales the current inventory can support.

Question 96: A CRA professional encounters an unfamiliar situation while performing best practices & standard procedures duties. What is the most appropriate first action?

Consult relevant standards, guidelines, or a qualified supervisor before proceeding (Correct answer)
Proceed based on general assumptions to avoid delays
Skip the task entirely and move to the next assignment
Apply a solution from an unrelated field without verification

Correct answer: Consult relevant standards, guidelines, or a qualified supervisor before proceeding

When facing unfamiliar situations in best practices & standard procedures, the most appropriate action is to consult relevant standards, guidelines, or a qualified supervisor. This ensures safety, accuracy, and compliance while building professional knowledge.

Question 97: What does a Net Promoter Score (NPS) measure in retail?

Customer willingness to recommend the retailer (Correct answer)
Inventory accuracy rate
Average transaction frequency
Product return likelihood

Correct answer: Customer willingness to recommend the retailer

NPS gauges customer loyalty by asking how likely shoppers are to recommend the retailer to others, on a 0–10 scale.

Question 98: Which communication channel is MOST appropriate for sharing a time-sensitive alert about a sudden sales drop at a top store?

Instant message or phone call to the relevant manager (Correct answer)
Monthly printed report
Weekly email digest
Annual strategy document

Correct answer: Instant message or phone call to the relevant manager

Time-sensitive operational issues require immediate channels like phone or instant messaging to enable rapid response.

Question 99: Which segmentation approach groups customers by demographic attributes such as age and income?

Geographic segmentation
Psychographic segmentation
Behavioral segmentation
Demographic segmentation (Correct answer)

Correct answer: Demographic segmentation

Demographic segmentation categorizes customers using observable characteristics like age, gender, and income level.

Question 100: What does the Retail Link metric 'Sell-Through Rate' measure for a seasonal or promotional item?

The percentage of received inventory that has been sold to consumers (Correct answer)
The ratio of promotional price to everyday price for a given SKU
The rate at which Walmart buyers reorder an item after its initial purchase
The number of weeks before an item reaches its modular reset date

Correct answer: The percentage of received inventory that has been sold to consumers

Sell-Through Rate measures the proportion of inventory received by stores that has actually been sold, indicating demand relative to supply.

Certified Retail Analyst (CRA)

The CRA certification from Northwest Arkansas Community College validates proficiency in retail analytics, data management, and strategic analysis for suppliers and retailers working with data tools like Walmart's Retail Link. It covers retail fundamentals, supply chain, category management, consumer analytics, and financial metrics.

100

Questions

120 min

Time Limit

80%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds