Use the Spreadsheet and Solver Sensitivity Report to Answer These

question 41

Essay

Use the spreadsheet and Solver sensitivity report to answer these questions.
a.What is the cell formula for B12?
b.What is the cell formula for C12?
c.What is the cell formula for D12?
d.What is the cell formula for B15?
e.What is the cell formula for B16?f. What is the cell formula for B17?g. What is the optimal value for x1?h. What is the optimal value for x2?i. Would you pay $.50 each for up to 60 more units of resource 1?j. Is it possible to figure the new objective function value if the profit on product 1 increases by a dollar, or do you have to rerun Solver?

---

Definitions:

Lateral Structures

Organizational configurations that emphasize an equal distribution of power and a more horizontal approach to management and communication.

External Environment

The conditions, entities, events, and factors surrounding an organization that influence its activities and choices, but are beyond its control.

Sociopolitical Environment

The division of the environment that includes the combined influence of societal and political factors affecting an organization or individual.

Practical Reasoning

The process of figuring out what to do in a given situation, typically involving the application of logical thinking and real-world problem-solving skills.