Question: please help solve. PROBK 1 Make a report that includes calculations (using Excel) and conclusions of your analysis of the following problem: Your back office

PROBK 1 Make a report that includes calculations (using Excel) and conclusions of your analysis of the following problem: Your back office needs 1820ft3 refrigerator. You must sell it in 5 years (project life =5 years). Estimate reasonable sales price of the used refrigerators at that time. The electricity cost is $0.10 per kW-hr. Electricity increases every year by __\% (you must select reasonable percent > 0). Company's MARR =10% (use 10\% interest rate). Compare two refingerators that make sense and select the best one based on present worth analysis method. You may choose to assign a utility value to the quality of refrigerators, if you like. * Make as many assumptions as you might need to solve the problems. - This is a project and not a matter of solving couple of problems! I would like to see how you approach such problems as a group and try to do it the way that you believe it should be analyzed and solved. In fact I will be interesting in the suggested approach and not looking for determining accurate results
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
