Developed an Excel-based tool to quickly generate cable tray quotations for the Canadian head-office of Thomas & Betts, a manufacturer and distributor of electric and electronic components. Inside sales reps at Thomas & Betts needed a tool to easily and quickly generate quotations for a line of cable tray systems composed of thousands of part numbers for multiple brand names. The Excel-based tool required minimal input from representatives, searched multiple pricing/part number databases for each brand name, and generated a comprehensive quote document ready to be faxed or emailed to potential clients. The tool also allowed testing and comparison of different discount scenarios.
Development of Tool to Generate Price Quotes (Thomas & Betts)
