Our Work
Examples of Projects Completed by Support Logix
Here is a selection of real-world projects delivered by Support Logix across Supply Chain, Human Resources, Business Analysis, Management Accounting, and Project Management. These examples demonstrate our ability to solve complex problems, improve processes, and deliver measurable value.
Supply Chain
Supply Chain Optimisation Application
Support Logix redesigned a manual Master Scheduling process used across 10 factories by developing a SQL Server–based optimisation application. The system prioritised high-margin sales, allowed product substitutions, and generated fully optimised production plans.
The automated model ran 300% faster than the manual process and could be executed multiple times to refine results. This improved inventory accuracy, reduced forecast shortages, and increased profitability. Support Logix also prepared the full business case for this project.
Human Resources
Data Validation Application
We developed an application that scanned approximately 700 remuneration contract workbooks daily and compared key information against payroll data. This process identified anomalies and reduced payroll errors by highlighting overpayments and underpayments.
Initially built as a VBA application, the prototype was so successful that the client requested a full Functional Specification for a .NET-based production system.
Human Resources
Fully Automated Data Update Application
For the Auckland District Health Board Human Resources Department, Support Logix developed a fully automated VBA application to process Senior Medical Officer (SMO) Job Sizing contracts and increase each SMO’s base salary by one salary step.
The solution automatically updated hundreds of SMO contracts within Excel Workbooks with no manual data entry required, significantly reducing the risk of human error and ensuring accuracy and consistency across all records. The application also automatically saved updated workbooks as new versions, providing a clear audit trail and preserving original files.
By automating what would otherwise have been a highly repetitive and time-consuming administrative process, the solution delivered substantial time savings and reduced operational costs for the Human Resources Department.
Business Analysis
Executive Sales Dashboard
Support Logix created an Executive Sales Dashboard for a food manufacturer. The dashboard provided clear visibility of sales performance metrics, enabling more focused and effective sales management.
HACCP Production Floor System
We developed a Microsoft Access SQL Server Production Floor system that combined recipe instructions with ingredient sequencing and batch tracking. This ensured consistent product quality, improved traceability, and enabled future production planning with accurate ingredient forecasting.
Management Accounting
Standard Labour Cost Review
For an FMCG manufacturer, Support Logix analysed production data, payroll information, and product structures to calculate accurate standard labour costs. This allowed the business to understand true product-level labour performance despite complex multi-department workflows.
Profit & Loss Management Report
We developed a comprehensive Profit & Loss report for a print manufacturer, combining financial and quantitative performance metrics. The report was built in Microsoft Excel and integrated with JD Edwards ERP data using advanced VBA programming.
Project Management
Automated Pavlova Roulade Base Production Plant
Support Logix project managed the initial research phase and secured Callaghan Innovation R&D funding to procure a new automated plant for a dessert manufacturer. This included managing the full lifecycle from design through to commissioning with our preferred project supplier.
The new automated Depositor eliminated seven manual Food Technician roles, delivering major labour cost savings. Increased capacity also enabled the business to take on new export orders. The project was completed on time and within budget, delivering a strong return on investment.
Construction
Quotation and Reporting Access Database
For a Roofing and Cladding Construction company, Support Logix developed a Microsoft Access Quotation and Reporting Database application that enabled data to be captured and processed offline, independent of internet connectivity. The application then synchronised data automatically and frequently with a central SQL Server database once an internet connection became available. This ensured that up-to-date datasets were consistently maintained while eliminating operational disruptions caused by location-based internet connectivity issues.
