-
Excel workbook preview
Project Procurement and Contracts
Make or Buy Analysis Calculator
3 downloads per free account, no card needed.
Who this is for
A project manager whose sponsor or board asked whether to build in house, buy a product or outsource the service, with costs and reasons on one page.
What is inside
- 12 worked cost lines across 3 options (make, buy, outsource) over year 0 to year 5
- Present value per line with Excel NPV() at the discount rate on the Settings sheet
- 5 weighted non-cost criteria scored 1 to 5 per option, weights checked to total 100%
- Result sheet: total cost, present value, cost score, criteria score, combined score and rank
- Recommendation cell names the highest combined score, live from the data
- Cost and criteria weights adjustable, with the delivery model assessment idea from the Sourcing Playbook
How to use it: Enter your cost lines per option and year on the Costs sheet, set the discount rate and weights on Settings, and score the criteria with the people who will run the result.
Files & formats
- XLSXmake-or-buy-analysis-calculator.xlsx14 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public or openly licensed guidance named here. They are not legal or contractual advice and are not endorsed by its publisher.


