SpendLogic works with government primes and subs to unlock organizational savings and fix procurement compliance issues. Our software solves the top three CPSR findings: Price Analysis, Commercial Item Determinations, and Source Justifications.
In this video, we will show you how to use SpendLogic to document a competition that was awarded based on low price.
Hi, I’m Patrick Mathern, founder of SpendLogic. We work with government primes and subs to unlock organizational savings and fixed procurement compliance issues. In this short video tutorial, I’m going to show you how to use SpendLogic to create a price analysis documentation of a competition that was awarded based on low price. Let’s get started. From any screen in SpendLogic, click Start a New Report and choose Price Analysis. This opens the Procurement tab.
Here, we will be providing information that will be used in the header of our final report. The information on this screen is also what’s used for the search report screen. Anything you type here becomes a searchable data item. Complete each of the fields on this screen. When you get to the bottom of the screen, indicate that you wish to write a competitive report. Then click Next. Now, you’re on the Parts tab.
Much like other methods, we’re now asked to identify what parts will be included in the competition. Adding parts is simple. Begin by typing the part number in the Part input box. If this part already exists in the system, you can choose it from the list. If your part doesn’t show up in the list, simply choose Create a New Part. Input the part number and description.
Then click Save. A best practice is to go to your ERP or purchasing system and copy the part number and description exactly as it’s shown there. Now, indicate the quantity that you’re buying. This should match the quantity that you included in the RFQ. You can continue this process for each part that is included in the competition. When you’re done adding parts, click Next. This brings up the Competition tab.
In the left-hand navigation, you’ll see that we’re on the Competition Details screen. On this screen, we’re providing a couple of facts about timing and then specifying the nature of the competition we’re conducting. The first two items ask if all the bidders received the RFQ or RFP on the same date, and whether they’re required to respond by the same date. Since providing some bidders with more time than others could provide an unfair advantage, indicating this fact will require additional explanation in order to proceed.
In this example, I’ll indicate that all RFQs and bids were released and received at the same time. Next, we need to specify the type of competition. Our choices are Lowest Price, Technically Acceptable, and Best Value. Lowest Price competitions are scored solely on price, whereas Best Value competitions are scored on price and other criteria that you specify.
Choose the award methodology that matches that which was included in your RFP or RFQ. In this example, I’ll choose Lowest Price. The last question on this page regards your intent to award a purchase order to one bidder or to multiple bidders. Choosing multiple will result in a mini-competition for each part and could result in multiple awards. I’m going to start with single award and come back and specify multiple to show you the differences.
When you’re done with this screen, click Next. On the Bid Details page, you see a blank chart that shows the parts and quantities that were indicated on the purchase order detail screen. Remember, if you ever want to add more parts, just click that Parts tab. It’s time to add bidders. Clicking add bidder brings up a new screen. Here, we can add some key information about our bidder, beginning with our bidder name and size classification.
As you type in the name of the supplier, note that it appears at the top of this screen. This will remain visible throughout these Bid Details screens and becomes important when you have multiple bidders. Next, we’re asked whether the bidder responded with a bid or a written no bid. If no response at all was received, the bidder should not be included in these screens. You’re then required to upload a copy of the bidder’s response, whether it’s their quote or their written no bid.
Last, you can indicate whether this bid was included in the competition. If you indicate that this bid was removed for technical reasons or was outside the competitive range, additional explanation will be required. When you’re done with these steps, click Next. Now we’re asked to input the actual bid. At the top of the screen, you can see which bidder’s quote we’re looking at as well as which part number. The quantity shown in the header is the quantity that was included in the RFP.
The first box has already been filled in for us. SpendLogic assumes that in most cases, the bidder will respond with a quantity that matches the RFP or RFQ. However, if your bidder chooses to include a different quantity, for example, if they have capacity constraints, you can input a different bid quantity here. Doing so requires additional explanation.
For now, I’ll leave it the same quantity as the RFQ. Next, we’re required to input bid amounts for recurring and non-recurring. Input the exact prices as provided by the bidder. The bid adjustment boxes would be used if your competition resulted in bids that were not directly comparable. For example, if your RFP requested pricing for widgets, and one bidder included pricing for widgets plus carrying cases while the others did not, you would then use the bid adjustment to remove the cost of carrying cases.
Positive values will add scope and adjust bids upward while negative values will remove scope and adjust bids downward. If a value is added in this box, you’re going to be required to provide additional explanation. When you’re done, if there are additional parts, click Next. When you’ve made it through all the parts, click Done. Now, our chart has one bidder included. To add additional bidders, simply repeat the process by clicking Add Bidder and follow the same steps we just covered.
I’ve gone ahead and done this already to show the results. At this point, we have in front of us the completed bid table. In green, SpendLogic shows which bidder is recommended for award. Since we chose single award on the competition details page, all quantities were awarded to one bidder. Now, let’s look at a scenario where a decision has been made to award to multiple bidders. To do this, return to the competition details link in the left-hand navigation.
Here, you can modify the award selection so that multiple awards may be made. Clicking Next, you now see that our award recommendation has changed. Each bidder has been awarded a portion of the total based on their bid. Another feature of SpendLogic is the ability to override the award. This comes into play if you determine that you need to award to multiple bidders due to dual-sourcing requirements or for capacity constraints.
To see this in action, click Override Analysis on the line item you wish to split. This brings up the Override Award screen, which requires you identify the quantities assigned to each bidder as well as provide the appropriate rationale. Once you click Done, you’ll see that the award has been moved to the other bidder. You’ll also notice that the competition is shown as modified.
Clicking this link allows you to change the awardee, the rationale, or remove all modifications. Once I remove modifications and click done, you can see that it reverts back to the original award state. Once the table reflects your intended award methodology, include a short competition summary. This is especially important if the override button was used or if there are any special considerations that a reviewer would need to know.
When you’re done, click Next. This is our Risk Check screen. As with all methods, if you see a lot of red flags on this screen, it means that your report is likely to be scrutinized. Try to minimize the number of risk checks that are shown. For those that can’t be removed, make sure your explanations are complete. Click Continue. Now, we’re on the Reports tab.
From here, you can either finalize or download your report. Remember, until a report is finalized, any updates to the BLS, which automatically take place monthly in the background, may result in changes to this report. Finalizing a report means it’s frozen in time and will not change. That brings us to the end of this tutorial. Thanks for watching. If you have any questions about this or any other feature in SpendLogic, go to spendlogic.com/help or email us at [email protected]