+ 61 3 9020 2085 info@parityanalytic.com.au

BUDGETING FOR AUTO-PARTS STORES

Share this article

The Brief

One of the leading suppliers of automotive parts in Australia, servicing both retail and commercial sectors engaged Parity to develop a new budget system.

Our client was using a spreadsheet-based budget process to collect 12-month forecasts from individual stores and aggregating them to an entity level budget. The process was heavily dependent on email, as well as manual entry from members of the finance team.  Due to a rapid growth in store numbers, several months were required each year to produce a budget.  The client needed a better solution, with the key requirements being:

  • Eliminate reliance on email
  • Reduce requirement for manual data entry
  • Significantly reduce the time required to complete the process

Additionally, the user interface at ‘Store’ level needed to be spreadsheet based and similar to the existing system in order to avoid the need for major retraining of store staff.

Our Approach

Parity worked closely with the finance team and key store managers to review the existing processes.  This was then re-engineered to utilise Power Query, PowerPivot and VBA to remove the need for emailing data.  A new, simpler budget tool was developed with single click refresh to import and update all individual store data. The requirement to manually copy and paste data was eliminated, as well as reducing the budget workbook size from 200 to 15 worksheets.

“The entire budget turnaround time was reduced from months to weeks following implementation of the new budget process and tool”

Outcome

The entire budget turnaround time was reduced from months to weeks following implementation of the new budget process and tool.  The client also reduced the effort required by finance team members, as well as significantly decreasing the risk of budget errors by removing the need to email and copy and paste data between spreadsheets.

Share this article
Brownlow Medal Prediction Using Excel Based Machine Learning

Brownlow Medal Prediction Using Excel Based Machine Learning

Brownlow Medal Prediction Using Excel Based Machine LearningShare this articlelinkedintwitterA spreadsheet-based regression model using Neural Networks to rank this year’s medal contendersBy Stephen Huppert and Jack LanghammerIt may not be September, and the finals...

Project Financing

Project Financing

Our client is a leading Australian independent school that regularly places in the top 10 schools for academic results in Victoria. The client needed various…

Fund Modelling

Fund Modelling

The trustee to one of the leading industry super funds in Australia was evaluating alternative strategies to reduce costs to its members, including the option…

TAKE THE FIRST STEP TO BETTER BUSINESS DECISIONS

+ 61 3 9020 2085
info@parityanalytic.com.au

Level 19, 15 William Street,
Melbourne VIC 3000

Home                    Careers

About Us               Contact Us

Our Work              Privacy

Insights                 

QUICK CONTACT