CRA Best Practices & Standard Procedures 3 — Questions and Answers
Question 1: Which practice best ensures data integrity when multiple analysts are working on the same retail database?
- Allowing all analysts to have unrestricted write access
- Implementing role-based access controls and version-controlled data transformation scripts (Correct answer)
- Using separate databases for each analyst and merging manually
- Restricting all database access to a single designated analyst
Correct answer: Implementing role-based access controls and version-controlled data transformation scripts
Role-based access controls combined with version-controlled scripts prevent unauthorized changes while maintaining a clear audit trail of all transformations.
Question 2: A retail analyst is tasked with creating an exception report. What should the report prioritize?
- All SKUs regardless of performance level
- Items where actuals deviate from plan beyond a defined threshold (Correct answer)
- Only items that exceeded plan targets
- Items alphabetically by SKU description
Correct answer: Items where actuals deviate from plan beyond a defined threshold
Exception reports highlight actionable variances—both positive and negative—beyond a defined threshold, enabling analysts to focus on what requires attention.
Question 3: When implementing a new markdown strategy, what is the recommended sequence of steps?
- Execute markdowns, then set objectives, then measure results
- Set objectives, model scenarios, gain cross-functional approval, then execute (Correct answer)
- 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 4: In retail space planning, what is the standard procedure for allocating shelf space to new items?
- Allocate equal space to all new items regardless of projected velocity
- Base initial space allocation on demand forecasts and comparable item performance (Correct answer)
- Allocate maximum space to new items to maximize visibility
- Allow store managers to determine new item space without category guidelines
Correct answer: Base initial space allocation on demand forecasts and comparable item performance
Using demand forecasts and comparable performance data for initial space allocation reduces the risk of over- or under-stocking new items at launch.
Question 5: Which best practice should guide a retail analyst when presenting conflicting data findings to senior leadership?
- Present only the data that supports the recommended course of action
- Disclose all relevant data sources, acknowledge discrepancies, and explain analytical assumptions (Correct answer)
- Delay the presentation until data conflicts are fully resolved
- Present the most favorable dataset and footnote the conflicting source
Correct answer: Disclose all relevant data sources, acknowledge discrepancies, and explain analytical assumptions
Transparency about conflicting data, sources, and assumptions builds credibility and enables leadership to make informed decisions.
Question 6: A retailer is standardizing its inventory counting procedures. What is the best practice for conducting a physical inventory count?
- Count during peak shopping hours to capture live inventory movement
- Freeze inventory transactions, count systematically by location, and reconcile to system records (Correct answer)
- Count only high-value items to save time and resources
- Use last year's count as a baseline and adjust for estimated receipts and sales
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 7: When building a retail assortment plan, which analytical output should be reviewed to identify underperforming attributes?
- Average unit retail price across all categories
- Attribute-level sales penetration and margin contribution analysis (Correct answer)
- Total SKU count by vendor
- Year-over-year store count changes
Correct answer: Attribute-level sales penetration and margin contribution analysis
Attribute-level penetration and margin analysis reveals which product characteristics (size, color, brand) are driving or dragging category performance.
CRA Best Practices & Standard Procedures 3
Which practice best ensures data integrity when multiple analysts are working on the same retail database?