Buy Now

Make or Buy Analysis
Excel and Google Sheets Template

 

Make better manufacturing decisions with our Make-or-Buy Analysis Excel Google Sheets Template. Simply plug in your data and watch our formulas, graphs and dashboards calculate whether you should outsource a process or make it in house. 
Buy Now

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

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now
World-Class Excel University

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog
How-To Videos

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Make or Buy Analysis

Excel and Google Sheets Template

Input direct and indirect costs associated with a specific product. Our Make or Buy Analysis Excel and Google Sheets Template will determine whether it's more economically viable to outsource to produce in-house.

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.

Run up to 8 models in our Make or Buy Analysis Excel Template to help you determine whether to make something in-house or outsource it. All formulas and visuals are pre-formulated for ease of use.

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

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.

Limited

$49

(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment
BUY NOW

Premium + University

$199

($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment
BUY NOW

Premium

$99

($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment
BUY NOW