Large Mart, a very large retail corporation, currently uses manual labor to process cases of retail goods at one of the corporations distribution centers. Large Mart is considering a project which would replace the manual labor with robots. Your first task as a project manager is to evaluate the potential project and determine if the project is feasible. Currently, 120,000,000 cases are being processed annually, at a rate of 650 cases per hour. The corporation expects the number of cases processed annually to increase by 5% for each of the next 5 years. Labor costs are currently $25.00 hour, and will increase by 2.5% each year, also for the next 5 years. Large Mart can purchase robots which are capable of processing the cases for $375,000, per robot. However, to take advantage of this price, all robots must be purchased as part of the initial set-up. The robots can process cases at a rate of 450 cases per hour and be utilized 24 hours per day, 365 days per year. There is an annual maintenance and licensing fee of $850,000 for the robots, regardless of the number of robots utilized. If Large Mart requires an annual return of 8% on investments, does the Net Present Value of the total annual cost savings from switching to robots offset the initial investment in the robots? With that requirement, is the project feasible? Disregard taxes, depreciation, and amortization expenses for this analysis. Assignment Instructions: Prepare an analysis using that attached MS Excel spreadsheet, and then submit your answers to the questions detailed (and described below) in the automated Blackboard assignment link (Click the title link for this activity). Upon submission you will see correct/incorrect answers. Complete this exercise as many times as it takes to get 100%.

What are the forecasted number of cases processed in years 1, 2, 3, 4, and 5?

What are the expected labor costs in years 1, 2, 3, 4, and 5?

How many robots are needed to process the forecasted cases in year 5?

How much are the net savings if robots are used and completely replace the labor costs in years 1, 2, 3, 4 and 5?

If all robots must be purchased in the initial set-up, what is the cost to purchase the number of robots that will be needed for this project? (Use your response to Question 11 for the number of robots needed.)

Use the initial outlay and annual cost savings to calculate the NPV of the Project at 8% Required Return?

Does the Net Present Value of the total annual cost savings from switching to robots offset the initial investment in the robots? (YES/NO)

With that requirement, is the project feasible? (YES/NO)

\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & & Present & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ \hline Cases Processed & & 120,000,000 & 126,000,000 & 132,300,000 & 138,915,000 & 145,860,750 & 153,153,788 \\ \hline Processing hours at 650 cases/hour & & 184,615 & & & & & \\ \hline Wage/Hour w /2.5% annual increase & $ & 25.00 & & & & & \\ \hline Labor Cost & $ & 4,615,385 & & & & & \\ \hline Cases Processed per Hour & & 13699 & & & & & \\ \hline Robots Required at 450 cases/hour & & 31 & & & & & \\ \hline & & Present & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ \hline Initial Investment (39 robot cells) & $ & 14,625,000 & & & & & \\ \hline Manual Labor Cost & $ & 4,615,384.62 & & & & & \\ \hline Annual Maintenance \& Licensing Fee & $ & 850,000.00 & & & & & \\ \hline \begin{tabular}{l} Cost Savings \\ Investment (Present) or Cost Savings (Years 1-5) \\ NPV of Project at 8% Required Return \end{tabular} & $ & 14,625,000 & & & & & \\ \hline \end{tabular}