SHOW IN EXCEL SHOW EACH PROCESS IN EXCEL Gasoline EV Purchase Cost $50,000 $80,000 Annual-Maintenance $5,000 $2,500 Annual Fuel $7,500 $3,000 Service Life Probability Service Life Probability55% 52% 6 10% 65% 7 25% 7 10% 8 35 % 8 25% 9 20% 9 50 % 10 5 % 10 8% a) (5 Points) What is theexpected value of the present worth and expected value of the standard deviation of each option? b) (5 Points) Whichoption should be chosen, and why? c) (5 Points) If the company' s MARR is 20%, which option would they chooseand why? d) (5 Points) What value of the MARR makes the company indifferent between choosing gasoline or electricvehicles?

Setting Up the Spreadsheet:Create a table with columns for Process, costs, service life, and…

Answered: SHOW IN EXCEL SHOW EACH PROCESS IN…

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

! Pls answer All ! Engineering Economics Questions (bartleby = 3 max questions)1. Sarah wishes to turn her P 10000 investment into P 100000 in 20 years. How much interest doesshe need to receive compounded annually to reach her goal? 2. Gio promised to pay Php 36000 at the end of 90 days. He was offered a 12% discount if he paysin 30 days. Find the rate of interest. 3. What is the uninflated present worth of a Php 200,000 future value in two years if the averageinflation rate is 6% and interest rate is 10%
5. A certain manufacturing plant is being sold and was submitted for bidding. Two bids were submitted by interested buyers. The first bid offered to pay P200,000 each year for 5 years, each payment being made at the beginning of each year. The second bidder offered to pay P120,000 for the first year, P150,000 the second year, P180,000 the third year P200,000 each year for the next 2 years, all payments being made at the beginning of each year. If money is worth 12% compounded annually, which bid should the owner of the plant accept? Show cashflow diagram.
8- The life of a project is 10 years. An equipment is needed for this project. Two alternatives are available. Equipment A has an initial cost of $5000.00, an annual maintenance cost of $300.00, and a salvage value of $800.00 after 5 years. Equipment B has an initial cost of $7000.00, an annual maintenance cost of $400.00, lasts for 10 years and has no salvage value. If the interest rate is 6%: a) Equipment A should be purchased. b) Equipment B should be purchased. c) No equipment should be purchased. d) There is no difference in choosing between A or B.
Consider five years of monthly pro fit for a company Month Sales Jan-16 747 Feb-16 697 Mar-16 1014 Apr-16 1126 May-16 1105 Jun-16 1450 Jul-16 1639 Aug-16 1711 Sep-16 1307 Oct-16 1223 Nov-16 975 Dec-16 953 Jan-17 1024 Feb-17 928 Mar-17 1442 Apr-17 1371 May-17 1536 Jun-17 2004 Jul-17 1854 Aug-17 1951 Sep-17 1516 Oct-17 1642 Nov-17 1166 Dec-17 1106 Jan-18 1189 Feb-18 1209 Mar-18 1754 Apr-18 1843 May-18 1769 Jun-18 2207 Jul-18 2471 Aug-18 2288 Sep-18 1867 Oct-18 1980 Nov-18 1418 Dec-18 1333 Jan-19 1333 Feb-19 1370 Mar-19 2142 Apr-19 2138 May-19 2078 Jun-19 2960 Jul-19 2616 Aug-19 2861 Sep-19 2237 Oct-19 2225 Nov-19 1590 Dec-19 1659 Jan-20 1613 Feb-20 1605 Mar-20 2349 Apr-20 2468 May-20 2532 Jun-20 3127 Jul-20 3288 Aug-20 3285 Sep-20 2485 Oct-20 2723 Nov-20 1835 Dec-20 1894 question: Forecast monthly sales for 2022 choosing an appropriate method.
31. (Table: Present Value of Projects A, B, C, and D) Examine the table Present Value of Projects A, B, C, and D. Given the information, if the annual interest rate were 10%, which project should be chosen? A) D B) C C) A D) B
In the lottery, the lucky winner won 3000000 (three million) TL. With this together the bonus has two different payment plans. First plan for 10 years each year 350000 (three hundred fifty thousand) TL payment, second plan is 2000000 (two million) TL. If the opportunity cost (interest rate) of the winner is 15%, what payment plan? should choose
Please no written by hand and no emage Solve in excel Carp, Inc. wants to evaluate two machines for packaging their products.Machine A:Initial cost is $700,001st year O&M cost is 18,000; this cost increases $900 each year.The annual benefits are $154,000It can be sold at the end of 10 years useful life for $145,000 Machine B:Initial cost is $1,600,001st year O&M cost is 28,000; this cost increases $650 each year.The annual benefits are $300,000It can be sold at the end of 20 years useful life for $210,000The companies uses an interest rate of 15% Use annual cash flow analysis to decide which is the most desirable alternative.
SHOW COMPLETE DETAILS AND SOLUTION . 4. A new civil engineer employee start a savings plan in which he saves P 10,000 eachyear for 15 years. He makes her first payment at age 22 and after paying for 15 yearsshe leaves the accumulated sum in the savings plan until she reach age 65. If thesavings plan pays 10% per year, how much will be in the savings account when sheage 65?5. Mr. Jo needs P 4,000,000 immediately to pay for a new home. Having insufficientfund for this, he borrows P 2,000,000 from an insurance company and repay the loanevery six months for 15 years, the first payment being at the end of 8 years from now.If the insurance company charged him 8% compounded semiannually, how much isthe amount of each payment?
A cloth manufacturing firm is deciding whether or not to invest in new machinery. The machinery costs $45,000 and is expected to increase cash flows in the first year by $25,000 and in the second year by $30,000. The firm’s current fixed costs are $9,000 and current marginal costs are $15. The firm currently charges $18 per unit. If the interest rate is 5% then the present value of the cash flows is Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Calculate the future value if present value (PV) = $1548, interest rate (r) = 9.0% and number of years (t) = 18
15) If money has a time value, then the future value will always be more than the original amount invested. Select one: True False 16) A series have the receipts in year 1 =$ 80000. If the Fees are expected to increase uniformly to a level of $200,000 in nine years. What is the possible value for the gradient? Select one: a. $20000 b. $ 15000 c. $ 30000 d. $ -20000 17) In a cash flow series regarding the gradient: Select one: a. Uniform gradient signifies that an income or disbursement changes by the same amount in each interest period b. Either an increase or decrease in the amount of a cash flow is called the gradient c. The gradient in the cash flow may be positive or negative d. All of the above is correct
How much money would have to be placed in a sinking fund each year toreplace machine B at the end of 25 years if the fund yields 10% annualcompound interest and if the first cost of the machine is assumed toincrease at a 6% annual compound rate? (Assume the salvage value doesnot change.) Group of answer choices A. $3,600 B. $4,110 C. $2,400 D. $7,000

SEE MORE QUESTIONS

Recommended textbooks for you

ENGR.ECONOMIC ANALYSIS

Economics

ISBN:

9780190931919

Author:

NEWNAN

Publisher:

Oxford University Press

Principles of Economics (12th Edition)

Economics

ISBN:

9780134078779

Author:

Karl E. Case, Ray C. Fair, Sharon E. Oster

Publisher:

PEARSON

Engineering Economy (17th Edition)

Economics

ISBN:

9780134870069

Author:

William G. Sullivan, Elin M. Wicks, C. Patrick Koelling

Publisher:

PEARSON

ENGR.ECONOMIC ANALYSIS

Economics

ISBN:

9780190931919

Author:

NEWNAN

Publisher:

Oxford University Press

Principles of Economics (12th Edition)

Economics

ISBN:

9780134078779

Author:

Karl E. Case, Ray C. Fair, Sharon E. Oster

Publisher:

PEARSON

Engineering Economy (17th Edition)

Economics

ISBN:

9780134870069

Author:

William G. Sullivan, Elin M. Wicks, C. Patrick Koelling

Publisher:

PEARSON

Principles of Economics (MindTap Course List)

Economics

ISBN:

9781305585126

Author:

N. Gregory Mankiw

Publisher:

Cengage Learning

Managerial Economics: A Problem Solving Approach

Economics

ISBN:

9781337106665

Author:

Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Publisher:

Cengage Learning

Managerial Economics & Business Strategy (Mcgraw-…

Economics

ISBN:

9781259290619

Author:

Michael Baye, Jeff Prince

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS