Case 3-2 Susan Is in Charge of the Inventory Reports for Her

question 67

Multiple Choice

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 make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet. She can use  ______.

• A) Lookup Analysis
• B) What-If Analysis
• C) IF conditions
• D) nested OR conditions

---

Definitions:

Acceptable Return

The minimum profit or benefit expected by an investor for the risk taken on an investment.

Income from Operations

Financial performance metric that shows earnings from normal business activities, excluding effects of interest and taxes.

Transfer Price

The price at which goods and services are sold between subdivisions, affiliates, or subsidiaries within the same organization.

Variable Cost

Variable costs are expenses that vary directly with the level of production or business activity, such as raw materials and direct labor.