Case study

Operating Information System

Agriculture, Food & Beverage

Forecast developed an Online Operating Information System for an Australian-owned pork processing and distribution business to replace their Excel-based system, which was becoming increasingly complex and difficult to maintain.


Our client is an Australian-owned pork processing and distribution business operating for over 25 years. Our client provides premium pork products to their customers across New South Wales and Queensland.


Our client relied on a set of Excel files combined with email-extracted RTF files (word document) as the base to manage their operational data. This system has potential issues of:

  • The Excel files are not working as intended, e.g. some buttons are no longer functioning

  • Execution of calculation is not user-friendly: e.g. user needs to execute calculation under Developer mode

  • Increased complexity: with the growth of the business, the logic implemented in Excel has become more complicated and difficult to maintain

  • Key-person Risk: only a few staff know how to maintain the Excel files

  • Human Error Risk: there is a lot of manual manipulation and pasting of data from different sources

Client management would like to retire the current Excel system and is looking for a solution that can manage the operation data in a robust and reliable tool.


Forecast proposed an Online Operating Information System to replace the existing Excel-based system. The solution adopted the typical 3 layers architecture with front, application and database. Some highlights of our approach are:

  • Adapted Amazon Amplify framework for quick frontend development

  • Applied Object-relational mapping (ORM) design pattern

  • Serverless backend architecture

  • Agile delivery

Forecast works closely with the client to understand their existing operation process and then took a user-centric agile delivery approach to lift the current Excel-based system into an eCommerce-ready online tool.


The project is planned to be carried out in several phases. The first phase is to replicate the current Excel-based operation system. The client is satisfied with the outcome of the first phase. The online Operating Information System provides a more robust and reliable way to manage key operational information. It paved way for the next phases to allow optimisation of the process.