1 answer

Correct Answer is -538998.72, please show all calculations/functions used in Excel. (note that negative sign simply...

Question:

Walmart is trying to compete with their competitors by enhancing the shipment. To do so, the company wants to replace its fork trucks with 25 robots. The new robotic system will have the following characteristics Initial cost per robot: $95,000 Annual Maintenance cost per robot: $450 increasing by $20 per year Batteries are rechargeable, but they will need to be replaced in Year 3 and Year 6 at a cost of $1,800 per robot YearCapital Maintenance Battery cost Net cost If the companys MARR is 8%, what is the Annual Equivalent cost of this project? Annual Equivalent

Correct Answer is -538998.72, please show all calculations/functions used in Excel. (note that negative sign simply means output, sign does not matter, so 538998.72 is correct)

Walmart is trying to compete with their competitors by enhancing the shipment. To do so, the company wants to replace its fork trucks with 25 robots. The new robotic system will have the following characteristics Initial cost per robot: $95,000 Annual Maintenance cost per robot: $450 increasing by $20 per year Batteries are rechargeable, but they will need to be replaced in Year 3 and Year 6 at a cost of $1,800 per robot YearCapital Maintenance Battery cost Net cost If the company's MARR is 8%, what is the Annual Equivalent cost of this project? Annual Equivalent

Answers

Let's calculate the annual cash flows per robot as shown below:

CF0 = -95,000, CF1 = -450, CF2 = -470, CF3 = -490 - 1800 = -2290, CF4 = -510, CF5 = -530, CF6 = -550 - 1800 = -2350

Calculate NPV using 8% = NPV(8%, -450...-2350) - 95000 = $99,853.96

Annual equivalent cost can be calculated using PMT function = PMT(rate = 8%, nper = 6, pv = 99,853.96, fv = 0, 0) = $21,599.95

Hence, for the entire project, annualized cost = 21,599.95 x 25 = $539,998.72

.

Similar Solved Questions

1 answer
Sales (1000s of gallons) 18 Week 19 23 17 16 20 17 23 19 10 12...
Sales (1000s of gallons) 18 Week 19 23 17 16 20 17 23 19 10 12 a. Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. 4 Period Period Moving ge Average Moving Averag WeekSales 18 19 23 17 16 19.6x 20.25 V 1911 19.4| 20 19.2x 19....
1 answer
23.9 Draw the product of the Michael addition (a) NO, (b) NO2 NO2 CN CN CN...
23.9 Draw the product of the Michael addition (a) NO, (b) NO2 NO2 CN CN CN سله الله .. دولت بهار (d) "NO: (e) NO2 CN CN e d." 23.9 Draw the product of the Michael addition. NaOET EN NO2 connect the a-ca...
1 answer
Consider 5 kg of Oxygen (O2) gas. It starts at: P1-5 bar, T1-400 K and through...
Consider 5 kg of Oxygen (O2) gas. It starts at: P1-5 bar, T1-400 K and through a process goes to p2-2 bar, T2-500 K Assume it behaves as a perfect gas. Find the change in entropy of the gas....
1 answer
Trophy Fish Company supplies flies and fishing gear to sporting goods stores and outfitters throughout the...
Trophy Fish Company supplies flies and fishing gear to sporting goods stores and outfitters throughout the western United States. The accounts receivable clerk for Trophy Fish prepared the following partially completed aging of receivables schedule as of the end of business on December 31, 20Y6: ...
1 answer
Are my answers correct? 5. Gravetter/Wallnau/Forzano, Essentials - Chapter 15 - End-of-chapter question 18 A recent...
Are my answers correct? 5. Gravetter/Wallnau/Forzano, Essentials - Chapter 15 - End-of-chapter question 18 A recent study indicates that people tend to select video game avatars with characteristics similar to those of their creators (Bélisle & Onur, 2010). Participants who had created ...
1 answer
15. Combining raw materials M and M2 and labor, a company produces units of A. B, and C. The requ...
15. Combining raw materials M and M2 and labor, a company produces units of A. B, and C. The requirements and profit (excluding the cost of labor) for the production and sale of a unit of each are as follows: Mi (lb) M2 (lb) Labor (hr) Profit (S) 105 165 60 12 For the next month, the company has ava...
1 answer
What would the signal look like for the indicated H atom in the 1H NMR spectrum...
What would the signal look like for the indicated H atom in the 1H NMR spectrum of the following molecule? What would the signal look like for the indicated H atom in the 1H NMR spectrum of the following molecule? singlet doublet triplet quartet quintet (5 line pattern)...
1 answer
Implement a boolean expression
implement the following boolean exression using 1-2 decoders and basic gates (inverter, AND, OR etc)...
1 answer
Part of your company's accounting database was destroyed when Godzilla attacked the city. You have been...
Part of your company's accounting database was destroyed when Godzilla attacked the city. You have been able to gather the following data from your files. Reconstruct the remaining information using the available data. All of the raw material purchased during the period was used in production. (...
1 answer
Suppose that a second shift is added to the assembly department. what is the new capacity...
suppose that a second shift is added to the assembly department. what is the new capacity of the assembly department Below is the XYZ operation. Molded Parts Mold Parts Finished Componen Final Assembly Purchased Pary Vnventory Purchase Parts from Vendors Assumptions 1) One worker is needed to opera...
1 answer
A guitar string is 60.0 cm long and has a mass of 0.720 g. From the...
A guitar string is 60.0 cm long and has a mass of 0.720 g. From the bridge to the support post L = 50.0 cm, and the string is under a tension of 12.0 N. What is the speed of the wave in the vibrating string? What are the frequencies of the fundamental and the first two overtones?...
1 answer
Please explain how to do this 9. For the following reaction, 2 H2(g) + 2 NO...
please explain how to do this 9. For the following reaction, 2 H2(g) + 2 NO (g) → N2(g) + 2 H20 (g) the rate law is: rate = k[H2][NO]?. At a given temperature, what is the effect on the reaction rate if the concentration of H2 is quadrupled and the concentration of NO is doubled?...
1 answer
Part 2: Solving Problem (show all your works and calculation, and write the formula that you...
Part 2: Solving Problem (show all your works and calculation, and write the formula that you choose from formula sheet and find your answer for solving each problem) 1- A 12 kg box is being pulled up an incline by a rope with force 120 N and moves up. The floor is rough and has angle of 200 related ...
1 answer
Question number 4, draw the products of the following reactants Ple 3. The conversion of cyclohexene...
question number 4, draw the products of the following reactants Ple 3. The conversion of cyclohexene to adipic acid is classified as what type of reaction ondONDA akene an up any spills oresent any unusual 4. Draw the products of the following reactions: r bar, add 7.4 gof cy ttach a fractionatin ad...
1 answer
5.What is the regular payment of the annuity if one needs to pay semi-annually, the future...
5.What is the regular payment of the annuity if one needs to pay semi-annually, the future value is P275,000.00 with an interest rate of 3% compounded quarterly, and the total payment of 20?...