Project Description

Excel VBA application for a financial team to track product SKU codes and manage pricing.

A leading beverage distribution company needed a way to calculate profitability on each promotion that they ran with large supermarket chains and their distributors. They hired us to provide a solution for the finance team to manage SKU’s and pricing, while giving the sales teams flexibility to discount for additional sales, all with formal margin control.

The solution was built using advanced VBA within Excel to process product pricing data and utilising Excel tables and chart functionality.
The build took 3 months using an agile based project approach. The development team size was 1.