Question

solve it with excel please.

PROBLEM 3: A small company that manufactures vibration isolation platforms is trying to decide whether it should upgrade the current assembly system D, which is rather labor intensive, with the more highly automated system C three years from now. Some components of the current system can be sold now for $15,000, but they will be worthless hereafter. The operating cost of the existing system is $210,000 per year. System C will cost $400,000 with a $72,000 salvage value after six years, which is its useful life. Its operating cost will be $75,000 per year. If you are told to do a replacement analysis using an interest rate of 10% per year, which system do you recommend?

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 10 more requests to produce the answer.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
solve it with excel please. PROBLEM 3: A small company that manufactures vibration isolation platforms is...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Please help me with this problem with NO EXCEL. Thank you very much and I will...

    Please help me with this problem with NO EXCEL. Thank you very much and I will rate. In 2018, a certain manufacturing company has some existing semi-automated production equipment which they are considering replacing. This equipment has a present market value of $62,000 and a book value of $34,000. It has five more years of straight-line depreciation available (if kept) of $6,800 per year, at which time its BV would be zero. The estimated market value of the equipment five...

  • Equipment purchased 2 years ago by Newport Corporation to make pneumatic vibration isolators cost $90,000. It...

    Equipment purchased 2 years ago by Newport Corporation to make pneumatic vibration isolators cost $90,000. It has a market value that can be described by the relation $90,000 – $5233k, where k is the years from time of purchase. The operating cost for the first 5 years is $25,000 per year, after which it increases by $5,000 per year. The asset’s salvage value was originally estimated to be $9,000 after a predicted 10-year useful life. Determine the values of CR...

  • Solve without excel: 9.17 A piece of imaging equipment was purchased two years ago for $50,000...

    Solve without excel: 9.17 A piece of imaging equipment was purchased two years ago for $50,000 with an expected useful life of 5 years and a $5000 salvage value. Since its in- stallation performance was poor, it was upgraded for $20,000 one year ago. Increased demand now requires another upgrade for an additional $22,000 so that it can be used for 3 more years. Its new an- nual operating cost will be $27.000 with a $12,000 salvage after the 3...

  • please show how to solve this in Excel. I posted the Excel sheet format it should...

    please show how to solve this in Excel. I posted the Excel sheet format it should look like 13-37 Big-J Construction Company, Inc. is conducting a routine periodic review of existing field equipment. They use a MARR of 20%. This includes a replace- ment evaluation of a paving machine now in use. The machine was purchased 5 years ago for $200,000, The paver's current market value is $65,000, and yearly operating and maintenance costs are as follows. Year, n Operating...

  • peryear interest, perform a replacement study or an for the two trade-in offers. 9.17 A piece...

    peryear interest, perform a replacement study or an for the two trade-in offers. 9.17 A piece of imaging equipment was purchased two usabl estim seco chase annu com annu pany years ago for $50,000 with an expected useful life of 5 years and a $5000 salvage value. Since its in- stallation performance was poor, it was upgraded for $20,000 one year ago. Increased demand now requires another upgrade for an addition so that it can be used for 3 more...

  • Harker Company manufactures automobile components for the worldwide market. The company has three large production facilities...

    Harker 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. In 2018, a certain manufacturing company has some existing semi-automated production equipment...

    6. In 2018, a certain manufacturing company has some existing semi-automated production equipment which they are considering replacing. This equipment has a present and a book valth orsimen ive years tromnw eny a Me) espense and other relaltor the new equipment are S12 100 five years Based on an market value of S58,000 and a book value of $35,000. It has five more years of straight-line depreciation available (if kept) of $7,000 per year, at which time its BV would...

  • A building owner is planning a renovation to an existing building, at an MARR of 12%....

    A building owner is planning a renovation to an existing building, at an MARR of 12%. As part of this renovation, they have two options: 1) Retain the current HVAC equipment, which has a current market value of $12,000. Its operating costs next year will be $3750, and these costs will increase by 35% each year. Its salvage value will decrease by 20% each year. 2) Obtain a new, more energy-efficient HVAC system at a cost of $18,000. It will...

  • please show all steps for thump up do not excel 4. (20 points) A machine purchased...

    please show all steps for thump up do not excel 4. (20 points) A machine purchased 3 years ago for $140,000 is now too slow to satisfy demand. The machine can be upgraded now for $70,000 (and thus be able to satisfy demand) or be sold to a smaller company for $40,000. After upgrading, the existing machine will have an annual operating cost of $85,000 per year, and an estimated life of 3 years after upgrading you will keep the...

  • Lasting Impressions (LI) Company is a medium-sized commercial printer of pro- motional advertising brochures, booklets, and...

    Lasting Impressions (LI) Company is a medium-sized commercial printer of pro- motional advertising brochures, booklets, and other direct-mail pieces. The firm's major clients are ad agencies based in New York and Chicago. The typical job is characterized by high quality and production runs of more than 50,000 units. LI has not been able to compete effectively with larger printers because of its existing older inefficient presses. The firm is currently having problems meeting run length requirements as well as meeting...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT