Make or Buy Analysis
Excel and Google Sheets Template
What's Inside the Make or Buy Analysis Template?
Details | 2 SheetsĀ
Supported Versions (All Features)Ā | Excel 2013, 2016, 2019, Office 365 (Mac)
Supported Versions (Significant Features)Ā | Excel 2010, 2013, 2016, 2019, Office 365 (Mac), Google Sheets
Category | Supply Chains & Operations,Ā Data Analysis
TagsĀ |Ā PMP, Build or Buy, Outsource
Why Professionals Choose Simple Sheets
It's simple. Access to the largest library of premium Excel Templates, plus world-class training.
100+ Professional Excel Templates
Optimized for use with Excel. Solve Excel problems in minutes, not hours.
World-Class Excel University
With our university, you'll learn how we make templates & how to make your own.
How-To Videos
Each template comes with a guide to use it along with how-to videos that show how it works.
Inside Our Make or Buy Analysis
Excel and Google Sheets Template
A Make-or-Buy Decision (also known as Outsourcing Decision) Analysis is a quantitative analysis for deciding whether to produce something in-house or to outsource it to an external vendor.
This is one of our best popular operations and supply chain management templates. There are a few reasons why a company would explore making something internally that they previously outsourced.
1, Quality issues
2. Price increases
3. Product Modification
In the case of one or multiple of those events, a company would run a Make-or-Buy Analysis to help them determine the best path forward.
Start by inputting your Buy Info data in D10 and the following rows in that column. Info includes Item Purchase Cost, Ordering Cost, Order Quantity, Total Ordering Ordering Cost and Holding Cost. Once you input that data you will be given a TTL (Total) cost number.
Starting in D3, input your Forecast Demand Quantity, Direct Material Cost, Direct Manpower Cost, Machine Depreciation Cost, Variable Overhead Cost and Relevant Fixed Cost. That will spit out a TTL cost in D9.
The Make or Buy result will auto populate based on your inputs.
It will show you which decision you should make based off the quantitative analysis, the definiteness of the result and your cost per unit.
There are up to 8 models so you run multiple Make-or-Buy Decisions simultaneously.
On the right hand side of the template are too graphs that showcase the Priority of Make and Priority of Buy for each model.
If that wasn't enough reason to get this template, did you know this template is compatible with Google Sheets? Collaborate with your co-workers in real time and enjoy the cloud auto-save feature of Sheets when you use this template!
If you like this template, you'll also want to check out our Cost-Benefit Analysis and Cost of Quality Templates.
More Operations Templates For You
