Susan Is in Charge of the Inventory Reports for Her

question 41

Multiple Choice

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 2013 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:

Marginal Revenue Product

The additional revenue generated from employing one more unit of a resource, factor, or input.

Total Product

The overall quantity of output that a firm produces, usually within a given period, considering all factors of production.

Complementary Resources

Assets or inputs that enhance the value or effectiveness when used in conjunction with another resource.

Least-costly Combination

In production, using the mix of resources that minimizes cost while producing a given level of output.