The teachers' office area in the Antonio Lucchetti building has problems 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:

Unit	Cost	Useful life
Centrfuga 50 tons	$33,000	15 years
Managers	$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 assistant	1 day	$1,550 $1,515
Annual maintenance of water pump	1 technician 1 assistant	1/2 day	$1,550 $1,515
Annual manufacturer visit				$1,000
Replacement fans every three years	1 technician 1 assistant	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. (They 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
Condensator MDV 400	$9,000	2		6 years
Condensator MDV 450	$9,700	2		6 years
Consoles 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 assistant	41	1.5 hours	$1,550 $1,515	$30/unit
Condenser cleaning once a year	1 technician 1 assistant	4	1 hour	$1,550 $1,515
Console extraction pump replacement, every 3 years	1 technician 1 assistant	41	day	1 tcnico 1 ayudante	$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	Each 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 to. 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. to. 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.

3. Consider that the equipment will be purchased by a manufacturing industry. to. 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.

In EXCEL to facilitate computations. Please show the computations and formulas in Excel.

All the info is above

?