Looking for someone can help me with this problem, the idea is to select the best option of the two alternatives given]

the explanatation can be in Excel just let me see the tables and the formulas you used to solve it

Problem:

The professors office area in the Antonio Lucchetti building has a problem associated with the air conditioning system. Currently the existing system is a centrifuge. The Buildings and Grounds Department is evaluating two alternatives to address the situation.

The first alternative consists of replacing the 50-ton centrifuge (chiller), the handler system, and its isolation system.

The initial costs are as follows:

Units	Cost	Useful life
Centrifuge 50 tons	$33,000	15 years
Handlers	$47,000	30 years
Labor for installation concept *	$1,400	n/a
Materials for initial installation **	$2,500	n/a
Isolation system	$22,000	n/a

* It is reduced to 40% of the original cost in case of equipment replacement.

** The cost of replacement materials is also assumed 40% of the original cost.

Maintenance of the centrifuge consists of:

Maintenance work	Personnel requirements	Duration of work	Monthly salary	Cost
Cleaning every 6 months	1 technician 1 helper	1 day	$1,550 $1,515
Annual maintenance of water pump	1 technician 1 helper	1/2 day	$1,550 $1,515
Annual manufacturer visit				$1,000
Fans replace every three years	1 technician 1 helper	1 hour	$1,550 $1,515	$150

Maintenance is carried out by personnel from the Refrigeration Workshop assigned to the Department of Buildings and Land of the land. The total hours that a regular employee works in the Campus is 1,950 hours per year, at a rate of 7.5 hours per day. (You will need to calculate the cost associated with the time staff spend on maintenance tasks for this particular equipment.)

Additional costs associated with operating the centrifuge are as follows:

Cost Item	Frequency	Cost
Cold Water Pipe Insulation Replacement	Every 6 years	$22,000

The costs associated with the electricity consumption of the centrifuge system are the following:

The cost of daily electricity consumption for a 50-ton centrifuge is $ 150 per day.

The cost for electricity consumption of the driver is $ 25 per day.

The centrifuge system operates continuously.

The second alternative consists of the installation of a system of individual units consisting of four condensers and 41 consoles.

The initial costs are as follows:

Cost Item	Unit Cost	Units	Total Cost	Useful Life
Condenser MDV 400	$9,000	2		6 years
Condenser MDV 450	$9,700	2		6 years
Consolas 12,000 BTU	$700	31		6 years
Consoles 19,000 BTU	$900	10		6 years
Materials***			$35,000	n/a
Labor for installation concept ****			$18,000	n/a

*** Includes materials for the insulation system. The cost of materials for the replacement of the consoles is obviated.

**** Replacement labor is reduced to 80% of original cost.

System maintenance consists of:

Maintenance work	Personnel requirements	Units	Duration of work	Monthly salary	Cost of parts to replace
Console cleaning and filter replacement once a year	1 technician 1 helper	41	1.5 horas	$1,550 $1,515	$30/unit
Condenser cleaning once a year	1 technician 1 helper	4	1 hora	$1,550 $1,515
Console extraction pump replacement, every 3 years	1 technician 1 helper	41	da	1 technician 1 helper	$50/unit

Maintenance is carried out by personnel from the Refrigeration Workshop assigned to the Department of Buildings and Land of the land. The total hours that a regular employee works in the Campus is 1,950 hours per year, at a rate of 7.5 hours per day. (They will need to calculate the cost associated with the time staff spend on maintenance tasks for this particular equipment.)

The additional costs associated with the operation of the console system are as follows:

Cost item	Frequency	Cost
Refrigerant Pipe Insulation Replacement	Every 12 years	$12,000

The costs associated with the electrical consumption of the console system are the following:

The cost for electricity consumption of the complete console system is $175 per day, at a rate of 12 hours per day.

Assume that the system will operate for 260 business days annually.

1. Perform a present value analysis to select the best alternative

a. Consider that the replacements will be for identical units

b. The residual value of the equipment corresponds to the cost of disposal of the unit

c. Analyze a 30-year horizon

d. Consider an interest rate of 6%

2. Perform a sensitivity analysis, keeping the parameters of the centrifuge system constant, and changing the useful life of the console system from 5 years to a maximum of 10 years.

3. Consider that the equipment will be purchased by a manufacturing industry.

a. Determine the internal rate of return at which both alternatives are equally attractive.

b. Assume that the previously analyzed console system will be used to provide air conditioning in a manufacturing industry that generates a taxable income of $ 3,000,000 to $ 5,000,000 annually. It will be installed in a certain production area that generates an annual gross income of $ 450,000. The operating costs are $ 125,000 per year. Depreciate the console system, in operational state, using the Modified Accelerated Capital Recovery System and determine the after-tax cash flow. Calculate the internal rate of return before and after taxes. Perform the scan only for the first time the equipment is installed (First cycle, depending on the life)