Provide Excel example/formulas as well as without excel? Thank you A tool and die company is considering thepurchase of a drill press with fuzzy-logic software to improve accuracy and reduce tool wear. The company has theopportunity to buy a slightly used machine for $15,000 or new one for $21,000. Because the new machine is a moresophisticated model, its operating cost is expected to be $7000 per year, while the used machine is expected to require$8200 per year. Each machine is expected to have 25 years life with 5% salvage value. Tabulate the incremental cashflow

Part 2: ExplanationStep 1: Calculate the Initial Investment DifferenceNew Machine Cost: $21,000Used…

Answered: Provide Excel example/formulas as well…

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

An electronics firm invested $60,000 in a precision inspection device. It cost $4000 to operate and maintain in the first year and $3000 in each of the subsequent years. At the end of 4 years, the firm changed their inspection procedure, eliminating the need for the device. The purchasing agent was very fortunate in being able to sell the inspection device for $60,000, the original price. The plant manager asks you to compute the equivalent uniform annual cost of the device during the 4 years it was used. Assume interest at 6% per year. Please show work, preferably not with excel. Will Upvote!
A factory manager bought a rare machine for $10 million. of the machine The sales value at the end of the first year will be $3 million and the machine will be sold by antique dealers. It is estimated to be valued at $500,000 due to the Initial cost of maintenance Expected to be $300,000 in 3 years and double each year thereafter. In this way, the maintenance cost of the 4th year is $600,000, the maintenance cost of the 5th year is $1,200,000, etc. will be. Calculate the economic life of this machine based on the Minimum Attractive Efficiency Ratio of 15%.
Evaluate to total present worth of all the cash-flow of machine ABC for an interest rate of 10% per year. Relevant costs are as follows investment cost = $18,000 useful life = 20 years Market value = $5000 Annual operating expenses =$250 Overhead cost end of the 7th year = $500 Overhead cost end of the 14th year = $800
Mr. Russ T. Steele sells his old vehicle for $5000 (you get more if you private salel) and pays cash for a used (but newer vehicle) that costs $10,000. He also understands that he needs to allow for maintenance and operation costs of his vehicle. He estimates that these costs will be approximately $2000 a year and estimates that the costs will increase by $100 per year. He hopes to keep the vehicle for five years and then sell it for an estimated value of $2000. Mr. Steele has an MARR of 8%. The present value of the cash flow associated with his purchase is most nearly: Oa. -$7,400 b.$-12,400 C $12,000 Od.-$15,100
A conveyor system costs $100,000 to install. The Salvage value of the convey or System decreases by $20,0 00 kach year until its salvage value is at $0, at which point it no longer decrates. The cost to operate and maintain the convey or system the first year is $20,000; this cost increases by 5% per year. What is the uptimal replacement interval and minimum EUAC for the conveyor systam, assuming a MARR of 12% is Used? Note that the oppimal replacement interva) is more than (and not equal to) n=13 and less than and ( not equal to) n=16 so you do not nerel to seouch for an n outside this range - In fact you will need to only check two values for n based on this range
T has bought the new N2 for 80,000 Knuts and because the broomstick flies only with the wizard who bought it in the first place, the market value of this N2 is always 0 from tha point on. Moreover, there is an annual cost of maintenance for the broomstick which T has calculated to be as Cost(m) = 10,000 + 6,000 * (m-1), where m is the year. What is the AEC of this broomstick in its economic life year if the interest rate in the wizarding world is 0%?
Product X currently sells for $12 per unit. The variable costs is $4 per unit and 10,000 units are sold annually with a profit of $30,000 per year. A new design will increase the variable cost by 21% and fixed cost by 11% but sales will increase to 12777 units per year. At what selling price do the break even occurs for the new design?
The price for obtaining a cubic reactor of 1.2 m length was 2000 $ in 2013 (and the instillation cost is 30% of its price). If it is wanted by an investor to obtain a new one of larger size (the double) this year and to insulate it using one layer of insulation material that was cost 7 $/m² in 2013 (knowing that the cost of workers was 4 $/m² in 2013). How much will be the cost to install this new reactor? Year M&S Material Worker Index Index Index 2013 323 360 1480 587 2021 1505 600
Jumbo Company uses 1,100 units of an particular item each year. Carrying the item in inventory costs $200 per unit per year. It costs $150 for each order of the chemical. The firm uses the item at a constant rate each year. Calculate the Economic Order Quantity AND Use the data from problem above and assume that Jumbo Company operates 250 days per year. Also assume that its total usage is 1,100 units per year. There is a lead time of 2 days and Jumbo desires to keep a safety stock of 4 units. Calculate the reorder point
A large city in mid-west needs to buy a street-cleaning machine. A used vehicle will cost $75000 and has a market value of $20000 after its five-year life. A new system cost $150000 and has a market value of $40000 after five-years. The new system has some features that reduce labor hours compared with used system. the used system requires labor hours of 8 hours per day and 20 days per month. the labor costs are $50 per hour. the MARR is 12%. if the new system is expected to be able to reduce labor hours by 20% compared with the used system, which system should the city purchase? and how many hours must the system be operated at the break even?
A steam generation system at a biomass-fueled power plant uses an electrostaticprecipitator (ESP) to clean its gaseous effluents. The power plant has consistently made use ofthe same type of ESP over the past several years. The installed cost of a new ESP has beenrelatively constant at $100,000. Records of operation and maintenance expenses indicate thefollowing average expenses per year as a function of the age of the ESP. The MVs of the ESP arealso reasonably well known as a function of age. Data graph in image attached. Determine the best time to replace the ESP if the MARR is 15% per year.
The monthly demand for ice cans being manufactured by Mr. Cruz is 3k pieces. With a manually guillotine, the unit cutting cost is $50.00. An electrically operated hydraulic guillotine was offered to Mr. Cruz at a price of $350 and which will cut by 25% the unit cutting cost. Disregarding the cost of money, how many months will Mr. Cruz be able to recover of the machine if he decides to buy now?

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