Create an excel spreadsheet to conduct a make or buy analysis of the

Procurement: Make or Buy?

Whether we are talking about purchasing for project management or operations management, most major purchasing decisions are made only after the completion of a “make-or-buy” analysis. Essentially, is the business able to cost effectively complete the work in-house (make), or would it be more cost effective to outsource the work (buy)?

When a manufacturer assembles parts to produce a finished product, mangers must first decide whether to make or buy those individual components. Consider a motorcycle. The manufacturer can either make or buy the wheels, seats, gas tanks, etc. used in the finished bike.

When you’re first trying to understand the concept of a Make-or-Buy Analysis, it helps to think of a DIY project you’ve undertaken. I can use the example of an oil change. An oil change for an SUV can cost in excess of $40. On the surface it may seem like the price is not worth it. After all, how much does a few quarts of oil cost, right?

Now let’s really think about everything that needs to happen to successfully change the oil in an SUV. Do you have the know-how to accomplish the job? Do you have the tools needed? Are you willing and able to get under the vehicle? Do you have a means of disposing of the old oil? How much value do you place on your time?

That last question might be one of the most important of all. Chances are good you would say an hour’s worth of your free time is worth at least $40. Since this would likely take an hour plus the expense of oil, tools and disposal, is it really worth doing it yourself?

Create an Excel spreadsheet to conduct a make or buy analysis of the following:

You manage a large multi-national business that manufactures/builds commercial airliners. In an effort to reduce costs, you are considering outsourcing some of the parts used to build the planes. You start with the parts that are used most often. We will call these “A” parts.

The estimated costs of producing 8,000 “A” parts in house are:

Per Unit

Total

Direct Materials

$13

$104,000

Direct Labor


10

80,000

Applied Variable Factory

Overhead

11

88,000

Applied Fixed Factory

Overhead


15

120,000

$49.00

$392,000.00

You can buy this part from a supplier overseas for only $41.49 each. You have never worked with this supplier before, but the price difference appears as if it could save your organization some money.

If you purchased from the supplier, 50% in fixed factory overhead would be saved. (NOTE: Keep in mind that Fixed overhead is overhead you must pay even if the factory is not producing anything!)

Using Excel, perform the calculations necessary to determine if you should make or buy.

Upload your Excel spreadsheet AND in the comments section of the D2L assignment screen, explain what you think you should do based on ALL information available. Is it worth outsourcing this part?

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
Hello, welcome to our site. Kindly send us a message and we will be in contact with you right away. "We are simply the best"