use excel to solve 11.02-PR002 You have been asked to perform a sensitivity analysis on a company's plan to modemize its facilities to determine the impact of possible errors in estimating the net annual savings. The initial investment in the modemnization is $30,000. The expected net annual savings are $13,000. The salvage value is $7,000 after a planning horizon of 7 years. MARR is 12% per year. Determine if the modernization is economically attractive based on the initial estimates and an annual worth (AW) analysis. Determine the AW if the net annual savings change by the following percentages from the initial estimate: -80%, -60%, -40%, -20 %, +20%, +40%. Determine the percentage change in net annual savings that causes a reversal in the decision regarding the attractiveness of the project.

H2

A manager is considering installation of one of the following two machines in his factory 24 Panther $30,000 Cheeler More Info 1 $90,000 $20,000 $30,000 4 6 None None Initial Cost Annual Costs Service life (years) Salvage value Since the machines have different service lives, his economic analysis will assume repeatability and use an analysis period of 12 years. Given a MARR of 10% per year, calculate the following two parameters Click the icon to view the interest and annuity table for discrete compounding when /-10% per month. The EUAC of the Cheeter over the analysis period is (select the closest value) OA. $9,335 OB. $50,665 OC. $43,209 OD. $101,330 OE. $56,417 The PW of the Cheeter over the analysis period is (select the closest value). OA. $441,318 OB. $384,408 OC. $345,216 The of " wie OA BI O . Ос OR H " 0 0 " 15 ожи кли Derm TOW 5 6 B 9 0 T Y U 1 O P

Please answer fast please arjent help please

an engineer knows that the supplier of their set-5100 laser surface metrology system used on one of their lines superseded their 5100 model with the 5105. the new model has a net cost of $420000. adding the new 5105 model to the production line would in decrease scrap rate estimated to save 630000 in the first year. the rate of return for on the set-5105 purchase is 13% MEMD IS 15% what is the opportunity cost

GMA will be visiting an automobile plant. It was decided by the plant management that they must paint the plant. Boysen paint costs Php 70 per gallon and covers 350 sq. ft. per gallon. The manufacturer claims that it will last 5 years and can be applied at a rate of 100 sq. ft. per hour. General paint costs Php 100 per gallon and covers 500 sq. ft. per gallon. It will last for 4 years and can be applied at a rate of 125 sq. ft. per hour. If the painter is Paid Php 15 per hour, which paint should be used?

Mary, a project manager for ABC Ic., is reviewing a product quality improvement project. She has determined that the project's Annual Worth of $3,396. for a period of 8 years. She now has to calculate the IRR for the project but unfortunately she has lost some information about the cash flows. She knows only that the project has: a 8-year project life with an initial cost of $400,000. a set of equal revenue cash flows occurred at the end of each year for 8 years, and • MARR used for calculation the Annual Worth was 8%. Find the annual revenue first and then calculate the IRR for the project = ? O 14% < IRR (i*) < 15% O 13% < IRR (i*) < 14% O 10% < IRR (i*) < 11% O 9% < IRR (i*) < 10% O 8% < IRR (i*) < 9%

A building cost P8.5 million and the salvage value is P50,000 after 23 years. The annual maintenance cost is P85,000, costs of repair is P350,000 every 3 years. Find the capitalized cost if money worth 14% per annum. What is the renewal cost? What is the capitalized cost? (2 decimal places, rounded off), if whole number no need to add .00

A machine costs $15000 and has a maintenance cost $1000 per year and a salvage value of $2500 after three years. The life cycle cost of the machine ?MARR =10%Explain each step for used formulas.

please provide correct answer it would great help