The Value to Proble 3 is 21.10 %

4. Using the value calculated in Problem 3, determine if the following is a good idea: Your company has an existing manufacturing program for a stable product line (reference and complete the Excel file called IENG 4140 Exam 2-F23 Problem 4) that is expected to continue for at least the next 35 years. The process is relatively stable but you think there is room for improvement. Based on what you have learned from the gifted faculty at UMASS Lowell, you boldly state that, for $1,080,000 in capital equipment plus another $300,000 for R&D, you could improve 2 process steps 15% each (you choose which ones) and that this would recover the capital equipment expense in less than 12 months. Is this possible? Choose wisely. The expected monthly volumes are: You will finance everything except R&D, which has is own internal funding. Your company's policy for profit is 35% on sell price. What are you going to recommend? Depending on your results, are there any other alternatives for you to consider? Provide a comprehensive solution to prove or disprove your assertion. l expect to see calculations..... meaning ones relevant to what you have been learning lately. Answers without showing how you got them will not be counted. Here's some more information and advice which you may find useful: - Financing is 8.0% annual rate; you will be financing over 12 months for simplicity (yeah, I know this sounds loan-sharkish but just go with it) - Manufacturing equipment, such as what you are recommending, typically has a useful life of 5 years - E=mc2 - Your company policy for equipment it to depreciate to zero - Be thorough and make sure that you have considered all factors and have listed and supported all decisions and assumptions used in your calculations - From there to here, from here to there, funny things are everywhere (Dr. Seuss)