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:

Fringe Benefits

Additional benefits offered to employees beyond salaries and wages, including health insurance, retirement plans, and paid vacation.

Nominal Wage

The amount of money paid to an employee before adjustments for inflation, often expressed as an hourly or annual figure.

Price Index

A measure that examines the weighted average of prices of a basket of consumer goods and services over time.

Real Wage

Adjusted for inflation, it represents the purchasing power of the wage rate.