please help me with the question following the instructions. please send the detailed explaination and a very detailed solution.

* Students need to solve the following problems as groups of two students each. * You might need to utilize some of the material that we have covered, the chapters that we are going to cover, and some of the text material that we will not cover. * 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! * Each group must submit a PRINTED COPY of the project by 12/4/2022. Electronic copies will not be accepted. PROBLEM 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 refrigerators 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. * Students need to solve the following problems as groups of two students each. * You might need to utilize some of the material that we have covered, the chapters that we are going to cover, and some of the text material that we will not cover. * 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! * Each group must submit a PRINTED COPY of the project by 12/4/2022. Electronic copies will not be accepted. PROBLEM 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 refrigerators 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