ALL ANSWERS MUST BE ENTERED AS FORMULAS

Please answer the yellow boxes

Alanco, the, manufactures a variety of products and is currently manufocturing all of its own component parts. An outside supplier has offered to teil one of those components io Aianco. The Controller has asked you to heip evaluate thes offer to determine if the company should make or buy the compotient. Use the information inchided in the Excel simulation and the Excel functions described below to complete the task: - Cell Reference: Allows you to refer to data from another coll in the worksheet, From the Excel Simulation below, if in a blank cell, "oca" wos enteredi, thio formulo would outpet the fesult from cell 64 , or 27,000,000 in this example. - Basic Math functionsi Allows you to use the basic meth symbols fo perform mathematical functions You can use the following keyst it (iplus sign to odd) - (minitis sign to subtract), "(asterisk sign to muttiply), and/ (forward slash to divide). From the Excel Simulation below, if in a blank cell " "C14+C15" was entered, the formula would odd the values from those cells and output the result, or 2,900,000 in this example. If using the other math symbols the resutt would output an appropriate answer for its function. - IF functions Allows you to test a condition and return a specific value is the result is true and different vaiue if the result is false. The syntax of the If function is "ifftest condition,vatue If thuevatie. . f false)" and specitic considerations need to be made when using this function. The test condition argument is ian evaluation of the status of a cell, such as if the value of a cell is greeter than, less than, or equal to another? number of cell. The wahue it true and value. it false arguments will return any specific result for each option, such as another coll teference. the fext itself should be entered in quotations so that Excel will recognize the text as a "string of text" instesd of another function. From the Ercet simulation below, if in a blank cell "UFF(C)P1000000, "Not income is good": Net income is bad7 was entered, the formula would output the rescit of the walie. if_true since the text_condition would be result as true, of in this case the text "Net income is good": Excel processes the If function by separating it out into separote parts. First the tosk condition-Eycol thinks, find call c8 and defermine if the value as vilitie. It fasse. - Absolute References Allows you to maintain the original cell reference when a formula is copled to another cell. The cell reference is "Tocked" by putting a dolliar sign (\$\$) before the column and tow references. By default a cell reforence is relative, so when you copy a formuia to another cell the values update based on a relative reference. For example, if you copy the formula "-88+B9" from cell ci to ceil C2, the formula in cell C2 will relatively update to be B9+B1 since the copled formula moved down one cell, the formula cell references as 50 moyed down one ceil. Conversely, by adding the absolute cell reforence tocks" to the equation, the formula will not change when copled to ary other cell. For example, " 58$8+$8$9 written in cell Cl is copied to cell C, the formula in cell C2 will remain "\$\$85843859" You con also use a mixed cell reforence by only "locking" the column of row only (\$88 or 8$8 ) which locks that specific columri or row and the other foference becomes a relative reference and "moves" with the formula as its copled to another cell. For formbla moved down sne cell, the formulis cell telative teferences also meved down one ceis, but the absolute "locked" reference remained shotid only suta-fit one cell of a time and not an entife tange. 1. Assuming the company has no alternative use for the facilitics now being used to produce the componeat, complete the following analysis to determine if the outside supplie's offer should be secepto 1. Assuming the company has no alternative use for the facilities now being used to produce the component, complete the following analysis to determine if the outside supplier's offer should be accepted