Capital Investments Production Process and Costs: Mr. William is considering temporarily increasing his manufacturing capacity to a maximum of an additional 50,000 units in 2023 by opening a small secondary facility in Sudbury. The expected life of this temporary new facility would be 3 years (2023-25) with no expected salvage value of the facilityor the equipment. For this expansion, the company would need to invest $8,000,000 by the end of 2022 . Given the company will not be selling chairs above market price he believes he should be able to sell all of the additional units (as long as he can motivate his sales team) at the same mix of 70% to other retailers and 30% in their Sudbury store. The previous consultants had provided this unfinished chart below for 5 different output options at the new facility that needs to be completed: The company would be financing the investment through a bank loan. The current cost to borrow for the company is 7%. Mr. Williams needs you to find which of the 5 output options maximizes profitat the new facility and then determine if the net present value of this investment is worth proceeding with the expansion. You need to Calculate the Net Present Value for each output, complete the cost chart above, givea correct optimal output and a justified recommendation on Mr. Williams Expansion