Question: **Use excel solver and select the solving method: non-GRG nonlinear to solve the problem** _A small manufacturing company has purchased a new machine to manufacture

**Use excel solver and select the solving method: non-GRG nonlinear to solve the problem**

**Use excel solver and select the solving method: non-GRG nonlinear to solve

_A small manufacturing company has purchased a new machine to manufacture its product. The company estimates that the revenues from using this machine for t years is given by the formula: Revenue = 4.0 (1.0 - 0.75t) where the units are in millions of dollars. For example, if the machine is used for t=4.0 years, the revenue would be: Revenue = 4.0 (1.0 - 0.754) = $2.73 million. If the company stops using the machine, they can sell the machine for its salvage value. The company estimates that if they sell the machine after t years of use, the machine's salvage value would be: 1.0 1.0+t Salvage value = where again the units are in millions of dollars. For example, if the machine is sold after t=4.0 years, the salvage value would be: 1.0 1.0+t Salvage value = = $0.20 million. What is the optimal time for the company to sell the machine

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!