This client is in the retail sales industry.
The accounting department had to compile the budgets for all the departments into a comprehensive plan. The new CFO was requesting historical data, trend information and multiple charts for each department every quarter.
A mountain of spreadsheets was assembled and once the scope of the problem was realized, they contacted us.
First we automated the import of the data into a single format. Then we set up a data validation program and let the accounting department manually check all the records for import accuracy over the next few days.
Next we set up a menu and standard charts that could be accessed on demand for any or all the departments. This application was then distributed to all the departments for further validation. Once the application was deployed the client realized they couldn't do without it and live data update was added so that charts and reports could be generated on demand year round.
The client experienced a drastic reduction in expenses immediately. The free flow of information gave the department principals the ability to watch expenditures in a way that had not been available before. This allowed for self regulation that far exceeded previous attempts to curb expenses through policy and quarterly reporting.
Total Hours: 95
The client stated that the application was paid for in two months.