Calculates the Estimated Total Revenue — Total_Estimate

This function returns the total estimated revenue calculated by taking the sum of money spent primary secondary and tertiary shoppers.

Usage

Total_Estimate_Revenue(
  per_of_grocery_spend_rare = 5,
  per_of_grocery_spend_sec = 25,
  per_of_grocery_spend_prim = 60,
  pct_metro_prim = 50,
  pct_rural_prim = 30,
  pct_town_prim = 30,
  pct_metro_sec = 40,
  pct_rural_sec = 50,
  pct_town_sec = 50,
  pct_metro_rare = 10,
  pct_rural_rare = 20,
  pct_town_rare = 20,
  metro_pop,
  town_pop,
  rural_pop,
  state_index,
  est_per_price_increase = 7,
  grocery_sales = 8.11541e+11,
  population = 334233854
)

Arguments

per_of_grocery_spend_rare: The percentage of groceries rare shoppers will spend at the proposed store
per_of_grocery_spend_sec: The percentage of groceries secondary shoppers will spend at the proposed store
per_of_grocery_spend_prim: The percentage of groceries primary shopper will spend at the proposed store
pct_metro_prim: The percentage of primary shoppers in metro market default taken as 50% unless specified otherwise.
pct_rural_prim: The percentage of primary shoppers in rural market default taken as 30% unless specified otherwise.
pct_town_prim: The percentage of primary shoppers in town market default taken as 30% unless specified otherwise.
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.
pct_metro_rare: The percentage of rare shoppers in metro market default taken as 10% unless specified otherwise.
pct_rural_rare: The percentage of rare shoppers in rural market default taken as 20% unless specified otherwise.
pct_town_rare: The percentage of rare shoppers in town market default taken as 20% 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
state_index: The ratio of the current price of the basket to the price of the basket during the base year
est_per_price_increase: Estimated increase in price of grocery in cumulative percent default taken as 7 for 2023.
grocery_sales: Total US grocery sales annually. Default value is 811541000000.
population: Total US population. Default value is 334233854.

Value

Outputs the estimated total revenue at the proposed store.

Details

This function is taken from the estimating Revenue.xlsx and calculated in step 4. This function calls Total_Spend_Primary_Shoppers(), Total_Spend_Secondary_Shoppers() and Total_Spend_Rare_Shoppers()

Author

Srika Raja

Examples

#Total_Estimate_Revenue(state_index=99)