Project Procurement Make or Buy Analysis
The following project procurement make or buy analysis spreadsheet considers two straightforward options: procuring from a 3rd party supplier and procuring internally. Keep in mind that many projects will face additional procurement options and considerations. The attached make or buy procurement analysis example includes a basic analysis using NPV and IRR, as well as a graphical representation of payback over time.