With a large sales force across the US, this company needed a better way to process quotes, orders and proposals. Using custom spreadsheets was too slow and creating proposals from scratch cumbersome.
Using Access and SQL Server, AccessExperts.net was able to design a custom quoting and pricing tool for a large sales force covering the entire USA. Quotes are delivered electronically to corporate and approved, modified or rejected as needed. Quoting time has been reduced from hours to minutes and quotes can now be done with Word templates distributed from corporate.
With many sales people around the US, this company was having a terrible time trying to process quotes and orders via email and fax. Communication between corporate and sales people was so bad, they gave corporate the nickname, “Black Hole”, since information would be sent to them, but nothing would be heard back. Sales people would type information into Excel, and then corporate would type it into Access and Oracle. All that repetitive typing consumed time and introduced errors into the process.
For the Salespeople, AccessExperts.net designed an Access database that allowed them to keep track of customers, easily create proposals and orders and to electronically submit either to corporate for approval. They are then imported into SQL Server at corporate and routed to the correct person for processing. Sales managers get copied on all documents, thus allowing them to gauge the performance of the salesperson. The SQL Server would email back to the engineer when the proposal was received and who it was assigned to. More emails go out when the order is approved and entered into Oracle.
Using Access, SQL Server and the Internet, we were able to reduce quote times by 75%, increase customer service and eliminate the paperwork needed to review and process orders.