Aeropets was receiving a massive number of enquiries and the manager and two staff ware working overtime to complete quotes manually. Each quote was taking around 20 minutes to prepare.
Excel Consultingconducted a complete evaluation of how Aeropets was gathering their data via their website. We suggested a number of key improvements that would enable then to collect more accurate information from their website enquiry form. We then updated their existing Excel spreadsheet with normalised data and created a series of pricing rules. Once the pricing was completed, we created a range of quote wording that could be customised for each enquiry. This customised solution was inexpensive and efficient and enabled Aeropets to reduce staff numbers, save time and increase their profit margin. In addition, Excel Consulting are now creating an Access database of all leads and quotes and performing analytics on the leads and sales conversions, email automation, analysing sales profitability), automating aspects of operations and creating stronger business processes for our client.
Our client, Aida Foxtel had received a quote of $250,000 to create a customised iPad app that would help to measure the sales and productivity of their staff without them having to return to the office at the end of the day to complete their daily metrics. The client was on the verge of accepting the proposal when we were contacted. After extensive consultation and a site visit, we developed a customised web based form to capture the sales team data that required at the end of the day. The form was optimised to be used on hand held devices such as an iPhone.
Excel Consulting designed and delivered an innovative, cost effective solution without a major sales system overhaul. We enabled their sales representatives to quickly and easily enter sales data from the road, freeing up their time and enabling them to focus on increasing sales. We were able to save our client more than $250,000, including the purchase of tens of thousands of ipads, streamline their sales reporting process and help them to capture data that was then used to populate various excel based reports that all franchisees nationwide are required to produce. This project required us to be flexible and think outside the box to ensure that our clients’ needs were met.
Eighth Gate required a flexible and robust feasibility model to analyse the economic worth of multiple projects. This complex feasibility model had withstand the scrutiny of independent auditors.
Excel Consulting worked closely with Eighth Gate throughout the lifespan of this complex and rapidly changing project. We Used a combination of excel macros and lesser known built in excel functions to develop a complex, yet easy to use feasibility model structure with many built in features. The client can now evaluate new projects in minutes, enabling them to analyse the best opportunities and successfully launch their first investment product. The model was signed off by independent auditors.