CPCM END OF COURSE 2025/2026 QUESTIONS WITH
ANSWERS RATED A+
✔✔B. Shelf capacity - ✔✔The bottom shelf in a gondola is usually deeper than the other
shelves, and has more:
A. Linear Feet
B. Shelf capacity
C. Profit per foot
D. Facings
✔✔C. 25.4 (Work =245/964 (Brand $ sales / Category $ sales)) - ✔✔If Brand X has
dollar sales of $245M and unit sales of 500 units, and the category has dollar sales of
$964M and equivalent volume sales of 1500, what is the share of category sales for
Brand X?
A. 3.3
C. 25.4
B. 3.9
D. 10.0
✔✔C. When it is "rolled up" to include and reflect channel and market data - ✔✔When is
retail measurement data (scanned sales data) considered to be syndicated data?
A. When it is segmented into product groupings including brand, subcategory and
category level data
B. When it includes retail scanned sales data for total stores, across banners and
geographies
C. When it is "rolled up" to include and reflect channel and market data
D. When it combines retail scanned sales, supplier shipment and market data
E. None of the these options are correct
✔✔C. Retailer point-of-sale data - ✔✔Which of the following data sources is internal
sales data collected by retailers?
A. Syndicated scanner data
B. Geodemographic data
C. Retailer point-of-sale data
D. Household panel data
✔✔A. True. Store size, geography and climate, consumer purchase behavior and
consumer demographics are all attributes that can affect differences across stores. -
✔✔True or false? Retailers should cluster their stores based on more attributes than
volume and store size for better Shopper focus
,A. True. Store size, geography and climate, consumer purchase behavior and
consumer demographics are all attributes that can affect differences across stores.
B. False. Store size and volume create effective segments that focus on consumer
differences without the complexity.
✔✔D. Days of supply - ✔✔A retailer needs to order more stock on an item because it
will run out of stock in 10 days. What space management measure provides this
information?
A. Capacity analysis
B. Number of facings
C. Post-reset tracking
D. Days of supply
✔✔True (cannibalization) - ✔✔True or false? The opposite effect of incremental
contribution is cannibalization.
✔✔C. Vary promotions, including feature & display activity, between the test and control
stores in both the pre-test period and the test period. - ✔✔When completing an in-store
test, which of the following activities should NOT be done to set up an effective test?
A. Conduct the in-store test for a period of 13 weeks.
B. If stores shelves are reset for the test, include a one-week gap between the
completion of the resets and the start of the test period.
C. Vary promotions, including feature & display activity, between the test and control
stores in both the pre-test period and the test period.
D. Include a pre-test period that lasts the same length of time as the test period.
✔✔B. False. You can still segment item level data based on common segments like
size, format, subcategory, price tier, without a consumer decision tree. - ✔✔True or
false? If you do not have access to a consumer decision tree you should not attempt to
segment the data.
A. True. You should not segment item-level data if you do not have a well-researched
CDT.
B. False. You can still segment item level data based on common segments like size,
format, subcategory, price tier, without a consumer decision tree.
✔✔A. Using multiple workbooks - ✔✔Which functionality would be least effective when
analyzing large volumes of syndicated scanner data in Microsoft Excel?
A. Using multiple workbooks
B. VLOOKUPs
C. Pivot tables
D. Pivot charts
, ✔✔14.4 ((WORK = 520 units per year / (6 facings x 6 units per facing) = 14.4) -
✔✔Product A has 6 facings and holds 6 units per facing. Its weekly movement is 10
units per week (520 units per year). What are the inventory turns for Product A? Type in
your answer as a number with one decimal place (example "10.2").
✔✔37.6 (Work= 1-(Reduced price/original price) .... 1-(2.49/3.99)) - ✔✔If an item has an
original retail price of $3.99 and is now selling at a reduced price of $2.49, what is the
markdown %?
✔✔A. 625.0 (Work = sales units or $ / the market's ACV / 1 000 - 20,000 /$32,000) x
1000)) - ✔✔Calculate the "Sales per $MM ACV" based on the following information: -
Store sales in units per year: 20,000 -Store ACV$: $32,000,000
A. 625.0
C. 640.0
B. 1260.0
D. 1.6
✔✔C. In-store shopper research - ✔✔Which of the following best describes information
collected by observing consumers while they shop followed by asking them a defined
set of questions?
A. Qualitative and quantitative research
B. Tracking studies
C. In-store shopper research
✔✔A. Ground and Large - ✔✔Refer to the table. In which two segments is the retailer
losing the most market share?
· Ground: Retailer = 8.8 (-7.0 % Growth) / Market = 58.1 (16 % Growth)
· Instant: Retailer = 11.0 (-6.0 % Growth) / Market = 35.1 (-8 % Growth) Beans: Retailer
= 8.3 (18 % Growth) / Market = 11.6 (-7 % Growth)
· Small: Retailer = 11.7 (-7.0 % Growth) / Market = 11.6 (-11 % Growth)
· Medium: Retailer = 10.8 (3.0 % Growth) / Market = 51.8 (2 % Growth) Large: Retailer
= 8.2 (24.0 % Growth) / Market = 36.0 (27% Growth)
A. Ground and Large
B. Beans and Medium
C. Ground and Medium
D. Beans and Large
✔✔True (Control test) - ✔✔True or false? A Control Store Test can provide data
validation on in store tests done across multiple stores.
ANSWERS RATED A+
✔✔B. Shelf capacity - ✔✔The bottom shelf in a gondola is usually deeper than the other
shelves, and has more:
A. Linear Feet
B. Shelf capacity
C. Profit per foot
D. Facings
✔✔C. 25.4 (Work =245/964 (Brand $ sales / Category $ sales)) - ✔✔If Brand X has
dollar sales of $245M and unit sales of 500 units, and the category has dollar sales of
$964M and equivalent volume sales of 1500, what is the share of category sales for
Brand X?
A. 3.3
C. 25.4
B. 3.9
D. 10.0
✔✔C. When it is "rolled up" to include and reflect channel and market data - ✔✔When is
retail measurement data (scanned sales data) considered to be syndicated data?
A. When it is segmented into product groupings including brand, subcategory and
category level data
B. When it includes retail scanned sales data for total stores, across banners and
geographies
C. When it is "rolled up" to include and reflect channel and market data
D. When it combines retail scanned sales, supplier shipment and market data
E. None of the these options are correct
✔✔C. Retailer point-of-sale data - ✔✔Which of the following data sources is internal
sales data collected by retailers?
A. Syndicated scanner data
B. Geodemographic data
C. Retailer point-of-sale data
D. Household panel data
✔✔A. True. Store size, geography and climate, consumer purchase behavior and
consumer demographics are all attributes that can affect differences across stores. -
✔✔True or false? Retailers should cluster their stores based on more attributes than
volume and store size for better Shopper focus
,A. True. Store size, geography and climate, consumer purchase behavior and
consumer demographics are all attributes that can affect differences across stores.
B. False. Store size and volume create effective segments that focus on consumer
differences without the complexity.
✔✔D. Days of supply - ✔✔A retailer needs to order more stock on an item because it
will run out of stock in 10 days. What space management measure provides this
information?
A. Capacity analysis
B. Number of facings
C. Post-reset tracking
D. Days of supply
✔✔True (cannibalization) - ✔✔True or false? The opposite effect of incremental
contribution is cannibalization.
✔✔C. Vary promotions, including feature & display activity, between the test and control
stores in both the pre-test period and the test period. - ✔✔When completing an in-store
test, which of the following activities should NOT be done to set up an effective test?
A. Conduct the in-store test for a period of 13 weeks.
B. If stores shelves are reset for the test, include a one-week gap between the
completion of the resets and the start of the test period.
C. Vary promotions, including feature & display activity, between the test and control
stores in both the pre-test period and the test period.
D. Include a pre-test period that lasts the same length of time as the test period.
✔✔B. False. You can still segment item level data based on common segments like
size, format, subcategory, price tier, without a consumer decision tree. - ✔✔True or
false? If you do not have access to a consumer decision tree you should not attempt to
segment the data.
A. True. You should not segment item-level data if you do not have a well-researched
CDT.
B. False. You can still segment item level data based on common segments like size,
format, subcategory, price tier, without a consumer decision tree.
✔✔A. Using multiple workbooks - ✔✔Which functionality would be least effective when
analyzing large volumes of syndicated scanner data in Microsoft Excel?
A. Using multiple workbooks
B. VLOOKUPs
C. Pivot tables
D. Pivot charts
, ✔✔14.4 ((WORK = 520 units per year / (6 facings x 6 units per facing) = 14.4) -
✔✔Product A has 6 facings and holds 6 units per facing. Its weekly movement is 10
units per week (520 units per year). What are the inventory turns for Product A? Type in
your answer as a number with one decimal place (example "10.2").
✔✔37.6 (Work= 1-(Reduced price/original price) .... 1-(2.49/3.99)) - ✔✔If an item has an
original retail price of $3.99 and is now selling at a reduced price of $2.49, what is the
markdown %?
✔✔A. 625.0 (Work = sales units or $ / the market's ACV / 1 000 - 20,000 /$32,000) x
1000)) - ✔✔Calculate the "Sales per $MM ACV" based on the following information: -
Store sales in units per year: 20,000 -Store ACV$: $32,000,000
A. 625.0
C. 640.0
B. 1260.0
D. 1.6
✔✔C. In-store shopper research - ✔✔Which of the following best describes information
collected by observing consumers while they shop followed by asking them a defined
set of questions?
A. Qualitative and quantitative research
B. Tracking studies
C. In-store shopper research
✔✔A. Ground and Large - ✔✔Refer to the table. In which two segments is the retailer
losing the most market share?
· Ground: Retailer = 8.8 (-7.0 % Growth) / Market = 58.1 (16 % Growth)
· Instant: Retailer = 11.0 (-6.0 % Growth) / Market = 35.1 (-8 % Growth) Beans: Retailer
= 8.3 (18 % Growth) / Market = 11.6 (-7 % Growth)
· Small: Retailer = 11.7 (-7.0 % Growth) / Market = 11.6 (-11 % Growth)
· Medium: Retailer = 10.8 (3.0 % Growth) / Market = 51.8 (2 % Growth) Large: Retailer
= 8.2 (24.0 % Growth) / Market = 36.0 (27% Growth)
A. Ground and Large
B. Beans and Medium
C. Ground and Medium
D. Beans and Large
✔✔True (Control test) - ✔✔True or false? A Control Store Test can provide data
validation on in store tests done across multiple stores.
