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. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.
Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=C4" was entered, the formula would output the result from cell C4, or 27,000,000 in this example.
Basic Math functions: Allows 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). 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 symbols 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 result is false. The syntax of the IF function is "=IF(test_condition, value_if_true, value_if_false)" and specific considerations need to be made when using this function. The test_condition argument is an evaluation of the status 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 value_if_false arguments will return any specific result for each option, such as another cell reference, a value, or text. Throughout the entire equation, if text is being used in the test_condition, value_if_true, or value_if_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 below, if in a blank cell "=IF(C8>1000000,"Net income is good","Net income is bad") was entered, the formula would output the result of the value_if_true since the test_condition would be result as true, or in this case the text "Net income is good". Excel processes the IF function by separating it out into separate parts. First the test_condition – Excel thinks, find cell C8 and determine if the value is greater 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 orvalue_if_false.
Absolute Reference: Allows you to maintain the original cell reference when a formula is copied to another cell. The cell reference is "locked" 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 cell the values update based on a relative reference. For example, if you copy the formula "=B8+B9" from cell C1 to cell C2, the formula in cell C2 will relatively update to be "=B9+B10" since the copied formula moved down one cell, the formula cell references also moved down one cell. Conversely, by adding the absolute cell reference "locks" to the equation, the formula will not change when copied to any other cell. For example, "=$B$8+$B$9" written in cell C1 is copied to cell C2, the formula in cell C2 will remain "=$B$8+$B$9". You can also use a mixed cell reference by only "locking" the column or row only ($B8 or B$8) 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 "=B$8+B9" from cell C1 to cell C2, the formula in cell C2 will update to be "=B$8+B10" since the copied formula moved down one cell, the formula cell relative references also moved down one cell, but the absolute "locked" reference remained the same. For this project, when using Absolute Cell Referencing, 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.
Answers: 1
Another question on Business
Business, 21.06.2019 21:00
You have just been hired as a financial analyst for barrington industries. unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. so, your first job will be to recreate the firm's cash flow statement for the year just ended. the firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. it earned $5 million in net income during the year but paid $800,000 in dividends to common shareholders. throughout the year, the firm purchased $5.5 million of machinery that was needed for a new project. you have just spoken to the firm's accountants and learned that annual depreciation expense for the year is $450,000; however, the purchase price for the machinery represents additions to property, plant, and equipment before depreciation. finally, you have determined that the only financing done by the firm was to issue long-term debt of $1 million at a 6% interest rate. what was the firm's end- of-year cash balance? recreate the firm's cash flow statement to arrive at your answer
Answers: 1
Business, 22.06.2019 02:00
Kenney co. uses process costing to account for the production of canned energy drinks. direct materials are added at the beginning of the process and conversion costs are incurred uniformly throughout the process. equivalent units have been calculated to be 19,200 units for materials and 16,000 units for conversion costs. beginning inventory consisted of $11,200 in materials and $6,400 in conversion costs. april costs were $57,600 for materials and $64,000 for conversion costs. ending inventory still in process was 6,400 units (100% complete for materials, 50% for conversion). the total cost per unit using the weighted average method would be closest to:
Answers: 2
Business, 22.06.2019 20:20
John has served as the chief operating officer (coo) for business graphics, inc., a publicly owned firm, the past 5 years. which of the following statements about john is correct? both john and the ceo of business graphics must certify to the sec that the firm's financial statements are accurate. as the coo, john will be ranked higher than the ceo but still below the cfo. in john's postition as the coo, it is highly unlikely that he would also be the chairperson of the board of directors. as the coo, john would typically be involved with accounting, finance, and asset purchase decisions.
Answers: 2
You know the right answer?
Alanco, Inc. manufactures a variety of products and is currently manufacturing all of its own compon...
Questions
Computers and Technology, 03.07.2021 04:00
Mathematics, 03.07.2021 04:00
Social Studies, 03.07.2021 04:00
Mathematics, 03.07.2021 04:00
Mathematics, 03.07.2021 04:00
