Question

In: Accounting

A company needs a modern material handling system for facilitating access to and from a busy...

A company needs a modern material handling system for facilitating access to and from a busy warehouse. If the company’s managementuse a MARR (given in the below table) 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.

MRR=17.1% per year


For Second-Hand system:

Investment Cost= 164500$

Annual expenses=46700$

Annual savings= 82600$

Useful Life = 10 years

Salvage Value = 34500$


For New system:

Investment cost =324000$

Annual expenses=121600$

First year savings=171300$ increasing by 3200$ each year thereafter

Useful life=20 years

Salvage value=108400$


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.

f) What are the annual savings required for the system to breakeven?

This question is best answered through excel. Please include the methods of solving.

Solutions

Expert Solution


Related Solutions

A company needs a modern material handling system for facilitating access to and from a busy...
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. PART 2: Considering the two mutually exclusive alternatives and assume permanent...
A company needs a modern material handling system for facilitating access to and from a busy...
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 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. Answer the following questions: MARR= 22.5% per year For Second-Hand system: Investment Cost= $146,600 Annual expenses=$17,300 Annual savings= $61,000 Useful Life...
A company needs a modern material handling system for facilitating access to and from a busy...
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) 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. PART1: For the second-hand system alternative: a).Calculate the simple and discounted payback periods. b).What...
The New York City subway station needs a modern transport solution for accessing a busy maintenance...
The New York City subway station needs a modern transport solution for accessing a busy maintenance depot that services the L train. A second-hand system will cost $60,000; a new system will cost \$135,000. Both systems have a useful life of 6 years. The market value of the used system is expected to be $45,000 at the end of the useful lifetime, whereas the market value of the new system is anticipated to be $55,000 in 6 years. Current maintenance...
The New York City subway station needs a modern transport solution for accessing a busy maintenance...
The New York City subway station needs a modern transport solution for accessing a busy maintenance depot that services the L train. A second-hand system will cost $75,000; a new system will cost $150,000. Both systems have a useful life of five years. The market value of the used system is expected to be $20,000 at the end of the useful lifetime, whereas the market value of the new system is anticipated to be $50,000 in five years. Current maintenance...
An expenditure of $25,000 is made to modify a material-handling system in a small job shop....
An expenditure of $25,000 is made to modify a material-handling system in a small job shop. This modification will result in first-year savings of $2,500, a second-year savings of $4,200, and a savings of $5,500 per year thereafter. How many years must the system last if an 15% return on investment is required? The system is tailor made for this job shop and has no market (salvage) value at any time.
Apricot Computers is considering replacing its material handling system and either purchasing or leasing a new...
Apricot Computers is considering replacing its material handling system and either purchasing or leasing a new system. The old system has an annual operating and maintenance cost of $31,000, a remaining life of 8 years, and an estimated salvage value of $5,800 at that time. A new system can be purchased for $237,000; it will be worth $26,000 in 8 years; and it will have annual operating and maintenance costs of $19,000/year . If the new system is purchased, the...
Dell is considering replacing one of its material handling systems. The old system was purchased 7...
Dell is considering replacing one of its material handling systems. The old system was purchased 7 years ago for $130,000 and was depreciated as MACRS-GDS 5-year property since the system is used in the manufacture of electronic components. It has an annual O&M cost of $48,000, a remaining operational life of 8 years, and an estimated salvage value of $6,000 at that time. A new system can be purchased for $175,000. It will be worth $50,000 in 8 years, and...
The company is considering the installation of a high-end server for handling the system with the...
The company is considering the installation of a high-end server for handling the system with the first initial cost of $25,000,000. This system will save $7,500,000 per year in spare part cost, but it will incur $2,750,000 in annual operating and maintenance expenditures. The salvage value at the end of the system’s 4 years' life is $1.500,000. At the end of the project, the company will invest the new server for the next 4 upcoming years with initial the initial...
Providing access to healthcare providers and securing a system from inappropriate access can be a difficult...
Providing access to healthcare providers and securing a system from inappropriate access can be a difficult balancing act. In many cases, the more secure a system is, the more restricted access to that system becomes. Discuss situations where this balancing act has created conflict or might create conflict within the clinical area and how that conflict was (or could be) managed.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT