Columbia College Alanco Inc Make or Buy Analysis
Description
PART 1
Alanco, Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. The Controller has asked you to help evaluate this offer to determine if the company should make or buy the component.
Here are some tips for using Excel:
Cell Reference: This allows you to refer to data from another cell in the worksheet. If you entered B5®bsp;into a blank cell, the formula would output the value from cell B5.
Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), – (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered B4+B5®bsp;in a blank cell, the formula would add the values from those cells and output the result. (Use the Excel attached to answer this question).
- PART 2 ( ANWER IN A WORD DOCUMENT 600 WORD MINIMUM)
Based upon the make or buy analysis you prepared, do you recommend that the company make or buy the component? Why?
- Besides the quantitative analysis that you prepared, identify and discuss at least three qualitative factors that should be considered as part of the analysis.
Describe one thing that surprised you or that you will be able to apply to your personal or professional life
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."