Question: EXCEL ONLY AND PLEASE POST FORMULAS USED AND STEP BY STEP The management of Brawn Engineering is considering three alternatives to satisfy an OSHA requirement

EXCEL ONLY AND PLEASE POST FORMULAS USED AND STEP BY STEP

The management of Brawn Engineering is considering three alternatives to satisfy an OSHA requirement for safety gates in the machine shop. Each gate will completely satisfy the requirement, so no combinations need to be considered. The first costs (year 0), operating costs, and salvage values over a 5-year planning horizon are shown below (Year 5 includes the salvage value shown in the positive portion) End of Year 0 1 2 3 4 5 Gate 1 -$21,000- (BBB/10) -$5,800 -$5,800 -$5,800 -$5,800 -$5,800+ $3500 Gate 2 -$19,600 -$5,900 -$5,900 -$5,900 -$5,900 -$5,900 + $3000 Gate 3 -$24,500 + (BBB/10) -$4,800 -$4,800 -$4,800 -$4,800 -$4,800 + $4,000 Using an External rate of return analysis with a MARR of AAA +3.5 % per year, determine the preferred gate. (You need to perform the ERR analysis in a step-by-step way)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

For the second question please determine the ERR for the project in percent. Current Attempt in Progress The management of Brawn Engineering is considering three alternatives to satisfy an OSHA...

Please Solve without Excel - use TVOM factors and be as detailed as possible to best understand the problem thanks! 06.02-PR016 Three alternatives are being considered by the management of Brawn...

Drop down options for Comparison 1: (Gate 2 vs Gate 1), (Gate 1 vs Gate 3), (Gate 2 vs Gate 3) Drop down options for Comparison 2: (Gate 3 vs Gate 1), (Gate 2 vs Gate 3), (Gate 1 vs Gate 2) The...

The management of Brawn Engineering is considering three alternatives to satisfy an OSHA requirement for safety gates in the machine shop. Each gate will completely satisfy the requirement, so no...

2.) Using a future worth analysis with a MARR of 20%/year, determine the preferred gate. The management of Brawn Engineering is considering three alternatives to satisfy an OSHA requirement for...

The management of Brawn Engineering is considering three alternatives to satisfy an OSHA requirement for safety gates in the machine shop. Each gate will completely satisfy the requirement, so no...

please show step by step solution. thank you. The management of Brawn Engineering is considering three alternatives to satisfy an OSHA requirement for safety gates in the machine shop. Each gate will...

(a) A dispersion colloid can be coagulated with the following electrolytes:51 mmoldm-3 NaCl,0.65mmoldm-3 CaCl2 and 0.095mmoldm-3AlCl3. What is the charge of the dispersed particle? (b) Suppose a...

Knife Edge Company purchased tool sharpening equipment on July 1, 2010, for $16,200. The equipment was expected to have a useful life of three years and a residual value of $900. Instruction...

Program trading has been criticized for introducing increased Blank _ _ _ _ _ _ to stock markets Multiple choice question. price volatility market capitalization trading volume investor confidence

Have you ever been asked unethical, biased, or uncivil questions? Did you ever, knowingly or unknowingly, use these types of questions yourself? How can you deal with questions like these if you find...

Particularly when dealing with your neutral and hostile audiences, what are some ways that you can bridge the gap between your beliefs and those of your audience members? How can you generate...

Is there a particular organizational pattern that would best suit you, your topic, or your audience? For example, are you comfortable with and knowledgeable enough about your hostile audiences...