Use goal seeking (under Data/What If Analysis) to determine how much the company can pay for each

Question:

Use goal seeking (under Data/What If Analysis) to determine how much the company can pay for each robot and break even, so that savings minus costs = 0. You will set the cell containing the (Savings – Cost) as the Set Cell, and enter 0 in the To Value input box. The cell that can be changed is the one that represents the unit cost of a telepresence robot. How much can the company pay for each robot, using the assumptions in the spreadsheet?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: