Question

Your company is upgrading the breakroom and kitchen. It is going to include an expresso machine, a fridge with compartments for each employee, a sink, microwave, toaster oven, tables chairs, a rock wall, snacks for everyone, and maybe some other bells and whistles. Your managers think that by updating this area employees will not take as long of lunches. They understand this purchase will be at a cost. You are tasked with considering two different options and presenting them to management. Use a 5% interest rate. Walmart Kit Target First Cost $40,000 $65,000Annual Maintenance Cost $10,000 $12,000Salvage Value $12,000 $25,000Life Years 3 6 a. Using NPW (Net Present Worth Analysis) analysis determine which kitchen kit you should chooseb. Using EUAW (Equivalent Uniform Annual Worth) analysis determine which kitchen kit you should choose. C. You really want the Target kit because it looks nicer and has more bells and whistles. You are willing to keep these products around for longer and therefore extend the lives of these products. Perform the analysis to show that the Target option is the better choice. d. Now from your analysis in part b think about how ethical presenting this information to management would be. Write 2-3 sentences about how you would present this information in a way that showed your bias. You will be graded on your ability to consider two options in an ethical comparison and how you perceive your bias.

Answer 1

Answer:

1. In a Year 20,367 20,017

2. In a Year 21,333 21,917

3. In the case of NPW analysis Selected Target is best option because it is the better and cheaper investment while EUAM analysis states Walmart kit is better option,

4.Target is the best option because the cost difference is only around $600 which will last for 6 Years while in walmart case we will need to replace all the furniture in 3 Years .

Explanation:

1. Using NPW Analysis

Walmart Kit Target

Intial Cost 40000 65000

AMC 10000 12000

Salvage Value 12000 25000

Life Years 3 6

Total Cost

Intial Cost 40000 65000

Less Salvage 12000 25000

Balance 28000 40000

5% Interest 6000 19500

AMC PV 2.71 5.05

Amc 27100 60600

Total Cost 61100 120100

In a Year 20,367 20,017

2. Using EUAW Analysis

Walmart Kit

Target

Intial Cost 40000 65000

AMC 10000 12000

Salvage Value 12000 25000

Life Years 3 6

Total Cost

Intial Cost 40000 65000

Less Salvage 12000 25000

Balance 28000 40000

5% Interest 6000 19500

AMC 30000 72000

Total 64000 131500

In a Year 21,333 21,917

In the case of NPW analysis Selected Target is best option because it is the better and cheaper investment while EUAM analysis states Walmart kit is better option,

Target is the best option because the cost difference is only around $600 which will last for 6 Years while in walmart case we will need to replace all the furniture in 3 Years .

Hence Target product will be the best option we would advice the management to go for.