1. 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

Assets are assumed to be sold at the end of their useful life.

Costs Annual labour costs Annual material costs Annual overhead costs Annual tooling costs Annual inventory costs Annual income taxes CMS $707,200 $598,400 $1,950,000 $300,000 $31,500 $1,650,000 FMS $1,169,600 $833,320 $3,150,000 $470,000 $141,000 $1,650,000 Use Excel functions. You may submit an Excel file of your work with your answers. 1. 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. Costs CMS FMS Annual labour costs $707,200 $1,169,600 Annual material costs $598,400 $833,320 $1,950,000 $3,150,000 Annual overhead costs Annual tooling costs $300,000 $470,000 Annual inventory costs $31,500 $141,000 Annual income taxes $1,650,000 $1,650,000 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). (34)