Question 2 Pina Colada Company manufactures automobile components for the worldwide market. The company has three large production facilities in Virginia, New Jersey, and California, which have been operating for many years. Brett Harker, vice president of production, believes it is time to upgrade operations by implementing computer-integrated manufacturing (CIM) at one of the plants. Brett has asked corporate controller Connie Carson to gather information about the costs and benefits of implementing CIM. Carson has gathered the following data: Initial equipment cost $ 6,678,000 Working capital required at start-up $ 667,200 Salvage value af existing equipment B2.475 Annual aperating cost savings $ 934,920 Salvage value of new equipment at end of its useful life $ 222,GOD Working capital released at end of its useful life $ 667,800 Useful life of equipment 10 years Pina Colada Company uses a 12% discount rate. Click here to view the factor table. Your answer is correct. Calculate the net present value of Pina Colada's proposed investment in CIM. (For calculation purposes, use 4 decimal places as displayed in the factor table provided and round final answer to O decimal place, e.g. 58,971. Enter negative amounts using a negative sign preceding the number, e.g. -59,991 or parentheses, e.g. (59,991).) Net present value $ 165 EHS SOLSTION SHOW ANSWER LINK TO VIDEO your answer is correct. Use Excel or a similar spreadsheet application to calculate the internal rate of return on Pina Colada's proposed investment. (Round internal rate of return to 2 decimal places, e.g. 15.25%.) Internal rate or retum 5.31% EROSOLUTION SHOW ANSWER LINK TO VIDEO "Your answer is partially correct. Try again, Andrew Burr, manager of the Virginia plant, has been looking over Carson's information and believes she has missed some important benefits of implernenting CIM. Burr believes that implementing CIM will reduce scrap and rework costs by $166,950 per year. The CIM equipment will take up less floor space in the factory than the old equipment, freeing up 6,000 square feet of space for a planned now research facility. Initial plans called for renting additional space for the new facility, at a cost of $22.26 per square foot. Calculate a revised net present value and internal rate of return using this additional information. (For calculation purposes, use 4 decimal places as displayed in the factor table provided and round final answer to O decimal places, e.g. 58,971. Round internal rate of return to 2 decimal places, e.g. 15.259.) Net present value Internal rate of retum 11.00% Does your recommendation change as a result of this new information? [Yes