
Trade area definition
Quantifying and understanding the
supply and demand of goods and services in your trade area is foundational
to
evaluating the performance of existing facilities and also planning
for future expansion. The Trade Area Solutions core
expertise is being able to estimate a network of trade areas using
our spatial economic framework. Its major advantage is that
it ensures a complete and accurate supply and demand picture by
accounting for the growing portion of producer purchases between
trade areas. Please
click here for
a complete explanation of our retail trade area framework and its major
benefits.
Trade Area Solutions also provides "quick and dirty"
trade area definitions such as circles
and customer point-of-sale derived polygons. We believe,
however, that these conventional trade area techniques are false
economy. Click
here for a background
as well as the major economic problems associated
with conventional trade area analysis.

Supply & demand analysis
Trade Area Solutions have developed detailed farm level supply and
disposition tables for western Canada linked directly to GIS mapping
software. Although the system uses Statistics Canada (STC) supply
and disposition data as a foundation, it differs in that it incorporates
additional data including STC Small Area data, Census of Agriculture
data, and Canadian Grain Commission data. The result is a complete supply
and demand analysis framework at a very detailed regional level. The farm level supply
and demand system is available for the major grains & oilseeds
(spring wheat, durum wheat, barley, oats, rye, canola, and flaxseed)
by rural municipalities in western Canada from 1986 to the present.
It also includes detailed livestock and poultry feed use by animal
subclass for each of the major grains and oilseeds.
|
Availability
of Canadian Regional Farm
Supply
& Disposition Estimates
|
Variables |
Statistics
Canada
|
Trade Area
Solutions
|
|
Opening Stocks |
|
yes |
|
Production |
yes |
yes |
|
Total
Supply |
|
yes |
|
Marketings |
|
yes |
| To primary elevators |
|
yes |
| Outside primary
elevators |
|
yes |
|
Seed |
|
yes |
|
Feed Use |
|
yes |
|
Waste |
|
yes |
|
Dockage |
|
yes |
|
Carry-over
stocks |
|
yes |
|
Total Disposition |
|
yes |
  
  
Short and
long-term forecasting
The detailed farm level supply and
demand data by rural municipality and by major grains and oilseeds
forms the foundation for short and long-term forecasting at a detailed
regional level. This is ideal for "what if" scenarios in policy
analysis and revenue planning. Trade Area Solutions have extensive
experience in supply and demand forecasting and agriculture/rural
policy analysis.
Grain
handling & transportation analysis
The Spatial
Grain Flow Model is ideally suited for monitoring changes and
analyzing the grain handling and transportation system. Its major
advantage is that in addition to complete supply and demand data by
rural municipality and by major grains and oilseeds, the system also
estimates grain flows by truck into or out of rural municipalities
and/or grain delivery trade areas in western Canada. The model is also
well suited to forecasting and analyzing "what if" scenarios
in many different areas including: • the impact of
changes in the livestock & poultry sector on grain flows;
• the impact of changes in transportation freight rates and/or
multi-car freight rate incentives on grain flow patterns; • the impact of structural changes such as branch line abandonment,
the construction of new high-through-put elevators and the closure
of elevators on grain flow patterns; • market share analysis:
forecast changes in shares given elevator openings and closures;
• accurate grains & oilseeds supply/demand analysis and
short and medium-term forecasts at a very detailed regional level:
for each rural municipality or each grain delivery point; •
analyzing the performance of elevators at each delivery point;
• estimating the volume of grains & oilseeds trucked out
of or into each rural municipality and/or each delivery point in western
Canada; • quantifying and forecasting the impact of grain
flow patterns on the road network; and • monitoring
the impact of changes in grain transportation policies.
   
   
   

Performance metrics
Analyzing the performance of a
facility brings together and compares supply and demand. Market
shares is one
of the most common performance metrics and is calculated and
analyzed by product category as data permits. Customer
point-of-sale data is mapped within the trade area and comparing
against total market size statistics. In addition, customer
point-of-sale data is also compared in relation to the trade area
boundaries to analyze under penetrated regions of your trade area
which can then be used to develop additional marketing strategies
such as target marketing.
The reality of
agri-business is that stores in different locations will have different
market shares for a number of reasons including the impact of
competition.
Market share statistics, however, don't include the impact of
competition. As a result, Trade Area Solutions also calculates an untapped
market potential performance metric.
Untapped market potential is defined as target sales - actual sales.
Target sales are calculated as an important byproduct of the indices
developed in the supply/competitive analysis.

The
end result is is untapped market potential metric that includes the
full impact of competitors within a trade area and allows for a
direct comparison between a network of existing facilities, and new
potential sites by individual goods and services despite very different
competitive profiles.
The calculation of
untapped market potential for both existing facilities and new
potential sites through the use of the supply analysis (destination
data) is an important advantage of our market research framework. This often removes the need
to spend additional resources on further site evaluation modeling or
analysis such as a spatial interaction models (based on consumer
origin data) to better forecast sales and/or calculate untapped
market potential.
Sales forecasting
Forecasting sales is one of the natural end products of trade area
analysis. Our advantage is that we don't forecast sales in
isolation from major competitors. We forecast sales for all
major competitors with information from the supply/competitor
analysis which ensures a much higher level of accuracy.
Although there is no perfect prediction tool given the
numerous factors and the potential for future change, the key is
a high level of understanding of the supply and demand within the trade
area. Since our framework builds a complete
supply and demand picture, sales forecasting is a natural byproduct of
this process. We also have extensive forecasting
experience and have the ability to use a variety of intuitive, econometric, and GIS
solutions when necessary. Often the best and most accurate
forecasting method is also the simplest.
The sales forecasting
process utilizes the profiles and indices developed in the supply
and demand analysis. The key supply and demand drivers are
identified and analyzed, which can then be fed directly into a
firm's marketing strategy, as well as site selection studies.
We can also perform a complete probabilistic risk assessment of the
sales forecasting results.

Trade area profiling/facility
sizing
Trade area
profiling involves the clustering of trade areas based on both
supply and demand variables such as consumer
variables, retail facility characteristics, market shares, sales,
trade area size, and the nature and strength of competitors. This becomes extremely
valuable when analyzing the optimal size of
a new
facility. One of the most common mistake in site selection is to allow
the forecast of sales or untapped market potential to determine
the size of a new facility. The Trade Area Solution framework coupled
with our supply and demand analysis sizes new potential
sites so that sales forecasts can also accommodate capital expenditures and future operational costs.

Site
selection/network
planning
For organizations with multiple
outlets, retail network optimization remains poorly understood.
The current conventional network optimization models are called
location-allocation models. These models have two components:
the location portion examines the location while the allocation
component is not unlike a spatial interaction model (SIM) which
predicts purchase behavior. The major problem is that the trade
area for location-allocation models is often an input into the model
and often assumed to be a relatively
simple conventional trade area. This creates a major data gaps
because the foundational supply and demand picture is incomplete and
inaccurate.
Economics 101 provides background
as well as the major economic problems associated with
conventional trade area analysis.
The Trade Area
Solution site selection and network planning services employ much of
the analysis framework outlined above. Our framework advantage
is that it is a whole-of-system approach, which offers a seamless
market analysis solution to locations with facilities (validated
with customer point-of-sale data), new potential sites and network
planning. It ensures a
complete picture and understanding of the market economics by filling in the missing regional supply and demand
data gap. This framework allows a direct comparison of existing facilities
with potential expansion sites and a ranking of these site in
terms of untapped market potential. In addition, the framework allows
us to analyze and model dynamic "what if" scenarios in
uncertain business environments where the market potential and competitor
actions or reactions are critical to the business plan.
Our
business advantage provides a
more complete explanation of our trade area framework and its major
benefits.
Trade Area Solutions offers a
wide range of detail for site selection and network planning
projects. We can build a site model that includes the key
supply and demand drivers to better forecast sales
and quantify the impact of the above internal trade area dynamics of
customer purchase behavior relative to competitors. Although there is no perfect prediction tool given the
numerous factors and the potential for future change, the key is
a high level of understanding of the supply and demand within the
trade area. We have the ability to use a variety of intuitive,
econometric, and GIS solutions when necessary. Often the best
and most accurate forecasting method is also the simplest. We
provide site selection and network planning at any scale from a
single store with a single product to a nationwide network with a
large basket of goods and services.

Producer profiling/segmentation
Whether your goal is growth in an
existing market or in a new location, an accurate size and
understanding of producer purchase behavior is foundational to the
decision making process and further market research.
Producer analysis looks at your
customer base and compares them to the total demand. The focus of
this analysis is to better understand your existing producer customers and
potential customers to identify
the key variables that drive your demand. It
helps match your competitive offer with the type of farm producer most
likely to patronize your facility. Once the trade area is
determined, you can analyze the demographics and lifestyle data in
order to profile your customers and better target them. Trade
Area Solutions has significant experience with farm producer
segmentation data that will help you better understand your customers.
   
   
Agriculture/rural
policy analysis
The Spatial Grain Flow Model is well suited for agriculture policy
analysis. It has the capability of analyzing "what if" scenarios
with respect to changes in regional supply and demand, forecasting
supply and demand, changes in livestock and poultry numbers, and changes
in the structure of the grains and oilseeds handling and transportation
system. Trade Area Solutions have extensive experience in agriculture/rural policy analysis.
Yield modeling
Trade Area Solutions is currently beta testing a yield model for US
corn and soybean crops. The yield model combines daily real time weather,
weekly near real time satellite remote sensing data, and daily short
and long-term weather forecasts using advanced statistical and GIS
modeling techniques. The result is a model capable of producing daily
yield estimates throughout much of the growing season, which can explicitly
incorporate virtually all available historical and forecast data on
any given day. Preliminary results suggest a viable commercial product
with an extremely high forecast accuracy rate.
The US yield model project began as a natural extension of our
modeling expertise. The objective was to build the most accurate
yield model possible for the major US, crops which could be run
on a daily basis throughout the growing season. An examination of
the industry revealed that there are few quantitative models currently
in use. And the ones in use are not capable of incorporating all
available information including remote sensing and weather data.
In addition, these competitor models often have accuracy rates that
are too low for them to be of significant commercial value.
This yield model is a first in that it combines daily real time
weather, bi-weekly near time satellite remote sensing data, and
daily short and long-term weather forecasts using advanced statistical
modeling techniques. The result is a model capable of producing
daily yield estimates throughout much of the growing season which
explicitly incorporates virtually all available historical and forecast
data on any given day.
Major
strengths
• Industry Leading Accuracy - When the results of the model
are aggregated up to the total crop, out of sample results show
an error range of less than 0.8 percent! This is due to a number
of factors:
• Incorporates current daily real time weather data;
• Incorporates daily short and long-term weather forecasts;
• Incorporates near real time bi-weekly remote sensing NDVI
images; and
• The model is conceptually robust. The conceptual model strictly
adheres to known crop phenology. The modeling process closely parallels
the actual production of the crop by accurately building the yield
throughout the growing season. This is verified by the fact that
in sample and out of sample results are virtually identical.
• Daily Estimates allows the model to fully account for all
known weather impacts every day during much of the growing and harvesting
period.
• The model is ideally suited for modeling "what if"
scenarios because of the way the model uses information during the
growing season. Unlike other modeling techniques, this model explicitly
incorporates daily weather and bi-weekly NDVI data for virtually
each day of the growing season. For example, one could analyze the
impact of a weather pattern during a portion of the growing season.
Data
The key to the accuracy of the model is essentially the data. The
following databases form the foundation for the research and development
of the model:
• Area, yield, production statistics for corn, soybeans,
cotton, winter wheat, spring wheat, durum wheat, barley, sorghum,
flaxseed and oats for each county, crop reporting district (CRD)
and state from 1990 to present. Source: NASS.
• Daily precipitation data for the conterminous US from 1990
to present in a 0.25 degree grid. Source: US National Weather Service
• Daily minimum and maximum temperature data from 1990 to
present in a 0.5 degree grid for the conterminous US. Source: US
National Weather Service
• Monthly soil moisture data by US weather region (344) from
1990 to present. Source: US National Weather Service.
• Bi-weekly Normalized Difference Vegetative Index (NDVI)
satellite remote sensing images from 1990 to present. Source: US
EROS data center.
Output
Yield forecasts are available for virtually the entire US corn and
soybean crops. Forecasts cover about 99% of corn and soybean seeded
area in a total of 30 states. Forecasts can be made daily at four
different levels: (1) For the aggregated total crop, (2) for each
state, (3) for each crop-reporting district (CRD), and (4) for each
county.
Accuracy
The value of a yield forecasting model hinges on its ability to
accurately forecast yields before actual crop yields are known.
The following two charts show how the model tracks the development
of the corn and soybean crops during the growing season.
As expected, forecast accuracy improves as the crop matures. Note
that the corn model begins (July 16th) with an average accuracy
of about 85 percent compared to over 90 percent for the soybean
model. Although these graphs display average accuracy from 1990
to 1999, it is important to note that if weather conditions in July,
August and September are relatively average, then the forecast accuracy
improves dramatically. For example, in 1995 when weather conditions
were relatively average during the growing season, the model predicted
both soybean and corn yields within 1 percent on July 16th.
The greater the weather deviates from normal during the growing
season, the higher the forecast error is during the beginning of
the crop year. For example, during the 1993 drought year, corn yields
are forecasted to be 25% higher than actual on July 16th. The final
1993 estimate, however, ended up being 100% accurate by Nov 5th.
 

Custom
mapping
Trade Area Solutions offers a full range of custom mapping including
wall maps of the grain handling and transportation system. Please
contact us for pricing.
 
Other
research and
analysis
Trade Area Solutions provides a full range of custom analytics
specific to the needs of your organization.

Print |