Analyst: Input-Output Modelling. A Closer Look.

Now that the the Input-Output Modelling tool, for Analyst, is available (read previous blog post here), it is time to take a closer look at one of the new reports, Regional Requirements.

Regional Requirements is just one of six new reports available in Analyst under the Input-Output Module. The report helps quantify the goods and services that a region requires from each industry, as well as the degree to which those requirements are met within the region.

This report can be used to perform comparative analysis of industries across the regions. It can answer questions like:

  • What value of purchases industries are making inside a region?
  • What value of purchases industries are making outside a region?
  • Where jobs are potentially leaking as a result?

This report gives the user two perspectives:

  • Region vs. Industry: what industry demands are being satisfied from within, and beyond the boundaries of a region?
  • The regional supply chain, in the broadest sense, is characterized by the industries within the region

Economic development officials can use this data to enhance their efforts accordingly.  This data can help identify and support:

  • What are all the industries in a region?
  • What industries are primarily using imports to service their needs?
  • Which industries may be able produce locally to reduce or substitute imports?
  • What jobs are need to for import substitution to be locally sustainable?

This report identifies where local demand is being sourced from and whether it is inside or outside the region.

First, identify the region(s) you want and click Run.


A similar table to the one below will appear. Find what level of industry you need by changing the level of NAICS codes, and based on the level you can filter by that NAICS industry.


Demand Met In-Region: amount spent on an industry by all business and population in the given region met within the regional economy

Demand Met by Imports: amount spent on an industry by all business and population in the given region met outside the regional economy

Clicking on any of the column titles will order the table in ascending/descending order to easily find the highest/lowest dollar amount or percentage.


Moreover, selecting the Export button in the top right corner gives you the option to save your findings as an excel file.

One more blog post to come regarding Input-Output Modelling in Analyst.

For the meantime, check out this tutorial of how to navigate and use the Regional Requirements Report or click for more information on Analyst.

New Economic Modelling Tool

Analyst Input-Output Tool

The Ontario Ministry of Agriculture, Food, and Rural Affairs – in partnership with Economic Modeling Specialists International (EMSI) – is excited to announce the addition of a Canadian version of their Input-Output Modelling tool in Analyst.

Input-Output models map out linkages within an economy by tracing the connections between industries, households and government. This is done by tracking the flow of money between those entities within a geographic area (for more background on input-output modelling). Continue reading New Economic Modelling Tool

Cost Of Production Calculators Available To Help With Business Planning

In the complex world of production agriculture, determining which crops will make you the most profit can be a daunting task. To help with decision making, several tools are available for downloading from the OMAFRA web site.

One of these tools is the crop budgeting tool.

The crop budgeting tool provides an easy way to enter your costs, yield, and return expectations. From this you can see whether one type of crop will provide value over another. Each producer will have individual costs for items such as seed, fertilizer, and custom work. By entering these costs, one can see the overall cost per acre to grow the crop. The tool also allows for an optimistic, expected, and pessimistic yield, showing the upper end of returns versus what happens if disaster occurs.

This data can be entered on a per acre basis, or on a total acre per field or farm basis.

The tool includes the ability to select the amount of crop insurance coverage a producer would like.

Figure 1 shows the input for the various yield expectations.


The tool also provides a unique “chance of breaking even” based on the data input. Figure 2.

figure-2-chance-of-breaking-evenSome field crops that have budget tools available are: corn, soybeans, canola, barley, oats and wheat.

There is also horticulture crop, fruit tree and livestock budgets available.

Knowing which crops have the potential to provide profit can assist producers with planning and meeting with suppliers and financial institutions. Knowledge is power, and these are powerful tools to provide that knowledge.

To access these tools, please go to:

The Community-Focused Rural Economic Development Program is Open for Applications

The Rural Economic Development (RED) program helps rural communities remove barriers to community economic development, through support for planning and implementation projects that benefit rural Ontario.

The program is now open and will accept applications until March 31, 2017. A second intake is scheduled for July 31, 2017 to September 29, 2017.

The RED program supports the government’s plan to create jobs, grow the economy, and help people in their everyday lives by:

  • Helping remove barriers to economic development for rural communities, Indigenous communities and organizations, and not-for-profit organizations.
  • Helping rural communities identify their economic strengths and develop strategies to attract business and investment which will help to retain and create jobs.
  • Helping rural communities and partners to be in a more competitive economic position so that they can diversify and grow their local economies – making economic growth more inclusive so that Ontario’s growing economy delivers real benefits to rural Ontario.

Applicants are required to read the program guidelines before completing the application.

For more information on the program, including guidelines, applications, and approved projects, please visit

How to Win Markets and Influence Grocery Buyers – Workshop

Grocery retailers, chefs, and other food buyers are looking for local product and they want to buy local says Erica Pate, a Direct Farm Marketing Specialist at the Ontario Ministry of Agriculture, Food and Rural Affairs (OMAFRA).

“When it comes to buying from farmers and small food processors, there is often a gap between what grocery retailers, chefs, and other food buyers need, when they need it, and how they do business” Erica Pate, a Direct Farm Marketing Specialist

The Town of Georgina in partnership with OMAFRA are hosting a one-day workshop in February that will bring together farmers and small food processors to learn how to address those gaps.

Ministry specialists will help participants learn about potential untapped sales channels that might be right for their business. The workshop will cover a number of topics ranging from market channel opportunities, food regulations, food safety, pricing for profit, packaging and labelling. 

Your business might benefit from selling to a local grocery store or other retailer, a restaurant or public sector organization like a university or school nutrition program. The key is to invest a few hours to learn about different market opportunities and what customers expect.

The Selling Food to Ontario workshop will be held on February 2 from 8:30 am – 3:30 pm at The Link, 20849 Dalton Road, Sutton, Ontario L0E 1R0. The cost of the workshop is $20 per person and registration is now open.

This event is hosted by the Town of Georgina and OMAFRA.

Recent Business Retention & Expansion Project Reports

The Business Retention and Expansion (BR+E) program is a collaborative effort between government, community, and businesses that identifies opportunities to help businesses expand and, retain and create jobs. The program also encourages the implementation of agreed upon activities to achieve goals, and actions to improve the local business climate.

Three recent examples of completed BR+E projects are from the communities of:

  • Lake Country,
  • Orangeville, and;
  • Almaguin Highlands.

Each of these projects identified key opportunities that could help promote business expansion and increase growth for businesses. Continue reading Recent Business Retention & Expansion Project Reports

#Agsplore The North

pic-1-modifiedAt the end of September 2016 a bus load of University 
of Guelph, Ontario Agriculture 
College (OAC) students headed north from Guelph to tour the Nipissing and Temiskaming farming districts. Through pictures and quotes here is a summary of their trip.

Two OAC students from the Temiskaming District, Emily Potter and Tanja Gahwiler, decided their fellow aggies should experience the agriculture found in northern Ontario, so they set about to organize a bus trip to northeastern Ontario.

With assistance and sponsorship from enthusiastic farm associations, the two brought 50 of their fellow students to the region. Continue reading #Agsplore The North

Thunder Bay and Area Food Strategy – Growing Local Economies from the Ground Up

In 2013, a new project—the Thunder Bay and Area Food Strategy—got off the ground in northern Ontario. Drawing inspiration from such trail blazing cities such as Vancouver and Toronto, the Food Strategy is intended as a comprehensive and action-oriented approach to building an economically robust, resilient, and equitable food system. The action plan is based on seven pillars of a healthy and sustainable food system, and was endorsed in 2014 by the City of Thunder Bay and 6 adjoining rural municipalities.

Continue reading Thunder Bay and Area Food Strategy – Growing Local Economies from the Ground Up

2016 Top 5 Award Winning Innovations

On December 7, 2016, Premier Kathleen Wynne announced  the winners of 10th annual Premier’s Awards for Agri-Innovation Excellence. These awards are presented to individuals who have made an exceptional contribution to innovation in the Ontario agri-food sector. The Premier’s award was given to Dairy Quality Inc., a company that created a mobile app that provides farmers with instant and accurate somatic cell counts.  Using the tool, dairy farmers can identify problems and take action before a cow develops advanced mastitis. That’s good news for cows, consumers and for farmers.

Continue reading 2016 Top 5 Award Winning Innovations