Use This Information to Answer the Following Questions -Use the Sensitivity Report to Answer the Following Questions:
A

question 17

Essay

Use this information to answer the following questions.
An investment company currently has $1 million available for investment in five different stocks.The company wants to maximize the interest earned over the next year.The five investment possibilities along with the expected interest earned are shown below.To manage risk,the investment firm wishes to have at least 35% of the investment in stocks A and B.Furthermore,no more than 15% of the investment may be in stock E.
$$\begin{array} { l c } \text { Investment } & \text { Expected Interest Earned (\%) } \\\text { Stock A } & 7 \\\text { Stock B } & 9 \\\text { Stock C } & 8 \\\text { Stock D } & 10 \\\text { Stock E } & 11\end{array}$$

-Use the Sensitivity Report to answer the following questions:
a.Suppose that the amount of money available for investment increases by $50,000.What impact would this have on the current optimal objective function value?
b.Suppose that total investment in stocks A and B must be at least 40% of the total amount available for investment (i.e. ,$400,000).What impact would this have on the current optimal objective function value?
c.Suppose that the total investment in stocks A and be must be at least 30% of the total amount available for investment.What impact would this have on the current optimal objective function value?
d.Assume that no more than 30% of the investment may be in stock E.What impact would this have on the current optimal objective function value?

Understand the concept and application of measures in Power Pivot.

Understand how to create and manipulate PivotTables in Power Pivot.

Understand the process of adding tables to the data model in Excel.

Understand the importance and functionality of relationships between tables in a data model.

---

Definitions:

Turnitin.com

An Internet-based plagiarism detection service used by educational institutions to check the originality of students' work.

Creative Commons

A non-profit organization that offers free licenses enabling creators to legally share their work with specified conditions.

Irrevocable

Something that cannot be changed, reversed, or recovered.

Intellectual Property

Refers to products derived from the mind, such as works of art and literature, inventions, and software code.