Please show work/formulas in Excel

(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? (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