The Rock Creek plant is considering the following projects to improve its production process. MARR = 15%. All projects that come to the plant's capital screening committee meet that rate. The Rock Creek plant can afford to do several projects, but not all. Project First Cost Annual Benefit Life (years) PW at 15% 7 1 $200,000 $50,000 15 $92,369 2 300,000 70,000 10 51,314 3 100,000 40,000 5 34,086 4 50,000 12,500 10 12,735 5 5 1,412 6 250,000 75,000 150,000 32,000 400,000 125,000 20 50,299 7 5 19,019 Question: rank the following project from best to worst using appropriate method Answer: 3,1,4,6,2,7,5 What is the MARR if the capital budget is $500,000 Answer: 20.85% Please only answer if you have excel solution with explanation. Thanks