Production Reporting App

Production Reporting App for a Regulatory Agency

London Yealing Sale
Slider

Client

Formed in 1967, the Ontario Greenhouse Vegetable Growers (OGVG) is a not-for-profit organization that represents over 200 producers of greenhouse tomatoes, cucumbers and peppers representing almost 2,900 acres of hydroponic greenhouse production in Ontario, Canada. OGVG lobbies and conducts research on behalf of the Ontario greenhouse growers and promotes their products through a variety of media.

As a part of their mandate, OGVG reports commodity supply forecasts to marketers on a weekly basis. It collects these data from growers’ voluntarily submissions of their production estimates for the next four weeks.

Business Problem

Prior to the introduction of our Production Reporting App, the production estimates were gathered through the use of several spreadsheets. Each grower received a new spreadsheet to fill-out and email back every week. Once returned, the values were manually aggregated in another spreadsheet for reporting purposes. Some of the challenges that the client was facing included:

  1. For growers, reporting in this manner was a tedious task (their previous submissions were saved elsewhere so finding those values required switching between multiple sources)
  2. For OGVG staff, aggregating and analyzing the data was time-consuming
  3. Historical and more complex data analysis was a non-trivial task

Solution

  • Fully responsive custom-built web application for mobile access
  • Designed to make the submission process as straightforward as possible
  • On-demand report generation

Our Process

Given the clear scope of this project, we were able to capture the application’s needs in a single in-person interview. A high-level specification of the application’s functional requirements also containing a number of mock-ups was completed to confirm that the proposed solution would meet their needs. As each component of the application was implemented, it was sent off to the client for immediate feedback, which was then promptly incorporated. This approach not only allowed the application to fully satisfy the client’s needs and expectations, but also eliminated the need of formal user training since the end-users had been involved throughout the entire process.

Benefits

  • Reduced time to query data and assemble reports
  • Historical data comparison and analysis is now possible
  • Encourages members’ participation so that more data is available for forecasting purposes
  • Streamlined data submission-analysis-report process

Technologies

Our Work