Manufacturing Systems Acme Corporation is going to buy a manufacturing system to produce its shaft couplings over six years. It is considering two types: the Cellular Manufacturing System (CMS) or the Flexible Manufacturing System (FMS). Acme will only buy one. There is no difference in the quantity or quality of output. With either system the firm will produce output of 544,000 units per year. The output price today is $25 per unit, but prices are expected to increase 5% per year over the life of the project.

Cellular Manufacturing System (CMS)

The initial investment cost of CMS is $8,000,000. CMS systems have a life of three years. The price of new CMS systems is expected to increase 5% per year. Today, three-year old used CMS sell for $1,000,000. The price of three-year old used CMS systems is expected to increase 5% per year as well. The annual equivalent operating costs for CMS are shown in the table below.

Flexible Manufacturing System (FMS)

The initial investment cost of FMS is $5,000,000. FMS systems have a life of six years. Today, six-year-old used FMS sell for $400,000. The price of six-year-old used FMS systems is expected to increase 5% per year.

The annual equivalent operating costs for FMS are shown in the table below.

Acme Corporation has a minimum acceptable rate of return (MARR) of 15%. Using the internal rate of return (IRR) evaluation method, determine which system Acme should purchase. (Report IRR to two decimal places).

Use Excel functions. You may submit an Excel file of your work with your answers.

Above is all the information we have - please help me with an answer