Calculates the Number of Secondary Shoppers in Each Market

This function calculates the number of secondary shoppers given the population in each market type.

Usage

Secondary_Shopper_Count(
  pct_metro_sec = 40,
  pct_rural_sec = 50,
  pct_town_sec = 50,
  metro_pop,
  town_pop,
  rural_pop
)

Arguments

pct_metro_sec

The percentage of secondary shoppers in metro market default taken as 40% unless specified otherwise.

pct_rural_sec

The percentage of secondary shoppers in rural market default taken as 50% unless specified otherwise.

pct_town_sec

The percentage of secondary shoppers in town market default taken as 50% unless specified otherwise.

metro_pop

Population of the store location

town_pop

Population of all towns in the county

rural_pop

Population of rural cities in our market

Value

Outputs the total number of secondary shoppers for the store

Details

This function is taken from the estimating Market Size.xlsx and calculated in step 6.

See also

Primary_Shopper_Count()

Rare_Shopper_Count()

Author

Srika Raja

Examples

#Secondary_Shopper_Count()