Question

Please using giving excell formulas from this excel document :)

Alanco, Inc 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 output the result from cell C4, or 27,000,000 in this example Allows you to use the basic math symbols to perform entered, the +(plus sign -04-Cis-was entered, the formula wold add the values from those cels and output the result, or 2.900,000 in this example· lf using the other and retun a specific value is the result is true and different value if the result is false. The syntax of the ofthe status of a cell·such as if the value of a cell is greater than, less than, or equal to another number to add),?(minus sign to subtract).·(asterisk sign to multiply. and / (1onverd slash to divide). From the Excel Simulation below. Ifin blank cell C true valve false and specific considerations need to be made when using this funiction. The or cell. The value text. Throughout the entire equation, if text is being used in the test condition, value it true, or value false arguments then the text itself should be entered in quotations so that Excel will recognize the text as a "string of text instead of another function. From the Excel Simulation and value K false arguments wil return any specific result for each option, such as another cell reference, a value, or below, If in a blank cell"-IF value- true since the Net income is good Net income is bad) was entered, the formula would output the result of the would be result as true, or in this case the text "Net income is good. Excel processes the IF function by Excel thinks, find cel C8 and determine if the value is greeter than 1,000.000 Once Excel determines if the result of that test condition is TRUE or FALSE, it will return the value_if true or value it false e Absolute R Alows you to maintain the original cell reference when a formula is copied to another cell. The cell reference is ??cked" by putting a dollar sign ($) before the column and row references. By default a cell reference is relative, so when you copy a formula to another cel the values update based on a relative r relatively update to be 89+810 since the copied formula moved down one cell, the formula cell For example, if you copy the formula88+89 from cell C1 to cell C2, the formula in cell C2 wil also moved down one cell by adding the absolute cell reference "locks to the equation, the formula will not change when copied to any other cell. For example, "-$8s8.seS9" wntten in Cell C1 s copied to cell C2, the formula i, cell C2 wll remain .-S8S8-ses9· You can also use a moed cell by only "locking" the column or row only (388 or B58) which locks that specific column or row and the other reference becomes a relative reference and "moves" with the formula as its copied to another cell. For example, if you copy the formula"-B58 B9" from cel C1 to cell C2·the formula n ce·C2 will update to be "-es8-Bior srce the copied formula moved down one ceil, the formula cell relative you can also use the auto-fill option, however, for proper grading you should only auto-fill one cell at a time and not an entire range. < Prev3 of 3 Next 8 dish

Answer 1

Assuming that the company has no alternative use for the facilities now being used to produce the thermostat, compute the total cost of making and buying the parts. (Round your Fixed manufacturing overhead per unit rate to nearest dollar amount.)
	Per Unit Differential Costs			12000 units
	Make	Buy	Make	Buy
Cost of purchasing		$21.00		$252,000.00
Direct materials	$4.00		$48,000.00
Direct labor	$6.00		$72,000.00
Variable manufacturing overhead	$2.00		$24,000.00
Fixed manufacturing overhead, traceable = $5 x 40%	$1.50		$18,000.00
Fixed manufacturing overhead, common	$0.00		$0.00
Total Cost	13.5	$21.00	$162,000.00	$252,000.00
Alanco should Make the Component.