Question

Case-Based Critical Thinking Questions ​ Case 3-2 Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. ​ ​ Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.

Answer 1

Goal Seek

Step-by-step explanation:

Susan can use Goal seek when we have an established goal, and we don't want to change that goal, but we can evaluate different values to get this goal.

For example:

If we want to buy a house and only we have $2500 for monthly payment.

We could change three values in this case:

- House value: $250,000.00 or $219,954.84

- interests: 8.76% or 11.00%

- Years to pay: 15 or 15

= Monthly payment: $2500 = $2500

Susan's example:

She needs to find the items number, this number always must be the same.

The inventory cost must change to get the inventory goal.