General instructions 1. It is recommended to use EXCEL to facilitate computations. You will need to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
General instructions 1. It is recommended to use EXCEL to facilitate computations. You will need to display the computations (in Excel or by hand, if you decide not to use the Excel functions). 2. If you make use of Excel, the file must be sent in original format. PDF documents or documents with cells with frozen results (No Paste Values) will not be accepted. Result cells should illustrate the functions used and reference cells, as applicable. The teachers' office area in the Antonio Lucchetti building has issues associated with the air conditioning system. Currently the existing system is centrifugal. The Department of Buildings and Land is evaluating two alternatives to address the situation. The first alternative is to replace the 50 tons centrifuge (chiller), the handle system and its isolation system. The upfront costs are as follows: Unit Cost Life Centrifuge 50 tons Handlers Installation work $33,000 $47,000 $1,400 $2,500 $22,000 15 years 30 years n/a n/a n/a *Reduces to 40% of original cost in case of equipment replacernent. Materials for initial installation ** Islation system ** The cost of replacement materials is also assumed 40% of the original cost. Centrifugal maintenance consists of Maintenance work Staff requirements Duration Monthly Cost of work salary $1,550 $1,515 $1,550 Cleaning every 6 months 1 technician 1 day 1 helper 1 technician Annual water pump 1/2 day maintenance 1 heloer $1.515 The upfront costs are as follows: Unit Cost Life Centrifuge 50 tons $33,000 $47,000 15 years Handlers 30 years Installation work n/a n/a n/a *Reduces to 40% of original cost in case of equipment replacenment. $1,400 $2,500 $22,000 Materials for initial installation ** Islation system ** The cost of replacement materials is also assumed 40% of theoginal cost Centrifugal maintenance consists of 田 Maintenance work Staff requirements Monthly salary $1,550 $1,515. $1,550 $1,515 Duration Cost of work 1 technician 1 helper 1 technician 1 helper Cleaning every 6 months 1 day Annual water pump maintenance 1/2 day Manufacturer's annual $1,000 visit Fan replacement every three years 1 technician 1 helper 1 hour $1,550 $1,515 $150 Maintenance is carried out by staff of the RefrigerationWorkshop attachedto the Department of Buildings and Land of the land. The total hours a regular employee works at the Campus is 1,950 hours per year, at a rate of 7.5 hours per day. (You must calculate the cost associated withthe time staff spend on the maintenance tasks of these particular equipment.) The additional costs associated with the centrifuge operation are as follows The additional costs associated with the centrifuge operation are as follows Cost item Frequency Every 6 years Cost Cold water pipe insulation $22,000 replacement The costs associated with power consumption to the centrifuge system are as follows: The cost of daily electricity consumption of a 50-ton centrifuge is $150 per day. The cost of power consumption of the handler is $25 per day. The centrifuge system operates continuously. The second alternative is the installation of a system of individual units consisting of four capacitors and 41 consoles. The upfront costs are as follows: Cost item MDV 400 capacitor MDV 450 capacitor Unit cost Units Total cost Life $9,000 $9,700 $700 $900 6 years old 6 years old Consoles 12,000 BTU 6 years old 6 years old 31 Consoles 19,000 BTU 10 Materials" $35,000 n/a The second alternative is the installation of a system of individual units consisting of four capacitors and 41 consoles. The upfront costs are as follows: 田 Cost item Unit cost Units Total cost Life MDV 400 capacitor $9,000 $9,700 $700 $900 2. MDV 450 capacitor 6 years old 6 years old 2. Consoles 12,000 BTU Consoles 19,000 BTU Materials** Installation work**** Includes materials for the is relaxation system. The cost of materials for replacing consolel ignored. Replacement work is reduced to 80% of the original cost. 31 6 vears old 6 years old n/a n/a 10 $35,000 $18,000 System maintenance consists of Maintenance work Staff Units Duration Monthly Cost parts to requirements 1 technician 1 helper 1 technician 1 helper 1 technician 1 helper of work salary $1,550 replace $30/unit Console cleaning and filter replacement once a year Condenser cleaning once a 41 1.5 hours $1,515 $1,550 $1,515 1 technician 1 helper 4 1 hour year Replacement console extraction pump, every 3 41 1/4 day $50/unit years Maintenance is carried out by staff of the RefrigerationWorkshop attachedto the Department of Buildings and Land of the land. The total hours a regular employee works at the Campus is 1,950 hours per year, at a rate of 7.5 hours per day. (You must calculate the cost associated with the time staff spend on the maintenance tasks of these particular eguipment.) The additional costs associated with operating the console system are as follows Cost item Refrigerant pipe insulation replacement The costs associated with the power consumption of the console system are as follows: Frequency Every12 years Cost $12,000 The cost of full console system power consumption is$1/5 per day, at a rate of 12 hours per day. It assumes that the system will operate for 260 working days analy. 1. Perform a present value analysis to select the best alternative a. Consider that replacements will be for identical units b. The residual value of the equipment corresponds to the cost of disposition of the unit c. Analyze a 30-year horizon d. Consider an interest rate of 6% 2. Perform a sensitivity analysis, keeping centrifugal system parameters constant, and changing the console system life 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 console system previously analyzed will be used to provide air conditioning in a manufacturing industry that generates a taxable incorne of $3,000,000 to $5,000,000 per year. It will be installed in a certain production area that generates an income of$450,000 gross annually. Operating costs are $125,000 per year. Depreciate the console system, in an operational state, using the Modified AcelerCapital Recovery Finger System and determine the cash flow aftertax. Calculate the internal rate of return before and after tax. Perform the scan only for the first time the computer is installed (First cycle, depending on the life General instructions 1. It is recommended to use EXCEL to facilitate computations. You will need to display the computations (in Excel or by hand, if you decide not to use the Excel functions). 2. If you make use of Excel, the file must be sent in original format. PDF documents or documents with cells with frozen results (No Paste Values) will not be accepted. Result cells should illustrate the functions used and reference cells, as applicable. The teachers' office area in the Antonio Lucchetti building has issues associated with the air conditioning system. Currently the existing system is centrifugal. The Department of Buildings and Land is evaluating two alternatives to address the situation. The first alternative is to replace the 50 tons centrifuge (chiller), the handle system and its isolation system. The upfront costs are as follows: Unit Cost Life Centrifuge 50 tons Handlers Installation work $33,000 $47,000 $1,400 $2,500 $22,000 15 years 30 years n/a n/a n/a *Reduces to 40% of original cost in case of equipment replacernent. Materials for initial installation ** Islation system ** The cost of replacement materials is also assumed 40% of the original cost. Centrifugal maintenance consists of Maintenance work Staff requirements Duration Monthly Cost of work salary $1,550 $1,515 $1,550 Cleaning every 6 months 1 technician 1 day 1 helper 1 technician Annual water pump 1/2 day maintenance 1 heloer $1.515 The upfront costs are as follows: Unit Cost Life Centrifuge 50 tons $33,000 $47,000 15 years Handlers 30 years Installation work n/a n/a n/a *Reduces to 40% of original cost in case of equipment replacenment. $1,400 $2,500 $22,000 Materials for initial installation ** Islation system ** The cost of replacement materials is also assumed 40% of theoginal cost Centrifugal maintenance consists of 田 Maintenance work Staff requirements Monthly salary $1,550 $1,515. $1,550 $1,515 Duration Cost of work 1 technician 1 helper 1 technician 1 helper Cleaning every 6 months 1 day Annual water pump maintenance 1/2 day Manufacturer's annual $1,000 visit Fan replacement every three years 1 technician 1 helper 1 hour $1,550 $1,515 $150 Maintenance is carried out by staff of the RefrigerationWorkshop attachedto the Department of Buildings and Land of the land. The total hours a regular employee works at the Campus is 1,950 hours per year, at a rate of 7.5 hours per day. (You must calculate the cost associated withthe time staff spend on the maintenance tasks of these particular equipment.) The additional costs associated with the centrifuge operation are as follows The additional costs associated with the centrifuge operation are as follows Cost item Frequency Every 6 years Cost Cold water pipe insulation $22,000 replacement The costs associated with power consumption to the centrifuge system are as follows: The cost of daily electricity consumption of a 50-ton centrifuge is $150 per day. The cost of power consumption of the handler is $25 per day. The centrifuge system operates continuously. The second alternative is the installation of a system of individual units consisting of four capacitors and 41 consoles. The upfront costs are as follows: Cost item MDV 400 capacitor MDV 450 capacitor Unit cost Units Total cost Life $9,000 $9,700 $700 $900 6 years old 6 years old Consoles 12,000 BTU 6 years old 6 years old 31 Consoles 19,000 BTU 10 Materials" $35,000 n/a The second alternative is the installation of a system of individual units consisting of four capacitors and 41 consoles. The upfront costs are as follows: 田 Cost item Unit cost Units Total cost Life MDV 400 capacitor $9,000 $9,700 $700 $900 2. MDV 450 capacitor 6 years old 6 years old 2. Consoles 12,000 BTU Consoles 19,000 BTU Materials** Installation work**** Includes materials for the is relaxation system. The cost of materials for replacing consolel ignored. Replacement work is reduced to 80% of the original cost. 31 6 vears old 6 years old n/a n/a 10 $35,000 $18,000 System maintenance consists of Maintenance work Staff Units Duration Monthly Cost parts to requirements 1 technician 1 helper 1 technician 1 helper 1 technician 1 helper of work salary $1,550 replace $30/unit Console cleaning and filter replacement once a year Condenser cleaning once a 41 1.5 hours $1,515 $1,550 $1,515 1 technician 1 helper 4 1 hour year Replacement console extraction pump, every 3 41 1/4 day $50/unit years Maintenance is carried out by staff of the RefrigerationWorkshop attachedto the Department of Buildings and Land of the land. The total hours a regular employee works at the Campus is 1,950 hours per year, at a rate of 7.5 hours per day. (You must calculate the cost associated with the time staff spend on the maintenance tasks of these particular eguipment.) The additional costs associated with operating the console system are as follows Cost item Refrigerant pipe insulation replacement The costs associated with the power consumption of the console system are as follows: Frequency Every12 years Cost $12,000 The cost of full console system power consumption is$1/5 per day, at a rate of 12 hours per day. It assumes that the system will operate for 260 working days analy. 1. Perform a present value analysis to select the best alternative a. Consider that replacements will be for identical units b. The residual value of the equipment corresponds to the cost of disposition of the unit c. Analyze a 30-year horizon d. Consider an interest rate of 6% 2. Perform a sensitivity analysis, keeping centrifugal system parameters constant, and changing the console system life 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 console system previously analyzed will be used to provide air conditioning in a manufacturing industry that generates a taxable incorne of $3,000,000 to $5,000,000 per year. It will be installed in a certain production area that generates an income of$450,000 gross annually. Operating costs are $125,000 per year. Depreciate the console system, in an operational state, using the Modified AcelerCapital Recovery Finger System and determine the cash flow aftertax. Calculate the internal rate of return before and after tax. Perform the scan only for the first time the computer is installed (First cycle, depending on the life
Expert Answer:
Answer rating: 100% (QA)
To perform the calculations and analysis outlined in your instructions it would be best to use a spreadsheet software like Microsoft Excel Heres a ste... View the full answer
Related Book For
Applied Statistics in Business and Economics
ISBN: 978-0073521480
4th edition
Authors: David Doane, Lori Seward
Posted Date:
Students also viewed these accounting questions
-
1. Diesel generators are quite common in African regions because of their durability and low upfront cost: just $250/kW for a device that can run almost all the time! Compute the LCOE of a 2 kW...
-
Factor Company is planning to add a new product to its line. To manufacture this product, the company needs to buy a new machine at a $515,000 cost with an expected four-year life and a $11,000...
-
Phil Cousteau is an accountant. Phil is 47 years old and is married to Claire who is 45 years old. She has Net Income For Tax Purposes in 2020 of $9,000, all of which is interest on investments she...
-
Solve the inequality. Write the solution in interval notation. |15 = x < 7
-
Set up the following T-accounts for Jones's Consulting with the balances provided. Prepare closing entries at December 31, 2014, and post them to the accounts. Assets Liabilities Dec. 31 142,000...
-
Select the statement that is least accurate: 1. Following the money can only be performed if those assets remain in their original identifiable form as they flow from place to place or person to...
-
(a) Show that for Poiseuille flow in a tube of radius \(R\) the magnitude of the wall shearing stress, \(\tau_{r z}\), can be obtained from the relationship \[ \left|\left(\tau_{r z} ight)_{\text...
-
Gates Video Games manufactures video game machines. Market saturation and technological innovations have caused pricing pressures that have resulted in declining profits. To stem the slide in profits...
-
Your company recently hired a new administrative assistant, Maryam Arjmand. On her first day, you stopped by her desk to meet her. During your conversation, you told her to let you know if there was...
-
The Salida Salt Company is considering making a bid to supply the highway department with rock salt to drop on roads in the county during the winter. The contract will guarantee a minimum of 25,000...
-
You are a middle-level manager in a public health department. One of your closest friends, Janie, is an RN under your span of control. Today, Janie calls and tells you that she injured her back...
-
Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: Activity Cost Pool...
-
The graph indicates that recent evidence shows a significant decrease in the number of EU immigrants in the UK, coupled with an increase in immigration from non-EU countries. A. Using graphs, explain...
-
On January 1, 2024, Alamar Corporation acquired a 40 percent interest in Burks, Incorporated, for $210,000. On that date, Burks's balance sheet disclosed net assets with both a fair and book value of...
-
1. Describe or summarize your previous the topic and technology in your previous discussion. 2. How has your understanding about the topic and technology been affected by the social science lens? 3....
-
How much does it cost to fully charge an electric car for 10 hours, if its battery draws a 30-A electric current from 240-V power line, and the electric company charges $0.20 for kilowatt hour. Show...
-
Chuck Harris viewed a single - family residential property on the far east side of town. Chuck has great credit and was approved for $ 4 8 0 , 0 0 0 . 0 0 . The List Price was $ 4 5 9 , 9 0 0 . 0 0 ....
-
Recall that Chapter 8 described the binary search algorithm for finding a particular entry in an ordered list. The idea behind binary search is to begin looking in the exact center of the list. If...
-
The weekly demand for Papa Chubby's pizzas on a Friday night is a random variable with mean 235 and standard deviation 10. Find the value(s) of X for each event. Show your work. a. Lowest 50 percent...
-
The mean arrival rate of fights at O'Hare Airport in marginal weather is 195 fights per hour with a historical standard deviation of 13 fights. To increase arrivals, a new air traffic control...
-
(a) Make an Excel line graph of the exchange rate data. Describe the pattern. (b) Click on the data and choose Add Trendline > Moving Average. Describe the effect of increasing m (e.g., m = 2, 4, 6,...
-
The equity section of Atrio Ltd. showed the following: share premium 6,101, share capitalordinary 925, share capitalpreference 58, retained earnings 7,420, and treasury shares 2,828. (All amounts are...
-
The following equity accounts are in the ledger of Eudaley Group at December 31, 2025. Instructions Prepare the equity section of the statement of financial position at December 31, 2025. Share...
-
Travis Mordica asks, Since share dividends dont change anything, why declare them? What is your answer to Travis?
Study smarter with the SolutionInn App