This morning I found myself sending an email to one of my staff members about procurement. This doesn't take into account stupid bolshie bob's new rules that are so ridiculous that he should be brought out of retirement to fix the mess he has created. But no - the ANC rewards uselessness.
Anyway before I head down the bolshie bob bashing route, here's a tutorial on how to go about calculating procurement.
Procurement
This sub element is vital, you have a submimimum of 8 points or you'll drop a level. But it can push you over to another level - so you might as well take it seriously. This is how I go about it
- The measurement period is always 12 consecutive months. I move periods around all the time, more often than not the client hasn't done what they should have and so we have to extend the period. I don't believe that you need to use a financial year, even though the draft verification manual says you do. I suppose once the awesome commissioner reads this post she'll write an opinion saying you must.
- You will need is an income statement for the measurement period.
- You then remove all the things that are not attributable to suppliers or service providers, thinks like commissions, salaries, bad debts and depreciation. This list is referred to as either total measured procurement spend (TMPS) or eligible procurement.
- I then send this list back to the client and ask them to break those figures down into suppliers and the amounts spent with that supplier. I always want this in Excel. Often I get the GL which can take hours to sort out. It does happen quite regularly that the description in the GL is a name that is not the name of the supplier. I'm now a little more resolute with my clients. I WANT IT IN EXCEL AND SUMMARISED
- At the same time I request the CapEx figures in EXCEL AND SUMMARISED!
- I then sort all of this information into largest to smallest, I will then look for the largest suppliers' BEE scorecards here. The Beagle database is quite good. I'll get most of the stuff I want from here. It is a manual and laborious process.
- You then populate your spreadsheet with the following columns
Supplier | LEVEL | TOTAL EXCL | Recognition level | TOTAL PROC based on multiplier | QSE | EME | BO | BWO | Designated |
-
- Supplier name
- Level
- Total spend with them excluding VAT
- Recognition level, i.e a level 8 is 0.1 and 4 is 1
- Multiply the total by the recognition level
- If it's a QSE then put the TOTAL PROC amount in the QSE column, this applies to all the divisions
- Now onto BEE certificates. There is a simple rule here - if that certificate was valid for one day of the verification period then we can use that certificate. Sometimes the prior, expired BEE certificate has higher black ownership levels or levels than the new one. I'll use that one. This file has annotations in it explaining how to read a BEE certificate
- And then you total it all up and put it into the procurement scorecard as a percentage.
OR - YOU COULD OUTSOURCE A LARGE AMOUNT OF THIS
The people at ProcureActiv have been harassing me to review their system. I did use it for a client at verification which helped me a great deal. They don't specifically want once off engagements they will manage all your suppliers and possibly refer you to better performing ones. They do this monthly for a sum per certificate per month. Contact Dijon de Jager at ProcureActiv and tell him I SENT YOU. I'm going to get some commission from all these referrals, which means that I might actually get some money from this blog. In essence I will be a professional blogger - I do depend on you to use the system for me to become independently wealthy.