A large coffee & donut franchisee with many locations was tracking sales by having store managers prepare a daily spreadsheet that was sent into franchise headquarters. This reliance on human input left the system fraught with errors. Data was copied incorrectly when transferring information from individual sheets to summaries, and other problems arose because of the "guerrilla" process the client was using.
P2 Automation used Microsoft Access to build a simple Sales Tracking Entry Program with a hosted SQL Server back-end. P2 Automation also provided a link that fed information from the point-of-sale system used at store locations directly into an Access-based reporting system. This link enabled managers to compare sales to same period last year, by day, week, month and/or year. And when they need deeper analysis, our client's store managers can "drill down" into the data to uncover the details behind the trends.