Your Cart
Loading

Bid Price Optimizer

On Sale
$795.00
$795.00
Added to cart

Excel tool to set the price of a tender. The Bid Price Optimizer combines your cost estimate and risk register with a model of your competitors' prices, finds the bid price with the highest expected profit within your decision rules, and shows how likely you are to win and how likely you are to lose money if you win.


WHAT IT ANSWERS

  • Which bid price gives the highest expected profit?
  • How likely are we to win at that price?
  • How likely is a loss on the contract if we win?


COST AND RISK

  • Up to 150 cost lines as three-point estimates (minimum, most likely, maximum), with correlation settings
  • Up to 50 discrete risks, each with a probability and a three-point impact
  • DELETE RISK removes the risk in the selected row
  • Overheads, bond, insurance, financing, tender cost, target profit and risk margin, giving the break-even and target price
  • Seeded, correlated Monte Carlo simulation of the total cost: 2,000 iterations to explore, 10,000 for the decision
  • Convergence check that tells you whether the result is precise enough for a bid decision


COMPETITION AND PRICE

  • Up to 10 named competitors plus generic bidders: participation, price level, spread and market co-movement
  • Award on lowest price or on price and quality (MEAT)
  • Ten non-price win factors, scored from 0 to 10
  • For 41 prices plus a fine grid of 21: the probability of winning, the expected profit, the margin if won and the probability of a loss if won
  • One recommended price with a band of prices that earn at least 95% of the maximum expected profit
  • Verdict against your own decision rules: BID, BID WITH REVIEW or NO-BID
  • Quick Start: a first price advice from six inputs, for the go or no-go phase


CONFIDENCE LEVELS

  • Total cost at P50 and at the P-level you choose, for example P80
  • Contingency: the cost at the P-level minus the reference estimate
  • P10 to P90 price range per competitor
  • Probability of winning and probability of a loss if won at every price on the grid


BID HISTORY, STRATEGIES AND CASH FLOW

  • Calibration on your own bid history: log every tender and the published competitor bids
  • Track record with your hit rate and the accuracy of past predictions
  • Four standard strategies (chosen, defensive, aggressive, break-even) and up to three price points of your own, side by side
  • Monthly cash flow with peak funding, financing cost and NPV
  • Sensitivity tornado of the expected profit and a two-way table of price against cost


REPORTING AND GOVERNANCE

  • Nine guided steps on the home sheet, from setup to decision
  • Two-page bid board memo, exported as PDF
  • Word management report and PowerPoint bid board presentation in one click; the text is written from the results of your case
  • Dashboard export as PDF
  • Decision sheet that records the chosen price, the rationale and the approvals
  • Validate inputs checks the estimates, probabilities, competitors and price grid; the dashboard shows when the simulation is out of date
  • Currency label USD, EUR or GBP, set once


VALIDATED AND TRANSPARENT

  • Compared with an independent Python implementation on all 67 evaluated prices: the recommended price is identical
  • The Python reference implementation is in the package
  • Reproducible: the same inputs and seed give the same answer on every computer; the seed is printed on the dashboard and in every report
  • Formulas you can trace on every sheet, with a Methodology Note and a Validation Note
  • Aligned with AACE RP 40R-08 and RP 18R-97 for the cost side, ISO 31000 for the risk register and Directive 2014/24/EU article 67 for MEAT award (alignment, not certification)


IN THE PACKAGE

  • Professional workbooks: one with the reference case (Kestrow Link, fictional) and an empty START workbook for your own tender
  • The simpler Standard workbooks, without bid history, strategies, cash flow and report generator, and a Demo (reference case read-only, 2,000 iterations)
  • Complete User Guide A to Z, Ten-Minute Briefing, Quick Reference and macOS Installation Guide
  • Sample management report and bid board presentation, generated by the tool
  • Methodology Note, Validation Note, Verification Note and Quality and Benchmark Dossier
  • Use case demo report, white paper and intake questionnaire
  • License agreement, disclaimer and privacy statement
  • A second zip with the step-by-step tutorial video and the overview video


REQUIREMENTS AND LICENCE

Built and tested for Microsoft Excel 2016 or later for Windows (Microsoft 365, 64-bit recommended), with macros enabled. The Word and PowerPoint generator needs Word and PowerPoint 2013 or later for Windows. Runs offline; nothing is sent or collected.


Mac: the workbooks are designed to run in Excel for Mac 2016 or later and a macOS Installation Guide is included, but the tool has not yet been field-tested on a Mac. The Word management report and the PowerPoint presentation are not available on a Mac: the generator needs Excel, Word and PowerPoint for Windows. On a Mac you use the PDF exports of the dashboard and the bid board memo. Try the free demo first.


Perpetual licence for one named user on up to two devices; twelve months of free updates.


For business and professional use only. The Bid Price Optimizer is a decision-support tool: results depend on the quality of your inputs. By buying you accept the Quantil License Agreement in the package. You may not modify, unlock, extract or reverse engineer the tool or its code, including with automated or AI tools.

You will get the following files:
  • ZIP (18MB)
  • ZIP (200MB)