A franchise comptroller came to us with some basic spreadsheets in Excel she was using to run the show: analyzing sales, forecasting inventory, reporting payroll, etc.
Her spreadsheets worked perfectly until the franchise grew to two stores… then three… then four.
–Enter Mongoose Coding.–
Now, each store manager has a system they use to manage their own data. And the comptroller has a system to manage and compare every stores’ performance.
Store managers can only see their information. They have beautiful interfaces to enter payroll and inventory figures, etc. Reports can be generated by department, category, salesperson or date. Managers are alerted when they are low on inventory and when to buy more.
The comptroller sees all stores’ information in real-time. Because we’re using a hosted database (Excel ‘talks’ with the hosted database), simultaneous users see information updates within about a second. Comparison reports are the focus – to find what’s working and what isn’t.
Now, no one has to juggle burgeoning number of workbooks – one per pay period per department (per store). Everything is simple, standardized and in one place.
***Note that this is a common thread among some of our clients – the business grows faster than the software systems can support.