Required: part 1, section d and f

required: part 2 section b

please include the methods of solving, this question is best solved through excel

A company needs a modern material handling system for facilitating access to and from a busy warehouse. If the company's management use a MARR (given in the below table for each group) in their economic decisions. The company found two systems, the first system is a second-hand and the second system is a new system. The economic consequences of both systems are given in the below table for each group. Make sure that you use the data for your GROUP to answer the following questions: PART1: For the second-hand system alternative: a) Draw the cash flow for the economic consequences. b) Find the present worth, annual worth, future worth C) Find the internal rate of return. d) Is the system economically justified? (explain why). e) Calculate the simple and discounted payback periods. What are the annual savings required for the system to breakeven? PART 2: Considering the two mutually exclusive alternatives and assume permanent need for the system (repeatability assumption). a) Using any equivalency analysis technique of your choice (PW or FW or AW), which alternative should the company pick? (explain why) b) Apply incremental analysis (rate of return technique) to determine the preferred alternative. c) Determine the unfavorable system's investment cost at which the company would be indifferent between alternatives. (For example, if when you analyze the problem, you pick the new system, determine the investment cost of the second-hand system that makes it on same level of economic desirability). Zoom MARR Second-hand System Investment cost $79,500 Annual expenses $21,000 Annual savings $37,100 Useful life Salvage value $10,600 Investment cost Annual expenses First year savings Useful life Salvage value New System $115,500 31,800 $56,200 decreasing by $850 each year thereafter 10.4% per year 8 years 16 years $25,800