Alanco. Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to seli 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. Use the information included in the Excel Simulation and the Excel functions described below to corpplete the task - Cell Reference; Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a biank cell, "ac c4" was entered, the formula would output the result from cell C4, or 27,000,000 in this example - Besic Moth functions: Alows you to use the basic math symbols to perform mathematical functions. You carn use the following keys + iplus sign to add), - (minus sign to subtract). ( (asterisk sign to multply), and / (forward siash to divide) From the Excel Simulation below, if in a blank cell "=C14+C15" was entered, the formula would add the values from those cells and output the result, or 2,900,000 in this example if using the other math symbois the result would output an appropriate answer for its function - If function: Allows you to test a condition and return a specific value is the result is true and different value if the resuit is faise. The symtax of the IF function is "=fF(test_conditionvalue of trie, value if. faise)" and specitic considerations need to be made when using this function The test concution argument is an evaluation of the stafus of a cell, such as if the value of a cell is greater than, less than, or equal to another number or cell. The value if true and vave it false arguments will return aryy specific result for each option, such as another cell refercnce. a value; or text. Throughout the entire equation, If text is being used in the test.conation, value if true, or value if. faise arguments then. the text itcelf should be entered in quotatiors so that Excel will tecognize the text as a "string of text" instead of another funclion. From the Excel Simtiation below, If in a blank cell "sF(CB>1000000, Net income is good", Net income is bad") was eritered, the formula would output the resuit of the value of true since the fest_condition would be resuit as true, or in this case the text "Net income is good" Excel processes the IF function by separatng it out into separate parts. Fust the test condition - Excel thinis, find ceir CB and determune if the vative is greafer than 1,000,000. Once Excer determines if the result of that fest concabon is TRUE or FALSE, wit weturn the value_it true or value if fuse: - Absolute Reference: Allows you to maintain the onginat cell reference when a formula is copicd to another cell. The cell reference is "locked" by puting a dolhar agn (s) before the column and row references. By defautt a cel reference is relative, so when you cogy a formula to another cell the values update based on a relatwe reference. For example, if you copy the formula * 38+89 from cell Cl to cell C2, the formula in cell C2 wil relatwely update to be "- 89+B10 since the copied formula moved down one cea, the formula cell references atso moved down one cell. Conversely, by adding the absowte cell reference "locks* to the taquboa, the formula wil not change when copued to any other celi. For example, s 5858+$8$9 written in cell clis copied to cell c2 the formula in cell c2 will remain "\$858+5659., You can abo use a mixed cell reference by only "locking the column or row oniy (5B8 or 858 ) which iocks that specific column or row and the other reference becormes a relative reference and "moves" with the fornaia as its copied to another cea For formula moved down one cell, the formusa cetl relative references also moved down one cel, but the absolute "locked" reference remained the same For thes project, when using Absolute Cetl kefefencing you can aiso use bre aito-till option, howeves, for proper grading you shouid only auto-til one ceil at o time and not an entire range Alanco, ind manufactures a variety of products and is currently maunfacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following information has been gathered relating to the cost of producing the component internally: Direct materials Directlabor Variable manufacturing overhead Fixed manufacturing overhead, traceable* Fixed manufacturing overhead, common but allocated Total cost $4.006.002.005.008.005.00 supplier price $21.00 Units used per year 12,000 - Fixed manufacturing overhead, traceable is composed of two items: Depreciation of equipment (no resale value) Supervisor salary 30% 70% 1. Assuming the company has no alternative use for the facilities now being used to produce the 21 component, complete the following analysis to determine if the outside supplier's offer should be accepted