Ready to chat data? That's what we're here for
The commercial team at Martin Baker wanted to create a bid pack tool that can be used as a template for generating all commercial bids across the business. This required the input of multiple users and departments across the business, as well as multiple iterations being tracked prior to completion.
The main challenge was ensuring efficiency and transparency throughout the bidding process, as well as tracking various iterations for audit purposes. Due to the nature of the industry, there was a high requirement in terms of security, accuracy and transparency. The solution required it to be intuitive and user-friendly, allowing multiple users across the business to be able to access the tool when required.
The main deliverable of the project was the creation of a “bid pack” template, which allowed multiple users within multiple departments to have access to the same workbook, all without having an impact on each other’s work. Finance, Operations and Commercial are just some of the teams involved in a bid at any given point. Each user would have their own set of login credentials, enabling them to have access to their part of the bidding process.
Multiple data sources were automatically pulled into the tool, which allowed information such as financial variables, bill of materials etc to be collated and shared easily. Users are then able to create the bid by using a checklist of variables, and then allocating certain commercial elements across the bid.
Find out how Excel Automation can help to make your business more efficient
