Please show work and formulas for cells in Excel

2. (32 points) You are part of a strategic planning team which is going to decide whether to keep the production of a product within the company or outsource the production to a contract manufacturer. If you produce in house, a new production line needs to be built at a cost of $1.8M. The variable cost per unit is estimated at $15 each. The contract manufacturer would cost $23 per unit. a) How many units would you need to produce to break-even between in-house manufacturing and outsourcing? b) Upon analyzing the product forecast over its lifetime, you figure that the company would sell 200,000 units of this product. Would you build it in-house or outsource it? 3. (34 points) A computer manufacturing company would like to identify the optimal timing for building a new manufacturing plant to satisfy growing demand. A plant with a capacity of 85,000 computers cost $2.25M to build. Doubling the capacity of an existing plant in its current location increases the plant establishment cost by 70%. Annual demand is expected to increase at 25,000 computers and discount rate for future costs are estimated at 7%. a) Find the values for k and a assuming a cost relationship of the form f(y)=kya b) Determine the optimal timing the new plant. c) What is the planned plant capacity