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:

Entrepreneurial Personality

A set of personality traits or characteristics that are commonly found in successful entrepreneurs, such as risk-taking, creativity, and resilience.

Need To Achieve

The personal quality, linked to entrepreneurship, of being motivated to excel and choose situations in which success is likely.

Entrepreneurship

The act of creating, managing, and building a business venture to make a profit while taking on financial risks.

Success

The achievement of set goals, targets or intended outcomes, often marked by performance or attainment in personal or business endeavors.