Many organisations have a slow down through festive seasons as many people head off on holidays and the volume of work often slows. So if you're lucky enough to be working during a quite time, what procurement tasks can you do to take advantage of the extra flexibility and set yourself up for when the pace picks up again?
As a key component of their goal of making it easier and more efficient for suppliers and agencies to do business with each other, in February this year the Procurement Transformation Division launched a new set of goods and services procurement invitation and contractual frameworks for use by all Government Agencies. If you are a supplier to or a buyer for the Queensland State Government and you haven't familiarised yourself with them yet, then it is high time you did. So what is new and what do we need to know about this new framework?
A critical function of any contracts and procurement process management solution is to generate a unique identifier for each process and contract. I cannot stress enough how important it is to allocate an identifier to a process and to use it for all communications regarding the process and the contract, both internally and externally. Why? Because loss of clarity in communications can result in regrettable errors. In addition to that, if you are managing more than a couple of processes and contracts, tremendous efficiency is gained when you include a direct relationship between a communication, document, record and a process or contract. Often the ID's are generated manually by looking at the last number used and adding one, but this can result in duplications through accidentally re-entering the same number and potential inconsistencies through data entry errors. You may mean to type CAT-112 and instead you type CAT-121. Nine numbers have been skipped, which can be confusing, and you may have actually recorded CAT-112 on all your documents and folders. So in this blog we'll look at a method in our Advanced Excel Contracts Manager to automatically generate and ID using Excel and a bit of VBA.
It is all well to create a complex list of data, but reviewing, adding and maintaining records in the Excel table format when there are more than a few fields quickly becomes slow and unreliable. End users will complain about having to maintain so many fields, managers will want the data displayed as different forms of information and administrators will quickly tire of trying to fix the errors introduced through poor data entry and accidental deletions. This is where the benefit of the Advanced Excel Contract Manager solution in separating access to and maintenance of the data from the raw data sheet delivers a tremendous advantage over basic spreadsheet tables.
Spreadsheets are a powerful and commonly used tool in procurement. Whether used to track what contracts we have, calculate cost, score evaluations or tracking projects. However, few Excel workbooks in procurement really leverage the full power and possibilities of Excel. With just a basic knowledge of the Visual Basic for Applications (VBA) language, you can turn your Excel workbook, into an Excel Application with functionality you never considered possible in a spreadsheet. This is the first in a series of blogs covering the development and use of an Excel Application to build a Advanced Excel Contracts Manager for managing Contract Lifecycle Management (CLM).
A critical component in building a powerful contract life cycle management application in Excel is to determine what data you want to capture and then taking steps to ensure data quality is maintained. It is always a balance between usability and the need to build meaningful reporting. While using a standard format spreadsheet quickly becomes arduous when there are more than 15 fields of data, the Advanced XL Contract Manager provides functionality that makes capturing a hundred fields efficient and easy. There are the obvious fields such as the contract number, title, description, start and expiry dates. But there are a few fields you may not have thought of. In this blog, we'll start with defining the Contract fields and validation methods to make sure our data stays clean.
Establishing and maintaining competitive tension in your procurement processes is the easiest and most effective method of driving value for money outcomes. So what is competitive tension? The most elegant description I have seen is that a proponent perceives a creditable threat to their ability to win the bid. The three key words are "perceives" and "credible threat".
What risks are involved and how can you manage contractors and commercial in confidence issues when you need to bring extra capacity into your organisation. Contractors, contracted resources, consultants, there are many names for the warm body we bring in to the business under contract to provide extra or specialist capacity. For this blog I'll just refer to them as "contractors".