Question: Correct answer is yes, recommend it, NPV = 21287534.11, please show all steps, functions used in excel (which functions used, which cells multiplied, etc.) Currently,

 Correct answer is yes, recommend it, NPV = 21287534.11, please show

Correct answer is yes, recommend it, NPV = 21287534.11, please show all steps, functions used in excel (which functions used, which cells multiplied, etc.)

Currently, Bryer' s Ice Cream uses Finamac continuous ice cream machines for their process. However, last week, Emery Thompson, a competitor of Finamac came into the facility to propose a new system that would improve the operation. The current finamac system has the following characteristics: Production Rate on Line: Production Labor on line Production Labor rate: 120 Gallons per minute $25 per hour, 8 hour/day, 5days a week for 50 weeks per year With the Emery Thompson system, there are many improvements: Production Rate on Line: 150 Gallons per Minute Production Labor Rate: The new Emery Thompson system would cost $12,620,000 up front and would have required maintenance of $1,000,000 per year going up at 6% per year. Would you recommend this project at the company MARR of 12%? Assume that the project ife is 10 years. Also, assume that the company can sell as many as product as it can produce for $2. (hint: find the NPV of the difference between the two alternatives) Do you recommend it? Machine System Production Rate on Line Production Hrs/day # of Days/week # of weeks/year Finamac

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 Finance Questions!